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