sql修改

Lius

2024-04-18 7b7eb31cb6b8a4594d09c1fa45dc96eb03c5e34f

sql修改

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

@@ -133,9 +133,9 @@
            mdc_equipment_statistical_info t1
            LEFT JOIN mdc_equipment t2 ON t1.equipment_id = t2.equipment_id
        <where>
            AND the_date BETWEEN #{start} AND #{end}
            AND t1.the_date BETWEEN #{start} AND #{end}
            <if test="equipmentIdList != null and equipmentIdList.size() > 0 ">
                AND equipment_id IN
                AND t1.equipment_id IN
                <foreach collection="equipmentIdList" index="index" item="id" open="(" separator="," close=")">
                    #{id}
                </foreach>