package com.nebula.erp.sales.model;

import com.fasterxml.jackson.annotation.JsonManagedReference;
import jakarta.persistence.*;
import lombok.Data;
import lombok.Getter;
import lombok.Setter;
import java.time.Instant;
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 Instant date;

    private String prescription_id;

    @Column(nullable = false)
    private String encounter_id;

    @Column(name = "custom_encounter_id")
    private String customEncounterId;

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

    @Column(nullable = false)
    private String patient_id;

    @Column(name = "prescription_total_amount")
    private Double prescriptionTotalAmount;

    private String patient_name;

    private String customer_name;

    private String customer_mobile;

    private String customer_email;

    private String customer_dob;

    private String customer_gender;

    private String customer_address;

    @Column(nullable = false)
    private Double total_amount;

    private Double discount;

    private String coupon_code;

    private Double coupon_amount;

    @Column(nullable = false)
    private String payment_status;

    @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;
    @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;

    @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;

    @Column(nullable = false, updatable = false)
    private Instant created_at;

    @Column(nullable = false)
    private Instant updated_at;

    private Instant deleted_at;

    @PrePersist
    protected void onCreate() {
        Instant now = Instant.now();
        created_at = now;
        updated_at = now;
    }

    @PreUpdate
    protected void onUpdate() {
        updated_at = Instant.now();
    }
}