package com.qxueyou.scc.org.model;

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

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.Table;
import javax.persistence.Transient;

import org.hibernate.annotations.Formula;
import org.hibernate.annotations.GenericGenerator;
import org.hibernate.annotations.NotFound;
import org.hibernate.annotations.NotFoundAction;
import org.springframework.format.annotation.DateTimeFormat;

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


/**
 * The persistent class for the org_class database table.
 * 
 */
@Entity
@Table(name="org_class_query_cm")
@NamedQuery(name="OrgClassQueryCm.findAll", query="SELECT o FROM OrgClassQueryCm o")
public class OrgClassQueryCm implements Serializable,ITrace {
	
	/**有直播*/
	public static final int HAVE_LIVE = 1;
	
	/**无直播*/
	public static final int NOT_HAVE_LIVE = 0;
	
	/**有视频*/
	public static final int HAVE_VIDEO = 1;
	
	/**无视频*/
	public static final int NOT_HAVE_VIDEO = 0;
	
	/**有讲义*/
	public static final int HAVE_HANDOUT = 1;
	
	/**无讲义*/
	public static final int NOT_HAVE_HANDOUT = 0;
	
	/**有推荐奖励*/
	public static final int HAVE_AWARD = 1;
	
	/**无推荐奖励*/
	public static final int NOT_HAVE_AWARD = 0;
	
	private static final long serialVersionUID = 1L;

	@Id
	@GeneratedValue(generator = "hibernate-uuid")
	@GenericGenerator(name = "hibernate-uuid", strategy = "uuid")
	@Column(name="CLASS_ID", unique=true, nullable=false, length=32)
	private String classId;

	@Column(name="CLASS_CHARGER", length=50)
	private String classCharger;

	@Column(name="CLASS_CHARGER_ID", length=32)
	private String classChargerId;

	@Column(name="CODE", length=50)
	private String code;

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

	@Column(name="COLLEGE_COURSE_NAME", length=255)
	private String collegeCourseName;

	@Column(name="CREATE_ID", nullable=false, length=32)
	@JsonIgnore
	private String createId;

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

	@Column(name="CREATOR", nullable=false, length=100)
	@JsonIgnore
	private String creator;

	@Column(name="DELETE_FLAG", nullable=false)
	@JsonIgnore
	private boolean deleteFlag;

	@Column(name="NAME", length=255)
	private String name;
	
	@Column(name="PROGRESS", length=255)
	private String progress;
	
	@Column(name="ADDRESS", length=255)
	private String address;
	
	@Column(name="ARRANGEMENT", length=255)
	private String arrangement;
	
	/** 班级优势 */
	@Column(name="ADVANTAGE", length=255)
	private String advantage;

	@Column(name="PRICE", precision=10, scale=2)
	private BigDecimal price;

	@Column(name="START_TIME", nullable=false)
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm")
	private Date startTime;
	
	@Column(name="END_TIME")
	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm")
	private Date endTime;

	/**当前已报名学生人数*/
	@Column(name="STUDENT_COUNT")
	private int studentCount;
	
	@Column(name="RECOMMEND", nullable=false)
	private boolean recommend;
	
	@Column(name="IMG_PATH", length=255)
	private String imgPath;

	@Column(name="UPDATE_ID", length=32)
	@JsonIgnore
	private String updateId;

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

	@Column(name="UPDATOR", length=100)
	@JsonIgnore
	private String updator;
	
	/** 是否推广  false：不推广  true：推广 */
	@Column(name="EXTENDED")
	private boolean extended;
	
	@Column(name="CLASS_TYPES", length=100)
	private String classTypes;
	
	@Column(name="DISCOUNT", precision=10, scale=2)
	private BigDecimal discount;
	
	@Column(name="DISPRICE", precision=10, scale=2)
	private BigDecimal disprice;
	
	@Column(name="STUDY_TIME", precision=10, scale=2)
	private BigDecimal studyTime;
	
	@Column(name="SCORE", precision=10, scale=2)
	private BigDecimal score;
	
	/**学生总数   计划招生人数,用于机构    指定 */
	@Column(name="STU_ALL_COUNT")
	private BigInteger stuAllCount;
	
	@Column(name="COMMENT_COUNT")
	private BigInteger commentCount;
	
	@Column(name="POINTER", length=255)
	private String pointer;
	
	/***点击次数**/
	@Column(name="CLICK_NUM", precision=11, scale=0)
	private BigDecimal clickNum;
	
	/***省份**/
	@Column(name="PROVINCE", length=255)
	private String province;
	
	/***城市**/
	@Column(name="CITY", length=255)
	private String city;
	
	/***区域**/
	@Column(name="REGION", length=255)
	private String region;
	
	/***是否置顶**/
	@Column(name="TOP_FLAG", length=255)
	private Boolean topFlag;
	
	/***方式**/
	@Column(name="MODE", length=255)
	private String mode;
	
	/***商品ID**/
	@Column(name="GOOD_ID", length=32)
	private String goodId;
	

