| | |
| | | <if test="deviceMaintenanceDto.maintenanceActuallyTimeReq != null"> |
| | | and dm.maintenance_actually_time like concat('%',#{deviceMaintenanceDto.maintenanceActuallyTimeReq},'%') |
| | | </if> |
| | | <if test="deviceMaintenanceDto.status != null"> |
| | | and dm.status = #{deviceMaintenanceDto.status} |
| | | </if> |
| | | </where> |
| | | </select> |
| | | <select id="detailById" resultType="com.ruoyi.device.dto.DeviceMaintenanceDto"> |
| | |
| | | <if test="deviceRepairDto.maintenanceTimeStr != null and deviceRepairDto.maintenanceTimeStr != '' "> |
| | | and dr.maintenance_time like concat('%',#{deviceRepairDto.maintenanceTimeStr},'%') |
| | | </if> |
| | | <if test="deviceRepairDto.status != null"> |
| | | and dr.status = #{deviceRepairDto.status} |
| | | </if> |
| | | </where> |
| | | </select> |
| | | <select id="detailById" resultType="com.ruoyi.device.dto.DeviceRepairDto"> |