package com.qxueyou.scc.exercise.model;

import java.math.BigDecimal;
import java.util.Date;

import javax.persistence.AttributeOverride;
import javax.persistence.AttributeOverrides;
import javax.persistence.Column;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

import org.springframework.format.annotation.DateTimeFormat;

@Entity
@Table(name = "exercise_result_v")
public class ExerciseResultV implements java.io.Serializable {	

	/**
	 * 
	 */
	private static final long serialVersionUID = 2527653338692282584L;

	@EmbeddedId
	@AttributeOverrides({
			@AttributeOverride(name = "exerciseInfoId", column = @Column(name = "EXERCISE_INFO_ID")),
			@AttributeOverride(name = "studentId", column = @Column(name = "STUDENT_ID")),
			@AttributeOverride(name = "classId", column = @Column(name = "CLASS_ID")),
			})
	private ExerciseResultVId id;
	
	@Column(name="EXERCISE_COMPLETE_ID")
	private String exerciseCompleteId;
	
	@Column(name="EXERCISE_NAME")
	private String exerciseName;
	
	@Column(name="EXERCISE_STATUS")
	private short exerciseStatus;
	
	@Temporal(TemporalType.TIMESTAMP)
	@Column(name = "START_TIME")
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	private Date startTime;
	
	@Temporal(TemporalType.TIMESTAMP)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@Column(name = "END_TIME")
	private Date endTime;
		
	@Column(name = "TYPE")
	private short type;
	
	@Column(name="SCORE")
	private BigDecimal score;
	
	@Column(name="SUBJECT_ID")
	private String subjectId;
	
	@Column(name="SUBJECT_NAME")
	private String subjectName;
	
	@Column(name = "PASSING_SCORE")
	private BigDecimal passingScore;
	
	@Column(name="REMIND")
	private String remind;
	
	@Column(name="TEACHER_ID")
	private String teacherId;
	
	@Column(name="TEACHER_NAME")
	private String teacherName;

	@Temporal(TemporalType.TIMESTAMP)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	@Column(name = "CREATE_TIME")
	private Date createTime;
	
	@Column(name="GROUP_ID")
	private String groupId;
	
	@Temporal(TemporalType.TIMESTAMP)
	@Column(name = "SUBMIT_TIME", nullable = false)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	private Date submitTime;
	
	@Column(name="CLASS_NAME")
	private String className;
	
	@Column(name="STUDENT_NO")
	private String studentNo;
	
	@Column(name="STUDENT_NAME")
	private String studentName;
	
	@Column(name="USER_ID")
	private String userId;
	
	@Column(name="STUDENT_SCORE")
	private BigDecimal studentScore;
	
	@Column(name="COMPLETE_STATUS")
	private short completeStatus;

	@Column(name="FILE_ID")
	private String fileId;
	
	@Column(name="FILE_PATH")
	private String filePath;
		
	@Column(name="TARGET_OBJECT_ID")
	private String targetObjectId;

	@Column(name="TEACHER_COMMENT")
	private String teacherComment;
	
	@Column(name="UPLOAD_DESC")
	private String uploadDesc;
	
	@Column(name = "SEX")
	private short sex;
	
	@Column(name = "MOBILE_PHONE")
	private String mobilePhone;

	public ExerciseResultV() {
	}
	
	public String getStudentName() {
		return studentName;
	}

	public void setStudentName(String studentName) {
		this.studentName = studentName;
	}

	public Date getStartTime() {
		return startTime;
	}

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

	public Date getEndTime() {
		return endTime;
	}

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

	public String getClassName() {
		return className;
	}

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

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

	public BigDecimal getScore() {
		return score;
	}

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

	public BigDecimal getPassingScore() {
		return passingScore;
	}

	public void setPassingScore(BigDecimal passingScore) {
		this.passingScore = passingScore;
	}
	
	public ExerciseResultVId getId() {
		return id;
	}

	public void setId(ExerciseResultVId id) {
		this.id = id;
	}

	public Date getSubmitTime() {
		return submitTime;
	}

	public void setSubmitTime(Date submitTime) {
		this.submitTime = submitTime;
	}

	public String getExerciseName() {
		return exerciseName;
	}

	public void setExerciseName(String exerciseName) {
		this.exerciseName = exerciseName;
	}

	public short getExerciseStatus() {
		return exerciseStatus;
	}

	public void setExerciseStatus(short exerciseStatus) {
		this.exerciseStatus = exerciseStatus;
	}

	public short getType() {
		return type;
	}

	public String getExerciseCompleteId() {
		return exerciseCompleteId;
	}

	public void setExerciseCompleteId(String exerciseCompleteId) {
		this.exerciseCompleteId = exerciseCompleteId;
	}

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

	public String getSubjectId() {
		return subjectId;
	}

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

	public String getSubjectName() {
		return subjectName;
	}

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

	public String getRemind() {
		return remind;
	}

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

	public String getTeacherId() {
		return teacherId;
	}

	public void setTeacherId(String teacherId) {
		this.teacherId = teacherId;
	}

	public String getTeacherName() {
		return teacherName;
	}

	public void setTeacherName(String teacherName) {
		this.teacherName = teacherName;
	}

	public Date getCreateTime() {
		return createTime;
	}

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

	public String getGroupId() {
		return groupId;
	}

	public void setGroupId(String groupId) {
		this.groupId = groupId;
	}

	public String getStudentNo() {
		return studentNo;
	}

	public void setStudentNo(String studentNo) {
		this.studentNo = studentNo;
	}

	public BigDecimal getStudentScore() {
		return studentScore;
	}

	public void setStudentScore(BigDecimal studentScore) {
		this.studentScore = studentScore;
	}

	public short getCompleteStatus() {
		return completeStatus;
	}

	public void setCompleteStatus(short completeStatus) {
		this.completeStatus = completeStatus;
	}

	public String getFileId() {
		return fileId;
	}

	public void setFileId(String fileId) {
		this.fileId = fileId;
	}

	public String getFilePath() {
		return filePath;
	}

	public void setFilePath(String filePath) {
		this.filePath = filePath;
	}

	public String getTargetObjectId() {
		return targetObjectId;
	}

	public void setTargetObjectId(String targetObjectId) {
		this.targetObjectId = targetObjectId;
	}

	public String getTeacherComment() {
		return teacherComment;
	}

	public void setTeacherComment(String teacherComment) {
		this.teacherComment = teacherComment;
	}

	public String getUploadDesc() {
		return uploadDesc;
	}

	public void setUploadDesc(String uploadDesc) {
		this.uploadDesc = uploadDesc;
	}

	public String getMobilePhone() {
		return mobilePhone;
	}

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

	public short getSex() {
		return sex;
	}

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

}