package com.qxueyou.scc.school.model;

import java.io.Serializable;
import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.persistence.Transient;

import org.hibernate.annotations.GenericGenerator;
import org.springframework.format.annotation.DateTimeFormat;

import com.qxueyou.scc.base.model.ITrace;
import com.fasterxml.jackson.annotation.JsonIgnore;


/**
 * The persistent class for the sch_sign_item database table. 签到次序表
 * 
 */
@Entity
@Table(name="sch_sign_statistics")
@NamedQuery(name="SchSignStatistics.findAll", query="SELECT s FROM SchSignStatistics s")
public class SchSignStatistics implements Serializable,ITrace {

	private static final long serialVersionUID = 1L;

	@Id
	@GeneratedValue(generator = "hibernate-uuid")
	@GenericGenerator(name = "hibernate-uuid", strategy = "uuid")
	@Column(name="SIGN_STATISTICS_ID", unique=true, nullable=false, length=32)
	private String signStatisticsId;
	
	/** 签到终端类型： 1：Q学友；  2： 微信 */
	public static final short TERMINAL_TYPE_QXUEYOU = 1;
	
	public static final short TERMINAL_TYPE_WECHAT = 2;
	
	/** 签到状态类型： 1：正常；  2： 迟到  ；3：早退；4：未签到*/
	public static final short SIGN_STATUS_NORMAL = 1;
	
	public static final short SIGN_STATUS_LATE = 2;
	
	/** 是否统计 1是2否 **/
	public static final int STATISTICS_FLAG_YES = 1;
	
	public static final int STATISTICS_FLAG_NO = 2;
	
	public static final short SIGN_STATUS_EARLY = 3;
	
	public static final short SIGN_STATUS_NO = 4;
	
	/** 用户ID */
	@Column(name="USER_ID", length=32)
	private String userId;
	
	/** 用户姓名 */
	@Column(name="USER_NAME", length=150)
	private String userName;

	/** 手机号码 */
	@Column(name="MOBILE_PHONE", length=15)
	private String mobilePhone;

	/** 签到ID */
	@Column(name="SIGN_ID", length=32)
	private String signId;
	
	/** 签到时间 */
	@Column(name="SIGN_DATE")
	@DateTimeFormat(pattern = "yyyy-MM-dd")
	private Date signDate;
	
	/** 上课签到时间 */
	@Column(name="FIRST_SIGN_TIME")
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	private Date firstSignTime;
	
	/** 上课签到排名 */
	@Column(name="FIRST_SIGN_ORDER")
	private Integer firstSignOrder;
	
	/** 上课签到状态 */
	@Column(name = "FIRST_SIGN_STATUS")
	private Short firstSignStatus;
	
	/** 下课签到时间 */
	@Column(name="LAST_SIGN_TIME")
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	private Date lastSignTime;
	
	/** 下课签到排名，未使用 */
	@Column(name="LAST_SIGN_ORDER")
	private Integer lastSignOrder;
	
	/** 下课签到状态 */
	@Column(name = "LAST_SIGN_STATUS")
	private Short lastSignStatus;
	
	/** 签到地址 */
	@Column(name="SIGN_ADDRESS", length=255)
	private String signAddress;
	
	/** 签到类型：q学友 Or 微信 */
	@Column(name="TERMINAL_TYPE", length=255)
	private Short terminalType;
	
	/** 是否当前班级激活学员  */
	@Column(name="REGISTE_FLAG", length=255)
	private boolean registeFlag;
	
	/** 是否有登录过q学友  */
	@Column(name="INSTALL_FLAG", length=255)
	private boolean installFlag;
	
	/** 创建时间 */
	@Column(name="CREATE_TIME", nullable=false)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	private Date createTime;
	
	/** 修改时间 */
	@Column(name="UPDATE_TIME")
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@JsonIgnore
	private Date updateTime;
	
	/** 创建人 */
	@Column(name="CREATOR", nullable=false, length=100)
	@JsonIgnore
	private String creator;
	
	/** 创建人ID */
	@Column(name="CREATE_ID", nullable=false, length=32)
	@JsonIgnore
	private String createId;
	
	/** 修改人 */
	@Column(name="UPDATOR", length=100)
	@JsonIgnore
	private String updator;
	
	/** 修改人ID */
	@Column(name="UPDATE_ID", length=32)
	@JsonIgnore
	private String updateId;

	/** 删除标志 */
	@Column(name="DELETE_FLAG", nullable=false)
	@JsonIgnore
	private boolean deleteFlag;
	
