From ee4643ab09a85661532fd75ddb45a1b44e92f530 Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期二, 16 五月 2023 09:37:18 +0800
Subject: [PATCH] 库存调整支持修改客户信息和备注

---
 src/main/java/com/zy/asrs/mapper/LocDetlMapper.java            |    2 
 src/main/java/com/zy/asrs/service/LocDetlService.java          |    2 +
 src/main/java/com/zy/asrs/entity/param/LocDetlAdjustParam.java |   12 +++++-
 src/main/webapp/static/js/pakStore/stockAdjust.js              |    4 ++
 src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java    |   41 +++++++++++---------
 src/main/resources/mapper/LocDetlMapper.xml                    |    2 +
 src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java |   11 +++++
 src/main/java/com/zy/asrs/entity/AdjDetl.java                  |    9 ++++
 src/main/resources/application.yml                             |    4 +-
 9 files changed, 62 insertions(+), 25 deletions(-)

diff --git a/src/main/java/com/zy/asrs/entity/AdjDetl.java b/src/main/java/com/zy/asrs/entity/AdjDetl.java
index b9b0f9b..7300d18 100644
--- a/src/main/java/com/zy/asrs/entity/AdjDetl.java
+++ b/src/main/java/com/zy/asrs/entity/AdjDetl.java
@@ -125,9 +125,15 @@
     @TableField("appe_time")
     private Date appeTime;
 
+    /**
+     * 瀹㈡埛淇℃伅
+     */
+    @ApiModelProperty(value= "瀹㈡埛淇℃伅")
+    private String manu;
+
     public AdjDetl() {}
 
-    public AdjDetl(String locNo, String matnr, String batch, Double oriCtns, Double oriQty, Double oriWt, Double adjCtns, Double adjQty, Double adjWt, String memo, Long modiUser, Date modiTime, Long appeUser, Date appeTime) {
+    public AdjDetl(String locNo, String matnr, String batch, Double oriCtns, Double oriQty, Double oriWt, Double adjCtns, Double adjQty, Double adjWt, String memo, Long modiUser, Date modiTime, Long appeUser, Date appeTime, String manu) {
         this.locNo = locNo;
         this.matnr = matnr;
         this.batch = batch;
@@ -142,6 +148,7 @@
         this.modiTime = modiTime;
         this.appeUser = appeUser;
         this.appeTime = appeTime;
+        this.manu = manu;
     }
 
     //    AdjDetl adjDetl = new AdjDetl(
diff --git a/src/main/java/com/zy/asrs/entity/param/LocDetlAdjustParam.java b/src/main/java/com/zy/asrs/entity/param/LocDetlAdjustParam.java
index 381d7c2..d0a09c9 100644
--- a/src/main/java/com/zy/asrs/entity/param/LocDetlAdjustParam.java
+++ b/src/main/java/com/zy/asrs/entity/param/LocDetlAdjustParam.java
@@ -30,10 +30,18 @@
         // 鍙樻洿鏁伴噺
         private Double count;
 
-        public LocDetlAdjust(String matnr, String batch, Double count) {
+        //瀹㈡埛淇℃伅
+        private String manu;
+
+        //澶囨敞
+        private String memo;
+
+        public LocDetlAdjust(String matnr, String batch, Double count, String manu, String memo) {
             this.matnr = matnr;
             this.batch = batch;
             this.count = count;
+            this.manu = manu;
+            this.memo = memo;
         }
     }
 
@@ -52,7 +60,7 @@
                 }
             }
             if (!exit) {
-                copyList.add(new LocDetlAdjustParam.LocDetlAdjust(adjust.getMatnr(), adjust.getBatch(), adjust.getCount()));
+                copyList.add(new LocDetlAdjustParam.LocDetlAdjust(adjust.getMatnr(), adjust.getBatch(), adjust.getCount(), adjust.getManu(), adjust.getMemo()));
             }
         }
         list = copyList;
diff --git a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
index 8b0f93a..03701da 100644
--- a/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/LocDetlMapper.java
@@ -21,7 +21,7 @@
 
     int deleteItem(@Param("locNo")String locNo, @Param("matnr")String matnr, @Param("batch")String batch);
 
