*

lsh

2025-04-02 76266d7e5779d1cd3256f63840ac78bbd7755c13

*

 src/main/resources/mapper/BasDevpMapper.xml

@@ -47,24 +47,24 @@

    <select id="getAvailableInSite" resultType="java.lang.Integer">
        select
        abd."dev_no"
        abd."DEV_NO"
        from "SOURCE"."asr_bas_devp" abd
        left join "SOURCE"."asr_sta_desc" asd on abd."dev_no" = asd."stn_no"
        left join "SOURCE"."asr_sta_desc" asd on abd."DEV_NO" = asd."STN_NO"
        where 1=1
        and asd."type_no" = #{typeNo}
        and abd."in_enable" = 'Y'
        group by abd."dev_no"
        and asd."TYPE_NO" = #{typeNo}
        and abd."IN_ENABLE" = 'Y'
        group by abd."DEV_NO"
    </select>

    <select id="getAvailableOutSite" resultType="java.lang.Integer">
        select
        abd."dev_no"
        abd."DEV_NO"
        from "SOURCE"."asr_bas_devp" abd
        left join "SOURCE"."asr_sta_desc" asd on abd."dev_no" = asd."stn_no"
        left join "SOURCE"."asr_sta_desc" asd on abd."DEV_NO" = asd."STN_NO"
        where 1=1
        and asd."type_no" = #{typeNo}
        and abd."out_enable" = 'Y'
        group by abd."dev_no"
        and asd."TYPE_NO" = #{typeNo}
        and abd."OUT_ENABLE" = 'Y'
        group by abd."DEV_NO"
    </select>

</mapper>

 src/main/resources/mapper/CommandInfoMapper.xml

@@ -20,24 +20,24 @@

    <select id="selectByTaskNoAndWrkNo" resultMap="BaseResultMap">
        select * from "SOURCE"."wcs_command_info"
        where "wrk_no" = #{wrkNo}
        and "task_no" = #{taskNo}
        where "WRK_NO" = #{wrkNo}
        and "TASK_NO" = #{taskNo}
    </select>

    <select id="selectByWrkNo" resultMap="BaseResultMap">
        select * from "SOURCE"."wcs_command_info"
        where "wrk_no" = #{wrkNo}
        where "WRK_NO" = #{wrkNo}
    </select>

    <select id="selectByTaskNo" resultMap="BaseResultMap">
        select * from "SOURCE"."wcs_command_info"
        where "task_no" = #{taskNo}
        where "TASK_NO" = #{taskNo}
    </select>

    <select id="selectCompleteManualCommand" resultMap="BaseResultMap">
        select * from "SOURCE"."wcs_command_info"
        where "command_type" = 2
        and "command_status" = 3
        where "COMMAND_TYPE" = 2
        and "COMMAND_STATUS" = 3
    </select>

</mapper>

 src/main/resources/mapper/ConfigMapper.xml

@@ -15,12 +15,12 @@

    <select id="selectByCode" resultMap="BaseResultMap">
        select top 1 * from "SOURCE"."sys_config"
        where "code" = #{code}
        where "CODE" = #{code}
    </select>

    <select id="selectByCodes" resultMap="BaseResultMap">
        select * from "SOURCE"."sys_config"
        where "code" in
        where "CODE" in
        <foreach item="item" collection="codes" index="index"  separator="," open="(" close=")">
            #{item}
        </foreach>

 src/main/resources/mapper/DataResourceMapper.xml

@@ -15,17 +15,17 @@

    <select id="selectRootData" resultMap="BaseResultMap">
        select * from "SOURCE"."wcs_data_resource"
        where "resource_id" is null
        where "RESOURCE_ID" is null
    </select>

    <select id="selectByResourceId" resultMap="BaseResultMap">
        select * from "SOURCE"."wcs_data_resource"
        where "resource_id" = #{resourceId}
        where "RESOURCE_ID" = #{resourceId}
    </select>

    <select id="selectAll" resultMap="BaseResultMap">
        select * from "SOURCE"."wcs_data_resource"
        order by "name"
        order by "NAME"
    </select>

</mapper>

 src/main/resources/mapper/DeviceErrorMapper.xml

@@ -14,14 +14,14 @@

    <select id="selectByDeviceAndDeviceId" resultMap="BaseResultMap">
        select top 1 * from "SOURCE"."wcs_device_error"
        where "device" = #{device}
        and "device_id" = #{deviceId}
        where "DEVICE" = #{device}
        and "DEVICE_ID" = #{deviceId}
    </select>

    <delete id="deleteByDeviceAndDeviceId">
        delete from "SOURCE"."wcs_device_error"
        where "device" = #{device}
        and "device_id" = #{deviceId}
        where "DEVICE" = #{device}
        and "CREATE_TIME" = #{deviceId}
    </delete>

</mapper>

 src/main/resources/mapper/LocDetlMapper.xml

@@ -51,19 +51,19 @@
            and a."LOC_NO" like '%' + #{loc_no} + '%'
        </if>
        <if test="matNo!=null and matNo!='' ">
            and a."matnr" like '%' + #{matNo} + '%'
            and a."MATNR" like '%' + #{matNo} + '%'
        </if>
        <if test="matName!=null and matName!='' ">
            and a."maktx" like '%' + #{matName} + '%'
            and a."MAKTX" like '%' + #{matName} + '%'
        </if>
        <if test="anfme!=null and anfme!='' ">
            and a."anfme" like '%' + #{anfme} + '%'
            and a."ANFME" like '%' + #{anfme} + '%'
        </if>
        <if test="altme!=null and altme!='' ">
            and a."altme" like '%' + #{altme} + '%'
            and a."ALTME" like '%' + #{altme} + '%'
        </if>
        <if test="startTime!=null and endTime!=null">
            and a."modi_time" between #{startTime} and #{endTime}
            and a."MODI_TIME" between #{startTime} and #{endTime}
        </if>
    </sql>