From ac92d2777fc472ae766e2bd6209c70691fe5dc5b Mon Sep 17 00:00:00 2001
From: whycq <913841844@qq.com>
Date: 星期三, 08 一月 2025 16:28:01 +0800
Subject: [PATCH] Merge branch 'mdqdasrs-auto' into mdqdasrsVersion

---
 src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java |    7 +
 src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java            |    3 
 src/main/java/com/zy/asrs/service/LocDetlService.java          |    1 
 src/main/java/com/zy/asrs/task/handler/WorkMastHandler.java    |   40 ++++++++
 src/main/java/com/zy/asrs/service/impl/WrkDetlServiceImpl.java |    5 +
 src/main/resources/mapper/LocMastMapper.xml                    |   10 ++
 src/main/resources/mapper/WrkMastMapper.xml                    |    2 
 src/main/java/com/zy/common/web/WcsController.java             |  166 +++++++++++++++++++++++++++++++++
 src/main/webapp/static/js/locDetl/locDetl.js                   |    1 
 src/main/resources/mapper/WrkDetlMapper.xml                    |    7 +
 src/main/java/com/zy/common/web/param/SearchLocParam.java      |    2 
 src/main/java/com/zy/asrs/mapper/LocMastMapper.java            |    2 
 src/main/webapp/static/js/common.js                            |    1 
 src/main/java/com/zy/asrs/service/LocMastService.java          |    2 
 src/main/java/com/zy/asrs/service/WrkDetlService.java          |    2 
 15 files changed, 250 insertions(+), 1 deletions(-)

diff --git a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
index 769a90d..670c0e0 100644
--- a/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/LocMastMapper.java
@@ -40,4 +40,6 @@
     List<LocMast> selectAreaEmpty(Short locType1,Integer crnNo);
 
     List<LocMast> selectAllLocNotEmpty(@Param("groupLoc") List<String> groupOuterLoc);
+
+    LocMast getLocFByMatnr(String locNo);
 }
diff --git a/src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java b/src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java
index 97d48d8..7baa1e4 100644
--- a/src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/WrkDetlMapper.java
@@ -6,6 +6,7 @@
 import org.apache.ibatis.annotations.Param;
 import org.springframework.stereotype.Repository;
 
+import java.util.Date;
 import java.util.List;
 
 @Mapper
@@ -23,4 +24,6 @@
     int updateInspect( @Param("wrkNo")Integer wrkNo, @Param("matnr")String matnr, @Param("batch")String batch);
 
     List<WrkDetl> selectPakoutQuery(@Param("staNo")Integer staNo, @Param("matnr")String matnr);
+
+    int updateIoTime(@Param("workNo") Integer workNo, @Param("ioTime") Date ioTime);
 }
diff --git a/src/main/java/com/zy/asrs/service/LocDetlService.java b/src/main/java/com/zy/asrs/service/LocDetlService.java
index 1070041..aae59de 100644
--- a/src/main/java/com/zy/asrs/service/LocDetlService.java
+++ b/src/main/java/com/zy/asrs/service/LocDetlService.java
@@ -89,4 +89,5 @@
     List<LocDetlAll> selectOwnerAllAnfme();
 
     List<String> getSameDetl(String matnr, String batch, String grade);
+
 }
diff --git a/src/main/java/com/zy/asrs/service/LocMastService.java b/src/main/java/com/zy/asrs/service/LocMastService.java
index 17d7af3..e3a6c64 100644
--- a/src/main/java/com/zy/asrs/service/LocMastService.java
+++ b/src/main/java/com/zy/asrs/service/LocMastService.java
@@ -57,4 +57,6 @@
     List<LocMast> selectAreaEmpty(Short locType1, Integer crnNo);
 
     boolean checkAllLocEmpty(List<String> groupLoc);
+
+    LocMast getLocFByMatnr(String matnr);
 }
diff --git a/src/main/java/com/zy/asrs/service/WrkDetlService.java b/src/main/java/com/zy/asrs/service/WrkDetlService.java
index ede2552..136b447 100644
--- a/src/main/java/com/zy/asrs/service/WrkDetlService.java
+++ b/src/main/java/com/zy/asrs/service/WrkDetlService.java
@@ -21,4 +21,6 @@
 
     List<WrkDetl> selectPakoutQuery(Integer staNo, String matnr);
 
