with condition in findall() or DataProvider

Yii 1.1 General Discussion
1

I am trying to build a dataprovider for a grid view. I have tried to use CActiveDataProvider, but I cant find a way to use a ‘with’ in the condition. In another forum i found the following solution.

$quotes = someModel::Model()->with(‘projectR’)->findall(array(‘condition’=>‘quoteId = ‘.$findQ.’ OR name LIKE %’.$findQ.’% AND projectR->owner=’.$user.’’,‘pagination’=>false));

basically with this, i am passing a project list. but i only want to pass projects that belong to the owner of the project. Is there a better way using CActiveDataProvider? or is the above solution close to what i should be doing? Thanks in advance for any help.

2

Look at this example:

http://yiiplayground.com/index.php?r=UiModule/dataview/gridView

Next, I’ll show you a piece of code that I wrote in the past for one of my projects, in which I use a with:

Post.php


	public function search()

	{

		$criteria=new CDbCriteria;

		$criteria->alias='p';

		$criteria->with = array('category'=>array('alias'=>'c'), 'user'=>array('alias'=>'u'));

		$criteria->compare('p.id',$this->id);

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

		$criteria->compare('c.name', $this->category_id,true);

		$criteria->compare('p.language',$this->language);

		$criteria->compare('p.status',$this->status);

		$criteria->compare('u.username',$this->user_id, true);

		

		return new CActiveDataProvider('Post', array(

			'criteria'=>$criteria,

			'sort'=>array(

				'defaultOrder'=>'p.id DESC, p.language ASC',

			),

			'pagination'=>array(

				'pageSize'=>Parameter::getValue(<img src='http://www.yiiframework.com/forum/public/style_emoticons/default/cool.gif' class='bbc_emoticon' alt='8)' />,

			),

		));

	}
3

Thank you! This was exactly what i was looking for. You got me on the right track, and it works great.