/**

  * 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.core.proposal.entity;

 import java.util.Date;

 import java.util.List;

 import javax.persistence.AttributeOverride;

 import javax.persistence.CascadeType;

 import javax.persistence.Column;

 import javax.persistence.Entity;

 import javax.persistence.FetchType;

 import javax.persistence.JoinColumn;

 import javax.persistence.JoinTable;

 import javax.persistence.ManyToMany;

 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;

 /**

  * Proposal

  *

  * @author Kuali Rice Team (kuali-rice@googlegroups.com)

  *

  */

 @Entity

 @Table(name = "KSPR_PROPOSAL")

 @NamedQueries( {

     @NamedQuery(name = "Proposal.getProposalsByIdList", query = "SELECT p FROM Proposal p WHERE p.id IN (:idList)"),

     @NamedQuery(name = "Proposal.getProposalsByProposalType", query = "SELECT DISTINCT p FROM Proposal p WHERE p.type.id = :proposalTypeId"),

     @NamedQuery(name = "Proposal.getProposalsByReference", query = "SELECT r.proposals FROM ProposalReference r WHERE r.objectReferenceId = :referenceId AND r.type.id = :referenceTypeId"),

     @NamedQuery(name = "Proposal.getProposalsByState", query = "SELECT DISTINCT p FROM Proposal p WHERE p.state = :proposalState AND p.type.id = :proposalTypeId"),

     @NamedQuery(name = "Proposal.getProposalByWorkflowId", query = "SELECT DISTINCT p FROM Proposal p WHERE p.workflowId = :workflowId"),

     @NamedQuery(name = "Proposal.getProposalTypesForReferenceType", query = "SELECT DISTINCT p.type FROM ProposalReference r JOIN r.proposals p WHERE r.type.id = :referenceTypeId"),

     @NamedQuery(name = "Proposal.getProposalsByRefernceIds", query = "SELECT DISTINCT p FROM ProposalReference r JOIN r.proposals p WHERE r.objectReferenceId IN (:referenceIds)")

 })

 @AttributeOverride(name="id", column=@Column(name="PROPOSAL_ID"))

 public class Proposal extends MetaEntity implements AttributeOwner<ProposalAttribute> {

         @Column(name="WORKFLOW_ID")

     private String workflowId;

         @Column(name="NAME")

     private String name;

     @OneToMany(cascade = CascadeType.ALL, mappedBy = "proposal")

     private List<ProposalPerson> proposerPerson;

     @OneToMany(cascade = CascadeType.ALL, mappedBy = "proposal")

     private List<ProposalOrg> proposerOrg;

     @ManyToMany(fetch=FetchType.EAGER)

     @JoinTable(name="KSPR_PROPOSAL_JN_REFERENCE",

             joinColumns=

             @JoinColumn(name="PROPOSAL_ID", referencedColumnName="PROPOSAL_ID"),

       inverseJoinColumns=

             @JoinColumn(name="REFERENCE_ID", referencedColumnName="REFERENCE_ID")

     )

     private List<ProposalReference> proposalReference;

     @Column(name = "RATIONALE")

     private String rationale;

     @Column(name = "DETAIL_DESC")

     private String detailDesc;

     @Temporal(TemporalType.TIMESTAMP)

     @Column(name = "EFF_DT")

     private Date effectiveDate;

     @Temporal(TemporalType.TIMESTAMP)

     @Column(name = "EXPIR_DT")

     private Date expirationDate;

     @OneToMany(cascade = CascadeType.ALL, mappedBy = "owner")

     private List<ProposalAttribute> attributes;

     @ManyToOne(optional=true)

     @JoinColumn(name = "TYPE")

     private ProposalType type;

     @Column(name = "STATE")

     private String state;

     public String getName() {

         return name;

     }

     public void setName(String name) {

         this.name = name;

     }

     public List<ProposalPerson> getProposerPerson() {

         return proposerPerson;

     }

     public void setProposerPerson(List<ProposalPerson> proposerPerson) {

         this.proposerPerson = proposerPerson;

     }

     public List<ProposalOrg> getProposerOrg() {

         return proposerOrg;

     }

     public void setProposerOrg(List<ProposalOrg> proposerOrg) {

         this.proposerOrg = proposerOrg;

     }

     public List<ProposalReference> getProposalReference() {

         return proposalReference;

     }

     public void setProposalReference(List<ProposalReference> proposalReference) {

         this.proposalReference = proposalReference;

     }

     public String getRationale() {

         return rationale;

     }

     public void setRationale(String rationale) {

         this.rationale = rationale;

     }

     public String getDetailDesc() {

         return detailDesc;

     }

     public void setDetailDesc(String detailDesc) {

         this.detailDesc = detailDesc;

     }

     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 ProposalType getType() {

         return type;

     }

     public void setType(ProposalType type) {

         this.type = type;

     }

     public String getState() {

         return state;

     }

     public void setState(String state) {

         this.state = state;

     }

     @Override

     public List<ProposalAttribute> getAttributes() {

         return attributes;

     }

     @Override

     public void setAttributes(List<ProposalAttribute> attributes) {

         this.attributes = attributes;

     }

     public String getWorkflowId() {

                 return workflowId;

         }

         public void setWorkflowId(String workflowId) {

                 this.workflowId = workflowId;

         }

 }