Kundefil.java

package kundedb.models;

import com.avaje.ebean.Model;

import javax.persistence.*;
import java.util.Date;
import java.util.List;

@Entity
@Table(name = "kundefil")
public class Kundefil extends Model {
  public static Finder<Long, Kundefil> find = new Finder<>("kundedb",Kundefil.class);

  public Kundefil() {
    pk = new KundefilPK();
  }

  @EmbeddedId
  public KundefilPK pk ;

  @ManyToOne
  @JoinColumn(name = "kundenr",insertable = false,updatable = false)
  public Kunde kunde;

  @ManyToOne
  @JoinColumn(name = "filnr",insertable = false,updatable = false)
  public Datafil datafil;

  public Date startdato;
  public Date sluttdato;

  public static List<Kundefil> findByOrdrenr(Long ordrenr) {
    return find.where()
        .eq("datafil.uri", "offshore_" + ordrenr + "/" + ordrenr + ".html")
        .findList();
  }

  @Override
  public String toString() {
    return "Kundefil{" +
        "pk=" + pk +
        ", kunde=" + kunde +
        ", datafil=" + datafil +
        ", startdato=" + startdato +
        ", sluttdato=" + sluttdato +
        '}';
  }
}