Bill.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.util.Calendar;
import java.util.List;

import javax.persistence.Column;
import javax.persistence.EmbeddedId;
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.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import javax.persistence.Version;
import static javax.persistence.TemporalType.DATE;

/**
 * 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")
@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") })
public class Bill implements EventChildInterface {

    private static final long serialVersionUID = 1L;

    @EmbeddedId
    private EventPk id;

    /**
     * When the bill is due to be paid.
     */
    @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")
    private List<BillLine> billLines;

    /**
     * When the bill is paid this AccountEvent is created and this is a
     * reference to that accountAction.
     */
    @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.
     */
    @JoinColumn(name = "user_id", referencedColumnName = "user_id", nullable = false)
    @ManyToOne(optional = false)
    private User user;

    @ManyToOne
    @JoinColumn(name = "event_id", referencedColumnName = "event_id", updatable = false, insertable = false)
    private LanEvent event;

    public Integer getReferenceNumberBase() {
        return event.getReferenceNumberBase() + billNumber;
    }

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

    @Override
    public EventPk getId() {
        return id;
    }

    @Override
    public void setId(EventPk id) {
        this.id = id;
    }

    @Version
    @Column(nullable = false)
    private int jpaVersionField = 0;

    public Bill() {
    }

    public Bill(LanEvent event) {
        this.id = new EventPk(event);
    }

    public Calendar getDueDate() {
        return dueDate;
    }

    public void setDueDate(Calendar dueDate) {
        this.dueDate = 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;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (id != null ? id.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are
        // not set
        if (!(object instanceof Bill)) {
            return false;
        }
        Bill other = (Bill) object;
        if ((this.id == null && other.id != null)
                || (this.id != null && !this.id.equals(other.id))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "fi.insomnia.bortal.model.Bill[id=" + id + "]";
    }

    @Override
    public void setJpaVersionField(int jpaVersionField) {
        this.jpaVersionField = jpaVersionField;
    }

    @Override
    public int getJpaVersionField() {
        return jpaVersionField;
    }

    public LanEvent getEvent() {
        return event;
    }

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

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

}