Ordered dropDownList using relations?

Question

I have some forms in Yii using the following to get lists of data from related tables in the form of a drop down:

dropDownList(CHtml::listData(Company::model()->findAll(array('order' => 'company ASC'))));

This works, but that means for every drop down list (which theres a lot of) I'm putting this array('order' => 'company ASC' in every one.

Is this the best way to do it? Is there not a way to get this data using the model relations(), and specifying the order within the relation?

Answer 1

I believe that the correct way to do this is by using scopes.

You can define any number of scopes that order the result set and use them like so:

Company::model()->scopeName()->findAll();

If your application always requires companies to be fetched in a sorted order, you can even define a default scope in your model class:

public function defaultScope() {
    return array('order' => 'company ASC');
}

This will result in every call to Company::model()->findAll(); returning sorted results.