/*
 * File: src/main/java/reports/model/purchase/GRNItem.java
 * Description: This model represents individual items within a Goods Received Note (GRN).
 * Each GRNItem captures details such as product ID, quantity, unit price, total price, expiration
 * date, and tax information. The model maintains references to the associated GRN and includes
 * metadata for creation, update, and deletion timestamps, providing a complete view of each item received.
 */

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

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

import java.time.LocalDate;
import java.time.LocalDateTime;

@Data
@Entity
@Table(name = "grn_item")
@Getter
@Setter
public class GRNItem {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @ManyToOne
    @JoinColumn(name = "grn_id")
    @JsonBackReference
    private GRN grn_item;

    @Column(nullable = false)
    private Long product_id;

    @Column(nullable = false)
    private Integer quantity;

    @Column(nullable = false)
    private Double unit_price;

    @Column(nullable = false)
    private Double total_price;

    @Column(nullable = false)
    private LocalDate expiration_date;

    @Column(nullable = false)
    private LocalDate manufacture_date;

    @Column(nullable = false)
    private String batch_code;

    @Column(nullable = false)
    private String tax_id;

    @Column(nullable = false)
    private String created_by;

    @Column(nullable = false)
    private String tenant;

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