CaseExportExcelData.java
3.67 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
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.DatetimeConverter;
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 CaseExportExcelData implements Serializable {
private static final long serialVersionUID = 1L;
@ExcelCheck(canEmpty = false, canRepeat = false)
@ExcelProperty(value = "案件标识", index = 0)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private String mark;
@ExcelCheck(canEmpty = false, canRepeat = false)
@ExcelProperty(value = "案件编号", index = 1)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private String code;
@ExcelCheck(canEmpty = false)
@ExcelProperty(value = "案件名称", index = 2)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private String name;
@ExcelCheck(canEmpty = false)
@ExcelProperty(value = "案件详情", index = 3)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private String caseDetail;
@ExcelCheck(canEmpty = false, dateFormatValid = "yyyy-MM-dd HH:mm:ss")
@ExcelProperty(value = "接警时间", index = 4, converter = DatetimeConverter.class)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private Date alarmDate;
@ExcelCheck(canEmpty = false, dateFormatValid = "yyyy-MM-dd HH:mm:ss")
@ExcelProperty(value = "立案时间", index = 5, converter = DatetimeConverter.class)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private Date filingDate;
@ExcelCheck(canEmpty = false)
@ExcelProperty(value = "立案单位", index = 6)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private String filingUnit;
@ExcelCheck(canEmpty = false)
@ExcelProperty(value = "地区", index = 7)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private String area;
@ExcelCheck(canEmpty = false)
@ExcelProperty(value = "县区", index = 8)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private String county;
@ExcelCheck(canEmpty = false)
@ExcelProperty(value = "涉案总金额", index = 9)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private Double totalAmount;
@ExcelCheck(canEmpty = false)
@ExcelProperty(value = "受害人性别", index = 10)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private String sex;
@ExcelCheck(canEmpty = false)
@ExcelProperty(value = "受害人年龄", index = 11)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private Integer age;
@ExcelCheck(canEmpty = false)
@ExcelProperty(value = "受害人职业", index = 12)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private String career;
@ExcelCheck(canEmpty = false)
@ExcelProperty(value = "诈骗类型", index = 13)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private String fraudType;
@ExcelCheck(canEmpty = false)
@ExcelProperty(value = "引流方式", index = 14)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private String rainageMethod;
@ExcelCheck(canEmpty = false)
@ExcelProperty(value = "支付方式", index = 15)
@ContentStyle(dataFormat = 49)
@ColumnWidth(25)
private String payMethod;
}