/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.bestray.healthcarecommonutil.vo;

import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToOne;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.Version;

/**
 *
 * @author User1
 */
@NamedQueries({
    
    @NamedQuery(
	name = "findMaxInPatientId",
    //query = "from TInpatentAdmission inPatient where id=(select max(id) from TInpatentAdmission)"),
      query = "from TInpatentAdmission inPatient where inpatientStatus IN('ADMITTED','DISCHARGED') and  DATE(admissionDate) >= '2014-04-01' order by CAST(inpatientId AS integer) DESC" ),
    
    @NamedQuery(
	name = "findAdmittedInPatientList",
    query = "from TInpatentAdmission inPatient where inpatientStatus = 'ADMITTED' order by inPatient.inpatientId asc"),
    
    @NamedQuery(
	name = "checkAvailableInPatient",
    query = "from TInpatentAdmission inPatient where patientId = ? and inpatientStatus = 'ADMITTED' order by inPatient.admissionDate asc"),
    
    @NamedQuery(
	name = "findDischargeIPListByDate",
    query = "from TInpatentAdmission where releaseDate between ? and ? and inpatientStatus = 'DISCHARGED' order by id asc "),
    
    @NamedQuery(
	name = "findAllAdmissionDateByPatient",
    query = "from TInpatentAdmission inPatient where inpatientStatus = 'DISCHARGED' and patientId = ? order by inPatient.inpatientId asc")
})
@Entity
@Table(name = "t_inpatent_admission")
public class TInpatentAdmission implements java.io.Serializable {

    /**
     * The id.
     */
    @Id
    //@GeneratedValue
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    /**
     * The In-Patient ID.
     */
    @Column(name = "inpatient_id")
    private String inpatientId;
    
    @Column(name = "ipd_no")
    private String ipdNo;

    
    @OneToOne
    @JoinColumn(name="enc_id")
    private TPatientEncounter encounter;
    
    /**
     * The patient id.
     */
    @ManyToOne
    @JoinColumn(name = "patient_id")
    private TPatient patientId;
    /**
     * The patient id.
     */
    @ManyToOne
    @JoinColumn(name = "doctor_id")
    private TDoctorInformation doctorId;
    /**
     * The patient id.
     */
    @ManyToOne
    @JoinColumn(name = "bed_id")
    private TBedMaster bedId;
    /**
     * The admission type.
     */
   
   
    @Column(name = "admission_type")
    private String admissionType;
    @Temporal(javax.persistence.TemporalType.TIMESTAMP)
    @Column(name = "admission_date")
    private Date admissionDate;
    @Temporal(javax.persistence.TemporalType.TIMESTAMP)
    @Column(name = "release_date")
    private Date releaseDate;
    @Column(name = "admitted_by")
    private String admittedBy;
    @Column(name = "inpatient_status")
    private String inpatientStatus;
    @Column(name = "patient_note")
    private String patientNote;
    @Column(name = "patient_disease")
    private String patientDisease;
    @Column(name = "created_date")
    @Temporal(javax.persistence.TemporalType.TIMESTAMP)
    private Date createdDate;
    @Column(name = "updated_date")
    @Temporal(javax.persistence.TemporalType.TIMESTAMP)
    private Date updatedDate;
    /**
     * The created by.
     */
    @Column(name = "created_by")
    private String createdBy;
    /**
     * The record version.
     */
    @Version
    @Column(name = "record_version")
    private Long recordVersion;

    public Long getId() {
        return id;
    }

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

    public String getInpatientId() {
        return inpatientId;
    }

    public void setInpatientId(String inpatientId) {
        this.inpatientId = inpatientId;
    }
    
    public String getIpdNo() {
        return ipdNo;
    }

    public void setIpdNo(String ipdNo) {
        this.ipdNo = ipdNo;
    }

    public TPatient getPatientId() {
        return patientId;
    }

    public TPatientEncounter getEncounter() {
        return encounter;
    }

    public void setEncounter(TPatientEncounter encounter) {
        this.encounter = encounter;
    }

    
    public void setPatientId(TPatient patientId) {
        this.patientId = patientId;
    }

    public TDoctorInformation getDoctorId() {
        return doctorId;
    }

    public void setDoctorId(TDoctorInformation doctorId) {
        this.doctorId = doctorId;
    }

    public TBedMaster getBedId() {
        return bedId;
    }

    public void setBedId(TBedMaster bedId) {
        this.bedId = bedId;
    }

    public String getAdmissionType() {
        return admissionType;
    }

    public void setAdmissionType(String admissionType) {
        this.admissionType = admissionType;
    }

    public Date getAdmissionDate() {
        return admissionDate;
    }

    public void setAdmissionDate(Date admissionDate) {
        this.admissionDate = admissionDate;
    }

    public String getAdmittedBy() {
        return admittedBy;
    }

    public void setAdmittedBy(String admittedBy) {
        this.admittedBy = admittedBy;
    }

    public String getInpatientStatus() {
        return inpatientStatus;
    }

    public void setInpatientStatus(String inpatientStatus) {
        this.inpatientStatus = inpatientStatus;
    }

    public String getPatientNote() {
        return patientNote;
    }

    public void setPatientNote(String patientNote) {
        this.patientNote = patientNote;
    }

    public Date getReleaseDate() {
        return releaseDate;
    }

    public void setReleaseDate(Date releaseDate) {
        this.releaseDate = releaseDate;
    }

    public Long getRecordVersion() {
        return recordVersion;
    }

    public void setRecordVersion(Long recordVersion) {
        this.recordVersion = recordVersion;
    }

    public Date getCreatedDate() {
        return createdDate;
    }

    public void setCreatedDate(Date createdDate) {
        this.createdDate = createdDate;
    }

    public Date getUpdatedDate() {
        return updatedDate;
    }

    public void setUpdatedDate(Date updatedDate) {
        this.updatedDate = updatedDate;
    }

    public String getCreatedBy() {
        return createdBy;
    }

    public void setCreatedBy(String createdBy) {
        this.createdBy = createdBy;
    }

    /**
     * @return the patientDisease
     */
    public String getPatientDisease() {
        return patientDisease;
    }

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