Bill.java

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

import java.util.Calendar;
import java.util.List;

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

/**
 * 
 * @author jkj
 */
@Entity
@Table(name = "bills")
@NamedQueries( {
        @NamedQuery(name = "Bill.findAll", query = "SELECT b FROM Bill b"),
        // @NamedQuery(name = "Bill.findById", query =

        @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.findByReferenceNumber", query = "SELECT b FROM Bill b WHERE b.referenceNumber = :referenceNumber"),
        @NamedQuery(name = "Bill.findByNotes", query = "SELECT b FROM Bill b WHERE b.notes = :notes") })
public class Bill implements ModelInterface {

    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "bills_id", nullable = false)
    private Integer id;

    @Column(name = "due_date")
    @Temporal(TemporalType.TIMESTAMP)
    private Calendar dueDate;

    @Column(name = "paid_date")
    @Temporal(TemporalType.TIMESTAMP)
    private Calendar paidDate;

    @Column(name = "reference_number")
    private String referenceNumber;

    @Lob
    @Column(name = "notes")
    private String notes;

    @OneToMany(mappedBy = "bill")
    private List<BillLine> billLines;

    @JoinColumn(name = "accout_events_id", referencedColumnName = "account_events_id")
    @OneToOne
    private AccountEvent accountEvent;

    @JoinColumn(name = "users_id", referencedColumnName = "users_id", nullable = false)
    @ManyToOne(optional = false)
    private User user;

    
    @ManyToOne
    @JoinColumn(name = "events_id", referencedColumnName = "events_id")
    private Event event;


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

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



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

    public Bill() {
    }

    public Bill(Integer billsId) {
        this.id = billsId;
    }

    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 getReferenceNumber() {
        return referenceNumber;
    }

    public void setReferenceNumber(String referenceNumber) {
        this.referenceNumber = referenceNumber;
    }

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

    /**
     * @return the event
     */
    public Event getEvent() {
        return event;
    }

    /**
     * @param event the event to set
     */
    public void setEvent(Event event) {
        this.event = event;
    }
}