Note:
This bundle has been replaced by the DatathekePagerBundle
You should use it instead
The GloomyPagerBundle allows you to display data with pagination, and to easily order and filter them.
4 services are available :
- Pager lets you manipulate resources like an Array or an Entity, but you keep total control of your template.
- DataGrid allows you to render a default template. But you can of course customize each part of it. It's built on top of the Pager.
- Crud adds create/edit/delete views in addition of the DataGrid view. It's built on top of the DataGrid.
- REST Connectors let you connect to a JavaScript grid or autocompleter easily (like jqGrid, DataTables, Autocomplete, Typeahead etc...)
Features are :
- Many wrappers
Array
Entity / ORM QueryBuilder
DBAL QueryBuilder
MongoDB
Datatheke.com
Null
- Advanced filtering (AND/OR);
<?php
//...
$filters = array( 'operator' => 'and',
'criteria' => array( array( 'field' => 'job', 'operator' => 'contains', 'value' => 'Director' ),
array( 'operator' => 'or',
'criteria' => array(
array( 'field' => 'firstname', 'operator' => 'contains', 'value' => 'y' ),
array( 'field' => 'moviesNb', 'operator' => 'less', 'value' => 30 ),
)
)
)
);- Multiple ordering (order by lastname asc, firstname asc)
- Ajax compatible
- Many pagers on the same page
MIT
More exemples in the documentation
##Crud
PHP
<?php
//...
/**
* @Template()
*/
public function crudAction()
{
return $this->get('gloomy.crud')->factory('MyBundle:MyEntity')->handle();
}TWIG
{{ crud(crud) }}##Datagrid
PHP
<?php
//...
/**
* @Template()
*/
public function dataGridAction()
{
return array('datagrid' => $this->get('gloomy.datagrid')->factory('MyBundle:MyEntity'));
}TWIG
{{ datagrid(datagrid) }}##Pager
PHP
<?php
//...
/**
* @Template()
*/
public function pagerAction()
{
return array('pager' => $this->get('gloomy.pager')->factory('MyBundle:MyEntity'));
}TWIG
{% extends "::base.html.twig" %}
{% import 'GloomyPagerBundle:Pager:macros.html.twig' as helper %}
{% block stylesheets %}
{{ parent() }}
{{ helper.stylesheets() }}
{% endblock %}
{% block javascripts %}
{{ parent() }}
{{ helper.javascripts() }}
{% endblock %}
{% block body %}
<form action="{{ pager.pathForm() }}" method="post">
<table class="table table-striped table-bordered table-hover">
<thead>
<tr>
<th>{{ helper.orderBy( pager, 'firstname', 'Firstname' ) }}</th>
<th>{{ helper.orderBy( pager, 'lastname', 'Lastname' ) }}</th>
<th>{{ helper.orderBy( pager, 'job', 'Job' ) }}</th>
<th>{{ helper.orderBy( pager, 'moviesNb', 'Number of movies' ) }}</th>
</tr>
<tr>
<th>{{ helper.filter( pager, 'firstname' ) }}</th>
<th>{{ helper.filter( pager, 'lastname' ) }}</th>
<th>{{ helper.filter( pager, 'job' ) }}</th>
<th>{{ helper.filter( pager, 'moviesNb' ) }}</th>
</tr>
</thead>
<tbody>
{% for person in pager.items %}
<tr>
<td>{{ person.firstname }}</td>
<td>{{ person.lastname }}</td>
<td>{{ person.job }}</td>
<td>{{ person.moviesNb }}</td>
</tr>
{% endfor %}
</tbody>
</table>
{# Allows submitting filters with 'Enter' #}
<input type="image" src="{{ asset('bundles/gloomypager/img/transparent.gif') }}" height="0" width="0" border="0">
{{ helper.paginate( pager ) }}
</form>
{% endblock %}composer.phar require "gloomy/pager-bundle" "dev-master"
<?php
//...
$bundles = array(
//...
new Gloomy\PagerBundle\GloomyPagerBundle(),
);php app/console assets:install web --symlink
