Alphapager advanced - sjaakpriester.nl

Total 38 items.

#	Last Name	First Name	Born	Died
1	Hackman	Gene	1930/01/30	—
2	Hagen	Nina	1955/03/11	—
3	Haran	Brady	1976/06/18	—
4	Hardy	Oliver	1892/01/18	1957/08/07
5	Haring	Keith	1958/05/04	1990/02/16
6	Harrison	George	1943/02/24	2001/11/29
7	Harvey	PJ	1969/10/09	—
8	Hauer	Rutger	1944/01/23	2019/07/19
9	Havel	Václav	1936/10/05	2011/12/18
10	Hawking	Stephen	1942/01/08	2018/03/14
11	Hayes	Isaac	1942/08/20	2008/08/10
12	Heineken	Freddy	1923/11/04	2002/01/03
13	Heisenberg	Werner	1901/12/05	1976/02/01
14	Heldring	Jérôme	1917/12/21	2013/04/27
15	Helm	Levon	1940/05/26	2012/04/19
16	Hemingway	Ernest	1899/07/21	1961/07/02
17	Hendrix	Jimi	1942/11/27	1970/09/18
18	Hergé	—	1907/05/22	1983/03/03
19	Hitchcock	Alfred	1899/08/13	1980/04/28
20	Hitchens	Christopher	1949/04/13	2011/12/15
21	Hockney	David	1937/07/09	—
22	Hoffman	Dustin	1937/08/08	—
23	Hoffman	Philip Seymour	1967/07/23	2014/02/02
24	Hofstadter	Douglas	1945/02/15	—
25	Holland	Jools	1958/01/24	—
26	Holt	Simeon ten	1923/01/24	2012/11/25
27	Hooker	John Lee	1917/08/22	2001/06/21
28	Hopkins	Anthony	1937/12/31	—
29	Hopper	Dennis	1936/05/17	2010/05/29
30	Hopper	Edward	1882/07/22	1967/05/15
31	Houdini	Harry	1874/03/24	1926/10/31
32	Houellebecq	Michel	1958/02/26	—
33	Hunt	Helen	1963/06/15	—
34	Huppert	Isabelle	1953/03/16	—
35	Hütter	Ralf	1946/08/20	—
36	Huxley	Aldous	1894/07/26	1963/11/22
37	Huygens	Christiaan	1629/04/14	1695/07/08
38	Hynde	Chrissie	1951/09/07	—

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.