From 0b892279761b47b56a1113848cd4f479cf8d00f2 Mon Sep 17 00:00:00 2001
From: dubin <bindu_bean@163.com>
Date: 星期二, 23 十二月 2025 17:02:55 +0800
Subject: [PATCH] #1
---
src/main/java/com/zy/asrs/service/MatBarcodeService.java | 2 ++
src/main/java/com/zy/asrs/service/impl/MatBarcodeServiceImpl.java | 6 ++++++
src/main/resources/mapper/MatBarcodeMapper.xml | 2 +-
src/main/java/com/zy/asrs/task/InOutSyncScheduler.java | 28 ++++++++++++++++++++++++++++
src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java | 6 ++++++
src/main/java/com/zy/asrs/entity/MatBarcode.java | 3 +++
6 files changed, 46 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/entity/MatBarcode.java b/src/main/java/com/zy/asrs/entity/MatBarcode.java
index 88a6dd1..1c71d72 100644
--- a/src/main/java/com/zy/asrs/entity/MatBarcode.java
+++ b/src/main/java/com/zy/asrs/entity/MatBarcode.java
@@ -23,4 +23,7 @@
@ApiModelProperty(value= "鍨嬪彿")
private String model;
+
+ @ApiModelProperty(value= "鏍囪")
+ private String color;
}
diff --git a/src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java b/src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java
index 2bb0d6b..fdb5f07 100644
--- a/src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/MatBarcodeMapper.java
@@ -5,7 +5,10 @@
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
+
+import java.util.List;
@Mapper
@Repository
@@ -16,4 +19,7 @@
void deleteByMatnr(String matnr);
String page(Integer pageNo, Integer pageSize, String barcode, Integer spec);
+
+ @Select("select top 100 * from cust_matnr_barcode where model = '' or model is null ")
+ List<MatBarcode> select100();
}
diff --git a/src/main/java/com/zy/asrs/service/MatBarcodeService.java b/src/main/java/com/zy/asrs/service/MatBarcodeService.java
index fa826b5..029879e 100644
--- a/src/main/java/com/zy/asrs/service/MatBarcodeService.java
+++ b/src/main/java/com/zy/asrs/service/MatBarcodeService.java
@@ -20,4 +20,6 @@
void addBarcodeMatnrTwo(Mat mat);
String page(Map<String, Object> param);
+
+ List<MatBarcode> select100();
}
diff --git a/src/main/java/com/zy/asrs/service/impl/MatBarcodeServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/MatBarcodeServiceImpl.java
index 6b515b0..766b520 100644
--- a/src/main/java/com/zy/asrs/service/impl/MatBarcodeServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/MatBarcodeServiceImpl.java
@@ -11,6 +11,7 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+import java.util.Collections;
import java.util.List;
import java.util.Map;
@@ -235,4 +236,9 @@
Integer spec = Integer.valueOf(param.get("spec").toString());
return matBarcodeMapper.page(pageNo,pageSize,barcode,spec);
}
+
+ @Override
+ public List<MatBarcode> select100() {
+ return this.baseMapper.select100();
+ }
}
diff --git a/src/main/java/com/zy/asrs/task/InOutSyncScheduler.java b/src/main/java/com/zy/asrs/task/InOutSyncScheduler.java
index 9e592b5..dd6ad89 100644
--- a/src/main/java/com/zy/asrs/task/InOutSyncScheduler.java
+++ b/src/main/java/com/zy/asrs/task/InOutSyncScheduler.java
@@ -5,8 +5,10 @@
import com.zy.asrs.entity.InOut;
import com.zy.asrs.entity.LocDetl;
import com.zy.asrs.entity.Mat;
+import com.zy.asrs.entity.MatBarcode;
import com.zy.asrs.service.InOutService;
import com.zy.asrs.service.LocDetlService;
+import com.zy.asrs.service.MatBarcodeService;
import com.zy.asrs.service.MatService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
@@ -26,6 +28,8 @@
private InOutService inOutService;
@Autowired
private MatService matService;
+ @Autowired
+ private MatBarcodeService matBarcodeService;
// @Scheduled(cron = "0/30 * * * * ? ")
private void syncInOut(){
@@ -57,4 +61,28 @@
}
log.info("鏇存柊" + locDetlList.size() + "鏉″晢鍝佷俊鎭垚鍔�");
}
+
+
+ @Scheduled(cron = "0/30 * * * * ? ")
+ private void syncBarcodeMat(){
+ List<MatBarcode> matBarcodeList = matBarcodeService.select100();
+ if (matBarcodeList.size() == 0){
+ log.info("鎵樼洏鐗╂枡缁戝畾鍏崇郴鏇存柊瀹屾瘯");
+ return;
+ }
+ for (MatBarcode matBarcode : matBarcodeList) {
+ String matnr = matBarcode.getMatnr();
+ String[] split = matnr.split("__");
+ if (split.length > 1){
+ matBarcode.setModel(split[1]); // 濂楀彿
+ matBarcode.setColor("1"); // 鏍囪
+ if (!matBarcodeService.update(matBarcode,new EntityWrapper<MatBarcode>().eq("matnr",matBarcode.getMatnr()))){
+ log.error("鏇存柊鎵樼洏鐗╂枡缁戝畾鍏崇郴澶辫触");
+ }
+ }else {
+ continue;
+ }
+ }
+ log.info("鏇存柊" + matBarcodeList.size() + "鏉℃墭鐩樼墿鏂欑粦瀹氬叧绯绘垚鍔�");
+ }
}
diff --git a/src/main/resources/mapper/MatBarcodeMapper.xml b/src/main/resources/mapper/MatBarcodeMapper.xml
index 05b2e05..e839c08 100644
--- a/src/main/resources/mapper/MatBarcodeMapper.xml
+++ b/src/main/resources/mapper/MatBarcodeMapper.xml
@@ -14,7 +14,7 @@
<result column="specs" property="specs" />
<result column="model" property="model" />
-<!-- <result column="color" property="color" />-->
+ <result column="color" property="color" />
<!-- <result column="brand" property="brand" />-->
<!-- <result column="unit" property="unit" />-->
<!-- <result column="price" property="price" />-->
--
Gitblit v1.9.1