OmstruckOrderServiceImpl.java 81 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864
  1. package com.steerinfo.dil.service.impl;
  2. import com.baomidou.mybatisplus.extension.api.R;
  3. import com.steerinfo.dil.feign.AmsFeign;
  4. import com.steerinfo.dil.feign.IMFeign;
  5. import com.steerinfo.dil.feign.TmsTruckFeign;
  6. import com.steerinfo.dil.mapper.*;
  7. import com.steerinfo.dil.model.*;
  8. import com.steerinfo.dil.service.IOmstruckOrderService;
  9. import com.steerinfo.dil.util.DataChange;
  10. import org.springframework.beans.factory.annotation.Autowired;
  11. import org.springframework.stereotype.Service;
  12. import org.springframework.transaction.annotation.Transactional;
  13. import java.math.BigDecimal;
  14. import java.text.SimpleDateFormat;
  15. import java.util.*;
  16. /**
  17. * OmstruckOrder服务实现:
  18. *
  19. * @author generator
  20. * @version 1.0-SNAPSHORT 2021-10-15 09:37
  21. * 类描述
  22. * 修订历史:
  23. * 日期:2021-10-15
  24. * 作者:generator
  25. * 参考:
  26. * 描述:OmstruckOrder服务实现
  27. * @Copyright 湖南视拓信息技术股份有限公司. All rights reserved.
  28. * @see null
  29. */
  30. @Service(value = "omstruckOrderService")
  31. public class OmstruckOrderServiceImpl implements IOmstruckOrderService {
  32. @Autowired
  33. private OmstruckOrderMapper omstruckOrderMapper;
  34. @Autowired
  35. private OmstruckOrderMaterialMapper omstruckOrderMaterialMapper;
  36. @Autowired
  37. private AmsFeign amsFeign;
  38. @Autowired
  39. private TmsTruckFeign tmsTruckFeign;
  40. @Autowired
  41. private IMFeign imFeign;
  42. @Autowired
  43. RmsCapacityMapper rmsCapacityMapper;
  44. @Autowired
  45. RmsDriverCapacityMapper rmsDriverCapacityMapper;
  46. @Autowired
  47. AmstruckInwardPlanMapper amstruckInwardPlanMapper;
  48. @Autowired
  49. OmstruckOrderSeparateServiceImpl omstruckOrderSeparateService;
  50. @Autowired
  51. OmstruckOrderSeparateMapper omstruckOrderSeparateMapper;
  52. /**
  53. * 用于远程调用运输订单新增
  54. *
  55. * @param omstruckOrder
  56. * @return
  57. */
  58. @Override
  59. public int insertSelective(OmstruckOrder omstruckOrder) {
  60. return omstruckOrderMapper.insertSelective(omstruckOrder);
  61. }
  62. /**
  63. * 查询所有运输订单
  64. * 获取已下发的运输订单 用于websocket
  65. *
  66. * @param map
  67. * @return
  68. */
  69. @Override
  70. public List<Map<String, Object>> getAllTruckOrder(Map<String, Object> map) {
  71. return omstruckOrderMapper.getAllTruckOrder(map);
  72. }
  73. /**
  74. * 新增运输订单
  75. *
  76. * @param map
  77. * @return
  78. */
  79. @Override
  80. @Transactional
  81. public int addPurOrder(Map<String, Object> map) {
  82. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  83. int i = 0;
  84. switch (orderType.intValue()) {
  85. case 1:
  86. i = dispatchSteelOrder(map);//新增销售订单
  87. break;
  88. case 2:
  89. i = dispatchSteelOrder(map);//新增水渣发运计划订单
  90. break;
  91. case 3:
  92. i = dispatchSteelOrder(map);//新增焦炭发运计划订单
  93. break;
  94. case 4:
  95. break;
  96. case 5:
  97. case 6:
  98. case 7:
  99. case 17:
  100. case 18:
  101. i = addCGPurOrders(map);
  102. break;
  103. case 8:
  104. i = addCGPurOrder(map); //新增采购运输订单
  105. break;
  106. case 9:
  107. break;
  108. case 10:
  109. break;
  110. case 11:
  111. }
  112. return i;
  113. }
  114. /**
  115. * 新增采购其他订单
  116. * @return
  117. */
  118. public int addCGPurOrders(Map<String, Object> map){
  119. //从map中获取司机运力列表
  120. List<Map<String, Object>> driverCapacityIdList = (List<Map<String, Object>>) map.get("driverCapacityIdList");
  121. BigDecimal purchaseOrderId = DataChange.dataToBigDecimal(map.get("purchaseOrderId"));
  122. //是否一车多趟 有则更新采购订单
  123. Object isMoreTrips = map.get("isMoreTrips");
  124. if(isMoreTrips != null){
  125. boolean trips = (boolean) isMoreTrips;
  126. if(trips){
  127. //更新采购订单为一车多趟类型
  128. omstruckOrderSeparateMapper.updateAPOisMoreTrips(DataChange.dataToBigDecimal(map.get("purchaseOrderId")));
  129. }
  130. }
  131. //物资ID
  132. Object materialId = map.get("materialId");
  133. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  134. //预计进厂时间
  135. Date orderEntryTime = new Date((long) map.get("orderEntryTime"));
  136. int count = 0;
  137. for (Map<String, Object> capacityMap : driverCapacityIdList) {
  138. //添加运输订单
  139. OmstruckOrder omstruckOrder = generateOmsTruckOrder(map);
  140. omstruckOrder.setOrderPlanId(purchaseOrderId);
  141. omstruckOrder.setCapacityId(DataChange.dataToBigDecimal(capacityMap.get("capacityId"))); //添加运力排班ID
  142. omstruckOrder.setOrderEntryTime(orderEntryTime);
  143. count += omstruckOrderMapper.insertSelective(omstruckOrder);
  144. BigDecimal orderId = omstruckOrder.getOrderId();
  145. //添加运输订单子表
  146. capacityMap.put("materialId", materialId);
  147. capacityMap.put("orderType", orderType);
  148. addOrderMaterial(capacityMap,orderId);
  149. //添加总实绩
  150. capacityMap.put("orderId", orderId);
  151. tmsTruckFeign.addTotalResult(capacityMap);
  152. //更改运力状态
  153. }
  154. return count;
  155. }
  156. /**
  157. * 新增采购进口矿运输订单订单
  158. *
  159. * @param map
  160. * @return
  161. */
  162. @Transactional
  163. public int addCGPurOrder(Map<String, Object> map) {
  164. //生成运输订单号和主键
  165. OmstruckOrder omstruckOrder = generateOmsTruckOrder(map);
  166. Object orderEntryTime = map.get("orderEntryTime");
  167. if (orderEntryTime != null) {
  168. omstruckOrder.setOrderEntryTime(new Date((long) orderEntryTime)); //新增预计进厂时间
  169. }
  170. if (map.get("orderMaterialWeight") != null) {
  171. amsFeign.updateMaterial(map); //更改运输计划子表 增加已分配重量 减少未分配重量 feign调用ams
  172. }
  173. //添加运力Id
  174. BigDecimal capacityId = DataChange.dataToBigDecimal(map.get("capacityId"));
  175. omstruckOrder.setCapacityId(capacityId);
  176. //新增运输订单
  177. omstruckOrderMapper.insertSelective(omstruckOrder);
  178. //更新运力状态为待运输:2
  179. // map.put("capacityStatus", 2);
  180. // omstruckOrderMapper.updateCapacityByCarIdOrNum(map);
  181. //新增运输订单子表
  182. addOrderMaterial(map, omstruckOrder.getOrderId());
  183. //新增实绩总表关联订单 feign 调用truckTms
  184. map.put("orderId", omstruckOrder.getOrderId());
  185. tmsTruckFeign.addTotalResult(map);
  186. return 1;
  187. }
  188. /**
  189. * 生成运输订单实体类
  190. */
  191. public OmstruckOrder generateOmsTruckOrder(Map<String, Object> map) {
  192. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  193. OmstruckOrder omstruckOrder = new OmstruckOrder();
  194. //生成订单主键Id
  195. BigDecimal maxId = omstruckOrderMapper.selectMaxId();
  196. omstruckOrder.setOrderId(maxId);
  197. //生成运输订单号
  198. int id = maxId.intValue();
  199. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", id);
  200. omstruckOrder.setOrderNumber(orderNumber);
  201. //设置线路
  202. omstruckOrder.setLineId(DataChange.dataToBigDecimal(map.get("lineId")));
  203. //运单状态 刚分配默认为未下发
  204. omstruckOrder.setOrderStatus(new BigDecimal(3));
  205. switch (orderType.intValue()) {
  206. case 1:
  207. omstruckOrder.setOrderPlanId(DataChange.dataToBigDecimal(map.get("saleOrderMaterialId")));
  208. break;
  209. case 2:
  210. case 3:
  211. omstruckOrder.setOrderPlanId(DataChange.dataToBigDecimal(map.get("dayPlanId")));
  212. break;
  213. case 4:
  214. break;
  215. case 5:
  216. case 6:
  217. case 7:
  218. case 8:
  219. case 17:
  220. case 18:
  221. if (map.get("purchaseOrderId") != null)
  222. omstruckOrder.setOrderPlanId(DataChange.dataToBigDecimal(map.get("purchaseOrderId")));
  223. if (map.get("unloadPointId") != null) // 添加卸货点
  224. omstruckOrder.setUnloadPointId(DataChange.dataToBigDecimal(map.get("unloadPointId")));
  225. break;
  226. case 9:
  227. break;
  228. case 10:
  229. break;
  230. case 11:
  231. }
  232. //添加订单类型
  233. omstruckOrder.setOrderType(orderType);
  234. omstruckOrder.setInsertUsername("admin");
  235. omstruckOrder.setInsertTime(new Date());
  236. return omstruckOrder;
  237. }
  238. /**
  239. * 新增订单子表
  240. *
  241. * @param map
  242. * @param
  243. */
  244. public void addOrderMaterial(Map<String, Object> map, BigDecimal orderId) {
  245. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  246. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  247. switch (orderType.intValue()) {
  248. case 1:
  249. //获得销售物资id
  250. //生成子表主键
  251. omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
  252. Integer saleOrderMaterialId = (Integer) map.get("saleOrderMaterialId");
  253. //通过车序号id查找物资件数和物资重量
  254. Map<String, Object> map1 = omstruckOrderMapper.selectTheoreticalWeightAndMaterialNumber(saleOrderMaterialId);
  255. BigDecimal materialNumber = (BigDecimal) map1.get("materialNumber");
  256. BigDecimal weight = (BigDecimal) map1.get("weight");
  257. //设置物资理重和物资件数
  258. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(weight));
  259. omstruckOrderMaterial.setOrderMaterialNumber(DataChange.dataToBigDecimal(materialNumber));
  260. //通过销售订单车序号id查找物资id
  261. List<Map<String, Object>> materialList = omstruckOrderMapper.selectMaterialIdBysaleOrderMaterialId(saleOrderMaterialId);
  262. for (int i = 0; i < materialList.size(); i++) {
  263. Map<String, Object> map2 = materialList.get(i);
  264. BigDecimal materialId = (BigDecimal) map2.get("materialId");
  265. omstruckOrderMaterial.setMaterialId(materialId);
  266. }
  267. //执行新增
  268. omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  269. break;
  270. case 2:
  271. //获取发运计划id
  272. //生成子表主键
  273. omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
  274. Integer dayPlanId = (Integer) map.get("dayPlanId");
  275. //设置订单id
  276. omstruckOrderMaterial.setOrderId(orderId);
  277. //根据发运计划id查找物资id和物资重量
  278. map = omstruckOrderMapper.selectMaterialIdAndWeightByDayPlanId(dayPlanId);
  279. BigDecimal materialId = (BigDecimal) map.get("materialId");
  280. BigDecimal materialWeight = (BigDecimal) map.get("materialWeight");
  281. //设置物资id
  282. omstruckOrderMaterial.setMaterialId(DataChange.dataToBigDecimal(materialId));
  283. //设置物资重量
  284. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(materialWeight));
  285. omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  286. break;
  287. case 3:
  288. //获取发运计划id
  289. //生成子表主键
  290. omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
  291. Integer dayPlanId1 = (Integer) map.get("dayPlanId");
  292. //设置订单id
  293. omstruckOrderMaterial.setOrderId(orderId);
  294. //根据发运计划id查找物资id和物资重量
  295. map = omstruckOrderMapper.selectMaterialIdAndWeightByDayPlanId(dayPlanId1);
  296. BigDecimal materialId1 = (BigDecimal) map.get("materialId");
  297. BigDecimal materialWeight1 = (BigDecimal) map.get("materialWeight");
  298. //设置物资id
  299. omstruckOrderMaterial.setMaterialId(DataChange.dataToBigDecimal(materialId1));
  300. //设置物资重量
  301. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(materialWeight1));
  302. omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  303. break;
  304. case 4:
  305. break;
  306. case 5:
  307. case 6:
  308. case 7:
  309. case 8:
  310. case 17:
  311. case 18:
  312. //生成子表主键
  313. omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
  314. omstruckOrderMaterial.setMaterialId(DataChange.dataToBigDecimal(map.get("materialId")));
  315. omstruckOrderMaterial.setOrderId(orderId);
  316. Object orderMaterialWeight = map.get("orderMaterialWeight");
  317. if (orderMaterialWeight != null) {
  318. if (orderMaterialWeight.toString().length() != 0) {
  319. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(map.get("orderMaterialWeight")));
  320. }
  321. }
  322. Object orderMaterialNumber = map.get("orderMaterialNumber");
  323. if(orderMaterialNumber != null ) {
  324. if (orderMaterialNumber.toString().length() != 0) {
  325. omstruckOrderMaterial.setOrderMaterialNumber(DataChange.dataToBigDecimal(map.get("orderMaterialNumber")));
  326. }
  327. }
  328. omstruckOrderMaterial.setInsertUsername("admin");
  329. omstruckOrderMaterial.setInsertTime(new Date());
  330. omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  331. break;
  332. case 9:
  333. break;
  334. case 10:
  335. break;
  336. case 11:
  337. }
  338. }
  339. /**
  340. * 修改运输订单 和订单子表
  341. *
  342. * @param map
  343. * @return
  344. */
  345. @Override
  346. @Transactional
  347. public int updateOrder(Map<String, Object> map) {
  348. //修改运输订单运力ID
  349. OmstruckOrder omstruckOrder = new OmstruckOrder();
  350. BigDecimal orderId = DataChange.dataToBigDecimal(map.get("orderId"));
  351. BigDecimal orderType;
  352. if(map.get("orderType") == null){
  353. //查询订单类型
  354. orderType = new BigDecimal(omstruckOrderMapper.getOrderTypeByOrderNumber(orderId));
  355. }else{
  356. orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  357. }
  358. omstruckOrder.setOrderId(orderId);
  359. if (map.get("unloadPointId") != null) {
  360. omstruckOrder.setUnloadPointId(DataChange.dataToBigDecimal(map.get("unloadPointId")));
  361. }
  362. if (map.get("capacityId") != null) {
  363. omstruckOrder.setCapacityId(DataChange.dataToBigDecimal(map.get("capacityId")));
  364. }
  365. if(map.get("orderEntryTime") != null){
  366. omstruckOrder.setOrderEntryTime(new Date((long) map.get("orderEntryTime")));
  367. }
  368. if(map.get("unloadPointId")!=null || map.get("capacityId") != null || map.get("orderEntryTime") != null){
  369. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  370. }
  371. switch (orderType.intValue()) {
  372. case 1:
  373. break;
  374. case 2:
  375. break;
  376. case 3:
  377. break;
  378. case 4:
  379. break;
  380. case 5:
  381. case 6:
  382. case 7:
  383. case 8:
  384. case 17:
  385. case 18:
  386. //修改运输订单子表物资重量
  387. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  388. //添加子表主键 通过订单ID查询出子表主键
  389. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.getOrderMaterialIdByOrderId(DataChange.dataToBigDecimal(map.get("orderId")));
  390. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  391. if (map.get("orderMaterialWeight") != null) {
  392. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(map.get("orderMaterialWeight")));
  393. if(orderType.intValue() == 8)
  394. amsFeign.updateMaterial(map);//修改运输计划子表 已分配未分配重量
  395. }
  396. if(map.get("orderMaterialNumber") != null) {
  397. omstruckOrderMaterial.setOrderMaterialNumber(DataChange.dataToBigDecimal(map.get("orderMaterialNumber")));
  398. }
  399. if (map.get("materialId") != null) {
  400. omstruckOrderMaterial.setMaterialId(DataChange.dataToBigDecimal(map.get("materialId")));
  401. }
  402. if(map.get("orderMaterialWeight") != null || map.get("orderMaterialNumber") != null || map.get("materialId") != null){
  403. omstruckOrderMaterialMapper.updateByPrimaryKeySelective(omstruckOrderMaterial);
  404. }
  405. break;
  406. case 9:
  407. break;
  408. case 10:
  409. break;
  410. case 11:
  411. }
  412. return 1;
  413. }
  414. /**
  415. * 逻辑删除未下发订单
  416. *
  417. * @param map
  418. * @return
  419. */
  420. @Override
  421. @Transactional
  422. public int deleteOrder(Map<String, Object> map) {
  423. OmstruckOrder omstruckOrder = new OmstruckOrder();
  424. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(map.get("orderId")));
  425. //设置状态为逻辑删除:7
  426. omstruckOrder.setOrderStatus(new BigDecimal(7));
  427. int i = omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  428. //若是传来物资重量则修改已分配未分配重量
  429. if (map.get("orderMaterialWeight") != null) {
  430. amsFeign.updateMaterial(map); //feign调用
  431. }
  432. // //通过车牌号修改运输状态为空闲中 0
  433. // String capacityNumber = (String) map.get("capacityNumber");
  434. // HashMap<String, Object> changeStatusMap = new HashMap<>();
  435. // changeStatusMap.put("capacityNumber", capacityNumber);
  436. // changeStatusMap.put("capacityStatus", 0);
  437. // int i1 = omstruckOrderMapper.updateCapacityByCarIdOrNum(changeStatusMap);
  438. return i;
  439. }
  440. /**
  441. * 运单派发、下发
  442. * 运单ID
  443. *
  444. * @param mapValue
  445. * @return
  446. */
  447. @Override
  448. @Transactional
  449. public int dispatchOrder(Map<String, Object> mapValue) {
  450. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  451. int result = 0;
  452. for (Map<String, Object> map : mapList) {
  453. Integer orderId = (Integer) map.get("orderId");
  454. OmstruckOrder omstruckOrder = new OmstruckOrder();
  455. omstruckOrder.setOrderId(new BigDecimal(orderId));
  456. //生成订单下发时间 修改订单表
  457. omstruckOrder.setOrderIssueTime(new Date());
  458. //设置状态为已下发:4
  459. omstruckOrder.setOrderStatus(new BigDecimal(4));
  460. //下发 推送数据给 websocket
  461. pushMesToWebsocket(map);
  462. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  463. }
  464. return result;
  465. }
  466. /**
  467. * 发送消息到 websocket 推送消息
  468. * orderId 订单Id
  469. * @return
  470. */
  471. public void pushMesToWebsocket(Map<String, Object> map) {
  472. Map<String, Object> mesMap = omstruckOrderMapper.pushMesToWebsocket(map);
  473. //添加消息实体
  474. HashMap<Object, Object> mapp = new HashMap<>();
  475. mapp.put("messageType", 3);
  476. mapp.put("sendPerson", "system");
  477. mapp.put("receivePerson", mesMap.get("capacityNumber"));
  478. mapp.put("messageContent", mesMap);
  479. mapp.put("createTime", new Date());
  480. ArrayList<Object> list = new ArrayList<>();
  481. list.add(mapp);
  482. //调用websocket接口推送
  483. HashMap<Object, Object> sendMap = new HashMap<>();
  484. //将消息实体放入list中存到map中
  485. sendMap.put("messages", list);
  486. String s = imFeign.sendToUser(sendMap);
  487. System.out.println(s);
  488. }
  489. @Override//判断一车多单是否还有订单,如果又就再推送消息给他
  490. public void pushMessageToDriver(Map<String, Object> mapValue) {
  491. Map<String,Object> mapAddOrder =omstruckOrderMapper.getSporadicOrdermapAddOrder(new BigDecimal(mapValue.get("orderId").toString()));
  492. BigDecimal sporadicOrderTimes = DataChange.dataToBigDecimal(mapAddOrder.get("sporadicOrderTimes"));
  493. BigDecimal sporadicOrderId = DataChange.dataToBigDecimal(mapAddOrder.get("sporadicOrderId"));
  494. BigDecimal orderId = DataChange.dataToBigDecimal(mapValue.get("orderId"));
  495. BigDecimal capacityId = DataChange.dataToBigDecimal(mapAddOrder.get("capacityId"));
  496. Map<String, Object> addMapSporadicOrder = new HashMap<>();
  497. addMapSporadicOrder.put("sporadicOrderId",sporadicOrderId);
  498. addMapSporadicOrder.put("orderId",orderId);
  499. List<Map<String,Object>> mapList = new ArrayList<>();
  500. Map<String,Object> map=new HashMap<>();
  501. map.put("capacityId",capacityId);
  502. mapList.add(map);
  503. addMapSporadicOrder.put("mapList",mapList);
  504. if (sporadicOrderTimes.intValue()>0){
  505. //mapvalue需要orderId,零星订单id,maplist放一个运力id
  506. amsFeign.addSporadicOrderTimes(addMapSporadicOrder);
  507. }
  508. }
  509. //撤销订单
  510. @Override
  511. public int undoOrder(Map<String, Object> map) {
  512. int result=0;
  513. Integer orderId =(Integer) map.get("orderId");
  514. OmstruckOrder omstruckOrder=new OmstruckOrder();
  515. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
  516. //根据运输订单号获取planId
  517. Map<String, Object> messageMap = omstruckOrderSeparateMapper.getOmstruckOrderResult(new BigDecimal(orderId));
  518. BigDecimal orderPlanId =(BigDecimal) messageMap.get("orderPlanId");
  519. //将订单状态设为未接收
  520. omstruckOrder.setOrderStatus(new BigDecimal(4));
  521. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  522. Map<String, Object> allResultId = omstruckOrderMapper.getAllResultId(DataChange.dataToBigDecimal(orderId));
  523. BigDecimal weightResultId =(BigDecimal) allResultId.get("weightResultId");
  524. result += omstruckOrderMapper.deleteWeightResult(weightResultId);
  525. BigDecimal loadResultId =(BigDecimal) allResultId.get("loadResultId");
  526. if (loadResultId!=null) {
  527. result += omstruckOrderMapper.deleteLoadResult(loadResultId);
  528. }
  529. BigDecimal leaveResultId=(BigDecimal) allResultId.get("leaveResultId");
  530. result += omstruckOrderMapper.deleteLeaveResult(leaveResultId);
  531. BigDecimal unloadResultId =(BigDecimal) allResultId.get("unloadResultId");
  532. if (unloadResultId!=null) {
  533. result += omstruckOrderMapper.deleteUnloadResult(unloadResultId);
  534. }
  535. BigDecimal enFactoryId =(BigDecimal) allResultId.get("enFactoryId");
  536. result +=omstruckOrderMapper.deleteEnResult(enFactoryId);
  537. //删除所有实绩
  538. Integer orderType = omstruckOrderMapper.getOrderTypeByOrderNumber(new BigDecimal(orderId));
  539. switch (orderType){
  540. case 12:
  541. case 13:
  542. case 15:
  543. case 16:
  544. Map<String, Object> sporadicOrderTimes = omstruckOrderMapper.getSporadicOrderTimes(new BigDecimal(orderId));
  545. BigDecimal orderTimes =(BigDecimal)sporadicOrderTimes.get("orderTimes");
  546. BigDecimal transTimes = (BigDecimal)sporadicOrderTimes.get("transTimes");
  547. //更新趟次
  548. omstruckOrderSeparateService.updateTimes(orderPlanId,orderTimes.intValue()+1);
  549. //更新已运输趟次
  550. if (transTimes.intValue()>0) {
  551. omstruckOrderSeparateMapper.updateTranTimes(orderPlanId, transTimes.intValue() - 1);
  552. }
  553. break;
  554. }
  555. return result;
  556. }
  557. //修改运力
  558. @Override
  559. public int updateCapacityId(Map<String,Object> map) {
  560. int result=0;
  561. OmstruckOrder omstruckOrder=new OmstruckOrder();
  562. BigDecimal orderId =DataChange.dataToBigDecimal(map.get("orderId"));
  563. BigDecimal capacityId =DataChange.dataToBigDecimal(map.get("capacityId"));
  564. omstruckOrder.setOrderId(orderId);
  565. omstruckOrder.setCapacityId(capacityId);
  566. result+=omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  567. return result;
  568. }
  569. /**
  570. * 销售物流,下发订单
  571. *
  572. * @param map
  573. * @return
  574. */
  575. @Override
  576. public int dispatchOrderForSale(Map<String, Object> map) {
  577. OmstruckOrder omstruckOrder = new OmstruckOrder();
  578. Integer orderId = (Integer) map.get("orderId");
  579. Integer orderType = (Integer) map.get("orderType");
  580. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
  581. if (orderType == 2 || orderType == 3) {
  582. Integer loadId = (Integer) map.get("LoadId");
  583. if (loadId != null) {
  584. //根据运输订单id查找装车实绩id
  585. omstruckOrder.setUnloadPointId(DataChange.dataToBigDecimal(loadId));
  586. }
  587. }
  588. //设置下发状态
  589. omstruckOrder.setOrderIssueTime(new Date());
  590. omstruckOrder.setOrderStatus(new BigDecimal(4));
  591. // pushMesToWebsocket(map); //下发 推送数据给 websocket
  592. return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  593. }
  594. @Override
  595. public List<Map<String, Object>> selectWaterSlagForOrder(Map<String, Object> map) {
  596. return omstruckOrderMapper.selectWaterSlagForOrder(map);
  597. }
  598. @Override
  599. public List<Map<String, Object>> selectCokeRailPlanForOrder(Map<String, Object> map) {
  600. return omstruckOrderMapper.selectCokeRailPlanForOrder(map);
  601. }
  602. /**
  603. * 司机接单、拒绝 0:拒绝 1:接收
  604. * 需要接收参数 主键Id 与 接收拒绝操作码
  605. *
  606. * @param map
  607. * @return
  608. */
  609. @Override
  610. @Transactional
  611. public synchronized int driverReceiveOrRefuse(Map<String, Object> map) {
  612. BigDecimal orderId = DataChange.dataToBigDecimal(map.get("orderId"));
  613. OmstruckOrder omstruckOrder = new OmstruckOrder();
  614. if((Integer) map.get("orderReceiveStatus") == 1) {
  615. List<Integer> orderIdList = omstruckOrderMapper.getReceiveOrderIdListByCapacityNum((String) map.get("capacityNumber"));
  616. if (orderIdList.size() > 0) {
  617. return 0;
  618. }
  619. omstruckOrder.setOrderStatus(new BigDecimal(5)); //5 :已接收
  620. //通过订单ID查询信息
  621. Map<String, Object> orderMessage = omstruckOrderSeparateMapper.getOrderMessagge(orderId);
  622. //添加各个实绩
  623. omstruckOrderSeparateService.addAllSonResult(orderMessage);
  624. //判断订单是否是一车多单
  625. BigDecimal orderType = (BigDecimal) orderMessage.get("orderType");
  626. if (orderType.intValue()==15 || orderType.intValue()==16) {
  627. //通过订单查询趟次
  628. Map<String, Object> sporadicOrderTimes = omstruckOrderMapper.getSporadicOrderTimes(orderId);
  629. BigDecimal orderTimes = DataChange.dataToBigDecimal(sporadicOrderTimes.get("orderTimes"));
  630. //通过订单id查询已运输趟次
  631. BigDecimal transTimes=DataChange.dataToBigDecimal(sporadicOrderTimes.get("transTimes"));
  632. //生成作业实绩之后、更改订单数量
  633. if (orderMessage.containsKey("orderPlanId") && orderTimes.intValue() > 0) {
  634. int state =0;
  635. state+=omstruckOrderSeparateService.updateTimes(new BigDecimal(orderMessage.get("orderPlanId").toString()), orderTimes.intValue() - 1);
  636. //接收订单以后已运输订单趟次+1
  637. state+=omstruckOrderSeparateMapper.updateTranTimes(DataChange.dataToBigDecimal(orderMessage.get("orderPlanId").toString()),transTimes.intValue()+1);
  638. System.out.println(state);
  639. }
  640. }
  641. } else { //其他状态都视为 拒绝接单
  642. omstruckOrder.setOrderStatus(new BigDecimal(6));
  643. //添加拒绝原因
  644. omstruckOrder.setInsertUpdateRemark((String) map.get("insertUpdateRemark"));
  645. }
  646. omstruckOrder.setOrderId(orderId);
  647. //生成接收/拒绝时间
  648. Date receiveTime = new Date();
  649. omstruckOrder.setOrderReceiveRefuseTime(receiveTime);
  650. //计算司机从派单到操作时长
  651. Date issueTime = omstruckOrderMapper.getInsertTimeById(orderId.intValue());
  652. long time = receiveTime.getTime() - issueTime.getTime();
  653. long min = time / (1000 * 60);
  654. omstruckOrder.setOrderCommunicationDuration(new BigDecimal(min));
  655. return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  656. }
  657. //根据承运商获取销售订单
  658. @Override
  659. public List<Map<String, Object>> selectSaleOrderForCarrier(Map<String, Object> map) {
  660. Integer carrierId = (Integer) map.get("carrierId");
  661. List<Map<String, Object>> maps = omstruckOrderMapper.selectSaleMaterialIdByCarrierId(carrierId);
  662. List<Map<String, Object>> list = null;
  663. for (Map<String, Object> map1 : maps) {
  664. BigDecimal saleOrderMaterialId = (BigDecimal) map1.get("saleOrderMaterialId");
  665. list = omstruckOrderMapper.selectSaleBySaleOrderMaterialId(saleOrderMaterialId.intValue());
  666. }
  667. return list;
  668. }
  669. /**
  670. * 查询已接收的焦炭发运计划
  671. *
  672. * @param
  673. * @return
  674. */
  675. @Override
  676. public List<Map<String, Object>> selectCokeDayPlanAndRecived(Map<String, Object> map) {
  677. return omstruckOrderMapper.selectCokeDayPlanAndRecived(map);
  678. }
  679. /**
  680. * 查询已接收的水渣发运计划
  681. *
  682. * @param
  683. * @return
  684. */
  685. @Override
  686. public List<Map<String, Object>> selectWaterSlagDayPlanAndRecived(Integer carrierId) {
  687. return omstruckOrderMapper.selectWaterSlagDayPlanAndRecived(carrierId);
  688. }
  689. /**
  690. * 司机接单推送数据
  691. * 车牌号
  692. * @param
  693. * @return
  694. */
  695. @Override
  696. public List<Map<String, Object>> sendMesToDriver(Map<String, Object> map) {
  697. //通过车牌号匹配运力ID
  698. BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum((String) map.get("capacityNumber"));
  699. if (capacityId == null) {
  700. return null;
  701. }
  702. map.put("capacityId", capacityId);
  703. //通过运力Id匹配 已下发的运输订单
  704. List<Map<String, Object>> truckOrderByCapacityNum;
  705. if ((Integer) map.get("orderType") == 1 || (Integer) map.get("orderType") == 2) {
  706. truckOrderByCapacityNum = omstruckOrderMapper.getSaleTruckOrderByCapacityNum(map);
  707. } else {
  708. truckOrderByCapacityNum = omstruckOrderMapper.getTruckOrderByCapacityNum(map);
  709. }
  710. return truckOrderByCapacityNum;
  711. }
  712. /**
  713. * 得到作业时间和地点
  714. *
  715. * @param orderId
  716. * @return
  717. */
  718. @Override
  719. public List<Map<String, Object>> selectPlaceAndTime(BigDecimal orderId) {
  720. List<Map<String, Object>> mapList = omstruckOrderMapper.selectPlaceAndTime(orderId);
  721. Map<String, Object> map = mapList.get(0);
  722. String entryGatepost = (String) map.get("entryGatepost");
  723. Date entryTime = (Date) map.get("entryTime");
  724. String entryResult = entryGatepost + "/" + entryTime;
  725. String grossCalculate = (String) map.get("grossCalculate");
  726. Date grossTime = (Date) map.get("grossTime");
  727. String grossResult = grossCalculate + "/" + grossTime;
  728. String unloadWarhouse = (String) map.get("unloadWarhouse");
  729. Date unloadTime = (Date) map.get("unloadTime");
  730. String unloadResult = unloadWarhouse + "/" + unloadTime;
  731. String tareCalculate = (String) map.get("tareCalculate");
  732. Date tareTime = (Date) map.get("tareTime");
  733. String tareResult = tareCalculate + "/" + tareTime;
  734. String leaveGatepost = (String) map.get("leaveGatepost");
  735. Date outTime = (Date) map.get("outTime");
  736. String leaveResult = leaveGatepost + "/" + outTime;
  737. String receiptWarhouse = (String) map.get("receiptWarhouse");
  738. Date receiptTime = (Date) map.get("receiptTime");
  739. String receiptResult = receiptWarhouse + "/" + receiptTime;
  740. List<Map<String, Object>> resultList = new ArrayList<>();
  741. Map<String, Object> map1 = new HashMap<>();
  742. map1.put("title", "进厂门岗/时间");
  743. map1.put("desc", entryResult);
  744. resultList.add(map1);
  745. Map<String, Object> map2 = new HashMap<>();
  746. map2.put("title", "毛重衡器/时间");
  747. map2.put("desc", grossResult);
  748. resultList.add(map2);
  749. Map<String, Object> map3 = new HashMap<>();
  750. map3.put("title", "卸货地点/时间");
  751. map3.put("desc", unloadResult);
  752. resultList.add(map3);
  753. Map<String, Object> map4 = new HashMap<>();
  754. map4.put("title", "皮重衡器/时间");
  755. map4.put("desc", tareResult);
  756. resultList.add(map4);
  757. Map<String, Object> map5 = new HashMap<>();
  758. map5.put("title", "出厂门岗/时间");
  759. map5.put("desc", leaveResult);
  760. resultList.add(map5);
  761. if ((Integer) map.get("orderType") == 1) {
  762. Map<String, Object> map6 = new HashMap<>();
  763. map5.put("title", "异地库/时间");
  764. map5.put("desc", receiptResult);
  765. resultList.add(map6);
  766. }
  767. Map<String, Object> map7 = new HashMap<>();
  768. BigDecimal orderLineSequence = (BigDecimal) map.get("orderLineSequence");
  769. map7.put("orderLineSequence", orderLineSequence);
  770. resultList.add(map7);
  771. return resultList;
  772. }
  773. /**
  774. * 查询已下发未接受的销售订单信息
  775. *
  776. * @param orderType
  777. * @return
  778. */
  779. @Override
  780. public List<Map<String, Object>> getOrderUnReceive(BigDecimal orderType) {
  781. return omstruckOrderMapper.getOrderUnReceive(orderType);
  782. }
  783. /**
  784. * 查询已下发已接受的销售订单信息
  785. *
  786. * @param orderType
  787. * @return
  788. */
  789. @Override
  790. public List<Map<String, Object>> getOrderReceived(BigDecimal orderType) {
  791. return omstruckOrderMapper.getOrderReceived(orderType);
  792. }
  793. /**
  794. * 分派钢材销售订单
  795. *
  796. * @param map
  797. * @return
  798. */
  799. @Override
  800. public int dispatchSteelOrder(Map<String, Object> map) {
  801. //新增运单(销售钢材订单)
  802. //生成运输订单号和主键以及绑定运力
  803. OmstruckOrder omstruckOrder = generateOmsTruckOrder(map);
  804. //设置线路 遗留问题,设置为进门门岗
  805. omstruckOrder.setLineId(new BigDecimal(1));
  806. //新增运输订单
  807. omstruckOrderMapper.insertSelective(omstruckOrder);
  808. //更新运力状态为待运输:2
  809. // map.put("capacityStatus", 2);
  810. // omstruckOrderMapper.updateCapacityById(map);
  811. //新增运输订单子表
  812. addOrderMaterial(map, omstruckOrder.getOrderId());
  813. //新增实绩总表关联订单 feign调用
  814. map.put("orderId", omstruckOrder.getOrderId());
  815. tmsTruckFeign.addTotalResult(map);
  816. return 6;
  817. }
  818. //设置销售订单下发状态
  819. @Override
  820. public int IssueSteelOrder(Map<String, Object> map) {
  821. //设置下发状态
  822. OmstruckOrder omstruckOrder = new OmstruckOrder();
  823. Integer orderId = (Integer) map.get("orderId");
  824. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
  825. omstruckOrder.setOrderIssueTime(new Date());
  826. //设置下发状态值:4
  827. omstruckOrder.setOrderStatus(new BigDecimal(4));
  828. return 2;
  829. }
  830. //销售模块查看所有订单
  831. @Override
  832. public List<Map<String, Object>> selectAllOrderForSale(Map<String, Object> map) {
  833. //map获取承运商
  834. Integer carrierId = (Integer) map.get("carrierId");
  835. Integer saleOrderMaterialId = (Integer) map.get("saleOrderMaterialId");
  836. List<Map<String, Object>> maps = omstruckOrderMapper.selectSaleMaterialIdByCarrierId(carrierId);
  837. //根据车序号查找运输订单
  838. List<Map<String, Object>> mapList = null;
  839. List<Map<String, Object>> maps1 = new ArrayList<>();
  840. //判断获取的车序号是否属于承运商
  841. for (Map<String, Object> map1 : maps) {
  842. BigDecimal compareNum = DataChange.dataToBigDecimal(map1.get("saleOrderMaterialId"));
  843. if (compareNum.intValue() == saleOrderMaterialId) {
  844. mapList = omstruckOrderMapper.selectAllOrderForSale(map);
  845. for (int i = 0; i < mapList.size(); i++) {
  846. Map<String, Object> map2 = mapList.get(i);
  847. if (map2.get("orderId") == null) {
  848. return maps1;
  849. }
  850. }
  851. return mapList;
  852. }
  853. }
  854. return maps1;
  855. }
  856. @Override
  857. public List<Map<String, Object>> selectTransportOrderForSale(Map<String, Object> map) {
  858. String carrierSsoId = (String) map.get("carrierSsoId");
  859. BigDecimal carrierId = omstruckOrderMapper.getCarrierIdBySSO(carrierSsoId);
  860. map.put("carrierId",carrierId);
  861. List<Map<String, Object>> mapList = omstruckOrderMapper.selectTransportOrderForSale(map);
  862. int count = 1;
  863. for (Map<String, Object> stringObjectMap : mapList) {
  864. stringObjectMap.put("ROW_ID",count);
  865. count ++;
  866. }
  867. return mapList;
  868. }
  869. @Override
  870. public List<Map<String, Object>> selectSteelSaleForCarrier(Map<String, Object> map) {
  871. return omstruckOrderMapper.selectSteelSaleForCarrier(map);
  872. }
  873. //根据销售订单id查找信息
  874. @Override
  875. public List<Map<String, Object>> selectInfoBySaleOrderId(Integer saleOrderId) {
  876. return omstruckOrderMapper.selectInfoBySaleOrderId(saleOrderId);
  877. }
  878. @Override
  879. public List<Map<String, Object>> selectCokeRailPlan(Map<String, Object> map) {
  880. return omstruckOrderMapper.selectCokeRailPlan(map);
  881. }
  882. @Override
  883. public List<Map<String, Object>> selectInfoByDayPlanId(Map<String, Object> map) {
  884. return omstruckOrderMapper.selectInfoByDayPlanId(map);
  885. }
  886. /**
  887. * 查找司机排班表信息
  888. *
  889. * @param map
  890. * @return
  891. */
  892. @Override
  893. public List<Map<String, Object>> selectCapacityAndDriver(Map<String, Object> map) {
  894. return omstruckOrderMapper.selectCapacityAndDriver(map);
  895. }
  896. /**
  897. * 查询所有运力信息
  898. *
  899. * @return
  900. */
  901. @Override
  902. public List<Map<String, Object>> getAllCapacity(Map<String, Object> map) {
  903. return omstruckOrderMapper.getAllCapacity(map);
  904. }
  905. /**
  906. * 用于后台展示司机接单未接单数据
  907. *
  908. * @param map
  909. * @return
  910. */
  911. @Override
  912. public List<Map<String, Object>> getReceiveRefuseOrder(Map<String, Object> map) {
  913. return omstruckOrderMapper.getTruckOrderByCapacityNum(map);
  914. }
  915. /**
  916. * 通过运输订单号查询运单所有信息 包含作业路径名称
  917. *
  918. * @param map 传运输订单号
  919. * @return
  920. */
  921. @Override
  922. public List<Map<String, Object>> getOrderMesByOrderNum(Map<String, Object> map) {
  923. return omstruckOrderMapper.getTruckOrderByCapacityNum(map);
  924. }
  925. /**
  926. * 查询所有司机已拒绝的订单
  927. * 车牌号
  928. *
  929. * @param map
  930. * @return
  931. */
  932. @Override
  933. public List<Map<String, Object>> getReceiveRefuseOrderByCapacityId(Map<String, Object> map) {
  934. //通过车牌号查询运力Id
  935. BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum((String) map.get("capacityNumber"));
  936. map.put("capacityId", capacityId);
  937. return omstruckOrderMapper.getReceiveRefuseOrderByCapacityId(map);
  938. }
  939. /**
  940. * 通过运单号查询订单详情
  941. * 运输订单号
  942. *
  943. * @param
  944. * @return
  945. */
  946. @Override
  947. public List<Map<String, Object>> getOrderByOrderId(BigDecimal orderId) {
  948. return omstruckOrderMapper.getOrderByOrderId(orderId);
  949. }
  950. /**
  951. * 查看运输派单
  952. *
  953. * @param map
  954. * @return
  955. */
  956. @Override
  957. public List<Map<String, Object>> getTransportDispatch(Map<String, Object> map) {
  958. return omstruckOrderMapper.getTransportDispatch(map);
  959. }
  960. /**
  961. * 用于更新路段顺序号
  962. *
  963. * @param map orderId
  964. * @return
  965. */
  966. public int updateOrderLineSequence(Map<String, Object> map, Integer lineSequence) {
  967. OmstruckOrder omstruckOrder = new OmstruckOrder();
  968. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(map.get("orderId")));
  969. omstruckOrder.setOrderLineSequence(new BigDecimal(lineSequence));
  970. return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  971. }
  972. //新增内转运输订单
  973. @Override
  974. public int insert(OmstruckOrder omstruckOrder) {
  975. //生成订单主键Id
  976. BigDecimal maxId = omstruckOrderMapper.selectMaxId();
  977. omstruckOrder.setOrderId(maxId);
  978. //生成运输订单号
  979. int id = maxId.intValue();
  980. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", id);
  981. omstruckOrder.setOrderNumber(orderNumber);
  982. //设置状态为未下发
  983. omstruckOrder.setOrderStatus(new BigDecimal(3));
  984. //设置运输订单的类型
  985. omstruckOrder.setOrderType(new BigDecimal(11));
  986. omstruckOrder.setInsertTime(new Date());
  987. omstruckOrder.setInsertUsername("admin");
  988. return omstruckOrderMapper.insertSelective(omstruckOrder);
  989. }
  990. //通过物资id查询批次表匹配最新的批次,关联最新的采购订单号
  991. @Override
  992. public Map<String, Object> selectNewOrderId(Map<String, Object> map) {
  993. return omstruckOrderMapper.selectNewOrderId(map);
  994. }
  995. //app司机接单查询数据
  996. @Override
  997. public Map<String, Object> sendMesToDriverApp(Map<String, Object> map) {
  998. //通过车牌号匹配运力ID
  999. BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum((String) map.get("capacityNumber"));
  1000. map.put("capacityId", capacityId);
  1001. if (capacityId == null) {
  1002. return null;
  1003. }
  1004. //通过运力Id匹配 已下发的运输订单
  1005. Map<String, Object> truckOrderByCapacityNum = new HashMap<>();
  1006. if ((Integer) map.get("orderType") == 1 || (Integer) map.get("orderType") == 2) {
  1007. //查询主干信息
  1008. Map<String, Object> map1 = omstruckOrderMapper.getSaleTruckOrderByCapacityId(map);
  1009. //查询物资信息
  1010. List<Map<String, Object>> mapList = omstruckOrderMapper.getSaleTruckOrderByCapacityNumMaterial(map);
  1011. truckOrderByCapacityNum.put("orderf", map1);
  1012. truckOrderByCapacityNum.put("materialList", mapList);
  1013. }
  1014. return truckOrderByCapacityNum;
  1015. }
  1016. @Override
  1017. public BigDecimal selectCapacityId(BigDecimal carrierId, String capacityNumber) {
  1018. return omstruckOrderMapper.selectCapacityId(carrierId, capacityNumber);
  1019. }
  1020. /**
  1021. * 车牌号下拉
  1022. *
  1023. * @return
  1024. */
  1025. @Override
  1026. public List<Map<String, Object>> getDriverCapacity() {
  1027. return omstruckOrderMapper.getDriverCapacity();
  1028. }
  1029. /**
  1030. * 派单信息
  1031. *
  1032. * @param dispatchId
  1033. * @return
  1034. */
  1035. @Override
  1036. public Map<String, Object> getTruckNoDispatchMap(Integer dispatchId) {
  1037. Map<String, Object> map = omstruckOrderMapper.getTruckNoDispatchMap(new BigDecimal(dispatchId));
  1038. List<BigDecimal> orderIdList = omstruckOrderMapper.getNullOrNotNull(new BigDecimal(dispatchId));
  1039. if (orderIdList != null || orderIdList.size() != 0) {
  1040. return null;
  1041. }
  1042. List<Map<String, Object>> materialMessages = omstruckOrderMapper.getMaterialMessages(new BigDecimal(dispatchId));
  1043. String allMaterialName = "";
  1044. String allMaterialNumber = "";
  1045. String allMaterialTheoreticalWeight = "";
  1046. String allMaterialSpecificationModel = "";
  1047. if (materialMessages == null || materialMessages.size() == 0) {
  1048. } else {
  1049. for (Map<String, Object> materialMap : materialMessages) {
  1050. if (materialMap != null) {
  1051. String materialName = (String) materialMap.get("materialName");
  1052. allMaterialName += materialName + "/";
  1053. String materialTheoreticalWeight = materialMap.get("materialTheoreticalWeight").toString();
  1054. if (materialTheoreticalWeight != null) {
  1055. allMaterialTheoreticalWeight += materialTheoreticalWeight + "/";
  1056. }
  1057. String saleOrderMaterialNumber = materialMap.get("saleOrderMaterialNumber").toString();
  1058. allMaterialNumber += saleOrderMaterialNumber + "/";
  1059. String specificationModel = materialMap.get("specificationModel").toString();
  1060. if (specificationModel != null) {
  1061. allMaterialSpecificationModel += specificationModel + "/";
  1062. }
  1063. }
  1064. }
  1065. String subMaterialName = null;
  1066. String subMaterialNumber = null;
  1067. String subMaterialTheoreticalWeight = null;
  1068. String subMaterialSpecificationModel = null;
  1069. if (allMaterialName.length() >= 2) {
  1070. subMaterialName = allMaterialName.substring(0, allMaterialName.length() - 2);
  1071. }
  1072. if (allMaterialName.length() < 2) {
  1073. subMaterialName = allMaterialName;
  1074. }
  1075. if (allMaterialNumber.length() >= 2) {
  1076. subMaterialNumber = allMaterialNumber.substring(0, allMaterialNumber.length() - 2);
  1077. }
  1078. if (allMaterialNumber.length() < 2) {
  1079. subMaterialNumber = allMaterialNumber;
  1080. }
  1081. if (allMaterialTheoreticalWeight.length() >= 2) {
  1082. subMaterialTheoreticalWeight = allMaterialTheoreticalWeight.substring(0, allMaterialTheoreticalWeight.length() - 2);
  1083. }
  1084. if (allMaterialTheoreticalWeight.length() < 2) {
  1085. subMaterialTheoreticalWeight = allMaterialTheoreticalWeight;
  1086. }
  1087. if (allMaterialSpecificationModel.length() >= 2) {
  1088. subMaterialSpecificationModel = allMaterialSpecificationModel.substring(0, allMaterialSpecificationModel.length() - 2);
  1089. }
  1090. if (allMaterialSpecificationModel.length() < 2) {
  1091. subMaterialSpecificationModel = allMaterialSpecificationModel;
  1092. }
  1093. map.put("allMaterialName", subMaterialName);
  1094. map.put("allMaterialNumber", subMaterialNumber);
  1095. map.put("allMaterialTheoreticalWeight", subMaterialTheoreticalWeight);
  1096. map.put("allMaterialSpecificationModel", subMaterialSpecificationModel);
  1097. }
  1098. return map;
  1099. }
  1100. /**
  1101. * 承运商分派运输订单给司机
  1102. * @param dispatchId
  1103. * @param orderType
  1104. * @param capacityNumber
  1105. * @param carrierId
  1106. * @return
  1107. */
  1108. @Override
  1109. public int addAppTruckOrder(Integer dispatchId, Integer orderType, String capacityNumber, Integer carrierId) {
  1110. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1111. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  1112. Map<String,Object> orderIdMap = new HashMap<>();
  1113. orderIdMap.put("orderId",orderId);
  1114. tmsTruckFeign.addTotalResult(orderIdMap);
  1115. omstruckOrder.setOrderId(orderId);
  1116. BigDecimal saleOrderMaterialId = omstruckOrderMapper.getSaleMaterialId(new BigDecimal(dispatchId));
  1117. omstruckOrder.setOrderPlanId(saleOrderMaterialId);
  1118. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue());
  1119. omstruckOrder.setOrderNumber(orderNumber);
  1120. omstruckOrder.setOrderIssueTime(new Date());
  1121. omstruckOrder.setOrderStatus(new BigDecimal(4));
  1122. omstruckOrder.setInsertTime(new Date());
  1123. omstruckOrder.setUpdateTime(new Date());
  1124. omstruckOrder.setInsertUsername("admin");
  1125. omstruckOrder.setUpdateUsername("admin");
  1126. omstruckOrder.setInsertUpdateRemark("无");
  1127. omstruckOrder.setDeleted(new BigDecimal(0));
  1128. omstruckOrder.setOrderType(new BigDecimal(orderType));
  1129. BigDecimal capacityId = omstruckOrderMapper.getCapacityId(capacityNumber);
  1130. omstruckOrder.setCapacityId(capacityId);
  1131. // omstruckOrder.setCarrierId();
  1132. // BigDecimal driverCapacityId = omstruckOrderMapper.getDriverCapacityId(capacityId);
  1133. // omstruckOrder.setDriverCapacityId(driverCapacityId);
  1134. // RmsDriverCapacity rmsDriverCapacity = rmsDriverCapacityMapper.selectByPrimaryKey(driverCapacityId);
  1135. // rmsDriverCapacity.setCarrierId(new BigDecimal(carrierId));
  1136. // rmsDriverCapacityMapper.updateByPrimaryKeySelective(rmsDriverCapacity);
  1137. List<Map<String, Object>> mapList = omstruckOrderMapper.getMaterialMessages(new BigDecimal(dispatchId));
  1138. if (mapList != null && mapList.size() != 0) {
  1139. for (Map<String, Object> map : mapList) {
  1140. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1141. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1142. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1143. omstruckOrderMaterial.setOrderId(orderId);
  1144. omstruckOrderMaterial.setInsertTime(new Date());
  1145. omstruckOrderMaterial.setUpdateTime(new Date());
  1146. omstruckOrderMaterial.setInsertUsername("admin");
  1147. omstruckOrderMaterial.setUpdateUsername("admin");
  1148. omstruckOrderMaterial.setInsertUpdateRemark("无");
  1149. if (map != null) {
  1150. BigDecimal materialTheoreticalWeight = (BigDecimal) map.get("materialTheoreticalWeight");
  1151. BigDecimal saleOrderMaterialNumber = (BigDecimal) map.get("saleOrderMaterialNumber");
  1152. BigDecimal materialId = (BigDecimal) map.get("materialId");
  1153. omstruckOrderMaterial.setOrderMaterialWeight(materialTheoreticalWeight);
  1154. omstruckOrderMaterial.setMaterialId(materialId);
  1155. omstruckOrderMaterial.setOrderMaterialNumber(saleOrderMaterialNumber);
  1156. }
  1157. omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  1158. }
  1159. }
  1160. // RmsCapacity rmsCapacity = new RmsCapacity();
  1161. // rmsCapacity.setCapacityId(capacityId);
  1162. // rmsCapacity.setCapacityStatus(new BigDecimal(2));
  1163. // rmsCapacityMapper.updateByPrimaryKeySelective(rmsCapacity);
  1164. int result = omstruckOrderMapper.insertSelective(omstruckOrder);
  1165. // 调用websocket推送数据给司机
  1166. pushMesToWebsocket(orderIdMap);
  1167. return result;
  1168. }
  1169. /**
  1170. * 根据运单id关闭订单
  1171. * @param orderId
  1172. * @return
  1173. */
  1174. @Override
  1175. public int closeOmstruckOrder(BigDecimal orderId) {
  1176. OmstruckOrder omstruckOrder = omstruckOrderMapper.selectByPrimaryKey(orderId);
  1177. omstruckOrder.setOrderStatus(new BigDecimal(7));
  1178. int result = omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1179. return result;
  1180. }
  1181. /**
  1182. * 查询所有车牌号和司机
  1183. * @param mapValue
  1184. * @return
  1185. */
  1186. @Override
  1187. public List<Map<String, Object>> getCapacityAndDriverList(Map<String, Object> mapValue) {
  1188. return omstruckOrderMapper.getCapacityAndDriver(mapValue);
  1189. }
  1190. @Override
  1191. public int closeOrder(Map<String, Object> map) {
  1192. Integer orderId =(Integer) map.get("orderId");
  1193. OmstruckOrder omstruckOrder=new OmstruckOrder();
  1194. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
  1195. omstruckOrder.setOrderStatus(new BigDecimal(8));
  1196. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1197. return 1;
  1198. }
  1199. /**
  1200. * 分解内转计划(新增运输订单)
  1201. * @param mapValue
  1202. * @return
  1203. */
  1204. @Transactional
  1205. @Override
  1206. public int addInwardOrder(Map<String, Object> mapValue) {
  1207. int result = 0;
  1208. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  1209. String planId = (String) mapValue.get("planId");
  1210. Integer lineId = (Integer) mapValue.get("lineId");
  1211. String orderType = (String) mapValue.get("orderType");
  1212. Integer carrierId = (Integer) mapValue.get("carrierId");
  1213. AmstruckInwardPlan amstruckInwardPlan = amstruckInwardPlanMapper.selectByPrimaryKey(new BigDecimal(planId));
  1214. amstruckInwardPlan.setPlanStatus(new BigDecimal(3));
  1215. result += amstruckInwardPlanMapper.updateByPrimaryKeySelective(amstruckInwardPlan);
  1216. BigDecimal materialId = omstruckOrderMapper.getInwardMaterial(new BigDecimal(planId));
  1217. for (Map<String,Object> orderMap : mapList) {
  1218. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1219. String capacityNumber = (String)orderMap.get("capacityNumber");
  1220. BigDecimal materialNumber = DataChange.dataToBigDecimal(orderMap.get("materialNumber")) ;
  1221. BigDecimal materialWeight = DataChange.dataToBigDecimal(orderMap.get("materialWeight"));
  1222. Map<String,Object> capacityMap = new HashMap<>();
  1223. capacityMap.put("capacityNumber",capacityNumber);
  1224. List<RmsCapacity> rmsCapacities = rmsCapacityMapper.selectByParameters(capacityMap);
  1225. RmsCapacity rmsCapacity = rmsCapacities.get(0);
  1226. // rmsCapacity.setCapacityStatus(new BigDecimal(2));
  1227. result +=rmsCapacityMapper.updateByPrimaryKeySelective(rmsCapacity);
  1228. BigDecimal capacityId = rmsCapacity.getCapacityId();
  1229. capacityMap.clear();
  1230. capacityMap.put("capacityId",capacityId);
  1231. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  1232. // 添加总实绩
  1233. Map<String,Object> orderIdMap = new HashMap<>();
  1234. orderIdMap.put("orderId",orderId);
  1235. tmsTruckFeign.addTotalResult(orderIdMap);
  1236. omstruckOrder.setOrderId(orderId);
  1237. omstruckOrder.setOrderPlanId(new BigDecimal(planId));
  1238. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue());
  1239. omstruckOrder.setOrderNumber(orderNumber);
  1240. omstruckOrder.setOrderIssueTime(new Date());
  1241. omstruckOrder.setOrderStatus(new BigDecimal(3));
  1242. omstruckOrder.setCapacityId(capacityId);
  1243. omstruckOrder.setInsertTime(new Date());
  1244. omstruckOrder.setUpdateTime(new Date());
  1245. omstruckOrder.setInsertUsername("admin");
  1246. omstruckOrder.setUpdateUsername("admin");
  1247. omstruckOrder.setInsertUpdateRemark("无");
  1248. omstruckOrder.setDeleted(new BigDecimal(0));
  1249. omstruckOrder.setOrderType(new BigDecimal(orderType));
  1250. omstruckOrder.setLineId(new BigDecimal(lineId));
  1251. result +=omstruckOrderMapper.insertSelective(omstruckOrder);
  1252. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1253. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1254. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1255. omstruckOrderMaterial.setOrderId(orderId);
  1256. omstruckOrderMaterial.setMaterialId(materialId);
  1257. omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
  1258. omstruckOrderMaterial.setInsertTime(new Date());
  1259. omstruckOrderMaterial.setUpdateTime(new Date());
  1260. omstruckOrderMaterial.setInsertUsername("admin");
  1261. omstruckOrderMaterial.setUpdateUsername("admin");
  1262. omstruckOrderMaterial.setInsertUpdateRemark("无");
  1263. omstruckOrderMaterial.setOrderMaterialWeight(materialWeight);
  1264. result +=omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  1265. }
  1266. return result;
  1267. }
  1268. /**
  1269. * 查询分解计划
  1270. * @param mapValue
  1271. * @return
  1272. */
  1273. @Override
  1274. public List<Map<String, Object>> getInwardOrderList(Map<String, Object> mapValue) {
  1275. List<Map<String,Object>> mapList = omstruckOrderMapper.getInwardOrderList(mapValue);
  1276. return mapList;
  1277. }
  1278. /**
  1279. * 下发计划
  1280. * @param mapList
  1281. * @return
  1282. */
  1283. @Override
  1284. public int issuePlanOrder(List<Map<String, Object>> mapList) {
  1285. int result = 0;
  1286. for (Map<String,Object> map : mapList) {
  1287. Integer orderId = (Integer) map.get("orderId");
  1288. OmstruckOrder omstruckOrder = omstruckOrderMapper.selectByPrimaryKey(new BigDecimal(orderId));
  1289. omstruckOrder.setOrderStatus(new BigDecimal(4));
  1290. omstruckOrder.setOrderIssueTime(new Date());
  1291. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1292. }
  1293. return result;
  1294. }
  1295. /**
  1296. * 分派计划
  1297. * @param mapList
  1298. * @return
  1299. */
  1300. @Override
  1301. public int apportionInwardOrder(List<Map<String, Object>> mapList) {
  1302. int result = 0;
  1303. for (Map<String,Object> map : mapList) {
  1304. BigDecimal orderId = new BigDecimal((Integer) map.get("orderId"));
  1305. OmstruckOrder omstruckOrder = omstruckOrderMapper.selectByPrimaryKey(orderId);
  1306. omstruckOrder.setOrderIssueTime(new Date());
  1307. omstruckOrder.setOrderStatus(new BigDecimal(4));
  1308. // Map<Object, Object> map9 = new HashMap<>();
  1309. // long data = new Date().getTime();
  1310. // //根据运输订单id查询车牌号
  1311. // String capacityNumber = omstruckOrderMapper.selectCapacityNumber(orderId);
  1312. // BigDecimal orderType = omstruckOrderMapper.selectOrderType(orderId);
  1313. //
  1314. // map9.put("receivePerson",capacityNumber);
  1315. // map9.put("messageType",2);
  1316. // map9.put("snedPerson","system");
  1317. // map9.put("creatTime",data);
  1318. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1319. }
  1320. return result;
  1321. }
  1322. /**
  1323. * 司机APP端查询下发给自己运输订单
  1324. * @param capacityNumber
  1325. * @return
  1326. */
  1327. @Override
  1328. public List<Map<String, Object>> sendOrderToApp(String capacityNumber) {
  1329. //通过车牌号匹配运力ID
  1330. BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum(capacityNumber);
  1331. List<Map<String,Object>> resultList = omstruckOrderMapper.getResultList(capacityId);
  1332. for (Map<String,Object> map : resultList) {
  1333. BigDecimal orderId = (BigDecimal) map.get("orderId");
  1334. BigDecimal orderType = (BigDecimal) map.get("orderType");
  1335. // 查询物资信息
  1336. List<Map<String,Object>> materialMapList = omstruckOrderMapper.getMaterialMes(orderId);
  1337. String allMaterialName = "";
  1338. String allMaterialNumber = "";
  1339. String allMaterialWeight = "";
  1340. String allMaterialSpecificationModel = "";
  1341. // 对物资信息进行处理
  1342. if (materialMapList == null && materialMapList.size() == 0) {
  1343. } else {
  1344. for (Map<String,Object> materialMap : materialMapList) {
  1345. String materialName = (String) materialMap.get("materialName");
  1346. BigDecimal materialNumber = (BigDecimal) materialMap.get("materialNumber");
  1347. BigDecimal materialWeight = (BigDecimal) materialMap.get("materialWeight");
  1348. String materialModel = (String) materialMap.get("materialModel");
  1349. String materialSpecification = (String) materialMap.get("materialSpecification");
  1350. if (materialName != null) {
  1351. allMaterialName += materialName + "/";
  1352. }
  1353. if (materialNumber != null) {
  1354. allMaterialNumber += materialNumber.toString() + "/";
  1355. }
  1356. if (materialWeight != null) {
  1357. allMaterialWeight += materialWeight.toString() + "/";
  1358. }
  1359. if (materialSpecification != null || materialModel != null) {
  1360. allMaterialSpecificationModel += materialSpecification + materialModel + "/";
  1361. }
  1362. }
  1363. String subMaterialName = "";
  1364. String subMaterialNumber = "";
  1365. String subMaterialWeight = "";
  1366. String subMaterialSpecificationModel = "";
  1367. if (allMaterialName.length() >= 2) {
  1368. subMaterialName = allMaterialName.substring(0, allMaterialName.length() - 2);
  1369. }
  1370. if (allMaterialName.length() < 2) {
  1371. subMaterialName = allMaterialName;
  1372. }
  1373. if (allMaterialNumber.length() >= 2) {
  1374. subMaterialNumber = allMaterialNumber.substring(0, allMaterialNumber.length() - 1);
  1375. }
  1376. if (allMaterialNumber.length() < 2) {
  1377. subMaterialNumber = allMaterialNumber;
  1378. }
  1379. if (allMaterialWeight.length() >= 2) {
  1380. subMaterialWeight = allMaterialWeight.substring(0, allMaterialWeight.length() - 1);
  1381. }
  1382. if (allMaterialWeight.length() < 2) {
  1383. subMaterialWeight = allMaterialWeight;
  1384. }
  1385. if (allMaterialSpecificationModel.length() >= 2) {
  1386. subMaterialSpecificationModel = allMaterialSpecificationModel.substring(0, allMaterialSpecificationModel.length() - 2);
  1387. }
  1388. if (allMaterialSpecificationModel.length() < 2) {
  1389. subMaterialSpecificationModel = allMaterialSpecificationModel;
  1390. }
  1391. map.put("allMaterialName", subMaterialName);
  1392. map.put("allMaterialNumber", subMaterialNumber);
  1393. map.put("allMaterialWeight", subMaterialWeight);
  1394. map.put("allMaterialSpecificationModel", subMaterialSpecificationModel);
  1395. }
  1396. Map<String,Object> orderMap = null;
  1397. int intValue = orderType.intValue();
  1398. if (intValue == 1 || intValue == 2 || intValue == 3) {
  1399. orderMap = omstruckOrderMapper.getSaleOrderMap(orderId);
  1400. }
  1401. if (intValue == 4) {
  1402. orderMap = omstruckOrderMapper.getSteelInwardOrderMap(orderId);
  1403. }
  1404. if (intValue == 5 || intValue == 6 || intValue == 7 || intValue == 8) {
  1405. orderMap = omstruckOrderMapper.getPurchaseOrderMap(orderId);
  1406. }
  1407. if (intValue == 9 || intValue == 10 || intValue == 11) {
  1408. orderMap = omstruckOrderMapper.getInwardOrderMap(orderId);
  1409. }
  1410. map.putAll(orderMap);
  1411. }
  1412. return resultList;
  1413. }
  1414. //新增内转异地库计划订单(新增运输订单)
  1415. @Override
  1416. public int apportionInwardOffsetOrder(Map<String, Object> mapValue) {
  1417. int result = 0;
  1418. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  1419. String dayPlanId = (String) mapValue.get("dayPlanId");
  1420. Integer lineId = (Integer) mapValue.get("lineId");
  1421. String orderType = (String) mapValue.get("orderType");
  1422. // Integer carrierId = (Integer) mapValue.get("carrierId");
  1423. // AmstruckInwardPlan amstruckInwardPlan = amstruckInwardPlanMapper.selectByPrimaryKey(new BigDecimal(planId));
  1424. // amstruckInwardPlan.setPlanStatus(new BigDecimal(3));
  1425. // result += amstruckInwardPlanMapper.updateByPrimaryKeySelective(amstruckInwardPlan);
  1426. BigDecimal materialId = omstruckOrderMapper.getInwardMaterial(new BigDecimal(dayPlanId));
  1427. for (Map<String,Object> orderMap : mapList) {
  1428. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1429. String capacityNumber = (String)orderMap.get("capacityNumber");
  1430. BigDecimal materialNumber = DataChange.dataToBigDecimal(orderMap.get("materialNumber")) ;
  1431. // BigDecimal materialWeight = DataChange.dataToBigDecimal(orderMap.get("materialWeight"));
  1432. Map<String,Object> capacityMap = new HashMap<>();
  1433. capacityMap.put("capacityNumber",capacityNumber);
  1434. List<RmsCapacity> rmsCapacities = rmsCapacityMapper.selectByParameters(capacityMap);
  1435. RmsCapacity rmsCapacity = rmsCapacities.get(0);
  1436. rmsCapacity.setCapacityStatus(new BigDecimal(2));
  1437. result +=rmsCapacityMapper.updateByPrimaryKeySelective(rmsCapacity);
  1438. BigDecimal capacityId = rmsCapacity.getCapacityId();
  1439. capacityMap.clear();
  1440. capacityMap.put("capacityId",capacityId);
  1441. List<RmsDriverCapacity> rmsDriverCapacities = rmsDriverCapacityMapper.selectByParameters(capacityMap);
  1442. RmsDriverCapacity rmsDriverCapacity = rmsDriverCapacities.get(0);
  1443. BigDecimal dcId = rmsDriverCapacity.getDriverCapacityId();
  1444. if(dcId!=null){
  1445. BigDecimal orderId = omstruckOrderMapper.selectOrderId(dcId);
  1446. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1447. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1448. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1449. omstruckOrderMaterial.setOrderId(orderId);
  1450. omstruckOrderMaterial.setMaterialId(materialId);
  1451. omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
  1452. omstruckOrderMaterial.setInsertTime(new Date());
  1453. omstruckOrderMaterial.setUpdateTime(new Date());
  1454. omstruckOrderMaterial.setInsertUsername("admin");
  1455. omstruckOrderMaterial.setUpdateUsername("admin");
  1456. omstruckOrderMaterial.setInsertUpdateRemark("无");
  1457. }
  1458. // rmsDriverCapacity.setCarrierId(new BigDecimal(carrierId));
  1459. result +=rmsDriverCapacityMapper.updateByPrimaryKeySelective(rmsDriverCapacity);
  1460. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  1461. omstruckOrder.setOrderId(orderId);
  1462. omstruckOrder.setOrderPlanId(new BigDecimal(dayPlanId));
  1463. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue());
  1464. omstruckOrder.setOrderNumber(orderNumber);
  1465. omstruckOrder.setOrderIssueTime(new Date());
  1466. omstruckOrder.setOrderStatus(new BigDecimal(3));
  1467. omstruckOrder.setInsertTime(new Date());
  1468. omstruckOrder.setUpdateTime(new Date());
  1469. omstruckOrder.setInsertUsername("admin");
  1470. omstruckOrder.setUpdateUsername("admin");
  1471. omstruckOrder.setInsertUpdateRemark("无");
  1472. omstruckOrder.setDeleted(new BigDecimal(0));
  1473. omstruckOrder.setOrderType(new BigDecimal(orderType));
  1474. omstruckOrder.setLineId(new BigDecimal(lineId));
  1475. result +=omstruckOrderMapper.insertSelective(omstruckOrder);
  1476. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1477. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1478. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1479. omstruckOrderMaterial.setOrderId(orderId);
  1480. omstruckOrderMaterial.setMaterialId(materialId);
  1481. omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
  1482. omstruckOrderMaterial.setInsertTime(new Date());
  1483. omstruckOrderMaterial.setUpdateTime(new Date());
  1484. omstruckOrderMaterial.setInsertUsername("admin");
  1485. omstruckOrderMaterial.setUpdateUsername("admin");
  1486. omstruckOrderMaterial.setInsertUpdateRemark("无");
  1487. // omstruckOrderMaterial.setOrderMaterialWeight(materialWeight);
  1488. result +=omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  1489. }
  1490. return result;
  1491. }
  1492. /**
  1493. * 查询运单下的所有信息
  1494. * @param capacityNumber
  1495. * @return
  1496. */
  1497. @Override
  1498. public List<Map<String, Object>> getAllOrderMessage(String capacityNumber) {
  1499. List<Map<String, Object>> resultList;
  1500. // 判断是走采购,销售还是内转
  1501. resultList = omstruckOrderMapper.getResultListByCapacity(capacityNumber);
  1502. // 如果不是内转则取下面的orderId和orderType
  1503. if (resultList == null || resultList.size() == 0) {
  1504. //通过车牌号匹配运力ID
  1505. BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum(capacityNumber);
  1506. BigDecimal driverCapacityId = omstruckOrderMapper.getDriverCapacityId(capacityId);
  1507. resultList = omstruckOrderMapper.getResultList(driverCapacityId);
  1508. }
  1509. // 循环遍历出每一条运输订单的信息
  1510. for (Map<String, Object> map : resultList) {
  1511. BigDecimal orderId = (BigDecimal) map.get("orderId");
  1512. BigDecimal orderType = (BigDecimal) map.get("orderType");
  1513. // 查询物资信息
  1514. List<Map<String, Object>> materialMapList = omstruckOrderMapper.getMaterialMes(orderId);
  1515. String allMaterialName = "";
  1516. String allMaterialNumber = "";
  1517. String allMaterialWeight = "";
  1518. String allMaterialSpecificationModel = "";
  1519. // 对物资信息进行处理
  1520. if (materialMapList == null && materialMapList.size() == 0) {
  1521. } else {
  1522. for (Map<String, Object> materialMap : materialMapList) {
  1523. String materialName = (String) materialMap.get("materialName");
  1524. BigDecimal materialNumber = (BigDecimal) materialMap.get("materialNumber");
  1525. BigDecimal materialWeight = (BigDecimal) materialMap.get("materialWeight");
  1526. String materialModel = (String) materialMap.get("materialModel");
  1527. String materialSpecification = (String) materialMap.get("materialSpecification");
  1528. if (materialName != null) {
  1529. allMaterialName += materialName + "/";
  1530. }
  1531. if (materialNumber != null) {
  1532. allMaterialNumber += materialNumber.toString() + "/";
  1533. }
  1534. if (materialWeight != null) {
  1535. allMaterialWeight += materialWeight.toString() + "/";
  1536. }
  1537. if (materialSpecification != null || materialModel != null) {
  1538. allMaterialSpecificationModel += materialSpecification + materialModel + "/";
  1539. }
  1540. }
  1541. String subMaterialName = "";
  1542. String subMaterialNumber = "";
  1543. String subMaterialWeight = "";
  1544. String subMaterialSpecificationModel = "";
  1545. if (allMaterialName.length() >= 2) {
  1546. subMaterialName = allMaterialName.substring(0, allMaterialName.length() - 2);
  1547. }
  1548. if (allMaterialName.length() < 2) {
  1549. subMaterialName = allMaterialName;
  1550. }
  1551. if (allMaterialNumber.length() >= 2) {
  1552. subMaterialNumber = allMaterialNumber.substring(0, allMaterialNumber.length() - 1);
  1553. }
  1554. if (allMaterialNumber.length() < 2) {
  1555. subMaterialNumber = allMaterialNumber;
  1556. }
  1557. if (allMaterialWeight.length() >= 2) {
  1558. subMaterialWeight = allMaterialWeight.substring(0, allMaterialWeight.length() - 1);
  1559. }
  1560. if (allMaterialWeight.length() < 2) {
  1561. subMaterialWeight = allMaterialWeight;
  1562. }
  1563. if (allMaterialSpecificationModel.length() >= 2) {
  1564. subMaterialSpecificationModel = allMaterialSpecificationModel.substring(0, allMaterialSpecificationModel.length() - 2);
  1565. }
  1566. if (allMaterialSpecificationModel.length() < 2) {
  1567. subMaterialSpecificationModel = allMaterialSpecificationModel;
  1568. }
  1569. map.put("allMaterialName", subMaterialName);
  1570. map.put("allMaterialNumber", subMaterialNumber);
  1571. map.put("allMaterialWeight", subMaterialWeight);
  1572. map.put("allMaterialSpecificationModel", subMaterialSpecificationModel);
  1573. }
  1574. Map<String, Object> orderMap = null;
  1575. int intValue = orderType.intValue();
  1576. if (intValue == 1 || intValue == 2 || intValue == 3) {
  1577. orderMap = omstruckOrderMapper.getSaleMap(orderId);
  1578. }
  1579. if (intValue == 4) {
  1580. orderMap = omstruckOrderMapper.getSteelInwardMap(orderId);
  1581. }
  1582. if (intValue == 5 || intValue == 6 || intValue == 7 || intValue == 8) {
  1583. orderMap = omstruckOrderMapper.getPurchaseMap(orderId);
  1584. }
  1585. if (intValue == 9 || intValue == 10 || intValue == 11) {
  1586. orderMap = omstruckOrderMapper.getInwardMap(orderId);
  1587. }
  1588. map.putAll(orderMap);
  1589. }
  1590. return resultList;
  1591. }
  1592. /**
  1593. * 司机确认订单
  1594. * orderNumber 运输订单号
  1595. * @param map
  1596. * @return
  1597. */
  1598. @Override
  1599. public int driverConfirmation(Map<String, Object> map) {
  1600. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1601. BigDecimal orderId;
  1602. //通过运输订单号查询运输订单Id
  1603. if(map.get("orderId") == null){
  1604. orderId = new BigDecimal(omstruckOrderMapper.getOrderIdByOrderNumber((String) map.get("orderNumber")));
  1605. }else {
  1606. orderId = DataChange.dataToBigDecimal(map.get("orderId"));
  1607. }
  1608. Map<String, Object> seqMap = omstruckOrderMapper.getMaxLineSeqByOrderId(orderId);
  1609. if(seqMap != null){
  1610. //如果没有到最后一步之前 不允许确认
  1611. BigDecimal orderLineSequence = DataChange.dataToBigDecimal(seqMap.get("orderLineSequence"));
  1612. BigDecimal maxSegmentSqe = DataChange.dataToBigDecimal(seqMap.get("segmentSqe"));
  1613. int i = maxSegmentSqe.intValue() - orderLineSequence.intValue();
  1614. if( i != 1){
  1615. return 0;
  1616. }
  1617. }
  1618. omstruckOrder.setOrderId(orderId);
  1619. //设置司机确认订单
  1620. omstruckOrder.setDriverConfirmation(new BigDecimal(1));
  1621. omstruckOrder.setUpdateTime(new Date());
  1622. return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1623. }
  1624. /**
  1625. * 查询订单是否确认
  1626. * @Author TXF
  1627. * @Date 2022/1/4 23:36
  1628. * @param map {orderId}
  1629. * @return
  1630. **/
  1631. public boolean getDriverConfirmation(Map<String, Object> map){
  1632. Integer driverConfirmation = omstruckOrderMapper.getDriverConfirmation(DataChange.dataToBigDecimal(map.get("orderId")));
  1633. if(driverConfirmation == null){
  1634. return true;
  1635. }else {
  1636. return false;
  1637. }
  1638. }
  1639. /**
  1640. * 通过运输订单号查询订单信息给司机
  1641. * @param map
  1642. * @return
  1643. */
  1644. public Map<String, Object> getMessageToApp(Map<String, Object> map){
  1645. BigDecimal orderId = DataChange.dataToBigDecimal(map.get("orderId"));
  1646. Integer orderType;
  1647. //获取订单类型
  1648. if(map.get("orderType") == null){
  1649. orderType = omstruckOrderMapper.getOrderTypeByOrderNumber(orderId);
  1650. }else {
  1651. orderType = DataChange.dataToBigDecimal(map.get("orderType")).intValue();
  1652. }
  1653. Map<String, Object> mesMap = new HashMap<>();
  1654. switch (orderType){
  1655. case 1:
  1656. case 2:
  1657. mesMap = omstruckOrderMapper.getXSOrderMessageToApp(map);
  1658. break;
  1659. case 3:
  1660. case 4:
  1661. mesMap = omstruckOrderMapper.getFYJHOrderMessageToApp(map);
  1662. break;
  1663. case 5:
  1664. case 6:
  1665. case 7:
  1666. case 8:
  1667. case 17:
  1668. case 18:
  1669. mesMap = omstruckOrderMapper.getCGOrderMessageToApp(map);
  1670. break;
  1671. case 9:
  1672. case 10:
  1673. case 11:
  1674. mesMap = omstruckOrderMapper.getNZOrderMessageToApp(map);
  1675. break;
  1676. case 12:
  1677. case 13:
  1678. case 15:
  1679. case 16:
  1680. mesMap = omstruckOrderMapper.getSporadicOrder(map);
  1681. }
  1682. mesMap.put("materialMesList", omstruckOrderMapper.getMaterialMes(orderId));
  1683. return mesMap;
  1684. }
  1685. /**
  1686. * 通过车牌号查询所有已下发未接收的订单信息
  1687. * @param map
  1688. * @return
  1689. */
  1690. public List<Map<String, Object>> getAllOrderMessagesByCapacityNum(Map<String, Object> map){
  1691. String capacityNumber = (String) map.get("capacityNumber");
  1692. //通过车牌号查询所有未下发的订单ID
  1693. List<Map<String, Object>> orderMesList = omstruckOrderMapper.getOrderIdListByCapacityNumber(capacityNumber);
  1694. List<Map<String, Object>> mesMapList = new ArrayList<>();
  1695. for (Map<String, Object> orderMesMap: orderMesList) {
  1696. //如果订单类型为2 则判断订单发货日期是否为当日 如果不是当日则不给显示
  1697. if(DataChange.dataToBigDecimal(orderMesMap.get("orderType")).intValue() == 2){
  1698. Integer judgeDate = omstruckOrderSeparateMapper.getDeliveryDate(orderMesMap.get("orderId"));
  1699. if(judgeDate == null){ // 数据为空则不是当天的订单
  1700. continue;
  1701. }
  1702. }
  1703. Map<String, Object> mesMap = getMessageToApp(orderMesMap);
  1704. mesMapList.add(mesMap);
  1705. }
  1706. return mesMapList;
  1707. }
  1708. /**
  1709. * 新增进口矿
  1710. * @param mapValue
  1711. * @return
  1712. */
  1713. @Transactional
  1714. @Override
  1715. public int addInputOrder(Map<String, Object> mapValue) {
  1716. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  1717. BigDecimal purchaseOrderId = new BigDecimal((Integer) mapValue.get("purchaseOrderId"));
  1718. BigDecimal materialId = new BigDecimal((Integer) mapValue.get("materialId"));
  1719. BigDecimal orderType = new BigDecimal((Integer) mapValue.get("orderType"));
  1720. BigDecimal lineId = new BigDecimal((Integer) mapValue.get("lineId"));
  1721. Integer planId = (Integer) mapValue.get("planId");
  1722. int result = 0;
  1723. for (Map<String, Object> map : mapList) {
  1724. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1725. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1726. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  1727. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1728. String capacityNumber = (String)map.get("capacityNumber");
  1729. BigDecimal capacityId = omstruckOrderMapper.getCapacityId(capacityNumber);
  1730. BigDecimal materialWeight = DataChange.dataToBigDecimal(map.get("orderMaterialWeight"));
  1731. String unloadPoint = (String) map.get("unloadPoint");
  1732. BigDecimal unloadPointId = omstruckOrderMapper.getUnloadPointId(unloadPoint);
  1733. // Date orderEntryTime = new Date((Long) map.get("orderEntryTime"));
  1734. // 运输订单
  1735. omstruckOrder.setOrderId(orderId);
  1736. omstruckOrder.setOrderNumber(DataChange.generateEightDigitsNumber("WYSDD",orderId.intValue()));
  1737. omstruckOrder.setCapacityId(capacityId);
  1738. omstruckOrder.setOrderPlanId(purchaseOrderId);
  1739. omstruckOrder.setOrderType(orderType);
  1740. omstruckOrder.setOrderStatus(new BigDecimal(3));
  1741. omstruckOrder.setLineId(lineId);
  1742. omstruckOrder.setUnloadPointId(unloadPointId);
  1743. // omstruckOrder.setOrderEntryTime(orderEntryTime);
  1744. omstruckOrder.setInsertTime(new Date());
  1745. omstruckOrder.setInsertUsername("admin");
  1746. // 运输订单子表
  1747. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1748. omstruckOrderMaterial.setOrderId(orderId);
  1749. omstruckOrderMaterial.setOrderMaterialWeight(materialWeight);
  1750. omstruckOrderMaterial.setMaterialId(materialId);
  1751. omstruckOrderMaterial.setInsertTime(new Date());
  1752. omstruckOrderMaterial.setInsertUsername("admin");
  1753. result += omstruckOrderMapper.insertSelective(omstruckOrder);
  1754. result += omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  1755. //新增实绩总表关联订单 feign 调用truckTms
  1756. map.put("orderId", omstruckOrder.getOrderId());
  1757. tmsTruckFeign.addTotalResult(map);
  1758. //更改运输计划子表 增加已分配重量 减少未分配重量 feign调用ams
  1759. map.put("planId",planId);
  1760. amsFeign.updateMaterial(map);
  1761. }
  1762. return result;
  1763. }
  1764. }