| | |
| | | @ExcelIgnore |
| | | private Boolean importantCommandImageTag; |
| | | |
| | | @ColumnWidth(16) |
| | | @ExcelProperty("是否重点指挥图像") |
| | | private String importantCommandImageTagString; |
| | | } |
| | |
| | | yu.unit_name, |
| | | yp.start_time, |
| | | yp.end_time, |
| | | yp.province_tag, |
| | | yp.important_tag, |
| | | yp.important_command_image_tag |
| | | CASE WHEN yp.province_tag = 0 THEN '' ELSE '省厅点位' END AS provinceTagString, |
| | | CASE WHEN yp.important_tag = 0 THEN '' ELSE '重点点位' END AS importantTagString, |
| | | CASE WHEN yp.important_command_image_tag = 0 THEN '' ELSE '重点指挥图像' END AS importantCommandImageTagString |
| | | FROM |
| | | t_yw_point yp |
| | | INNER JOIN t_monitor m ON yp.serial_number = m.serial_number |