[/code]Hi to all...
Firstly I have a search form as shown in pic and in the same page I have cgridview to show the data ,which retrieved from search form..
In other words ,when search button in page is clicked data is retrieved and displayed in cgridview in same page...this is concept..
search form is as shown in pic and Code for cgridview in same page is as follows
[code]
$this->widget('zii.widgets.grid.CGridView', array(
'id'=>'family-record-grid',
'dataProvider'=>$dataProviderRegSum,
'enableSorting' => false,
//'enablePagination'=>false,
'itemsCssClass'=>'tabchin',
'columns'=>
array(
array('header'=>'html',
'id'=>'autoId',
'class'=>'CCheckBoxColumn',
'selectableRows' => '50',
'headerTemplate'=>'<label>Select All{item}<span></span></label>',
'value'=>'$data["familyid"].",".$data["PersonID"].",".$data["PaymentStatus"].",".$data["RegistrationStatus"].",".$data["SignUpCode"].",".$data["firstname"].",".$data["lastname"].",".$data["PaymentTxnDate"].",".$data["ChoiceCode"].",".$data["ChoiceLabel"].",".$data["ClassAssignment"]
.",".$data["CreatedDate"].",".$data["Gender"].",".$data["age"].",".$data["schoolgrade"].",".$data["primarypersonid"].",".$data["PrimaryParentFirstName"].",".$data["PrimaryParentLastName"].",".str_replace(",",":",$data["primaryEmail"])
.",".$data["SessionAssignment"].",".$data["SubClassAssignment"].",".$data["Reconcile"]',
'htmlOptions'=>array("width"=>"40px;","align"=>"center"),
),
array(
'name'=>'PaymentDate',
'header'=>'Payment Date',
'value'=>'$data["PaymentTxnDate"]',
'type'=>'raw',
'htmlOptions'=>array("width"=>"100px","align"=>"left"),
),
array(
'header'=>'Family ID',
'name'=>'RegistrationID',
'value' => 'CHtml::link($data["familyid"], Yii::app() ->createUrl("registration/familyregview",array("id"=>$data["familyid"])),array("class"=>"regfamily"))',
'htmlOptions'=>array('style'=>'width:50px;text-align:center;'),
'type' => 'raw',
),
array(
'name'=>'PersonID',
'header'=>'Person ID',
'value'=>'$data["PersonID"].CHtml::hiddenField("Reg[]",$data["PersonID"])',
'type'=>'raw',
'htmlOptions'=>array("width"=>"50px;","align"=>"left"),
),
array(
'name'=>'FirstName',
'header'=>'First Name',
'value'=>'$data["firstname"]',
'type'=>'raw',
'htmlOptions'=>array("width"=>"100px;","align"=>"left"),
),
array(
'name'=>'LastName',
'header'=>'Family Name',
'value'=>'$data["lastname"]',
'type'=>'raw',
'htmlOptions'=>array("width"=>"100px;","align"=>"left"),
),
array(
'name'=>'Gender',
'header'=>'Gender',
'value'=>'$data["Gender"]',
'type'=>'raw',
'htmlOptions'=>array("width"=>"60px;","align"=>"left"),
),
array(
'name'=>'age',
'header'=>'Age',
'value'=>'$data["age"]',
'type'=>'raw',
'htmlOptions'=>array("width"=>"50px;","align"=>"left",'title'=>'Age Calculate by Program SatrtDate'),
),
array(
'name'=>'schoolgrade',
'header'=>'School Grade',
'value'=>'$data["schoolgrade"]',
'type'=>'raw',
'htmlOptions'=>array("width"=>"100px;","align"=>"left"),
),
array(
'name'=>'primarypersonid',
'header'=>'Primary Person ID',
'value'=>'$data["primarypersonid"]',
'type'=>'raw',
'htmlOptions'=>array("width"=>"100px;","align"=>"left"),
),
array(
'name'=>'PrimaryParentFirstName',
'header'=>'Primary First Name',
'value'=>'$data["PrimaryParentFirstName"]',
'type'=>'raw',
'htmlOptions'=>array("width"=>"100px;","align"=>"left"),
),
array(
'name'=>'PrimaryParentLastName',
'header'=>'Primary Last Name',
'value'=>'$data["PrimaryParentLastName"]',
'type'=>'raw',
'htmlOptions'=>array("width"=>"100px;","align"=>"left"),
),
array(
'name'=>'primaryEmail',
'header'=>'E-Mail',
'value'=>'$data["primaryEmail"]',
'type'=>'raw',
'htmlOptions'=>array("width"=>"100px;","align"=>"left"),
),
array(
'name'=>'Reconcile',
'header'=>'Reconcile',
'value'=>'$data["Reconcile"]',
'type'=>'raw',
'htmlOptions'=>array("width"=>"40px;","align"=>"left"),
),
//primaryEmail
array(
'header'=>'Payment',
'name'=>'Payemnt',
'value' => 'CHtml::link(CHtml::image("img/payment_history.png", "Delete", array("title"=>"Payment History","style"=>"width:32px;height:32px;")),
Yii::app() ->createUrl("registration/paymentregview",array("id"=>$data["familyid"])),array("class"=>"regpay"))',
'htmlOptions'=>array('style'=>'width:50px;text-align:center;'),
'type' => 'raw',
),
array(
'name'=>'CreatedDate',
'header'=>'Date Created',
'value'=>'$data["CreatedDate"]',
'type'=>'raw',
'htmlOptions'=>array("width"=>"80px;","align"=>"left"),
),
),
));
and i have action for search button is as
$count = Yii::app()->db->createCommand('SELECT COUNT(familyid) FROM (' . $sql2 . ') as count_alias')->queryScalar();
$rawData = Yii::app()->db->createCommand($sql2);
$dataProviderRegSum = new CSqlDataProvider($rawData, array(
'keyField' => 'familyid',
//'pagination'=>false,
/* 'pagination' => array(
'pageSize' => Yii::app()->user->getState( 'pageSize', Yii::app()->params[ 'defaultPageSize' ] ),PaymentTxnDate
), */
'totalItemCount' => $count,
/* 'sort'=>array(
//'defaultOrder' => 'CreatedDate desc',
'defaultOrder' => 'PaymentTxnDate asc',
'attributes'=>array(
'RegistrationID'=>array(
'asc'=>'familyid',
'desc'=>'familyid DESC',
),
'FirstName'=>array(
'asc'=>'firstname',
'desc'=>'firstname DESC',
),
'LastName'=>array(
'asc'=>'lastname',
'desc'=>'lastname DESC',
),
'CreatedDate'=>array(
'asc'=>'CreatedDate',
'desc'=>'CreatedDate DESC',
),
'EmailedDate'=>array(
'asc'=>'EamiledDate',
'desc'=>'EamiledDate DESC',
),
),),
*/ 'pagination'=>array('pageSize'=>20)
));
here
$sql2
is my query…
the question is that…
how to render this
$dataProviderRegSum
to same search view…and display in cgridview with pagination…
please help me as i have been facing for 10 days…
please help me …urgent…