Alphapager advanced - sjaakpriester.nl

Total 53 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/14
8	Malkovich	John	1953/12/09	—
9	Mandela	Nelson	1918/07/17	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/14
20	Matisse	Henri	1869/12/31	1954/11/03
21	Mayall	John	1933/11/29	2024/07/22
22	Mayall	Rik	1958/03/07	2014/06/09
23	McCarthy	Cormac	1933/07/20	2023/06/13
24	McCartney	Paul	1942/06/18	—
25	McEwan	Ian	1948/06/21	—
26	McLaren	Malcolm	1946/01/22	2010/04/08
27	Meier	Dieter	1945/03/04	—
28	Meijer	Ischa	1943/02/14	1995/02/14
29	Melville	Herman	1819/08/19	1891/09/28
30	Mendelejev	Dmitri	1834/02/08	1907/02/02
31	Mendes	Sam	1965/08/01	—
32	Menuhin	Yehudi	1916/04/21	1999/03/12
33	Mercury	Freddy	1946/09/04	1991/11/24
34	Miller	Arthur	1915/10/16	2005/02/10
35	Miller	Henry	1891/12/26	1980/06/17
36	Mitchell	David	1969/01/12	—
37	Mondriaan	Piet	1872/03/07	1944/02/01
38	Monk	Thelonious	1917/10/09	1982/02/17
39	Monroe	Marilyn	1926/06/01	1962/08/05
40	Moog	Robert	1934/05/23	2005/08/21
41	Moon	Keith	1946/08/22	1978/09/07
42	Moore	Henry	1898/07/30	1981/08/31
43	Moore	Patrick	1923/03/04	2012/12/09
44	Moore	Roger	1927/10/14	2017/05/23
45	Moravia	Alberto	1907/11/28	1990/09/26
46	Morricone	Ennio	1928/11/10	2020/07/06
47	Morrison	Jim	1943/12/08	1971/07/03
48	Morrison	Van	1945/08/31	—
49	Mozart	Wolfgang Amadeus	1756/01/27	1791/12/05
50	Murakami	Haruki	1949/01/12	—
51	Murphy	Cillian	1976/05/25	—
52	Musil	Robert	1880/11/06	1942/04/15
53	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.