RechargeAmountDaily.java
3.73 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
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
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
package com.xiniunet.lecunstomization.domain;/**
* Created by zzb on 2018/5/2.
*/
import com.xiniunet.framework.base.BaseDomain;
import java.util.Date;
/**
* @author zzb
* @create 2018-05-02 18:55
* @desc 充值日汇总报表
**/
public class RechargeAmountDaily extends BaseDomain{
/*select DATE_FORMAT(PAYMENT_TIME,'%Y-%m-%d'),MEMBER_ID,m.`NAME`,m.TYPE,sum(c.RECHARGE_AMOUNT) from cus_recharge_detail c
left join membership.mem_member m on m.id = c.MEMBER_ID
group by c.DATE_ID,c.MEMBER_ID*/
private Date paymentTime;
/**
* 会员id
*/
private Long memberId;
/**
* 会员name
*/
private String name;
/**
* 会员类型
*/
private String type;
/**
* 充值金额
*/
private Double rechargeAmount;
/**
* 变更时间
*/
private Date transactionTime;
/**
* 余额消费
*/
private Double transactionAmount;
/**
* 余额消费
*/
private Double freezeAmount;
/**
* 提现金额
*/
private Double withDrawAmount;
/**
* 用券时间
*/
private Date useTime;
/**
* 折扣金额
*/
private Double discountAmount;
/**
* 积分
*/
private Double transactionPoint;
/**
* 根据日期转化的8位纯数字
*/
private Long dateId;
//红包、优惠券类别
private String ticketType;
public Date getPaymentTime() {
return paymentTime;
}
public void setPaymentTime(Date paymentTime) {
this.paymentTime = paymentTime;
}
public Long getMemberId() {
return memberId;
}
public void setMemberId(Long memberId) {
this.memberId = memberId;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public Double getRechargeAmount() {
return rechargeAmount;
}
public void setRechargeAmount(Double rechargeAmount) {
this.rechargeAmount = rechargeAmount;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Date getTransactionTime() {
return transactionTime;
}
public void setTransactionTime(Date transactionTime) {
this.transactionTime = transactionTime;
}
public Double getTransactionAmount() {
return transactionAmount;
}
public void setTransactionAmount(Double transactionAmount) {
this.transactionAmount = transactionAmount;
}
public Double getFreezeAmount() {
return freezeAmount;
}
public void setFreezeAmount(Double freezeAmount) {
this.freezeAmount = freezeAmount;
}
public Double getWithDrawAmount() {
return withDrawAmount;
}
public void setWithDrawAmount(Double withDrawAmount) {
this.withDrawAmount = withDrawAmount;
}
public Date getUseTime() {
return useTime;
}
public void setUseTime(Date useTime) {
this.useTime = useTime;
}
public Double getDiscountAmount() {
return discountAmount;
}
public void setDiscountAmount(Double discountAmount) {
this.discountAmount = discountAmount;
}
public Double getTransactionPoint() {
return transactionPoint;
}
public void setTransactionPoint(Double transactionPoint) {
this.transactionPoint = transactionPoint;
}
public Long getDateId() {
return dateId;
}
public void setDateId(Long dateId) {
this.dateId = dateId;
}
public String getTicketType() {
return ticketType;
}
public void setTicketType(String ticketType) {
this.ticketType = ticketType;
}
}