From 900b7c3e7c0d887574a2fc62973749d6b479f95b Mon Sep 17 00:00:00 2001 From: lsh <lsh@163.com> Date: 星期二, 17 十二月 2024 14:59:21 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/entity/WrkDetlLog.java | 18 +++ src/main/java/com/zy/asrs/entity/OrderDetlPakout.java | 18 +++ src/main/resources/mapper/WrkDetlLogMapper.xml | 3 src/main/java/com/zy/asrs/entity/OrderDetl.java | 21 +++ src/main/resources/mapper/WaitPakinMapper.xml | 3 src/main/resources/mapper/LocDetlMapper.xml | 3 src/main/resources/mapper/WaitPakinLogMapper.xml | 3 src/main/java/com/zy/asrs/entity/OrderDetlPakin.java | 18 +++ src/main/resources/mapper/OrderDetlPakinMapper.xml | 61 +++------- src/main/resources/mapper/OrderDetlMapper.xml | 61 +++------- src/main/resources/mapper/WrkDetlMapper.xml | 3 src/main/java/com/zy/asrs/entity/WaitPakinLog.java | 18 +++ src/main/java/com/zy/asrs/entity/WaitPakin.java | 18 +++ src/main/java/com/zy/asrs/entity/LocDetl.java | 18 +++ src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java | 10 src/main/java/com/zy/asrs/entity/WrkDetl.java | 18 +++ src/main/resources/mapper/OrderDetlPakoutMapper.xml | 61 +++------- src/main/java/com/zy/common/service/CommonService.java | 1 18 files changed, 222 insertions(+), 134 deletions(-) diff --git a/src/main/java/com/zy/asrs/entity/LocDetl.java b/src/main/java/com/zy/asrs/entity/LocDetl.java index 8d649da..da9a941 100644 --- a/src/main/java/com/zy/asrs/entity/LocDetl.java +++ b/src/main/java/com/zy/asrs/entity/LocDetl.java @@ -165,6 +165,24 @@ @ApiModelProperty(value= "鎷ユ湁鑰� 1: 鏉板厠 ") private Integer owner; + /** + * 澶囩敤1 + */ + @ApiModelProperty(value= "澶囩敤1") + private Integer standby1; + + /** + * 澶囩敤2 + */ + @ApiModelProperty(value= "澶囩敤2") + private Integer standby2; + + /** + * 澶囩敤3 + */ + @ApiModelProperty(value= "澶囩敤3") + private Integer standby3; + public String getLocNo$(){ LocMastService service = SpringUtils.getBean(LocMastService.class); LocMast locMast = service.selectById(this.locNo); diff --git a/src/main/java/com/zy/asrs/entity/OrderDetl.java b/src/main/java/com/zy/asrs/entity/OrderDetl.java index 04bbfec..2fa2301 100644 --- a/src/main/java/com/zy/asrs/entity/OrderDetl.java +++ b/src/main/java/com/zy/asrs/entity/OrderDetl.java @@ -310,6 +310,24 @@ @TableField("line_number") private Integer lineNumber; + /** + * 澶囩敤1 + */ + @ApiModelProperty(value= "澶囩敤1") + private Integer standby1; + + /** + * 澶囩敤2 + */ + @ApiModelProperty(value= "澶囩敤2") + private Integer standby2; + + /** + * 澶囩敤3 + */ + @ApiModelProperty(value= "澶囩敤3") + private Integer standby3; + public OrderDetl() {} public OrderDetl(Long orderId, String orderNo, Double anfme, Double qty, String matnr, String maktx, String batch, String specs, String model, String color, String brand, String unit, Double price, String sku, Double units, String barcode, String origin, String manu, String manuDate, String itemNum, Double safeQty, Double weight, Double manLength, Double volume, String threeCode, String supp, String suppCode, Integer beBatch, String deadTime, Integer deadWarn, Integer source, Integer inspect, Integer danger, Integer status, Long createBy, Date createTime, Long updateBy, Date updateTime, String memo) { @@ -396,6 +414,9 @@ this.memo = orderDetl.getMemo(); this.pakinPakoutStatus = orderDetl.getPakinPakoutStatus(); this.lineNumber = orderDetl.getLineNumber(); + this.standby1 = orderDetl.getStandby1(); + this.standby2 = orderDetl.getStandby2(); + this.standby3 = orderDetl.getStandby3(); } diff --git a/src/main/java/com/zy/asrs/entity/OrderDetlPakin.java b/src/main/java/com/zy/asrs/entity/OrderDetlPakin.java index 2a176ff..ee91692 100644 --- a/src/main/java/com/zy/asrs/entity/OrderDetlPakin.java +++ b/src/main/java/com/zy/asrs/entity/OrderDetlPakin.java @@ -310,6 +310,24 @@ @TableField("line_number") private Integer lineNumber; + /** + * 澶囩敤1 + */ + @ApiModelProperty(value= "澶囩敤1") + private Integer standby1; + + /** + * 澶囩敤2 + */ + @ApiModelProperty(value= "澶囩敤2") + private Integer standby2; + + /** + * 澶囩敤3 + */ + @ApiModelProperty(value= "澶囩敤3") + private Integer standby3; + public OrderDetlPakin() {} public OrderDetlPakin(Long orderId, String orderNo, Double anfme, Double qty, String matnr, String maktx, String batch, String specs, String model, String color, String brand, String unit, Double price, String sku, Double units, String barcode, String origin, String manu, String manuDate, String itemNum, Double safeQty, Double weight, Double manLength, Double volume, String threeCode, String supp, String suppCode, Integer beBatch, String deadTime, Integer deadWarn, Integer source, Integer inspect, Integer danger, Integer status, Long createBy, Date createTime, Long updateBy, Date updateTime, String memo) { diff --git a/src/main/java/com/zy/asrs/entity/OrderDetlPakout.java b/src/main/java/com/zy/asrs/entity/OrderDetlPakout.java index 6fd912a..c91c3ab 100644 --- a/src/main/java/com/zy/asrs/entity/OrderDetlPakout.java +++ b/src/main/java/com/zy/asrs/entity/OrderDetlPakout.java @@ -310,6 +310,24 @@ @TableField("line_number") private Integer lineNumber; + /** + * 澶囩敤1 + */ + @ApiModelProperty(value= "澶囩敤1") + private Integer standby1; + + /** + * 澶囩敤2 + */ + @ApiModelProperty(value= "澶囩敤2") + private Integer standby2; + + /** + * 澶囩敤3 + */ + @ApiModelProperty(value= "澶囩敤3") + private Integer standby3; + public OrderDetlPakout() {} public OrderDetlPakout(Long orderId, String orderNo, Double anfme, Double qty, String matnr, String maktx, String batch, String specs, String model, String color, String brand, String unit, Double price, String sku, Double units, String barcode, String origin, String manu, String manuDate, String itemNum, Double safeQty, Double weight, Double manLength, Double volume, String threeCode, String supp, String suppCode, Integer beBatch, String deadTime, Integer deadWarn, Integer source, Integer inspect, Integer danger, Integer status, Long createBy, Date createTime, Long updateBy, Date updateTime, String memo) { diff --git a/src/main/java/com/zy/asrs/entity/WaitPakin.java b/src/main/java/com/zy/asrs/entity/WaitPakin.java index 84d4c5e..ebe00f9 100644 --- a/src/main/java/com/zy/asrs/entity/WaitPakin.java +++ b/src/main/java/com/zy/asrs/entity/WaitPakin.java @@ -152,6 +152,24 @@ @ApiModelProperty(value= "澶囨敞") private String memo; + /** + * 澶囩敤1 + */ + @ApiModelProperty(value= "澶囩敤1") + private Integer standby1; + + /** + * 澶囩敤2 + */ + @ApiModelProperty(value= "澶囩敤2") + private Integer standby2; + + /** + * 澶囩敤3 + */ + @ApiModelProperty(value= "澶囩敤3") + private Integer standby3; + public String getBeBatch$(){ if (null == this.beBatch){ return null; } switch (this.beBatch){ diff --git a/src/main/java/com/zy/asrs/entity/WaitPakinLog.java b/src/main/java/com/zy/asrs/entity/WaitPakinLog.java index 9834e38..dc9a3c9 100644 --- a/src/main/java/com/zy/asrs/entity/WaitPakinLog.java +++ b/src/main/java/com/zy/asrs/entity/WaitPakinLog.java @@ -151,6 +151,24 @@ @ApiModelProperty(value= "澶囨敞") private String memo; + /** + * 澶囩敤1 + */ + @ApiModelProperty(value= "澶囩敤1") + private Integer standby1; + + /** + * 澶囩敤2 + */ + @ApiModelProperty(value= "澶囩敤2") + private Integer standby2; + + /** + * 澶囩敤3 + */ + @ApiModelProperty(value= "澶囩敤3") + private Integer standby3; + public String getBeBatch$(){ if (null == this.beBatch){ return null; } switch (this.beBatch){ diff --git a/src/main/java/com/zy/asrs/entity/WrkDetl.java b/src/main/java/com/zy/asrs/entity/WrkDetl.java index 39284b7..e46c57a 100644 --- a/src/main/java/com/zy/asrs/entity/WrkDetl.java +++ b/src/main/java/com/zy/asrs/entity/WrkDetl.java @@ -270,6 +270,24 @@ @ApiModelProperty(value= "澶囨敞") private String memo; + /** + * 澶囩敤1 + */ + @ApiModelProperty(value= "澶囩敤1") + private Integer standby1; + + /** + * 澶囩敤2 + */ + @ApiModelProperty(value= "澶囩敤2") + private Integer standby2; + + /** + * 澶囩敤3 + */ + @ApiModelProperty(value= "澶囩敤3") + private Integer standby3; + public String getIoTime$(){ if (Cools.isEmpty(this.ioTime)){ return ""; diff --git a/src/main/java/com/zy/asrs/entity/WrkDetlLog.java b/src/main/java/com/zy/asrs/entity/WrkDetlLog.java index 155b09f..a6cc5fc 100644 --- a/src/main/java/com/zy/asrs/entity/WrkDetlLog.java +++ b/src/main/java/com/zy/asrs/entity/WrkDetlLog.java @@ -269,6 +269,24 @@ @ApiModelProperty(value= "澶囨敞") private String memo; + /** + * 澶囩敤1 + */ + @ApiModelProperty(value= "澶囩敤1") + private Integer standby1; + + /** + * 澶囩敤2 + */ + @ApiModelProperty(value= "澶囩敤2") + private Integer standby2; + + /** + * 澶囩敤3 + */ + @ApiModelProperty(value= "澶囩敤3") + private Integer standby3; + public String getIoTime$(){ if (Cools.isEmpty(this.ioTime)){ return ""; diff --git a/src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java index 03acb2b..94a3788 100644 --- a/src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/WorkServiceImpl.java @@ -412,11 +412,11 @@ if (locDto.getAnfme()==null || locDto.getAnfme() <= 0.0D) { continue; } // OrderDetl orderDetl = orderDetlService.selectItem(locDto.getOrderNo(), locDto.getMatnr(), locDto.getBatch()); OrderDetl orderDetl = OrderInAndOutUtil.selectItem(Boolean.FALSE, locDto.getOrderNo(), locDto.getMatnr(), locDto.getBatch()); - if (orderDetl == null) { -// orderDetl = orderDetlService.selectItem(locDto.getOrderNo(), locDto.getMatnr(), null); - orderDetl = OrderInAndOutUtil.selectItem(Boolean.FALSE, locDto.getOrderNo(), locDto.getMatnr(), null); - - } +// if (orderDetl == null) { +//// orderDetl = orderDetlService.selectItem(locDto.getOrderNo(), locDto.getMatnr(), null); +// orderDetl = OrderInAndOutUtil.selectItem(Boolean.FALSE, locDto.getOrderNo(), locDto.getMatnr(), null); +// +// } WrkDetl wrkDetl = new WrkDetl(); wrkDetl.sync(orderDetl); wrkDetl.setZpallet(wrkMast.getBarcode()); diff --git a/src/main/java/com/zy/common/service/CommonService.java b/src/main/java/com/zy/common/service/CommonService.java index 2a10d14..8958695 100644 --- a/src/main/java/com/zy/common/service/CommonService.java +++ b/src/main/java/com/zy/common/service/CommonService.java @@ -517,6 +517,7 @@ List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>() .eq("crn_no", crnNo).eq("loc_sts", "O").eq("whs_type",rowLastnoType.getType().longValue())); if (locMasts.size()<=5){ + nearRow = 0; times++; continue; } diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml index 94745c9..53a2bfd 100644 --- a/src/main/resources/mapper/LocDetlMapper.xml +++ b/src/main/resources/mapper/LocDetlMapper.xml @@ -44,6 +44,9 @@ <result column="appe_user" property="appeUser" /> <result column="appe_time" property="appeTime" /> <result column="memo" property="memo" /> + <result column="standby1" property="standby1" /> + <result column="standby2" property="standby2" /> + <result column="standby3" property="standby3" /> </resultMap> <sql id="batchSeq"> diff --git a/src/main/resources/mapper/OrderDetlMapper.xml b/src/main/resources/mapper/OrderDetlMapper.xml index 295b5e9..c46a62c 100644 --- a/src/main/resources/mapper/OrderDetlMapper.xml +++ b/src/main/resources/mapper/OrderDetlMapper.xml @@ -47,22 +47,27 @@ <result column="memo" property="memo" /> <result column="pakin_pakout_status" property="pakinPakoutStatus" /> <result column="line_number" property="lineNumber" /> + <result column="standby1" property="standby1" /> + <result column="standby2" property="standby2" /> + <result column="standby3" property="standby3" /> </resultMap> + + <sql id="standbyAll"> + and batch = #{batch} + and line_number = #{lineNumber} + and specs = #{specs} + and standby1 = #{standby1} + and standby2 = #{standby2} + and standby3 = #{standby3} + </sql> <select id="selectItem" resultMap="BaseResultMap"> select * from man_order_detl where 1=1 and order_id = #{orderId} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </select> <select id="selectItemByOrderNo" resultMap="BaseResultMap"> @@ -70,9 +75,7 @@ where 1=1 and order_no = #{orderNo} and matnr = #{matnr} - <if test="batch!=null and batch!='' "> - and batch = #{batch} - </if> + <include refid="standbyAll"></include> </select> <select id="selectWorkingDetls" resultMap="BaseResultMap"> @@ -133,14 +136,7 @@ where 1=1 and order_id = #{orderId} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </update> <update id="decrease"> @@ -149,14 +145,7 @@ where 1=1 and order_no = #{orderNo} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </update> <update id="modifyStatus"> @@ -176,14 +165,7 @@ where 1=1 and order_no = #{orderNo} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </update> <update id="increaseWorkQty"> @@ -192,14 +174,7 @@ where 1=1 and order_id = #{orderId} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </update> </mapper> diff --git a/src/main/resources/mapper/OrderDetlPakinMapper.xml b/src/main/resources/mapper/OrderDetlPakinMapper.xml index c04bf92..256bbd8 100644 --- a/src/main/resources/mapper/OrderDetlPakinMapper.xml +++ b/src/main/resources/mapper/OrderDetlPakinMapper.xml @@ -47,22 +47,27 @@ <result column="memo" property="memo" /> <result column="pakin_pakout_status" property="pakinPakoutStatus" /> <result column="line_number" property="lineNumber" /> + <result column="standby1" property="standby1" /> + <result column="standby2" property="standby2" /> + <result column="standby3" property="standby3" /> </resultMap> + + <sql id="standbyAll"> + and batch = #{batch} + and line_number = #{lineNumber} + and specs = #{specs} + and standby1 = #{standby1} + and standby2 = #{standby2} + and standby3 = #{standby3} + </sql> <select id="selectItem" resultMap="BaseResultMap"> select * from man_order_detl_pakin where 1=1 and order_id = #{orderId} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </select> <select id="selectItemByOrderNo" resultMap="BaseResultMap"> @@ -70,9 +75,7 @@ where 1=1 and order_no = #{orderNo} and matnr = #{matnr} - <if test="batch!=null and batch!='' "> - and batch = #{batch} - </if> + <include refid="standbyAll"></include> </select> <select id="selectWorkingDetls" resultMap="BaseResultMap"> @@ -133,14 +136,7 @@ where 1=1 and order_id = #{orderId} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </update> <update id="decrease"> @@ -149,14 +145,7 @@ where 1=1 and order_no = #{orderNo} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </update> <update id="modifyStatus"> @@ -176,14 +165,7 @@ where 1=1 and order_no = #{orderNo} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </update> <update id="increaseWorkQty"> @@ -192,14 +174,7 @@ where 1=1 and order_id = #{orderId} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </update> </mapper> diff --git a/src/main/resources/mapper/OrderDetlPakoutMapper.xml b/src/main/resources/mapper/OrderDetlPakoutMapper.xml index 737b736..1300fc1 100644 --- a/src/main/resources/mapper/OrderDetlPakoutMapper.xml +++ b/src/main/resources/mapper/OrderDetlPakoutMapper.xml @@ -47,22 +47,27 @@ <result column="memo" property="memo" /> <result column="pakin_pakout_status" property="pakinPakoutStatus" /> <result column="line_number" property="lineNumber" /> + <result column="standby1" property="standby1" /> + <result column="standby2" property="standby2" /> + <result column="standby3" property="standby3" /> </resultMap> + + <sql id="standbyAll"> + and batch = #{batch} + and line_number = #{lineNumber} + and specs = #{specs} + and standby1 = #{standby1} + and standby2 = #{standby2} + and standby3 = #{standby3} + </sql> <select id="selectItem" resultMap="BaseResultMap"> select * from man_order_detl_pakout where 1=1 and order_id = #{orderId} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </select> <select id="selectItemByOrderNo" resultMap="BaseResultMap"> @@ -70,9 +75,7 @@ where 1=1 and order_no = #{orderNo} and matnr = #{matnr} - <if test="batch!=null and batch!='' "> - and batch = #{batch} - </if> + <include refid="standbyAll"></include> </select> <select id="selectWorkingDetls" resultMap="BaseResultMap"> @@ -133,14 +136,7 @@ where 1=1 and order_id = #{orderId} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </update> <update id="decrease"> @@ -149,14 +145,7 @@ where 1=1 and order_no = #{orderNo} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </update> <update id="modifyStatus"> @@ -176,14 +165,7 @@ where 1=1 and order_no = #{orderNo} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </update> <update id="increaseWorkQty"> @@ -192,14 +174,7 @@ where 1=1 and order_id = #{orderId} and matnr = #{matnr} - <choose> - <when test="batch != null and batch != ''"> - and batch = #{batch} - </when> - <otherwise> - and (batch IS NULL OR batch = '') - </otherwise> - </choose> + <include refid="standbyAll"></include> </update> </mapper> diff --git a/src/main/resources/mapper/WaitPakinLogMapper.xml b/src/main/resources/mapper/WaitPakinLogMapper.xml index a06714a..a4e1429 100644 --- a/src/main/resources/mapper/WaitPakinLogMapper.xml +++ b/src/main/resources/mapper/WaitPakinLogMapper.xml @@ -47,6 +47,9 @@ <result column="appe_time" property="appeTime" /> <result column="appe_user" property="appeUser" /> <result column="memo" property="memo" /> + <result column="standby1" property="standby1" /> + <result column="standby2" property="standby2" /> + <result column="standby3" property="standby3" /> </resultMap> </mapper> diff --git a/src/main/resources/mapper/WaitPakinMapper.xml b/src/main/resources/mapper/WaitPakinMapper.xml index 3daeffc..594e499 100644 --- a/src/main/resources/mapper/WaitPakinMapper.xml +++ b/src/main/resources/mapper/WaitPakinMapper.xml @@ -47,6 +47,9 @@ <result column="appe_time" property="appeTime" /> <result column="appe_user" property="appeUser" /> <result column="memo" property="memo" /> + <result column="standby1" property="standby1" /> + <result column="standby2" property="standby2" /> + <result column="standby3" property="standby3" /> </resultMap> </mapper> diff --git a/src/main/resources/mapper/WrkDetlLogMapper.xml b/src/main/resources/mapper/WrkDetlLogMapper.xml index bef4275..86dbba8 100644 --- a/src/main/resources/mapper/WrkDetlLogMapper.xml +++ b/src/main/resources/mapper/WrkDetlLogMapper.xml @@ -45,6 +45,9 @@ <result column="appe_user" property="appeUser"/> <result column="appe_time" property="appeTime"/> <result column="memo" property="memo"/> + <result column="standby1" property="standby1" /> + <result column="standby2" property="standby2" /> + <result column="standby3" property="standby3" /> </resultMap> <sql id="batchSeq"> diff --git a/src/main/resources/mapper/WrkDetlMapper.xml b/src/main/resources/mapper/WrkDetlMapper.xml index 6674b26..82bdff8 100644 --- a/src/main/resources/mapper/WrkDetlMapper.xml +++ b/src/main/resources/mapper/WrkDetlMapper.xml @@ -45,6 +45,9 @@ <result column="appe_user" property="appeUser" /> <result column="appe_time" property="appeTime" /> <result column="memo" property="memo" /> + <result column="standby1" property="standby1" /> + <result column="standby2" property="standby2" /> + <result column="standby3" property="standby3" /> </resultMap> <sql id="batchSeq"> -- Gitblit v1.9.1