Subversion Repositories SmartDukaan

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

import java.io.Serializable;

import java.time.LocalDate;

import java.time.LocalDateTime;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.EnumType;

import javax.persistence.Enumerated;

import javax.persistence.Id;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.Table;

import javax.persistence.Transient;

import com.spice.profitmandi.common.enumuration.CounterSize;

import com.spice.profitmandi.common.enumuration.FofoType;

import com.spice.profitmandi.dao.entity.user.Address;

/**

 * This class basically contains store code details

 * 

 * @author ashikali

 *

 */

@Entity

@Table(name = "fofo.fofo_store", schema = "fofo")

@NamedQueries({

		@NamedQuery(name="FofoStore.selectAllDtrUserIds", query = "select ua.userId from FofoStore fs join UserAccount ua on fs.id=ua.accountKey " +

				"where ua='saholic' and fs.internal=false and fs.active=true"),

		@NamedQuery(name = "FofoStore.selectGroupByBrandWarehousePartnerSale", query = "select new com.spice.profitmandi.dao.model.BrandWisePartnerSaleModel(foi.brand, "

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :lms then CAST(foi.quantity*foi.mop  AS integer ) else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :lms then foi.quantity  else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd  then CAST(foi.quantity*foi.mop  AS integer ) else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd  then foi.quantity else 0 end), "

				+ "sum(case when foi.createTimestamp between  :lmtdStartDate and :lmtdEndDate  then CAST(foi.quantity*foi.mop  AS int) else 0 end), "

				+ "sum(case when foi.createTimestamp between  :lmtdStartDate and :lmtdEndDate then foi.quantity else 0 end))"

				+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id  join Item i on i.id = foi.itemId  where fo.cancelledTimestamp is null and fs.active = true "

				+ "and foi.createTimestamp >= :lmtdStartDate and i.categoryId = :categoryId and fs.id in :fofoId"

				+ " group by foi.brand"),

		@NamedQuery(name = "FofoStore.selectGroupByWarehouseBrandWisePartnerSale", query = "select new com.spice.profitmandi.dao.model.WarehouseWiseBrandSaleModel("

				+ "(case when a.city in ('Noida', 'Ghaziabad')  and foi.brand = 'Vivo' then 7573 else fs.warehouseId end) AS col_0_0_,"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :lms then CAST(foi.quantity*foi.mop  AS int) else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :lms then foi.quantity  else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd  then CAST(foi.quantity*foi.mop  AS int) else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd  then foi.quantity else 0 end), "

				+ "sum(case when foi.createTimestamp between  :lmtdStartDate and :lmtdEndDate  then CAST(foi.quantity*foi.mop  AS int) else 0 end), "

				+ "sum(case when foi.createTimestamp between  :lmtdStartDate and :lmtdEndDate then foi.quantity else 0 end))"

				+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id  join Item i on i.id = foi.itemId"

				+ " join com.spice.profitmandi.dao.entity.user.User u on u.id = fs.id join Address a on a.id = u.addressId"

				+ " where fo.cancelledTimestamp is null and fs.active = true"

				+ " and foi.createTimestamp >= :lmtdStartDate and foi.brand = :brand and i.categoryId = :categoryId and fs.id in :fofoId"

				+ " group by col_0_0_"),

		@NamedQuery(name = "FofoStore.selectWarehouseBrandItemSale", query = "select new com.spice.profitmandi.dao.model.WarehouseBrandWiseItemSaleModel(fs.warehouseId,i.id, i.brand, i.modelName, i.modelNumber,i.color,"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :lms then CAST(foi.quantity*foi.mop  AS int) else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :lms then foi.quantity  else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd  then CAST(foi.quantity*foi.mop  AS int) else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd  then foi.quantity else 0 end), "

				+ "sum(case when foi.createTimestamp between  :lmtdStartDate and :lmtdEndDate  then CAST(foi.quantity*foi.mop  AS int) else 0 end), "

				+ "sum(case when foi.createTimestamp between  :lmtdStartDate and :lmtdEndDate then foi.quantity else 0 end))"

				+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id  join Item i on i.id = foi.itemId  where fo.cancelledTimestamp is null and fs.active = true"

				+ " and  foi.createTimestamp >= :lmtdStartDate and fs.warehouseId in :warehouseId and i.brand = :brand and i.categoryId = :categoryId and fs.id in :fofoId group by i.id"),

		@NamedQuery(name = "FofoStore.selectGroupByBrandAccesoriesWarehousePartnerSale", query = "select new com.spice.profitmandi.dao.model.BrandWisePartnerSaleModel(foi.brand, "

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :lms then CAST(foi.quantity*foi.mop  AS int) else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :lms then foi.quantity  else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd  then CAST(foi.quantity*foi.mop  AS int) else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd  then foi.quantity else 0 end), "

				+ "sum(case when foi.createTimestamp between  :lmtdStartDate and :lmtdEndDate  then CAST(foi.quantity*foi.mop  AS int) else 0 end), "

				+ "sum(case when foi.createTimestamp between  :lmtdStartDate and :lmtdEndDate then foi.quantity else 0 end))"

				+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id  join Item i on i.id = foi.itemId  where fo.cancelledTimestamp is null and fs.active = true "

				+ "and foi.createTimestamp >= :lmtdStartDate and i.categoryId != :categoryId and fs.id in :fofoId"

				+ " group by foi.brand"),

		@NamedQuery(name = "FofoStore.selectGroupByWarehouseAccesoriesBrandWisePartnerSale", query = "select new com.spice.profitmandi.dao.model.WarehouseWiseBrandSaleModel(fs.warehouseId,"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :lms then CAST(foi.quantity*foi.mop  AS int) else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :lms then foi.quantity  else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd  then CAST(foi.quantity*foi.mop  AS int) else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd  then foi.quantity else 0 end), "

				+ "sum(case when foi.createTimestamp between  :lmtdStartDate and :lmtdEndDate  then CAST(foi.quantity*foi.mop  AS int) else 0 end), "

				+ "sum(case when foi.createTimestamp between  :lmtdStartDate and :lmtdEndDate then foi.quantity else 0 end))"

				+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id  join Item i on i.id = foi.itemId  where fo.cancelledTimestamp is null and fs.active = true"

				+ " and foi.createTimestamp >= :lmtdStartDate and foi.brand = :brand and i.categoryId != :categoryId and fs.id in :fofoId"

				+ " group by fs.warehouseId"),

		@NamedQuery(name = "FofoStore.selectWarehouseAccesoriesBrandItemSale", query = "select new com.spice.profitmandi.dao.model.WarehouseBrandWiseItemSaleModel(fs.warehouseId,i.id, i.brand, i.modelName, i.modelNumber,i.color,"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :lms then CAST(foi.quantity*foi.mop  AS int) else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :lms then foi.quantity  else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd  then CAST(foi.quantity*foi.mop  AS int) else 0 end),"

				+ "sum(case when concat(year(foi.createTimestamp), month(foi.createTimestamp))= :mtd  then foi.quantity else 0 end), "

				+ "sum(case when foi.createTimestamp between  :lmtdStartDate and :lmtdEndDate  then CAST(foi.quantity*foi.mop  AS int) else 0 end), "

				+ "sum(case when foi.createTimestamp between  :lmtdStartDate and :lmtdEndDate then foi.quantity else 0 end))"

				+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id  join Item i on i.id = foi.itemId  where fo.cancelledTimestamp is null and fs.active = true"

				+ " and  foi.createTimestamp >= :lmtdStartDate and fs.warehouseId in :warehouseId and i.brand = :brand and i.categoryId != :categoryId  and fs.id in :fofoId group by i.id"),

		@NamedQuery(name = "FofoStore.selectPartnerPendingIndentItem", query = "select new com.spice.profitmandi.dao.model.PartnerPendingIndentItemModel(o.retailerName,"

				+ " li.quantity, li.totalPrice)"

				+ " from FofoStore fs join Order o on fs.id = o.retailerId join  LineItem li on li.orderId = o.id "

				+ " where li.itemId = :itemId and fs.warehouseId = :warehouseId and o.status = 3"),

		@NamedQuery(name = "FofoStore.selectUnbilledActivateStockGroupByBrand", query = "select new com.spice.profitmandi.dao.model.BrandWiseUnbilledActivateStockModel(i.brand,"

				+ "  sum(case when concat(year(ai.activationTimestamp), month(ai.activationTimestamp)) = :almtd then 1 else 0 end),"

				+ "  sum(case when concat(year(ai.activationTimestamp), month(ai.activationTimestamp)) = :almtd then CAST(tl.sellingPrice  AS int) else 0 end))"

				+ " from FofoStore fs join InventoryItem ii on fs.id = ii.fofoId join ActivatedImei ai on ai.serialNumber = ii.serialNumber join Item i on i.id = ii.itemId join TagListing tl on tl.itemId = i.id"

				+ " where fs.active = true and ii.goodQuantity >= 1 and fs.id in :fofoId group by i.brand"),

		@NamedQuery(name = "FofoStore.selectUnbilledActivateStockGroupByWarehouse", query = "select new com.spice.profitmandi.dao.model.WarehouseWiseBrandUnbilledActivatedModel(fs.warehouseId,"

				+ "  sum(case when concat(year(ai.activationTimestamp), month(ai.activationTimestamp)) = :almtd then 1 else 0 end),"

				+ "  sum(case when concat(year(ai.activationTimestamp), month(ai.activationTimestamp)) = :almtd then CAST(tl.sellingPrice  AS int) else 0 end))"

				+ " from FofoStore fs join InventoryItem ii on fs.id = ii.fofoId join ActivatedImei ai on ai.serialNumber = ii.serialNumber join Item i on i.id = ii.itemId join TagListing tl on tl.itemId = i.id"

				+ " where fs.active = true and ii.goodQuantity >= 1 and i.brand = :brand and fs.id in :fofoId group by fs.warehouseId"),

		@NamedQuery(name = "FofoStore.selectWarehouseBrandItemUnbilledActivateStock", query = "select new com.spice.profitmandi.dao.model.WarehouseBrandItemUnbilledActivatedModel(fs.warehouseId,i.id, i.brand, i.modelName, i.modelNumber,i.color,"

				+ "  sum(case when concat(year(ai.activationTimestamp), month(ai.activationTimestamp)) = :almtd then 1 else 0 end),"

				+ "  sum(case when concat(year(ai.activationTimestamp), month(ai.activationTimestamp)) = :almtd then CAST(tl.sellingPrice  AS int) else 0 end))"

				+ " from FofoStore fs join InventoryItem ii on fs.id = ii.fofoId join ActivatedImei ai on ai.serialNumber = ii.serialNumber join Item i on i.id = ii.itemId join TagListing tl on tl.itemId = i.id"

				+ " where fs.active = true and ii.goodQuantity >= 1 and i.brand = :brand and fs.warehouseId in :warehouseId and fs.id in :fofoId  group by i.id"),

		@NamedQuery(name = "FofoStore.selectGroupByBrandLms", query = "select new com.spice.profitmandi.dao.model.BrandWiseModel(foi.brand, DATE_FORMAT(fo.createTimestamp, '%m-%Y'),sum(cast(foi.mop*foi.quantity As int)))"

				+ " from FofoStore fs join FofoOrder fo on fs.id = fo.fofoId join FofoOrderItem foi on foi.orderId = fo.id  join Item i on i.id = foi.itemId  where fo.cancelledTimestamp is null and fs.active = true "

				+ " and foi.createTimestamp >= :lmsStartDate and i.categoryId = :categoryId and fs.id in :fofoId and fs.warehouseId in :warehouseId"

				+ " group by foi.brand,DATE_FORMAT(fo.createTimestamp, '%m-%Y')"), })

