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

import java.math.BigDecimal;
import java.sql.Timestamp;

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

@Entity
@Table(name="ORDER_LINE", schema="TPCC")
@IdClass(schema1.entity.tpcc.OrderLine.OrderLinePK.class)
public class OrderLine {

    int orderId;
    int districtId;
    int warehouseId;
    int orderLineNumber;
    int itemId;
    int supplyWarehouseId;
    Timestamp deliveryDateTime;
    int quantity;
    BigDecimal amount;
    String distInfo;
    
    Order order;
    Stock stock;
    
    @Column(name="OL_AMOUNT", precision=6, scale=2)
    public BigDecimal getAmount() {
        return amount;
    }
    @Column(name="OL_DELIVERY_D")
    public Timestamp getDeliveryDateTime() {
        return deliveryDateTime;
    }
    @Column(name="OL_DIST_INFO")
    public String getDistInfo() {
        return distInfo;
    }
    @Id
    @Column(name="OL_D_ID", nullable=false, insertable=false, updatable=false)
    public int getDistrictId() {
        return districtId;
    }
    @Column(name="OL_I_ID", nullable=false, insertable=false, updatable=false)
    public int getItemId() {
        return itemId;
    }
    @ManyToOne
    @JoinColumns({
        @JoinColumn(name="OL_W_ID", referencedColumnName="O_W_ID"),
        @JoinColumn(name="OL_D_ID", referencedColumnName="O_D_ID"),
        @JoinColumn(name="OL_O_ID", referencedColumnName="O_ID")
    })
    public Order getOrder() {
        return order;
    }
    @Id
    @Column(name="OL_O_ID", nullable=false, insertable=false, updatable=false)
    public int getOrderId() {
        return orderId;
    }
    @Id
    @Column(name="OL_NUMBER", nullable=false)
    public int getOrderLineNumber() {
        return orderLineNumber;
    }
    @Column(name="OL_QUANTITY")
    public int getQuantity() {
        return quantity;
    }
    @ManyToOne
    @JoinColumns({
        @JoinColumn(name="OL_SUPPLY_W_ID", referencedColumnName="S_W_ID"),
        @JoinColumn(name="OL_I_ID", referencedColumnName="S_I_ID")
    })
    public Stock getStock() {
        return stock;
    }
    @Column(name="OL_SUPPLY_W_ID", nullable=false, insertable=false, updatable=false)
    public int getSupplyWarehouseId() {
        return supplyWarehouseId;
    }
    @Id
    @Column(name="OL_W_ID", nullable=false, insertable=false, updatable=false)
    public int getWarehouseId() {
        return warehouseId;
    }
    
    public void setAmount(BigDecimal amount) {
        this.amount = amount;
    }
    public void setDeliveryDateTime(Timestamp deliveryDateTime) {
        this.deliveryDateTime = deliveryDateTime;
    }
    public void setDistInfo(String distInfo) {
        this.distInfo = distInfo;
    }
    public void setDistrictId(int districtId) {
        this.districtId = districtId;
    }
    public void setItemId(int itemId) {
        this.itemId = itemId;
    }
    public void setOrder(Order order) {
        this.order = order;
    }
    public void setOrderId(int orderId) {
        this.orderId = orderId;
    }
    public void setOrderLineNumber(int orderLineNumber) {
        this.orderLineNumber = orderLineNumber;
    }
    public void setQuantity(int quantity) {
        this.quantity = quantity;
    }
    public void setStock(Stock stock) {
        this.stock = stock;
    }
    public void setSupplyWarehouseId(int supplyWarehouseId) {
        this.supplyWarehouseId = supplyWarehouseId;
    }
    public void setWarehouseId(int warehouseId) {
        this.warehouseId = warehouseId;
    }
    
    public static class OrderLinePK {
        int warehouseId;
        int districtId;
        int orderId;
        int orderLineNumber;
        public int getDistrictId() {
            return districtId;
        }
        public int getOrderId() {
            return orderId;
        }
        public int getOrderLineNumber() {
            return orderLineNumber;
        }
        public int getWarehouseId() {
            return warehouseId;
        }
        public void setDistrictId(int districtId) {
            this.districtId = districtId;
        }
        public void setOrderId(int orderId) {
            this.orderId = orderId;
        }
        public void setOrderLineNumber(int orderLineNumber) {
            this.orderLineNumber = orderLineNumber;
        }
        public void setWarehouseId(int warehouseId) {
            this.warehouseId = warehouseId;
        }
        
    }
    
}