/*
|
* Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
|
*
|
* Redistribution and use in source and binary forms, with or without
|
* modification, are permitted provided that the following conditions are met:
|
*
|
* Redistributions of source code must retain the above copyright notice,
|
* this list of conditions and the following disclaimer.
|
* Redistributions in binary form must reproduce the above copyright
|
* notice, this list of conditions and the following disclaimer in the
|
* documentation and/or other materials provided with the distribution.
|
* Neither the name of the dreamlu.net developer nor the names of its
|
* contributors may be used to endorse or promote products derived from
|
* this software without specific prior written permission.
|
* Author: Chill 庄骞 (smallchill@163.com)
|
*/
|
package org.sxkj.gd.workOrder.excel;
|
|
|
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.HeadRowHeight;
|
import lombok.Data;
|
|
import java.io.Serializable;
|
import java.math.BigDecimal;
|
import java.util.Date;
|
|
|
/**
|
* 设备信息 Excel实体类
|
*
|
* @author lw
|
* @since 2026-01-14
|
*/
|
@Data
|
@ColumnWidth(25)
|
@HeadRowHeight(20)
|
@ContentRowHeight(18)
|
public class GdManageDeviceExcel implements Serializable {
|
|
private static final long serialVersionUID = 1L;
|
|
/**
|
* dock, drone, remote control
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("dock, drone, remote control")
|
private String deviceSn;
|
/**
|
* model of the device. This parameter corresponds to the device name in the device dictionary table.
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("model of the device. This parameter corresponds to the device name in the device dictionary table.")
|
private String deviceName;
|
/**
|
* custom name of the device
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("custom name of the device")
|
private String nickname;
|
/**
|
* The workspace to which the current device belongs.如果为时间戳则表明该机场已被解绑
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("The workspace to which the current device belongs.如果为时间戳则表明该机场已被解绑")
|
private String workspaceId;
|
/**
|
* This parameter corresponds to the device type in the device dictionary table.
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("This parameter corresponds to the device type in the device dictionary table.")
|
private Integer deviceType;
|
/**
|
* This parameter corresponds to the sub type in the device dictionary table.
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("This parameter corresponds to the sub type in the device dictionary table.")
|
private Integer subType;
|
/**
|
* 设备负载（红外，喇叭，闪光灯）
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("设备负载（红外，喇叭，闪光灯）")
|
private String devicePayload;
|
/**
|
* 当前经度
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("当前经度")
|
private Double longitude;
|
/**
|
* 当前纬度
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("当前纬度")
|
private Double latitude;
|
/**
|
* The account used when the device was bound.
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("The account used when the device was bound.")
|
private String userId;
|
/**
|
* This parameter corresponds to the domain in the device dictionary table.
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("This parameter corresponds to the domain in the device dictionary table.")
|
private Integer domain;
|
/**
|
* firmware version of the device
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("firmware version of the device")
|
private String firmwareVersion;
|
/**
|
* 1:一致;0:不一致;固件版本是否一致。
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("1:一致;0:不一致;固件版本是否一致。")
|
private Boolean compatibleStatus;
|
/**
|
* version of the protocol. This field is currently not useful.
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("version of the protocol. This field is currently not useful.")
|
private String version;
|
/**
|
* Control of the drone, A control or B control.
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("Control of the drone, A control or B control.")
|
private String deviceIndex;
|
/**
|
* The device controlled by the gateway.
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("The device controlled by the gateway.")
|
private String childSn;
|
/**
|
* The time when the device is bound to the workspace.
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("The time when the device is bound to the workspace.")
|
private Long boundTime;
|
/**
|
* The status when the device is bound to the workspace. 1: bound; 0: not bound;
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("The status when the device is bound to the workspace. 1: bound; 0: not bound;")
|
private Boolean boundStatus;
|
/**
|
* The time of the last device login.
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("The time of the last device login.")
|
private Long loginTime;
|
/**
|
*
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("")
|
private String deviceDesc;
|
/**
|
* The icon displayed on the remote control.
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("The icon displayed on the remote control.")
|
private String urlNormal;
|
/**
|
* The icon displayed on the remote control when it is selected.
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("The icon displayed on the remote control when it is selected.")
|
private String urlSelect;
|
/**
|
* 保护区ID
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("保护区ID")
|
private String reserveId;
|
/**
|
* 相机名称
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("相机名称")
|
private String creamaName;
|
/**
|
* 机巢编号
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("机巢编号")
|
private String machineNestSn;
|
/**
|
* 飞机操控密码
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("飞机操控密码")
|
private String operatePassword;
|
/**
|
* 设备状态：{"0":"空闲中","1":"现场调试","2":"远程调试","3":"固件升级中","4":"作业中","5":"待标定"}
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("设备状态：{0:空闲中,1:现场调试,2:远程调试,3:固件升级中,4:作业中,5:待标定}")
|
private Long modeCode;
|
/**
|
* 是否可移动,0=不可移动，1=可移动
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("是否可移动,0=不可移动，1=可移动")
|
private Byte movable;
|
/**
|
* 保险过期时间
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("保险过期时间")
|
private Date insureExpiredTime;
|
/**
|
* 流量剩余类型：0充足，1=流量到期，2=不足
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("流量剩余类型：0充足，1=流量到期，2=不足")
|
private Byte flowType;
|
/**
|
* 维保开始时间
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("维保开始时间")
|
private Date maintenanceStart;
|
/**
|
* 维保结束时间
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("维保结束时间")
|
private Date maintenanceEnd;
|
/**
|
* 保险开始时间
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("保险开始时间")
|
private Date insureStartTime;
|
/**
|
* 设备eid编号
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("设备eid编号")
|
private String eid;
|
/**
|
* 剩余流量(单位:GB)
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("剩余流量(单位:GB)")
|
private BigDecimal trafficRemaining;
|
/**
|
* 流量到期时间
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("流量到期时间")
|
private Date trafficExpireTime;
|
/**
|
* 内部隐藏标识（0-正常，1-下线）
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("内部隐藏标识（0-正常，1-下线）")
|
private Boolean hiddenFlag;
|
/**
|
* 部署模式：0-统一部署，1-独立部署
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("部署模式：0-统一部署，1-独立部署")
|
private Boolean deploymentMode;
|
/**
|
* 绑定机构id
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("绑定机构id")
|
private Long deptId;
|
/**
|
* 是否删除0未删除1已删除
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("是否删除0未删除1已删除")
|
private Integer isDeleted;
|
/**
|
* 行政区域编号
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("行政区域编号")
|
private String areaCode;
|
/**
|
* 4G流量数据
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("4G流量数据")
|
private String trafficData;
|
/**
|
* DEM数据状态：0-未初始化，1-初始化中，2-初始化成功，3-初始化失败
|
*/
|
@ColumnWidth(20)
|
@ExcelProperty("DEM数据状态：0-未初始化，1-初始化中，2-初始化成功，3-初始化失败")
|
private Integer demStatus;
|
|
}
|
