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(); }
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 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; }