package com.geosegbar.entities;

import java.time.LocalDateTime;
import java.util.HashSet;
import java.util.Set;

import org.hibernate.annotations.CreationTimestamp;

import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
import com.fasterxml.jackson.annotation.JsonManagedReference;
import com.geosegbar.common.enums.AnomalyOriginEnum;

import jakarta.persistence.CascadeType;
import jakarta.persistence.Column;
import jakarta.persistence.Entity;
import jakarta.persistence.EnumType;
import jakarta.persistence.Enumerated;
import jakarta.persistence.FetchType;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
import jakarta.persistence.Index;
import jakarta.persistence.JoinColumn;
import jakarta.persistence.ManyToOne;
import jakarta.persistence.NamedAttributeNode;
import jakarta.persistence.NamedEntityGraph;
import jakarta.persistence.NamedEntityGraphs;
import jakarta.persistence.OneToMany;
import jakarta.persistence.Table;
import jakarta.validation.constraints.NotNull;
import lombok.AllArgsConstructor;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;

@Entity
@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
@JsonIgnoreProperties({"hibernateLazyInitializer", "handler"})
@Table(name = "anomalies", indexes = {
    @Index(name = "idx_anomaly_dam_id", columnList = "dam_id"),
    @Index(name = "idx_anomaly_user_id", columnList = "user_id"),
    @Index(name = "idx_anomaly_status_id", columnList = "status_id"),
    @Index(name = "idx_anomaly_danger_level_id", columnList = "danger_level_id"),
    @Index(name = "idx_anomaly_created_at", columnList = "created_at"),
    @Index(name = "idx_anomaly_created_desc", columnList = "created_at DESC"),
    @Index(name = "idx_anomaly_coordinates", columnList = "latitude, longitude"),
    @Index(name = "idx_anomaly_dam_coordinates", columnList = "dam_id, latitude, longitude"),
    @Index(name = "idx_anomaly_dam_status", columnList = "dam_id, status_id"),
    @Index(name = "idx_anomaly_dam_created", columnList = "dam_id, created_at DESC"),
    @Index(name = "idx_anomaly_user_created", columnList = "user_id, created_at DESC"),
    @Index(name = "idx_anomaly_status_created", columnList = "status_id, created_at DESC"),
    @Index(name = "idx_anomaly_danger_created", columnList = "danger_level_id, created_at DESC"),
    @Index(name = "idx_anomaly_origin", columnList = "origin"),
    @Index(name = "idx_anomaly_questionnaire_id", columnList = "questionnaire_id"),
    @Index(name = "idx_anomaly_question_id", columnList = "question_id"),
    @Index(name = "idx_anomaly_origin_dam", columnList = "origin, dam_id"),
    @Index(name = "idx_anomaly_dam_danger_status", columnList = "dam_id, danger_level_id, status_id"),
    @Index(name = "idx_anomaly_complete_filter", columnList = "dam_id, status_id, danger_level_id, created_at DESC")
})
@NamedEntityGraphs({
    @NamedEntityGraph(
            name = "anomaly.complete",
            attributeNodes = {
                @NamedAttributeNode("photos"),
                @NamedAttributeNode("user"),
                @NamedAttributeNode("dam"),
                @NamedAttributeNode("dangerLevel"),
                @NamedAttributeNode("status")
            }
    )
})
public class AnomalyEntity {

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

    @ManyToOne(fetch = FetchType.EAGER)
    @JoinColumn(name = "user_id", nullable = false)
    @JsonIgnoreProperties({"damPermissions", "createdUsers", "psbFoldersCreated", "psbFilesUploaded", "sharedFolders"})
    @NotNull(message = "Usuário é obrigatório!")
    private UserEntity user;

    @ManyToOne(fetch = FetchType.EAGER)
    @JoinColumn(name = "dam_id", nullable = false)
    @JsonIgnoreProperties({"checklists", "checklistResponses", "damPermissions", "reservoirs", "psbFolders"})
    @NotNull(message = "Barragem é obrigatória!")
    private DamEntity dam;

    @Column(name = "created_at", nullable = false, updatable = false)
    @CreationTimestamp
    private LocalDateTime createdAt;

    @Column(nullable = false)
    @NotNull(message = "Latitude é obrigatória!")
    private Double latitude;

    @Column(nullable = false)
    @NotNull(message = "Longitude é obrigatória!")
    private Double longitude;

    @Column(name = "questionnaire_id")
    private Long questionnaireId;

    @Column(name = "question_id")
    private Long questionId;

    @Enumerated(EnumType.STRING)
    @Column(name = "origin", nullable = false)
    private AnomalyOriginEnum origin;

    @Column(name = "observation", columnDefinition = "TEXT")
    private String observation;

    @Column(name = "recommendation", columnDefinition = "TEXT")
    private String recommendation;

    @ManyToOne(fetch = FetchType.EAGER)
    @JoinColumn(name = "danger_level_id", nullable = false)
    @NotNull(message = "Nível de Perigo é obrigatório!")
    private DangerLevelEntity dangerLevel;

    @ManyToOne(fetch = FetchType.EAGER)
    @JoinColumn(name = "status_id", nullable = false)
    @NotNull(message = "Status é obrigatório!")
    private AnomalyStatusEntity status;

    @OneToMany(mappedBy = "anomaly", fetch = FetchType.LAZY,
            cascade = CascadeType.ALL, orphanRemoval = true)
    @JsonManagedReference(value = "anomaly-photos")
    private Set<AnomalyPhotoEntity> photos = new HashSet<>();
}