From 7a3a72bf94a86641ead835b1b8be7644cffa9a53 Mon Sep 17 00:00:00 2001 From: LSH Date: 星期五, 06 一月 2023 08:12:19 +0800 Subject: [PATCH] # --- src/main/java/com/zy/ints/task/scheduler/ErpPrdtScheduler.java | 35 +++++++++++++++++++++++++++-------- 1 files changed, 27 insertions(+), 8 deletions(-) diff --git a/src/main/java/com/zy/ints/task/scheduler/ErpPrdtScheduler.java b/src/main/java/com/zy/ints/task/scheduler/ErpPrdtScheduler.java index 5fe2939..0231f2b 100644 --- a/src/main/java/com/zy/ints/task/scheduler/ErpPrdtScheduler.java +++ b/src/main/java/com/zy/ints/task/scheduler/ErpPrdtScheduler.java @@ -3,6 +3,7 @@ import com.core.common.Cools; import com.zy.asrs.entity.Mat; import com.zy.asrs.entity.Tag; +import com.zy.asrs.service.ApiLogService; import com.zy.asrs.service.MatService; import com.zy.asrs.service.TagService; import com.zy.ints.entity.Prdt; @@ -31,6 +32,10 @@ */ @Value("${erp.enabled}") private Boolean erpEnabled; + @Value("${erp.useName.ip}") + private String ip; + @Autowired + private ApiLogService apiLogService; @Autowired private TagService tagService; @Autowired @@ -65,15 +70,20 @@ matNew.setMaktx(prdt.getName()); matNew.setUnit(prdt.getUt()); matNew.setSpecs(prdt.getSpc()); - matNew.setCreateBy(9999L); + matNew.setCreateBy(9999L);//9999琛ㄧずerp涓嬪彂 matNew.setCreateTime(date); - matNew.setUpdateBy(9999L); + matNew.setUpdateBy(9999L);//9999琛ㄧずerp涓嬪彂 matNew.setUpdateTime(date); if (matService.insert(matNew)) { erpSqlServer.update(sqlUpDatePrdtOne + "'" + prdt.getPrdNo() + "'"); + callApiLogSave(prdt, "erp_prdt", "鎺ユ敹ERP涓嬪彂鍟嗗搧淇℃伅鎴愬姛锛佹坊鍔犲晢鍝佷俊鎭垚鍔燂紒", true); } else { erpSqlServer.update(sqlUpDatePrdtTwo + "'" + prdt.getPrdNo() + "'"); + callApiLogSave(prdt, "erp_prdt", "鎺ユ敹ERP涓嬪彂鍟嗗搧淇℃伅澶辫触锛侊紒锛佹坊鍔犲晢鍝佷俊鎭け璐ワ紒锛侊紒", false); } + } else { + erpSqlServer.update(sqlUpDatePrdtTwo + "'" + prdt.getPrdNo() + "'"); + callApiLogSave(prdt, "erp_prdt", "鎺ユ敹ERP涓嬪彂鍟嗗搧淇℃伅澶辫触锛侊紒锛佸晢鍝佸凡瀛樺湪锛侊紒锛�", false); } } else if (type == 2) { Mat mat = matService.selectByMatnr(prdt.getPrdNo()); @@ -83,8 +93,10 @@ mat.setSpecs(prdt.getSpc()); if (matService.updateById(mat)) { erpSqlServer.update(sqlUpDatePrdtOne + "'" + prdt.getPrdNo() + "'"); + callApiLogSave(prdt, "erp_prdt", "鎺ユ敹ERP涓嬪彂鍟嗗搧淇℃伅鎴愬姛锛佷慨鏀瑰晢鍝佷俊鎭垚鍔燂紒", true); } else { erpSqlServer.update(sqlUpDatePrdtTwo + "'" + prdt.getPrdNo() + "'"); + callApiLogSave(prdt, "erp_prdt", "鎺ユ敹ERP涓嬪彂鍟嗗搧淇℃伅澶辫触锛侊紒锛佷慨鏀瑰晢鍝佷俊鎭け璐ワ紒锛侊紒", false); } } } else if (type == 3) { @@ -92,12 +104,14 @@ if (!Cools.isEmpty(mat)) { if (matService.deleteById(mat.getId())) { erpSqlServer.update(sqlUpDatePrdtOne + "'" + prdt.getPrdNo() + "'"); + callApiLogSave(prdt, "erp_prdt", "鎺ユ敹ERP涓嬪彂鍟嗗搧淇℃伅鎴愬姛锛佸垹闄ゅ晢鍝佷俊鎭垚鍔燂紒", true); } else { erpSqlServer.update(sqlUpDatePrdtTwo + "'" + prdt.getPrdNo() + "'"); + callApiLogSave(prdt, "erp_prdt", "鎺ユ敹ERP涓嬪彂鍟嗗搧淇℃伅鎴愬姛锛佸垹闄ゅ晢鍝佷俊鎭け璐ワ紒", false); } } } else { - + callApiLogSave(prdt, "erp_prdt", "鍟嗗搧淇℃伅鍑虹幇寮傚父璧勬枡鏈鐞嗭紒", false); } } else if (prdt.getStatus() == 1) { HashMap<String, Object> condition = new HashMap<>(); @@ -108,21 +122,26 @@ condition.put("type", "'" + prdt.getType() + "'"); condition.put("status", "'" + prdt.getStatus() + "'"); erpSqlServer.insert(PrdtBak.class, condition); +// callApiLogSave(prdt, "erp_prdt_bak", "ERP涓嬪彂鍟嗗搧淇℃伅澶囦唤鎴愬姛锛�", true); HashMap<String, String> condition2 = new HashMap<>(); condition2.put("prd_no", "'" + prdt.getPrdNo() + "'"); erpSqlServer.delete(Prdt.class, condition2); - } else if (prdt.getStatus() == 2) { - +// callApiLogSave(prdt, "erp_prdt_bak", "ERP涓嬪彂鍟嗗搧淇℃伅澶囦唤鍚庡垹闄ゆ垚鍔燂紒", true); } else { - + callApiLogSave(prdt, "erp_prdt", "鍟嗗搧淇℃伅鍑虹幇寮傚父璧勬枡鏈鐞嗭紒", false); } - } } } catch (Exception e) { - + Date date = new Date(); + log.error(date + ": 琛ㄥ悕锛歟rp_prdt :" + e); } + } + public void callApiLogSave(Prdt prdt, String tableName, String response, Boolean bool) { + apiLogService.save("ERP涓嬪彂鍟嗗搧淇℃伅", tableName, "null", ip, + "鍝佸彿锛�" + prdt.getPrdNo() + "銆佸搧鍚嶏細" + prdt.getName() + "銆佺被鍨嬶細" + prdt.getType() + "銆佺姸鎬侊細" + prdt.getStatus$(), + response, bool); } } -- Gitblit v1.9.1