ERPServiceImpl.java 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317
  1. package com.uas.eis.service.Impl;
  2. import com.alibaba.fastjson.JSON;
  3. import com.alibaba.fastjson.JSONObject;
  4. import com.alibaba.fastjson.serializer.SerializerFeature;
  5. import com.uas.eis.core.support.TokenProperties;
  6. import com.uas.eis.dao.BaseDao;
  7. import com.uas.eis.dao.SqlRowList;
  8. import com.uas.eis.entity.*;
  9. import com.uas.eis.sdk.entity.ApiResult;
  10. import com.uas.eis.sdk.resp.ApiResponse;
  11. import com.uas.eis.service.ERPService;
  12. import com.uas.eis.utils.*;
  13. import org.slf4j.Logger;
  14. import org.slf4j.LoggerFactory;
  15. import org.springframework.beans.factory.annotation.Autowired;
  16. import org.springframework.jdbc.core.BeanPropertyRowMapper;
  17. import org.springframework.stereotype.Service;
  18. import java.util.ArrayList;
  19. import java.util.HashMap;
  20. import java.util.List;
  21. import java.util.Map;
  22. /**
  23. * @author koul
  24. * @email koul@usoftchina.com
  25. * @date 2021-12-06 18:27
  26. */
  27. @Service
  28. public class ERPServiceImpl implements ERPService {
  29. private final Logger logger = LoggerFactory.getLogger(this.getClass());
  30. private static Map<String,String> tokenConfig = TokenProperties.getAllProperty();
  31. @Autowired
  32. private BaseDao baseDao;
  33. @Override
  34. public ApiResult<String> syncProduct(String data) {
  35. Map<Object, Object> store = BaseUtil.parseFormStoreToMap(data);
  36. Product product = baseDao.getJdbcTemplate().queryForObject("select case when pr_kh_user='柏英特' or nvl(pr_kh_user,' ')=' ' then 'BYT' else nvl(cu_mescode,cu_code) end pr_kh_user,pr_code ,pr_detail ,replace(PR_SPEC,'''','''''') pr_spec,nvl(pr_unit,'PCS') pr_unit,nvl(pr_cop,'BYT') pr_cop,nvl(pr_version,'0') pr_version,case when nvl(pr_kind,'')='半成品' or nvl(pr_kind,' ')='成品' then 'product' else 'raw' end pr_serial,nvl(pr_validdays,'0') pr_validdays,pr_msdlevel ,pr_fhelpcode ,pr_f_115 ,pr_f_116 ,pr_f_102,pr_kind,flag,pr_statuscode,pr_status,pr_whcode,pr_kind3,pr_kind2 from mes_product left join customer on pr_kh_user=cu_shortname where pr_id=?",
  37. new BeanPropertyRowMapper<Product>(Product.class),store.get("pr_id"));
  38. //获取MES对应仓库
  39. String prWhcode = product.getPr_whcode();
  40. if (prWhcode!=null&&!"".equals(prWhcode)) {
  41. SqlRowList rs = baseDao.queryForRowSet("select * from customtabledetail left join customtable on ct_id=cd_ctid where ct_caller='MESWarehouse' and ct_statuscode='AUDITED' and cd_varchar50_3='" + prWhcode + "' order by ct_id desc,cd_id desc");
  42. if (rs.next()){
  43. product.setPr_whcode(rs.getGeneralString("cd_varchar50_1"));
  44. }
  45. }
  46. product.setFlag(Integer.parseInt(StringUtil.nvl(store.get("flag"),"-1")));
  47. product.setMesUser(tokenConfig.get("mesUser"));
  48. product.setMesPwd(MD5Util.encodeByMD5(tokenConfig.get("mesPwd")));
  49. return syncMES(JSON.toJSONString(product, SerializerFeature.WriteMapNullValue).replace("null","\"\""),tokenConfig.get("syncProduct"));
  50. }
  51. @Override
  52. public ApiResult<String> syncMakeBase(String data) {
  53. Map<Object, Object> store = BaseUtil.parseFormStoreToMap(data);
  54. Make make = baseDao.getJdbcTemplate().queryForObject("select ma_code,ma_prodcode,ma_qty,nvl(cu_mescode,ma_custcode) ma_custcode,pr_unit,pr_detail,replace(PR_SPEC,'''','''''') pr_spec,ma_salecode,to_char(ma_planbegindate,'yyyy-MM-dd') ma_planbegindate,to_char(ma_planenddate,'yyyy-MM-dd') ma_planenddate,nvl(ma_cop,'BYT') ma_cop,'S' status,to_char(ma_date,'yyyy-MM-dd HH24:mi:ss') ma_date,ma_recorder,nvl(ma_version,0) ma_version,ma_id,wc_id,pr_id,to_char(ma_modifydate,'yyyy-MM-dd HH24:mi:ss') ma_modifydate,ma_modifier from make left join product on ma_prodcode=pr_code left join workcenter on ma_wccode=wc_code left join customer on ma_custcode=cu_code where ma_id=?",
  55. new BeanPropertyRowMapper<Make>(Make.class),store.get("ma_id"));
  56. make.setFlag(Integer.parseInt(StringUtil.nvl(store.get("flag"),"-1")));
  57. make.setMesPwd(MD5Util.encodeByMD5(tokenConfig.get("mesPwd")));
  58. make.setMesUser(tokenConfig.get("mesUser"));
  59. return syncMES(JSON.toJSONString(make, SerializerFeature.WriteMapNullValue).replace("null","\"\""),tokenConfig.get("syncMakeBase"));
  60. }
  61. @Override
  62. public ApiResult<String> syncMakeBaseDetail(String data) {
  63. Map<Object, Object> store = BaseUtil.parseFormStoreToMap(data);
  64. MakeMaterial makeMaterial = baseDao.getJdbcTemplate().queryForObject("select mm_code,erpid,mm_prodcode,pr_detail,replace(PR_SPEC,'''','''''') pr_spec,pr_unit,mm_oneuseqty qty,mm_qty,mm_oneuseqty,case when mm_ifrep=-1 then 'alternative' else 'main' end type,bo_recorder,to_char(bo_date,'yyyy-MM-dd HH24:mi:ss') bo_date,nvl(bo_version,0) bo_version,nvl(bo_cop,'BYT') bo_cop,mm_repprodcode,mm_balance,nvl(cu_mescode,ma_custcode) ma_custcode,to_char(mc_indate,'yyyy-MM-dd HH24:mi:ss') mc_indate,mc_recorder,flag from mes_makematerial left join make on ma_id=mm_maid left join Product on mm_prodcode=pr_code left join bom on bo_id=mm_bomid left join MakeMaterialChangeDet on md_makecode=ma_code and md_mmdetno=mm_detno left join MakeMaterialChange on mc_id=md_mcid left join customer on ma_custcode=cu_code where mm_id=? order by mm_detno",
  65. new BeanPropertyRowMapper<MakeMaterial>(MakeMaterial.class),store.get("mm_id"));
  66. makeMaterial.setFlag(Integer.parseInt(StringUtil.nvl(store.get("flag"),"-1")));
  67. makeMaterial.setMesUser(tokenConfig.get("mesUser"));
  68. makeMaterial.setMesPwd(MD5Util.encodeByMD5(tokenConfig.get("mesPwd")));
  69. return syncMES(JSON.toJSONString(makeMaterial, SerializerFeature.WriteMapNullValue).replace("null","\"\""),tokenConfig.get("syncMakeBaseDetail"));
  70. }
  71. @Override
  72. public ApiResult<String> syncUpdateReceiveByErp(String data) {
  73. try {
  74. Map<Object, Object> store = BaseUtil.parseFormStoreToMap(data);
  75. VerifyApply verifyApply = baseDao.getJdbcTemplate().queryForObject("select va_id,va_mescode,va_code,to_char(va_date,'yyyy-MM-dd HH24:mi:ss') va_date,va_vendcode,va_vendname,va_currency,va_rate,va_paymentscode,va_payments,va_transport,va_sendcode,va_emcode,va_emname,va_departmentcode,va_department,va_recorder,'BYT' va_cop,va_remark,va_ancode,va_factory,0 version,va_type,va_pucode,case when nvl(va_pucode,' ')=' ' then 0 else (select pu_id from purchase where pu_code=va_pucode) end pu_id,va_status,1 posted,to_char(va_auditdate,'yyyy-MM-dd HH24:mi:ss') va_auditdate,va_auditman,va_custcode,va_custname from VerifyApply where va_id=?",
  76. new BeanPropertyRowMapper<VerifyApply>(VerifyApply.class), store.get("va_id"));
  77. SqlRowList rs = baseDao.queryForRowSet("select case when va_custcode='AR214' or nvl(va_custcode,' ')=' ' then 'BYT' else nvl(cu_mescode,cu_code) end cu_code,cu_name from verifyapply left join customer on va_custcode=cu_code where va_id="+store.get("va_id"));
  78. if (rs.next()){
  79. verifyApply.setVa_custcode(rs.getString("cu_code"));
  80. //verifyApply.setVa_custname(rs.getString("cu_name"));
  81. }
  82. verifyApply.setMesPwd(MD5Util.encodeByMD5(tokenConfig.get("mesPwd")));
  83. verifyApply.setMesUser(tokenConfig.get("mesUser"));
  84. verifyApply.setFlag(Integer.parseInt(StringUtil.nvl(store.get("flag"),"-1")));
  85. List<VerifyApplyDetail> verifyApplyDetails = baseDao.query("select vad_code,vad_prodcode,pr_detail,replace(PR_SPEC,'''','''''') pr_spec,pr_unit,va_recorder,va_date,pr_kh_user,cu_name,sum(nvl(vad_qty,0)) vad_qty,vad_salecode from ( select vad_code,vad_prodcode,pr_detail,pr_spec,pr_unit,vad_qty,va_recorder,to_char(va_date,'yyyy-MM-dd HH24:mi:ss') va_date,case when pr_kh_user='柏英特' or nvl(pr_kh_user,' ')=' ' then 'BYT' else nvl(cu_mescode,cu_code) end pr_kh_user,cu_name,vad_salecode from verifyapplydetail left join VerifyApply on va_id=vad_vaid left join product on vad_prodcode=pr_code left join customer on cu_shortname=pr_kh_user where nvl(vad_qty,0)>0 and vad_vaid="+store.get("va_id")+") group by vad_code,vad_prodcode,pr_detail,pr_spec,pr_unit,va_recorder,va_date,pr_kh_user,cu_name,vad_salecode", VerifyApplyDetail.class);
  86. verifyApply.setDetail(verifyApplyDetails);
  87. return syncMES(JSON.toJSONString(verifyApply, SerializerFeature.WriteMapNullValue).replace("null","\"\""),tokenConfig.get("syncUpdateReceiveByErp"));
  88. }catch (Exception e){
  89. logger.info("同步收料单异常信息:"+e.getMessage());
  90. e.printStackTrace();
  91. return ApiResponse.failRsp("104",e.getMessage());
  92. }
  93. }
  94. @Override
  95. public Map<String, Object> syncDeleteMake(String data) {
  96. Map<Object, Object> store = BaseUtil.parseFormStoreToMap(data);
  97. Object maId = store.get("ma_id");
  98. int flag = Integer.parseInt(StringUtil.nvl(store.get("flag"), "-1"));
  99. Map<String, Object> hashMap = new HashMap<>();
  100. hashMap.put("code", 0);
  101. int count = baseDao.getCount("select count(1) from mes_make where erpid="+maId);
  102. if (count>0) {
  103. Make make = baseDao.getJdbcTemplate().queryForObject("select ma_code,ma_prodcode,ma_qty,nvl(cu_mescode,'BYT') ma_custcode,pr_unit,pr_detail,replace(PR_SPEC,'''','''''') pr_spec,nvl(ma_zgrwl,ma_salecode) ma_salecode,to_char(ma_planbegindate,'yyyy-MM-dd') ma_planbegindate,to_char(ma_planenddate,'yyyy-MM-dd') ma_planenddate,nvl(ma_cop,'BYT') ma_cop,'C' status,to_char(ma_date,'yyyy-MM-dd HH24:mi:ss') ma_date,ma_recorder,0 ma_version,erpid,wc_id,nvl(mk_id,0) ma_kind,to_char(ma_modifydate,'yyyy-MM-dd HH24:mi:ss') ma_modifydate,ma_modifier," + flag + " flag from mes_make left join MakeKind on ma_kind=mk_name left join product on ma_prodcode=pr_code left join workcenter on ma_wccode=wc_code left join customer on pr_kh_user=cu_shortname where erpid=?", new BeanPropertyRowMapper<Make>(Make.class), maId);
  104. make.setMesPwd(MD5Util.encodeByMD5(tokenConfig.get("mesPwd")));
  105. make.setMesUser(tokenConfig.get("mesUser"));
  106. Map<String, Object> map = syncMESDeleteMake(JSON.toJSONString(make, SerializerFeature.WriteMapNullValue).replace("null", "\"\""), tokenConfig.get("syncMakeBase"));
  107. hashMap.put("code", -1);
  108. hashMap.put("msg", "删除工单异常,请联系MES处理!");
  109. if (map != null) {
  110. int code = Integer.parseInt(StringUtil.nvl(map.get("code"), "-1"));
  111. if (code == 0) {
  112. List<MakeMaterial> makeMaterials = baseDao.getJdbcTemplate().query("select mm_code,erpid,mm_prodcode,pr_detail,replace(PR_SPEC,'''','''''') pr_spec,pr_unit,mm_oneuseqty qty,mm_qty,mm_oneuseqty,'main' type,bo_recorder,to_char(bo_date,'yyyy-MM-dd HH24:mi:ss') bo_date,0 bo_version,nvl(bo_cop,'BYT') bo_cop,mm_prodcode mm_repprodcode,mm_balance,(select nvl(cu_mescode,'BYT') from Product left join customer on pr_kh_user=cu_shortname where pr_code=ma_prodcode) ma_custcode,to_char(mc_indate,'yyyy-MM-dd HH24:mi:ss') mc_indate,mc_recorder," + flag + " flag,0 rpid from mes_makematerial left join make on ma_id=mm_maid left join Product on mm_prodcode=pr_code left join bom on bo_id=mm_bomid left join (select max(mc_indate) mc_indate,max(mc_recorder) mc_recorder,max(md_mmdetno) md_mmdetno,max(md_makecode) md_makecode from MakeMaterialChangeDet left join MakeMaterialChange on mc_id=md_mcid) on md_makecode=ma_code and md_mmdetno=mm_detno where erpid is not null and mm_maid=" + maId + " order by mm_detno", new Object[]{},new BeanPropertyRowMapper<MakeMaterial>(MakeMaterial.class));
  113. for (MakeMaterial makeMaterial: makeMaterials) {
  114. makeMaterial.setMesUser(tokenConfig.get("mesUser"));
  115. makeMaterial.setMesPwd(MD5Util.encodeByMD5(tokenConfig.get("mesPwd")));
  116. Map<String, Object> map1 = syncMESDeleteMake(JSON.toJSONString(makeMaterial, SerializerFeature.WriteMapNullValue).replace("null", "\"\""), tokenConfig.get("syncMakeBaseDetail"));
  117. hashMap.put("msg", "删除BOM异常,请联系MES处理!");
  118. if (map1 != null) {
  119. int code1 = Integer.parseInt(StringUtil.nvl(map1.get("code"), "-1"));
  120. hashMap.put("code", code1);
  121. hashMap.put("msg", map1.get("msg"));
  122. }
  123. }
  124. List<MakeMaterial> makeMaterials2 = baseDao.getJdbcTemplate().query("select mm.mm_code,mm.erpid,mr.mp_prodcode mm_prodcode,pr_detail,replace(PR_SPEC,'''','''''') pr_spec,pr_unit,mm.mm_oneuseqty qty,mr.mp_canuseqty mm_qty,mm.mm_oneuseqty,'alternative' type,bo_recorder,to_char(bo_date,'yyyy-MM-dd HH24:mi:ss') bo_date,0 bo_version,nvl(bo_cop,'BYT') bo_cop,mm.mm_prodcode mm_repprodcode,mm.mm_balance,(select nvl(cu_mescode,'BYT') from Product left join customer on pr_kh_user=cu_shortname where pr_code=ma_prodcode) ma_custcode,to_char(mc_indate,'yyyy-MM-dd HH24:mi:ss') mc_indate,mc_recorder," + flag + " flag,mr.erpid rpid from mes_makematerialreplace mr left join mes_makematerial mm on mr.mp_mmid=mm.erpid left join make on mm.mm_maid=ma_id left join Product on mr.mp_prodcode=pr_code left join bom on bo_id=mm.mm_bomid left join (select max(mc_indate) mc_indate,max(mc_recorder) mc_recorder,max(md_mmdetno) md_mmdetno,max(md_makecode) md_makecode from MakeMaterialChangeDet left join MakeMaterialChange on mc_id=md_mcid) on md_makecode=ma_code and md_mmdetno=mm.mm_detno where mm.erpid is not null and mr.mp_maid="+ maId,new Object[]{},new BeanPropertyRowMapper<MakeMaterial>(MakeMaterial.class));
  125. for (MakeMaterial makeMaterial: makeMaterials2) {
  126. makeMaterial.setMesUser(tokenConfig.get("mesUser"));
  127. makeMaterial.setMesPwd(MD5Util.encodeByMD5(tokenConfig.get("mesPwd")));
  128. Map<String, Object> map2 = syncMESDeleteMake(JSON.toJSONString(makeMaterial, SerializerFeature.WriteMapNullValue).replace("null", "\"\""), tokenConfig.get("syncMakeBaseDetail"));
  129. hashMap.put("msg", "删除替代料异常,请联系MES处理!");
  130. if (map2 != null) {
  131. int code2 = Integer.parseInt(StringUtil.nvl(map2.get("code"), "-1"));
  132. hashMap.put("code", code2);
  133. hashMap.put("msg", map2.get("msg"));
  134. }
  135. }
  136. }
  137. hashMap.put("code", code);
  138. hashMap.put("msg", map.get("msg"));
  139. }
  140. }
  141. return hashMap;
  142. }
  143. @Override
  144. public ApiResult<String> syncProdInOutMakeGive(String data) {
  145. try {
  146. Map<Object, Object> store = BaseUtil.parseFormStoreToMap(data);
  147. String mesUser = tokenConfig.get("mesUser");
  148. String mesPwd = MD5Util.encodeByMD5(tokenConfig.get("mesPwd"));
  149. int flag = Integer.parseInt(StringUtil.nvl(store.get("flag"), "-1"));
  150. ProdInOutMakeGive prodInOutMakeGive = baseDao.getJdbcTemplate().queryForObject("select '"+mesUser+"' mesUser,'"+mesPwd+"' mesPwd,(select wm_concat(distinct pd_ordercode) from prodiodetail where pd_piid=pi_id) maCodes,pi_inoutno from prodinout where pi_id=?",
  151. new BeanPropertyRowMapper<ProdInOutMakeGive>(ProdInOutMakeGive.class), store.get("pi_id"));
  152. List<ProdInOutMakeGiveDetail> prodInOutMakeGiveDetails = baseDao.query("select pd_ordercode,mm_id,pd_prodcode,pd_outqty," +
  153. "'BYT' pi_cop,pi_recordman,to_char(pi_recorddate,'yyyy-MM-dd HH24:mi:ss') pi_recorddate,pi_updateman," +
  154. "case when pi_updatedate is not null then to_char(pi_updatedate,'yyyy-MM-dd HH24:mi:ss') else null end pi_updatedate,"+flag+" flag " +
  155. "from prodiodetail left join prodinout on pd_piid=pi_id left join product on pd_prodcode=pr_code left join customer on cu_shortname=pr_kh_user left join MakeMaterial on pd_ordercode=mm_code and pd_orderdetno=mm_detno where nvl(pd_outqty,0)>nvl((select sum(ba_remain) from batch where nvl(ba_macode,' ')=pd_ordercode and pd_prodcode=ba_prodcode and ba_whcode in (select wh_code from Warehouse where wh_statuscode='AUDITED' and wh_description like '%线边仓%') and nvl(ba_remain,0)>0),0) and pi_id=" + store.get("pi_id"), ProdInOutMakeGiveDetail.class);
  156. prodInOutMakeGive.setDetail(prodInOutMakeGiveDetails);
  157. return syncMES(JSON.toJSONString(prodInOutMakeGive, SerializerFeature.WriteMapNullValue).replace("null","\"\""),tokenConfig.get("syncProdInOutMakeGive"));
  158. }catch (Exception e){
  159. logger.error("同步补料单异常信息:"+e.getMessage());
  160. e.printStackTrace();
  161. return ApiResponse.failRsp("104",e.getMessage());
  162. }
  163. }
  164. @Override
  165. public Map<String, Object> checkProdBomItem(String data) {
  166. Map<String, Object> hashMap = new HashMap<>();
  167. hashMap.put("code", 0);
  168. hashMap.put("msg", "参数异常,请联系管理员!");
  169. System.err.println(JSONObject.parseObject(data));
  170. System.err.println(JSON.toJSONString(data));
  171. Map<String, Object> map = syncMESCheckBomItems(JSON.toJSONString(JSONObject.parseObject(data)).replace("null", "\"\""), tokenConfig.get("syncMakeMaterialCheck"));
  172. if (map != null) {
  173. int msgId = Integer.parseInt(StringUtil.nvl(map.get("code"), "-1"));
  174. hashMap.put("code", msgId);
  175. hashMap.put("msg", map.get("msg"));
  176. }
  177. return hashMap;
  178. }
  179. @Override
  180. public Map<String, Object> updateChangeOrderByErp(String data) {
  181. Map<String, Object> hashMap = new HashMap<>();
  182. hashMap.put("code", 0);
  183. hashMap.put("msg", "参数异常,请联系管理员!");
  184. List<Map<Object, Object>> maps = BaseUtil.parseGridStoreToMaps(data);
  185. List<EcrMakeDetail> ecrMakeDetails = new ArrayList<>();
  186. Map<String, Object> ma = new HashMap<>();
  187. for (Map<Object, Object> store:maps) {
  188. String s = store.get("STATUS") == null ? "" : store.get("STATUS").toString();
  189. String status = "AUDITED".equals(s) ? "已审核" : "COMMITED".equals(s) ? "已提交" : "已删除";
  190. EcrMakeDetail ecrMakeDetail = baseDao.getJdbcTemplate().queryForObject("select ecr_code,emd_macode,ecr_tempg,ecr_tempb,ecr_tempc,'" + status + "' status,case when nvl(emd_ifzhix,0)=0 then '否' else '是' end emd_ifzhix,emd_controlpoint,emd_detno||'' emd_detno from ecrmakedetail left join ecr on ecr_id=emd_ecrid where emd_id=?",
  191. new BeanPropertyRowMapper<EcrMakeDetail>(EcrMakeDetail.class), store.get("ID"));
  192. ecrMakeDetail.setMesUser(tokenConfig.get("mesUser"));
  193. ecrMakeDetail.setMesPwd(MD5Util.encodeByMD5(tokenConfig.get("mesPwd")));
  194. ecrMakeDetails.add(ecrMakeDetail);
  195. }
  196. ma.put("Data",ecrMakeDetails);
  197. Map<String, Object> map = syncMESCheckBomItems(JSON.toJSONString(ma, SerializerFeature.WriteMapNullValue).replace("null", "\"\""), tokenConfig.get("updateChangeOrderByErp"));
  198. if (map != null) {
  199. int msgId = Integer.parseInt(StringUtil.nvl(map.get("code"), "-1"));
  200. hashMap.put("code", msgId);
  201. hashMap.put("msg", map.get("msg"));
  202. }
  203. return hashMap;
  204. }
  205. @Override
  206. public Map<String, Object> syncMakeScrap(String data) {
  207. Map<Object, Object> store = BaseUtil.parseFormStoreToMap(data);
  208. Object msId = store.get("ms_id");
  209. String mesUser = tokenConfig.get("mesUser");
  210. String mesPwd = MD5Util.encodeByMD5(tokenConfig.get("mesPwd"));
  211. int flag = Integer.parseInt(StringUtil.nvl(store.get("flag"), "-1"));
  212. Map<String, Object> hashMap = new HashMap<>();
  213. hashMap.put("code", 0);
  214. int count = baseDao.getCount("select count(1) from MakeScrap where ms_id="+msId);
  215. if (count>0) {
  216. List<MakeScrapDetail> makeScrapDetail = baseDao.getJdbcTemplate().query("select ms_code,ms_id,md_detno,1 issw,md_mmcode,md_mmdetno,md_prodcode,mm_prodcode,md_qty,"+mesUser+" mesUser,"+mesPwd+" mesPwd,"+flag+" flag from MakeScrap left join MakeScrapDetail on ms_id=md_msid left join MakeMaterial on mm_code=md_mmcode and mm_detno=md_mmdetno where ms_id="+ msId,new Object[]{},new BeanPropertyRowMapper<MakeScrapDetail>(MakeScrapDetail.class));
  217. Map<String, Object> map = syncMESDeleteMake(JSON.toJSONString(makeScrapDetail, SerializerFeature.WriteMapNullValue).replace("null", "\"\""), tokenConfig.get("syncMakeScrap"));
  218. hashMap.put("code", -1);
  219. hashMap.put("msg", "MES异常,请联系MES处理!");
  220. if (map != null&&map.isEmpty()) {
  221. int code = Integer.parseInt(StringUtil.nvl(map.get("code"), "-1"));
  222. hashMap.put("code", code);
  223. hashMap.put("msg", map.get("msg"));
  224. }
  225. }
  226. return hashMap;
  227. }
  228. private ApiResult<String> syncMES(String params,String url) {
  229. try {
  230. logger.info("params:" + params);
  231. String post = PSHttpUtils.sendPost(tokenConfig.get("mesHttp") + url, params);
  232. logger.info("post:" + post);
  233. JSONObject jsonObject = JSON.parseObject(post);
  234. int code = jsonObject.getIntValue("result");
  235. if (code == 0) {
  236. return ApiResponse.successRsp("0", "同步MES成功");
  237. } else if (code == 1) {
  238. return ApiResponse.failRsp("101", jsonObject.getString("message"));
  239. } else {
  240. return ApiResponse.failRsp("102", "接口调用异常,请联系MES处理!");
  241. }
  242. } catch (Exception e) {
  243. logger.info("异常信息:" + e.getMessage());
  244. return ApiResponse.failRsp("103", "接口调用异常,请联系MES处理!");
  245. }
  246. }
  247. private Map<String, Object> syncMESDeleteMake(String params,String url){
  248. Map<String, Object> map = new HashMap<>();
  249. map.put("code",-1);
  250. logger.info("params:"+params);
  251. try {
  252. String post = PSHttpUtils.sendPost(tokenConfig.get("mesHttp") + url, params);
  253. logger.info("post:"+post);
  254. JSONObject jsonObject = JSON.parseObject(post);
  255. int code = jsonObject.getIntValue("result");
  256. if (code==0){
  257. map.put("code",code);
  258. map.put("msg","同步MES成功");
  259. }else if(code==1){
  260. map.put("code",code);
  261. map.put("msg",jsonObject.getString("message"));
  262. }else {
  263. map.put("msg","接口调用异常,错误代码:"+code+",请联系MES处理!");
  264. }
  265. }catch (Exception e){
  266. map.put("msg","接口调用异常,异常信息:"+e.getMessage()+",请联系MES处理!");
  267. logger.info("异常信息:"+e.getMessage());
  268. e.printStackTrace();
  269. }
  270. return map;
  271. }
  272. private Map<String, Object> syncMESCheckBomItems(String params,String url){
  273. Map<String, Object> map = new HashMap<>();
  274. map.put("code",-1);
  275. logger.info("params:"+params);
  276. try {
  277. String post = PSHttpUtils.sendPost(tokenConfig.get("mesHttp") + url, params);
  278. logger.info("post:"+post);
  279. JSONObject jsonObject = JSON.parseObject(post);
  280. int code = jsonObject.getIntValue("msgId");
  281. if (code==0){
  282. map.put("code",code);
  283. map.put("msg","同步MES成功");
  284. }else if(code==1){
  285. map.put("code",code);
  286. map.put("msg",jsonObject.getString("msgStr"));
  287. }else {
  288. map.put("msg","接口调用异常,错误代码:"+code+",请联系MES处理!");
  289. }
  290. }catch (Exception e){
  291. map.put("msg","接口调用异常,异常信息:"+e.getMessage()+",请联系MES处理!");
  292. logger.info("异常信息:"+e.getMessage());
  293. e.printStackTrace();
  294. }
  295. return map;
  296. }
  297. }