Product.java

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

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

import javax.persistence.CascadeType;
import javax.persistence.CollectionTable;
import javax.persistence.Column;
import javax.persistence.ElementCollection;
import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.Lob;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import javax.persistence.UniqueConstraint;

import org.eclipse.persistence.annotations.PrivateOwned;

/**
 * 
 */
@Entity
@Table(name = "products")
public class Product extends GenericEntity {

    private static final String PRODUCTFLAG_TABLE_PRODUCTID = "product_id";
    private static final String PRODUCTFLAG_TABLE_COLUMN = "productflags";
    private static final long serialVersionUID = 1L;
    public static final String EVENT_ID_COLUMN = "event_id";

    public static final Product EMPTY_PRODUCT = new Product("----");

    @ManyToOne()
    @JoinColumn(name = EVENT_ID_COLUMN, nullable = false)
    private LanEvent event;

    private String color;

    @Column(name = "product_name")
    private String name;
    @Column(name = "description")
    @Lob
    private String description;

    @Column(name = "price", nullable = false, precision = 24, scale = 4)
    private BigDecimal price = BigDecimal.ZERO;

    @Column(name = "buy_in_price", nullable = true, precision = 24, scale = 4)
    private BigDecimal buyInPrice = BigDecimal.ZERO;

    @Column(name = "sort", nullable = false)
    private int sort;

    @Column(name = "barcode")
    private String barcode;

    
    @OneToMany(cascade = CascadeType.ALL, mappedBy = "product")
    private List<LicenseTarget> licenseTargets;
    
    
    @Enumerated(EnumType.STRING)
    @PrivateOwned
    @ElementCollection()
    @CollectionTable(
            joinColumns = @JoinColumn(name = PRODUCTFLAG_TABLE_PRODUCTID, referencedColumnName = ID_COLUMN),
            uniqueConstraints = @UniqueConstraint(columnNames = { PRODUCTFLAG_TABLE_PRODUCTID, PRODUCTFLAG_TABLE_COLUMN }))
    @Column(name = PRODUCTFLAG_TABLE_COLUMN)
    private Set<ProductFlag> productFlags = new HashSet<ProductFlag>();

    @JoinColumn(name = "provided_role_id", referencedColumnName = Role.ID_COLUMN)
    @ManyToOne
    private Role provides;

    @OneToMany(cascade = CascadeType.ALL, mappedBy = "product")
    private List<Place> places;

    @ManyToMany()
    private List<ProductLimitation> productLimits;

    @OneToMany(cascade = CascadeType.ALL, mappedBy = "product")
    private List<AccountEvent> accountEvents;

    @OneToMany(cascade = CascadeType.ALL, mappedBy = "product")
    private List<InventoryEvent> inventoryEvents;

    @ManyToMany(cascade = CascadeType.ALL)
    @JoinTable(name = "product_discounts",
            inverseJoinColumns = {
                    @JoinColumn(name = "discount_id", referencedColumnName = Discount.ID_COLUMN)
            },
            joinColumns = {
                    @JoinColumn(name = PRODUCTFLAG_TABLE_PRODUCTID, referencedColumnName = Product.ID_COLUMN)
            })
    private List<Discount> discounts;

    @Column(name = "vat", nullable = false, precision = 4, scale = 3)
    private BigDecimal vat = BigDecimal.ZERO;
    private String unitName = "";

    @ManyToMany()
    @JoinTable(name = "product_foodwavetemplate",
            joinColumns = {
                    @JoinColumn(name = PRODUCTFLAG_TABLE_PRODUCTID, referencedColumnName = Product.ID_COLUMN),
            },
            inverseJoinColumns = {
                    @JoinColumn(name = "food_wave_template_id", referencedColumnName = FoodWaveTemplate.ID_COLUMN)
            },
            uniqueConstraints = {
                    @UniqueConstraint(columnNames = { PRODUCTFLAG_TABLE_PRODUCTID, "food_wave_template_id" })
            })
    private List<FoodWaveTemplate> foodWaveTemplates;

    public Product() {
        super();
    }

    public Product(LanEvent event) {
        super();
        this.setEvent(event);

    }

