Subversion Repositories SmartDukaan

Rev

Rev 33305 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 33305 Rev 33308
Line 20... Line 20...
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 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 u.mobile_verified = true AND 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"
28 
		)
 28 
		)
29 
})
 29 
})
30 
 
 30