#出入库统计计数

zjj

2025-02-20 b08837ad4e64348a27e21b2bb621352a523e2b7b

#出入库统计计数

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

@@ -157,6 +157,62 @@
        return R.ok(page);
    }

    @RequestMapping("/viewInOutList/count")
    public R getAllCount() {
        ViewInOutBean bean = new ViewInOutBean();
        bean.setPageSize(99999);
        bean.setPageNumber(1);
        List<ViewInOutBean> list = new ArrayList<>();
        Map<String, Double> map =  new HashMap<>();
        Double in = 0.0;
        Double out = 0.0;
        list = reportQueryMapper.queryViewInOutListDay(bean);
        for (ViewInOutBean bean1 : list) {
            in += bean1.getSto_qty().doubleValue();
            out += bean1.getRet_qty().doubleValue();
        }
        map.put("in", in);
        map.put("out", out);
        return R.ok(map);
    }

    /**
     * 获取库存总数
     * @return
     */
    @RequestMapping("/viewInOutList/date/count")
    public R getCount(@RequestBody Map<String, String> param){
        ViewInOutBean bean = new ViewInOutBean();
        bean.setPageSize(99999);
        bean.setPageNumber(1);
        if (!Cools.isEmpty(param.get("modi_time"))) {
            String[] dates = param.get("modi_time").toString().split(RANGE_TIME_LINK);
            bean.setBegin_date(dates[0]);
            bean.setEnd_date(dates[1]);
        }
        Map<String, Double> map =  new HashMap<>();
        Double in = 0.0;
        Double out = 0.0;
        List<ViewInOutBean> list = new ArrayList<>();
        if (param.get("type") == null || param.get("type").equals(1)) {
            list = reportQueryMapper.queryViewInOutListDay(bean);
        }else if ( param.get("type").equals("2")) {
            list = reportQueryMapper.queryViewInOutListMonth(bean);
        } else if (param.get("type").equals("3")) {
            list = reportQueryMapper.queryViewInOutListYear(bean);
        }else {
            list = reportQueryMapper.queryViewInOutListDay(bean);

        }
        for (ViewInOutBean bean1 : list) {
            in += bean1.getSto_qty().doubleValue();
            out += bean1.getRet_qty().doubleValue();
        }
        map.put("in", in);
        map.put("out", out);
        return R.ok(map);
    }

    //excel导出
    @RequestMapping("/viewInOutExport.action")
    @ManagerAuth(memo = "站点日入出库次数统计导出")

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

@@ -91,4 +91,6 @@
    Integer selectWorkCountInSum(String matnr, @Param("start") String startTime, @Param("end") String endTime);

    Integer selectWorkCountOutSum(String matnr, @Param("start") String startTime, @Param("end") String endTime);

    List<ViewInOutBean> selectAll();
}

 src/main/resources/mapper/ViewInOutMapper.xml

@@ -297,5 +297,9 @@
            and matnr = #{matnr}
        </if>
    </select>
    <select id="selectAll" resultType="com.zy.asrs.entity.ViewInOutBean">
        select * from asr_sta_inout_view a

    </select>

</mapper>

 src/main/webapp/static/js/report/inOut.js

@@ -46,6 +46,17 @@
            }
            pageCurr=curr;
            limit();

            $.ajax({
                url: baseUrl+"/report/viewInOutList/count",
                headers: {'token': localStorage.getItem('token')},
                contentType:'application/json;charset=UTF-8',
                method: 'POST',
                success: function (res) {
                    $("#countNumIn").text(res.data.in + '次');
                    $("#countNumOut").text(res.data.out + '次');
                }
            });
        }
    });

@@ -218,6 +229,21 @@
            limit(child);
        }
    });
    /**
     * 显示库存总数量
     */
    $.ajax({
        url: baseUrl+"/report/viewInOutList/date/count",
        headers: {'token': localStorage.getItem('token')},
        contentType:'application/json;charset=UTF-8',
        method: 'POST',
        data: JSON.stringify(searchData),
        success: function (res) {
            console.log(res);
            $("#countNumIn").text(res.data.in + '次');
            $("#countNumOut").text(res.data.out + '次');
        }
    });
}

function setFormVal(el, data, showImg) {

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

@@ -20,6 +20,22 @@
<!-- 搜索栏 -->
<div id="search-box" class="layui-form layui-card-header">
    <div class="layui-inline">
        <fieldset class="layui-elem-field">
            <legend>入库总计次数</legend>
            <div class="layui-field-box" id="countNumIn">
                请稍等
            </div>
        </fieldset>
    </div>
    <div class="layui-inline">
        <fieldset class="layui-elem-field">
            <legend>出库总计次数</legend>
            <div class="layui-field-box" id="countNumOut">
                请稍等
            </div>
        </fieldset>
    </div>
    <div class="layui-inline">
        <div class="layui-input-inline">
            <select name="type">
                <option value="1" selected>日</option>