Subversion Repositories SmartDukaan

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

import com.spice.profitmandi.dao.enumuration.dtr.MetaLeadOutcome;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.EnumType;
import javax.persistence.Enumerated;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.Table;
import javax.persistence.UniqueConstraint;
import java.time.LocalDateTime;

/**
 * One row of a Meta lead-ads export, and what the import did with it.
 *
 * <p>Serves three jobs at once:
 *
 * <ul>
 *   <li><b>Idempotency.</b> {@code meta_lead_id} is Meta's own id — unique and stable — so
 *       re-uploading the same file, or an overlapping export, creates nothing twice. The existing
 *       lead CSV import ({@code /csvFileAndSetLead}) has no dedupe at all and silently doubles every
 *       lead on a second upload; this is the fix for that class of mistake.</li>
 *   <li><b>Accounting.</b> Every row gets a row here whatever happened to it, so a 60-row file
 *       always adds up to 60 and "where did that lead go?" has an answer.</li>
 *   <li><b>Attribution.</b> Campaign, form and placement are kept so lead quality can later be
 *       compared across campaigns — the reason for running the ads in the first place.</li>
 * </ul>
 *
 * <p>{@code raw_row} holds the original row verbatim as JSON. Mapping is lossy by nature (a business
 * -value band becomes a number, a name gets split), and the source file will not be around in six
 * months; keeping the original means a mapping bug can be replayed rather than merely regretted.
 */
@Entity
@Table(name = "user.meta_lead",
        uniqueConstraints = {@UniqueConstraint(columnNames = "meta_lead_id")})
public class MetaLead {

    @Id
    @Column(name = "id", unique = true, updatable = false)
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;

    /** Meta's own lead id. The idempotency key — unique, and stable across exports. */
    @Column(name = "meta_lead_id")
    private String metaLeadId;

    @Column(name = "import_batch_id")
    private Integer importBatchId;

    /** The lead this became. Null for every outcome except CREATED. */
    @Column(name = "lead_id")
    private Integer leadId;

    @Column(name = "outcome")
    @Enumerated(EnumType.STRING)
    private MetaLeadOutcome outcome;

    /** Why it was skipped or rejected. Null on CREATED. */
    @Column(name = "reason")
    private String reason;

    @Column(name = "campaign_name")
    private String campaignName;

    @Column(name = "form_name")
    private String formName;

    /** {@code fb} or {@code ig} — which placement produced the lead. */
    @Column(name = "platform")
    private String platform;

    /** When Meta captured the lead, as opposed to when we imported it. */
    @Column(name = "meta_created_time")
    private LocalDateTime metaCreatedTime;

    /** The original row as JSON, so a mapping bug can be replayed rather than guessed at. */
    @Lob
    @Column(name = "raw_row")
    private String rawRow;

    @Column(name = "created_timestamp")
    private LocalDateTime createdTimestamp;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getMetaLeadId() {
        return metaLeadId;
    }

    public void setMetaLeadId(String metaLeadId) {
        this.metaLeadId = metaLeadId;
    }

    public Integer getImportBatchId() {
        return importBatchId;
    }

    public void setImportBatchId(Integer importBatchId) {
        this.importBatchId = importBatchId;
    }

    public Integer getLeadId() {
        return leadId;
    }

    public void setLeadId(Integer leadId) {
        this.leadId = leadId;
    }

    public MetaLeadOutcome getOutcome() {
        return outcome;
    }

    public void setOutcome(MetaLeadOutcome outcome) {
        this.outcome = outcome;
    }

    public String getReason() {
        return reason;
    }

    public void setReason(String reason) {
        this.reason = reason;
    }

    public String getCampaignName() {
        return campaignName;
    }

    public void setCampaignName(String campaignName) {
        this.campaignName = campaignName;
    }

    public String getFormName() {
        return formName;
    }

    public void setFormName(String formName) {
        this.formName = formName;
    }

    public String getPlatform() {
        return platform;
    }

    public void setPlatform(String platform) {
        this.platform = platform;
    }

    public LocalDateTime getMetaCreatedTime() {
        return metaCreatedTime;
    }

    public void setMetaCreatedTime(LocalDateTime metaCreatedTime) {
        this.metaCreatedTime = metaCreatedTime;
    }

    public String getRawRow() {
        return rawRow;
    }

    public void setRawRow(String rawRow) {
        this.rawRow = rawRow;
    }

    public LocalDateTime getCreatedTimestamp() {
        return createdTimestamp;
    }

    public void setCreatedTimestamp(LocalDateTime createdTimestamp) {
        this.createdTimestamp = createdTimestamp;
    }

    @Override
    public String toString() {
        return "MetaLead [metaLeadId=" + metaLeadId + ", outcome=" + outcome + ", leadId=" + leadId + "]";
    }
}