	/***产品ID**/
	@Column(name="PRODUCT_ID", length=255)
	private String productId;
	
	/***机构ID**/
	@Column(name="ORG_ID", length=32)
	private String orgId;
	
	/***是否有直播**/
	@Column(name="HAVE_LIVE", length=1)
	private Integer haveLive;
	
	/***是否有视频**/
	@Column(name="HAVE_VIDEO", length=1)
	private Integer haveVideo;
	
	/***是否有讲义**/
	@Column(name="HAVE_HANDOUT", length=1)
	private Integer haveHandout;
	
	/***经度**/
	@Column(name="LONGITUDE_X", length=32)
	private String logitudeX;
	
	/***纬度**/
	@Column(name="LATITUDE_Y", length=32)
	private String latitudeY;
	
	/***付款人数**/
	@Column(name="PAYMENT_NUM", length=11)
	private BigInteger paymentNum;
	
	/***是否有推荐奖励**/
	@Column(name="HAVA_AWARD", length=32)
	private Integer haveAward;
	
	@ManyToOne(cascade = CascadeType.ALL,fetch = FetchType.LAZY)
    @JoinColumn(name = "COLLEGE_COURSE_ID",referencedColumnName="COLLEGE_COURSE_ID",updatable=false,insertable=false)
	@JsonIgnore
	private OrgCollegeCourse orgCollegeCourse;
	
	@ManyToOne(cascade = CascadeType.REFRESH,fetch = FetchType.LAZY)
	@NotFound(action=NotFoundAction.IGNORE)
    @JoinColumn(name = "CLASS_CHARGER_ID",referencedColumnName="ORG_CHARGER_ID",updatable=false,insertable=false)
	@JsonIgnore
	private OrgCharger charger;
	
	@ManyToOne(cascade = CascadeType.ALL,fetch = FetchType.LAZY)
    @JoinColumn(name = "ORG_ID",referencedColumnName="ORGANIZATION_ID",updatable=false,insertable=false)
	@JsonIgnore
	private Organization org;
	
	@Transient
	private String content;
	
	@Transient
	private String courseId ;
	
	@Transient
	private String courseName ;
	
	@Transient
	private String orgName ;
	
	@Transient
	private String orgShortName ;
	
	//班级引荐费
	@Transient
	private BigDecimal referFee ;
	
	/** 报名人数**/
	@Formula("(select count(1) from User_Registration u WHERE u.CLASS_ID=CLASS_ID and u.DELETE_FLAG = 0)")
	private Integer signUpCount ;
	
	public Integer getSignUpCount() {
		return signUpCount;
	}

	public void setSignUpCount(Integer signUpCount) {
		this.signUpCount = signUpCount;
	}

	public BigDecimal getReferFee() {
		return referFee;
	}

	public void setReferFee(BigDecimal referFee) {
		this.referFee = referFee;
	}


	public Organization getOrg() {
		return org;
	}


	public void setOrg(Organization org) {
		this.org = org;
	}

	public OrgCharger getCharger() {
		return charger;
	}


	public void setCharger(OrgCharger charger) {
		this.charger = charger;
	}


	public String getClassId() {
		return this.classId;
	}

	public String getOrgId() {
		return orgId;
	}


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


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

	public String getClassCharger() {
		return this.classCharger;
	}

	public void setClassCharger(String classCharger) {
		this.classCharger = classCharger;
	}

	public String getClassChargerId() {
		return this.classChargerId;
	}

	public void setClassChargerId(String classChargerId) {
		this.classChargerId = classChargerId;
	}

	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 BigDecimal getPrice() {
		return this.price;
	}

	public void setPrice(BigDecimal price) {
		this.price = price;
	}

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

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

	public int getStudentCount() {
		return this.studentCount;
	}

	public void setStudentCount(int studentCount) {
		this.studentCount = studentCount;
	}

	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 Date getEndTime() {
		return endTime;
	}

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

	public String getProgress() {
		return progress;
	}

	public void setProgress(String progress) {
		this.progress = progress;
	}

	public String getContent() {
		return content;
	}

	public void setContent(String content) {
		this.content = content;
	}

	public boolean getRecommend() {
		return recommend;
	}

	public void setRecommend(boolean recommend) {
		this.recommend = recommend;
	}

	public String getImgPath() {
		return imgPath;
	}

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


	public boolean getExtended() {
		return extended;
	}


	public void setExtended(boolean extended) {
		this.extended = extended;
	}

	public String getClassTypes() {
		return classTypes;
	}


	public void setClassTypes(String classTypes) {
		this.classTypes = classTypes;
	}


	public BigDecimal getDiscount() {
		return discount;
	}


	public void setDiscount(BigDecimal discount) {
		this.discount = discount;
	}


	public BigDecimal getDisprice() {
		return disprice;
	}


	public void setDisprice(BigDecimal disprice) {
		this.disprice = disprice;
	}


	public BigDecimal getStudyTime() {
		return studyTime;
	}


	public void setStudyTime(BigDecimal studyTime) {
		this.studyTime = studyTime;
	}


