Bill.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package fi.insomnia.bortal.model;

import static javax.persistence.TemporalType.DATE;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.JoinColumn;
import javax.persistence.JoinColumns;
import javax.persistence.Lob;
import javax.persistence.ManyToOne;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;
import javax.persistence.OneToOne;
import javax.persistence.OrderBy;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import javax.persistence.UniqueConstraint;

import org.eclipse.persistence.annotations.OptimisticLocking;
import org.eclipse.persistence.annotations.OptimisticLockingType;
import org.eclipse.persistence.annotations.PrivateOwned;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

/**
 * The system can send bills to the users. When user pays bill a AccountEvent
 * row is created for product whose price is +1 and Bills paidDate is changed to
 * not null.
 */
@Entity
@Table(name = "bills", uniqueConstraints = { @UniqueConstraint(columnNames = { "event_id", "bill_number" }) })
@NamedQueries({
        @NamedQuery(name = "Bill.findAll", query = "SELECT b FROM Bill b"),

        // @NamedQuery(name = "Bill.findByDueDate", query =
        // "SELECT b FROM Bill b WHERE b.dueDate = :dueDate"),
        @NamedQuery(name = "Bill.findByPaidDate", query = "SELECT b FROM Bill b WHERE b.paidDate = :paidDate"),
        @NamedQuery(name = "Bill.findByNotes", query = "SELECT b FROM Bill b WHERE b.notes = :notes"),
        @NamedQuery(name = "Bill.findbiggestBillNumber", query = "SELECT max(b.billNumber) from Bill b where b.event = :event") })
@OptimisticLocking(type = OptimisticLockingType.CHANGED_COLUMNS)
public class Bill extends GenericEventChild {

    /**
     * 
     */
    private static final long serialVersionUID = -6713643278149221869L;

    /**
     * When the bill is due to be paid.
     */
    // Can be calculated from SentDate + paymentTime
    // @Column(name = "due_date")
    // @Temporal(TemporalType.TIMESTAMP)
    // private Calendar dueDate;

    /**
     * When the money has appeared on the bank account.
     */
    @Column(name = "paid_date")
    @Temporal(TemporalType.TIMESTAMP)
    private Calendar paidDate;

    /**
     * The bill number from which the reference number will be generated
     * 
     * @See http://www.fkl.fi/www/page/fk_www_1293
     * 
     */
    @Column(name = "bill_number")
    private Integer billNumber;

    /**
     * Address where the bill should be sent;
     */
    private String addr1;
    private String addr2;
    private String addr3;
    private String addr4;
    private String addr5;

    @Column(nullable = false, name = "sent_time")
    @Temporal(DATE)
    private Calendar sentDate = Calendar.getInstance();

    @Column(name = "payment_time", nullable = false)
    private Integer paymentTime = 0;
    @Column(name = "notice_days", nullable = false)
    private String noticetime = "8 vrk";
    @Column(name = "their_reference", nullable = false)
    private String theirReference = "";
    @Column(name = "our_reference", nullable = false)
    private String ourReference = "";
    @Column(name = "delivery_terms", nullable = false)
    private String deliveryTerms = "";
    @Column(name = "delay_intrest", nullable = false)
    private Integer delayIntrest = 11;

    /**
     * Notes for the event organisators about the bill.
     */
    @Lob
    @Column(name = "notes")
    private String notes;

    /**
     * Bill may have multiple items on multiple rows.
     */

    @OneToMany(mappedBy = "bill", cascade = CascadeType.ALL)
    @OrderBy("id.id")
    @PrivateOwned
    private List<BillLine> billLines;

    /**
     * When the bill is paid this AccountEvent is created and this is a
     * reference to that accountAction. if this bill
     */
    @JoinColumns({
            @JoinColumn(name = "account_event_id", referencedColumnName = "id", updatable = false),
            @JoinColumn(name = "event_id", referencedColumnName = "event_id", updatable = false, insertable = false) })
    @OneToOne
    private AccountEvent accountEvent;

    /**
     * User who should pay this bill.
     */
    @ManyToOne(optional = false)
    private User user;

    private static final Logger logger = LoggerFactory.getLogger(Bill.class);

    public Integer getReferenceNumberBase() {
        if (getEvent() != null && getEvent().getReferenceNumberBase() != null && getBillNumber() != null) {
            return getEvent().getReferenceNumberBase() + getBillNumber();
        }
        return null;
    }

    /**
     * Commodity function to calculate the total price of the bill.
     * 
     * @return The total sum of the bill ( unitPrice * units * vat )
     */
    public BigDecimal totalPrice() {
        BigDecimal total = BigDecimal.ZERO;
        for (BillLine line : getBillLines()) {
            total = total.add(line.getLinePrice());
        }
        return total;
    }

