Subversion Repositories SmartDukaan

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

import com.spice.profitmandi.common.util.FormattingUtils;

import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;

import com.spice.profitmandi.dao.entity.fofo.PartnerType;

import com.spice.profitmandi.dao.enumuration.catalog.AmountType;

import com.spice.profitmandi.dao.enumuration.catalog.SchemeType;

import javax.persistence.*;

import java.io.Serializable;

import java.time.LocalDateTime;

import java.time.format.DateTimeFormatter;

import java.util.*;

/**

 * This class basically contains scheme details

 *

 * @author ashikali

 */

@NamedQueries({ @NamedQuery(name = "scheme.selectSchemesByRetailerIdsSchemeIds", query = "select sr.schemeId from"

		+ " SchemeRegion sr join PartnerRegion pr on pr.regionId=sr.regionId where pr.fofoId in :fofoIds and sr.schemeId in :schemeIds"),

		@NamedQuery(name = "Scheme.selectSchemeByModelsPartnerTypeFofoId", query = "select s from Scheme s"

				+ " join SchemeItem si on si.schemeId = s.id" + " join SchemeRegion sr on sr.schemeId = s.id"

				+ " join PartnerRegion pr on pr.regionId=sr.regionId"

				+ " where pr.fofoId in :fofoIds and s.partnerType in :partnerTypes" + " and si.catalogId in :catalogIds"

				+ " and :onDate between s.startDateTime and s.endDateTime" +

				// " and s.endDateTime >= :onDate" +

				" and s.activeTimestamp is not null"),

		@NamedQuery(name = "Scheme.selectSchemesByBrandsAndFofoRegion", query = "select distinct s from Scheme s"

				+ " join SchemeItem si on si.schemeId = s.id"

				+ " join Item i on i.catalogItemId = si.catalogId"

				+ " join SchemeRegion sr on sr.schemeId = s.id"

				+ " where i.brand in :brands"

				+ " and s.activeTimestamp is not null"

				+ " and s.partnerType in :partnerTypes"

				+ " and s.startDateTime <= :onDate"

				+ " and COALESCE(s.expireTimestamp, s.endDateTime) >= :onDate"

				+ " and (si.endDate is null or si.endDate >= :onDate)"

				+ " and (sr.regionId = 5 or sr.regionId in :regionIds)"

				+ " order by s.id desc"),

		@NamedQuery(name = "Scheme.selectSchemesByBrands", query = "select distinct s from Scheme s"

				+ " join SchemeItem si on si.schemeId = s.id"

				+ " join Item i on i.catalogItemId = si.catalogId"

				+ " where i.brand in :brands"

				+ " and s.activeTimestamp is not null"

				+ " and s.partnerType in :partnerTypes"

				+ " and s.startDateTime <= :onDate"

				+ " and COALESCE(s.expireTimestamp, s.endDateTime) >= :onDate"

				+ " and (si.endDate is null or si.endDate >= :onDate)"

				+ " order by s.id desc"),

		@NamedQuery(name = "Scheme.selectActiveSchemesByFofoRegion", query = "select distinct s from Scheme s"

				+ " join SchemeItem si on si.schemeId = s.id"

				+ " join SchemeRegion sr on sr.schemeId = s.id"

				+ " where s.activeTimestamp is not null"

				+ " and s.partnerType in :partnerTypes"

				+ " and s.startDateTime <= :onDate"

				+ " and COALESCE(s.expireTimestamp, s.endDateTime) >= :onDate"

				+ " and (si.endDate is null or si.endDate >= :onDate)"

				+ " and (sr.regionId = 5 or sr.regionId in :regionIds)"

				+ " order by s.id desc"),

		@NamedQuery(name = "Scheme.selectAllActiveSchemes", query = "select distinct s from Scheme s"

				+ " join SchemeItem si on si.schemeId = s.id"

				+ " where s.activeTimestamp is not null"

				+ " and s.partnerType in :partnerTypes"

				+ " and s.startDateTime <= :onDate"

				+ " and COALESCE(s.expireTimestamp, s.endDateTime) >= :onDate"

				+ " and (si.endDate is null or si.endDate >= :onDate)"

				+ " order by s.id desc")

		/*

		 * ,

		 * 

		 * @NamedQuery(name="scheme.getImeiMarginsPaidOnBillingMonth", query=

		 * "select new com.spice.profitmandi.dao.repository.catalog.ImeiMarginModel(" +

		 * ") from LineItemImei li1" +

		 * "         left join LineItemImei li2 on (li1.serialNumber = li2.serialNumber and li1.id < li2.id)"

		 * + "         join LineItem li on li.id = li1.lineItemId" +

		 * "         join Order o on o.id = li.orderId" +

		 * "         join Item ci on li.itemId = ci.id" +

		 * "         join SchemeItem si on si.catalogId = ci.catalogItemId" +

		 * "         join Scheme s1 on s1.id = si.schemeId" +

		 * "         join SchemeRegion sr on sr.schemeId = s1.id" +

		 * "         join PartnerRegion pr on (pr.regionId = sr.regionId and pr.fofoId in (0, o.id))"

		 * + "         left join PartnerTypeChange ptc on ptc.fofoId = o.retailerId" +

		 * "         left join PartnerTypeChange ptc2 on (ptc2.fofoId = ptc.fofoId and ptc.createTimestamp < ptc2.createTimestamp)"

		 * + "where li2.id is null" + "  and ptc2.createTimestamp is null" +

		 * "  and o.billing_timestamp between :startDate and :endDate" +

		 * "  and '2022-12-01' between s1.start_date_time and s1.end_date_time" +

		 * "  and ((ptc.partnerType is null and s1.partner_type in ('ALL', 'NEW'))" +

		 * "    or s1.partnerType in (ptc.partnerType, 'ALL'))" +

		 * "  and s1.activeTimestamp is not null" + "  and s1.amountType = 'PERCENTAGE'"

		 * + "group by li.serial_number) as set1\n" + "")

		 */

})

