青羊经侦大队-数据平台
wl
2022-07-21 48e1a3658117ebda9270d87092cfb0d31a634b92
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
package com.example.jz.modle.vo;
 
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.alibaba.excel.enums.BooleanEnum;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.alibaba.excel.enums.poi.VerticalAlignmentEnum;
import com.alibaba.excel.metadata.data.ImageData;
import com.alibaba.excel.metadata.data.WriteCellData;
import io.swagger.annotations.ApiModel;
import lombok.Data;
 
import java.util.Date;
import java.util.List;
 
@Data
@ApiModel(description = "导出excel报案材料", value = "ExportExcelReportVo")
@ContentRowHeight(120)
@HeadRowHeight(20)
@ColumnWidth(25)
public class ExportExcelReportVo {
 
    @ExcelProperty(value = "报案人", index = 0)
    @ContentStyle(wrapped = BooleanEnum.TRUE, horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER)
    private String realName;
 
    @ExcelProperty(value = "手机号码", index = 1)
    @ContentStyle(wrapped = BooleanEnum.TRUE, horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER)
    private String userMobile;
 
    @ExcelProperty(value = "身份证号", index = 2)
    @ContentStyle(wrapped = BooleanEnum.TRUE, horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER)
    private String userIdcard;
    //被骗时间
    @ExcelProperty(value = "被骗时间", index = 3)
    @ContentStyle(wrapped = BooleanEnum.TRUE, horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER)
    private Date cheatTime;
 
    //涉案金额
    @ExcelProperty(value = "涉案金额", index = 4)
    @ContentStyle(wrapped = BooleanEnum.TRUE, horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER)
    private Double amountInvolved;
 
    @ExcelProperty(value = "案件描述",index = 5)
    @ContentStyle(wrapped = BooleanEnum.TRUE, horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER)
    private String reportDescription;
    //补充信息
    @ExcelProperty(value = "补充信息", index = 6)
    @ContentStyle(wrapped = BooleanEnum.TRUE, horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER)
    private String information;
 
    @ExcelProperty(value = "案件材料", index = 7)
    @ColumnWidth(120)
    private WriteCellData<List<ImageData>> writeCellData;
}