Help With Many-To-Many Relation

Yii 1.1 General Discussion
1

Thanks in advance.

I have a many-to-many relation with models:

Dispositivos


'localizacoes' => array(self::MANY_MANY, 'Localizacoes', 'dispositivos_local(id_dispositivos, id_local)'),

Localizacoes


 'dispositivos' => array(self::MANY_MANY, 'Dispositivos', 'dispositivos_local(id_local, id_dispositivos)'),

how can i filter cgridview of dispositivos by field of localizacoes.id_projeto


public function search()

	{

            

		// Warning: Please modify the following code to remove attributes that

		// should not be searched.


		$criteria=new CDbCriteria;

                $criteria->with=array('localizacoes');

		$criteria->compare('localizacoes.id_projeto',  Yii::app()->user->projeto,true);

		return new CActiveDataProvider($this, array(

			'criteria'=>$criteria,

		));

	}

Column not found: 1054 Unknown column ‘localizacoes.id_projeto’ in ‘where clause’

2

add




$criteria->together = true;
3

yep,thanks a lot

4

Also, be very aware of the problems with pagination in HAS_MANY and MANY_MANY relations. This page is very helpful.

5

And in cgridview


array(

        'name'=>'localizacao',

        'value'=>'$data->localizacoes->local . " ," . $data->localizacoes->distrito',

        'header'=>'Local',

),

i have

Trying to get property of non-object

6

If it’s a MANY_MANY relationship, $data->localizacoes will be an array. You would need to either iterate through all of the elements or use a specific one by index:




'value'=>'isset($data->localizacoes[0])

        ? $data->localizacoes[0]->local . " ," . $data->localizacoes[0]->distrito

        : ""',

Or a less ugly construct if you prefer…

7

thanks

8

and how to do this

How i can filter if isset($_GET(‘idlocalizacao’))?


$criteria->compare('localizacoes.id_local',  isset($_GET('idlocalizacao'))? $_GET('idlocalizacao'):NULL);

thanks again.

9

You shouldn’t be accessing $_GET in your model, that’s the job of the controller.

Read this page for information on the appropriate way to handle this.

10

But,Keith ,then i get again

Trying to get property of non-object

11

Read through the link that I gave you; you need to implement each part of that to get this to work correctly.

12

but what about the many-many relation.

Maybe need a coffee

13

The technique works fine with MANY_MANY, but you need to also take the pagination issues into account.

First, get the filter working with the help of this page.

Then, fix pagination issues with the help of this page.

The second link might also help you to understand how the filters work with MANY_MANY relations.

EDIT: Also, coffee is recommended ;)