TmstruckWeightResultServiceImpl.java 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467
  1. package com.steerinfo.dil.service.impl;
  2. import com.steerinfo.dil.feign.QmsFeign;
  3. import com.steerinfo.dil.mapper.RulesMapper;
  4. import com.steerinfo.dil.mapper.TmstruckReceiptResultMapper;
  5. import com.steerinfo.dil.mapper.TmstruckWeightResultMapper;
  6. import com.steerinfo.dil.mapper.UtilsMapper;
  7. import com.steerinfo.dil.model.TmstruckReceiptResult;
  8. import com.steerinfo.dil.model.TmstruckWeightResult;
  9. import com.steerinfo.dil.service.ITmstruckWeightResultService;
  10. import com.steerinfo.dil.util.DataChange;
  11. import org.springframework.beans.factory.annotation.Autowired;
  12. import org.springframework.stereotype.Service;
  13. import org.springframework.transaction.annotation.Transactional;
  14. import java.math.BigDecimal;
  15. import java.text.DecimalFormat;
  16. import java.util.Date;
  17. import java.util.HashMap;
  18. import java.util.List;
  19. import java.util.Map;
  20. /**
  21. * TmstruckWeightResult服务实现:
  22. * @author generator
  23. * @version 1.0-SNAPSHORT 2021-09-09 02:21
  24. * 类描述
  25. * 修订历史:
  26. * 日期:2021-09-09
  27. * 作者:generator
  28. * 参考:
  29. * 描述:TmstruckWeightResult服务实现
  30. * @see null
  31. * @Copyright 湖南视拓信息技术股份有限公司. All rights reserved.
  32. */
  33. @Service(value = "tmstruckWeightResultService")
  34. public class TmstruckWeightResultServiceImpl implements ITmstruckWeightResultService {
  35. @Autowired
  36. private TmstruckWeightResultMapper tmstruckWeightResultMapper;
  37. @Autowired
  38. private TmstruckReceiptResultMapper tmstruckReceiptResultMapper;
  39. @Autowired
  40. private UtilsServiceImpl utilsService;
  41. @Autowired
  42. private UtilsMapper utilsMapper;
  43. @Autowired
  44. private QmsFeign qmsFeign;
  45. @Autowired
  46. private RulesServiceImpl rulesService;
  47. @Autowired
  48. private RulesMapper rulesMapper;
  49. @Autowired
  50. private TmstruckLoadResultServiceImpl tmstruckLoadResultService;
  51. @Autowired
  52. private TmstruckLeaveFactoryResultServiceImpl tmstruckLeaveFactoryResultService;
  53. /**
  54. * 查询所有计毛实绩
  55. * @param map
  56. * @return
  57. */
  58. @Override
  59. public List<Map<String, Object>> getAllJiMaoResult(Map<String, Object> map) {
  60. Integer orderType = (Integer) map.get("orderTypee");
  61. switch (orderType){
  62. case 1:
  63. return tmstruckWeightResultMapper.getXSAllJiMaoResult(map); // apiID:212
  64. case 2:
  65. break;
  66. case 3:
  67. break;
  68. case 4:
  69. return tmstruckWeightResultMapper.getSteelNzJiMaoResult(map); //apiId:264
  70. case 5:
  71. case 6:
  72. case 7:
  73. case 8:
  74. return tmstruckWeightResultMapper.getCGAllJiMaoResult(map); //apiId:102
  75. case 9:
  76. return tmstruckWeightResultMapper.getImportedDomesticNzJiMaoResult(map); // apiID:354
  77. case 10:
  78. return tmstruckWeightResultMapper.getImportedDomesticNzJiMao2Result(map); // apiID:354
  79. case 11:
  80. return tmstruckWeightResultMapper.getInFactoryJiLiangResult(map); //apiId: 358
  81. }
  82. return null;
  83. }
  84. /**
  85. * 查询所有计皮实绩
  86. * @param map
  87. * @return
  88. */
  89. @Override
  90. public List<Map<String, Object>> getAllJiPiResult(Map<String, Object> map) {
  91. Integer orderType = (Integer) map.get("orderTypee");
  92. switch (orderType){
  93. case 1:
  94. return tmstruckWeightResultMapper.getXSAllJiPiResult(map); //apiId:211
  95. case 2:
  96. break;
  97. case 3:
  98. break;
  99. case 4:
  100. return tmstruckWeightResultMapper.getSteelNzJiPiResult(map); //apiId:262
  101. case 5:
  102. case 6:
  103. case 7:
  104. case 8:
  105. return tmstruckWeightResultMapper.getCGAllJiPiResult(map); // apiId: 104
  106. case 9:
  107. return tmstruckWeightResultMapper.getImportedDomesticNzJiPiResult(map);// apiId: 104
  108. case 10:
  109. return tmstruckWeightResultMapper.getImportedDomesticNzJiPi2Result(map);// apiId: 104
  110. case 11:
  111. }
  112. return null;
  113. }
  114. /**
  115. * 派单时新增计重实绩
  116. * 总实绩ID、计皮点、计毛点
  117. * @return
  118. */
  119. @Override
  120. public int addWeightResult(Map<String, Object> map) {
  121. TmstruckWeightResult tmstruckWeightResult = new TmstruckWeightResult();
  122. //生成最大主键ID
  123. tmstruckWeightResult.setWeightTaskResultId(tmstruckWeightResultMapper.selectMaxId());
  124. tmstruckWeightResult.setResultTotalId(DataChange.dataToBigDecimal(map.get("resultTotalId")));
  125. //添加是否需要扣水扣杂
  126. tmstruckWeightResult.setIsdeduct(DataChange.dataToBigDecimal(map.get("isdeduct")));
  127. // 添加物资Id (销售、内转到异地库)
  128. tmstruckWeightResult.setMaterialId(DataChange.dataToBigDecimal(map.get("materialId")));
  129. return tmstruckWeightResultMapper.insertSelective(tmstruckWeightResult);
  130. }
  131. /**
  132. * 更新计毛实绩 采集需要的数据
  133. * 运输订单号
  134. * 汽车衡编号
  135. * 物资名称
  136. * 毛重
  137. * 毛重时间
  138. * 磅单号
  139. * @return
  140. */
  141. @Override
  142. @Transactional
  143. public int addJiMaoResult(Map<String, Object> map) {
  144. TmstruckWeightResult tmstruckWeightResult = new TmstruckWeightResult();
  145. //通过物资名称和物资规格查询物资Id
  146. int materialId = tmstruckWeightResultMapper.getMaterialIdByMaterialNameAndSpe(map);
  147. map.put("materialId", materialId);
  148. //通过传来的运输订单号与物资ID查询计重实绩
  149. map.putAll(tmstruckWeightResultMapper.selectTotalIdByOrderNo(map));
  150. generateMaoWeightResult(map, tmstruckWeightResult);
  151. BigDecimal orderId = DataChange.dataToBigDecimal(map.get("orderId"));
  152. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderTypee"));
  153. int i = 0;
  154. switch (orderType.intValue()){
  155. case 1:
  156. //添加第二次计量常规字段
  157. addUpdateRegularField(tmstruckWeightResult);
  158. //查询当前计毛是否为最后一拼(针对多拼) (查询是否还有装车实绩没有数据)
  159. List<Map<String, Object>> list = rulesMapper.judgeLastMaterial(orderId);
  160. if(list.size() == 0){
  161. //如果没有未装车的装车实绩则计算出厂门岗并更新出厂实绩
  162. BigDecimal resultTotalId = DataChange.dataToBigDecimal(map.get("resultTotalId"));
  163. //计算出厂门岗 更新出厂门岗
  164. int gatepostId = rulesService.calculateGatepost(map);
  165. i += tmstruckLeaveFactoryResultService.updateLeaveFactoryGatepostId(resultTotalId.intValue(), gatepostId);
  166. }else {
  167. //如果还有未装车的实绩 则代表还有未装车的物资 计算各个物资装车点 并更新到装车实绩中
  168. //如果是多拼 使用多种物资计算第一个装货的物资和装车点
  169. Map<String, Object> platIdMap = rulesService.calculateMaterial(list); //获得materialId loadingId
  170. platIdMap.put("orderId", map.get("orderId"));
  171. i += tmstruckLoadResultService.updateLoadingId(platIdMap); //更新装货点
  172. //更新下一计量实绩以当前毛重为皮重
  173. platIdMap.put("resultTareWeight", map.get("resultGrossWeight"));
  174. i += updateWeightResult(platIdMap);
  175. //添加仓库排队
  176. platIdMap.put("orderNumber", map.get("orderNumber"));
  177. qmsFeign.addQueueResultByCk(platIdMap);
  178. }
  179. break;
  180. case 2:
  181. case 3:
  182. break;
  183. case 4:
  184. break;
  185. case 5:
  186. case 6:
  187. case 7:
  188. case 8: //采购订单记录计毛为第一次计重 添加磅单号
  189. addInsertRegularField(tmstruckWeightResult); //插入第一次计重时间常规字段
  190. break;
  191. case 9:
  192. break;
  193. case 10:
  194. break;
  195. case 11:
  196. break;
  197. }
  198. i += tmstruckWeightResultMapper.updateByPrimaryKeySelective(tmstruckWeightResult);
  199. //路段顺序号 + 1
  200. i += utilsService.updateOrderLineSequence(map);
  201. return i;
  202. }
  203. /**
  204. * 生成计毛实体类
  205. * @param map
  206. * @return
  207. */
  208. public void generateMaoWeightResult(Map<String, Object> map, TmstruckWeightResult tmstruckWeightResult){
  209. //添加磅单号
  210. tmstruckWeightResult.setResultPoundNo((String) map.get("resultPoundNo"));
  211. //添加查询出来的主键
  212. BigDecimal weightTaskResultId = DataChange.dataToBigDecimal(map.get("weightTaskResultId"));
  213. tmstruckWeightResult.setWeightTaskResultId(weightTaskResultId);
  214. //添加毛重
  215. DecimalFormat df = new DecimalFormat("0.00");
  216. String resultGrossWeight = df.format((double) map.get("resultGrossWeight"));
  217. tmstruckWeightResult.setResultGrossWeight(new BigDecimal(resultGrossWeight));
  218. //添加毛重时间
  219. long resultGrossWeightTime = (long) map.get("resultGrossWeightTime");
  220. tmstruckWeightResult.setResultGrossWeightTime(new Date(resultGrossWeightTime));
  221. //添加净重 (如果传入的净重不为0)
  222. BigDecimal resultNetWeight = DataChange.dataToBigDecimal(map.get("resultNetWeight"));
  223. if(resultNetWeight.intValue() != 0){
  224. tmstruckWeightResult.setResultNetWeight(resultNetWeight);
  225. }
  226. //通过汽车衡编号查询汽车衡ID
  227. Integer calculateId = tmstruckWeightResultMapper.selectTruckCalculateId((String) map.get("truckCalculateNumber"));
  228. //添加计毛汽车衡
  229. if(calculateId != null){
  230. tmstruckWeightResult.setResultGrossPlaceId(new BigDecimal(calculateId));
  231. }
  232. }
  233. /**
  234. * 更新计皮实绩 需要采集的数据
  235. * 运输订单号 orderNumber
  236. * 汽车衡编号 truckCalculateNumber
  237. * 皮重 resultTareWeight
  238. * 皮重时间 resultTareWeightTime
  239. * 净重
  240. * 物资名称:materialName 物资规格:materialSpecification 型号:materialModel
  241. * @param map
  242. * @return
  243. */
  244. @Override
  245. @Transactional
  246. public int addJiPiResult(Map<String, Object> map) {
  247. TmstruckWeightResult tmstruckWeightResult = new TmstruckWeightResult();
  248. //通过物资名称和物资规格查询物资Id
  249. int materialId = tmstruckWeightResultMapper.getMaterialIdByMaterialNameAndSpe(map);
  250. map.put("materialId", materialId);
  251. //通过传来的运输订单号 与 物资ID查询计重实绩ID
  252. map.putAll(tmstruckWeightResultMapper.selectTotalIdByOrderNo(map));
  253. generatePiWeightResult(map, tmstruckWeightResult);
  254. int i = 0;
  255. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderTypee"));
  256. switch (orderType.intValue()){
  257. case 1:
  258. //销售订单计皮为第一次计重
  259. addInsertRegularField(tmstruckWeightResult);// 添加插入常规字段 就是第一次计重时间;
  260. //查询还未装车的物资
  261. List<Map<String, Object>> mapList = rulesService.judgeLastMaterial(DataChange.dataToBigDecimal(map.get("orderId")));
  262. if(mapList.size() == 1){
  263. //如果是单拼 则直接
  264. Map<String, Object> mesMap = mapList.get(0);
  265. i += tmstruckLoadResultService.updateLoadingId(mesMap); //更新装货点
  266. //添加仓库排队
  267. mesMap.put("orderNumber", map.get("orderNumber"));
  268. qmsFeign.addQueueResultByCk(mesMap);
  269. }else {
  270. //如果是多拼 使用多种物资计算第一个装货的物资和装车点
  271. Map<String, Object> platIdMap = rulesService.calculateMaterial(mapList); //获得materialId loadingId
  272. platIdMap.put("orderId", map.get("orderId"));
  273. i += tmstruckLoadResultService.updateLoadingId(platIdMap); //更新装货点
  274. //添加仓库排队
  275. platIdMap.put("orderNumber", map.get("orderNumber"));
  276. qmsFeign.addQueueResultByCk(platIdMap);
  277. }
  278. break;
  279. case 2:
  280. case 3:
  281. //销售订单计皮为第一次计重
  282. addInsertRegularField(tmstruckWeightResult);// 添加插入常规字段 就是第一次计重时间;
  283. //焦炭、水渣只有一种物资 装货点是通过发运计划的时候填写的
  284. break;
  285. case 4:
  286. break;
  287. case 5:
  288. case 6:
  289. case 7:
  290. case 8:
  291. //如果订单类型为采购订单 则执行采购订单计皮规则
  292. addUpdateRegularField(tmstruckWeightResult); // 添加更新常规字段 就是第二次计重时间
  293. //计皮作业完成后自动完成签收
  294. i += autoReceipt(DataChange.dataToBigDecimal(map.get("resultTotalId")));
  295. //计皮完成后计算出厂门岗并更新实绩出厂门岗ID
  296. i += rulesService.calculateGatepost(map);
  297. break;
  298. case 9:
  299. break;
  300. case 10:
  301. break;
  302. case 11:
  303. break;
  304. }
  305. i += tmstruckWeightResultMapper.updateByPrimaryKeySelective(tmstruckWeightResult);
  306. //路段顺序号 + 1
  307. i += utilsService.updateOrderLineSequence(map);
  308. return i;
  309. }
  310. /**
  311. * 生成计皮实绩
  312. * @param tmstruckWeightResult
  313. * @return
  314. */
  315. public void generatePiWeightResult(Map<String, Object> map, TmstruckWeightResult tmstruckWeightResult){
  316. //添加磅单号
  317. tmstruckWeightResult.setResultPoundNo((String) map.get("resultPoundNo"));
  318. //添加查询出来的主键
  319. BigDecimal resultId = (BigDecimal) map.get("weightTaskResultId");
  320. tmstruckWeightResult.setWeightTaskResultId(resultId);
  321. //添加皮重
  322. DecimalFormat df = new DecimalFormat("0.00");
  323. String resultTareWeight = df.format((double) map.get("resultTareWeight"));
  324. tmstruckWeightResult.setResultTareWeight(new BigDecimal(resultTareWeight));
  325. //添加皮重时间
  326. long resultTareWeightTime = (long) map.get("resultTareWeightTime");
  327. tmstruckWeightResult.setResultTareWeightTime(new Date(resultTareWeightTime));
  328. //添加净重 (如果传入的净重不为0)
  329. BigDecimal resultNetWeight = DataChange.dataToBigDecimal(map.get("resultNetWeight"));
  330. if(resultNetWeight.intValue() != 0){
  331. tmstruckWeightResult.setResultNetWeight(resultNetWeight);
  332. }
  333. //通过汽车衡编号查询汽车衡ID 添加计皮汽车衡
  334. Integer calculateId = tmstruckWeightResultMapper.selectTruckCalculateId((String) map.get("truckCalculateNumber"));
  335. if(calculateId != null){
  336. tmstruckWeightResult.setResultTarePlaceId(new BigDecimal(calculateId));
  337. }
  338. }
  339. /**
  340. * 更新计量实绩 计皮点 计毛点 皮重
  341. * @param map
  342. */
  343. public int updateWeightResult(Map<String, Object> map){
  344. TmstruckWeightResult tmstruckWeightResult = new TmstruckWeightResult();
  345. //通过物资ID和运输订单Id修改查找计量实绩ID
  346. Integer id = tmstruckWeightResultMapper.getWeightIdByMaterialIdAndOrderId(map);
  347. tmstruckWeightResult.setId(new BigDecimal(id));
  348. if(map.get("tarePlaceId") != null){ //如果皮重汽车衡不为空 更新皮重汽车衡
  349. tmstruckWeightResult.setResultTarePlaceId(DataChange.dataToBigDecimal(map.get("tarePlaceId")));
  350. }
  351. if(map.get("grossPlaceId") != null){//如果毛重汽车衡不为空 更新毛重汽车衡
  352. tmstruckWeightResult.setResultGrossPlaceId(DataChange.dataToBigDecimal(map.get("grossPlaceId")));
  353. }
  354. if(map.get("resultTareWeight")!= null){ //如果皮重不为空 更新皮重
  355. tmstruckWeightResult.setResultTareWeight(DataChange.dataToBigDecimal(map.get("resultTareWeight")));
  356. }
  357. return tmstruckWeightResultMapper.updateByPrimaryKeySelective(tmstruckWeightResult);
  358. }
  359. /**
  360. * 自动签收
  361. * @return
  362. */
  363. public int autoReceipt(BigDecimal resultTotalId){
  364. TmstruckReceiptResult tmstruckReceiptResult = new TmstruckReceiptResult();
  365. tmstruckReceiptResult.setResultTotalId(resultTotalId);
  366. tmstruckReceiptResult.setStatus(new BigDecimal(1));
  367. tmstruckReceiptResult.setInsertUsername("admin");
  368. tmstruckReceiptResult.setInsertTime(new Date());
  369. return tmstruckReceiptResultMapper.updateByTotalResultId(tmstruckReceiptResult);
  370. }
  371. /**
  372. * 添加首次计重时的常规字段
  373. * @param tmstruckWeightResult
  374. */
  375. public void addInsertRegularField(TmstruckWeightResult tmstruckWeightResult){
  376. tmstruckWeightResult.setInsertTime(new Date());
  377. tmstruckWeightResult.setInsertUsername("admin");
  378. tmstruckWeightResult.setInsertUpdateRemark("无");
  379. }
  380. /**
  381. * 添加第二次计重时的常规字段
  382. * @param tmstruckWeightResult
  383. */
  384. public void addUpdateRegularField(TmstruckWeightResult tmstruckWeightResult){
  385. tmstruckWeightResult.setUpdateTime(new Date());
  386. tmstruckWeightResult.setUpdateUsername("admin");
  387. }
  388. /**
  389. * 多拼计算计毛汽车衡
  390. * @param map
  391. */
  392. public int calculateTruckCalculate(Map<String, Object> map, Integer resultTotalId){
  393. //通过总实绩ID查询订单Id
  394. Integer orderId = utilsService.getOrderIdByTotalId(resultTotalId);
  395. //查询未装车的装车实绩
  396. List<Map<String, Object>> list = rulesService.judgeLastMaterial(new BigDecimal(orderId));
  397. Map<String, Object> mesMap = new HashMap<>(); //用于查询更新存放数据map
  398. mesMap.put("orderId", orderId);
  399. int i = 0;
  400. if(list.size() == 0){
  401. //如果是最后一拼则走出厂称 计算出厂称
  402. mesMap.put("materialId", map.get("materialId"));
  403. mesMap.put("nature", 1);
  404. Integer calculate = rulesService.calculateWeighbridge(mesMap);
  405. //更新汽车衡
  406. mesMap.put("grossPlaceId", calculate);
  407. i += updateWeightResult(mesMap);
  408. }else {
  409. //如果后面还有物资未装车 则走拼装秤 10号秤 (固定数据)
  410. mesMap.put("materialId", map.get("materialId"));
  411. mesMap.put("grossPlaceId", 10);
  412. i += updateWeightResult(mesMap);
  413. }
  414. return i;
  415. }
  416. /**
  417. * 单拼销售计算汽车衡
  418. * @return
  419. */
  420. public int calculateTruckCalculateByOne(Map<String, Object> map, Integer type){
  421. String orderNumber = (String) map.get("orderNumber");
  422. //通过运输订单号查找物资ID、订单ID
  423. Map<String, Object> oIdAndMidMap = tmstruckWeightResultMapper.getOrderIdAndMaterialIdByOrderNum(orderNumber);
  424. //通过物资ID计算汽车衡
  425. if(type == 1){
  426. //1:进厂
  427. oIdAndMidMap.put("nature", type); //1: 进厂秤
  428. int calculateId = rulesService.calculateWeighbridge(oIdAndMidMap);
  429. oIdAndMidMap.put("tarePlaceId", calculateId);
  430. }else if(type == 2){
  431. //2:出厂
  432. oIdAndMidMap.put("nature", type); //2: 出厂称
  433. int calculateId = rulesService.calculateWeighbridge(oIdAndMidMap);
  434. oIdAndMidMap.put("grossPlaceId", calculateId);
  435. }
  436. return updateWeightResult(oIdAndMidMap);
  437. }
  438. }