Advertisement
Guest User

Untitled

a guest
Apr 19th, 2014
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. $qb = $this->getEntityManager()->createQueryBuilder();
  2.  
  3. $qb->select( 'e' )
  4. ->from( 'EntityEvent', 'e' )
  5. ->setMaxResults( $limit )
  6. ->setFirstResult( $offset )
  7. ->orderBy('e.dateStart', 'ASC');
  8.  
  9. $events = $qb->getQuery()->getResult();
  10.  
  11. /**
  12. * User
  13. *
  14. * @ORMTable(name="event")
  15. * @ORMEntity(repositoryClass="RepositoriesEventRepository")
  16. */
  17. class Event
  18. {
  19. /**
  20. * @var DateTime
  21. *
  22. * @ORMColumn(name="date_start", type="datetime", precision=0, scale=0, nullable=true, unique=false)
  23. */
  24. private $dateStart;
  25.  
  26. ...
  27. }
  28.  
  29. $qb->select( 'e' )
  30. ->from( 'EntityEvent', 'e' )
  31. ->Where(
  32. $qb->expr()->andX(
  33. $qb->expr()->between('e.dateStart', ':from', ':to')
  34. )
  35. )
  36. ->orderBy('e.dateStart', 'ASC')
  37. ->setFirstResult( $offset )
  38. ->setMaxResults( $limit );
  39.  
  40. $qb->select( 'e' )
  41. ->from( 'EntityEvent', 'e' )
  42. ->orderBy('e.dateStart', 'ASC');
  43. ->setFirstResult( $offset )
  44. ->setMaxResults(20);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement