Subversion Repositories SmartDukaan

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

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

import javax.persistence.*;

import java.io.Serializable;

import java.time.LocalDate;

import java.time.LocalDateTime;

import java.time.format.DateTimeFormatter;

/**

 * This class basically contains details

 *

 * @author ashikali

 */

/**

 * @author amit

 *

 */

@Entity

@Table(name = "transaction.price_drop")

@NamedQueries(value = {

		@NamedQuery(name = "PriceDrop.selectBrandPendingPriceDropByYearMonth", query = "select new com.spice.profitmandi.dao.model.PriceDropYearMonthModel(i.brand, "

				+ "   DATE_FORMAT(pd.affectedOn, '%m-%Y'),sum(cast(pd.amount As  integer )) ) from PriceDrop pd join  PriceDropIMEI pdi  on"

				+ " (pd.id = pdi.priceDropId) join InventoryItem it  on (pdi.imei = it.serialNumber and pdi.partnerId=it.fofoId)"

				+ " join Item i on i.id = it.itemId where pdi.status ='PENDING' and pdi.partnerId = :fofoId and "

				+ " pd.amount > 0 and pd.affectedOn >= :startDate group by i.brand, DATE_FORMAT(pd.affectedOn, '%m-%Y')"),

		@NamedQuery(name = "PriceDrop.selectSixMonthBrandPriceDropByYearMonth", query = "select new com.spice.profitmandi.dao.model.PriceDropBrandModel(i.brand, "

				+ " sum(cast(pd.amount As integer )) ) from PriceDrop pd join  PriceDropIMEI pdi  on"

				+ " (pd.id = pdi.priceDropId) join InventoryItem it on (pdi.imei = it.serialNumber and pdi.partnerId=it.fofoId)"

				+ " join Item i on i.id = it.itemId where pdi.status ='PENDING' and pdi.partnerId = :fofoId and "

				+ " pd.amount > 0 and pd.affectedOn >= :startDate and pd.affectedOn <= :endDate group by i.brand"),

		@NamedQuery(name = "PriceDrop.selectBrandPendingPriceDropWithDetailsByYearMonth", query = "select new com.spice.profitmandi.dao.model.PriceDropWithDetailsByYearMonthModel(i.brand, "

				+ "  i.modelName,i.modelNumber,cast(pd.amount As integer ),pdi.imei ) from PriceDrop pd join  PriceDropIMEI pdi  on"

				+ " (pd.id = pdi.priceDropId) join InventoryItem it  on (pdi.imei = it.serialNumber and pdi.partnerId=it.fofoId)"

				+ " join Item i on i.id = it.itemId where pdi.status ='PENDING' and pdi.partnerId = :fofoId and "

				+ " pd.amount > 0  and i.brand = :brand and DATE_FORMAT(pd.affectedOn, '%m-%Y') = :yearMonthValue"),

		@NamedQuery(name = "PriceDrop.selectBrandPendingPriceDropWithDetailsAndSixMonth", query = "select new com.spice.profitmandi.dao.model.PriceDropWithDetailsByYearMonthModel(i.brand, "

				+ "  i.modelName,i.modelNumber,cast(pd.amount As integer ),pdi.imei ) from PriceDrop pd join  PriceDropIMEI pdi  on"

				+ " (pd.id = pdi.priceDropId) join InventoryItem it  on (pdi.imei = it.serialNumber and pdi.partnerId=it.fofoId)"

				+ " join Item i on i.id = it.itemId where pdi.status ='PENDING' and pdi.partnerId = :fofoId and "

				+ " pd.amount > 0  and i.brand = :brand and pd.affectedOn >= :startDate and pd.affectedOn <= :endDate"),

		@NamedQuery(name = "PriceDrop.selectPriceDropToReprocess", query = "select distinct pd.id " +

				"from PriceDrop pd " +

				"         join PriceDropIMEI pdi on pd.id = pdi.priceDropId " +

				"         join ActivatedImei ai on ai.serialNumber = pdi.imei " +

				"where pd.affectedOn > ai.activationTimestamp " +

				"  and pdi.status = 'APPROVED' " +

				"  and pdi.creditTimestamp >= :dateOnwards"),

})

public class PriceDrop implements Serializable {

	private static final long serialVersionUID = 1L;

	public PriceDrop() {

	}

	@Id

	@Column(name = "id")

	@GeneratedValue(strategy = GenerationType.IDENTITY)

	private int id;

	@Column(name = "catalog_id")

	private int catalogItemId;

	@Column(name = "amount")

	private float amount;

	@Column(name = "new_dp")

	private float newDp;

	@Column(name = "old_dp")

	private float oldDp;

	@Column(name = "mop")

	private float mop;

	@Column(name = "tp")

	private float tp;

	@Column(name = "nlc")

