Subversion Repositories SmartDukaan

Rev

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

Rev 23418 Rev 33305
Line 1... Line 1...
1 
package com.spice.profitmandi.dao.entity.dtr;
 1 
package com.spice.profitmandi.dao.entity.dtr;
2 
 
 2 
 
3 
import java.io.Serializable;
 - 
 
4 
import java.time.LocalDateTime;
 3 
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
5 
 
 - 
 
6 
import javax.persistence.Column;
 - 
 
7 
import javax.persistence.Convert;
 - 
 
8 
import javax.persistence.Entity;
 - 
 
9 
import javax.persistence.GeneratedValue;
 4 
import com.spice.profitmandi.dao.model.VerifiedB2CUsersModel;
10 
import javax.persistence.GenerationType;
 - 
 
11 
import javax.persistence.Id;
 - 
 
12 
import javax.persistence.Table;
 - 
 
13 
import javax.persistence.UniqueConstraint;
 - 
 
14 
 
 - 
 
15 
import org.hibernate.annotations.UpdateTimestamp;
 5 
import org.hibernate.annotations.UpdateTimestamp;
16 
 
 6 
 
- 
 
 7 
import javax.persistence.*;
- 
 
 8 
import java.io.Serializable;
17 
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
 9 
import java.time.LocalDateTime;
18 
 
 10 
 
19 
 
 11 
 
20 
/**
 12 
/**
21 
 * This is used to store information of end user.
 13 
 * This is used to store information of end user.
22 
 * @author ashikali
 14 
 * @author ashikali
23 
 *
 15 
 *
24 
 */
 16 
 */
25 
@Entity(name = "dtrUser")
 17 
@Entity(name = "dtrUser")
26 
@Table(name="dtr.users", uniqueConstraints = {@UniqueConstraint(columnNames = {"email","mobile_number"})})
 18 
@Table(name="dtr.users", uniqueConstraints = {@UniqueConstraint(columnNames = {"email","mobile_number"})})
- 
 
 19 
@NamedNativeQueries({
- 
 
 20 
		@NamedNativeQuery(
- 
 
 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 " +
- 
 
 23 
						"FROM dtr.`users` u " +
- 
 
 24 
						"JOIN dtr.otp o on u.mobile_number = o.mobile " +
- 
 
 25 
						"WHERE u.mobile_verified = true AND o.verified = true " +
- 
 
 26 
						"AND date(u.created) BETWEEN :startDate AND :endDate order by u.id desc",
- 
 
 27 
				resultSetMapping = "VerifiedB2CUsersModel"
- 
 
 28 
		)
- 
 
 29 
})
- 
 
 30 
 
- 
 
 31 
@SqlResultSetMappings({
- 
 
 32 
		@SqlResultSetMapping(name = "VerifiedB2CUsersModel", classes = {@ConstructorResult(targetClass = VerifiedB2CUsersModel.class,
- 
 
 33 
				columns = {@ColumnResult(name = "first_name", type = String.class),
- 
 
 34 
						@ColumnResult(name = "last_name", type = String.class),
- 
 
 35 
						@ColumnResult(name = "email", type = String.class),
- 
 
 36 
						@ColumnResult(name = "mobile_number", type = String.class),
- 
 
 37 
						@ColumnResult(name = "city", type = String.class),
- 
 
 38 
						@ColumnResult(name = "pincode", type = Integer.class),
- 
 
 39 
						@ColumnResult(name = "state", type = String.class),
- 
 
 40 
						@ColumnResult(name = "created", type = LocalDateTime.class),
- 
 
 41 
				})}),
- 
 
 42 
 
- 
 
 43 
 
- 
 
 44 
})
- 
 
 45 
 
- 
 
 46 
 
27 
public class User implements Serializable{
 47 
public class User implements Serializable{
28
48
29
49
30 
	private static final long serialVersionUID = 1L;
 50 
	private static final long serialVersionUID = 1L;
31 
 
 51