NonPoServerImpl.java 54 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069
  1. package com.malk.taisen.service.impl;
  2. import com.alibaba.fastjson.JSON;
  3. import com.alibaba.fastjson.JSONObject;
  4. import com.fasterxml.jackson.databind.JsonNode;
  5. import com.fasterxml.jackson.databind.ObjectMapper;
  6. import com.malk.taisen.util.CusutUtil;
  7. import com.malk.taisen.util.HttpUtil;
  8. import cn.hutool.json.JSONArray;
  9. import com.malk.server.aliwork.YDConf;
  10. import com.malk.server.aliwork.YDParam;
  11. import com.malk.server.dingtalk.DDR_New;
  12. import com.malk.service.aliwork.YDClient;
  13. import com.malk.service.aliwork.YDService;
  14. import com.malk.service.dingtalk.DDClient;
  15. import com.malk.taisen.service.NonPoServer;
  16. import com.malk.utils.UtilMap;
  17. import lombok.extern.slf4j.Slf4j;
  18. import org.springframework.beans.factory.annotation.Autowired;
  19. import org.springframework.beans.factory.annotation.Value;
  20. import org.springframework.http.HttpEntity;
  21. import org.springframework.http.HttpHeaders;
  22. import org.springframework.http.MediaType;
  23. import org.springframework.http.ResponseEntity;
  24. import org.springframework.stereotype.Service;
  25. import org.springframework.web.client.RestTemplate;
  26. import java.math.BigDecimal;
  27. import java.math.RoundingMode;
  28. import java.text.ParseException;
  29. import java.text.SimpleDateFormat;
  30. import java.util.*;
  31. @Slf4j
  32. @Service
  33. public class NonPoServerImpl implements NonPoServer {
  34. @Autowired
  35. private YDClient ydClient;
  36. @Autowired
  37. private YDService ydService;
  38. @Autowired
  39. private DDClient ddClient;
  40. /**
  41. * 测试地址
  42. */
  43. private String QA_sapUrl = "https://etl-nonprod-tasks.tysondt.com:443/api/1/rest/feed/run/task/TysonNonProd/Ultra_PoC/10-QA-team-fssc/tk_oa_to_sap_p2p?bearer_token=bBiGTA7PS0JJ6wKhQU8Vm0vLsIDNjLaN&interface_id=";
  44. // @Override
  45. // public void NonPoinsetSAP0005_tse(String type, String InstanceId) {
  46. // YDParam ydParam = _getYDTokenKPD();
  47. // ydParam.setFormInstanceId(InstanceId);
  48. // DDR_New ddr = ydClient.queryData(ydParam, YDConf.FORM_QUERY.retrieve_id);
  49. // Map dataForm = ddr.getFormData();
  50. // String paymentType = getString(dataForm, "selectField_mejfoona", "");//Type / 付款类型
  51. // // 发票总额 or 支付金额
  52. // String invoiceAmt = getNumberValue(dataForm, "numberField_mejfoook_value");//Invoice Amount / 发票总额
  53. // String payAmt = getNumberValue(dataForm, "numberField_mejfoool_value");//Payment Amount / 支付总额(含税)
  54. //
  55. //
  56. // String PD = (String) dataForm.get("selectField_mj1cq2oz_id");//formatDate(dataForm, "selectField_mj1cq2oz_id");//
  57. // String SAPID = (String) dataForm.get("textField_mejezfwk");//formatDate(dataForm, "textField_mejezfwk").equals("")? formatDate(dataForm, "textField_mj2gpdiu"): formatDate(dataForm, "textField_mejezfwk");
  58. //
  59. // // 若不需要生成 SAP 凭证,但已有 SAPID,则执行发票勾选
  60. // if ("否".equals(PD) && !SAPID.isEmpty()) {
  61. // FPGX(InstanceId, SAPID, getString(dataForm, "textField_mi73dy3n", ""));
  62. // return;
  63. // }
  64. //
  65. //
  66. // // 只有“是”才继续处理
  67. // if ("否".equals(PD)) {
  68. // return;
  69. // }
  70. //
  71. // JSONObject sapJson = new JSONObject();
  72. // sapJson.put("ZDUEDATE", formatDate(dataForm, "dateField_mejfoonv"));
  73. // sapJson.put("BKTXT", getString(dataForm, "textareaField_mejfoonw", ""));
  74. // sapJson.put("ZOA_NUMBER", getString(dataForm, "textField_mi73dy3n", ""));
  75. // sapJson.put("interface_id", "SAP005");
  76. //
  77. //
  78. // if ("收据支付".equals(paymentType)) {
  79. // sapJson.put("ZINVOICE_AMT", payAmt);
  80. // } else {
  81. // sapJson.put("ZINVOICE_AMT", invoiceAmt);
  82. // }
  83. //
  84. // sapJson.put("BANKA", getString(dataForm, "textField_mejfoon9", ""));
  85. // sapJson.put("BLDAT", formatDate(dataForm, "dateField_l9nsavm3"));
  86. //
  87. // // 获取过账人 UID
  88. // String uid = getPostingUserUid(dataForm);
  89. // sapJson.put("USNAM", uid);
  90. //
  91. // sapJson.put("BUDAT", formatDate(dataForm, "dateField_mhxdzyaa"));
  92. // sapJson.put("ZOA_TYPE", "无票预付".equals(paymentType) ? "AD" : "NP");
  93. // sapJson.put("ZPAY_AMT", payAmt);
  94. // sapJson.put("BUKRS", getString(dataForm, "textField_mejfj9iw", ""));
  95. // sapJson.put("BANKN", getString(dataForm, "textField_mejfoon8", ""));
  96. // sapJson.put("WAERS", getString(dataForm, "selectField_mejfoong", ""));
  97. // sapJson.put("KOINH", getString(dataForm, "textField_mejezfwl", ""));
  98. // sapJson.put("LIFNR", getString(dataForm, "textField_mejezfwv", ""));
  99. //
  100. // // 设置凭证类型 & 构建 ITEM
  101. // JSONArray itemArray = new JSONArray();
  102. // if ("发票支付".equals(paymentType)) {
  103. // sapJson.put("BLART", "Z2");
  104. // buildInvoicePaymentItems(dataForm, "tableField_l6ujr47b", itemArray);
  105. // } else if ("无票预付".equals(paymentType)) {
  106. // sapJson.put("BLART", "Z4");
  107. // sapJson.put("UMSKZ", "A");
  108. // buildAdvancePaymentItem(dataForm, itemArray);
  109. // } else if ("收据支付".equals(paymentType)) {
  110. // sapJson.put("BLART", "Z2");
  111. // buildReceiptPaymentItems(dataForm, "tableField_mi7c3wl9", itemArray);
  112. // } else if ("100%清预付款".equals(paymentType)) {
  113. // sapJson.put("BLART", "Z2");
  114. // String xref1 = "", xref2 = "";
  115. // List<Map<String, Object>> refList = getList(dataForm, "tableField_mi8q495e");
  116. // if (refList != null && !refList.isEmpty()) {
  117. // if (refList.size() == 1) {
  118. // xref1 = getString(refList.get(0), "textField_mi8q495f", "");
  119. // } else {
  120. // refList.sort((a, b) -> {
  121. // Long timeA = getDateTimestamp(a, "dateField_mj13wpls");
  122. // Long timeB = getDateTimestamp(b, "dateField_mj13wpls");
  123. // return Long.compare(timeB, timeA);
  124. // });
  125. // xref1 = getString(refList.get(0), "textField_mi8q495f", "");
  126. // xref2 = getString(refList.get(1), "textField_mi8q495f", "");
  127. // }
  128. // }
  129. // buildClearAdvanceItems(dataForm, "tableField_l6ujr47b", xref1, xref2, itemArray);
  130. // }
  131. //
  132. // sapJson.put("ITEM", itemArray);
  133. //
  134. // // 调用 SAP 接口
  135. // log.info("发起POST请求:URL={},参数={}", QA_sapUrl + "SAP005", sapJson);
  136. // System.out.println(sapJson);
  137. // String post = HttpUtil.post(QA_sapUrl + "SAP005", null, sapJson.toString(), null);
  138. // log.info("{} POST反馈={}", getString(dataForm, "textField_mi73dy3n", ""), post);
  139. // System.out.println("POST反馈=====" + post);
  140. //
  141. // handleSapResponse(post, InstanceId, dataForm, paymentType);
  142. // }
  143. // === 辅助方法(全部为 private static 或局部 lambda,但 Java 不支持局部函数,故用 private 方法)===
  144. // 注意:这些方法必须定义在类中,但未扩展主逻辑
  145. private String getString(Map map, String key, String defaultValue) {
  146. Object val = map.get(key);
  147. return val instanceof String ? (String) val : defaultValue;
  148. }
  149. private String getNumberValue(Map map, String key) {
  150. Object val = map.get(key);
  151. if (val == null || "".equals(val)) return "0";
  152. return val.toString();
  153. }
  154. private Long getDateTimestamp(Map map, String key) {
  155. Object val = map.get(key);
  156. if (val instanceof Number) {
  157. return ((Number) val).longValue();
  158. }
  159. return 0L;
  160. }
  161. private String formatDate(Map map, String dateKey) {
  162. Object val = map.get(dateKey);
  163. if (val instanceof Long) {
  164. return CusutUtil.getFormatDate((Long) val);
  165. }
  166. return "";
  167. }
  168. @SuppressWarnings("unchecked")
  169. private List<Map<String, Object>> getList(Map map, String key) {
  170. Object val = map.get(key);
  171. if (val instanceof List) {
  172. return (List<Map<String, Object>>) val;
  173. }
  174. return null;
  175. }
  176. private String getPostingUserUid(Map dataForm) {
  177. String empId = dataForm.get("employeeField_mhxdzya9_id").toString();
  178. if (empId.isEmpty()) {
  179. return "TEST-CN001";
  180. }
  181. List<Map<String, Object>> conditions = Arrays.asList(
  182. buildCondition("textField_l6dddg5k", empId, "TEXT", "eq", "TextField")
  183. );
  184. String listJson = JSON.toJSONString(conditions);
  185. YDParam YGydParam = _getYDTokenZXXZ(listJson);
  186. DDR_New result = ydClient.queryData(YGydParam, YDConf.FORM_QUERY.retrieve_search_form);
  187. List<Map> dataList = (List<Map>) result.getData();
  188. if (dataList != null && !dataList.isEmpty()) {
  189. Map formData = (Map) dataList.get(0).get("formData");
  190. Object uidObj = formData.get("textField_l6djch1m");
  191. if (uidObj != null) {
  192. return "CHN-0" + uidObj.toString();
  193. }
  194. }
  195. return "TEST-CN001";
  196. }
  197. private void buildInvoicePaymentItems(Map dataForm, String tableKey, JSONArray itemArray) {
  198. buildCommonItems(dataForm, tableKey, itemArray, true, "", "");
  199. }
  200. private void buildReceiptPaymentItems(Map dataForm, String tableKey, JSONArray itemArray) {
  201. buildCommonItems(dataForm, tableKey, itemArray, false, "", "");
  202. }
  203. private void buildClearAdvanceItems(Map dataForm, String tableKey, String xref1, String xref2, JSONArray itemArray) {
  204. buildCommonItems(dataForm, tableKey, itemArray, true, xref1, xref2);
  205. }
  206. private void buildCommonItems(Map dataForm, String tableKey, JSONArray itemArray, boolean hasTax, String xref1, String xref2) {
  207. List<Map<String, Object>> rows = getList(dataForm, tableKey);
  208. if (rows == null || rows.isEmpty()) return;
  209. int index = 1;
  210. for (Map<String, Object> row : rows) {
  211. JSONObject item = new JSONObject();
  212. item.put("KOSTL", getString(row, "textField_mi5kjmwk", ""));
  213. item.put("DMBTR", getNumberValue(row, "numberField_mi7c3wky"));
  214. item.put("XREF1", xref1);
  215. if (!xref2.isEmpty()) {
  216. item.put("XREF2", xref2);
  217. }
  218. item.put("ZOA_ITEMNO", formatItemNo(index++));
  219. item.put("HKONT", getString(row, "textField_l6lvt6lj", ""));
  220. item.put("ZTAXOUT_AMT", "0");
  221. item.put("MWSKZ", hasTax ? getString(row, "textField_l7a6bzpv", "") : "");
  222. item.put("ZTAX_AMT", hasTax ? getNumberValue(row, "numberField_l6vu65fp") : "0");
  223. item.put("SGTXT", getString(row, "textField_mejfoonz", ""));
  224. itemArray.add(item);
  225. }
  226. }
  227. private void buildAdvancePaymentItem(Map dataForm, JSONArray itemArray) {
  228. JSONObject item = new JSONObject();
  229. item.put("ZOA_ITEMNO", "001");
  230. item.put("HKONT", "");
  231. item.put("KOSTL", "");
  232. item.put("MWSKZ", "");
  233. item.put("ZTAX_AMT", "0");
  234. item.put("ZTAXOUT_AMT", "0");
  235. item.put("SGTXT", "");
  236. String payAmtStr = getNumberValue(dataForm, "numberField_mejfoool_value");
  237. try {
  238. BigDecimal amt = new BigDecimal(payAmtStr).setScale(2, RoundingMode.HALF_UP);
  239. item.put("DMBTR", amt);
  240. } catch (Exception e) {
  241. item.put("DMBTR", "0");
  242. }
  243. item.put("XREF1", getString(dataForm, "textareaField_mejfoonw", ""));
  244. itemArray.add(item);
  245. }
  246. private String formatItemNo(int index) {
  247. if (index < 10) return "00" + index;
  248. if (index < 100) return "0" + index;
  249. return String.valueOf(index);
  250. }
  251. private void handleSapResponse(String post, String instanceId, Map dataForm, String paymentType) {
  252. if (post == null || post.trim().isEmpty()) {
  253. updateFormStatus(instanceId, post, "失败");
  254. return;
  255. }
  256. try {
  257. JSONArray jsonArray = new JSONArray(post);
  258. if (jsonArray.isEmpty()) {
  259. updateFormStatus(instanceId, "Empty response", "失败");
  260. return;
  261. }
  262. cn.hutool.json.JSONObject resp = jsonArray.getJSONObject(0);
  263. String msgType = resp.getStr("E_SYSMSGTYPE");
  264. String message = resp.getStr("E_MESSAGE");
  265. if ("S".equals(msgType)) {
  266. String e_belnr = resp.getStr("E_BELNR");
  267. if (e_belnr != null && e_belnr.contains(";")) {
  268. e_belnr = e_belnr.split(";")[0];
  269. }
  270. String year = resp.getStr("E_GJAHR");
  271. updateFormStatus(instanceId, year, e_belnr, message, "成功");
  272. if ("发票支付".equals(paymentType)) {
  273. FPGX(instanceId, e_belnr, getString(dataForm, "textField_mi73dy3n", ""));
  274. }
  275. } else {
  276. updateFormStatus(instanceId, message, "失败");
  277. }
  278. } catch (Exception ex) {
  279. log.error("解析 SAP 响应失败", ex);
  280. updateFormStatus(instanceId, "Response parse error: " + ex.getMessage(), "失败");
  281. }
  282. }
  283. private void updateFormStatus(String instanceId, String field1, String field2, String field3, String status) {
  284. ydClient.operateData(
  285. YDParam.builder()
  286. .appType("APP_N9NPHVTQLPBPO8MR6WFG")
  287. .systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW")
  288. .formInstanceId(instanceId)
  289. .updateFormDataJson(JSON.toJSONString(UtilMap.map(
  290. "textField_l9nsavm2, textField_mejezfwk, textareaField_mi5kjmxb, selectField_mi72r4s6",
  291. field1, field2, field3, status)))
  292. .build(),
  293. YDConf.FORM_OPERATION.update
  294. );
  295. }
  296. private void updateFormStatus(String instanceId, String message, String status) {
  297. ydClient.operateData(
  298. YDParam.builder()
  299. .appType("APP_N9NPHVTQLPBPO8MR6WFG")
  300. .systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW")
  301. .formInstanceId(instanceId)
  302. .updateFormDataJson(JSON.toJSONString(UtilMap.map(
  303. "textareaField_mi5kjmxb, selectField_mi72r4s6",
  304. message, status)))
  305. .build(),
  306. YDConf.FORM_OPERATION.update
  307. );
  308. }
  309. // @Override
  310. public void NonPoinsetSAP0005(String type, String InstanceId) {
  311. YDParam ydParam = _getYDTokenKPD();
  312. ydParam.setFormInstanceId(InstanceId);
  313. DDR_New ddr = ydClient.queryData(ydParam, YDConf.FORM_QUERY.retrieve_id);
  314. Map dataForm = ddr.getFormData();
  315. // dataForm.put("InstanceId", InstanceId);
  316. JSONObject sapJson = new JSONObject();
  317. JSONObject upJson = new JSONObject();
  318. String PD = (String) dataForm.get("selectField_mj1cq2oz");//是否生成SAP凭证
  319. String SAPID = (String) dataForm.get("textField_mejezfwk");//SAP凭证号码
  320. String SFXCFK = (String) dataForm.get("radioField_mj1gc7qe");//仅携程付款是否
  321. /**
  322. * 是否需要生成SAP凭证
  323. */
  324. if (("否".equals(PD) && !SAPID.equals("")) || "是".equals(SFXCFK)) {
  325. FPGX(InstanceId, SAPID, (String) dataForm.get("textField_mi73dy3n"));
  326. } else if (!"否".equals(PD)) {
  327. // 添加顶级键值对
  328. sapJson.put("ZDUEDATE", CusutUtil.getFormatDate((Long) dataForm.get("dateField_mejfoonv"))); //Due date / 到期日
  329. sapJson.put("BKTXT", dataForm.get("textareaField_mejfoonw"));//备注 抬头文本
  330. sapJson.put("ZOA_NUMBER", dataForm.get("textField_mi73dy3n")); //钉钉单据号dataForm.get("textField_mi73dy3n")
  331. if (dataForm.get("selectField_mejfoona").equals("收据支付")) {//☑ 票据支付时 代码ZINVOICE_AMT 默认ZPAY_AMT的值
  332. sapJson.put("ZINVOICE_AMT", dataForm.get("numberField_mejfoool_value").equals("") ? "0" : dataForm.get("numberField_mejfoool_value"));//支付金额
  333. } else {
  334. sapJson.put("ZINVOICE_AMT", dataForm.get("numberField_mejfoook_value").equals("") ? "0" : dataForm.get("numberField_mejfoook_value"));//发票总额
  335. }
  336. sapJson.put("BANKA", dataForm.get("textField_mejfoon9")); //开户行
  337. sapJson.put("BLDAT", CusutUtil.getFormatDate((Long) dataForm.get("dateField_l9nsavm3"))); //凭证日期ƒ Date / 申请日期
  338. String uid = "TEST-CN001";
  339. String uname = "";
  340. if (!dataForm.get("employeeField_mhxdzya9_id").equals("")) {
  341. List<Map<String, Object>> conditions = new ArrayList<>(Arrays.asList(buildCondition("textField_l6dddg5k", dataForm.get("employeeField_mhxdzya9_id"), "TEXT", "eq", "TextField")));
  342. String listJson = JSON.toJSONString(conditions);
  343. YDParam YGydParam = _getYDTokenZXXZ(listJson);
  344. List<Map> dataList = (List<Map>) ydClient.queryData(YGydParam, YDConf.FORM_QUERY.retrieve_search_form).getData();
  345. if (dataList != null && dataList.size() > 0) {
  346. Map map = dataList.get(0);
  347. Map formData = (Map) map.get("formData");
  348. uid = formData.get("textField_l6djch1m").toString();
  349. uid = "CHN-0" + uid;
  350. }
  351. }
  352. // uid = "CHN-01000332";//测试过账人
  353. sapJson.put("USNAM", uid); //过账人
  354. sapJson.put("BUDAT", CusutUtil.getFormatDate((Long) dataForm.get("dateField_mhxdzyaa"))); //过账日期
  355. sapJson.put("ZOA_TYPE", dataForm.get("selectField_mejfoona").equals("无票预付") || dataForm.get("selectField_mejfoona").equals("100%清预付款") || dataForm.get("selectField_mejfoona").equals("100%清收据") ? "AD" : "NP");//OA单据类型
  356. sapJson.put("ZPAY_AMT", dataForm.get("numberField_mejfoool_value").equals("") ? "0" : dataForm.get("numberField_mejfoool_value")); //支付金额
  357. sapJson.put("BUKRS", dataForm.get("textField_mejfj9iw"));//公司代码
  358. sapJson.put("BANKN", dataForm.get("textField_mejfoon8")); //银行账号
  359. sapJson.put("WAERS", dataForm.get("selectField_mejfoong")); //币种
  360. sapJson.put("KOINH", dataForm.get("textField_mejezfwl")); //收款方名称
  361. sapJson.put("LIFNR", dataForm.get("textField_mejezfwv"));//供应商代码
  362. sapJson.put("interface_id", "SAP005");
  363. //获取子表
  364. if (dataForm.get("selectField_mejfoona").equals("发票支付")) {
  365. sapJson.put("BLART", "Z2");//凭证类型
  366. JSONArray itemArray = new JSONArray();
  367. int x = 1;//OA单据行号累计用
  368. List<Map<String, Object>> tableFils = (List<Map<String, Object>>) dataForm.get("tableField_l6ujr47b");
  369. if (tableFils != null && tableFils.size() > 0) {
  370. for (int n = 0; n < tableFils.size(); n++) {
  371. Map<String, Object> row = new HashMap(tableFils.get(n));
  372. JSONObject itemObj = new JSONObject();
  373. itemObj.put("KOSTL", String.valueOf(row.get("textField_mi5kjmwk"))); //成本中心
  374. itemObj.put("DMBTR", String.valueOf(row.get("numberField_l6ujr47g_value"))); //不含税金额
  375. itemObj.put("XREF1", "");//参考码 9000242
  376. String sjItemNo = "";
  377. if (x < 10) {
  378. sjItemNo += "00" + x;
  379. } else if (x < 100) {
  380. sjItemNo += "0" + x;
  381. } else {
  382. sjItemNo += x;
  383. }
  384. x++;
  385. itemObj.put("ZOA_ITEMNO", sjItemNo);//OA单据行号
  386. itemObj.put("HKONT", String.valueOf(row.get("textField_l6lvt6lj"))); //会计科目
  387. itemObj.put("ZTAXOUT_AMT", "0");//进项税转出金额 、、、 String.valueOf(row.get("numberField_l6bx7hqk_value"))
  388. itemObj.put("MWSKZ", String.valueOf(row.get("textField_l7a6bzpv")));///税码
  389. itemObj.put("ZTAX_AMT", String.valueOf(row.get("numberField_memejxqp")).equals("") ? "0" : String.valueOf(row.get("numberField_memejxqp"))); //税额
  390. itemObj.put("SGTXT", String.valueOf(row.get("textField_mejfoonz"))); //行项目文本
  391. itemArray.put(itemObj);
  392. }
  393. }
  394. sapJson.put("ITEM", itemArray);
  395. } else if (dataForm.get("selectField_mejfoona").equals("无票预付")) {
  396. sapJson.put("BLART", "Z4");//凭证类型
  397. sapJson.put("UMSKZ", "A");//特别总账标识
  398. JSONArray SapItem = new JSONArray(); //子表
  399. JSONObject itemObject = new JSONObject();
  400. itemObject.put("ZOA_ITEMNO", "001"); //OA单据行号
  401. itemObject.put("HKONT", ""); //会计科目
  402. itemObject.put("KOSTL", ""); //成本中心
  403. BigDecimal bigBhsje = new BigDecimal(dataForm.get("numberField_mejfoool_value").toString());//改大数
  404. bigBhsje = bigBhsje.setScale(2, RoundingMode.HALF_UP);
  405. itemObject.put("DMBTR", bigBhsje); //不含税金额
  406. // itemObject.put("DMBTR", object.get("numberField_l6bwb4hg").toString()); //不含税金额--支付金额
  407. itemObject.put("MWSKZ", ""); //税码
  408. itemObject.put("ZTAX_AMT", "0"); //税额
  409. itemObject.put("ZTAXOUT_AMT", "0"); //进项税转出金额
  410. itemObject.put("SGTXT", ""); //行项目文本
  411. itemObject.put("XREF1", dataForm.get("textareaField_mejfoonw")); //cir项目号
  412. SapItem.put(itemObject);
  413. sapJson.put("ITEM", SapItem);
  414. } else if (dataForm.get("selectField_mejfoona").equals("收据支付")) {
  415. sapJson.put("BLART", "Z2");//凭证类型
  416. JSONArray itemArray = new JSONArray();
  417. int x = 1;//OA单据行号累计用
  418. List<Map<String, Object>> tableFils = (List<Map<String, Object>>) dataForm.get("tableField_mi7c3wl9");
  419. if (tableFils != null && tableFils.size() > 0) {
  420. for (int n = 0; n < tableFils.size(); n++) {
  421. Map<String, Object> row = new HashMap(tableFils.get(n));
  422. JSONObject itemObj = new JSONObject();
  423. itemObj.put("KOSTL", String.valueOf(row.get("textField_mi7c3wku"))); //成本中心
  424. itemObj.put("DMBTR", String.valueOf(row.get("numberField_mi7c3wky_value"))); //不含税金额
  425. itemObj.put("XREF1", "");//参考码 9000242
  426. String sjItemNo = "";
  427. if (x < 10) {
  428. sjItemNo += "00" + x;
  429. } else if (x < 100) {
  430. sjItemNo += "0" + x;
  431. } else {
  432. sjItemNo += x;
  433. }
  434. x++;
  435. itemObj.put("ZOA_ITEMNO", sjItemNo);//OA单据行号
  436. itemObj.put("HKONT", String.valueOf(row.get("textField_mi7c3wl5"))); //会计科目
  437. itemObj.put("ZTAXOUT_AMT", "0");//进项税转出金额 、、、 String.valueOf(row.get("numberField_l6bx7hqk_value"))
  438. itemObj.put("MWSKZ", "");///税码
  439. itemObj.put("ZTAX_AMT", "0"); //税额
  440. itemObj.put("SGTXT", String.valueOf(row.get("textField_mi7c3wkn"))); //行项目文本
  441. itemArray.put(itemObj);
  442. }
  443. }
  444. sapJson.put("ITEM", itemArray);
  445. } else if (dataForm.get("selectField_mejfoona").equals("100%清预付款")) {
  446. String XREF1 = "";
  447. String XREF2 = "";
  448. /***
  449. * 获取参考代码1 2
  450. */
  451. List<Map<String, Object>> XREFlist = (List<Map<String, Object>>) dataForm.get("tableField_mi8q495e");
  452. if (XREFlist != null && !XREFlist.isEmpty()) {
  453. if (XREFlist.size() == 1) {
  454. Map<String, Object> row = XREFlist.get(0);
  455. XREF1 = row.get("textField_mi8q495f") != null ? row.get("textField_mi8q495f").toString() : "";
  456. } else {
  457. // 多于一条,按时间戳降序排序
  458. XREFlist.sort((a, b) -> {
  459. Long timeA = a.get("dateField_mj13wpls") instanceof Number
  460. ? ((Number) a.get("dateField_mj13wpls")).longValue()
  461. : 0L;
  462. Long timeB = b.get("dateField_mj13wpls") instanceof Number
  463. ? ((Number) b.get("dateField_mj13wpls")).longValue()
  464. : 0L;
  465. return Long.compare(timeB, timeA); // 降序:最新在前
  466. });
  467. // 取前两条
  468. XREF1 = XREFlist.get(0).get("textField_mi8q495f") != null
  469. ? XREFlist.get(0).get("textField_mi8q495f").toString() : "";
  470. XREF2 = XREFlist.get(1).get("textField_mi8q495f") != null
  471. ? XREFlist.get(1).get("textField_mi8q495f").toString() : "";
  472. }
  473. }
  474. sapJson.put("BLART", "Z2");//凭证类型
  475. JSONArray itemArray = new JSONArray();
  476. int x = 1;//OA单据行号累计用
  477. List<Map<String, Object>> tableFils = (List<Map<String, Object>>) dataForm.get("tableField_l6ujr47b");
  478. if (tableFils != null && tableFils.size() > 0) {
  479. for (int n = 0; n < tableFils.size(); n++) {
  480. Map<String, Object> row = new HashMap(tableFils.get(n));
  481. JSONObject itemObj = new JSONObject();
  482. itemObj.put("KOSTL", String.valueOf(row.get("textField_mi5kjmwk"))); //成本中心
  483. itemObj.put("DMBTR", String.valueOf(row.get("numberField_l6ujr47g_value"))); //不含税金额
  484. itemObj.put("XREF1", XREF1);//参考码1
  485. itemObj.put("XREF2", XREF2);//参考码2
  486. String sjItemNo = "";
  487. if (x < 10) {
  488. sjItemNo += "00" + x;
  489. } else if (x < 100) {
  490. sjItemNo += "0" + x;
  491. } else {
  492. sjItemNo += x;
  493. }
  494. x++;
  495. itemObj.put("ZOA_ITEMNO", sjItemNo);//OA单据行号
  496. itemObj.put("HKONT", String.valueOf(row.get("textField_l6lvt6lj"))); //会计科目
  497. itemObj.put("ZTAXOUT_AMT", "0");//进项税转出金额 、、、 String.valueOf(row.get("numberField_l6bx7hqk_value"))
  498. itemObj.put("MWSKZ", String.valueOf(row.get("textField_l7a6bzpv")));///税码
  499. itemObj.put("ZTAX_AMT", String.valueOf(row.get("numberField_memejxqp")).equals("") ? "0" : String.valueOf(row.get("numberField_memejxqp"))); //税额
  500. itemObj.put("SGTXT", String.valueOf(row.get("textField_mejfoonz"))); //行项目文本
  501. itemArray.put(itemObj);
  502. }
  503. }
  504. sapJson.put("ITEM", itemArray);
  505. } else if (dataForm.get("selectField_mejfoona").equals("100%清收据")) {
  506. String XREF1 = "";
  507. String XREF2 = "";
  508. /***
  509. * 获取参考代码1 2
  510. */
  511. List<Map<String, Object>> XREFlist = (List<Map<String, Object>>) dataForm.get("tableField_mi8q495e");
  512. if (XREFlist != null && !XREFlist.isEmpty()) {
  513. if (XREFlist.size() == 1) {
  514. Map<String, Object> row = XREFlist.get(0);
  515. XREF1 = row.get("textField_mi8q495f") != null ? row.get("textField_mi8q495f").toString() : "";
  516. } else {
  517. // 多于一条,按时间戳降序排序
  518. XREFlist.sort((a, b) -> {
  519. Long timeA = a.get("dateField_mj13wpls") instanceof Number
  520. ? ((Number) a.get("dateField_mj13wpls")).longValue()
  521. : 0L;
  522. Long timeB = b.get("dateField_mj13wpls") instanceof Number
  523. ? ((Number) b.get("dateField_mj13wpls")).longValue()
  524. : 0L;
  525. return Long.compare(timeB, timeA); // 降序:最新在前
  526. });
  527. // 取前两条
  528. XREF1 = XREFlist.get(0).get("textField_mi8q495f") != null
  529. ? XREFlist.get(0).get("textField_mi8q495f").toString() : "";
  530. XREF2 = XREFlist.get(1).get("textField_mi8q495f") != null
  531. ? XREFlist.get(1).get("textField_mi8q495f").toString() : "";
  532. }
  533. }
  534. sapJson.put("BLART", "Z2");//凭证类型
  535. JSONArray itemArray = new JSONArray();
  536. int x = 1;//OA单据行号累计用
  537. List<Map<String, Object>> tableFils = (List<Map<String, Object>>) dataForm.get("tableField_mi7c3wl9");
  538. if (tableFils != null && tableFils.size() > 0) {
  539. for (int n = 0; n < tableFils.size(); n++) {
  540. Map<String, Object> row = new HashMap(tableFils.get(n));
  541. JSONObject itemObj = new JSONObject();
  542. itemObj.put("KOSTL", String.valueOf(row.get("textField_mi7c3wku"))); //成本中心
  543. itemObj.put("DMBTR", String.valueOf(row.get("numberField_mi7c3wky_value"))); //不含税金额
  544. itemObj.put("XREF1", XREF1);//参考码1
  545. itemObj.put("XREF2", XREF2);//参考码2
  546. String sjItemNo = "";
  547. if (x < 10) {
  548. sjItemNo += "00" + x;
  549. } else if (x < 100) {
  550. sjItemNo += "0" + x;
  551. } else {
  552. sjItemNo += x;
  553. }
  554. x++;
  555. itemObj.put("ZOA_ITEMNO", sjItemNo);//OA单据行号
  556. itemObj.put("HKONT", String.valueOf(row.get("textField_mi7c3wl5"))); //会计科目
  557. itemObj.put("ZTAXOUT_AMT", "0");//进项税转出金额 、、、 String.valueOf(row.get("numberField_l6bx7hqk_value"))
  558. itemObj.put("MWSKZ", "");///税码
  559. itemObj.put("ZTAX_AMT", "0"); //税额
  560. itemObj.put("SGTXT", String.valueOf(row.get("textField_mi7c3wkn"))); //行项目文本
  561. itemArray.put(itemObj);
  562. }
  563. }
  564. sapJson.put("ITEM", itemArray);
  565. }
  566. /***
  567. * 调用接口
  568. */
  569. System.out.println(sapJson);
  570. log.info("发起POST请求:URL={},参数={}", QA_sapUrl + "SAP005", sapJson);
  571. String post = HttpUtil.post(QA_sapUrl + "SAP005", null, sapJson.toString(), null);
  572. log.info(dataForm.get("textField_mi73dy3n") + "POST反馈={}", post);
  573. System.out.println("POST反馈=====" + post);
  574. if (!post.equals("")) {
  575. JSONArray jsonArray = new JSONArray(post);
  576. if (jsonArray.size() > 0) {
  577. String voucherNumber = "";
  578. try {
  579. cn.hutool.json.JSONObject postJsonObject = jsonArray.getJSONObject(0);
  580. String E_SYSMSGTYPE = postJsonObject.getStr("E_SYSMSGTYPE");//状态
  581. String E_MESSAGE = postJsonObject.getStr("E_MESSAGE");//SAP005 接口 反馈值
  582. if (E_SYSMSGTYPE.equals("S")) {
  583. String e_belnr = postJsonObject.getStr("E_BELNR");
  584. if (e_belnr.contains(";")) {
  585. String[] split = e_belnr.split(";");
  586. try {
  587. e_belnr = split[0];//+ ";";
  588. } catch (Exception ex) {
  589. e_belnr = ";";
  590. }
  591. }
  592. voucherNumber = e_belnr;
  593. String E_GJAHR = postJsonObject.getStr("E_GJAHR");//凭证年度
  594. // 执行完加入,把更改表单凭证数据
  595. ydClient.operateData(YDParam.builder().appType("APP_N9NPHVTQLPBPO8MR6WFG").systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW").formInstanceId(String.valueOf(InstanceId)).updateFormDataJson(JSON.toJSONString(UtilMap.map("textField_l9nsavm2, textField_mejezfwk, textareaField_mi5kjmxb, selectField_mi72r4s6", E_GJAHR, e_belnr, E_MESSAGE, "成功"))).build(), YDConf.FORM_OPERATION.update);
  596. /**
  597. * 执行勾选发票
  598. */
  599. if (dataForm.get("selectField_mejfoona").equals("发票支付") || dataForm.get("selectField_mejfoona").equals("100%清预付款")) {
  600. FPGX(InstanceId, voucherNumber, (String) dataForm.get("textField_mi73dy3n"));
  601. }
  602. } else {
  603. // 报错写入
  604. ydClient.operateData(YDParam.builder().appType("APP_N9NPHVTQLPBPO8MR6WFG").systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW").formInstanceId(String.valueOf(InstanceId)).updateFormDataJson(JSON.toJSONString(UtilMap.map("textareaField_mi5kjmxb, selectField_mi72r4s6", E_MESSAGE, "失败"))).build(), YDConf.FORM_OPERATION.update);
  605. }
  606. } catch (Exception ex) {
  607. }
  608. } else {
  609. }
  610. } else {
  611. // 报错写入
  612. ydClient.operateData(YDParam.builder().appType("APP_N9NPHVTQLPBPO8MR6WFG").systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW").formInstanceId(String.valueOf(InstanceId)).updateFormDataJson(JSON.toJSONString(UtilMap.map("textareaField_mi5kjmxb, selectField_mi72r4s6", post, "失败"))).build(), YDConf.FORM_OPERATION.update);
  613. }
  614. }
  615. }
  616. /***
  617. * 发票勾选处理
  618. * @param InstanceId
  619. * @param voucherNumber
  620. */
  621. @Override
  622. public void FPGX(String InstanceId, String voucherNumber, String OAnumber) {
  623. try {
  624. YDParam ydParam = _getYDTokenKPD();
  625. ydParam.setFormInstanceId(InstanceId);
  626. DDR_New ddr = ydClient.queryData(ydParam, YDConf.FORM_QUERY.retrieve_id);
  627. Map dataForm = ddr.getFormData();
  628. @SuppressWarnings("unchecked")
  629. List<Map<String, Object>> tableFils = (List<Map<String, Object>>) dataForm.get("tableField_l6ujr47b");
  630. if (tableFils == null || tableFils.isEmpty()) {
  631. return;
  632. }
  633. String nowDate = CusutUtil.getNowDate();
  634. Map<String, Object> request = new LinkedHashMap<>();
  635. request.put("voucherNumber", voucherNumber);
  636. request.put("voucherstatus", "0");
  637. request.put("voucherdate", nowDate);
  638. request.put("applytime", nowDate);
  639. request.put("bookeepflag", "1");
  640. request.put("syssource", "第三方系统规定");
  641. JSONArray invoices = new JSONArray();
  642. for (Map<String, Object> row : tableFils) {
  643. if (!row.get("selectField_mepxp7tc").toString().contains("发票") && !row.get("selectField_mepxp7tc").toString().contains("全电")) {
  644. row.put("selectField_mgz2tut4", "不相关");
  645. continue;
  646. }
  647. if ("".equals(row.get("textField_l6ujr47c")) || "泰森(江苏)畜禽业发展有限公司".equals(row.get("textField_l6vk7131"))) {
  648. row.put("selectField_mgz2tut4", "不相关");
  649. continue;
  650. }
  651. Object instanceIdObj = row.get("textField_mi1l1tcc");
  652. if (instanceIdObj == null) continue;
  653. String instanceId = instanceIdObj.toString();
  654. // 查询发票详情
  655. DDR_New invoiceDdr = ydClient.queryData(
  656. YDParam.builder()
  657. .appType("APP_N9NPHVTQLPBPO8MR6WFG")
  658. .systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW")
  659. .formUuid("FORM-4J7669A1Z1X22RIL61LB7AOXGRX82OHP45U6L51")
  660. .formInstanceId(instanceId)
  661. .build(),
  662. YDConf.FORM_QUERY.retrieve_id
  663. );
  664. Map formdata = invoiceDdr.getFormData();
  665. if (formdata == null) continue;
  666. Map<String, Object> invoice = new LinkedHashMap<>();
  667. invoice.put("taxno", safeGetString(formdata, "textField_l6u55vdn"));
  668. String fpType = safeGetString(formdata, "textField_l6u55vd8");
  669. invoice.put("invoicecode", fpType.contains("全电") ? "全电发票" : safeGetString(formdata, "textField_l6u55vd9"));
  670. invoice.put("invoicenumber", safeGetString(formdata, "textField_l6u55vd3"));
  671. invoice.put("usetax", safeGetString(formdata, "textField_l6vu65fs"));
  672. // 税率处理
  673. String taxRateStr = safeGetString(formdata, "textField_l6vvuq3f");
  674. double taxRate = 0.0;
  675. if (!taxRateStr.isEmpty()) {
  676. try {
  677. if (taxRateStr.endsWith("%")) {
  678. taxRate = Double.parseDouble(taxRateStr.substring(0, taxRateStr.lastIndexOf('%'))) / 100.0;
  679. } else {
  680. taxRate = Double.parseDouble(taxRateStr) / 100.0;
  681. }
  682. } catch (NumberFormatException ignored) {
  683. taxRate = 0.0;
  684. }
  685. }
  686. invoice.put("taxrate", taxRate);
  687. invoice.put("autodeduct", "1");
  688. invoice.put("oper", "1");
  689. invoices.add(invoice);
  690. }
  691. if (invoices.isEmpty()) {
  692. return;
  693. }
  694. request.put("invoices", invoices);
  695. List<Map<String, Object>> requestList = Collections.singletonList(request);
  696. String jsonBody = new ObjectMapper().writeValueAsString(requestList);
  697. RestTemplate restTemplate = new RestTemplate();
  698. String PROXY_URL = "https://poc.cloudpure.cn/api/ts/bookkeeping";
  699. HttpHeaders headers = new HttpHeaders();
  700. headers.setContentType(MediaType.APPLICATION_JSON);
  701. HttpEntity<String> entity = new HttpEntity<>(jsonBody, headers);
  702. ResponseEntity<String> response = restTemplate.postForEntity(PROXY_URL, entity, String.class);
  703. String responseBody = response.getBody();
  704. if (responseBody == null) {
  705. updateMainFormError(InstanceId, "Empty response from bookkeeping API");
  706. return;
  707. }
  708. ObjectMapper objectMapper = new ObjectMapper();
  709. JsonNode rootNode = objectMapper.readTree(responseBody);
  710. JsonNode dataArray = rootNode.path("data");
  711. String code = rootNode.path("code").asText();
  712. if ("0000".equals(code) && dataArray.isArray() && dataArray.size() > 0) {
  713. List<Map> updatedRows = new ArrayList<>();
  714. for (int i = 0; i < tableFils.size(); i++) {
  715. Map<String, Object> originalRow = tableFils.get(i);
  716. String fpInstanceId = safeGetString(originalRow, "textField_mi1l1tcc");
  717. String invoiceNoInTable = safeGetString(originalRow, "textField_l6ujr47c");
  718. String status = originalRow.containsKey("selectField_mgz2tut4") && !"".equals(originalRow.get("selectField_mgz2tut4")) ? (String) originalRow.get("selectField_mgz2tut4") : "未勾选";
  719. String returnMsg = "";
  720. // 匹配返回的发票结果
  721. for (JsonNode item : dataArray) {
  722. String respInvoiceNo = item.path("invoicenumber").asText();
  723. returnMsg = item.path("returnmsg").asText();
  724. if (respInvoiceNo.equals(invoiceNoInTable) && returnMsg.contains("申请成功")) {
  725. status = "已勾选";
  726. break;
  727. }
  728. }
  729. if ("不相关".equals(status)) {
  730. returnMsg = "";
  731. }
  732. // 构建更新后的行数据
  733. Map<String, Object> updatedRow = new HashMap<>(originalRow);
  734. updatedRow.put("selectField_mgz2tut4", status);
  735. updatedRow.put("textareaField_mi5kjmxc", returnMsg);
  736. // 保留级联字段原始ID(防止丢失)
  737. Object cascadeId = originalRow.get("cascadeSelectField_mejfoony_id");
  738. if (cascadeId != null) {
  739. updatedRow.put("cascadeSelectField_mejfoony", cascadeId);
  740. }
  741. updatedRows.add(updatedRow);
  742. // 更新发票子表单状态
  743. Map<String, Object> fpUpdateMap = new HashMap<>();
  744. fpUpdateMap.put("textField_l7efm5az", status);
  745. fpUpdateMap.put("textField_l7efm5ay", "是");
  746. fpUpdateMap.put("textField_lz0v4x8o", voucherNumber);
  747. fpUpdateMap.put("textField_lz0v4x8p", OAnumber);
  748. ydClient.operateData(
  749. YDParam.builder()
  750. .appType("APP_N9NPHVTQLPBPO8MR6WFG")
  751. .systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW")
  752. .formInstanceId(fpInstanceId)
  753. .updateFormDataJson(JSON.toJSONString(fpUpdateMap))
  754. .build(),
  755. YDConf.FORM_OPERATION.update
  756. );
  757. }
  758. // 更新主表单
  759. Map<String, Object> mainUpdate = new HashMap<>();
  760. mainUpdate.put("tableField_l6ujr47b", updatedRows);
  761. mainUpdate.put("textareaField_mi7et0wm", rootNode.toString());
  762. ydClient.operateData(
  763. YDParam.builder()
  764. .appType("APP_N9NPHVTQLPBPO8MR6WFG")
  765. .systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW")
  766. .formInstanceId(InstanceId)
  767. .updateFormDataJson(JSON.toJSONString(mainUpdate))
  768. .build(),
  769. YDConf.FORM_OPERATION.update
  770. );
  771. } else {
  772. // 接口调用失败或无有效数据
  773. updateMainFormError(InstanceId, rootNode.toString());
  774. }
  775. } catch (Exception ex) {
  776. ex.printStackTrace();
  777. updateMainFormError(InstanceId, "Exception: " + ex.getMessage());
  778. }
  779. }
  780. // === 内联辅助逻辑(以局部方法形式模拟,实际用 private 方法,但按要求不扩展 => 改为内联表达式)===
  781. // 因不能新增方法,以下逻辑直接内联,但为清晰起见,此处用注释说明“安全获取”逻辑:
  782. // 实际替换为:(map.get(key) instanceof String ? (String) map.get(key) : "")
  783. private String safeGetString(Map map, String key) {
  784. Object val = map.get(key);
  785. return val instanceof String ? (String) val : "";
  786. }
  787. private void updateMainFormError(String instanceId, String errorMsg) {
  788. ydClient.operateData(
  789. YDParam.builder()
  790. .appType("APP_N9NPHVTQLPBPO8MR6WFG")
  791. .systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW")
  792. .formInstanceId(instanceId)
  793. .updateFormDataJson(JSON.toJSONString(UtilMap.map("textareaField_mi7et0wm", errorMsg)))
  794. .build(),
  795. YDConf.FORM_OPERATION.update
  796. );
  797. }
  798. // @Override
  799. // public void FPGX(String InstanceId, String voucherNumber, String OAnumber) {
  800. // YDParam ydParam = _getYDTokenKPD();
  801. // ydParam.setFormInstanceId(InstanceId);
  802. // DDR_New ddr = ydClient.queryData(ydParam, YDConf.FORM_QUERY.retrieve_id);
  803. // Map dataForm = ddr.getFormData();
  804. // try {
  805. // String nowDate = CusutUtil.getNowDate();
  806. // List<Map<String, Object>> requestList = new ArrayList<>();
  807. // Map<String, Object> request = new LinkedHashMap<>();
  808. // JSONArray invoices = new JSONArray();
  809. // ArrayList<String> ids = new ArrayList<>();
  810. // request.put("voucherNumber", voucherNumber);
  811. // request.put("voucherstatus", "0");
  812. // request.put("voucherdate", nowDate);
  813. // request.put("applytime", nowDate);
  814. // request.put("bookeepflag", "1");
  815. // request.put("syssource", "第三方系统规定");
  816. // List<Map> list = new ArrayList<>();
  817. // List<Map<String, Object>> tableFils = (List<Map<String, Object>>) dataForm.get("tableField_l6ujr47b");
  818. // if (tableFils != null && tableFils.size() > 0) {
  819. // list = (List<Map>) dataForm.get("tableField_l6ujr47b");
  820. // for (int n = 0; n < tableFils.size(); n++) {
  821. //
  822. // Map<String, Object> row = new HashMap(tableFils.get(n));
  823. // Map<Object, Object> invoice = new LinkedHashMap<>();
  824. //// String substring = row.getString("associationFormField_l6yglav7_id").replaceAll("\\\\", "").substring(1);
  825. // String instanceId = row.get("textField_mi1l1tcc").toString();
  826. //
  827. // Map formdata = ydClient.queryData(YDParam.builder().appType("APP_N9NPHVTQLPBPO8MR6WFG").systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW").formUuid("FORM-4J7669A1Z1X22RIL61LB7AOXGRX82OHP45U6L51").formInstanceId(instanceId).build(), YDConf.FORM_QUERY.retrieve_id).getFormData();
  828. // if (formdata != null) {
  829. // ids.add(instanceId);
  830. // JSONObject jsonObject = new JSONObject();
  831. // invoice.put("taxno", formdata.get("textField_l6u55vdn"));
  832. // if (formdata.get("textField_l6u55vd8").toString().contains("全电")) {
  833. // invoice.put("invoicecode", "全电发票");
  834. // } else {
  835. // invoice.put("invoicecode", formdata.get("textField_l6u55vd9"));
  836. // }
  837. // invoice.put("invoicenumber", formdata.get("textField_l6u55vd3"));
  838. // invoice.put("usetax", formdata.get("textField_l6vu65fs").toString());
  839. // try {
  840. // if (!formdata.containsKey("textField_l6vvuq3f") || formdata.get("textField_l6vvuq3f").equals("")) {
  841. // formdata.remove("textField_l6vvuq3f");
  842. // formdata.put("textField_l6vvuq3f", "0");
  843. // }
  844. // invoice.put("taxrate", Double.parseDouble(formdata.get("textField_l6vvuq3f").toString().substring(0, formdata.get("textField_l6vvuq3f").toString().lastIndexOf("%"))) / 100);
  845. // } catch (Exception ex) {
  846. // try {
  847. // invoice.put("taxrate", Double.parseDouble(formdata.get("textField_l6vvuq3f").toString()) / 100);
  848. // } catch (Exception ex2) {
  849. // invoice.put("taxrate", 0);
  850. // }
  851. // }
  852. // invoice.put("autodeduct", "1");
  853. // invoice.put("oper", "1");
  854. // jsonObject.toString();
  855. // invoices.put(invoice);
  856. // request.put("invoices", invoices);
  857. // }
  858. //
  859. // }
  860. // requestList.add(request);
  861. // String jsonBody = new ObjectMapper().writeValueAsString(requestList);
  862. // System.out.println(jsonBody.toString());
  863. // RestTemplate restTemplate = new RestTemplate();
  864. // String PROXY_URL = "https://poc.cloudpure.cn/api/ts/bookkeeping";
  865. // HttpHeaders headers = new HttpHeaders();
  866. // headers.setContentType(MediaType.APPLICATION_JSON);
  867. // ResponseEntity<String> response = restTemplate.postForEntity(PROXY_URL, new HttpEntity<>(jsonBody, headers), String.class);
  868. //
  869. // String responseBody = response.getBody();
  870. // try {
  871. // ObjectMapper objectMapper = new ObjectMapper();
  872. // JsonNode rootNode = objectMapper.readTree(responseBody);
  873. // ArrayList<Map> maps_YD = new ArrayList<>();
  874. // HashMap map = new HashMap();
  875. // // 获取 data 数组
  876. // JsonNode dataArray = rootNode.get("data");
  877. // String code = String.valueOf(rootNode.get("code"));
  878. // // 循环遍历 data 数组
  879. // if (dataArray.size() > 0 && code.equals("\"0000\"")) {
  880. //
  881. // for (int i = 0; i < list.size(); i++) {
  882. // Map sss2 = (Map) list.get(i);
  883. // String pd = (String) sss2.get("selectField_mgz2tut4");//发票是否勾选?
  884. // String fpidInstanceId = (String) sss2.get("textField_mi1l1tcc");//发票实例ID
  885. //
  886. // String returnMsg = "";
  887. // for (JsonNode dataItem : dataArray) {
  888. // returnMsg = dataItem.get("returnmsg").asText();
  889. // String invoicenumber = dataItem.get("invoicenumber").asText();
  890. // if (invoicenumber.equals(sss2.get("textField_l6ujr47c")) && !returnMsg.equals("未同步到该发票信息,请先进行同步发票操作!")) {
  891. // pd = "已勾选";
  892. // } else {
  893. // pd = "不相关";
  894. // }
  895. // }
  896. // sss2.put("cascadeSelectField_mejfoony", list.get(i).get("cascadeSelectField_mejfoony_id"));
  897. // sss2.put("selectField_mgz2tut4", pd);
  898. // sss2.put("textareaField_mi5kjmxc", returnMsg);
  899. // maps_YD.add(sss2);
  900. // //更改发票信息
  901. // HashMap FPMAP = new HashMap();
  902. // FPMAP.put("textField_l7efm5az", pd);
  903. // FPMAP.put("textField_l7efm5ay", "是");
  904. // FPMAP.put("textField_lz0v4x8o", voucherNumber);
  905. // FPMAP.put("textField_lz0v4x8p", OAnumber);
  906. // ydClient.operateData(YDParam.builder().appType("APP_N9NPHVTQLPBPO8MR6WFG").systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW").formInstanceId(String.valueOf(fpidInstanceId)).updateFormDataJson(JSON.toJSONString(FPMAP)).build(), YDConf.FORM_OPERATION.update);
  907. // }
  908. // map.put("tableField_l6ujr47b", maps_YD);
  909. // map.put("textareaField_mi7et0wm", rootNode);
  910. // ydClient.operateData(YDParam.builder().appType("APP_N9NPHVTQLPBPO8MR6WFG").systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW").formInstanceId(String.valueOf(InstanceId)).updateFormDataJson(JSON.toJSONString(map)).build(), YDConf.FORM_OPERATION.update);
  911. //
  912. // } else {
  913. //
  914. // // 报错写入
  915. // ydClient.operateData(YDParam.builder().appType("APP_N9NPHVTQLPBPO8MR6WFG").systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW").formInstanceId(String.valueOf(InstanceId)).updateFormDataJson(JSON.toJSONString(UtilMap.map("textareaField_mi7et0wm", rootNode))).build(), YDConf.FORM_OPERATION.update);
  916. //
  917. //
  918. // }
  919. //
  920. // } catch (Exception e) {
  921. // e.printStackTrace();
  922. // }
  923. //
  924. //
  925. // }
  926. //
  927. // } catch (Exception ex) {
  928. // ex.printStackTrace();
  929. // System.out.println(ex);
  930. // }
  931. //
  932. // }
  933. public YDParam _getYDTokenKPD() {
  934. /**
  935. * 泰森付款
  936. */
  937. return YDParam.builder().appType("APP_N9NPHVTQLPBPO8MR6WFG").systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW").build();
  938. }
  939. /**
  940. * 泰森付款 人员档案表
  941. */
  942. public static YDParam _getYDTokenZXXZ(String searchFieldJson) {
  943. return YDParam.builder().appType("APP_N9NPHVTQLPBPO8MR6WFG").systemToken("UM6660D1PGF2O34KAVVKG8XZ756E3O06MZX5LW").formUuid("FORM-4J7669A10FO250UJ9C6Q7CM00PC62YPW8DD6LT").searchFieldJson(searchFieldJson).build();
  944. }
  945. //匹配条件用
  946. private static final String KEY = "key";
  947. private static final String VALUE = "value";
  948. private static final String TYPE = "type";
  949. private static final String OPERATOR = "operator";
  950. private static final String COMPONENT_NAME = "componentName";
  951. private static Map<String, Object> buildCondition(String key, Object value, String type, String operator, String componentName) {
  952. Map<String, Object> condition = new HashMap<>();
  953. condition.put(KEY, key);
  954. condition.put(VALUE, value);
  955. condition.put(TYPE, type);
  956. condition.put(OPERATOR, operator);
  957. condition.put(COMPONENT_NAME, componentName);
  958. return condition;
  959. }
  960. }