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.findBySerialNumbers",

			query = "select it1 from InventoryItem it1 join"

					+ " (select it2.serialNumber, max(it2.created) as created from InventoryItem it2 where it2.serialNumber in (:serialNumbers) "

					+ " group by it2.serialNumber) b ON it1.serialNumber = b.serialNumber AND it1.created = b.created"),*/

	@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.selectByItemId", query = "select ii from InventoryItem ii where ii.fofoId = :fofoId"),

	@NamedQuery(name = "InventoryItem.selectByItemId", query = "select ii from InventoryItem ii where ii.serialNumber = :serialNumber")

})

@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 = "serial_number")

	private String serailNumber; 

	@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 String getSerailNumber() {

		return serailNumber;

	}

	public void setSerailNumber(String serailNumber) {

		this.serailNumber = serailNumber;

	}

	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;

	}

	@Override

	public String toString() {

		return "InventoryItem [id=" + id + ", itemId=" + itemId + ", fofoId=" + fofoId + ", serailNumber="

				+ serailNumber + ", initialQuantity=" + initialQuantity + ", goodQuantity=" + goodQuantity

				+ ", badQuantity=" + badQuantity + ", lastScanType=" + lastScanType + ", purchaseReference="

				+ purchaseReference + ", createTimestamp=" + createTimestamp + "]";

	}

}