TYPO3 Formidable - PasteBin

Ajax pager datasource:DB

Permalink to this snippet:

http://formidable.typo3.ug/pastebin/snippet/111.html

The authors comment:

An evolution of the ajax pager at snippet 107.

Manuel Rego, 2010-06-08@13:49:07, pasted:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<formidable version="1.0.0">

<datasources>
                        <datasource:DB name="news">
                                <fields>uid, title</fields>
                                <table>tt_news</table>
                                <enablefields>true</enablefields>
                                <beforeSqlExec>
                                        <userobj>
                                                <php><![CDATA[
                                                        $info = func_get_arg(1);
                                                        $sql = $info['sql'];

$total = $this->oSandBox->sbNumRows;
                                                        $perpage = $this->oSandBox->sbPerpage ? $this->oSandBox->sbPerpage : 5;
                                                        $from = $this->oSandBox->sbPage * $perpage;

$this->oSandBox->sbNumpages = ceil($total / $perpage);

$sql = str_replace('LIMIT 0, 1000000', "LIMIT $from, $perpage", $sql);
                                                        return ($sql);
                                                ]]></php>
                                        </userobj>
                                </beforeSqlExec>
                        </datasource:DB>

<datasource:PHPARRAY name="pages">
                                <bindsto>
                                        <userobj>
                                                <php><![CDATA[
                                                        $pages = array();
                                                        if ($this->oSandBox->sbPage > 0) {
                                                                $pages[] = array (
                                                                        'uid' => 'PREVIOUS',
                                                                        'label' => 'Prev',
                                                                        );
                                                                $pages[] = array (
                                                                        'uid' => 'FIRST',
                                                                        'label' => 'First',
                                                                        );
                                                        }

$page = $this->oSandBox->sbPage;
                                                        $window = $this->oSandBox->sbWindow;
                                                        $from = $page - $window;
                                                        if ($from > 0) {
                                                                $pages[] = array (
                                                                        'uid' => '',
                                                                        'label' => '...',
                                                                        );
                                                        } else {
                                                                $from = 0;
                                                        }
                                                        $to = $page + $window;
                                                        if ($to > ($this->oSandBox->sbNumpages - 1)) {
                                                                $to = $this->oSandBox->sbNumpages - 1;
                                                        }

for ($i = $from; $i <= $to; $i++) {
                                                                $label = $i + 1;
                                                                $pages[] = array (
                                                                        'uid' => $i,
                                                                        'label' => $label,
                                                                        );
                                                        }

if ($to < ($this->oSandBox->sbNumpages - 1)) {
                                                                $pages[] = array (
                                                                        'uid' => '',
                                                                        'label' => '...',
                                                                        );
                                                        }
                                                        if ($this->oSandBox->sbPage < ($this->oSandBox->sbNumpages - 1)) {
                                                                $pages[] = array (
                                                                        'uid' => 'LAST',
                                                                        'label' => 'Last',
                                                                        );
                                                                $pages[] = array (
                                                                        'uid' => 'NEXT',
                                                                        'label' => 'Next',
                                                                        );
                                                        }
                                                        return $pages;
                                                ]]></php>
                                        </userobj>
                                </bindsto>
                        </datasource:PHPARRAY>

</datasources>

</control>

<renderlet:LISTER name="pager">
                        <datasource use="pages" />
                        <columns>
                                <column name="my" type="TEXT">
                                        <data>
                                                <value>
                                                        <userobj>
                                                                <php><![CDATA[
                                                                        $row = $this->oDataHandler->_getListData();
                                                                        if ($row['uid'] === $this->oSandBox->sbPage) {
                                                                                $row['label'] = '<strong>' . $row['label'] . '</strong>';
                                                                        } else {
                                                                                if ($row['uid'] !== '') {
                                                                                        $row['label'] = '<u>' . $row['label'] . '</u>';
                                                                                }
                                                                        }
                                                                        return $row['label'];
                                                                ]]></php>
                                                        </userobj>
                                                </value>
                                        </data>
                                        <onclick runat="ajax" cache="false" params="rowData::uid">
                                                <userobj>
                                                        <php><![CDATA[
                                                                $aParams = func_get_arg(1);
                                                                $uid = $aParams['uid'];
                                                                switch ($uid) {
                                                                        case 'PREVIOUS':
                                                                                $this->oSandBox->sbPage--;
                                                                                break;
                                                                        case 'NEXT':
                                                                                $this->oSandBox->sbPage++;
                                                                                break;
                                                                        case 'FIRST':
                                                                                $this->oSandBox->sbPage = 0;
                                                                                break;
                                                                        case 'LAST':
                                                                                $this->oSandBox->sbPage = $this->oSandBox->sbNumpages - 1;
                                                                                break;
                                                                        default:
                                                                                $this->oSandBox->sbPage = $uid;
                                                                }
                                                                return array(
                                                                        $this->aORenderlets["mylist"]->majixRepaint(),
                                                                        $this->aORenderlets["pager"]->majixRepaint(),
                                                                );
                                                        ]]></php>
                                                </userobj>
                                        </onclick>
                                </column>
                        </columns>
                        <pager>
                                <rows>
                                        <perpage>-1</perpage>
                                </rows>
                        </pager>
                </renderlet:LISTER>

</elements>

</formidable>

Ajax pager datasource:DB

Download

Features

Documentation

Many thanks to

Latest snippets