    private Product(String string) {
        super();
        name = "----";
    }

    public BigDecimal getSoldCash() {
        BigDecimal tot = BigDecimal.ZERO;
        for (AccountEvent ac : this.getAccountEvents()) {
            if (ac.isCash()) {
                tot = tot.add(ac.getQuantity());
            }
        }
        return tot;
    }

    public BigDecimal getSoldBill() {
        BigDecimal tot = BigDecimal.ZERO;
        for (AccountEvent ac : this.getAccountEvents()) {
            if (!ac.isCash()) {
                tot = tot.add(ac.getQuantity());
            }
        }
        return tot;
    }

    public BigDecimal getInventoryCount() {
        BigDecimal ret = new BigDecimal(0);

        if (accountEvents != null) {
            for (AccountEvent ae : accountEvents) {
                ret = ret.subtract(ae.getQuantity());
            }
        }
        if (inventoryEvents != null) {
            for (InventoryEvent ie : inventoryEvents) {
                ret = ret.add(ie.getQuantity());
            }
        }

        return ret;
    }

    public String getName() {
        return name;
    }

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

    /** 
     * Get product price, includes vat
     * @return
     */
    public BigDecimal getPrice() {
        return price;
    }

    /** 
     * Set price, including vat
     * @param price
     */
    public void setPrice(BigDecimal price) {
        this.price = price;
    }

    public int getSort() {
        return sort;
    }

    public void setSort(int sort) {
        this.sort = sort;
    }

    public String getBarcode() {
        return barcode;
    }

    public void setBarcode(String barcode) {
        this.barcode = barcode;
    }

    public List<Place> getPlaces() {
        return places;
    }

    public void setPlaces(List<Place> placeList) {
        this.places = placeList;
    }

    public List<AccountEvent> getAccountEvents() {
        return accountEvents;
    }

    public void setAccountEvents(List<AccountEvent> accountEventList) {
        this.accountEvents = accountEventList;
    }

    public void setDiscounts(List<Discount> discounts) {
        this.discounts = discounts;
    }

    public List<Discount> getDiscounts() {
        return discounts;
    }

    public void setFoodWaveTemplates(List<FoodWaveTemplate> foodWaveTemplates) {
        this.foodWaveTemplates = foodWaveTemplates;
    }

    public List<FoodWaveTemplate> getFoodWaveTemplates() {
        return foodWaveTemplates;
    }

    /**
     * Set product vat-%, value between 0 and 1
     * @param vat
     */
    public void setVat(BigDecimal vat) {
        this.vat = vat;
    }

    /** 
     * Get product vat-%, value between 0 and 1
     * @return
     */
    public BigDecimal getVat() {
        return vat;
    }

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

    public String getUnitName() {
        return unitName;
    }

    public void setProvides(Role provides) {
        this.provides = provides;
    }

    public Role getProvides() {
        return provides;
    }

    public LanEvent getEvent() {
        return event;
    }

    public void setEvent(LanEvent event) {
        this.event = event;
    }

    public String getColor() {
        return color;
    }

    public void setColor(String color) {
        this.color = color;
    }

    public Set<ProductFlag> getProductFlags() {
        return productFlags;
    }

    public void setProductFlags(Set<ProductFlag> productFlags) {
        this.productFlags = productFlags;
    }

    public List<ProductLimitation> getProductLimits() {
        return productLimits;
    }

    public void setProductLimits(List<ProductLimitation> productLimits) {
        this.productLimits = productLimits;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public BigDecimal getBuyInPrice() {
        return buyInPrice;
    }

    public void setBuyInPrice(BigDecimal buyInPrice) {
        this.buyInPrice = buyInPrice;
    }

    public List<InventoryEvent> getInventoryEvents() {
        return inventoryEvents;
    }

    public void setInventoryEvents(List<InventoryEvent> inventoryEvents) {
        this.inventoryEvents = inventoryEvents;
    }

    public List<LicenseTarget> getLicenseTargets() {
        return licenseTargets;
    }

    public void setLicenseTargets(List<LicenseTarget> licenseTargets) {
        this.licenseTargets = licenseTargets;
    }

}