-    int updateAnfme(@Param("anfme")Double anfme, @Param("locNo")String locNo, @Param("matnr")String matnr, @Param("batch")String batch);
+    int updateAnfme(@Param("anfme") Double anfme, @Param("locNo") String locNo, @Param("matnr") String matnr, @Param("batch") String batch, @Param("manu") String manu, @Param("memo") String memo);
 
     List<LocDetl> getStockOutPage(Map<String, Object> map);
 
diff --git a/src/main/java/com/zy/asrs/service/LocDetlService.java b/src/main/java/com/zy/asrs/service/LocDetlService.java
index 3e8d5ef..6cfe1d4 100644
--- a/src/main/java/com/zy/asrs/service/LocDetlService.java
+++ b/src/main/java/com/zy/asrs/service/LocDetlService.java
@@ -20,6 +20,8 @@
      */
     boolean updateAnfme(Double anfme, String locNo, String matnr, String batch);
 
+    boolean updateAnfme(Double anfme, String locNo, String matnr, String batch, String manu, String memo);
+
     boolean updateLocNo(String newLocNo, String oldLocNo);
 
     /**
diff --git a/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java
index 64b512f..e7cece3 100644
--- a/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java
@@ -29,7 +29,16 @@
         if (anfme <= 0) {
             return this.baseMapper.deleteItem(locNo, matnr, batch) > 0;
         } else {
-            return baseMapper.updateAnfme(anfme, locNo, matnr, batch) > 0;
+            return baseMapper.updateAnfme(anfme, locNo, matnr, batch, null, null) > 0;
+        }
+    }
+
+    @Override
+    public boolean updateAnfme(Double anfme, String locNo, String matnr, String batch, String manu, String memo) {
+        if (anfme <= 0) {
+            return this.baseMapper.deleteItem(locNo, matnr, batch) > 0;
+        } else {
+            return baseMapper.updateAnfme(anfme, locNo, matnr, batch, manu, memo) > 0;
         }
     }
 
diff --git a/src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java
index 650eb6a..6e070ad 100644
--- a/src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java
@@ -775,25 +775,26 @@
                     continue;
                 }
                 if (locDetl.getMatnr().equals(adjust.getMatnr()) && Cools.eq(locDetl.getBatch(), adjust.getBatch())) {
-                    if (!locDetl.getAnfme().equals(adjust.getCount())) {
-                        // todo 鐩樼偣璁板綍
-                        // 淇敼搴撳瓨
-                        if (!locDetlService.updateAnfme(adjust.getCount(), locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getBatch())) {
-                            throw new CoolException(locDetl.getLocNo() + "搴撲綅锛�" + locDetl.getMatnr() + "鍟嗗搧锛�" + locDetl.getBatch() + "搴忓垪鐮佷慨鏀规暟閲忓け璐�");
-                        }
-                        // 淇濆瓨璋冩暣璁板綍
-                        AdjDetl adjDetl = new AdjDetl();
-                        adjDetl.setLocNo(locDetl.getLocNo());
-                        adjDetl.setMatnr(locDetl.getMatnr());
-                        adjDetl.setBatch(locDetl.getBatch());
-                        adjDetl.setOriQty(locDetl.getAnfme());
-                        adjDetl.setAdjQty(adjust.getCount());
-                        adjDetl.setModiTime(now);
-                        adjDetl.setModiUser(userId);
-                        adjDetl.setAppeTime(now);
-                        adjDetl.setAppeUser(userId);
-                        adjDetlService.save(adjDetl, userId);
+                    // todo 鐩樼偣璁板綍
+                    // 淇敼搴撳瓨
+                    if (!locDetlService.updateAnfme(adjust.getCount(), locDetl.getLocNo(), locDetl.getMatnr(), locDetl.getBatch(), adjust.getManu(), adjust.getMemo())) {
+                        throw new CoolException(locDetl.getLocNo() + "搴撲綅锛�" + locDetl.getMatnr() + "鍟嗗搧锛�" + locDetl.getBatch() + "搴忓垪鐮佷慨鏀规暟閲忓け璐�");
                     }
+                    // 淇濆瓨璋冩暣璁板綍
+                    AdjDetl adjDetl = new AdjDetl();
+                    adjDetl.setLocNo(locDetl.getLocNo());
+                    adjDetl.setMatnr(locDetl.getMatnr());
+                    adjDetl.setBatch(locDetl.getBatch());
+                    adjDetl.setOriQty(locDetl.getAnfme());
+                    adjDetl.setAdjQty(adjust.getCount());
+                    adjDetl.setMemo(adjust.getMemo());
+                    adjDetl.setManu(adjust.getManu());
+                    adjDetl.setModiTime(now);
+                    adjDetl.setModiUser(userId);
+                    adjDetl.setAppeTime(now);
+                    adjDetl.setAppeUser(userId);
+                    adjDetlService.save(adjDetl, userId);
+
                     iterator.remove();
                     iterator1.remove();
                 }
@@ -831,6 +832,8 @@
             locDetl.setBatch(adjust.getBatch());
             locDetl.setLocNo(locMast.getLocNo());
             locDetl.setAnfme(adjust.getCount()); // 鏁伴噺
+            locDetl.setMemo(adjust.getMemo());
+            locDetl.setManu(adjust.getManu());
             locDetl.setModiUser(userId); // 鎿嶄綔浜哄憳淇℃伅
             locDetl.setModiTime(now);
             locDetl.setAppeUser(userId);
@@ -843,6 +846,8 @@
             adjDetl.setLocNo(locMast.getLocNo());
             adjDetl.setMatnr(adjust.getMatnr());
             adjDetl.setBatch(adjust.getBatch());
+            adjDetl.setMemo(adjust.getMemo());
+            adjDetl.setManu(adjust.getManu());
             adjDetl.setOriQty(0.0D);
             adjDetl.setAdjQty(adjust.getCount());
             adjDetl.setModiTime(now);
diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
index e759cba..b83d0c7 100644
--- a/src/main/resources/application.yml
+++ b/src/main/resources/application.yml
@@ -10,8 +10,8 @@
     enabled: false
   datasource:
     driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
-    url: jdbc:sqlserver://10.10.10.100:1433;databasename=bfasrs
-#    url: jdbc:sqlserver://192.168.4.15:1433;databasename=bfasrs
+#    url: jdbc:sqlserver://10.10.10.100:1433;databasename=bfasrs
+    url: jdbc:sqlserver://192.168.4.13:1433;databasename=bfasrs
     username: sa
 #    password: Zoneyung@zy56$
     password: sa@123
diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index 587b7ff..e88f471 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -78,6 +78,8 @@
         update asr_loc_detl
         set anfme = #{anfme}
         , modi_time = getdate()
+        , manu = #{manu}
+        , memo = #{memo}
         where 1=1
         and loc_no = #{locNo}
         and matnr = #{matnr}
diff --git a/src/main/webapp/static/js/pakStore/stockAdjust.js b/src/main/webapp/static/js/pakStore/stockAdjust.js
index 52d8db1..62dc502 100644
--- a/src/main/webapp/static/js/pakStore/stockAdjust.js
+++ b/src/main/webapp/static/js/pakStore/stockAdjust.js
@@ -11,6 +11,10 @@
     ];
     arrRemove(detlCols, "field", "anfme");
     arrRemove(detlCols, "field", "batch");
+    arrRemove(detlCols, "field", "manu");
+    arrRemove(detlCols, "field", "memo");
+    detlCols.push({field: 'manu', align: 'center', title: '瀹㈡埛淇℃伅', edit: 'text', hide: false});
+    detlCols.push({field: 'memo', align: 'center',title: '澶囨敞', edit: 'text' ,hide: false})
     cols.push.apply(cols, detlCols);
     cols.push({fixed: 'right', title:'鎿嶄綔', align: 'center', toolbar: '#operate', width:80})
     return cols;

--
Gitblit v1.9.1