Subversion Repositories SmartDukaan

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

import com.fasterxml.jackson.annotation.JsonIgnore;

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"),

        @NamedQuery(name = "InventoryItem.selectActivatedStockAmount",

                query = "select coalesce(sum(tl.sellingPrice), 0) from InventoryItem ii" +

                        " join Item i on i.id = ii.itemId" +

                        " join TagListing tl on tl.itemId = i.id" +

                        " join ActivatedImei ai on ai.serialNumber = ii.serialNumber" +

                        " where ii.goodQuantity = 1 and ai.activationTimestamp is not null" +

                        " and i.brand != 'Live Demo' and ii.fofoId = :fofoId"),

        @NamedQuery(name = "InventoryItem.selectActivatedStockAmountByFofoIds",

                query = "select ii.fofoId, coalesce(sum(tl.sellingPrice), 0) from InventoryItem ii" +

                        " join Item i on i.id = ii.itemId" +

                        " join TagListing tl on tl.itemId = i.id" +

                        " join ActivatedImei ai on ai.serialNumber = ii.serialNumber" +

                        " where ii.goodQuantity = 1 and ai.activationTimestamp is not null" +

                        " and i.brand != 'Live Demo' and ii.fofoId in :fofoIds group by ii.fofoId"),

        @NamedQuery(name = "InventoryItem.selectPurchaseSummary",

                query = "select new com.spice.profitmandi.dao.model.ItemPurchaseSummaryModel(" +

                        "ii.id, o.billingTimestamp,o.invoiceNumber, cast(li.unitPrice as float), li.item)" +

                        "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.lineItemId=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();

    @JsonIgnore

    @OneToOne(fetch = FetchType.LAZY)

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

    private Item item;

    @JsonIgnore

    @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 == null ? serialNumber : serialNumber.toLowerCase();

    }

    public void setSerialNumber(String serialNumber) {

        this.serialNumber = serialNumber == null ? 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();

    }

}