Guest User

Untitled

a guest
May 22nd, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.68 KB | None | 0 0
  1. CREATE TABLE "pre_vendas" (
  2. "id_prev_venda" BIGINT NOT NULL,
  3. "data_prev_venda" DATE NOT NULL,
  4. "data_real_venda" DATE NOT NULL,
  5. "valor_real_venda" NUMERIC(10,2) NULL DEFAULT NULL,
  6. PRIMARY KEY ("id_prev_venda")
  7. );
  8.  
  9. @Entity
  10. @Table(name = "pre_vendas")
  11. @XmlRootElement
  12. public class PreVenda implements Serializable {
  13.  
  14. private static final long serialVersionUID = 1345540614644262508L;
  15.  
  16. @Id
  17. @GeneratedValue(generator = "pre_venda_seq_gen")
  18. @GenericGenerator(name = "pre_venda_seq_gen", strategy = "org.hibernate.id.enhanced.SequenceStyleGenerator", parameters = {
  19. @Parameter(name = "sequence_name", value = "seq_manejo"), @Parameter(name = "optimizer", value = "hilo"),
  20. @Parameter(name = "initial_value", value = "1"), @Parameter(name = "increment_size", value = "1") })
  21. @Column(name = "id_prev_venda", nullable = false)
  22. private Long idPrevVenda;
  23.  
  24. @Column(name = "data_prev_venda", nullable = false)
  25. @Temporal(TemporalType.DATE)
  26. private Date dataPrevVenda;
  27.  
  28. @Column(name = "data_real_venda", nullable = false)
  29. @Temporal(TemporalType.DATE)
  30. private Date dataRealVenda;
  31.  
  32. @Column(name = "valor_real_venda", nullable = false, precision = 10, scale = 2)
  33. private BigDecimal valorRealVenda;
  34.  
  35. }
  36.  
  37. CriteriaBuilder builder = sf.getCurrentSession().getCriteriaBuilder();
  38. CriteriaQuery<Tuple> criteria = builder.createTupleQuery();
  39. Root<PreVenda> root = criteria.from(PreVenda.class);
  40.  
  41. Expression<Long> dataPrevVenda = root.get(PreVenda_.dataPrevVenda).as(Long.class);
  42.  
  43. Expression<Long> dataRealVenda = root.get(PreVenda_.dataRealVenda).as(Long.class);
  44.  
  45. criteria.select(builder.tuple(builder.diff(dataRealVenda,dataPrevVenda)));
Add Comment
Please, Sign In to add comment