public function loadModel($id) { $m = VodoOdometer::model(); // apply scope, if available $scopes = $m->scopes(); if (isset($scopes[$this->scope])) { $m->{$this->scope}(); } $model = $m->findByPk($id); if ($model === null) { throw new CHttpException(404, Yii::t('TrucksModule.crud', 'The requested page does not exist.')); } return $model; }
/** * get last reading before requestd date * @param int $vtrc_id * @param date $date * @return VodoOdometer record */ public static function getOdoByDate($vtrc_id, $date) { $criteria = new CDbCriteria(); $criteria->compare('vodo_vtrc_id', $vtrc_id); $criteria->condition = "vodo_end_datetime < :date"; $criteria->params = array(':date' => $date); return VodoOdometer::model()->find($criteria); }