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 java.math.RoundingMode;

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;

import org.eclipse.persistence.annotations.OptimisticLocking;
import org.eclipse.persistence.annotations.OptimisticLockingType;

/**
 * 
 */
@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") })
@OptimisticLocking(type = OptimisticLockingType.CHANGED_COLUMNS)
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;

    @JoinColumn(name = "lineProduct_id", referencedColumnName = "id", nullable = true, updatable = 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 bill2, Product product, BigDecimal count) {
        super(bill2.getEvent());
        this.bill = bill2;
        this.lineProduct = product;
        this.name = product.getName();
        this.setUnitName(product.getUnitName());
        this.setQuantity(count);
        this.setUnitPrice(product.getPrice());
        this.setVat(product.getVat());
    }

    public BillLine(Bill bill2, Product product, Discount disc, BigDecimal count) {
        super(bill2.getEvent());
        this.bill = bill2;
        BigDecimal unitPrice = product.getPrice().subtract(product.getPrice().multiply(disc.getPercentage())).negate().setScale(2, RoundingMode.HALF_UP);
        BigDecimal vatPrice = product.getVat().subtract(product.getVat().multiply(disc.getPercentage())).negate().setScale(2, RoundingMode.HALF_UP);
        this.name = disc.getShortdesc();
        this.unitName = product.getUnitName();
        this.quantity = count;
        this.unitPrice = unitPrice;
        this.vat = vatPrice;
    }

    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;
    }

}