Subversion Repositories SmartDukaan

import java.util.ArrayList;

import java.time.LocalDateTime;

				+ " where cis.fofoId = :fofoId and cis.availability > 0 and REPLACE(CONCAT(i.brand,' ', ifnull(i.modelName, ' '), ' ', ifnull(i.modelNumber, ' ')), '  ', ' ')  like CONCAT('%',:query,'%')"),

@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,'%')"),

				+ " where tl.mop between :startPrice and :endPrice and  i.categoryId=10006 group by i.catalogItemId"),

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

				+ "  i from Item i join TagListing tl on tl.itemId = i.id where i.brand in :brands and i.categoryId = :categoryId") })

        @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")})

@Table(name = "catalog.item", schema = "catalog")

@Table(name = "catalog.item")

	public static final List<String> SMART_PG = Arrays.asList("85171300", "85171290");

    public static final List<String> SMART_PG = Arrays.asList("85171300", "85171290");

	private static final long serialVersionUID = 1L;

    private static final long serialVersionUID = 1L;

	public Item() {

    public Item() {

	}

    }

	@Id

    @Id

	@Column(name = "id", columnDefinition = "int(11)")

    @Column(name = "id", columnDefinition = "int(11)")

	@GeneratedValue(strategy = GenerationType.IDENTITY)

    @GeneratedValue(strategy = GenerationType.IDENTITY)

	private int id;

    private int id;

	@Column(name = "brand", length = 100)

    @Column(name = "brand", length = 100)

	private String brand;

    private String brand;

	@Column(name = "status")

    @Column(name = "status")

	@Enumerated(EnumType.ORDINAL)

    @Enumerated(EnumType.ORDINAL)

	private status status;

    private status status;

	@Column(name = "product_group", length = 100)

    @Column(name = "product_group", length = 100)

	private String productGroup;

    private String productGroup;

	@Column(name = "model_name", length = 100)

    @Column(name = "model_name", length = 100)

	private String modelName;

    private String modelName;

	@Column(name = "model_number", length = 100)

    @Column(name = "model_number", length = 100)

	private String modelNumber;

    private String modelNumber;

	@Column(name = "color", length = 20)

    @Column(name = "color", length = 20)

	private String color;

    private String color;

	@Column(name = "catalog_item_id")

    @Column(name = "catalog_item_id")

	private int catalogItemId;

    private int catalogItemId;

	@Column(name = "weight")

    @Column(name = "weight")

	private Double weight;

    private Double weight;

	@Column(name = "category")

    @Column(name = "category")

	private int categoryId;

    private int categoryId;

	public int getCategoryId() {

    @Column(name = "startDate")

		return categoryId;

    private LocalDateTime startDate;

	}

    public int getCategoryId() {

	public void setCategoryId(int categoryId) {

        return categoryId;

		this.categoryId = categoryId;

    }

	}

    public void setCategoryId(int categoryId) {

	@Enumerated(EnumType.STRING)

        this.categoryId = categoryId;

	@Column(name = "type")

    }

	private ItemType type;

    @Enumerated(EnumType.STRING)

	@Column(name = "hsnCode")

    @Column(name = "type")

	private String hsnCode;

    private ItemType type;

	@Column(name = "sellingPrice")

    @Column(name = "hsnCode")

	private Float sellingPrice;

    private String hsnCode;

	@Column

    @Column(name = "sellingPrice")

	private Float mrp;

    private Float sellingPrice;

	public String getProductGroup() {

    public String getProductGroup() {

		return productGroup;

        return productGroup;

	}

    }

	public void setProductGroup(String productGroup) {

    public void setProductGroup(String productGroup) {

		this.productGroup = productGroup;

        this.productGroup = productGroup;

	}

    }

	public int getId() {

    public int getId() {

		return id;

        return id;

	}

    }

	public void setId(int id) {

    @Column

		this.id = id;

    private Float mrp;

	}

    public void setId(int id) {

	public String getBrand() {

        this.id = id;

		return brand;

    }

	}

    public String getBrand() {

	public void setBrand(String brand) {

        return brand;

		this.brand = brand;

    }

	}

    public void setBrand(String brand) {

	public String getModelName() {

        this.brand = brand;

		return modelName;

    }

	}

    public String getModelName() {

	public void setModelName(String modelName) {

        return modelName;

		this.modelName = modelName;

    }

	}

    public void setModelName(String modelName) {

	public String getModelNumber() {

        this.modelName = modelName;

		return modelNumber;

    }

	}

    public String getModelNumber() {

	public void setModelNumber(String modelNumber) {

        return modelNumber;

		this.modelNumber = modelNumber;

    }

	}

    public void setModelNumber(String modelNumber) {

	public String getColor() {

        this.modelNumber = modelNumber;

		if (color != null && (color.startsWith("f_") || color.startsWith("F_"))) {

    }

			return color.substring(2);

		}

    public String getColor() {

		return color;

        if (color != null && (color.startsWith("f_") || color.startsWith("F_"))) {

	}

            return color.substring(2);

        }

	public String getColorNatural() {

        return color;

		return this.color;

    }

	}

    public String getColorNatural() {

	public void setColor(String color) {

        return this.color;

		this.color = color;

    }

	}

    public void setColor(String color) {

	public ItemType getType() {

        this.color = color;

		return type;

    }

	}

    public ItemType getType() {

	public void setType(ItemType type) {

        return type;

		this.type = type;

    }

	}

    public void setType(ItemType type) {

	public String getHsnCode() {

        this.type = type;

		return hsnCode;

    }

	}

    public String getHsnCode() {

	public void setHsnCode(String hsnCode) {

        return hsnCode;

		this.hsnCode = hsnCode;

    }

	}

    public void setHsnCode(String hsnCode) {

	public int getCatalogItemId() {

        this.hsnCode = hsnCode;

		return catalogItemId;

    }

	}

    public int getCatalogItemId() {

	public Double getWeight() {

        return catalogItemId;

		return weight;

    }

	}

    public Double getWeight() {

	public void setWeight(Double weight) {

        return weight;

		this.weight = weight;

    }

	}

    public void setWeight(Double weight) {

	public void setCatalogItemId(int catalogItemId) {

        this.weight = weight;

		this.catalogItemId = catalogItemId;

    }

	}

    public void setCatalogItemId(int catalogItemId) {

	public Float getSellingPrice() {

        this.catalogItemId = catalogItemId;

		return sellingPrice;

    }

	}

    public Float getSellingPrice() {

	public void setSellingPrice(Float sellingPrice) {

        return sellingPrice;

		this.sellingPrice = sellingPrice;

    }

	}

    public void setSellingPrice(Float sellingPrice) {

	public String getItemDescription() {

        this.sellingPrice = sellingPrice;

		StringBuilder itemString = new StringBuilder();

    }

		if (this.getBrand() != null && !this.getBrand().isEmpty()) {

			itemString.append(this.getBrand().trim());

		}

    public LocalDateTime getStartDate() {

		itemString.append(" ");

        return startDate;

		if (this.getModelName() != null && !this.getModelName().isEmpty()) {

    }

			itemString.append(this.getModelName().trim());

		}

    public void setStartDate(LocalDateTime startDate) {

		if (this.getModelNumber() != null && !this.getModelNumber().isEmpty()) {

        this.startDate = startDate;

			itemString.append(" ");

    }

			itemString.append(this.getModelNumber().trim());

		}

    public String getItemDescription() {

		if (this.getColor() != null && !this.getColor().isEmpty() && !this.getColor().trim().equals("f_")) {

        StringBuilder itemString = new StringBuilder();

			itemString.append(" ");

        if (this.getBrand() != null && !this.getBrand().isEmpty()) {

			itemString.append(this.getColor().trim());

            itemString.append(this.getBrand().trim());

		}

        }

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

        itemString.append(" ");

	}

        if (this.getModelName() != null && !this.getModelName().isEmpty()) {

            itemString.append(this.getModelName().trim());

	public boolean isSmartPhone() {

        }

		return SMART_PG.contains(this.getHsnCode());

        if (this.getModelNumber() != null && !this.getModelNumber().isEmpty()) {

	}

            itemString.append(" ");

            itemString.append(this.getModelNumber().trim());

	public String getItemDescriptionNoColor() {

        }

		StringBuilder itemString = new StringBuilder();

        if (this.getColor() != null && !this.getColor().isEmpty() && !this.getColor().trim().equals("f_")) {

		if (this.getBrand() != null && !this.getBrand().isEmpty()) {

            itemString.append(" ");

			itemString.append(this.getBrand().trim());

            itemString.append(this.getColor().trim());

		}

        }

		itemString.append(" ");

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

		if (this.getModelName() != null && !this.getModelName().isEmpty()) {

    }

			itemString.append(this.getModelName().trim());

		}

    public boolean isSmartPhone() {

		if (this.getModelNumber() != null && !this.getModelNumber().isEmpty()) {

        return SMART_PG.contains(this.getHsnCode());

			itemString.append(" ");

    }

			itemString.append(this.getModelNumber().trim());

		}

    public String getItemDescriptionNoColor() {

        StringBuilder itemString = new StringBuilder();

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

        if (this.getBrand() != null && !this.getBrand().isEmpty()) {

	}

            itemString.append(this.getBrand().trim());

        }

	@Override

        itemString.append(" ");

	public int hashCode() {

        if (this.getModelName() != null && !this.getModelName().isEmpty()) {

		final int prime = 31;

            itemString.append(this.getModelName().trim());

		int result = 1;

        }

		result = prime * result + id;

        if (this.getModelNumber() != null && !this.getModelNumber().isEmpty()) {

		return result;

            itemString.append(" ");

	}

            itemString.append(this.getModelNumber().trim());

        }

	@Override

	public boolean equals(Object obj) {

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

		if (this == obj)

    }

			return true;

		if (obj == null)

    @Override

			return false;

    public int hashCode() {

		if (getClass() != obj.getClass())

        final int prime = 31;

			return false;

        int result = 1;

		Item other = (Item) obj;

        result = prime * result + ((brand == null) ? 0 : brand.hashCode());

		if (id != other.id)

        result = prime * result + catalogItemId;

			return false;

        result = prime * result + categoryId;

		return true;

        result = prime * result + ((color == null) ? 0 : color.hashCode());

	}

        result = prime * result + ((hsnCode == null) ? 0 : hsnCode.hashCode());

        result = prime * result + id;

	@Override

        result = prime * result + ((modelName == null) ? 0 : modelName.hashCode());

	public String toString() {

        result = prime * result + ((modelNumber == null) ? 0 : modelNumber.hashCode());

		return "Item [id=" + id + ", brand=" + brand + ", status=" + status + ", productGroup=" + productGroup

        result = prime * result + ((productGroup == null) ? 0 : productGroup.hashCode());

				+ ", modelName=" + modelName + ", modelNumber=" + modelNumber + ", color=" + color + ", catalogItemId="

        result = prime * result + ((sellingPrice == null) ? 0 : sellingPrice.hashCode());

				+ catalogItemId + ", weight=" + weight + ", categoryId=" + categoryId + ", type=" + type + ", hsnCode="

        result = prime * result + ((startDate == null) ? 0 : startDate.hashCode());

				+ hsnCode + ", sellingPrice=" + sellingPrice + "]";

        result = prime * result + ((status == null) ? 0 : status.hashCode());

	}

        result = prime * result + ((type == null) ? 0 : type.hashCode());

        result = prime * result + ((weight == null) ? 0 : weight.hashCode());

	public status getStatus() {

        return result;

		return status;

    }

	}

    @Override

	public void setStatus(status status) {

    public boolean equals(Object obj) {

		this.status = status;

        if (this == obj) return true;

	}

        if (obj == null) return false;

        if (getClass() != obj.getClass()) return false;

	public boolean isAnyColor() {

        Item other = (Item) obj;

		if(this.color != null) {

        if (brand == null) {

			String lowerCaseColor = this.color.toLowerCase();

            if (other.brand != null) return false;

			return lowerCaseColor.equals("any color") || lowerCaseColor.equals("f_any color") || lowerCaseColor.equals("any colour") || lowerCaseColor.equals("f_any colour");

        } else if (!brand.equals(other.brand)) return false;

		}

        if (catalogItemId != other.catalogItemId) return false;

		return false;

        if (categoryId != other.categoryId) return false;

	}

        if (color == null) {

            if (other.color != null) return false;

	public Float getMrp() {

        } else if (!color.equals(other.color)) return false;

		return mrp;

        if (hsnCode == null) {

	}

            if (other.hsnCode != null) return false;

        } else if (!hsnCode.equals(other.hsnCode)) return false;

	public void setMrp(Float mrp) {

        if (id != other.id) return false;

		this.mrp = mrp;

        if (modelName == null) {

	}

            if (other.modelName != null) return false;