@NamedNativeQueries({

		@NamedNativeQuery(name = "scheme.getActiveScheme", query = "select si.catalog_id from catalog.scheme s join "

				+ " fofo.scheme_item si on s.id = si.scheme_id join catalog.item i on i.catalog_item_id = si.catalog_id"

				+ " where s.active_timestamp is not null and start_date_time <= :startDate and end_date_time >= :startDate"

				+ " and (si.start_date is null or :startDate between si.start_date and si.end_date)"

				+ " and s.type = 'SPECIAL_SUPPORT' and i.hsnCode = '85171300' order by active_timestamp desc "),

		@NamedNativeQuery(name = "scheme.selectMissedActivationSale", query = "select cs.id as scheme_id, ai.serial_number, sr.order_id, ii.id as inventory_item_id, ai.activation_timestamp"

				+ " from fofo.activated_imei ai "

				+ "   join fofo.inventory_item ii on ai.serial_number = ii.serial_number "

				+ "   join catalog.item i on i.id = ii.item_id "

				+ "   join catalog.scheme cs on ai.activation_timestamp >= cs.start_date_time and ai.activation_timestamp <= cs.end_date_time  "

				+ "   join fofo.scheme_item si on (si.scheme_id = cs.id and i.catalog_item_id = si.catalog_id and (si.start_date is null or ai.activation_timestamp between si.start_date and si.end_date)) "

				+ "	  join fofo.scan_record sr on (sr.inventory_item_id = ii.id)"

				+ "   join fofo.scheme_region sre on sre.scheme_id = cs.id"

				+ "   join cs.partner_region pr on (pr.region_id = sre.region_id and (pr.fofo_id = ii.fofo_id or pr.fofo_id = 0))"

				+ "	left join fofo.scheme_in_out sio on (sio.scheme_id = cs.id and sio.inventory_item_id = ii.id) "

				+ " where cs.active_timestamp is not null " + " and cs.type ='SPECIAL_SUPPORT'"

				+ " and sr.type = 'SALE'" + " and (sio.id is null or sio.status='REJECTED') "

				+ " and ai.checked = false", resultSetMapping = "missedActivationSaleMapping") })

@SqlResultSetMappings({ @SqlResultSetMapping(name = "missedActivationSaleMapping", classes = {

		@ConstructorResult(targetClass = SchemesImeisModel.class, columns = {

				@ColumnResult(name = "serial_number", type = String.class),

				@ColumnResult(name = "activation_timestamp", type = LocalDateTime.class),

				@ColumnResult(name = "order_id", type = Integer.class),

				@ColumnResult(name = "inventory_item_id", type = Integer.class),

				@ColumnResult(name = "scheme_id", type = Integer.class), }) }) })

@Entity

@Table(name = "catalog.scheme")

