Alphapager advanced - sjaakpriester.nl

Total 48 items.

#	Last Name	First Name	Born	Died
1	Calatrava	Santiago	1951/07/28	—
2	Calder	Alexander	1898/07/26	1976/11/11
3	Cale	J.J.	1938/12/05	2013/07/27
4	Cale	John	1942/03/09	—
5	Camus	Albert	1913/11/07	1960/01/04
6	Canetti	Elias	1905/07/25	1994/08/14
7	Capote	Truman	1924/09/30	1984/08/25
8	Carroll	Lewis	1832/01/27	1898/01/14
9	Cartier-Bresson	Henri	1908/08/22	2004/08/02
10	Cash	Johnny	1932/02/26	2003/09/12
11	Casimir	Hendrik	1909/07/15	2000/05/04
12	Cassidy	Eva	1963/02/02	1996/11/02
13	Castellanata	Dan	1957/10/29	—
14	Cave	Nick	1957/09/22	—
15	Céline	Louis-Ferdinand	1894/05/27	1961/07/02
16	Chaplin	Charles	1889/04/16	1977/12/25
17	Chapman	Graham	1941/01/08	1989/10/04
18	Charles	Ray	1930/09/23	2004/06/10
19	Chomsky	Noam	1928/12/07	—
20	Christo		1935/06/13	2020/05/31
21	Chubby	Popa	1960/03/31	—
22	Cleese	John	1939/10/27	—
23	Clinton	Bill	1946/08/19	—
24	Cocker	Joe	1944/05/20	2014/12/22
25	Coetzee	J.M.	1940/02/09	—
26	Cohen	Leonard	1934/09/21	2016/11/07
27	Cohn-Bendit	Daniel	1945/04/04	—
28	Coltrane	John	1926/09/23	1967/07/17
29	Connery	Sean	1930/08/25	2020/10/31
30	Conway	John	1937/12/26	2020/04/11
31	Cooder	Ry	1947/03/15	—
32	Copernicus	Nicolaus	1473/02/10	1543/05/14
33	Coppola	Francis Ford	1939/04/07	—
34	Corbusier	Le	1887/10/06	1965/08/27
35	Corea	Chick	1941/06/12	2021/02/09
36	Costello	Elvis	1954/08/25	—
37	Coupland	Douglas	1961/12/30	—
38	Coward	Noël	1899/12/16	1973/03/26
39	Coyne	Kevin	1944/01/27	2004/12/02
40	Cranston	Bryan	1956/03/07	—
41	Crichton	Michael	1942/10/23	2008/11/04
42	Crick	Francis	1916/06/08	2004/07/29
43	Cronkite	Walter	1916/11/04	2009/07/17
44	Crosby	David	1941/08/14	2023/01/18
45	Cruijff	Johan	1947/04/25	2016/03/24
46	Crumb	Robert	1943/08/30	—
47	cummings	e.e.	1894/10/14	1962/09/03
48	Curtis	Ian	1956/07/15	1980/05/18

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.