OmstruckOrderServiceImpl.java 62 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474
  1. package com.steerinfo.dil.service.impl;
  2. import com.steerinfo.dil.feign.AmsFeign;
  3. import com.steerinfo.dil.feign.IMFeign;
  4. import com.steerinfo.dil.feign.TmsTruckFeign;
  5. import com.steerinfo.dil.mapper.*;
  6. import com.steerinfo.dil.model.*;
  7. import com.steerinfo.dil.service.IOmstruckOrderService;
  8. import com.steerinfo.dil.util.DataChange;
  9. import org.springframework.beans.factory.annotation.Autowired;
  10. import org.springframework.stereotype.Service;
  11. import org.springframework.transaction.annotation.Transactional;
  12. import java.math.BigDecimal;
  13. import java.util.*;
  14. /**
  15. * OmstruckOrder服务实现:
  16. *
  17. * @author generator
  18. * @version 1.0-SNAPSHORT 2021-10-15 09:37
  19. * 类描述
  20. * 修订历史:
  21. * 日期:2021-10-15
  22. * 作者:generator
  23. * 参考:
  24. * 描述:OmstruckOrder服务实现
  25. * @Copyright 湖南视拓信息技术股份有限公司. All rights reserved.
  26. * @see null
  27. */
  28. @Service(value = "omstruckOrderService")
  29. public class OmstruckOrderServiceImpl implements IOmstruckOrderService {
  30. @Autowired
  31. private OmstruckOrderMapper omstruckOrderMapper;
  32. @Autowired
  33. private OmstruckOrderMaterialMapper omstruckOrderMaterialMapper;
  34. @Autowired
  35. private AmsFeign amsFeign;
  36. @Autowired
  37. private TmsTruckFeign tmsTruckFeign;
  38. @Autowired
  39. private IMFeign imFeign;
  40. @Autowired
  41. RmsCapacityMapper rmsCapacityMapper;
  42. @Autowired
  43. RmsDriverCapacityMapper rmsDriverCapacityMapper;
  44. @Autowired
  45. AmstruckInwardPlanMapper amstruckInwardPlanMapper;
  46. /**
  47. * 用于远程调用运输订单新增
  48. *
  49. * @param omstruckOrder
  50. * @return
  51. */
  52. @Override
  53. public int insertSelective(OmstruckOrder omstruckOrder) {
  54. return omstruckOrderMapper.insertSelective(omstruckOrder);
  55. }
  56. /**
  57. * 查询所有运输订单
  58. * 获取已下发的运输订单 用于websocket
  59. *
  60. * @param map
  61. * @return
  62. */
  63. @Override
  64. public List<Map<String, Object>> getAllTruckOrder(Map<String, Object> map) {
  65. return omstruckOrderMapper.getAllTruckOrder(map);
  66. }
  67. /**
  68. * 新增运输订单
  69. *
  70. * @param map
  71. * @return
  72. */
  73. @Override
  74. @Transactional
  75. public int addPurOrder(Map<String, Object> map) {
  76. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  77. int i = 0;
  78. switch (orderType.intValue()) {
  79. case 1:
  80. i = dispatchSteelOrder(map);//新增销售订单
  81. break;
  82. case 2:
  83. i = dispatchSteelOrder(map);//新增水渣发运计划订单
  84. break;
  85. case 3:
  86. i = dispatchSteelOrder(map);//新增焦炭发运计划订单
  87. break;
  88. case 4:
  89. break;
  90. case 5:
  91. case 6:
  92. case 7:
  93. i = addCGPurOrders(map);
  94. break;
  95. case 8:
  96. i = addCGPurOrder(map); //新增采购运输订单
  97. break;
  98. case 9:
  99. break;
  100. case 10:
  101. break;
  102. case 11:
  103. }
  104. return i;
  105. }
  106. /**
  107. * 新增采购其他订单
  108. * @return
  109. */
  110. public int addCGPurOrders(Map<String, Object> map){
  111. //从map中获取司机运力列表
  112. List<Map<String, Object>> driverCapacityIdList = (List<Map<String, Object>>) map.get("driverCapacityIdList");
  113. BigDecimal purchaseOrderId = DataChange.dataToBigDecimal(map.get("purchaseOrderId"));
  114. //物资ID
  115. Object materialId = map.get("materialId");
  116. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  117. //预计进厂时间
  118. Date orderEntryTime = new Date((long) map.get("orderEntryTime"));
  119. int count = 0;
  120. for (Map<String, Object> capacityMap : driverCapacityIdList) {
  121. //添加运输订单
  122. OmstruckOrder omstruckOrder = generateOmsTruckOrder(map);
  123. omstruckOrder.setOrderPlanId(purchaseOrderId);
  124. omstruckOrder.setDriverCapacityId(DataChange.dataToBigDecimal(capacityMap.get("driverCapacityId"))); //添加运力排班ID
  125. omstruckOrder.setOrderEntryTime(orderEntryTime);
  126. omstruckOrder.setLineId(new BigDecimal(1)); // 设置线路 遗留问题
  127. count += omstruckOrderMapper.insertSelective(omstruckOrder);
  128. BigDecimal orderId = omstruckOrder.getOrderId();
  129. //添加运输订单子表
  130. capacityMap.put("materialId", materialId);
  131. capacityMap.put("orderType", orderType);
  132. addOrderMaterial(capacityMap,orderId);
  133. //添加总实绩
  134. capacityMap.put("orderId", orderId);
  135. tmsTruckFeign.addTotalResult(map);
  136. //更改运力状态
  137. }
  138. return count;
  139. }
  140. /**
  141. * 新增采购进口矿运输订单订单
  142. *
  143. * @param map
  144. * @return
  145. */
  146. @Transactional
  147. public int addCGPurOrder(Map<String, Object> map) {
  148. //生成运输订单号和主键
  149. OmstruckOrder omstruckOrder = generateOmsTruckOrder(map);
  150. //设置线路 遗留问题
  151. omstruckOrder.setLineId(new BigDecimal(1));
  152. Object orderEntryTime = map.get("orderEntryTime");
  153. if (orderEntryTime != null) {
  154. omstruckOrder.setOrderEntryTime(new Date((long) orderEntryTime)); //新增预计进厂时间
  155. }
  156. if (map.get("orderMaterialWeight") != null) {
  157. amsFeign.updateMaterial(map); //更改运输计划子表 增加已分配重量 减少未分配重量 feign调用ams
  158. }
  159. //添加运力Id
  160. BigDecimal driverCapacityId = DataChange.dataToBigDecimal(map.get("driverCapacityId"));
  161. omstruckOrder.setDriverCapacityId(driverCapacityId);
  162. //新增运输订单
  163. omstruckOrderMapper.insertSelective(omstruckOrder);
  164. //更新运力状态为待运输:2
  165. // map.put("capacityStatus", 2);
  166. // omstruckOrderMapper.updateCapacityByCarIdOrNum(map);
  167. //新增运输订单子表
  168. addOrderMaterial(map, omstruckOrder.getOrderId());
  169. //新增实绩总表关联订单 feign 调用truckTms
  170. map.put("orderId", omstruckOrder.getOrderId());
  171. tmsTruckFeign.addTotalResult(map);
  172. return 1;
  173. }
  174. /**
  175. * 生成运输订单实体类
  176. */
  177. public OmstruckOrder generateOmsTruckOrder(Map<String, Object> map) {
  178. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  179. OmstruckOrder omstruckOrder = new OmstruckOrder();
  180. //生成订单主键Id
  181. BigDecimal maxId = omstruckOrderMapper.selectMaxId();
  182. omstruckOrder.setOrderId(maxId);
  183. //生成运输订单号
  184. int id = maxId.intValue();
  185. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", id);
  186. omstruckOrder.setOrderNumber(orderNumber);
  187. //运单状态 刚分配默认为未下发
  188. omstruckOrder.setOrderStatus(new BigDecimal(3));
  189. switch (orderType.intValue()) {
  190. case 1:
  191. omstruckOrder.setOrderPlanId(DataChange.dataToBigDecimal(map.get("saleOrderMaterialId")));
  192. break;
  193. case 2:
  194. omstruckOrder.setOrderPlanId(DataChange.dataToBigDecimal(map.get("dayPlanId")));
  195. break;
  196. case 3:
  197. omstruckOrder.setOrderPlanId(DataChange.dataToBigDecimal(map.get("dayPlanId")));
  198. break;
  199. case 4:
  200. break;
  201. case 5:
  202. case 6:
  203. case 7:
  204. case 8:
  205. if (map.get("purchaseOrderId") != null)
  206. omstruckOrder.setOrderPlanId(DataChange.dataToBigDecimal(map.get("purchaseOrderId")));
  207. if (map.get("unloadPointId") != null) // 添加卸货点
  208. omstruckOrder.setUnloadPointId(DataChange.dataToBigDecimal(map.get("unloadPointId")));
  209. break;
  210. case 9:
  211. break;
  212. case 10:
  213. break;
  214. case 11:
  215. }
  216. //添加订单类型
  217. omstruckOrder.setOrderType(orderType);
  218. omstruckOrder.setInsertUsername("admin");
  219. omstruckOrder.setInsertTime(new Date());
  220. return omstruckOrder;
  221. }
  222. /**
  223. * 新增订单子表
  224. *
  225. * @param map
  226. * @param
  227. */
  228. public void addOrderMaterial(Map<String, Object> map, BigDecimal orderId) {
  229. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  230. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  231. switch (orderType.intValue()) {
  232. case 1:
  233. //获得销售物资id
  234. //生成子表主键
  235. omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
  236. Integer saleOrderMaterialId = (Integer) map.get("saleOrderMaterialId");
  237. //通过车序号id查找物资件数和物资重量
  238. Map<String, Object> map1 = omstruckOrderMapper.selectTheoreticalWeightAndMaterialNumber(saleOrderMaterialId);
  239. BigDecimal materialNumber = (BigDecimal) map1.get("materialNumber");
  240. BigDecimal weight = (BigDecimal) map1.get("weight");
  241. //设置物资理重和物资件数
  242. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(weight));
  243. omstruckOrderMaterial.setOrderMaterialNumber(DataChange.dataToBigDecimal(materialNumber));
  244. //通过销售订单车序号id查找物资id
  245. List<Map<String, Object>> materialList = omstruckOrderMapper.selectMaterialIdBysaleOrderMaterialId(saleOrderMaterialId);
  246. for (int i = 0; i < materialList.size(); i++) {
  247. Map<String, Object> map2 = materialList.get(i);
  248. BigDecimal materialId = (BigDecimal) map2.get("materialId");
  249. omstruckOrderMaterial.setMaterialId(materialId);
  250. }
  251. //执行新增
  252. omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  253. break;
  254. case 2:
  255. //获取发运计划id
  256. //生成子表主键
  257. omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
  258. Integer dayPlanId = (Integer) map.get("dayPlanId");
  259. //设置订单id
  260. omstruckOrderMaterial.setOrderId(orderId);
  261. //根据发运计划id查找物资id和物资重量
  262. map = omstruckOrderMapper.selectMaterialIdAndWeightByDayPlanId(dayPlanId);
  263. BigDecimal materialId = (BigDecimal) map.get("materialId");
  264. BigDecimal materialWeight = (BigDecimal) map.get("materialWeight");
  265. //设置物资id
  266. omstruckOrderMaterial.setMaterialId(DataChange.dataToBigDecimal(materialId));
  267. //设置物资重量
  268. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(materialWeight));
  269. omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  270. break;
  271. case 3:
  272. //获取发运计划id
  273. //生成子表主键
  274. omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
  275. Integer dayPlanId1 = (Integer) map.get("dayPlanId");
  276. //设置订单id
  277. omstruckOrderMaterial.setOrderId(orderId);
  278. //根据发运计划id查找物资id和物资重量
  279. map = omstruckOrderMapper.selectMaterialIdAndWeightByDayPlanId(dayPlanId1);
  280. BigDecimal materialId1 = (BigDecimal) map.get("materialId");
  281. BigDecimal materialWeight1 = (BigDecimal) map.get("materialWeight");
  282. //设置物资id
  283. omstruckOrderMaterial.setMaterialId(DataChange.dataToBigDecimal(materialId1));
  284. //设置物资重量
  285. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(materialWeight1));
  286. omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  287. break;
  288. case 4:
  289. break;
  290. case 5:
  291. case 6:
  292. case 7:
  293. case 8:
  294. //生成子表主键
  295. omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
  296. omstruckOrderMaterial.setMaterialId(DataChange.dataToBigDecimal(map.get("materialId")));
  297. omstruckOrderMaterial.setOrderId(orderId);
  298. if (map.get("orderMaterialWeight") != null) // 采购辅料没有物资重量
  299. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(map.get("orderMaterialWeight")));
  300. if(map.get("orderMaterialNumber") != null) // 辅料可能有物资件数
  301. omstruckOrderMaterial.setOrderMaterialNumber(DataChange.dataToBigDecimal(map.get("orderMaterialNumber")));
  302. omstruckOrderMaterial.setInsertUsername("admin");
  303. omstruckOrderMaterial.setInsertTime(new Date());
  304. omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  305. break;
  306. case 9:
  307. break;
  308. case 10:
  309. break;
  310. case 11:
  311. }
  312. }
  313. /**
  314. * 修改运输订单 和订单子表
  315. *
  316. * @param map
  317. * @return
  318. */
  319. @Override
  320. @Transactional
  321. public int updateOrder(Map<String, Object> map) {
  322. //修改运输订单运力ID
  323. OmstruckOrder omstruckOrder = new OmstruckOrder();
  324. BigDecimal orderId = DataChange.dataToBigDecimal(map.get("orderId"));
  325. omstruckOrder.setOrderId(orderId);
  326. if (map.get("unloadPointId") != null) {
  327. omstruckOrder.setUnloadPointId(DataChange.dataToBigDecimal(map.get("unloadPointId")));
  328. }
  329. if (map.get("capacityId") != null) {
  330. omstruckOrder.setCapacityId(DataChange.dataToBigDecimal(map.get("capacityId")));
  331. }
  332. if(map.get("orderEntryTime") != null){
  333. omstruckOrder.setOrderEntryTime(new Date((long) map.get("orderEntryTime")));
  334. }
  335. if(map.get("unloadPointId")!=null || map.get("capacityId") != null || map.get("orderEntryTime") != null){
  336. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  337. }
  338. Integer orderType = (Integer) map.get("orderType");
  339. switch (orderType) {
  340. case 1:
  341. break;
  342. case 2:
  343. break;
  344. case 3:
  345. break;
  346. case 4:
  347. break;
  348. case 5:
  349. case 6:
  350. case 7:
  351. case 8:
  352. //修改运输订单子表物资重量
  353. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  354. //添加子表主键 通过订单ID查询出子表主键
  355. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.getOrderMaterialIdByOrderId(DataChange.dataToBigDecimal(map.get("orderId")));
  356. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  357. if (map.get("orderMaterialWeight") != null) {
  358. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(map.get("orderMaterialWeight")));
  359. if(orderType == 8)
  360. amsFeign.updateMaterial(map);//修改运输计划子表 已分配未分配重量
  361. }
  362. if(map.get("orderMaterialNumber") != null) {
  363. omstruckOrderMaterial.setOrderMaterialNumber(DataChange.dataToBigDecimal(map.get("orderMaterialNumber")));
  364. }
  365. if (map.get("materialId") != null) {
  366. omstruckOrderMaterial.setMaterialId(DataChange.dataToBigDecimal(map.get("materialId")));
  367. }
  368. omstruckOrderMaterialMapper.updateByPrimaryKeySelective(omstruckOrderMaterial);
  369. break;
  370. case 9:
  371. break;
  372. case 10:
  373. break;
  374. case 11:
  375. }
  376. return 1;
  377. }
  378. /**
  379. * 逻辑删除未下发订单
  380. *
  381. * @param map
  382. * @return
  383. */
  384. @Override
  385. @Transactional
  386. public int deleteOrder(Map<String, Object> map) {
  387. OmstruckOrder omstruckOrder = new OmstruckOrder();
  388. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(map.get("orderId")));
  389. //设置状态为逻辑删除:7
  390. omstruckOrder.setOrderStatus(new BigDecimal(7));
  391. int i = omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  392. //若是传来物资重量则修改已分配未分配重量
  393. if (map.get("orderMaterialWeight") != null) {
  394. amsFeign.updateMaterial(map); //feign调用
  395. }
  396. // //通过车牌号修改运输状态为空闲中 0
  397. // String capacityNumber = (String) map.get("capacityNumber");
  398. // HashMap<String, Object> changeStatusMap = new HashMap<>();
  399. // changeStatusMap.put("capacityNumber", capacityNumber);
  400. // changeStatusMap.put("capacityStatus", 0);
  401. // int i1 = omstruckOrderMapper.updateCapacityByCarIdOrNum(changeStatusMap);
  402. return i;
  403. }
  404. /**
  405. * 运单派发
  406. * 运单ID
  407. *
  408. * @param map
  409. * @return
  410. */
  411. @Override
  412. @Transactional
  413. public int dispatchOrder(Map<String, Object> map) {
  414. OmstruckOrder omstruckOrder = new OmstruckOrder();
  415. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(map.get("orderId")));
  416. //设置状态为已下发:4
  417. //生成订单下发时间 修改订单表
  418. //添加卸货点ID
  419. if (map.get("unloadPointId") != null) {
  420. omstruckOrder.setUnloadPointId(DataChange.dataToBigDecimal(map.get("unloadPointId")));
  421. }
  422. omstruckOrder.setOrderIssueTime(new Date());
  423. omstruckOrder.setOrderStatus(new BigDecimal(4));
  424. pushMesToWebsocket(map); //下发 推送数据给 websocket
  425. return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  426. }
  427. /**
  428. * 发送消息到 websocket 推送消息
  429. * orderId 订单Id (unloadPointId)卸货点Id
  430. * @return
  431. */
  432. public void pushMesToWebsocket(Map<String, Object> map) {
  433. Map<String, Object> mesMap = omstruckOrderMapper.pushMesToWebsocket(map);
  434. //添加消息实体
  435. HashMap<Object, Object> mapp = new HashMap<>();
  436. mapp.put("messageType", 2);
  437. mapp.put("sendPerson", "system");
  438. mapp.put("receivePerson", mesMap.get("capacityNumber"));
  439. mapp.put("messageContent", mesMap);
  440. mapp.put("createTime", new Date());
  441. ArrayList<Object> list = new ArrayList<>();
  442. list.add(mapp);
  443. //调用websocket接口推送
  444. HashMap<Object, Object> sendMap = new HashMap<>();
  445. //将消息实体放入list中存到map中
  446. sendMap.put("messages", list);
  447. String s = imFeign.sendToUser(sendMap);
  448. System.out.println(s);
  449. }
  450. /**
  451. * 销售物流,下发订单
  452. *
  453. * @param map
  454. * @return
  455. */
  456. @Override
  457. public int dispatchOrderForSale(Map<String, Object> map) {
  458. OmstruckOrder omstruckOrder = new OmstruckOrder();
  459. Integer orderId = (Integer) map.get("orderId");
  460. Integer orderType = (Integer) map.get("orderType");
  461. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
  462. if (orderType == 2 || orderType == 3) {
  463. Integer loadId = (Integer) map.get("LoadId");
  464. if (loadId != null) {
  465. //根据运输订单id查找装车实绩id
  466. omstruckOrder.setUnloadPointId(DataChange.dataToBigDecimal(loadId));
  467. }
  468. }
  469. //设置下发状态
  470. omstruckOrder.setOrderIssueTime(new Date());
  471. omstruckOrder.setOrderStatus(new BigDecimal(4));
  472. // pushMesToWebsocket(map); //下发 推送数据给 websocket
  473. return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  474. }
  475. @Override
  476. public List<Map<String, Object>> selectWaterSlagForOrder(Map<String, Object> map) {
  477. return omstruckOrderMapper.selectWaterSlagForOrder(map);
  478. }
  479. @Override
  480. public List<Map<String, Object>> selectCokeRailPlanForOrder(Map<String, Object> map) {
  481. return omstruckOrderMapper.selectCokeRailPlanForOrder(map);
  482. }
  483. /**
  484. * 司机接单、拒绝 0:拒绝 1:接收
  485. * 需要接收参数 主键Id 与 接收拒绝操作码
  486. *
  487. * @param map
  488. * @return
  489. */
  490. @Override
  491. public int driverReceiveOrRefuse(Map<String, Object> map) {
  492. OmstruckOrder omstruckOrder = new OmstruckOrder();
  493. if((Integer) map.get("orderReceiveStatus") == 1){
  494. omstruckOrder.setOrderReceiveStatus(new BigDecimal(1));
  495. omstruckOrder.setOrderStatus(new BigDecimal(5)); //5 :已接收
  496. //添加实绩
  497. addSomeResult(DataChange.dataToBigDecimal(map.get("orderId")).intValue());
  498. }else { //其他状态都视为 拒绝接单
  499. omstruckOrder.setOrderReceiveStatus(new BigDecimal(0));
  500. omstruckOrder.setOrderStatus(new BigDecimal(6));
  501. //添加拒绝原因
  502. omstruckOrder.setInsertUpdateRemark((String) map.get("insertUpdateRemark"));
  503. // //将司机运力置为空闲 通过运输订单Id 查询运力ID
  504. // BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByOrderOrNum(map);
  505. // map.put("capacityId", capacityId);
  506. // map.put("capacityStatus", 0);
  507. // omstruckOrderMapper.updateCapacityByCarIdOrNum(map);
  508. }
  509. BigDecimal orderId = DataChange.dataToBigDecimal(map.get("orderId"));
  510. omstruckOrder.setOrderId(orderId);
  511. //生成接收/拒绝时间
  512. Date receiveTime = new Date();
  513. omstruckOrder.setOrderReceiveRefuseTime(receiveTime);
  514. //计算司机从派单到操作时长
  515. Date issueTime = omstruckOrderMapper.getInsertTimeById(orderId.intValue());
  516. long time = receiveTime.getTime() - issueTime.getTime();
  517. long min = time / (1000 * 60);
  518. omstruckOrder.setOrderCommunicationDuration(new BigDecimal(min));
  519. return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  520. }
  521. /**
  522. * 司机接收订单自动生成实绩
  523. *
  524. * @param orderId
  525. */
  526. public void addSomeResult(Integer orderId) {
  527. //通过运输订单ID 总实绩ID
  528. Map<String, Object> numMap = new HashMap<>();
  529. numMap.put("orderId", orderId);
  530. Map<String, Object> map = omstruckOrderMapper.getResultTotalIdByOrderNumAndId(numMap);
  531. //通过运输订单ID查询运输订单子表有几种物资 :物资ID
  532. List<Integer> materialIdList = omstruckOrderMapper.getMaterialIdListByOrderId(orderId);
  533. //生成进厂实绩
  534. tmsTruckFeign.addEnFactoryResult(map);
  535. //生成出厂实绩
  536. tmsTruckFeign.addLeaveFactory(map);
  537. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  538. switch (orderType.intValue()) {
  539. case 1:
  540. //如果有多种物资 就添加多条装车实绩和计量实绩
  541. for (Integer materialId : materialIdList) {
  542. map.put("materialId", materialId);
  543. tmsTruckFeign.addWeightResult(map);
  544. tmsTruckFeign.addLoadResult(map);
  545. }
  546. break;
  547. case 2:
  548. case 3:
  549. map.put("materialId", materialIdList.get(0)); //只会存在一种物资
  550. tmsTruckFeign.addWeightResult(map);
  551. tmsTruckFeign.addLoadResult(map);
  552. break;
  553. case 4:
  554. break;
  555. case 5:
  556. case 6:
  557. case 7:
  558. case 8:
  559. map.put("materialId", materialIdList.get(0)); //只会存在一种物资
  560. map.put("isdeduct", 1);
  561. tmsTruckFeign.addWeightResult(map);
  562. tmsTruckFeign.addUnloadResult(map); //feign调用
  563. break;
  564. case 9:
  565. break;
  566. case 10:
  567. break;
  568. case 11:
  569. }
  570. }
  571. //根据承运商获取销售订单
  572. @Override
  573. public List<Map<String, Object>> selectSaleOrderForCarrier(Map<String, Object> map) {
  574. Integer carrierId = (Integer) map.get("carrierId");
  575. List<Map<String, Object>> maps = omstruckOrderMapper.selectSaleMaterialIdByCarrierId(carrierId);
  576. List<Map<String, Object>> list = null;
  577. for (Map<String, Object> map1 : maps) {
  578. BigDecimal saleOrderMaterialId = (BigDecimal) map1.get("saleOrderMaterialId");
  579. list = omstruckOrderMapper.selectSaleBySaleOrderMaterialId(saleOrderMaterialId.intValue());
  580. }
  581. return list;
  582. }
  583. /**
  584. * 查询已接收的焦炭发运计划
  585. *
  586. * @param
  587. * @return
  588. */
  589. @Override
  590. public List<Map<String, Object>> selectCokeDayPlanAndRecived(Map<String, Object> map) {
  591. return omstruckOrderMapper.selectCokeDayPlanAndRecived(map);
  592. }
  593. /**
  594. * 查询已接收的水渣发运计划
  595. *
  596. * @param
  597. * @return
  598. */
  599. @Override
  600. public List<Map<String, Object>> selectWaterSlagDayPlanAndRecived(Integer carrierId) {
  601. return omstruckOrderMapper.selectWaterSlagDayPlanAndRecived(carrierId);
  602. }
  603. /**
  604. * 司机接单推送数据
  605. * 车牌号
  606. *
  607. * @param
  608. * @return
  609. */
  610. @Override
  611. public List<Map<String, Object>> sendMesToDriver(Map<String, Object> map) {
  612. //通过车牌号匹配运力ID
  613. BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum((String) map.get("capacityNumber"));
  614. if (capacityId == null) {
  615. return null;
  616. }
  617. map.put("capacityId", capacityId);
  618. //通过运力Id匹配 已下发的运输订单
  619. List<Map<String, Object>> truckOrderByCapacityNum;
  620. if ((Integer) map.get("orderType") == 1 || (Integer) map.get("orderType") == 2) {
  621. truckOrderByCapacityNum = omstruckOrderMapper.getSaleTruckOrderByCapacityNum(map);
  622. } else {
  623. truckOrderByCapacityNum = omstruckOrderMapper.getTruckOrderByCapacityNum(map);
  624. }
  625. return truckOrderByCapacityNum;
  626. }
  627. /**
  628. * 得到作业时间和地点
  629. *
  630. * @param orderId
  631. * @return
  632. */
  633. @Override
  634. public List<Map<String, Object>> selectPlaceAndTime(BigDecimal orderId) {
  635. List<Map<String, Object>> mapList = omstruckOrderMapper.selectPlaceAndTime(orderId);
  636. Map<String, Object> map = mapList.get(0);
  637. String entryGatepost = (String) map.get("entryGatepost");
  638. Date entryTime = (Date) map.get("entryTime");
  639. String entryResult = entryGatepost + "/" + entryTime;
  640. String grossCalculate = (String) map.get("grossCalculate");
  641. Date grossTime = (Date) map.get("grossTime");
  642. String grossResult = grossCalculate + "/" + grossTime;
  643. String unloadWarhouse = (String) map.get("unloadWarhouse");
  644. Date unloadTime = (Date) map.get("unloadTime");
  645. String unloadResult = unloadWarhouse + "/" + unloadTime;
  646. String tareCalculate = (String) map.get("tareCalculate");
  647. Date tareTime = (Date) map.get("tareTime");
  648. String tareResult = tareCalculate + "/" + tareTime;
  649. String leaveGatepost = (String) map.get("leaveGatepost");
  650. Date outTime = (Date) map.get("outTime");
  651. String leaveResult = leaveGatepost + "/" + outTime;
  652. String receiptWarhouse = (String) map.get("receiptWarhouse");
  653. Date receiptTime = (Date) map.get("receiptTime");
  654. String receiptResult = receiptWarhouse + "/" + receiptTime;
  655. List<Map<String, Object>> resultList = new ArrayList<>();
  656. Map<String, Object> map1 = new HashMap<>();
  657. map1.put("title", "进厂门岗/时间");
  658. map1.put("desc", entryResult);
  659. resultList.add(map1);
  660. Map<String, Object> map2 = new HashMap<>();
  661. map2.put("title", "毛重衡器/时间");
  662. map2.put("desc", grossResult);
  663. resultList.add(map2);
  664. Map<String, Object> map3 = new HashMap<>();
  665. map3.put("title", "卸货地点/时间");
  666. map3.put("desc", unloadResult);
  667. resultList.add(map3);
  668. Map<String, Object> map4 = new HashMap<>();
  669. map4.put("title", "皮重衡器/时间");
  670. map4.put("desc", tareResult);
  671. resultList.add(map4);
  672. Map<String, Object> map5 = new HashMap<>();
  673. map5.put("title", "出厂门岗/时间");
  674. map5.put("desc", leaveResult);
  675. resultList.add(map5);
  676. if ((Integer) map.get("orderType") == 1) {
  677. Map<String, Object> map6 = new HashMap<>();
  678. map5.put("title", "异地库/时间");
  679. map5.put("desc", receiptResult);
  680. resultList.add(map6);
  681. }
  682. Map<String, Object> map7 = new HashMap<>();
  683. BigDecimal orderLineSequence = (BigDecimal) map.get("orderLineSequence");
  684. map7.put("orderLineSequence", orderLineSequence);
  685. resultList.add(map7);
  686. return resultList;
  687. }
  688. /**
  689. * 查询已下发未接受的销售订单信息
  690. *
  691. * @param orderType
  692. * @return
  693. */
  694. @Override
  695. public List<Map<String, Object>> getOrderUnReceive(BigDecimal orderType) {
  696. return omstruckOrderMapper.getOrderUnReceive(orderType);
  697. }
  698. /**
  699. * 查询已下发已接受的销售订单信息
  700. *
  701. * @param orderType
  702. * @return
  703. */
  704. @Override
  705. public List<Map<String, Object>> getOrderReceived(BigDecimal orderType) {
  706. return omstruckOrderMapper.getOrderReceived(orderType);
  707. }
  708. /**
  709. * 分派钢材销售订单
  710. *
  711. * @param map
  712. * @return
  713. */
  714. @Override
  715. public int dispatchSteelOrder(Map<String, Object> map) {
  716. //新增运单(销售钢材订单)
  717. //生成运输订单号和主键以及绑定运力
  718. OmstruckOrder omstruckOrder = generateOmsTruckOrder(map);
  719. //设置线路 遗留问题,设置为进门门岗
  720. omstruckOrder.setLineId(new BigDecimal(1));
  721. //新增运输订单
  722. omstruckOrderMapper.insertSelective(omstruckOrder);
  723. //更新运力状态为待运输:2
  724. map.put("capacityStatus", 2);
  725. omstruckOrderMapper.updateCapacityById(map);
  726. //新增运输订单子表
  727. addOrderMaterial(map, omstruckOrder.getOrderId());
  728. //新增实绩总表关联订单 feign调用
  729. map.put("orderId", omstruckOrder.getOrderId());
  730. tmsTruckFeign.addTotalResult(map);
  731. return 6;
  732. }
  733. //设置销售订单下发状态
  734. @Override
  735. public int IssueSteelOrder(Map<String, Object> map) {
  736. //设置下发状态
  737. OmstruckOrder omstruckOrder = new OmstruckOrder();
  738. Integer orderId = (Integer) map.get("orderId");
  739. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
  740. omstruckOrder.setOrderIssueTime(new Date());
  741. //设置下发状态值:4
  742. omstruckOrder.setOrderStatus(new BigDecimal(4));
  743. return 2;
  744. }
  745. //销售模块查看所有订单
  746. @Override
  747. public List<Map<String, Object>> selectAllOrderForSale(Map<String, Object> map) {
  748. //map获取承运商
  749. Integer carrierId = (Integer) map.get("carrierId");
  750. Integer saleOrderMaterialId = (Integer) map.get("saleOrderMaterialId");
  751. List<Map<String, Object>> maps = omstruckOrderMapper.selectSaleMaterialIdByCarrierId(carrierId);
  752. //根据车序号查找运输订单
  753. List<Map<String, Object>> mapList = null;
  754. List<Map<String, Object>> maps1 = new ArrayList<>();
  755. //判断获取的车序号是否属于承运商
  756. for (Map<String, Object> map1 : maps) {
  757. BigDecimal compareNum = DataChange.dataToBigDecimal(map1.get("saleOrderMaterialId"));
  758. if (compareNum.intValue() == saleOrderMaterialId) {
  759. mapList = omstruckOrderMapper.selectAllOrderForSale(map);
  760. for (int i = 0; i < mapList.size(); i++) {
  761. Map<String, Object> map2 = mapList.get(i);
  762. if (map2.get("orderId") == null) {
  763. return maps1;
  764. }
  765. }
  766. return mapList;
  767. }
  768. }
  769. return maps1;
  770. }
  771. @Override
  772. public List<Map<String, Object>> selectTransportOrderForSale(Map<String, Object> map) {
  773. return omstruckOrderMapper.selectTransportOrderForSale(map);
  774. }
  775. @Override
  776. public List<Map<String, Object>> selectSteelSaleForCarrier(Map<String, Object> map) {
  777. return omstruckOrderMapper.selectSteelSaleForCarrier(map);
  778. }
  779. //根据销售订单id查找信息
  780. @Override
  781. public List<Map<String, Object>> selectInfoBySaleOrderId(Integer saleOrderId) {
  782. return omstruckOrderMapper.selectInfoBySaleOrderId(saleOrderId);
  783. }
  784. @Override
  785. public List<Map<String, Object>> selectCokeRailPlan(Map<String, Object> map) {
  786. return omstruckOrderMapper.selectCokeRailPlan(map);
  787. }
  788. @Override
  789. public List<Map<String, Object>> selectInfoByDayPlanId(Map<String, Object> map) {
  790. return omstruckOrderMapper.selectInfoByDayPlanId(map);
  791. }
  792. /**
  793. * 查找司机排班表信息
  794. *
  795. * @param map
  796. * @return
  797. */
  798. @Override
  799. public List<Map<String, Object>> selectCapacityAndDriver(Map<String, Object> map) {
  800. return omstruckOrderMapper.selectCapacityAndDriver(map);
  801. }
  802. /**
  803. * 查询所有运力信息
  804. *
  805. * @return
  806. */
  807. @Override
  808. public List<Map<String, Object>> getAllCapacity(Map<String, Object> map) {
  809. return omstruckOrderMapper.getAllCapacity(map);
  810. }
  811. /**
  812. * 用于后台展示司机接单未接单数据
  813. *
  814. * @param map
  815. * @return
  816. */
  817. @Override
  818. public List<Map<String, Object>> getReceiveRefuseOrder(Map<String, Object> map) {
  819. return omstruckOrderMapper.getTruckOrderByCapacityNum(map);
  820. }
  821. /**
  822. * 通过运输订单号查询运单所有信息 包含作业路径名称
  823. *
  824. * @param map 传运输订单号
  825. * @return
  826. */
  827. @Override
  828. public List<Map<String, Object>> getOrderMesByOrderNum(Map<String, Object> map) {
  829. return omstruckOrderMapper.getTruckOrderByCapacityNum(map);
  830. }
  831. /**
  832. * 查询所有司机已拒绝的订单
  833. * 车牌号
  834. *
  835. * @param map
  836. * @return
  837. */
  838. @Override
  839. public List<Map<String, Object>> getReceiveRefuseOrderByCapacityId(Map<String, Object> map) {
  840. //通过车牌号查询运力Id
  841. BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum((String) map.get("capacityNumber"));
  842. map.put("capacityId", capacityId);
  843. return omstruckOrderMapper.getReceiveRefuseOrderByCapacityId(map);
  844. }
  845. /**
  846. * 通过运单号查询订单详情
  847. * 运输订单号
  848. *
  849. * @param
  850. * @return
  851. */
  852. @Override
  853. public List<Map<String, Object>> getOrderByOrderId(BigDecimal orderId) {
  854. return omstruckOrderMapper.getOrderByOrderId(orderId);
  855. }
  856. /**
  857. * 查看运输派单
  858. *
  859. * @param map
  860. * @return
  861. */
  862. @Override
  863. public List<Map<String, Object>> getTransportDispatch(Map<String, Object> map) {
  864. return omstruckOrderMapper.getTransportDispatch(map);
  865. }
  866. /**
  867. * 用于更新路段顺序号
  868. *
  869. * @param map orderId
  870. * @return
  871. */
  872. public int updateOrderLineSequence(Map<String, Object> map, Integer lineSequence) {
  873. OmstruckOrder omstruckOrder = new OmstruckOrder();
  874. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(map.get("orderId")));
  875. omstruckOrder.setOrderLineSequence(new BigDecimal(lineSequence));
  876. return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  877. }
  878. //新增内转运输订单
  879. @Override
  880. public int insert(OmstruckOrder omstruckOrder) {
  881. //生成订单主键Id
  882. BigDecimal maxId = omstruckOrderMapper.selectMaxId();
  883. omstruckOrder.setOrderId(maxId);
  884. //生成运输订单号
  885. int id = maxId.intValue();
  886. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", id);
  887. omstruckOrder.setOrderNumber(orderNumber);
  888. //设置状态为未下发
  889. omstruckOrder.setOrderStatus(new BigDecimal(3));
  890. //设置运输订单的类型
  891. omstruckOrder.setOrderType(new BigDecimal(11));
  892. omstruckOrder.setInsertTime(new Date());
  893. omstruckOrder.setInsertUsername("admin");
  894. return omstruckOrderMapper.insertSelective(omstruckOrder);
  895. }
  896. //通过物资id查询批次表匹配最新的批次,关联最新的采购订单号
  897. @Override
  898. public Map<String, Object> selectNewOrderId(Map<String, Object> map) {
  899. return omstruckOrderMapper.selectNewOrderId(map);
  900. }
  901. //app司机接单查询数据
  902. @Override
  903. public Map<String, Object> sendMesToDriverApp(Map<String, Object> map) {
  904. //通过车牌号匹配运力ID
  905. BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum((String) map.get("capacityNumber"));
  906. map.put("capacityId", capacityId);
  907. if (capacityId == null) {
  908. return null;
  909. }
  910. //通过运力Id匹配 已下发的运输订单
  911. Map<String, Object> truckOrderByCapacityNum = new HashMap<>();
  912. if ((Integer) map.get("orderType") == 1 || (Integer) map.get("orderType") == 2) {
  913. //查询主干信息
  914. Map<String, Object> map1 = omstruckOrderMapper.getSaleTruckOrderByCapacityId(map);
  915. //查询物资信息
  916. List<Map<String, Object>> mapList = omstruckOrderMapper.getSaleTruckOrderByCapacityNumMaterial(map);
  917. truckOrderByCapacityNum.put("orderf", map1);
  918. truckOrderByCapacityNum.put("materialList", mapList);
  919. }
  920. return truckOrderByCapacityNum;
  921. }
  922. @Override
  923. public BigDecimal selectCapacityId(BigDecimal carrierId, String capacityNumber) {
  924. return omstruckOrderMapper.selectCapacityId(carrierId, capacityNumber);
  925. }
  926. /**
  927. * 车牌号下拉
  928. *
  929. * @return
  930. */
  931. @Override
  932. public List<Map<String, Object>> getDriverCapacity() {
  933. return omstruckOrderMapper.getDriverCapacity();
  934. }
  935. /**
  936. * 派单信息
  937. *
  938. * @param dispatchId
  939. * @return
  940. */
  941. @Override
  942. public Map<String, Object> getTruckNoDispatchMap(Integer dispatchId) {
  943. Map<String, Object> map = omstruckOrderMapper.getTruckNoDispatchMap(new BigDecimal(dispatchId));
  944. List<BigDecimal> orderIdList = omstruckOrderMapper.getNullOrNotNull(new BigDecimal(dispatchId));
  945. if (orderIdList != null || orderIdList.size() != 0) {
  946. return null;
  947. }
  948. List<Map<String, Object>> materialMessages = omstruckOrderMapper.getMaterialMessages(new BigDecimal(dispatchId));
  949. String allMaterialName = "";
  950. String allMaterialNumber = "";
  951. String allMaterialTheoreticalWeight = "";
  952. String allMaterialSpecificationModel = "";
  953. if (materialMessages == null || materialMessages.size() == 0) {
  954. } else {
  955. for (Map<String, Object> materialMap : materialMessages) {
  956. if (materialMap != null) {
  957. String materialName = (String) materialMap.get("materialName");
  958. allMaterialName += materialName + "/";
  959. String materialTheoreticalWeight = materialMap.get("materialTheoreticalWeight").toString();
  960. if (materialTheoreticalWeight != null) {
  961. allMaterialTheoreticalWeight += materialTheoreticalWeight + "/";
  962. }
  963. String saleOrderMaterialNumber = materialMap.get("saleOrderMaterialNumber").toString();
  964. allMaterialNumber += saleOrderMaterialNumber + "/";
  965. String specificationModel = materialMap.get("specificationModel").toString();
  966. if (specificationModel != null) {
  967. allMaterialSpecificationModel += specificationModel + "/";
  968. }
  969. }
  970. }
  971. String subMaterialName = null;
  972. String subMaterialNumber = null;
  973. String subMaterialTheoreticalWeight = null;
  974. String subMaterialSpecificationModel = null;
  975. if (allMaterialName.length() >= 2) {
  976. subMaterialName = allMaterialName.substring(0, allMaterialName.length() - 2);
  977. }
  978. if (allMaterialName.length() < 2) {
  979. subMaterialName = allMaterialName;
  980. }
  981. if (allMaterialNumber.length() >= 2) {
  982. subMaterialNumber = allMaterialNumber.substring(0, allMaterialNumber.length() - 2);
  983. }
  984. if (allMaterialNumber.length() < 2) {
  985. subMaterialNumber = allMaterialNumber;
  986. }
  987. if (allMaterialTheoreticalWeight.length() >= 2) {
  988. subMaterialTheoreticalWeight = allMaterialTheoreticalWeight.substring(0, allMaterialTheoreticalWeight.length() - 2);
  989. }
  990. if (allMaterialTheoreticalWeight.length() < 2) {
  991. subMaterialTheoreticalWeight = allMaterialTheoreticalWeight;
  992. }
  993. if (allMaterialSpecificationModel.length() >= 2) {
  994. subMaterialSpecificationModel = allMaterialSpecificationModel.substring(0, allMaterialSpecificationModel.length() - 2);
  995. }
  996. if (allMaterialSpecificationModel.length() < 2) {
  997. subMaterialSpecificationModel = allMaterialSpecificationModel;
  998. }
  999. map.put("allMaterialName", subMaterialName);
  1000. map.put("allMaterialNumber", subMaterialNumber);
  1001. map.put("allMaterialTheoreticalWeight", subMaterialTheoreticalWeight);
  1002. map.put("allMaterialSpecificationModel", subMaterialSpecificationModel);
  1003. }
  1004. return map;
  1005. }
  1006. /**
  1007. * 承运商分派运输订单给司机
  1008. * @param dispatchId
  1009. * @param orderType
  1010. * @param capacityNumber
  1011. * @param carrierId
  1012. * @return
  1013. */
  1014. @Transactional
  1015. @Override
  1016. public int addAppTruckOrder(Integer dispatchId, Integer orderType, String capacityNumber, Integer carrierId) {
  1017. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1018. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  1019. omstruckOrder.setOrderId(orderId);
  1020. BigDecimal saleOrderMaterialId = omstruckOrderMapper.getSaleMaterialId(new BigDecimal(dispatchId));
  1021. omstruckOrder.setOrderPlanId(saleOrderMaterialId);
  1022. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue());
  1023. omstruckOrder.setOrderNumber(orderNumber);
  1024. omstruckOrder.setOrderIssueTime(new Date());
  1025. omstruckOrder.setOrderStatus(new BigDecimal(4));
  1026. omstruckOrder.setInsertTime(new Date());
  1027. omstruckOrder.setUpdateTime(new Date());
  1028. omstruckOrder.setInsertUsername("admin");
  1029. omstruckOrder.setUpdateUsername("admin");
  1030. omstruckOrder.setInsertUpdateRemark("无");
  1031. omstruckOrder.setDeleted(new BigDecimal(0));
  1032. omstruckOrder.setOrderType(new BigDecimal(orderType));
  1033. BigDecimal capacityId = omstruckOrderMapper.getCapacityId(capacityNumber);
  1034. BigDecimal driverCapacityId = omstruckOrderMapper.getDriverCapacityId(capacityId);
  1035. omstruckOrder.setDriverCapacityId(driverCapacityId);
  1036. RmsDriverCapacity rmsDriverCapacity = rmsDriverCapacityMapper.selectByPrimaryKey(driverCapacityId);
  1037. rmsDriverCapacity.setCarrierId(new BigDecimal(carrierId));
  1038. rmsDriverCapacityMapper.updateByPrimaryKeySelective(rmsDriverCapacity);
  1039. List<Map<String, Object>> mapList = omstruckOrderMapper.getMaterialMessages(new BigDecimal(dispatchId));
  1040. if (mapList != null && mapList.size() != 0) {
  1041. for (Map<String, Object> map : mapList) {
  1042. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1043. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1044. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1045. omstruckOrderMaterial.setOrderId(orderId);
  1046. omstruckOrderMaterial.setInsertTime(new Date());
  1047. omstruckOrderMaterial.setUpdateTime(new Date());
  1048. omstruckOrderMaterial.setInsertUsername("admin");
  1049. omstruckOrderMaterial.setUpdateUsername("admin");
  1050. omstruckOrderMaterial.setInsertUpdateRemark("无");
  1051. if (map != null) {
  1052. BigDecimal materialTheoreticalWeight = (BigDecimal) map.get("materialTheoreticalWeight");
  1053. BigDecimal saleOrderMaterialNumber = (BigDecimal) map.get("saleOrderMaterialNumber");
  1054. BigDecimal materialId = (BigDecimal) map.get("materialId");
  1055. omstruckOrderMaterial.setOrderMaterialWeight(materialTheoreticalWeight);
  1056. omstruckOrderMaterial.setMaterialId(materialId);
  1057. omstruckOrderMaterial.setOrderMaterialNumber(saleOrderMaterialNumber);
  1058. }
  1059. omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  1060. }
  1061. }
  1062. RmsCapacity rmsCapacity = rmsCapacityMapper.selectByPrimaryKey(capacityId);
  1063. rmsCapacity.setCapacityStatus(new BigDecimal(2));
  1064. rmsCapacityMapper.updateByPrimaryKeySelective(rmsCapacity);
  1065. return omstruckOrderMapper.insertSelective(omstruckOrder);
  1066. }
  1067. /**
  1068. * 根据运单id关闭订单
  1069. * @param orderId
  1070. * @return
  1071. */
  1072. @Override
  1073. public int closeOmstruckOrder(BigDecimal orderId) {
  1074. OmstruckOrder omstruckOrder = omstruckOrderMapper.selectByPrimaryKey(orderId);
  1075. omstruckOrder.setOrderStatus(new BigDecimal(7));
  1076. int result = omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1077. return result;
  1078. }
  1079. /**
  1080. * 查询所有车牌号和司机
  1081. * @param mapValue
  1082. * @return
  1083. */
  1084. @Override
  1085. public List<Map<String, Object>> getCapacityAndDriverList(Map<String, Object> mapValue) {
  1086. return omstruckOrderMapper.getCapacityAndDriver(mapValue);
  1087. }
  1088. @Override
  1089. public int closeOrder(Map<String, Object> map) {
  1090. Integer orderId =(Integer) map.get("orderId");
  1091. OmstruckOrder omstruckOrder=new OmstruckOrder();
  1092. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
  1093. omstruckOrder.setOrderStatus(new BigDecimal(8));
  1094. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1095. return 1;
  1096. }
  1097. /**
  1098. * 新增内转运输订单
  1099. * @param mapValue
  1100. * @return
  1101. */
  1102. @Transactional
  1103. @Override
  1104. public int addInwardOrder(Map<String, Object> mapValue) {
  1105. int result = 0;
  1106. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  1107. String planId = (String) mapValue.get("planId");
  1108. Integer lineId = (Integer) mapValue.get("lineId");
  1109. String orderType = (String) mapValue.get("orderType");
  1110. Integer carrierId = (Integer) mapValue.get("carrierId");
  1111. AmstruckInwardPlan amstruckInwardPlan = amstruckInwardPlanMapper.selectByPrimaryKey(new BigDecimal(planId));
  1112. amstruckInwardPlan.setPlanStatus(new BigDecimal(3));
  1113. result += amstruckInwardPlanMapper.updateByPrimaryKeySelective(amstruckInwardPlan);
  1114. BigDecimal materialId = omstruckOrderMapper.getInwardMaterial(new BigDecimal(planId));
  1115. for (Map<String,Object> orderMap : mapList) {
  1116. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1117. String capacityNumber = (String)orderMap.get("capacityNumber");
  1118. BigDecimal materialNumber = DataChange.dataToBigDecimal(orderMap.get("materialNumber")) ;
  1119. BigDecimal materialWeight = DataChange.dataToBigDecimal(orderMap.get("materialWeight"));
  1120. Map<String,Object> capacityMap = new HashMap<>();
  1121. capacityMap.put("capacityNumber",capacityNumber);
  1122. List<RmsCapacity> rmsCapacities = rmsCapacityMapper.selectByParameters(capacityMap);
  1123. RmsCapacity rmsCapacity = rmsCapacities.get(0);
  1124. rmsCapacity.setCapacityStatus(new BigDecimal(2));
  1125. result +=rmsCapacityMapper.updateByPrimaryKeySelective(rmsCapacity);
  1126. BigDecimal capacityId = rmsCapacity.getCapacityId();
  1127. capacityMap.clear();
  1128. capacityMap.put("capacityId",capacityId);
  1129. List<RmsDriverCapacity> rmsDriverCapacities = rmsDriverCapacityMapper.selectByParameters(capacityMap);
  1130. RmsDriverCapacity rmsDriverCapacity = rmsDriverCapacities.get(0);
  1131. rmsDriverCapacity.setCarrierId(new BigDecimal(carrierId));
  1132. result +=rmsDriverCapacityMapper.updateByPrimaryKeySelective(rmsDriverCapacity);
  1133. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  1134. omstruckOrder.setOrderId(orderId);
  1135. omstruckOrder.setOrderPlanId(new BigDecimal(planId));
  1136. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue());
  1137. omstruckOrder.setOrderNumber(orderNumber);
  1138. omstruckOrder.setOrderIssueTime(new Date());
  1139. omstruckOrder.setOrderStatus(new BigDecimal(3));
  1140. omstruckOrder.setInsertTime(new Date());
  1141. omstruckOrder.setUpdateTime(new Date());
  1142. omstruckOrder.setInsertUsername("admin");
  1143. omstruckOrder.setUpdateUsername("admin");
  1144. omstruckOrder.setInsertUpdateRemark("无");
  1145. omstruckOrder.setDeleted(new BigDecimal(0));
  1146. omstruckOrder.setOrderType(new BigDecimal(orderType));
  1147. omstruckOrder.setLineId(new BigDecimal(lineId));
  1148. omstruckOrder.setDriverCapacityId(rmsDriverCapacity.getDriverCapacityId());
  1149. result +=omstruckOrderMapper.insertSelective(omstruckOrder);
  1150. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1151. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1152. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1153. omstruckOrderMaterial.setOrderId(orderId);
  1154. omstruckOrderMaterial.setMaterialId(materialId);
  1155. omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
  1156. omstruckOrderMaterial.setInsertTime(new Date());
  1157. omstruckOrderMaterial.setUpdateTime(new Date());
  1158. omstruckOrderMaterial.setInsertUsername("admin");
  1159. omstruckOrderMaterial.setUpdateUsername("admin");
  1160. omstruckOrderMaterial.setInsertUpdateRemark("无");
  1161. omstruckOrderMaterial.setOrderMaterialWeight(materialWeight);
  1162. result +=omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  1163. }
  1164. return result;
  1165. }
  1166. /**
  1167. * 查询分解计划
  1168. * @param mapValue
  1169. * @return
  1170. */
  1171. @Override
  1172. public List<Map<String, Object>> getInwardOrderList(Map<String, Object> mapValue) {
  1173. List<Map<String,Object>> mapList = omstruckOrderMapper.getInwardOrderList(mapValue);
  1174. return mapList;
  1175. }
  1176. /**
  1177. * 下发计划
  1178. * @param mapList
  1179. * @return
  1180. */
  1181. @Override
  1182. public int issuePlanOrder(List<Map<String, Object>> mapList) {
  1183. int result = 0;
  1184. for (Map<String,Object> map : mapList) {
  1185. Integer orderId = (Integer) map.get("orderId");
  1186. OmstruckOrder omstruckOrder = omstruckOrderMapper.selectByPrimaryKey(new BigDecimal(orderId));
  1187. omstruckOrder.setOrderStatus(new BigDecimal(4));
  1188. omstruckOrder.setOrderIssueTime(new Date());
  1189. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1190. }
  1191. return result;
  1192. }
  1193. /**
  1194. * 分派计划
  1195. * @param mapList
  1196. * @return
  1197. */
  1198. @Override
  1199. public int apportionInwardOrder(List<Map<String, Object>> mapList) {
  1200. int result = 0;
  1201. for (Map<String,Object> map : mapList) {
  1202. BigDecimal orderId = new BigDecimal((Integer) map.get("orderId"));
  1203. OmstruckOrder omstruckOrder = omstruckOrderMapper.selectByPrimaryKey(orderId);
  1204. omstruckOrder.setOrderIssueTime(new Date());
  1205. omstruckOrder.setOrderStatus(new BigDecimal(4));
  1206. Map<Object, Object> map9 = new HashMap<>();
  1207. long data = new Date().getTime();
  1208. //根据运输订单id查询车牌号
  1209. String capacityNumber = omstruckOrderMapper.selectCapacityNumber(orderId);
  1210. // BigDecimal orderType = omstruckOrderMapper.selectOrderType(orderId);
  1211. //
  1212. // map9.put("receivePerson",capacityNumber);
  1213. // map9.put("messageType",2);
  1214. // map9.put("snedPerson","system");
  1215. // map9.put("creatTime",data);
  1216. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1217. }
  1218. return result;
  1219. }
  1220. /**
  1221. * 司机APP端查询下发给自己运输订单
  1222. * @param capacityNumber
  1223. * @return
  1224. */
  1225. @Override
  1226. public List<Map<String, Object>> sendOrderToApp(String capacityNumber) {
  1227. //通过车牌号匹配运力ID
  1228. BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum(capacityNumber);
  1229. BigDecimal driverCapacityId = omstruckOrderMapper.getDriverCapacityId(capacityId);
  1230. List<Map<String,Object>> resultList = omstruckOrderMapper.getResultList(driverCapacityId);
  1231. for (Map<String,Object> map : resultList) {
  1232. BigDecimal orderId = (BigDecimal) map.get("orderId");
  1233. BigDecimal orderType = (BigDecimal) map.get("orderType");
  1234. // 查询物资信息
  1235. List<Map<String,Object>> materialMapList = omstruckOrderMapper.getMaterialMes(orderId);
  1236. int intValue = orderType.intValue();
  1237. String allMaterialName = null;
  1238. String allMaterialNumber = null;
  1239. String allMaterialWeight = null;
  1240. String allMaterialSpecificationModel = null;
  1241. // 对物资信息进行处理
  1242. if (materialMapList != null && materialMapList.size() != 0) {
  1243. for (Map<String,Object> materialMap : materialMapList) {
  1244. String materialName = (String) materialMap.get("materialName");
  1245. BigDecimal materialNumber = (BigDecimal) materialMap.get("materialNumber");
  1246. BigDecimal materialWeight = (BigDecimal) materialMap.get("materialWeight");
  1247. String materialModel = (String) materialMap.get("materialModel");
  1248. String materialSpecification = (String) materialMap.get("materialSpecification");
  1249. allMaterialName += materialName + "/";
  1250. allMaterialNumber += materialNumber + "/";
  1251. allMaterialWeight += materialWeight + "/";
  1252. allMaterialSpecificationModel += materialSpecification + materialModel + "/";
  1253. }
  1254. String subMaterialName = null;
  1255. String subMaterialNumber = null;
  1256. String subMaterialWeight = null;
  1257. String subMaterialSpecificationModel = null;
  1258. if (allMaterialName.length() >= 2) {
  1259. subMaterialName = allMaterialName.substring(0, allMaterialName.length() - 2);
  1260. }
  1261. if (allMaterialName.length() < 2) {
  1262. subMaterialName = allMaterialName;
  1263. }
  1264. if (allMaterialNumber.length() >= 2) {
  1265. subMaterialNumber = allMaterialNumber.substring(0, allMaterialNumber.length() - 2);
  1266. }
  1267. if (allMaterialNumber.length() < 2) {
  1268. subMaterialNumber = allMaterialNumber;
  1269. }
  1270. if (allMaterialWeight.length() >= 2) {
  1271. subMaterialWeight = allMaterialWeight.substring(0, allMaterialWeight.length() - 2);
  1272. }
  1273. if (allMaterialWeight.length() < 2) {
  1274. subMaterialWeight = allMaterialWeight;
  1275. }
  1276. if (allMaterialSpecificationModel.length() >= 2) {
  1277. subMaterialSpecificationModel = allMaterialSpecificationModel.substring(0, allMaterialSpecificationModel.length() - 2);
  1278. }
  1279. if (allMaterialSpecificationModel.length() < 2) {
  1280. subMaterialSpecificationModel = allMaterialSpecificationModel;
  1281. }
  1282. map.put("allMaterialName", subMaterialName);
  1283. map.put("allMaterialNumber", subMaterialNumber);
  1284. map.put("allMaterialWeight", subMaterialWeight);
  1285. map.put("allMaterialSpecificationModel", subMaterialSpecificationModel);
  1286. }
  1287. Map<String,Object> orderMap = null;
  1288. if (intValue == 1 || intValue == 2 || intValue == 3) {
  1289. orderMap = omstruckOrderMapper.getSaleOrderMap(orderId);
  1290. }
  1291. if (intValue == 4) {
  1292. orderMap = omstruckOrderMapper.getSteelInwardOrderMap(orderId);
  1293. }
  1294. if (intValue == 5 || intValue == 6 || intValue == 7 || intValue == 8) {
  1295. orderMap = omstruckOrderMapper.getPurchaseOrderMap(orderId);
  1296. }
  1297. if (intValue == 9 || intValue == 10 || intValue == 11) {
  1298. orderMap = omstruckOrderMapper.getInwardOrderMap(orderId);
  1299. }
  1300. map.putAll(orderMap);
  1301. }
  1302. return resultList;
  1303. }
  1304. //新增内转异地库计划订单
  1305. @Override
  1306. public int apportionInwardOffsetOrder(Map<String, Object> mapValue) {
  1307. int result = 0;
  1308. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  1309. String dayPlanId = (String) mapValue.get("dayPlanId");
  1310. Integer lineId = (Integer) mapValue.get("lineId");
  1311. String orderType = (String) mapValue.get("orderType");
  1312. // Integer carrierId = (Integer) mapValue.get("carrierId");
  1313. // AmstruckInwardPlan amstruckInwardPlan = amstruckInwardPlanMapper.selectByPrimaryKey(new BigDecimal(planId));
  1314. // amstruckInwardPlan.setPlanStatus(new BigDecimal(3));
  1315. // result += amstruckInwardPlanMapper.updateByPrimaryKeySelective(amstruckInwardPlan);
  1316. BigDecimal materialId = omstruckOrderMapper.getInwardMaterial(new BigDecimal(dayPlanId));
  1317. for (Map<String,Object> orderMap : mapList) {
  1318. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1319. String capacityNumber = (String)orderMap.get("capacityNumber");
  1320. BigDecimal materialNumber = DataChange.dataToBigDecimal(orderMap.get("materialNumber")) ;
  1321. // BigDecimal materialWeight = DataChange.dataToBigDecimal(orderMap.get("materialWeight"));
  1322. Map<String,Object> capacityMap = new HashMap<>();
  1323. capacityMap.put("capacityNumber",capacityNumber);
  1324. List<RmsCapacity> rmsCapacities = rmsCapacityMapper.selectByParameters(capacityMap);
  1325. RmsCapacity rmsCapacity = rmsCapacities.get(0);
  1326. rmsCapacity.setCapacityStatus(new BigDecimal(2));
  1327. result +=rmsCapacityMapper.updateByPrimaryKeySelective(rmsCapacity);
  1328. BigDecimal capacityId = rmsCapacity.getCapacityId();
  1329. capacityMap.clear();
  1330. capacityMap.put("capacityId",capacityId);
  1331. List<RmsDriverCapacity> rmsDriverCapacities = rmsDriverCapacityMapper.selectByParameters(capacityMap);
  1332. RmsDriverCapacity rmsDriverCapacity = rmsDriverCapacities.get(0);
  1333. BigDecimal dcId = rmsDriverCapacity.getDriverCapacityId();
  1334. if(dcId!=null){
  1335. BigDecimal orderId = omstruckOrderMapper.selectOrderId(dcId);
  1336. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1337. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1338. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1339. omstruckOrderMaterial.setOrderId(orderId);
  1340. omstruckOrderMaterial.setMaterialId(materialId);
  1341. omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
  1342. omstruckOrderMaterial.setInsertTime(new Date());
  1343. omstruckOrderMaterial.setUpdateTime(new Date());
  1344. omstruckOrderMaterial.setInsertUsername("admin");
  1345. omstruckOrderMaterial.setUpdateUsername("admin");
  1346. omstruckOrderMaterial.setInsertUpdateRemark("无");
  1347. }
  1348. // rmsDriverCapacity.setCarrierId(new BigDecimal(carrierId));
  1349. result +=rmsDriverCapacityMapper.updateByPrimaryKeySelective(rmsDriverCapacity);
  1350. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  1351. omstruckOrder.setOrderId(orderId);
  1352. omstruckOrder.setOrderPlanId(new BigDecimal(dayPlanId));
  1353. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue());
  1354. omstruckOrder.setOrderNumber(orderNumber);
  1355. omstruckOrder.setOrderIssueTime(new Date());
  1356. omstruckOrder.setOrderStatus(new BigDecimal(3));
  1357. omstruckOrder.setInsertTime(new Date());
  1358. omstruckOrder.setUpdateTime(new Date());
  1359. omstruckOrder.setInsertUsername("admin");
  1360. omstruckOrder.setUpdateUsername("admin");
  1361. omstruckOrder.setInsertUpdateRemark("无");
  1362. omstruckOrder.setDeleted(new BigDecimal(0));
  1363. omstruckOrder.setOrderType(new BigDecimal(orderType));
  1364. omstruckOrder.setLineId(new BigDecimal(lineId));
  1365. omstruckOrder.setDriverCapacityId(rmsDriverCapacity.getDriverCapacityId());
  1366. result +=omstruckOrderMapper.insertSelective(omstruckOrder);
  1367. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1368. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1369. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1370. omstruckOrderMaterial.setOrderId(orderId);
  1371. omstruckOrderMaterial.setMaterialId(materialId);
  1372. omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
  1373. omstruckOrderMaterial.setInsertTime(new Date());
  1374. omstruckOrderMaterial.setUpdateTime(new Date());
  1375. omstruckOrderMaterial.setInsertUsername("admin");
  1376. omstruckOrderMaterial.setUpdateUsername("admin");
  1377. omstruckOrderMaterial.setInsertUpdateRemark("无");
  1378. // omstruckOrderMaterial.setOrderMaterialWeight(materialWeight);
  1379. result +=omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  1380. }
  1381. return result;
  1382. }
  1383. }