public class FofoStore implements Serializable {

	private static final long serialVersionUID = 1L;

	public FofoStore() {

	}

	@Id

	@Column(name = "id", unique = true, updatable = false)

	private int id;

	@Column(name = "code", unique = true)

	private String code;

	@Column(name = "latitude")

	private String latitude;

	@Column(name = "longitude")

	private String longitude;

	@Column(name = "counter_size")

	@Enumerated(EnumType.STRING)

	private CounterSize counterSize = CounterSize.TEN_LAC;

	@Column(name = "warehouse_id")

	private int warehouseId;

	@Column(name = "minimum_investment")

	private float minimumInvestment;

	@Column(name = "grace_date")

	private LocalDate graceDate;

	@Column(name = "investment_ok")

	private boolean investmentOk;

	@Column

	private boolean active = true;

	@Column

	private String pan;

	@Transient

	private Address userAddress;

	@Column(name = "internal")

	private boolean internal;

	@Column(name = "bags_last_credited")

	private LocalDateTime bagsLastCredited;

	@Column(name = "fofo_type")

	@Enumerated(EnumType.STRING)

	private FofoType fofoType;

	@Column(name = "active_timestamp")

	private LocalDateTime activeTimeStamp;

	public LocalDateTime getBagsLastCredited() {

		return bagsLastCredited;

	}

