update

Lius

2025-02-18 efa70c90aa58fd175b48c1475bfe52513dd00548

update

 lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/xml/MdcMttrInfoMapper.xml

@@ -9,18 +9,18 @@
        FROM
            mdc_mttr_info
        <where>
            <if test="MdcMttrInfoVo.equipmentId != null and MdcMttrInfoVo.equipmentId != ''">
                AND equipment_id = #{ MdcMttrInfoVo.equipmentId }
            <if test="mdcMttrInfoVo.equipmentId != null and mdcMttrInfoVo.equipmentId != ''">
                AND equipment_id = #{ mdcMttrInfoVo.equipmentId }
            </if>
            <if test="MdcMttrInfoVo.startTime != null and MdcMttrInfoVo.startTime != ''">
                AND the_date &gt;= #{ MdcMttrInfoVo.startTime }
            <if test="mdcMttrInfoVo.startTime != null and mdcMttrInfoVo.startTime != ''">
                AND the_date &gt;= #{ mdcMttrInfoVo.startTime }
            </if>
            <if test="MdcMttrInfoVo.endTime != null and MdcMttrInfoVo.endTime != ''">
                AND the_date &lt;= #{MdcMttrInfoVo.endTime }
            <if test="mdcMttrInfoVo.endTime != null and mdcMttrInfoVo.endTime != ''">
                AND the_date &lt;= #{mdcMttrInfoVo.endTime }
            </if>
            <if test="MdcMttrInfoVo.equipmentIdList != null and MdcMttrInfoVo.equipmentIdList.size() > 0 ">
            <if test="mdcMttrInfoVo.equipmentIdList != null and mdcMttrInfoVo.equipmentIdList.size() > 0 ">
                AND equipment_id IN
                <foreach collection="MdcMttrInfoVo.equipmentIdList" item="id" index="index" open="(" close=")" separator=",">
                <foreach collection="mdcMttrInfoVo.equipmentIdList" item="id" index="index" open="(" close=")" separator=",">
                    #{ id }
                </foreach>
            </if>