	/** 是否统计 */
	@Column(name="STATISTICS_FLAG", length=1)
	private int statisticsFlag;
	
	/** 位置经度纬度 */
	@Column(name="POSITION", length=20)
	private String position;
	
	/** 距离 */
	@Column(name="OUT_OF_RANGE", length=10)
	private double outOfRange;

	/** 班级课程ID  */
	@Column(name="CLASS_SUBJECT_ID", length=32)
	private String classSubjectId;
	
	/** 班级课程name  */
	@Column(name="CLASS_SUBJECT_NAME", length=32)
	private String classSubjectName;

	/**公司名*/
	@Transient
	private String companyName;
	
	@Transient
	private Integer signType;
	
	@Transient
	private String userImgPath;
	
	@Transient
	private String attribute1;
	
	@Transient
	private String sex;
	
	@Transient
	private String className;
	
	@Transient
	private String salesCode;
	
	@Transient
	private String regTime;
	
	@Transient
	private String activationTime;
	
	public String getActivationTime() {
		return activationTime;
	}

	public void setActivationTime(String activationTime) {
		this.activationTime = activationTime;
	}

	public int getStatisticsFlag() {
		return statisticsFlag;
	}

	public void setStatisticsFlag(int statisticsFlag) {
		this.statisticsFlag = statisticsFlag;
	}

	public String getPosition() {
		return position;
	}

	public void setPosition(String position) {
		this.position = position;
	}

	public double getOutOfRange() {
		return outOfRange;
	}

	public void setOutOfRange(double outOfRange) {
		this.outOfRange = outOfRange;
	}

	public Date getSignDate() {
		return signDate;
	}

	public void setSignDate(Date signDate) {
		this.signDate = signDate;
	}

	public String getClassSubjectId() {
		return classSubjectId;
	}

	public void setClassSubjectId(String classSubjectId) {
		this.classSubjectId = classSubjectId;
	}

	public String getClassSubjectName() {
		return classSubjectName;
	}

	public void setClassSubjectName(String classSubjectName) {
		this.classSubjectName = classSubjectName;
	}

	public String getSex() {
		return sex;
	}

	public void setSex(String sex) {
		this.sex = sex;
	}

	public String getClassName() {
		return className;
	}

	public void setClassName(String className) {
		this.className = className;
	}

	public String getSalesCode() {
		return salesCode;
	}

	public void setSalesCode(String salesCode) {
		this.salesCode = salesCode;
	}

	public String getRegTime() {
		return regTime;
	}

	public void setRegTime(String regTime) {
		this.regTime = regTime;
	}

	public String getSignStatisticsId() {
		return signStatisticsId;
	}

	public void setSignStatisticsId(String signStatisticsId) {
		this.signStatisticsId = signStatisticsId;
	}

	public String getUserId() {
		return userId;
	}

	public void setUserId(String userId) {
		this.userId = userId;
	}

	public String getUserName() {
		return userName;
	}

	public void setUserName(String userName) {
		this.userName = userName;
	}

	public String getMobilePhone() {
		return mobilePhone;
	}

	public void setMobilePhone(String mobilePhone) {
		this.mobilePhone = mobilePhone;
	}

	public String getSignId() {
		return signId;
	}

	public void setSignId(String signId) {
		this.signId = signId;
	}

	public Date getFirstSignTime() {
		return firstSignTime;
	}

	public void setFirstSignTime(Date firstSignTime) {
		this.firstSignTime = firstSignTime;
	}

	public Integer getFirstSignOrder() {
		return firstSignOrder;
	}

	public void setFirstSignOrder(Integer firstSignOrder) {
		this.firstSignOrder = firstSignOrder;
	}

	public Short getFirstSignStatus() {
		return firstSignStatus;
	}

	public void setFirstSignStatus(Short firstSignStatus) {
		this.firstSignStatus = firstSignStatus;
	}

	public Date getLastSignTime() {
		return lastSignTime;
	}

	public void setLastSignTime(Date lastSignTime) {
		this.lastSignTime = lastSignTime;
	}

	public Integer getLastSignOrder() {
		return lastSignOrder;
	}

	public void setLastSignOrder(Integer lastSignOrder) {
		this.lastSignOrder = lastSignOrder;
	}

	public Short getLastSignStatus() {
		return lastSignStatus;
	}

	public void setLastSignStatus(Short lastSignStatus) {
		this.lastSignStatus = lastSignStatus;
	}

