Subversion Repositories SmartDukaan

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

import com.spice.profitmandi.dao.enumuration.dtr.LeadCallProvider;
import com.spice.profitmandi.dao.enumuration.dtr.LeadCallStatus;

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.Table;
import javax.persistence.UniqueConstraint;
import java.time.LocalDateTime;

/**
 * One dial attempt against an LMS lead (SOP §12) — the call history {@code Lead} cannot hold.
 *
 * <p>{@code Lead} keeps a single last-write-wins {@code disposition} and {@code recording_url} and has
 * no call id, duration or direction at all; {@code lead_activity} is an append-only human trail whose
 * {@code remark} is rendered prose. Neither can answer "how many calls, how long, which recording".
 * This table can, and {@code lead_activity.lead_call_id} points back at it — the same shape
 * {@code auth.partner_collection_remark.agent_call_log_id} already uses for collection remarks.
 *
 * <p>Rows are created by the answer webhook (not by the browser), keyed on the provider's
 * {@code conversation_uuid}, and then advanced by the event and recording webhooks. Deliberately
 * separate from {@code cs.agent_call_log}: that table is Knowlarity-shaped, keyed off
 * {@code sip_master.caller_id}, and shared with the ticket/upsell flows this feature must not disturb.
 */
@Entity
@Table(name = "user.lead_call",
        uniqueConstraints = {@UniqueConstraint(columnNames = "provider_call_uuid")})
public class LeadCall {

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

    @Column(name = "lead_id")
    private int leadId;

    /** The agent who placed the call — {@code auth.auth_user.id}. */
    @Column(name = "auth_id")
    private int authId;

    @Column(name = "provider")
    @Enumerated(EnumType.STRING)
    private LeadCallProvider provider;

    /**
     * The provider's own id for the agent leg. Null until the provider tells us — the row is created
     * on the answer webhook, which is the first moment we have a durable handle.
     */
    @Column(name = "provider_call_uuid")
    private String providerCallUuid;

    /** Groups both legs of the bridged call; this is the correlation key across webhooks. */
    @Column(name = "conversation_uuid")
    private String conversationUuid;

    /** OUTBOUND for everything today; INBOUND reserved for a future retailer-callback flow. */
    @Column(name = "direction")
    private String direction;

    /** Outbound CLI actually presented to the retailer. */
    @Column(name = "from_number")
    private String fromNumber;

    @Column(name = "to_number")
    private String toNumber;

    @Column(name = "started_at")
    private LocalDateTime startedAt;

    /** When the retailer picked up. Null on an unanswered call — this is what proves contact. */
    @Column(name = "answered_at")
    private LocalDateTime answeredAt;

    @Column(name = "ended_at")
    private LocalDateTime endedAt;

    /** Billed/talk seconds as reported by the provider, not {@code ended - started}. */
    @Column(name = "duration_seconds")
    private Integer durationSeconds;

    @Column(name = "status")
    @Enumerated(EnumType.STRING)
    private LeadCallStatus status;

    /** Provider's recording handle, kept as provenance even after we archive our own copy. */
    @Column(name = "recording_uuid")
    private String recordingUuid;

    /**
     * Key of our own archived copy in the object store. Null until the archival sweep has stored it.
     *
     * <p>Deliberately not {@code dtr.document}: that table's {@code path} is VARCHAR(30) and a
     * recording key is ~58 characters, so routing recordings through it made every upload fail on a
     * STRICT-mode truncation error.
     */
    @Column(name = "recording_object_key")
    private String recordingObjectKey;

    /**
     * Failed fetch attempts. A call whose audio has expired at the provider can never succeed, and
     * without a ceiling it would occupy a slot in every batch forever and starve newer recordings.
     */
    @Column(name = "recording_archive_attempts")
    private int recordingArchiveAttempts;

    @Column(name = "recording_duration")
    private Integer recordingDuration;

