diff options
Diffstat (limited to 'protected/models')
| -rw-r--r-- | protected/models/Veranstaltung.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/protected/models/Veranstaltung.php b/protected/models/Veranstaltung.php index 2b03df1..a0f1f9d 100644 --- a/protected/models/Veranstaltung.php +++ b/protected/models/Veranstaltung.php @@ -124,7 +124,8 @@ class Veranstaltung extends CActiveRecord //$criteria->compare('startzeit','> '.$nowMin); //$criteria->compare('startzeit','< '.$nowPlus); //$criteria->compare("endzeit"," <= ".$now,'AND'); - $criteria->condition = '(startzeit between SUBDATE(NOW(),INTERVAL 1 HOUR) and ADDDATE(NOW(),INTERVAL 1 HOUR) OR startzeit < NOW() and endzeit > NOW() ) and endzeit > NOW() and published = 1 order by startzeit asc'; + $criteria->condition = '(startzeit between SUBDATE(NOW(),INTERVAL 1 HOUR) and ADDDATE(NOW(),INTERVAL 1 HOUR) OR startzeit < NOW() and endzeit > NOW() ) and endzeit > NOW() and published = 1'; + $criteria->order = "startzeit ASC"; Yii::trace(print_r($criteria,true)); return new CActiveDataProvider($this, array( 'criteria'=>$criteria, |