/*
 * 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.Table;
import javax.persistence.Temporal;
import javax.persistence.Version;

// TODO: Auto-generated Javadoc
/**
 * The Class TAppointment.
 *
 * @author sumitHome
 */

@NamedQueries({
	@NamedQuery(
	name = "findAllAppointmentList",
	query = "from TAppointment where appointmentDate = ? and doctorNameId = ? and appointmentStatus = 1 and patientStatus != 3 "
        ),
        @NamedQuery(
	name = "findAppointmentListByPatient",
	query = "from TAppointment where patientNameId = ? and appointmentStatus = 1 "
	),
        @NamedQuery(
	name = "findAppointmentListByDate",
	query = "from TAppointment where appointmentDate = ? and appointmentStatus = 1 order by patientOpdNumber asc "
	),
        @NamedQuery(
	name = "findPreviousAppointments",
	query = "from TAppointment where patientNameId = ? and appointmentDate = ? and departmentNameId = ? and doctorNameId = ? and visitType = ? and appointmentStatus = 1 and patientStatus in(1,2) "
	),
        @NamedQuery(
	name = "findAppointmentListByDepartment",
	query = "from TAppointment where appointmentDate = ? and departmentNameId = ? and appointmentStatus = 1 order by patientOpdNumber asc "
	),
        @NamedQuery(
	name = "findAppointmentListByDoctor",
	query = "from TAppointment where appointmentDate = ? and departmentNameId = ? and doctorNameId = ? and appointmentStatus = 1 order by patientOpdNumber asc "
	),
        @NamedQuery(
	name = "findVisitOccuranceByPatient",
	query = "from TAppointment where patientNameId = ? and appointmentStatus = 1 and patientStatus = 0 "
	),
        @NamedQuery(
	name = "getAppointmentList",
	query = "from TAppointment where appointmentDate = ? OR (monthname(appointmentDate)= ? AND year(appointmentDate)= ?) OR year(appointmentDate)= ? ORDER BY appointmentDate,patientOpdNumber "
        ),
        @NamedQuery(
	name = "getAppointmentListByDeptWise",
	query = "from TAppointment where (appointmentDate = ? OR (monthname(appointmentDate)= ? AND year(appointmentDate)= ?) OR year(appointmentDate)= ?) AND departmentNameId = ? ORDER BY appointmentDate,patientOpdNumber "
        )        
})

@Entity
@Table(name="t_doctor_appointment")
public class TAppointment implements java.io.Serializable {
    
    /** The id. */
    @Id
    //@GeneratedValue
    @GeneratedValue(strategy = GenerationType.IDENTITY)
     private Long id;
    
    /** The appointment date. */
    @Temporal(javax.persistence.TemporalType.DATE)
    @Column(name="appointment_date")
     private Date appointmentDate;
    
    /** The doctor name id. */
    @ManyToOne
    @JoinColumn(name="doctor_name_id")
    private TDoctorInformation doctorNameId;
    
    /** The patient name id. */
    @ManyToOne
    @JoinColumn(name="patient_name_id")
     private TPatient patientNameId;
    
    /** The department name id. */
    @ManyToOne
    @JoinColumn(name="department_name_id")
     private TDepartmentMaster departmentNameId;
    
    /** The appointment time. */
    @Column(name="appointment_time")
     private String appointmentTime;
             
    /** The visit type. */
    @Column(name="visit_type")
     private String visitType;
    
    /** The visit interval. */
    @Column(name="visit_interval")
     private Integer visitInterval;
    
    /** The appointment status. */
    @Column(name="appointment_status")
     private int appointmentStatus;
    
    /** The patient status. */
    @Column(name="patient_status")
     private int patientStatus;
    
    /** The patient checkin time. */
    @Temporal(javax.persistence.TemporalType.TIME)
    @Column(name="patient_checkin_time")
     private Date patientCheckinTime;
    
    /** The patient checkout time. */
    @Temporal(javax.persistence.TemporalType.TIME)
    @Column(name="patient_checkout_time")
     private Date patientCheckoutTime;
    
    /** The patient opd number. */
    @Column(name="patient_opd_number")
     private Integer patientOpdNumber;
    
    
    /** The appointment notes. */
    @Column(name="appointment_notes")
     private String appointmentNotes;
            
    /** The created by. */
    @Column(name="created_by")
     private String createdBy;
    
    /** The created date. */
    @Temporal(javax.persistence.TemporalType.TIMESTAMP)
    @Column(name="created_date")
     private Date createdDate;
    
    /** The updated date. */
    @Temporal(javax.persistence.TemporalType.TIMESTAMP)
    @Column(name="updated_date")
     private Date updatedDate;
    