    /**
     * Our archived copy — {@code dtr.document.id}. Null until the archival worker has fetched it;
     * a null here with a non-null {@code recording_uuid} means "recording exists, not yet pulled".
     */
    @Column(name = "recording_document_id")
    private Integer recordingDocumentId;

    /** The trail entry this call produced, once the agent dispositions it. */
    @Column(name = "lead_activity_id")
    private Integer leadActivityId;

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

    public int getId() {
        return id;
    }

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

    public int getLeadId() {
        return leadId;
    }

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

    public int getAuthId() {
        return authId;
    }

    public void setAuthId(int authId) {
        this.authId = authId;
    }

    public LeadCallProvider getProvider() {
        return provider;
    }

    public void setProvider(LeadCallProvider provider) {
        this.provider = provider;
    }

    public String getProviderCallUuid() {
        return providerCallUuid;
    }

    public void setProviderCallUuid(String providerCallUuid) {
        this.providerCallUuid = providerCallUuid;
    }

    public String getConversationUuid() {
        return conversationUuid;
    }

    public void setConversationUuid(String conversationUuid) {
        this.conversationUuid = conversationUuid;
    }

    public String getDirection() {
        return direction;
    }

    public void setDirection(String direction) {
        this.direction = direction;
    }

    public String getFromNumber() {
        return fromNumber;
    }

    public void setFromNumber(String fromNumber) {
        this.fromNumber = fromNumber;
    }

    public String getToNumber() {
        return toNumber;
    }

    public void setToNumber(String toNumber) {
        this.toNumber = toNumber;
    }

    public LocalDateTime getStartedAt() {
        return startedAt;
    }

    public void setStartedAt(LocalDateTime startedAt) {
        this.startedAt = startedAt;
    }

    public LocalDateTime getAnsweredAt() {
        return answeredAt;
    }

    public void setAnsweredAt(LocalDateTime answeredAt) {
        this.answeredAt = answeredAt;
    }

    public LocalDateTime getEndedAt() {
        return endedAt;
    }

    public void setEndedAt(LocalDateTime endedAt) {
        this.endedAt = endedAt;
    }

    public Integer getDurationSeconds() {
        return durationSeconds;
    }

    public void setDurationSeconds(Integer durationSeconds) {
        this.durationSeconds = durationSeconds;
    }

    public LeadCallStatus getStatus() {
        return status;
    }

    public void setStatus(LeadCallStatus status) {
        this.status = status;
    }

    public String getRecordingUuid() {
        return recordingUuid;
    }

    public void setRecordingUuid(String recordingUuid) {
        this.recordingUuid = recordingUuid;
    }

    public Integer getRecordingDuration() {
        return recordingDuration;
    }

    public void setRecordingDuration(Integer recordingDuration) {
        this.recordingDuration = recordingDuration;
    }

    public String getRecordingObjectKey() {
        return recordingObjectKey;
    }

    public void setRecordingObjectKey(String recordingObjectKey) {
        this.recordingObjectKey = recordingObjectKey;
    }

    public int getRecordingArchiveAttempts() {
        return recordingArchiveAttempts;
    }

    public void setRecordingArchiveAttempts(int recordingArchiveAttempts) {
        this.recordingArchiveAttempts = recordingArchiveAttempts;
    }

    public Integer getRecordingDocumentId() {
        return recordingDocumentId;
    }

    public void setRecordingDocumentId(Integer recordingDocumentId) {
        this.recordingDocumentId = recordingDocumentId;
    }

    public Integer getLeadActivityId() {
        return leadActivityId;
    }

    public void setLeadActivityId(Integer leadActivityId) {
        this.leadActivityId = leadActivityId;
    }

    public LocalDateTime getCreatedTimestamp() {
        return createdTimestamp;
    }

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

    @Override
    public String toString() {
        return "LeadCall [id=" + id + ", leadId=" + leadId + ", authId=" + authId + ", provider=" + provider
                + ", conversationUuid=" + conversationUuid + ", status=" + status
                + ", durationSeconds=" + durationSeconds + "]";
    }
}