OWbInveMngServiceImpl.java 9.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306
  1. package com.emato.biz.service.impl;
  2. import java.io.IOException;
  3. import java.util.*;
  4. import cn.hutool.http.HttpException;
  5. import cn.hutool.http.HttpRequest;
  6. import com.alibaba.fastjson.JSON;
  7. import com.alibaba.fastjson.JSONArray;
  8. import com.alibaba.fastjson.JSONObject;
  9. import com.emato.biz.config.OmsConfig;
  10. import com.emato.biz.domain.warehouse.PullInveQueryVO;
  11. import com.emato.biz.mapper.warehouse.WbInveMngMapper;
  12. import com.emato.common.core.domain.AjaxResult;
  13. import com.emato.common.exception.ServiceException;
  14. import com.emato.common.utils.DateUtils;
  15. import com.emato.common.utils.oms.JacksonUtils;
  16. import com.emato.common.utils.oms.OkHttpUtils;
  17. import com.emato.common.utils.oms.request.OmsSign;
  18. import okhttp3.Request;
  19. import org.apache.http.HttpStatus;
  20. import org.apache.http.client.methods.CloseableHttpResponse;
  21. import org.apache.http.client.methods.HttpPost;
  22. import org.apache.http.entity.StringEntity;
  23. import org.apache.http.impl.client.CloseableHttpClient;
  24. import org.apache.http.impl.client.HttpClients;
  25. import org.apache.http.util.EntityUtils;
  26. import org.slf4j.Logger;
  27. import org.slf4j.LoggerFactory;
  28. import org.springframework.beans.factory.annotation.Autowired;
  29. import org.springframework.stereotype.Service;
  30. import com.emato.biz.mapper.warehouse.OWbInveMngMapper;
  31. import com.emato.biz.domain.warehouse.OWbInveMng;
  32. import com.emato.biz.service.warehouse.IOWbInveMngService;
  33. import org.springframework.transaction.annotation.Transactional;
  34. import javax.annotation.Resource;
  35. /**
  36. * 库存管理,wms入库回传时,增加库存数Service业务层处理
  37. *
  38. * @author yangbo
  39. * @date 2021-02-01
  40. */
  41. @Service
  42. public class OWbInveMngServiceImpl implements IOWbInveMngService
  43. {
  44. @Resource
  45. private OWbInveMngMapper oWbInveMngMapper;
  46. @Resource
  47. private WbInveMngMapper wbInveMngMapper;
  48. private static final Logger log = LoggerFactory.getLogger(OWbInveMngServiceImpl.class);
  49. /**
  50. * 根据条件拉取 OMS 数据
  51. *
  52. * @param queryVO
  53. * @return
  54. */
  55. @Override
  56. public AjaxResult pullInveMng(PullInveQueryVO queryVO) {
  57. // 构建请求报文
  58. // 初始化请求 oms 参数 Map
  59. Map<String, String> reqOmsPram = new TreeMap<>();
  60. queryVO.setThirdMerchId("tmb770630141444423680");
  61. // 请求 oms 数据
  62. reqOmsPram.put("data", JacksonUtils.toJsonStr(queryVO));
  63. // 请求 oms 商户号
  64. reqOmsPram.put("merchId", OmsConfig.getMerchSn());
  65. log.debug("===== 请求 oms 商户号 ====> {}", OmsConfig.getMerchSn());
  66. // 请求 oms 时间戳
  67. String timestamp = System.currentTimeMillis()/1000 + "";
  68. reqOmsPram.put("timestamp", timestamp);
  69. log.debug("===== 请求 oms 时间戳 ====> {}", timestamp);
  70. // 请求 oms 签名
  71. String sign = OmsSign.sign(reqOmsPram, OmsConfig.getMd5Salt());
  72. reqOmsPram.put("sign", sign);
  73. // oms 请求地址
  74. String url = OmsConfig.getQueryMngInveUrl();
  75. log.debug("===== 请求 oms 地址 ====> {}", url);
  76. // 请求 oms 报文
  77. String reqBody = JacksonUtils.toJsonStr(reqOmsPram);
  78. log.debug("===== 请求 oms 报文 ====> {}", reqBody);
  79. // oms 返回数据
  80. String body = null;
  81. try {
  82. body = HttpRequest.post(url)
  83. .body(JacksonUtils.toJsonStr(reqOmsPram))
  84. .execute()
  85. .body();
  86. } catch (Exception e) {
  87. throw new ServiceException("请求 OMS 异常!");
  88. }
  89. log.debug("OMS 响应信息 => {}", body);
  90. // 获取响应,入库
  91. return AjaxResult.success("拉取库存成功!");
  92. }
  93. /**
  94. * 查询库存管理,wms入库回传时,增加库存数
  95. *
  96. * @param inveSn 库存管理,wms入库回传时,增加库存数ID
  97. * @return 库存管理,wms入库回传时,增加库存数
  98. */
  99. @Override
  100. public OWbInveMng selectOWbInveMngById(String inveSn)
  101. {
  102. return oWbInveMngMapper.selectOWbInveMngById(inveSn);
  103. }
  104. /**
  105. * 查询库存管理,wms入库回传时,增加库存数列表
  106. *
  107. * @param oWbInveMng 库存管理,wms入库回传时,增加库存数
  108. * @return 库存管理,wms入库回传时,增加库存数
  109. */
  110. @Override
  111. public List<OWbInveMng> selectOWbInveMngList(OWbInveMng oWbInveMng)
  112. {
  113. return wbInveMngMapper.selectWbInveMngList(oWbInveMng);
  114. }
  115. /**
  116. * 新增库存管理,wms入库回传时,增加库存数
  117. *
  118. * @param oWbInveMng 库存管理,wms入库回传时,增加库存数
  119. * @return 结果
  120. */
  121. @Override
  122. public int insertOWbInveMng(OWbInveMng oWbInveMng)
  123. {
  124. oWbInveMng.setCreateTime(DateUtils.getNowDate());
  125. return oWbInveMngMapper.insertOWbInveMng(oWbInveMng);
  126. }
  127. /**
  128. * 修改库存管理,wms入库回传时,增加库存数
  129. *
  130. * @param oWbInveMng 库存管理,wms入库回传时,增加库存数
  131. * @return 结果
  132. */
  133. @Override
  134. public int updateOWbInveMng(OWbInveMng oWbInveMng)
  135. {
  136. return oWbInveMngMapper.updateOWbInveMng(oWbInveMng);
  137. }
  138. /**
  139. * 批量删除库存管理,wms入库回传时,增加库存数
  140. *
  141. * @param inveSns 需要删除的库存管理,wms入库回传时,增加库存数ID
  142. * @return 结果
  143. */
  144. @Override
  145. public int deleteOWbInveMngByIds(String[] inveSns)
  146. {
  147. return oWbInveMngMapper.deleteOWbInveMngByIds(inveSns);
  148. }
  149. /**
  150. * 删除库存管理,wms入库回传时,增加库存数信息
  151. *
  152. * @param inveSn 库存管理,wms入库回传时,增加库存数ID
  153. * @return 结果
  154. */
  155. @Override
  156. public int deleteOWbInveMngById(String inveSn)
  157. {
  158. return oWbInveMngMapper.deleteOWbInveMngById(inveSn);
  159. }
  160. /**
  161. * 根据商户编号去拉取数据
  162. *
  163. * @param merchSn
  164. * @return
  165. */
  166. @Override
  167. @Transactional
  168. public int pullInveMng(String merchSn) {
  169. int page = 1;
  170. Integer querySize = OmsConfig.getQuerySize();
  171. int resultCode = pullInveMngFromOms(merchSn,page, querySize);
  172. while(resultCode != 1){
  173. page = page + 1;
  174. resultCode = pullInveMngFromOms(merchSn, page, querySize);
  175. }
  176. return resultCode==0?1:resultCode;
  177. }
  178. private int pullInveMngFromOms(String merchSn, int page, Integer querySize) {
  179. Map<String,String> data = new HashMap();
  180. data.put("merchId",merchSn);
  181. data.put("page",page+"");
  182. data.put("limit",querySize.toString());
  183. Map sParaTemp = new TreeMap();
  184. sParaTemp.put("data", JSON.toJSONString(data));
  185. sParaTemp.put("merchId",OmsConfig.getMerchSn());
  186. String timestamp = String.valueOf(System.currentTimeMillis()/1000);
  187. sParaTemp.put("timestamp", timestamp);
  188. //生成要请求给oms秘钥
  189. log.info("md5混淆码参数:" + OmsConfig.getMd5Salt());
  190. String sign = OmsSign.sign(sParaTemp,OmsConfig.getMd5Salt());
  191. sParaTemp.put("sign", sign);
  192. //构建Request
  193. String url = OmsConfig.getQueryMngInveUrl();
  194. String jsonParam = JSONObject.toJSONString(sParaTemp);
  195. log.info("Eccs 请求 OMS url => {}, 请求 OMS 报文 => {}", url, jsonParam);
  196. // 同步访问,返回结果字符串
  197. String responseString = null;
  198. try {
  199. JSONObject jsonObject = httpPost(url,JSONObject.parseObject(jsonParam));
  200. log.info("oms的响应报文"+jsonObject.toString());
  201. //解析响应数据
  202. JSONArray result = (JSONArray) jsonObject.get("data");
  203. Object msg = jsonObject.get("msg");
  204. Object code = jsonObject.get("code");
  205. if(result == null || result.size() == 0){
  206. return 1;
  207. }
  208. for(int i = 0 ; i < result.size(); i ++){
  209. JSONObject o = (JSONObject) result.get(i);
  210. OWbInveMng oWbInveMng = o.toJavaObject(OWbInveMng.class);
  211. //oWbInveMngMapper.saveOrUpdate(oWbInveMng);
  212. wbInveMngMapper.saveOrUpdate(oWbInveMng);
  213. }
  214. if("202".equals(code)){
  215. return 1;
  216. }
  217. } catch (Exception e) {
  218. log.error(e.getMessage());
  219. return 1;
  220. }
  221. return 0;
  222. }
  223. public static JSONObject httpPost(String url, JSONObject jsonParam)
  224. {
  225. // post请求返回结果
  226. CloseableHttpClient httpClient = HttpClients.createDefault();
  227. JSONObject jsonResult = null;
  228. HttpPost httpPost = new HttpPost(url);
  229. // 设置请求和传输超时时间
  230. // httpPost.setConfig(requestConfig);
  231. try
  232. {
  233. if (null != jsonParam)
  234. {
  235. // 解决中文乱码问题
  236. StringEntity entity = new StringEntity(jsonParam.toString(), "utf-8");
  237. entity.setContentEncoding("UTF-8");
  238. entity.setContentType("application/json");
  239. httpPost.setEntity(entity);
  240. }
  241. CloseableHttpResponse result = httpClient.execute(httpPost);
  242. // 请求发送成功,并得到响应
  243. if (result.getStatusLine().getStatusCode() == HttpStatus.SC_OK)
  244. {
  245. String str = "";
  246. try
  247. {
  248. // 读取服务器返回过来的json字符串数据
  249. str = EntityUtils.toString(result.getEntity(), "utf-8");
  250. // 把json字符串转换成json对象
  251. jsonResult = JSONObject.parseObject(str);
  252. }
  253. catch (Exception e)
  254. {
  255. log.error("post请求提交失败:" + url, e);
  256. }
  257. }
  258. }
  259. catch (IOException e)
  260. {
  261. log.error("post请求提交失败:" + url, e);
  262. }
  263. finally
  264. {
  265. httpPost.releaseConnection();
  266. }
  267. return jsonResult;
  268. }
  269. }