提交

“linengliang”

2024-01-02 50904787dcb3ea277f6956fcbc09f9efefece2ce

提交

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

@@ -15,7 +15,6 @@
            t1.approval approval,
            t1.fault_time faultTime,
            t1.source source,
            t1.type,
            t1.source_id sourceId,
            t1.urgency urgency,
            t1.is_create_order isCreateOrder,
@@ -31,6 +30,7 @@
            t2.num equipmentNum,
            t2.name equipmentName,
            t2.model equipmentModel,
        t2.specific_equipment specificEquipment,
            t2.team_id teamId,
            t2.specification equipmentSpecification,
            t3.depart_name departName,
@@ -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>