Changes

mrzhssss

2022-05-19 ed1bbbc669763da0840be52c15773345f804dba8

Changes

 src/main/java/com/zy/asrs/controller/LocDetlController.java

@@ -227,4 +227,14 @@
                .doWrite(excel);
    }

    /**
     * 获取库存总数
     * @return
     */
    @RequestMapping("/locDetl/count")
    public R getAllCount(){
        Integer sum = locDetlService.sum();
        return R.ok(sum);
    }

}

 src/main/java/com/zy/asrs/mapper/LocDetlMapper.java

@@ -56,4 +56,6 @@

    List<StockVo> queryStockTotal();


    Integer sum();
}

 src/main/java/com/zy/asrs/service/LocDetlService.java

@@ -46,4 +46,6 @@

    List<StockVo> queryStockTotal();


    Integer sum();
}

 src/main/java/com/zy/asrs/service/impl/LocDetlServiceImpl.java

@@ -83,6 +83,17 @@
        return this.baseMapper.queryStockTotal();
    }

    /**
     * 获取库存总数
     * @return
     */
    @Override
    public Integer sum() {

        return this.baseMapper.sum();
    }


    @Override
    public LocDetl selectItem(String locNo, String matnr, String batch) {
        return this.baseMapper.selectItem(locNo, matnr, batch);

 src/main/resources/mapper/LocDetlMapper.xml

@@ -297,5 +297,9 @@
        where 1=1
        group by matnr,batch
    </select>
    <select id="sum" resultType="java.lang.Integer">
        SELECT SUM(anfme) FROM asr_loc_detl
    </select>


</mapper>

 src/main/webapp/static/js/locDetl/locDetl.js

@@ -21,8 +21,8 @@
        headers: {token: localStorage.getItem('token')},
        url: baseUrl+'/locDetl/list/auth',
        page: true,
        limit: 16,
        limits: [16, 30, 50, 100, 200, 500],
        limit: 20,
        limits: [20, 30, 50, 100, 200, 500],
        even: true,
        toolbar: '#toolbar',
        cellMinWidth: 50,

 src/main/webapp/static/js/locDetlStatis/locDetlStatis.js

@@ -24,8 +24,8 @@
        headers: {token: localStorage.getItem('token')},
        url: baseUrl+'/locDetl/statis/auth',
        page: true,
        limit: 16,
        limits: [16, 30, 50, 100, 200, 500],
        limit: 20,
        limits: [20, 30, 50, 100, 200, 500],
        even: true,
        toolbar: '#toolbar',
        cellMinWidth: 50,
@@ -59,6 +59,19 @@
                    res.data[_index][data.value] = 'N';
                }
            });
            /**
             * 显示库存总数量
             */
            $.ajax({
                url: baseUrl+"/locDetl/count",
                headers: {'token': localStorage.getItem('token')},
                contentType:'application/json;charset=UTF-8',
                method: 'POST',
                success: function (res) {
                    $("#countNum").text(res.data + '个');
                }
            });

        }
    });


 src/main/webapp/static/js/stoMan/stoQue.js

@@ -19,8 +19,8 @@
        headers: {token: localStorage.getItem('token')},
        url: baseUrl+'/locMast/list/auth',
        page: true,
        limit: 16,
        limits: [16, 30, 50, 100, 200, 500],
        limit: 20,
        limits: [20, 30, 50, 100, 200, 500],
        even: true,
        toolbar: '#toolbar',
        cellMinWidth: 50,

 src/main/webapp/views/locDetl/locDetl.html

@@ -21,9 +21,15 @@
    </div>
    <div class="layui-inline">
        <div class="layui-input-inline">
            <input class="layui-input" type="text" name="zpallet" placeholder="托盘码" autocomplete="off">
        </div>
    </div>
    <div class="layui-inline">
        <div class="layui-input-inline">
            <input class="layui-input" type="text" name="matnr" placeholder="商品编号" autocomplete="off">
        </div>
    </div>

    <div class="layui-inline">
        <div class="layui-input-inline">
            <input class="layui-input" type="text" name="condition" placeholder="请输入" autocomplete="off">

 src/main/webapp/views/locDetlStatis/locDetlStatis.html

@@ -21,8 +21,18 @@
    </div>
    <!-- 待添加 -->
    <div id="data-search-btn" class="layui-btn-container layui-form-item" style="display: inline-block">
        <button id="search" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="search">搜索</button>
        <button id="reset" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="reset">重置</button>
        <button id="search" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="search">搜索
        </button>
        <button id="reset" class="layui-btn layui-btn-primary layui-btn-radius" lay-submit lay-filter="reset">重置
        </button>
    </div>
    <div class="layui-inline">
        <fieldset class="layui-elem-field">
            <legend>总计数量</legend>
            <div class="layui-field-box" id="countNum">
                请稍等
            </div>
        </fieldset>
    </div>
</div>

@@ -31,7 +41,8 @@
    <table class="layui-hide" id="locDetlStatis" lay-filter="locDetlStatis"></table>
</div>
<script type="text/html" id="toolbar">
    <div class="layui-btn-container">

    <div class="layui-btn-container layui-col-md1">
        <button class="layui-btn" lay-event="exportAll" style="margin-top: -0px">导出全部</button>
    </div>
</script>

 src/main/webapp/views/report/locDetl.html

@@ -51,7 +51,7 @@
            headers: {token: localStorage.getItem('token')},
            url: baseUrl+'/locDetl/list/auth',
            page: true,
            limit: 10,
            limit: 20,
            skin: 'line',
            where: {loc_no: parent.locNo},
            even: true,

 src/main/webapp/views/stoMan/stoQue.html

@@ -32,6 +32,11 @@
            <input class="layui-input" type="text" name="loc_no" placeholder="库位号" autocomplete="off">
        </div>
    </div>
    <div class="layui-inline">
        <div class="layui-input-inline">
            <input class="layui-input" type="text" name="barcode" placeholder="托盘码" autocomplete="off">
        </div>
    </div>
    <!-- 日期范围 -->
    <div class="layui-inline" style="width: 300px">
        <div class="layui-input-inline">