Alphapager advanced - sjaakpriester.nl

Total 26 items.

#	Last Name	First Name	Born	Died
1	Laan	Eberhard van der	1955/06/28	2017/10/05
2	Lamarr	Hedy	1914/11/08	2000/01/19
3	Lang	Fritz	1890/12/05	1976/08/02
4	Lartigue	Jacques-Henri	1894/06/13	1986/09/12
5	Laurel	Stan	1890/06/16	1965/02/23
6	Lee	Christopher	1922/05/27	2015/06/07
7	Lee	Peggy	1920/05/26	2002/01/21
8	Leeuwenhoek	Antoni van	1632/10/24	1723/08/26
9	Lehrer	Tom	1928/04/09	2025/07/26
10	Lennon	John	1940/10/09	1980/12/08
11	Lennox	Annie	1964/12/25	—
12	Leone	Sergio	1929/01/03	1989/04/30
13	Lichtenstein	Roy	1923/10/27	1997/09/29
14	Ligeti	György	1923/05/27	2006/06/12
15	Lindemann	Till	1963/01/04	—
16	Littell	Jonathan	1967/10/10	—
17	Little Richard		1932/12/05	2020/05/09
18	Lollobrigida	Gina	1927/07/04	2023/01/16
19	Lord	Jon	1941/06/09	2012/07/16
20	Loren	Sophia	1934/09/20	—
21	Lovecraft	H.P.	1890/08/20	1937/03/15
22	Lovelace	Ada	1815/12/10	1852/11/27
23	Lovelace	Linda	1949/01/10	2002/04/22
24	Lovelock	James	1919/07/26	2022/07/26
25	Lowry	Malcolm	1909/07/28	1957/06/27
26	Lynch	David	1946/01/20	2025/01/15

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.