diff options
| author | Patrick Seeger <pseeger@ccwn.org> | 2012-05-15 21:30:11 +0200 |
|---|---|---|
| committer | Patrick Seeger <pseeger@ccwn.org> | 2012-05-15 21:30:11 +0200 |
| commit | 5759435f4da8ec800ba9af0fbbf7d6691e9ed56c (patch) | |
| tree | a3e6f6c676743e89b11804a03bd4f1e837983be9 /protected/models/Veranstaltung.php | |
| parent | 94bdb31c204cdae3ca820828d4731f11f6ffeeae (diff) | |
diverse Layoutings
Diffstat (limited to '')
| -rw-r--r-- | protected/models/Veranstaltung.php | 24 |
1 files changed, 21 insertions, 3 deletions
diff --git a/protected/models/Veranstaltung.php b/protected/models/Veranstaltung.php index 0e4d9b8..2b03df1 100644 --- a/protected/models/Veranstaltung.php +++ b/protected/models/Veranstaltung.php @@ -50,8 +50,8 @@ class Veranstaltung extends CActiveRecord array('titel', 'length', 'max'=>100), array('startzeit, endzeit, beschreibung', 'safe'), array('startzeit, endzeit', 'date', 'format'=>'dd.MM.yyyy HH:mm'), - array('startzeit, endzeit', 'DateRangeValidator', 'minDate'=>Yii::app()->params['start_date'].' '.Yii::app()->params['start_time'], 'maxDate'=>Yii::app()->params['end_date'].' '.Yii::app()->params['end_time']), - array('startzeit', 'DateCompareValidator', 'compareAttribute'=>'endzeit', 'operator'=>'<'), + // array('startzeit, endzeit', 'DateRangeValidator', 'minDate'=>Yii::app()->params['start_date'].' '.Yii::app()->params['start_time'], 'maxDate'=>Yii::app()->params['end_date'].' '.Yii::app()->params['end_time']), + // array('startzeit', 'DateCompareValidator', 'compareAttribute'=>'endzeit', 'operator'=>'<'), // The following rule is used by search(). // Please remove those attributes that should not be searched. array('id, verein_id, titel, startzeit, endzeit, beschreibung, standort_id, published', 'safe', 'on'=>'search'), @@ -106,13 +106,31 @@ class Veranstaltung extends CActiveRecord $criteria->compare('endzeit',$this->endzeit,true); $criteria->compare('beschreibung',$this->beschreibung,true); $criteria->compare('standort_id',$this->standort_id); - $criteria->compare('published',$this->published); + $criteria->compare('published',true); return new CActiveDataProvider($this, array( 'criteria'=>$criteria, )); } + public function now() + { + + $criteria=new CDbCriteria; + + $nowMin = new CDbExpression('SUBDATE(NOW(),INTERVAL 1 HOUR)'); + $nowPlus= new CDbExpression('ADDDATE(NOW(),INTERVAL 1 HOUR)'); + $now = new CDbExpression("NOW()"); + //$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'; + Yii::trace(print_r($criteria,true)); + return new CActiveDataProvider($this, array( + 'criteria'=>$criteria, + )); + } + public function beforeSave() { $isValid = parent::beforeSave(); if ($isValid) { |