增加退货搜索框

pang.jiabao

2025-02-17 1a77bac582e942b91c03567772039a40fe63c78a

增加退货搜索框

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

@@ -20,7 +20,7 @@

//    @Select("select brand, matnr,workshop , sum(weight_anfme) as weight from asr_pla_detl GROUP BY brand,matnr,workshop ORDER BY matnr,workshop desc")
    List<Pla> getStockStatisAll(@Param("brand") String brand,@Param("status") String status,@Param("stime") Date stime, @Param("etime") Date etime,
                                @Param("type") String type,@Param("workshop") String workshop);
                                @Param("type") String type,@Param("workshop") String workshop,@Param("transfer") String transfer);


    Integer getStockStatisCountAll(Map<String, Object> map);

 src/main/resources/mapper/PlaMapper.xml

@@ -37,6 +37,9 @@
            <if test="workshop != null and workshop != ''">
                and workshop = #{workshop}
            </if>
            <if test="transfer != null and transfer != ''">
                and transfer = #{transfer}
            </if>
        </where>
        GROUP BY brand,matnr,workshop HAVING SUM(weight_anfme) > 0 ORDER BY matnr,workshop
    </select>

 src/main/webapp/static/js/pla/plaDetl.js

@@ -67,7 +67,9 @@
        // ,{field: 'pakoutTime', align: 'center',title: '出库时间', hide:true}
        // ,{field: 'orderWeight', align: 'center',title: '重量', hide:true}
        // ,{field: 'handlerBy', align: 'center',title: '经办人', hide:true}
        // ,{field: 'transfer', align: 'center',title: '流转形式', hide:true}
        ,{field: 'transfer', align: 'center',title: '退货标识', hide:true}
        ,{field: 'modifyUser', align: 'center',title: '退货人', hide:true}
        ,{field: 'createUser', align: 'center',title: '退货备注', hide:true}
        // ,{field: 'customer', align: 'center',title: '客户名称', hide:true}
        // ,{field: 'allocate', align: 'center',title: '调拨到', hide:true}
        // ,{field: 'memo', align: 'center',title: '备注', hide:true}

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

@@ -48,6 +48,14 @@
            <input class="layui-input" type="text" name="workshop" placeholder="车间" autocomplete="off">
        </div>
    </div>
    <div class="layui-inline">
        <div class="layui-input-inline">
            <select name="transfer">
                <option value="">是否退货</option>
                <option value="退货">是</option>
            </select>
        </div>
    </div>
    <div class="layui-inline" style="width: 300px">
        <div class="layui-input-inline">
            <input class="layui-input layui-laydate-range" name="create_time" type="text" placeholder="入库起始时间 - 终止时间" autocomplete="off" style="width: 300px">

 src/main/webapp/views/pla/plaDetl.html

@@ -312,7 +312,14 @@
                <input class="layui-input" type="text" name="stash" placeholder="仓库" autocomplete="off">
            </div>
        </div>

        <div class="layui-inline">
            <div class="layui-input-inline">
                <select name="transfer">
                    <option value="">是否退货</option>
                    <option value="退货">是</option>
                </select>
            </div>
        </div>
    </div>

</div>