/**
    * Copyright 2010 The Kuali Foundation Licensed under the
    * Educational Community License, Version 2.0 (the "License"); you may
    * not use this file except in compliance with the License. You may
    * obtain a copy of the License at
    *
    * http://www.osedu.org/licenses/ECL-2.0
    *
    * Unless required by applicable law or agreed to in writing,
   * software distributed under the License is distributed on an "AS IS"
   * BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
   * or implied. See the License for the specific language governing
   * permissions and limitations under the License.
   */
  
  package org.kuali.student.r2.lum.lu.entity;
  
  import java.util.Date;
  import java.util.List;
  
  import javax.persistence.CascadeType;
  import javax.persistence.Column;
  import javax.persistence.Entity;
  import javax.persistence.JoinColumn;
  import javax.persistence.ManyToOne;
  import javax.persistence.NamedQueries;
  import javax.persistence.NamedQuery;
  import javax.persistence.OneToMany;
  import javax.persistence.Table;
  import javax.persistence.Temporal;
  import javax.persistence.TemporalType;
  
  import org.kuali.student.r1.common.entity.AttributeOwner;
  import org.kuali.student.r1.common.entity.MetaEntity;
  
  @Entity
  @Table(name = "KSLU_CLUCLU_RELTN")
  @NamedQueries({
  	@NamedQuery(name="CluCluRelation.getCluCluRelation", query="SELECT rel FROM CluCluRelation rel WHERE rel.clu.id = :cluId or rel.relatedClu.id = :cluId"),
  	@NamedQuery(name="CluCluRelation.getRelatedCluIdsByCluId", query="SELECT rel.relatedClu.id FROM CluCluRelation rel WHERE rel.clu.id = :cluId AND rel.luLuRelationType.id = :luLuRelationTypeId"),
  	@NamedQuery(name="CluCluRelation.getCluIdsByRelatedCluId", query = "SELECT rel.clu.id FROM CluCluRelation rel WHERE rel.relatedClu.id = :relatedCluId AND rel.luLuRelationType.id = :luLuRelationTypeId"),
  	@NamedQuery(name="CluCluRelation.getRelationTypeByCluId", query="SELECT distinct rel.luLuRelationType.id FROM CluCluRelation rel WHERE rel.clu.id = :cluId AND rel.relatedClu.id = :relatedCluId"),
  	@NamedQuery(name="CluCluRelation.getRelatedClusByCluId", query="SELECT rel.relatedClu FROM CluCluRelation rel WHERE rel.clu.id = :cluId AND rel.luLuRelationType.id = :luLuRelationTypeId"),
  	@NamedQuery(name="CluCluRelation.getClusByRelatedCluId", query="SELECT rel.clu FROM CluCluRelation rel WHERE rel.relatedClu.id = :relatedCluId AND rel.luLuRelationType.id = :luLuRelationTypeId"),
  	@NamedQuery(name="CluCluRelation.getRelatedClusByCluIdSt", query="SELECT rel.relatedClu FROM CluCluRelation rel WHERE rel.clu.id = :cluId AND rel.luLuRelationType.id = :luLuRelationTypeId AND rel.relatedClu.state in (:luStateList)"),
  	@NamedQuery(name="CluCluRelation.getClusByRelatedCluIdSt", query="SELECT rel.clu FROM CluCluRelation rel WHERE rel.relatedClu.id = :relatedCluId AND rel.luLuRelationType.id = :luLuRelationTypeId AND rel.clu.state in (:luStateList)")
  })
  public class CluCluRelation extends MetaEntity implements
  		AttributeOwner<CluCluRelationAttribute> {
  	
  	@ManyToOne
  	@JoinColumn(name="CLU_ID")
  	private Clu clu;
  	
  	@ManyToOne
  	@JoinColumn(name="RELATED_CLU_ID")
  	private Clu relatedClu;
  	
  	@ManyToOne
  	@JoinColumn(name="LU_RELTN_TYPE_ID")
  	private LuLuRelationType luLuRelationType;
  	
  	@Column(name = "CLU_RELTN_REQ")
  	private boolean cluRelationRequired;
  
  	@Temporal(TemporalType.TIMESTAMP)
  	@Column(name = "EFF_DT")
      private Date effectiveDate;
  
  	@Temporal(TemporalType.TIMESTAMP)
  	@Column(name = "EXPIR_DT")
  	private Date expirationDate;
  
  	@Column(name = "ST")
  	private String state;
  
  	@OneToMany(cascade = CascadeType.ALL, mappedBy = "owner")
  	private List<CluCluRelationAttribute> attributes;
  	
  	public Clu getClu() {
  		return clu;
  	}
  
  	public void setClu(Clu clu) {
  		this.clu = clu;
  	}
  
  	public Clu getRelatedClu() {
  		return relatedClu;
  	}
  
  	public void setRelatedClu(Clu relatedClu) {
  		this.relatedClu = relatedClu;
  	}
  
  	public LuLuRelationType getLuLuRelationType() {
  		return luLuRelationType;
  	}
  
 	public void setLuLuRelationType(LuLuRelationType luLuRelationType) {
 		this.luLuRelationType = luLuRelationType;
 	}
 
 	public boolean isCluRelationRequired() {
 		return cluRelationRequired;
 	}
 
 	public void setCluRelationRequired(boolean cluRelationRequired) {
 		this.cluRelationRequired = cluRelationRequired;
 	}
 
 	public Date getEffectiveDate() {
 		return effectiveDate;
 	}
 
 	public void setEffectiveDate(Date effectiveDate) {
 		this.effectiveDate = effectiveDate;
 	}
 
 	public Date getExpirationDate() {
 		return expirationDate;
 	}
 
 	public void setExpirationDate(Date expirationDate) {
 		this.expirationDate = expirationDate;
 	}
 
 	public String getState() {
 		return state;
 	}
 
 	public void setState(String state) {
 		this.state = state;
 	}
 	
 	@Override
     public List<CluCluRelationAttribute> getAttributes() {
 		return attributes;
 	}
 
 	@Override
     public void setAttributes(List<CluCluRelationAttribute> attributes) {
 		this.attributes = attributes;
 	}
 }