package com.sn.sowsysrestapi.domain.entity;

import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.ToString;
import org.hibernate.annotations.CreationTimestamp;
import org.hibernate.annotations.UpdateTimestamp;

import javax.persistence.*;
import java.time.LocalDate;
import java.time.OffsetDateTime;
import java.util.ArrayList;
import java.util.List;

@Data
@Entity
@EqualsAndHashCode(onlyExplicitlyIncluded = true)
@ToString
@Table(name = "report")
public class Report {

    @EqualsAndHashCode.Include
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id")
    private Long id;

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

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

    @Column(name = "start_date")
    private LocalDate startDate;

    @Column(name = "end_date")
    private LocalDate endDate;

    @Column(name = "total_worked_hours_completed_tasks")
    private Double totalWorkedHoursCompletedTasks = 0.0;

    @Column(name = "total_worked_hours_current_tasks")
    private Double totalWorkedHoursCurrentTasks = 0.0;

    @Column(name = "total_worked_hours")
    private Double totalWorkedHours = 0.0;

    @Column(name = "qty_current_tasks")
    private Integer qtyCurrentTasks = 0;

    @Column(name = "qty_completed_tasks")
    private Integer qtyCompletedTasks = 0;

    @CreationTimestamp
    @Column(name = "created_on")
    private OffsetDateTime createdOn;

    @UpdateTimestamp
    @Column(name = "updated_on")
    private OffsetDateTime updatedOn;

    @OneToMany(mappedBy = "report")
    private List<Concern> concernList = new ArrayList<>();

    @OneToMany(mappedBy = "report")
    private List<CurrentTask> currentTaskList = new ArrayList<>();

    @OneToMany(mappedBy = "report")
    private List<CompletedTask> completedTaskList = new ArrayList<>();

    @OneToMany(mappedBy = "report")
    private List<Suggestion> suggestionList = new ArrayList<>();

    @OneToMany(mappedBy = "report")
    private List<NextPeriodTask> nextPeriodTaskList = new ArrayList<>();

    @ManyToOne
    @JoinColumn(name = "report_directory_id", foreignKey = @ForeignKey(name = "FK_REPORT_DIRECTORY_ID_REPORT"))
    private ReportDirectory reportDirectory;


}