TWarehouseAgreementServiceImpl.java 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676
  1. package com.ruoyi.warehouseBusiness.service.impl;
  2. import cn.hutool.core.collection.CollUtil;
  3. import com.alibaba.fastjson.JSONArray;
  4. import com.alibaba.fastjson.JSONObject;
  5. import com.ruoyi.approvalFlow.domain.AuditItems;
  6. import com.ruoyi.approvalFlow.service.impl.AuditItemsServiceImpl;
  7. import com.ruoyi.basicData.domain.TCorps;
  8. import com.ruoyi.basicData.domain.TFees;
  9. import com.ruoyi.basicData.mapper.TCorpsMapper;
  10. import com.ruoyi.basicData.mapper.TFeesMapper;
  11. import com.ruoyi.common.core.domain.AjaxResult;
  12. import com.ruoyi.common.core.domain.model.LoginUser;
  13. import com.ruoyi.common.exception.WarehouseException;
  14. import com.ruoyi.common.utils.DateUtils;
  15. import com.ruoyi.common.utils.StringUtils;
  16. import com.ruoyi.system.domain.SysConfig;
  17. import com.ruoyi.system.mapper.SysConfigMapper;
  18. import com.ruoyi.system.mapper.SysDeptMapper;
  19. import com.ruoyi.warehouseBusiness.domain.BillnoDel;
  20. import com.ruoyi.warehouseBusiness.domain.TAnnex;
  21. import com.ruoyi.warehouseBusiness.domain.TWarehouseAgreement;
  22. import com.ruoyi.warehouseBusiness.domain.TWarehouseAgreementitems;
  23. import com.ruoyi.warehouseBusiness.domain.dto.CalculateStorageFeesDTO;
  24. import com.ruoyi.warehouseBusiness.domain.dto.StorageFeeRangeDTO;
  25. import com.ruoyi.warehouseBusiness.domain.enums.AnnexActEnum;
  26. import com.ruoyi.warehouseBusiness.domain.enums.WarehouseTypeEnum;
  27. import com.ruoyi.warehouseBusiness.domain.vo.StorageFeeCalculationResultVO;
  28. import com.ruoyi.warehouseBusiness.mapper.BillnoDelMapper;
  29. import com.ruoyi.warehouseBusiness.mapper.TAnnexMapper;
  30. import com.ruoyi.warehouseBusiness.mapper.TWarehouseAgreementMapper;
  31. import com.ruoyi.warehouseBusiness.mapper.TWarehouseAgreementitemsMapper;
  32. import com.ruoyi.warehouseBusiness.service.ITWarehouseAgreementService;
  33. import org.springframework.beans.factory.annotation.Autowired;
  34. import org.springframework.stereotype.Service;
  35. import org.springframework.transaction.annotation.Transactional;
  36. import org.springframework.transaction.interceptor.TransactionAspectSupport;
  37. import java.math.BigDecimal;
  38. import java.math.RoundingMode;
  39. import java.util.*;
  40. /**
  41. * 仓储费Service业务层处理
  42. *
  43. * @author ruoyi
  44. * @date 2020-12-11
  45. */
  46. @Service
  47. public class TWarehouseAgreementServiceImpl implements ITWarehouseAgreementService {
  48. @Autowired
  49. private TWarehouseAgreementMapper tWarehouseAgreementMapper;
  50. @Autowired
  51. private TWarehouseAgreementitemsMapper tWarehouseAgreementitemsMapper;
  52. @Autowired
  53. private BillnoSerialServiceImpl billnoSerialServiceImpl;
  54. @Autowired
  55. private BillnoDelMapper billnoDelMapper;
  56. @Autowired
  57. private TCorpsMapper tCorpsMapper;
  58. @Autowired
  59. private TAnnexMapper annexMapper;
  60. @Autowired
  61. private TFeesMapper tFeesMapper;
  62. @Autowired
  63. private SysDeptMapper sysDeptMapper;
  64. @Autowired
  65. private SysConfigMapper sysConfigMapper;
  66. @Autowired
  67. private AuditItemsServiceImpl auditItemsService;
  68. /**
  69. * 查询仓储费
  70. *
  71. * @param fId 仓储费ID
  72. * @return 仓储费
  73. */
  74. @Override
  75. public TWarehouseAgreement selectTWarehouseAgreementById(Long fId) {
  76. return tWarehouseAgreementMapper.selectTWarehouseAgreementById(fId);
  77. }
  78. @Override
  79. public Map<String, Object> selectTWarehouseAgreementById1(Long fId) {
  80. Map<String, Object> map = new HashMap<>();
  81. // 查询协议主表数据
  82. TWarehouseAgreement tWarehouseAgreement = tWarehouseAgreementMapper.selectTWarehouseAgreementById(fId);
  83. // 客户表
  84. List<Long> corpsId = new ArrayList<>();
  85. // 费用
  86. List<Long> feesId = new ArrayList<>();
  87. if (!StringUtils.isNull(tWarehouseAgreement)) {
  88. corpsId.add(tWarehouseAgreement.getfCorpid());
  89. map.put("tWarehouseAgreement", tWarehouseAgreement);
  90. }
  91. // 协议从表
  92. TWarehouseAgreementitems tWarehouseAgreementitems = new TWarehouseAgreementitems();
  93. tWarehouseAgreementitems.setfPid(fId);
  94. List<TWarehouseAgreementitems> tWarehouseAgreementitemss = tWarehouseAgreementitemsMapper.selectTWarehouseAgreementitemsList(tWarehouseAgreementitems);
  95. if (StringUtils.isNotEmpty(tWarehouseAgreementitemss)) {
  96. for (TWarehouseAgreementitems fees : tWarehouseAgreementitemss) {
  97. feesId.add(fees.getfFeeid());
  98. }
  99. }
  100. // 附件
  101. Long type;
  102. if (tWarehouseAgreement.getfFeetypeid() < 1) {
  103. type = AnnexActEnum.STORAGE_FEE.getType();
  104. } else {
  105. type = AnnexActEnum.HOMEWORK_FEE.getType();
  106. }
  107. TAnnex annex = new TAnnex();
  108. annex.setfPid(fId);
  109. annex.setfActid(type);
  110. List<TAnnex> annexList = annexMapper.selectTAnnexList(annex);
  111. if (StringUtils.isNotEmpty(annexList)) {
  112. map.put("attachList", annexList);
  113. }
  114. List<TCorps> corpsList = new ArrayList<>();
  115. List<Long> corpsIdList = StringUtils.integerDeduplication(corpsId);
  116. for (Long corpId : corpsIdList) {
  117. TCorps corps = tCorpsMapper.selectTCorpsById(corpId);
  118. if (StringUtils.isNotNull(corps)) {
  119. corpsList.add(corps);
  120. }
  121. }
  122. List<TFees> feesList = new ArrayList<>();
  123. List<Long> longList = StringUtils.integerDeduplication(feesId);
  124. for (Long fees : longList) {
  125. TFees tFees = tFeesMapper.selectTFeesById(fees);
  126. if (StringUtils.isNotNull(tFees)) {
  127. feesList.add(tFees);
  128. }
  129. }
  130. map.put("corps", corpsList);
  131. map.put("feesList", feesList);
  132. map.put("tWarehouseAgreementitems", tWarehouseAgreementitemss);
  133. map.put("dept", sysDeptMapper.selectDeptById(tWarehouseAgreement.getfDeptid()));
  134. return map;
  135. }
  136. /**
  137. * 查询仓储费列表
  138. *
  139. * @param tWarehouseAgreement 仓储费
  140. * @return 仓储费
  141. */
  142. @Override
  143. public List<Map<String, Object>> selectTWarehouseAgreementList1(TWarehouseAgreement tWarehouseAgreement) {
  144. return tWarehouseAgreementMapper.selectTWarehouseAgreementList1(tWarehouseAgreement);
  145. }
  146. /**
  147. * 查询仓储费列表
  148. *
  149. * @param tWarehouseAgreement 仓储费
  150. * @return 仓储费
  151. */
  152. @Override
  153. public List<TWarehouseAgreement> selectTWarehouseAgreementList(TWarehouseAgreement tWarehouseAgreement) {
  154. return tWarehouseAgreementMapper.selectTWarehouseAgreementList(tWarehouseAgreement);
  155. }
  156. /**
  157. * 新增
  158. *
  159. * @param agreement
  160. * @param agreementitems
  161. * @param loginUser
  162. * @return
  163. */
  164. @Override
  165. @Transactional
  166. public AjaxResult insertTWarehouseAgreement(String agreement, String agreementitems, String attachments, LoginUser loginUser, int fFeetypeid) {
  167. Long fPid;
  168. Long type;
  169. Map<String, Object> map = new HashMap<>();
  170. if (fFeetypeid < 1) {
  171. type = AnnexActEnum.STORAGE_FEE.getType();
  172. } else {
  173. type = AnnexActEnum.HOMEWORK_FEE.getType();
  174. }
  175. TWarehouseAgreement tWarehouseAgreement = JSONArray.parseObject(agreement, TWarehouseAgreement.class);
  176. if (StringUtils.isNull(tWarehouseAgreement.getfId())) {
  177. // 如果是新数据
  178. tWarehouseAgreement.setCreateBy(loginUser.getUser().getUserName());
  179. tWarehouseAgreement.setCreateTime(new Date());
  180. // 业务编码
  181. String billNo = billnoSerialServiceImpl.getBillNo("WA", new Date());
  182. tWarehouseAgreement.setfBillno(billNo);
  183. tWarehouseAgreement.setfDeptid(loginUser.getUser().getDeptId());
  184. tWarehouseAgreement.setfFeetypeid((long) fFeetypeid);
  185. tWarehouseAgreement.setfStatus("1"); // 停用
  186. tWarehouseAgreement.setfBillstatus("2"); // 暂存
  187. tWarehouseAgreementMapper.insertTWarehouseAgreement(tWarehouseAgreement);
  188. fPid = tWarehouseAgreement.getfId();
  189. } else {
  190. fPid = tWarehouseAgreement.getfId();
  191. tWarehouseAgreement.setfBillstatus("2");
  192. tWarehouseAgreement.setUpdateBy(loginUser.getUser().getUserName());
  193. tWarehouseAgreement.setUpdateTime(new Date());
  194. tWarehouseAgreementMapper.updateTWarehouseAgreement(tWarehouseAgreement);
  195. tWarehouseAgreementitemsMapper.deleteByFPid(fPid);
  196. annexMapper.deleteByPid(fPid, type);
  197. }
  198. // 从表添加
  199. if (StringUtils.isNotNull(agreementitems) && !"[]".equals(agreementitems)) {
  200. JSONArray jsonDrArray = JSONArray.parseArray(agreementitems);
  201. List<TWarehouseAgreementitems> tWarehouseAgreementitemsList = JSONObject.parseArray(jsonDrArray.toJSONString(), TWarehouseAgreementitems.class);
  202. for (TWarehouseAgreementitems tWarehouseAgreementitems : tWarehouseAgreementitemsList) {
  203. tWarehouseAgreementitems.setfPid(fPid);
  204. tWarehouseAgreementitems.setCreateBy(loginUser.getUser().getUserName());
  205. tWarehouseAgreementitems.setCreateTime(new Date());
  206. tWarehouseAgreementitemsMapper.insertTWarehouseAgreementitems(tWarehouseAgreementitems);
  207. }
  208. }
  209. // 附件添加
  210. if (StringUtils.isNotNull(attachments) && !"[]".equals(attachments)) {
  211. JSONArray jsonDrArray = JSONArray.parseArray(attachments);
  212. List<TAnnex> annexList = JSONObject.parseArray(jsonDrArray.toJSONString(), TAnnex.class);
  213. annexList.forEach(li -> {
  214. li.setfPid(fPid);
  215. li.setfActid(type);
  216. if (Objects.nonNull(li.getfId())) {
  217. li.setCreateTime(new Date());
  218. li.setCreateBy(loginUser.getUsername());
  219. } else {
  220. li.setUpdateTime(new Date());
  221. li.setUpdateBy(loginUser.getUsername());
  222. }
  223. annexMapper.insertTAnnex(li);
  224. });
  225. map.put("attachList", annexList);
  226. }
  227. TWarehouseAgreementitems tWarehouseAgreementitems = new TWarehouseAgreementitems();
  228. tWarehouseAgreementitems.setfPid(fPid);
  229. map.put("tWarehouseAgreement", tWarehouseAgreement);
  230. map.put("tWarehouseAgreementitems", tWarehouseAgreementitemsMapper.selectTWarehouseAgreementitemsList(tWarehouseAgreementitems));
  231. return AjaxResult.success("成功", map);
  232. }
  233. /**
  234. * 仓储费请核
  235. *
  236. * @param agreement
  237. * @param agreementitems
  238. * @param loginUser
  239. * @param fFeetypeid
  240. * @return
  241. */
  242. @Override
  243. @Transactional
  244. public AjaxResult tWarehouseAgreementSubmit(String agreement, String agreementitems, String attachments, LoginUser loginUser, int fFeetypeid) {
  245. Long fPid;
  246. Long type;
  247. Map<String, Object> map = new HashMap<>();
  248. if (fFeetypeid < 1) {
  249. type = AnnexActEnum.STORAGE_FEE.getType();
  250. } else {
  251. type = AnnexActEnum.HOMEWORK_FEE.getType();
  252. }
  253. TWarehouseAgreement tWarehouseAgreement = JSONArray.parseObject(agreement, TWarehouseAgreement.class);
  254. if (StringUtils.isNull(tWarehouseAgreement.getfId())) {
  255. // 如果是新数据
  256. tWarehouseAgreement.setCreateBy(loginUser.getUser().getUserName());
  257. // 业务编码
  258. String billNo = billnoSerialServiceImpl.getBillNo("WA", new Date());
  259. tWarehouseAgreement.setfBillno(billNo);
  260. tWarehouseAgreement.setCreateBy(loginUser.getUser().getUserName());
  261. tWarehouseAgreement.setfDeptid(loginUser.getUser().getDeptId());
  262. tWarehouseAgreement.setfFeetypeid((long) fFeetypeid);
  263. tWarehouseAgreement.setfStatus("1"); // 停用
  264. tWarehouseAgreement.setfBillstatus("4");
  265. tWarehouseAgreementMapper.insertTWarehouseAgreement(tWarehouseAgreement);
  266. fPid = tWarehouseAgreement.getfId();
  267. } else {
  268. fPid = tWarehouseAgreement.getfId();
  269. tWarehouseAgreement.setfBillstatus("4");
  270. tWarehouseAgreement.setUpdateBy(loginUser.getUser().getUserName());
  271. tWarehouseAgreement.setUpdateTime(new Date());
  272. tWarehouseAgreementMapper.updateTWarehouseAgreement(tWarehouseAgreement);
  273. tWarehouseAgreementitemsMapper.deleteByFPid(fPid);
  274. annexMapper.deleteByPid(fPid, type);
  275. }
  276. // 从表添加
  277. if (StringUtils.isNotNull(agreementitems) && !"[]".equals(agreementitems)) {
  278. JSONArray jsonDrArray = JSONArray.parseArray(agreementitems);
  279. List<TWarehouseAgreementitems> tWarehouseAgreementitemsList = JSONObject.parseArray(jsonDrArray.toJSONString(), TWarehouseAgreementitems.class);
  280. for (TWarehouseAgreementitems tWarehouseAgreementitems : tWarehouseAgreementitemsList) {
  281. tWarehouseAgreementitems.setfPid(fPid);
  282. tWarehouseAgreementitems.setCreateBy(loginUser.getUser().getUserName());
  283. tWarehouseAgreementitems.setCreateTime(new Date());
  284. tWarehouseAgreementitemsMapper.insertTWarehouseAgreementitems(tWarehouseAgreementitems);
  285. }
  286. }
  287. // 附件添加
  288. if (StringUtils.isNotNull(attachments) && !"[]".equals(attachments)) {
  289. JSONArray jsonDrArray = JSONArray.parseArray(attachments);
  290. List<TAnnex> annexList = JSONObject.parseArray(jsonDrArray.toJSONString(), TAnnex.class);
  291. annexList.forEach(li -> {
  292. li.setfPid(fPid);
  293. li.setfActid(type);
  294. if (Objects.nonNull(li.getfId())) {
  295. li.setCreateTime(new Date());
  296. li.setCreateBy(loginUser.getUsername());
  297. } else {
  298. li.setUpdateTime(new Date());
  299. li.setUpdateBy(loginUser.getUsername());
  300. }
  301. annexMapper.insertTAnnex(li);
  302. });
  303. map.put("attachList", annexList);
  304. }
  305. // 这里加个判断取系统参数来确定是否需要启用审批流
  306. String key = "";
  307. boolean isApprove = false;
  308. long actId = 0L;
  309. if (fFeetypeid == 0) {
  310. actId = 310L;
  311. key = "warehouse.storage.ApprovalFlow";
  312. } else if (fFeetypeid == 1) {
  313. actId = 320L;
  314. key = "warehouse.task.ApprovalFlow";
  315. }
  316. SysConfig sysConfig = sysConfigMapper.checkConfigKeyUnique(key);
  317. if (StringUtils.isNull(sysConfig)) {
  318. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  319. return AjaxResult.error("系统参数异常,未找到开启审批流参数");
  320. }
  321. if ("0".equals(sysConfig.getConfigValue())) {
  322. isApprove = true;
  323. }
  324. if (isApprove) {
  325. AuditItems auditItems = new AuditItems();
  326. auditItems.setLevelId(0L);
  327. auditItems.setBillId(fPid);
  328. auditItems.setActId(actId);
  329. auditItems.setFidStatus("f_billstatus");
  330. auditItems.setTimes(1L);
  331. auditItems.setIffinalItem("F");
  332. auditItems.setBillNo(tWarehouseAgreement.getfBillno());
  333. auditItems.setRefno1(String.valueOf(tWarehouseAgreement.getfCorpid()));
  334. if (fFeetypeid == 0) {
  335. auditItems.setRefno2("CCF");// 存储业务类型(业务类型)
  336. } else {
  337. auditItems.setRefno2("ZYF");// 存储业务类型(业务类型)
  338. }
  339. auditItems.setSendUserId(loginUser.getUser().getUserId());
  340. auditItems.setSendName(loginUser.getUsername());
  341. auditItems.setSendTime(new Date());
  342. auditItems.setAuditUserId(loginUser.getUser().getUserId());
  343. auditItems.setAuditItem(new Date());
  344. auditItems.setAuditOpTime(new Date());
  345. auditItems.setAuditMsg("提交");
  346. auditItems.setAuditStatus("O");
  347. AjaxResult approvalFlow = auditItemsService.createApprovalFlow(auditItems);
  348. Long code = Long.valueOf(String.valueOf(approvalFlow.get("code"))).longValue();
  349. if (code.equals(500L)) {
  350. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  351. }
  352. return approvalFlow;
  353. } else {
  354. AjaxResult ajaxResult = agreementFollow(fPid, 6L);
  355. Long code = Long.valueOf(String.valueOf(ajaxResult.get("code"))).longValue();
  356. return ajaxResult;
  357. }
  358. }
  359. @Override
  360. public AjaxResult revoke(String agreement, String agreementitems, LoginUser loginUser, int fFeetypeid) {
  361. Long fPid = null;
  362. TWarehouseAgreement tWarehouseAgreement = JSONArray.parseObject(agreement, TWarehouseAgreement.class);
  363. fPid = tWarehouseAgreement.getfId();
  364. tWarehouseAgreement.setfStatus("1"); // 停用
  365. tWarehouseAgreement.setfBillstatus("2");// 暂存
  366. tWarehouseAgreement.setUpdateBy(loginUser.getUser().getUserName());
  367. tWarehouseAgreement.setUpdateTime(new Date());
  368. tWarehouseAgreementMapper.updateTWarehouseAgreement(tWarehouseAgreement);
  369. tWarehouseAgreementitemsMapper.deleteByFPid(fPid);
  370. // 从表添加
  371. if (StringUtils.isNotNull(agreementitems) && !"[]".equals(agreementitems)) {
  372. JSONArray jsonDrArray = JSONArray.parseArray(agreementitems);
  373. List<TWarehouseAgreementitems> tWarehouseAgreementitemsList = JSONObject.parseArray(jsonDrArray.toJSONString(), TWarehouseAgreementitems.class);
  374. for (TWarehouseAgreementitems tWarehouseAgreementitems : tWarehouseAgreementitemsList) {
  375. tWarehouseAgreementitems.setfPid(fPid);
  376. tWarehouseAgreementitems.setCreateBy(loginUser.getUser().getUserName());
  377. tWarehouseAgreementitems.setCreateTime(new Date());
  378. tWarehouseAgreementitemsMapper.insertTWarehouseAgreementitems(tWarehouseAgreementitems);
  379. }
  380. }
  381. return AjaxResult.success();
  382. }
  383. /**
  384. * 根据协议主表id 更新对应明细表状态
  385. *
  386. * @param fPid 协议主表id
  387. * @return 结果
  388. */
  389. @Transactional
  390. public AjaxResult agreementFollow(Long fPid, long fettle) {
  391. if (StringUtils.isNull(fPid)) {
  392. return AjaxResult.error("协议更新状态未找到主表信息,请与管理员联系");
  393. }
  394. TWarehouseAgreement tWarehouseAgreement = new TWarehouseAgreement();
  395. tWarehouseAgreement.setfId(fPid);
  396. tWarehouseAgreement.setfBillstatus(String.valueOf(fettle));
  397. int tFeeUpdateResult = tWarehouseAgreementMapper.updateTWarehouseAgreement(tWarehouseAgreement);
  398. if (tFeeUpdateResult <= 0) {
  399. TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
  400. return AjaxResult.error("更新协议明细状态失败,请联系管理员");
  401. }
  402. return AjaxResult.success();
  403. }
  404. /**
  405. * 修改仓储费
  406. *
  407. * @param tWarehouseAgreement 仓储费
  408. * @return 结果
  409. */
  410. @Override
  411. public int updateTWarehouseAgreement(TWarehouseAgreement tWarehouseAgreement) {
  412. tWarehouseAgreement.setUpdateTime(DateUtils.getNowDate());
  413. return tWarehouseAgreementMapper.updateTWarehouseAgreement(tWarehouseAgreement);
  414. }
  415. /**
  416. * 批量删除仓储费
  417. *
  418. * @param fIds 需要删除的仓储费ID
  419. * @return 结果
  420. */
  421. @Override
  422. @Transactional
  423. public int deleteTWarehouseAgreementByIds(Long[] fIds) {
  424. // 取出业务编号、 放入 billno_del
  425. for (Long id : fIds) {
  426. // 1、查询主表信息
  427. TWarehouseAgreement tWarehouseAgreement = tWarehouseAgreementMapper.selectTWarehouseAgreementById(id);
  428. // 2、业务编号、客存编号 放入 billno_del
  429. BillnoDel billnoDel = new BillnoDel();
  430. billnoDel.setBillType("WA");
  431. billnoDel.setBillNo(tWarehouseAgreement.getfBillno());
  432. Long type;
  433. if (tWarehouseAgreement.getfFeetypeid() < 1) {
  434. type = AnnexActEnum.STORAGE_FEE.getType();
  435. } else {
  436. type = AnnexActEnum.HOMEWORK_FEE.getType();
  437. }
  438. billnoDelMapper.insertBillnoDel(billnoDel);
  439. tWarehouseAgreementitemsMapper.deleteByFPid(id);
  440. annexMapper.deleteByPid(id, type);
  441. }
  442. tWarehouseAgreementMapper.deleteTWarehouseAgreementByIds(fIds);
  443. return 1;
  444. }
  445. /**
  446. * 删除仓储费信息
  447. *
  448. * @param fId 仓储费ID
  449. * @return 结果
  450. */
  451. @Override
  452. public int deleteTWarehouseAgreementById(Long fId) {
  453. return tWarehouseAgreementMapper.deleteTWarehouseAgreementById(fId);
  454. }
  455. @Override
  456. public AjaxResult queryRemove(Long fId) {
  457. // 查询协议主表数据
  458. TWarehouseAgreement tWarehouseAgreement = tWarehouseAgreementMapper.selectTWarehouseAgreementById(fId);
  459. TWarehouseAgreementitems tWarehouseAgreementitems = new TWarehouseAgreementitems();
  460. tWarehouseAgreementitems.setfPid(tWarehouseAgreement.getfId());
  461. List<TWarehouseAgreementitems> tWarehouseAgreementitemss = tWarehouseAgreementitemsMapper.selectTWarehouseAgreementitemsList(tWarehouseAgreementitems);
  462. if (StringUtils.isNull(tWarehouseAgreement)) {
  463. return AjaxResult.success("0");
  464. } else if (StringUtils.isNotNull(tWarehouseAgreement) && StringUtils.isEmpty(tWarehouseAgreementitemss)) {
  465. return AjaxResult.success("1");
  466. } else {
  467. return AjaxResult.success("2");
  468. }
  469. }
  470. /**
  471. * 计算存储费用
  472. *
  473. * @param storageFeesDto 参数
  474. * @return 结果
  475. * @author shanxin
  476. */
  477. public StorageFeeCalculationResultVO getCarryingCost(CalculateStorageFeesDTO storageFeesDto) {
  478. if (null == storageFeesDto.getfCorpid() ||
  479. null == storageFeesDto.getfGoodsid() ||
  480. null == storageFeesDto.getDays() ||
  481. null == storageFeesDto.getEarlySumDays() ||
  482. null == storageFeesDto.getWarehouseId() ||
  483. null == storageFeesDto.getStartTime() ||
  484. null == storageFeesDto.getEndTime() ||
  485. null == storageFeesDto.getCangKey()) {
  486. throw new WarehouseException("缺少查询计费规则条件");
  487. }
  488. // 查询计费规则
  489. List<TWarehouseAgreementitems> itemList =
  490. this.tWarehouseAgreementitemsMapper.getItemsBytWarehouseAgreementMsg(storageFeesDto.getfCorpid(),
  491. storageFeesDto.getfGoodsid(),
  492. String.valueOf(storageFeesDto.getWarehouseId()), storageFeesDto.getCangKey());
  493. // 如果未找到计费规则 则抛出异常
  494. if (CollUtil.isEmpty(itemList)) {
  495. throw new WarehouseException("编号" + storageFeesDto.getfMblno() + "未找到计费规则");
  496. }
  497. // 如果仓储费出现两个不同计费单位就进行抛异常
  498. long count = itemList.stream().map(TWarehouseAgreementitems::getfFeeunitid).distinct().count();
  499. if (count > 1) {
  500. throw new WarehouseException("计费规则存在多条,请确认");
  501. }
  502. // 根据规则的计费单位去获取要计算的数量
  503. TWarehouseAgreementitems agreementitems = itemList.stream().findFirst()
  504. .orElseThrow(() -> new WarehouseException("计费规则不存在"));
  505. BigDecimal qty = acquiredQuantity(storageFeesDto, agreementitems.getfFeeunitid());
  506. if (qty.compareTo(BigDecimal.ZERO) < 1) {
  507. return null;
  508. }
  509. BigDecimal money = BigDecimal.ZERO;
  510. Long dayLength;
  511. Long feeId = 0L;
  512. // 备注 天X钱=金额
  513. String remark = "";
  514. // 计费区间 月日-月日X钱
  515. String billingInterval = "";
  516. for (TWarehouseAgreementitems tWarehouseAgreementitems : itemList) {
  517. // 如果要计费天数不足一天,不予计算
  518. if (storageFeesDto.getDays() < 1) {
  519. break;
  520. }
  521. dayLength = tWarehouseAgreementitems.getfEndays() - tWarehouseAgreementitems.getfFromdays() + 1L;
  522. // 如果已计费天数超出本阶层,则进入下一层规则,并剪掉当前层天数
  523. if (storageFeesDto.getEarlySumDays() >= dayLength) {
  524. storageFeesDto.setEarlySumDays(storageFeesDto.getEarlySumDays() - dayLength);
  525. continue; //将已算账的天数 与 计费规则的 最后一天作比较如果 已算10天 > 规则结束 不算帐
  526. }
  527. // 如果计费日期超过本层天数
  528. if (storageFeesDto.getDays() >= dayLength) {
  529. // 天数剪掉 剩余已计费库存天数
  530. dayLength -= storageFeesDto.getEarlySumDays();
  531. storageFeesDto.setEarlySumDays(0L);
  532. feeId = tWarehouseAgreementitems.getfFeeid();
  533. // 获取最终金额:数量 * 单价 * 天数
  534. BigDecimal calculate = this.getCalculate(qty, tWarehouseAgreementitems.getfPrice(), dayLength);
  535. money = money.add(calculate);
  536. storageFeesDto.setDays(storageFeesDto.getDays() - dayLength);
  537. // 组装运费明细记录
  538. String details = assemblyBillingDetails(StorageFeeRangeDTO.builder()
  539. .dayNum(dayLength).price(tWarehouseAgreementitems.getfPrice()).qty(qty).amt(calculate)
  540. .build());
  541. remark = StringUtils.isEmpty(remark) ? details : remark + "," + details;
  542. // 计算区间费用信息
  543. String costRange = assemblyBillingInterval(StorageFeeRangeDTO.builder()
  544. .startTime(storageFeesDto.getStartTime()).dayNum(dayLength).price(tWarehouseAgreementitems.getfPrice())
  545. .qty(qty).unit(agreementitems.getfFeeunitid())
  546. .build());
  547. billingInterval = StringUtils.isEmpty(billingInterval) ? costRange : billingInterval + "," + costRange;
  548. storageFeesDto.setStartTime(DateUtils.dateAdd(storageFeesDto.getStartTime(), dayLength.intValue()));
  549. } else {
  550. // 最后一次计算天数
  551. feeId = tWarehouseAgreementitems.getfFeeid();
  552. BigDecimal calculate = this.getCalculate(qty, tWarehouseAgreementitems.getfPrice(), storageFeesDto.getDays());
  553. money = money.add(calculate);
  554. // 计算费用明细
  555. String details = assemblyBillingDetails(StorageFeeRangeDTO.builder()
  556. .dayNum(storageFeesDto.getDays()).price(tWarehouseAgreementitems.getfPrice()).qty(qty).amt(calculate)
  557. .build());
  558. remark = StringUtils.isEmpty(remark) ? details : remark + "," + details;
  559. // 计算区间费用信息
  560. String interval = assemblyBillingInterval(StorageFeeRangeDTO.builder()
  561. .startTime(storageFeesDto.getStartTime()).dayNum(storageFeesDto.getDays())
  562. .price(tWarehouseAgreementitems.getfPrice())
  563. .qty(qty).unit(agreementitems.getfFeeunitid())
  564. .build());
  565. billingInterval = StringUtils.isEmpty(billingInterval) ? interval : billingInterval + "," + interval;
  566. break;
  567. }
  568. }
  569. StorageFeeCalculationResultVO resultVO = new StorageFeeCalculationResultVO();
  570. resultVO.setQty(qty);
  571. resultVO.setAmt(money);
  572. resultVO.setFeeId(feeId);
  573. resultVO.setRemark(remark);
  574. resultVO.setUnit(agreementitems.getfFeeunitid());
  575. resultVO.setBillingInterval(billingInterval);
  576. return resultVO;
  577. }
  578. /**
  579. * 根据不同计费单位获取不同 计算库存明细数量
  580. *
  581. * @param storageFeesDto 库存明细
  582. * @param unit 计费单位
  583. * @return 结果
  584. */
  585. public BigDecimal acquiredQuantity(CalculateStorageFeesDTO storageFeesDto, Long unit) {
  586. BigDecimal fQty = new BigDecimal(0);
  587. if (unit.equals(Long.parseLong(WarehouseTypeEnum.BOX_NUM.getType()))) {
  588. return storageFeesDto.getfQty().setScale(2, RoundingMode.HALF_UP);
  589. } else if (unit.equals(Long.parseLong(WarehouseTypeEnum.GROSS_WEIGHT.getType()))) {
  590. fQty = storageFeesDto.getfGrossweight();
  591. } else if (unit.equals(Long.parseLong(WarehouseTypeEnum.NET_WEIGHT.getType()))) {
  592. fQty = storageFeesDto.getfNetweight();
  593. } else if (unit.equals(Long.parseLong(WarehouseTypeEnum.MEASURE.getType()))) {
  594. fQty = storageFeesDto.getfVolumn();
  595. } else if (unit.equals(Long.parseLong(WarehouseTypeEnum.FIXED.getType()))) {
  596. fQty = BigDecimal.ONE;
  597. }
  598. // 结果值除以1000 保留两位
  599. BigDecimal divisor = new BigDecimal("1000");
  600. return fQty.divide(divisor, 2, RoundingMode.HALF_UP);
  601. }
  602. /**
  603. * 组装运费明细记录
  604. *
  605. * @param rangeDto 金额
  606. * @return
  607. */
  608. private String assemblyBillingDetails(StorageFeeRangeDTO rangeDto) {
  609. return rangeDto.getDayNum() + "天*" + rangeDto.getPrice() + "元*" + rangeDto.getQty() + " = " + rangeDto.getAmt() + "元";
  610. }
  611. /**
  612. * 计算计费区间
  613. *
  614. * @param feeRangeDto
  615. * @return 计算计费区间
  616. */
  617. private String assemblyBillingInterval(StorageFeeRangeDTO feeRangeDto) {
  618. // 求总金额
  619. BigDecimal bigDecimal = feeRangeDto.getPrice().multiply(feeRangeDto.getQty()).multiply(new BigDecimal(feeRangeDto.getDayNum()));
  620. return DateUtils.dateTime(feeRangeDto.getStartTime()) + "至" + DateUtils.dateTime(DateUtils.dateAdd(feeRangeDto.getStartTime(), (feeRangeDto.getDayNum().intValue() - 1))) +
  621. "*" + feeRangeDto.getPrice() + "元 " + feeRangeDto.getDayNum() + "天" + feeRangeDto.getQty() + WarehouseTypeEnum.getUnitCharging(feeRangeDto.getUnit())
  622. + " " + bigDecimal + "元";
  623. }
  624. /**
  625. * 数量 * 单价 * 天数
  626. *
  627. * @param itemNumsBig 数量
  628. * @param unitPrice 单价
  629. * @param dateLength 天数
  630. * @return
  631. */
  632. public BigDecimal getCalculate(BigDecimal itemNumsBig, BigDecimal unitPrice, Long dateLength) {
  633. BigDecimal money;
  634. BigDecimal bigDaysBig = new BigDecimal(dateLength);
  635. money = itemNumsBig.multiply(unitPrice).multiply(bigDaysBig);
  636. return money;
  637. }
  638. }