/**

  * 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.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.common.entity.AttributeOwner;

 import org.kuali.student.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;

         }

 }