package com.qxueyou.scc.exercise.model;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import javax.persistence.Transient;

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

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


/**
 * The persistent class for the exercise_exam database table.
 * 
 */
@Entity
@Table(name="exercise_info")
@NamedQuery(name="ExerciseInfo.findAll", query="SELECT e FROM ExerciseInfo e")
public class ExerciseInfo implements Serializable, ITrace {
	private static final long serialVersionUID = 1L;
	
	//作业类型   1：答题作业，2：文件作业，3：写作作业
	public static final short EXERCISE_TYPE_ANSWER = 1;
	public static final short EXERCISE_TYPE_FILE = 2;
	public static final short EXERCISE_TYPE_WRITING = 3;
	
	//文件作业提交作业类型  1 图片； 2 文档 ； 3 视频 ； 4 音频； 5 附件
	public static final short EXERCISE_FILE_COMMIT_IMG = 1;
	public static final short EXERCISE_FILE_COMMIT_DOC = 2;
	public static final short EXERCISE_FILE_COMMIT_VIDEO = 3;
	public static final short EXERCISE_FILE_COMMIT_AUDIO = 4;
	public static final short EXERCISE_FILE_COMMIT_ATTACH = 5;
	
	
	//文件作业状态
	public static final short EXERCISE_STATUS_DRAFT = 0;
	public static final short EXERCISE_STATUS_PUBLISHED = 1;
	
	@Id
	@Column(name="EXERCISE_INFO_ID", unique=true, nullable=false, length=32)
	private String exerciseInfoId;

	@Column(name="CREATE_ID")
	private String createId;

	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@Column(name="CREATE_TIME")
	private Date createTime;

	private String creator;

	@DateTimeFormat(pattern = "yyyy-MM-dd")
	private Date date;

	@Column(name="DELETE_FLAG")
	private boolean deleteFlag;

	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm")
	@Column(name="end_time")
	private Date endTime;

	private String name;

	@Column(name="org_id")
	private String orgId;
	
	
	@Column(name="subject_id")
	private String subjectId;
	
	@Column(name="CLASS_COUNT")
	private Integer classCount;
	
	@Column(name="PASSING_SCORE")
	private BigDecimal passingScore;

	@Column(name="REMIND")
	private String  remind;
	
	private Double score = 0.0;

	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm")
	@Column(name="start_time")
	private Date startTime;

	private short type;
	
	@Column(name="status")
	private short status;

	@Column(name="UPDATE_ID")
	private String updateId;

	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@Column(name="UPDATE_TIME")
	private Date updateTime;
	
	@Column(name="COMMIT_UPLOAD_TYPE")
	private short commitUploadType;
	
	@OneToMany(fetch = FetchType.LAZY, mappedBy = "exerciseInfo")
	@Where(clause="DELETE_FLAG=0")
	private List<ExerciseItemSet> exerciseItemSets;
	
	@ManyToOne(cascade = CascadeType.ALL,fetch = FetchType.LAZY)
	@JoinColumn(name = "SUBJECT_ID",referencedColumnName="SUBJECT_ID",updatable=false,insertable=false)
	@JsonIgnore
	private Subject subject;
	
	//关联的题库信息
	@OneToMany(fetch = FetchType.LAZY, mappedBy = "exerciseInfo")
	@Where(clause="DELETE_FLAG=0 AND TYPE=1 ")
	private List<ExerciseExamReGroup> reGroups;
	
	//关联的班级信息
	@OneToMany(fetch = FetchType.LAZY, mappedBy = "exerciseInfo")
	@Where(clause="DELETE_FLAG=0")
	private List<ExerciseExamReClass> reClasses;
	
	private String updator;
	
	@Transient
	private String uploadPath;
	
	@Transient
	private String subjectName;
	
	public List<ExerciseItemSet> getExerciseItemSets() {
		return exerciseItemSets;
	}

	public void setExerciseItemSets(List<ExerciseItemSet> exerciseItemSets) {
		this.exerciseItemSets = exerciseItemSets;
	}

	public List<ExerciseExamReGroup> getReGroups() {
		return reGroups;
	}

	public void setReGroups(List<ExerciseExamReGroup> reGroups) {
		this.reGroups = reGroups;
	}

	public List<ExerciseExamReClass> getReClasses() {
		return reClasses;
	}

	public void setReClasses(List<ExerciseExamReClass> reClasses) {
		this.reClasses = reClasses;
	}

	public short getCommitUploadType() {
		return commitUploadType;
	}

	public void setCommitUploadType(short commitUploadType) {
		this.commitUploadType = commitUploadType;
	}

	public BigDecimal getPassingScore() {
		return passingScore;
	}

	public void setPassingScore(BigDecimal passingScore) {
		this.passingScore = passingScore;
	}

	public Integer getClassCount() {
		return classCount;
	}

	public void setClassCount(Integer classCount) {
		this.classCount = classCount;
	}

	public Double getScore() {
		return score;
	}

	public void setScore(Double score) {
		this.score = score;
	}

	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 Date getDate() {
		return this.date;
	}

	public void setDate(Date date) {
		this.date = date;
	}

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

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

	public Date getEndTime() {
		return this.endTime;
	}

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

	public String getName() {
		return this.name;
	}

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

	public String getOrgId() {
		return this.orgId;
	}

	public void setOrgId(String orgId) {
		this.orgId = orgId;
	}

//	public String getSourceGroupId() {
//		return this.sourceGroupId;
//	}
//
//	public void setSourceGroupId(String sourceGroupId) {
//		this.sourceGroupId = sourceGroupId;
//	}

	public Date getStartTime() {
		return this.startTime;
	}

	public void setStartTime(Date startTime) {
		this.startTime = startTime;
	}

	public short getType() {
		return this.type;
	}

	public void setType(short type) {
		this.type = type;
	}

	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 short getStatus() {
		return status;
	}

	public void setStatus(short status) {
		this.status = status;
	}

	public String getExerciseInfoId() {
		return exerciseInfoId;
	}

	public void setExerciseInfoId(String exerciseInfoId) {
		this.exerciseInfoId = exerciseInfoId;
	}

	public String getSubjectId() {
		return subjectId;
	}

	public void setSubjectId(String subjectId) {
		this.subjectId = subjectId;
	}

	public String getRemind() {
		return remind;
	}

	public void setRemind(String remind) {
		this.remind = remind;
	}

	public String getUploadPath() {
		return uploadPath;
	}

	public void setUploadPath(String uploadPath) {
		this.uploadPath = uploadPath;
	}
	
	public Subject getSubject() {
		return subject;
	}

	public void setSubject(Subject subject) {
		this.subject = subject;
	}

	public String getSubjectName() {
		return subjectName;
	}

	public void setSubjectName(String subjectName) {
		this.subjectName = subjectName;
	}
	
	
	
	
	
}