package com.qxueyou.scc.school.model;

import java.io.Serializable;
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.GeneratedValue;
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 org.hibernate.annotations.Fetch;
//import org.hibernate.annotations.FetchMode;
//import org.hibernate.annotations.GenericGenerator;
import org.springframework.format.annotation.DateTimeFormat;

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

/**
 * The persistent class for the sch_chapter database table.
 * 
 */
@Entity
@Table(name = "SCH_CHAPTER")
@NamedQuery(name = "SchChapter.findAll", query = "SELECT s FROM SchChapter s")
public class SchChapter implements Serializable, ITrace {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="CHAPTER_ID")
	private String chapterId;

	private String code;

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

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

	private String creator;

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

	@Column(name = "ORG_ID")
	private String orgId;

	@Column(name = "TOP_ORG_ID")
	private String topOrgId;

	private String name;

	@Column(name = "PARENT_CHAPTER_ID")
	private String parentChapterId;

	@Column(name = "ORG_CHAPTER_ID")
	private String orgChapterId;

	@Column(name = "ORIG_CHAPTER_ID")
	private String origChapterId;

	@Column(name = "SUBJECT_ID")
	private String subjectId;

	@Column(name = "COLLEGE_COURSE_ID")
	private String collegeCourseId;

	@Column(name = "CLASS_ID")
	private String classId;

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

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

	private String updator;

	@Column(name = "ORDER_NUM")
	private int orderNum;

	
	@ManyToOne(cascade = CascadeType.ALL,fetch = FetchType.LAZY)
	//,referencedColumnName="CHAPTER_ID"
	@JoinColumn(name = "PARENT_CHAPTER_ID",updatable=false,insertable=false)	
	private SchChapter parent;
	
	@OneToMany(fetch = FetchType.LAZY, mappedBy = "parent")
	private List<SchChapter> childs;

	/**
	 * 
	 */
	@ManyToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
	@JoinColumn(name = "SUBJECT_ID", referencedColumnName = "CLASS_SUBJECT_ID", insertable = false, updatable = false)
	@JsonIgnore
	private SchClassSubject classSubject;

	/** 课程 */
	@ManyToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
	@JoinColumn(name = "SUBJECT_ID", referencedColumnName = "SUBJECT_ID", updatable = false, insertable = false)
	@JsonIgnore
	private Subject subject;
	
	
	public SchChapter getParent() {
		return parent;
	}

	public void setParent(SchChapter parent) {
		this.parent = parent;
	}

	public List<SchChapter> getChilds() {
		return childs;
	}

	public void setChilds(List<SchChapter> childs) {
		this.childs = childs;
	}
	
	
	public SchClassSubject getClassSubject() {
		return classSubject;
	}

	public void setClassSubject(SchClassSubject classSubject) {
		this.classSubject = classSubject;
	}

	public Subject getSubject() {
		return subject;
	}

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

	public String getTopOrgId() {
		return topOrgId;
	}

	public void setTopOrgId(String topOrgId) {
		this.topOrgId = topOrgId;
	}

	public String getCollegeCourseId() {
		return collegeCourseId;
	}

	public void setCollegeCourseId(String collegeCourseId) {
		this.collegeCourseId = collegeCourseId;
	}

	public String getOrgChapterId() {
		return orgChapterId;
	}

	public void setOrgChapterId(String orgChapterId) {
		this.orgChapterId = orgChapterId;
	}

	public String getOrigChapterId() {
		return origChapterId;
	}

	public void setOrigChapterId(String origChapterId) {
		this.origChapterId = origChapterId;
	}

	public String getClassId() {
		return classId;
	}

	public void setClassId(String classId) {
		this.classId = classId;
	}

	public int getOrderNum() {
		return orderNum;
	}

	public void setOrderNum(int orderNum) {
		this.orderNum = orderNum;
	}

	public String getOrgId() {
		return orgId;
	}

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

	public String getChapterId() {
		return this.chapterId;
	}

	public void setChapterId(String chapterId) {
		this.chapterId = chapterId;
	}

	public String getCode() {
		return this.code;
	}

	public void setCode(String code) {
		this.code = code;
	}

	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 getName() {
		return this.name;
	}

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

	public String getParentChapterId() {
		return this.parentChapterId;
	}

	public void setParentChapterId(String parentChapterId) {
		this.parentChapterId = parentChapterId;
	}

	public String getSubjectId() {
		return this.subjectId;
	}

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

	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;
	}
	
	
	

}