Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity;

import java.time.LocalDateTime;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

import com.spice.profitmandi.dao.enumuration.ScanType;

@NamedQueries({
        @NamedQuery(name = "InventoryItem.selectCount", query = "select count(ii) from InventoryItem ii"), 
        @NamedQuery(name = "InventoryItem.selectByItemId", query = "select ii from InventoryItem ii where ii.itemId = :itemId"),
        @NamedQuery(name = "InventoryItem.selectByFofoId", query = "select ii from InventoryItem ii where ii.fofoId = :fofoId"),
        //@NamedQuery(name = "InventoryItem.selectBySerialNumber", query = "select ii from InventoryItem ii join Imei i on ii.imeiId = i.id where i.imei = :serialNumber"),
        //@NamedQuery(name = "InventoryItem.selectQuantitySum", query = "select sum(ii.initialQuantity) as inventoryQuantity from InventoryItem ii where ii.itemId = :itemId and ii.fofoId = :fofoId and ii.purchaseReference = :purchaseReference")
        
        @NamedQuery(
                name = "InventoryItem.selectScannedCount",
                query = "select ii.itemId, sum(ii.initialQuantity) from InventoryItem ii "
                                + "where ii.itemId in :itemIds and ii.fofoId = :fofoId and ii.purchaseReference = :purchaseReference group by ii.itemId")
})
@Entity
@Table(name="fofo.inventory_item", schema = "fofo")
public class InventoryItem {
        
        @Id
        @Column(name="id", unique=true, updatable=false)
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private int id;
        
        @Column(name = "item_id")
        private int itemId; 
        
        @Column(name = "fofo_id")
        private int fofoId; 
        
        @Column(name = "imei_id")
        private int imeiId; 
        
        @Column(name = "intial_quantity")
        private int initialQuantity;
        
        @Column(name = "good_quantity")
        private int goodQuantity; 
        
        @Column(name = "bad_quantity")
        private int badQuantity;
        
        @Column(name = "last_scan_type")
        @Enumerated(EnumType.STRING)
        private ScanType lastScanType;
        
        @Column(name = "purchase_reference")
        private String purchaseReference;
        
        @Column(name = "create_timestamp")
        private LocalDateTime createTimestamp;

        public int getId() {
                return id;
        }

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

        public int getItemId() {
                return itemId;
        }

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

        public int getFofoId() {
                return fofoId;
        }

        public void setFofoId(int fofoId) {
                this.fofoId = fofoId;
        }

        public int getImeiId() {
                return imeiId;
        }
        
        public void setImeiId(int imeiId) {
                this.imeiId = imeiId;
        }
        

        public int getInitialQuantity() {
                return initialQuantity;
        }

        public void setInitialQuantity(int initialQuantity) {
                this.initialQuantity = initialQuantity;
        }

        public int getGoodQuantity() {
                return goodQuantity;
        }

        public void setGoodQuantity(int goodQuantity) {
                this.goodQuantity = goodQuantity;
        }

        public int getBadQuantity() {
                return badQuantity;
        }

        public void setBadQuantity(int badQuantity) {
                this.badQuantity = badQuantity;
        }

        public ScanType getLastScanType() {
                return lastScanType;
        }

        public void setLastScanType(ScanType lastScanType) {
                this.lastScanType = lastScanType;
        }

        public String getPurchaseReference() {
                return purchaseReference;
        }
        public void setPurchaseReference(String purchaseReference) {
                this.purchaseReference = purchaseReference;
        }

        public LocalDateTime getCreateTimestamp() {
                return createTimestamp;
        }

        public void setCreateTimestamp(LocalDateTime createTimestamp) {
                this.createTimestamp = createTimestamp;
        }
        
        
        
}