package com.qxueyou.scc.exam.model;

import java.math.BigDecimal;
import java.math.BigInteger;
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 = "exam_result_v")
public class ExamResultV implements java.io.Serializable {

	/**
	 * 
	 */
	private static final long serialVersionUID = 8897668335729792129L;
	
	@EmbeddedId
	@AttributeOverrides({
			@AttributeOverride(name = "examBatchId", column = @Column(name = "EXAM_BATCH_ID")),
			@AttributeOverride(name = "studentNo", column = @Column(name = "STUDENT_NO")),
			@AttributeOverride(name = "classId", column = @Column(name = "CLASS_ID")),
			})
	private ExamResultVId id;
	
	@Column(name="EXAM_ID")
	private String examId;
	
	@Column(name="STUDENT_NAME")
	private String studentName;
	
	@Column(name="RECORD_ID")
	private String recordId;
	
	@Column(name="EXAM_NAME")
	private String examName;
	
	@Column(name="SUBJECT_ID")
	private String subjectId;
	
	@Column(name="SUBJECT_Name")
	private String subjectName;
	
	@Column(name = "TOTAL_SCORE")
	private float totalScore;
	
	@Column(name = "PASSING_SCORE")
	private BigDecimal passingScore;
	
	@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="CLASS_NAME")
	private String className;
	
	@Column(name="PAPER_NAME")
	private String paperName;
	
	@Column(name="RELATION_PAPER_CODE")
	private String paperCode;
	
	@Column(name="USER_ID")
	private String userId;
	
	@Column(name="ACCURACY")
	private BigDecimal accuracy;

	@Column(name="COMPLETION_RATE")
	private BigDecimal completionRate;
	
	@Column(name="SCORE")
	private BigDecimal score;

	@Column(name="STATUS") 
	private String status;
	
	@Column(name="EXERCISE_GROUP_ID")
	private String exerciseGroupId;
	
	@Column(name = "EXAM_BATCH_NO")
	private short examBatchNo;
	
	@Column(name = "EXAM_STATUS")
	private short examStatus;
	
	@Column(name="CORRECT_COUNT")
	private BigInteger correctCount;
	
	@Temporal(TemporalType.TIMESTAMP)
	@Column(name = "SUBMIT_TIME", nullable = false)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
	private Date submitTime;
	
	@Column(name = "REMAINING_SECONDS")
	private Integer remainingSeconds;
	
	@Column(name = "SEX")
	private short sex;
	
	@Column(name = "MOBILE_PHONE")
	private String mobilePhone;
	

	public ExamResultV() {
	}

	public String getExamId() {
		return examId;
	}

	public void setExamId(String examId) {
		this.examId = examId;
	}
	
	public String getStudentName() {
		return studentName;
	}

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

	public void setRecordId(String recordId) {
		this.recordId = recordId;
	}

	public String getExamName() {
		return examName;
	}

	public void setExamName(String examName) {
		this.examName = examName;
	}

	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 getPaperName() {
		return paperName;
	}

	public void setPaperName(String paperName) {
		this.paperName = paperName;
	}

	public String getPaperCode() {
		return paperCode;
	}

	public void setPaperCode(String paperCode) {
		this.paperCode = paperCode;
	}

	public String getUserId() {
		return userId;
	}

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

	public BigDecimal getAccuracy() {
		return accuracy;
	}

	public void setAccuracy(BigDecimal accuracy) {
		this.accuracy = accuracy;
	}

	public BigDecimal getCompletionRate() {
		return completionRate;
	}

	public void setCompletionRate(BigDecimal completionRate) {
		this.completionRate = completionRate;
	}

	public BigDecimal getScore() {
		return score;
	}

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

	public String getStatus() {
		return status;
	}

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

	public BigDecimal getPassingScore() {
		return passingScore;
	}

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

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

	public String getExerciseGroupId() {
		return exerciseGroupId;
	}

	public void setExerciseGroupId(String exerciseGroupId) {
		this.exerciseGroupId = exerciseGroupId;
	}

	public short getExamBatchNo() {
		return examBatchNo;
	}

	public void setExamBatchNo(short examBatchNo) {
		this.examBatchNo = examBatchNo;
	}

	public short getExamStatus() {
		return examStatus;
	}

	public void setExamStatus(short examStatus) {
		this.examStatus = examStatus;
	}

	public BigInteger getCorrectCount() {
		return correctCount;
	}

	public void setCorrectCount(BigInteger correctCount) {
		this.correctCount = correctCount;
	}

	public Date getSubmitTime() {
		return submitTime;
	}

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

	public Integer getRemainingSeconds() {
		return remainingSeconds;
	}

	public void setRemainingSeconds(Integer remainingSeconds) {
		this.remainingSeconds = remainingSeconds;
	}

	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 short getSex() {
		return sex;
	}

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

	public String getMobilePhone() {
		return mobilePhone;
	}

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

	public float getTotalScore() {
		return totalScore;
	}

	public void setTotalScore(float totalScore) {
		this.totalScore = totalScore;
	}
	
}