Alphapager advanced - sjaakpriester.nl

Total 33 items.

#	Last Name	First Name	Born	Died
1	Galilei	Galileo	1564/02/05	1642/01/08
2	Gambon	Michael	1940/10/19	2023/09/28
3	Gandolfini	James	1961/09/18	2013/06/19
4	Ganz	Bruno	1941/03/22	2019/02/15
5	Gardner	Martin	1914/10/21	2010/05/22
6	Gates	Bill	1955/10/28	—
7	Gaudi	Antoni	1852/06/25	1926/06/10
8	Gauss	Johann Carl Friedrich	1777/04/30	1855/02/23
9	Geesink	Anton	1934/04/06	2010/08/27
10	Gehry	Frank	1929/02/28	—
11	Genet	Jean	1910/12/19	1986/04/15
12	George	Götz	1938/07/23	2016/06/19
13	Gershwin	George	1898/09/26	1937/07/11
14	Getz	Stan	1927/02/02	1991/06/06
15	Ghandi	Mahatma	1869/10/02	1948/01/30
16	Giger	H.R.	1940/02/05	2014/05/12
17	Gilliam	Terry	1940/11/22	—
18	Gilligan	Vince	1967/02/10	—
19	Glover	Crispin	1964/04/20	—
20	Godard	Jean-Luc	1930/12/03	2022/09/13
21	Goethe	Johann Wolfgang von	1749/08/28	1832/03/22
22	Gogh	Theo van	1957/07/23	2004/11/02
23	Gogh	Vincent van	1853/03/30	1890/07/29
24	Gogol	Nikolai	1809/03/19	1852/03/04
25	Gombrowitz	Witold	1904/08/04	1969/07/24
26	Gorbatsjov	Michail	1931/03/02	2022/08/30
27	Gordon	Dexter	1923/02/23	1990/04/25
28	Goscinny	René	1926/08/14	1977/11/05
29	Gould	Stephen Jay	1941/09/10	2002/05/20
30	Grapelli	Stéphane	1908/01/26	1997/12/01
31	Grass	Günther	1927/10/16	2015/04/13
32	Groening	Matt	1954/02/15	—
33	Grunberg	Arnon	1971/02/22	—

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.