From 9ae7c6a2d11b1fcf9fef01b310a543414c7b427e Mon Sep 17 00:00:00 2001
From: ZY <zc857179121@qq.com>
Date: 星期五, 07 二月 2025 07:51:29 +0800
Subject: [PATCH] 四期

---
 src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java |    4 
 src/main/java/com/zy/asrs/controller/AgvLocDetlController.java    |    3 
 src/main/java/com/zy/asrs/task/OrderLogScheduler.java             |    2 
 src/main/java/com/zy/asrs/service/impl/AgvMobileServiceImpl.java  |   10 
 src/main/resources/四期sql/devp                                     |   96 +++++++++++++
 src/main/java/com/zy/asrs/task/AutoMoveScheduler.java             |   10 
 src/main/java/com/zy/asrs/task/OrderSyncScheduler.java            |    2 
 src/main/java/com/zy/asrs/service/impl/AgvBasDevpServiceImpl.java |    6 
 src/main/java/com/zy/asrs/service/impl/AgvWrkMastServiceImp.java  |    2 
 src/main/java/com/zy/asrs/mapper/AgvBasDevpMapper.java            |   11 +
 src/main/java/com/zy/asrs/task/handler/AgvWrkMastHandler.java     |    6 
 src/main/java/com/zy/common/service/AgvCommonService.java         |    6 
 src/main/java/com/zy/asrs/controller/AgvMobileController.java     |   24 +++
 src/main/java/com/zy/asrs/service/impl/AgvWorkServiceImpl.java    |  213 ++++++++++++++++++++++++++++++
 src/main/java/com/zy/asrs/controller/OutController.java           |    2 
 src/main/java/com/zy/asrs/service/AgvWorkService.java             |    3 
 src/main/java/com/zy/asrs/service/AgvBasDevpService.java          |    4 
 src/main/java/com/zy/asrs/task/handler/AutoMoveHandler.java       |   12 +
 18 files changed, 389 insertions(+), 27 deletions(-)

diff --git a/src/main/java/com/zy/asrs/controller/AgvLocDetlController.java b/src/main/java/com/zy/asrs/controller/AgvLocDetlController.java
index 08f5a62..63c9e80 100644
--- a/src/main/java/com/zy/asrs/controller/AgvLocDetlController.java
+++ b/src/main/java/com/zy/asrs/controller/AgvLocDetlController.java
@@ -123,7 +123,8 @@
         AgvWrkMast agvWrkMast = agvWrkMastService.selectOne(new EntityWrapper<AgvWrkMast>().eq("source_loc_no", param.get("loc_no")));
         String orderNo = null;
         if (agvWrkMast != null) {
-            List<AgvWrkDetl> agvWrkDetls = agvWrkDetlService.selectByWrkNo(agvWrkMast.getWrkNo());
+            //List<AgvWrkDetl> agvWrkDetls = agvWrkDetlService.selectByWrkNo(agvWrkMast.getWrkNo());
+            List<AgvWrkDetl> agvWrkDetls = agvWrkDetlService.selectList(new EntityWrapper<AgvWrkDetl>().eq("wrk_no", agvWrkMast.getWrkNo()));
             if (!agvWrkDetls.isEmpty()) {
                 orderNo = agvWrkDetls.get(0).getOrderNo();
             }
diff --git a/src/main/java/com/zy/asrs/controller/AgvMobileController.java b/src/main/java/com/zy/asrs/controller/AgvMobileController.java
index 76361f2..2cc3121 100644
--- a/src/main/java/com/zy/asrs/controller/AgvMobileController.java
+++ b/src/main/java/com/zy/asrs/controller/AgvMobileController.java
@@ -167,6 +167,28 @@
     }
 
     /*
+    鍚姩鍏ュ簱锛岀粍鎵� + 鐢熸垚宸ヤ綔妗�,涓昏鐢ㄤ簬鍚稿涓�妤肩殑鍏ュ簱
+    */
+    @PostMapping("/start/pakin/auth/v2")
+    @Synchronized
+    @Transactional
+    @ManagerAuth(memo = "鍚姩鍏ュ簱v2")
+    public R startPakinV2(@RequestBody AgvMobileStartPakin params) {
+        if (params == null) {
+            return R.error("缂哄皯鍙傛暟");
+        }
+        log.info("鍚姩鍏ュ簱v2,{}", JSON.toJSONString(params));
+        // 缁勬墭
+        params.getCombParams().forEach(combParam -> {
+            agvMobileService.comb(combParam, getUserId());
+        });
+        params.setContainerType(Short.valueOf(params.getContainerCode().substring(0, 2)));
+        workService.emptyPlateInV2(params.getDevNo(), params.getContainerCode(), params.getContainerType(), getUserId(), false, params.getFactory());
+
+        return R.ok("鐢熸垚宸ヤ綔妗ｆ垚鍔�");
+    }
+
+    /*
     鍏ュ簱
      */
     @PostMapping("/pakin/empty/auth")
@@ -605,7 +627,7 @@
             if (Cools.isEmpty(locMastS)) {
                 throw new CoolException("褰撳墠搴撲綅闈炲湪搴撶姸鎬侊紒搴撲綅鍙�=" + locNo);
             }
-            AgvWrkMast wrkMast = createWrkMast(ioType, 22L, locNo, "", barcode, now, getUserId(), 30, floor);
+            AgvWrkMast wrkMast = createWrkMast(ioType, 22L, locNo, "", barcode, now, getUserId(), Integer.parseInt(barcode.substring(0,2)), floor);
             // 鍚屾璋冩嫧鍗�
             long flowId = snowflakeIdWorker.nextId();
             List<AgvLocDetl> agvLocDetls = agvLocDetlService.selectList(new EntityWrapper<AgvLocDetl>().eq("loc_no", locNo));
