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
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
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;
/**
* @ Description: 用户列表展示dto
* @ Author : 86187
* @ Date : 2021/1/7 10:47
* @author 86187
*/
@Data
@ApiModel(value = "UserInfoDto")
@NoArgsConstructor
@AllArgsConstructor
@Builder
//内容高度
@ContentRowHeight(25)
//表头行高度
@HeadRowHeight(25)
//列的宽度
@ColumnWidth(25)
public class UserInfoDto implements Serializable {
private static final long serialVersionUID = 4791446858538524520L;
/**
* 用户id
*/
@ApiModelProperty(value = "用户id", name = "userId")
private Integer userId;
/**
* 用户名称
*/
@ApiModelProperty(value = "用户名称", name = "userName")
@ExcelProperty(value = "用户名称")
private String userName;
/**
* 性别 0:男 1:女
*/
@ApiModelProperty(value = "性别 0:男 1:女", name = "sex")
@ExcelProperty(value = "性别")
private Integer sex;
/**
* 考生类型 1:文化课考生 2:美术生 3:体育生 4:文学编导考生
*/
@ApiModelProperty(value = "考生类型 1:文化课考生 2:美术生 3:体育生 4:文学编导考生", name = "examType")
@ExcelProperty(value = "考生类型")
private Integer examType;
/**
* 登录来源
*/
@ApiModelProperty(name ="source",value = "登录来源:1 PC,2 WAP")
@ExcelProperty(value = "登录来源")
private Integer source;
/**
* vip用户手机
*/
@ApiModelProperty(value = "vip用户手机", name = "vipMobile")
@ExcelProperty(value = "vip用户手机")
private String vipMobile;
/**
* 手机
*/
@ApiModelProperty(value = "手机号", name = "phone")
@ExcelProperty(value = "手机号")
private String phone;
/**
* 学校
*/
@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 = "moneyAmount")
@ExcelProperty(value = "用户充值总金额")
private String moneyAmount;
/**
* 用户充值次数
*/
@ApiModelProperty(value ="充值卡充值总次数",name = "RechargeTimes")
@ExcelProperty(value = "充值卡充值总次数")
private int rechargeTimes;
/**
* 用户微信充值总金额
*/
@ApiModelProperty(value ="用户微信充值总金额",name = "WeChatMoney")
@ExcelProperty(value = "用户微信充值总金额")
private String weChatMoney;
/**
* 用户支付宝充值总金额
*/
@ApiModelProperty(value ="用户支付宝充值总金额",name = "AlipayMoney")
@ExcelProperty(value = "用户支付宝充值总金额")
private String alipayMoney;
/**
* ip
*/
@ApiModelProperty(value = "ip", name = "ip")
@ExcelProperty(value = "ip")
private String ip;
/**
* 注册时间
*/
@ApiModelProperty(value = "注册时间", name = "registerTime")
@ExcelProperty(value = "注册时间")
private Date registerTime;
/**
* 用户最后登陆时间
*/
@ApiModelProperty(value = "用户最后登陆时间", name = "lastLoginTime")
@ExcelProperty(value = "用户最后登陆时间")
private Date lastLoginTime;
/**
* 员工名称
*/
@ApiModelProperty(name = "staffName",value = "员工名字")
private String staffName;
}