| | |
| | | package com.ycl.vo.casePool; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import lombok.Data; |
| | | |
| | | import java.time.LocalDateTime; |
| | | |
| | | @Data |
| | | public class BaseCaseVO { |
| | |
| | | private String grade; |
| | | private String street; |
| | | private String community; |
| | | |
| | | @JsonFormat(timezone = "GMT",pattern = "yyyy-MM-dd HH:mm:ss") |
| | | private LocalDateTime alarmTime; |
| | | } |
| | |
| | | t4.pic_data, |
| | | t5.`name` as grade, |
| | | t6.`name` as street, |
| | | t7.`name` as community |
| | | t7.`name` as community, |
| | | t1.alarm_time as alarmTime |
| | | FROM |
| | | ums_base_case t1 |
| | | LEFT JOIN ums_violations t2 ON t1.id = t2.id |