Subversion Repositories SmartDukaan

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

import java.io.Serializable;

import java.time.LocalDateTime;

import javax.persistence.Column;

import javax.persistence.Convert;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.Table;

import javax.persistence.UniqueConstraint;

import org.hibernate.annotations.UpdateTimestamp;

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

/**

 * This is used to store information of end user.

 * @author ashikali

 *

 */

@Entity

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

@NamedQueries({

	@NamedQuery(name = "User.selectCount", query = "select count(u) from User u"),

	@NamedQuery(name = "User.selectAll",query="select u from User u"),

	@NamedQuery(name = "User.selectById",query="select u from User u where u.id= :id"),

	@NamedQuery(name = "User.selectByEmailId", query = "select u from User u where u.emailId= :emailId"),

	@NamedQuery(name = "User.selectByMobileNumber", query = "select u from User u where u.mobileNumber= :mobileNumber"),

	@NamedQuery(name = "User.countByEmailId", query = "select count(u) from User u where u.emailId= :emailId"),

	@NamedQuery(name = "User.countByMobileNumber", query = "select count(u) from User u where u.mobileNumber= :mobileNumber"),

	@NamedQuery(name = "User.selectIdAndSololicUserId", query = "select u.id, ua.account_key, u.createTimestamp, u.updateTimestamp from User u join UserAccounts ua on u.id = ua.user_id where ua.account_type = 'saholic'")

})

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 = 10, name = "mobile_number")

	private String mobileNumber;

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

	private String city;

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

	private Integer pinCode;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

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

	private LocalDateTime createTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name="modified")

	@UpdateTimestamp

	private LocalDateTime updateTimestamp;

	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 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 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;

	}

	@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

				+ ", mobileNumber=" + mobileNumber + ", city=" + city + ", pinCode=" + pinCode + ", createTimestamp="

				+ createTimestamp + ", updateTimestamp=" + updateTimestamp + ", username=" + username + ", password="

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

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

	}

}