WarningInstanceExcelData.java
4.09 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
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;
}