| Line 17... |
Line 17... |
| 17 |
@Entity(name = "dtrUser")
|
17 |
@Entity(name = "dtrUser")
|
| 18 |
@Table(name="dtr.users", uniqueConstraints = {@UniqueConstraint(columnNames = {"email","mobile_number"})})
|
18 |
@Table(name="dtr.users", uniqueConstraints = {@UniqueConstraint(columnNames = {"email","mobile_number"})})
|
| 19 |
@NamedNativeQueries({
|
19 |
@NamedNativeQueries({
|
| 20 |
@NamedNativeQuery(
|
20 |
@NamedNativeQuery(
|
| 21 |
name = "User.b2cVerifiedUsersList",
|
21 |
name = "User.b2cVerifiedUsersList",
|
| 22 |
query = "SELECT u.first_name, u.last_name, u.email, u.mobile_number, u.city, u.pincode, u.state, u.created " +
|
22 |
query = "SELECT DISTINCT u.first_name, u.last_name, u.email, u.mobile_number, u.city, u.pincode, u.state, u.created " +
|
| 23 |
"FROM dtr.`users` u " +
|
23 |
"FROM dtr.`users` u " +
|
| 24 |
"JOIN dtr.otp o on u.mobile_number = o.mobile " +
|
24 |
"JOIN dtr.otp o on u.mobile_number = o.mobile " +
|
| 25 |
"WHERE o.verified = true " +
|
25 |
"WHERE o.verified = true " +
|
| 26 |
"AND date(u.created) BETWEEN :startDate AND :endDate order by u.id desc",
|
26 |
"AND date(u.created) BETWEEN :startDate AND :endDate order by u.id desc",
|
| 27 |
resultSetMapping = "VerifiedB2CUsersModel"
|
27 |
resultSetMapping = "VerifiedB2CUsersModel"
|