Subversion Repositories SmartDukaan

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

import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;

import com.spice.profitmandi.dao.entity.catalog.Item;

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

import org.hibernate.annotations.UpdateTimestamp;

import javax.persistence.*;

import java.time.LocalDateTime;

import java.time.format.DateTimeFormatter;

import java.util.Objects;

@NamedQueries({

		@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.purchaseId = :purchaseId group by ii.itemId"),

		//For Serialized models

		@NamedQuery(name = "InventoryItem.selectAllLineItemIdsByInventoryIds", query = "select new com.spice.profitmandi.dao.model.InventoryItemSaleModel(ii.id, lii.id)   from InventoryItem ii" +

				" join Purchase p on p.id = ii.purchaseId join Order o on o.invoiceNumber = p.purchaseReference" +

				" join LineItem li on li.orderId = o.id join LineItemImei lii on (lii.id=li.id and lii.serialNumber=ii.serialNumber)" +

				"where ii.id in :inventoryItemIds")

})

@Entity

@Table(name = "fofo.inventory_item")

public class InventoryItem implements Comparable {

	public InventoryItem(String serialNumber) {

		this.serialNumber = serialNumber;

	}

	public 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", length = 100)

	private String serialNumber;

	@Column(name = "initial_quantity")

	private int initialQuantity;

	@Column(name = "good_quantity")

	private int goodQuantity;

	@Column(name = "bad_quantity")

	private int badQuantity;

	@Column(name = "activation_timestamp")

	private LocalDateTime activationTimestamp;

	@Column(name = "last_scan_type")

	@Enumerated(EnumType.STRING)

	private ScanType lastScanType;

	@Column(name = "purchase_id")

	private int purchaseId;

	@Column(name = "unit_price")

	private float unitPrice;

	@Column(name = "price_drop_amount")

	private float priceDropAmount;

	@Column(name = "buy_back", columnDefinition = "tinyint(1) default 1")

	private boolean buyBack;

	@Column(name = "igst_rate")

	private float igstRate;

	@Column(name = "cgst_rate")

	private float cgstRate;

	@Column(name = "sgst_rate")

	private float sgstRate;

	@Column(name = "hsn_code")

