Alphapager advanced - sjaakpriester.nl

Total 52 items.

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