コード例 #1
0
 /**
  * @param string               $alias
  * @param ListRequestInterface $request
  *
  * @return \Doctrine\ORM\QueryBuilder
  */
 public function createQueryBuilderWithLimitAndOrder(string $alias, ListRequestInterface $request)
 {
     return $this->createQueryBuilder($alias)->setFirstResult(($request->getPage() - 1) * $request->getLimit())->setMaxResults($request->getLimit())->addOrderBy($alias . '.' . $request->getSort(), $request->getOrder());
 }
コード例 #2
0
 /**
  * @param array                $criteria
  * @param ListRequestInterface $request
  *
  * @return array total and items
  */
 public function getEntitiesByWithListRequestAndTotal(array $criteria, ListRequestInterface $request)
 {
     $items = $this->getEntitiesBy($criteria, [$request->getSort() => $request->getOrder()], $request->getLimit(), ($request->getPage() - 1) * $request->getLimit());
     return ['total' => $this->repository->countByCriteria($criteria), 'items' => $items];
 }