public function createRepresentationFromPagerfanta(Pagerfanta $pager)
{
$this->pager = empty($pager) ? $this->pager : $pager;
if (empty($this->pager)) {
return array();
}
$representation = array('hasToPaginate' => $this->pager->haveToPaginate(), 'hasNextPage' => $this->pager->hasNextPage(), 'hasPreviousPage' => $this->pager->hasPreviousPage(), 'totalItems' => $this->pager->getNbResults(), 'itemsPerPage' => $this->pager->getMaxPerPage(), 'currentPage' => $this->pager->getCurrentPage(), 'data' => $this->pager->getCurrentPageResults());
return $representation;
}
/**
* Lists all Test entities.
*
* @Route("/", name="test")
* @Template()
*/
public function indexAction()
{
$request = $this->getRequest();
$em = $this->getDoctrine()->getEntityManager();
$page = $request->query->get('page');
if (!$page) {
$page = 1;
}
$query = $em->createQueryBuilder();
$query->add('select', 't')->add('from', 'ApplicationTestBundle:Test t')->add('orderBy', 't.featured DESC, t.position ASC, t.id DESC');
$adapter = new DoctrineORMAdapter($query);
$pagerfanta = new Pagerfanta($adapter);
$pagerfanta->setMaxPerPage(10);
// 10 by default
$maxPerPage = $pagerfanta->getMaxPerPage();
$pagerfanta->setCurrentPage($page);
// 1 by default
$entities = $pagerfanta->getCurrentPageResults();
$routeGenerator = function ($page) {
$url = '?page=' . $page;
return $url;
};
$view = new DefaultView();
$html = $view->render($pagerfanta, $routeGenerator);
//$twig = $this->container->get('twig');
//$twig->addExtension(new \Twig_Extensions_Extension_Text);
return array('pager' => $html, 'entities' => $entities);
}
/**
* Paginate to the next dataset if possible
*/
protected function paginate()
{
if ($this->currentItem == $this->pagerfanta->getMaxPerPage() and $this->pagerfanta->hasNextPage()) {
$this->pagerfanta->setCurrentPage($this->pagerfanta->getNextPage());
$this->loadData();
}
}
/**
* @param Pagerfanta $pager The pager
* @param Route $route The collection's route
* @param mixed $inline Most of the time, a custom `CollectionRepresentation` instance
*
* @return PaginatedRepresentation
*/
public function createRepresentation(Pagerfanta $pager, Route $route, $inline = null)
{
if (null === $inline) {
$inline = new CollectionRepresentation($pager->getCurrentPageResults());
}
return new PaginatedRepresentation($inline, $route->getName(), $route->getParameters(), $pager->getCurrentPage(), $pager->getMaxPerPage(), $pager->getNbPages(), $this->getPageParameterName(), $this->getLimitParameterName(), $route->isAbsolute(), $pager->getNbResults());
}
/**
* @param Request $request
* @param AdapterInterface $adapter
* @param string|null $route
*
* @return PaginatedRepresentation
*/
protected function paginate(Request $request, AdapterInterface $adapter, $route = null, $routeParameters = null)
{
$pagerfanta = new Pagerfanta($adapter);
$pagerfanta->setMaxPerPage($request->query->get(self::LIMIT_PARAMETER, 5));
$pagerfanta->setCurrentPage($request->query->get(self::PAGE_PARAMETER, 1));
$collection = new CollectionRepresentation($pagerfanta->getCurrentPageResults());
$paginated = new PaginatedRepresentation($collection, $route ?? $request->get('_route'), $routeParameters ?? $request->attributes->get('_route_params'), $pagerfanta->getCurrentPage(), $pagerfanta->getMaxPerPage(), $pagerfanta->getNbPages(), self::PAGE_PARAMETER, self::LIMIT_PARAMETER, false, $pagerfanta->count());
return $paginated;
}
/**
* @param Pagerfanta $object
*
* @return PaginatedRepresentation
*/
protected function createPaginatedRepresentation($object)
{
if (!$object instanceof Pagerfanta) {
return;
}
$items = $object->getCurrentPageResults();
if ($items instanceof \ArrayIterator) {
$items = $items->getArrayCopy();
}
return new PaginatedRepresentation($items, $object->getCurrentPage(), $object->getMaxPerPage(), $object->getNbPages(), $object->getNbResults());
}
protected function addPagination(Request $request, Pagerfanta $pager, $resource)
{
$route = $request->attributes->get('_route');
$params = $request->attributes->get('_route_params');
$params = array_merge($params, $request->query->all());
$resource->setMetaValue('page', $pager->getCurrentPage());
$resource->setMetaValue('count', $pager->getNbResults());
$resource->setMetaValue('nextPage', null);
$resource->setMetaValue('previousPage', null);
$resource->setMetaValue('next', null);
$resource->setMetaValue('previous', null);
if ($pager->hasNextPage()) {
$resource->setMetaValue('next', $this->generateUrl($route, array_replace($params, ['page' => $pager->getNextPage(), 'limit' => $pager->getMaxPerPage()]), true));
$resource->setMetaValue('nextPage', $pager->getNextPage());
}
if ($pager->hasPreviousPage()) {
$resource->setMetaValue('previous', $this->generateUrl($route, array_replace($params, ['page' => $pager->getPreviousPage(), 'limit' => $pager->getMaxPerPage()]), true));
$resource->setMetaValue('previousPage', $pager->getPreviousPage());
}
}
public function testTransformPaginatedObjectCollectionReturnsCorrectArray()
{
$collection = array(new \stdClass());
$pager = new Pagerfanta(new MockPager($collection));
$pagerAdapter = new PagerfantaPaginatorAdapter($pager, function () {
return 'url';
});
$registry = new TransformerRegistry();
$transformer = new ArrayTransformer(new Manager(), $registry);
$registry->setTransformer('mock', new MockTransformer());
$data = $transformer->transformList('mock', array(new \stdClass()), array('child'), $pagerAdapter);
$this->assertEquals(array('data' => array(array('transformed' => true, 'child' => array('data' => array('transformed' => true)))), 'meta' => array('pagination' => array('total' => 1, 'count' => 1, 'per_page' => $pager->getMaxPerPage(), 'current_page' => 1, 'total_pages' => 1, 'links' => array()))), $data);
}
/**
* Lists all Project entities.
*
* @Route("/", name="project")
* @Template()
*/
public function indexAction()
{
$request = $this->getRequest();
$page = $request->query->get('page', 1);
// type?
$type = $request->query->get('t', 0);
if (!in_array($type, array(0, 1, 2))) {
return $this->redirect($this->generateUrl('project'));
}
// category_id?
$category_id = $request->query->get('c', 0);
$q = $this->getDoctrine()->getEntityManager()->getRepository('ApplicationProjectBundle:Project')->getProjectsDQL($type, $category_id);
$adapter = new DoctrineORMAdapter($q);
$pagerfanta = new Pagerfanta($adapter);
$pagerfanta->setMaxPerPage(10);
// 10 by default
$maxPerPage = $pagerfanta->getMaxPerPage();
$pagerfanta->setCurrentPage($page);
// 1 by default
$entities = $pagerfanta->getCurrentPageResults();
$routeGenerator = function ($page, $category_id, $type) {
$url = '?page=' . $page;
if ($category_id) {
$url .= '&c=' . $category_id;
}
if ($type) {
$url .= '&t=' . $type;
}
return $url;
};
$view = new DefaultView();
$html = $view->render($pagerfanta, $routeGenerator, array('category_id' => (int) $category_id, 'type' => (int) $type));
//$twig = $this->container->get('twig');
//$twig->addExtension(new \Twig_Extensions_Extension_Text);
switch ($type) {
case 0:
$page_title = 'Ideas';
break;
case 1:
$page_title = 'Beta';
break;
case 2:
$page_title = 'Startup';
break;
default:
throw $this->createNotFoundException('Unable to find Category entity.');
break;
}
return array('pager' => $html, 'entities' => $entities, 'type' => $type, 'page_title' => $page_title, 'category_id' => $category_id);
}
/**
* @param JsonApiSerializationVisitor $visitor
* @param Pagerfanta $pagerfanta
* @param array $type
* @param Context $context
* @return Pagerfanta
*/
public function serializePagerfanta(JsonApiSerializationVisitor $visitor, Pagerfanta $pagerfanta, array $type, Context $context)
{
$request = $this->requestStack->getCurrentRequest();
$pagerfanta->setNormalizeOutOfRangePages(true);
$pagerfanta->setAllowOutOfRangePages(true);
$pagerfanta->setMaxPerPage($request->get('page[limit]', $this->paginationOptions['limit'], true));
$pagerfanta->setCurrentPage($request->get('page[number]', 1, true));
$results = $pagerfanta->getCurrentPageResults();
if ($results instanceof \ArrayIterator) {
$results = $results->getArrayCopy();
}
$data = $context->accept($results);
$root = $visitor->getRoot();
$root['meta'] = array('page' => $pagerfanta->getCurrentPage(), 'limit' => $pagerfanta->getMaxPerPage(), 'pages' => $pagerfanta->getNbPages(), 'total' => $pagerfanta->getNbResults());
$root['links'] = array('first' => $this->getUriForPage(1), 'last' => $this->getUriForPage($pagerfanta->getNbPages()), 'prev' => $pagerfanta->hasPreviousPage() ? $this->getUriForPage($pagerfanta->getPreviousPage()) : null, 'next' => $pagerfanta->hasNextPage() ? $this->getUriForPage($pagerfanta->getNextPage()) : null);
$visitor->setRoot($root);
return $data;
}
private function getNavigationLinks(Pagerfanta $pager, array $params = array())
{
$page = $pager->getCurrentPage();
$limit = $pager->getMaxPerPage();
$links = [];
if ($pager->getCurrentPage() > 1) {
$links['first'] = $this->generateUrl('app_api_categories', array_merge($params, ['offset' => $this->getOffset(1, $limit)]));
}
if ($pager->hasPreviousPage()) {
$links['previous'] = $this->generateUrl('app_api_categories', array_merge($params, ['offset' => $this->getOffset($pager->getPreviousPage(), $limit)]));
}
if ($pager->hasNextPage()) {
$links['next'] = $this->generateUrl('app_api_categories', array_merge($params, ['offset' => $this->getOffset($pager->getNextPage(), $limit)]));
}
if ($pager->getNbPages() != $page) {
$links['last'] = $this->generateUrl('app_api_categories', array_merge($params, ['offset' => $this->getOffset($pager->getNbPages(), $limit)]));
}
return $links;
}
/**
* @Route("/", name = "jms_jobs_overview")
* @Template
*/
public function overviewAction()
{
$lastJobsWithError = $this->getRepo()->findLastJobsWithError(5);
$qb = $this->getEm()->createQueryBuilder();
$qb->select('j')->from('JMSJobQueueBundle:Job', 'j')->where($qb->expr()->isNull('j.originalJob'))->orderBy('j.id', 'desc');
foreach ($lastJobsWithError as $i => $job) {
$qb->andWhere($qb->expr()->neq('j.id', '?' . $i));
$qb->setParameter($i, $job->getId());
}
$pager = new Pagerfanta(new DoctrineORMAdapter($qb));
$pager->setCurrentPage(max(1, (int) $this->request->query->get('page', 1)));
$pager->setMaxPerPage(max(5, min(50, (int) $this->request->query->get('per_page', 20))));
$pagerView = new TwitterBootstrapView();
$router = $this->router;
$routeGenerator = function ($page) use($router, $pager) {
return $router->generate('jms_jobs_overview', array('page' => $page, 'per_page' => $pager->getMaxPerPage()));
};
return array('jobsWithError' => $lastJobsWithError, 'jobPager' => $pager, 'jobPagerView' => $pagerView, 'jobPagerGenerator' => $routeGenerator);
}
private function calculateNbResults($nbPages)
{
return $nbPages * $this->pagerfanta->getMaxPerPage();
}
/**
* Admin Thread entities.
*
* @Route("/admin", name="thread_admin")
* @Template()
*/
public function adminAction()
{
$session = $this->getRequest()->getSession();
if (!$session->get('admin')) {
return $this->redirect('/');
}
$request = $this->getRequest();
$page = $request->query->get('page');
if (!$page) {
$page = 1;
}
$em = $this->getDoctrine()->getEntityManager();
$query = $em->createQueryBuilder();
$query->add('select', 't')->add('from', 'ApplicationForumBundle:Thread t')->add('orderBy', 't.featured DESC, t.id DESC');
// categoria?
$category_id = $request->query->get('c');
if ($category_id) {
$query->add('where', 't.forum_id = :forum_id')->setParameter('forum_id', $category_id);
}
$adapter = new DoctrineORMAdapter($query);
$pagerfanta = new Pagerfanta($adapter);
$pagerfanta->setMaxPerPage(20);
// 10 by default
$maxPerPage = $pagerfanta->getMaxPerPage();
$pagerfanta->setCurrentPage($page);
// 1 by default
$entities = $pagerfanta->getCurrentPageResults();
$routeGenerator = function ($page, $category_id) {
$url = '?page=' . $page;
if ($category_id) {
$url .= '&c=' . $category_id;
}
return $url;
};
$view = new DefaultView();
$html = $view->render($pagerfanta, $routeGenerator, array('category_id' => (int) $category_id));
// estadisticas de anuncios
$query = "SELECT COUNT(t.id) AS total, t.forum_id, f.title FROM Thread t, Forum f WHERE t.forum_id = f.id GROUP BY f.title ORDER BY total DESC";
$db = $this->get('database_connection');
$categories = $db->fetchAll($query);
return array('categories_aux' => $categories, 'pager' => $html, 'entities' => $entities);
}
protected function configureCollectionRepresentation(CollectionRepresentation $collectionRepresentation, Pagerfanta $pager, $entity = null, $collectionRel = null)
{
// Properties
$collectionRepresentation->total = $pager->getNbResults();
$collectionRepresentation->page = $pager->getCurrentPage();
$collectionRepresentation->limit = $pager->getMaxPerPage();
// Links between pages
$createRoute = function ($page, $limit) use($entity, $collectionRel) {
$parameters = array('search' => array('page' => $page, 'limit' => $limit));
return null !== $entity && null !== $collectionRel ? $this->getUrlGenerator()->generateEntityCollectionUrl($entity, $collectionRel, $parameters) : $this->getUrlGenerator()->generateCollectionUrl($parameters);
};
$collectionRepresentation->addLink($this->atomLinkFactory->create('self', $createRoute($pager->getCurrentPage(), $pager->getMaxPerPage())));
if ($pager->hasNextPage()) {
$collectionRepresentation->addLink($this->atomLinkFactory->create('next', $createRoute($pager->getNextPage(), $pager->getMaxPerPage())));
}
if ($pager->hasPreviousPage()) {
$collectionRepresentation->addLink($this->atomLinkFactory->create('previous', $createRoute($pager->getPreviousPage(), $pager->getMaxPerPage())));
}
$collectionRepresentation->addLink($this->atomLinkFactory->create('first', $createRoute(1, $pager->getMaxPerPage())));
$collectionRepresentation->addLink($this->atomLinkFactory->create('last', $createRoute($pager->getNbPages(), $pager->getMaxPerPage())));
}
public function serializeToArray(GenericSerializationVisitor $visitor, Pagerfanta $pager, array $type, Context $context)
{
$resultsType = array('name' => 'array');
if (isset($type['params'])) {
$resultsType['params'] = $type['params'];
}
$shouldSetRoot = null === $visitor->getRoot();
$data = array('page' => $pager->getCurrentPage(), 'limit' => $pager->getMaxPerPage(), 'total' => $pager->getNbResults(), 'results' => $visitor->getNavigator()->accept($pager->getCurrentPageResults(), $resultsType, $context));
if (null !== ($links = $this->linkEventSubscriber->getOnPostSerializeData(new ObjectEvent($context, $pager, $type)))) {
$data[$this->linksJsonKey] = $links;
}
if (null !== ($relations = $this->embedderEventSubscriber->getOnPostSerializeData(new ObjectEvent($context, $pager, $type)))) {
$data[$this->relationsJsonKey] = $relations;
}
if ($shouldSetRoot) {
$visitor->setRoot($data);
}
return $data;
}
/**
* Admin Place entities.
*
* @Route("/admin", name="place_admin")
* @Template()
*/
public function adminAction()
{
$session = $this->getRequest()->getSession();
if (!$session->get('admin')) {
return $this->redirect('/');
}
$request = $this->getRequest();
$page = $request->query->get('page');
if (!$page) {
$page = 1;
}
$em = $this->getDoctrine()->getEntityManager();
$query = $em->createQueryBuilder();
$query->add('select', 'p')->add('from', 'ApplicationPlaceBundle:Place p')->add('orderBy', 'p.featured DESC, p.id DESC');
$adapter = new DoctrineORMAdapter($query);
$pagerfanta = new Pagerfanta($adapter);
$pagerfanta->setMaxPerPage(10);
// 10 by default
$maxPerPage = $pagerfanta->getMaxPerPage();
$pagerfanta->setCurrentPage($page);
// 1 by default
$entities = $pagerfanta->getCurrentPageResults();
$routeGenerator = function ($page) {
//, $category_id
$url = '?page=' . $page;
return $url;
};
$view = new DefaultView();
$html = $view->render($pagerfanta, $routeGenerator);
//, array('category_id' => (int)$category_id)
return array('pager' => $html, 'entities' => $entities);
}
/**
* @dataProvider setMaxPerPageShouldConvertStringsToIntegersProvider
*/
public function testSetMaxPerPageShouldConvertStringsToIntegers($maxPerPage)
{
$this->pagerfanta->setMaxPerPage($maxPerPage);
$this->assertSame((int) $maxPerPage, $this->pagerfanta->getMaxPerPage());
}
/**
* Finds and displays a Forum entity.
*
* @Route("/f{id}/", name="forum_show")
* @Template()
*/
public function showAction($id)
{
$request = $this->getRequest();
$em = $this->getDoctrine()->getEntityManager();
$entity = $em->getRepository('ApplicationForumBundle:Forum')->find($id);
if (!$entity) {
throw $this->createNotFoundException('Unable to find Forum entity.');
}
$page = $request->query->get('page');
if (!$page) {
$page = 1;
}
$query = $em->createQueryBuilder();
$query->add('select', 't')->add('from', 'ApplicationForumBundle:Thread t')->add('where', 't.forum_id = :forum_id')->setParameter('forum_id', $id)->add('orderBy', 't.featured DESC, t.date_update DESC');
$adapter = new DoctrineORMAdapter($query);
$pagerfanta = new Pagerfanta($adapter);
$pagerfanta->setMaxPerPage(10);
// 10 by default
$maxPerPage = $pagerfanta->getMaxPerPage();
$pagerfanta->setCurrentPage($page);
// 1 by default
$threads = $pagerfanta->getCurrentPageResults();
$routeGenerator = function ($page, $id) {
$url = '?page=' . $page;
if ($id) {
$url .= '&c=' . $id;
}
return $url;
};
$view = new DefaultView();
$html = $view->render($pagerfanta, $routeGenerator, array('category_id' => $id));
return array('entity' => $entity, 'threads' => $threads, 'pager' => $html);
}
/**
* @param Pagerfanta $pager
*
* @return array
*/
protected function getPagerMeta(Pagerfanta $pager)
{
if ($pager instanceof OutOfRangePager) {
return array('currentPage' => $pager->getOriginalPage(), 'maxPerPage' => $pager->getMaxPerPage(), 'hasNextPage' => false, 'outOfRange' => true);
}
$meta = array('currentPage' => $pager->getCurrentPage(), 'maxPerPage' => $pager->getMaxPerPage(), 'pagesCount' => $pager->getNbPages(), 'hasNextPage' => $pager->hasNextPage(), 'resultsCount' => $pager->getNbResults(), 'hasPreviousPage' => $pager->hasPreviousPage());
if ($pager->hasNextPage()) {
$meta['nextPage'] = $pager->getNextPage();
}
if ($pager->hasPreviousPage()) {
$meta['previousPage'] = $pager->getPreviousPage();
}
return $meta;
}
public function serializePagerfantaToJson(JsonSerializationVisitor $visitor, Pagerfanta $pagerfanta, array $type, Context $context)
{
$type['name'] = 'array';
return ['items' => $visitor->visitArray((array) $pagerfanta->getCurrentPageResults(), $type, $context), 'pages_count' => $pagerfanta->getNbPages(), 'current_page' => $pagerfanta->getCurrentPage(), 'max_per_page' => $pagerfanta->getMaxPerPage(), 'items_count' => $pagerfanta->count()];
}
/**
* Admin Event entities.
*
* @Route("/admin", name="event_admin")
* @Template()
*/
public function adminAction()
{
$session = $this->getRequest()->getSession();
if (!$session->get('admin')) {
return $this->redirect('/');
}
$request = $this->getRequest();
$page = $request->query->get('page');
if (!$page) {
$page = 1;
}
$em = $this->getDoctrine()->getEntityManager();
$query = $em->createQueryBuilder();
$query->add('select', 'e')->add('from', 'ApplicationEventBundle:Event e')->add('orderBy', 'e.featured DESC, e.id DESC');
$adapter = new DoctrineORMAdapter($query);
$pagerfanta = new Pagerfanta($adapter);
$pagerfanta->setMaxPerPage(10);
// 10 by default
$maxPerPage = $pagerfanta->getMaxPerPage();
$pagerfanta->setCurrentPage($page);
// 1 by default
$entities = $pagerfanta->getCurrentPageResults();
$routeGenerator = function ($page) {
//, $category_id
$url = '?page=' . $page;
//if( $category_id ) $url .= '&c=' . $category_id;
return $url;
};
$view = new DefaultView();
$html = $view->render($pagerfanta, $routeGenerator);
//, array('category_id' => (int)$category_id)
//$em = $this->getDoctrine()->getEntityManager();
//$entities = $em->getRepository('ApplicationEventBundle:Event')->findAll();
//$twig = $this->container->get('twig');
//$twig->addExtension(new \Twig_Extensions_Extension_Text);
return array('pager' => $html, 'entities' => $entities);
}
public function create(Pagerfanta $pager, $route, array $routeParameters = array())
{
return new PaginatedCollection($pager->getCurrentPageResults(), $route, $routeParameters, $pager->getCurrentPage(), $pager->getMaxPerPage(), $pager->getNbPages(), $this->pageParameterName, $this->limitParameterName);
}
/**
* Get the number per page.
*
* @return int
*/
public function getPerPage()
{
return $this->paginator->getMaxPerPage();
}
/**
* Construct a pagerfanta representation from the current request
*
* @param AdapterInterface $adapter - The adapter to use
* @return QueryablePaginatedRepresentation
*/
protected function getPagerfantaRepresentation(Request $request, AdapterInterface $adapter)
{
$pagerfanta = new Pagerfanta($adapter);
$limit = $request->query->get('limit');
$zeroLimit = false;
if (!$limit && ($limit === 0 || $limit === '0')) {
$limit = $pagerfanta->count();
$zeroLimit = true;
}
if (!$limit) {
$limit = 10;
}
$pagerfanta->setMaxPerPage($limit);
$page = $request->query->get('page');
$nbPages = $pagerfanta->getNbPages();
if (!$page) {
$page = 1;
}
// Avoid errors: redirect to max page
if ($page > $nbPages) {
$page = $nbPages;
}
$pagerfanta->setCurrentPage($page);
$route = new Route($request->get('_route'), $request->attributes->get('_route_params'), false);
return new QueryablePaginatedRepresentation(new CollectionRepresentation($pagerfanta->getCurrentPageResults()), $route->getName(), $route->getParameters(), $pagerfanta->getCurrentPage(), $zeroLimit ? 0 : $pagerfanta->getMaxPerPage(), $nbPages, $pagerfanta->count(), null, null, $route->isAbsolute(), $request->query->get('where'), $request->query->get('search'), $request->query->get('order'), null, null, null);
}
