Alphapager advanced - sjaakpriester.nl

Total 28 items.

#	Last Name	First Name	Born	Died
1	Wagner	Richard	1813/05/22	1883/02/13
2	Waits	Tom	1949/12/07	—
3	Walken	Christopher	1943/03/31	—
4	Walker	Scott	1943/01/09	2019/03/25
5	Warhol	Andy	1927/08/08	1987/02/22
6	Watson	James D.	1928/04/06	2025/11/06
7	Watts	Charlie	1941/06/02	2021/08/24
8	Wayne	John	1907/05/26	1979/06/11
9	Weiss	Peter	1916/11/07	1982/05/10
10	Welles	Orson	1915/05/05	1985/10/10
11	Wells	H.G.	1866/09/21	1946/08/12
12	West	Mae	1893/08/17	1980/11/22
13	White	Tony Joe	1943/07/23	—
14	Wiesenthal	Simon	1908/12/31	2005/09/19
15	Williams	John (Edward)	1922/08/29	1994/03/03
16	Williams	Robin	1951/07/21	2014/08/11
17	Williams	Tennessee	1914/03/26	1983/02/24
18	Wilson	Brian	1942/06/20	2025/06/11
19	Wilson	E.O.	1929/06/10	2021/12/26
20	Winehouse	Amy	1983/09/14	2011/07/23
21	Wittgenstein	Ludwig	1889/04/26	1951/04/29
22	Wolinski		1934/06/28	2015/01/07
23	Womack	Bobby	1944/03/04	2014/06/27
24	Wonder	Stevie	1950/05/13	—
25	Woolf	Virginia	1882/01/25	1941/03/28
26	Wright	Richard	1943/07/28	2008/09/15
27	Wright	Will	1960/01/20	—
28	Wyatt	Robert	1945/01/28	—

Yii2 Alphapager lets you do alphabetic paging in the Yii framework 2.0. On this page it is shown with some special settings.

The relevant code involved is something like this:

<?php

use sjaakp\alphapager\ActiveDataProvider;
use sjaakp\alphapager\AlphaPager;

$query = Person::find()->orderBy('last_name, first_name');

$dataProvider = new ActiveDataProvider([
    'query' => $query,
    'alphaAttribute' => 'last_name',
    'alphaDigits' => 'compact',                // one button for digits '0' - '9'
    'alphaPages' => [
        'P' => [
               'label' => 'pq',                // label button 'P' with 'pq'
               'pattern' => [ '[PpQq]' ],      // regular expression: include words starting with 'Q' under 'P'
           ],
        'Q' => false,                          // suppress page 'Q'
        'Z' => [
               'label' => 'x-z',               // label button 'Z' with 'x-z'
               'pattern' => [ '[X-Zx-z]' ],    // regular expression: include words starting with 'X' or 'Y' under 'Z'
           ],
        'X' => false,                          // suppress page 'X'
        'Y' => false,                          // suppress page 'Y'
    ],
    'pagination' => false                      // switch off normal pagination
]);
?>

<?= AlphaPager::widget([
    'dataProvider' => $dataProvider,
    'preButtons' => [],                       // no 'all' button
    'lowerCase' => true                       // buttons in lower case
]) ?>

<?= GridView::widget([
    'dataProvider' => $dataProvider,
    'columns' => [
        ['class' => 'yii\grid\SerialColumn'],

        'last_name:ntext',
        'first_name:ntext',
        'born:date',
        'died:date',
    ],
]); ?>

A basic example is here.