| | |
| | | "<if test='screenEventDTO.endTime != null and screenEventDTO.endTime != ""'>" + |
| | | " AND e.create_at <![CDATA[<=]]> #{screenEventDTO.endTime} " + |
| | | " </if> " + |
| | | "<if test='screenEventDTO.eventProcessStatus != null'>" + |
| | | " AND e.event_process_status = #{screenEventDTO.eventProcessStatus} " + |
| | | " </if> " + |
| | | "<if test='screenEventDTO.redCard != null'>" + |
| | | " AND e.red_card = #{screenEventDTO.redCard} " + |
| | | " </if> " + |
| | | "<if test='screenEventDTO.yellowCard != null'>" + |
| | | " AND e.yellow_card = #{screenEventDTO.yellowCard} " + |
| | | " </if> " + |
| | | "UNION ALL SELECT " + |
| | | " IFNULL( NULL, 7 ) AS type, " + |
| | | " id AS eventId, " + |
| | |
| | | "<if test='screenEventDTO.endTime != null and screenEventDTO.endTime != ""'>" + |
| | | " AND create_at <![CDATA[<=]]> #{screenEventDTO.endTime} " + |
| | | " </if> " + |
| | | "<if test='screenEventDTO.eventProcessStatus != null'>" + |
| | | " AND handle_status = #{screenEventDTO.eventProcessStatus} " + |
| | | " </if> " + |
| | | " </script>") |
| | | List<EventGridIncidentStatisticsVO> getEventScreenEventList(@Param("screenEventDTO") BigScreenEventDTO screenEventDTO); |
| | | |