| | |
| | | left join sys_users su on su.user_id = t.admin_user |
| | | <where> |
| | | <trim suffixOverrides=" AND "> |
| | | t.is_use = 1 AND |
| | | <if test="bigDeviceName !=null and bigDeviceName !=''"> |
| | | bd.big_device_name LIKE concat('%',#{bigDeviceName},'%') |
| | | bd.big_device_name LIKE concat('%',#{bigDeviceName},'%') AND |
| | | </if> |
| | | <if test="startTime !=null"> |
| | | t.check_time >= #{startTime} |
| | | t.check_time >= #{startTime} AND |
| | | </if> |
| | | <if test="endTime !=null"> |
| | | t.check_time <= #{endTime} |
| | | t.check_time <= #{endTime} AND |
| | | </if> |
| | | </trim> |
| | | </where> |