/* * 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; /** * 设备维护状态{0:无需保养,1:待保养,2:正在保养} */ @ColumnWidth(20) @ExcelProperty("设备维护状态{0:无需保养,1:待保养,2:正在保养}") private Integer maintenanceState; }