| | |
| | | AND cspr.patrol_person LIKE concat('%',#{comSwPatrolRecordDTO.patrolPerson},'%') |
| | | </if> |
| | | <if test='comSwPatrolRecordDTO.patrolType != null and comSwPatrolRecordDTO.patrolType != ""'> |
| | | AND cspr.patrol_type = #{comSwPatrolRecordDTO.patrolType} |
| | | AND cspr.patrol_type LIKE concat('%',#{comSwPatrolRecordDTO.patrolType},'%') |
| | | </if> |
| | | <if test='comSwPatrolRecordDTO.status != null and comSwPatrolRecordDTO.status != ""'> |
| | | AND cspr.patrol_type = #{comSwPatrolRecordDTO.patrolType} |
| | | AND csdr.status = #{comSwPatrolRecordDTO.status} |
| | | </if> |
| | | <if test='comSwPatrolRecordDTO.patrolAtBegin != null and comSwPatrolRecordDTO.patrolAtBegin != ""'> |
| | | AND cspr.patrol_time <![CDATA[ >= ]]> #{comSwPatrolRecordDTO.patrolAtBegin} |