/*
 * Created on: 24-Jan-2006
 * Author: Dibyendu Majumdar
 */
package schema1.entity.tpcc;

import java.math.BigDecimal;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.IdClass;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
import javax.persistence.Version;

@Entity
@Table(name="STOCK", schema="TPCC")
@IdClass(schema1.entity.tpcc.Stock.StockPK.class)
public class Stock {
    
    int itemId;
    int warehouseId;
    int version;
    int quantity;
    String dist1;
    String dist2;
    String dist3;
    String dist4;
    String dist5;
    String dist6;
    String dist7;
    String dist8;
    String dist9;
    String dist10;
    BigDecimal ytd;
    int orderCount;
    int remoteCount;
    String data;

    Item item;
    Warehouse warehouse;
    
    @Column(name="S_DATA", length=50)
    public String getData() {
        return data;
    }

    @Column(name="S_DIST_01", length=24)
    public String getDist1() {
        return dist1;
    }

    @Column(name="S_DIST_10", length=24)
    public String getDist10() {
        return dist10;
    }

    @Column(name="S_DIST_02", length=24)
    public String getDist2() {
        return dist2;
    }

    @Column(name="S_DIST_03", length=24)
    public String getDist3() {
        return dist3;
    }

    @Column(name="S_DIST_04", length=24)
    public String getDist4() {
        return dist4;
    }

    @Column(name="S_DIST_05", length=24)
    public String getDist5() {
        return dist5;
    }

    @Column(name="S_DIST_06", length=24)
    public String getDist6() {
        return dist6;
    }

    @Column(name="S_DIST_07", length=24)
    public String getDist7() {
        return dist7;
    }

    @Column(name="S_DIST_08", length=24)
    public String getDist8() {
        return dist8;
    }

    @Column(name="S_DIST_09", length=24)
    public String getDist9() {
        return dist9;
    }

    @Id
    @Column(name="S_I_ID", nullable=false, insertable=false, updatable=false)
    public int getItemId() {
        return itemId;
    }

    @Column(name="S_ORDER_CNT")
    public int getOrderCount() {
        return orderCount;
    }

    @Column(name="S_QUANTITY")
    public int getQuantity() {
        return quantity;
    }

    @Column(name="S_REMOTE_CNT")
    public int getRemoteCount() {
        return remoteCount;
    }

    @Version
    @Column(name="S_VERSION")
    public int getVersion() {
        return version;
    }

    @Id
    @Column(name="S_W_ID", nullable=false, insertable=false, updatable=false)
    public int getWarehouseId() {
        return warehouseId;
    }

    @Column(name="S_YTD", precision=8, scale=2)
    public BigDecimal getYtd() {
        return ytd;
    }

    @ManyToOne
    @JoinColumn(name="S_I_ID", referencedColumnName="I_ID")
    public Item getItem() {
        return item;
    }

    @ManyToOne
    @JoinColumn(name="S_W_ID", referencedColumnName="W_ID")
    public Warehouse getWarehouse() {
        return warehouse;
    }

    public void setItem(Item item) {
        this.item = item;
    }

    public void setWarehouse(Warehouse warehouse) {
        this.warehouse = warehouse;
    }

    public void setData(String data) {
        this.data = data;
    }

    public void setDist1(String dist1) {
        this.dist1 = dist1;
    }

    public void setDist10(String dist10) {
        this.dist10 = dist10;
    }

    public void setDist2(String dist2) {
        this.dist2 = dist2;
    }

    public void setDist3(String dist3) {
        this.dist3 = dist3;
    }

    public void setDist4(String dist4) {
        this.dist4 = dist4;
    }

    public void setDist5(String dist5) {
        this.dist5 = dist5;
    }

    public void setDist6(String dist6) {
        this.dist6 = dist6;
    }

    public void setDist7(String dist7) {
        this.dist7 = dist7;
    }

    public void setDist8(String dist8) {
        this.dist8 = dist8;
    }

    public void setDist9(String dist9) {
        this.dist9 = dist9;
    }

    public void setItemId(int itemId) {
        this.itemId = itemId;
    }

    public void setOrderCount(int orderCount) {
        this.orderCount = orderCount;
    }

    public void setQuantity(int quantity) {
        this.quantity = quantity;
    }

    public void setRemoteCount(int remoteCount) {
        this.remoteCount = remoteCount;
    }

    public void setVersion(int version) {
        this.version = version;
    }

    public void setWarehouseId(int warehouseId) {
        this.warehouseId = warehouseId;
    }

    public void setYtd(BigDecimal ytd) {
        this.ytd = ytd;
    }

    public static class StockPK {
        int itemId;

        int warehouseId;

        public int getItemId() {
            return itemId;
        }

        public int getWarehouseId() {
            return warehouseId;
        }

        public void setItemId(int id) {
            this.itemId = id;
        }

        public void setWarehouseId(int warehouseId) {
            this.warehouseId = warehouseId;
        }

        @Override
        public boolean equals(Object arg0) {
            if (arg0 == this) {
                return true;
            } else if (arg0 instanceof StockPK) {
                StockPK other = (StockPK) arg0;
                return itemId == other.itemId
                        && warehouseId == other.warehouseId;
            }
            return false;
        }

        @Override
        public int hashCode() {
            return itemId ^ warehouseId;
        }
    }
}