From 9f2749cff3cc5c05ed6314f0dfac3f405052b21c Mon Sep 17 00:00:00 2001 From: whycq <10027870+whycq@user.noreply.gitee.com> Date: 星期一, 20 五月 2024 15:50:47 +0800 Subject: [PATCH] # --- src/main/resources/mapper/AgvWrkDetlMapper.xml | 155 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 155 insertions(+), 0 deletions(-) diff --git a/src/main/resources/mapper/AgvWrkDetlMapper.xml b/src/main/resources/mapper/AgvWrkDetlMapper.xml new file mode 100644 index 0000000..6326029 --- /dev/null +++ b/src/main/resources/mapper/AgvWrkDetlMapper.xml @@ -0,0 +1,155 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.zy.asrs.mapper.AgvWrkDetlMapper"> + + <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 --> + <resultMap id="BaseResultMap" type="com.zy.asrs.entity.WrkDetl"> + <result column="wrk_no" property="wrkNo" /> + <result column="io_time" property="ioTime" /> + <result column="anfme" property="anfme" /> + <result column="zpallet" property="zpallet" /> + <result column="matnr" property="matnr" /> + <result column="maktx" property="maktx" /> + <result column="batch" property="batch" /> + <result column="order_no" property="orderNo" /> + + <result column="specs" property="specs" /> + <result column="model" property="model" /> + <result column="color" property="color" /> + <result column="brand" property="brand" /> + <result column="unit" property="unit" /> + <result column="price" property="price" /> + <result column="sku" property="sku" /> + <result column="units" property="units" /> + <result column="barcode" property="barcode" /> + <result column="origin" property="origin" /> + <result column="manu" property="manu" /> + <result column="manu_date" property="manuDate" /> + <result column="item_num" property="itemNum" /> + <result column="safe_qty" property="safeQty" /> + <result column="weight" property="weight" /> + <result column="length" property="length" /> + <result column="volume" property="volume" /> + <result column="three_code" property="threeCode" /> + <result column="supp" property="supp" /> + <result column="supp_code" property="suppCode" /> + <result column="be_batch" property="beBatch" /> + <result column="dead_time" property="deadTime" /> + <result column="dead_warn" property="deadWarn" /> + <result column="source" property="source" /> + <result column="inspect" property="inspect" /> + <result column="danger" property="danger" /> + + <result column="modi_user" property="modiUser" /> + <result column="modi_time" property="modiTime" /> + <result column="appe_user" property="appeUser" /> + <result column="appe_time" property="appeTime" /> + <result column="memo" property="memo" /> + </resultMap> + + <sql id="batchSeq"> + <choose> + <when test="batch != null and batch != ''"> + and batch = #{batch} + </when> + <otherwise> + and (batch IS NULL OR batch = '') + </otherwise> + </choose> + </sql> + + + <select id="selectByWrkNo" resultMap="BaseResultMap"> + select * from asr_wrk_detl where 1=1 and wrk_no = #{wrkNo} + </select> + + <delete id="deleteItem"> + delete from asr_wrk_detl + where 1=1 + and wrk_no = #{wrkNo} + and matnr = #{matnr} + <include refid="batchSeq"></include> + </delete> + + <update id="updateAnfme"> + update asr_wrk_detl + set anfme = #{anfme} + , modi_time = getdate() + where 1=1 + and wrk_no = #{wrkNo} + and matnr = #{matnr} + <include refid="batchSeq"></include> + </update> + + <select id="selectAndLogByOrderNo" resultMap="BaseResultMap"> + select awd.* + from asr_wrk_detl awd + left join asr_wrk_mast awm on awd.wrk_no = awm.wrk_no and awd.io_time = awm.io_time + where order_no = #{orderNo} + union + select distinct awdl.* + from asr_wrk_detl_log awdl + left join asr_wrk_mast_log awml on awdl.wrk_no = awml.wrk_no and awdl.io_time = awml.io_time + where awdl.order_no = #{orderNo} + and (awml.manu_type is null or awml.manu_type != '鎵嬪姩鍙栨秷') + </select> + + <select id="selectAndLogByOrderNoGroupByMatnrOfSum" resultMap="BaseResultMap"> + select awd.wrk_no, awd.io_time, awd.matnr, sum(awd.anfme) as anfme + from asr_wrk_detl awd + left join asr_wrk_mast awm on awd.wrk_no = awm.wrk_no and awd.io_time = awm.io_time + where order_no = #{orderNo} + group by awd.wrk_no, awd.io_time, awd.matnr + union + select distinct awdl.wrk_no, awdl.io_time, awdl.matnr, sum(awdl.anfme) as anfme + from asr_wrk_detl_log awdl + left join asr_wrk_mast_log awml on awdl.wrk_no = awml.wrk_no and awdl.io_time = awml.io_time + where awdl.order_no = #{orderNo} + and (awml.manu_type is null or awml.manu_type != '鎵嬪姩鍙栨秷') + group by awdl.wrk_no, awdl.io_time, awdl.matnr + </select> + + <update id="updateInspect"> + update asr_wrk_detl + set inspect = 1 + where 1=1 + and wrk_no = #{wrkNo} + and matnr = #{matnr} + <include refid="batchSeq"></include> + </update> + + <select id="selectPakoutQuery" resultMap="BaseResultMap"> + select + awd.* + from asr_wrk_detl awd + left join asr_wrk_mast awm on awd.wrk_no = awm.wrk_no + where 1=1 + and awm.wrk_sts = 14 + and (awd.inspect is null or awd.inspect = 0) + and awm.sta_no = #{staNo} + and awd.matnr + '-' + awd.batch = #{matnr} + </select> + + <update id="updateOrderNo"> + update asr_wrk_detl + set order_no = #{orderNo} + , modi_time = getdate() + where 1=1 + and wrk_no = #{wrkNo} + and matnr = #{matnr} + <include refid="batchSeq"></include> + </update> + + <update id="updateWrkNo1" > + update agv_wrk_detl + set wrk_no = #{wrkNo} + , modi_time = getdate() + where 1=1 + and supp_code = #{barcode} + and matnr = #{matnr} + and three_code = #{threrCode} + </update> + + + +</mapper> -- Gitblit v1.9.1