	public BigDecimal getScore() {
		return score;
	}


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

	public BigInteger getStuAllCount() {
		return stuAllCount;
	}


	public void setStuAllCount(BigInteger stuAllCount) {
		this.stuAllCount = stuAllCount;
	}


	public BigInteger getCommentCount() {
		return commentCount;
	}


	public void setCommentCount(BigInteger commentCount) {
		this.commentCount = commentCount;
	}


	public String getPointer() {
		return pointer;
	}


	public void setPointer(String pointer) {
		this.pointer = pointer;
	}
	
	public String getCollegeCourseId() {
		return collegeCourseId;
	}

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

	public OrgCollegeCourse getOrgCollegeCourse() {
		return orgCollegeCourse;
	}

	public void setOrgCollegeCourse(OrgCollegeCourse orgCollegeCourse) {
		this.orgCollegeCourse = orgCollegeCourse;
	}

	public String getCollegeCourseName() {
		return collegeCourseName;
	}

	public void setCollegeCourseName(String collegeCourseName) {
		this.collegeCourseName = collegeCourseName;
	}

	public String getCourseId() {
		return courseId;
	}

	public void setCourseId(String courseId) {
		this.courseId = courseId;
	}

	public String getCourseName() {
		return courseName;
	}

	public void setCourseName(String courseName) {
		this.courseName = courseName;
	}


	public String getAddress() {
		return address;
	}


	public void setAddress(String address) {
		this.address = address;
	}


	public String getArrangement() {
		return arrangement;
	}


	public void setArrangement(String arrangement) {
		this.arrangement = arrangement;
	}


	public String getAdvantage() {
		return advantage;
	}


	public void setAdvantage(String advantage) {
		this.advantage = advantage;
	}


	public BigDecimal getClickNum() {
		return clickNum;
	}


	public void setClickNum(BigDecimal clickNum) {
		this.clickNum = clickNum;
	}


	public String getProvince() {
		return province;
	}


	public void setProvince(String province) {
		this.province = province;
	}


	public String getCity() {
		return city;
	}


	public void setCity(String city) {
		this.city = city;
	}


	public String getRegion() {
		return region;
	}


	public void setRegion(String region) {
		this.region = region;
	}


	public Boolean getTopFlag() {
		return topFlag;
	}


	public void setTopFlag(Boolean topFlag) {
		this.topFlag = topFlag;
	}


	public String getMode() {
		return mode;
	}


	public void setMode(String mode) {
		this.mode = mode;
	}


	public String getGoodId() {
		return goodId;
	}


	public void setGoodId(String goodId) {
		this.goodId = goodId;
	}


	public String getProductId() {
		return productId;
	}


	public void setProductId(String productId) {
		this.productId = productId;
	}
	
	public String getOrgName() {
		return orgName;
	}


	public void setOrgName(String orgName) {
		this.orgName = orgName;
	}


	/**
	 * @return the haveLive
	 */
	public Integer getHaveLive() {
		return haveLive;
	}


	/**
	 * @param haveLive the haveLive to set
	 */
	public void setHaveLive(Integer haveLive) {
		this.haveLive = haveLive;
	}


	/**
	 * @return the haveVideo
	 */
	public Integer getHaveVideo() {
		return haveVideo;
	}


	/**
	 * @param haveVideo the haveVideo to set
	 */
	public void setHaveVideo(Integer haveVideo) {
		this.haveVideo = haveVideo;
	}


	/**
	 * @return the haveHandout
	 */
	public Integer getHaveHandout() {
		return haveHandout;
	}


	/**
	 * @param haveHandout the haveHandout to set
	 */
	public void setHaveHandout(Integer haveHandout) {
		this.haveHandout = haveHandout;
	}


	/**
	 * @return the logitudeX
	 */
	public String getLogitudeX() {
		return logitudeX;
	}


	/**
	 * @param logitudeX the logitudeX to set
	 */
	public void setLogitudeX(String logitudeX) {
		this.logitudeX = logitudeX;
	}


	/**
	 * @return the latitudeY
	 */
	public String getLatitudeY() {
		return latitudeY;
	}


	/**
	 * @param latitudeY the latitudeY to set
	 */
	public void setLatitudeY(String latitudeY) {
		this.latitudeY = latitudeY;
	}


	/**
	 * @return the paymentNum
	 */
	public BigInteger getPaymentNum() {
		return paymentNum;
	}


	/**
	 * @param paymentNum the paymentNum to set
	 */
	public void setPaymentNum(BigInteger paymentNum) {
		this.paymentNum = paymentNum;
	}


	/**
	 * @return the haveAward
	 */
	public Integer getHaveAward() {
		return haveAward;
	}


	/**
	 * @param haveAward the haveAward to set
	 */
	public void setHaveAward(int haveAward) {
		this.haveAward = haveAward;
	}

	public String getOrgShortName() {
		return orgShortName;
	}

	public void setOrgShortName(String orgShortName) {
		this.orgShortName = orgShortName;
	}
	
}