diff --git a/casic-server/src/main/java/com/casic/missiles/modular/device/dto/BusGmDeviceExportDTO.java b/casic-server/src/main/java/com/casic/missiles/modular/device/dto/BusGmDeviceExportDTO.java new file mode 100644 index 0000000..8859bd8 --- /dev/null +++ b/casic-server/src/main/java/com/casic/missiles/modular/device/dto/BusGmDeviceExportDTO.java @@ -0,0 +1,136 @@ +package com.casic.missiles.modular.device.dto; + +import com.alibaba.excel.annotation.ExcelIgnoreUnannotated; +import com.alibaba.excel.annotation.ExcelProperty; +import com.alibaba.excel.annotation.write.style.ColumnWidth; +import com.alibaba.excel.annotation.write.style.ContentRowHeight; +import com.alibaba.excel.annotation.write.style.ContentStyle; +import com.alibaba.excel.annotation.write.style.HeadRowHeight; +import com.alibaba.excel.enums.poi.BorderStyleEnum; +import com.baomidou.mybatisplus.annotation.TableField; +import com.baomidou.mybatisplus.annotation.TableId; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.math.BigDecimal; +import java.util.Date; + +@ColumnWidth(30) +@HeadRowHeight(15) +@ContentRowHeight(20) +@ContentStyle(borderLeft = BorderStyleEnum.THIN, borderBottom = BorderStyleEnum.THIN, borderTop = BorderStyleEnum.THIN, borderRight = BorderStyleEnum.THIN) +@ExcelIgnoreUnannotated +@Data +public class BusGmDeviceExportDTO { + + @ApiModelProperty(value = "主键", dataType = "Long") + @TableId("id") + private Long id; + + + @ApiModelProperty(value = "区域名称", dataType = "String") + @TableField("station_name") + private String stationName; + + @ExcelProperty("设备名称") + @ApiModelProperty(value = "设备名称", dataType = "String") + @TableField("monitor_name") + private String monitorName; + + + + + + + + + + @ApiModelProperty(value = "设备类型", dataType = "String") + @TableField("device_type") + private String deviceType; + + @ExcelProperty("设备类型名称") + @ApiModelProperty(value = "设备类型名称", accessMode = ApiModelProperty.AccessMode.READ_ONLY) + @TableField(exist = false) + private String deviceTypeName; + @ExcelProperty("备注") + @ApiModelProperty(value = "备注", dataType = "String") + @TableField("description") + private String description; + + @ApiModelProperty(value = "设备状态( 在线 1 离线 0 字典status)", dataType = "Integer") + @TableField("device_status") + private Integer deviceStatus; + @ExcelProperty("设备状态名称") + @ApiModelProperty(value = "设备状态名称", accessMode = ApiModelProperty.AccessMode.READ_ONLY) + @TableField(exist = false) + private String deviceStatusName; + + @ApiModelProperty(value = "层级ID", dataType = "String") + @TableField("fleet_id") + private String fleetId; + + @ApiModelProperty(value = "密级(0,一般 1 重要 2 秘密)", dataType = "Integer") + @TableField("secret_level") + private Integer secretLevel; + @TableField(exist = false) + private String secretLevelName; + @ApiModelProperty(value = "所属组织", dataType = "Long") + @TableField("dept_id") + private Long deptId; + @ExcelProperty("所属单位") + @TableField(exist = false) + private String deptName; + + @ApiModelProperty(value = "经度", dataType = "BigDecimal") + @TableField("longitude") + private BigDecimal longitude; + + @ApiModelProperty(value = "纬度", dataType = "BigDecimal") + @TableField("latitude") + private BigDecimal latitude; + + @ApiModelProperty(value = "布防状态(1,布防 0 撤防)", dataType = "Integer") + @TableField("bf_flag") + private Integer bfFlag; + @ExcelProperty("创建时间") + @ApiModelProperty(value = "创建时间", dataType = "Date") + @TableField("create_time") + private Date createTime; + + @ApiModelProperty(value = "修改时间", dataType = "Date") + @TableField("update_time") + private Date updateTime; + + @ApiModelProperty(value = "所属区域", dataType = "String") + @TableField("area") + private String area; + + @ExcelProperty("所属区域") + @ApiModelProperty(value = "所属区域", dataType = "String") + @TableField(exist = false) + private String areaName; + + @ApiModelProperty(value = "播放地址", dataType = "String") + @TableField("play_url") + private String playUrl; + + @ApiModelProperty(value = "通道标识", dataType = "String") + @TableField("camera_index_code") + private String cameraIndexCode; + @ApiModelProperty(value = "nvr设备编码", dataType = "String") + @TableField("nvr_index_code") + private String nvrIndexCode; + @ExcelProperty("详细地址") + @ApiModelProperty(value = "详细地址", dataType = "String") + @TableField("location") + private String location; + + @ApiModelProperty(value = "nvr厂家(类型:Dahua,HIKVISION)", dataType = "String") + @TableField("nvr_manufacture") + private String nvrManufacture; + + @ApiModelProperty(value = "设备厂家(类型:Dahua,Manufacturer)", dataType = "String") + @TableField("device_manufacture") + private String deviceManufacture; +}