/*
 * File: src/main/java/reports/model/sales/Sales.java
 * Description: This model represents the Sales entity, capturing details
 * related to sales transactions in the application. It includes relationships
 * with SalesItem and Payments entities, and tracks essential information
 * such as patient details, encounter ID, total amount, and payment status.
 */

package com.nebula.erp.reports.model.sales;

import com.fasterxml.jackson.annotation.JsonManagedReference;
import jakarta.persistence.*;
import lombok.Data;
import lombok.Getter;
import lombok.Setter;

import java.time.LocalDateTime;
import java.util.List;

@Data
@Entity
@Table(name = "sales")
@Setter
@Getter
public class Sales {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(nullable = false)
    private LocalDateTime date;

    private String prescription_id;

    @Column(nullable = false)
    private String encounter_id;

    private String custom_encounter_id;

    @Column(nullable = false)
    private String patient_id;

    private String patient_name;

    private String customer_name;

    private String customer_mobile;

    private String customer_email;

    private String customer_dob;

    private String customer_address;

    @Column(nullable = false)
    private Double total_amount;

    private Double discount;

    private String coupon_code;

    private Double coupon_amount;

    @Column(name = "total_debit_amount")
    private Double total_debit_amount = 0.0;

    @Column(name = "total_paid_for_sale")
    private Double total_paid_for_sale = 0.0;

    @Column(name = "previous_due_paid")
    private Double previous_due_paid = 0.0;

    @Column(name = "remaining_due_amount")
    private Double remaining_due_amount = 0.0;

    @Column(name = "refund_amount")
    private Double refund_amount = 0.0;

    @Column(nullable = false)
    private String payment_status; // Could be enum in the future, e.g., PAID, PENDING, etc.

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

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

    @Column(nullable = false)
    private String created_by;

    @Column(nullable = false)
    private String tenant;

    @OneToMany(mappedBy = "sales", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    @JsonManagedReference
    private List<SalesItem> sales_items;

    @OneToOne(mappedBy = "sales", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    @JsonManagedReference
    private Payments payments;

    private LocalDateTime created_at = LocalDateTime.now();
    private LocalDateTime updated_at = LocalDateTime.now();
    private LocalDateTime deleted_at = null;

}