Alphapager advanced - sjaakpriester.nl

Total 28 items.

#	Last Name	First Name	Born	Died
1	Faithfull	Marianne	1946/12/29	2025/01/30
2	Falk	Peter	1927/09/16	2011/06/23
3	Faraldo	Claude	1936/03/23	2008/01/29
4	Farrell	Colin	1976/05/31	—
5	Fassbinder	Rainer Werner	1946/05/30	1982/06/10
6	Feldman	Marty	1933/07/08	1982/12/02
7	Fellini	Federico	1920/01/20	1993/10/31
8	Fender	Leo	1909/08/10	1991/03/21
9	Ferréol	Andréa	1947/01/06	—
10	Ferreri	Marco	1928/05/10	1997/05/09
11	Ferry	Bryan	1945/09/26	—
12	Fields	W.C.	1880/01/29	1946/12/25
13	Fignon	Laurent	1960/08/12	2010/08/31
14	Fimmel	Travis	1979/07/15	—
15	Fincher	David	1962/05/10	—
16	Finney	Albert	1936/05/08	2019/02/07
17	Fleming	Ian	1908/05/28	1964/08/12
18	Fo	Dario	1926/03/24	2016/10/13
19	Fogerty	John	1945/05/28	—
20	Fokker	Anthony	1890/04/06	1939/12/23
21	Franklin	Aretha	1942/03/25	2018/08/16
22	Franssens	Jean-Paul	1938/02/05	2003/06/19
23	Franzen	Jonathan	1959/08/17	—
24	Freud	Lucien	1922/12/08	2011/07/21
25	Freud	Sigmund	1856/05/06	1939/09/23
26	Frost	David	1937/04/06	2013/08/31
27	Fry	Stephen	1957/08/24	—
28	Fuller	Richard Buckminster	1895/07/12	1983/07/01

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.