Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity.fofo;

import java.io.Serializable;
import java.util.Set;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import javax.persistence.UniqueConstraint;

@Entity
@Table(name="fofo.fofo_line_item", schema = "fofo", uniqueConstraints = {@UniqueConstraint(columnNames = {"order_id","item_id"})})
@NamedQueries({
        @NamedQuery(name = "FofoLineItem.selectById", query = "select fli from FofoLineItem fli where fli.id = :id"),
        @NamedQuery(name="FofoLineItem.selectByOrderId",query="select fli from FofoLineItem fli where fli.orderId = :orderId")
})
public class FofoLineItem implements Serializable{

        private static final long serialVersionUID = 1L;

        @Id
        @Column(name = "id")
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private int id;
        
        @Column(name = "order_id")
        private int orderId;
        
        @Column(name = "item_id")
        private int itemId;
        
        @Column(name = "quantity")
        private int quantity;
        
        @Column(name = "selling_price")
        private float sellingPrice;
        
        @Column(name = "cost")
        private float cost;
        
        @Column(name = "tax_rate")
        private float taxRate;
        
        @Column(name = "tax")
        private float tax;
        
        @Column(name = "dp")
        private float dp;
        
        @Column(name = "brand")
        private String brand;
        
        @Column(name = "model_name")
        private String modelName;
        
        @Column(name = "model_number")
        private String modelNumber;
        
        @Column(name = "color")
        private String color;
        
        @OneToMany(cascade=CascadeType.ALL,fetch=FetchType.LAZY)
        @JoinColumn(name="fofo_line_item_id",insertable=false,updatable=false,nullable=false)
        private Set<FofoLineItemSerialNumber> fofoLineItemSerialNumbers;
        
        public int getId() {
                return id;
        }
        public void setId(int id) {
                this.id = id;
        }
        public int getOrderId() {
                return orderId;
        }
        public void setOrderId(int orderId) {
                this.orderId = orderId;
        }
        public int getItemId() {
                return itemId;
        }
        public void setItemId(int itemId) {
                this.itemId = itemId;
        }
        public int getQuantity() {
                return quantity;
        }
        public void setQuantity(int quantity) {
                this.quantity = quantity;
        }
        public float getSellingPrice() {
                return sellingPrice;
        }
        public void setSellingPrice(float sellingPrice) {
                this.sellingPrice = sellingPrice;
        }
        
        public float getCost() {
                return cost;
        }
        public void setCost(float cost) {
                this.cost = cost;
        }
        
        public float getTax() {
                return tax;
        }
        public void setTax(float tax) {
                this.tax = tax;
        }
        public float getTaxRate() {
                return taxRate;
        }
        public void setTaxRate(float taxRate) {
                this.taxRate = taxRate;
        }
        public float getDp() {
                return dp;
        }
        public void setDp(float dp) {
                this.dp = dp;
        }
        public String getBrand() {
                return brand;
        }
        public void setBrand(String brand) {
                this.brand = brand;
        }
        public String getModelName() {
                return modelName;
        }
        public void setModelName(String modelName) {
                this.modelName = modelName;
        }
        public String getModelNumber() {
                return modelNumber;
        }
        public void setModelNumber(String modelNumber) {
                this.modelNumber = modelNumber;
        }
        public String getColor() {
                return color;
        }
        public void setColor(String color) {
                this.color = color;
        }
        
        public Set<FofoLineItemSerialNumber> getFofoLineItemSerialNumbers() {
                return fofoLineItemSerialNumbers;
        }
        public void setFofoLineItemSerialNumbers(Set<FofoLineItemSerialNumber> fofoLineItemSerialNumbers) {
                this.fofoLineItemSerialNumbers = fofoLineItemSerialNumbers;
        }
        @Override
        public String toString() {
                return "FofoLineItem [id=" + id + ", orderId=" + orderId + ", itemId=" + itemId + ", quantity=" + quantity
                                + ", sellingPrice=" + sellingPrice + ", tax=" + tax + ", dp=" + dp + ", brand=" + brand + ", modelName="
                                + modelName + ", modelNumber=" + modelNumber + ", color=" + color + "]";
        }
        
        
}