#

Junjie

2023-10-15 db92e88a70a59437b48c9369cf1c46dba0ecb0a5

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

@@ -24,8 +24,11 @@
            "\t\tROW_NUMBER() over (order by sum(a.anfme) desc) as row\n" +
            "\t\t, a.matnr\n" +
            "\t\t, sum(a.anfme) as anfme\n" +
            "\t\tfrom agv_loc_detl a\n" +
            "\t\twhere 1=1\n" +
//            "\t\tfrom agv_loc_detl a\n" +
//            "\t\twhere 1=1\n" +
//            "\t\t<when #{matnr} != '>" +
//            "\t\tAND matnr = #{matnr}" +
            "\t\t</when>" +
            "\t\tgroup by a.matnr\n" +
            " ) t where t.row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize})")
    List<AgvLocDetl> getStockStatis(Map<String, Object> map);