*

lsh

8 小时以前 2ce9436d64aaee5d9743e34f89e64f2207cc8583

*

 src/main/java/com/zy/asrs/entity/result/OrderPakoutDetailVo.java

@@ -8,6 +8,7 @@
@Data
public class OrderPakoutDetailVo {
    private Long id;
    private Long row;
    private String itemName;
    private String matnr;
    private String batch;

 src/main/java/com/zy/asrs/entity/result/OrderPakoutMainVo.java

@@ -8,6 +8,7 @@
@Data
public class OrderPakoutMainVo {
    private Long id;
    private Long row;
    private String itemName;
    private Integer orderCount;
    private String uuid;

 src/main/resources/mapper/OrderDetlPakoutMapper.xml

@@ -53,6 +53,7 @@
    <!-- 明细视图B的通用查询映射结果 -->
    <resultMap id="PakoutDetailResultMap" type="com.zy.asrs.entity.result.OrderPakoutDetailVo">
        <id column="id" property="id" jdbcType="BIGINT"/>
        <result column="row" property="row" jdbcType="BIGINT"/>
        <result column="item_name" property="itemName" jdbcType="VARCHAR"/>
        <result column="matnr" property="matnr" jdbcType="VARCHAR"/>
        <result column="batch" property="batch" jdbcType="VARCHAR"/>
@@ -261,6 +262,7 @@
        <if test="itemName != null and itemName != ''">
            AND item_name LIKE CONCAT('%', #{itemName}, '%')
        </if>
        AND row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize})
        ORDER BY create_time DESC
    </select>


 src/main/resources/mapper/OrderPakoutMapper.xml

@@ -44,7 +44,8 @@

    <!-- 主视图A的通用查询映射结果 -->
    <resultMap id="PakoutMainResultMap" type="com.zy.asrs.entity.result.OrderPakoutMainVo">
        <id column="id" property="id" jdbcType="BIGINT"/>
        <result column="id" property="id" jdbcType="BIGINT"/>
        <result column="row" property="row" jdbcType="BIGINT"/>
        <result column="item_name" property="itemName" jdbcType="VARCHAR"/>
        <result column="order_count" property="orderCount" jdbcType="INTEGER"/>
        <result column="uuid" property="uuid" jdbcType="VARCHAR"/>
@@ -158,6 +159,7 @@
        <if test="status != null and status != ''">
            AND status = #{status}
        </if>
        AND row between ((#{pageNumber}-1)*#{pageSize}+1) and (#{pageNumber}*#{pageSize})
        ORDER BY create_time DESC
    </select>