Alphapager advanced - sjaakpriester.nl

Total 52 items.

#	Last Name	First Name	Born	Died
1	Sacharov	Andrej	1921/05/21	1989/12/14
2	Sacks	Oliver	1933/07/09	2015/08/30
3	Sagan	Carl	1934/11/09	1996/12/20
4	Sagan	Françoise	1935/06/21	2004/09/24
5	Saint Phalle	Niki de	1930/10/29	2002/05/21
6	Salter	James	1925/06/10	2015/06/19
7	Santana	Carlos	1947/07/20	—
8	Sartre	Jean-Paul	1905/06/21	1980/04/15
9	Satie	Erik	1866/05/17	1925/07/01
10	Schiele	Egon	1890/06/12	1918/10/31
11	Schneider	Florian	1947/04/07	2020/04/21
12	Schneider	Maria	1952/03/27	2011/02/03
13	Schneider	Romy	1938/09/23	1982/05/29
14	Schulz	Charles M.	1922/11/26	2000/02/12
15	Schwarzenegger	Arnold	1947/07/30	—
16	Schwitters	Kurt	1887/06/20	1948/01/08
17	Schygulla	Hanna	1943/12/25	—
18	Scola	Ettore	1931/05/10	2016/01/19
19	Scorcese	Martin	1942/11/17	—
20	Scott	Ridley	1937/11/30	—
21	Seeger	Pete	1919/05/03	2014/01/27
22	Shakespeare	William	1564/04/13	1616/04/23
23	Shteyngart	Gary	1972/07/05	—
24	Simenon	Georges	1903/02/13	1989/09/04
25	Simon	Paul	1941/10/13	—
26	Simone	Nina	1933/02/21	2003/04/20
27	Sinatra	Frank	1915/12/12	1998/05/14
28	Slick	Grace	1939/10/30	—
29	Smith	Patti	1946/12/30	—
30	Snowden	Edward	1983/06/21	—
31	Solondz	Todd	1959/10/15	—
32	Spacey	Kevin	1959/07/26	—
33	Spence	Joseph	1910/08/03	1984/03/18
34	Spielberg	Steven	1946/12/18	—
35	Spinoza	Baruch	1632/11/24	1677/02/21
36	Springfield	Dusty	1939/04/16	1999/03/02
37	Springsteen	Bruce	1949/09/23	—
38	Starr	Ringo	1940/07/07	—
39	Stein	Gertrude	1874/02/03	1946/07/27
40	Stephenson	Neal	1959/10/31	—
41	Stevenson	Robert Louis	1850/11/13	1894/12/03
42	Stewart	Patrick	1940/07/13	—
43	Sting	—	1951/10/02	—
44	Stipe	Michael	1960/01/04	—
45	Stone	Matt	1971/05/27	—
46	Stone	Oliver	1946/09/15	—
47	Strawinsky	Igor	1882/06/17	1971/04/06
48	Stroustrup	Bjarne	1950/12/30	—
49	Sutherland	Donald	1935/07/17	—
50	Sutherland	Kiefer	1966/12/21	—
51	Sydow	Max von	1929/04/10	2020/03/08
52	Szabó	István	1938/02/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.