	public void setBagsLastCredited(LocalDateTime bagsLastCredited) {

		this.bagsLastCredited = bagsLastCredited;

	}

	public boolean isInternal() {

		return internal;

	}

	public void setInternal(boolean internal) {

		this.internal = internal;

	}

	public int getWarehouseId() {

		return warehouseId;

	}

	public void setWarehouseId(int warehouseId) {

		this.warehouseId = warehouseId;

	}

	public boolean isInvestmentOk() {

		return investmentOk;

	}

	public void setInvestmentOk(boolean investmentOk) {

		this.investmentOk = investmentOk;

	}

	@Column(name = "grace_count")

	private int graceCount;

	public String getPan() {

		return pan;

	}

	public void setPan(String pan) {

		this.pan = pan;

	}

	public int getGraceCount() {

		return graceCount;

	}

	public boolean isActive() {

		return active;

	}

	public void setActive(boolean active) {

		this.active = active;

	}

	public void setGraceCount(int graceCount) {

		this.graceCount = graceCount;

	}

	public LocalDate getGraceDate() {

		return graceDate;

	}

	public void setGraceDate(LocalDate graceDate) {

		this.graceDate = graceDate;

	}

	public float getMinimumInvestment() {

		return minimumInvestment;

	}

	public void setMinimumInvestment(float minimumInvestment) {

		this.minimumInvestment = minimumInvestment;

	}

