Subversion Repositories SmartDukaan

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

import com.spice.profitmandi.dao.enumuration.transaction.UpSaleCallStatus;
import com.spice.profitmandi.dao.model.UpsellingReportModel;

import javax.persistence.*;
import java.io.Serializable;
import java.time.LocalDateTime;
import java.util.Objects;

/**
 * @author ranu
 */
@Entity
@Table(name = "fofo.upSaleCall")
@NamedQueries({
        @NamedQuery(name = "upSaleCall.checkNumberIsExist", query = "SELECT COUNT(u) FROM UpSaleCall u WHERE u.mobile = :mobile AND u.originalOrderId = :orderId"),
        @NamedQuery(name = "upSaleCall.checkOrderIsExist", query = "SELECT COUNT(u) FROM UpSaleCall u WHERE u.originalOrderId = :orderId"),
})


@NamedNativeQueries({
        @NamedNativeQuery(name = "Upsell.UpsellingReport",
                query = "SELECT uc.agentId, ucd.agent_id as agentEmail,u.name as partnerName,ua.phone as partnerMobile, ua.state, uc.originalOrderId as orderId, uc.mobile as customerNumber, " +
                        "ucd.created_timestamp as callingDate, coalesce(ucd.disposition,'-') as disposition,coalesce(ucd.remark,'-') as remark," +
                        " coalesce(rp.payment_status, 'Not Found') as paymentStatus, " +
                        "(CASE WHEN ac.create_timestamp IS NOT NULL THEN 'Created' ELSE 'Not Created' END) AS insuranceStatus, " +
                        "coalesce(ip.sale_amount,0) as soldAmount, coalesce(ip.invoice_number,'Not Found') as invoiceNumber, coalesce(ip.serial_number,'Not Found') as serialNumber" +
                        " FROM fofo.upSaleCall uc" +
                        " JOIN fofo.upsell_call_details ucd on uc.id = ucd.upsale_call_id" +
                        " JOIN fofo.fofo_order fo on fo.id = uc.originalOrderId" +
                        " JOIN user.user u on u.id = fo.fofo_id" +
                        " JOIN user.address ua on ua.id = u.default_address_id" +
                        " LEFT JOIN fofo.upsellRazorpayPaymentStatus rp on rp.order_id = uc.originalOrderId" +
                        " LEFT JOIN fofo.upsaleAgentCollection ac on ac.order_id = uc.originalOrderId" +
                        " LEFT JOIN dtr.insurance_policy ip on ip.device_invoice_number = fo.invoice_number" +
                        " WHERE uc.create_timestamp >= :startDate and uc.create_timestamp < :endDate",
                resultSetMapping = "UpsellingReport"),

})

@SqlResultSetMappings({

        @SqlResultSetMapping(name = "UpsellingReport",
                classes = {@ConstructorResult(targetClass = UpsellingReportModel.class,
                        columns = {
                                @ColumnResult(name = "agentId", type = Integer.class),
                                @ColumnResult(name = "agentEmail", type = String.class),
                                @ColumnResult(name = "partnerName", type = String.class),
                                @ColumnResult(name = "partnerMobile", type = String.class),
                                @ColumnResult(name = "state", type = String.class),
                                @ColumnResult(name = "orderId", type = Integer.class),
                                @ColumnResult(name = "customerNumber ", type = String.class),
                                @ColumnResult(name = "callingDate ", type = String.class),
                                @ColumnResult(name = "disposition ", type = String.class),
                                @ColumnResult(name = "remark ", type = String.class),
                                @ColumnResult(name = "paymentStatus ", type = String.class),
                                @ColumnResult(name = "insuranceStatus ", type = String.class),
                                @ColumnResult(name = "soldAmount ", type = Float.class),
                                @ColumnResult(name = "invoiceNumber ", type = String.class),
                                @ColumnResult(name = "serialNumber ", type = String.class),
                        }
                )}
        )

})
public class UpSaleCall implements Serializable {


    private static final long serialVersionUID = 1L;
    @Id
    @Column(name = "id")
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;

    @Column(name = "agentId")
    private int agentId;

    @Column(name = "originalOrderId")
    private int originalOrderId;

    @Column(name = "mobile")
    private String mobile;

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

    @Column(name = "create_timestamp")
    private LocalDateTime createdTimestamp = LocalDateTime.now();

    @Column(name = "rescheduled_timestamp")
    private LocalDateTime rescheduledTimestamp;

    public int getId() {
        return id;
    }

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

    public int getAgentId() {
        return agentId;
    }

    public void setAgentId(int agentId) {
        this.agentId = agentId;
    }

    public String getMobile() {
        return mobile;
    }

    public void setMobile(String mobile) {
        this.mobile = mobile;
    }

    public UpSaleCallStatus getStatus() {
        return status;
    }

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

    public LocalDateTime getCreatedTimestamp() {
        return createdTimestamp;
    }

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

    public int getOriginalOrderId() {
        return originalOrderId;
    }

    public void setOriginalOrderId(int originalOrderId) {
        this.originalOrderId = originalOrderId;
    }

    public LocalDateTime getRescheduledTimestamp() {
        return rescheduledTimestamp;
    }

    public void setRescheduledTimestamp(LocalDateTime rescheduledTimestamp) {
        this.rescheduledTimestamp = rescheduledTimestamp;
    }

    @Override
    public String toString() {
        return "UpSaleCall{" +
                "id=" + id +
                ", agentId=" + agentId +
                ", originalOrderId=" + originalOrderId +
                ", mobile='" + mobile + '\'' +
                ", status=" + status +
                ", createdTimestamp=" + createdTimestamp +
                ", rescheduledTimestamp=" + rescheduledTimestamp +
                '}';
    }


    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;
        UpSaleCall that = (UpSaleCall) o;
        return id == that.id && agentId == that.agentId && originalOrderId == that.originalOrderId && Objects.equals(mobile, that.mobile) && status == that.status && Objects.equals(createdTimestamp, that.createdTimestamp) && Objects.equals(rescheduledTimestamp, that.rescheduledTimestamp);
    }

    @Override
    public int hashCode() {
        return Objects.hash(id, agentId, originalOrderId, mobile, status, createdTimestamp, rescheduledTimestamp);
    }
}