zhangherong
2025-03-06 3ccf817b104384af4dd9e341a1c82805021d21f0
art: 设备台账-设备履历 维修记录查询修改
已修改1个文件
5 ■■■■■ 文件已修改
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EamEquipmentMapper.xml 5 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EamEquipmentMapper.xml
@@ -108,7 +108,7 @@
            t1.fault_time as faultTime,
            t2.item_text as maintenanceMethodName,
            t3.name as teamName,
            t4.realname as recipientuserName,
            t1.recipient_user_id as recipientuserName,
            t1.actual_hour as actualHour,
            t1.actual_start_time AS actualStartTime,
            t1.actual_end_time as  actualEndTime
@@ -116,8 +116,7 @@
            mom_eam_repair_order t1
        LEFT JOIN ( SELECT * FROM v_sys_dict WHERE dict_code = 'maintenance_method' ) t2 ON t2.item_value = t1.maintenance_method
        left join mom_base_team t3 on t1.team_id = t3.id
        left join sys_user t4 on t1.recipient_user_id = t4.id
        WHERE t1.del_flag = '0' and t4.del_flag= '0'  and t3.del_flag= '0' and t1.equipment_id = #{params.equipmentId}
        WHERE t1.del_flag = '0' and t1.equipment_id = #{params.equipmentId}
    </select>
    <select id="getResumeCalibrationRecordList"  parameterType="Map" resultType="Map">