/**
  * @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;
 }