Alphapager advanced - sjaakpriester.nl

Total 52 items.

#	Last Name	First Name	Born	Died
1	Ma	Yo-Yo	1955/10/07	—
2	MacFarlane	Seth	1973/10/26	—
3	MacKay	George	1992/03/13	—
4	Macnee	Patrick	1922/02/06	2015/06/25
5	Madonna		1959/08/16	—
6	Mailer	Norman	1923/01/31	2007/11/10
7	Malevitsj	Kazimir	1878/02/23	1935/05/15
8	Malkovich	John	1953/12/09	—
9	Mandela	Nelson	1918/07/18	2013/12/05
10	Mandelbrot	Benoît	1924/11/20	2010/10/14
11	Mann	Thomas	1875/06/06	1955/08/12
12	Manzarek	Ray	1939/02/12	2013/05/20
13	Marley	Bob	1945/02/06	1981/05/11
14	Márquez	Gabriel García	1927/03/06	2014/04/17
15	Martin	Don	1931/05/18	2000/01/06
16	Martin	George	1926/01/03	2016/03/08
17	Marx	Groucho	1895/10/02	1977/08/18
18	Mastroianni	Marcello	1923/09/28	1996/12/19
19	Mata Hari		1876/08/07	1917/10/15
20	Matisse	Henri	1869/12/31	1954/11/03
21	Mayall	Rik	1958/03/07	2014/06/09
22	McCarthy	Cormac	1933/07/20	2023/06/13
23	McCartney	Paul	1942/06/18	—
24	McEwan	Ian	1948/06/21	—
25	McLaren	Malcolm	1946/01/22	2010/04/08
26	Meier	Dieter	1945/03/04	—
27	Meijer	Ischa	1943/02/14	1995/02/14
28	Melville	Herman	1819/08/19	1891/09/28
29	Mendelejev	Dmitri	1834/02/08	1907/02/02
30	Mendes	Sam	1965/08/01	—
31	Menuhin	Yehudi	1916/04/22	1999/03/12
32	Mercury	Freddy	1946/09/05	1991/11/24
33	Miller	Arthur	1915/10/17	2005/02/10
34	Miller	Henry	1891/12/26	1980/06/17
35	Mitchell	David	1969/01/12	—
36	Mondriaan	Piet	1872/03/07	1944/02/01
37	Monk	Thelonious	1917/10/10	1982/02/17
38	Monroe	Marilyn	1926/06/01	1962/08/05
39	Moog	Robert	1934/05/23	2005/08/21
40	Moon	Keith	1946/08/23	1978/09/07
41	Moore	Henry	1898/07/30	1981/08/31
42	Moore	Patrick	1923/03/04	2012/12/09
43	Moore	Roger	1927/10/14	2017/05/23
44	Moravia	Alberto	1907/11/28	1990/09/26
45	Morricone	Ennio	1928/11/10	2020/07/06
46	Morrison	Jim	1943/12/08	1971/07/03
47	Morrison	Van	1945/08/31	—
48	Mozart	Wolfgang Amadeus	1756/01/27	1791/12/05
49	Murakami	Haruki	1949/01/12	—
50	Murphy	Cillian	1976/05/25	—
51	Musil	Robert	1880/11/06	1942/04/15
52	Muybridge	Eadweard	1830/04/09	1904/05/08

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.