#明细统计总计修改可查看当前查询物料总计

zjj

2024-12-20 56678dd52e0e25afa36612f1be4a1d3ef0f4a82c

#明细统计总计修改可查看当前查询物料总计

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

@@ -299,7 +299,24 @@
     */
    @RequestMapping("/locDetl/count")
    public R getAllCount(){
        Integer sum = locDetlService.sum();
        Double sum = locDetlService.sum();
        return R.ok(sum);
    }

    /**
     * 获取库存总数
     * @return
     */
    @RequestMapping("/locDetl/matnr/count")
    public R getCount(@RequestBody Map<String, String> param){
        String matnr = param.get("matnr");
        Double sum = 0.0;
        if (Cools.isEmpty(matnr)){
            sum = locDetlService.sum();
        }else {
            sum = locDetlService.getSumAnfme(matnr);
        }

        return R.ok(sum);
    }


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

@@ -66,7 +66,7 @@
    List<StockVo> queryStockTotal();


    Integer sum();
    Double sum();

    List<LocDetl> unreason();


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

@@ -61,7 +61,7 @@
    List<StockVo> queryStockTotal();


    Integer sum();
    Double sum();

    List<LocDetl> unreason();


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

@@ -114,11 +114,11 @@

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

    public Double sum() {
        return this.baseMapper.sum();
    }


 src/main/resources/mapper/LocDetlMapper.xml

@@ -314,7 +314,7 @@
        where 1=1
        group by matnr,batch
    </select>
    <select id="sum" resultType="java.lang.Integer">
    <select id="sum" resultType="java.lang.Double">
        SELECT SUM(anfme) FROM asr_loc_detl
    </select>
    <select id="unreason" resultMap="BaseResultMap">

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

@@ -235,6 +235,19 @@
            limit(child);
        }
    });
    /**
     * 显示库存总数量
     */
    $.ajax({
        url: baseUrl+"/locDetl/matnr/count",
        headers: {'token': localStorage.getItem('token')},
        contentType:'application/json;charset=UTF-8',
        method: 'POST',
        data: JSON.stringify(searchData),
        success: function (res) {
            $("#countNum").text(res.data + '个');
        }
    });
}

function detailScreen(index) {