private String getEmailAddr(Bill bill) {
   if (bill == null) return null;
   String currName = bill.getCurrUserName();
   if (!Util.isEmpty(currName)) {
     List<User> list = billDao.getEntitiesByColumn(User.class, "name", currName);
     if (list != null && list.size() > 0) return list.get(0).getEmail();
   }
   return null;
 }
  // 对已经有的草稿进行提交
  public Bill submitDraftBill(Bill bill) {
    // 当前处理人
    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 Admin) {
      bill.setCurrUserName(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;
  }
  // 确认单据
  public Bill confirmBill(Bill bill) {
    // 当前处理人
    Provider provider = billDao.getEntityById(Provider.class, bill.getProvider().getId());
    bill.setCurrUserName(provider.getAccount().getName());
    bill.setProviderAccount(provider.getAccount());

    User userObj = (User) ActionContext.getContext().getSession().get(WebConstants.SESS_USER_OBJ);
    if (userObj instanceof ManagerAccount) {
      ManagerAccount aa = (ManagerAccount) userObj;
      bill.setManager(aa);
    }
    baseDao.saveOrUpdate(bill);
    // 保存日志
    BillLog log = Util.getBaseLog(BillLog.class, "审核中 -> 已审核");
    log.setBill(bill);
    log.setRemark(bill.getShenpiRemark());
    baseDao.saveOrUpdate(log);

    // 发邮件
    sendEmail(bill, "单据通过审核");

    logger.info("提交单据【" + bill.getOrderId() + "】成功");
    return bill;
  }
  // 提交单据
  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;
  }
  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;
  }
  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;
  }
  public Bill changeBillStatus(Bill bill) {
    Bill billInDB = this.getEntityById(Bill.class, bill.getId());
    // 如果超级管理员将状态从“已送达”变更为其他任何状态的时候,要删除其相应的厂商财务信息和农户财务信息。
    if (billInDB.getStatus() == WebConstants.BILL_STATUS_FINISH
        && bill.getStatus() != WebConstants.BILL_STATUS_FINISH) {
      billDao.deleteFinance(billInDB.getId());
    }

    String oldStatus = billInDB.getStatusTxt();
    String newStatus = bill.getStatusTxt();
    billInDB.setStatus(bill.getStatus());
    billInDB.setReason(bill.getReason());
    this.saveOrUpdateEntity(billInDB);
    // 保存日志
    BillLog log = Util.getBaseLog(BillLog.class, oldStatus + " -> " + newStatus);
    log.setBill(bill);
    log.setRemark(bill.getReason());

    // 发邮件
    sendEmail(billInDB, "单据状态改变(" + oldStatus + " -> " + newStatus + ")");

    this.saveOrUpdateEntity(log);
    return billInDB;
  }
  public Bill sendBill(Bill bill) {
    Bill billInDB = this.getEntityById(Bill.class, bill.getId());
    billInDB.setPriceOnOrder(bill.getPriceOnOrder());
    billInDB.setShenheRemark(bill.getShenheRemark());
    billInDB.setShenheResult(bill.getShenheResult());
    billInDB.setTranslater(bill.getTranslater());
    billInDB.setAgentUnitPrice(bill.getAgentUnitPrice());
    billInDB.setOrderNo(bill.getOrderNo());
    billInDB.setRemark(bill.getRemark());
    if (bill.getShenheResult() == null) { // 仅仅是保存
      this.saveOrUpdateEntity(billInDB);
      // 保存日志
      BillLog log = Util.getBaseLog(BillLog.class, "已审核 -> 已审核");
      log.setBill(bill);
      log.setRemark(bill.getRemark());
      this.saveOrUpdateEntity(log);
    } else if (bill.getShenheResult()) { // 发料
      billInDB.setSendDate(new Date());
      billInDB.setStatus(WebConstants.BILL_STATUS_SENT);
      if (billInDB.getAreaAccount() != null) {
        billInDB.setCurrUserName(billInDB.getAreaAccount().getName());
      } else if (billInDB.getManager() != null) {
        billInDB.setCurrUserName(billInDB.getManager().getName());
      }
      this.saveOrUpdateEntity(billInDB);
      // 保存日志
      BillLog log = Util.getBaseLog(BillLog.class, "已审核 -> 已发料");
      log.setBill(bill);
      log.setRemark(bill.getShenheRemark());

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

      baseDao.saveOrUpdate(log);
    } else { // 驳回
      billInDB.setStatus(WebConstants.BILL_STATUS_SUBMIT);
      this.saveOrUpdateEntity(billInDB);
      // 保存日志
      BillLog log = Util.getBaseLog(BillLog.class, "已审核 -> 审核中");
      log.setBill(bill);
      log.setRemark(bill.getShenheRemark());

      // 发邮件
      sendEmail(billInDB, "单据驳回");

      this.saveOrUpdateEntity(log);
    }
    return billInDB;
  }
  // 保存单据草稿
  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;
  }
 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();
 }