/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return LiikuntaUser the loaded model * @throws CHttpException */ public function loadModel($id) { $model = LiikuntaUser::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
<center> <div id="example1" style="height: 90px;" class="form-group"></div> <div id="example2" style="height: 90px;" class="form-group"></div> <div id="example3" style="height: 90px;" class="form-group"></div> </center> </div> <div id="chart-container"></div> <?php $energiankulutus = 0; if (isset(Yii::app()->user->id)) { $pvm = date("Y-m-d", strtotime($pvm)); $criteria = new CDbCriteria(); $criteria->condition = " user_id='" . Yii::app()->user->id . "' AND pvm='" . $pvm . "' "; $li = LiikuntaUser::model()->findAll($criteria); if (isset($li[0])) { foreach ($li as $data) { $energiankulutus += (double) $data->energiankulutus; } } } ?> <input type="hidden" id="energiankulutus" value="<?php echo $energiankulutus; ?> "> <input type="hidden" id="arvo" value="<?php echo $this->arvo(); ?>
protected function yhteensaLiikunta($k, $kausi) { $return = array(); $criteria = new CDbCriteria(); //$criteria->select = " YEARWEEK(`pvm`) as gramm,t.* "; $criteria->condition = "\n\t\t\tuser_id = '" . Yii::app()->user->id . "' \n\t\t"; //echo $k.'<br>'; if ($kausi == 'pvm') { $criteria->addCondition(" `pvm`='" . $k . "' "); } elseif ($kausi == 'viikko') { $criteria->addCondition(" YEARWEEK(DATE_ADD(`pvm`, INTERVAL 1 DAY), 3) = '" . $k . "' "); } elseif ($kausi == 'kuukausi') { $criteria->addCondition(" EXTRACT(YEAR_MONTH FROM `pvm`)='" . $k . "' "); } else { $criteria->addCondition(" pvm='" . $k . "' "); } $arr = $this->LiikenneUserArray(); $m = LiikuntaUser::model()->findAll($criteria); if (isset($m[0])) { foreach ($arr as $key) { foreach ($m as $model) { if (!isset($return[$key])) { $return[$key] = ''; } $return[$key] += $model->{$key}; } } } return $return; }