| | |
| | | */ |
| | | @TableField("send_time") |
| | | @ApiModelProperty(value = "文书发放时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm", timezone = "GMT+8") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private LocalDateTime sendTime; |
| | | |
| | | /** |
| | |
| | | */ |
| | | @TableField("limit_time") |
| | | @ApiModelProperty(value = "文书限定时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm", timezone = "GMT+8") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private LocalDateTime limitTime; |
| | | |
| | | /** |
| | |
| | | */ |
| | | @TableField("rectify_time") |
| | | @ApiModelProperty(value = "实际整改时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm", timezone = "GMT+8") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private LocalDateTime rectifyTime; |
| | | |
| | | /** |
| | |
| | | * 所属区域 |
| | | */ |
| | | @TableField("belong_area") |
| | | private Integer belongArea; |
| | | private String belongArea; |
| | | } |
| | |
| | | @ExcelProperty(index = 6, value = "出入城类型") |
| | | private String inOutCityTypeName; |
| | | |
| | | @ExcelIgnore |
| | | @ApiModelProperty(value = "所属区域") |
| | | @ExcelProperty(index = 7, value = "所属区域") |
| | | private String belongArea; |
| | | } |
| | |
| | | t1.latitude, |
| | | t1.longitude, |
| | | t1.`port`, |
| | | t1.belong_area belongArea, |
| | | t1.belong_area, |
| | | t1.front_end_type frontEndType, |
| | | t1.in_out_city_type inOutCityType, |
| | | t2.`name` as frontEndTypeName, |
| | | t3.`name` as inOutCityTypeName, |
| | | t4.region_name as belongArea |
| | | t3.`name` as inOutCityTypeName |
| | | FROM |
| | | `ums_equipment_bayonet` t1 |
| | | LEFT JOIN |