	public String getSignAddress() {
		return signAddress;
	}

	public void setSignAddress(String signAddress) {
		this.signAddress = signAddress;
	}

	public Short getTerminalType() {
		return terminalType;
	}

	public void setTerminalType(Short terminalType) {
		this.terminalType = terminalType;
	}

	public boolean isRegisteFlag() {
		return registeFlag;
	}

	public void setRegisteFlag(boolean registeFlag) {
		this.registeFlag = registeFlag;
	}

	public boolean isInstallFlag() {
		return installFlag;
	}

	public void setInstallFlag(boolean installFlag) {
		this.installFlag = installFlag;
	}

	public Date getCreateTime() {
		return createTime;
	}

	public void setCreateTime(Date createTime) {
		this.createTime = createTime;
	}

	public Date getUpdateTime() {
		return updateTime;
	}

	public void setUpdateTime(Date updateTime) {
		this.updateTime = updateTime;
	}

	public String getCreator() {
		return creator;
	}

	public void setCreator(String creator) {
		this.creator = creator;
	}

	public String getCreateId() {
		return createId;
	}

	public void setCreateId(String createId) {
		this.createId = createId;
	}

	public String getUpdator() {
		return updator;
	}

	public void setUpdator(String updator) {
		this.updator = updator;
	}

	public String getUpdateId() {
		return updateId;
	}

	public void setUpdateId(String updateId) {
		this.updateId = updateId;
	}

	public boolean getDeleteFlag() {
		return deleteFlag;
	}

	public void setDeleteFlag(boolean deleteFlag) {
		this.deleteFlag = deleteFlag;
	}
	
	public String getCompanyName() {
		return companyName;
	}

	public void setCompanyName(String companyName) {
		this.companyName = companyName;
	}

	public String getFirstStatusValue(){
		String value = "";
		if(this.firstSignStatus != null ){
			if(SchSignStatistics.SIGN_STATUS_NORMAL == this.firstSignStatus){
				value = "正常";
			}else if(SchSignStatistics.SIGN_STATUS_LATE == this.firstSignStatus){
				value = "迟到";
			}else if(SchSignStatistics.SIGN_STATUS_NO == this.firstSignStatus){
				value = "未到";
			}
		}
		return value;
	}
	
	public String getLastStatusValue(){
		String value = "";
		if(this.lastSignStatus != null){
			if(SchSignStatistics.SIGN_STATUS_NORMAL == this.lastSignStatus){
				value = "正常";
			}else if(SchSignStatistics.SIGN_STATUS_EARLY == this.lastSignStatus){
				value = "早退";
			}else if(SchSignStatistics.SIGN_STATUS_NO == this.firstSignStatus){
				value = "未到";
			}
		}
		return value;
	}
	
	public String getTerminalTypeValue(){
		String value = "";
		if(this.terminalType != null ){
			if(SchSignStatistics.TERMINAL_TYPE_QXUEYOU == this.terminalType){
				value = "Q学友";
			}else if(SchSignStatistics.TERMINAL_TYPE_WECHAT == this.terminalType){
				value = "微信";
			}
			return value;
		}
		return null;
	}
	
	public String getInstallValue(){
		String value = "否";
		if(this.installFlag){
			value = "是";
		}
		return value;
	}
	
	public String getRegisteValue(){
		String value = "否";
		if(this.registeFlag){
			value = "是";
		}
		return value;
	}

	public Integer getSignType() {
		return signType;
	}

	public void setSignType(Integer signType) {
		this.signType = signType;
	}

	public String getUserImgPath() {
		return userImgPath;
	}

	public void setUserImgPath(String userImgPath) {
		this.userImgPath = userImgPath;
	}

	public String getAttribute1() {
		return attribute1;
	}

	public void setAttribute1(String attribute1) {
		this.attribute1 = attribute1;
	}

	@Override
	public int hashCode() {
		final int prime = 31;
		int result = 1;
		result = prime * result + ((signStatisticsId == null) ? 0 : signStatisticsId.hashCode());
		return result;
	}

	@Override
	public boolean equals(Object obj) {
		if (this == obj){
			return true;
		}
		if (obj == null){
			return false;
		}
		if (getClass() != obj.getClass()){
			return false;
		}
		SchSignStatistics other = (SchSignStatistics) obj;
		if (signStatisticsId == null) {
			if (other.signStatisticsId != null){
				return false;
			}
		} else if (!signStatisticsId.equals(other.signStatisticsId)){
			return false;
		}
		return true;
	}

	
}