Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity.dtr;

import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;

import com.spice.profitmandi.dao.model.VerifiedB2CUsersModel;

import org.hibernate.annotations.UpdateTimestamp;

import javax.persistence.*;

import java.io.Serializable;

import java.time.LocalDateTime;

/**

 * This is used to store information of end user.

 * @author ashikali

 *

 */

@Entity(name = "dtrUser")

@Table(name="dtr.users", uniqueConstraints = {@UniqueConstraint(columnNames = {"email","mobile_number"})})

@NamedNativeQueries({

		@NamedNativeQuery(

				name = "User.b2cVerifiedUsersList",

				query = "SELECT u.first_name, u.last_name, u.email, u.mobile_number, u.city, u.pincode, u.state, u.created " +

						"FROM dtr.`users` u " +

						"JOIN dtr.otp o on u.mobile_number = o.mobile " +

						"WHERE o.verified = true " +

						"AND date(u.created) BETWEEN :startDate AND :endDate order by u.id desc",

				resultSetMapping = "VerifiedB2CUsersModel"

		)

})

@SqlResultSetMappings({

		@SqlResultSetMapping(name = "VerifiedB2CUsersModel", classes = {@ConstructorResult(targetClass = VerifiedB2CUsersModel.class,

				columns = {@ColumnResult(name = "first_name", type = String.class),

						@ColumnResult(name = "last_name", type = String.class),

						@ColumnResult(name = "email", type = String.class),

						@ColumnResult(name = "mobile_number", type = String.class),

						@ColumnResult(name = "city", type = String.class),

						@ColumnResult(name = "pincode", type = Integer.class),

						@ColumnResult(name = "state", type = String.class),

						@ColumnResult(name = "created", type = LocalDateTime.class),

				})}),

})

public class User implements Serializable{

	private static final long serialVersionUID = 1L;

	public User(){

	}

	@Id

	@Column(name="id",updatable=false, unique=true)

	@GeneratedValue(strategy = GenerationType.IDENTITY)

	private int id;

	@Column(name = "first_name", length = 64, nullable = false)

	private String firstName;

	@Column(name = "last_name", length = 64, nullable = false)

	private String lastName;

	@Column(length=25,name="email",unique=true)

	private String emailId;

	@Column(length = 25, name = "secondry_email_id", unique = true)

	private String secondryEmailId;

	@Column(length = 10, name = "mobile_number")

	private String mobileNumber;

	@Column(name = "city", length = 128)

	private String city;

	@Column(name = "pincode", length = 6)

	private Integer pinCode;

	private String state;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name="created",updatable=false)

	private LocalDateTime createTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name="modified")

	@UpdateTimestamp

	private LocalDateTime updateTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name="activation_time")

	private LocalDateTime activationTime;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name="login_timestamp")

	private LocalDateTime loginTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name="logout_timestamp")

	private LocalDateTime logoutTimestamp;

	public LocalDateTime getActivationTime() {

		return activationTime;

	}

	public void setActivationTime(LocalDateTime activationTime) {

		this.activationTime = activationTime;

	}

	public int getStatus() {

		return status;

	}

	private String username;

	private String password;

	private boolean mobile_verified;

	private String referral_url;

	private String referrer;

	private int group_id;

	@Column(columnDefinition="tinyint(1) default 0")

	private int status;

	@Column(columnDefinition="tinyint(1) default 0")

	private boolean activated;

	public LocalDateTime getLoginTimestamp() {

		return loginTimestamp;

	}

	public void setLoginTimestamp(LocalDateTime loginTimestamp) {

		this.loginTimestamp = loginTimestamp;

	}

	public LocalDateTime getLogoutTimestamp() {

		return logoutTimestamp;

	}

	public void setLogoutTimestamp(LocalDateTime logoutTimestamp) {

		this.logoutTimestamp = logoutTimestamp;

	}

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	public String getFirstName() {

		return firstName;

	}

	public void setFirstName(String firstName) {

		this.firstName = firstName;

	}

	public String getLastName() {

		return lastName;

	}

	public void setLastName(String lastName) {

		this.lastName = lastName;

	}

	public String getEmailId() {

		return emailId;

	}

	public void setEmailId(String emailId) {

		this.emailId = emailId;

	}

	public String getSecondryEmailId() {

		return secondryEmailId;

	}

	public void setSecondryEmailId(String secondryEmailId) {

		this.secondryEmailId = secondryEmailId;

	}

	public String getMobileNumber() {

		return mobileNumber;

	}

	public void setMobileNumber(String mobileNumber) {

		this.mobileNumber = mobileNumber;

	}

	public String getCity() {

		return city;

	}

	public void setCity(String city) {

		this.city = city;

	}

	public Integer getPinCode() {

		return pinCode;

	}

	public void setPinCode(Integer pinCode) {

		this.pinCode = pinCode;

	}

	public LocalDateTime getCreateTimestamp() {

		return createTimestamp;

	}

	public void setCreateTimestamp(LocalDateTime createTimestamp) {

		this.createTimestamp = createTimestamp;

	}

	public LocalDateTime getUpdateTimestamp() {

		return updateTimestamp;

	}

	public void setUpdateTimestamp(LocalDateTime updateTimestamp) {

		this.updateTimestamp = updateTimestamp;

	}

	public String getUsername() {

		return username;

	}

	public void setUsername(String username) {

		this.username = username;

	}

	public String getPassword() {

		return password;

	}

	public void setPassword(String password) {

		this.password = password;

	}

	public boolean isMobile_verified() {

		return mobile_verified;

	}

	public void setMobile_verified(boolean mobile_verified) {

		this.mobile_verified = mobile_verified;

	}

	public String getReferral_url() {

		return referral_url;

	}

	public void setReferral_url(String referral_url) {

		this.referral_url = referral_url;

	}

	public int getGroup_id() {

		return group_id;

	}

	public void setGroup_id(int group_id) {

		this.group_id = group_id;

	}

	public String getReferrer() {

		return referrer;

	}

	public void setReferrer(String referrer) {

		this.referrer = referrer;

	}

	public int isStatus() {

		return status;

	}

	public void setStatus(int status) {

		this.status = status;

	}

	public boolean isActivated() {

		return activated;

	}

	public void setActivated(boolean activated) {

		this.activated = activated;

	}

	public String getState() {

		return state;

	}

	public void setState(String state) {

		this.state = state;

	}

	@Override

	public int hashCode() {

		final int prime = 31;

		int result = 1;

		result = prime * result + id;

		return result;

	}

	@Override

	public boolean equals(Object obj) {

		if (this == obj)

			return true;

		if (obj == null)

			return false;

		if (getClass() != obj.getClass())

			return false;

		User other = (User) obj;

		if (id != other.id)

			return false;

		return true;

	}

	@Override

	public String toString() {

		return "User [id=" + id + ", firstName=" + firstName + ", lastName=" + lastName + ", emailId=" + emailId

				+ ", secondryEmailId=" + secondryEmailId + ", mobileNumber=" + mobileNumber + ", city=" + city

				+ ", pinCode=" + pinCode + ", state=" + state + ", createTimestamp=" + createTimestamp

				+ ", updateTimestamp=" + updateTimestamp + ", activationTime=" + activationTime + ", loginTimestamp="

				+ loginTimestamp + ", logoutTimestamp=" + logoutTimestamp + ", username=" + username + ", password="

				+ password + ", mobile_verified=" + mobile_verified + ", referral_url=" + referral_url + ", referrer="

				+ referrer + ", group_id=" + group_id + ", status=" + status + ", activated=" + activated + "]";

	}

}