package net.sumaris.core.model.data;
   
   /*-
    * #%L
    * SUMARiS:: Core
    * %%
    * Copyright (C) 2018 SUMARiS Consortium
    * %%
    * This program is free software: you can redistribute it and/or modify
   * it under the terms of the GNU General Public License as
   * published by the Free Software Foundation, either version 3 of the
   * License, or (at your option) any later version.
   *
   * This program is distributed in the hope that it will be useful,
   * but WITHOUT ANY WARRANTY; without even the implied warranty of
   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   * GNU General Public License for more details.
   *
   * You should have received a copy of the GNU General Public
   * License along with this program.  If not, see
   * <http://www.gnu.org/licenses/gpl-3.0.html>.
   * #L%
   */
  
  import com.google.common.collect.Sets;
  import lombok.Data;
  import lombok.experimental.FieldNameConstants;
  import net.sumaris.core.model.administration.programStrategy.Program;
  import net.sumaris.core.model.administration.user.Department;
  import net.sumaris.core.model.administration.user.Person;
  import net.sumaris.core.model.referential.location.Location;
  import net.sumaris.core.model.referential.QualityFlag;
  import net.sumaris.core.model.referential.SaleType;
  import org.hibernate.annotations.Cascade;
  
  import javax.persistence.*;
  import java.util.ArrayList;
  import java.util.Date;
  import java.util.List;
  import java.util.Set;
  
  @Data
  @FieldNameConstants
  @Entity
  @Table(name = "sale")
  public class Sale implements IRootDataEntity<Integer>,
          IWithVesselEntity<Integer, Vessel> {
  
      @Id
      @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SALE_SEQ")
      @SequenceGenerator(name = "SALE_SEQ", sequenceName = "SALE_SEQ")
      private Integer id;
  
      @Column(name = "creation_date", nullable = false)
      @Temporal(TemporalType.TIMESTAMP)
      private Date creationDate;
  
      @Column(name = "update_date")
      @Temporal(TemporalType.TIMESTAMP)
      private Date updateDate;
  
      @ManyToOne(fetch = FetchType.LAZY)
      @JoinColumn(name = "recorder_person_fk")
      private Person recorderPerson;
  
      @ManyToOne(fetch = FetchType.LAZY)
      @JoinColumn(name = "recorder_department_fk", nullable = false)
      private Department recorderDepartment;
  
      @Column(length = 2000)
      private String comments;
  
      @Column(name = "control_date")
      @Temporal(TemporalType.TIMESTAMP)
      private Date controlDate;
  
      @Column(name = "validation_date")
      @Temporal(TemporalType.TIMESTAMP)
      private Date validationDate;
  
      @Column(name = "qualification_date")
      @Temporal(TemporalType.TIMESTAMP)
      private Date qualificationDate;
  
      @Column(name = "qualification_comments", length = LENGTH_COMMENTS)
      private String qualificationComments;
  
      @ManyToOne(fetch = FetchType.LAZY, targetEntity = QualityFlag.class)
      @JoinColumn(name = "quality_flag_fk", nullable = false)
      private QualityFlag qualityFlag;
  
      @ManyToOne(fetch = FetchType.LAZY, targetEntity = Vessel.class)
      @JoinColumn(name = "vessel_fk", nullable = false)
      private Vessel vessel;
  
      @Column(name = "start_date_time", nullable = false)
      private Date startDateTime;
  
      @Column(name = "end_date_time")
     private Date endDateTime;
 
     @ManyToOne(fetch = FetchType.EAGER, targetEntity = Location.class)
     @JoinColumn(name = "sale_location_fk", nullable = false)
     private Location saleLocation;
 
     @ManyToOne(fetch = FetchType.EAGER, targetEntity = SaleType.class)
     @JoinColumn(name = "sale_type_fk", nullable = false)
     private SaleType saleType;
 
     @ManyToOne(fetch = FetchType.LAZY, targetEntity = Program.class)
     @JoinColumn(name = "program_fk", nullable = false)
     private Program program;
 
     @ManyToMany(fetch = FetchType.EAGER, targetEntity = Person.class)
     @Cascade(org.hibernate.annotations.CascadeType.DETACH)
     @JoinTable(name = "sale2observer_person", joinColumns = {
             @JoinColumn(name = "sale_fk", nullable = false, updatable = false)},
             inverseJoinColumns = {
                     @JoinColumn(name = "person_fk", nullable = false, updatable = false)})
     private Set<Person> observers = Sets.newHashSet();
 
     /* -- measurements -- */
 
     @OneToMany(fetch = FetchType.LAZY, targetEntity = SaleMeasurement.class, mappedBy = SaleMeasurement.Fields.SALE)
     @Cascade(org.hibernate.annotations.CascadeType.DELETE)
     private List<SaleMeasurement> measurements = new ArrayList<>();
 
     /* -- parent -- */
 
     @ManyToOne(fetch = FetchType.LAZY, targetEntity = Trip.class)
     @JoinColumn(name = "trip_fk")
     private Trip trip;
 
     @ManyToOne(fetch = FetchType.LAZY, targetEntity = ObservedLocation.class)
     @JoinColumn(name = "observed_location_fk")
     private ObservedLocation observedLocation;
 }