qsw 故障报修修改

qushaowei

2023-08-24 bcef154b145308fe2b9603d96558ff3a44cf2346

qsw 故障报修修改

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

@@ -8,6 +8,7 @@
        t1.equipment_id equipmentId,
        t1.fault_description faultDescription,
        t1.photo photo,
            t1.is_stop isStop,
        t1.approval approval,
        t1.fault_time faultTime,
        t1.source source,
@@ -27,13 +28,15 @@
        t2.specification equipmentSpecification,
        t3.depart_name departName,
        t4.item_text urgencyName,
        t5.item_text statusName
            t5.item_text statusName,
            t6.item_text isStopName
        FROM
        mom_eam_equipment_report_repair t1
        left join mom_eam_equipment t2 on t1.equipment_id = t2.id
        left join sys_depart t3 on t1.use_depart_id = t3.id
        left join (select * from v_sys_dict where dict_code='urgency') t4 on t1.urgency = t4.item_value
        left join (select * from v_sys_dict where dict_code='equipment_report_repair_status') t5 on t1.status = t5.item_value
        left join (select * from v_sys_dict where dict_code='is_stop') t6 on t1.is_stop = t6.item_value
        WHERE t1.del_flag = 0
        <if test="params.num != null and params.num != ''">
            and t1.num like concat('%',#{params.num},'%')