YdHuaGaoServiceImpl.java 56 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969
  1. package com.malk.huagao.service.impl;
  2. import cn.hutool.core.util.ObjectUtil;
  3. import com.alibaba.fastjson.JSON;
  4. import com.alibaba.fastjson.JSONObject;
  5. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  6. import com.malk.huagao.entity.*;
  7. import com.malk.huagao.mapper.*;
  8. import com.malk.huagao.service.YdHuaGaoService;
  9. import com.malk.server.aliwork.YDConf;
  10. import com.malk.server.aliwork.YDParam;
  11. import com.malk.server.dingtalk.DDConf;
  12. import com.malk.service.aliwork.YDClient;
  13. import com.malk.utils.UtilMap;
  14. import lombok.extern.slf4j.Slf4j;
  15. import org.checkerframework.checker.units.qual.A;
  16. import org.springframework.beans.factory.annotation.Autowired;
  17. import org.springframework.stereotype.Service;
  18. import java.math.BigDecimal;
  19. import java.time.LocalDateTime;
  20. import java.time.format.DateTimeFormatter;
  21. import java.util.*;
  22. import java.util.stream.Collectors;
  23. @Slf4j
  24. @Service
  25. public class YdHuaGaoServiceImpl implements YdHuaGaoService {
  26. @Autowired
  27. private KdYdCustomerMapper kdYdCustomerMapper;
  28. @Autowired
  29. private YDClient ydClient;
  30. @Autowired
  31. private KdYdCustomerReferrerMapper kdYdCustomerReferrerMapper;
  32. @Autowired
  33. private KdYdOrderMapper kdYdOrderMapper;
  34. @Autowired
  35. private KdYdDeliveryMapper kdYdDeliveryMapper;
  36. @Autowired
  37. private KdYdOutboundMapper kdYdOutboundMapper;
  38. @Autowired
  39. private KdYdReceivableMapper kdYdReceivableMapper;
  40. @Autowired
  41. private KdYdOutboundDetailMapper kdYdOutboundDetailMapper;
  42. @Autowired
  43. private KdYdReceivableDetailMapper kdYdReceivableDetailMapper;
  44. @Autowired
  45. private KdYdDeliveryDetailMapper kdYdDeliveryDetailMapper;
  46. @Autowired
  47. private KdYdPaymentReceiptDetailMapper kdYdPaymentReceiptDetailMapper;
  48. @Autowired
  49. private KdYdPaymentReceiptMapper kdYdPaymentReceiptMapper;
  50. @Autowired
  51. private KdYdReceivalablePaymentMapper kdYdReceivalablePaymentMapper;
  52. @Autowired
  53. private KdYdZpMapper kdYdZpMapper;
  54. @Autowired
  55. private KdYdMaterialMapper kdYdMaterialMapper;
  56. @Autowired
  57. private YDConf ydConf;
  58. @Autowired
  59. private DDConf ddConf;
  60. @Override
  61. public void syncKdYdCustomer() {
  62. }
  63. @Override
  64. public void syncKdYDcustomerLiaison() {
  65. log.info("定时同步-客户推荐人");
  66. try {
  67. LocalDateTime now = LocalDateTime.now();
  68. LocalDateTime fiveMinutesAgo = now.minusMinutes(5);
  69. DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
  70. List<KdYdCustomerReferrer> KdYdCustomerReferrers = kdYdCustomerReferrerMapper.selectRecentUpdated(fiveMinutesAgo);
  71. if (KdYdCustomerReferrers.isEmpty()) {
  72. log.info("【客户推荐人同步任务】无需要同步的数据,结束");
  73. return;
  74. }
  75. for (KdYdCustomerReferrer kdYdCustomerReferrer : KdYdCustomerReferrers) {
  76. try {
  77. String bm = kdYdCustomerReferrer.getBm();
  78. String tjruuid = kdYdCustomerReferrer.getTjruuid();
  79. String formInstId = kdYdCustomerReferrer.getFormInstId();
  80. if (ObjectUtil.hasEmpty(formInstId, bm)) {
  81. log.warn("跳过同步: formInstId 或 khbm 为空, customer={}", kdYdCustomerReferrer.getId());
  82. continue;
  83. }
  84. // if (tjruuid == null) {
  85. // List<Map> khdata = (List<Map>) ydClient.queryData(
  86. // YDParam.builder()
  87. // .formUuid("FORM-68154CC0A7054BF0B1C933752CD3881FB0SR")
  88. // .searchFieldJson(JSONObject.toJSONString(UtilMap.map("textField_mgqbiov3", tjruuid)))
  89. // .build(),
  90. // YDConf.FORM_QUERY.retrieve_list_all
  91. // ).getData();
  92. // if (khdata.size() > 0) {
  93. // khbm = UtilMap.getString(khdata.get(0), "textField_meqhqqvg");
  94. // }
  95. //// }
  96. // LambdaQueryWrapper<KdYdCustomer> YdCustomerLambdaQueryWrapper = new LambdaQueryWrapper<>();
  97. // YdCustomerLambdaQueryWrapper.eq(KdYdCustomer::getTjruuid, tjruuid);
  98. // KdYdCustomer kdYdCustomer1 = kdYdCustomerMapper.selectOne(YdCustomerLambdaQueryWrapper);
  99. // String formInstId1 = kdYdCustomer1.getFormInstId();
  100. // ydClient.operateData(
  101. // YDParam.builder()
  102. // .formInstanceId(formInstId1)
  103. // .updateFormDataJson(JSONObject.toJSONString(UtilMap.map("textField_mfdrrg87", bm)))
  104. // .useLatestVersion(true).build(), YDConf.FORM_OPERATION.update);
  105. ydClient.operateData(
  106. YDParam.builder()
  107. .formInstanceId(formInstId)
  108. .updateFormDataJson(JSONObject.toJSONString(UtilMap.map("textField_mgqbiouy", bm)))
  109. .useLatestVersion(true).build(), YDConf.FORM_OPERATION.update);
  110. } catch (Exception e) {
  111. log.error("同步单条客户推荐人数据异常: formInstId={}", kdYdCustomerReferrer.getFormInstId(), e);
  112. }
  113. }
  114. log.info("【客户推荐人同步任务】执行完成,共处理 {} 条记录", KdYdCustomerReferrers.size());
  115. } catch (Exception e) {
  116. log.error("【客户推荐人同步任务】执行过程中发生严重错误", e);
  117. }
  118. }
  119. @Override
  120. public void syncKdYdOrder() {
  121. log.info("定时同步-订单");
  122. try {
  123. LocalDateTime now = LocalDateTime.now();
  124. LocalDateTime fiveMinutesAgo = now.minusMinutes(5);
  125. DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
  126. List<KdYdOrder> KdYdOrders = kdYdOrderMapper.selectRecentUpdated(fiveMinutesAgo);
  127. if (KdYdOrders.isEmpty()) {
  128. log.info("【订单同步任务】无需要同步的数据,结束");
  129. return;
  130. }
  131. for (KdYdOrder kdYdOrder : KdYdOrders) {
  132. try {
  133. String bm = kdYdOrder.getDjbh();
  134. // String tjruuid = kdYdOrder.getTjruuid();
  135. String formInstId = kdYdOrder.getForminstid();
  136. if (ObjectUtil.hasEmpty(formInstId, bm)) {
  137. log.warn("跳过同步: formInstId 或 khbm 为空, customer={}", kdYdOrder.getId());
  138. continue;
  139. }
  140. // if (tjruuid == null) {
  141. // List<Map> khdata = (List<Map>) ydClient.queryData(
  142. // YDParam.builder()
  143. // .formUuid("FORM-68154CC0A7054BF0B1C933752CD3881FB0SR")
  144. // .searchFieldJson(JSONObject.toJSONString(UtilMap.map("textField_mgqbiov3", tjruuid)))
  145. // .build(),
  146. // YDConf.FORM_QUERY.retrieve_list_all
  147. // ).getData();
  148. // if (khdata.size() > 0) {
  149. // khbm = UtilMap.getString(khdata.get(0), "textField_meqhqqvg");
  150. // }
  151. //// }
  152. // LambdaQueryWrapper<KdYdCustomer> YdCustomerLambdaQueryWrapper = new LambdaQueryWrapper<>();
  153. // YdCustomerLambdaQueryWrapper.eq(KdYdCustomer::getTjruuid, tjruuid);
  154. // KdYdCustomer kdYdCustomer1 = kdYdCustomerMapper.selectOne(YdCustomerLambdaQueryWrapper);
  155. // String formInstId1 = kdYdCustomer1.getFormInstId();
  156. // ydClient.operateData(
  157. // YDParam.builder()
  158. // .formInstanceId(formInstId1)
  159. // .updateFormDataJson(JSONObject.toJSONString(UtilMap.map("textField_mfdrrg87", bm)))
  160. // .useLatestVersion(true).build(), YDConf.FORM_OPERATION.update);
  161. ydClient.operateData(
  162. YDParam.builder()
  163. .formInstanceId(formInstId)
  164. .updateFormDataJson(JSONObject.toJSONString(UtilMap.map("textField_mg327tqe", bm)))
  165. .useLatestVersion(true).build(), YDConf.FORM_OPERATION.update);
  166. } catch (Exception e) {
  167. log.error("同步单条订单数据异常: formInstId={}", kdYdOrder.getForminstid(), e);
  168. }
  169. }
  170. log.info("【订单同步任务】执行完成,共处理 {} 条记录", KdYdOrders.size());
  171. } catch (Exception e) {
  172. log.error("【订单同步任务】执行过程中发生严重错误", e);
  173. }
  174. }
  175. @Override
  176. public void syncKdYdDelivery() {
  177. log.info("定时同步-发货单");
  178. try {
  179. LocalDateTime now = LocalDateTime.now();
  180. LocalDateTime fiveMinutesAgo = now.minusMinutes(5);
  181. DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
  182. List<KdYdDelivery> KdYdDeliverys = kdYdDeliveryMapper.selectRecentUpdated(fiveMinutesAgo);
  183. if (KdYdDeliverys.isEmpty()) {
  184. log.info("【发货单同步任务】无需要同步的数据,结束");
  185. return;
  186. }
  187. for (KdYdDelivery kdYdDelivery : KdYdDeliverys) {
  188. try {
  189. String djbh = kdYdDelivery.getDjbh();
  190. // String tjruuid = kdYdOrder.getTjruuid();
  191. String formInstId = kdYdDelivery.getForminstid();
  192. if (ObjectUtil.hasEmpty(formInstId, djbh)) {
  193. log.warn("跳过同步: formInstId 或 khbm 为空, customer={}", kdYdDelivery.getId());
  194. continue;
  195. }
  196. ydClient.operateData(
  197. YDParam.builder()
  198. .formInstanceId(formInstId)
  199. .updateFormDataJson(JSONObject.toJSONString(UtilMap.map("textField_mg3fuqvh", djbh)))
  200. .useLatestVersion(true).build(), YDConf.FORM_OPERATION.update);
  201. } catch (Exception e) {
  202. log.error("同步单条发货单数据异常: formInstId={}", kdYdDelivery.getForminstid(), e);
  203. }
  204. }
  205. log.info("【发货单同步任务】执行完成,共处理 {} 条记录", KdYdDeliverys.size());
  206. } catch (Exception e) {
  207. log.error("【发货单同步任务】执行过程中发生严重错误", e);
  208. }
  209. }
  210. @Override
  211. public void synckdYdOutbound() {
  212. log.info("定时同步-出库单");
  213. LambdaQueryWrapper<KdYdOutbound> outboundqw = new LambdaQueryWrapper<>();
  214. outboundqw.eq(KdYdOutbound::getSyncStatus, "0");
  215. List<KdYdOutbound> kdYdOutbounds = kdYdOutboundMapper.selectList(outboundqw);
  216. if (kdYdOutbounds.isEmpty()) {
  217. log.info("【出库单同步任务】无需要同步的数据,结束");
  218. return;
  219. }
  220. log.info("【出库单同步任务】开始同步,共{}条数据", kdYdOutbounds.size());
  221. int successCount = 0;
  222. int failCount = 0;
  223. for (KdYdOutbound kdYdOutbound : kdYdOutbounds) {
  224. try {
  225. Long outboundId = kdYdOutbound.getId();
  226. String djbh = kdYdOutbound.getDjbh();
  227. String deliveryId = kdYdOutbound.getDeliveryId();
  228. log.debug("开始同步出库单: ID={}, 单据编号={}", outboundId, djbh);
  229. LambdaQueryWrapper<KdYdOutboundDetail> outbounddetailqw = new LambdaQueryWrapper<>();
  230. outbounddetailqw.eq(KdYdOutboundDetail::getOutboundId, outboundId)
  231. .orderByAsc(KdYdOutboundDetail::getDetailId);
  232. List<KdYdOutboundDetail> kdYdOutboundDetails = kdYdOutboundDetailMapper.selectList(outbounddetailqw);
  233. ArrayList<Object> tableList = new ArrayList<>();
  234. for (KdYdOutboundDetail kdYdOutboundDetail : kdYdOutboundDetails) {
  235. HashMap<String, String> tablemap = new HashMap<>();
  236. tablemap.put("textField_mejnamff", kdYdOutboundDetail.getWlbm());
  237. tablemap.put("textField_mejnamfg", kdYdOutboundDetail.getWlmc());
  238. tablemap.put("textField_mg34txh1", kdYdOutboundDetail.getTpsb());
  239. tablemap.put("textField_mejnamfh", kdYdOutboundDetail.getGgxh());
  240. tablemap.put("textField_mejnamfk", kdYdOutboundDetail.getKcdw());
  241. tablemap.put("numberField_mejnamfl", String.valueOf(kdYdOutboundDetail.getYfsl() != null ? kdYdOutboundDetail.getYfsl().setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP)));
  242. tablemap.put("numberField_mg34txh2", kdYdOutboundDetail.getSfsl() != null ? kdYdOutboundDetail.getSfsl().setScale(2, java.math.RoundingMode.HALF_UP).toString() : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP).toString());
  243. tablemap.put("numberField_mg34txh3", kdYdOutboundDetail.getDj() != null ? kdYdOutboundDetail.getDj().setScale(2, java.math.RoundingMode.HALF_UP).toString() : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP).toString());
  244. tablemap.put("numberField_mg34txh4", kdYdOutboundDetail.getHsdj() != null ? kdYdOutboundDetail.getHsdj().setScale(2, java.math.RoundingMode.HALF_UP).toString() : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP).toString());
  245. tablemap.put("textField_mg34txh5", kdYdOutboundDetail.getPh());
  246. tablemap.put("numberField_mg34txh6", kdYdOutboundDetail.getSl() != null ? kdYdOutboundDetail.getSl().setScale(2, java.math.RoundingMode.HALF_UP).toString() : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP).toString());
  247. tablemap.put("numberField_mg34txh7", kdYdOutboundDetail.getSe() != null ? kdYdOutboundDetail.getSe().setScale(2, java.math.RoundingMode.HALF_UP).toString() : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP).toString());
  248. tablemap.put("numberField_mg34txh8", kdYdOutboundDetail.getJe() != null ? kdYdOutboundDetail.getJe().setScale(2, java.math.RoundingMode.HALF_UP).toString() : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP).toString());
  249. tablemap.put("numberField_mg34txh9", kdYdOutboundDetail.getJshj() != null ? kdYdOutboundDetail.getJshj().setScale(2, java.math.RoundingMode.HALF_UP).toString() : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP).toString());
  250. tablemap.put("textField_mf6a0h6l", kdYdOutboundDetail.getCk());
  251. tablemap.put("textField_mf6a0h6k", kdYdOutboundDetail.getCw());
  252. tablemap.put("textField_mf6a0h6p", kdYdOutboundDetail.getKczt());
  253. tablemap.put("numberField_mg34txha", kdYdOutboundDetail.getJtc() != null ? kdYdOutboundDetail.getJtc().setScale(2, java.math.RoundingMode.HALF_UP).toString() : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP).toString());
  254. tablemap.put("textField_mejnamf6", kdYdOutboundDetail.getSjr());
  255. tablemap.put("textField_mejnamf7", kdYdOutboundDetail.getSjdh());
  256. tablemap.put("textareaField_mf6a0h5e", kdYdOutboundDetail.getSjdz());
  257. tablemap.put("textField_mejnamfx", kdYdOutboundDetail.getSsxl());
  258. tablemap.put("textField_mf6a0h6u", kdYdOutboundDetail.getGg());
  259. tablemap.put("textField_mhlqeoas", kdYdOutboundDetail.getZbq());
  260. tablemap.put("dateField_mg34txhb", kdYdOutboundDetail.getFwdqr() != null ? String.valueOf(kdYdOutboundDetail.getFwdqr().atZone(java.time.ZoneId.systemDefault()).toInstant().toEpochMilli()) : "");
  261. tablemap.put("textField_mf6a0h6w", kdYdOutboundDetail.getXlh());
  262. tablemap.put("textField_mhlqeoat", kdYdOutboundDetail.getZbqsf());
  263. tablemap.put("textField_mf6a0h6x", kdYdOutboundDetail.getKddh());
  264. tablemap.put("textField_mf6a0h6y", kdYdOutboundDetail.getJx());
  265. // tablemap.put("radioField_mf6a0h6h", kdYdOutboundDetail.getSfzp());
  266. tableList.add(tablemap);
  267. }
  268. String fhdformInstanceId = null;
  269. String fhdbh = null;
  270. try {
  271. log.debug("开始查询出库数据: deliveryId={}", deliveryId);
  272. List<Map> ddlist = (List<Map>) ydClient.queryData(
  273. YDParam.builder()
  274. .formUuid("FORM-A7F03ACEE01D4F609550C86BF7FE87D35M6I")
  275. .appType("APP_VQDMMWS6OR1VHL8VMFD3")
  276. .systemToken("XE766X81JHKXK4Z27SYOI86CPCLQ3J1LV7ODMH2")
  277. .searchCondition(JSON.toJSONString(UtilMap.map("serialNumberField_mheazm7w", deliveryId)))
  278. .build(),
  279. YDConf.FORM_QUERY.retrieve_list_all
  280. ).getData();
  281. if (ddlist != null && !ddlist.isEmpty()) {
  282. for (Map<String, Object> khitem : ddlist) {
  283. Map<String, Object> khformData = (Map<String, Object>) khitem.get("formData");
  284. if (khformData != null && deliveryId.equals(khformData.get("serialNumberField_mheazm7w"))) {
  285. fhdformInstanceId = (String) khitem.get("formInstanceId");
  286. fhdbh = (String) khformData.get("serialNumberField_mheazm7w");
  287. break;
  288. }
  289. }
  290. if (fhdformInstanceId == null) {
  291. log.warn("未找到与fhdbh={}完全匹配的订单数据", fhdbh);
  292. }
  293. } else {
  294. log.warn("未查询到订单数据: fhdbh={}", fhdbh);
  295. }
  296. } catch (Exception e) {
  297. log.error("查询订单数据异常: fhdbh={}, 错误信息={}", fhdbh, e.getMessage(), e);
  298. }
  299. HashMap<Object, Object> updateMap = new HashMap<>();
  300. updateMap.put("tableField_mejnamfd", tableList);
  301. if (fhdbh != null && fhdformInstanceId != null) {
  302. updateMap.put("associationFormField_mejmml36",
  303. Arrays.asList(getfhdAss(fhdbh,fhdformInstanceId)));
  304. }
  305. updateMap.put("dateField_krbgloam", kdYdOutbound.getDateTime() != null ? String.valueOf(kdYdOutbound.getDateTime().atZone(java.time.ZoneId.systemDefault()).toInstant().toEpochMilli()) : "");
  306. updateMap.put("textField_krnn5bmr", kdYdOutbound.getXsDept());
  307. updateMap.put("textField_mhjxw689", kdYdOutbound.getFhDept());
  308. updateMap.put("textField_mhjxw686", kdYdOutbound.getCgy());
  309. updateMap.put("selectField_mejowmna", kdYdOutbound.getDjlx());
  310. updateMap.put("textField_mg34txgm", kdYdOutbound.getDjbh());
  311. updateMap.put("textField_mhlqeoar", kdYdOutbound.getJsbb());
  312. updateMap.put("textField_mejnamf2", kdYdOutbound.getKh());
  313. updateMap.put("selectField_mejowmnc", kdYdOutbound.getXslx());
  314. updateMap.put("textField_mhjxw688", kdYdOutbound.getXsy());
  315. updateMap.put("selectField_mg34txgt", kdYdOutbound.getXssx());
  316. updateMap.put("selectField_megi74y8", kdYdOutbound.getKhsx());
  317. updateMap.put("textField_mg34txgy", kdYdOutbound.getKhtjr());
  318. updateMap.put("textField_mg34txgz", kdYdOutbound.getYsdh());
  319. // 添加同步操作(根据您的实际需求添加)
  320. // ydClient.operateData(...);
  321. // 更新同步状态
  322. kdYdOutbound.setSyncStatus("1");
  323. kdYdOutboundMapper.updateById(kdYdOutbound);
  324. successCount++;
  325. log.info("出库单同步成功: 单据编号={}", djbh);
  326. } catch (Exception e) {
  327. failCount++;
  328. log.error("同步单条出库单数据异常: 单据编号={}, 错误信息={}",
  329. kdYdOutbound.getDjbh(), e.getMessage(), e);
  330. }
  331. }
  332. log.info("【出库单同步任务】完成: 成功={}, 失败={}, 总计={}",
  333. successCount, failCount, kdYdOutbounds.size());
  334. }
  335. @Override
  336. public void syncKdYdReceivable() {
  337. log.info("定时同步-应收单");
  338. LambdaQueryWrapper<KdYdReceivable> receivableqw = new LambdaQueryWrapper<>();
  339. receivableqw.eq(KdYdReceivable::getSyncStatus, "0");
  340. List<KdYdReceivable> kdYdReceivables = kdYdReceivableMapper.selectList(receivableqw);
  341. if (kdYdReceivables.isEmpty()) {
  342. log.info("【应收单同步任务】无需要同步的数据,结束");
  343. return;
  344. }
  345. log.info("【应收单同步任务】开始同步,共{}条数据", kdYdReceivables.size());
  346. int successCount = 0;
  347. int failCount = 0;
  348. for (KdYdReceivable kdYdReceivable : kdYdReceivables) {
  349. try {
  350. Long id = kdYdReceivable.getId();
  351. String djbh = kdYdReceivable.getDjbh();
  352. log.debug("开始同步应收单: ID={}, 单据编号={}", id, djbh);
  353. // 同步应收单明细
  354. LambdaQueryWrapper<KdYdReceivableDetail> receivabledetailqw = new LambdaQueryWrapper<>();
  355. receivabledetailqw.eq(KdYdReceivableDetail::getReceivableId, id)
  356. .orderByAsc(KdYdReceivableDetail::getDetailId);
  357. List<KdYdReceivableDetail> kdYdReceivabledetails = kdYdReceivableDetailMapper.selectList(receivabledetailqw);
  358. if (kdYdReceivabledetails.isEmpty()) {
  359. log.info("【应收单{}】无需要同步的明细数据", djbh);
  360. continue;
  361. }
  362. ArrayList<Object> tableList = new ArrayList<>();
  363. for (KdYdReceivableDetail kdYdReceivableDetail : kdYdReceivabledetails) {
  364. HashMap<Object, Object> tablemap = new HashMap<>();
  365. String wlbm = kdYdReceivableDetail.getWlbm();
  366. String wlmc = kdYdReceivableDetail.getWlmc();
  367. String ggxh = kdYdReceivableDetail.getGgxh();
  368. String jjdw = kdYdReceivableDetail.getJjdw();
  369. String ssxl = kdYdReceivableDetail.getSsxl();
  370. BigDecimal dj = kdYdReceivableDetail.getDj();
  371. BigDecimal hsdj = kdYdReceivableDetail.getHsdj();
  372. BigDecimal sl = kdYdReceivableDetail.getSl();
  373. BigDecimal je = kdYdReceivableDetail.getJe();
  374. BigDecimal zbjshj = kdYdReceivableDetail.getJshj();
  375. String kcdw = kdYdReceivableDetail.getKcdw();
  376. String ph = kdYdReceivableDetail.getPh();
  377. BigDecimal se = kdYdReceivableDetail.getSe();
  378. BigDecimal jjsl = kdYdReceivableDetail.getJjsl();
  379. BigDecimal zkl = kdYdReceivableDetail.getZkl();
  380. BigDecimal bhsje = kdYdReceivableDetail.getBhsje();
  381. BigDecimal jjjbsl = kdYdReceivableDetail.getJjjbsl();
  382. BigDecimal kcsl = kdYdReceivableDetail.getKcsl();
  383. String sfzp = kdYdReceivableDetail.getSfzp();
  384. String gg = kdYdReceivableDetail.getGg();
  385. BigDecimal tc = kdYdReceivableDetail.getTc();
  386. String jx = kdYdReceivableDetail.getJx();
  387. BigDecimal zke = kdYdReceivableDetail.getZke();
  388. String detailId = kdYdReceivableDetail.getDetailId();
  389. // 优化:确保所有金额字段保留两位小数
  390. tablemap.put("textField_mf6el3zy", wlbm);
  391. tablemap.put("textField_mf6el3zz", wlmc);
  392. tablemap.put("textField_mejmtic5", ggxh);
  393. tablemap.put("textField_mf6el400", jjdw);
  394. tablemap.put("textField_mhllijwo", ssxl);
  395. tablemap.put("numberField_mf6el402", dj != null ? dj.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  396. tablemap.put("numberField_mejmticb", hsdj != null ? hsdj.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  397. tablemap.put("numberField_mf6el403", sl != null ? sl.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  398. tablemap.put("numberField_mejmtic7", zbjshj != null ? zbjshj.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  399. tablemap.put("textField_mf6el409", kcdw);
  400. tablemap.put("textField_mf6el408", ph);
  401. tablemap.put("numberField_mf6el406", se != null ? se.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  402. tablemap.put("numberField_mejmtic6", jjsl != null ? jjsl.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  403. tablemap.put("numberField_mf6el404", zkl != null ? zkl.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  404. tablemap.put("numberField_mejmticc", bhsje != null ? bhsje.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  405. tablemap.put("numberField_mf6el407", jjjbsl != null ? jjjbsl.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  406. tablemap.put("numberField_mf6el40a", kcsl != null ? kcsl.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  407. tablemap.put("radioField_mejnamfn", sfzp);
  408. tablemap.put("numberField_mf6el40c", tc != null ? tc.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  409. tablemap.put("textField_mf6el40d", jx);
  410. tablemap.put("textField_mf6el40b", gg);
  411. tablemap.put("numberField_mf6el405", zke != null ? zke.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  412. tableList.add(tablemap);
  413. kdYdReceivableDetail.setSyncStatus("1");
  414. kdYdReceivableDetailMapper.updateById(kdYdReceivableDetail);
  415. }
  416. // 同步收款计划
  417. LambdaQueryWrapper<KdYdReceivablePayment> receivablepayqw = new LambdaQueryWrapper<>();
  418. receivablepayqw
  419. .eq(KdYdReceivablePayment::getReceivableId, id)
  420. .orderByAsc(KdYdReceivablePayment::getDetailId);
  421. List<KdYdReceivablePayment> kdYdReceivablePayments = kdYdReceivalablePaymentMapper.selectList(receivablepayqw);
  422. ArrayList<Object> tableListPay = new ArrayList<>();
  423. if (!kdYdReceivablePayments.isEmpty()) {
  424. for (KdYdReceivablePayment kdYdReceivablePayment : kdYdReceivablePayments) {
  425. HashMap<Object, Object> tablemap1 = new HashMap<>();
  426. long timestamp = kdYdReceivablePayment.getEndTime().atZone(java.time.ZoneId.systemDefault()).toInstant().toEpochMilli();
  427. String xsddh = kdYdReceivablePayment.getXsddh();
  428. BigDecimal ysje = kdYdReceivablePayment.getYsje();
  429. BigDecimal ysbl = kdYdReceivablePayment.getYsbl();
  430. BigDecimal ysjebwb = kdYdReceivablePayment.getYsjebwb();
  431. BigDecimal stkdglje = kdYdReceivablePayment.getStkdglje();
  432. tablemap1.put("textField_mhiui6va", xsddh);
  433. tablemap1.put("dateField_mhiui6v9", timestamp);
  434. tablemap1.put("numberField_mhiui6v8", ysje != null ? ysje.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  435. tablemap1.put("numberField_mhiui6v6", ysbl != null ? ysbl.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  436. tablemap1.put("numberField_mhiui6vb", ysjebwb != null ? ysjebwb.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  437. tablemap1.put("numberField_mhjy9hzj", stkdglje != null ? stkdglje.setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  438. tableListPay.add(tablemap1);
  439. }
  440. }
  441. String ckddjbh = kdYdReceivable.getCkddjbh();
  442. String ckdformInstanceId = null;
  443. String ckdbh = null;
  444. try {
  445. List<Map> ddlist = (List<Map>) ydClient.queryData(
  446. YDParam.builder()
  447. .formUuid("FORM-AADBCDA8126F41A0ADDEE3353828583192M8")
  448. .appType("APP_VQDMMWS6OR1VHL8VMFD3")
  449. .systemToken("XE766X81JHKXK4Z27SYOI86CPCLQ3J1LV7ODMH2")
  450. .searchCondition(JSON.toJSONString(UtilMap.map("textField_mg34txgm", ckddjbh)))
  451. .build(),
  452. YDConf.FORM_QUERY.retrieve_list_all
  453. ).getData();
  454. if (ddlist != null && !ddlist.isEmpty()) {
  455. for (Map<String, Object> khitem : ddlist) {
  456. Map<String, Object> khformData = (Map<String, Object>) khitem.get("formData");
  457. if (khformData != null && ckddjbh.equals(khformData.get("textField_mg34txgm"))) {
  458. ckdformInstanceId = (String) khitem.get("formInstanceId");
  459. ckdbh = (String) khformData.get("textField_mejnamf2");
  460. break;
  461. }
  462. }
  463. if (ckdformInstanceId == null) {
  464. log.warn("未找到与ckdbh={}完全匹配的订单数据", ckdbh);
  465. }
  466. } else {
  467. log.warn("未查询到订单数据: ckdbh={}", ckdbh);
  468. }
  469. } catch (Exception e) {
  470. log.error("查询订单数据异常: ckdbh={}, 错误信息={}", ckdbh, e.getMessage(), e);
  471. }
  472. HashMap<Object, Object> updateMap = new HashMap<>();
  473. updateMap.put("tableField_mh9woanl", tableList);
  474. if (ckdbh != null && ckdformInstanceId != null) {
  475. updateMap.put("associationFormField_mejmtick",
  476. Arrays.asList(getysdAss(ckdbh,ckdformInstanceId)));
  477. }
  478. // 构建主表数据
  479. HashMap<Object, Object> updateData = new HashMap<>();
  480. updateData.put("tableField_mf6el3zx", tableList);
  481. updateData.put("tableField_mhiui6v5", tableListPay);
  482. updateData.put("textField_mg3a0tgs", kdYdReceivable.getDjbh());
  483. updateData.put("selectField_mg3a0th4", kdYdReceivable.getDjlx());
  484. updateData.put("selectField_mev13l3r", kdYdReceivable.getSktj());
  485. updateData.put("dateField_mejmtic3", kdYdReceivable.getEndTime().atZone(java.time.ZoneId.systemDefault()).toInstant().toEpochMilli());
  486. updateData.put("dateField_mejmtic2", kdYdReceivable.getBusinessTime().atZone(java.time.ZoneId.systemDefault()).toInstant().toEpochMilli());
  487. updateData.put("numberField_mejmtic8", kdYdReceivable.getJshj() != null ? kdYdReceivable.getJshj().setScale(2, java.math.RoundingMode.HALF_UP) : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  488. updateData.put("textField_mejmml3k", kdYdReceivable.getKh());
  489. updateData.put("textField_mhjy9hzh", kdYdReceivable.getXsy());
  490. updateData.put("selectField_mejowmnc", kdYdReceivable.getXslx());
  491. updateData.put("selectField_megi74y8", kdYdReceivable.getKhsx());
  492. updateData.put("textField_krnn5bmr", kdYdReceivable.getXsbm());
  493. updateData.put("textField_mhjy9hzi", kdYdReceivable.getLzlx());
  494. updateData.put("textareaField_mg3a0tgx", kdYdReceivable.getBz());
  495. updateData.put("selectField_mg3fuqvn", kdYdReceivable.getBb());
  496. log.debug("开始同步到宜搭: 单据编号={}, 表单UUID=FORM-4E1CE4550339494A9BE5498FB119FF2E9ERU", djbh);
  497. // 执行同步
  498. ydClient.operateData(YDParam.builder()
  499. .formUuid("FORM-4E1CE4550339494A9BE5498FB119FF2E9ERU")
  500. .searchCondition(JSONObject.toJSONString(UtilMap.map("textField_mg3a0tgs", kdYdReceivable.getDjbh())))
  501. .formDataJson(JSONObject.toJSONString(updateData))
  502. .build(), YDConf.FORM_OPERATION.upsert
  503. );
  504. kdYdReceivable.setSyncStatus("1");
  505. kdYdReceivableMapper.updateById(kdYdReceivable);
  506. successCount++;
  507. log.info("应收单同步成功: 单据编号={}", djbh);
  508. } catch (Exception e) {
  509. failCount++;
  510. log.error("同步应收单异常: ID={}, 单据编号={}, 错误信息={}",
  511. kdYdReceivable.getId(), kdYdReceivable.getDjbh(), e.getMessage(), e);
  512. }
  513. }
  514. log.info("【应收单同步任务】完成: 成功={}, 失败={}, 总计={}",
  515. successCount, failCount, kdYdReceivables.size());
  516. }
  517. @Override
  518. public void synckdYdZp() {
  519. log.info("定时同步-发票单");
  520. try {
  521. LocalDateTime now = LocalDateTime.now();
  522. LocalDateTime fiveMinutesAgo = now.minusMinutes(5);
  523. DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
  524. List<KdYdZp> kdYdZps = kdYdZpMapper.selectRecentUpdated(fiveMinutesAgo);
  525. if (kdYdZps.isEmpty()) {
  526. log.info("【发票单同步任务】无需要同步的数据,结束");
  527. return;
  528. }
  529. for (KdYdZp kdYdZp : kdYdZps) {
  530. try {
  531. String djbh = kdYdZp.getDjbh();
  532. String fph = kdYdZp.getFph();
  533. String formInstId = kdYdZp.getForminstid();
  534. if (ObjectUtil.hasEmpty(formInstId, djbh, fph)) {
  535. log.warn("跳过同步: formInstId 或 khbm 为空, customer={}", kdYdZp.getId());
  536. continue;
  537. }
  538. ydClient.operateData(
  539. YDParam.builder()
  540. .formInstanceId(formInstId)
  541. .updateFormDataJson(JSONObject.toJSONString(UtilMap.map("textField_mgt6lcqq, textField_mejmml3a", djbh, fph)))
  542. .useLatestVersion(true).build(), YDConf.FORM_OPERATION.update);
  543. } catch (Exception e) {
  544. log.error("同步单条发票单数据异常: formInstId={}", kdYdZp.getForminstid(), e);
  545. }
  546. }
  547. log.info("【发票单同步任务】执行完成,共处理 {} 条记录", kdYdZps.size());
  548. } catch (Exception e) {
  549. log.error("【发票单同步任务】执行过程中发生严重错误", e);
  550. }
  551. }
  552. @Override
  553. public void synckdYdMaterial() {
  554. log.info("定时同步-物料单");
  555. LambdaQueryWrapper<KdYdMaterial> materialqw = new LambdaQueryWrapper<>();
  556. materialqw.eq(KdYdMaterial::getSyncStatus, "0");
  557. // .or()
  558. // .eq(KdYdMaterial::getOperationType, 2);
  559. List<KdYdMaterial> kdYdMaterials = kdYdMaterialMapper.selectList(materialqw);
  560. log.info("本次需要同步的物料单数量: {}", kdYdMaterials.size());
  561. int successCount = 0;
  562. int failCount = 0;
  563. for (KdYdMaterial kdYdMaterial : kdYdMaterials) {
  564. try {
  565. String wlbm = kdYdMaterial.getWlbm();
  566. String wlmc = kdYdMaterial.getWlmc();
  567. String xh = kdYdMaterial.getXh();
  568. String gg = kdYdMaterial.getGg();
  569. String wlfz = kdYdMaterial.getWlfz();
  570. String wlsx = kdYdMaterial.getWlsx();
  571. String jbdw = kdYdMaterial.getJbdw();
  572. String ssxl = kdYdMaterial.getSsxl();
  573. String jx = kdYdMaterial.getJx();
  574. Integer sd = kdYdMaterial.getSd();
  575. String mrsl = kdYdMaterial.getMrsl();
  576. String chlb = kdYdMaterial.getChlb();
  577. String xsy = kdYdMaterial.getXsy();
  578. BigDecimal xsjzj = kdYdMaterial.getXsjzj();
  579. String smzs = kdYdMaterial.getSmzs();
  580. String sjzt = kdYdMaterial.getSjzt();
  581. String jyzt = kdYdMaterial.getJyzt();
  582. String dzl = kdYdMaterial.getDzl();
  583. String pzzt = kdYdMaterial.getPzzt();
  584. String wlbt = wlmc + wlbm;
  585. // String materialtitle = kdYdMaterial.getMaterialtitle();
  586. Map updateFormData = new HashMap();
  587. updateFormData.put("textField_l43jpnsf", wlmc);
  588. updateFormData.put("textField_mfxbtcdh", wlbm);
  589. updateFormData.put("textField_l43jpnsg", xh);
  590. updateFormData.put("textField_lqbxkzbq", gg);
  591. updateFormData.put("textField_mhlbx8hi", wlfz);
  592. updateFormData.put("textField_l43jpnsh", wlsx);
  593. updateFormData.put("textField_mfxbtcdo", jbdw);
  594. updateFormData.put("textField_mfxbtcdp", ssxl);
  595. updateFormData.put("textField_mejl9nrs", jx);
  596. updateFormData.put("numberField_mfxbtceb", sd);
  597. updateFormData.put("textField_mejl9nrp", dzl);
  598. updateFormData.put("selectField_mejl9nrq", pzzt);
  599. updateFormData.put("textField_mfxbtcdq", mrsl);
  600. updateFormData.put("textField_mfxbtcdr", chlb);
  601. updateFormData.put("textField_mfxbtce5", xsy);
  602. //确保金额字段保留两位小数
  603. if (xsjzj != null) {
  604. updateFormData.put("numberField_mejl9nsc", xsjzj.setScale(2, java.math.RoundingMode.HALF_UP));
  605. } else {
  606. updateFormData.put("numberField_mejl9nsc", java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP));
  607. }
  608. updateFormData.put("textField_mfxbtce4", smzs);
  609. updateFormData.put("textField_mfxbtcea", jyzt);
  610. updateFormData.put("textField_mg4h6mz5", wlbt);
  611. ydClient.operateData(YDParam.builder()
  612. .formUuid("FORM-E132ECE2BED94BCF81D9842B3F2054E7XWQ7")
  613. .appType("APP_VQDMMWS6OR1VHL8VMFD3")
  614. .systemToken("XE766X81JHKXK4Z27SYOI86CPCLQ3J1LV7ODMH2")
  615. .searchCondition(JSONObject.toJSONString(UtilMap.map("textField_mg4h6mz5", wlbt)))
  616. // .searchCondition(JSONObject.toJSONString(UtilMap.map("textField_mfxbtcdh", wlbm)))
  617. .formDataJson(JSONObject.toJSONString(updateFormData))
  618. .build(), YDConf.FORM_OPERATION.upsert);
  619. // 同步成功,更新状态
  620. kdYdMaterial.setSyncStatus("1");
  621. kdYdMaterialMapper.updateById(kdYdMaterial);
  622. successCount++;
  623. log.info("物料单同步成功: wlbm={}, wlmc={}", wlbm, wlmc);
  624. } catch (Exception e) {
  625. failCount++;
  626. log.error("同步单条物料单数据异常: wlbm={}, wlmc={}",
  627. kdYdMaterial.getWlbm(), kdYdMaterial.getWlmc(), e);
  628. }
  629. }
  630. // 添加同步结果统计日志
  631. log.info("物料单同步完成: 成功={}, 失败={}, 总计={}",
  632. successCount, failCount, kdYdMaterials.size());
  633. }
  634. @Override
  635. public void syncKdYdDeliveryDetail() {
  636. log.info("定时同步-发货单详情");
  637. try {
  638. LocalDateTime now = LocalDateTime.now();
  639. LocalDateTime fiveMinutesAgo = now.minusMinutes(5);
  640. // 1. 查询最近更新的 delivery detail
  641. List<KdYdDeliveryDetail> kdYdDeliveryDetails = kdYdDeliveryDetailMapper.selectRecentUpdated(fiveMinutesAgo);
  642. if (kdYdDeliveryDetails.isEmpty()) {
  643. log.info("【发货详情单同步任务】无需要同步的数据,结束");
  644. return;
  645. }
  646. // 2. 按 deliveryId 提取主单 ID 列表,避免重复查询
  647. Set<Long> deliveryIds = kdYdDeliveryDetails.stream()
  648. .map(KdYdDeliveryDetail::getDeliveryId)
  649. .filter(Objects::nonNull)
  650. .collect(Collectors.toSet());
  651. // 3. 批量查询主单信息(包含 formInstId)
  652. List<KdYdDelivery> mainDeliveries = kdYdDeliveryMapper.selectBatchIds(deliveryIds);
  653. Map<Long, KdYdDelivery> deliveryMap = mainDeliveries.stream()
  654. .collect(Collectors.toMap(KdYdDelivery::getId, d -> d));
  655. // 4. 按 formInstId 分组,减少 API 调用次数
  656. Map<String, List<KdYdDeliveryDetail>> detailsByFormInstId = kdYdDeliveryDetails.stream()
  657. .filter(detail -> deliveryMap.containsKey(detail.getDeliveryId()))
  658. .collect(Collectors.groupingBy(detail -> {
  659. KdYdDelivery main = deliveryMap.get(detail.getDeliveryId());
  660. return main != null ? main.getForminstid() : null;
  661. }));
  662. int successCount = 0;
  663. int errorCount = 0;
  664. // 5. 遍历每个 formInstId,只调用一次 query + 一次 update
  665. for (Map.Entry<String, List<KdYdDeliveryDetail>> entry : detailsByFormInstId.entrySet()) {
  666. String formInstId = entry.getKey();
  667. if (formInstId == null || formInstId.trim().isEmpty()) {
  668. log.warn("跳过空 formInstId 的记录");
  669. continue;
  670. }
  671. try {
  672. // 查询当前表单数据
  673. Map formData = ydClient.queryData(
  674. YDParam.builder()
  675. .formInstId(formInstId)
  676. .appType(ydConf.getAppType())
  677. .systemToken(ydConf.getSystemToken())
  678. .userId(ddConf.getOperator())
  679. .build(),
  680. YDConf.FORM_QUERY.retrieve_id
  681. ).getFormData();
  682. if (formData == null) {
  683. log.warn("formInstId={} 的 formData 为空", formInstId);
  684. continue;
  685. }
  686. List<Map<String, Object>> tableData = (List<Map<String, Object>>) formData.get("tableField_mejnamfd");
  687. if (tableData == null || tableData.isEmpty()) {
  688. log.warn("formInstId={} 的子表 tableField_mejnamfd 为空", formInstId);
  689. continue;
  690. }
  691. // 标记是否需要更新
  692. boolean modified = false;
  693. // 处理当前 formInstId 下的所有待同步 detail
  694. for (KdYdDeliveryDetail detail : entry.getValue()) {
  695. String wlbm = detail.getWlbm();
  696. String mdh = detail.getMdh();
  697. for (Map<String, Object> row : tableData) {
  698. Object wlbmIdObj = row.get("textField_mejnamff");
  699. if (wlbmIdObj != null && wlbm.equals(wlbmIdObj.toString())) {
  700. row.put("textField_mf6a0h6y", mdh);
  701. modified = true;
  702. successCount++;
  703. break; // 找到匹配行即可跳出
  704. }
  705. }
  706. }
  707. // 只有修改了才提交
  708. if (modified) {
  709. ydClient.operateData(
  710. YDParam.builder()
  711. .formInstanceId(formInstId)
  712. .updateFormDataJson(JSON.toJSONString(Collections.singletonMap("tableField_mejnamfd", tableData)))
  713. .useLatestVersion(true)
  714. .build(),
  715. YDConf.FORM_OPERATION.update
  716. );
  717. log.debug("已更新 formInstId={} 的子表数据", formInstId);
  718. } else {
  719. log.debug("formInstId={} 无需更新", formInstId);
  720. }
  721. } catch (Exception e) {
  722. errorCount += entry.getValue().size(); // 统计失败数量
  723. log.error("同步 formInstId={} 时发生异常", formInstId, e);
  724. }
  725. }
  726. log.info("【发货详情单同步任务】执行完成,共处理 {} 条记录,成功 {} 条,失败 {} 条",
  727. kdYdDeliveryDetails.size(), successCount, errorCount);
  728. } catch (Exception e) {
  729. log.error("【发货单同步任务】执行过程中发生严重错误", e);
  730. }
  731. }
  732. @Override
  733. public void synckdYdPayment() {
  734. log.info("定时同步-收款单");
  735. LambdaQueryWrapper<KdYdPaymentReceipt> paymentqw = new LambdaQueryWrapper<>();
  736. paymentqw.eq(KdYdPaymentReceipt::getSyncStatus, "0");
  737. List<KdYdPaymentReceipt> kdYdPaymentReceipts = kdYdPaymentReceiptMapper.selectList(paymentqw);
  738. if (kdYdPaymentReceipts.isEmpty()) {
  739. log.info("【收款单同步任务】无需要同步的数据,结束");
  740. return;
  741. }
  742. log.info("【收款单同步任务】开始同步,共{}条数据", kdYdPaymentReceipts.size());
  743. int successCount = 0;
  744. int failCount = 0;
  745. for (KdYdPaymentReceipt kdYdPaymentReceipt : kdYdPaymentReceipts) {
  746. try {
  747. Long paymentReceiptId = kdYdPaymentReceipt.getId();
  748. String djbh = kdYdPaymentReceipt.getDjbh();
  749. log.debug("开始同步收款单: ID={}, 单据编号={}", paymentReceiptId, djbh);
  750. LambdaQueryWrapper<KdYdPaymentReceiptDetail> receivedetailqw = new LambdaQueryWrapper<>();
  751. receivedetailqw.eq(KdYdPaymentReceiptDetail::getPayreceiptId, paymentReceiptId)
  752. .orderByAsc(KdYdPaymentReceiptDetail::getDetailId);
  753. List<KdYdPaymentReceiptDetail> kdYDPaymentReceiptDetails = kdYdPaymentReceiptDetailMapper.selectList(receivedetailqw);
  754. ArrayList<Object> tableList = new ArrayList<>();
  755. for (KdYdPaymentReceiptDetail kdYdPaymentReceiptDetail : kdYDPaymentReceiptDetails) {
  756. HashMap<String, String> tablemap = new HashMap<>();
  757. tablemap.put("textField_mh9woanr", kdYdPaymentReceiptDetail.getJsfs());
  758. tablemap.put("textField_mh9woans", kdYdPaymentReceiptDetail.getSkyt());
  759. tablemap.put("textField_mh9woant", kdYdPaymentReceiptDetail.getYsxmlx());
  760. tablemap.put("textField_mh9woanu", kdYdPaymentReceiptDetail.getYsxsdd());
  761. tablemap.put("numberField_mh9woanv", kdYdPaymentReceiptDetail.getYsje() != null ? kdYdPaymentReceiptDetail.getYsje().setScale(2, java.math.RoundingMode.HALF_UP).toString() : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP).toString());
  762. tablemap.put("numberField_mh9woanw", kdYdPaymentReceiptDetail.getSxf() != null ? kdYdPaymentReceiptDetail.getSxf().setScale(2, java.math.RoundingMode.HALF_UP).toString() : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP).toString());
  763. tablemap.put("textField_mhmr1ecr", kdYdPaymentReceiptDetail.getCdk());
  764. tablemap.put("textField_mh9woany", kdYdPaymentReceiptDetail.getWfyhzh());
  765. tablemap.put("textField_mh9woao2", kdYdPaymentReceiptDetail.getXsddh());
  766. tablemap.put("textField_mh9woao1", kdYdPaymentReceiptDetail.getFyxm());
  767. tablemap.put("numberField_mh9woanz", kdYdPaymentReceiptDetail.getSsje() != null ? kdYdPaymentReceiptDetail.getSsje().setScale(2, java.math.RoundingMode.HALF_UP).toString() : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP).toString());
  768. tablemap.put("numberField_mh9woao0", kdYdPaymentReceiptDetail.getZhje() != null ? kdYdPaymentReceiptDetail.getZhje().setScale(2, java.math.RoundingMode.HALF_UP).toString() : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP).toString());
  769. // tablemap.put("radioField_mf6a0h6h", kdYdOutboundDetail.getSfzp());
  770. tableList.add(tablemap);
  771. }
  772. String xsddbh = kdYdPaymentReceipt.getXsddbh();
  773. String ddformInstanceId = null;
  774. String ddbh = null;
  775. try {
  776. log.debug("开始查询订单数据: xsddbh={}", xsddbh);
  777. List<Map> ddlist = (List<Map>) ydClient.queryData(
  778. YDParam.builder()
  779. .formUuid("FORM-B62CAE3075CE4098B17BB86C90FFA21C9B7C")
  780. .appType("APP_VQDMMWS6OR1VHL8VMFD3")
  781. .systemToken("XE766X81JHKXK4Z27SYOI86CPCLQ3J1LV7ODMH2")
  782. .searchCondition(JSON.toJSONString(UtilMap.map("serialNumberField_mewfgzku", xsddbh)))
  783. .build(),
  784. YDConf.FORM_QUERY.retrieve_list_all
  785. ).getData();
  786. if (ddlist != null && !ddlist.isEmpty()) {
  787. for (Map<String, Object> khitem : ddlist) {
  788. Map<String, Object> khformData = (Map<String, Object>) khitem.get("formData");
  789. if (khformData != null && xsddbh.equals(khformData.get("serialNumberField_mewfgzku"))) {
  790. ddformInstanceId = (String) khitem.get("formInstanceId");
  791. ddbh = (String) khformData.get("serialNumberField_mewfgzku");
  792. break;
  793. }
  794. }
  795. if (ddformInstanceId == null) {
  796. log.warn("未找到与xsddbh={}完全匹配的订单数据", xsddbh);
  797. }
  798. } else {
  799. log.warn("未查询到订单数据: xsddbh={}", xsddbh);
  800. }
  801. } catch (Exception e) {
  802. log.error("查询订单数据异常: xsddbh={}, 错误信息={}", xsddbh, e.getMessage(), e);
  803. }
  804. HashMap<Object, Object> updateMap = new HashMap<>();
  805. updateMap.put("tableField_mh9woanl", tableList);
  806. if (ddbh != null && ddformInstanceId != null) {
  807. updateMap.put("associationFormField_mh9woamy",
  808. Arrays.asList(getddAss(ddbh,ddformInstanceId)));
  809. }
  810. updateMap.put("textField_mh9woanm", kdYdPaymentReceipt.getDjlx());
  811. updateMap.put("textField_mh9woann", kdYdPaymentReceipt.getFkdwlx());
  812. updateMap.put("textField_mh9woamt", kdYdPaymentReceipt.getDjbh());
  813. updateMap.put("textField_mh9woamz", kdYdPaymentReceipt.getSkgld());
  814. updateMap.put("textField_mh9woano", kdYdPaymentReceipt.getBb());
  815. updateMap.put("dateField_mh9woan5", kdYdPaymentReceipt.getYwrq() != null ? String.valueOf(kdYdPaymentReceipt.getYwrq().atZone(java.time.ZoneId.systemDefault()).toInstant().toEpochMilli()) : "");
  816. updateMap.put("textField_mh9woanp", kdYdPaymentReceipt.getWldwlx());
  817. updateMap.put("textField_mh9woanq", kdYdPaymentReceipt.getWldw());
  818. updateMap.put("numberField_mh9woanc", kdYdPaymentReceipt.getYsje() != null ? kdYdPaymentReceipt.getYsje().setScale(2, java.math.RoundingMode.HALF_UP).toString() : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP).toString());
  819. updateMap.put("numberField_mh9woand", kdYdPaymentReceipt.getSsje() != null ? kdYdPaymentReceipt.getSsje().setScale(2, java.math.RoundingMode.HALF_UP).toString() : java.math.BigDecimal.ZERO.setScale(2, java.math.RoundingMode.HALF_UP).toString());
  820. updateMap.put("textField_mhjxv2tf", kdYdPaymentReceipt.getXsy());
  821. updateMap.put("textField_mhjxv2tg", kdYdPaymentReceipt.getXsbm());
  822. updateMap.put("textareaField_mh9woank", kdYdPaymentReceipt.getBz());
  823. log.debug("开始同步到宜搭: 单据编号={}, 表单UUID=FORM-0569C06E47074C2981ADEEAFCE083EDAK5AM", djbh);
  824. // 添加同步操作(根据您的实际需求添加)
  825. ydClient.operateData(YDParam.builder()
  826. .formUuid("FORM-0569C06E47074C2981ADEEAFCE083EDAK5AM")
  827. .appType("APP_VQDMMWS6OR1VHL8VMFD3")
  828. .systemToken("XE766X81JHKXK4Z27SYOI86CPCLQ3J1LV7ODMH2")
  829. .searchCondition(JSONObject.toJSONString(UtilMap.map("textField_mh9woamt", kdYdPaymentReceipt.getDjbh())))
  830. .formDataJson(JSONObject.toJSONString(updateMap))
  831. .build(), YDConf.FORM_OPERATION.upsert);
  832. // 更新同步状态
  833. kdYdPaymentReceipt.setSyncStatus("1");
  834. kdYdPaymentReceiptMapper.updateById(kdYdPaymentReceipt);
  835. successCount++;
  836. log.info("收款单同步成功: 单据编号={}", djbh);
  837. } catch (Exception e) {
  838. failCount++;
  839. log.error("同步单条收款单数据异常: 单据编号={}, 错误信息={}",
  840. kdYdPaymentReceipt.getDjbh(), e.getMessage(), e);
  841. }
  842. }
  843. log.info("【收款单同步任务】完成: 成功={}, 失败={}, 总计={}",
  844. successCount, failCount, kdYdPaymentReceipts.size());
  845. }
  846. private Object getddAss(String title, String id) {
  847. return UtilMap.map("appType, formUuid, formType, instanceId, title, subTitle", "APP_VQDMMWS6OR1VHL8VMFD3", "FORM-B62CAE3075CE4098B17BB86C90FFA21C9B7C", "receipt", id, title, "");
  848. }
  849. private Object getfhdAss(String title, String id) {
  850. return UtilMap.map("appType, formUuid, formType, instanceId, title, subTitle", "APP_VQDMMWS6OR1VHL8VMFD3", "FORM-A7F03ACEE01D4F609550C86BF7FE87D35M6I", "receipt", id, title, "");
  851. }
  852. private Object getysdAss(String title, String id) {
  853. return UtilMap.map("appType, formUuid, formType, instanceId, title, subTitle", "APP_VQDMMWS6OR1VHL8VMFD3", "FORM-AADBCDA8126F41A0ADDEE3353828583192M8", "receipt", id, title, "");
  854. }
  855. }