package org.mifos.platform.questionnaire.domain;

import java.io.Serializable;

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

@NamedQueries( {
    @NamedQuery(
            name = "SectionQuestionLink.retrieveDependentSectionQuestionLinksFromQuestion",
            query = "from SectionQuestionLink s where " +
                    "s.questionGroupLink.sourceSectionQuestion.id = ?"
    ),
    @NamedQuery(
            name = "SectionQuestionLink.retrieveAllConditions",
            query = "SELECT new org.mifos.application.master.business.LookUpValueEntity(value.lookUpId,value.lookUpName) " +
                    "FROM org.mifos.application.master.business.LookUpValueEntity value, org.mifos.application.master.business.LookUpEntity entity WHERE " +
                    "value.lookUpEntity.entityId = (SELECT entityId FROM entity where entity.entityType='ConditionType') and entity.entityType='ConditionType'"
    ),
    @NamedQuery(
            name = "SectionQuestionLink.retrieveSectionQuestionLinksByAffectedQuestionId",
            query = "from SectionQuestionLink s where " +
                    "s.affectedSectionQuestion.id = :affectedQuestionId"
    )
})
@Entity
@Table(name = "section_question_link")
public class SectionQuestionLink implements Serializable {

	private static final long serialVersionUID = 1L;

	@Id
    @GeneratedValue
    @Column(name="id")
    private Integer id;

    @ManyToOne(fetch=FetchType.EAGER)
    @JoinColumn(name="question_group_link_id")
    private QuestionGroupLink questionGroupLink;

    @ManyToOne
    @JoinColumn(name="affected_section_question_id")
    private SectionQuestion affectedSectionQuestion;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public QuestionGroupLink getQuestionGroupLink() {
		return questionGroupLink;
	}

	public void setQuestionGroupLink(QuestionGroupLink questionGroupLink) {
		this.questionGroupLink = questionGroupLink;
	}

	public SectionQuestion getAffectedSectionQuestion() {
		return affectedSectionQuestion;
	}

	public void setAffectedSectionQuestion(SectionQuestion affectedSectionQuestion) {
		this.affectedSectionQuestion = affectedSectionQuestion;
	}
    
}