Merge remote-tracking branch 'origin/master'
| | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import org.sxkj.fw.area.entity.FwAreaDivideEntity; |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.time.LocalDate; |
| | | import java.time.LocalTime; |
| | | import java.time.LocalDateTime; |
| | | |
| | | /** |
| | | * 区域划分表 数据传输对象实体类 |
| | |
| | | @ApiModelProperty(value = "关联派出所id") |
| | | private Long policeStationId; |
| | | /** |
| | | * 可飞行时间段-开始 |
| | | * 可飞行日期时间-开始 |
| | | */ |
| | | @ApiModelProperty(value = "可飞行时间段-开始") |
| | | private LocalTime flyTimeStart; |
| | | @ApiModelProperty(value = "可飞行日期时间-开始") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | private LocalDateTime flyDateStart; |
| | | /** |
| | | * 可飞行时间段-结束 |
| | | * 可飞行日期时间-结束 |
| | | */ |
| | | @ApiModelProperty(value = "可飞行时间段-结束") |
| | | private LocalTime flyTimeEnd; |
| | | /** |
| | | * 可飞行日期-开始 |
| | | */ |
| | | @ApiModelProperty(value = "可飞行日期-开始") |
| | | private LocalDate flyDateStart; |
| | | /** |
| | | * 可飞行日期-结束 |
| | | */ |
| | | @ApiModelProperty(value = "可飞行日期-结束") |
| | | private LocalDate flyDateEnd; |
| | | @ApiModelProperty(value = "可飞行日期时间-结束") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | private LocalDateTime flyDateEnd; |
| | | /** |
| | | * 区域编码 |
| | | */ |
| | |
| | | |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | |
| | | import org.springblade.core.mp.base.BaseEntity; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.time.LocalDate; |
| | | import java.time.LocalTime; |
| | | import java.time.LocalDateTime; |
| | | |
| | | /** |
| | | * 区域划分表 实体类 |
| | |
| | | @ApiModelProperty(value = "关联派出所id") |
| | | private Long policeStationId; |
| | | /** |
| | | * 可飞行时间段-开始 |
| | | */ |
| | | @TableField("fly_time_start") |
| | | @ApiModelProperty(value = "可飞行时间段-开始") |
| | | private LocalTime flyTimeStart; |
| | | /** |
| | | * 可飞行时间段-结束 |
| | | */ |
| | | @TableField("fly_time_end") |
| | | @ApiModelProperty(value = "可飞行时间段-结束") |
| | | private LocalTime flyTimeEnd; |
| | | /** |
| | | * 可飞行日期-开始 |
| | | * 可飞行日期时间-开始 |
| | | */ |
| | | @TableField("fly_date_start") |
| | | @ApiModelProperty(value = "可飞行日期-开始") |
| | | private LocalDate flyDateStart; |
| | | @ApiModelProperty(value = "可飞行日期时间-开始") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private LocalDateTime flyDateStart; |
| | | /** |
| | | * 可飞行日期-结束 |
| | | * 可飞行日期时间-结束 |
| | | */ |
| | | @TableField("fly_date_end") |
| | | @ApiModelProperty(value = "可飞行日期-结束") |
| | | private LocalDate flyDateEnd; |
| | | @ApiModelProperty(value = "可飞行日期时间-结束") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private LocalDateTime flyDateEnd; |
| | | /** |
| | | * 区域编码 |
| | | */ |
| | |
| | | import com.alibaba.excel.annotation.write.style.ContentRowHeight; |
| | | import com.alibaba.excel.annotation.write.style.HeadRowHeight; |
| | | import lombok.Data; |
| | | import org.sxkj.fw.utils.excel.LocalTimeConverter; |
| | | import org.sxkj.fw.utils.excel.LocalDateTimeConverter; |
| | | |
| | | import java.io.Serializable; |
| | | import java.math.BigDecimal; |
| | | import java.time.LocalDate; |
| | | import java.time.LocalTime; |
| | | import java.time.LocalDateTime; |
| | | |
| | | |
| | | /** |
| | |
| | | @ExcelProperty("关联派出所id") |
| | | private Long policeStationId; |
| | | /** |
| | | * 可飞行时间段-开始 |
| | | * 可飞行日期时间-开始 |
| | | */ |
| | | @ColumnWidth(20) |
| | | @ExcelProperty(value = "可飞行时间段-开始", converter = LocalTimeConverter.class) |
| | | private LocalTime flyTimeStart; |
| | | @ExcelProperty(value = "可飞行日期时间-开始", converter = LocalDateTimeConverter.class) |
| | | private LocalDateTime flyDateStart; |
| | | /** |
| | | * 可飞行时间段-结束 |
| | | * 可飞行日期时间-结束 |
| | | */ |
| | | @ColumnWidth(20) |
| | | @ExcelProperty(value = "可飞行时间段-结束", converter = LocalTimeConverter.class) |
| | | private LocalTime flyTimeEnd; |
| | | /** |
| | | * 可飞行日期-开始 |
| | | */ |
| | | @ColumnWidth(20) |
| | | @ExcelProperty("可飞行日期-开始") |
| | | private LocalDate flyDateStart; |
| | | /** |
| | | * 可飞行日期-结束 |
| | | */ |
| | | @ColumnWidth(20) |
| | | @ExcelProperty("可飞行日期-结束") |
| | | private LocalDate flyDateEnd; |
| | | @ExcelProperty(value = "可飞行日期时间-结束", converter = LocalDateTimeConverter.class) |
| | | private LocalDateTime flyDateEnd; |
| | | /** |
| | | * 区域编码 |
| | | */ |
| | |
| | | <result column="response_mechanism" property="responseMechanism"/> |
| | | <result column="control_level" property="controlLevel"/> |
| | | <result column="police_station_id" property="policeStationId"/> |
| | | <result column="fly_time_start" property="flyTimeStart"/> |
| | | <result column="fly_time_end" property="flyTimeEnd"/> |
| | | <result column="fly_date_start" property="flyDateStart"/> |
| | | <result column="fly_date_end" property="flyDateEnd"/> |
| | | <result column="area_code" property="areaCode"/> |
| | |
| | | ad.response_mechanism, |
| | | ad.control_level, |
| | | ad.police_station_id, |
| | | ad.fly_time_start, |
| | | ad.fly_time_end, |
| | | ad.fly_date_start, |
| | | ad.fly_date_end, |
| | | ad.area_code, |
| | |
| | | <if test="param2.policeStationId != null and param2.policeStationId != ''"> |
| | | and ad.police_station_id = #{param2.policeStationId} |
| | | </if> |
| | | <if test="param2.flyTimeStart != null and param2.flyTimeStart != ''"> |
| | | and ad.fly_time_start >= #{param2.flyTimeStart} |
| | | </if> |
| | | <if test="param2.flyTimeEnd != null and param2.flyTimeEnd != ''"> |
| | | and ad.fly_time_end <= #{param2.flyTimeEnd} |
| | | </if> |
| | | <if test="param2.flyDateStart != null and param2.flyDateStart != ''"> |
| | | and ad.fly_date_start >= #{param2.flyDateStart} |
| | | </if> |
| | |
| | | ad.response_mechanism, |
| | | ad.control_level, |
| | | ad.police_station_id, |
| | | ad.fly_time_start, |
| | | ad.fly_time_end, |
| | | ad.fly_date_start, |
| | | ad.fly_date_end, |
| | | ad.area_code, |
| | |
| | | response_mechanism, |
| | | control_level, |
| | | police_station_id, |
| | | fly_time_start, |
| | | fly_time_end, |
| | | fly_date_start, |
| | | fly_date_end, |
| | | area_code, |
| | |
| | | response_mechanism, |
| | | control_level, |
| | | police_station_id, |
| | | fly_time_start, |
| | | fly_time_end, |
| | | fly_date_start, |
| | | fly_date_end, |
| | | area_code, |
| | |
| | | #{responseMechanism}, |
| | | #{controlLevel}, |
| | | #{policeStationId}, |
| | | #{flyTimeStart}, |
| | | #{flyTimeEnd}, |
| | | #{flyDateStart}, |
| | | #{flyDateEnd}, |
| | | #{areaCode}, |
| | |
| | | <if test="responseMechanism != null">response_mechanism = #{responseMechanism},</if> |
| | | <if test="controlLevel != null">control_level = #{controlLevel},</if> |
| | | <if test="policeStationId != null">police_station_id = #{policeStationId},</if> |
| | | <if test="flyTimeStart != null">fly_time_start = #{flyTimeStart},</if> |
| | | <if test="flyTimeEnd != null">fly_time_end = #{flyTimeEnd},</if> |
| | | <if test="flyDateStart != null">fly_date_start = #{flyDateStart},</if> |
| | | <if test="flyDateEnd != null">fly_date_end = #{flyDateEnd},</if> |
| | | <if test="areaCode != null">area_code = #{areaCode},</if> |