WarningInstanceExcelData.java 4.09 KB
package com.ash.excelData;

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.ash.base.excelOpt.ExcelCheck;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;
import java.util.Date;

@Data
@ContentRowHeight(15)
@HeadRowHeight(20)
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class WarningInstanceExcelData implements Serializable {
    private static final long serialVersionUID = 1L;

    @ExcelCheck(canEmpty = false, canRepeat = false)
    @ExcelProperty(value = "警情单编号", index = 0)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String code;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "报警时间", index = 1)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private Date alarmDate;

    @ExcelCheck(canEmpty = false, dateFormatValid = "yyyy-MM-dd HH:mm:ss")
    @ExcelProperty(value = "报警电话", index = 2)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String phoneNum;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "所属市局", index = 3)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String municipalPolice;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "所属分县局", index = 4)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String countyPolice;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "管辖单位", index = 5)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String jurisdictionalUnit;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "所属区县", index = 6)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String county;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "事发地址", index = 7)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String address;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "报警内容", index = 8)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String content;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "接警警情类别", index = 9)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String alarmCategory;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "接警警情类型", index = 10)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String alarmType;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "接警警情细类", index = 11)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String alarmTypeDetail;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "接警警情子类", index = 12)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String alarmSubType;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "反馈内容", index = 13)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String feedbackContent;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "警情类别", index = 14)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String category;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "警情类型", index = 15)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String type;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "警情细类", index = 16)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String typeDetail;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "警情子类", index = 17)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String subType;

    @ExcelCheck(canEmpty = false)
    @ExcelProperty(value = "处理结果", index = 18)
    @ContentStyle(dataFormat = 49)
    @ColumnWidth(25)
    private String result;


}