@Table(name = "affaire")
@Data
@Entity
public class Affaire implements Serializable {

    private static final long servialVersionUID = 1L;


    private int id;
    private String sn;
    private String zc;
    private String certificat;
    private boolean etat;
    private Date finEval;
    private Date finRep;
    private String limiteCalendaire;
    private Date dateLancement;
    private boolean accordClient;
    private Accessoire accessoire;
    private int idAccessoire;
    private Flux flux;
    private int idFlux;
    private Reparation reparation;
    private int idReparation;
    private Variante variante;
    private int idVariante;
    private List<Affecter> affecters;

    public Affaire() {
    }

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    public int getId() {
        return id;
    }

    @Column(name = "sn")
    public String getSn() {
        return sn;
    }

    @Column(name = "zc")
    public String getZc() {
        return zc;
    }

    @Column(name = "certificat")
    public String getCertificat() {
        return certificat;
    }

    @Column(name = "etat")
    public boolean isEtat() {
        return etat;
    }

    @Column(name = "finEval")
    public Date getFinEval() {
        return finEval;
    }

    @Column(name = "finRep")
    public Date getFinRep() {
        return finRep;
    }

    @Column(name = "limiteCalendaire")
    public String getLimiteCalendaire() {
        return limiteCalendaire;
    }

    @Column(name = "dateLancement")
    public Date getDateLancement() {
        return dateLancement;
    }

    @Column(name = "accordClient")
    public boolean isAccordClient() {
        return accordClient;
    }

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name="id_accessoire", nullable = false)
    @JsonBackReference
    public Accessoire getAccessoire() {
        return accessoire;
    }

    @Column(name = "id_accessoire", insertable = false, updatable = false)
    public int getIdAccessoire() {
        return idAccessoire;
    }

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name="id_flux", nullable = false)
    @JsonBackReference
    public Flux getFlux() {
        return flux;
    }

    @Column(name = "id_flux", insertable = false, updatable = false)
    public int getIdFlux() {
        return idFlux;
    }

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name="id_reparation", nullable = false)
    @JsonBackReference
    public Reparation getReparation() {
        return reparation;
    }

    @Column(name = "id_reparation", insertable = false, updatable = false)
    public int getIdReparation() {
        return idReparation;
    }

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name="id_variante", nullable = false)
    @JsonBackReference
    public Variante getVariante() {
        return variante;
    }

    @Column(name = "id_variante", insertable = false, updatable = false)
    public int getIdVariante() {
        return idVariante;
    }

    @OneToMany(mappedBy = "affaire", cascade=CascadeType.ALL, fetch=FetchType.LAZY)
    @JsonManagedReference
    public List<Affecter> getAffecters() {
        return affecters;
    }

}

@Table(name = "affecter")
@Data
@Entity
public class Affecter implements Serializable {

    private static final long serialVersionUID = 1L;

    private int id;
    private Date dateEntree;
    private Date dateSortie;
    private Affaire affaire;
    private int idAffaire;
    private Service service;
    private int idService;

    public Affecter() {
    }

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id")
    public int getId() {
        return id;
    }

    @Column(name = "dateEntree")
    public Date getDateEntree() {
        return dateEntree;
    }

    @Column(name = "dateSortie")
    public Date getDateSortie() {
        return dateSortie;
    }

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name="id_affaire", nullable = false)
    @JsonBackReference
    public Affaire getAffaire() {
        return affaire;
    }

    @Column(name = "id_affaire", insertable = false, updatable = false)
    public int getIdAffaire() {
        return idAffaire;
    }

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name="id_service", nullable = false)
    @JsonBackReference
    public Service getService() {
        return service;
    }

    @Column(name = "id_service", insertable = false, updatable = false)
    public int getIdService() {
        return idService;
    }

    public String getSn(){
        return affaire.getSn();
    }