Subversion Repositories SmartDukaan

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

import javax.persistence.*;

import java.time.LocalDate;

import java.time.LocalDateTime;

import java.util.Objects;

/**

 * Entity to store daily agent performance insights from Knowlarity.

 * Data is updated on each scheduled scrape (every 2 hours) for the same date.

 * Historical data is preserved for past dates.

 */

@Entity

@Table(name = "cs.agent_daily_insight",

        uniqueConstraints = @UniqueConstraint(columnNames = {"agent_email", "insight_date"}))

public class AgentDailyInsight {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private Long id;

    @Column(name = "agent_name")

    private String agentName;

    @Column(name = "agent_email")

    private String agentEmail;

    @Column(name = "agent_number")

    private String agentNumber;

    @Column(name = "agent_sip_id")

    private String agentSipId;

    @Column(name = "auth_id")

    private Integer authId;

    @Column(name = "total_logged_in_time")

    private String totalLoggedInTime;

    @Column(name = "logged_in_seconds")

    private Integer loggedInSeconds;

    @Column(name = "total_break_duration")

    private String totalBreakDuration;

    @Column(name = "break_seconds")

    private Integer breakSeconds;

    @Column(name = "available_time")

    private String availableTime;

    @Column(name = "available_seconds")

    private Integer availableSeconds;

    @Column(name = "total_talk_time")

    private String totalTalkTime;

    @Column(name = "talk_seconds")

    private Integer talkSeconds;

    @Column(name = "calls_answered")

    private Integer callsAnswered;

    @Column(name = "missed_calls")

    private Integer missedCalls;

    @Column(name = "total_calls")

    private Integer totalCalls;

    @Column(name = "insight_date")

    private LocalDate insightDate;

    @Column(name = "last_updated")

    private LocalDateTime lastUpdated;

    @Column(name = "create_timestamp")

    private LocalDateTime createTimestamp;

    public AgentDailyInsight() {

    }

    public AgentDailyInsight(String agentName, String agentEmail, LocalDate insightDate) {

        this.agentName = agentName;

        this.agentEmail = agentEmail;

        this.insightDate = insightDate;

        this.createTimestamp = LocalDateTime.now();

        this.lastUpdated = LocalDateTime.now();

    }

    // Getters and Setters

    public Long getId() {

        return id;

    }

    public void setId(Long id) {

        this.id = id;

    }

    public String getAgentName() {

        return agentName;

    }

    public void setAgentName(String agentName) {

        this.agentName = agentName;

    }

    public String getAgentEmail() {

        return agentEmail;

    }

    public void setAgentEmail(String agentEmail) {

        this.agentEmail = agentEmail;

    }

    public String getAgentNumber() {

        return agentNumber;

    }

    public void setAgentNumber(String agentNumber) {

        this.agentNumber = agentNumber;

    }

    public String getAgentSipId() {

        return agentSipId;

    }

    public void setAgentSipId(String agentSipId) {

        this.agentSipId = agentSipId;

    }

    public Integer getAuthId() {

        return authId;

    }

    public void setAuthId(Integer authId) {

        this.authId = authId;

    }

    public String getTotalLoggedInTime() {

        return totalLoggedInTime;

    }

    public void setTotalLoggedInTime(String totalLoggedInTime) {

        this.totalLoggedInTime = totalLoggedInTime;

    }

    public Integer getLoggedInSeconds() {

        return loggedInSeconds;

    }

    public void setLoggedInSeconds(Integer loggedInSeconds) {

        this.loggedInSeconds = loggedInSeconds;

    }

    public String getTotalBreakDuration() {

        return totalBreakDuration;

    }

    public void setTotalBreakDuration(String totalBreakDuration) {

        this.totalBreakDuration = totalBreakDuration;

    }

    public Integer getBreakSeconds() {

        return breakSeconds;

    }

    public void setBreakSeconds(Integer breakSeconds) {

        this.breakSeconds = breakSeconds;

    }

    public String getAvailableTime() {

        return availableTime;

    }

    public void setAvailableTime(String availableTime) {

        this.availableTime = availableTime;

    }

    public Integer getAvailableSeconds() {

        return availableSeconds;

    }

    public void setAvailableSeconds(Integer availableSeconds) {

        this.availableSeconds = availableSeconds;

    }

    public String getTotalTalkTime() {

        return totalTalkTime;

    }

    public void setTotalTalkTime(String totalTalkTime) {

        this.totalTalkTime = totalTalkTime;

    }

    public Integer getTalkSeconds() {

        return talkSeconds;

    }

    public void setTalkSeconds(Integer talkSeconds) {

        this.talkSeconds = talkSeconds;

    }

    public Integer getCallsAnswered() {

        return callsAnswered;

    }

    public void setCallsAnswered(Integer callsAnswered) {

        this.callsAnswered = callsAnswered;

    }

    public Integer getMissedCalls() {

        return missedCalls;

    }

    public void setMissedCalls(Integer missedCalls) {

        this.missedCalls = missedCalls;

    }

    public Integer getTotalCalls() {

        return totalCalls;

    }

    public void setTotalCalls(Integer totalCalls) {

        this.totalCalls = totalCalls;

    }

    public LocalDate getInsightDate() {

        return insightDate;

    }

    public void setInsightDate(LocalDate insightDate) {

        this.insightDate = insightDate;

    }

    public LocalDateTime getLastUpdated() {

        return lastUpdated;

    }

    public void setLastUpdated(LocalDateTime lastUpdated) {

        this.lastUpdated = lastUpdated;

    }

    public LocalDateTime getCreateTimestamp() {

        return createTimestamp;

    }

    public void setCreateTimestamp(LocalDateTime createTimestamp) {

        this.createTimestamp = createTimestamp;

    }

    @Override

    public boolean equals(Object o) {

        if (this == o) return true;

        if (o == null || getClass() != o.getClass()) return false;

        AgentDailyInsight that = (AgentDailyInsight) o;

        return Objects.equals(agentEmail, that.agentEmail) &&

                Objects.equals(insightDate, that.insightDate);

    }

    @Override

    public int hashCode() {

        return Objects.hash(agentEmail, insightDate);

    }

    @Override

    public String toString() {

        return "AgentDailyInsight{" +

                "id=" + id +

                ", agentName='" + agentName + '\'' +

                ", agentEmail='" + agentEmail + '\'' +

                ", insightDate=" + insightDate +

                ", totalLoggedInTime='" + totalLoggedInTime + '\'' +

                ", totalBreakDuration='" + totalBreakDuration + '\'' +

                ", availableTime='" + availableTime + '\'' +

                ", totalTalkTime='" + totalTalkTime + '\'' +

                ", lastUpdated=" + lastUpdated +

                '}';

    }

}