    /** The record version. */
    @Version
    @Column(name = "record_version")
    private Long recordVersion;  
    
    /** The visit number. */
    @Column(name="visit_number")
     private Integer visitNumber;
    
    /** The paid amount. */
    @Column(name="paid_amount")
     private Double paidAmount;
    
    /** The free patient. */
    @Column(name="free_patient")
     private String free_patient;
    
    /** The schedule type. */
    @Column(name="schedule_type")
     private String scheduleType;
    
    /**
     * Gets the id.
     *
     * @return the id
     */
    public Long getId() {
        return id;
    }

    /**
     * Sets the id.
     *
     * @param id the new id
     */
    public void setId(Long id) {
        this.id = id;
    }

    /**
     * Gets the appointment date.
     *
     * @return the appointment date
     */
    public Date getAppointmentDate() {
        return appointmentDate;
    }

    /**
     * Sets the appointment date.
     *
     * @param appointmentDate the new appointment date
     */
    public void setAppointmentDate(Date appointmentDate) {
        this.appointmentDate = appointmentDate;
    }

    /**
     * Gets the doctor name id.
     *
     * @return the doctor name id
     */
    public TDoctorInformation getDoctorNameId() {
        return doctorNameId;
    }

    /**
     * Sets the doctor name id.
     *
     * @param doctorNameId the new doctor name id
     */
    public void setDoctorNameId(TDoctorInformation doctorNameId) {
        this.doctorNameId = doctorNameId;
    }

    /**
     * Gets the patient name id.
     *
     * @return the patient name id
     */
    public TPatient getPatientNameId() {
        return patientNameId;
    }

    /**
     * Sets the patient name id.
     *
     * @param patientNameId the new patient name id
     */
    public void setPatientNameId(TPatient patientNameId) {
        this.patientNameId = patientNameId;
    }

    /**
     * Gets the department name id.
     *
     * @return the department name id
     */
    public TDepartmentMaster getDepartmentNameId() {
        return departmentNameId;
    }

    /**
     * Sets the department name id.
     *
     * @param departmentNameId the new department name id
     */
    public void setDepartmentNameId(TDepartmentMaster departmentNameId) {
        this.departmentNameId = departmentNameId;
    }

    /**
     * Gets the appointment time.
     *
     * @return the appointment time
     */
    public String getAppointmentTime() {
        return appointmentTime;
    }

    /**
     * Sets the appointment time.
     *
     * @param appointmentTime the new appointment time
     */
    public void setAppointmentTime(String appointmentTime) {
        this.appointmentTime = appointmentTime;
    }

    /**
     * Gets the visit type.
     *
     * @return the visit type
     */
    public String getVisitType() {
        return visitType;
    }

    /**
     * Sets the visit type.
     *
     * @param visitType the new visit type
     */
    public void setVisitType(String visitType) {
        this.visitType = visitType;
    }

    /**
     * Gets the visit interval.
     *
     * @return the visit interval
     */
    public Integer getVisitInterval() {
        return visitInterval;
    }

    /**
     * Sets the visit interval.
     *
     * @param visitInterval the new visit interval
     */
    public void setVisitInterval(Integer visitInterval) {
        this.visitInterval = visitInterval;
    }

    
    
    /**
     * Gets the appointment status.
     *
     * @return the appointment status
     */
    public int getAppointmentStatus() {
        return appointmentStatus;
    }

    /**
     * Sets the appointment status.
     *
     * @param appointmentStatus the new appointment status
     */
    public void setAppointmentStatus(int appointmentStatus) {
        this.appointmentStatus = appointmentStatus;
    }

    /**
     * Gets the patient status.
     *
     * @return the patient status
     */
    public int getPatientStatus() {
        return patientStatus;
    }

    /**
     * Sets the patient status.
     *
     * @param patientStatus the new patient status
     */
    public void setPatientStatus(int patientStatus) {
        this.patientStatus = patientStatus;
    }

    /**
     * Gets the patient checkin time.
     *
     * @return the patient checkin time
     */
    public Date getPatientCheckinTime() {
        return patientCheckinTime;
    }

    /**
     * Sets the patient checkin time.
     *
     * @param patientCheckinTime the new patient checkin time
     */
    public void setPatientCheckinTime(Date patientCheckinTime) {
        this.patientCheckinTime = patientCheckinTime;
    }

    /**
     * Gets the patient checkout time.
     *
     * @return the patient checkout time
     */
    public Date getPatientCheckoutTime() {
        return patientCheckoutTime;
    }

