Subversion Repositories SmartDukaan

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

import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;

import javax.persistence.Column;
import javax.persistence.Convert;
import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
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.OneToOne;
import javax.persistence.Table;
import javax.persistence.Transient;

import org.hibernate.annotations.UpdateTimestamp;

import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
import com.spice.profitmandi.dao.entity.catalog.Item;
import com.spice.profitmandi.dao.enumuration.fofo.ScanType;

@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") })
@Entity
@Table(name = "fofo.inventory_item", schema = "fofo")
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 = "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;

        
        @OneToOne(fetch = FetchType.EAGER)
        @JoinColumn(name = "serial_number", insertable = false, updatable = false, referencedColumnName = "serial_number")
        private ActivatedImei activatedImei;


        public void setUnitPrice(float unitPrice) {
                this.unitPrice = unitPrice;
        }

        @Transient
        private String itemDescription;

        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;
        }

        public void setSerialNumber(String serialNumber) {
                this.serialNumber = serialNumber;
        }

        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 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;
        }

        @Override
        public int hashCode() {
                final int prime = 31;
                int result = 1;
                result = prime * result + ((activatedImei == null) ? 0 : activatedImei.hashCode());
                result = prime * result + badQuantity;
                result = prime * result + (buyBack ? 1231 : 1237);
                result = prime * result + Float.floatToIntBits(cgstRate);
                result = prime * result + ((createTimestamp == null) ? 0 : createTimestamp.hashCode());
                result = prime * result + fofoId;
                result = prime * result + goodQuantity;
                result = prime * result + ((hsnCode == null) ? 0 : hsnCode.hashCode());
                result = prime * result + id;
                result = prime * result + Float.floatToIntBits(igstRate);
                result = prime * result + initialQuantity;
                result = prime * result + ((item == null) ? 0 : item.hashCode());
                result = prime * result + ((itemDescription == null) ? 0 : itemDescription.hashCode());
                result = prime * result + itemId;
                result = prime * result + ((lastScanType == null) ? 0 : lastScanType.hashCode());
                result = prime * result + Float.floatToIntBits(priceDropAmount);
                result = prime * result + ((purchase == null) ? 0 : purchase.hashCode());
                result = prime * result + purchaseId;
                result = prime * result + ((serialNumber == null) ? 0 : serialNumber.hashCode());
                result = prime * result + Float.floatToIntBits(sgstRate);
                result = prime * result + Float.floatToIntBits(unitPrice);
                result = prime * result + ((updateTimestamp == null) ? 0 : updateTimestamp.hashCode());
                return result;
        }

        @Override
        public boolean equals(Object obj) {
                if (this == obj)
                        return true;
                if (obj == null)
                        return false;
                if (getClass() != obj.getClass())
                        return false;
                InventoryItem other = (InventoryItem) obj;
                if (activatedImei == null) {
                        if (other.activatedImei != null)
                                return false;
                } else if (!activatedImei.equals(other.activatedImei))
                        return false;
                if (badQuantity != other.badQuantity)
                        return false;
                if (buyBack != other.buyBack)
                        return false;
                if (Float.floatToIntBits(cgstRate) != Float.floatToIntBits(other.cgstRate))
                        return false;
                if (createTimestamp == null) {
                        if (other.createTimestamp != null)
                                return false;
                } else if (!createTimestamp.equals(other.createTimestamp))
                        return false;
                if (fofoId != other.fofoId)
                        return false;
                if (goodQuantity != other.goodQuantity)
                        return false;
                if (hsnCode == null) {
                        if (other.hsnCode != null)
                                return false;
                } else if (!hsnCode.equals(other.hsnCode))
                        return false;
                if (id != other.id)
                        return false;
                if (Float.floatToIntBits(igstRate) != Float.floatToIntBits(other.igstRate))
                        return false;
                if (initialQuantity != other.initialQuantity)
                        return false;
                if (item == null) {
                        if (other.item != null)
                                return false;
                } else if (!item.equals(other.item))
                        return false;
                if (itemDescription == null) {
                        if (other.itemDescription != null)
                                return false;
                } else if (!itemDescription.equals(other.itemDescription))
                        return false;
                if (itemId != other.itemId)
                        return false;
                if (lastScanType != other.lastScanType)
                        return false;
                if (Float.floatToIntBits(priceDropAmount) != Float.floatToIntBits(other.priceDropAmount))
                        return false;
                if (purchase == null) {
                        if (other.purchase != null)
                                return false;
                } else if (!purchase.equals(other.purchase))
                        return false;
                if (purchaseId != other.purchaseId)
                        return false;
                if (serialNumber == null) {
                        if (other.serialNumber != null)
                                return false;
                } else if (!serialNumber.equals(other.serialNumber))
                        return false;
                if (Float.floatToIntBits(sgstRate) != Float.floatToIntBits(other.sgstRate))
                        return false;
                if (Float.floatToIntBits(unitPrice) != Float.floatToIntBits(other.unitPrice))
                        return false;
                if (updateTimestamp == null) {
                        if (other.updateTimestamp != null)
                                return false;
                } else if (!updateTimestamp.equals(other.updateTimestamp))
                        return false;
                return true;
        }

        @Override
        public String toString() {
                return "InventoryItem [id=" + id + ", itemId=" + itemId + ", fofoId=" + fofoId + ", serialNumber="
                                + serialNumber + ", initialQuantity=" + initialQuantity + ", goodQuantity=" + goodQuantity
                                + ", badQuantity=" + badQuantity + ", 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 + ", activatedImei=" + activatedImei + ", itemDescription="
                                + itemDescription + "]";
        }

        @Override
        public int compareTo(Object o) {
                return o.hashCode() - this.hashCode();
        }

}