package com.qxueyou.scc.school.model;
// Generated 2015-8-20 16:41:37 by Hibernate Tools 4.0.0

import java.math.BigDecimal;
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.Temporal;
import javax.persistence.TemporalType;
import javax.persistence.Transient;

import org.hibernate.annotations.Formula;
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_rank_his")
@NamedQuery(name="SchRankHis.findAll", query="SELECT s FROM SchRankHis s")
public class SchRankHis implements java.io.Serializable,ITrace {
	
	/**
	 * 
	 */
	private static final long serialVersionUID = -3377176468950409846L;

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

	/**  排名 */	
	@Column(name = "RANK")
	private Integer rank;

	/**  排名依据 */
	@Column(name = "VALUE", precision = 20, scale = 6)
	private BigDecimal value;

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

	/**  用户姓名 */
	@Formula("(select u.NAME from USER u WHERE u.USER_ID=USER_ID)")
	private String name;

	/**  用户头像 */
	@Formula("(select u.IMG_PATH from USER u WHERE u.USER_ID=USER_ID)")
	private String imgPath;

	/**  版本ID */
	@Column(name = "VERSION_ID", length = 32)
	private String versionId;

	/**  排名时间 */
	@Temporal(TemporalType.TIMESTAMP)
	@Column(name = "RANK_TIME", nullable = false, length = 19)
	private Date rankTime;

	/**  学习排名主键  */
	@Column(name = "RANK_ID", length = 32)
	private String rankId;

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

	/** 修改时间  */
	@Column(name="UPDATE_TIME", nullable=false)
	@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;
	
	/**  全站排名百分比  */
	@Transient
	private BigDecimal percentages;
	
	/** 等级  */
	@Transient
	private String level;
	
	public String getLevel() {
		return level;
	}

	public void setLevel(String level) {
		this.level = level;
	}

	public BigDecimal getPercentages() {
		return percentages;
	}

	public void setPercentages(BigDecimal percentages) {
		this.percentages = percentages;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public void setImgPath(String imgPath) {
		this.imgPath = imgPath;
	}

	public String getImgPath() {
		return imgPath;
	}

	public String getHisRankId() {
		return this.hisRankId;
	}

	public void setHisRankId(String hisRankId) {
		this.hisRankId = hisRankId;
	}

	public Integer getRank() {
		return this.rank;
	}

	public void setRank(Integer rank) {
		this.rank = rank;
	}

	public BigDecimal getValue() {
		return this.value;
	}

	public void setValue(BigDecimal value) {
		this.value = value;
	}

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

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

	public Date getRankTime() {
		return this.rankTime;
	}

	public void setRankTime(Date rankTime) {
		this.rankTime = rankTime;
	}

	public String getRankId() {
		return this.rankId;
	}

	public void setRankId(String rankId) {
		this.rankId = rankId;
	}

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

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

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

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

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

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

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

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

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

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

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

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

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

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

	public String getVersionId() {
		return versionId;
	}

	public void setVersionId(String versionId) {
		this.versionId = versionId;
	}

}