Demos · Guide · Class Reference · Wiki · Extensions · Forum · Live Chat · Login

auto-count-grid-view Follow @yiiframework

License: <a target="_blank" rel="nofollow" href="http://www.opensource.org/licenses/bsd-license.php">New BSD License
Developed by: prekageo
Category: User Interface
Votes: +2
Downloaded: 406 times
Created on: Jul 21, 2011
Last updated: Jul 21, 2011
Tags: gridview

AutoCountGridView works together with AutoCountSqlDataProvider. It displays SQL tables with increased performance.

AutoCountGridView extends CGridView. It works together with AutoCountSqlDataProvider in order to browse large tables without first counting their rows, thus increasing performance.

Requirements ¶

auto count sql data provider extension

Usage ¶

$this->widget('application.extensions.AutoCountGridView', array(
    'dataProvider'=>new AutoCountSqlDataProvider(
        'tbl_user',
        new CDbCriteria(array('condition'=>'column1 is not null')),
        false,
        array(
            'sort'=>array(
                'attributes'=>array('column1','column2'),
            ),
            'pagination'=>array(
                'pageSize'=>10,
            ),
        )
    ),
    'filter'=>null,
    'columns'=>array('column1','column2'),
    'selectableRows'=>0,
    'template'=>"{summary}\n<div style='overflow:auto'>{items}</div>\n{pager}",
    'count_get_variable'=>'count',
));