	/*

	 * public int getCreditCycle() { return creditCycle; } public void

	 * setCreditCycle(int creditCycle) { this.creditCycle = creditCycle; }

	 */

	public CounterSize getCounterSize() {

		return counterSize;

	}

	public void setCounterSize(CounterSize counterSize) {

		this.counterSize = counterSize;

	}

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	public String getCode() {

		return code;

	}

	public void setCode(String code) {

		this.code = code;

	}

	public String getLatitude() {

		return latitude;

	}

	public void setLatitude(String latitude) {

		this.latitude = latitude;

	}

	public String getLongitude() {

		return longitude;

	}

	public void setLongitude(String longitude) {

		this.longitude = longitude;

	}

	public Address getUserAddress() {

		return userAddress;

	}

	public void setUserAddress(Address userAddress) {

		this.userAddress = userAddress;

	}

	public LocalDateTime getActiveTimeStamp() {

		return activeTimeStamp;

	}

	public void setActiveTimeStamp(LocalDateTime activeTimeStamp) {

		this.activeTimeStamp = activeTimeStamp;

	}

	public FofoType getFofoType() {

		return fofoType;

	}

	public void setFofoType(FofoType fofoType) {

		this.fofoType = fofoType;

	}

	@Override

	public int hashCode() {

		final int prime = 31;

		int result = 1;

		result = prime * result + (active ? 1231 : 1237);

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

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

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

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

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

		result = prime * result + graceCount;

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

		result = prime * result + id;

		result = prime * result + (internal ? 1231 : 1237);

		result = prime * result + (investmentOk ? 1231 : 1237);

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

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

		result = prime * result + Float.floatToIntBits(minimumInvestment);

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

		result = prime * result + warehouseId;

		return result;

	}

	@Override

	public boolean equals(Object obj) {

		if (this == obj)

			return true;

		if (obj == null)

			return false;

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

			return false;

		FofoStore other = (FofoStore) obj;

		if (active != other.active)

			return false;

		if (activeTimeStamp == null) {

			if (other.activeTimeStamp != null)

				return false;

		} else if (!activeTimeStamp.equals(other.activeTimeStamp))

			return false;

		if (bagsLastCredited == null) {

			if (other.bagsLastCredited != null)

				return false;

		} else if (!bagsLastCredited.equals(other.bagsLastCredited))

			return false;

		if (code == null) {

			if (other.code != null)

				return false;

		} else if (!code.equals(other.code))

			return false;

		if (counterSize != other.counterSize)

			return false;

		if (fofoType != other.fofoType)

			return false;

		if (graceCount != other.graceCount)

			return false;

		if (graceDate == null) {

			if (other.graceDate != null)

				return false;

		} else if (!graceDate.equals(other.graceDate))

			return false;

		if (id != other.id)

			return false;

		if (internal != other.internal)

			return false;

		if (investmentOk != other.investmentOk)

			return false;

		if (latitude == null) {

			if (other.latitude != null)

				return false;

		} else if (!latitude.equals(other.latitude))

			return false;

		if (longitude == null) {

			if (other.longitude != null)

				return false;

		} else if (!longitude.equals(other.longitude))

			return false;

		if (Float.floatToIntBits(minimumInvestment) != Float.floatToIntBits(other.minimumInvestment))

			return false;

		if (userAddress == null) {

			if (other.userAddress != null)

				return false;

		} else if (!userAddress.equals(other.userAddress))

			return false;

		if (warehouseId != other.warehouseId)

			return false;

		return true;

	}

	@Override

	public String toString() {

		return "FofoStore [id=" + id + ", code=" + code + ", latitude=" + latitude + ", longitude=" + longitude

				+ ", counterSize=" + counterSize + ", warehouseId=" + warehouseId + ", minimumInvestment="

				+ minimumInvestment + ", graceDate=" + graceDate + ", investmentOk=" + investmentOk + ", active="

				+ active + ", userAddress=" + userAddress + ", internal=" + internal + ", bagsLastCredited="

				+ bagsLastCredited + ", fofoType=" + fofoType + ", activeTimeStamp=" + activeTimeStamp + ", graceCount="

				+ graceCount + "]";

	}

}