| | |
| | | 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 |
| | |
| | | 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"> |