package com.qxueyou.scc.school.model;

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

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
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;


/**
 * 签到记录明细表  实体
 * @author ody.yuan
 *
 */
@Entity
@Table(name="sch_sign_item")
@NamedQuery(name="SchSignItem.findAll", query="SELECT s FROM SchSignItem s")
public class SchSignItem implements Serializable,ITrace {
	private static final long serialVersionUID = 1L;

	/**  主键 */
	@Id
	@GeneratedValue(generator = "hibernate-uuid")
	@GenericGenerator(name = "hibernate-uuid", strategy = "uuid")
	@Column(name="SIGN_ITEM_ID", unique=true, nullable=false, length=32)
	private String signItemId;

	/**  创建人ID */
	@Column(name="CREATE_ID", nullable=false, length=32)
	@JsonIgnore
	private String createId;

	/**  创建时间 */
	@Column(name="CREATE_TIME", nullable=false)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@JsonIgnore
	private Date createTime;

	/**  创建人 */
	@Column(name="CREATOR", nullable=false, length=100)
	@JsonIgnore
	private String creator;

	/**  删除标志 */
	@Column(name="DELETE_FLAG", nullable=false)
	@JsonIgnore
	private boolean deleteFlag;

	/**  签到地址 */
	@Column(name="SIGN_ADDRESS", length=255)
	private String signAddress;

	/**  签到主表ID */
	@Column(name="SIGN_ID", length=32)
	private String signId;

	/**  签到时间 */
	@Column(name="SIGN_TIME", nullable=false)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	private Date signTime;

	/**  修改人ID */
	@Column(name="UPDATE_ID", length=32)
	@JsonIgnore
	private String updateId;

	/** 修改时间  */
	@Column(name="UPDATE_TIME", nullable=false)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@JsonIgnore
	private Date updateTime;

	/** 修改人  */
	@Column(name="UPDATOR", length=100)
	@JsonIgnore
	private String updator;

	/**  签到用户ID  */
	@Column(name="USER_ID", length=32)
	private String userId;

	/**  签到用户姓名 */
	@Column(name="USER_NAME", length=150)
	private String userName;

	/**   */
	@ManyToOne(cascade = CascadeType.ALL,fetch = FetchType.LAZY)
    @JoinColumn(name = "SIGN_ID",referencedColumnName="SIGN_ID",updatable=false,insertable=false)
	@JsonIgnore
	private SchSign sign;
	
	//最后一次签到时间
	@Transient
	private Date endTime;
	
	//第一次签到排名
	@Transient
	private Short signOrder;
	
	//移动电话
	@Transient
	private String mobilePhone;
	
	//是否已报名
	@Transient
	private String registeFlag;
	
	//是否已下载
	@Transient
	private String installFlag;
	
	public SchSignItem() {
	}
	
	public SchSign getSign() {
		return sign;
	}

	public void setSign(SchSign sign) {
		this.sign = sign;
	}

	public String getSignItemId() {
		return this.signItemId;
	}

	public void setSignItemId(String signItemId) {
		this.signItemId = signItemId;
	}

	public String getCreateId() {
		return this.createId;
	}

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

	public Date getCreateTime() {
		return this.createTime;
	}

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

	public String getCreator() {
		return this.creator;
	}

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

	public boolean getDeleteFlag() {
		return this.deleteFlag;
	}

	public void setDeleteFlag(boolean deleteFlag) {
		this.deleteFlag = deleteFlag;
	}

	public String getSignAddress() {
		return this.signAddress;
	}

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

	public String getSignId() {
		return this.signId;
	}

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

	public Date getSignTime() {
		return this.signTime;
	}

	public void setSignTime(Date signTime) {
		this.signTime = signTime;
	}

	public String getUpdateId() {
		return this.updateId;
	}

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

	public Date getUpdateTime() {
		return this.updateTime;
	}

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

	public String getUpdator() {
		return this.updator;
	}

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

	public String getUserId() {
		return this.userId;
	}

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

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

	public Date getEndTime() {
		return endTime;
	}

	public void setEndTime(Date endTime) {
		this.endTime = endTime;
	}

	public Short getSignOrder() {
		return signOrder;
	}

	public void setSignOrder(Short signOrder) {
		this.signOrder = signOrder;
	}

	public String getMobilePhone() {
		return mobilePhone;
	}

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

	public String getRegisteFlag() {
		return registeFlag;
	}

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

	public String getInstallFlag() {
		return installFlag;
	}

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

}