#

18516761980

2021-09-09 77897585d6d29a7018e9510db8dbe07f2db3330b

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

@@ -31,4 +31,18 @@
    List<LocDetl> selectLocDetlList(@Param("mat_no") String matNo);

    Double selectLocDetlSumQty(String locNo);


    List<LocDetl> getStockStatis(Map<String, Object> condition);

    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();
}