/** * @param Request $request * @param Criteria $criteria */ private function addOffset(Request $request, Criteria $criteria) { $page = $request->getParam('sPage', 1); $criteria->offset(($page - 1) * $criteria->getLimit()); }
private function getPages(Criteria $criteria, $currentPage, $totalCount) { if ($criteria->getLimit() != 0) { $numberPages = ceil($totalCount / $criteria->getLimit()); } else { $numberPages = 0; } if ($numberPages > 1) { for ($i = 1; $i <= $numberPages; $i++) { $sPages['pages'][$i] = $i; } // Previous page if ($currentPage != 1) { $sPages["before"] = $currentPage - 1; } else { $sPages["before"] = null; } // Next page if ($currentPage != $numberPages) { $sPages["next"] = $currentPage + 1; } else { $sPages["next"] = null; } } return $sPages; }