维修工单查询条件修改

Lius

2025-04-09 07ad62ce0edbd32eb0b690e099c5f7091d269cd0

维修工单查询条件修改

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EamReportRepairMapper.xml

@@ -22,7 +22,10 @@
                </otherwise>
            </choose>
            <if test="eamReportRepair.equipmentId != null and eamReportRepair.equipmentId != ''">
                AND t2.equipment_code LIKE CONCAT(CONCAT('%',#{ eamReportRepair.equipmentId }),'%')
                AND t2.id = #{ eamReportRepair.equipmentId }
            </if>
            <if test="eamReportRepair.equipmentCode != null and eamReportRepair.equipmentCode != ''">
                AND t2.equipment_code LIKE CONCAT(CONCAT('%',#{ eamReportRepair.equipmentCode }),'%')
            </if>
            <if test="eamReportRepair.equipmentName != null and eamReportRepair.equipmentName != ''">
                AND t2.equipment_name = LIKE CONCAT(CONCAT('%',#{ eamReportRepair.equipmentName }),'%')

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/request/EamReportRepairQuery.java

@@ -22,6 +22,11 @@
    private static final long serialVersionUID = -7111580122226167877L;

    /**
     * 设备编码
     */
    private String equipmentCode;

    /**
     * 开始时间
     */
    private String startTime;