| | |
| | | AND t1.equipment_name = #{mdcEquipment.equipmentModel} |
| | | </if> |
| | | <if test="mdcEquipment.equipmentType != null and mdcEquipment.equipmentType != '' "> |
| | | AND t1.equipmentType = #{mdcEquipment.equipmentType} |
| | | AND t1.equipment_type = #{mdcEquipment.equipmentType} |
| | | </if> |
| | | <if test="mdcEquipment.driveType != null and mdcEquipment.driveType != '' "> |
| | | AND t1.drive_type = #{mdcEquipment.driveType} |
| | |
| | | AND t1.equipment_id LIKE CONCAT(CONCAT('%',#{mdcEquipment.equipmentId}),'%') |
| | | </if> |
| | | <if test="mdcEquipment.equipmentType != null and mdcEquipment.equipmentType != '' "> |
| | | AND t2.equipmentType = #{mdcEquipment.equipmentType} |
| | | AND t2.equipment_type = #{mdcEquipment.equipmentType} |
| | | </if> |
| | | <if test="mdcEquipment.driveType != null and mdcEquipment.driveType != '' "> |
| | | AND t2.drive_type = #{mdcEquipment.driveType} |