public function dataAction() { $response = $this->getResponse(); $grid = $this->grid('Application\\Index\\Index', array('-', 'id', 'title', 'category', 'username', 'created_at', '-')); if (isset($this->getSessionContainer()->parent_id)) { $grid['parent_id'] = $this->getSessionContainer()->parent_id; } $result = $this->getResourceTable()->fetchDataGrid($grid); $adapter = new ArrayAdapter($result); $paginator = new Paginator($adapter); $page = ceil(intval($grid['start']) / intval($grid['length'])) + 1; $paginator->setCurrentPageNumber($page); $paginator->setItemCountPerPage(intval($grid['length'])); $data = array(); $data['data'] = array(); foreach ($paginator as $row) { $category = array_key_exists('category', $row) ? $row['category'] : '-'; $title = $row['node_type'] == \Application\Model\Resource::NODE_TYPE_CATEGORY ? '<a href="/admin/resource/parent_id/' . $row['id'] . '" title="' . strip_tags($row['description']) . '">' . strip_tags($row['title']) . '</a>' : '<i>' . strip_tags($row['title']) . '</i>'; $actions = ''; if ($row['url']) { $actions .= '<a class="btn btn-xs btn-outline blue-steel btn-view" href="' . $row['url'] . '" data-id="' . $row['id'] . '" target="_blank">View</a> '; } $actions .= '<a class="btn btn-xs btn-outline red" href="/admin/resource/delete/id/' . $row['id'] . '" onclick="return confirm("Are you sure you wish to delete selected resources?");">Delete</a>'; $data['data'][] = array('<input type="checkbox" name="id[' . $row['id'] . ']" value="' . $row['id'] . '" />', '<a class="btn btn-xs btn-outline blue-steel btn-view" href="/admin/resource/edit/id/' . $row['id'] . '/parent_id/' . $row['parent_id'] . '" title="' . $row['id'] . '">Edit: ' . $row['id'] . '</a>', $title, $category, $row['username'], date('F jS Y', strtotime($row['created_at'])), $actions); } $data['page'] = $page; $data['grid'] = $grid; $data['draw'] = intval($grid['draw']); $data['recordsTotal'] = $paginator->getTotalItemCount(); $data['recordsFiltered'] = $paginator->getTotalItemCount(); $response->setStatusCode(200); $response->setContent(Json::encode($data)); return $response; }
public function indexAction() { $this->layout('layout/bags'); $getuser = $this->forward()->dispatch('Admin\\Controller\\Index', array('action' => 'getuser')); $this->layout()->getuser = $getuser; if (!$getuser) { // notlogin $this->redirect()->toUrl(WEBPATH); } $this->layout()->getuser = $getuser; //$ProductTable = $this->getServiceLocator()->get('ProductTable'); $allRecord = $this->getSlideTable()->countAll(); //print_r($allRecord);die; $pageNull = new PageNull($allRecord); $itemsPerPage = 5; $pageRange = 3; $page = $this->params()->fromRoute('page', 1); $offset = ($page - 1) * $itemsPerPage; $paginator = new Paginator($pageNull); $paginator->setCurrentPageNumber($page); $paginator->setItemCountPerPage($itemsPerPage); $paginator->setPageRange($pageRange); $listpr_tmp = $this->getSlideTable()->getList($offset, $itemsPerPage); //--------------------------------- $fetch_slideshow = $this->getSlideTable()->getList($offset, $itemsPerPage); $this->layout()->fetch_slideshow = $fetch_slideshow; return new ViewModel(array('paginator' => $paginator, 'allRecord' => $allRecord, 'offset' => $offset, 'itemsPerPage' => $itemsPerPage)); }
public function indexAction() { $page = $this->params()->fromRoute("page", 1); $posts = new Paginator(new ArrayAdapter($this->getPostRepository()->findBy(array(), array("postDate" => "DESC")))); $posts->setCurrentPageNumber($page)->setItemCountPerPage(6); return new ViewModel(array("pageTitle" => "Latest News", "bodyClass" => "postsPage blackLayout", "posts" => $posts)); }
/** * Creates a paginator * * @return Paginator Zend Paginator */ public function newPaginator(array $images = array(), $currentPage = 1, $perPage = 25) { $paginator = new Paginator(new ArrayAdapter($images)); $paginator->setItemCountPerPage($perPage); $paginator->setCurrentPageNumber($currentPage); return $paginator; }
public function publicarAction() { $form = new FotosForm(); $id = (int) $this->params()->fromRoute('id', 0); $fotosValidator = new FotosValidator(); $request = $this->getRequest(); $album = $this->getObjectManager()->find('Admin\\Model\\Galeria', $id); $collection = new ArrayCollection($this->getService('Admin\\Service\\Fotos')->fetchAll($id)); $paginator = new Paginator(new Adapter($collection)); $paginator->setCurrentPageNumber($this->params()->fromQuery('page', 1))->setItemCountPerPage(12); if (!$album) { $this->redirect()->toUrl('/admin/galeria-de-fotos'); $this->flashMessenger()->addErrorMessage('Álbum não localizado'); } if ($request->isPost()) { $form->setInputFilter($fotosValidator->getInputFilter()); $form->setData(array_merge_recursive($this->getRequest()->getPost()->toArray(), $this->getRequest()->getFiles()->toArray())); if ($form->isValid()) { $dados = $form->getData(); try { $this->getService('Admin\\Service\\Fotos')->saveFotos($dados, $album); $this->flashMessenger()->addSuccessMessage('Fotos Publicadas com Sucesso.'); } catch (\Exception $e) { $this->flashMessenger()->addErrorMessage('Erro ao publicar fotos, por favor tente novamente.'); } return $this->redirect()->toUrl('/admin/galeria-de-fotos'); } } return new ViewModel(array('form' => $form, 'fotos' => $collection)); }
/** * @return EntryView[] */ private function prepareEntries(int $page, Paginator $posts) : array { return array_map(function ($post) { $post['uriHelper'] = $this->uriHelper; return new EntryView($post); }, iterator_to_array($posts->getItemsByPage($page))); }
/** * Get users * * @param integer $page * @param integer $perPage * @param string $orderBy * @param string $orderType * @param array $filters * string nickname * string email * string status * integer role * @return object */ public function getUsers($page = 1, $perPage = 0, $orderBy = null, $orderType = null, array $filters = []) { $orderFields = ['id', 'nickname', 'email', 'registered', 'status']; $orderType = !$orderType || $orderType == 'desc' ? 'desc' : 'asc'; $orderBy = $orderBy && in_array($orderBy, $orderFields) ? $orderBy : 'id'; $select = $this->select(); $select->from(['a' => 'user_list'])->columns(['id' => 'user_id', 'nickname' => 'nick_name', 'email', 'status', 'registered', 'role_id' => 'role'])->join(['b' => 'acl_role'], 'a.role = b.id', ['role' => 'name'])->order($orderBy . ' ' . $orderType); // filter by nickname if (!empty($filters['nickname'])) { $select->where([new LikePredicate('nick_name', $filters['nickname'] . '%')]); } // filter by email if (!empty($filters['email'])) { $select->where(['email' => $filters['email']]); } // filter by status if (!empty($filters['status'])) { $select->where(['status' => $filters['status']]); } // filter by role if (!empty($filters['role'])) { $select->where(['role' => $filters['role']]); } $paginator = new Paginator(new DbSelectPaginator($select, $this->adapter)); $paginator->setCurrentPageNumber($page); $paginator->setItemCountPerPage(PaginationUtility::processPerPage($perPage)); $paginator->setPageRange(SettingService::getSetting('application_page_range')); return $paginator; }
public function listAction() { $pagerAction = $this->handlePager(); $limit = $this->getLimit($this->defaultPageSize); // $limit = $this->getRequest()->getQuery('limit', // $this->defaultPageSize); $page = $this->getRequest()->getQuery('page', 0); $sort = $this->getRequest()->getQuery('sort', $this->defaultSort); $order = $this->getRequest()->getQuery('order', $this->defaultOrder); if (empty($sort)) { $sort = $this->defaultSort; } $offset = $limit * $page - $limit; if ($offset < 0) { $offset = 0; } /* @var $qb \Doctrine\ORM\QueryBuilder */ $qb = $this->getEntityManager()->createQueryBuilder(); $qb->add('select', 'e')->add('from', $this->getEntityClass() . ' e')->orderBy('e.' . $sort, $order)->setFirstResult($offset)->setMaxResults($limit); $qb = $this->handleSearch($qb); $pager = $this->getPagerForm($limit); $paginator = new Paginator(new DoctrinePaginator(new ORMPaginator($qb->getQuery(), true))); $paginator->setDefaultItemCountPerPage($limit); $paginator->setCurrentPageNumber($page); $paginator->setPageRange($this->paginatorRange); $ui = ['table' => ["occurred" => ["col" => 2, "label" => "Date", "sort" => true], "event" => ["col" => 2, "label" => "Event", "sort" => false], "account" => ["col" => 3, "label" => "Account", "sort" => false], "message" => ["col" => 5, "label" => "Info", "sort" => false]]]; $filters = $this->getFilterForm($this->params()->fromQuery()); $post = $this->params()->fromPost(); $redirectUrl = $this->url()->fromRoute($this->getActionRoute(), [], true); return ['paginator' => $paginator, 'sort' => $sort, 'order' => $order, 'page' => $page, 'pager' => $pager, 'query' => $this->params()->fromQuery(), 'filters' => $filters, 'ui' => $ui, 'history' => $this->setHistory()]; }
public function indexAction() { /* $service1=new \Lib\Service1\Custom(); echo $service1->demo(); die; */ /* $plugin=$this->CustomPlugin(); print_r($plugin->doSomthing()); die; */ /* $facebook = new \Facebook(array( 'appId' => 'xxx', 'secret' => 'xxx', )); print_r($facebook); die; */ $auth = new AuthenticationService(); if (!$auth->hasIdentity()) { return $this->redirect()->toRoute('home'); } $select = new Select(); $search = @$_REQUEST['search']; if (!empty($search)) { $select->where->like('name', '%' . $search . '%')->or->like('email', '%' . $search . '%')->or->like('mob', '%' . $search . '%')->or->like('title', '%' . $search . '%'); } $order_by = $this->params()->fromRoute('order_by') ? $this->params()->fromRoute('order_by') : 'id'; $order = $this->params()->fromRoute('order') ? $this->params()->fromRoute('order') : Select::ORDER_ASCENDING; $page = $this->params()->fromRoute('page') ? (int) $this->params()->fromRoute('page') : 1; $album = $this->getAdminTable()->fetchAll($select->order($order_by . ' ' . $order), $search); $itemPerPage = 2; $album->current(); $paginator = new Paginator(new PaginatorIterator($album)); $paginator->setCurrentPageNumber($page); $paginator->setItemCountPerPage($itemPerPage); $paginator->setPageRange(10); //print_r($paginator); die; return new ViewModel(array('order_by' => $order_by, 'order' => $order, 'page' => $page, 'paginator' => $paginator)); }
private function getPaginator($query, $page) { $doc_paginator = new DoctrinePaginator(new ORMPaginator($query)); $paginator = new Paginator($doc_paginator); $paginator->setCurrentPageNumber($page)->setItemCountPerPage(20); return $paginator; }
public function getProfilesPaginator($iPage = 1, $iCount = null) { $oPaginator = new Paginator(new MongoCursor($this->mapper->fetchAllIds())); $oPaginator->setItemCountPerPage($iCount ? $iCount : $this->oOptions->getProfilesCountPerPage()); $oPaginator->setCurrentPageNumber($iPage); return $oPaginator; }
public function indexAction() { $id = (int) $this->getEvent()->getRouteMatch()->getParam('id'); $request = $this->getRequest(); if ($request->isPost()) { $post = $request->getPost(); if ($post->nomeVisitante != '') { $query = $this->getEntityManager()->createQuery("SELECT u FROM\n Visitante\\Entity\\Visitante u WHERE u.nomeVisitante LIKE :data"); $query->setParameters(array('data' => '%' . $post->nomeVisitante . '%')); $dados = $query->getResult(); if ($dados) { $page = (int) $this->getEvent()->getRouteMatch()->getParam('page'); $paginator = new Paginator(new ArrayAdapter($dados)); $paginator->setCurrentPageNumber($page)->setDefaultItemCountPerPage(8); return new ViewModel(array('data' => $paginator, 'page' => $page)); } } } if (!$id) { $visitantes = $this->getEntityManager()->getRepository('Visitante\\Entity\\Visitante')->findBy(array(), array('nomeVisitante' => 'ASC')); $page = (int) $this->getEvent()->getRouteMatch()->getParam('page'); $paginator = new Paginator(new ArrayAdapter($visitantes)); $paginator->setCurrentPageNumber($page)->setDefaultItemCountPerPage(8); return new ViewModel(array('data' => $paginator, 'page' => $page)); } $visitantes = $this->findVisitanteByNome($id); return new ViewModel(array('visitantes' => $visitantes)); }
public function listAction() { $page = $this->getRequest()->getQuery('page', 0); $limit = $this->getRequest()->getQuery('limit', $this->defaultPageSize); $sort = $this->getRequest()->getQuery('sort', $this->defaultSort); $order = $this->getRequest()->getQuery('order', $this->defaultOrder); $id = $this->getEvent()->getRouteMatch()->getParam('id', 0); if (empty($sort)) { $sort = $this->defaultSort; } $offset = $limit * $page - $limit; if ($offset < 0) { $offset = 0; } /* @var $qb \Doctrine\ORM\QueryBuilder */ $qb = $this->getEntityManager()->createQueryBuilder(); $qb->add('select', 'e')->add('from', '\\Lead\\Entity\\Lead e')->innerJoin('e.account', 'a')->andWhere('a.id = :id')->orderBy('e.' . $sort, $order)->setFirstResult($offset)->setMaxResults($limit)->setParameter('id', $id); $qb = $this->handleSearch($qb); $paginator = new Paginator(new DoctrinePaginator(new LosPaginator($qb, false))); $paginator->setDefaultItemCountPerPage($limit); $paginator->setCurrentPageNumber($page); $paginator->setPageRange($this->paginatorRange); $ui = ['table' => ["referrer" => ["col" => 6, "label" => "Source", "sort" => true], "lastsubmitted" => ["col" => 4, "label" => "Submitted", "sort" => true]]]; $filters = $this->getFilterForm($this->params()->fromQuery())->remove('account'); return ['id' => $id, 'paginator' => $paginator, 'sort' => $sort, 'order' => $order, 'page' => $page, 'query' => $this->params()->fromQuery(), 'filters' => $filters, 'ui' => $ui]; }
public function indexAction() { $id = (int) $this->getEvent()->getRouteMatch()->getParam('id'); $request = $this->getRequest(); if ($request->isPost()) { $post = $request->getPost(); if ($post->numerotombo != '') { $query = $this->getEntityManager()->createQuery("SELECT u FROM\n Equipamento\\Entity\\Equipamento u WHERE u.ntombo LIKE :data"); $query->setParameters(array('data' => '%' . $post->numerotombo . '%')); $dados = $query->getResult(); $qb = $this->getEntityManager()->createQueryBuilder()->select('u')->from('Equipamento\\Entity\\Equipamento', 'u')->innerJoin('Equipamento\\Entity\\Tombo', 't', 'WITH', 'u.idequipamento = t.tomboequipamento')->where('t.numeroTombo LIKE :data')->setParameter('data', '%' . $post->numerotombo . '%')->getQuery(); $dados = $dados + $qb->getResult(); if ($dados) { $page = (int) $this->getEvent()->getRouteMatch()->getParam('page'); $paginator = new Paginator(new ArrayAdapter($dados)); $paginator->setCurrentPageNumber($page)->setDefaultItemCountPerPage(8); return new ViewModel(array('data' => $paginator, 'page' => $page)); } } } if (!$id) { $equipamentos = $this->getEntityManager()->getRepository('Equipamento\\Entity\\Equipamento')->findBy(array(), array('ntombo' => 'ASC')); $page = (int) $this->getEvent()->getRouteMatch()->getParam('page'); $paginator = new Paginator(new ArrayAdapter($equipamentos)); $paginator->setCurrentPageNumber($page)->setDefaultItemCountPerPage(8); return new ViewModel(array('data' => $paginator, 'page' => $page)); } $equipamentos = $this->findEquipamentoByTombo($id); return new ViewModel(array('equipamentos' => $equipamentos)); }
public function indexAction() { $searchform = new AlbumSearchForm(); $searchform->get('submit')->setValue('Search'); $select = new Select(); $order_by = $this->params()->fromRoute('order_by') ? $this->params()->fromRoute('order_by') : 'id'; $order = $this->params()->fromRoute('order') ? $this->params()->fromRoute('order') : Select::ORDER_ASCENDING; $page = $this->params()->fromRoute('page') ? (int) $this->params()->fromRoute('page') : 1; $select->order($order_by . ' ' . $order); $search_by = $this->params()->fromRoute('search_by') ? $this->params()->fromRoute('search_by') : ''; $where = new \Zend\Db\Sql\Where(); $formdata = array(); if (!empty($search_by)) { $formdata = (array) json_decode($search_by); if (!empty($formdata['artist'])) { $where->addPredicate(new \Zend\Db\Sql\Predicate\Like('artist', '%' . $formdata['artist'] . '%')); } if (!empty($formdata['title'])) { $where->addPredicate(new \Zend\Db\Sql\Predicate\Like('title', '%' . $formdata['title'] . '%')); } } if (!empty($where)) { $select->where($where); } $album = $this->getAlbumTable()->fetchAll($select); $totalRecord = $album->count(); $itemsPerPage = 2; $album->current(); $paginator = new Paginator(new paginatorIterator($album)); $paginator->setCurrentPageNumber($page)->setItemCountPerPage($itemsPerPage)->setPageRange(7); $searchform->setData($formdata); return new ViewModel(array('search_by' => $search_by, 'order_by' => $order_by, 'order' => $order, 'page' => $page, 'paginator' => $paginator, 'pageAction' => 'album', 'form' => $searchform, 'totalRecord' => $totalRecord)); }
/** * Returns an array of "local" pages given a page number and range. * * @param \Zend\Paginator\Paginator $paginator * @param integer $pageRange (Optional) Page range * @return array */ public function getPages(\Zend\Paginator\Paginator $paginator, $pageRange = null) { if ($pageRange === null) { $pageRange = $paginator->getPageRange(); } $pageNumber = $paginator->getCurrentPageNumber(); $pageCount = count($paginator); if ($pageRange > $pageCount) { $pageRange = $pageCount; } $delta = ceil($pageRange / 2); if ($pageNumber - $delta > $pageCount - $pageRange) { $lowerBound = $pageCount - $pageRange + 1; $upperBound = $pageCount; } else { if ($pageNumber - $delta < 0) { $delta = $pageNumber; } $offset = $pageNumber - $delta; $lowerBound = $offset + 1; $upperBound = $offset + $pageRange; } return $paginator->getPagesInRange($lowerBound, $upperBound); }
public function __invoke($page, $entity) { $auditModuleOptions = $this->getServiceLocator()->getServiceLocator()->get('auditModuleOptions'); $entityManager = $auditModuleOptions->getEntityManager(); $auditService = $this->getServiceLocator()->getServiceLocator()->get('auditService'); if (gettype($entity) != 'string' and in_array(get_class($entity), array_keys($auditModuleOptions->getAuditedClassNames()))) { $auditEntityClass = 'ZF\\Doctrine\\Audit\\Entity\\' . str_replace('\\', '_', get_class($entity)); $identifiers = $auditService->getEntityIdentifierValues($entity); } elseif ($entity instanceof AbstractAudit) { $auditEntityClass = get_class($entity); $identifiers = $auditService->getEntityIdentifierValues($entity, true); } else { $auditEntityClass = 'ZF\\Doctrine\\Audit\\Entity\\' . str_replace('\\', '_', $entity); } $search = array('auditEntityClass' => $auditEntityClass); if (isset($identifiers)) { $search['entityKeys'] = serialize($identifiers); } $queryBuilder = $entityManager->getRepository('ZF\\Doctrine\\Audit\\Entity\\RevisionEntity')->createQueryBuilder('rev'); $queryBuilder->orderBy('rev.id', 'DESC'); $i = 0; foreach ($search as $key => $val) { $i++; $queryBuilder->andWhere("rev.{$key} = ?{$i}"); $queryBuilder->setParameter($i, $val); } $adapter = new DoctrineAdapter(new ORMPaginator($queryBuilder)); $paginator = new Paginator($adapter); $paginator->setDefaultItemCountPerPage($auditModuleOptions->getPaginatorLimit()); $paginator->setCurrentPageNumber($page); return $paginator; }
public function listAction() { $pagerAction = $this->handlePager(); $limit = $this->getLimit($this->defaultPageSize); $limit = 100; $page = $this->getRequest()->getQuery('page', 0); $sort = $this->getRequest()->getQuery('sort', $this->defaultSort); $order = $this->getRequest()->getQuery('order', $this->defaultOrder); if (empty($sort)) { $sort = $this->defaultSort; } $offset = $limit * $page - $limit; if ($offset < 0) { $offset = 0; } /* @var $qb \Doctrine\ORM\QueryBuilder */ $qb = $this->getEntityManager()->createQueryBuilder(); $qb->select(['e.referrer', 'COUNT(e.id) AS refcount'])->from($this->getEntityClass(), 'e')->setFirstResult($offset)->setMaxResults($limit)->groupBy('e.referrer')->orderBy('e.' . $sort, $order); $qb = $this->handleSearch($qb); $pager = $this->getPagerForm($limit); $q = $qb->getQuery(); $q->setMaxResults($limit); $q->setFirstResult($offset); $results = $this->getSources($q->getArrayResult()); $paginator = new Paginator(new ArrayAdapter($results)); $paginator->setCacheEnabled(true); $paginator->setDefaultItemCountPerPage($limit); $paginator->setCurrentPageNumber($page); $paginator->setPageRange($this->paginatorRange); $ui = ['table' => ["source" => ["col" => 3, "label" => "Source", "sort" => false], "referrers" => ["col" => 6, "label" => "Referrers", "sort" => false], "count" => ["col" => 1, "label" => "# Leads", "sort" => false]]]; return ['paginator' => $paginator, 'sort' => $sort, 'order' => $order, 'page' => $page, 'pager' => $pager, 'query' => $this->params()->fromQuery(), 'ui' => $ui, 'isAdmin' => $this->isAdmin(), 'history' => $this->setHistory()]; }
public function indexAction() { /* $temp = $this->forward()->dispatch('Application/Controller/Album', array('action' => 'index')); echo '<pre>'; print_r($temp); echo '<pre>';die; */ $auth = new AuthenticationService(); if (!$auth->hasIdentity()) { return $this->redirect()->toRoute('home'); } $select = new Select(); $search = @$_REQUEST['search']; if (!empty($search)) { $select->where->like('name', '%' . $search . '%'); } $order_by = $this->params()->fromRoute('order_by') ? $this->params()->fromRoute('order_by') : 'id'; $order = $this->params()->fromRoute('order') ? $this->params()->fromRoute('order') : Select::ORDER_ASCENDING; $page = $this->params()->fromRoute('page') ? (int) $this->params()->fromRoute('page') : 1; $category = $this->getCategoryTable()->fetchAllCategory($select->order($order_by . ' ' . $order), $search); $itemPerPage = 2; $category->current(); $paginator = new Paginator(new PaginatorIterator($category)); $paginator->setCurrentPageNumber($page); $paginator->setItemCountPerPage($itemPerPage); $paginator->setPageRange(10); return new ViewModel(array('order_by' => $order_by, 'order' => $order, 'page' => $page, 'paginator' => $paginator)); }
public function indexAction() { $this->layout()->setVariable('skipWelcome', false); $paginator = new Paginator(new ArrayAdapter($this->modulesList)); $paginator->setCurrentPageNumber((int) $this->params()->fromQuery('page', 1)); $paginator->setItemCountPerPage(10); return new ViewModel(['paginator' => $paginator]); }
/** * 1 - Listar registros */ public function indexAction() { $list = $this->getEm()->getRepository($this->entity)->findAll(); $page = $this->params()->fromRoute('page'); $paginator = new Paginator(new ArrayAdapter($list)); $paginator->setCurrentPageNumber($page)->setDefaultItemCountPerPage(10); return new ViewModel(array('data' => $paginator, 'page' => $page)); }
public function listarTodosAction() { $controles = $this->getEntityManager()->getRepository('Controle\\Entity\\Controle')->findAll(); $page = (int) $this->getEvent()->getRouteMatch()->getParam('page'); $paginator = new Paginator(new ArrayAdapter($controles)); $paginator->setCurrentPageNumber($page)->setDefaultItemCountPerPage(8); return new ViewModel(array('data' => $paginator, 'page' => $page)); }
/** * Convert a paginator to array * * @param Paginator $paginator * @param string $key root key for items, leave null to return items in root * @return array */ protected function paginatorToArray(Paginator $paginator, $key = null) { $items = iterator_to_array($paginator->getCurrentItems()); if (null === $key) { return $items; } return array('pages' => $paginator->count(), 'current' => $paginator->getCurrentPageNumber(), 'count' => $paginator->getTotalItemCount(), $key => $items); }
/** * @param int $page * @param string $searchQuery * @param array $tags * @param null $orderBy * @return ShortUrl[]|Paginator */ public function listShortUrls($page = 1, $searchQuery = null, array $tags = [], $orderBy = null) { /** @var ShortUrlRepository $repo */ $repo = $this->em->getRepository(ShortUrl::class); $paginator = new Paginator(new PaginableRepositoryAdapter($repo, $searchQuery, $tags, $orderBy)); $paginator->setItemCountPerPage(PaginableRepositoryAdapter::ITEMS_PER_PAGE)->setCurrentPageNumber($page); return $paginator; }
public function _set_paginator($array, $item_per_page) { $doctrine_collection = new ArrayCollection($array); $adapter = new CollectionAdapter($doctrine_collection); $paginator = new Paginator($adapter); $paginator->setCurrentPageNumber($this->params()->fromRoute('page'))->setItemCountPerPage($item_per_page); return $paginator; }
public function indexAction() { $page = $this->params()->fromRoute('page') ? (int) $this->params()->fromRoute('page') : 1; $apps = $this->getAppTable()->fetchAll(); $paginator = new Paginator(new PaginatorIterator($apps)); $paginator->setCurrentPageNumber($page)->setItemCountPerPage($this->config['pagination']['itempage'])->setPageRange($this->config['pagination']['pagerange']); return new ViewModel(array('apps' => $paginator, 'config' => $this->config)); }
/** * Returns a paginator instance from Doctrine query * * @param mixed {Doctrine\ORM\Query, Doctrine\ORM\QueryBuilder} * @param int $page * @param int $items_per_page * @return Zend\Paginator\Paginator **/ public static function create($qb, $page = 1, $items_per_page = 10) { $dPaginator = new DoctrinePaginator($qb); $adapter = new DoctrinePaginatorAdapter($dPaginator); $zfPaginator = new ZendPaginator($adapter); $zfPaginator->setCurrentPageNumber($page); $zfPaginator->setItemCountPerPage($items_per_page); return $zfPaginator; }
public function createPaginatorFromQuery($query, $page, $limit) { $paginator = new Paginator($query); $adapter = new DoctrinePaginatorAdapter($paginator); $zendPaginator = new ZendPaginator($adapter); $zendPaginator->setCurrentPageNumber($page); $zendPaginator->setItemCountPerPage($limit); return $zendPaginator; }
public function getPagination($iPageNumber = 0, $iCountPerPage = 0, $aOptions = array()) { $paginatorAdapter = new DbSelect($this->mAuthorityTb->getSql()->select()->where($aOptions), $this->mAuthorityTb->getAdapter(), $this->mAuthorityTb->getResultSetPrototype()); $paginator = new Paginator($paginatorAdapter); $paginator->setCurrentPageNumber($iPageNumber)->setItemCountPerPage($iCountPerPage); $iTotal = $paginator->getTotalItemCount(); $aRows = $this->mCore->IteratorToArray($paginator->getCurrentItems()); return json_encode(array('rows' => $aRows, 'total' => $iTotal)); }
public function indexAction() { $em = $this->getEntityManager(); $query = $em->createQuery('SELECT p FROM ' . $this->getConfig()['entity_class'] . ' p ORDER BY p.created_at DESC, p.id DESC'); $paginator = new Paginator(new DoctrinePaginator(new ORMPaginator($query))); $paginator->setCurrentPageNumber($this->params()->fromRoute('page')); $paginator->setItemCountPerPage($this->getConfig('posts-per-page')); return array('posts' => $paginator, 'config' => $this->getConfig()); }