TmstruckLeaveFactoryResultServiceImpl.java 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727
  1. package com.steerinfo.dil.service.impl;
  2. import com.alibaba.fastjson.JSON;
  3. import com.alibaba.fastjson.JSONObject;
  4. import com.steerinfo.dil.feign.*;
  5. import com.steerinfo.dil.mapper.TmstruckEnfactoryResultMapper;
  6. import com.steerinfo.dil.mapper.TmstruckLeaveFactoryResultMapper;
  7. import com.steerinfo.dil.mapper.TmstruckLoadResultMapper;
  8. import com.steerinfo.dil.mapper.UtilsMapper;
  9. import com.steerinfo.dil.model.TmstruckLeaveFactoryResult;
  10. import com.steerinfo.dil.model.TmstruckWeightResult;
  11. import com.steerinfo.dil.service.ITmstruckLeaveFactoryResultService;
  12. import com.steerinfo.dil.util.DataChange;
  13. import com.steerinfo.dil.util.HTTPRequestUtils;
  14. import com.steerinfo.dil.util.getRequestUtils;
  15. import org.springframework.beans.factory.annotation.Autowired;
  16. import org.springframework.scheduling.annotation.Scheduled;
  17. import org.springframework.stereotype.Service;
  18. import org.springframework.transaction.annotation.Transactional;
  19. import java.io.IOException;
  20. import java.math.BigDecimal;
  21. import java.text.DateFormat;
  22. import java.text.SimpleDateFormat;
  23. import java.util.*;
  24. /**
  25. * TmstruckLeaveFactoryResult服务实现:
  26. * @author generator
  27. * @version 1.0-SNAPSHORT 2021-09-11 10:32
  28. * 类描述
  29. * 修订历史:
  30. * 日期:2021-09-11
  31. * 作者:generator
  32. * 参考:
  33. * 描述:TmstruckLeaveFactoryResult服务实现
  34. * @see null
  35. * @Copyright 湖南视拓信息技术股份有限公司. All rights reserved.
  36. */
  37. @Service(value = "tmstruckLeaveFactoryResultService")
  38. public class TmstruckLeaveFactoryResultServiceImpl implements ITmstruckLeaveFactoryResultService {
  39. @Autowired
  40. private TmstruckLeaveFactoryResultMapper tmstruckLeaveFactoryResultMapper;
  41. @Autowired
  42. private TmstruckEnfactoryResultMapper tmstruckEnfactoryResultMapper;
  43. @Autowired
  44. private TmstruckLoadResultMapper tmstruckLoadResultMapper;
  45. @Autowired
  46. private UtilsServiceImpl utilsService;
  47. @Autowired
  48. private UtilsMapper utilsMapper;
  49. @Autowired
  50. private OtmsFeign otmsFeign;
  51. @Autowired
  52. private TmstruckEnfactoryResultServiceImpl tmstruckEnfactoryResultService;
  53. @Autowired
  54. TmstruckSmsRusultServiceImpl tmstruckSmsRusultService;
  55. @Autowired
  56. OmsFeign omsFeign;
  57. @Autowired
  58. BmsTruckFeign bmsTruckFeign;
  59. @Autowired
  60. AmsFeign amsFeign;
  61. @Autowired
  62. JoinFeign joinFeign;
  63. //果园库测试接口:"http://113.204.217.110:9810/dagang/receiving";
  64. //果园库正式接口
  65. private String guoYuanUrl="http://114.117.208.165:9810/dagang/receiving";
  66. //城嘉库登录访问接口
  67. private String chengJiaLoginUrl="http://116.204.73.104:8083/dagon/login";
  68. //城嘉库推送数据接口
  69. private String chengJiaSendUrl="http://116.204.73.104:8083/dagon/selectSaleSteelOrder";
  70. /**
  71. * 查看运输线路是否为出厂
  72. * @param orderNumber
  73. * @return
  74. */
  75. @Override
  76. public Integer selectTransportRoute(String orderNumber) {
  77. return tmstruckLeaveFactoryResultMapper.selectTransportRoute(orderNumber);
  78. }
  79. /**
  80. * 派单后新增出厂实绩
  81. * 总实绩ID、线路终点
  82. * @param map
  83. * @return
  84. */
  85. @Override
  86. public int addLeaveFactory(Map<String, Object> map) {
  87. TmstruckLeaveFactoryResult tmstruckLeaveFactoryResult = new TmstruckLeaveFactoryResult();
  88. //添加主键
  89. tmstruckLeaveFactoryResult.setId(tmstruckLeaveFactoryResultMapper.selectMaxId());
  90. //添加总实绩ID
  91. BigDecimal resultTotalId = DataChange.dataToBigDecimal(map.get("resultTotalId"));
  92. tmstruckLeaveFactoryResult.setResultTotalId(resultTotalId);
  93. List<Integer> gatepostIdList = utilsMapper.getLineSegmentGateCalcId(map);
  94. gatepostIdList.remove(null);
  95. //随机取门岗值
  96. Integer gatepostId = utilsService.randomGetValue(gatepostIdList);
  97. try{
  98. //如果是物资里有钒渣,则取5
  99. map.put("con","钒渣");
  100. if(utilsMapper.getMaterialNumByTotal(map) > 0){
  101. gatepostId=5;
  102. }
  103. }catch (Exception e){
  104. e.printStackTrace();
  105. }
  106. //获取门岗ID
  107. tmstruckLeaveFactoryResult.setGatepostId(new BigDecimal(gatepostId));
  108. //添加路段顺序号
  109. tmstruckLeaveFactoryResult.setSegmentSqe(DataChange.dataToBigDecimal(map.get("segmentSqe")));
  110. //添加门岗ID 出厂门岗为线路的终点
  111. int i=tmstruckLeaveFactoryResultMapper.insertSelective(tmstruckLeaveFactoryResult);
  112. try{
  113. tmstruckLeaveFactoryResultMapper.clearRepeat(tmstruckLeaveFactoryResult);
  114. }catch (Exception e){
  115. e.printStackTrace();
  116. }
  117. return i;
  118. }
  119. @Override
  120. public Map<String, Object> getTruckFactoryResult(String orderNumber) {
  121. return tmstruckLeaveFactoryResultMapper.getTruckFactoryResult(orderNumber);
  122. }
  123. /**
  124. * APP查询出厂信息
  125. * @param orderNumber
  126. * @return
  127. */
  128. @Override
  129. public List<Map<String, Object>> getLeaveFactoryList(String orderNumber) {
  130. return tmstruckLeaveFactoryResultMapper.getLeaveFactoryList(orderNumber);
  131. }
  132. /**
  133. * 查询所有的出厂实绩
  134. * 1:销售订单;2:焦炭发运计划;3:水渣发运计划;4:内转到异地库;5:采购辅料订单;6:采购老区燃料订单;
  135. * 7:采购新区燃料订单;8:采购进口矿(万州-厂内);9:采购内转(达州-厂内);10:采购内转(老区-厂内); 11:厂内内转
  136. * @param map
  137. * @return
  138. */
  139. @Override
  140. public List<Map<String, Object>> getLeaveFactoryResult(Map<String, Object> map) {
  141. Integer orderType = (Integer) map.get("orderTypee");
  142. switch (orderType){
  143. case 1:
  144. case 2:
  145. case 3:
  146. return tmstruckLeaveFactoryResultMapper.selectAllLeaveFacatoryForSale(map);
  147. case 4:
  148. return tmstruckLeaveFactoryResultMapper.selectSteelNzLeaveFactory(map);
  149. case 5:
  150. case 6:
  151. case 7:
  152. case 8:
  153. case 17:
  154. case 18:
  155. return tmstruckLeaveFactoryResultMapper.getCGLeaveFactoryResult(map); //apiId:110
  156. case 9:
  157. return tmstruckLeaveFactoryResultMapper.getImportedDomesticNzEnFactoryResult(map); //apiId:110
  158. case 10:
  159. case 20:
  160. case 23:
  161. case 24:
  162. return tmstruckEnfactoryResultMapper.getCgNzOutFactory(map);
  163. case 11:
  164. return tmstruckLeaveFactoryResultMapper.getInFactoryOutFactoryResult(map); //apiId:361
  165. case 12:
  166. case 13:
  167. case 14:
  168. case 19:
  169. case 100:
  170. return tmstruckLeaveFactoryResultMapper.getSporadicLeaveFactory(map);//apiId:421
  171. }
  172. return null;
  173. }
  174. /**
  175. * 通过 PDA 出厂
  176. * 1:销售订单;2:焦炭发运计划;3:水渣发运计划;4:内转到异地库;5:采购辅料订单;6:采购老区燃料订单;
  177. * 7:采购新区燃料订单;8:采购进口矿(万州-厂内);9:采购内转(达州-厂内);10:采购内转(老区-厂内); 11:厂内内转
  178. * @param map
  179. * @return
  180. */
  181. @Transactional(rollbackFor = Exception.class)
  182. @Override
  183. public int leaveFactoryByPDA(Map<String, Object> map) throws Exception{
  184. int i = 0;
  185. String orderNumber = (String) map.get("orderNumber");
  186. orderNumber = orderNumber.substring(0, orderNumber.length() - 1);
  187. //通过订单号查询订单类型 及总实绩Id
  188. Map<String, Object> mesMap = utilsMapper.getOrderTypeByOrderNumber(orderNumber);
  189. int orderType = DataChange.dataToBigDecimal(mesMap.get("orderType")).intValue();
  190. String capacityNumber = (String) mesMap.get("capacityNumber");
  191. if(orderType == 11 || orderType == 15 || orderType == 16){
  192. return orderType11Use(map, mesMap,capacityNumber);
  193. }else if(orderType == 21){
  194. return tmstruckEnfactoryResultService.orderType21Use(map, orderNumber, DataChange.dataToBigDecimal(mesMap.get("orderId")));
  195. }
  196. Map<String, Object> selectMap = tmstruckLeaveFactoryResultMapper.selectResultId(DataChange.dataToBigDecimal(mesMap.get("resultTotalId")));
  197. if(selectMap == null){
  198. throw new Exception("该车已出厂!!");
  199. }else{
  200. BigDecimal segmentSqe = DataChange.dataToBigDecimal(selectMap.get("segmentSqe"));
  201. BigDecimal orderSegmentSqe = DataChange.dataToBigDecimal(mesMap.get("orderSegmentSqe"));
  202. //如果当前路段顺序号 +1 不等于出厂路段顺序号 则不允许出厂
  203. if(segmentSqe.intValue() != (orderSegmentSqe.intValue() + 1) && orderType != 1){
  204. throw new Exception("该车作业环节未全部完成!");
  205. }
  206. }
  207. if(orderType == 2){
  208. Map<String,Object> loadResultMap = tmstruckLoadResultMapper.getLoadResultMap(DataChange.dataToBigDecimal(mesMap.get("resultTotalId")));
  209. //根据总实绩ID查询该车有没有装货
  210. if(loadResultMap != null && loadResultMap.get("loadEndTime") == null){
  211. throw new Exception("该车未扫装货,请提醒司机去扫装货");
  212. }
  213. // 查询运单所属的销售订单id
  214. BigDecimal saleOrderId = tmstruckLeaveFactoryResultMapper.getSaleOrderId(orderNumber);
  215. // 得到销售订单下已出厂车辆已计量净重
  216. Double allNetWeight = tmstruckLeaveFactoryResultMapper.getLeaveFactoryNetWeight(saleOrderId);
  217. if (allNetWeight != null) {
  218. // 得到当前运单净重
  219. Double nowNetWeight = tmstruckLeaveFactoryResultMapper.getNowNetWeight(orderNumber);
  220. // 得到销售订单下单总重量
  221. Double saleWeight = tmstruckLeaveFactoryResultMapper.getSaleMaterialWeight(saleOrderId);
  222. //判断当前订单是否可出厂
  223. Integer canWork = tmstruckLeaveFactoryResultMapper.getCanWorkStatus(DataChange.dataToBigDecimal(mesMap.get("orderId")));
  224. if (allNetWeight + nowNetWeight > saleWeight && canWork == null) {
  225. throw new Exception("该销售订单吨位已超额,不允许出厂,请司机走流程卸货!");
  226. }
  227. }
  228. }
  229. if(orderType == 13 ){
  230. //检查物资类型
  231. List<String> materials=null;
  232. try{
  233. materials=tmstruckLeaveFactoryResultMapper.getMaterial(orderNumber);
  234. }catch (Exception e){
  235. e.printStackTrace();
  236. System.out.println("查询物资失败,不检查是否装货,不影响后续执行");
  237. }
  238. //检查是否装货
  239. if(materials!=null && materials.size()>0){
  240. Map<String,Object> loadResultMap = tmstruckLoadResultMapper.getLoadResultMap(DataChange.dataToBigDecimal(mesMap.get("resultTotalId")));
  241. if(loadResultMap == null || loadResultMap.get("loadEndTime") == null){
  242. throw new Exception("该车未扫装货,请提醒司机去扫装货");
  243. }
  244. }
  245. }
  246. if(orderType == 23 || orderType == 24) {
  247. //查询卸货
  248. Map<String,Object> unloadMap = tmstruckLeaveFactoryResultMapper.getUnloadResult(DataChange.dataToBigDecimal(mesMap.get("orderId")));
  249. if (unloadMap != null && unloadMap.get("resultEndTime") == null) {
  250. throw new Exception("该车未扫卸货,请提醒司机去补扫卸货");
  251. }
  252. }
  253. if(orderType == 1 && "true".equals(tmstruckLeaveFactoryResultMapper.getPrintFlag())) {
  254. //如果是钢材订单,且打印送货单是必须打印,那么进这个方法
  255. Integer printNumber = tmstruckLeaveFactoryResultMapper.getPrintNumber(DataChange.dataToBigDecimal(mesMap.get("orderId")));
  256. if(printNumber == 0){
  257. throw new Exception("未打印送货单,请提醒司机去打印");
  258. }
  259. }
  260. map.putAll(mesMap);
  261. map.putAll(selectMap);
  262. map.remove("Sqe");
  263. map.put("orderNumber", orderNumber);
  264. BigDecimal orderId = DataChange.dataToBigDecimal(map.get("orderId"));
  265. i += updateLeaveResultByPDA(map); //更新出厂实绩
  266. //更新路段顺序号
  267. i += utilsService.updateOrderLineSequence(map);
  268. switch (orderType){
  269. case 1:
  270. //判断该订单是不是自提
  271. String isSelfMention = tmstruckLeaveFactoryResultMapper.getIsSelfMention(orderId);
  272. try {
  273. if(isSelfMention != null && isSelfMention.equals("是")) {
  274. //如果是自提,则关闭运单
  275. i += utilsService.closeOrderSteel(map);
  276. break;
  277. }
  278. } catch (Exception e) {
  279. e.printStackTrace();
  280. }
  281. //查询该订单的出库单制作日期
  282. // try {
  283. // List<String> easPrimaryIds = tmstruckLeaveFactoryResultMapper.getEasPrimaryIds(orderNumber);
  284. // Map<String, Object> easPrimaryMap = new HashMap<>();
  285. // easPrimaryMap.put("easPrimaryList",easPrimaryIds);
  286. // amsFeign.getMakeOrderDate(easPrimaryMap);
  287. // } catch (Exception e) {
  288. // e.printStackTrace();
  289. // }
  290. //判断该订单是不是异地库
  291. try {
  292. String addressPlace = tmstruckLeaveFactoryResultMapper.getAddressPlace(orderId);
  293. if (addressPlace != null && addressPlace.contains("城嘉库")) {
  294. List<Map<String,Object>> data =getOffSiteWarehouse(orderNumber);
  295. //调用城嘉库登录接口获取token
  296. String token = DagonloginChenJiaku();
  297. if (token != null) {
  298. for (Map<String,Object> map1:data) {
  299. map1.put("token", token);
  300. //接口发送日期
  301. map1.put("sendTime",new Date());
  302. ///调用城嘉库推送接口
  303. sendMesToChengJia(map1);
  304. }
  305. } else {
  306. System.out.println("登录城嘉库失败");
  307. }
  308. }else if(addressPlace!=null && addressPlace.contains("果园港")){
  309. //果园库
  310. List<Map<String,Object>> data =getOffSiteWarehouse(orderNumber);
  311. Map<String,Object> details=new HashMap<>();
  312. DateFormat format=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  313. for(Map<String,Object> temp:data){
  314. temp.put("resultOutGateTime",format.format((Date)(temp.get("outGateTime"))));
  315. temp.put("orderIssueTime",format.format((Date)(temp.get("orderIssueTime"))));
  316. temp.remove("outGateTime");
  317. temp.put("orderWagonNo",temp.get("capacityNo"));
  318. }
  319. //发送时间
  320. details.put("sendTime",format.format(new Date()));
  321. //系统代码
  322. details.put("sysCode", "DGXT");
  323. //仓库代码
  324. details.put("warehouseCode", "LJJT");
  325. //运输方式
  326. details.put("transportType", "汽运");
  327. //详细数据
  328. details.put("details", data);
  329. //推送数据
  330. sendMesToGuoyuan(details);
  331. }
  332. } catch (IOException e) {
  333. e.printStackTrace();
  334. }
  335. try {
  336. //发送短信
  337. Map<String,Object> messageMap = tmstruckLeaveFactoryResultMapper.getMessageMap(orderId);
  338. if(messageMap.get("saleOrderConsigneeTEL") != null){
  339. String capacityNum = (String) messageMap.get("capacityNumber");
  340. String mobile = (String)messageMap.get("saleOrderConsigneeTEL");
  341. tmstruckSmsRusultService.generaSendMessage(mobile,capacityNum,orderId);
  342. }
  343. // 调用结算
  344. }catch (Exception ex){
  345. System.out.println(ex.getMessage());
  346. }
  347. //销售厂外监控
  348. try {
  349. Map<String, Object> parem = getTruckFactoryResult(orderNumber);
  350. parem.put("turnOf","0");
  351. otmsFeign.createTotalResult(parem);
  352. } catch (Exception e) {
  353. e.printStackTrace();
  354. }
  355. try {
  356. System.out.println(orderId + "生成结算数据");
  357. bmsTruckFeign.addDetailsOrder(orderId);
  358. } catch (Exception e) {
  359. e.printStackTrace();
  360. }
  361. break;
  362. case 2:
  363. case 3:
  364. //查询司机是否已确认订单 如果订单未确认 则不允许出厂
  365. Integer driverConfirmation = utilsMapper.getDriverConfirmation(orderId);
  366. if(driverConfirmation == null){
  367. throw new Exception("请提醒司机确认订单!");
  368. }
  369. i += utilsService.closeOrderNormally(map);
  370. // 判断是否要自动派单
  371. Map<String,Object> mapValue = omsFeign.getSaleAllMessages(orderId.intValue());
  372. Object closeStatus = mapValue.get("closeStatus");
  373. if (closeStatus != null && DataChange.dataToBigDecimal(closeStatus).intValue() == 0) {
  374. amsFeign.dispatchTruckOrderByCarrier(mapValue);
  375. }
  376. try {
  377. bmsTruckFeign.addDetailsOrder(orderId);
  378. } catch (Exception e) {
  379. e.printStackTrace();
  380. }
  381. break;
  382. case 4:
  383. i += utilsService.closeOrderNormally(map);
  384. break;
  385. case 5:
  386. case 6:
  387. case 7:
  388. case 8:
  389. //判断出厂路段顺序号是否为最后一个 采购订单关闭订单
  390. i += utilsService.closeOrderNormally(map);
  391. //查询是否为一车多趟采购订单类型
  392. Integer isMoreTripsStatus = tmstruckLeaveFactoryResultMapper.getIsMoreTripsStatus(DataChange.dataToBigDecimal(map.get("orderId")));
  393. if(isMoreTripsStatus != null && isMoreTripsStatus == 1){
  394. //如果是一车多趟 则重新下一个运输订单
  395. omsFeign.addNewTransportOrder(orderId.intValue());
  396. }
  397. break;
  398. case 9:
  399. case 17:
  400. case 18:
  401. //判断出厂路段顺序号是否为最后一个 采购订单关闭订单
  402. i += utilsService.closeOrderNormally(map);
  403. break;
  404. case 10:
  405. case 20:
  406. //生成新的采购内转运输订单
  407. //判断出厂路段顺序号是否为最后一个 采购订单关闭订单
  408. i += utilsService.closeOrderNormally(map);
  409. //根据运输订单ID查询路段顺序号
  410. Integer orderStatus = tmstruckLeaveFactoryResultMapper.getOrderStatus(orderId);
  411. if(orderStatus == 2){
  412. //判断是否满足条件--计划是否被启用
  413. Integer j = tmstruckLeaveFactoryResultMapper.getPlanEnable(orderId);
  414. if(j == 1){
  415. //生成新的运输订单
  416. omsFeign.addPurInwardOrder(orderId);
  417. }
  418. try {
  419. bmsTruckFeign.addInwardDetailsOrder(map);
  420. } catch (Exception e) {
  421. e.printStackTrace();
  422. }
  423. }
  424. break;
  425. case 23:
  426. case 24:
  427. i += utilsService.closeOrderNormally(map);
  428. omsFeign.addPurInwardOrder(orderId);
  429. try {
  430. bmsTruckFeign.addInwardDetailsOrder(map);
  431. } catch (Exception e) {
  432. e.printStackTrace();
  433. }
  434. break;
  435. case 12:
  436. case 13:
  437. case 19:
  438. case 14:
  439. //关闭当前订单
  440. i += utilsService.closeOrderNormally(map);
  441. //生成新的零星订单
  442. omsFeign.pushMessageToDriver(map);
  443. break;
  444. }
  445. utilsService.pushMesToWebsocket((String) map.get("capacityNumber"), "出厂");
  446. return i;
  447. }
  448. /**
  449. * 内转订单类型
  450. * @Author TXF
  451. * @Date 2022/3/18 18:03
  452. * @param map
  453. * @param mesMap
  454. * @param capacityNumber
  455. * @return
  456. **/
  457. public int orderType11Use(Map<String, Object> map, Map<String, Object> mesMap, String capacityNumber){
  458. //内转订单类型 没有生成实绩 直接新增
  459. int sqe = DataChange.dataToBigDecimal(mesMap.get("Sqe")).intValue();
  460. sqe = sqe + 1;
  461. map.put("resultId",tmstruckLeaveFactoryResultMapper.selectMaxId());//出厂实绩ID
  462. map.put("Sqe",sqe);//查询路段顺序号+1
  463. map.put(("totalId"),mesMap.get("totalId"));
  464. tmstruckLeaveFactoryResultMapper.insertSelective(generateLeaveFactory(map));
  465. //更新路段顺序号
  466. mesMap.put("orderLineSequence",sqe);
  467. utilsService.updateOrderLineSqeByOrderNumber(mesMap);
  468. utilsService.pushMesToWebsocket(capacityNumber, "出厂");
  469. return 1;
  470. }
  471. //内转订单类型新增出厂实绩
  472. private TmstruckLeaveFactoryResult generateLeaveFactory(Map<String, Object> map) {
  473. TmstruckLeaveFactoryResult tmstruckLeaveFactoryResult = new TmstruckLeaveFactoryResult();
  474. //获取出厂实绩ID
  475. tmstruckLeaveFactoryResult.setResultId(DataChange.dataToBigDecimal(map.get("resultId")));
  476. //添加门岗
  477. tmstruckLeaveFactoryResult.setGatepostId(DataChange.dataToBigDecimal(map.get("gatepostId")));
  478. //添加路段顺序号
  479. tmstruckLeaveFactoryResult.setSegmentSqe(DataChange.dataToBigDecimal(map.get("Sqe")));
  480. //添加出厂时间
  481. tmstruckLeaveFactoryResult.setResultOutGateTime(new Date());
  482. tmstruckLeaveFactoryResult.setInsertTime(new Date());
  483. tmstruckLeaveFactoryResult.setResultOutMode("手动抬杆");
  484. tmstruckLeaveFactoryResult.setInsertUsername("admin");
  485. if(map.get("Sqe") !=null){
  486. tmstruckLeaveFactoryResult.setSegmentSqe(DataChange.dataToBigDecimal(map.get("Sqe")));
  487. }
  488. if(map.get("totalId") !=null){
  489. tmstruckLeaveFactoryResult.setResultTotalId(DataChange.dataToBigDecimal(map.get("totalId")));
  490. }
  491. return tmstruckLeaveFactoryResult;
  492. }
  493. /**
  494. * 更新出厂实绩
  495. * @param mapValue {运输订单号:orderNumber 门岗名称:gatepostName}
  496. * @return
  497. */
  498. public int updateLeaveResultByPDA(Map<String, Object> mapValue){
  499. TmstruckLeaveFactoryResult tmstruckLeaveFactoryResult = new TmstruckLeaveFactoryResult();
  500. tmstruckLeaveFactoryResult.setResultId(DataChange.dataToBigDecimal(mapValue.get("resultId")));
  501. //通过门岗名称获取门岗ID
  502. if(mapValue.get("gatepostId") == null){
  503. Integer gatepostId = tmstruckEnfactoryResultMapper.selectGatepostIdByGatepostName((String) mapValue.get("gatepostName"));
  504. if(gatepostId != null){
  505. tmstruckLeaveFactoryResult.setGatepostId(new BigDecimal(gatepostId));
  506. }
  507. }else {
  508. tmstruckLeaveFactoryResult.setGatepostId(DataChange.dataToBigDecimal(mapValue.get("gatepostId")));
  509. }
  510. //设置常规字段 添加 出厂时间 和 出厂方式
  511. tmstruckLeaveFactoryResult.setResultOutGateTime(new Date());
  512. tmstruckLeaveFactoryResult.setResultOutMode("手动抬杠");
  513. tmstruckLeaveFactoryResult.setInsertUsername("admin");
  514. tmstruckLeaveFactoryResult.setInsertTime(new Date());
  515. tmstruckLeaveFactoryResultMapper.updateResultTotalOutStatus(DataChange.dataToBigDecimal(mapValue.get("resultTotalId")));
  516. return tmstruckLeaveFactoryResultMapper.updateByPrimaryKeySelective(tmstruckLeaveFactoryResult);
  517. }
  518. /**
  519. * 通过总实绩Id修改出厂实绩出厂门岗
  520. * @param resultTotalId
  521. * @param gatepostId
  522. * @return
  523. */
  524. public int updateLeaveFactoryGatepostId(Integer resultTotalId, Integer gatepostId){
  525. TmstruckLeaveFactoryResult tmstruckLeaveFactoryResult = new TmstruckLeaveFactoryResult();
  526. //通过总实绩ID查询出产实绩
  527. BigDecimal resultId = tmstruckLeaveFactoryResultMapper.getResultIdByTotalId(resultTotalId);
  528. tmstruckLeaveFactoryResult.setResultId(resultId);
  529. tmstruckLeaveFactoryResult.setGatepostId(new BigDecimal(gatepostId));
  530. return tmstruckLeaveFactoryResultMapper.updateByPrimaryKeySelective(tmstruckLeaveFactoryResult);
  531. }
  532. /**
  533. * 查询零星物资出厂列表
  534. * @param mapValue
  535. * @return
  536. */
  537. @Override
  538. public List<Map<String, Object>> getSporadicLeaveFactory(Map<String, Object> mapValue) {
  539. return tmstruckLeaveFactoryResultMapper.getSporadicLeaveFactory(mapValue);
  540. }
  541. public List<Map<String,Object>> getOffSiteWarehouse(String orderNumber) {
  542. List<Map<String, Object>> mapList = tmstruckLeaveFactoryResultMapper.getOffSiteWarehouse(orderNumber);
  543. for (Map<String,Object> map1:mapList){
  544. String materialName =(String) map1.get("materialName");
  545. if (materialName.contains("盘螺")){
  546. map1.put("materialType","盘螺");
  547. }else if (materialName.contains("盘圆")||materialName.contains("盘元")){
  548. map1.put("materialType","盘圆");
  549. }else if (materialName.contains("螺纹")){
  550. map1.put("materialType","螺纹钢");
  551. }
  552. }
  553. return mapList;
  554. }
  555. /**
  556. * 访问城嘉库接口方法
  557. * @param
  558. * @return
  559. */
  560. public String DagonloginChenJiaku() throws IOException {
  561. Map<String, String> reqMap = new HashMap<>();
  562. reqMap.put("username","dagon");
  563. reqMap.put("password","147258");
  564. // JSONObject jsonObject = new JSONObject();
  565. // jsonObject.putAll(reqMap);
  566. // Map<String,Object> map=new HashMap<>();
  567. // map.put("username","dagon");
  568. // map.put("password","147258");
  569. // jsonObject.putAll(map);
  570. // jsonObject.put("username","dagon");
  571. // jsonObject.put("password","147258");
  572. String jsonData = null;
  573. jsonData = getRequestUtils.doPost(chengJiaLoginUrl,reqMap);
  574. if(!"null".equals(jsonData)){
  575. System.out.println(jsonData);
  576. HashMap hashMap = JSON.parseObject(jsonData, HashMap.class);
  577. BigDecimal code = DataChange.dataToBigDecimal( hashMap.get("code"));
  578. System.out.println(hashMap.get("message"));
  579. if(200==code.intValue()){
  580. Map<String,Object> result =(Map<String,Object>) hashMap.get("result");
  581. String token =(String) result.get("token");
  582. return token;
  583. }else {
  584. System.out.println("推送数据失败"+hashMap.get("message"));
  585. }
  586. }
  587. return null;
  588. // String body = restTemplate.postForEntity(chengJiaLoginUrl, reqMap, String.class).getBody();
  589. // System.out.println(body);
  590. // return body;
  591. }
  592. /**
  593. * 推送数据给城嘉库
  594. */
  595. public int sendMesToChengJia(Map<String, Object> map){
  596. String token =(String) map.get("token");
  597. Map<String,Object> jsonObject = new HashMap<>();
  598. jsonObject.remove(token);
  599. jsonObject.putAll(map);
  600. String jsonData = null;
  601. jsonData = getRequestUtils.doPostAddHeader(chengJiaSendUrl, jsonObject,token);
  602. if(!"null".equals(jsonData)){
  603. System.out.println(jsonData);
  604. HashMap hashMap = JSON.parseObject(jsonData, HashMap.class);
  605. BigDecimal code = DataChange.dataToBigDecimal(hashMap.get("code"));
  606. System.out.println(hashMap.get("message"));
  607. if(code.intValue()==200){
  608. return 1;
  609. }else {
  610. System.out.println("推送数据失败"+hashMap.get("message"));
  611. }
  612. }
  613. return 0;
  614. }
  615. /**
  616. * 访问重庆果园库接口方法
  617. * @param map
  618. * @return
  619. */
  620. public int sendMesToGuoyuan(Map<String, Object> map){
  621. JSONObject jsonObject = new JSONObject();
  622. jsonObject.putAll(map);
  623. String jsonData = null;
  624. try {
  625. jsonData = HTTPRequestUtils.send(guoYuanUrl, jsonObject, "utf-8");
  626. } catch (IOException e) {
  627. e.printStackTrace();
  628. }
  629. if(!"null".equals(jsonData)){
  630. System.out.println(jsonData);
  631. try{
  632. HashMap hashMap = JSON.parseObject(jsonData, HashMap.class);
  633. BigDecimal code =DataChange.dataToBigDecimal(hashMap.get("code"));
  634. System.out.println(hashMap.get("message"));
  635. if(code.intValue()==200){
  636. return 1;
  637. }else {
  638. System.out.println("推送数据失败"+hashMap.get("message"));
  639. }
  640. }catch (Exception e){
  641. }
  642. }
  643. return 0;
  644. }
  645. /**
  646. * 自动补扫出厂
  647. */
  648. @Scheduled(fixedRate = 1000*60*60*3)
  649. public void autoLeaveFactory(){
  650. Date date=new Date();
  651. Calendar calendar=Calendar.getInstance();
  652. calendar.setTime(date);
  653. //非钢材,出净重24h后自动出厂,并关单
  654. calendar.add(Calendar.HOUR_OF_DAY,-12);
  655. date=calendar.getTime();
  656. Map<String,Object> map = new HashMap<>();
  657. map.put("nowDate",date);
  658. List<Map<String,Object>> list = tmstruckLeaveFactoryResultMapper.getWeightResultNetted(map);
  659. //钢材,打印送货单3小时后补扫出厂
  660. calendar.setTime(new Date());
  661. calendar.add(Calendar.HOUR_OF_DAY,-3);
  662. date=calendar.getTime();
  663. map.put("nowDate",date);
  664. if(list != null){
  665. list.addAll(tmstruckLeaveFactoryResultMapper.getSteelForLeave(map));
  666. }else{
  667. list = tmstruckLeaveFactoryResultMapper.getSteelForLeave(map);
  668. }
  669. for(Map<String,Object> item:list){
  670. try{
  671. System.out.println(item);
  672. leaveFactoryByPDA(item);
  673. }catch (Exception e){
  674. e.printStackTrace();
  675. if(DataChange.dataToBigDecimal(item.get("orderType")).compareTo(new BigDecimal(1)) != 0) {
  676. tmstruckLeaveFactoryResultMapper.updateOrderStatus(DataChange.dataToBigDecimal(item.get("orderId")));
  677. }
  678. }
  679. }
  680. }
  681. }