/** * 多个黄单号对应-个主单号计算超重方法 * * @param array */ public void manyFlightToOneFax(List<FiDeliverycost> array, double totalFdWeight) { double diffWeight = DoubleUtil.sub(totalFdWeight, array.get(0).getFaxWeight()); FiDeliverycost fiDeliverycost = array.get(0); // 多票匹配放在第一个黄单记录里面 fiDeliverycost.setDiffWeight(diffWeight); fiDeliverycost.setDiffAmount( Math.ceil(DoubleUtil.mul(fiDeliverycost.getDiffWeight(), fiDeliverycost.getPrice()))); save(fiDeliverycost); if (diffWeight > 0.0) { // 主单超重处理 List<OprFaxIn> listMain = oprFaxInDao.find( "from OprFaxIn oi where oi.faxMainId=? and oi.status=1 ", Long.parseLong(array.get(0).getFaxId())); if (listMain.size() > 0) { OprFaxIn oprFaxIn = listMain.get(0); CusOverweightManager cusMan = null; List<CusOverweightManager> cuslist = this.cusOverManagerService.findBy("cusId", oprFaxIn.getCusId()); if (cuslist.size() == 0) { List<CusOverweightManager> listM = cusOverManagerService.find("from CusOverweightManager cs where cs.cusId is null "); if (listM.size() == 0) { throw new ServiceException("请在主单超重模块录入主单超重相关信息"); } else { cusMan = listM.get(0); } } else { cusMan = cuslist.get(0); } if (diffWeight > cusMan.getLowWeight()) { // 写入主单超重表 OprOverweight oprOverweight = new OprOverweight(); oprOverweight.setCustomerId(oprFaxIn.getCusId()); oprOverweight.setCustomerName(oprFaxIn.getCpName()); oprOverweight.setWeight(diffWeight); oprOverweight.setFlightMainNo(array.get(0).getFaxMainNo()); oprOverweight.setDepartId(array.get(0).getDepartId()); oprOverweight.setDepartName(array.get(0).getDepartName()); oprOverweight.setFaxWeight(array.get(0).getFaxWeight()); oprOverweight.setFlightWeight(totalFdWeight); oprOverweight.setAmount( Math.ceil(DoubleUtil.mul(diffWeight, cusMan.getOverweightRate()))); oprOverweight.setRate(cusMan.getOverweightRate()); oprOverweight.setStatus(1l); cusOverWeightService.save(oprOverweight); } } } }
/** * 一个黄单号对应多个主单号计算超重方法 * * @param array */ public void oneFlightToManyFax(List<FiDeliverycost> array) { FiDeliverycost fiDeliverycost = array.get(0); double diffWeight = DoubleUtil.sub(fiDeliverycost.getFlightWeight(), fiDeliverycost.getFaxWeight()); if (diffWeight > 0.0) { // 主单超重处理 这里计了多次,在超重处理时,必须得判断一下 List<Long> list = getPksByIds(fiDeliverycost.getFaxId()); for (int j = 0; j < list.size(); j++) { List<OprFaxIn> listMain = oprFaxInDao.find( "from OprFaxIn oi where oi.faxMainId=? and oi.status=1 ", list.get(j)); OprFaxIn oprFaxIn = listMain.get(0); CusOverweightManager cusMan = null; List<CusOverweightManager> cuslist = this.cusOverManagerService.findBy("cusId", oprFaxIn.getCusId()); if (cuslist.size() == 0) { List<CusOverweightManager> listM = cusOverManagerService.find("from CusOverweightManager cs where cs.cusId is null "); if (listM.size() == 0) { throw new ServiceException("请在主单超重模块录入主单超重相关信息"); } else { cusMan = listM.get(0); } } else { cusMan = cuslist.get(0); } if (diffWeight > cusMan.getLowWeight()) { // 写入主单超重表 OprOverweight oprOverweight = new OprOverweight(); oprOverweight.setCustomerId(oprFaxIn.getCusId()); oprOverweight.setCustomerName(oprFaxIn.getCpName()); oprOverweight.setWeight(diffWeight); oprOverweight.setFlightMainNo(array.get(0).getFaxMainNo()); oprOverweight.setDepartId(array.get(0).getDepartId()); oprOverweight.setDepartName(array.get(0).getDepartName()); oprOverweight.setFaxWeight(array.get(0).getFaxWeight()); oprOverweight.setFlightWeight(fiDeliverycost.getFlightWeight()); oprOverweight.setAmount( Math.ceil(DoubleUtil.mul(diffWeight, cusMan.getOverweightRate()))); oprOverweight.setRate(cusMan.getOverweightRate()); oprOverweight.setStatus(1l); cusOverWeightService.save(oprOverweight); } } } }
public void save(FiDeliverycost entity) { if (entity.getId() == null) { if (entity.getFlightMainNo() != null) { List<FiDeliverycost> list = find( "from FiDeliverycost fi where fi.flightMainNo=? and fi.customerId=? ", entity.getFlightMainNo(), entity.getCustomerId()); if (list.size() > 0) { throw new ServiceException("此黄单号已录入,不能重复录入"); } } else { throw new ServiceException("录入的黄单号不能为空"); } } fiDeliverycostDao.save(entity); }
// 匹配保存 @ModuleName(value = "提货成本管理匹配保存", logType = LogType.fi) public void saveMat(List<FiDeliverycost> aa) throws Exception { List<FiDeliverycost> arrayFide = new ArrayList<FiDeliverycost>(); double totalFdWeight = 0.0; for (FiDeliverycost fiDeliver : aa) { FiDeliverycost fiDeliverycost = get(fiDeliver.getId()); fiDeliverycost.setTs(fiDeliver.getTs()); if (fiDeliverycost == null) { throw new ServiceException("这黄单号记录可能已经删除,无法手工匹配"); } else if (fiDeliverycost.getMatStatus() == 1l || fiDeliverycost.getMatStatus() == 2l || fiDeliverycost.getMatStatus() == 3l) { throw new ServiceException("这黄单号记录已经系统匹配,不能匹配多次"); } fiDeliverycost.setFaxId(fiDeliver.getFaxId()); String longFaxId = fiDeliver.getFaxId(); List<Long> list = getPksByIds(longFaxId); if (aa.size() > 1 || list.size() > 1) { fiDeliverycost.setMatStatus(3l); } else { fiDeliverycost.setMatStatus(2l); } if (list.size() == 0) { throw new ServiceException("匹配时出错了"); } double totalWeight = 0.0; long totalPiece = 0l; StringBuffer sb = new StringBuffer(""); for (int i = 0; i < list.size(); i++) { OprFaxMain fiMain = oprFaxMainService.get(list.get(i)); fiMain.setMatchStatus(1l); totalWeight += fiMain.getTotalWeight(); totalPiece += fiMain.getTotalPiece(); if (i != (list.size() - 1)) { sb.append(fiMain.getFlightMainNo()).append(","); } else { sb.append(fiMain.getFlightMainNo()); } oprFaxMainService.save(fiMain); } fiDeliverycost.setFaxMainNo(sb.toString()); fiDeliverycost.setFaxPiece(totalPiece); fiDeliverycost.setFaxWeight(totalWeight); if (aa.size() == 1) { // 正常匹配写入重量差异 多票黄单匹配在后面处理 fiDeliverycost.setDiffWeight( DoubleUtil.sub(fiDeliverycost.getFlightWeight(), fiDeliverycost.getFaxWeight())); fiDeliverycost.setDiffAmount( Math.ceil(DoubleUtil.mul(fiDeliverycost.getDiffWeight(), fiDeliverycost.getPrice()))); } save(fiDeliverycost); totalFdWeight = DoubleUtil.add(fiDeliverycost.getFlightWeight(), totalFdWeight); arrayFide.add(fiDeliverycost); } if (aa.size() == 1) { oneFlightToManyFax(arrayFide); } else { manyFlightToOneFax(arrayFide, totalFdWeight); } }
/* * 取消成本审核 */ @ModuleName(value = "提货成本管理取消成本审核", logType = LogType.fi) public void saveQxFiAudit(List<FiDeliverycost> aa) throws Exception { List<Long> fiDelivAll = new ArrayList<Long>(); // 取消审核的ID集合 for (FiDeliverycost fd : aa) { fiDelivAll.add(fd.getId()); } List<FiDeliverycost> listAa = new ArrayList<FiDeliverycost>(); for (FiDeliverycost fiDeliverycost : aa) { // 验证时间戳 FiDeliverycost fiDeli = fiDeliverycostDao.get(fiDeliverycost.getId()); List<Long> faxIdList = getPksByIds(fiDeli.getFaxId()); for (Long faxIdLong : faxIdList) { OprFaxMain fiMain = oprFaxMainService.get(faxIdLong); fiMain.setCostAuditStatus(0l); oprFaxMainService.save(fiMain); // fiCostService.sumCostBySourceDataId("提货成本", fiDeliverycost.getId()); //总 List<OprFaxIn> listFax = oprFaxInDao.find( "from OprFaxIn oi where oi.faxMainId=? and oi.status=1 ", fiMain.getId()); // 找到配送单号 for (OprFaxIn oin : listFax) { double totalCost = fiCostService.sumCostBySourceDataId("提货成本", oin.getDno()); // 所有配送单号提货成本 FiCost fiCostNew = new FiCost(); fiCostNew.setCostType("提货成本"); fiCostNew.setCostTypeDetail("撤销审核"); fiCostNew.setCostAmount(-totalCost); fiCostNew.setDataSource("提货成本"); fiCostNew.setDno(oin.getDno()); fiCostNew.setSourceSignNo(fiDeliverycost.getId() + ""); fiCostNew.setStatus(1l); fiCostService.save(fiCostNew); // 重新 oprHistoryService.saveLog( oin.getDno(), "提货成本审核撤销,撤销金额:" + totalCost, log_qxAuditCost); // 操作日志 } } if (faxIdList.size() == 1) { List<FiDeliverycost> lisd = find( "from FiDeliverycost fd where fd.departId=? and fd.faxId=? and fd.id<> ? ", fiDeli.getDepartId(), fiDeli.getFaxId(), fiDeli.getId()); List<Long> idsLongList = new ArrayList<Long>(); for (FiDeliverycost fiDt2 : lisd) { idsLongList.add(fiDt2.getId()); } if (!fiDelivAll.containsAll(idsLongList)) { throw new ServiceException("存在多条黄单记录匹配一条主单号的记录,请一起取消审核"); } } if (fiDeli.getPayStatus() == 1l) { throw new ServiceException("不能撤销会计审核,存在已支付的数据"); } fiDeli.setTs(fiDeliverycost.getTs()); fiDeliverycostDao.save(fiDeli); listAa.add(fiDeli); } List<FiDeliverycost> list = fiDeliverycostDao.find( "from FiDeliverycost f where f.batchNo=? ", listAa.get(0).getBatchNo()); if (list.size() == listAa.size()) { // 如果是一个批次的数据全部撤销 for (FiDeliverycost fiDeliverycost : listAa) { // 财务接口 List<FiInterfaceProDto> listfiInterfaceDto = new ArrayList<FiInterfaceProDto>(); FiInterfaceProDto fiIn = new FiInterfaceProDto(); fiIn.setSourceData("提货成本"); fiIn.setSourceNo(fiDeliverycost.getBatchNo()); fiIn.setAmount(fiDeliverycost.getAmount()); listfiInterfaceDto.add(fiIn); fiInterfaceImpl.changePaymentAmount(listfiInterfaceDto); fiDeliverycost.setReviewDept(null); fiDeliverycost.setReviewDate(null); fiDeliverycost.setBatchNo(null); fiDeliverycost.setReviewUser(null); fiDeliverycost.setBatchNo(null); fiDeliverycost.setStatus(0l); save(fiDeliverycost); // 更新会计审核信息 } } else { // 如果只撤销一部分 double totalChange = 0.0; for (int i = 0; i < listAa.size(); i++) { totalChange = DoubleUtil.add(listAa.get(i).getAmount(), totalChange); // 修改的总金额 } // 财务接口 撤销部分应收应入 List<FiInterfaceProDto> listfiInterfaceDto = new ArrayList<FiInterfaceProDto>(); FiInterfaceProDto fiIn = new FiInterfaceProDto(); fiIn.setSourceData("提货成本"); fiIn.setSourceNo(listAa.get(0).getBatchNo()); fiIn.setAmount(totalChange); listfiInterfaceDto.add(fiIn); fiInterfaceImpl.revocationFiDeliveryCost(listfiInterfaceDto); // throw new ServiceException("正在开发中..."); for (FiDeliverycost fiDeliverycost : listAa) { fiDeliverycost.setReviewDept(null); fiDeliverycost.setReviewDate(null); fiDeliverycost.setReviewUser(null); fiDeliverycost.setBatchNo(null); fiDeliverycost.setStatus(0l); save(fiDeliverycost); // 更新会计审核信息 } } }
// 取消匹配 @ModuleName(value = "提货成本管理取消匹配", logType = LogType.fi) public String qxAudit(List<FiDeliverycost> aa) throws Exception { List<Long> fiDelivAll = new ArrayList<Long>(); // 取消匹配的ID集合 for (FiDeliverycost fd : aa) { fiDelivAll.add(fd.getId()); } for (FiDeliverycost fiDeliv : aa) { FiDeliverycost fiDeliverycost = fiDeliverycostDao.get(fiDeliv.getId()); fiDeliverycost.setTs(fiDeliv.getTs()); if (fiDeliverycost.getStatus() == 1l) { throw new ServiceException("已审核数据不能进行取消匹配操作"); } if (fiDeliverycost.getMatStatus() == null || fiDeliverycost.getMatStatus() == 0l) { throw new ServiceException("未匹配的数据不能进行取消匹配操作"); } List<Long> list = getPksByIds(fiDeliverycost.getFaxId()); for (Long faxIdLong : list) { OprFaxMain fiMain = oprFaxMainService.get(faxIdLong); fiMain.setMatchStatus(0l); oprFaxMainService.save(fiMain); // 超重删除 List<OprOverweight> list2 = cusOverWeightService.find( "from OprOverweight oo where oo.departId=? and oo.flightMainNo=? and oo.status=1 ", fiDeliverycost.getDepartId(), fiMain.getFlightMainNo()); for (OprOverweight oprOverweight : list2) { oprOverweight.setStatus(0l); cusOverWeightService.save(oprOverweight); } } if (list.size() == 1) { // 保存黄单多对一的ID集合,用来判断是否一次全部取消匹配 List<FiDeliverycost> lisd = find( "from FiDeliverycost fd where fd.departId=? and fd.faxId=? and fd.id<> ? ", fiDeliverycost.getDepartId(), fiDeliverycost.getFaxId(), fiDeliverycost.getId()); List<Long> idsLongList = new ArrayList<Long>(); for (FiDeliverycost fiDt2 : lisd) { idsLongList.add(fiDt2.getId()); } if (!fiDelivAll.containsAll(idsLongList)) { throw new ServiceException("存在多条黄单记录匹配一条主单号的记录,请全部取消匹配"); } } if (fiDeliverycost.getStatus() != null && fiDeliverycost.getStatus() == 1l) { throw new ServiceException("数据已审核,不能撤销手工匹配"); } fiDeliverycost.setMatStatus(0l); fiDeliverycost.setFaxMainNo(null); fiDeliverycost.setFaxPiece(0l); fiDeliverycost.setFaxWeight(0.0); fiDeliverycost.setDiffAmount(0.0); fiDeliverycost.setDiffWeight(0.0); fiDeliverycost.setFaxId(null); fiDeliverycostDao.save(fiDeliverycost); // 撤销手工匹配 } return null; }
// 审核 @ModuleName(value = "提货成本管理会计审核", logType = LogType.fi) public void saveFiAudit(List<FiDeliverycost> list, User user) throws Exception { List<Long> fiDelivAll = new ArrayList<Long>(); // 审核的ID集合 for (FiDeliverycost fd : list) { fiDelivAll.add(fd.getId()); } List<FiDeliverycost> listDliv = new ArrayList<FiDeliverycost>(); for (FiDeliverycost fiDeliverycost : list) { FiDeliverycost fiDeliverycost2 = get(fiDeliverycost.getId()); fiDeliverycost2.setTs(fiDeliverycost.getTs()); // save(fiDeliverycost2); //验证时间戳 listDliv.add(fiDeliverycost2); } FiDeliverycost fiDecost = get(list.get(0).getId()); if (fiDecost == null) { throw new ServiceException("记录已不存在"); } Long cusLong = fiDecost.getCustomerId(); String cusString = fiDecost.getCustomerName(); Long batchNo = fiDeliverycostExcelService.getBatchNO(1l); Double totalMoney = 0.0; for (FiDeliverycost fiDeliverycost : listDliv) { if (fiDeliverycost == null) { throw new ServiceException("记录已不存在"); } if (fiDeliverycost.getMatStatus() == null || fiDeliverycost.getMatStatus() == 0) { throw new ServiceException("存在未匹配的数据,不能审核"); } if (!cusLong.equals(fiDeliverycost.getCustomerId())) { throw new ServiceException("不同提货公司不能一起审核"); } if (fiDeliverycost.getStatus() != null && fiDeliverycost.getStatus() == 1l) { throw new ServiceException("存在记录已审核,请重新查询后再提交记录审核"); } else { totalMoney = DoubleUtil.add(fiDeliverycost.getAmount(), totalMoney); fiDeliverycost.setReviewDept(user.get("departName").toString()); fiDeliverycost.setReviewDate(new Date()); fiDeliverycost.setReviewUser(user.get("name").toString()); fiDeliverycost.setBatchNo(batchNo); fiDeliverycost.setStatus(1l); save(fiDeliverycost); // 更新会计审核信息 List<Long> listFid = getPksByIds(fiDeliverycost.getFaxId()); if (listFid.size() == 1) { // 保存黄单多对一的ID集合,用来判断是否一次全部取消匹配 List<FiDeliverycost> lisd = find( "from FiDeliverycost fd where fd.departId=? and fd.faxId=? and fd.id<> ? ", fiDeliverycost.getDepartId(), fiDeliverycost.getFaxId(), fiDeliverycost.getId()); List<Long> idsLongList = new ArrayList<Long>(); for (FiDeliverycost fiDt2 : lisd) { idsLongList.add(fiDt2.getId()); } if (!fiDelivAll.containsAll(idsLongList)) { throw new ServiceException("存在多条黄单记录匹配一条主单号的记录,请一起审核"); } } // 主单处理 for (Long faxIdLong : listFid) { OprFaxMain fiMain = oprFaxMainService.get(faxIdLong); // 标记此主单的成本已分摊 if (fiMain.getCostAuditStatus() == 1l) { continue; } else { fiMain.setCostAuditStatus(1l); } oprFaxMainService.save(fiMain); List<OprFaxIn> listFax = oprFaxInDao.find( " from OprFaxIn o where o.faxMainId=? and o.status=1 ", fiMain.getId()); double doubv = fiDeliverycost.getAmount(); // 保存到成本表中 for (int i = 0; i < listFax.size(); i++) { OprFaxIn oprFaxIn = listFax.get(i); FiCost fiCost = new FiCost(); fiCost.setDno(oprFaxIn.getDno()); fiCost.setCostType("提货成本"); fiCost.setCostTypeDetail(oprFaxIn.getTakeMode()); if ((listFax.size() - 1) == i) { fiCost.setCostAmount(doubv); oprHistoryService.saveLog( oprFaxIn.getDno(), "提货成本审核,审核支付金额:" + doubv, log_auditCost); // 操作日志 } else { double dou2 = DoubleUtil.div(fiDeliverycost.getAmount(), listFax.size(), 2); fiCost.setCostAmount(dou2); oprHistoryService.saveLog( oprFaxIn.getDno(), "提货成本审核,审核支付金额:" + dou2, log_auditCost); // 操作日志 doubv = DoubleUtil.sub(doubv, dou2); } fiCost.setSourceSignNo(fiDeliverycost.getId() + ""); fiCost.setDataSource("提货成本"); fiCostService.save(fiCost); } } } } /* //财务接口 List<FiInterfaceProDto> listfiInterfaceDto =new ArrayList<FiInterfaceProDto>(); FiInterfaceProDto fiIn = new FiInterfaceProDto(); fiIn.setCustomerId(cusLong); fiIn.setCustomerName(cusString); fiIn.setDistributionMode("客商"); fiIn.setSettlementType(2l); fiIn.setDocumentsType("成本"); fiIn.setDocumentsSmalltype("提货对账单"); fiIn.setDocumentsNo(batchNo); fiIn.setAmount(totalMoney); fiIn.setCostType("对账"); fiIn.setDepartId(Long.parseLong(user.get("departId")+"")); fiIn.setSourceData("提货成本"); fiIn.setSourceNo(batchNo); fiIn.setCreateRemark("支付"+cusString+"提货费"+totalMoney+"元"); listfiInterfaceDto.add(fiIn); fiInterfaceImpl.reconciliationToFiPayment(listfiInterfaceDto);*/ // fiInterfaceImpl.addFinanceInfo(listPro); }