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