Subversion Repositories SmartDukaan

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

import com.spice.profitmandi.common.enumuration.ItemType;
import in.shop2020.model.v1.catalog.status;

import javax.persistence.*;
import java.io.Serializable;

/**
 * This class basically contains item details
 *
 * @author ashikali
 */

@NamedQueries({
                @NamedQuery(name = "Item.selectItemByLikes", query = "select new com.spice.profitmandi.common.model.CustomItemModel("
                                + "     i.id, i.brand, i.modelName, i.modelNumber, i.color"
                                + "     ) from Item  i join CurrentInventorySnapshot cis on i.id = cis.itemId "
                                + " where cis.fofoId = :fofoId and cis.availability > 0 and REPLACE(CONCAT(i.brand,' ', ifnull(i.modelName, ' '), ' ', ifnull(i.modelNumber, ' ')), '  ', ' ')  like CONCAT('%',:query,'%')"),

                @NamedQuery(name = "Item.selectCatalogIdByMopRange", query = "select i.catalogItemId"
                                + " from Item i join TagListing tl on tl.itemId = i.id "
                                + " where tl.mop between :startPrice and :endPrice and  i.categoryId=10006 group by i.catalogItemId"),

                @NamedQuery(name = "Item.selectAllBrands", query = "select distinct"
                                + "  i.brand from Item i join TagListing tl on tl.itemId = i.id "
                                + " where i.categoryId=:categoryId"),
                @NamedQuery(name = "Item.selectAllCategories", query = "select distinct"
                                + "  i.categoryId from Item i join TagListing tl on tl.itemId = i.id "),
                @NamedQuery(name = "Item.selectAllModels", query = "select "
                                + "  i from Item i join TagListing tl on tl.itemId = i.id where i.brand in :brands and i.categoryId = :categoryId")
})
@Entity
@Table(name = "catalog.item", schema = "catalog")
public class Item implements Serializable {

        private static final long serialVersionUID = 1L;

        public Item() {
        }

        @Id
        @Column(name = "id", columnDefinition = "int(11)")
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private int id;

        @Column(name = "brand", length = 100)
        private String brand;

        @Column(name = "status")
        @Enumerated(EnumType.ORDINAL)
        private status status;

        @Column(name = "product_group", length = 100)
        private String productGroup;

        @Column(name = "model_name", length = 100)
        private String modelName;

        @Column(name = "model_number", length = 100)
        private String modelNumber;

        @Column(name = "color", length = 20)
        private String color;

        @Column(name = "catalog_item_id")
        private int catalogItemId;

        @Column(name = "weight")
        private Double weight;

        @Column(name = "category")
        private int categoryId;

        public int getCategoryId() {
                return categoryId;
        }

        public void setCategoryId(int categoryId) {
                this.categoryId = categoryId;
        }

        @Enumerated(EnumType.STRING)
        @Column(name = "type")
        private ItemType type;

        @Column(name = "hsnCode")
        private String hsnCode;

        @Column(name = "sellingPrice")
        private Float sellingPrice;

        public String getProductGroup() {
                return productGroup;
        }

        public void setProductGroup(String productGroup) {
                this.productGroup = productGroup;
        }

        public int getId() {
                return id;
        }

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

        public String getBrand() {
                return brand;
        }

        public void setBrand(String brand) {
                this.brand = brand;
        }

        public String getModelName() {
                return modelName;
        }

        public void setModelName(String modelName) {
                this.modelName = modelName;
        }

        public String getModelNumber() {
                return modelNumber;
        }

        public void setModelNumber(String modelNumber) {
                this.modelNumber = modelNumber;
        }

        public String getColor() {
                if (color != null && (color.startsWith("f_") || color.startsWith("F_"))) {
                        return color.substring(2);
                }
                return color;
        }

        public String getColorNatural() {
                return this.color;
        }

        public void setColor(String color) {
                this.color = color;
        }

        public ItemType getType() {
                return type;
        }

        public void setType(ItemType type) {
                this.type = type;
        }

        public String getHsnCode() {
                return hsnCode;
        }

        public void setHsnCode(String hsnCode) {
                this.hsnCode = hsnCode;
        }

        public int getCatalogItemId() {
                return catalogItemId;
        }

        public Double getWeight() {
                return weight;
        }

        public void setWeight(Double weight) {
                this.weight = weight;
        }

        public void setCatalogItemId(int catalogItemId) {
                this.catalogItemId = catalogItemId;
        }

        public Float getSellingPrice() {
                return sellingPrice;
        }

        public void setSellingPrice(Float sellingPrice) {
                this.sellingPrice = sellingPrice;
        }

        public String getItemDescription() {
                StringBuilder itemString = new StringBuilder();
                if (this.getBrand() != null && !this.getBrand().isEmpty()) {
                        itemString.append(this.getBrand().trim());
                }
                itemString.append(" ");
                if (this.getModelName() != null && !this.getModelName().isEmpty()) {
                        itemString.append(this.getModelName().trim());
                }
                if (this.getModelNumber() != null && !this.getModelNumber().isEmpty()) {
                        itemString.append(" ");
                        itemString.append(this.getModelNumber().trim());
                }
                if (this.getColor() != null && !this.getColor().isEmpty() && !this.getColor().trim().equals("f_")) {
                        itemString.append(" ");
                        itemString.append(this.getColor().trim());
                }
                return itemString.toString().replaceAll("\\s+", " ").trim();
        }

        public String getItemDescriptionNoColor() {
                StringBuilder itemString = new StringBuilder();
                if (this.getBrand() != null && !this.getBrand().isEmpty()) {
                        itemString.append(this.getBrand().trim());
                }
                itemString.append(" ");
                if (this.getModelName() != null && !this.getModelName().isEmpty()) {
                        itemString.append(this.getModelName().trim());
                }
                if (this.getModelNumber() != null && !this.getModelNumber().isEmpty()) {
                        itemString.append(" ");
                        itemString.append(this.getModelNumber().trim());
                }

                return itemString.toString().replaceAll("\\s+", " ").trim();
        }

        @Override
        public int hashCode() {
                final int prime = 31;
                int result = 1;
                result = prime * result + id;
                return result;
        }

        @Override
        public boolean equals(Object obj) {
                if (this == obj)
                        return true;
                if (obj == null)
                        return false;
                if (getClass() != obj.getClass())
                        return false;
                Item other = (Item) obj;
                if (id != other.id)
                        return false;
                return true;
        }

        @Override
        public String toString() {
                return "Item [id=" + id + ", brand=" + brand + ", status=" + status + ", productGroup=" + productGroup
                                + ", modelName=" + modelName + ", modelNumber=" + modelNumber + ", color=" + color + ", catalogItemId="
                                + catalogItemId + ", weight=" + weight + ", categoryId=" + categoryId + ", type=" + type + ", hsnCode="
                                + hsnCode + ", sellingPrice=" + sellingPrice + "]";
        }

        public status getStatus() {
                return status;
        }

        public void setStatus(status status) {
                this.status = status;
        }

}