#

zjj

2024-05-17 71221f63e1c7d930308baeb5fdf25a88028f2cdf

#

 src/main/resources/mapper/LocDetlMapper.xml

@@ -574,7 +574,7 @@

    </select>
    <select id="getStockStatisAll" resultType="com.zy.asrs.entity.result.LocDetlAll">
        select t.*,m.specs from
        select t.* from
        (
        select
        ROW_NUMBER() over (order by sum(a.anfme) desc) as row
@@ -587,7 +587,7 @@
        <include refid="stockOutCondition"></include>
        group by a.matnr,a.batch,a.owner,a.payment
        ) t
        LEFT JOIN man_mat m on t.matnr = m.matnr

        where t.row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize})
    </select>