WeaponIssue.java

package com.crimeLink.analyzer.entity;

import com.crimeLink.analyzer.enums.WeaponStatus;
import jakarta.persistence.*;
import lombok.*;

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


@Entity
@Table(name = "weapon_issues")
@Data
@NoArgsConstructor
@AllArgsConstructor
public class WeaponIssue {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer issueId;

    /* Weapon */
    @ManyToOne
    @JoinColumn(name = "weapon_serial", referencedColumnName = "serial_number")
    private Weapon weapon;

    /* Issued to */
    @ManyToOne
    @JoinColumn(name = "issued_to", referencedColumnName = "user_id")
    private User issuedTo;

    /* Handed over by */
    @ManyToOne
    @JoinColumn(name = "handed_over_by", referencedColumnName = "user_id")
    private User handedOverBy;

    /* Received by */
    @ManyToOne
    @JoinColumn(name = "received_by", referencedColumnName = "user_id")
    private User receivedBy;

    private LocalDateTime issuedAt;
    private LocalDate dueDate;
    private LocalDateTime returnedAt;

    private String issueNote;
    private String returnNote;

    @Enumerated(EnumType.STRING)
    private WeaponStatus status;


     // ===== INTEGRATED BULLET TRACKING =====
    @Column(name = "bullet_type")
    private String bulletType;
    
    @Column(name = "issued_magazines")
    private Integer issuedMagazines;
    
    @Column(name = "returned_magazines")
    private Integer returnedMagazines;
    
    @Column(name = "used_bullets")
    private Integer usedBullets;
    
    @Column(name = "bullet_condition")
    private String bulletCondition;
    
    @Column(name = "bullet_remarks")
    private String bulletRemarks;
}