/** * Prepares the environment before running a test. */ protected function setUp() { parent::setUp(); $this->scrollingStyle = new \Zend\Paginator\ScrollingStyle\All(); $this->paginator = new Paginator(new ArrayAdapter(range(1, 101))); $this->paginator->setItemCountPerPage(10); }
/** * Prepares the environment before running a test. */ protected function setUp() { parent::setUp(); $this->_scrollingStyle = new \Zend\Paginator\ScrollingStyle\All(); $this->_paginator = \Zend\Paginator\Paginator::factory(range(1, 101)); $this->_paginator->setItemCountPerPage(10); }
/** * Prepares the environment before running a test. */ protected function setUp() { parent::setUp(); $this->_scrollingStyle = new \Zend\Paginator\ScrollingStyle\Jumping(); $this->_paginator = \Zend\Paginator\Paginator::factory(range(1, 101)); $this->_paginator->setItemCountPerPage(10); $this->_paginator->setPageRange(10); $this->_expectedRange = array_combine(range(1, 10), range(1, 10)); }
/** * Prepares the environment before running a test. */ protected function setUp() { parent::setUp(); $this->scrollingStyle = new \Zend\Paginator\ScrollingStyle\Jumping(); $this->paginator = new Paginator(new ArrayAdapter(range(1, 101))); $this->paginator->setItemCountPerPage(10); $this->paginator->setPageRange(10); $this->expectedRange = array_combine(range(1, 10), range(1, 10)); }
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; }
/** * 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 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)); }
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)); }
/** * 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 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 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()->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]); }
/** * Sets the number of items per page. * * @param int $itemCountPerPage * @return Paginator $this */ public function setItemCountPerPage($itemCountPerPage = -1) { $adapter = $this->getAdapter(); if ($adapter instanceof PaginatorAdapterInterface && $itemCountPerPage > 1) { $adapter->setLimit($itemCountPerPage); } return parent::setItemCountPerPage($itemCountPerPage); }
/** * @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; }
/** * The default action - show the home page */ public function fetchAll(array $filter = null) { $url = $this->options->getEndpointHost() . sprintf($this->options->getEndpointAlbums()); $albums = self::doRequest($url); $iteratorAdapter = new ArrayAdapter((array) $albums->_embedded->album); $paginator = new Paginator($iteratorAdapter); $paginator->setItemCountPerPage(25); return $paginator; }
/** * @param int $perpage * @return \Zend\Paginator\Paginator */ public function setupPaginatorItemsPerPage($perpage = null) { $this->assertPaginator(); if (!is_numeric($perpage)) { $perpage = $this->perpageDefault; } $this->paginator->setItemCountPerPage($perpage); return $this->paginator; }
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; }
/** * 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 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()); }
/** * Get the feed list and the posts of the feed we are looking at now * * @return void */ public function indexAction() { $viewData = array(); $flashMessenger = $this->flashMessenger(); $username = $this->params()->fromRoute('username'); $currentFeedId = $this->params()->fromRoute('feed_id'); $userData = ApiClient::getUser($username); if ($userData !== FALSE) { $hydrator = new ClassMethods(); $user = $hydrator->hydrate($userData, new User()); } else { $this->getResponse()->setStatusCode(404); return; } $subscribeForm = new SubscribeForm(); $unsubscribeForm = new UnsubscribeForm(); $subscribeForm->setAttribute('action', $this->url()->fromRoute('feeds-subscribe', array('username' => $username))); $unsubscribeForm->setAttribute('action', $this->url()->fromRoute('feeds-unsubscribe', array('username' => $username))); $hydrator = new ClassMethods(); $response = ApiClient::getFeeds($username); $feeds = array(); foreach ($response as $r) { $feeds[$r['id']] = $hydrator->hydrate($r, new Feed()); } if ($currentFeedId === null && !empty($feeds)) { $currentFeedId = reset($feeds)->getId(); } $feedsMenu = new Navigation(); $router = $this->getEvent()->getRouter(); $routeMatch = $this->getEvent()->getRouteMatch()->setParam('feed_id', $currentFeedId); foreach ($feeds as $f) { $feedsMenu->addPage(AbstractPage::factory(array('title' => $f->getTitle(), 'icon' => $f->getIcon(), 'route' => 'feeds', 'routeMatch' => $routeMatch, 'router' => $router, 'params' => array('username' => $username, 'feed_id' => $f->getId())))); } $currentFeed = $currentFeedId != null ? $feeds[$currentFeedId] : null; if ($currentFeed != null) { $paginator = new Paginator(new ArrayAdapter($currentFeed->getArticles())); $paginator->setItemCountPerPage(5); $paginator->setCurrentPageNumber($this->params()->fromRoute('page')); $viewData['paginator'] = $paginator; $viewData['feedId'] = $currentFeedId; } $unsubscribeForm->get('feed_id')->setValue($currentFeedId); $viewData['subscribeForm'] = $subscribeForm; $viewData['unsubscribeForm'] = $unsubscribeForm; $viewData['username'] = $username; $viewData['feedsMenu'] = $feedsMenu; $viewData['user'] = $user; $viewData['paginator'] = $paginator; $viewData['feedId'] = $currentFeedId; $viewData['feed'] = $currentFeed; $this->layout()->username = $username; if ($flashMessenger->hasMessages()) { $viewData['flashMessages'] = $flashMessenger->getMessages(); } return $viewData; }
public function fetchAll($pageNumber = 1, $countPerPage = 2) { $select = new Select(); $select->from($this->table)->order('categoria_nome'); $adapter = new DbSelect($select, $this->adapter, $this->resultSetPrototype); $paginator = new Paginator($adapter); $paginator->setCurrentPageNumber($pageNumber); $paginator->setItemCountPerPage($countPerPage); return $paginator; }
/** * Retrieve advisories. * * Returns a paginator with advisories sorted newest to oldest. * * @return Paginator */ public function getAdvisories() { if ($this->paginator instanceof Paginator) { return $this->paginator; } $paginator = new Paginator(new ArrayPaginator($this->advisories)); $paginator->setItemCountPerPage($this->pageSize); $this->paginator = $paginator; return $paginator; }
public function testCanOutputPaginator() { $paginator = new Paginator(new ArrayAdapter([1, 2, 3, 4, 5, 6])); $paginator->setItemCountPerPage(3); $paginator->setCurrentPageNumber(2); $helper = new RenderPaginator(); $result = $helper($paginator); $expected = ['limit' => 3, 'offset' => 3, 'total' => 6]; $this->assertEquals($expected, $result); }
public function fetchList($page = 1, $perPage = 15) { $select = $this->getTable()->getSql()->select(); $adapter = new DbSelect($select, $this->getTable()->getAdapter(), $this->getTable()->getResultSetPrototype()); $paginator = new Paginator($adapter); $paginator->setCurrentPageNumber($page); $paginator->setItemCountPerPage($perPage); $paginator->setPageRange(9); return $paginator; }
/** * Get user's membership connections * * @param integer $userId * @param integer $page * @param integer $perPage * @return \Zend\Paginator\Paginator */ public function getUserMembershipConnections($userId, $page = 1, $perPage = 0) { $select = $this->select(); $select->from(['a' => 'membership_level_connection'])->columns(['id', 'active', 'expire_date', 'expire_value'])->join(['b' => 'membership_level'], 'a.membership_id = b.id', ['title', 'role_id', 'cost', 'lifetime', 'expiration_notification', 'description', 'language', 'image'])->where(['user_id' => $userId])->order('a.id'); $paginator = new Paginator(new DbSelectPaginator($select, $this->adapter)); $paginator->setCurrentPageNumber($page); $paginator->setItemCountPerPage($perPage); $paginator->setPageRange(SettingService::getSetting('application_page_range')); return $paginator; }
public function fetchAll($pageNumber = 1, $itemCountPerPage = 10) { $select = new Select(); $select->from($this->table)->order("first_name"); $adapter = new DbSelect($select, $this->adapter . $this->resultSetPrototype); $paginator = new Paginator($adapter); $paginator->setCurrentPageNumber($pageNumber); $paginator->setItemCountPerPage($itemCountPerPage); return $paginator; }
/** * Get an activity paginator by the status of the activity * @param integer $status * @param integer $page * @param integer $perPage * @return Paginator */ public function getActivityPaginatorByStatus($status, $page = 1, $perPage = 5) { $qb = $this->em->createQueryBuilder(); $qb->select('a')->from('Activity\\Model\\Activity', 'a')->where('a.status = :status')->orderBy('a.beginTime', 'desc')->setParameters(['status' => $status]); $resultArray = $qb->getQuery()->getResult(); $paginator = new Paginator(new ArrayAdapter($resultArray)); $paginator->setCurrentPageNumber($page); $paginator->setItemCountPerPage($perPage); return $paginator; }
/** * Get images * * @param integer $page * @param integer $category * @param integer $perPage * @return \Zend\Paginator\Paginator */ public function getImages($page, $category, $perPage) { $select = $this->select(); $select->from('miniphotogallery_image')->columns(['name', 'description', 'image'])->order('order asc, created desc')->where(['category_id' => $category]); $paginator = new Paginator(new DbSelectPaginator($select, $this->adapter)); $paginator->setCurrentPageNumber($page); $paginator->setItemCountPerPage($perPage); $paginator->setPageRange(SettingService::getSetting('application_page_range')); return $paginator; }
/** * @param \SxBlog\Entity\Category $category * @param int $page * @param int $limit * * @return \Zend\Paginator\Paginator */ public function findByCategoryPaginated(CategoryEntity $category, $page = 1, $limit = 10) { $queryBuilder = $this->createQueryBuilder('p'); $queryBuilder->join('p.categories', 'c')->where('c = :category')->setParameter('category', $category); $ORMPaginator = new ORMPaginator($queryBuilder->getQuery(), false); $paginatorAdapter = new DoctrinePaginator($ORMPaginator); $paginator = new Paginator($paginatorAdapter); $paginator->setItemCountPerPage($limit); $paginator->setCurrentPageNumber($page); return $paginator; }
/** * @param $select * @param array $options Paginator options * @param ResultSetInterface $resultSet * @return Paginator */ public function initPaginator($select, array $options, ResultSetInterface $resultSet = null) { $paginator = new Paginator(new DbSelect($select, $this->tableGateway->getAdapter(), $resultSet)); if (isset($options['perpage'])) { $paginator->setItemCountPerPage($options['perpage']); } if (isset($options['page'])) { $paginator->setCurrentPageNumber($options['page']); } return $paginator; }