Skip to main content

YII CGRIDVIEW drop down filter

 <?php  
 $this->widget('zii.widgets.grid.CGridView', array(  
   'itemsCssClass' => 'table table-hover table-striped table-bordered table-condensed',  
   'id' => 'orders-grid',  
   'dataProvider' => $model->search(),  
   'filter' => $model,  
   'columns' => array(  
     'order_id',  
     'user_id',  
     array(  
       'header' => 'Product Name (QTY)',  
       'value' => 'OcProductDescription::model()->order_products("$data->offer_ids")',  
     ),  
     'offer_ids',  
     'order_total',  
     'order_status',  
     'payment_status',  
// this code below is used to create drop down filter
     array(  
       'name' => 'affiliate',  
       'value' => 'Orders::model()->getAffiliateValue($data->affiliate)',  
       'filter' => array(  
         '1' => 'ΓΑΙΤΑΝΗΣ ΒΑΣΙΛΕΙΟΣ',  
         '2' => 'ΘΕΟΔΩΡΟΣ ΚΑΜΠΟΛΗΣ',  
         '3' => 'ΑΘΗΝΑ ΦΡΑΓΚΟΥ',  
       )  
     ),  
     'order_date',  
     array(  
       'class' => 'CButtonColumn',  
     ),  
   ),  
 ));  
 ?>  

Popular posts from this blog

yii, recursive function to create category sub category hierarchy

Create this function in the category model file: ---------------------------------------------------------------------------------  <?php public function get_category_hr ( $cat_id , $selected_cat_id , $level_string ) { $select_str = '' ; if ( ! $level_string ) { $level_string = '' ; } if ( $cat_arr = $this -> findAll ( 'category_parent_id=' . $cat_id )) { foreach ( $cat_arr as $cat ) { $select_str .= "<option value= { $cat -> category_id } " ; if ( $selected_cat_id == $cat -> category_id ) $select_str .= ' selected' ; $select_str .= "> { $level_string }{ $cat -> category_name } </option>" ; $select_str .= $this -...

yii, Executing a SQL without calling a Model

yii, Executing a SQL without calling a Model <? $connection = Yii :: app () -> db ; $sql = "SELECT id,username FROM users" ; $command = $connection -> createCommand ( $sql ); $dataReader = $command -> query (); $rows = $dataReader -> readAll (); print_r ( $rows ); ?>