1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
| @Entity
@Table (name="order3d")
public class Order3d implements Serializable {
private static final long serialVersionUID = -2241346447352903470L;
public enum State {DEMAND, ESTIMATED, PAYED, PENDING, PRODUCED, SENT, DELIVERED};
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
@Column (name="id")
private int id;
@Column (name="person")
private int person;
@Column (name="state", columnDefinition="smallint")
private State state;
@Column (name="labor_expense")
private float laborExpense=0;
@Column (name="travel_expense")
private float travelExpense=0;
@Column (name="validity_date")
private Date validityDate;
@Column (name="demand_date")
private Date demandDate;
@Column (name="estimate_date")
private Date estimateDate;
@Column (name="order_date")
private Date orderDate=null;
@Column (name="modification", columnDefinition="TEXT")
private String modification;
@Column (name="delivery", columnDefinition = "BIT", length = 1)
private Boolean delivery=true;
@OneToMany(mappedBy="order3d", cascade=CascadeType.ALL)
private Set<DrawFile> myDraws=new HashSet<DrawFile>(5);
}
@Entity
@Table (name="draw")
public class DrawFile implements Serializable {
private static final long serialVersionUID = -9024754876558087847L;
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
@Column (name="id")
private int id;
@Column (name="hashname", columnDefinition="CHAR(64)")
private String hashname;
@Column (name="filename")
private String filename="";
@Column (name="accepted", columnDefinition = "BIT", length = 1)
private Boolean accepted=true;
@Column (name="format")
private String format;
@Column (name="size")
private int size;
@Column(name="width")
short width;
@Column(name="depth")
short depth;
@Column(name="height")
short height;
@OneToMany(mappedBy="draw", cascade=CascadeType.ALL)
private Set<Order3dLine> myLines=new HashSet<Order3dLine>(5);
@ManyToOne
@JoinColumn(name="order3d_id")
private Order3d order3d;
}
@Entity
@Table (name="line3d")
public class Order3dLine implements Serializable {
private static final long serialVersionUID = 3993578603382571145L;
@NaturalId
@ManyToOne
@JoinColumn(name="draw_id")
private DrawFile draw;
@Column (name="quantity")
private short quantity=0;
@Id
@Column (name="material")
private String material;
@Id
@Column (name="color")
private int color;
@Column(name="produced")
short produced=0;
@Column(name="duration")
short duration=0;
} |
Partager