提交

“linengliang”

2024-01-02 50904787dcb3ea277f6956fcbc09f9efefece2ce

提交

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

@@ -3,41 +3,41 @@
<mapper namespace="org.jeecg.modules.eam.mapper.EquipmentReportRepairMapper">
    <select id="getReportRepairList"  parameterType="Map" resultType="Map">
        SELECT
            t1.id,
            t1.err_uda1 errUda1,
            t1.err_uda2 errUda2,
            t1.num num,
            t1.equipment_id equipmentId,
            t1.fault_reason faultReason,
            t1.fault_description faultDescription,
            t1.photo photo,
            t1.is_stop isStop,
            t1.approval approval,
            t1.fault_time faultTime,
            t1.source source,
            t1.type,
            t1.source_id sourceId,
            t1.urgency urgency,
            t1.is_create_order isCreateOrder,
            t1.use_depart_id useDepartId,
            t1.remark remark,
            t1.status status,
            t1.create_by createBy,
            t1.create_time createTime,
            t1.update_by updateBy,
            t1.update_time updateTime,
            t1.accept_time acceptTime,
            t1.fault_hour faultHour,
            t2.num equipmentNum,
            t2.name equipmentName,
            t2.model equipmentModel,
            t2.team_id teamId,
            t2.specification equipmentSpecification,
            t3.depart_name departName,
            t4.item_text urgencyName,
            t5.item_text statusName,
            t6.item_text isStopName,
            t7.item_text errUda1_dictText
        t1.id,
        t1.err_uda1 errUda1,
        t1.err_uda2 errUda2,
        t1.num num,
        t1.equipment_id equipmentId,
        t1.fault_reason faultReason,
        t1.fault_description faultDescription,
        t1.photo photo,
        t1.is_stop isStop,
        t1.approval approval,
        t1.fault_time faultTime,
        t1.source source,
        t1.source_id sourceId,
        t1.urgency urgency,
        t1.is_create_order isCreateOrder,
        t1.use_depart_id useDepartId,
        t1.remark remark,
        t1.status status,
        t1.create_by createBy,
        t1.create_time createTime,
        t1.update_by updateBy,
        t1.update_time updateTime,
        t1.accept_time acceptTime,
        t1.fault_hour faultHour,
        t2.num equipmentNum,
        t2.name equipmentName,
        t2.model equipmentModel,
        t2.specific_equipment specificEquipment,
        t2.team_id teamId,
        t2.specification equipmentSpecification,
        t3.depart_name departName,
        t4.item_text urgencyName,
        t5.item_text statusName,
        t6.item_text isStopName,
        t7.item_text errUda1_dictText
        FROM
        mom_eam_equipment_report_repair t1
        left join mom_eam_equipment t2 on t1.equipment_id = t2.id
@@ -89,6 +89,9 @@
        <if test="params.model != null and params.model != ''">
            and t2.model like concat('%',#{params.model},'%')
        </if>
        <if test="params.specificEquipment != null and params.specificEquipment != ''">
            and t2.specific_equipment = #{params.specificEquipment}
        </if>
        <if test="params.specification != null and params.specification != ''">
            and t2.specification like concat('%',#{params.specification},'%')
        </if>