/* * 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.util.Date; /** * 工单任务表 Excel实体类 * * @author lw * @since 2026-01-14 */ @Data @ColumnWidth(25) @HeadRowHeight(20) @ContentRowHeight(18) public class GdWorkOrderExcel implements Serializable { private static final long serialVersionUID = 1L; /** * 工单名称 */ @ColumnWidth(20) @ExcelProperty("工单名称") private String workOrderName; /** * 工单编号(唯一) */ @ColumnWidth(20) @ExcelProperty("工单编号(唯一)") private String workOrderCode; /** * 工单类型(巡查类/安检类等) */ @ColumnWidth(20) @ExcelProperty("工单类型(巡查类/安检类等)") private String workOrderType; /** * 设备负载需求(红外、喊话器、探照灯) */ @ColumnWidth(20) @ExcelProperty("设备负载需求(红外、喊话器、探照灯)") private String deviceLoadDemand; /** * 推荐设备ID(逗号分隔) */ @ColumnWidth(20) @ExcelProperty("推荐设备ID(逗号分隔)") private String recommendDeviceIds; /** * 工单状态:0草稿、10发布中_接单中、11发布中_拒绝接单、20响应中_待拆分、21响应中_申请取消、22响应中_申请修改、23响应中_已取消、30执行中_待全部完成、31执行中_协商修改、40完成待验_待全部验收、50验收通过_待结算、60结算完成_已结算 */ @ColumnWidth(20) @ExcelProperty("工单状态:0草稿、10发布中_接单中、11发布中_拒绝接单、20响应中_待拆分、21响应中_申请取消、22响应中_申请修改、23响应中_已取消、30执行中_待全部完成、31执行中_协商修改、40完成待验_待全部验收、50验收通过_待结算、60结算完成_已结算") private Byte workOrderStatus; /** * 执行时间范围-开始 */ @ColumnWidth(20) @ExcelProperty("执行时间范围-开始") private Date executeStartTime; /** * 执行时间范围-结束 */ @ColumnWidth(20) @ExcelProperty("执行时间范围-结束") private Date executeEndTime; /** * 服务方(审核人) */ @ColumnWidth(20) @ExcelProperty("服务方(审核人)") private String serviceParty; /** * 备注 */ @ColumnWidth(20) @ExcelProperty("备注") private String remark; /** * 区域编码 */ @ColumnWidth(20) @ExcelProperty("区域编码") private String areaCode; /** * 删除标志(0存在 1删除) */ @ColumnWidth(20) @ExcelProperty("删除标志(0存在 1删除)") private Byte isDeleted; }