库存明细统计显示是否贴标

pang.jiabao

2 天以前 2102c46adbd36c403fe026208f648411442874aa

库存明细统计显示是否贴标

 src/main/resources/mapper/LocDetlMapper.xml

@@ -406,13 +406,14 @@
            , a.volume
            ,manu_date manuDate
            ,batch
            ,brand
            , sum(a.anfme) as anfme
            ,sum(a.weight) weight
            ,sum(a.man_length) manLength
            from asr_loc_detl a
            where 1=1
            <include refid="stockOutCondition"></include>
            group by a.matnr,a.maktx,a.model,a.volume,manu_date,batch
            group by a.matnr,a.maktx,a.model,a.volume,manu_date,batch,brand
         ) t where t.row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize})
    </select>