/** * Retrieves a list of models based on the current search/filter conditions. * * Typical usecase: * - Initialize the model fields with values from filter form. * - Execute this method to get CActiveDataProvider instance which will filter * models according to data in model fields. * - Pass data provider to CGridView, CListView or any similar widget. * * @return CActiveDataProvider the data provider that can return the models * based on the search/filter conditions. */ public function search() { // @todo Please modify the following code to remove attributes that should not be searched. $criteria = new CDbCriteria(); if (isset($_GET["Audit"])) { $dH = new DateTimeHelper(); $dtFrom = $dH->getDateTimeFromUI($_GET["Audit"]["dateTimeFrom"]); $dtTo = $dH->getDateTimeFromUI($_GET["Audit"]["dateTimeTo"]); if ($desde !== false) { $criteria->addCondition('date_time >= ' . $dtFrom->getTimestamp()); } else { $criteria->addCondition('date_time >= ' . $dH->getDefaultStartRangeFilter("")->getTimestamp()); } if ($hasta !== false) { $criteria->addCondition('date_time <= ' . $dtTo->getTimestamp()); } else { $criteria->addCondition('date_time <= ' . $dH->getDefaultEndRangeFilter("audit")->getTimestamp()); } } $criteria->compare('object', $this->object, true); $criteria->compare('operation', $this->operation, true); $criteria->compare('description', $this->description, true); $criteria->compare('user', $this->user, true); return new CActiveDataProvider($this, array('criteria' => $criteria)); }
/** * Manages all models. */ public function actionAdmin() { $model = new Audit('search'); $model->unsetAttributes(); if (isset($_GET['Audit'])) { $model->attributes = $_GET['Audit']; } $dH = new DateTimeHelper(); if (isset($_GET["Audit"]["dateTimeFrom"]) && strcmp($_GET["Audit"]["dateTimeFrom"], "") !== 0) { $model->dateTimeFrom = $_GET["Audit"]["dateTimeFrom"]; } else { $model->dateTimeFrom = $dH->getDefaultStartRangeFilter("")->format(Yii::app()->params["dateTimeDisplayFormat"]); } if (isset($_GET["Audit"]["dateTimeTo"]) && strcmp($_GET["Audit"]["dateTimeTo"], "") !== 0) { $model->dateTimeTo = $_GET["Audit"]["dateTimeTo"]; } else { $model->dateTimeTo = $dH->getDefaultEndRangeFilter("")->format(Yii::app()->params["dateTimeDisplayFormat"]); } $this->render('admin', array('model' => $model)); }