#

whycq

2023-01-10 03210aeb31d8e9dfa3c1f9f065587d7208d80dd8

#

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

@@ -68,6 +68,21 @@
        ViewStayTimeBean bean = new ViewStayTimeBean();
        bean.setPageSize(limit);
        bean.setPageNumber(curr);
        String matnr = String.valueOf(param.get("matnr"));
        if (!Cools.isEmpty(matnr) && !matnr.equals("null")) {
            bean.setMatnr(matnr);
        }

        String maktx = String.valueOf(param.get("maktx"));
        if (!Cools.isEmpty(maktx) && !maktx.equals("null")) {
            bean.setMaktx(maktx);
        }

        String specs = String.valueOf(param.get("specs"));
        if (!Cools.isEmpty(specs) && !specs.equals("null")) {
            bean.setSpecs(specs);
        }

        String locNo = String.valueOf(param.get("loc_no"));
        if (!Cools.isEmpty(locNo) && !locNo.equals("null")) {
            bean.setLoc_no(locNo);

 src/main/resources/mapper/ViewStayTimeMapper.xml

@@ -8,6 +8,9 @@
        <if test="loc_no!=null and loc_no!='' ">
            and asr_loc_mast.loc_no like '%' + #{loc_no} + '%'
        </if>
        <if test="specs!=null and specs!='' ">
            and specs like '%' + #{specs} + '%'
        </if>
        <if test="matnr!=null and matnr!='' ">
            and matnr like '%' + #{matnr} + '%'
        </if>

 src/main/webapp/views/home/console.html

@@ -109,7 +109,7 @@
<div class="home-elem loc-retention">
    <div class="layui-form">
        <div id="form-header">库存滞留时间统计表</div>
        <div class="layui-card" style="padding: 0 20px 20px 20px;">
        <div class="layui-card" style="padding: 0 20px 1px 20px;">
            <fieldset class="layui-elem-field site-demo-button" style="margin: 20px;">
                <legend>搜索栏</legend>
                <div id="search-box" class="layui-form layui-card-header">
@@ -120,23 +120,13 @@
                    </div>
                    <div class="layui-inline">
                        <div class="layui-input-inline">
                            <input class="layui-input" type="text" name="maktx" placeholder="商品名称" autocomplete="off">
                        </div>
                    </div>
                    <!-- 日期范围 -->
                    <div class="layui-inline" style="width: 300px">
                        <div class="layui-input-inline">
                            <input class="layui-input layui-laydate-range" name="modi_time" type="text" placeholder="起始时间 - 终止时间" autocomplete="off" style="width: 300px">
                        </div>
                    </div>
                    <div class="layui-inline">
                        <div class="layui-input-inline">
                            <input class="layui-input" type="text" name="condition" placeholder="请输入" autocomplete="off">
                            <input class="layui-input" type="text" name="specs" placeholder="规格" autocomplete="off">
                        </div>
                    </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>
                    </div>
                </div>
            </fieldset>
@@ -291,6 +281,7 @@
        var table = layui.table;
        var $ = layui.jquery;
        var layer = layui.layer;
        var form = layui.form;

        // 数据渲染
        tableIns = table.render({
@@ -389,6 +380,28 @@
                }
            });
        });

        // 搜索栏搜索事件
        form.on('submit(search)', function (data) {
            tableReload();
        });
        // 搜索栏搜索事件
        form.on('submit(reset)', function (data) {
                $(':input', $('#search-box'))
                    .val('')
                    .removeAttr('checked')
                    .removeAttr('selected');
        });

        function tableReload() {
            var searchData = {};
            $.each($('#search-box [name]').serializeArray(), function() {
                searchData[this.name] = this.value;
            });
            tableIns.reload({
                where: searchData
            });
        }
    });