Gridview Filters

Yii 1.1 General Discussion
1

Hello Friends.

       In my app I have one alert page. That page will intimate that who are all having birthday for next 30 days. So i need to show only those rows display in my Cgridview. how can I do this???
2

Try this code




<?php

public function search_next_30_days()

{


	$criteria=new CDbCriteria;

        $next_30_days= date('Y-m-d', strtotime("+30 days"));

        $today= date('Y-m-d');

	..............

	//$criteria->compare('emp_birthday',$this->emp_birthday,true);                

        $criteria->addBetweenCondition("t.emp_birthday",$today,$next_30_days,"AND");

        ..............

	return new CActiveDataProvider($this, array(

		'criteria'=>$criteria,

	));

}

?>
3

Is this in my controller rite.

Thank you bala… and how can i use this in the filters in gridview

4

No you have to add this code in your model and call this function in gridview.

Just use ‘search_next_30_days’ function instead of ‘search’.

See the gridview code




<?php $this->widget('zii.widgets.grid.CGridView', array(

	'id'=>'emptermination-grid',

	'dataProvider'=>$model->search_next_30_days(),

	'filter'=>$model,

	'columns'=>array(

		'id',

		'employee_id',

		'emp_name',

		'emp_birthday',

		array(

			'class'=>'CButtonColumn',

		),

	),

)); ?>
5

In my model


public function search_next_30_days()

{


        $criteria=new CDbCriteria;

        $next_30_days= date('Y-m-d', strtotime("-30 days"));

        $today= date('Y-m-d');

        //$criteria->compare('emp_birthday',$this->emp_birthday,true);                

        $criteria->addBetweenCondition("maturitydate",$today,$next_30_days,"AND");

        return new CActiveDataProvider($this, array(

                'criteria'=>$criteria,

        ));

}

In my Gridview:


<?php $this->widget('zii.widgets.grid.CGridView', array(

	'id'=>'alert-fd-grid',

	'dataProvider'=>$model->search_next_30_days(),

	'filter'=>$model,

	'columns'=>array(

		'add_id',

		'code',

		'catg_id',

		'head_id',

		'shead_id',

		'fdnumber',

		'fdname',

		'startdate',

		'noofyears',

		'maturitydate',

		'amount',

		'bank',

		'branch',

		'rateofinterest',

		'interestamount',

		'interest_bank',

		'interest_branch',

		'annual',

		array(

			'class'=>'CButtonColumn',

		),

	),

));

It shows no result found… How can get sure its working or not

6

Enable the log in ‘config/main.php’ file and find the sql query to run in database.

7

Now its work bala…Thank you.