From 2e71ee94af4962b9aaf83805bc912d9a8fe118fa Mon Sep 17 00:00:00 2001 From: whycq <123456> Date: 星期一, 08 八月 2022 13:31:43 +0800 Subject: [PATCH] # --- src/main/resources/mapper/WrkDetlMapper.xml | 8 src/main/java/com/zy/asrs/utils/VersionUtils.java | 14 src/main/java/com/zy/core/thread/LedThread.java | 39 +- src/main/java/com/zy/asrs/entity/LocDetl.java | 234 +++++++++++++------ src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java | 10 src/main/resources/mapper/LocDetlMapper.xml | 51 +++- src/main/java/com/zy/asrs/entity/WrkDetl.java | 309 ++++++++++++++++++++----- src/main/resources/application.yml | 12 8 files changed, 480 insertions(+), 197 deletions(-) diff --git a/src/main/java/com/zy/asrs/entity/LocDetl.java b/src/main/java/com/zy/asrs/entity/LocDetl.java index 9899b48..87c44d8 100644 --- a/src/main/java/com/zy/asrs/entity/LocDetl.java +++ b/src/main/java/com/zy/asrs/entity/LocDetl.java @@ -1,14 +1,13 @@ package com.zy.asrs.entity; +import com.alibaba.excel.annotation.ExcelProperty; import com.baomidou.mybatisplus.annotations.TableField; -import com.baomidou.mybatisplus.annotations.TableId; import com.baomidou.mybatisplus.annotations.TableName; -import com.baomidou.mybatisplus.enums.IdType; +import com.core.common.Cools; +import com.core.common.SpringUtils; import com.zy.asrs.service.LocMastService; import com.zy.system.entity.User; import com.zy.system.service.UserService; -import com.core.common.Cools; -import com.core.common.SpringUtils; import io.swagger.annotations.ApiModelProperty; import lombok.Data; @@ -22,57 +21,119 @@ private static final long serialVersionUID = 1L; - @ApiModelProperty(value= "搴撲綅鍙�") - @TableId(value = "loc_no", type = IdType.INPUT) @TableField("loc_no") private String locNo; - - @ApiModelProperty(value= "浜у搧缂栫爜") - @TableId(value = "mat_no", type = IdType.INPUT) - @TableField("mat_no") - private String matNo; - - @ApiModelProperty(value= "浜у搧鍚嶇О") - @TableId(value = "mat_name") - @TableField("mat_name") - private String matName; - - @ApiModelProperty(value= "瑙勬牸") - private String specs; - - @ApiModelProperty(value= "灏哄") - private String size; - - @ApiModelProperty(value= "棰滆壊") - private String color; - - @ApiModelProperty(value= "鍗曢噸") - private Double weight; - - @ApiModelProperty(value= "渚涘簲鍟�") - private String supplier; - - @ApiModelProperty(value= "浠撳簱") - private String warehouse; - - @ApiModelProperty(value= "鍝佺墝") - private String brand; - - @ApiModelProperty(value= "鏁伴噺") - private Double qty; - - @ApiModelProperty(value= "鍗曚綅") - private String unit; @ApiModelProperty(value= "鎵樼洏鏉$爜") private String zpallet; - @ApiModelProperty(value= "鐢ㄦ埛ID") - private String bname; + @ApiModelProperty(value= "鏁伴噺") + @ExcelProperty("鏁伴噺") + private Double anfme; - @ApiModelProperty(value= "澶囨敞") - private String memo; + @ApiModelProperty(value= "鍟嗗搧缂栧彿") + @ExcelProperty("鍟嗗搧缂栧彿") + private String matnr; + + @ApiModelProperty(value= "鍟嗗搧鍚嶇О") + @ExcelProperty("鍟嗗搧鍚嶇О") + private String maktx; + + @ApiModelProperty(value= "鎵瑰彿") + @ExcelProperty("鎵瑰彿") + private String batch; + + @ApiModelProperty(value= "鍗曟嵁缂栧彿") + @ExcelProperty("鍗曟嵁缂栧彿") + @TableField("order_no") + private String orderNo; + + @ApiModelProperty(value= "瑙勬牸") + private String specs; + + @ApiModelProperty(value= "鍨嬪彿") + private String model; + + @ApiModelProperty(value= "棰滆壊") + private String color; + + @ApiModelProperty(value= "鍝佺墝") + private String brand; + + @ApiModelProperty(value= "鍗曚綅") + private String unit; + + @ApiModelProperty(value= "鍗曚环") + private Double price; + + @ApiModelProperty(value= "sku") + private String sku; + + @ApiModelProperty(value= "鍗曚綅閲�") + private Double units; + + @ApiModelProperty(value= "鏉$爜") + private String barcode; + + @ApiModelProperty(value= "浜у湴") + private String origin; + + @ApiModelProperty(value= "鍘傚") + private String manu; + + @ApiModelProperty(value= "鐢熶骇鏃ユ湡") + @TableField("manu_date") + private String manuDate; + + @ApiModelProperty(value= "鍝侀」鏁�") + @TableField("item_num") + private String itemNum; + + @ApiModelProperty(value= "瀹夊叏搴撳瓨閲�") + @TableField("safe_qty") + private Double safeQty; + + @ApiModelProperty(value= "閲嶉噺") + private Double weight; + + @ApiModelProperty(value= "闀垮害") + private Double length; + + @ApiModelProperty(value= "浣撶Н") + private Double volume; + + @ApiModelProperty(value= "涓夋柟缂栫爜") + @TableField("three_code") + private String threeCode; + + @ApiModelProperty(value= "渚涘簲鍟�") + private String supp; + + @ApiModelProperty(value= "渚涘簲鍟嗙紪鐮�") + @TableField("supp_code") + private String suppCode; + + @ApiModelProperty(value= "鏄惁鎵规 1: 鏄� 0: 鍚� ") + @TableField("be_batch") + private Integer beBatch; + + @ApiModelProperty(value= "淇濊川鏈�") + @TableField("dead_time") + private String deadTime; + + @ApiModelProperty(value= "棰勮澶╂暟") + @TableField("dead_warn") + private Integer deadWarn; + + @ApiModelProperty(value= "鍒惰喘 1: 鍒堕�� 2: 閲囪喘 3: 澶栧崗 ") + private Integer source; + + @ApiModelProperty(value= "瑕佹眰妫�楠� 1: 鏄� 0: 鍚� ") + private Integer inspect; + + @ApiModelProperty(value= "鍗遍櫓鍝� 1: 鏄� 0: 鍚� ") + private Integer danger; @ApiModelProperty(value= "淇敼浜哄憳") @TableField("modi_user") @@ -90,30 +151,8 @@ @TableField("appe_time") private Date appeTime; - @TableField("bill_no") - private String billNo; - - @TableField("seq_no") - private int seqNo; - - @TableField("bill_type") - private int billType; - - @TableField("object_id") - private String objectId; - - @TableField("object_name") - private String objectName; - - @TableField("det_id") - private int detId; - - @TableId(value = "Item_batch", type = IdType.INPUT) - @TableField("Item_batch") - private String itemBatch; - - @TableField("order_no") - private String orderNo; + @ApiModelProperty(value= "澶囨敞") + private String memo; public String getLocNo$(){ LocMastService service = SpringUtils.getBean(LocMastService.class); @@ -122,6 +161,56 @@ return String.valueOf(locMast.getLocNo()); } return null; + } + + public String getBeBatch$(){ + if (null == this.beBatch){ return null; } + switch (this.beBatch){ + case 1: + return "鏄�"; + case 0: + return "鍚�"; + default: + return String.valueOf(this.beBatch); + } + } + + public String getSource$(){ + if (null == this.source){ return null; } + switch (this.source){ + case 1: + return "鍒堕��"; + case 2: + return "閲囪喘"; + case 3: + return "澶栧崗"; + default: + return String.valueOf(this.source); + } + } + + public String getInspect$(){ + if (null == this.inspect){ return null; } + switch (this.inspect){ + case 1: + return "鏄�"; + case 0: + return "鍚�"; + default: + return String.valueOf(this.inspect); + } + } + + public String getDanger$(){ + if (null == this.danger){ return null; } + switch (this.danger){ + case 1: + return "鏄�"; + case 0: + return "鍚�"; + default: + return String.valueOf(this.danger); + } } public String getModiUser$(){ @@ -140,7 +229,6 @@ return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.modiTime); } - public String getAppeUser$(){ UserService service = SpringUtils.getBean(UserService.class); User user = service.selectById(this.appeUser); @@ -156,4 +244,6 @@ } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.appeTime); } + + } diff --git a/src/main/java/com/zy/asrs/entity/WrkDetl.java b/src/main/java/com/zy/asrs/entity/WrkDetl.java index 37c368d..05c9703 100644 --- a/src/main/java/com/zy/asrs/entity/WrkDetl.java +++ b/src/main/java/com/zy/asrs/entity/WrkDetl.java @@ -1,24 +1,19 @@ package com.zy.asrs.entity; import com.baomidou.mybatisplus.annotations.TableField; -import com.baomidou.mybatisplus.annotations.TableId; import com.baomidou.mybatisplus.annotations.TableName; import com.core.common.Cools; import com.core.common.SpringUtils; import com.zy.system.entity.User; import com.zy.system.service.UserService; import io.swagger.annotations.ApiModelProperty; -import lombok.AllArgsConstructor; import lombok.Data; -import lombok.NoArgsConstructor; import java.io.Serializable; import java.text.SimpleDateFormat; import java.util.Date; @Data -@NoArgsConstructor -@AllArgsConstructor @TableName("asr_wrk_detl") public class WrkDetl implements Serializable { @@ -38,59 +33,11 @@ @TableField("io_time") private Date ioTime; - @ApiModelProperty(value= "浜у搧缂栫爜") - @TableId(value = "mat_no") - @TableField("mat_no") - private String matNo; - - @ApiModelProperty(value= "浜у搧鍚嶇О") - @TableId(value = "mat_name") - @TableField("mat_name") - private String matName; - - @ApiModelProperty(value= "瑙勬牸") - private String specs; - - @ApiModelProperty(value= "灏哄") - private String size; - - @ApiModelProperty(value= "棰滆壊") - private String color; - - @ApiModelProperty(value= "鍗曢噸") - private Double weight; - - /** - * 鍗曟嵁缂栧彿 - */ - @ApiModelProperty(value= "鍗曟嵁缂栧彿") - @TableField("bill_no") - private String billNo; - - /** - * 搴忓彿 - */ - @ApiModelProperty(value= "搴忓彿") - @TableField("seq_no") - private Integer seqNo; - - /** - * 浠撳簱鍙� - */ - @ApiModelProperty(value= "鍝佺墝") - private String brand; - /** * 鏁伴噺 */ @ApiModelProperty(value= "鏁伴噺") - private Double qty; - - /** - * 鍗曚綅 - */ - @ApiModelProperty(value= "鍗曚綅") - private String unit; + private Double anfme; /** * 鎵樼洏鏉$爜 @@ -99,16 +46,193 @@ private String zpallet; /** - * 鐢ㄦ埛ID + * 鐗╂枡 */ - @ApiModelProperty(value= "鐢ㄦ埛ID") - private String bname; + @ApiModelProperty(value= "鍟嗗搧缂栧彿") + private String matnr; /** - * 澶囨敞 + * 鐗╂枡鎻忚堪 */ - @ApiModelProperty(value= "澶囨敞") - private String memo; + @ApiModelProperty(value= "鍟嗗搧鍚嶇О") + private String maktx; + + /** + * 鎵瑰彿 + */ + @ApiModelProperty(value= "鎵瑰彿") + private String batch; + + /** + * 鍗曟嵁缂栧彿 + */ + @ApiModelProperty(value= "鍗曟嵁缂栧彿") + @TableField("order_no") + private String orderNo; + + /** + * 瑙勬牸 + */ + @ApiModelProperty(value= "瑙勬牸") + private String specs; + + /** + * 鍨嬪彿 + */ + @ApiModelProperty(value= "鍨嬪彿") + private String model; + + /** + * 棰滆壊 + */ + @ApiModelProperty(value= "棰滆壊") + private String color; + + /** + * 鍝佺墝 + */ + @ApiModelProperty(value= "鍝佺墝") + private String brand; + + /** + * 鍗曚綅 + */ + @ApiModelProperty(value= "鍗曚綅") + private String unit; + + /** + * 鍗曚环 + */ + @ApiModelProperty(value= "鍗曚环") + private Double price; + + /** + * sku + */ + @ApiModelProperty(value= "sku") + private String sku; + + /** + * 鍗曚綅閲� + */ + @ApiModelProperty(value= "鍗曚綅閲�") + private Double units; + + /** + * 鏉$爜 + */ + @ApiModelProperty(value= "鏉$爜") + private String barcode; + + /** + * 浜у湴 + */ + @ApiModelProperty(value= "浜у湴") + private String origin; + + /** + * 鍘傚 + */ + @ApiModelProperty(value= "鍘傚") + private String manu; + + /** + * 鐢熶骇鏃ユ湡 + */ + @ApiModelProperty(value= "鐢熶骇鏃ユ湡") + @TableField("manu_date") + private String manuDate; + + /** + * 鍝侀」鏁� + */ + @ApiModelProperty(value= "鍝侀」鏁�") + @TableField("item_num") + private String itemNum; + + /** + * 瀹夊叏搴撳瓨閲� + */ + @ApiModelProperty(value= "瀹夊叏搴撳瓨閲�") + @TableField("safe_qty") + private Double safeQty; + + /** + * 閲嶉噺 + */ + @ApiModelProperty(value= "閲嶉噺") + private Double weight; + + /** + * 闀垮害 + */ + @ApiModelProperty(value= "闀垮害") + private Double length; + + /** + * 浣撶Н + */ + @ApiModelProperty(value= "浣撶Н") + private Double volume; + + /** + * 涓夋柟缂栫爜 + */ + @ApiModelProperty(value= "涓夋柟缂栫爜") + @TableField("three_code") + private String threeCode; + + /** + * 渚涘簲鍟� + */ + @ApiModelProperty(value= "渚涘簲鍟�") + private String supp; + + /** + * 渚涘簲鍟嗙紪鐮� + */ + @ApiModelProperty(value= "渚涘簲鍟嗙紪鐮�") + @TableField("supp_code") + private String suppCode; + + /** + * 鏄惁鎵规 1: 鏄� 0: 鍚� + */ + @ApiModelProperty(value= "鏄惁鎵规 1: 鏄� 0: 鍚� ") + @TableField("be_batch") + private Integer beBatch; + + /** + * 淇濊川鏈� + */ + @ApiModelProperty(value= "淇濊川鏈�") + @TableField("dead_time") + private String deadTime; + + /** + * 棰勮澶╂暟 + */ + @ApiModelProperty(value= "棰勮澶╂暟") + @TableField("dead_warn") + private Integer deadWarn; + + /** + * 鍒惰喘 1: 鍒堕�� 2: 閲囪喘 3: 澶栧崗 + */ + @ApiModelProperty(value= "鍒惰喘 1: 鍒堕�� 2: 閲囪喘 3: 澶栧崗 ") + private Integer source; + + /** + * 瑕佹眰妫�楠� 1: 鏄� 0: 鍚� + */ + @ApiModelProperty(value= "瑕佹眰妫�楠� 1: 鏄� 0: 鍚� ") + private Integer inspect; + + /** + * 鍗遍櫓鍝� 1: 鏄� 0: 鍚� + */ + @ApiModelProperty(value= "鍗遍櫓鍝� 1: 鏄� 0: 鍚� ") + private Integer danger; /** * 淇敼浜哄憳 @@ -138,21 +262,67 @@ @TableField("appe_time") private Date appeTime; - @ApiModelProperty(value= "搴撲綅鍙�") - @TableField(exist = false) - private String locNo; - - @TableField("Item_batch") - private String itemBatch; - - @TableField("order_no") - private String orderNo; + /** + * 澶囨敞 + */ + @ApiModelProperty(value= "澶囨敞") + private String memo; public String getIoTime$(){ if (Cools.isEmpty(this.ioTime)){ return ""; } return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.ioTime); + } + + public String getBeBatch$(){ + if (null == this.beBatch){ return null; } + switch (this.beBatch){ + case 1: + return "鏄�"; + case 0: + return "鍚�"; + default: + return String.valueOf(this.beBatch); + } + } + + public String getSource$(){ + if (null == this.source){ return null; } + switch (this.source){ + case 1: + return "鍒堕��"; + case 2: + return "閲囪喘"; + case 3: + return "澶栧崗"; + default: + return String.valueOf(this.source); + } + } + + public String getInspect$(){ + if (null == this.inspect){ return null; } + switch (this.inspect){ + case 1: + return "鏄�"; + case 0: + return "鍚�"; + default: + return String.valueOf(this.inspect); + } + } + + public String getDanger$(){ + if (null == this.danger){ return null; } + switch (this.danger){ + case 1: + return "鏄�"; + case 0: + return "鍚�"; + default: + return String.valueOf(this.danger); + } } public String getModiUser$(){ @@ -187,4 +357,5 @@ return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(this.appeTime); } + } diff --git a/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java index 6ce64f9..6d9409d 100644 --- a/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/MainServiceImpl.java @@ -130,7 +130,7 @@ // 鍒ゆ柇鏄惁婊¤冻鍏ュ簱鏉′欢 if (staProtocol.isAutoing() && staProtocol.isLoading() && staProtocol.isInEnable() - && !staProtocol.isEmptyMk() && (staProtocol.getWorkNo() == 0 || staProtocol.getWorkNo() == 9999) + && !staProtocol.isEmptyMk() && (staProtocol.getWorkNo() == 0 || staProtocol.getWorkNo() > 9990) && staProtocol.isPakMk()){// && !Cools.isEmpty(barcode)) { // if(Cools.isEmpty(barcode) || "NG".endsWith(barcode) || "NoRead".equals(barcode)) { @@ -1408,7 +1408,7 @@ ledCommand.setStaNo(wrkMast.getStaNo()); if (wrkMast.getIoType() != 110) { List<WrkDetl> wrkDetls = wrkDetlService.findByWorkNo(wrkMast.getWrkNo()); - wrkDetls.forEach(wrkDetl -> ledCommand.getMatDtos().add(new MatDto(wrkDetl.getMatNo(), wrkDetl.getMatName(), wrkDetl.getQty()))); + wrkDetls.forEach(wrkDetl -> ledCommand.getMatDtos().add(new MatDto(wrkDetl.getMatnr(), wrkDetl.getMaktx(), wrkDetl.getAnfme()))); } commands.add(ledCommand); } @@ -1499,7 +1499,7 @@ } } // 鑾峰彇led绾跨▼ - LedThread ledThread = (LedThread) SlaveConnection.get(SlaveType.Led, led.getDevpPlcId()); + LedThread ledThread = (LedThread) SlaveConnection.get(SlaveType.Led, led.getId()); // led鏄剧ず榛樿鍐呭 if (reset && !ledThread.isLedMk()) { ledThread.setLedMk(true); @@ -1553,7 +1553,7 @@ WrkDetl wrkDetl = new WrkDetl(); wrkDetl.setWrkNo(workNo); wrkDetl.setIoTime(now); - wrkDetl.setQty(locDetl.getQty()); + wrkDetl.setAnfme(locDetl.getAnfme()); VersionUtils.setWrkDetl(wrkDetl, locDetl); // 鐗堟湰鎺у埗 wrkDetl.setAppeTime(now); wrkDetl.setModiTime(now); @@ -1670,7 +1670,7 @@ WrkDetl wrkDetl = new WrkDetl(); wrkDetl.setWrkNo(workNo); wrkDetl.setIoTime(new Date()); - wrkDetl.setQty(locDetl.getQty()); + wrkDetl.setAnfme(locDetl.getAnfme()); VersionUtils.setWrkDetl(wrkDetl, locDetl); // 鐗堟湰鎺у埗 wrkDetl.setAppeTime(new Date()); wrkDetl.setModiTime(new Date()); diff --git a/src/main/java/com/zy/asrs/utils/VersionUtils.java b/src/main/java/com/zy/asrs/utils/VersionUtils.java index bb6afba..0e8be1f 100644 --- a/src/main/java/com/zy/asrs/utils/VersionUtils.java +++ b/src/main/java/com/zy/asrs/utils/VersionUtils.java @@ -28,11 +28,11 @@ } public static void setWrkDetl(WrkDetl wrkDetl, LocDetl locDetl) { - wrkDetl.setMatNo(locDetl.getMatNo()); // 浜у搧缂栧彿 - wrkDetl.setMatName(locDetl.getMatName()); // 浜у搧鎻忚堪 + wrkDetl.setMatnr(locDetl.getMatnr()); // 浜у搧缂栧彿 + wrkDetl.setMaktx(locDetl.getMaktx()); // 浜у搧鎻忚堪 wrkDetl.setSpecs(locDetl.getSpecs()); // 瑙勬牸 wrkDetl.setUnit(locDetl.getUnit()); // 鍗曚綅 - wrkDetl.setSize(locDetl.getSize()); // 灏哄 +// wrkDetl.setSize(locDetl.getSize()); // 灏哄 wrkDetl.setColor(locDetl.getColor()); // 棰滆壊 wrkDetl.setWeight(locDetl.getWeight()); // 鍗曢噸 wrkDetl.setZpallet(locDetl.getZpallet()); // 鎵樼洏鏉$爜 @@ -52,13 +52,13 @@ } public static void setLocDetl(LocDetl locDetl, WrkDetl wrkDetl) { - locDetl.setMatNo(wrkDetl.getMatNo()); // 浜у搧缂栧彿 - locDetl.setMatName(wrkDetl.getMatName()); // 浜у搧鎻忚堪 + locDetl.setMatnr(wrkDetl.getMatnr()); // 浜у搧缂栧彿 + locDetl.setMaktx(wrkDetl.getMaktx()); // 浜у搧鎻忚堪 locDetl.setSpecs(wrkDetl.getSpecs()); // 瑙勬牸 locDetl.setUnit(wrkDetl.getUnit()); // 鍗曚綅 - locDetl.setSize(wrkDetl.getSize()); // 灏哄 +// locDetl.setSize(wrkDetl.getSize()); // 灏哄 locDetl.setColor(wrkDetl.getColor()); // 棰滆壊 - locDetl.setQty(wrkDetl.getQty()); // 鏁伴噺 + locDetl.setAnfme(wrkDetl.getAnfme()); // 鏁伴噺 locDetl.setZpallet(wrkDetl.getZpallet()); // 鎵樼洏鏉$爜 } diff --git a/src/main/java/com/zy/core/thread/LedThread.java b/src/main/java/com/zy/core/thread/LedThread.java index 3305f41..cdc583a 100644 --- a/src/main/java/com/zy/core/thread/LedThread.java +++ b/src/main/java/com/zy/core/thread/LedThread.java @@ -40,7 +40,7 @@ TextCaptionBxArea area; DisplayStyleFactory.DisplayStyle[] styles = DisplayStyleFactory.getStyles().toArray(new DisplayStyleFactory.DisplayStyle[0]); private Set<Integer> workNos = new HashSet<>(); - private boolean ledMk = true; + private boolean ledMk = false; private boolean resetStatus = false; // 澶嶄綅鐘舵�� public LedThread(Slave slave) { @@ -114,7 +114,7 @@ } // 璁剧疆瀛椾綋 - page.setFont(new Font("瀹嬩綋",Font.PLAIN,10)); + page.setFont(new Font("瀹嬩綋",Font.PLAIN,12)); // 璁剧疆鏂囨湰棰滆壊 page.setForeground(Color.red); // 璁剧疆鏄剧ず鐗规妧涓哄揩閫熸墦鍑� @@ -133,9 +133,9 @@ } private void reset() throws Bx5GException { -// if (!connect()) { -// return; -// } + if (!connect()) { + return; + } // if (resetStatus) { // return; // } @@ -146,20 +146,21 @@ // 鍒涘缓涓�涓暟鎹〉 TextBxPage page = new TextBxPage(); - List<String> list = null; - try { - String ledDefaultMsg = Parameter.get().getLedDefaultMsg(); - list = JSON.parseArray(ledDefaultMsg, String.class); - } catch (Exception ignore) { - } - if (!Cools.isEmpty(list)) { - for (String str : list) { - page.newLine(str); - } - } else { - page.newLine("鑷姩鍖栫珛浣撲粨搴�"); - page.newLine("瑗挎牸杩堣偂浠芥湁闄愬叕鍙�"); - } +// List<String> list = null; +// try { +// String ledDefaultMsg = Parameter.get().getLedDefaultMsg(); +// list = JSON.parseArray(ledDefaultMsg, String.class); +// } catch (Exception ignore) { +// } +// if (!Cools.isEmpty(list)) { +// for (String str : list) { +// page.newLine(str); +// } +// } else { +// page.newLine("鑷姩鍖栫珛浣撲粨搴�"); +// page.newLine("瑗挎牸杩堣偂浠芥湁闄愬叕鍙�"); +// } + page.newLine(""); // 璁剧疆瀛椾綋 page.setFont(new Font("瀹嬩綋",Font.PLAIN,13)); diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml index a440e63..45ee0c8 100644 --- a/src/main/resources/application.yml +++ b/src/main/resources/application.yml @@ -185,39 +185,39 @@ ip: 10.10.10.201 port: 5005 devpPlcId: ${wcs-slave.devp[0].id} - staArr: 110 + staArr: 102 # LED2 led[1]: id: 2 ip: 10.10.10.202 port: 5005 devpPlcId: ${wcs-slave.devp[0].id} - staArr: 117 + staArr: 103 # LED3 led[2]: id: 3 ip: 10.10.10.203 port: 5005 devpPlcId: ${wcs-slave.devp[0].id} - staArr: 124 + staArr: 202 # LED4 led[3]: id: 4 ip: 10.10.10.204 port: 5005 devpPlcId: ${wcs-slave.devp[0].id} - staArr: 131 + staArr: 203 # LED5 led[4]: id: 5 ip: 10.10.10.205 port: 5005 devpPlcId: ${wcs-slave.devp[0].id} - staArr: 136 + staArr: 303 # LED6 led[5]: id: 5 ip: 10.10.10.206 port: 5005 devpPlcId: ${wcs-slave.devp[0].id} - staArr: 136 \ No newline at end of file + staArr: 305 \ No newline at end of file diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml index d66d35c..4fb3cbf 100644 --- a/src/main/resources/mapper/LocDetlMapper.xml +++ b/src/main/resources/mapper/LocDetlMapper.xml @@ -5,24 +5,45 @@ <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 --> <resultMap id="BaseResultMap" type="com.zy.asrs.entity.LocDetl"> <result column="loc_no" property="locNo" /> - <result column="mat_no" property="matNo" /> - <result column="mat_name" property="matName" /> - <result column="specs" property="specs" /> - <result column="size" property="size" /> - <result column="color" property="color" /> - <result column="weight" property="weight" /> - <result column="supplier" property="supplier" /> - <result column="warehouse" property="warehouse" /> - <result column="brand" property="brand" /> - <result column="qty" property="qty" /> - <result column="unit" property="unit" /> <result column="zpallet" property="zpallet" /> - <result column="bname" property="bname" /> - <result column="memo" property="memo" /> + <result column="anfme" property="anfme" /> + <result column="matnr" property="matnr" /> + <result column="maktx" property="maktx" /> + <result column="batch" property="batch" /> + <result column="order_no" property="orderNo" /> + + <result column="specs" property="specs" /> + <result column="model" property="model" /> + <result column="color" property="color" /> + <result column="brand" property="brand" /> + <result column="unit" property="unit" /> + <result column="price" property="price" /> + <result column="sku" property="sku" /> + <result column="units" property="units" /> + <result column="barcode" property="barcode" /> + <result column="origin" property="origin" /> + <result column="manu" property="manu" /> + <result column="manu_date" property="manuDate" /> + <result column="item_num" property="itemNum" /> + <result column="safe_qty" property="safeQty" /> + <result column="weight" property="weight" /> + <result column="length" property="length" /> + <result column="volume" property="volume" /> + <result column="three_code" property="threeCode" /> + <result column="supp" property="supp" /> + <result column="supp_code" property="suppCode" /> + <result column="be_batch" property="beBatch" /> + <result column="dead_time" property="deadTime" /> + <result column="dead_warn" property="deadWarn" /> + <result column="source" property="source" /> + <result column="inspect" property="inspect" /> + <result column="danger" property="danger" /> + <result column="modi_user" property="modiUser" /> <result column="modi_time" property="modiTime" /> <result column="appe_user" property="appeUser" /> <result column="appe_time" property="appeTime" /> + <result column="memo" property="memo" /> </resultMap> <sql id="stockOutCondition"> @@ -30,10 +51,10 @@ and a.loc_no like '%' + #{loc_no} + '%' </if> <if test="matNo!=null and matNo!='' "> - and a.mat_no like '%' + #{matNo} + '%' + and a.matnr like '%' + #{matNo} + '%' </if> <if test="matName!=null and matName!='' "> - and a.mat_name like '%' + #{matName} + '%' + and a.maktx like '%' + #{matName} + '%' </if> <if test="anfme!=null and anfme!='' "> and a.anfme like '%' + #{anfme} + '%' diff --git a/src/main/resources/mapper/WrkDetlMapper.xml b/src/main/resources/mapper/WrkDetlMapper.xml index 1d078f3..a28c05b 100644 --- a/src/main/resources/mapper/WrkDetlMapper.xml +++ b/src/main/resources/mapper/WrkDetlMapper.xml @@ -6,8 +6,8 @@ <resultMap id="BaseResultMap" type="com.zy.asrs.entity.WrkDetl"> <result column="wrk_no" property="wrkNo" /> <result column="io_time" property="ioTime" /> - <result column="mat_no" property="matNo" /> - <result column="mat_name" property="matName" /> + <result column="matnr" property="matnr" /> + <result column="maktx" property="maktx" /> <result column="specs" property="specs" /> <result column="size" property="size" /> <result column="color" property="color" /> @@ -15,7 +15,7 @@ <result column="bill_no" property="billNo" /> <result column="seq_no" property="seqNo" /> <result column="brand" property="brand" /> - <result column="qty" property="qty" /> + <result column="anfme" property="anfme" /> <result column="unit" property="unit" /> <result column="zpallet" property="zpallet" /> <result column="bname" property="bname" /> @@ -27,7 +27,7 @@ </resultMap> <select id="findByWorkNo" resultMap="BaseResultMap"> - select wrk_no, mat_no, mat_name, qty from asr_wrk_detl where 1=1 and wrk_no = #{workNo} + select wrk_no, matnr, maktx, anfme from asr_wrk_detl where 1=1 and wrk_no = #{workNo} </select> <update id="updateIoTime"> -- Gitblit v1.9.1