OmstruckOrderServiceImpl.java 102 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313
  1. package com.steerinfo.dil.service.impl;
  2. import com.alibaba.druid.support.json.JSONUtils;
  3. import com.baomidou.mybatisplus.extension.api.R;
  4. import com.steerinfo.dil.feign.AmsFeign;
  5. import com.steerinfo.dil.feign.IMFeign;
  6. import com.steerinfo.dil.feign.JoinFeign;
  7. import com.steerinfo.dil.feign.TmsTruckFeign;
  8. import com.steerinfo.dil.mapper.*;
  9. import com.steerinfo.dil.model.*;
  10. import com.steerinfo.dil.service.IOmstruckOrderService;
  11. import com.steerinfo.dil.util.DataChange;
  12. import com.steerinfo.dil.util.EASCapacityTestUtil;
  13. import com.steerinfo.dil.util.getRequestUtils;
  14. import io.swagger.models.auth.In;
  15. import org.junit.Test;
  16. import org.springframework.beans.factory.annotation.Autowired;
  17. import org.springframework.stereotype.Service;
  18. import org.springframework.transaction.annotation.Transactional;
  19. import java.math.BigDecimal;
  20. import java.text.SimpleDateFormat;
  21. import java.util.*;
  22. /**
  23. * OmstruckOrder服务实现:
  24. *
  25. * @author generator
  26. * @version 1.0-SNAPSHORT 2021-10-15 09:37
  27. * 类描述
  28. * 修订历史:
  29. * 日期:2021-10-15
  30. * 作者:generator
  31. * 参考:
  32. * 描述:OmstruckOrder服务实现
  33. * @Copyright 湖南视拓信息技术股份有限公司. All rights reserved.
  34. * @see null
  35. */
  36. @Service(value = "omstruckOrderService")
  37. public class OmstruckOrderServiceImpl implements IOmstruckOrderService {
  38. @Autowired
  39. private OmstruckOrderMapper omstruckOrderMapper;
  40. @Autowired
  41. private OmstruckOrderMaterialMapper omstruckOrderMaterialMapper;
  42. @Autowired
  43. private AmsFeign amsFeign;
  44. @Autowired
  45. private TmsTruckFeign tmsTruckFeign;
  46. @Autowired
  47. private IMFeign imFeign;
  48. @Autowired
  49. RmsCapacityMapper rmsCapacityMapper;
  50. @Autowired
  51. RmsDriverCapacityMapper rmsDriverCapacityMapper;
  52. @Autowired
  53. AmstruckInwardPlanMapper amstruckInwardPlanMapper;
  54. @Autowired
  55. OmstruckOrderSeparateServiceImpl omstruckOrderSeparateService;
  56. @Autowired
  57. OmstruckOrderSeparateMapper omstruckOrderSeparateMapper;
  58. @Autowired
  59. private ZJXLUtilServiceImpl zjxlUtilService;
  60. @Autowired
  61. private ZJXLUtilMapper zjxlUtilMapper;
  62. @Autowired
  63. JoinFeign joinFeign;
  64. private static final String judgeInwardFactory = "化工园区铁专线内转";
  65. /**
  66. * 用于远程调用运输订单新增
  67. *
  68. * @param omstruckOrder
  69. * @return
  70. */
  71. @Override
  72. public int insertSelective(OmstruckOrder omstruckOrder) {
  73. return omstruckOrderMapper.insertSelective(omstruckOrder);
  74. }
  75. /**
  76. * 查询所有运输订单
  77. * 获取已下发的运输订单 用于websocket
  78. *
  79. * @param map
  80. * @return
  81. */
  82. @Override
  83. public List<Map<String, Object>> getAllTruckOrder(Map<String, Object> map) {
  84. return omstruckOrderMapper.getAllTruckOrder(map);
  85. }
  86. /**
  87. * 新增运输订单
  88. *
  89. * @param map
  90. * @return
  91. */
  92. @Override
  93. @Transactional
  94. public int addPurOrder(Map<String, Object> map) {
  95. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  96. int i = 0;
  97. switch (orderType.intValue()) {
  98. case 1:
  99. case 2:
  100. case 3:
  101. case 4:
  102. i = dispatchSteelOrder(map);//新增焦炭发运计划订单
  103. break;
  104. case 5:
  105. case 6:
  106. case 7:
  107. case 8:
  108. case 17:
  109. case 18:
  110. i = addCGPurOrders(map);
  111. break;
  112. // case 8:
  113. // i = addCGPurOrder(map); //新增采购运输订单
  114. // break;
  115. case 9:
  116. break;
  117. case 10:
  118. break;
  119. case 11:
  120. }
  121. return i;
  122. }
  123. /**
  124. * 新增采购其他订单
  125. * @return
  126. */
  127. public int addCGPurOrders(Map<String, Object> map){
  128. //从map中获取司机运力列表
  129. List<Map<String, Object>> driverCapacityIdList = (List<Map<String, Object>>) map.get("driverCapacityIdList");
  130. BigDecimal purchaseOrderId = DataChange.dataToBigDecimal(map.get("purchaseOrderId"));
  131. //是否一车多趟 有则更新采购订单
  132. Object isMoreTrips = map.get("isMoreTrips");
  133. if(isMoreTrips != null){
  134. boolean trips = (boolean) isMoreTrips;
  135. if(trips){
  136. //更新采购订单为一车多趟类型
  137. omstruckOrderSeparateMapper.updateAPOisMoreTrips(DataChange.dataToBigDecimal(map.get("purchaseOrderId")));
  138. }
  139. }
  140. //物资ID
  141. Object materialId = map.get("materialId");
  142. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  143. //预计进厂时间
  144. Date orderEntryTime = null;
  145. if(map.get("orderEntryTime") != null){
  146. try {
  147. orderEntryTime = new Date((long) map.get("orderEntryTime"));
  148. } catch (Exception e) {
  149. System.out.println("预估进厂日期转换失败");
  150. }
  151. }
  152. int count = 0;
  153. for (Map<String, Object> capacityMap : driverCapacityIdList) {
  154. map.put("carrierId",capacityMap.get("carrierId"));
  155. map.put("priceId",capacityMap.get("priceId"));
  156. //添加运输订单
  157. OmstruckOrder omstruckOrder = generateOmsTruckOrder(map);
  158. if (omstruckOrder.equals("")){
  159. return -1;
  160. }
  161. omstruckOrder.setOrderPlanId(purchaseOrderId);
  162. omstruckOrder.setCapacityId(DataChange.dataToBigDecimal(capacityMap.get("capacityId"))); //添加运力ID
  163. omstruckOrder.setOrderEntryTime(orderEntryTime);
  164. count += omstruckOrderMapper.insertSelective(omstruckOrder);
  165. BigDecimal orderId = omstruckOrder.getOrderId();
  166. //添加运输订单子表
  167. capacityMap.put("materialId", materialId);
  168. capacityMap.put("orderType", orderType);
  169. addOrderMaterial(capacityMap,orderId);
  170. //添加总实绩
  171. capacityMap.put("orderId", orderId);
  172. tmsTruckFeign.addTotalResult(capacityMap);
  173. }
  174. return count;
  175. }
  176. /**
  177. * 新增采购进口矿运输订单订单
  178. *
  179. * @param map
  180. * @return
  181. */
  182. @Transactional
  183. public int addCGPurOrder(Map<String, Object> map) {
  184. //生成运输订单号和主键
  185. OmstruckOrder omstruckOrder = generateOmsTruckOrder(map);
  186. Object orderEntryTime = map.get("orderEntryTime");
  187. if (orderEntryTime != null) {
  188. omstruckOrder.setOrderEntryTime(new Date((long) orderEntryTime)); //新增预计进厂时间
  189. }
  190. if (map.get("orderMaterialWeight") != null) {
  191. amsFeign.updateMaterial(map); //更改运输计划子表 增加已分配重量 减少未分配重量 feign调用ams
  192. }
  193. //添加运力Id
  194. BigDecimal capacityId = DataChange.dataToBigDecimal(map.get("capacityId"));
  195. omstruckOrder.setCapacityId(capacityId);
  196. //新增运输订单
  197. omstruckOrderMapper.insertSelective(omstruckOrder);
  198. //更新运力状态为待运输:2
  199. // map.put("capacityStatus", 2);
  200. // omstruckOrderMapper.updateCapacityByCarIdOrNum(map);
  201. //新增运输订单子表
  202. addOrderMaterial(map, omstruckOrder.getOrderId());
  203. //新增实绩总表关联订单 feign 调用truckTms
  204. map.put("orderId", omstruckOrder.getOrderId());
  205. tmsTruckFeign.addTotalResult(map);
  206. return 1;
  207. }
  208. /**
  209. * 生成运输订单实体类
  210. */
  211. public OmstruckOrder generateOmsTruckOrder(Map<String, Object> map) {
  212. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  213. OmstruckOrder omstruckOrder = new OmstruckOrder();
  214. String orgCode =(String) map.get("orgCode");
  215. String userId = (String) map.get("userId");
  216. if (orgCode!=null){
  217. omstruckOrder.setOptionerCode(orgCode);
  218. }
  219. //生成订单主键Id
  220. BigDecimal maxId = omstruckOrderMapper.selectMaxId();
  221. omstruckOrder.setOrderId(maxId);
  222. //生成运输订单号
  223. int id = maxId.intValue();
  224. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", id);
  225. omstruckOrder.setOrderNumber(orderNumber);
  226. //设置线路
  227. omstruckOrder.setLineId(DataChange.dataToBigDecimal(map.get("lineId")));
  228. //添加当前订单所属承运商Id与运价ID
  229. Object carrierId = map.get("carrierId");
  230. Object priceId = map.get("priceId");
  231. if(carrierId != null) omstruckOrder.setCarrierId(DataChange.dataToBigDecimal(carrierId));
  232. if (priceId != null) omstruckOrder.setPriceId(DataChange.dataToBigDecimal(priceId));
  233. //运单状态 刚分配默认为未下发
  234. omstruckOrder.setOrderStatus(new BigDecimal(3));
  235. switch (orderType.intValue()) {
  236. case 1:
  237. omstruckOrder.setOrderPlanId(DataChange.dataToBigDecimal(map.get("saleOrderMaterialId")));
  238. break;
  239. case 2:
  240. case 3:
  241. omstruckOrder.setOrderPlanId(DataChange.dataToBigDecimal(map.get("dayPlanId")));
  242. break;
  243. case 4:
  244. break;
  245. case 5:
  246. case 6:
  247. case 7:
  248. case 8:
  249. case 17:
  250. case 18:
  251. if (map.get("loadNameId")!=null) omstruckOrder.setDriverConfirmation(DataChange.dataToBigDecimal(map.get("loadNameId")));//装货点
  252. if (map.get("purchaseOrderId") != null) omstruckOrder.setOrderPlanId(DataChange.dataToBigDecimal(map.get("purchaseOrderId"))); //订单ID
  253. if (map.get("unloadPointId") != null) omstruckOrder.setUnloadPointId(DataChange.dataToBigDecimal(map.get("unloadPointId")));// 添加卸货点
  254. break;
  255. case 9:
  256. break;
  257. case 10:
  258. break;
  259. case 11:
  260. }
  261. //添加订单类型
  262. omstruckOrder.setOrderType(orderType);
  263. omstruckOrder.setInsertUsername(userId);
  264. omstruckOrder.setInsertTime(new Date());
  265. return omstruckOrder;
  266. }
  267. /**
  268. * 新增订单子表
  269. *
  270. * @param map
  271. * @param
  272. */
  273. public void addOrderMaterial(Map<String, Object> map, BigDecimal orderId) {
  274. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  275. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  276. switch (orderType.intValue()) {
  277. case 1:
  278. //获得销售物资id
  279. //生成子表主键
  280. omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
  281. Integer saleOrderMaterialId = (Integer) map.get("saleOrderMaterialId");
  282. //通过车序号id查找物资件数和物资重量
  283. Map<String, Object> map1 = omstruckOrderMapper.selectTheoreticalWeightAndMaterialNumber(saleOrderMaterialId);
  284. BigDecimal materialNumber = (BigDecimal) map1.get("materialNumber");
  285. BigDecimal weight = (BigDecimal) map1.get("weight");
  286. //设置物资理重和物资件数
  287. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(weight));
  288. omstruckOrderMaterial.setOrderMaterialNumber(DataChange.dataToBigDecimal(materialNumber));
  289. //通过销售订单车序号id查找物资id
  290. List<Map<String, Object>> materialList = omstruckOrderMapper.selectMaterialIdBysaleOrderMaterialId(saleOrderMaterialId);
  291. for (int i = 0; i < materialList.size(); i++) {
  292. Map<String, Object> map2 = materialList.get(i);
  293. BigDecimal materialId = (BigDecimal) map2.get("materialId");
  294. omstruckOrderMaterial.setMaterialId(materialId);
  295. }
  296. //执行新增
  297. omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  298. break;
  299. case 2:
  300. case 3:
  301. //获取发运计划id
  302. //生成子表主键
  303. omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
  304. Integer dayPlanId = (Integer) map.get("dayPlanId");
  305. //设置订单id
  306. omstruckOrderMaterial.setOrderId(orderId);
  307. //根据发运计划id查找物资id和物资重量
  308. map = omstruckOrderMapper.selectMaterialIdAndWeightByDayPlanId(dayPlanId);
  309. BigDecimal materialId = (BigDecimal) map.get("materialId");
  310. BigDecimal materialWeight = (BigDecimal) map.get("materialWeight");
  311. //设置物资id
  312. omstruckOrderMaterial.setMaterialId(DataChange.dataToBigDecimal(materialId));
  313. //设置物资重量
  314. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(materialWeight));
  315. omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  316. break;
  317. case 4:
  318. break;
  319. case 5:
  320. case 6:
  321. case 7:
  322. case 8:
  323. case 17:
  324. case 18:
  325. //生成子表主键
  326. omstruckOrderMaterial.setOrderMaterialId(omstruckOrderMaterialMapper.selectMaxId());
  327. omstruckOrderMaterial.setMaterialId(DataChange.dataToBigDecimal(map.get("materialId")));
  328. omstruckOrderMaterial.setOrderId(orderId);
  329. Object orderMaterialWeight = map.get("orderMaterialWeight");
  330. if (orderMaterialWeight != null) {
  331. if (orderMaterialWeight.toString().length() != 0) {
  332. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(map.get("orderMaterialWeight")));
  333. }
  334. }
  335. Object orderMaterialNumber = map.get("orderMaterialNumber");
  336. if(orderMaterialNumber != null ) {
  337. if (orderMaterialNumber.toString().length() != 0) {
  338. omstruckOrderMaterial.setOrderMaterialNumber(DataChange.dataToBigDecimal(map.get("orderMaterialNumber")));
  339. }
  340. }
  341. omstruckOrderMaterial.setInsertUsername("admin");
  342. omstruckOrderMaterial.setInsertTime(new Date());
  343. omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  344. break;
  345. case 9:
  346. break;
  347. case 10:
  348. break;
  349. case 11:
  350. }
  351. }
  352. /**
  353. * 修改运输订单 和订单子表
  354. *
  355. * @param map
  356. * @return
  357. */
  358. @Override
  359. @Transactional
  360. public int updateOrder(Map<String, Object> map) {
  361. //修改运输订单运力ID
  362. OmstruckOrder omstruckOrder = new OmstruckOrder();
  363. BigDecimal orderId = DataChange.dataToBigDecimal(map.get("orderId"));
  364. BigDecimal orderType;
  365. if(map.get("orderType") == null){
  366. //查询订单类型
  367. orderType = new BigDecimal(omstruckOrderMapper.getOrderTypeByOrderNumber(orderId));
  368. }else{
  369. orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  370. }
  371. omstruckOrder.setOrderId(orderId);
  372. if (map.get("unloadPointId") != null) {
  373. omstruckOrder.setUnloadPointId(DataChange.dataToBigDecimal(map.get("unloadPointId")));
  374. }
  375. if (map.get("capacityId") != null) {
  376. omstruckOrder.setCapacityId(DataChange.dataToBigDecimal(map.get("capacityId")));
  377. }
  378. if(map.get("orderEntryTime") != null){
  379. omstruckOrder.setOrderEntryTime(new Date((long) map.get("orderEntryTime")));
  380. }
  381. if(map.get("unloadPointId")!=null || map.get("capacityId") != null || map.get("orderEntryTime") != null){
  382. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  383. }
  384. switch (orderType.intValue()) {
  385. case 1:
  386. break;
  387. case 2:
  388. break;
  389. case 3:
  390. break;
  391. case 4:
  392. break;
  393. case 5:
  394. case 6:
  395. case 7:
  396. case 8:
  397. case 17:
  398. case 18:
  399. //修改运输订单子表物资重量
  400. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  401. //添加子表主键 通过订单ID查询出子表主键
  402. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.getOrderMaterialIdByOrderId(DataChange.dataToBigDecimal(map.get("orderId")));
  403. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  404. if (map.get("orderMaterialWeight") != null) {
  405. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(map.get("orderMaterialWeight")));
  406. if(orderType.intValue() == 8)
  407. amsFeign.updateMaterial(map);//修改运输计划子表 已分配未分配重量
  408. }
  409. if(map.get("orderMaterialNumber") != null) {
  410. omstruckOrderMaterial.setOrderMaterialNumber(DataChange.dataToBigDecimal(map.get("orderMaterialNumber")));
  411. }
  412. if (map.get("materialId") != null) {
  413. omstruckOrderMaterial.setMaterialId(DataChange.dataToBigDecimal(map.get("materialId")));
  414. }
  415. if(map.get("orderMaterialWeight") != null || map.get("orderMaterialNumber") != null || map.get("materialId") != null){
  416. omstruckOrderMaterialMapper.updateByPrimaryKeySelective(omstruckOrderMaterial);
  417. }
  418. break;
  419. case 9:
  420. break;
  421. case 10:
  422. break;
  423. case 11:
  424. }
  425. return 1;
  426. }
  427. /**
  428. * 逻辑删除未下发订单
  429. *
  430. * @param map
  431. * @return
  432. */
  433. @Override
  434. @Transactional
  435. public int deleteOrder(Map<String, Object> map) {
  436. OmstruckOrder omstruckOrder = new OmstruckOrder();
  437. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(map.get("orderId")));
  438. //设置状态为逻辑删除:7
  439. omstruckOrder.setOrderStatus(new BigDecimal(7));
  440. int i = omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  441. //若是传来物资重量则修改已分配未分配重量
  442. if (map.get("orderMaterialWeight") != null) {
  443. amsFeign.updateMaterial(map); //feign调用
  444. }
  445. // //通过车牌号修改运输状态为空闲中 0
  446. // String capacityNumber = (String) map.get("capacityNumber");
  447. // HashMap<String, Object> changeStatusMap = new HashMap<>();
  448. // changeStatusMap.put("capacityNumber", capacityNumber);
  449. // changeStatusMap.put("capacityStatus", 0);
  450. // int i1 = omstruckOrderMapper.updateCapacityByCarIdOrNum(changeStatusMap);
  451. return i;
  452. }
  453. /**
  454. * 运单派发、下发
  455. * 运单ID
  456. *
  457. * @param mapValue
  458. * @return
  459. */
  460. @Override
  461. @Transactional
  462. public int dispatchOrder(Map<String, Object> mapValue) {
  463. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  464. int result = 0;
  465. for (Map<String, Object> map : mapList) {
  466. Integer orderId = (Integer) map.get("orderId");
  467. OmstruckOrder omstruckOrder = new OmstruckOrder();
  468. omstruckOrder.setOrderId(new BigDecimal(orderId));
  469. //生成订单下发时间 修改订单表
  470. omstruckOrder.setOrderIssueTime(new Date());
  471. //设置状态为已下发:4
  472. omstruckOrder.setOrderStatus(new BigDecimal(4));
  473. //下发 推送数据给 websocket
  474. pushMesToWebsocket(map);
  475. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  476. }
  477. return result;
  478. }
  479. /**
  480. * 发送消息到 websocket 推送消息
  481. * orderId 订单Id
  482. * @return
  483. */
  484. public void pushMesToWebsocket(Map<String, Object> map) {
  485. Map<String, Object> mesMap = omstruckOrderMapper.pushMesToWebsocket(map);
  486. //添加消息实体
  487. HashMap<Object, Object> mapp = new HashMap<>();
  488. mapp.put("messageType", 3);
  489. mapp.put("sendPerson", "system");
  490. mapp.put("receivePerson", mesMap.get("capacityNumber"));
  491. mapp.put("messageContent", mesMap);
  492. mapp.put("createTime", new Date());
  493. ArrayList<Object> list = new ArrayList<>();
  494. list.add(mapp);
  495. //调用websocket接口推送
  496. HashMap<Object, Object> sendMap = new HashMap<>();
  497. //将消息实体放入list中存到map中
  498. sendMap.put("messages", list);
  499. String s = imFeign.sendToUser(sendMap);
  500. System.out.println(s);
  501. }
  502. @Override//判断一车多单是否还有订单,如果又就再推送消息给他
  503. public void pushMessageToDriver(Map<String, Object> mapValue) {
  504. Map<String,Object> mapAddOrder =omstruckOrderMapper.getSporadicOrdermapAddOrder(new BigDecimal(mapValue.get("orderId").toString()));
  505. BigDecimal sporadicOrderTimes = DataChange.dataToBigDecimal(mapAddOrder.get("sporadicOrderTimes"));
  506. BigDecimal sporadicOrderId = DataChange.dataToBigDecimal(mapAddOrder.get("sporadicOrderId"));
  507. BigDecimal transStatus = DataChange.dataToBigDecimal(mapAddOrder.get("transStatus"));
  508. BigDecimal orderId = DataChange.dataToBigDecimal(mapValue.get("orderId"));
  509. //获取运输订单类型
  510. Integer orderType = omstruckOrderMapper.getOrderTypeByOrderId(orderId);
  511. BigDecimal capacityId = DataChange.dataToBigDecimal(mapAddOrder.get("capacityId"));
  512. Map<String, Object> addMapSporadicOrder = new HashMap<>();
  513. addMapSporadicOrder.put("sporadicOrderId",sporadicOrderId);
  514. addMapSporadicOrder.put("orderId",orderId);
  515. List<Map<String,Object>> mapList = new ArrayList<>();
  516. Map<String,Object> map=new HashMap<>();
  517. map.put("capacityId",capacityId);
  518. mapList.add(map);
  519. addMapSporadicOrder.put("mapList",mapList);
  520. switch (orderType) {
  521. case 13:
  522. case 19:
  523. case 12:
  524. case 14:
  525. if (transStatus.intValue()==1){
  526. amsFeign.addSporadicOrderTimes(addMapSporadicOrder);
  527. }
  528. break;
  529. //普通零星
  530. case 15:
  531. case 16:
  532. if (sporadicOrderTimes.intValue() > 0) {
  533. //mapvalue需要orderId,零星订单id,maplist放一个运力id
  534. amsFeign.addSporadicOrderTimes(addMapSporadicOrder);
  535. }
  536. }
  537. }
  538. //撤销订单
  539. @Transactional(rollbackFor = Exception.class)
  540. @Override
  541. public int undoOrder(Map<String, Object> map) throws Exception{
  542. int result=0;
  543. BigDecimal orderId =DataChange.dataToBigDecimal(map.get("orderId"));
  544. Map<String, Object> mesMap = omstruckOrderSeparateMapper.getOrderMesByOrderId(orderId);
  545. if(DataChange.dataToBigDecimal(mesMap.get("orderType")).intValue() == 1||DataChange.dataToBigDecimal(mesMap.get("orderType")).intValue() == 4){
  546. throw new Exception("钢材订单不允许撤销!");
  547. }
  548. if(DataChange.dataToBigDecimal(mesMap.get("lineSqe")).intValue() >= 1){
  549. throw new Exception("撤单失败");
  550. }
  551. //获取运输订单号
  552. String orderNumber = (String) mesMap.get("orderNumber");
  553. //撤销订单的同时删除计量数据
  554. String url = "http://172.16.33.122:44325/api/logistics/delEntrust";
  555. String sendUrl = url + "?orderNumber=" + orderNumber;
  556. String jsonData = getRequestUtils.doGet(sendUrl);
  557. System.out.println(jsonData);
  558. BigDecimal orderPlanId = DataChange.dataToBigDecimal(mesMap.get("orderPlanId"));
  559. int orderType = DataChange.dataToBigDecimal(mesMap.get("orderType")).intValue();
  560. BigDecimal resultTotalId = DataChange.dataToBigDecimal(mesMap.get("resultTotalId"));
  561. OmstruckOrder omstruckOrder = new OmstruckOrder();
  562. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
  563. omstruckOrder.setOrderStatus(new BigDecimal(8));
  564. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  565. String dateStr = sdf.format(new Date());
  566. omstruckOrder.setInsertUpdateRemark(map.get("capacityNumber") + "司机撤销订单将订单删除," + "撤销时间:" + dateStr + "撤销时路段顺序号为:" + mesMap.get("lineSqe"));
  567. //讲路段顺序号设为空,适应进厂以后扫码
  568. omstruckOrder.setOrderLineSequence(new BigDecimal(0));
  569. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  570. if(orderType == 11 ){
  571. result += omstruckOrderMapper.deleteLoadResult(resultTotalId);
  572. return result ;
  573. }
  574. if (orderType==21){
  575. //根据总实绩id查找计时实绩id
  576. int timeTaskByTotalId = omstruckOrderMapper.getTimeTaskByTotalId(resultTotalId);
  577. if (timeTaskByTotalId!=0)
  578. {
  579. throw new Exception("已经计时开始");
  580. }else {
  581. result += omstruckOrderMapper.deleteTimeTaskByTotalId(resultTotalId);
  582. }
  583. }
  584. if(orderType == 1||orderType == 4){
  585. //取消订阅车辆
  586. String remark = String.valueOf(mesMap.get("insertUpdateRemark"));
  587. if("电子围栏订阅成功".equals(remark)){
  588. String capacityNumber = String.valueOf(map.get("capacityNumber"));
  589. map.put("capacityNumber", capacityNumber + "_2");
  590. int i = zjxlUtilService.cancelSubsCapacity(map, 1);
  591. if(i == 1){
  592. zjxlUtilMapper.cancelSubCapacity(capacityNumber);
  593. }
  594. }
  595. }
  596. //通过总实绩ID删除所有已经生成的实绩
  597. result += omstruckOrderMapper.deleteEnResult(resultTotalId);
  598. result += omstruckOrderMapper.deleteWeightResult(resultTotalId);
  599. result += omstruckOrderMapper.deleteUnloadResult(resultTotalId);
  600. result += omstruckOrderMapper.deleteLoadResult(resultTotalId);
  601. result += omstruckOrderMapper.deleteLeaveResult(resultTotalId);
  602. if(orderType == 12 || orderType == 13 || orderType == 14 || orderType == 19){
  603. Map<String, Object> sporadicOrderTimes = omstruckOrderMapper.getSporadicOrderTimes(orderId);
  604. BigDecimal orderTimes =(BigDecimal)sporadicOrderTimes.get("orderTimes");
  605. BigDecimal transTimes = (BigDecimal)sporadicOrderTimes.get("transTimes");
  606. //更新趟次
  607. omstruckOrderSeparateService.updateTimes(orderPlanId,orderTimes.intValue()+1);
  608. //更新状态
  609. omstruckOrderSeparateMapper.updateSporadicStatus(orderPlanId,1);
  610. //更新已运输趟次
  611. if (transTimes.intValue()>0) {
  612. omstruckOrderSeparateMapper.updateTranTimes(orderPlanId, transTimes.intValue() - 1);
  613. }
  614. }
  615. System.out.println(map.get("capacityNumber") + "司机撤销订单将订单删除" + "撤销时间:" + dateStr + "撤销订单号为:" + orderId);
  616. return result;
  617. }
  618. //修改运力
  619. @Override
  620. public int updateCapacityId(Map<String,Object> map) {
  621. int result=0;
  622. OmstruckOrder omstruckOrder=new OmstruckOrder();
  623. BigDecimal orderId =DataChange.dataToBigDecimal(map.get("orderId"));
  624. BigDecimal capacityId =DataChange.dataToBigDecimal(map.get("capacityId"));
  625. BigDecimal lineSeq = omstruckOrderMapper.getLineSeq(orderId);
  626. if (lineSeq == null || lineSeq.intValue() == 0) {
  627. omstruckOrder.setOrderId(orderId);
  628. omstruckOrder.setCapacityId(capacityId);
  629. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  630. }
  631. return result;
  632. }
  633. //采购内转派单
  634. @Override
  635. public int addPurInwardOrder(Map<String, Object> mapValue) {
  636. int result = 0;
  637. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  638. BigDecimal planId = DataChange.dataToBigDecimal(mapValue.get("planId"));
  639. BigDecimal lineId = DataChange.dataToBigDecimal(mapValue.get("lineId"));
  640. BigDecimal orderType = DataChange.dataToBigDecimal(mapValue.get("orderType"));
  641. String orgCode =(String) mapValue.get("orgCode");
  642. AmstruckInwardPlan amstruckInwardPlan = amstruckInwardPlanMapper.selectByPrimaryKey(planId);
  643. amstruckInwardPlan.setPlanStatus(new BigDecimal(3));
  644. result += amstruckInwardPlanMapper.updateByPrimaryKeySelective(amstruckInwardPlan);
  645. BigDecimal materialId = omstruckOrderMapper.getInwardMaterial(planId);
  646. for (Map<String,Object> orderMap : mapList) {
  647. OmstruckOrder omstruckOrder = new OmstruckOrder();
  648. String capacityNumber = (String)orderMap.get("capacityNumber");
  649. Map<String,Object> capacityMap = new HashMap<>();
  650. capacityMap.put("capacityNumber",capacityNumber);
  651. List<RmsCapacity> rmsCapacities = rmsCapacityMapper.selectByParameters(capacityMap);
  652. RmsCapacity rmsCapacity = rmsCapacities.get(0);
  653. result +=rmsCapacityMapper.updateByPrimaryKeySelective(rmsCapacity);
  654. BigDecimal capacityId = rmsCapacity.getCapacityId();
  655. capacityMap.clear();
  656. capacityMap.put("capacityId",capacityId);
  657. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  658. // 添加总实绩
  659. Map<String,Object> orderIdMap = new HashMap<>();
  660. orderIdMap.put("orderId",orderId);
  661. tmsTruckFeign.addTotalResult(orderIdMap);
  662. omstruckOrder.setOrderId(orderId);
  663. omstruckOrder.setOrderPlanId(planId);
  664. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue());
  665. omstruckOrder.setOrderNumber(orderNumber);
  666. omstruckOrder.setOrderIssueTime(new Date());
  667. omstruckOrder.setOrderStatus(new BigDecimal(4));
  668. omstruckOrder.setCapacityId(capacityId);
  669. omstruckOrder.setInsertTime(new Date());
  670. omstruckOrder.setUpdateTime(new Date());
  671. omstruckOrder.setInsertUsername("admin");
  672. omstruckOrder.setUpdateUsername("admin");
  673. if(orgCode!=null) {
  674. omstruckOrder.setOptionerCode(orgCode);
  675. }
  676. omstruckOrder.setInsertUpdateRemark("无");
  677. omstruckOrder.setDeleted(new BigDecimal(0));
  678. omstruckOrder.setOrderType(orderType);
  679. if(lineId != null){
  680. omstruckOrder.setLineId(lineId);
  681. }
  682. result +=omstruckOrderMapper.insertSelective(omstruckOrder);
  683. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  684. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  685. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  686. omstruckOrderMaterial.setOrderId(orderId);
  687. omstruckOrderMaterial.setMaterialId(materialId);
  688. omstruckOrderMaterial.setInsertTime(new Date());
  689. omstruckOrderMaterial.setUpdateTime(new Date());
  690. omstruckOrderMaterial.setInsertUsername("admin");
  691. omstruckOrderMaterial.setUpdateUsername("admin");
  692. omstruckOrderMaterial.setInsertUpdateRemark("无");
  693. result +=omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  694. }
  695. return result;
  696. }
  697. @Override
  698. public List<Map<String, Object>> getPurInwardOrderList(Map<String, Object> mapValue) {
  699. List<Map<String,Object>> mapList = omstruckOrderMapper.getPurInwardOrderList(mapValue);
  700. return mapList;
  701. }
  702. @Override
  703. public int addPurInwardOrder1(BigDecimal orderId) {
  704. //根据运输订单id查询信息
  705. Map<String,Object>map = omstruckOrderMapper.selectOrderMap(orderId);
  706. BigDecimal planId = DataChange.dataToBigDecimal(map.get("planId"));
  707. BigDecimal lineId = DataChange.dataToBigDecimal(map.get("lineId"));
  708. BigDecimal orderType = DataChange.dataToBigDecimal(map.get("orderType"));
  709. BigDecimal capacityId = DataChange.dataToBigDecimal(map.get("capacityId"));
  710. BigDecimal materialId = DataChange.dataToBigDecimal(map.get("materialId"));
  711. int result = 0;
  712. OmstruckOrder omstruckOrder = new OmstruckOrder();
  713. BigDecimal orderIds = omstruckOrderMapper.selectMaxId();
  714. // 添加总实绩
  715. Map<String,Object> orderIdMap = new HashMap<>();
  716. orderIdMap.put("orderId",orderIds);
  717. tmsTruckFeign.addTotalResult(orderIdMap);
  718. omstruckOrder.setOrderId(orderIds);
  719. omstruckOrder.setOrderPlanId(planId);
  720. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderIds.intValue());
  721. omstruckOrder.setOrderNumber(orderNumber);
  722. omstruckOrder.setOrderIssueTime(new Date());
  723. omstruckOrder.setOrderStatus(new BigDecimal(4));
  724. omstruckOrder.setCapacityId(capacityId);
  725. omstruckOrder.setInsertTime(new Date());
  726. omstruckOrder.setUpdateTime(new Date());
  727. omstruckOrder.setInsertUsername("admin");
  728. omstruckOrder.setUpdateUsername("admin");
  729. omstruckOrder.setInsertUpdateRemark("无");
  730. omstruckOrder.setDeleted(new BigDecimal(0));
  731. omstruckOrder.setOrderType(orderType);
  732. omstruckOrder.setLineId(lineId);
  733. result +=omstruckOrderMapper.insertSelective(omstruckOrder);
  734. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  735. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  736. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  737. omstruckOrderMaterial.setOrderId(orderIds);
  738. omstruckOrderMaterial.setMaterialId(materialId);
  739. omstruckOrderMaterial.setInsertTime(new Date());
  740. omstruckOrderMaterial.setUpdateTime(new Date());
  741. omstruckOrderMaterial.setInsertUsername("admin");
  742. omstruckOrderMaterial.setUpdateUsername("admin");
  743. omstruckOrderMaterial.setInsertUpdateRemark("无");
  744. result +=omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  745. return result;
  746. }
  747. @Override
  748. public int refuseCtrlZ(Map<String, Object> map) {
  749. return omstruckOrderMapper.refuseCtrlZ(map);
  750. }
  751. //获取运输订单对应的车牌以及车辆状态
  752. @Override
  753. public List<Map<String, Object>> getTransportOrder(Map<String, Object> mapValue) {
  754. return omstruckOrderMapper.getTransportOrder(mapValue);
  755. }
  756. /**
  757. * 出库信息
  758. * @param mapValue
  759. * @return
  760. */
  761. @Override
  762. public List<Map<String, Object>> getWarehouseMes(Map<String, Object> mapValue) {
  763. return omstruckOrderMapper.getWarehouseMes(mapValue);
  764. }
  765. /**
  766. * 销售物流,下发订单
  767. *
  768. * @param map
  769. * @return
  770. */
  771. @Override
  772. public int dispatchOrderForSale(Map<String, Object> map) {
  773. OmstruckOrder omstruckOrder = new OmstruckOrder();
  774. Integer orderId = (Integer) map.get("orderId");
  775. Integer orderType = (Integer) map.get("orderType");
  776. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
  777. if (orderType == 2 || orderType == 3) {
  778. Integer loadId = (Integer) map.get("LoadId");
  779. if (loadId != null) {
  780. //根据运输订单id查找装车实绩id
  781. omstruckOrder.setUnloadPointId(DataChange.dataToBigDecimal(loadId));
  782. }
  783. }
  784. //设置下发状态
  785. omstruckOrder.setOrderIssueTime(new Date());
  786. omstruckOrder.setOrderStatus(new BigDecimal(4));
  787. // pushMesToWebsocket(map); //下发 推送数据给 websocket
  788. return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  789. }
  790. @Override
  791. public List<Map<String, Object>> selectWaterSlagForOrder(Map<String, Object> map) {
  792. return omstruckOrderMapper.selectWaterSlagForOrder(map);
  793. }
  794. @Override
  795. public List<Map<String, Object>> selectCokeRailPlanForOrder(Map<String, Object> map) {
  796. return omstruckOrderMapper.selectCokeRailPlanForOrder(map);
  797. }
  798. /**
  799. * 司机接单、拒绝 0:拒绝 1:接收
  800. * 需要接收参数 主键Id 与 接收拒绝操作码
  801. *
  802. * @param map
  803. * @return
  804. */
  805. @Override
  806. @Transactional
  807. public int driverReceiveOrRefuse(Map<String, Object> map) throws RuntimeException {
  808. BigDecimal orderId = DataChange.dataToBigDecimal(map.get("orderId"));
  809. OmstruckOrder omstruckOrder = new OmstruckOrder();
  810. if((Integer) map.get("orderReceiveStatus") == 1) {
  811. List<Integer> orderIdList = omstruckOrderMapper.getReceiveOrderIdListByCapacityNum((String) map.get("capacityNumber"));
  812. if (orderIdList.size() > 0) {
  813. throw new RuntimeException("已有接收的订单!");
  814. }
  815. omstruckOrder.setOrderStatus(new BigDecimal(5)); //5 :已接收
  816. //通过订单ID查询信息
  817. Map<String, Object> orderMessage = omstruckOrderSeparateMapper.getOrderMessagge(orderId);
  818. int orderStatus = DataChange.dataToBigDecimal(orderMessage.get("orderStatus")).intValue();
  819. if(orderStatus == 5 || orderStatus == 6) {
  820. throw new RuntimeException("订单已被接收或已被拒绝!");
  821. }
  822. int orderType = DataChange.dataToBigDecimal(orderMessage.get("orderType")).intValue();
  823. if(orderType == 1){
  824. //订阅车辆 查询车牌号
  825. String capacityNumber = omstruckOrderMapper.getCapacityNumberByCapacityId(DataChange.dataToBigDecimal(orderMessage.get("capacityId")));
  826. Map<String, Object> subMap = new HashMap<>();
  827. subMap.put("capacityNumber", capacityNumber + "_2");
  828. String s = zjxlUtilService.subsCapacity(subMap, 1);
  829. if(!"成功".equals(s.substring(s.length() - 2))){
  830. System.out.println("车辆订阅失败:" + capacityNumber);
  831. omstruckOrder.setInsertUpdateRemark("电子围栏订阅失败");
  832. }else{
  833. omstruckOrder.setInsertUpdateRemark("电子围栏订阅成功");
  834. zjxlUtilMapper.insertSubCapacity(zjxlUtilMapper.getSubCapacityMaxId(), capacityNumber, DataChange.dataToBigDecimal(orderMessage.get("resultTotalId")));
  835. }
  836. }
  837. if(orderType == 11 || orderType == 15 || orderType == 16){
  838. //判断是否为化专线厂区内转
  839. Map<String, Object> inwardLine = omstruckOrderMapper.isInwardLine(orderId);
  840. String rangeValue = (String) inwardLine.get("rangeValue");
  841. if (rangeValue!=null&&rangeValue.contains(judgeInwardFactory)) {
  842. //设置进厂厂区为达兴能源
  843. orderMessage.put("factory",2);
  844. }else {
  845. //设置进厂厂区为达兴能源
  846. orderMessage.put("factory",1);
  847. }
  848. orderMessage.put("orderId", orderId);
  849. orderMessage.put("asd", 1);
  850. Map<String, Object> mcMap = tmsTruckFeign.sendMeasureCommission(orderMessage);
  851. if (!"200".equals(mcMap.get("code"))) {
  852. throw new RuntimeException("委托发送失败!");
  853. }
  854. }else if(orderType!=21&&orderType!=25){
  855. //添加各个实绩
  856. omstruckOrderSeparateService.addAllSonResult(orderMessage);
  857. }
  858. //判断订单是否是一车多单
  859. if (orderType ==12 || orderType ==13 || orderType ==14 || orderType ==19) {
  860. //通过订单查询趟次
  861. Map<String, Object> sporadicOrderTimes = omstruckOrderMapper.getSporadicOrderTimes(orderId);
  862. BigDecimal orderTimes = DataChange.dataToBigDecimal(sporadicOrderTimes.get("orderTimes"));
  863. //通过订单id查询已运输趟次
  864. BigDecimal transTimes=DataChange.dataToBigDecimal(sporadicOrderTimes.get("transTimes"));
  865. //生成作业实绩之后、更改订单数量
  866. if (orderMessage.containsKey("orderPlanId") && orderTimes.intValue() > 0) {
  867. int state =0;
  868. //如果运输趟次,接完之后将变成0
  869. if(orderTimes.intValue() == 1){
  870. //修改零星订单运输状态
  871. state +=omstruckOrderSeparateMapper.updateSporadicStatus(DataChange.dataToBigDecimal(orderMessage.get("orderPlanId")),0);
  872. }
  873. state+=omstruckOrderSeparateService.updateTimes(new BigDecimal(orderMessage.get("orderPlanId").toString()), orderTimes.intValue() - 1);
  874. //接收订单以后已运输订单趟次+1
  875. state+=omstruckOrderSeparateMapper.updateTranTimes(DataChange.dataToBigDecimal(orderMessage.get("orderPlanId").toString()),transTimes.intValue()+1);
  876. }
  877. }
  878. } else { //其他状态都视为 拒绝接单
  879. omstruckOrder.setOrderStatus(new BigDecimal(6));
  880. //添加拒绝原因
  881. omstruckOrder.setInsertUpdateRemark((String) map.get("insertUpdateRemark"));
  882. }
  883. omstruckOrder.setOrderId(orderId);
  884. //生成接收/拒绝时间
  885. Date receiveTime = new Date();
  886. omstruckOrder.setOrderReceiveRefuseTime(receiveTime);
  887. //计算司机从派单到操作时长
  888. Date issueTime = omstruckOrderMapper.getInsertTimeById(orderId.intValue());
  889. long time = receiveTime.getTime() - issueTime.getTime();
  890. long min = time / (1000 * 60);
  891. omstruckOrder.setOrderCommunicationDuration(new BigDecimal(min));
  892. return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  893. }
  894. //根据承运商获取销售订单
  895. @Override
  896. public List<Map<String, Object>> selectSaleOrderForCarrier(Map<String, Object> map) {
  897. Integer carrierId = (Integer) map.get("carrierId");
  898. List<Map<String, Object>> maps = omstruckOrderMapper.selectSaleMaterialIdByCarrierId(carrierId);
  899. List<Map<String, Object>> list = null;
  900. for (Map<String, Object> map1 : maps) {
  901. BigDecimal saleOrderMaterialId = (BigDecimal) map1.get("saleOrderMaterialId");
  902. list = omstruckOrderMapper.selectSaleBySaleOrderMaterialId(saleOrderMaterialId.intValue());
  903. }
  904. return list;
  905. }
  906. /**
  907. * 查询已接收的焦炭发运计划
  908. *
  909. * @param
  910. * @return
  911. */
  912. @Override
  913. public List<Map<String, Object>> selectCokeDayPlanAndRecived(Map<String, Object> map) {
  914. return omstruckOrderMapper.selectCokeDayPlanAndRecived(map);
  915. }
  916. /**
  917. * 查询已接收的水渣发运计划
  918. *
  919. * @param
  920. * @return
  921. */
  922. @Override
  923. public List<Map<String, Object>> selectWaterSlagDayPlanAndRecived(Integer carrierId) {
  924. return omstruckOrderMapper.selectWaterSlagDayPlanAndRecived(carrierId);
  925. }
  926. /**
  927. * 司机接单推送数据
  928. * 车牌号
  929. * @param
  930. * @return
  931. */
  932. @Override
  933. public List<Map<String, Object>> sendMesToDriver(Map<String, Object> map) {
  934. //通过车牌号匹配运力ID
  935. BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum((String) map.get("capacityNumber"));
  936. if (capacityId == null) {
  937. return null;
  938. }
  939. map.put("capacityId", capacityId);
  940. //通过运力Id匹配 已下发的运输订单
  941. List<Map<String, Object>> truckOrderByCapacityNum;
  942. if ((Integer) map.get("orderType") == 1 || (Integer) map.get("orderType") == 2||(Integer) map.get("orderType") == 4) {
  943. truckOrderByCapacityNum = omstruckOrderMapper.getSaleTruckOrderByCapacityNum(map);
  944. } else {
  945. truckOrderByCapacityNum = omstruckOrderMapper.getTruckOrderByCapacityNum(map);
  946. }
  947. return truckOrderByCapacityNum;
  948. }
  949. /**
  950. * 得到作业时间和地点
  951. *
  952. * @param orderId
  953. * @return
  954. */
  955. @Override
  956. public List<Map<String, Object>> selectPlaceAndTime(BigDecimal orderId) {
  957. List<Map<String, Object>> mapList = omstruckOrderMapper.selectPlaceAndTime(orderId);
  958. Map<String, Object> map = mapList.get(0);
  959. String entryGatepost = (String) map.get("entryGatepost");
  960. Date entryTime = (Date) map.get("entryTime");
  961. String entryResult = entryGatepost + "/" + entryTime;
  962. String grossCalculate = (String) map.get("grossCalculate");
  963. Date grossTime = (Date) map.get("grossTime");
  964. String grossResult = grossCalculate + "/" + grossTime;
  965. String unloadWarhouse = (String) map.get("unloadWarhouse");
  966. Date unloadTime = (Date) map.get("unloadTime");
  967. String unloadResult = unloadWarhouse + "/" + unloadTime;
  968. String tareCalculate = (String) map.get("tareCalculate");
  969. Date tareTime = (Date) map.get("tareTime");
  970. String tareResult = tareCalculate + "/" + tareTime;
  971. String leaveGatepost = (String) map.get("leaveGatepost");
  972. Date outTime = (Date) map.get("outTime");
  973. String leaveResult = leaveGatepost + "/" + outTime;
  974. String receiptWarhouse = (String) map.get("receiptWarhouse");
  975. Date receiptTime = (Date) map.get("receiptTime");
  976. String receiptResult = receiptWarhouse + "/" + receiptTime;
  977. List<Map<String, Object>> resultList = new ArrayList<>();
  978. Map<String, Object> map1 = new HashMap<>();
  979. map1.put("title", "进厂门岗/时间");
  980. map1.put("desc", entryResult);
  981. resultList.add(map1);
  982. Map<String, Object> map2 = new HashMap<>();
  983. map2.put("title", "毛重衡器/时间");
  984. map2.put("desc", grossResult);
  985. resultList.add(map2);
  986. Map<String, Object> map3 = new HashMap<>();
  987. map3.put("title", "卸货地点/时间");
  988. map3.put("desc", unloadResult);
  989. resultList.add(map3);
  990. Map<String, Object> map4 = new HashMap<>();
  991. map4.put("title", "皮重衡器/时间");
  992. map4.put("desc", tareResult);
  993. resultList.add(map4);
  994. Map<String, Object> map5 = new HashMap<>();
  995. map5.put("title", "出厂门岗/时间");
  996. map5.put("desc", leaveResult);
  997. resultList.add(map5);
  998. if ((Integer) map.get("orderType") == 1) {
  999. Map<String, Object> map6 = new HashMap<>();
  1000. map5.put("title", "异地库/时间");
  1001. map5.put("desc", receiptResult);
  1002. resultList.add(map6);
  1003. }
  1004. Map<String, Object> map7 = new HashMap<>();
  1005. BigDecimal orderLineSequence = (BigDecimal) map.get("orderLineSequence");
  1006. map7.put("orderLineSequence", orderLineSequence);
  1007. resultList.add(map7);
  1008. return resultList;
  1009. }
  1010. /**
  1011. * 查询已下发未接受的销售订单信息
  1012. *
  1013. * @param orderType
  1014. * @return
  1015. */
  1016. @Override
  1017. public List<Map<String, Object>> getOrderUnReceive(BigDecimal orderType) {
  1018. return omstruckOrderMapper.getOrderUnReceive(orderType);
  1019. }
  1020. /**
  1021. * 查询已下发已接受的销售订单信息
  1022. *
  1023. * @param orderType
  1024. * @return
  1025. */
  1026. @Override
  1027. public List<Map<String, Object>> getOrderReceived(BigDecimal orderType) {
  1028. return omstruckOrderMapper.getOrderReceived(orderType);
  1029. }
  1030. /**
  1031. * 分派钢材销售订单
  1032. *
  1033. * @param map
  1034. * @return
  1035. */
  1036. @Override
  1037. public int dispatchSteelOrder(Map<String, Object> map) {
  1038. //新增运单(销售钢材订单)
  1039. //生成运输订单号和主键以及绑定运力
  1040. OmstruckOrder omstruckOrder = generateOmsTruckOrder(map);
  1041. //设置线路 遗留问题,设置为进门门岗
  1042. omstruckOrder.setLineId(new BigDecimal(1));
  1043. //新增运输订单
  1044. omstruckOrderMapper.insertSelective(omstruckOrder);
  1045. //更新运力状态为待运输:2
  1046. // map.put("capacityStatus", 2);
  1047. // omstruckOrderMapper.updateCapacityById(map);
  1048. //新增运输订单子表
  1049. addOrderMaterial(map, omstruckOrder.getOrderId());
  1050. //新增实绩总表关联订单 feign调用
  1051. map.put("orderId", omstruckOrder.getOrderId());
  1052. tmsTruckFeign.addTotalResult(map);
  1053. return 6;
  1054. }
  1055. //设置销售订单下发状态
  1056. @Override
  1057. public int IssueSteelOrder(Map<String, Object> map) {
  1058. //设置下发状态
  1059. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1060. Integer orderId = (Integer) map.get("orderId");
  1061. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
  1062. omstruckOrder.setOrderIssueTime(new Date());
  1063. //设置下发状态值:4
  1064. omstruckOrder.setOrderStatus(new BigDecimal(4));
  1065. return 2;
  1066. }
  1067. //销售模块查看所有订单
  1068. @Override
  1069. public List<Map<String, Object>> selectAllOrderForSale(Map<String, Object> map) {
  1070. //map获取承运商
  1071. Integer carrierId = (Integer) map.get("carrierId");
  1072. Integer saleOrderMaterialId = (Integer) map.get("saleOrderMaterialId");
  1073. List<Map<String, Object>> maps = omstruckOrderMapper.selectSaleMaterialIdByCarrierId(carrierId);
  1074. //根据车序号查找运输订单
  1075. List<Map<String, Object>> mapList = null;
  1076. List<Map<String, Object>> maps1 = new ArrayList<>();
  1077. //判断获取的车序号是否属于承运商
  1078. for (Map<String, Object> map1 : maps) {
  1079. BigDecimal compareNum = DataChange.dataToBigDecimal(map1.get("saleOrderMaterialId"));
  1080. if (compareNum.intValue() == saleOrderMaterialId) {
  1081. mapList = omstruckOrderMapper.selectAllOrderForSale(map);
  1082. for (int i = 0; i < mapList.size(); i++) {
  1083. Map<String, Object> map2 = mapList.get(i);
  1084. if (map2.get("orderId") == null) {
  1085. return maps1;
  1086. }
  1087. }
  1088. return mapList;
  1089. }
  1090. }
  1091. return maps1;
  1092. }
  1093. @Override
  1094. public List<Map<String, Object>> selectTransportOrderForSale(Map<String, Object> map) {
  1095. List<Map<String, Object>> mapList = omstruckOrderMapper.selectTransportOrderForSale(map);
  1096. int count = 1;
  1097. for (Map<String, Object> stringObjectMap : mapList) {
  1098. stringObjectMap.put("ROW_ID",count);
  1099. count ++;
  1100. }
  1101. return mapList;
  1102. }
  1103. @Override
  1104. public List<Map<String, Object>> selectTransportOrderForSale1(Map<String, Object> map) {
  1105. List<Map<String, Object>> mapList = omstruckOrderMapper.selectTransportOrderForSale1(map);
  1106. int count = 1;
  1107. for (Map<String, Object> stringObjectMap : mapList) {
  1108. stringObjectMap.put("ROW_ID",count);
  1109. count ++;
  1110. }
  1111. return mapList;
  1112. }
  1113. @Override
  1114. public List<Map<String, Object>> selectSteelSaleForCarrier(Map<String, Object> map) {
  1115. return omstruckOrderMapper.selectSteelSaleForCarrier(map);
  1116. }
  1117. //根据销售订单id查找信息
  1118. @Override
  1119. public List<Map<String, Object>> selectInfoBySaleOrderId(Integer saleOrderId) {
  1120. return omstruckOrderMapper.selectInfoBySaleOrderId(saleOrderId);
  1121. }
  1122. @Override
  1123. public List<Map<String, Object>> selectCokeRailPlan(Map<String, Object> map) {
  1124. return omstruckOrderMapper.selectCokeRailPlan(map);
  1125. }
  1126. @Override
  1127. public List<Map<String, Object>> selectInfoByDayPlanId(Map<String, Object> map) {
  1128. return omstruckOrderMapper.selectInfoByDayPlanId(map);
  1129. }
  1130. /**
  1131. * 查找司机排班表信息
  1132. *
  1133. * @param map
  1134. * @return
  1135. */
  1136. @Override
  1137. public List<Map<String, Object>> selectCapacityAndDriver(Map<String, Object> map) {
  1138. return omstruckOrderMapper.selectCapacityAndDriver(map);
  1139. }
  1140. /**
  1141. * 查询所有运力信息
  1142. *
  1143. * @return
  1144. */
  1145. @Override
  1146. public List<Map<String, Object>> getAllCapacity(Map<String, Object> map) {
  1147. return omstruckOrderMapper.getAllCapacity(map);
  1148. }
  1149. /**
  1150. * 用于后台展示司机接单未接单数据
  1151. *
  1152. * @param map
  1153. * @return
  1154. */
  1155. @Override
  1156. public List<Map<String, Object>> getReceiveRefuseOrder(Map<String, Object> map) {
  1157. return omstruckOrderMapper.getTruckOrderByCapacityNum(map);
  1158. }
  1159. /**
  1160. * 通过运输订单号查询运单所有信息 包含作业路径名称
  1161. *
  1162. * @param map 传运输订单号
  1163. * @return
  1164. */
  1165. @Override
  1166. public List<Map<String, Object>> getOrderMesByOrderNum(Map<String, Object> map) {
  1167. return omstruckOrderMapper.getTruckOrderByCapacityNum(map);
  1168. }
  1169. /**
  1170. * 查询所有司机已拒绝的订单
  1171. * 车牌号
  1172. *
  1173. * @param map
  1174. * @return
  1175. */
  1176. @Override
  1177. public List<Map<String, Object>> getReceiveRefuseOrderByCapacityId(Map<String, Object> map) {
  1178. //通过车牌号查询运力Id
  1179. BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum((String) map.get("capacityNumber"));
  1180. map.put("capacityId", capacityId);
  1181. return omstruckOrderMapper.getReceiveRefuseOrderByCapacityId(map);
  1182. }
  1183. /**
  1184. * 通过运单号查询订单详情
  1185. * 运输订单号
  1186. *
  1187. * @param
  1188. * @return
  1189. */
  1190. @Override
  1191. public List<Map<String, Object>> getOrderByOrderId(BigDecimal orderId) {
  1192. return omstruckOrderMapper.getOrderByOrderId(orderId);
  1193. }
  1194. /**
  1195. * 查看运输派单
  1196. *
  1197. * @param map
  1198. * @return
  1199. */
  1200. @Override
  1201. public List<Map<String, Object>> getTransportDispatch(Map<String, Object> map) {
  1202. return omstruckOrderMapper.getTransportDispatch(map);
  1203. }
  1204. /**
  1205. * 用于更新路段顺序号
  1206. *
  1207. * @param map orderId
  1208. * @return
  1209. */
  1210. public int updateOrderLineSequence(Map<String, Object> map, Integer lineSequence) {
  1211. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1212. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(map.get("orderId")));
  1213. omstruckOrder.setOrderLineSequence(new BigDecimal(lineSequence));
  1214. return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1215. }
  1216. //新增内转运输订单
  1217. @Override
  1218. public int insert(OmstruckOrder omstruckOrder) {
  1219. //生成订单主键Id
  1220. BigDecimal maxId = omstruckOrderMapper.selectMaxId();
  1221. omstruckOrder.setOrderId(maxId);
  1222. //生成运输订单号
  1223. int id = maxId.intValue();
  1224. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", id);
  1225. omstruckOrder.setOrderNumber(orderNumber);
  1226. //设置状态为未下发
  1227. omstruckOrder.setOrderStatus(new BigDecimal(3));
  1228. //设置运输订单的类型
  1229. omstruckOrder.setOrderType(new BigDecimal(11));
  1230. omstruckOrder.setInsertTime(new Date());
  1231. omstruckOrder.setInsertUsername("admin");
  1232. return omstruckOrderMapper.insertSelective(omstruckOrder);
  1233. }
  1234. //通过物资id查询批次表匹配最新的批次,关联最新的采购订单号
  1235. @Override
  1236. public Map<String, Object> selectNewOrderId(Map<String, Object> map) {
  1237. return omstruckOrderMapper.selectNewOrderId(map);
  1238. }
  1239. //app司机接单查询数据
  1240. @Override
  1241. public Map<String, Object> sendMesToDriverApp(Map<String, Object> map) {
  1242. //通过车牌号匹配运力ID
  1243. BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum((String) map.get("capacityNumber"));
  1244. map.put("capacityId", capacityId);
  1245. if (capacityId == null) {
  1246. return null;
  1247. }
  1248. //通过运力Id匹配 已下发的运输订单
  1249. Map<String, Object> truckOrderByCapacityNum = new HashMap<>();
  1250. if ((Integer) map.get("orderType") == 1 || (Integer) map.get("orderType") == 2||(Integer) map.get("orderType") == 4) {
  1251. //查询主干信息
  1252. Map<String, Object> map1 = omstruckOrderMapper.getSaleTruckOrderByCapacityId(map);
  1253. //查询物资信息
  1254. List<Map<String, Object>> mapList = omstruckOrderMapper.getSaleTruckOrderByCapacityNumMaterial(map);
  1255. truckOrderByCapacityNum.put("orderf", map1);
  1256. truckOrderByCapacityNum.put("materialList", mapList);
  1257. }
  1258. return truckOrderByCapacityNum;
  1259. }
  1260. @Override
  1261. public BigDecimal selectCapacityId(BigDecimal carrierId, String capacityNumber) {
  1262. return omstruckOrderMapper.selectCapacityId(carrierId, capacityNumber);
  1263. }
  1264. /**
  1265. * 车牌号下拉
  1266. *
  1267. * @return
  1268. */
  1269. @Override
  1270. public List<Map<String, Object>> getDriverCapacity() {
  1271. return omstruckOrderMapper.getDriverCapacity();
  1272. }
  1273. /**
  1274. * 派单信息
  1275. *
  1276. * @param dispatchId
  1277. * @return
  1278. */
  1279. @Override
  1280. public Map<String, Object> getTruckNoDispatchMap(Integer dispatchId) {
  1281. Map<String, Object> map = omstruckOrderMapper.getTruckNoDispatchMap(new BigDecimal(dispatchId));
  1282. List<BigDecimal> orderIdList = omstruckOrderMapper.getNullOrNotNull(new BigDecimal(dispatchId));
  1283. if (orderIdList != null || orderIdList.size() != 0) {
  1284. return null;
  1285. }
  1286. List<Map<String, Object>> materialMessages = omstruckOrderMapper.getMaterialMessages(new BigDecimal(dispatchId));
  1287. String allMaterialName = "";
  1288. String allMaterialNumber = "";
  1289. String allMaterialTheoreticalWeight = "";
  1290. String allMaterialSpecificationModel = "";
  1291. if (materialMessages == null || materialMessages.size() == 0) {
  1292. } else {
  1293. for (Map<String, Object> materialMap : materialMessages) {
  1294. if (materialMap != null) {
  1295. String materialName = (String) materialMap.get("materialName");
  1296. allMaterialName += materialName + "/";
  1297. String materialTheoreticalWeight = materialMap.get("materialTheoreticalWeight").toString();
  1298. if (materialTheoreticalWeight != null) {
  1299. allMaterialTheoreticalWeight += materialTheoreticalWeight + "/";
  1300. }
  1301. String saleOrderMaterialNumber = materialMap.get("saleOrderMaterialNumber").toString();
  1302. allMaterialNumber += saleOrderMaterialNumber + "/";
  1303. String specificationModel = materialMap.get("specificationModel").toString();
  1304. if (specificationModel != null) {
  1305. allMaterialSpecificationModel += specificationModel + "/";
  1306. }
  1307. }
  1308. }
  1309. String subMaterialName = null;
  1310. String subMaterialNumber = null;
  1311. String subMaterialTheoreticalWeight = null;
  1312. String subMaterialSpecificationModel = null;
  1313. if (allMaterialName.length() >= 2) {
  1314. subMaterialName = allMaterialName.substring(0, allMaterialName.length() - 2);
  1315. }
  1316. if (allMaterialName.length() < 2) {
  1317. subMaterialName = allMaterialName;
  1318. }
  1319. if (allMaterialNumber.length() >= 2) {
  1320. subMaterialNumber = allMaterialNumber.substring(0, allMaterialNumber.length() - 2);
  1321. }
  1322. if (allMaterialNumber.length() < 2) {
  1323. subMaterialNumber = allMaterialNumber;
  1324. }
  1325. if (allMaterialTheoreticalWeight.length() >= 2) {
  1326. subMaterialTheoreticalWeight = allMaterialTheoreticalWeight.substring(0, allMaterialTheoreticalWeight.length() - 2);
  1327. }
  1328. if (allMaterialTheoreticalWeight.length() < 2) {
  1329. subMaterialTheoreticalWeight = allMaterialTheoreticalWeight;
  1330. }
  1331. if (allMaterialSpecificationModel.length() >= 2) {
  1332. subMaterialSpecificationModel = allMaterialSpecificationModel.substring(0, allMaterialSpecificationModel.length() - 2);
  1333. }
  1334. if (allMaterialSpecificationModel.length() < 2) {
  1335. subMaterialSpecificationModel = allMaterialSpecificationModel;
  1336. }
  1337. map.put("allMaterialName", subMaterialName);
  1338. map.put("allMaterialNumber", subMaterialNumber);
  1339. map.put("allMaterialTheoreticalWeight", subMaterialTheoreticalWeight);
  1340. map.put("allMaterialSpecificationModel", subMaterialSpecificationModel);
  1341. }
  1342. return map;
  1343. }
  1344. /**
  1345. * 承运商分派运输订单给司机
  1346. * @param dispatchId
  1347. * @param orderType
  1348. * @param capacityNumber
  1349. * @param carrierId
  1350. * @return
  1351. */
  1352. @Override
  1353. public int addAppTruckOrder(Integer dispatchId, Integer orderType, String capacityNumber, Integer carrierId) {
  1354. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1355. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  1356. Map<String,Object> orderIdMap = new HashMap<>();
  1357. orderIdMap.put("orderId",orderId);
  1358. tmsTruckFeign.addTotalResult(orderIdMap);
  1359. omstruckOrder.setOrderId(orderId);
  1360. BigDecimal saleOrderMaterialId = omstruckOrderMapper.getSaleMaterialId(new BigDecimal(dispatchId));
  1361. omstruckOrder.setOrderPlanId(saleOrderMaterialId);
  1362. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue());
  1363. omstruckOrder.setOrderNumber(orderNumber);
  1364. omstruckOrder.setOrderIssueTime(new Date());
  1365. omstruckOrder.setOrderStatus(new BigDecimal(4));
  1366. omstruckOrder.setInsertTime(new Date());
  1367. omstruckOrder.setUpdateTime(new Date());
  1368. omstruckOrder.setInsertUsername("admin");
  1369. omstruckOrder.setUpdateUsername("admin");
  1370. omstruckOrder.setInsertUpdateRemark("无");
  1371. omstruckOrder.setDeleted(new BigDecimal(0));
  1372. omstruckOrder.setOrderType(new BigDecimal(orderType));
  1373. BigDecimal capacityId = omstruckOrderMapper.getCapacityId(capacityNumber);
  1374. omstruckOrder.setCapacityId(capacityId);
  1375. // omstruckOrder.setCarrierId();
  1376. // BigDecimal driverCapacityId = omstruckOrderMapper.getDriverCapacityId(capacityId);
  1377. // omstruckOrder.setDriverCapacityId(driverCapacityId);
  1378. // RmsDriverCapacity rmsDriverCapacity = rmsDriverCapacityMapper.selectByPrimaryKey(driverCapacityId);
  1379. // rmsDriverCapacity.setCarrierId(new BigDecimal(carrierId));
  1380. // rmsDriverCapacityMapper.updateByPrimaryKeySelective(rmsDriverCapacity);
  1381. List<Map<String, Object>> mapList = omstruckOrderMapper.getMaterialMessages(new BigDecimal(dispatchId));
  1382. if (mapList != null && mapList.size() != 0) {
  1383. for (Map<String, Object> map : mapList) {
  1384. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1385. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1386. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1387. omstruckOrderMaterial.setOrderId(orderId);
  1388. omstruckOrderMaterial.setInsertTime(new Date());
  1389. omstruckOrderMaterial.setUpdateTime(new Date());
  1390. omstruckOrderMaterial.setInsertUsername("admin");
  1391. omstruckOrderMaterial.setUpdateUsername("admin");
  1392. omstruckOrderMaterial.setInsertUpdateRemark("无");
  1393. if (map != null) {
  1394. BigDecimal materialTheoreticalWeight = (BigDecimal) map.get("materialTheoreticalWeight");
  1395. BigDecimal saleOrderMaterialNumber = (BigDecimal) map.get("saleOrderMaterialNumber");
  1396. BigDecimal materialId = (BigDecimal) map.get("materialId");
  1397. omstruckOrderMaterial.setOrderMaterialWeight(materialTheoreticalWeight);
  1398. omstruckOrderMaterial.setMaterialId(materialId);
  1399. omstruckOrderMaterial.setOrderMaterialNumber(saleOrderMaterialNumber);
  1400. }
  1401. omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  1402. }
  1403. }
  1404. // RmsCapacity rmsCapacity = new RmsCapacity();
  1405. // rmsCapacity.setCapacityId(capacityId);
  1406. // rmsCapacity.setCapacityStatus(new BigDecimal(2));
  1407. // rmsCapacityMapper.updateByPrimaryKeySelective(rmsCapacity);
  1408. int result = omstruckOrderMapper.insertSelective(omstruckOrder);
  1409. // 调用websocket推送数据给司机
  1410. pushMesToWebsocket(orderIdMap);
  1411. return result;
  1412. }
  1413. /**
  1414. * 根据运单id关闭订单
  1415. * @param orderId
  1416. * @return
  1417. */
  1418. @Override
  1419. public int closeOmstruckOrder(BigDecimal orderId) throws Exception {
  1420. BigDecimal i = omstruckOrderSeparateMapper.getWeightTask(orderId);
  1421. if(i != null){
  1422. throw new Exception("存在计量实绩,无法删除");
  1423. }
  1424. OmstruckOrder omstruckOrder = omstruckOrderMapper.selectByPrimaryKey(orderId);
  1425. omstruckOrder.setOrderStatus(new BigDecimal(7));
  1426. int result = omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1427. return result;
  1428. }
  1429. /**
  1430. * 查询所有车牌号和司机
  1431. * @param mapValue
  1432. * @return
  1433. */
  1434. @Override
  1435. public List<Map<String, Object>> getCapacityAndDriverList(Map<String, Object> mapValue) {
  1436. return omstruckOrderMapper.getCapacityAndDriver(mapValue);
  1437. }
  1438. @Override
  1439. public int closeOrder(Map<String, Object> map) {
  1440. Integer orderId =(Integer) map.get("orderId");
  1441. OmstruckOrder omstruckOrder=new OmstruckOrder();
  1442. omstruckOrder.setOrderId(DataChange.dataToBigDecimal(orderId));
  1443. omstruckOrder.setOrderStatus(new BigDecimal(8));
  1444. omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1445. return 1;
  1446. }
  1447. /**
  1448. * 分解内转计划(新增运输订单)
  1449. * @param mapValue
  1450. * @return
  1451. */
  1452. @Transactional
  1453. @Override
  1454. public int addInwardOrder(Map<String, Object> mapValue) {
  1455. int result = 0;
  1456. BigDecimal orderType;
  1457. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  1458. BigDecimal planId = DataChange.dataToBigDecimal(mapValue.get("planId")) ;
  1459. BigDecimal lineId = DataChange.dataToBigDecimal(mapValue.get("lineId")) ;
  1460. String orgCode =(String) mapValue.get("orgCode");
  1461. if (orgCode==null||orgCode.equals("")){
  1462. return -1;
  1463. }
  1464. orderType = DataChange.dataToBigDecimal(mapValue.get("orderType"));
  1465. String userId=(String) mapValue.get("userId");
  1466. //根据计划查找需求,如果是计时,就添加新的订单类型
  1467. String inwardType = amstruckInwardPlanMapper.getInwardByPlanId(planId);
  1468. if (inwardType.equals("计时")) {
  1469. mapValue.remove(orderType);
  1470. orderType = BigDecimal.valueOf(21);
  1471. mapValue.put("orderType", orderType);
  1472. }
  1473. if (inwardType.equals("倒库")) {
  1474. mapValue.remove(orderType);
  1475. orderType = BigDecimal.valueOf(25);
  1476. mapValue.put("orderType", orderType);
  1477. }
  1478. Integer carrierId = (Integer) mapValue.get("carrierId");
  1479. AmstruckInwardPlan amstruckInwardPlan = amstruckInwardPlanMapper.selectByPrimaryKey(planId);
  1480. amstruckInwardPlan.setPlanStatus(new BigDecimal(3));
  1481. result += amstruckInwardPlanMapper.updateByPrimaryKeySelective(amstruckInwardPlan);
  1482. for (Map<String,Object> orderMap : mapList) {
  1483. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1484. omstruckOrder.setInsertUsername(userId);
  1485. String capacityNumber = (String)orderMap.get("capacityNumber");
  1486. List<Map<String,Object>>orderMaterialList = (List<Map<String,Object>>)orderMap.get("orderMaterialList");
  1487. Map<String,Object> capacityMap = new HashMap<>();
  1488. capacityMap.put("capacityNumber",capacityNumber);
  1489. List<RmsCapacity> rmsCapacities = rmsCapacityMapper.selectByParameters(capacityMap);
  1490. RmsCapacity rmsCapacity = rmsCapacities.get(0);
  1491. // rmsCapacity.setCapacityStatus(new BigDecimal(2));
  1492. result +=rmsCapacityMapper.updateByPrimaryKeySelective(rmsCapacity);
  1493. BigDecimal capacityId = rmsCapacity.getCapacityId();
  1494. capacityMap.clear();
  1495. capacityMap.put("capacityId",capacityId);
  1496. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  1497. // 添加总实绩
  1498. Map<String,Object> orderIdMap = new HashMap<>();
  1499. orderIdMap.put("orderId",orderId);
  1500. tmsTruckFeign.addTotalResult(orderIdMap);
  1501. omstruckOrder.setOrderId(orderId);
  1502. omstruckOrder.setOrderPlanId(planId);
  1503. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue());
  1504. omstruckOrder.setOrderNumber(orderNumber);
  1505. omstruckOrder.setOrderIssueTime(new Date());
  1506. omstruckOrder.setOrderStatus(new BigDecimal(4));
  1507. omstruckOrder.setOptionerCode(orgCode);
  1508. omstruckOrder.setCapacityId(capacityId);
  1509. omstruckOrder.setInsertTime(new Date());
  1510. omstruckOrder.setUpdateTime(new Date());
  1511. omstruckOrder.setInsertUpdateRemark("无");
  1512. omstruckOrder.setDeleted(new BigDecimal(0));
  1513. omstruckOrder.setOrderType(orderType);
  1514. if(lineId != null){
  1515. omstruckOrder.setLineId(lineId);
  1516. }
  1517. omstruckOrder.setCarrierId(new BigDecimal(carrierId));
  1518. result +=omstruckOrderMapper.insertSelective(omstruckOrder);
  1519. for (Map<String,Object>orderMaterial:orderMaterialList
  1520. ) {
  1521. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1522. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1523. BigDecimal materialId = DataChange.dataToBigDecimal(orderMaterial.get("materialId"));
  1524. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1525. omstruckOrderMaterial.setOrderId(orderId);
  1526. omstruckOrderMaterial.setMaterialId(materialId);
  1527. if (orderMaterial.get("materialCount")!=null) {
  1528. omstruckOrderMaterial.setOrderMaterialNumber(DataChange.dataToBigDecimal(orderMaterial.get("materialCount")));
  1529. }
  1530. omstruckOrderMaterial.setInsertTime(new Date());
  1531. omstruckOrderMaterial.setInsertUsername(userId);
  1532. omstruckOrderMaterial.setUpdateTime(new Date());
  1533. if (orderMaterial.get("materialWeight")!=null) {
  1534. omstruckOrderMaterial.setOrderMaterialWeight(DataChange.dataToBigDecimal(orderMaterial.get("materialWeight")));
  1535. }
  1536. result +=omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  1537. }
  1538. }
  1539. return result;
  1540. }
  1541. /**
  1542. * 查询分解计划
  1543. * @param mapValue
  1544. * @return
  1545. */
  1546. @Override
  1547. public List<Map<String, Object>> getInwardOrderList(Map<String, Object> mapValue) {
  1548. List<Map<String,Object>> mapList = omstruckOrderMapper.getInwardOrderList(mapValue);
  1549. return mapList;
  1550. }
  1551. /**
  1552. * 下发计划
  1553. * @param mapList
  1554. * @return
  1555. */
  1556. @Override
  1557. public int issuePlanOrder(List<Map<String, Object>> mapList) {
  1558. int result = 0;
  1559. for (Map<String,Object> map : mapList) {
  1560. Integer orderId = (Integer) map.get("orderId");
  1561. OmstruckOrder omstruckOrder = omstruckOrderMapper.selectByPrimaryKey(new BigDecimal(orderId));
  1562. omstruckOrder.setOrderStatus(new BigDecimal(4));
  1563. omstruckOrder.setOrderIssueTime(new Date());
  1564. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1565. }
  1566. return result;
  1567. }
  1568. /**
  1569. * 分派计划
  1570. * @param mapList
  1571. * @return
  1572. */
  1573. @Override
  1574. public int apportionInwardOrder(List<Map<String, Object>> mapList) {
  1575. int result = 0;
  1576. for (Map<String,Object> map : mapList) {
  1577. BigDecimal orderId = new BigDecimal((Integer) map.get("orderId"));
  1578. OmstruckOrder omstruckOrder = omstruckOrderMapper.selectByPrimaryKey(orderId);
  1579. omstruckOrder.setOrderIssueTime(new Date());
  1580. omstruckOrder.setOrderStatus(new BigDecimal(4));
  1581. // Map<Object, Object> map9 = new HashMap<>();
  1582. // long data = new Date().getTime();
  1583. // //根据运输订单id查询车牌号
  1584. // String capacityNumber = omstruckOrderMapper.selectCapacityNumber(orderId);
  1585. // BigDecimal orderType = omstruckOrderMapper.selectOrderType(orderId);
  1586. //
  1587. // map9.put("receivePerson",capacityNumber);
  1588. // map9.put("messageType",2);
  1589. // map9.put("snedPerson","system");
  1590. // map9.put("creatTime",data);
  1591. result += omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1592. }
  1593. return result;
  1594. }
  1595. /**
  1596. * 司机APP端查询下发给自己运输订单
  1597. * @param capacityNumber
  1598. * @return
  1599. */
  1600. @Override
  1601. public List<Map<String, Object>> sendOrderToApp(String capacityNumber) {
  1602. //通过车牌号匹配运力ID
  1603. BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum(capacityNumber);
  1604. List<Map<String,Object>> resultList = omstruckOrderMapper.getResultList(capacityId);
  1605. for (Map<String,Object> map : resultList) {
  1606. BigDecimal orderId = (BigDecimal) map.get("orderId");
  1607. BigDecimal orderType = (BigDecimal) map.get("orderType");
  1608. // 查询物资信息
  1609. List<Map<String,Object>> materialMapList = omstruckOrderMapper.getMaterialMes(orderId, null);
  1610. String allMaterialName = "";
  1611. String allMaterialNumber = "";
  1612. String allMaterialWeight = "";
  1613. String allMaterialSpecificationModel = "";
  1614. // 对物资信息进行处理
  1615. if (materialMapList == null && materialMapList.size() == 0) {
  1616. } else {
  1617. for (Map<String,Object> materialMap : materialMapList) {
  1618. String materialName = (String) materialMap.get("materialName");
  1619. BigDecimal materialNumber = (BigDecimal) materialMap.get("materialNumber");
  1620. BigDecimal materialWeight = (BigDecimal) materialMap.get("materialWeight");
  1621. String materialModel = (String) materialMap.get("materialModel");
  1622. String materialSpecification = (String) materialMap.get("materialSpecification");
  1623. if (materialName != null) {
  1624. allMaterialName += materialName + "/";
  1625. }
  1626. if (materialNumber != null) {
  1627. allMaterialNumber += materialNumber.toString() + "/";
  1628. }
  1629. if (materialWeight != null) {
  1630. allMaterialWeight += materialWeight.toString() + "/";
  1631. }
  1632. if (materialSpecification != null || materialModel != null) {
  1633. allMaterialSpecificationModel += materialSpecification + materialModel + "/";
  1634. }
  1635. }
  1636. String subMaterialName = "";
  1637. String subMaterialNumber = "";
  1638. String subMaterialWeight = "";
  1639. String subMaterialSpecificationModel = "";
  1640. if (allMaterialName.length() >= 2) {
  1641. subMaterialName = allMaterialName.substring(0, allMaterialName.length() - 2);
  1642. }
  1643. if (allMaterialName.length() < 2) {
  1644. subMaterialName = allMaterialName;
  1645. }
  1646. if (allMaterialNumber.length() >= 2) {
  1647. subMaterialNumber = allMaterialNumber.substring(0, allMaterialNumber.length() - 1);
  1648. }
  1649. if (allMaterialNumber.length() < 2) {
  1650. subMaterialNumber = allMaterialNumber;
  1651. }
  1652. if (allMaterialWeight.length() >= 2) {
  1653. subMaterialWeight = allMaterialWeight.substring(0, allMaterialWeight.length() - 1);
  1654. }
  1655. if (allMaterialWeight.length() < 2) {
  1656. subMaterialWeight = allMaterialWeight;
  1657. }
  1658. if (allMaterialSpecificationModel.length() >= 2) {
  1659. subMaterialSpecificationModel = allMaterialSpecificationModel.substring(0, allMaterialSpecificationModel.length() - 2);
  1660. }
  1661. if (allMaterialSpecificationModel.length() < 2) {
  1662. subMaterialSpecificationModel = allMaterialSpecificationModel;
  1663. }
  1664. map.put("allMaterialName", subMaterialName);
  1665. map.put("allMaterialNumber", subMaterialNumber);
  1666. map.put("allMaterialWeight", subMaterialWeight);
  1667. map.put("allMaterialSpecificationModel", subMaterialSpecificationModel);
  1668. }
  1669. Map<String,Object> orderMap = null;
  1670. int intValue = orderType.intValue();
  1671. if (intValue == 1 || intValue == 2 || intValue == 3) {
  1672. orderMap = omstruckOrderMapper.getSaleOrderMap(orderId);
  1673. }
  1674. if (intValue == 4) {
  1675. orderMap = omstruckOrderMapper.getSteelInwardOrderMap(orderId);
  1676. }
  1677. if (intValue == 5 || intValue == 6 || intValue == 7 || intValue == 8) {
  1678. orderMap = omstruckOrderMapper.getPurchaseOrderMap(orderId);
  1679. }
  1680. if (intValue == 9 || intValue == 10 || intValue == 11) {
  1681. orderMap = omstruckOrderMapper.getInwardOrderMap(orderId);
  1682. }
  1683. map.putAll(orderMap);
  1684. }
  1685. return resultList;
  1686. }
  1687. //新增内转异地库计划订单(新增运输订单)
  1688. @Override
  1689. public int apportionInwardOffsetOrder(Map<String, Object> mapValue) {
  1690. int result = 0;
  1691. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  1692. String dayPlanId = (String) mapValue.get("dayPlanId");
  1693. Integer lineId = (Integer) mapValue.get("lineId");
  1694. String orderType = (String) mapValue.get("orderType");
  1695. // Integer carrierId = (Integer) mapValue.get("carrierId");
  1696. // AmstruckInwardPlan amstruckInwardPlan = amstruckInwardPlanMapper.selectByPrimaryKey(new BigDecimal(planId));
  1697. // amstruckInwardPlan.setPlanStatus(new BigDecimal(3));
  1698. // result += amstruckInwardPlanMapper.updateByPrimaryKeySelective(amstruckInwardPlan);
  1699. BigDecimal materialId = omstruckOrderMapper.getInwardMaterial(new BigDecimal(dayPlanId));
  1700. for (Map<String,Object> orderMap : mapList) {
  1701. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1702. String capacityNumber = (String)orderMap.get("capacityNumber");
  1703. BigDecimal materialNumber = DataChange.dataToBigDecimal(orderMap.get("materialNumber")) ;
  1704. // BigDecimal materialWeight = DataChange.dataToBigDecimal(orderMap.get("materialWeight"));
  1705. Map<String,Object> capacityMap = new HashMap<>();
  1706. capacityMap.put("capacityNumber",capacityNumber);
  1707. List<RmsCapacity> rmsCapacities = rmsCapacityMapper.selectByParameters(capacityMap);
  1708. RmsCapacity rmsCapacity = rmsCapacities.get(0);
  1709. rmsCapacity.setCapacityStatus(new BigDecimal(2));
  1710. result +=rmsCapacityMapper.updateByPrimaryKeySelective(rmsCapacity);
  1711. BigDecimal capacityId = rmsCapacity.getCapacityId();
  1712. capacityMap.clear();
  1713. capacityMap.put("capacityId",capacityId);
  1714. List<RmsDriverCapacity> rmsDriverCapacities = rmsDriverCapacityMapper.selectByParameters(capacityMap);
  1715. RmsDriverCapacity rmsDriverCapacity = rmsDriverCapacities.get(0);
  1716. BigDecimal dcId = rmsDriverCapacity.getDriverCapacityId();
  1717. if(dcId!=null){
  1718. BigDecimal orderId = omstruckOrderMapper.selectOrderId(dcId);
  1719. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1720. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1721. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1722. omstruckOrderMaterial.setOrderId(orderId);
  1723. omstruckOrderMaterial.setMaterialId(materialId);
  1724. omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
  1725. omstruckOrderMaterial.setInsertTime(new Date());
  1726. omstruckOrderMaterial.setUpdateTime(new Date());
  1727. omstruckOrderMaterial.setInsertUsername("admin");
  1728. omstruckOrderMaterial.setUpdateUsername("admin");
  1729. omstruckOrderMaterial.setInsertUpdateRemark("无");
  1730. }
  1731. // rmsDriverCapacity.setCarrierId(new BigDecimal(carrierId));
  1732. result +=rmsDriverCapacityMapper.updateByPrimaryKeySelective(rmsDriverCapacity);
  1733. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  1734. omstruckOrder.setOrderId(orderId);
  1735. omstruckOrder.setOrderPlanId(new BigDecimal(dayPlanId));
  1736. String orderNumber = DataChange.generateEightDigitsNumber("WYSDD", orderId.intValue());
  1737. omstruckOrder.setOrderNumber(orderNumber);
  1738. omstruckOrder.setOrderIssueTime(new Date());
  1739. omstruckOrder.setOrderStatus(new BigDecimal(3));
  1740. omstruckOrder.setInsertTime(new Date());
  1741. omstruckOrder.setUpdateTime(new Date());
  1742. omstruckOrder.setInsertUsername("admin");
  1743. omstruckOrder.setUpdateUsername("admin");
  1744. omstruckOrder.setInsertUpdateRemark("无");
  1745. omstruckOrder.setDeleted(new BigDecimal(0));
  1746. omstruckOrder.setOrderType(new BigDecimal(orderType));
  1747. omstruckOrder.setLineId(new BigDecimal(lineId));
  1748. result +=omstruckOrderMapper.insertSelective(omstruckOrder);
  1749. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  1750. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  1751. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  1752. omstruckOrderMaterial.setOrderId(orderId);
  1753. omstruckOrderMaterial.setMaterialId(materialId);
  1754. omstruckOrderMaterial.setOrderMaterialNumber(materialNumber);
  1755. omstruckOrderMaterial.setInsertTime(new Date());
  1756. omstruckOrderMaterial.setUpdateTime(new Date());
  1757. omstruckOrderMaterial.setInsertUsername("admin");
  1758. omstruckOrderMaterial.setUpdateUsername("admin");
  1759. omstruckOrderMaterial.setInsertUpdateRemark("无");
  1760. // omstruckOrderMaterial.setOrderMaterialWeight(materialWeight);
  1761. result +=omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  1762. }
  1763. return result;
  1764. }
  1765. /**
  1766. * 查询运单下的所有信息
  1767. * @param capacityNumber
  1768. * @return
  1769. */
  1770. @Override
  1771. public List<Map<String, Object>> getAllOrderMessage(String capacityNumber) {
  1772. List<Map<String, Object>> resultList;
  1773. // 判断是走采购,销售还是内转
  1774. resultList = omstruckOrderMapper.getResultListByCapacity(capacityNumber);
  1775. // 如果不是内转则取下面的orderId和orderType
  1776. if (resultList == null || resultList.size() == 0) {
  1777. //通过车牌号匹配运力ID
  1778. BigDecimal capacityId = omstruckOrderMapper.getCapacityIdByCapacityNum(capacityNumber);
  1779. BigDecimal driverCapacityId = omstruckOrderMapper.getDriverCapacityId(capacityId);
  1780. resultList = omstruckOrderMapper.getResultList(driverCapacityId);
  1781. }
  1782. // 循环遍历出每一条运输订单的信息
  1783. for (Map<String, Object> map : resultList) {
  1784. BigDecimal orderId = (BigDecimal) map.get("orderId");
  1785. BigDecimal orderType = (BigDecimal) map.get("orderType");
  1786. // 查询物资信息
  1787. List<Map<String, Object>> materialMapList = omstruckOrderMapper.getMaterialMes(orderId, null);
  1788. String allMaterialName = "";
  1789. String allMaterialNumber = "";
  1790. String allMaterialWeight = "";
  1791. String allMaterialSpecificationModel = "";
  1792. // 对物资信息进行处理
  1793. if (materialMapList == null && materialMapList.size() == 0) {
  1794. } else {
  1795. for (Map<String, Object> materialMap : materialMapList) {
  1796. String materialName = (String) materialMap.get("materialName");
  1797. BigDecimal materialNumber = (BigDecimal) materialMap.get("materialNumber");
  1798. BigDecimal materialWeight = (BigDecimal) materialMap.get("materialWeight");
  1799. String materialModel = (String) materialMap.get("materialModel");
  1800. String materialSpecification = (String) materialMap.get("materialSpecification");
  1801. if (materialName != null) {
  1802. allMaterialName += materialName + "/";
  1803. }
  1804. if (materialNumber != null) {
  1805. allMaterialNumber += materialNumber.toString() + "/";
  1806. }
  1807. if (materialWeight != null) {
  1808. allMaterialWeight += materialWeight.toString() + "/";
  1809. }
  1810. if (materialSpecification != null || materialModel != null) {
  1811. allMaterialSpecificationModel += materialSpecification + materialModel + "/";
  1812. }
  1813. }
  1814. String subMaterialName = "";
  1815. String subMaterialNumber = "";
  1816. String subMaterialWeight = "";
  1817. String subMaterialSpecificationModel = "";
  1818. if (allMaterialName.length() >= 2) {
  1819. subMaterialName = allMaterialName.substring(0, allMaterialName.length() - 2);
  1820. }
  1821. if (allMaterialName.length() < 2) {
  1822. subMaterialName = allMaterialName;
  1823. }
  1824. if (allMaterialNumber.length() >= 2) {
  1825. subMaterialNumber = allMaterialNumber.substring(0, allMaterialNumber.length() - 1);
  1826. }
  1827. if (allMaterialNumber.length() < 2) {
  1828. subMaterialNumber = allMaterialNumber;
  1829. }
  1830. if (allMaterialWeight.length() >= 2) {
  1831. subMaterialWeight = allMaterialWeight.substring(0, allMaterialWeight.length() - 1);
  1832. }
  1833. if (allMaterialWeight.length() < 2) {
  1834. subMaterialWeight = allMaterialWeight;
  1835. }
  1836. if (allMaterialSpecificationModel.length() >= 2) {
  1837. subMaterialSpecificationModel = allMaterialSpecificationModel.substring(0, allMaterialSpecificationModel.length() - 2);
  1838. }
  1839. if (allMaterialSpecificationModel.length() < 2) {
  1840. subMaterialSpecificationModel = allMaterialSpecificationModel;
  1841. }
  1842. map.put("allMaterialName", subMaterialName);
  1843. map.put("allMaterialNumber", subMaterialNumber);
  1844. map.put("allMaterialWeight", subMaterialWeight);
  1845. map.put("allMaterialSpecificationModel", subMaterialSpecificationModel);
  1846. }
  1847. Map<String, Object> orderMap = null;
  1848. int intValue = orderType.intValue();
  1849. if (intValue == 1 || intValue == 2 || intValue == 3) {
  1850. orderMap = omstruckOrderMapper.getSaleMap(orderId);
  1851. }
  1852. if (intValue == 4) {
  1853. orderMap = omstruckOrderMapper.getSteelInwardMap(orderId);
  1854. }
  1855. if (intValue == 5 || intValue == 6 || intValue == 7 || intValue == 8) {
  1856. orderMap = omstruckOrderMapper.getPurchaseMap(orderId);
  1857. }
  1858. if (intValue == 9 || intValue == 10 || intValue == 11) {
  1859. orderMap = omstruckOrderMapper.getInwardMap(orderId);
  1860. }
  1861. map.putAll(orderMap);
  1862. }
  1863. return resultList;
  1864. }
  1865. /**
  1866. * 司机确认订单
  1867. * orderNumber 运输订单号
  1868. * @param map
  1869. * @return
  1870. */
  1871. @Override
  1872. public int driverConfirmation(Map<String, Object> map) {
  1873. OmstruckOrder omstruckOrder = new OmstruckOrder();
  1874. BigDecimal orderId;
  1875. //通过运输订单号查询运输订单Id
  1876. if(map.get("orderId") == null){
  1877. orderId = new BigDecimal(omstruckOrderMapper.getOrderIdByOrderNumber((String) map.get("orderNumber")));
  1878. }else {
  1879. orderId = DataChange.dataToBigDecimal(map.get("orderId"));
  1880. }
  1881. Map<String, Object> seqMap = omstruckOrderMapper.getMaxLineSeqByOrderId(orderId);
  1882. if(seqMap != null){
  1883. //如果没有到最后一步之前 不允许确认
  1884. BigDecimal orderLineSequence = DataChange.dataToBigDecimal(seqMap.get("orderLineSequence"));
  1885. BigDecimal maxSegmentSqe = DataChange.dataToBigDecimal(seqMap.get("segmentSqe"));
  1886. int i = maxSegmentSqe.intValue() - orderLineSequence.intValue();
  1887. if( i != 1 && i != 2){
  1888. return 0;
  1889. }
  1890. }
  1891. omstruckOrder.setOrderId(orderId);
  1892. //设置司机确认订单
  1893. omstruckOrder.setDriverConfirmation(new BigDecimal(1));
  1894. omstruckOrder.setUpdateTime(new Date());
  1895. return omstruckOrderMapper.updateByPrimaryKeySelective(omstruckOrder);
  1896. }
  1897. /**
  1898. * 查询订单是否确认
  1899. * @Author TXF
  1900. * @Date 2022/1/4 23:36
  1901. * @param map {orderId}
  1902. * @return
  1903. **/
  1904. public boolean getDriverConfirmation(Map<String, Object> map){
  1905. Integer driverConfirmation = omstruckOrderMapper.getDriverConfirmation(DataChange.dataToBigDecimal(map.get("orderId")));
  1906. return driverConfirmation == null;
  1907. }
  1908. /**
  1909. * 通过运输订单号查询订单信息给司机
  1910. * @param map
  1911. * @return
  1912. */
  1913. public Map<String, Object> getMessageToApp(Map<String, Object> map) throws Exception {
  1914. BigDecimal orderId = DataChange.dataToBigDecimal(map.get("orderId"));
  1915. Integer orderType;
  1916. //获取订单类型
  1917. if(map.get("orderType") == null){
  1918. orderType = omstruckOrderMapper.getOrderTypeByOrderNumber(orderId);
  1919. }else {
  1920. orderType = DataChange.dataToBigDecimal(map.get("orderType")).intValue();
  1921. }
  1922. Map<String, Object> mesMap = new HashMap<>();
  1923. String steelJudge = null;
  1924. switch (orderType){
  1925. case 1:
  1926. mesMap = omstruckOrderMapper.getSteelOrderMessageToApp(map);
  1927. steelJudge = "steel";
  1928. break;
  1929. case 4:
  1930. mesMap = omstruckOrderMapper.getInwardSteelOrderMessageToApp(map);
  1931. steelJudge = "steel";
  1932. break;
  1933. case 2:
  1934. mesMap = omstruckOrderMapper.getXSOrderMessageToApp(map);
  1935. break;
  1936. case 3:
  1937. mesMap = omstruckOrderMapper.getFYJHOrderMessageToApp(map);
  1938. break;
  1939. case 5:
  1940. case 6:
  1941. case 7:
  1942. case 8:
  1943. case 17:
  1944. case 18:
  1945. mesMap = omstruckOrderMapper.getCGOrderMessageToApp(map);
  1946. break;
  1947. case 9:
  1948. case 10:
  1949. case 20:
  1950. mesMap = omstruckOrderMapper.getNZOrderMessageToApp(map);
  1951. mesMap.put("loadName","化工园区铁专线");
  1952. BigDecimal organizationId =(BigDecimal) mesMap.get("organizationId");
  1953. if (organizationId.intValue()==1){
  1954. mesMap.put("organizationCode","一厂");
  1955. }else if (organizationId.intValue()==2){
  1956. mesMap.put("organizationCode","二厂");
  1957. }
  1958. break;
  1959. case 15:
  1960. mesMap = omstruckOrderMapper.getNZOrderMessageToApp(map);
  1961. mesMap.put("inwardType","拼装车皮进厂");
  1962. break;
  1963. case 16:
  1964. case 23:
  1965. case 24:
  1966. mesMap = omstruckOrderMapper.getNZOrderMessageToApp(map);
  1967. if (DataChange.dataToBigDecimal(mesMap.get("organizationId")).intValue()==1){
  1968. mesMap.put("organizationCode","一厂");
  1969. }else if (DataChange.dataToBigDecimal(mesMap.get("organizationId")).intValue()==2){
  1970. mesMap.put("organizationCode","二厂");
  1971. }
  1972. break;
  1973. case 11:
  1974. mesMap = omstruckOrderMapper.getInwardOrderMessageToApp(map);
  1975. mesMap.put("inwardType", "内转计重");
  1976. break;
  1977. case 25:
  1978. mesMap = omstruckOrderMapper.getMulInwardOrderMessageToApp(map);
  1979. handleMulInward(omstruckOrderMapper.getMulInwardMaterials(map),mesMap);
  1980. mesMap.put("inwardType", "内转倒库");
  1981. break;
  1982. case 21:
  1983. mesMap =omstruckOrderMapper.getInwardTimeOrderMessageToApp(map);
  1984. mesMap.put("inwardType", "内转计时");
  1985. break;
  1986. case 12:
  1987. case 13:
  1988. case 14:
  1989. mesMap = omstruckOrderMapper.getSporadicOrder(map);
  1990. break;
  1991. case 19:
  1992. mesMap=omstruckOrderMapper.getSporadicOrder(map);
  1993. mesMap.put("type", "零星退货");
  1994. }
  1995. mesMap.put("materialMesList", omstruckOrderMapper.getMaterialMes(orderId, steelJudge));
  1996. return mesMap;
  1997. }
  1998. /**
  1999. * 通过车牌号查询所有已下发未接收的订单信息
  2000. * @param map
  2001. * @return
  2002. */
  2003. public List<Map<String, Object>> getAllOrderMessagesByCapacityNum(Map<String, Object> map) throws Exception {
  2004. String capacityNumber = (String) map.get("capacityNumber");
  2005. //通过车牌号查询所有未下发的订单ID
  2006. List<Map<String, Object>> orderMesList = omstruckOrderMapper.getOrderIdListByCapacityNumber(capacityNumber);
  2007. List<Map<String, Object>> mesMapList = new ArrayList<>();
  2008. for (Map<String, Object> orderMesMap: orderMesList) {
  2009. int orderType = DataChange.dataToBigDecimal(orderMesMap.get("orderType")).intValue();
  2010. //如果订单类型为2 则判断订单发货日期是否为当日 如果不是当日则不给显示
  2011. if(orderType == 2){
  2012. Integer judgeDate = omstruckOrderSeparateMapper.getDeliveryDate(orderMesMap.get("orderId"));
  2013. if(judgeDate == null){ // 数据为空则是已过截止日期 关闭订单
  2014. omstruckOrderMapper.closeTruckOrder(DataChange.dataToBigDecimal(orderMesMap.get("orderId")));
  2015. continue;
  2016. }
  2017. }
  2018. if (orderType == 1) {
  2019. Integer judgeDate = omstruckOrderSeparateMapper.getDeliveryDatePass(orderMesMap.get("orderId"));
  2020. if(judgeDate == null){ // 数据为空则是已过截止日期 关闭订单
  2021. omstruckOrderMapper.closeTruckOrder(DataChange.dataToBigDecimal(orderMesMap.get("orderId")));
  2022. continue;
  2023. }
  2024. }
  2025. if(orderType == 10|| orderType == 20 || orderType == 15 || orderType == 16 || orderType == 23 || orderType == 24){
  2026. Integer planEnable = omstruckOrderSeparateMapper.getOrderPlanEnable(orderMesMap.get("orderId"));
  2027. if(planEnable == 0){ // 数据为0则失效
  2028. omstruckOrderMapper.closeTruckOrder(DataChange.dataToBigDecimal(orderMesMap.get("orderId")));
  2029. continue;
  2030. }
  2031. }
  2032. if(orderType == 12|| orderType == 13 || orderType == 14 || orderType == 19){
  2033. Integer sporadicStatus = omstruckOrderSeparateMapper.getSporadicStatus(orderMesMap.get("orderId"));
  2034. if(sporadicStatus == 0){ // 数据为0则失效
  2035. omstruckOrderMapper.closeTruckOrder(DataChange.dataToBigDecimal(orderMesMap.get("orderId")));
  2036. continue;
  2037. }
  2038. }
  2039. //如果订单类型为11 当订单大于截止日期时,不显示订单
  2040. if(orderType == 11 || orderType == 21){
  2041. int result = omstruckOrderSeparateMapper.getInward(orderMesMap.get("orderId"));
  2042. if(result == 0){
  2043. omstruckOrderMapper.closeTruckOrder(DataChange.dataToBigDecimal(orderMesMap.get("orderId")));
  2044. continue;
  2045. }
  2046. }
  2047. Map<String, Object> mesMap = getMessageToApp(orderMesMap);
  2048. mesMapList.add(mesMap);
  2049. }
  2050. return mesMapList;
  2051. }
  2052. /**
  2053. * 新增进口矿
  2054. * @param mapValue
  2055. * @return
  2056. */
  2057. @Transactional
  2058. @Override
  2059. public int addInputOrder(Map<String, Object> mapValue) {
  2060. List<Map<String,Object>> mapList = (List<Map<String, Object>>) mapValue.get("mapList");
  2061. BigDecimal purchaseOrderId = new BigDecimal((Integer) mapValue.get("purchaseOrderId"));
  2062. BigDecimal materialId = new BigDecimal((Integer) mapValue.get("materialId"));
  2063. BigDecimal orderType = new BigDecimal((Integer) mapValue.get("orderType"));
  2064. BigDecimal lineId = new BigDecimal((Integer) mapValue.get("lineId"));
  2065. Integer planId = (Integer) mapValue.get("planId");
  2066. int result = 0;
  2067. for (Map<String, Object> map : mapList) {
  2068. OmstruckOrder omstruckOrder = new OmstruckOrder();
  2069. OmstruckOrderMaterial omstruckOrderMaterial = new OmstruckOrderMaterial();
  2070. BigDecimal orderId = omstruckOrderMapper.selectMaxId();
  2071. BigDecimal orderMaterialId = omstruckOrderMaterialMapper.selectMaxId();
  2072. String capacityNumber = (String)map.get("capacityNumber");
  2073. BigDecimal capacityId = omstruckOrderMapper.getCapacityId(capacityNumber);
  2074. BigDecimal materialWeight = DataChange.dataToBigDecimal(map.get("orderMaterialWeight"));
  2075. String unloadPoint = (String) map.get("unloadPoint");
  2076. BigDecimal unloadPointId = omstruckOrderMapper.getUnloadPointId(unloadPoint);
  2077. // Date orderEntryTime = new Date((Long) map.get("orderEntryTime"));
  2078. // 运输订单
  2079. omstruckOrder.setOrderId(orderId);
  2080. omstruckOrder.setOrderNumber(DataChange.generateEightDigitsNumber("WYSDD",orderId.intValue()));
  2081. omstruckOrder.setCapacityId(capacityId);
  2082. omstruckOrder.setOrderPlanId(purchaseOrderId);
  2083. omstruckOrder.setOrderType(orderType);
  2084. omstruckOrder.setOrderStatus(new BigDecimal(3));
  2085. omstruckOrder.setLineId(lineId);
  2086. omstruckOrder.setUnloadPointId(unloadPointId);
  2087. // omstruckOrder.setOrderEntryTime(orderEntryTime);
  2088. omstruckOrder.setInsertTime(new Date());
  2089. omstruckOrder.setInsertUsername("admin");
  2090. // 运输订单子表
  2091. omstruckOrderMaterial.setOrderMaterialId(orderMaterialId);
  2092. omstruckOrderMaterial.setOrderId(orderId);
  2093. omstruckOrderMaterial.setOrderMaterialWeight(materialWeight);
  2094. omstruckOrderMaterial.setMaterialId(materialId);
  2095. omstruckOrderMaterial.setInsertTime(new Date());
  2096. omstruckOrderMaterial.setInsertUsername("admin");
  2097. result += omstruckOrderMapper.insertSelective(omstruckOrder);
  2098. result += omstruckOrderMaterialMapper.insertSelective(omstruckOrderMaterial);
  2099. //新增实绩总表关联订单 feign 调用truckTms
  2100. map.put("orderId", omstruckOrder.getOrderId());
  2101. tmsTruckFeign.addTotalResult(map);
  2102. //更改运输计划子表 增加已分配重量 减少未分配重量 feign调用ams
  2103. map.put("planId",planId);
  2104. amsFeign.updateMaterial(map);
  2105. }
  2106. return result;
  2107. }
  2108. /**
  2109. * 查询销售订单下的运单信息
  2110. * @param map
  2111. * @return
  2112. */
  2113. @Override
  2114. public List<Map<String, Object>> getDriverInfoForSale2(Map<String, Object> map) {
  2115. List<Map<String, Object>> mapList = omstruckOrderMapper.getDriverInfoForSale2(map);
  2116. int count = 1;
  2117. String carStatus = null;
  2118. for (Map<String, Object> stringObjectMap : mapList) {
  2119. // 未接单
  2120. if (((BigDecimal)stringObjectMap.get("orderStatus")).intValue() == 4) {
  2121. carStatus = "未接单";
  2122. stringObjectMap.put("carStatus",carStatus);
  2123. stringObjectMap.put("ROW_ID",count);
  2124. count ++;
  2125. continue;
  2126. }
  2127. // 已出厂
  2128. if (stringObjectMap.get("outGateTime") != null) {
  2129. carStatus = "已出厂";
  2130. stringObjectMap.put("carStatus",carStatus);
  2131. stringObjectMap.put("ROW_ID",count);
  2132. count ++;
  2133. continue;
  2134. }
  2135. // 已计毛
  2136. if (stringObjectMap.get("grossWeight") != null) {
  2137. carStatus = "已计毛";
  2138. stringObjectMap.put("carStatus",carStatus);
  2139. stringObjectMap.put("ROW_ID",count);
  2140. count ++;
  2141. continue;
  2142. }
  2143. // 已装货
  2144. if (stringObjectMap.get("loadTime") != null) {
  2145. carStatus = "已装货";
  2146. stringObjectMap.put("carStatus",carStatus);
  2147. stringObjectMap.put("ROW_ID",count);
  2148. count ++;
  2149. continue;
  2150. }
  2151. // 已计皮
  2152. if (stringObjectMap.get("tareWeight") != null) {
  2153. carStatus = "已计皮";
  2154. stringObjectMap.put("carStatus",carStatus);
  2155. stringObjectMap.put("ROW_ID",count);
  2156. count ++;
  2157. continue;
  2158. }
  2159. // 已进厂
  2160. if (stringObjectMap.get("enGateTime") != null) {
  2161. carStatus = "已进厂";
  2162. stringObjectMap.put("carStatus",carStatus);
  2163. stringObjectMap.put("ROW_ID",count);
  2164. count ++;
  2165. continue;
  2166. }
  2167. // 未进厂
  2168. if (stringObjectMap.get("enGateTime") == null) {
  2169. carStatus = "未进厂";
  2170. stringObjectMap.put("carStatus",carStatus);
  2171. stringObjectMap.put("ROW_ID",count);
  2172. count ++;
  2173. continue;
  2174. }
  2175. }
  2176. return mapList;
  2177. }
  2178. /**
  2179. * 处理内转多拼的装卸货点
  2180. * @param list
  2181. * @param map
  2182. */
  2183. private void handleMulInward(List<Map<String,Object>> list,Map<String,Object> map){
  2184. String loadName="";
  2185. String unloadName="";
  2186. for(Map<String,Object> temp:list){
  2187. if(temp==null)
  2188. continue;
  2189. if(temp.get("loadName")!=null)
  2190. loadName+=(temp.get("loadName").toString()+";");
  2191. if(temp.get("unloadName")!=null)
  2192. unloadName+=(temp.get("unloadName").toString()+";");
  2193. }
  2194. map.put("loadName",loadName);
  2195. map.put("unloadName",unloadName);
  2196. }
  2197. }