From 98bcd061526cad604a83241cc94994e1e225982a Mon Sep 17 00:00:00 2001 From: pang.jiabao <pang_jiabao@163.com> Date: 星期一, 10 二月 2025 09:21:03 +0800 Subject: [PATCH] 库存明细统计增加车间,树脂类型搜索框,默认统计库存状态为(已入库+部分出库+待出库),库存重量为0不显示记录 --- src/main/java/com/zy/asrs/mapper/PlaMapper.java | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/PlaMapper.java b/src/main/java/com/zy/asrs/mapper/PlaMapper.java index 7c03a65..04c1a1f 100644 --- a/src/main/java/com/zy/asrs/mapper/PlaMapper.java +++ b/src/main/java/com/zy/asrs/mapper/PlaMapper.java @@ -19,7 +19,8 @@ List<Pla> getStockStatisAllByBrand(@Param("brand") String brand); // @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); + 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); Integer getStockStatisCountAll(Map<String, Object> map); -- Gitblit v1.9.1