1. Documentation
2. view
3. controller
4. Change Log

Version 1.0.12 for yii 1.1.7

Version 1.0.10 for yii 1.1.5

Version 1.0.9 optimized for yii 1.1.4, some enh and bug fix

Version 1.0.8 optimized for yii 1.1.3, css improved, NO MORE jqGrid

Version 1.0.7 optimized for yii 1.1.2

Version 1.0.4+ only for yii 1.1.1

Extension to use CGridView, CDetailView and CLinkPager with jquery-ui theme framework.

It includes a new jqGrid wrapper based on CJuiWidget from zii.

Put it in your extensions folder and use it like normal widget. Since it isn't extended from CJuiWidget, you need to include a jquery-ui css theme in your page or, to test, simply put a zii CJuiWidget (CJuiTabs for example) before in order to auto-include a default theme.

For jqgrid you don't need to include any jquery-ui.css in the page (it uses zii jui default theme)

Tested (quickly) on FF 3.5.x, Google Chrome, IE8, IE7, IE6

Known issues:

• IE6, IE7 pager buttons spacing and dimensions are not the same as in FF

jqGrid is a bit more than a wrapper. Feel free to help me to improve it!

Documentation ¶

Requirements ¶

• Version 1.0.4+ Yii 1.1.1+
• Yii 1.1.0 or above

Installation ¶

• Extract the release file under protected/extensions

Usage ¶

See the following code example:

// use 'ext.eziiui.grid.CGridViewUI' from version 1.0.4
$this->widget('ext.eziiui.CGridViewUI', array(
    'dataProvider'=>$model,
    'columns'=>array(
        'column1',
        //......
    ),
));

$this->widget('ext.eziiui.CDetailViewUI', array(
    'data'=>$model,
    'attributes'=>array(
        'id',   
        'column1',
    ),
));

CJuiJqGrid ¶

view ¶

$this->widget('ext.eziiui.jqgrid.CJuiJqGrid', array(
    'modelClass'=>'Model', // used for columns label
    'htmlOptions'=>array(
        'id'=>'grid',
    ),
    'navbar'=>true,
    'options'=>array(
        'height'=>400,
        'autowidth'=>true,
        'datatype'=>'json',
        'url'=>Yii::app()->createUrl('index'), // ajax request for data
        'colNames'=>array('id','column1','column2'), // model attributes
//      'colModel'=>array( // optional, this is automatically generated from colNames if 'modelClass' is defined
//           array('index'=>'id','name'=>'id','hidden'=>true)
//           array('index'=>'column1','name'=>'column1')
//           array('index'=>'column2','name'=>'column2')
//      ),
        'rowNum'=>20,
        'rowList'=>array(20,50,100),
        'sortname'=>'column',
        'sortorder'=>"asc",
        'caption'=>"Grid title",
    )
)

controller ¶

if (Yii::app()->request->isAjaxRequest) {
    $criteria=new CDbCriteria;
    $page = $_GET['page'];
    $limit = $_GET['rows'];
    $sidx = $_GET['sidx']; // get index row - i.e. user click to sort
    $sord = $_GET['sord']; // get the direction
    $dataProvider = new CActiveDataProvider('Model', array(
        'criteria'=>$criteria,
        'pagination'=>array(
            'currentPage'=>$page-1, // CActiveDataProvider is zero-based, jqGrid not
            'pageSize'=>$limit,
        ),
        'sort'=>array(
            'defaultOrder'=>"$sidx $sord",
        )
    ));
    $count = $dataProvider->totalItemCount;
    $total_pages=($count) ? $total_pages = ceil($count/$limit) : $total_pages = 0;
    // prepare json data for jqGrid
    $response->page = $page;
    $response->total = $total_pages;
    $response->records = $count;
    $data=$dataProvider->getData();
    foreach($data as $row) {
        $response->rows[]=array(
 	    'id'=>$row->id,
  	    'cell'=>array(
 	        $row->column1,
                $row->column2,
                //...
            )
        );
    }
    echo CJavaScript::jsonEncode($response);
}

Have a look inside CJuiJqGrid.php for more documentation

Change Log ¶

April 28, 2011 ¶

1.0.12 ¶

Enh: update for yii-1.1.7

November 23, 2010 ¶

1.0.10 ¶

Enh: update for yii-1.1.5

November 5, 2010 ¶

1.0.9 ¶

• Enh: added UHtml (builds input fields adding ui-corner-all class automatically)
• Enh: added CActiveFormUI (same as CActiveForm but uses UHtml)
• Enh: added CCheckBoxColumnUI.php (thanks to Corey Tisdale for fixing CCheckColumn select all css error)
• Enh: CLinkPagerUI css improvements and bug fix
• Ehn: CDetailViewUI added visible property

July 29, 2010 ¶

1.0.8 ¶

• Enh: css improvements
• Enh: added visible property to CDetailViewUI
• ...: removed jqGrid... sorry but I don't use jqGrid, so I can't maintain it again.

May 3, 2010 ¶

1.0.7 ¶

• Enh: CLinkPagerUI hover effect
• Enh: css improvements
• Enh: yii-1.1.2 support

March 15, 2010 ¶

1.0.6 ¶

• Bug: CSS bug

1.0.5 ¶

• Bug: Pagination bug solved
• Enh: CGridViewUI now is derived from CBaseListUI

1.0.4 ¶

• Upd: changed path from "eziiui.widgets.CGridViewUI" to "eziiui.widgets.grid.CGridViewUI"
• Enh: yii 1.1.1 support
• Enh: minor improvements

February 1, 2010 ¶

• 1.0.3 added jqGrid wrapper based on CJuiWidget from zii
• 1.0.2 some fixes and improvements (see CHANGELOG inside).
• 1.0.1 removed filter property for 1.1.0 compatibility

January 31, 2010 ¶

• 1.0.0 Initial release.