BillLine.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package fi.insomnia.bortal.model;

import java.math.BigDecimal;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.JoinColumn;
import javax.persistence.JoinColumns;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToOne;
import javax.persistence.OrderBy;
import javax.persistence.Table;

/**
 * 
 */
@Entity
@Table(name = "bill_lines")
@NamedQueries({
        @NamedQuery(name = "BillLine.findAll", query = "SELECT b FROM BillLine b"),

        @NamedQuery(name = "BillLine.findByProduct", query = "SELECT b FROM BillLine b WHERE b.name = :name"),
        @NamedQuery(name = "BillLine.findByQuantity", query = "SELECT b FROM BillLine b WHERE b.quantity = :quantity"),
        @NamedQuery(name = "BillLine.findByUnitPrice", query = "SELECT b FROM BillLine b WHERE b.unitPrice = :unitPrice"),
        @NamedQuery(name = "BillLine.findByVat", query = "SELECT b FROM BillLine b WHERE b.vat = :vat") })
public class BillLine extends GenericEventChild {
    private static final long serialVersionUID = 1L;
    private static final BigDecimal DEFAULT_VAT = BigDecimal.ZERO;

    /**
     * Product name shown on the bill
     */
    @Column(name = "product_name", nullable = false)
    private String name;

    /**
     * How many quantity the of the product has been purchased eg. 14 (Entrance
     * tickets), 1.5 (l) eh.. something..
     */
    @Column(name = "quantity", nullable = false, precision = 24, scale = 4)
    private BigDecimal quantity = BigDecimal.ZERO;

    /**
     * How much one(1) unit of this product costs
     * 
     */
    @Column(name = "unit_price", nullable = false, precision = 24, scale = 4)
    private BigDecimal unitPrice = BigDecimal.ZERO;

    /**
     * 
     */
    @Column(name = "unit_name", nullable = false)
    private String unitName = "";

    /**
     * How much VAT this product contains ( 0, 0.22 ) etc
     */
    @Column(name = "vat", nullable = false, precision = 4, scale = 3)
    private BigDecimal vat = DEFAULT_VAT;

    /**
     * Which bill this bill line belongs to
     */
    @JoinColumns({
            @JoinColumn(name = "bill_id", referencedColumnName = "id", nullable = false, updatable = false),
            @JoinColumn(name = "event_id", referencedColumnName = "event_id", nullable = false, updatable = false, insertable = false) })
    @ManyToOne
    private Bill bill;

    @JoinColumns({
            @JoinColumn(name = "lineProduct_id", referencedColumnName = "id", nullable = true, updatable = false),
            @JoinColumn(name = "event_id", referencedColumnName = "event_id", nullable = false, updatable = false, insertable = false) })
    @OneToOne
    @OrderBy("id.id")
    private Product lineProduct;

    /**
     * Calculate the total price for the items on this line
     * 
     * @return
     */
    public BigDecimal getLinePrice() {
        BigDecimal vatMultiplicand = BigDecimal.ONE.add(getVat());
        return getLinePriceVatless().multiply(vatMultiplicand);
    }

    public BigDecimal getLineVat() {
        return getLinePriceVatless().multiply(getVat());
    }

    /**
     * Calculate the total VAT-less price for the items on this lin
     * 
     * @return
     */
    public BigDecimal getLinePriceVatless() {
        return getUnitPrice().multiply(getQuantity());
    }

    public BillLine() {
        super();
    }

    public BillLine(Bill bill) {
        super();
        setId(new EventPk(bill.getId().getEventId()));
        this.bill = bill;
    }

    public BillLine(Bill bill, String product, String unitName, BigDecimal units,
            BigDecimal unitPrice, BigDecimal vat) {
        this(bill);
        this.unitName = unitName;
        this.name = product;
        this.setQuantity(units);
        this.setUnitPrice(unitPrice);
        this.setVat(vat);
    }

    public String getName() {
        return name;
    }

    public void setName(String product) {
        this.name = product;
    }

    public Bill getBill() {
        return bill;
    }

    public void setBill(Bill billsId) {
        this.bill = billsId;
    }

    public void setQuantity(BigDecimal units) {
        this.quantity = units;
    }

    public BigDecimal getQuantity() {
        return quantity;
    }

    public void setUnitPrice(BigDecimal price) {
        this.unitPrice = price;
    }

    public BigDecimal getUnitPrice() {
        return unitPrice;
    }

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

    public BigDecimal getVat() {
        return vat;
    }

    public void setUnitName(String unitName) {
        this.unitName = unitName;
    }

    public String getUnitName() {
        return unitName;
    }

    public void setLineProduct(Product lineProduct) {
        this.lineProduct = lineProduct;
    }

    public Product getLineProduct() {
        return lineProduct;
    }

}