From e0771f5cca8636156e2021bbc5db736cdeec79a6 Mon Sep 17 00:00:00 2001
From: LSH
Date: 星期六, 16 十二月 2023 10:52:50 +0800
Subject: [PATCH] #

---
 src/main/webapp/views/locDetlStatis/locDetlStatis.html |    3 +++
 src/main/resources/mapper/LocDetlMapper.xml            |   10 +++++++---
 src/main/webapp/static/js/manLocDetl/manLocDetl.js     |   13 +++++++------
 src/main/webapp/static/js/common.js                    |    1 +
 4 files changed, 18 insertions(+), 9 deletions(-)

diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml
index 71f512f..49d29d1 100644
--- a/src/main/resources/mapper/LocDetlMapper.xml
+++ b/src/main/resources/mapper/LocDetlMapper.xml
@@ -122,6 +122,9 @@
         <if test="crnNo!=null and crnNo!='' ">
             and b.crn_no=#{crnNo}
         </if>
+        <if test="owner!=null and owner!='' ">
+            and a.owner=#{owner}
+        </if>
     </sql>
 
     <select id="getStockOutPage" resultMap="BaseResultMap">
@@ -573,10 +576,11 @@
         ROW_NUMBER() over (order by sum(a.anfme) desc) as row
         , a.matnr
         , sum(a.anfme) as anfme
+        , a.owner
         from asr_loc_detl_all a
         where 1=1
         <include refid="stockOutCondition"></include>
-        group by a.matnr
+        group by a.matnr, a.owner
         ) t where t.row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize})
     </select>
 
@@ -584,11 +588,11 @@
         select count(1) as count from
         (
         select
-        a.matnr
+        a.matnr, a.owner
         from asr_loc_detl_all a
         where 1=1
         <include refid="stockOutCondition"></include>
-        group by a.matnr
+        group by a.matnr, a.owner
         ) b
     </select>
 
diff --git a/src/main/webapp/static/js/common.js b/src/main/webapp/static/js/common.js
index 4b5c5bc..71c5244 100644
--- a/src/main/webapp/static/js/common.js
+++ b/src/main/webapp/static/js/common.js
@@ -274,6 +274,7 @@
     ,{field: 'source$', align: 'center',title: '鍒惰喘', hide: true}
     ,{field: 'check$', align: 'center',title: '瑕佹眰妫�楠�', hide: true}
     ,{field: 'danger$', align: 'center',title: '鍗遍櫓鍝�', hide: true}
+    ,{field: 'owner$', align: 'center',title: '璐т富', hide: false}
 ]
 
 function getQueryVariable(variable)
diff --git a/src/main/webapp/static/js/manLocDetl/manLocDetl.js b/src/main/webapp/static/js/manLocDetl/manLocDetl.js
index 405073b..34f7a28 100644
--- a/src/main/webapp/static/js/manLocDetl/manLocDetl.js
+++ b/src/main/webapp/static/js/manLocDetl/manLocDetl.js
@@ -1,16 +1,16 @@
 var pageCurr;
 function getCol() {
     var cols = [
-        {field: 'locNo', align: 'center',title: '搴撲綅鍙�'},
+        {field: 'locNo', align: 'center',title: '搴撲綅鍙�', hide: false},
         {field: 'matnr', align: 'center',title: '鍟嗗搧缂栧彿', sort:true}
         ,{field: 'maktx', align: 'center',title: '鍟嗗搧鍚嶇О', sort:true}
         ,{field: 'orderNo', align: 'center',title: '鍗曟嵁缂栧彿', hide: true}
-        ,{field: 'specs', align: 'center',title: '瑙勬牸'}
+        ,{field: 'specs', align: 'center',title: '瑙勬牸', hide: false}
         ,{field: 'weight', align: 'center',title: '搴撲綅鎬婚噸閲�', hide: true}
 
-        ,{field: 'batch', align: 'center',title: '鎵瑰彿', sort:true}
-        ,{field: 'anfme', align: 'center',title: '鏁伴噺'}
-        ,{field: 'zpallet', align: 'center',title: '鎵樼洏鏉$爜'}
+        ,{field: 'batch', align: 'center',title: '鎵瑰彿', sort:true, hide: false}
+        ,{field: 'anfme', align: 'center',title: '閲嶉噺锛坘g锛�', sort:true, hide: false}
+        ,{field: 'zpallet', align: 'center',title: '鎵樼洏鏉$爜', sort:true, hide: true}
         ,{field: 'model', align: 'center',title: '浠g爜', hide: true}
         ,{field: 'color', align: 'center',title: '棰滆壊', hide: true}
         ,{field: 'brand', align: 'center',title: '鍝佺墝', hide: true}
@@ -35,7 +35,8 @@
         ,{field: 'source$', align: 'center',title: '鍒惰喘', hide: true}
         ,{field: 'check$', align: 'center',title: '瑕佹眰妫�楠�', hide: true}
         ,{field: 'danger$', align: 'center',title: '鍗遍櫓鍝�', hide: true}
-        ,{field: 'status$', align: 'center',title: '鏄庣粏閿�', hide: false}
+        ,{field: 'status$', align: 'center',title: '鏄庣粏閿�', hide: true}
+        ,{field: 'owner$', align: 'center',title: '璐т富', hide: false}
 
     ];
 
diff --git a/src/main/webapp/views/locDetlStatis/locDetlStatis.html b/src/main/webapp/views/locDetlStatis/locDetlStatis.html
index 22786eb..ee6f979 100644
--- a/src/main/webapp/views/locDetlStatis/locDetlStatis.html
+++ b/src/main/webapp/views/locDetlStatis/locDetlStatis.html
@@ -18,6 +18,9 @@
         <div class="layui-input-inline">
             <input class="layui-input" type="text" name="matnr" placeholder="鍟嗗搧缂栧彿" autocomplete="off">
         </div>
+        <div class="layui-input-inline">
+            <input class="layui-input" type="text" name="owner" placeholder="璐т富缂栧彿" autocomplete="off">
+        </div>
     </div>
     <!-- 寰呮坊鍔� -->
     <div id="data-search-btn" class="layui-btn-container layui-form-item" style="display: inline-block">

--
Gitblit v1.9.1