at the moment I’m working on some kind of a “news page”. Has lots of posts, which should be sorted in a special order.
There are two columns in the base table after which the entrys should be sorted.
Column "fixedUntil" contains a datetime value (nullable).
Column "timestamp" contains a timestamp value - the creationdate.
Now I want to sort the datasets as follows:
All "fixedUntil" columns != null and > actual time should be on top.
Of these fixed entrys should be the ones on top, which end to be fixed at first.
The rest of the datasets should be ordered by the timestamp (after all the fixedones), newest entries first.
Well… with the condition attribute its probably not possible. In general I would write my own function for this, but I’m wondering if there is a better solution, or if there is some kind of a “Yii-way” for this problem?
public function actionIndex() {
// Sorting News by timestamp via criteria
$criteria = new CDbCriteria(array(
'order' => 'timestamp DESC',
));
$dataProvider = new CActiveDataProvider('News', array(
'pagination' => array(
'pageSize' => Yii::app()->params['postsPerPage'],
),
'criteria' => $criteria,
'sort' => array(),
));
// Initializing the variables to temporary save the fixed and not fixed entrys
$fixedEntrys;
$notFixedEntrys;
foreach ($dataProvider->data as $news) {
// sort the datasets
if (strtotime($news->fixedBis) > time()){
$fixedEntrys[] = $news;
} else {
$notFixedEntrys[] = $news;
}
}
// save all datasets in the correct order in $allEntrys variable
$allEntrys = $fixedEntrys;
foreach ($notFixedEntrys as $entry){
$allEntrys[] = $entry;
}
// fill the $dataProvider->data Array
$dataProvider->data = $allEntrys;
$this->render('index', array(
'dataProvider' => $dataProvider,
));
}