+    boolean updateIoTime(Integer workNo, Date ioTime);
+
 }
diff --git a/src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java
index 6d6b86b..f2b6e39 100644
--- a/src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/LocMastServiceImpl.java
@@ -121,4 +121,11 @@
         return result.size() <= 0;
     }
 
+    @Override
+    public LocMast getLocFByMatnr(String matnr) {
+        return this.baseMapper.getLocFByMatnr(matnr);
+    }
+
+
+
 }
diff --git a/src/main/java/com/zy/asrs/service/impl/WrkDetlServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/WrkDetlServiceImpl.java
index 196874a..4c6cd21 100644
--- a/src/main/java/com/zy/asrs/service/impl/WrkDetlServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/WrkDetlServiceImpl.java
@@ -79,4 +79,9 @@
     public List<WrkDetl> selectPakoutQuery(Integer staNo, String matnr) {
         return this.baseMapper.selectPakoutQuery(staNo, matnr);
     }
+
+    @Override
+    public boolean updateIoTime(Integer workNo, Date ioTime) {
+        return this.baseMapper.updateIoTime(workNo, ioTime) > 0;
+    }
 }
diff --git a/src/main/java/com/zy/asrs/task/handler/WorkMastHandler.java b/src/main/java/com/zy/asrs/task/handler/WorkMastHandler.java
index be59bb9..2527b59 100644
--- a/src/main/java/com/zy/asrs/task/handler/WorkMastHandler.java
+++ b/src/main/java/com/zy/asrs/task/handler/WorkMastHandler.java
@@ -213,6 +213,45 @@
                     }
                     break;
                 // 骞舵澘鍏ュ簱
+                case 55:
+                    // 鏍规嵁宸ヤ綔鍙凤紝鏌ヨ宸ヤ綔鏄庣粏妗�
+                    List<WrkDetl> wrkDetls55 = wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("wrk_no", wrkMast.getWrkNo()));
+                    if (wrkDetls55.isEmpty()) {
+//                        exceptionHandle("骞舵澘鍏ュ簱 ===>> 宸ヤ綔鏄庣粏妗d负绌猴紱[workNo={0}]", wrkMast.getWrkNo());
+                        TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
+                        return FAIL.setMsg("骞舵澘鍏ュ簱 ===>> 宸ヤ綔鏄庣粏妗d负绌�; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getLocNo() + "]");
+                    }
+                    // 淇敼搴撳瓨鏄庣粏鏁伴噺锛屽鏃犲簱瀛橈紝鏇炬柊澧�
+                    for (WrkDetl wrkDetl:wrkDetls55) {
+
+                        LocDetl locDetl = locDetlService.selectOne(new EntityWrapper<LocDetl>().eq("loc_no", locMast.getLocNo()));
+                        locDetlService.delete(new EntityWrapper<LocDetl>().eq("loc_no", locDetl.getLocNo()));
+                        locDetl = new LocDetl();
+                        locDetl.sync(wrkDetl);
+                        locDetl.setLocNo(wrkMast.getLocNo()); // 搴撲綅鍙�
+                        locDetl.setAnfme(wrkDetl.getAnfme()); // 鏁伴噺
+                        locDetl.setZpallet(wrkDetl.getZpallet()); // 鎵樼洏鏉$爜
+                        locDetl.setModiTime(now);
+                        locDetl.setAppeTime(now);
+                        if (!locDetlService.insert(locDetl)) {
+//                                exceptionHandle("骞舵澘鍏ュ簱 ===>> 鏂板搴撳瓨鏄庣粏澶辫触锛沎workNo={0}],[matnr={1}]", wrkMast.getWrkNo(), wrkDetl.getMatnr());
+                            TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
+                            return FAIL.setMsg("骞舵澘鍏ュ簱 ===>> 鏂板搴撳瓨鏄庣粏澶辫触; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getLocNo() + "]");
+                        }
+                    }
+                    // 淇敼搴撲綅鐘舵�� Q ====>> F
+                    if (locMast.getLocSts().equals("Q")) {
+                        locMast.setLocSts("F");
+                        locMast.setBarcode(wrkMast.getBarcode());
+                        locMast.setIoTime(now);
+                        locMast.setModiTime(now);
+                        if (!locMastService.updateById(locMast)) {
+//                            exceptionHandle("骞舵澘鍏ュ簱 ===>> 淇敼搴撲綅鐘舵�佸け璐ワ紱[workNo={0}],[locNo={1}]", wrkMast.getWrkNo(), wrkMast.getLocNo());
+                            TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
+                            return FAIL.setMsg("骞舵澘鍏ュ簱 ===>> 淇敼搴撲綅鐘舵�佸け璐�; [workNo=" + wrkMast.getWrkNo() + "],[locNo=" + wrkMast.getLocNo() + "]");
+                        }
+                    }
+                    break;
                 case 54:
                     // 鏍规嵁宸ヤ綔鍙凤紝鏌ヨ宸ヤ綔鏄庣粏妗�
                     List<WrkDetl> wrkDetls54 = wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("wrk_no", wrkMast.getWrkNo()));