	private float nlc;

	@Transient

	private String description;

	public String getDescription() {

		return description;

	}

	public void setDescription(String description) {

		this.description = description;

	}

	public float getMop() {

		return mop;

	}

	public void setMop(float mop) {

		this.mop = mop;

	}

	public float getNewDp() {

		return newDp;

	}

	public void setNewDp(float newDp) {

		this.newDp = newDp;

	}

	public float getOldDp() {

		return oldDp;

	}

	public void setOldDp(float oldDp) {

		this.oldDp = oldDp;

	}

	public float getTp() {

		return tp;

	}

	public void setTp(float tp) {

		this.tp = tp;

	}

	public float getNlc() {

		return nlc;

	}

	public void setNlc(float nlc) {

		this.nlc = nlc;

	}

	@Column(name = "credit_note_number")

	private String creditNoteNumber;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "process_timestamp")

	private LocalDateTime processTimestamp;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "complete_timestamp")

	private LocalDateTime completeTimestamp;

	@Column(name = "price_drop_in")

	private float priceDropIn;

	@Column(name = "partner_payout")

	private float partnerPayout;

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "created_on")

	private LocalDateTime createdOn = LocalDateTime.now();

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "affected_on")

	private LocalDateTime affectedOn = LocalDateTime.now();

	@Convert(converter = LocalDateTimeAttributeConverter.class)

	@Column(name = "credit_note_date")

	private LocalDateTime creditNoteDate;

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	public float getPriceDropIn() {

		return priceDropIn;

	}

	public void setPriceDropIn(float priceDropIn) {

		this.priceDropIn = priceDropIn;

	}

	public int getCatalogItemId() {

		return catalogItemId;

	}

	public void setCatalogItemId(int catalogItemId) {

		this.catalogItemId = catalogItemId;

	}

	@Override

	public String toString() {

		return "PriceDrop [id=" + id + ", catalogItemId=" + catalogItemId + ", amount=" + amount + ", newDp=" + newDp

				+ ", oldDp=" + oldDp + ", mop=" + mop + ", tp=" + tp + ", nlc=" + nlc + ", description=" + description

				+ ", creditNoteNumber=" + creditNoteNumber + ", processTimestamp=" + processTimestamp

				+ ", completeTimestamp=" + completeTimestamp + ", priceDropIn=" + priceDropIn + ", partnerPayout="

				+ partnerPayout + ", createdOn=" + createdOn + ", affectedOn=" + affectedOn + ", creditNoteDate="

				+ creditNoteDate + "]";

	}

	public float getAmount() {

		return amount;

	}

	public void setAmount(float amount) {

		this.amount = amount;

	}

	public LocalDateTime getProcessTimestamp() {

		return processTimestamp;

	}

	public void setProcessTimestamp(LocalDateTime processTimestamp) {

		this.processTimestamp = processTimestamp;

	}

	public String getCreditNoteNumber() {

		return creditNoteNumber;

	}

	public void setCreditNoteNumber(String creditNoteNumber) {

		this.creditNoteNumber = creditNoteNumber;

	}

	public LocalDateTime getCreatedOn() {

		return createdOn;

	}

	public void setCreatedOn(LocalDateTime createdOn) {

		this.createdOn = createdOn;

	}

	public LocalDateTime getAffectedOn() {

		return affectedOn;

	}

	public void setAffectedOn(LocalDateTime affectedOn) {

		this.affectedOn = affectedOn;

	}

	public LocalDateTime getCreditNoteDate() {

		return creditNoteDate;

	}

	public void setCreditNoteDate(LocalDateTime creditNoteDate) {

		this.creditNoteDate = creditNoteDate;

	}

	public float getPartnerPayout() {

		return partnerPayout;

	}

	public float getDropAmount() {

		return oldDp - newDp;

	}

	public float getAutoPartnerPayout(LocalDateTime creditDate) {

		if (creditDate.toLocalDate().isAfter(LocalDate.of(2022, 9, 15))) {

			return this.getDropAmount();

		} else {

			if (this.getPartnerPayout() == 0) {

				return this.getDropAmount() / 1.18f;

			} else {

				return this.getPartnerPayout();

			}

		}

	}

	public void setPartnerPayout(float partnerPayout) {

		this.partnerPayout = partnerPayout;

	}

	public String getDate(LocalDateTime ldt) {

		DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy/MM/dd");

		String s = dtf.format(ldt);

		return s;

	}

	public LocalDateTime getCompleteTimestamp() {

		return completeTimestamp;

	}

	public void setCompleteTimestamp(LocalDateTime completeTimestamp) {

		this.completeTimestamp = completeTimestamp;

	}

	@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;

		PriceDrop other = (PriceDrop) obj;

		if (id != other.id)

			return false;

		return true;

	}

}