    /**
     * Commodity function to calculate the total price of the bill.
     * 
     * @return The total sum of the bill ( unitPrice * units * vat )
     */
    public BigDecimal totalVat() {
        BigDecimal total = BigDecimal.ZERO;
        for (BillLine line : getBillLines()) {
            total = total.add(line.getLineVat());
        }
        return total;
    }

    /**
     * Commodity function to return the vatless price of the bill
     * 
     * @return The total VAT-less sum of the bill ( unitPrice * units )
     */
    public BigDecimal totalPriceVatless() {
        BigDecimal total = BigDecimal.ZERO;
        for (BillLine line : getBillLines()) {
            total = total.add(line.getLinePriceVatless());
        }
        return total;
    }

    public Bill(LanEvent event, User user) {
        this(event);
        this.setUser(user);
        this.setAddr1(user.getFirstnames() + " " + user.getLastname());
        this.setAddr2(user.getAddress());
        this.setAddr3(user.getZip() + " " + user.getTown());
    }

    public Bill(LanEvent event) {
        super(event);
    }

    public Bill() {
        super();
    }

    public Calendar getDueDate() {

        Calendar dueDate = (Calendar) this.getSentDate().clone();
        dueDate.add(Calendar.DATE, this.getPaymentTime());
        return dueDate;
    }

    public Calendar getPaidDate() {
        return paidDate;
    }

    public void setPaidDate(Calendar paidDate) {
        this.paidDate = paidDate;
    }

    public String getNotes() {
        return notes;
    }

    public void setNotes(String notes) {
        this.notes = notes;
    }

    public List<BillLine> getBillLines() {
        return billLines;
    }

    public void setBillLines(List<BillLine> billLineList) {
        this.billLines = billLineList;
    }

    public AccountEvent getAccountEvent() {
        return accountEvent;
    }

    public void setAccountEvent(AccountEvent accoutEventsId) {
        this.accountEvent = accoutEventsId;
    }

    public User getUser() {
        return user;
    }

    public void setUser(User usersId) {
        this.user = usersId;
    }

    public Integer getBillNumber() {
        return billNumber;
    }

    public String getAddr1() {
        return addr1;
    }

    public void setAddr1(String addr1) {
        this.addr1 = addr1;
    }

    public String getAddr2() {
        return addr2;
    }

    public void setAddr2(String addr2) {
        this.addr2 = addr2;
    }

    public String getAddr3() {
        return addr3;
    }

    public void setAddr3(String addr3) {
        this.addr3 = addr3;
    }

    public String getAddr4() {
        return addr4;
    }

    public void setAddr4(String addr4) {
        this.addr4 = addr4;
    }

    public String getAddr5() {
        return addr5;
    }

    public void setAddr5(String addr5) {
        this.addr5 = addr5;
    }

    public Calendar getSentDate() {
        return sentDate;
    }

    public void setSentDate(Calendar sentDate) {
        this.sentDate = sentDate;
    }

    public String getNoticetime() {
        return noticetime;
    }

    public void setNoticetime(String noticetime) {
        this.noticetime = noticetime;
    }

    public String getOurReference() {
        return ourReference;
    }

    public void setOurReference(String ourReference) {
        this.ourReference = ourReference;
    }

    public void setTheirReference(String theirReference) {
        this.theirReference = theirReference;
    }

    public String getTheirReference() {
        return theirReference;
    }

    public void setDeliveryTerms(String deliveryTerms) {
        this.deliveryTerms = deliveryTerms;
    }

    public String getDeliveryTerms() {
        return deliveryTerms;
    }

    public void setPaymentTime(Integer paymentTime) {
        this.paymentTime = paymentTime;
    }

    public Integer getPaymentTime() {
        return paymentTime;
    }

    public void setDelayIntrest(Integer delayIntrest) {
        this.delayIntrest = delayIntrest;
    }

    public Integer getDelayIntrest() {
        return delayIntrest;
    }

    public void addProduct(Product product, BigDecimal count) {
        // If bill number > 0 bill has been sent and extra privileges are needed
        // to modify.
        // if (!iscurrent || billnr != null) {
        // permbean.fatalPermission(BillPermission.WRITE_ALL,
        // "User tried to modify bill ", bill,
        // "without sufficient permissions");
        // }
        if (this.billLines == null) {
            billLines = new ArrayList<BillLine>();
        }
        logger.info("Adding billine: {}", this.getEvent());
        this.getBillLines().add(new BillLine(this, product, count));
        logger.info("Adding billine2: {}", this.getEvent());

        for (Discount disc : product.getActiveDiscounts(count)) {

            this.getBillLines().add(new BillLine(this, product, disc, count));

        }
    }

    public void setBillNumber(Integer billNumber) {
        this.billNumber = billNumber;
    }
}