diff --git a/src/main/java/com/zy/asrs/controller/OutController.java b/src/main/java/com/zy/asrs/controller/OutController.java
index 2a8ac8a..70a25c7 100644
--- a/src/main/java/com/zy/asrs/controller/OutController.java
+++ b/src/main/java/com/zy/asrs/controller/OutController.java
@@ -179,7 +179,7 @@
             }
 
             AgvLocMast agvLocMast = agvLocMastService.selectById(locDto.getLocNo());
-            List<String> staNoList = agvBasDevpService.selectCacheShelvesStationCodeByLocType(agvLocMast.getLocType1(),agvLocMast.getFloor());
+            List<String> staNoList = agvBasDevpService.selectCacheShelvesStationCodeByLocType(agvLocMast.getLocType1());
 
             if(!staNoList.contains(locDto.getAgvStaNo())){
                 return R.error(locDto.getAgvStaNo()+"璇ョ珯鐐瑰凡鏈夊嚭搴撲换鍔★紝鏃犳硶閫夋嫨璇ョ珯鐐瑰嚭搴�");
diff --git a/src/main/java/com/zy/asrs/mapper/AgvBasDevpMapper.java b/src/main/java/com/zy/asrs/mapper/AgvBasDevpMapper.java
index 885fb64..bcee96b 100644
--- a/src/main/java/com/zy/asrs/mapper/AgvBasDevpMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/AgvBasDevpMapper.java
@@ -41,6 +41,17 @@
             "\tdev_no \n" +
             "FROM\n" +
             "\tagv_bas_devp\n" +
+            "\tLEFT JOIN agv_wrk_mast ON agv_bas_devp.dev_no = agv_wrk_mast.loc_no \n" +
+            "WHERE\n" +
+            "\tagv_wrk_mast.loc_no IS NULL \n" +
+            "\tAND agv_bas_devp.loc_type1 = #{locType} \n" +
+            "\tAND agv_bas_devp.out_enable = 'Y'")
+    List<String> selectCacheShelvesStationCodeByLocTypeV2(@Param("locType") Short locType);
+
+    @Select("SELECT\n" +
+            "\tdev_no \n" +
+            "FROM\n" +
+            "\tagv_bas_devp\n" +
             "\tLEFT JOIN agv_wrk_mast ON agv_bas_devp.dev_no = agv_wrk_mast.source_loc_no \n" +
             "WHERE\n" +
             "\tagv_wrk_mast.loc_no IS NULL \n" +
diff --git a/src/main/java/com/zy/asrs/service/AgvBasDevpService.java b/src/main/java/com/zy/asrs/service/AgvBasDevpService.java
index dab9548..43557f4 100644
--- a/src/main/java/com/zy/asrs/service/AgvBasDevpService.java
+++ b/src/main/java/com/zy/asrs/service/AgvBasDevpService.java
@@ -26,6 +26,10 @@
 
     List<String> selectCacheShelvesStationCodeByFloor(int floor);
     List<String> selectCacheShelvesStationCodeByLocType(short locType, int floor);
+
+    List<String> selectCacheShelvesStationCodeByLocType(short locType);
+
+
     List<String> selectCacheShelvesStationCodeByLocType2(short locType, int floor);
 
     public List<Map<String,Object>> selectDevNoAndNumBystationCode(String stationCode);
diff --git a/src/main/java/com/zy/asrs/service/AgvWorkService.java b/src/main/java/com/zy/asrs/service/AgvWorkService.java
index b266a04..06bafe4 100644
--- a/src/main/java/com/zy/asrs/service/AgvWorkService.java
+++ b/src/main/java/com/zy/asrs/service/AgvWorkService.java
@@ -46,6 +46,9 @@
      */
     String emptyPlateIn(String station, String containerCode, Short containerType, Long userId, boolean emptyAutoIn);
 
+    String emptyPlateInV2(String station, String containerCode, Short containerType, Long userId, boolean emptyAutoIn,String factory);
+
+
     void emptyPlateOut(String station, int containerType, Long userId);
 
     /**
diff --git a/src/main/java/com/zy/asrs/service/impl/AgvBasDevpServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/AgvBasDevpServiceImpl.java
index 2242247..a3f6339 100644
--- a/src/main/java/com/zy/asrs/service/impl/AgvBasDevpServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/AgvBasDevpServiceImpl.java
@@ -303,6 +303,12 @@
     public List<String> selectCacheShelvesStationCodeByLocType(short locType, int floor) {
         return this.baseMapper.selectCacheShelvesStationCodeByLocType(locType,floor);
     }
+
+    @Override
+    public List<String> selectCacheShelvesStationCodeByLocType(short locType) {
+        return this.baseMapper.selectCacheShelvesStationCodeByLocTypeV2(locType);
+    }
+
     @Override
     public List<String> selectCacheShelvesStationCodeByLocType2(short locType, int floor) {
         return this.baseMapper.selectCacheShelvesStationCodeByLocType2(locType,floor);
diff --git a/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java
index a6d8aac..fbf95e5 100644
--- a/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/AgvLocDetlServiceImpl.java
@@ -134,7 +134,9 @@
                 //褰撳墠搴撲綅鎵�澶勬ゼ灞�
                 int floor = Integer.parseInt(agvLocDetl.getLocNo().split("F")[1]);
                 //locDto.setAgvStaNos(queryAgvStaNosByFloor(floor));
-                locDto.setAgvStaNos(agvBasDevpService.selectCacheShelvesStationCodeByLocType(agvLocMast.getLocType1(), floor));
+                //鍥涙湡
+                //locDto.setAgvStaNos(agvBasDevpService.selectCacheShelvesStationCodeByLocType(agvLocMast.getLocType1(), floor));
+                locDto.setAgvStaNos(agvBasDevpService.selectCacheShelvesStationCodeByLocType(agvLocMast.getLocType1()));
                 locDtoList.add(locDto);
 
                 issued -= anfme;
diff --git a/src/main/java/com/zy/asrs/service/impl/AgvMobileServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/AgvMobileServiceImpl.java
index 41dc775..ddb7f00 100644
--- a/src/main/java/com/zy/asrs/service/impl/AgvMobileServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/AgvMobileServiceImpl.java
@@ -876,11 +876,11 @@
         agvWrkMast.setModiTime(now);
         agvWrkMast.setIoTime(now);
         // 鎵撴爣璁帮紝鑻ュ簱浣嶄笉澶燂紝鍏ュ簱鍒板埆鐨勬ゼ灞傦紝閭ｄ箞闇�瑕佽法灞傜Щ搴�
-        if (!Cools.isEmpty(factory)){
-            if (newLocMast.getLev1() == 1 && factory.equals(AsrsConstants.SANCHANG)) {
-                agvWrkMast.setPacked("1");
-            } else if (newLocMast.getLev1() == 2 && factory.equals(AsrsConstants.ERCHANG)) {
-                agvWrkMast.setPacked("1");
+        if (!Cools.isEmpty(factory)) {
+            if (newLocMast.getLev1() == 1 && !factory.equals(AsrsConstants.SANCHANG)) {
+                agvWrkMast.setCtnNo("1");
+            } else if (newLocMast.getLev1() == 2 && !factory.equals(AsrsConstants.ERCHANG)) {
+                agvWrkMast.setCtnNo("1");
             }
         }
         if (!agvWrkMastService.update(agvWrkMast, new EntityWrapper<AgvWrkMast>().eq("wrk_no", agvWrkMast.getWrkNo()))) {
diff --git a/src/main/java/com/zy/asrs/service/impl/AgvWorkServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/AgvWorkServiceImpl.java
index 3ee5b12..b869eb7 100644
--- a/src/main/java/com/zy/asrs/service/impl/AgvWorkServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/AgvWorkServiceImpl.java
@@ -7,6 +7,7 @@
 import com.core.common.Cools;
 import com.core.common.SnowflakeIdWorker;
 import com.core.exception.CoolException;
+import com.zy.asrs.constant.AsrsConstants;
 import com.zy.asrs.entity.*;
 import com.zy.asrs.entity.param.LocDetlAdjustParam;
 import com.zy.asrs.entity.param.StockOutParam;
@@ -594,8 +595,164 @@
             String devNo = agvBasDevp.getDevNo();
             String locNo = agvLocMast.getLocNo();
 
+
             //鐢熸垚宸ヤ綔妗�
             AgvWrkMast wrkMast = createWrkMast(1, 201L, devNo, locNo, containerCode, now, userId, containerType, agvLocMast.getPltType());
+            //鐢熸垚宸ヤ綔妗ｆ槑缁�
+            long flowId = snowflakeIdWorker.nextId();
+            agvWaitPakinList.forEach(wp -> {
+                createWrkDetlReWrite(wp.getMatnr(), wrkMast.getWrkNo(), wp.getOrderNo(), wp.getBatch(), wp.getAnfme(), wp.getSuppCode(), now, userId, wp.getThreeCode(), wp.getDeadTime(), wp.getProcessSts());
+            });
+            //淇敼鍏ュ簱閫氱煡妗ｇ姸鎬�
+            agvWaitPakinService.updateIoStatus(containerCode, "Y");
+            //鏇存柊婧愮珯鐐圭姸鎬�
+            updateAgvBasDevp(agvBasDevp, "R", containerType);
+        } else {
+            //鏌ヨ宸ヤ綔妗�
+            AgvWrkMast agvWrkMast1 = agvWrkMastService.selectByContainerCode(containerCode);
+            if (!Cools.isEmpty(agvWrkMast1)) {
+                throw new CoolException("褰撳墠璐ф灦宸叉湁鍏ュ簱浠诲姟锛屾棤娉曡繘琛屽叆搴�");
+            }
+            agvLocMast = agvCommonService.getLocNo(locType, agvBasDevp.getFloor(), true, true);
+            // 鐢熸垚宸ヤ綔妗� 10.绌烘澘鍏ュ簱
+            createWrkMast(10, 201L, agvBasDevp.getDevNo(), agvLocMast.getLocNo(), containerCode, now, userId, containerType, agvLocMast.getPltType());
+            //鏇存柊婧愮珯鐐圭姸鎬�
+            updateAgvBasDevp(agvBasDevp, "R", containerType, containerCode);
+        }
+
+        //鏇存柊鐩爣搴撲綅鐘舵�佸拰淇℃伅
+        updateAgvLocMast(agvLocMast, "S");
+        return agvLocMast.getLocNo();
+    }
+
+    /*
+   鍏ュ簱
+    */
+    @Transactional
+    public String emptyPlateInV2(String station, String containerCode, Short containerType, Long userId, boolean emptyAutoIn, String code) {
+
+        Date now = new Date();
+
+        Short locType = 0;
+
+        AgvBasDevp agvBasDevp = agvBasDevpService.selectById(station);
+        if (Cools.isEmpty(agvBasDevp)) {
+            throw new CoolException("鏆傛棤" + station + "绔欑偣");
+        }
+        int br = 0;
+        if (containerType == 21 && agvBasDevp.getFloor() == 2) {
+            containerType = 20;
+        }
+        switch (containerType) {
+            case 10:
+                br = 1;
+                break;
+            case 20:
+                br = 2;
+                break;
+            case 21:
+                br = 4;
+                break;
+            case 30:
+                br = 3;
+                break;
+            case 31:
+                br = 6;
+                break;
+            case 40:
+                br = 5;
+                break;
+        }
+        if (br == 4 && agvBasDevp.getLocType1() == 2) {
+            br = 2;
+        }
+        if (agvBasDevp.getLocType1() != br) {
+            throw new CoolException("绔欑偣绫诲瀷鍜岃揣鏋剁被鍨嬩笉绗︼紒");
+        }
+        AtomicReference<String> factory = new AtomicReference<>();
+        if (containerType == 40) {
+            locType = 5;
+        } else if (containerType == 21 && agvBasDevp.getFloor() == 3) {
+            locType = 4;
+        } else if (containerType == 20 && agvBasDevp.getFloor() == 3) {
+            locType = 2;
+        } else if (containerType == 30) {
+            locType = 3;
+        } else if (containerType == 31) {
+            locType = 6;
+        } else {
+            locType = agvBasDevp.getLocType1();
+        }
+
+        if (!Cools.eq(agvBasDevp.getBarcode(), containerCode) && !agvBasDevp.getLocSts().equals("O") && !emptyAutoIn) {
+            throw new CoolException("褰撳墠宸ヤ綔浣嶇姸鎬佷负" + agvBasDevp.getLocSts() + ",鏃犳硶杩涜鍏ュ簱");
+        }
+
+        //鏌ヨ宸ヤ綔妗�
+        AgvWrkMast agvWrkMast = agvWrkMastService.selectByContainerCode(containerCode);
+        if (!Cools.isEmpty(agvWrkMast) && !emptyAutoIn) {
+            throw new CoolException("褰撳墠璐ф灦宸叉湁鍏ュ簱浠诲姟锛屾棤娉曡繘琛屽叆搴�");
+        }
+
+        //妫�绱㈠簱浣嶏紝閫夋嫨鍚堥�傜殑搴撲綅
+        AgvLocMast agvLocMast = new AgvLocMast();
+
+        //鏌ヨ搴撳瓨
+        AgvLocMast locMast = agvLocMastService.selectOne(new EntityWrapper<AgvLocMast>().eq("barcode", containerCode));
+        if (!Cools.isEmpty(locMast)) {
+            throw new CoolException("褰撳墠璐ф灦宸插湪搴撳瓨涓紝鏃犳硶杩涜鍏ュ簱");
+        }
+
+        //鏌ヨ鍏ュ簱閫氱煡妗�
+        List<AgvWaitPakin> agvWaitPakinList = agvWaitPakinService.selectByContainerCode(containerCode);
+        if (!Cools.isEmpty(agvWaitPakinList)) {
+            AtomicBoolean isCurrLev = new AtomicBoolean(false);
+            agvWaitPakinList.forEach(agvWaitPakin -> {
+                factory.set(OrderUtils.getFactory(agvWaitPakin.getThreeCode()));
+                if (!Cools.isEmpty(agvWaitPakin.getProcessSts())) {
+                    if (agvWaitPakin.getProcessSts() == 1) {
+                        isCurrLev.set(true);
+                    }
+                }
+            });
+
+
+//            Config config = configService.selectOne(new EntityWrapper<Config>().eq("code", "elevatorTasks"));
+//            if (Cools.isEmpty(config)) {
+//                if (isCurrLev.get()) {
+//                    agvLocMast = agvCommonService.getLocNo(locType, agvBasDevp.getFloor(), false, true);
+//                } else {
+//                    agvLocMast = agvCommonService.getLocNo(locType, agvBasDevp.getFloor(), false, false);
+//                }
+//            } else {
+//                List<AgvWrkMast> agvWrkMasts = agvWrkMastService.selectList(new EntityWrapper<AgvWrkMast>().like("loc_no", "02F1").like("source_loc_no", "F1"));
+//                if (Integer.parseInt(config.getValue()) <= agvWrkMasts.size()) {
+//                    agvLocMast = agvCommonService.getLocNo(locType, agvBasDevp.getFloor(), false, true);
+//                } else {
+//                    if (isCurrLev.get()) {
+//                        agvLocMast = agvCommonService.getLocNo(locType, agvBasDevp.getFloor(), false, true);
+//                    } else {
+//                        agvLocMast = agvCommonService.getLocNo(locType, agvBasDevp.getFloor(), false, false);
+//                    }
+//                    //agvLocMast = agvCommonService.getLocNo(locType,agvBasDevp.getFloor(),false,false);
+//                }
+//            }
+            agvLocMast = agvCommonService.getLocByLocRule(3, 1, code);
+
+
+            String devNo = agvBasDevp.getDevNo();
+            String locNo = agvLocMast.getLocNo();
+            String ctnNo = null;
+            // 鎵撴爣璁帮紝鑻ュ簱浣嶄笉澶燂紝鍏ュ簱鍒板埆鐨勬ゼ灞傦紝閭ｄ箞闇�瑕佽法灞傜Щ搴�
+            if (!Cools.isEmpty(code)) {
+                if (agvLocMast.getLev1() == 1 && !code.equals(AsrsConstants.SANCHANG)) {
+                    ctnNo = "1";
+                } else if (agvLocMast.getLev1() == 2 && !code.equals(AsrsConstants.ERCHANG)) {
+                    ctnNo = "1";
+                }
+            }
+            //鐢熸垚宸ヤ綔妗�
+            AgvWrkMast wrkMast = createWrkMastV2(1, 201L, devNo, locNo, containerCode, now, userId, containerType, agvLocMast.getPltType(), ctnNo);
             //鐢熸垚宸ヤ綔妗ｆ槑缁�
             long flowId = snowflakeIdWorker.nextId();
             agvWaitPakinList.forEach(wp -> {
@@ -1049,9 +1206,11 @@
                 // 鏇存柊璁㈠崟
                 for (AgvLocDetl agvLocDetl : agvLocDetls) {
                     OrderDetl orderDetl = orderDetlService.selectOne(new EntityWrapper<OrderDetl>().eq("order_no", "DB" + agvLocDetl.getOrderNo()).eq("matnr", agvLocDetl.getMatnr()).eq("three_code", agvLocDetl.getThreeCode()));
-                    orderDetl.setQty(orderDetl.getQty() - agvLocDetl.getAnfme());
-                    if (!orderDetlService.update(orderDetl, new EntityWrapper<OrderDetl>().eq("order_no", "DB" + agvLocDetl.getOrderNo()).eq("matnr", agvLocDetl.getMatnr()).eq("three_code", agvLocDetl.getThreeCode()))) {
-                        throw new CoolException("淇敼璁㈠崟鏄庣粏澶辫触锛岃鑱旂郴绠＄悊鍛�" + agvLocDetl.getOrderNo() + agvLocDetl.getMatnr());
+                    if (orderDetl != null) {
+                        orderDetl.setQty(orderDetl.getQty() - agvLocDetl.getAnfme());
+                        if (!orderDetlService.update(orderDetl, new EntityWrapper<OrderDetl>().eq("order_no", "DB" + agvLocDetl.getOrderNo()).eq("matnr", agvLocDetl.getMatnr()).eq("three_code", agvLocDetl.getThreeCode()))) {
+                            throw new CoolException("淇敼璁㈠崟鏄庣粏澶辫触锛岃鑱旂郴绠＄悊鍛�" + agvLocDetl.getOrderNo() + agvLocDetl.getMatnr());
+                        }
                     }
 //                    FlowLog flowLog = new FlowLog();
 //                    flowLog.setFid(String.valueOf(flowId));
@@ -1346,6 +1505,7 @@
         wrkMast.setPltType(pltType);
         wrkMast.setLogErrMemo("createWaitPainWrkMastStart");
 
+
         if (!agvWrkMastService.insertByIncrease(wrkMast)) {
             throw new CoolException("淇濆瓨宸ヤ綔妗ｅけ璐�");
         }
@@ -1358,6 +1518,53 @@
         return wrkMast;
     }
 
+    /*
+   鐢熸垚宸ヤ綔妗�
+    */
+    private AgvWrkMast createWrkMastV2(int ioType, long wrkSts, String sourceLocNo, String locNo, String barcode, Date now, Long userId, int containerType, Integer pltType, String ctnNo) {
+        AgvWrkMast wrkMast = new AgvWrkMast();
+        //宸ヤ綔鐘舵��
+        wrkMast.setWrkSts(wrkSts);
+        //鍏ュ嚭搴撶被鍨�
+        wrkMast.setIoType(ioType);
+        wrkMast.setIoTime(now);
+        //浼樺厛绾�
+        wrkMast.setIoPri(300.0);
+        //婧愮珯鐐�
+        wrkMast.setSourceLocNo(sourceLocNo);
+        //鐩爣绔欑偣
+        wrkMast.setLocNo(locNo);
+        //璐ф灦缂栫爜
+        wrkMast.setBarcode(barcode);
+        //璐ф灦绫诲瀷
+        wrkMast.setWhsType(containerType);
+
+        wrkMast.setAppeUser(userId);
+        wrkMast.setAppeTime(now);
+        wrkMast.setModiUser(userId);
+        wrkMast.setModiTime(now);
+        if (!Cools.isEmpty(locNo) && Cools.isEmpty(pltType)) {
+            AgvLocMast agvLocMast = agvLocMastService.selectById(locNo);
+            pltType = agvLocMast.getPltType();
+        }
+        wrkMast.setPltType(pltType);
+        wrkMast.setLogErrMemo("createWaitPainWrkMastStart");
+        wrkMast.setCtnNo(ctnNo);
+
+
+        if (!agvWrkMastService.insertByIncrease(wrkMast)) {
+            throw new CoolException("淇濆瓨宸ヤ綔妗ｅけ璐�");
+        }
+
+        //鏆傚瓨浣嶄换鍔�+1
+        addInQty(locNo);
+
+        wrkMast = agvWrkMastService.selectOne(new EntityWrapper<AgvWrkMast>().eq("loc_no", locNo).eq("source_loc_no", sourceLocNo));
+
+        return wrkMast;
+    }
+
+
     private boolean isPakOut(String locNo, TaskDto taskDto) {
         Double allAnfme = agvLocDetlService.selectSumAnfmeByLocNo(locNo);
         Double pakOutAnfme = 0.0;
diff --git a/src/main/java/com/zy/asrs/service/impl/AgvWrkMastServiceImp.java b/src/main/java/com/zy/asrs/service/impl/AgvWrkMastServiceImp.java
index 383ea3b..07c0a8c 100644
--- a/src/main/java/com/zy/asrs/service/impl/AgvWrkMastServiceImp.java
+++ b/src/main/java/com/zy/asrs/service/impl/AgvWrkMastServiceImp.java
@@ -286,7 +286,7 @@
     private boolean processUseTiShengJi(String sourceLocNo, String locNo) {
         // 鍒ゆ柇鏄惁鏄彁鍗囨満
         if (sourceLocNo.startsWith("YZ")) {
-            if (sourceLocNo.endsWith("01F2") && !locNo.startsWith("YZ") && locNo.endsWith("F4") && locNo.startsWith("Q")) {
+            if (sourceLocNo.endsWith("01F2") && !locNo.startsWith("YZ") && locNo.endsWith("F4") ) {
                 // 浠庣敓浜т簩鍘傜殑搴撲綅鍒板惛濉戜簩鍘傜殑鐐逛綅涓�
                 return true;
             } else if (sourceLocNo.endsWith("01F2") && locNo.startsWith("YZ") && locNo.endsWith("02F1")) {
diff --git a/src/main/java/com/zy/asrs/task/AutoMoveScheduler.java b/src/main/java/com/zy/asrs/task/AutoMoveScheduler.java
index c6d9042..e8f5d8c 100644
--- a/src/main/java/com/zy/asrs/task/AutoMoveScheduler.java
+++ b/src/main/java/com/zy/asrs/task/AutoMoveScheduler.java
@@ -218,7 +218,9 @@
         // 鏌ヨ 涓嶄负1妤肩殑绌鸿揣鏋�
         List<AgvLocMast> agvLocMasts = agvLocMastService.selectList(new EntityWrapper<AgvLocMast>()
                 // TODO 鍥涙湡
-                .eq("loc_sts", "D").eq("loc_type1", 3).ne("floor", 1).ne("lev1", 1));
+                .eq("loc_sts", "D").eq("loc_type1", 3)
+                .andNew()
+                .ne("floor", 1).or().ne("lev1", 1));
         if (agvLocMasts.isEmpty()) {
             return;
         }
@@ -335,7 +337,7 @@
     }
 
     /**
-     * 鑷姩绉诲簱
+     * 璺ㄥ眰鑷姩绉诲簱
      */
     @Scheduled(cron = "0/2 * * * * ? ")
     private void autoEmptyBack7() throws ParseException {
@@ -382,7 +384,7 @@
 
 
     /**
-     * 鑷姩绉诲簱锛屽洓鏈�
+     * 鎵撴爣璁扮殑搴撲綅杩涜鑷姩绉诲簱锛屽洓鏈�
      * 鍦ㄥ簱浣嶄笉澶熺殑鎯呭喌涓嬶紝绠卞３鍏ュ簱鍒殑妤煎眰搴撲綅鐨勬椂鍊欙紝鏅氫笂杩涜璺ㄥ眰绉诲簱
      */
     @Scheduled(cron = "0/2 * * * * ? ")
@@ -406,7 +408,7 @@
             long time3 = time - time1;
 
 
-            if (time3 > 0 && time3 < (1000 * 60 * 10)) {
+            if (time3 > 0) {
 
                 List<AgvWrkMast> agvWrkMasts = agvWrkMastService.selectList(new EntityWrapper<AgvWrkMast>().eq("io_type", 12));
                 if (agvWrkMasts != null && maxTansk <= agvWrkMasts.size()) {
diff --git a/src/main/java/com/zy/asrs/task/OrderLogScheduler.java b/src/main/java/com/zy/asrs/task/OrderLogScheduler.java
index ff27c40..2b14763 100644
--- a/src/main/java/com/zy/asrs/task/OrderLogScheduler.java
+++ b/src/main/java/com/zy/asrs/task/OrderLogScheduler.java
@@ -24,7 +24,7 @@
 //    private boolean isERP;
 //
     //@Scheduled(cron = "0/10 * * * * ? ")
-    @Scheduled(fixedDelay = 1000)
+    @Scheduled(fixedDelay = 60000)
     private void execute() {
         List<Order> orders = orderService.selectToBeHistoryOrder();
         if (orders.isEmpty()) {
diff --git a/src/main/java/com/zy/asrs/task/OrderSyncScheduler.java b/src/main/java/com/zy/asrs/task/OrderSyncScheduler.java
index fa4219c..dc7c784 100644
--- a/src/main/java/com/zy/asrs/task/OrderSyncScheduler.java
+++ b/src/main/java/com/zy/asrs/task/OrderSyncScheduler.java
@@ -109,7 +109,7 @@
     瀹氭椂鏌ヨ鐘舵�佷负2.浣滀笟涓殑鍗曟嵁锛屾鏌ユ槸鍚﹀畬鎴�
      */
     //@Scheduled(cron = "0 */1 * * * ? ")
-    @Scheduled(fixedDelay = 60000)
+    @Scheduled(fixedDelay = 600000)
     public void completeOrder() {
         try {
             Page<Order> settle = orderService.selectPage(new Page<Order>(page, size), new EntityWrapper<Order>().eq("settle", 2));
diff --git a/src/main/java/com/zy/asrs/task/handler/AgvWrkMastHandler.java b/src/main/java/com/zy/asrs/task/handler/AgvWrkMastHandler.java
index 3d79d0d..b22ed86 100644
--- a/src/main/java/com/zy/asrs/task/handler/AgvWrkMastHandler.java
+++ b/src/main/java/com/zy/asrs/task/handler/AgvWrkMastHandler.java
@@ -171,7 +171,7 @@
 
             switch (agvWrkMast.getIoType()) {
                 case 1:
-                    agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(), "F", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue());
+                    agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(), "F", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue(),agvWrkMast.getCtnNo());
                     //鏇存柊鐩爣搴撲綅鏄庣粏
                     log.info("鏇存柊鐩爣搴撲綅鏄庣粏 agvWrkMast.getLocNo(): " + agvWrkMast.getLocNo() + ", wrkNo: " + wrkNo);
                     agvLocDetlService.addLocDetlInfo(agvWrkMast.getLocNo(), wrkNo);
@@ -191,7 +191,7 @@
                     //鏇存柊搴撳瓨鏄庣粏
                     agvLocDetlService.updateStock(agvWrkMast.getSourceLocNo(), agvWrkMast.getLocNo());
                     //淇敼婧愬簱浣嶇姸鎬佷负O
-                    agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(), "O", "", null,null);
+                    agvLocMastService.updateLocStsByLocNo(agvWrkMast.getSourceLocNo(), "O", "", null,"");
                     break;
                 case 53:
                     //淇敼宸ヤ綔鍏氭槑缁�
@@ -254,7 +254,7 @@
                     });
                     // 鏇存柊绔欑偣 + 搴撲綅鐘舵��     婧愬簱浣嶆槸绔欑偣
                     agvBasDevpService.updateLocStsAndBarcodeByDevNo(agvWrkMast.getSourceLocNo(), "O", "", agvWrkMast.getWhsType().shortValue());
-                    agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(), "F", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue(),agvWrkMast.getPacked());
+                    agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(), "F", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue(),agvWrkMast.getCtnNo());
                     break;
                 case 58:
                     agvLocMastService.updateLocStsByLocNo(agvWrkMast.getLocNo(), "F", agvWrkMast.getBarcode(), agvWrkMast.getWhsType().shortValue());
diff --git a/src/main/java/com/zy/asrs/task/handler/AutoMoveHandler.java b/src/main/java/com/zy/asrs/task/handler/AutoMoveHandler.java
index b96533b..0b4fb38 100644
--- a/src/main/java/com/zy/asrs/task/handler/AutoMoveHandler.java
+++ b/src/main/java/com/zy/asrs/task/handler/AutoMoveHandler.java
@@ -193,8 +193,16 @@
 
     private ReturnT<String> doAutoMove2(AgvWrkMast agvWrkMast) {
         Date now = new Date();
-        //妫�绱㈠簱浣嶏紝閫夋嫨鍚堥�傜殑搴撲綅
-        AgvLocMast locMast = agvCommonService.getLocNo(3, agvWrkMast.getCrnNo(), false, true);
+        String barcode = agvWrkMast.getBarcode();
+        AgvLocMast locMast;
+        if (Integer.parseInt(barcode.substring(0, 2)) == 31) {
+            //妫�绱㈠簱浣嶏紝閫夋嫨鍚堥�傜殑搴撲綅
+            locMast = agvCommonService.getLocByLocRule(6, 2, 1);
+        } else {
+            //妫�绱㈠簱浣嶏紝閫夋嫨鍚堥�傜殑搴撲綅
+            locMast = agvCommonService.getLocNo(3, agvWrkMast.getCrnNo(), false, true);
+        }
+
         if (Cools.isEmpty(locMast)) {
             log.info("鏆傛棤搴撲綅");
             return FAIL;
diff --git a/src/main/java/com/zy/common/service/AgvCommonService.java b/src/main/java/com/zy/common/service/AgvCommonService.java
index d026f0d..c7903e4 100644
--- a/src/main/java/com/zy/common/service/AgvCommonService.java
+++ b/src/main/java/com/zy/common/service/AgvCommonService.java
@@ -152,15 +152,15 @@
             List<AgvLocMast> agvLocMasts = new ArrayList<>();
             //涓嶆槸绌烘澘浼樺厛鎵�2灞�
             if (Cools.isEmpty(factory)) {
-                wrapper.eq("floor", floor).orderBy("lev1", false);
+                wrapper.eq("floor", floor).orderBy("lev1", true);
             } else {
                 //B鏄簩鍘傦紝G鏄笁鍘�
                 switch (factory) {
                     case "B":
-                        wrapper.eq("floor", floor).orderBy("lev1", true);
+                        wrapper.eq("floor", floor).orderBy("lev1", false);
                         break;
                     case "G":
-                        wrapper.eq("floor", floor).orderBy("lev1", false);
+                        wrapper.eq("floor", floor).orderBy("lev1", true);
                         break;
                     default:
                         wrapper.eq("floor", floor).orderBy("lev1", true);
diff --git "a/src/main/resources/\345\233\233\346\234\237sql/devp" "b/src/main/resources/\345\233\233\346\234\237sql/devp"
new file mode 100644
index 0000000..e00e9ad
--- /dev/null
+++ "b/src/main/resources/\345\233\233\346\234\237sql/devp"
@@ -0,0 +1,96 @@
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_01F4', NULL, NULL, 'N', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 133, '2024-07-04 16:24:38.550', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_02F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_03F4', NULL, NULL, 'N', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 133, '2024-07-04 16:24:44.600', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_04F4', NULL, NULL, 'N', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 133, '2024-07-04 16:25:01.967', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_05F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_06F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_07F4', NULL, NULL, 'N', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 133, '2024-07-04 16:25:13.467', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_08F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_09F4', NULL, NULL, 'N', 'N', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 26, '2024-12-10 14:35:21.377', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_10F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_11F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_12F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('XO_01F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 3, 30, NULL, NULL, '2024-04-02 09:25:50.763', NULL, '2024-04-02 09:25:50.763', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('XO_02F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 3, 30, NULL, NULL, '2024-04-02 09:25:50.763', NULL, '2024-04-02 09:25:50.763', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('XO_03F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 3, 30, NULL, NULL, '2024-04-02 09:25:50.763', NULL, '2024-04-02 09:25:50.763', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('XO_04F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 3, 30, NULL, NULL, '2024-04-02 09:25:50.763', NULL, '2024-04-02 09:25:50.763', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('XO_05F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 3, 30, NULL, NULL, '2024-04-02 09:25:50.763', NULL, '2024-04-02 09:25:50.763', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('XO_06F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 3, 30, NULL, NULL, '2024-04-02 09:25:50.763', NULL, '2024-04-02 09:25:50.763', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('XO_07F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 3, 30, NULL, NULL, '2024-04-02 09:25:50.763', NULL, '2024-04-02 09:25:50.763', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('XO_08F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 3, 30, NULL, NULL, '2024-04-02 09:25:50.763', NULL, '2024-04-02 09:25:50.763', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('YO_01F4', NULL, NULL, 'N', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 2, 20, NULL, 133, '2024-07-04 16:24:38.550', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('YO_02F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 2, 20, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('YO_03F4', NULL, NULL, 'N', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 2, 20, NULL, 133, '2024-07-04 16:24:44.600', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('YO_04F4', NULL, NULL, 'N', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 2, 20, NULL, 133, '2024-07-04 16:25:01.967', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('YO_05F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 2, 20, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('YO_06F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 2, 20, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('YO_07F4', NULL, NULL, 'N', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 2, 20, NULL, 133, '2024-07-04 16:25:13.467', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('YO_08F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 2, 20, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('YO_09F4', NULL, NULL, 'N', 'N', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 2, 20, NULL, 26, '2024-12-10 14:35:21.377', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('YO_10F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 2, 20, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('YO_11F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 2, 20, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('YO_12F4', NULL, NULL, 'N', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 4, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 2, 20, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_01F2', NULL, NULL, 'Y', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 133, '2024-07-04 16:24:38.550', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_02F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_03F2', NULL, NULL, 'Y', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 133, '2024-07-04 16:24:44.600', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_04F2', NULL, NULL, 'Y', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 133, '2024-07-04 16:25:01.967', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_05F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_06F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_07F2', NULL, NULL, 'Y', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 133, '2024-07-04 16:25:13.467', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_08F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_09F2', NULL, NULL, 'Y', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 26, '2024-12-10 14:35:21.377', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_10F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_11F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_12F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_13F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_14F2', NULL, NULL, 'Y', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 26, '2024-12-10 14:35:41.707', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_15F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_16F2', NULL, NULL, 'Y', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 133, '2024-07-09 08:54:06.067', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_17F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '200233', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_18F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, NULL, '2024-04-02 09:25:50.747', NULL, '2024-04-02 09:25:50.747', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_19F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:13:48.607', 9527, '2024-04-30 14:13:48.607', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_20F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:14:22.290', 9527, '2024-04-30 14:14:22.290', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_21F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:14:34.620', 9527, '2024-04-30 14:14:34.620', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_22F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:14:46.800', 9527, '2024-04-30 14:14:46.800', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_23F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:14:55.607', 9527, '2024-04-30 14:14:55.607', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_24F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:15:06.360', 9527, '2024-04-30 14:15:06.360', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_25F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:15:16.347', 9527, '2024-04-30 14:15:16.347', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_26F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:15:26.547', 9527, '2024-04-30 14:15:26.547', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_27F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:15:37.113', 9527, '2024-04-30 14:15:37.113', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_28F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:15:46.927', 9527, '2024-04-30 14:15:46.927', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_29F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:15:57.347', 9527, '2024-04-30 14:15:57.347', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_30F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:16:16.087', 9527, '2024-04-30 14:16:16.087', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_31F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:16:24.927', 9527, '2024-04-30 14:16:24.927', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_32F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:16:24.927', 9527, '2024-04-30 14:16:24.927', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_33F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:16:53.760', 9527, '2024-04-30 14:16:53.760', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_34F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '201184', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:17:03.257', 9527, '2024-04-30 14:17:03.257', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_35F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:17:12.570', 9527, '2024-04-30 14:17:12.570', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_36F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:17:23.407', 9527, '2024-04-30 14:17:23.407', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_37F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:17:32.363', 9527, '2024-04-30 14:17:32.363', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_38F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '201019', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:17:42.407', 9527, '2024-04-30 14:17:42.407', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_39F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '201198', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-04-30 14:17:53.823', 9527, '2024-04-30 14:17:53.823', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_40F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '201260', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-05-10 15:34:09.787', 9527, '2024-05-10 15:34:09.787', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_41F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '201090', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-05-10 15:34:19.993', 9527, '2024-05-10 15:34:19.993', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_42F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-05-10 15:34:37.323', 9527, '2024-05-10 15:34:37.323', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_43F2', NULL, NULL, 'Y', 'Y', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 9527, '2024-05-10 15:34:53.090', 9527, '2024-05-10 15:34:53.090', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_44F2', NULL, NULL, 'Y', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 26, '2024-05-31 15:33:09.330', 26, '2024-05-31 15:33:09.330', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_45F2', NULL, NULL, 'Y', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 26, '2024-05-31 15:35:47.123', 26, '2024-05-31 15:35:24.447', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_46F2', NULL, NULL, 'Y', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 26, '2024-05-31 15:36:54.717', 26, '2024-05-31 15:36:54.717', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_47F2', NULL, NULL, 'Y', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 26, '2024-05-31 15:37:29.737', 26, '2024-05-31 15:37:29.737', .000, .000, .000, .000, 0, NULL, NULL, NULL);
+INSERT INTO [dbo].[agv_bas_devp]([dev_no], [dec_desc], [dev_mk], [in_enable], [out_enable], [autoing], [loading], [canining], [canouting], [fronting], [rearing], [uping], [downing], [loc_sts], [cache_shelves], [wrk_no], [floor], [ctn_type], [barcode], [in_qty], [row1], [io_time], [area], [in_ok], [out_ok], [loc_type1], [loc_type2], [loc_type3], [modi_user], [modi_time], [appe_user], [appe_time], [std_qty], [min_wt], [max_wt], [gross_wt], [cart_pos], [qr_code_value], [loc_no], [station_code]) VALUES ('QO_48F2', NULL, NULL, 'Y', 'Y', 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'O', NULL, 0, 2, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 6, 60, NULL, 26, '2024-05-31 15:37:51.857', 26, '2024-05-31 15:37:51.857', .000, .000, .000, .000, 0, NULL, NULL, NULL);

--
Gitblit v1.9.1