Subversion Repositories SmartDukaan

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

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

import com.spice.profitmandi.dao.enumuration.pinelabs.PinelabsPaymentStatus;

import javax.persistence.*;

import java.io.Serializable;

import java.math.BigDecimal;

import java.time.LocalDateTime;

import java.util.Objects;

/**

 * Entity representing Pinelabs order lifecycle.

 * Replaces the old payment.pine_labs table with enhanced tracking capabilities.

 *

 * @author Pinelabs Integration Team

 * @since 1.0

 */

@Entity

@Table(name = "fofo.pinelabs_orders", schema = "fofo")

public class PinelabsOrder implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id

    @Column(name = "id")

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    private long id;

    /**

     * Reference to internal pending order (fofo.pending_order.id)

     */

    @Column(name = "pending_order_id", nullable = false)

    private Integer pendingOrderId;

    /**

     * Order ID generated by Pinelabs API

     */

    @Column(name = "pinelabs_order_id", nullable = false, unique = true, length = 100)

    private String pinelabsOrderId;

    /**

     * Merchant reference for the order (optional, for reconciliation)

     */

    @Column(name = "pinelabs_merchant_order_ref", length = 100)

    private String pinelabsMerchantOrderRef;

    /**

     * Reference to Pinelabs customer (null for guest checkout)

     */

    @ManyToOne(fetch = FetchType.LAZY, cascade = CascadeType.ALL)

    @JoinColumn(name = "pinelabs_customer_id")

    private PinelabsCustomer pinelabsCustomer;

    /**

     * Payment method used for this order (null if not using saved card)

     */

    @ManyToOne(fetch = FetchType.LAZY)

    @JoinColumn(name = "payment_method_id")

    private PinelabsPaymentMethod paymentMethod;

    /**

     * Order amount in INR

     */

    @Column(name = "order_amount", nullable = false, precision = 12, scale = 2)

    private BigDecimal orderAmount;

    /**

     * Currency code (default: INR)

     */

    @Column(name = "currency", nullable = false, length = 3)

    private String currency = "INR";

    /**

     * Payment status

     */

    @Column(name = "payment_status", nullable = false, length = 50)

    @Enumerated(EnumType.STRING)

    private PinelabsPaymentStatus paymentStatus = PinelabsPaymentStatus.PENDING;

    /**

     * Payment method type (CARD, UPI, WALLET, NETBANKING, BNPL)

     */

    @Column(name = "payment_method_type", length = 50)

    private String paymentMethodType;

    /**

     * Transaction ID from Pinelabs

     */

    @Column(name = "transaction_id", length = 100)

    private String transactionId;

    /**

     * Pinelabs checkout URL (for redirect)

     */

    @Column(name = "payment_url", columnDefinition = "TEXT")

    private String paymentUrl;

    /**

     * Amount actually captured (for partial captures)

     */

    @Column(name = "captured_amount", precision = 12, scale = 2)

    private BigDecimal capturedAmount = BigDecimal.ZERO;

    /**

     * Amount refunded

     */

    @Column(name = "refunded_amount", precision = 12, scale = 2)

    private BigDecimal refundedAmount = BigDecimal.ZERO;

    /**

     * Applied offer/EMI code

     */

    @Column(name = "offer_code", length = 100)

    private String offerCode;

    /**

     * EMI tenure in months (if EMI selected)

     */

    @Column(name = "emi_tenure")

    private Integer emiTenure;

    /**

     * When the order expires (for payment link expiry)

     */

    @Convert(converter = LocalDateTimeAttributeConverter.class)

    @Column(name = "order_expiry_timestamp")

    private LocalDateTime orderExpiryTimestamp;

    /**

     * When payment callback was received from Pinelabs

     */

    @Convert(converter = LocalDateTimeAttributeConverter.class)

    @Column(name = "callback_received_timestamp")

    private LocalDateTime callbackReceivedTimestamp;

    /**

     * Raw JSON response from Pinelabs (for debugging/audit)

     */

    @Column(name = "response_data", columnDefinition = "TEXT")

    private String responseData;

    /**

     * Order creation timestamp

     */

    @Convert(converter = LocalDateTimeAttributeConverter.class)

    @Column(name = "create_timestamp", nullable = false, updatable = false)

    private LocalDateTime createTimestamp = LocalDateTime.now();

    /**

     * Last update timestamp

     */

    @Convert(converter = LocalDateTimeAttributeConverter.class)

    @Column(name = "update_timestamp", nullable = false)

    private LocalDateTime updateTimestamp = LocalDateTime.now();

    /**

     * Default constructor

     */

    public PinelabsOrder() {

    }

    /**

     * Constructor with essential fields

     *

     * @param pendingOrderId   Internal order ID

     * @param pinelabsOrderId  Pinelabs order ID

     * @param orderAmount      Order amount

     */

    public PinelabsOrder(Integer pendingOrderId, String pinelabsOrderId, BigDecimal orderAmount) {

        this.pendingOrderId = pendingOrderId;

        this.pinelabsOrderId = pinelabsOrderId;

        this.orderAmount = orderAmount;

    }

    // ==================== Getters and Setters ====================

    public long getId() {

        return id;

    }

    public void setId(long id) {

        this.id = id;

    }

    public Integer getPendingOrderId() {

        return pendingOrderId;

    }

    public void setPendingOrderId(Integer pendingOrderId) {

        this.pendingOrderId = pendingOrderId;

    }

    public String getPinelabsOrderId() {

        return pinelabsOrderId;

    }

    public void setPinelabsOrderId(String pinelabsOrderId) {

        this.pinelabsOrderId = pinelabsOrderId;

    }

    public String getPinelabsMerchantOrderRef() {

        return pinelabsMerchantOrderRef;

    }

    public void setPinelabsMerchantOrderRef(String pinelabsMerchantOrderRef) {

        this.pinelabsMerchantOrderRef = pinelabsMerchantOrderRef;

    }

    public PinelabsCustomer getPinelabsCustomer() {

        return pinelabsCustomer;

    }

    public void setPinelabsCustomer(PinelabsCustomer pinelabsCustomer) {

        this.pinelabsCustomer = pinelabsCustomer;

    }

    public PinelabsPaymentMethod getPaymentMethod() {

        return paymentMethod;

    }

    public void setPaymentMethod(PinelabsPaymentMethod paymentMethod) {

        this.paymentMethod = paymentMethod;

    }

    public BigDecimal getOrderAmount() {

        return orderAmount;

    }

    public void setOrderAmount(BigDecimal orderAmount) {

        this.orderAmount = orderAmount;

    }

    public String getCurrency() {

        return currency;

    }

    public void setCurrency(String currency) {

        this.currency = currency;

    }

    public PinelabsPaymentStatus getPaymentStatus() {

        return paymentStatus;

    }

    public void setPaymentStatus(PinelabsPaymentStatus paymentStatus) {

        this.paymentStatus = paymentStatus;

    }

    public String getPaymentMethodType() {

        return paymentMethodType;

    }

    public void setPaymentMethodType(String paymentMethodType) {

        this.paymentMethodType = paymentMethodType;

    }

    public String getTransactionId() {

        return transactionId;

    }

    public void setTransactionId(String transactionId) {

        this.transactionId = transactionId;

    }

    public String getPaymentUrl() {

        return paymentUrl;

    }

    public void setPaymentUrl(String paymentUrl) {

        this.paymentUrl = paymentUrl;

    }

    public BigDecimal getCapturedAmount() {

        return capturedAmount;

    }

    public void setCapturedAmount(BigDecimal capturedAmount) {

        this.capturedAmount = capturedAmount;

    }

    public BigDecimal getRefundedAmount() {

        return refundedAmount;

    }

    public void setRefundedAmount(BigDecimal refundedAmount) {

        this.refundedAmount = refundedAmount;

    }

    public String getOfferCode() {

        return offerCode;

    }

    public void setOfferCode(String offerCode) {

        this.offerCode = offerCode;

    }

    public Integer getEmiTenure() {

        return emiTenure;

    }

    public void setEmiTenure(Integer emiTenure) {

        this.emiTenure = emiTenure;

    }

    public LocalDateTime getOrderExpiryTimestamp() {

        return orderExpiryTimestamp;

    }

    public void setOrderExpiryTimestamp(LocalDateTime orderExpiryTimestamp) {

        this.orderExpiryTimestamp = orderExpiryTimestamp;

    }

    public LocalDateTime getCallbackReceivedTimestamp() {

        return callbackReceivedTimestamp;

    }

    public void setCallbackReceivedTimestamp(LocalDateTime callbackReceivedTimestamp) {

        this.callbackReceivedTimestamp = callbackReceivedTimestamp;

    }

    public String getResponseData() {

        return responseData;

    }

    public void setResponseData(String responseData) {

        this.responseData = responseData;

    }

    public LocalDateTime getCreateTimestamp() {

        return createTimestamp;

    }

    public void setCreateTimestamp(LocalDateTime createTimestamp) {

        this.createTimestamp = createTimestamp;

    }

    public LocalDateTime getUpdateTimestamp() {

        return updateTimestamp;

    }

    public void setUpdateTimestamp(LocalDateTime updateTimestamp) {

        this.updateTimestamp = updateTimestamp;

    }

    // ==================== Helper Methods ====================

    /**

     * Check if order has expired

     *

     * @return true if order has expired

     */

    public boolean isExpired() {

        if (orderExpiryTimestamp == null) {

            return false;

        }

        return LocalDateTime.now().isAfter(orderExpiryTimestamp);

    }

    /**

     * Check if payment is successful

     *

     * @return true if payment status is CAPTURED

     */

    public boolean isPaymentSuccessful() {

        return paymentStatus == PinelabsPaymentStatus.CAPTURED;

    }

    /**

     * Check if refund is possible

     *

     * @return true if order can be refunded

     */

    public boolean canBeRefunded() {

        if (paymentStatus != PinelabsPaymentStatus.CAPTURED) {

            return false;

        }

        if (refundedAmount == null) {

            return true;

        }

        // Can refund if not fully refunded

        return refundedAmount.compareTo(capturedAmount != null ? capturedAmount : orderAmount) < 0;

    }

    /**

     * Get remaining refundable amount

     *

     * @return Amount that can still be refunded

     */

    public BigDecimal getRefundableAmount() {

        BigDecimal totalPaid = capturedAmount != null ? capturedAmount : orderAmount;

        BigDecimal alreadyRefunded = refundedAmount != null ? refundedAmount : BigDecimal.ZERO;

        return totalPaid.subtract(alreadyRefunded);

    }

    // ==================== Object Methods ====================

    @Override

    public boolean equals(Object o) {

        if (!(o instanceof PinelabsOrder)) return false;

        PinelabsOrder that = (PinelabsOrder) o;

        return id == that.id && Objects.equals(pendingOrderId, that.pendingOrderId) && Objects.equals(pinelabsOrderId, that.pinelabsOrderId) && Objects.equals(pinelabsMerchantOrderRef, that.pinelabsMerchantOrderRef) && Objects.equals(pinelabsCustomer, that.pinelabsCustomer) && Objects.equals(paymentMethod, that.paymentMethod) && Objects.equals(orderAmount, that.orderAmount) && Objects.equals(currency, that.currency) && paymentStatus == that.paymentStatus && Objects.equals(paymentMethodType, that.paymentMethodType) && Objects.equals(transactionId, that.transactionId) && Objects.equals(paymentUrl, that.paymentUrl) && Objects.equals(capturedAmount, that.capturedAmount) && Objects.equals(refundedAmount, that.refundedAmount) && Objects.equals(offerCode, that.offerCode) && Objects.equals(emiTenure, that.emiTenure) && Objects.equals(orderExpiryTimestamp, that.orderExpiryTimestamp) && Objects.equals(callbackReceivedTimestamp, that.callbackReceivedTimestamp) && Objects.equals(responseData, that.responseData) && Objects.equals(createTimestamp, that.createTimestamp) && Objects.equals(updateTimestamp, that.updateTimestamp);

    }

    @Override

    public int hashCode() {

        return Objects.hash(id, pendingOrderId, pinelabsOrderId, pinelabsMerchantOrderRef, pinelabsCustomer, paymentMethod, orderAmount, currency, paymentStatus, paymentMethodType, transactionId, paymentUrl, capturedAmount, refundedAmount, offerCode, emiTenure, orderExpiryTimestamp, callbackReceivedTimestamp, responseData, createTimestamp, updateTimestamp);

    }

    @Override

    public String toString() {

        return "PinelabsOrder [id=" + id + ", pendingOrderId=" + pendingOrderId + ", pinelabsOrderId="

                + pinelabsOrderId + ", orderAmount=" + orderAmount + ", currency=" + currency + ", paymentStatus="

                + paymentStatus + ", paymentMethodType=" + paymentMethodType + ", transactionId=" + transactionId

                + ", capturedAmount=" + capturedAmount + ", refundedAmount=" + refundedAmount + ", createTimestamp="

                + createTimestamp + "]";

    }

}