@@ -259,6 +298,7 @@
                         }
                     }
                     break;
+
                 // 鐩樼偣鍏ュ簱
                 case 57:
                     // 鏍规嵁宸ヤ綔鍙凤紝鏌ヨ宸ヤ綔鏄庣粏妗�
diff --git a/src/main/java/com/zy/common/web/WcsController.java b/src/main/java/com/zy/common/web/WcsController.java
index 3def9f9..f15f562 100644
--- a/src/main/java/com/zy/common/web/WcsController.java
+++ b/src/main/java/com/zy/common/web/WcsController.java
@@ -8,10 +8,13 @@
 import com.zy.asrs.entity.*;
 import com.zy.asrs.entity.param.EmptyPlateOutParam;
 import com.zy.asrs.service.*;
+import com.zy.asrs.service.impl.MatServiceImpl;
 import com.zy.asrs.utils.Utils;
 import com.zy.common.CodeRes;
+import com.zy.common.model.LocDto;
 import com.zy.common.model.LocTypeDto;
 import com.zy.common.model.StartupDto;
+import com.zy.common.model.enums.WorkNoType;
 import com.zy.common.service.CommonService;
 import com.zy.common.web.param.SearchLocParam;
 import lombok.extern.slf4j.Slf4j;
@@ -52,6 +55,14 @@
     private WorkService workService;
     @Autowired
     private BasCrnpService basCrnpService;
+    @Autowired
+    private StaDescService staDescService;
+    @Autowired
+    private WrkMastLogService wrkMastLogService;
+    @Autowired
+    private WrkDetlLogService wrkDetlLogService;
+    @Autowired
+    private MatServiceImpl matService;
 
     @PostMapping("/pakin/loc/v1")
     @ResponseBody
@@ -342,4 +353,159 @@
         return dto;
     }
 
