Subversion Repositories SmartDukaan

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

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

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

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

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

import javax.persistence.*;

import java.io.Serializable;

import java.time.LocalDate;

import java.time.LocalDateTime;

/**

 * This class basically contains store code details

 *

 * @author ashikali

 */

@Entity

@Table(name = "fofo.fofo_store")

@NamedQueries({

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

                + "where ua.type='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, :groupParameter),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 between :lmsStartDate and :endDate) and i.categoryId = :categoryId and fs.id in :fofoId and fs.warehouseId in :warehouseId"

                + " group by foi.brand,DATE_FORMAT(fo.createTimestamp, :groupParameter)"),})

public class FofoStore implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id

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

    private int id;

    private int codeInt;

    @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 = "counter_potential")

    private float counterPotential;

    @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 = "activation_type")

    @Enumerated(EnumType.STRING)

    private ActivationType activationType = ActivationType.BILLING_PENDING;

    @Column(name = "active_timestamp")

    private LocalDateTime activeTimeStamp;

    @Column(name = "target")

    private int target;

    @Column(name = "grace_count")

    private int graceCount;

    @Column(name = "astId")

    private int astId;

    public FofoStore() {

    }

    public int getAstId() {

        return astId;

    }

    public void setAstId(int astId) {

        this.astId = astId;

    }

    public int getCodeInt() {

        return codeInt;

    }

    public void setCodeInt(int codeInt) {

        this.codeInt = codeInt;

    }

    public int getTarget() {

        return target;

    }

    public void setTarget(int target) {

        this.target = target;

    }

    public ActivationType getActivationType() {

        return activationType;

    }

    public void setActivationType(ActivationType activationType) {

        this.activationType = activationType;

    }

    public float getCounterPotential() {

        return counterPotential;

    }

    public void setCounterPotential(float counterPotential) {

        this.counterPotential = counterPotential;

    }

    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;

    }

    public String getPan() {

        return pan;

    }

    public void setPan(String pan) {

        this.pan = pan;

    }

    public int getGraceCount() {

        return graceCount;

    }

    public void setGraceCount(int graceCount) {

        this.graceCount = graceCount;

    }

    public boolean isActive() {

        return active;

    }

    public void setActive(boolean active) {

        this.active = active;

    }

    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 + ((activationType == null) ? 0 : activationType.hashCode());

        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 + Float.floatToIntBits(counterPotential);

        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 + ((pan == null) ? 0 : pan.hashCode());

        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 (activationType != other.activationType)

            return false;

        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 (Float.floatToIntBits(counterPotential) != Float.floatToIntBits(other.counterPotential))

            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 (astId != other.astId)

            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 (pan == null) {

            if (other.pan != null)

                return false;

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

            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 + ",astId=" + astId + ", code=" + code + ", latitude=" + latitude + ", longitude=" + longitude

                + ", counterSize=" + counterSize + ", counterPotential=" + counterPotential + ", warehouseId="

                + warehouseId + ", minimumInvestment=" + minimumInvestment + ", graceDate=" + graceDate

                + ", investmentOk=" + investmentOk + ", active=" + active + ", pan=" + pan + ", userAddress="

                + userAddress + ", internal=" + internal + ", bagsLastCredited=" + bagsLastCredited + ", fofoType="

                + fofoType + ", activationType=" + activationType + ", activeTimeStamp=" + activeTimeStamp

                + ", graceCount=" + graceCount + "]";

    }

}