Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $qb = $this->getEntityManager()->createQueryBuilder();
- $qb->select( 'e' )
- ->from( 'EntityEvent', 'e' )
- ->setMaxResults( $limit )
- ->setFirstResult( $offset )
- ->orderBy('e.dateStart', 'ASC');
- $events = $qb->getQuery()->getResult();
- /**
- * User
- *
- * @ORMTable(name="event")
- * @ORMEntity(repositoryClass="RepositoriesEventRepository")
- */
- class Event
- {
- /**
- * @var DateTime
- *
- * @ORMColumn(name="date_start", type="datetime", precision=0, scale=0, nullable=true, unique=false)
- */
- private $dateStart;
- ...
- }
- $qb->select( 'e' )
- ->from( 'EntityEvent', 'e' )
- ->Where(
- $qb->expr()->andX(
- $qb->expr()->between('e.dateStart', ':from', ':to')
- )
- )
- ->orderBy('e.dateStart', 'ASC')
- ->setFirstResult( $offset )
- ->setMaxResults( $limit );
- $qb->select( 'e' )
- ->from( 'EntityEvent', 'e' )
- ->orderBy('e.dateStart', 'ASC');
- ->setFirstResult( $offset )
- ->setMaxResults(20);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement