zikula/sortable-columns

This package is abandoned and no longer maintained. No replacement package was suggested.

SortableColumns is a zikula component to help manage data table column headings that can be clicked to sort the data

1.0.0 2020-01-21 22:10 UTC

This package is auto-updated.

Last update: 2022-09-18 10:02:31 UTC


README

SortableColumns has been included into the core repository.

SortableColumns

SortableColumns is a Zikula component to help manage data table column headings that can be clicked to sort the data. The collection is an Doctrine\Common\Collections\ArrayCollection of Zikula\Component\SortableColumns\Column objects. Use SortableColumns::generateSortableColumns to create an array of attributes (url, css class) indexed by column name which can be used in the generation of table headings/links.

Controller:

use Zikula\Component\SortableColumns\SortableColumns;

// in controller method
$orderBy = $request->query->get('orderby', 'pageid');
$currentSortDirection = $request->query->get('sdir', Column::DIRECTION_DESCENDING);

$sortableColumns = new SortableColumns($this->get('router'), 'zikulapagesmodule_admin_index', 'orderby', 'sdir');
$sortableColumns->addColumn(new Column('pageid')); // first added is automatically the default
$sortableColumns->addColumn(new Column('title'));
$sortableColumns->addColumn(new Column('cr_date'));
$sortableColumns->setOrderBy($sortableColumns->getColumn($orderBy), $currentSortDirection);
$sortableColumns->setAdditionalUrlParameters(array(
    'language' => isset($filterData['language']) ? $filterData['language'] : null,
));

$templateParameters['sort'] = $sortableColumns->generateSortableColumns();

Twig template:

<tr>
    <th><a class='{{ sort.pageid.class }}' href='{{ sort.pageid.url }}'>{% trans %}ID{% endtrans %}</a></th>
    <th><a class='{{ sort.title.class }}' href='{{ sort.title.url }}'>{% trans %}Title{% endtrans %}</a></th>
    <th><a class='{{ sort.cr_date.class }}' href='{{ sort.cr_date.url }}'>{% trans %}Created{% endtrans %}</a></th>
</tr>

Additional shortcut methods are available:

  • $sortableColumns->addColumns()
  • $sortableColumns->setOrderByFromRequest()
$sortableColumns->addColumns([new Column('pageid'), new Column('title'), new Column('cr_date')]);
$sortableColumns->setOrderByFromRequest($request);

If needed, you can obtain the values of the orderByFields (e.g. for a DB query) using:

$sortableColumns->getSortColumn()->getName()
$sortableColumns->getSortDirection()