    /**
     * Sets the patient checkout time.
     *
     * @param patientCheckoutTime the new patient checkout time
     */
    public void setPatientCheckoutTime(Date patientCheckoutTime) {
        this.patientCheckoutTime = patientCheckoutTime;
    }

    /**
     * Gets the patient opd number.
     *
     * @return the patient opd number
     */
    public Integer getPatientOpdNumber() {
        return patientOpdNumber;
    }

    /**
     * Sets the patient opd number.
     *
     * @param patientOpdNumber the new patient opd number
     */
    public void setPatientOpdNumber(Integer patientOpdNumber) {
        this.patientOpdNumber = patientOpdNumber;
    }

    /**
     * Gets the appointment notes.
     *
     * @return the appointment notes
     */
    public String getAppointmentNotes() {
        return appointmentNotes;
    }

    /**
     * Sets the appointment notes.
     *
     * @param appointmentNotes the new appointment notes
     */
    public void setAppointmentNotes(String appointmentNotes) {
        this.appointmentNotes = appointmentNotes;
    }

    /**
     * Gets the created by.
     *
     * @return the created by
     */
    public String getCreatedBy() {
        return createdBy;
    }

    /**
     * Sets the created by.
     *
     * @param createdBy the new created by
     */
    public void setCreatedBy(String createdBy) {
        this.createdBy = createdBy;
    }

    /**
     * Gets the created date.
     *
     * @return the created date
     */
    public Date getCreatedDate() {
        return createdDate;
    }

    /**
     * Sets the created date.
     *
     * @param createdDate the new created date
     */
    public void setCreatedDate(Date createdDate) {
        this.createdDate = createdDate;
    }

    /**
     * Gets the updated date.
     *
     * @return the updated date
     */
    public Date getUpdatedDate() {
        return updatedDate;
    }

    /**
     * Sets the updated date.
     *
     * @param updatedDate the new updated date
     */
    public void setUpdatedDate(Date updatedDate) {
        this.updatedDate = updatedDate;
    }

    /**
     * Gets the record version.
     *
     * @return the record version
     */
    public Long getRecordVersion() {
        return recordVersion;
    }

    /**
     * Sets the record version.
     *
     * @param recordVersion the new record version
     */
    public void setRecordVersion(Long recordVersion) {
        this.recordVersion = recordVersion;
    }

    /**
     * Gets the visit number.
     *
     * @return the visit number
     */
    public Integer getVisitNumber() {
        return visitNumber;
    }

    /**
     * Sets the visit number.
     *
     * @param visitNumber the new visit number
     */
    public void setVisitNumber(Integer visitNumber) {
        this.visitNumber = visitNumber;
    }

    public Double getPaidAmount() {
        return paidAmount;
    }

    public void setPaidAmount(Double paidAmount) {
        this.paidAmount = paidAmount;
    }

    public String getFree_patient() {
        return free_patient;
    }

    public void setFree_patient(String free_patient) {
        this.free_patient = free_patient;
    }

    public String getScheduleType() {
        return scheduleType;
    }

    public void setScheduleType(String scheduleType) {
        this.scheduleType = scheduleType;
    }
    
    
    
    /**
     * Clone appointment.
     *
     * @param appointment the appointment
     * @return the t appointment
     */
    public TAppointment cloneAppointment(TAppointment appointment){
            
        TAppointment appoint = new TAppointment();
        appoint.setDoctorNameId(appointment.getDoctorNameId());
        appoint.setPatientNameId(appointment.getPatientNameId());
        appoint.setDepartmentNameId(appointment.getDepartmentNameId());
        appoint.setAppointmentTime(appointment.getAppointmentTime());
        appoint.setVisitType(appointment.getVisitType());
        return appoint;
        
        
    }
    
    /**
     * Clone appointment by time.
     *
     * @param appointment the appointment
     * @return the t appointment
     */
    public TAppointment cloneAppointmentByTime(TAppointment appointment){
            
        TAppointment appoint = new TAppointment();
        appoint.setAppointmentDate(appointment.getAppointmentDate());
        appoint.setDoctorNameId(appointment.getDoctorNameId());
        appoint.setPatientNameId(appointment.getPatientNameId());
        appoint.setDepartmentNameId(appointment.getDepartmentNameId());
        appoint.setAppointmentTime(appointment.getAppointmentTime());
        appoint.setVisitType(appointment.getVisitType());
        appoint.setAppointmentStatus(appointment.getAppointmentStatus());
        appoint.setPatientStatus(appointment.getPatientStatus());
        appoint.setFree_patient(appointment.getFree_patient());
        appoint.setPaidAmount(appointment.getPaidAmount());
        return appoint;
        
        
    }
}