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

import java.util.Date;
import java.util.Set;
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.OneToMany;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.Version;

/**
 *
 * @author User1
 */
@NamedQueries({
    @NamedQuery(
            name = "findBillingNumber",
            query = "from TPharmacyBilling billing where billingType= ? order by id asc"
            ),
    @NamedQuery(
            name = "findBillByDate",
            query = "from TPharmacyBilling bill where bill.billingType= ? AND bill.billingDate= ? order by id asc"
            ),
    @NamedQuery(
            name = "findBillByBillNo",
            query = "from TPharmacyBilling pbill where pbill.billingNumber= ?  order by id asc"
            ),
    @NamedQuery(
            name = "getAvailablePurchaseByStockistByDate",
            query = "from TPharmacyBilling  where stockistDetail = ? and billingDate = ? order by id asc"
            ),
    @NamedQuery(
            name = "getAvailablePurchaseByStockistByBalanceAmount",
            query = "from TPharmacyBilling  where balanceAmount > 0 order by id asc"
            ),
    @NamedQuery(
            name = "getAvailablePurchaseByStockistByMonth",
            query = "from TPharmacyBilling  where stockistDetail = ? and monthname(billingDate) = ? AND year(billingDate) = ? order by id asc"
            ),
    @NamedQuery(
            name = "getAvailablePurchaseByStockistByYear",
            query = "from TPharmacyBilling  where stockistDetail = ? AND year(billingDate) = ? order by id asc"
            ),
    @NamedQuery(
            name = "updateDueBalanceAmount",
            query = "update TPharmacyBilling set paidPrice= ?, balanceAmount = ? where stockistDetail = ?"
            )
})
@Entity
@Table(name="t_pharmacy_billing")
public class TPharmacyBilling implements java.io.Serializable{
    
    @Id
    //@GeneratedValue
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name="id")
    private Long id;
    
    @Temporal(javax.persistence.TemporalType.DATE)
    @Column(name="billing_date")
     private Date billingDate;
    
    @Column(name="billing_number")
    private String billingNumber;
    
    @Column(name="billing_type")
    private String billingType;
    
    @ManyToOne
    @JoinColumn(name="patient_detail")
    private TPatient patientDetail;
    
    @ManyToOne
    @JoinColumn(name="stockist_detail")
    private TStockiestDetailMaster stockistDetail;
    
    @Column(name="total_product_price")
    private Double totalProductPrice ;
    
    @Column(name="tax")
    private Double tax ;
    
    @Column(name="vat")
    private Double vat ;
    
    @Column(name="discount_price")
    private Double discountPrice ;
    
    @Column(name="total_price_to_be_paid")
    private Double totalPriceToBePaid ;
    
    @Column(name="paid_price")
    private Double paidPrice ;
    
    @Column(name="balance_amount")
    private Double balanceAmount ;
    
    /** The created date. */
    @Column(name="created_date")
    @Temporal(javax.persistence.TemporalType.TIMESTAMP)
     private Date createdDate;

    /** The updated date. */
    @Column(name="updated_date")
    @Temporal(javax.persistence.TemporalType.TIMESTAMP)
     private Date updatedDate;

     /** The record version. */
    @Version
    @Column(name = "record_version")
    private Long recordVersion;
    
    @OneToMany(mappedBy="pharmacyBillingpurchase")
    private Set<TPharmacyPurchase> purchase;
    
    @OneToMany(mappedBy="salesBillingNumber")
    private Set<TPharmacySales> sales;    

    @Column(name="created_by")
    private String createdBy;
    
    @Column(name="updated_by")
    private String updatedBy;
    
    public Long getId() {
        return id;
    }

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

    public Date getBillingDate() {
        return billingDate;
    }

    public void setBillingDate(Date billingDate) {
        this.billingDate = billingDate;
    }

    public String getBillingNumber() {
        return billingNumber;
    }

    public void setBillingNumber(String billingNumber) {
        this.billingNumber = billingNumber;
    }

    public String getBillingType() {
        return billingType;
    }

    public void setBillingType(String billingType) {
        this.billingType = billingType;
    }

    public Double getTotalProductPrice() {
        return totalProductPrice;
    }

    public void setTotalProductPrice(Double totalProductPrice) {
        this.totalProductPrice = totalProductPrice;
    }

    public Double getTax() {
        return tax;
    }

    public void setTax(Double tax) {
        this.tax = tax;
    }

    public Double getVat() {
        return vat;
    }

    public void setVat(Double vat) {
        this.vat = vat;
    }

    public Double getDiscountPrice() {
        return discountPrice;
    }

    public void setDiscountPrice(Double discountPrice) {
        this.discountPrice = discountPrice;
    }

    public Double getTotalPriceToBePaid() {
        return totalPriceToBePaid;
    }

    public void setTotalPriceToBePaid(Double totalPriceToBePaid) {
        this.totalPriceToBePaid = totalPriceToBePaid;
    }

    public Double getPaidPrice() {
        return paidPrice;
    }

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

    public Double getBalanceAmount() {
        return balanceAmount;
    }

    public void setBalanceAmount(Double balanceAmount) {
        this.balanceAmount = balanceAmount;
    }

    public Set<TPharmacyPurchase> getPurchase() {
        return purchase;
    }

    public void setPurchase(Set<TPharmacyPurchase> purchase) {
        this.purchase = purchase;
    }

    public Set<TPharmacySales> getSales() {
        return sales;
    }

    public void setSales(Set<TPharmacySales> sales) {
        this.sales = sales;
    }

    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 Long getRecordVersion() {
        return recordVersion;
    }

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

    public String getCreatedBy() {
        return createdBy;
    }

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

    public String getUpdatedBy() {
        return updatedBy;
    }

    public void setUpdatedBy(String updatedBy) {
        this.updatedBy = updatedBy;
    }

    public TPatient getPatientDetail() {
        return patientDetail;
    }

    public void setPatientDetail(TPatient patientDetail) {
        this.patientDetail = patientDetail;
    }

    public TStockiestDetailMaster getStockistDetail() {
        return stockistDetail;
    }

    public void setStockistDetail(TStockiestDetailMaster stockistDetail) {
        this.stockistDetail = stockistDetail;
    }
    
    
}