[cesarc]

Hi
I want to pass the order from cgridview in admin view, that was seted clicking in title column, to another view

array('label'=>Yii::t('app','Report'), 'url'=>array('report','orderto'=>$orderto)),

How to get the value to pass in var $orderto ?


Thanks.

[seenivasan]

Dear Friend

We can make the all the GET parameters stateful by storing them in session.

Then we can make use of it at any place.

I have a model Post.

PostController.php

public function actionAdmin()
	{
		$model=new Post('search');
		$model->unsetAttributes(); 
		if(isset($_GET['Post'])){
			$model->attributes=$_GET['Post'];
			
		}
		Yii::app()->user->setState("grid",$_GET);//storing all the GET parameters in session.
		
		$this->render('admin',array(
			'model'=>$model,
		));
	}

//For an example ,Now we can make use of it in actionIndex


public function actionIndex()
	{   $sort="";
		if(Yii::app()->user->hasState("grid"))
		{
				$grid=Yii::app()->user->getState('grid');
				if(isset($grid["Post_sort"]))
				{
					$sort=$grid['Post_sort'];
					$dot=strpos($sort,'.');
					if($dot>0)
					{
						$prop=substr($sort,0,$dot);
						$order=substr($sort,$dot+1);
						$order=strtoupper($order);
						$sort=$prop." ".$order;
					}
				}
				Yii::app()->user->setState('grid',null);
	    }
	    
		$dataProvider=new CActiveDataProvider('Post',array(
			'sort'=>array('defaultOrder'=>$sort),
		));
		$this->render('index',array(
			'dataProvider'=>$dataProvider,
			
		));
	}

Rather than strong in session, if you want a link with get parameter the following can be done.

You have to declare beforeAjaxUpdate property in CGridView.

<?php $this->widget('zii.widgets.grid.CGridView', array(
	'id'=>'post-grid',
	'dataProvider'=>$model->search(),
	'filter'=>$model,
	'beforeAjaxUpdate'=>'js:function(id,options)
          {
		var url=options.url;
		var arr=url.split("&");
		arr.shift();
		var params={};
	        for each(var e in arr)
	        {
	           var el=e.split("=");
	           params[el[0]]=el[1];
	        }
	        $("#link").attr("href","index.php?r=post/index"+"&"+params.Post_sort);
	   }',
	'columns'=>array(
		'id',
		'title',
		'created',
...............................................................................
..............................................................................

Then we have to add a link in following way.

echo CHtml::link("index","#",array('id'=>'link'));

I hope I helped a bit.

[cesarc]

Thanks very much seenivasan!

I copy and paste your reply and it work! I still don't understand how
I implemented the first solution.

My controller

public function actionAdmin()
	{
		$model=new Peliculas('search');
		$model->unsetAttributes();  // clear any default values
		if(isset($_GET['Peliculas']))
			$model->attributes=$_GET['Peliculas'];
		Yii::app()->user->setState("grid",$_GET);//storing all the GET parameters in session.
		$this->render('admin',array(
			'model'=>$model,
		));
	}

My view

if(Yii::app()->user->hasState("grid"))
{
	$grid=Yii::app()->user->getState('grid');
	if(isset($grid["Peliculas_sort"]))
	{
		$sort=$grid['Peliculas_sort'];
		$dot=strpos($sort,'.');
		if($dot>0)
		{
				$prop=substr($sort,0,$dot);
				$order=substr($sort,$dot+1);
				$order=strtoupper($order);
				$sort=$prop." ".$order;
		}
	}
	Yii::app()->user->setState('grid',null);
}
            

$criteria= $_SESSION['filtro'];
$criteria->order = $sort;
$dataProvider=new CActiveDataProvider('Peliculas', array(
    'criteria'=>$criteria,
    'pagination'=>false,
));
$data=$dataProvider->getData();
...

My model, search() function:

public function search()
	{
		// Warning: Please modify the following code to remove attributes that
		// should not be searched.

		$criteria=new CDbCriteria;

		$criteria->compare('id',trim($this->id));
		$criteria->compare('lower(catalogo)',strtolower($this->catalogo),true);
		$criteria->compare('id_pelicula',trim($this->id_pelicula));
		$criteria->compare('lower(titulo)',strtolower($this->titulo),true);
		$criteria->compare('lower(actores)',strtolower($this->actores),true);
		$criteria->compare('lower(director)',strtolower($this->director),true);
		
		$_SESSION['filtro']=$criteria;
		
		return new CActiveDataProvider($this, array(
			'criteria'=>$criteria,
		));
	}