예제 #1
0
 private String buildEmailBody(Bill bill) {
   StringBuffer sb = new StringBuffer();
   sb.append(
       "您有一条新任务,请进入<a href=\""
           + WebConstants.URL
           + "\" target=\"_blank\">"
           + WebConstants.URL
           + "</a>来处理");
   sb.append("农场管区: ");
   sb.append(bill.getFarm() == null ? "" : bill.getFarm().getName());
   sb.append("-" + bill.getArea() == null ? "" : bill.getArea().getName());
   sb.append("\n");
   sb.append("饲料经理签名:" + (bill.getManager() == null ? "" : bill.getManager().getName()));
   sb.append("\n");
   sb.append("单据编号:" + bill.getOrderId());
   sb.append("\n");
   sb.append("管区:" + (bill.getArea() == null ? "" : bill.getArea().getName()));
   sb.append("\n");
   sb.append("单据:" + (bill.getOrderNo() == null ? "" : bill.getOrderNo()));
   sb.append("\n");
   sb.append("负责人:" + bill.getCurrUserName());
   sb.append("\n");
   sb.append("饲料规格:" + bill.getModel());
   sb.append("\n");
   sb.append("饲料型号:" + bill.getSize());
   sb.append("\n");
   sb.append("饲料吨数:" + bill.getAmount());
   sb.append("\n");
   sb.append("预计达到时间:" + Util.getDate(bill.getPlanDate()));
   sb.append("\n");
   return sb.toString();
 }
예제 #2
0
  // 提交单据
  public Bill addNewBill(Bill bill) {
    Farm farm = billDao.getEntityById(Farm.class, bill.getFarm().getId());
    Factory factory = billDao.getEntityById(Factory.class, bill.getFactory().getId());
    // 生成订单号
    bill.setOrderId(Util.genOrderId(farm.getName(), factory.getName(), getCurrNum()));
    // 当前处理人
    User userObj = (User) ActionContext.getContext().getSession().get(WebConstants.SESS_USER_OBJ);
    if (userObj instanceof AreaAccount) {
      AreaAccount aa = (AreaAccount) userObj;
      bill.setCurrUserName(aa.getArea().getFarm().getManager().getName());
      bill.setAreaAccount(aa);
    } else if (userObj instanceof ManagerAccount) {
      ManagerAccount aa = (ManagerAccount) userObj;
      bill.setCurrUserName(aa.getName());
      bill.setManager(aa);
    } else if (userObj instanceof Admin) {
      bill.setCurrUserName(userObj.getName());
    }
    // 保存创建人和创建日期
    if (bill.getCreateDate() == null) bill.setCreateDate(new Date());
    if (bill.getCreateName() == null) bill.setCreateName(userObj.getName());

    baseDao.saveOrUpdate(bill);
    // 保存日志
    BillLog log = Util.getBaseLog(BillLog.class, "草稿 -> 审核中");
    log.setBill(bill);
    log.setRemark(bill.getApplyRemark());
    baseDao.saveOrUpdate(log);

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

    logger.info("提交单据【" + bill.getOrderId() + "】成功");
    return bill;
  }
예제 #3
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;
  }
예제 #4
0
  // 保存单据草稿
  public Bill saveBillDraft(Bill bill) {
    if (bill == null) return null;
    /*
    if (!Util.isEmpty(bill.getFarmer().getName())) {
    	Farmer farmer = this.getEntityByUnique(Farmer.class, "name", bill.getFarmer().getName());
    	bill.setFarmer(farmer);
    }*/
    Farm farm = billDao.getEntityById(Farm.class, bill.getFarm().getId());
    Factory factory = billDao.getEntityById(Factory.class, bill.getFactory().getId());
    // 生成订单号
    bill.setOrderId(Util.genOrderId(farm.getName(), factory.getName(), getCurrNum()));
    // 当前处理人
    User userObj = (User) ActionContext.getContext().getSession().get(WebConstants.SESS_USER_OBJ);
    if (userObj instanceof AreaAccount) {
      AreaAccount aa = (AreaAccount) userObj;
      bill.setAreaAccount(aa);
    } else if (userObj instanceof ManagerAccount) {
      ManagerAccount aa = (ManagerAccount) userObj;
      bill.setManager(aa);
    }
    bill.setCurrUserName(userObj.getName());
    baseDao.saveOrUpdate(bill);
    // 保存日志
    BillLog log =
        Util.getBaseLog(
            BillLog.class,
            (bill.getShenpiResult() != null && bill.getShenpiResult() == false)
                ? "审核中 -> 草稿"
                : "拟定 -> 草稿");
    log.setBill(bill);
    log.setRemark(
        (bill.getShenpiResult() != null && bill.getShenpiResult() == false)
            ? bill.getShenpiRemark()
            : bill.getApplyRemark());
    baseDao.saveOrUpdate(log);

    logger.info("保存单据草稿【" + bill.getOrderId() + "】成功");
    return bill;
  }
예제 #5
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;
  }