diff options
| author | Patrick Seeger <pseeger@ccwn.org> | 2012-05-25 09:13:44 +0200 |
|---|---|---|
| committer | Patrick Seeger <pseeger@ccwn.org> | 2012-05-25 09:13:44 +0200 |
| commit | 9bdc1d98f91181375a6c077052db3c702a27c294 (patch) | |
| tree | 192e01303b6f883375aeb6048c83a7ad1af326fa /protected/models | |
| parent | 73cbf16f510930747aae963a863570c277332187 (diff) | |
2012 Inhalte für die Datenbank, anzeige erstmal auf cms reduziert
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, |