public class Scheme implements Serializable {

	public PartnerType getPartnerType() {

		return partnerType;

	}

	public void setPartnerType(PartnerType partnerType) {

		this.partnerType = partnerType;

	}

	private static final long serialVersionUID = 1L;

	public Scheme() {

	}

	@Id

	@Column(name = "id")

	@GeneratedValue(strategy = GenerationType.IDENTITY)

	private int id;

	@Column(name = "`name`")

	private String name;

	@Column(name = "description")

	private String description;

	@Column(name = "`type`")

	@Enumerated(EnumType.STRING)

	private SchemeType type;

	@Column(name = "amount_type")

	@Enumerated(EnumType.STRING)

	private AmountType amountType;

	@Column(name = "base_plus_gst_calc")

	private boolean basePlusGstCalc;

	@Column(name = "amount")

	private float amount;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "start_date_time")

	private LocalDateTime startDateTime = LocalDateTime.now();

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "end_date_time")

	private LocalDateTime endDateTime = LocalDateTime.now();

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "create_timestamp")

	private LocalDateTime createTimestamp = LocalDateTime.now();

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "active_timestamp")

	private LocalDateTime activeTimestamp = null;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "expire_timestamp")

	private LocalDateTime expireTimestamp = null;

	@Column(name = "created_by")

	private int createdBy;

	//Dummy hardcode

	@Transient

	private int target;

	public int getTarget() {

		return target;

	}

	public void setTarget(int target) {

		this.target = target;

	}

	@Column

	private boolean cashback;

	@Transient

	private Set<Integer> retailerIds;

	@Transient

	private String amountModel;

	@Transient

	private float schemeValue;

	public float getSchemeValue() {

		return schemeValue;

	}

	public void setSchemeValue(float schemeValue) {

		this.schemeValue = schemeValue;

	}

	public String getSchemePeriod() {

		return FormattingUtils.formatDateMonthNonHyphenated(this.getStartDateTime()) + " - " + FormattingUtils.formatDateMonthNonHyphenated(this.getEndDateTime());

	}

	@Column(name = "partner_type")

	@Enumerated(EnumType.STRING)

	private PartnerType partnerType;

	@Override

	public String toString() {

		return "Scheme{" + "id=" + id + ", name='" + name + '\'' + ", description='" + description + '\'' + ", type="

				+ type + ", amountType=" + amountType + ", gstReversal=" + basePlusGstCalc + ", amount=" + amount

				+ ", startDateTime=" + startDateTime + ", endDateTime=" + endDateTime + ", createTimestamp="

				+ createTimestamp + ", activeTimestamp=" + activeTimestamp + ", expireTimestamp=" + expireTimestamp

				+ ", createdBy=" + createdBy + ", cashback=" + cashback + ", retailerIds=" + retailerIds

				+ ", amountModel='" + amountModel + '\'' + ", schemeValue=" + schemeValue + ", partnerType="

				+ partnerType + ", catalogStringMap=" + catalogStringMap + '}';

	}

	@Override

	public boolean equals(Object o) {

		if (this == o)

			return true;

		if (o == null || getClass() != o.getClass())

			return false;

		Scheme scheme = (Scheme) o;

		return id == scheme.id && basePlusGstCalc == scheme.basePlusGstCalc && Float.compare(scheme.amount, amount) == 0

				&& createdBy == scheme.createdBy && cashback == scheme.cashback

				&& Float.compare(scheme.schemeValue, schemeValue) == 0 && Objects.equals(name, scheme.name)

				&& Objects.equals(description, scheme.description) && type == scheme.type

				&& amountType == scheme.amountType && Objects.equals(startDateTime, scheme.startDateTime)

				&& Objects.equals(endDateTime, scheme.endDateTime)

				&& Objects.equals(createTimestamp, scheme.createTimestamp)

				&& Objects.equals(activeTimestamp, scheme.activeTimestamp)

				&& Objects.equals(expireTimestamp, scheme.expireTimestamp)

				&& Objects.equals(retailerIds, scheme.retailerIds) && Objects.equals(amountModel, scheme.amountModel)

				&& partnerType == scheme.partnerType && Objects.equals(catalogStringMap, scheme.catalogStringMap);

	}

	@Override

	public int hashCode() {

		return Objects.hash(id, name, description, type, amountType, basePlusGstCalc, amount, startDateTime,

				endDateTime, createTimestamp, activeTimestamp, expireTimestamp, createdBy, cashback, retailerIds,

				amountModel, schemeValue, partnerType, catalogStringMap);

	}

	@Transient

	private Map<Integer, String> catalogStringMap = new HashMap<>();

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	public String getAmountModel() {

		return amountModel;

	}

	public void setAmountModel(String amountModel) {

		this.amountModel = amountModel;

	}

	public String getName() {

		return name;

	}

	public void setName(String name) {

		this.name = name;

	}

	public String getDescription() {

		return description;

	}

	public void setDescription(String description) {

		this.description = description;

	}

	public boolean isCashback() {

		return cashback;

	}

	public void setCashback(boolean cashback) {

		this.cashback = cashback;

	}

	public SchemeType getType() {

		return type;

	}

	public void setType(SchemeType type) {

		this.type = type;

	}

	public AmountType getAmountType() {

		return amountType;

	}

	public void setAmountType(AmountType amountType) {

		this.amountType = amountType;

	}

	public float getAmount() {

		return amount;

	}

	public void setAmount(float amount) {

		this.amount = amount;

	}

	public LocalDateTime getStartDateTime() {

		return startDateTime;

	}

	public void setStartDateTime(LocalDateTime startDateTime) {

		this.startDateTime = startDateTime;

	}

	public LocalDateTime getEndDateTime() {

		return endDateTime;

	}

	public void setEndDateTime(LocalDateTime endDateTime) {

		this.endDateTime = endDateTime;

	}

	public LocalDateTime getCreateTimestamp() {

		return createTimestamp;

	}

	public void setCreateTimestamp(LocalDateTime createTimestamp) {

		this.createTimestamp = createTimestamp;

	}

	public int getCreatedBy() {

		return createdBy;

	}

	public void setCreatedBy(int createdBy) {

		this.createdBy = createdBy;

	}

	public LocalDateTime getActiveTimestamp() {

		return activeTimestamp;

	}

	public void setActiveTimestamp(LocalDateTime activeTimestamp) {

		this.activeTimestamp = activeTimestamp;

	}

	public LocalDateTime getExpireTimestamp() {

		return expireTimestamp;

	}

	public void setExpireTimestamp(LocalDateTime expireTimestamp) {

		this.expireTimestamp = expireTimestamp;

	}

	public String getFormattedStartDateTime() {

		if (startDateTime == null) {

			return null;

		}

		DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-yyyy");

		return startDateTime.format(formatter);

	}

	public String getFormattedEndDateTime() {

		if (endDateTime == null) {

			return null;

		}

		DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-yyyy");

		return endDateTime.format(formatter);

	}

	public String getFormattedCreateTimestamp() {

		if (createTimestamp == null) {

			return null;

		}

		DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-yyyy HH:mm");

		return createTimestamp.format(formatter);

	}

	public String getFormattedActiveTimestamp() {

		if (activeTimestamp == null) {

			return null;

		}

		DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-yyyy HH:mm");

		return activeTimestamp.format(formatter);

	}

	public String getFormattedExpireTimestamp() {

		if (expireTimestamp == null) {

			return null;

		}

		DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-yyyy HH:mm");

		return expireTimestamp.format(formatter);

	}

	public Set<Integer> getRetailerIds() {

		return retailerIds;

	}

	public void setRetailerIds(Set<Integer> retailerIds) {

		this.retailerIds = retailerIds;

	}

	public String getRetailerIdsString() {

		if (retailerIds == null || retailerIds.isEmpty()) {

			return "";

		}

		Set<String> stringRetailerIds = new HashSet<>();

		for (int retailerId : retailerIds) {

			stringRetailerIds.add(String.valueOf(retailerId));

		}

		return String.join(", ", stringRetailerIds);

	}

	public boolean isBasePlusGstCalc() {

		return basePlusGstCalc;

	}

	public void setBasePlusGstCalc(boolean gstReversal) {

		this.basePlusGstCalc = gstReversal;

	}

	public Map<Integer, String> getCatalogStringMap() {

		return catalogStringMap;

	}

	public void setCatalogStringMap(Map<Integer, String> catalogStringMap) {

		this.catalogStringMap = catalogStringMap;

	}

	public boolean isWithinRange(LocalDateTime testDate) {

		return !(testDate.isBefore(this.startDateTime) || testDate.isAfter(endDateTime));

	}

}