#

18516761980

2021-09-03 d9ede471f578455480764e88888436c0e58ce474

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

@@ -38,4 +38,11 @@
    Integer getStockStatisCount(Map<String, Object> condition);

    List<LocDetl> getStockStatisExcel();

    /**
     * 库存上报ERP时，根据物料汇总查询库存总量
     * @return
     */
    @Select("select mat_no,mat_name,sum(qty) qty from asr_loc_detl group by mat_no,mat_name")
    List<LocDetl> getStockSum();
}