+    @PostMapping("/process/loc/v1")
+    @ResponseBody
+    @Transactional
+    public synchronized R processLoc() {
+        log.info("鏀跺埌WCS缃愯鍑哄簱鎺ュ彛璇锋眰");
+        Date now = new Date();
+        // 鏌ヨ搴撳瓨鐘舵�佷綅F 涓� 搴撳瓨鏄庣粏鍖呭惈璇ョ墿鏂欑殑搴撲綅
+        LocMast tarLoc = locMastService.getLocFByMatnr("BZ10100ZZ00000010");
+        if (Cools.isEmpty(tarLoc)) {
+            throw new CoolException("娌℃湁鍙嚭搴撶殑搴撲綅");
+        }
+        List<WrkMast> wrkMasts = wrkMastService.selectList(new EntityWrapper<WrkMast>().eq("io_type", 105).ne("wrk_sts", 14));
+        if (!Cools.isEmpty(tarLoc)) {
+            if (wrkMasts.size() > 3) {
+                throw new CoolException("褰撳墠宸叉湁4绗斿嚭搴撲换鍔★紝鏆傚仠涓嬪彂");
+            }
+        }
+        // 鑾峰彇婧愮珯
+        StaDesc staDesc = staDescService.selectOne(new EntityWrapper<StaDesc>()
+                .eq("type_no", 105)
+                .eq("stn_no", 2301)
+                .eq("crn_no", tarLoc.getCrnNo()));
+        Integer sourceStaNo = staDesc.getCrnStn();
+        // 鐢熸垚宸ヤ綔鍙�
+        int workNo = commonService.getWorkNo(WorkNoType.getWorkNoType(103));
+        // 鐢熸垚宸ヤ綔妗�
+        WrkMast wrkMast = new WrkMast();
+        wrkMast.setWrkNo(workNo);
+        wrkMast.setIoTime(now);
+        wrkMast.setWrkSts(11L); // 宸ヤ綔鐘舵�侊細11.鐢熸垚鍑哄簱ID
+        wrkMast.setIoType(105); // 鍏ュ嚭搴撶姸鎬�
+        wrkMast.setIoPri(13D); // 浼樺厛绾э細13
+        wrkMast.setCrnNo(tarLoc.getCrnNo());
+        wrkMast.setSourceStaNo(sourceStaNo); // 婧愮珯
+        wrkMast.setStaNo(2301); // 鐩爣绔�
+        wrkMast.setSourceLocNo(tarLoc.getLocNo()); // 婧愬簱浣�
+        wrkMast.setFullPlt("Y"); // 婊℃澘锛歒
+        wrkMast.setPicking("N"); // 鎷f枡
+        wrkMast.setExitMk("N"); // 閫�鍑�
+        wrkMast.setEmptyMk("N"); // 绌烘澘
+        wrkMast.setLinkMis("N");
+        wrkMast.setBarcode(tarLoc.getBarcode());
+        wrkMast.setAppeTime(now);
+        wrkMast.setModiTime(now);
+        if (!wrkMastService.insert(wrkMast)) {
+            throw new CoolException("淇濆瓨宸ヤ綔妗eけ璐ワ紝鍑哄簱搴撲綅鍙凤細"+tarLoc.getLocNo());
+        }
+        // 鐢熸垚宸ヤ綔妗f槑缁�
+        List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>().eq("loc_no", tarLoc.getLocNo()));
+        for (LocDetl locDetl : locDetls) {
+            WrkDetl wrkDetl = new WrkDetl();
+            wrkDetl.sync(locDetl);
+            wrkDetl.setZpallet(wrkMast.getBarcode());
+            wrkDetl.setIoTime(now);
+            wrkDetl.setWrkNo(workNo);
+            wrkDetl.setBatch(locDetl.getBatch());
+            wrkDetl.setAnfme(locDetl.getAnfme()); // 鏁伴噺
+            wrkDetl.setAppeTime(now);
+            wrkDetl.setModiTime(now);
+            if (!wrkDetlService.insert(wrkDetl)) {
+                throw new CoolException("淇濆瓨宸ヤ綔妗f槑缁嗗け璐�");
+            }
+        }
+        // 淇敼搴撲綅鐘舵��:   F.鍦ㄥ簱 ====>>> R.鍑哄簱棰勭害/P.鎷f枡/鐩樼偣/骞舵澘鍑哄簱涓�
+        if (tarLoc.getLocSts().equals("F")) {
+            tarLoc.setLocSts("P");
+            tarLoc.setModiTime(now);
+            if (!locMastService.updateById(tarLoc)) {
+                throw new CoolException("棰勭害搴撲綅鐘舵�佸け璐ワ紝搴撲綅鍙凤細"+tarLoc.getLocNo());
+            }
+        } else {
+            throw new CoolException(tarLoc.getLocNo() + "搴撲綅涓嶆槸鍦ㄥ簱鐘舵��");
+        }
+        return R.ok();
+    }
+    @PostMapping("/process/in/loc/v1")
+    @ResponseBody
+    @Transactional
+    public synchronized R processInLoc(@RequestBody SearchLocParam param){
+        log.info("鐏岃绾挎敹鍒癢CS鍏ュ簱鎺ュ彛璇锋眰====>>鍏ュ弬:{}", param);
+        WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper<WrkMast>()
+                .eq("barcode", param.getBarcode())
+                .eq("io_type", 105)
+                .eq("wrk_sts", 14));
+        if (Cools.isEmpty(wrkMast)) {
+            log.info("鏌ヨ涓嶅埌璇ユ墭鐩樼爜鐨勭綈瑁呭嚭搴撲换鍔★紝鎵樼洏鐮佷綅{" + param.getBarcode() + "}" );
+            throw new CoolException("鏌ヨ涓嶅埌璇ユ墭鐩樼爜鐨勭綈瑁呭嚭搴撲换鍔★紝鎵樼洏鐮佷綅{" + param.getBarcode() + "}" );
+        }
+        // 鑾峰彇鐩爣绔�
+        Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>()
+                .eq("type_no", 55)
+                .eq("stn_no", 2106)
+                .eq("crn_no", wrkMast.getCrnNo());
+        StaDesc staDesc = staDescService.selectOne(wrapper);
+        if (Cools.isEmpty(staDesc)) {
+            throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦紒");
+        }
+        try {
+            // 淇濆瓨宸ヤ綔鏄庣粏妗e巻鍙叉。
+            if (!wrkMastLogService.save(wrkMast.getWrkNo())) {
+                throw new CoolException("淇濆瓨宸ヤ綔鏄庣粏妗e巻鍙叉。澶辫触");
+            }
+            // 淇濆瓨宸ヤ綔涓绘。鍘嗗彶妗�
+            if (!wrkDetlLogService.save(wrkMast.getWrkNo())) {
+                throw new CoolException("淇濆瓨宸ヤ綔涓绘。鍘嗗彶妗eけ璐�");
+            }
+            Date now = new Date();
+            // 鍫嗗灈鏈虹珯鐐�(鐩爣绔�)
+            Integer staNo = staDesc.getCrnStn();
+            // 鏇存柊宸ヤ綔妗f暟鎹姸鎬�
+            wrkMast.setIoTime(now);
+            wrkMast.setIoType(55);
+            wrkMast.setWrkSts(2L);
+            wrkMast.setSourceStaNo(2106);
+            wrkMast.setStaNo(staNo);
+            wrkMast.setLocNo(wrkMast.getSourceLocNo());
+            wrkMast.setSourceLocNo("");
+            wrkMast.setModiTime(now);
+            if (!wrkMastService.updateById(wrkMast)) {
+                throw new CoolException("鏇存柊宸ヤ綔妗f暟鎹姸鎬佸け璐�");
+            }
+            List<WrkDetl> wrkDetls = wrkDetlService.selectByWrkNo(wrkMast.getWrkNo());
+            for (WrkDetl wrkDetl : wrkDetls) {
+                Mat mat = matService.selectByMatnr("CP10103TY22014617");
+                WrkDetl wrkDetl1 = new WrkDetl();
+                wrkDetl1.sync(wrkDetl);
+                wrkDetl1.sync(mat);
+                wrkDetl1.setBatch(param.getBatch());
+                wrkDetl1.setIoTime(now);
+                wrkDetlService.insert(wrkDetl1);
+            }
+            wrkDetlService.delete(new EntityWrapper<WrkDetl>().eq("matnr", "BZ10100ZZ00000010").eq("wrk_no",wrkMast.getWrkNo()));
+            // 鏇存柊鏄庣粏妗o_time (鍘嗗彶妗e叧鑱斾娇鐢級
+//            wrkDetlService.updateIoTime(wrkMast.getWrkNo(), now);
+
+            // 淇敼搴撲綅鐘舵�� Q.鎷f枡/鐩樼偣/骞舵澘鍐嶅叆搴�
+            LocMast locMast = locMastService.selectById(wrkMast.getLocNo());
+            locMast.setLocSts("Q");
+            locMast.setModiTime(new Date());
+            if (!locMastService.updateById(locMast)) {
+                throw new CoolException("淇敼搴撲綅鐘舵�佸け璐�");
+            }
+
+        } catch (Exception e) {
+            throw new CoolException("鍏ュ簱澶辫触锛�");
+        }
+        StartupDto dto = new StartupDto();
+        dto.setWorkNo(wrkMast.getWrkNo());
+        dto.setCrnNo(wrkMast.getCrnNo());
+        dto.setSourceStaNo(wrkMast.getSourceStaNo());
+        dto.setStaNo(wrkMast.getStaNo());
+        dto.setLocNo(wrkMast.getLocNo());
+        log.info("WCS鍏ュ簱鎺ュ彛杩斿弬:{},鎵樼洏鐮�:{}", dto, param.getBarcode());
+        return R.ok().add(dto);
+    }
 }
