43 lines
2.4 KiB
XML
43 lines
2.4 KiB
XML
<?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.bonus.newInput.dao.MachinesAcceptDao" >
|
|
<resultMap id="MachinesAccept" type="com.bonus.newInput.beans.MachinesAcceptBean">
|
|
<result column="CHECK_TIME" property="checkTime" jdbcType="VARCHAR"/>
|
|
<result column="CHECK_CODE" property="checkCode" jdbcType="VARCHAR"/>
|
|
<result column="CHECK_NUM" property="checkNum" jdbcType="VARCHAR"/>
|
|
<result column="EXTERIOR_CHECK" property="exteriorCheck" jdbcType="VARCHAR"/>
|
|
<result column="TEST_CHECK" property="testCheck" jdbcType="VARCHAR"/>
|
|
<result column="CHECK_CONCLUSION" property="checkConclusion" jdbcType="VARCHAR"/>
|
|
<result column="BUYER" property="buyer" jdbcType="VARCHAR"/>
|
|
<result column="STOREKEEPER" property="storekeeper" jdbcType="VARCHAR"/>
|
|
<result column="LEASE_MANAGER" property="leaseManager" jdbcType="VARCHAR"/>
|
|
<result column="REPAIRMAN" property="repaitman" jdbcType="VARCHAR"/>
|
|
<result column="REPAIR_MANAGER" property="repairManageer" jdbcType="VARCHAR"/>
|
|
<result column="CHECKER" property="checker" jdbcType="VARCHAR"/>
|
|
<result column="SAFETY_MANAGER" property="safetyManager" jdbcType="VARCHAR"/>
|
|
<result column="LEADER" property="leader" jdbcType="VARCHAR"/>
|
|
</resultMap>
|
|
|
|
<select id="find" parameterType="com.bonus.newInput.beans.MachinesAcceptBean"
|
|
resultType="com.bonus.newInput.beans.MachinesAcceptBean">
|
|
SELECT DISTINCT tmt.TASK_ID as taskId,mt.ID as maTypeId,mtb.`NAME` as machineType,
|
|
mt.`NAME` as model,bac.CHECK_NUM as checkNum,bac.EXTERIOR_CHECK as
|
|
exteriorCheck,bac.TEST_CHECK as testCheck,bac.CHECK_CONCLUSION as checkConclusion,
|
|
mt.IS_TEST as isTest
|
|
FROM tm_task_ma_type tmt
|
|
LEFT JOIN ma_type mt ON tmt.MA_TYPE_ID = mt.ID
|
|
LEFT JOIN ma_type mtb ON mt.PARENT_ID = mtb.ID
|
|
LEFT JOIN ba_check bac on bac.TASK_ID = tmt.TASK_ID and bac.MA_TYPE_ID = mt.ID
|
|
where tmt.TASK_ID = #{batchId} AND mt.ID = #{maTypeId}
|
|
</select>
|
|
|
|
<insert id="insert" parameterType="com.bonus.newInput.beans.MachinesAcceptBean">
|
|
replace into ba_check
|
|
(TASK_ID,MA_TYPE_ID,CHECK_TIME,CHECK_CODE,CHECK_NUM,EXTERIOR_CHECK,TEST_CHECK,
|
|
CHECK_CONCLUSION,MAT_DATA)
|
|
values
|
|
(#{taskId},#{maTypeId},#{checkTime},#{checkCode},#{checkNum},#{exteriorCheck},
|
|
#{testCheck},#{checkConclusion},#{matData})
|
|
</insert>
|
|
|
|
</mapper> |