Пример #1
0
  public String getSentBillExcelDownloadFile(
      Bill condition, Date fromDate, Date toDate, String currMan, String accountName) {
    List<Bill> billList =
        billDao.getSentBillList(condition, fromDate, toDate, currMan, accountName);
    String path = Thread.currentThread().getContextClassLoader().getResource("/").getPath();
    path = path.substring(0, path.indexOf("WEB-INF"));
    path += "excel";
    System.out.println("excel saved path : " + path);
    // String sourceFile = path + File.separator + "template.xls";
    String targetFile = path + File.separator + System.currentTimeMillis() + ".xls";
    Workbook rw = null;
    try {
      WritableWorkbook workbook = Workbook.createWorkbook(new File(targetFile));
      WritableSheet sheet = workbook.createSheet("单据列表", 0);

      // 加表头
      WritableFont font = new WritableFont(WritableFont.TIMES, 12, WritableFont.BOLD);
      WritableCellFormat format = new WritableCellFormat(font);
      sheet.addCell(new Label(0, 0, "编号", format));
      sheet.addCell(new Label(1, 0, "供货厂商", format));
      sheet.addCell(new Label(2, 0, "饲料厂商", format));
      sheet.addCell(new Label(3, 0, "计划到料日期", format));
      sheet.addCell(new Label(4, 0, "发料日期", format));
      sheet.addCell(new Label(5, 0, "到料日期", format));
      sheet.addCell(new Label(6, 0, "规格", format));
      sheet.addCell(new Label(7, 0, "用料量(吨)", format));
      sheet.addCell(new Label(8, 0, "合计金额", format));
      sheet.addCell(new Label(9, 0, "单据状态", format));
      sheet.addCell(new Label(10, 0, "当前处理人", format));
      sheet.addCell(new Label(11, 0, "所属区域", format));
      // 加内容
      int i = 1;
      for (Bill f : billList) {
        sheet.addCell(new Number(0, i, f.getId()));
        sheet.addCell(new Label(1, i, f.getProvider().getName()));
        sheet.addCell(new Label(2, i, f.getFactory().getName()));
        sheet.addCell(new Label(3, i, f.getPlanDate().toString()));
        sheet.addCell(new Label(4, i, Util.getDate(f.getSendDate()))); // 发料日期
        sheet.addCell(new Label(5, i, Util.getDate(f.getFinishDate()))); // 到料日期
        sheet.addCell(new Label(6, i++, f.getSize()));
        sheet.addCell(new Number(7, i++, f.getAmount()));
        sheet.addCell(new Label(8, i++, f.getBillPrice()));
        sheet.addCell(new Label(9, i++, f.getStatusTxt()));
        sheet.addCell(new Label(10, i++, f.getCurrUserName())); // 当前处理人
        sheet.addCell(new Label(11, i++, f.getFarm().getName()));
      }

      workbook.write();
      workbook.close();
      return targetFile;
    } catch (Exception e) {
      e.printStackTrace();

    } finally {
      if (rw != null) rw.close();
    }
    return null;
  }
Пример #2
0
  public Bill finishBill(Bill b, String[] billDetail) {
    Bill bill = baseDao.getEntityById(Bill.class, b.getId());
    bill.setFinishDate(b.getFinishDate());
    bill.setFinishAmount(b.getFinishAmount());
    bill.setFinishPrice(b.getFinishPrice());
    bill.setFinishRemark(b.getFinishRemark());
    bill.setStatus(WebConstants.BILL_STATUS_FINISH);

    // 保存农户财务明细
    for (String detail : billDetail) {
      String[] arr = detail.split(",");
      long areaId = Long.parseLong(arr[0]);
      long farmerId = Long.parseLong(arr[1]);
      double amount = Double.parseDouble(arr[2]);
      double totalPrice = Double.parseDouble(arr[3]);
      FarmerFinance ff = new FarmerFinance();
      ff.setAmount(amount);
      ff.setArea(this.getEntityById(Area.class, areaId));
      ff.setBill(bill);
      ff.setCreateDate(new Date());
      ff.setCreateName(
          ((User) ActionContext.getContext().getSession().get(WebConstants.SESS_USER_OBJ))
              .getName());
      ff.setEnable(true);
      ff.setFactory(bill.getFactory());
      ff.setFarmer(this.getEntityById(Farmer.class, farmerId));
      ff.setModel(bill.getModel());
      ff.setMoney(totalPrice);
      ff.setProvider(bill.getProvider());
      ff.setRateFromDate(bill.getFinishDate());
      ff.setSize(bill.getSize());
      ff.setType(0);
      billDao.saveOrUpdate(ff);
      logger.info("农户分配财务信息保存成功【" + ff.getFarmer().getName() + "】");
    }

    // 保存供应厂财务明细
    ProviderFinance pf = new ProviderFinance();
    pf.setBill(bill);
    pf.setCreateDate(new Date());
    pf.setCreateName(
        ((User) ActionContext.getContext().getSession().get(WebConstants.SESS_USER_OBJ)).getName());
    pf.setEnable(true);
    pf.setProvider(bill.getProvider());
    pf.setAmount(bill.getFinishAmount());
    pf.setFarm(bill.getFarm());
    pf.setFarmer(bill.getFarmer());
    pf.setFactory(bill.getFactory());
    // pf.setMoney(bill.getFinishPrice());
    // 获取实付料款
    pf.setMoney(Util.multiplyMoney(bill.getAmount(), bill.getPriceOnOrder()));
    pf.setAgentMoney(Util.multiplyMoney(bill.getAmount(), bill.getAgentUnitPrice()));

    pf.setRateFromDate(bill.getFinishDate());
    pf.setType(0);
    billDao.saveOrUpdate(pf);
    logger.info("供应厂分配财务信息保存成功【" + pf.getProvider().getName() + "】");

    // 保存单据
    billDao.saveOrUpdate(bill);
    // 保存日志
    BillLog log = Util.getBaseLog(BillLog.class, "已发料 -> 已送达");
    log.setBill(bill);
    log.setRemark(bill.getFinishRemark());

    // 发邮件
    sendEmail(bill, "单据发料成功");

    this.saveOrUpdateEntity(log);
    return bill;
  }