diff --git a/src/main/java/com/zy/common/web/param/SearchLocParam.java b/src/main/java/com/zy/common/web/param/SearchLocParam.java
index 1a170ce..8e18268 100644
--- a/src/main/java/com/zy/common/web/param/SearchLocParam.java
+++ b/src/main/java/com/zy/common/web/param/SearchLocParam.java
@@ -17,4 +17,6 @@
     // 搴撲綅瑙勬牸锛� 0:鏈煡, 1:浣庡簱浣�, 2:楂樺簱浣嶏級
     private Short locType1;
 
+    private String batch;
+
 }
diff --git a/src/main/resources/mapper/LocMastMapper.xml b/src/main/resources/mapper/LocMastMapper.xml
index 51a64f3..0225960 100644
--- a/src/main/resources/mapper/LocMastMapper.xml
+++ b/src/main/resources/mapper/LocMastMapper.xml
@@ -117,5 +117,15 @@
         </foreach>
     </select>
 
+    <select id="getLocFByMatnr" resultMap="BaseResultMap">
+        SELECT TOP 1 mast.*
+        FROM asr_loc_mast mast
+        JOIN asr_loc_detl detl
+        ON mast.loc_no = detl.loc_no
+        AND mast.loc_sts = 'F'
+        AND detl.matnr = #{matnr}
+        ORDER BY mast.modi_time
+    </select>
+
 
 </mapper>
