/*
 * 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;

/**
 *
 * @author User1
 */
@NamedQueries({
        @NamedQuery(
	name = "findMaxReceiptId",
	query = "from TPatLabReceipt receipt where id=(select max(id) from TPatLabReceipt)"
	),
        @NamedQuery(
	name = "findAvailableLabReceipt",
	query = "from TPatLabReceipt receipt where receipt.patientId =? and receipt.encounterId =?"
	),
        @NamedQuery(
	name = "getLabReceiptList",
	query = "from TPatLabReceipt where DATE(receiptDate) = ? OR (monthname(receiptDate)= ? AND year(receiptDate)= ?) OR year(receiptDate)= ? ORDER BY receiptDate "
        )
	
})



@Entity
@Table(name="t_pat_lab_receipt")
public class TPatLabReceipt implements java.io.Serializable{
    
    @Id
    //@GeneratedValue
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name="id")
    private Long id;
    
    @ManyToOne
    @JoinColumn(name="patient_id")
    private TPatient patientId;
    
    @ManyToOne
    @JoinColumn(name="encounter_id")
    private TPatientEncounter encounterId;
    
    @Column(name="receipt_number")
    private String receiptNumber;
    
    @Column(name="total_price")
    private String totalTrice;
    
    @Column(name="paid_amount")
    private String paidPrice;
    
    @Column(name="due_amount")
    private String dueAmount;
    
    @Column(name="adjustment_amount")
    private String adjustmentAmount;
    
    @Column(name="comments")
    private String comments;
    
    @Column(name="received_by")
    private String receivedBy;
    
    @Temporal(javax.persistence.TemporalType.TIMESTAMP)
    @Column(name="receipt_date")
    private Date receiptDate;

    @Version
    @Column(name = "record_version")
    private Long recordVersion;
    
    public Long getId() {
        return id;
    }

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

    public TPatient getPatientId() {
        return patientId;
    }

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

    public String getReceiptNumber() {
        return receiptNumber;
    }

    public void setReceiptNumber(String receiptNumber) {
        this.receiptNumber = receiptNumber;
    }

    public String getTotalTrice() {
        return totalTrice;
    }

    public void setTotalTrice(String totalTrice) {
        this.totalTrice = totalTrice;
    }

    public String getPaidPrice() {
        return paidPrice;
    }

    public void setPaidPrice(String paidPrice) {
        this.paidPrice = paidPrice;
    }

    public String getAdjustmentAmount() {
        return adjustmentAmount;
    }

    public void setAdjustmentAmount(String adjustmentAmount) {
        this.adjustmentAmount = adjustmentAmount;
    }

    public String getComments() {
        return comments;
    }

    public void setComments(String comments) {
        this.comments = comments;
    }

    public String getReceivedBy() {
        return receivedBy;
    }

    public void setReceivedBy(String receivedBy) {
        this.receivedBy = receivedBy;
    }

    public Date getReceiptDate() {
        return receiptDate;
    }

    public void setReceiptDate(Date receiptDate) {
        this.receiptDate = receiptDate;
    }

    public TPatientEncounter getEncounterId() {
        return encounterId;
    }

    public void setEncounterId(TPatientEncounter encounterId) {
        this.encounterId = encounterId;
    }

    public Long getRecordVersion() {
        return recordVersion;
    }

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

    public String getDueAmount() {
        return dueAmount;
    }

    public void setDueAmount(String dueAmount) {
        this.dueAmount = dueAmount;
    }
    
    
}