/**
* 多个黄单号对应-个主单号计算超重方法
*
* @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);
}
}
}
}
// 作废EDI临时信息主表
public void deleteStatusCtTmD(Long dno) throws Exception {
List<CtTmD> tmdlist = this.ctTmDDao.findBy("DNo", dno + "");
if (null == dno) {
throw new ServiceException("配送单号为空！");
}
if (null != tmdlist && tmdlist.size() > 0) {
CtTmD tmd = tmdlist.get(0);
tmd.setStatus(0l); // 0表示需要删除
this.ctTmDDao.save(tmd);
} else {
CtTmD tmd = new CtTmD();
OprFaxIn faxIn = this.oprFaxInService.get(dno);
if (!this.edi_distributionMode.equals(faxIn.getDistributionMode())) {
throw new ServiceException("配送单号为 " + dno + "的货物不是中转的货物！");
}
try {
tmd.setCtId(Long.valueOf(this.customerService.get(faxIn.getGoWhereId()).getEdiUserId()));
} catch (Exception e) {
throw new ServiceException("获取EDI编码获取失败！");
}
tmd.setDNo(faxIn.getDno() + "");
tmd.setStopflag("0");
tmd.setGoodStatus("1");
tmd.setOkFlag("0");
tmd.setSignFlag("0");
tmd.setExceptionFlag("1"); // 1为否，0为是
tmd.setIsvaluables("0");
tmd.setCtName(faxIn.getGowhere());
tmd.setCubage(faxIn.getBulk());
tmd.setCustomerServiceName(faxIn.getCustomerService());
tmd.setDnAmt(faxIn.getConsigneeFee());
tmd.setDnAmtChange(0d);
tmd.setEndpayAmt(faxIn.getPaymentCollection());
tmd.setFlyTime(faxIn.getFlightTime());
tmd.setGoods(faxIn.getGoods());
tmd.setPiece(faxIn.getPiece());
tmd.setReceAdd(faxIn.getAddr());
tmd.setReceCorp("");
tmd.setReceMan(faxIn.getConsignee());
tmd.setReceTel(faxIn.getConsigneeTel());
tmd.setShfNo(faxIn.getFlightNo());
tmd.setSustbillNo(faxIn.getSubNo());
tmd.setTakeMode(faxIn.getTakeMode().trim());
tmd.setTraAmt(faxIn.getTraFee());
tmd.setTraCost(faxIn.getTraFeeRate());
tmd.setWeight(faxIn.getCusWeight());
tmd.setYdNo(faxIn.getFlightMainNo());
tmd.setSignType(faxIn.getReceiptType()); // 签单类型
tmd.setDeptName(faxIn.getInDepartId() == 457l ? "广州" : "深圳");
tmd.setIsSp(faxIn.getSonderzug() == null ? "0" : faxIn.getSonderzug() + ""); // 是否专车
tmd.setIsurgent(
faxIn.getUrgentService() == null ? "0" : faxIn.getUrgentService() + ""); // 是否加急
tmd.setStatus(0l); // STATUS 1：正常，0：保存时，需要删除的判断依据
this.save(tmd);
}
}
/*
* 取消成本审核
*/
@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 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);
}
public List<? extends PrintBean> setPrintBeanList(
BillLadingList mainbill, Map<String, String> map) {
List<PrintBean> list = new ArrayList<PrintBean>();
String dno = map.get("dno");
String changeNo = map.get("changeNo");
if (null == map.get("changeNos") || "".equals(map.get("changeNos").trim())) {
mainbill.setMsg("请传更改明细单号过来！");
return list;
}
if (null == changeNo || "".equals(changeNo)) {
mainbill.setMsg("请传更改单号过来！");
return list;
}
if (null == dno || "".equals(dno)) {
mainbill.setMsg("请传配送单号过来！");
return list;
}
String changeNos[] = map.get("changeNos").split(",");
OprChangeMain changeMain = this.oprFaxChangeDao.get(Long.valueOf(changeNo));
if (null == changeMain) {
mainbill.setMsg("更改单号有误，没有找到该更改单号！");
return list;
}
OprFaxIn fax = this.oprFaxInDao.get(changeMain.getDno());
if (null == fax) {
mainbill.setMsg("没有找到对应的传真记录！");
return list;
}
OprChangeDetail detail = null;
OprFaxChangeBean bean = null;
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm ss");
SimpleDateFormat sdfPrint = new SimpleDateFormat("yyyy-MM-dd HH:mm"); // 打印格式
User user = WebRalasafe.getCurrentUser(ServletActionContext.getRequest());
Iterator<OprChangeDetail> itr = changeMain.getOprChangeDetail().iterator();
while (itr.hasNext()) {
detail = itr.next();
boolean bool = false;
for (int i = 0; i < changeNos.length; i++) {
if (detail.getId().equals(Long.valueOf(changeNos[i]))) {
bool = true;
break;
}
}
if (!bool) {
continue;
}
bean = new OprFaxChangeBean();
bean.setChangeContent(
"原 "
+ detail.getChangeFieldZh()
+ " 为："
+ detail.getChangePre()
+ " 现改为："
+ detail.getChangePost());
try {
bean.setChangeDate(sdf.format(changeMain.getCreateTime()));
} catch (Exception e) {
mainbill.setMsg("更改申请主表创建时间有误！");
logger.debug("更改申请主表创建时间有误！");
}
bean.setChangeDepart(changeMain.getDepartName() == null ? "" : changeMain.getDepartName());
bean.setChangeName(changeMain.getCreateName() == null ? "" : changeMain.getCreateName());
bean.setChangeNo(changeNo);
bean.setChangeTitle("配送中心更改通知单"); // 设置标题
bean.setConsignee(fax.getConsignee() == null ? "" : fax.getConsignee());
bean.setCusName(fax.getCpName() == null ? "" : fax.getCpName());
bean.setDistributionMode(fax.getDistributionMode() == null ? "" : fax.getDistributionMode());
bean.setDno(fax.getDno() + "");
bean.setFlightMainNo(fax.getFlightMainNo() == null ? "" : fax.getFlightMainNo());
bean.setSubNo(fax.getSubNo() == null ? "" : fax.getSubNo());
bean.setGoWhere(fax.getRealGoWhere() == null ? "" : fax.getRealGoWhere());
bean.setPayWay(fax.getWhoCash() == null ? "" : fax.getWhoCash());
bean.setPiece(fax.getPiece() == null ? "0" : fax.getPiece() + "");
bean.setTakeMode(fax.getTakeMode() == null ? "" : fax.getTakeMode());
bean.setWeight(fax.getCqWeight() == null ? "0" : fax.getCqWeight() + ""); // 重量
bean.setWeightFee(fax.getCusWeight() == null ? "" : fax.getCusWeight() + ""); // 计费重量
bean.setXbwlImagePath(this.print_fax_change_img); // 设置图片路径
bean.setPrintId("");
bean.setPrintName(user.get("name") + "");
bean.setPrintNum(1l);
bean.setPrintTime(sdfPrint.format(new Date())); // 打印时间
bean.setSourceNo(changeNo);
list.add(bean);
}
return list;
}
