From 2c1720ea4614c4d18b6eb9f0f27c7250dc450bf8 Mon Sep 17 00:00:00 2001 From: zjj <3272660260@qq.com> Date: 星期二, 12 三月 2024 10:45:44 +0800 Subject: [PATCH] #库存统计 --- src/main/webapp/static/js/locDetl/locDetl.js | 4 ++-- src/main/webapp/static/js/locDetlStatis/locDetlStatis.js | 1 - src/main/resources/mapper/LocDetlMapper.xml | 7 ++++--- src/main/webapp/static/js/common.js | 2 +- 4 files changed, 7 insertions(+), 7 deletions(-) diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml index fa37930..3704d4e 100644 --- a/src/main/resources/mapper/LocDetlMapper.xml +++ b/src/main/resources/mapper/LocDetlMapper.xml @@ -574,14 +574,14 @@ ( select ROW_NUMBER() over (order by sum(a.anfme) desc) as row - , a.matnr + , a.matnr,a.batch , sum(a.anfme) as anfme ,owner ,payment from asr_loc_detl_all a where 1=1 <include refid="stockOutCondition"></include> - group by a.matnr,a.owner,a.payment + group by a.matnr,a.batch,a.owner,a.payment ) t LEFT JOIN man_mat m on t.matnr = m.matnr where t.row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize}) @@ -592,12 +592,13 @@ ( select a.matnr + ,a.batch ,owner ,payment from asr_loc_detl_all a where 1=1 <include refid="stockOutCondition"></include> - group by a.matnr,a.owner,a.payment + group by a.matnr,a.batch,a.owner,a.payment ) b </select> diff --git a/src/main/webapp/static/js/common.js b/src/main/webapp/static/js/common.js index 01cbe00..ca698e8 100644 --- a/src/main/webapp/static/js/common.js +++ b/src/main/webapp/static/js/common.js @@ -244,7 +244,7 @@ ,{field: 'batch', align: 'center',title: '鎵瑰彿', sort:true} ,{field: 'anfme', align: 'center',title: '鏁伴噺(浠�)',hide: false} ,{field: 'zpallet', align: 'center',title: '鎵樼洏鏉$爜',hide: false} - ,{field: 'specs', align: 'center',title: '瑙勬牸',hide: true} + ,{field: 'specs', align: 'center',title: '瑙勬牸',hide: false} ,{field: 'model', align: 'center',title: '浠g爜', hide: false} ,{field: 'color', align: 'center',title: '棰滆壊', hide: true} ,{field: 'brand', align: 'center',title: '鍝佺墝', hide: true} diff --git a/src/main/webapp/static/js/locDetl/locDetl.js b/src/main/webapp/static/js/locDetl/locDetl.js index dcc1056..7355982 100644 --- a/src/main/webapp/static/js/locDetl/locDetl.js +++ b/src/main/webapp/static/js/locDetl/locDetl.js @@ -4,11 +4,11 @@ {field: 'locNo$', align: 'center',title: '搴撲綅鍙�'}, {field: 'matnr', align: 'center',title: '鍟嗗搧缂栧彿', sort:true} ,{field: 'maktx', align: 'center',title: '鍟嗗搧鍚嶇О', sort:true} + ,{field: 'specs', align: 'center',title: '瑙勬牸',hide: false} ,{field: 'orderNo', align: 'center',title: '鍗曟嵁缂栧彿', hide: false} - ,{field: 'batch', align: 'center',title: '鎵瑰彿', width: 200, sort:true} + ,{field: 'batch', align: 'center',title: '鎵规', sort:true} ,{field: 'anfme', align: 'center',title: '鏁伴噺'} ,{field: 'zpallet', align: 'center',title: '鎵樼洏鏉$爜'} - ,{field: 'specs', align: 'center',title: '閰嶇疆',hide: true} ,{field: 'model', align: 'center',title: '浠g爜', hide: true} ,{field: 'color', align: 'center',title: '棰滆壊', hide: true} ,{field: 'brand', align: 'center',title: '鍝佺墝', hide: true} diff --git a/src/main/webapp/static/js/locDetlStatis/locDetlStatis.js b/src/main/webapp/static/js/locDetlStatis/locDetlStatis.js index 1cc77fc..a259837 100644 --- a/src/main/webapp/static/js/locDetlStatis/locDetlStatis.js +++ b/src/main/webapp/static/js/locDetlStatis/locDetlStatis.js @@ -5,7 +5,6 @@ ]; arrRemove(detlCols, "field", "anfme") arrRemove(detlCols, "field", "zpallet") - arrRemove(detlCols, "field", "batch") arrRemove(detlCols, "field", "model") arrRemove(detlCols, "field", "weight") cols.push.apply(cols, detlCols); -- Gitblit v1.9.1