	private String hsnCode;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "create_timestamp")

	private LocalDateTime createTimestamp = LocalDateTime.now();

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "update_timestamp")

	@UpdateTimestamp

	private LocalDateTime updateTimestamp = LocalDateTime.now();

	@OneToOne(fetch = FetchType.LAZY)

	@JoinColumn(name = "item_id", insertable = false, updatable = false, nullable = false, referencedColumnName = "id")

	private Item item;

	@OneToOne(fetch = FetchType.LAZY)

	@JoinColumn(name = "purchase_id", insertable = false, updatable = false, nullable = false, referencedColumnName = "id")

	private Purchase purchase;

	public void setUnitPrice(float unitPrice) {

		this.unitPrice = unitPrice;

	}

	@Transient

	private String itemDescription;

	@Transient

	private LocalDateTime activatedTimestamp;

	@Transient

	private boolean priceDropValidated = true;

	@Transient

	private String pdValidationFailedReason = null;

	@Override

	public boolean equals(Object o) {

		if (this == o) return true;

		if (o == null || getClass() != o.getClass()) return false;

		InventoryItem that = (InventoryItem) o;

		return id == that.id && itemId == that.itemId && fofoId == that.fofoId && initialQuantity == that.initialQuantity && goodQuantity == that.goodQuantity && badQuantity == that.badQuantity && purchaseId == that.purchaseId && Float.compare(that.unitPrice, unitPrice) == 0 && Float.compare(that.priceDropAmount, priceDropAmount) == 0 && buyBack == that.buyBack && Float.compare(that.igstRate, igstRate) == 0 && Float.compare(that.cgstRate, cgstRate) == 0 && Float.compare(that.sgstRate, sgstRate) == 0 && priceDropValidated == that.priceDropValidated && pdValidationFailedReason == that.pdValidationFailedReason && Objects.equals(serialNumber, that.serialNumber) && Objects.equals(activationTimestamp, that.activationTimestamp) && lastScanType == that.lastScanType && Objects.equals(hsnCode, that.hsnCode) && Objects.equals(createTimestamp, that.createTimestamp) && Objects.equals(updateTimestamp, that.updateTimestamp) && Objects.equals(item, that.item) && Objects.equals(purchase, that.purchase) && Objects.equals(itemDescription, that.itemDescription) && Objects.equals(activatedTimestamp, that.activatedTimestamp);

	}

	@Override

	public int hashCode() {

		return Objects.hash(id, itemId, fofoId, serialNumber, initialQuantity, goodQuantity, badQuantity, activationTimestamp, lastScanType, purchaseId, unitPrice, priceDropAmount, buyBack, igstRate, cgstRate, sgstRate, hsnCode, createTimestamp, updateTimestamp, item, purchase, itemDescription, activatedTimestamp, priceDropValidated, pdValidationFailedReason);

	}

	public String getPdValidationFailedReason() {

		return pdValidationFailedReason;

	}

	public void setPdValidationFailedReason(String pdValidationFailedReason) {

		this.pdValidationFailedReason = pdValidationFailedReason;

	}

	@Override

	public String toString() {

		return "InventoryItem{" +

				"id=" + id +

				", itemId=" + itemId +

				", fofoId=" + fofoId +

				", serialNumber='" + serialNumber + '\'' +

				", initialQuantity=" + initialQuantity +

				", goodQuantity=" + goodQuantity +

				", badQuantity=" + badQuantity +

				", activationTimestamp=" + activationTimestamp +

				", lastScanType=" + lastScanType +

				", purchaseId=" + purchaseId +

				", unitPrice=" + unitPrice +

				", priceDropAmount=" + priceDropAmount +

				", buyBack=" + buyBack +

				", igstRate=" + igstRate +

				", cgstRate=" + cgstRate +

				", sgstRate=" + sgstRate +

				", hsnCode='" + hsnCode + '\'' +

				", createTimestamp=" + createTimestamp +

				", updateTimestamp=" + updateTimestamp +

				", item=" + item +

				", purchase=" + purchase +

				", itemDescription='" + itemDescription + '\'' +

				", activatedTimestamp=" + activatedTimestamp +

				", priceDropValidated=" + priceDropValidated +

				", pdValidationFailedReason='" + pdValidationFailedReason + '\'' +

				'}';

	}

	public LocalDateTime getActivatedTimestamp() {

		return activatedTimestamp;

	}

	public void setActivatedTimestamp(LocalDateTime activatedTimestamp) {

		this.activatedTimestamp = activatedTimestamp;

	}

	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 void setFofoId(int fofoId) {

		this.fofoId = fofoId;

	}

	public int getFofoId() {

		return fofoId;

	}

	public String getSerialNumber() {

		return serialNumber.toLowerCase();

	}

	public void setSerialNumber(String serialNumber) {

		this.serialNumber = serialNumber.toLowerCase();

	}

	public int getInitialQuantity() {

		return initialQuantity;

	}

	public float getUnitPrice() {

		return unitPrice;

	}

	public void setUnitPrice(Float unitPrice) {

		this.unitPrice = unitPrice;

	}

	public void setInitialQuantity(int initialQuantity) {

		this.initialQuantity = initialQuantity;

	}

	public float getNetPrice() {

		return unitPrice - priceDropAmount;

	}

	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 int getPurchaseId() {

		return purchaseId;

	}

	public void setPurchaseId(int purchaseId) {

		this.purchaseId = purchaseId;

	}

	public float getPriceDropAmount() {

		return priceDropAmount;

	}

	public void setPriceDropAmount(float priceDropAmount) {

		this.priceDropAmount = priceDropAmount;

	}

	public float getIgstRate() {

		return igstRate;

	}

	public void setIgstRate(float igstRate) {

		this.igstRate = igstRate;

	}

	public float getCgstRate() {

		return cgstRate;

	}

	public void setCgstRate(float cgstRate) {

		this.cgstRate = cgstRate;

	}

	public float getSgstRate() {

		return sgstRate;

	}

	public void setSgstRate(float sgstRate) {

		this.sgstRate = sgstRate;

	}

	public String getHsnCode() {

		return hsnCode;

	}

	public void setHsnCode(String hsnCode) {

		this.hsnCode = hsnCode;

	}

	public LocalDateTime getCreateTimestamp() {

		return createTimestamp;

	}

	public void setCreateTimestamp(LocalDateTime createTimestamp) {

		this.createTimestamp = createTimestamp;

	}

	public LocalDateTime getUpdateTimestamp() {

		return updateTimestamp;

	}

	public void setUpdateTimestamp(LocalDateTime updateTimestamp) {

		this.updateTimestamp = updateTimestamp;

	}

	public Item getItem() {

		return item;

	}

	public void setItem(Item item) {

		this.item = item;

	}

	public boolean isBuyBack() {

		return buyBack;

	}

	public void setBuyBack(boolean buyBack) {

		this.buyBack = buyBack;

	}

	public Purchase getPurchase() {

		return purchase;

	}

	public double getMarginPercentage(double amount) {

		return amount / this.getNetPrice() * (100 + this.getCgstRate() + this.getIgstRate() + this.getSgstRate());

	}

	public void setPurchase(Purchase purchase) {

		this.purchase = purchase;

	}

	public String getFormattedCreateTimestamp() {

		if (createTimestamp == null) {

			return null;

		}

		DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-yyyy HH:mm");

		return createTimestamp.format(formatter);

	}

	public String getItemDescription() {

		return itemDescription;

	}

	public void setItemDescription(String itemDescription) {

		this.itemDescription = itemDescription;

	}

	public LocalDateTime getActivationTimestamp() {

		return activationTimestamp;

	}

	public void setActivationTimestamp(LocalDateTime activationTimestamp) {

		this.activationTimestamp = activationTimestamp;

	}

	public boolean isPriceDropValidated() {

		return priceDropValidated;

	}

	public void setPriceDropValidated(boolean priceDropValidated) {

		this.priceDropValidated = priceDropValidated;

	}

	@Override

	public int compareTo(Object o) {

		return o.hashCode() - this.hashCode();

	}

}