diff --git a/src/main/resources/mapper/WrkDetlMapper.xml b/src/main/resources/mapper/WrkDetlMapper.xml
index be7898e..dc4737a 100644
--- a/src/main/resources/mapper/WrkDetlMapper.xml
+++ b/src/main/resources/mapper/WrkDetlMapper.xml
@@ -111,4 +111,11 @@
         and awd.matnr + '-' + awd.batch = #{matnr}
     </select>
 
+    <update id="updateIoTime">
+        update asr_wrk_detl
+        set io_time = #{ioTime}
+        where 1=1
+          and wrk_no = #{workNo}
+    </update>
+
 </mapper>
diff --git a/src/main/resources/mapper/WrkMastMapper.xml b/src/main/resources/mapper/WrkMastMapper.xml
index cba6ab8..c71dc34 100644
--- a/src/main/resources/mapper/WrkMastMapper.xml
+++ b/src/main/resources/mapper/WrkMastMapper.xml
@@ -63,7 +63,7 @@
     </resultMap>
 
     <select id="selectToBeCompleteData" resultMap="BaseResultMap">
-        select * from asr_wrk_mast where ((wrk_sts = 4 Or wrk_sts = 14 ) and io_type != 103 and io_type != 104 and io_type != 107 ) or (wrk_sts = 2 and io_type=6) order by upd_mk,error_time,io_time,wrk_no
+        select * from asr_wrk_mast where ((wrk_sts = 4 Or wrk_sts = 14 ) and io_type != 103 and io_type != 104 and io_type != 105 and io_type != 107 ) or (wrk_sts = 2 and io_type=6) order by upd_mk,error_time,io_time,wrk_no
     </select>
 
     <select id="selectToBeHistoryData" resultMap="BaseResultMap">
diff --git a/src/main/webapp/static/js/common.js b/src/main/webapp/static/js/common.js
index 299563c..2f035ab 100644
--- a/src/main/webapp/static/js/common.js
+++ b/src/main/webapp/static/js/common.js
@@ -271,6 +271,7 @@
     ,{field: 'check$', align: 'center',title: '瑕佹眰妫�楠�', hide: true}
     ,{field: 'danger$', align: 'center',title: '鍗遍櫓鍝�', hide: true}
     ,{field: 'owner$', align: 'center',title: '璐т富', hide: true}
+    ,{field: 'memo', align: 'center',title: '澶囨敞', hide: false}
     ,{field: 'payment$', align: 'center',title: '璐х墿褰㈡��', hide: false}
 ]
 
diff --git a/src/main/webapp/static/js/locDetl/locDetl.js b/src/main/webapp/static/js/locDetl/locDetl.js
index 7355982..9f44269 100644
--- a/src/main/webapp/static/js/locDetl/locDetl.js
+++ b/src/main/webapp/static/js/locDetl/locDetl.js
@@ -24,6 +24,7 @@
         ,{field: 'safeQty', align: 'center',title: '瀹夊叏搴撳瓨閲�', hide: true}
         ,{field: 'weight', align: 'center',title: '閲嶉噺', hide: false}
         ,{field: 'owner$', align: 'center',title: '璐т富', hide: false}
+        ,{field: 'memo', align: 'center',title: '澶囨敞', hide: false}
         ,{field: 'payment$', align: 'center',title: '璐х墿鐘舵��', hide: false}
         ,{field: 'length', align: 'center',title: '鍗曠姣涢噸', hide: true}
         ,{field: 'volume', align: 'center',title: '鍗曠浣撶Н', hide: true}

--
Gitblit v1.9.1