UniversalServiceImpl.java 9.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291
  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.JoinFeign;
  5. import com.steerinfo.dil.mapper.UniversalMapper;
  6. import com.steerinfo.dil.service.UniversalService;
  7. import com.steerinfo.dil.util.ESUtil;
  8. import com.steerinfo.dil.util.HTTPRequestUtils;
  9. import com.steerinfo.framework.controller.RESTfulResult;
  10. import io.swagger.annotations.ApiModelProperty;
  11. import org.apache.commons.codec.digest.DigestUtils;
  12. import org.springframework.beans.factory.annotation.Autowired;
  13. import org.springframework.scheduling.annotation.Async;
  14. import org.springframework.scheduling.annotation.EnableAsync;
  15. import org.springframework.scheduling.annotation.EnableScheduling;
  16. import org.springframework.scheduling.annotation.Scheduled;
  17. import org.springframework.stereotype.Service;
  18. import javax.annotation.Resource;
  19. import java.io.IOException;
  20. import java.io.InputStream;
  21. import java.math.BigDecimal;
  22. import java.sql.Blob;
  23. import java.sql.SQLException;
  24. import java.util.*;
  25. /**
  26. * @ author :TXF
  27. * @ time :2021/10/19 18:05
  28. */
  29. @Service
  30. @EnableScheduling
  31. @EnableAsync
  32. public class UniversalServiceImpl implements UniversalService {
  33. @Resource
  34. private UniversalMapper universalMapper;
  35. @Autowired
  36. private JoinFeign joinFeign;
  37. @Autowired
  38. private ESUtil esUtil;
  39. /**
  40. * 打印提货单
  41. * @param orderNumber 运输订单号
  42. * @return
  43. */
  44. @Override
  45. public Map<String, Object> printTiHuoDan(String orderNumber) {
  46. //查询订单信息
  47. Map<String, Object> tiHuoDanMap = universalMapper.getTiHuoDan(orderNumber);
  48. //查询该订单下的所有装车信息
  49. List<Map<String, Object>> oomMes = universalMapper.getOOMMes(orderNumber);
  50. tiHuoDanMap.put("loadMes", oomMes);
  51. return tiHuoDanMap;
  52. }
  53. /**
  54. * 查询路段顺序及当前路段顺序号
  55. * @param map
  56. * @return
  57. */
  58. @Override
  59. public Map<String, Object> getNowLineMes(Map<String, Object> map) {
  60. return null;
  61. }
  62. // @Override
  63. // public List<String> getWarrantyAndPrint(String orderNumber) {
  64. // List<Map<String,Object>> warrantyCode = universalMapper.getWarranty(orderNumber);
  65. // List<String> list = new ArrayList<>();
  66. // String content = null;
  67. // for(Map<String,Object> code:warrantyCode){
  68. // Blob blob = (Blob) code.get("warrantyCode");
  69. // try {
  70. // content = new String(blob.getBytes((long)1, (int)blob.length()));
  71. // String string = content.substring(0,content.length()-2);
  72. // System.out.println(string);
  73. // list.add(string);
  74. // } catch (SQLException throwables) {
  75. // throwables.printStackTrace();
  76. // }
  77. // }
  78. //
  79. // return list;
  80. // }
  81. @Override
  82. public List<String> getWarranty(String orderNumber) {
  83. List<String> list = new ArrayList<>();
  84. //回传金蝶
  85. //根据orderNumber查询
  86. Map<String,Object> map = getWarrantyToES(orderNumber);
  87. String string = null;
  88. try{
  89. string = joinFeign.sendWarranty(map);
  90. Map<String,Object> waMap = JSON.parseObject(string);
  91. //成功
  92. if(waMap.get("kdStatus").equals("1")){
  93. List<Map<String,Object>> reportList = (List<Map<String,Object>>) waMap.get("qcReportList");
  94. Map<String,Object> map1 = reportList.get(0);
  95. Iterator<Map.Entry<String, Object>> it = map1.entrySet().iterator();
  96. Map.Entry<String,Object> entry;
  97. while(it.hasNext()){
  98. entry = it.next();
  99. String value = (String) entry.getValue();
  100. list.add(value);
  101. }
  102. } //失败
  103. else{
  104. list.add("-1");
  105. }
  106. }catch (NullPointerException e){
  107. e.printStackTrace();
  108. list.add("-2");
  109. }
  110. return list;
  111. }
  112. @Override
  113. public List<String> getTest(Map<String, Object> map) {
  114. List<String> list = new ArrayList<>();
  115. //成功
  116. if(map.get("kdStatus").equals("1")){
  117. List<Map<String,Object>> reportList = (List<Map<String,Object>>) map.get("qcReportList");
  118. Map<String,Object> map1 = reportList.get(0);
  119. Iterator<Map.Entry<String, Object>> it = map1.entrySet().iterator();
  120. Map.Entry<String,Object> entry;
  121. while(it.hasNext()){
  122. entry = it.next();
  123. String value = (String) entry.getValue();
  124. list.add(value);
  125. }
  126. }//失败
  127. else{
  128. list.add("0");
  129. }
  130. return list;
  131. }
  132. //出库与金蝶打通接口(获得质保书)
  133. public Map<String,Object> getWarrantyToES(String orderNumber) {
  134. Map<String, Object> input = new HashMap<>();
  135. Map<String, Object> head = universalMapper.selectNum(orderNumber);
  136. input.put("head", head);
  137. List<Map<String, Object>> mapList = universalMapper.selectOutbound(orderNumber);
  138. input.put("entries",mapList);
  139. Map<String,Object> totalMap = esUtil.getTotalMap();
  140. //组装报文
  141. totalMap.put("input",input);
  142. return totalMap;
  143. }
  144. /**
  145. * sha1加密字符串
  146. * @param text
  147. * @return
  148. */
  149. public String sha1DigestUtils(String text){
  150. return DigestUtils.sha1Hex(text);
  151. }
  152. /**
  153. * 根据收货客户查询承运商
  154. */
  155. public Map<String, Object> getCarrierByConsignee(Map<String, Object> mapValue){
  156. String isSelfMention = (String) mapValue.get("isSelfMention");
  157. String consigneeName = (String) mapValue.get("consigneeName");
  158. Map<String, Object> map = new HashMap<>();
  159. if (isSelfMention.equals("是")) {
  160. map = universalMapper.getCarrierByConsignee(consigneeName);
  161. }
  162. else {
  163. map.put("carrierId",null);
  164. map.put("carrierName",null);
  165. }
  166. return map;
  167. }
  168. /**
  169. *
  170. * @param mapValue
  171. * @return
  172. */
  173. public Map<String, Object> isInCapacityCarrier(Map<String, Object> mapValue) {
  174. BigDecimal capacityCarrierId = universalMapper.isInCapacityCarrier(mapValue);
  175. BigDecimal capacityId = universalMapper.isInCapacity(mapValue);
  176. Map<String,Object> map = new HashMap<>();
  177. map.put("capacityCarrierId",capacityCarrierId);
  178. map.put("capacityId",capacityId);
  179. return map;
  180. }
  181. public List<Map<String, Object>> getPortId() {
  182. return universalMapper.getPortId();
  183. }
  184. //获取订单号以及订单号下的物资
  185. public Map<String, Object> getOrderNumber(String num) {
  186. return universalMapper.getOrderNumber(num);
  187. }
  188. public List<Map<String, Object>> getCapacityNumber(String num) {
  189. return universalMapper.getCapacityNumber(num);
  190. }
  191. public List<Map<String, Object>> getMaterialIdByOrderId(Integer orderId) {
  192. return universalMapper.getMaterialIdByOrderId(orderId);
  193. }
  194. public int recordingWeightResult(List<Map<String, Object>> mapList) throws IOException {
  195. String URL = "http://172.16.33.166:8066/api/v1/join/tmstruckweightresult/receiveTmsTruckWeightResult";
  196. String jsonData = null;
  197. String jsonString= JSON.toJSONString(mapList);
  198. jsonData = HTTPRequestUtils.send(URL, jsonString,"utf-8");
  199. if(!"null".equals(jsonData)){
  200. System.out.println(jsonData);
  201. HashMap hashMap = JSON.parseObject(jsonData, HashMap.class);
  202. String code = (String) hashMap.get("code");
  203. System.out.println(hashMap.get("code"));
  204. if("SUCCESS".equals(code)){
  205. return 1;
  206. }else{
  207. return 0;
  208. }
  209. }else{
  210. System.out.println("补录委托失败:" + jsonData);
  211. return 0;
  212. }
  213. }
  214. /**
  215. * 关闭过期运输订单
  216. * @return
  217. */
  218. //@Scheduled(cron = "0 0,5 8 * * ?")
  219. public void closePassedOrder() {
  220. List<Map<String,Object>> passedOrderList = universalMapper.findPassedOrder();
  221. System.out.println("关闭的未出厂过期订单如下:<" + passedOrderList + ">");
  222. int result=0;
  223. //int result = universalMapper.closePassedOrder();
  224. try {
  225. if (passedOrderList.isEmpty()){
  226. }else {
  227. for (Map<String, Object> map : passedOrderList) {
  228. BigDecimal orderId = (BigDecimal) map.get("orderId");
  229. //分两种情况关单
  230. //净重为0状态设为2,不为零设为7
  231. BigDecimal bigDecimal = universalMapper.sumNetWeight(orderId);
  232. if (bigDecimal.compareTo(BigDecimal.ZERO)!=0){
  233. result+=universalMapper.updateStatusTwo(orderId);
  234. }else {
  235. result+=universalMapper.updateStatusSeven(orderId);
  236. }
  237. /* BigDecimal capacityIdS=universalMapper.queueSingle(orderId);*/
  238. /*if (capacityIdS !=null){
  239. //删除单拼
  240. universalMapper.delectQueueS(capacityIdS);
  241. }*/
  242. /*//查询多拼的数据
  243. BigDecimal capacityIdM =universalMapper.queueMore(orderId);
  244. if (capacityIdM !=null){
  245. //删除多拼
  246. universalMapper.delectQueueM(capacityIdM);
  247. }
  248. //查询单拼的数据
  249. BigDecimal capacityIdS=universalMapper.queueSingle(orderId);
  250. if (capacityIdS !=null){
  251. //删除单拼
  252. universalMapper.delectQueueS(capacityIdS);
  253. }*/
  254. }
  255. }
  256. }catch (Exception e){
  257. }
  258. System.out.println("订单关闭数为:" + result);
  259. //return 1;
  260. }
  261. }