Dynamically sort related AR models

Yii 1.1 General Discussion
1

I have this code in my Work class (extends CActiveRecord), with a relation to the Media class:




public function relations()

{

	return array(

		'media' => array(

		    self::MANY_MANY,

		    'Media',

		    'ass_media(work_id,media_id)', 

		    'order'=>$this->getRelatedSortOrderDetails('media') // THIS DOES NOT WORK

		),

	);

}

Of course, it does not work since ‘order’ should be static (somehow defined in the model class, before being instantiated i guess). Also using behaviors it does not work.

What is the right and cleanest way to order AR related models dynamically? Could you please post an example?

Many thanks if you could help :)

2

haven’t you read the guide ? :angry:

dynamic-relational-query-options

3

do not be too bad with me, i’m still learning Yii. ;)

yes, of course i’ve read that already. but i still cannot make it work with CActiveDataProvider:




$dataProvider = new CActiveDataProvider('Work', array(

                        'criteria' => array(

                            'condition' =>  'id=' . $model->id,

                            'limit'=>1,

                            'with'=>array(

                                    'media'=>array(

                                        'select'=>'id, title, url, mime',

					'order'=>'ass_work_media.sort_order ASC' // DOES NOT WORK

				    )

                           ),

                ),

));

i know that must be something very simple, but i do not know what is wrong… no errors though, in this case: it simply does not apply any order.

4

question: maybe the problem is that the sort order is in the associative table and not in the related model table?

the associative table has 3 columns: work_id, media_id, sort_order because i need to have manual sorting too.

5

yiqing95 put me in the right path and i could finally find a possible solution. In the controller action (for example actionView) you simply do:




public function actionView($id)

	{

		$model = $this->loadModel($id);

	    

		/**

		 * Get sort type for related models (from sort_media column).

		 */

		$sortMedia = $model->sort_media;

		

		/**

		 * Related data: media.

		 */

		$model->media = $model->media(array(

			'order'=>$model->getRelatedOrder($sortMedia),

			// getRelatedOrder() is a method i put in a behavoir

		    )

		);

		

		$this->render('view',array(

			'model'=>$model

		));

	}

Then you can access related models as usual:




$model->media;

Thank you very much for your help.