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
package cn.wisenergy.model.dto;
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 io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.io.Serializable;
import java.util.Date;
@Data
@ApiModel(value = "UserDto")
@NoArgsConstructor
@AllArgsConstructor
@Builder
//内容高度
@ContentRowHeight(25)
//表头行高度
@HeadRowHeight(25)
//列的宽度
@ColumnWidth(25)
public class UserDto implements Serializable {
private static final long serialVersionUID = 68008573682224495L;
/**
* 注册时间
*/
@ApiModelProperty(value = "注册时间", name = "registerTime")
@ExcelProperty(value = "注册时间")
private Date registerTime;
/**
* 登录来源
*/
@ApiModelProperty(name ="source",value = "登录来源：1 PC,2 WAP")
@ExcelProperty(value = "注册来源")
private String source;
/**
* 用户名称
*/
@ApiModelProperty(value = "用户名称", name = "userName")
@ExcelProperty(value = "用户名称")
private String userName;
/**
* 性别 0：男 1：女
*/
@ApiModelProperty(value = "性别 0：男 1：女", name = "sex")
@ExcelProperty(value = "性别")
private String sex;
/**
* 考生类型 1：文化课考生 2：美术生 3：体育生 4：文学编导考生
*/
@ApiModelProperty(value = "考生类型 1：文化课考生 2：美术生 3：体育生 4：文学编导考生", name = "examType")
@ExcelProperty(value = "考生类型")
private String examType;
/**
* 手机
*/
@ApiModelProperty(value = "手机号", name = "phone")
@ExcelProperty(value = "手机号")
private String phone;
/**
* vip手机号
*/
@ApiModelProperty(value = "vip手机号", name = "vipMobile")
@ExcelProperty(value = "vip手机号")
private String vipMobile;
/**
* 学校
*/
@ApiModelProperty(name = "school", value = "毕业院校")
@ExcelProperty(value = "毕业院校")
private String school;
/**
* 文化成绩
*/
@ApiModelProperty(value = "文化成绩", name = "cultureGrade")
@ExcelProperty(value = "文化成绩")
private String cultureGrade;
/**
* 专业成绩
*/
@ApiModelProperty(value = "专业成绩", name = "majorGrade")
@ExcelProperty(value = "专业成绩")
private String majorGrade;
/**
* 用户剩余查询次数
*/
@ApiModelProperty(value = "用户剩余查询次数", name = "queryLimit")
@ExcelProperty(value = "用户剩余查询次数")
private Integer queryLimit;
/**
* 用户微信充值总金额
*/
@ApiModelProperty(value ="用户微信充值总金额",name = "WeChatMoney")
@ExcelProperty(value = "用户微信充值总金额")
private String weChatMoney;
/**
* 用户支付宝充值总金额
*/
@ApiModelProperty(value ="用户支付宝充值总金额",name = "AlipayMoney")
@ExcelProperty(value = "用户支付宝充值总金额")
private String alipayMoney;
/**
* 用户充值次数
*/
@ApiModelProperty(value ="充值卡充值总次数",name = "RechargeTimes")
@ExcelProperty(value = "充值卡充值总次数")
private int rechargeTimes;
/**
* 用户最后登陆时间
*/
@ApiModelProperty(value = "用户最后登陆时间", name = "lastLoginTime")
@ExcelProperty(value = "用户最后登陆时间")
private Date lastLoginTime;
}