<br>
<div class="row">
<div class="panel panel-primary">
<div class="panel-heading">Tilastot</div>
<div class="panel-body">
<div class="table-responsive">
<table class="table table-hover table-bordered">
<tr>
<th>PVM</th>
<?php
$attributes = Mittaus::model()->getAttributes();
$m = new Mittaus();
unset($attributes['id'], $attributes['pvm'], $attributes['user_id']);
foreach ($attributes as $key => $val) {
echo '<th>' . $m->getAttributeLabel($key) . '</th>';
}
?>
</tr>
<?php
foreach ($data as $model) {
$return = array();
$pvm = date("d.m.Y", strtotime($model->pvm));
$vko = (int) date("YW", strtotime($model->pvm));
$kk = (int) date("Ym", strtotime($model->pvm));
//echo $pvm.' '.$vko.'<br>';
echo '<tr>';
<?php
function allZeroes($arr)
{
foreach ($arr as $v) {
if ($v != 0) {
return false;
}
}
return true;
}
$i = 0;
$category = array();
$d = array();
$attributes = Mittaus::model()->getAttributes();
unset($attributes['id'], $attributes['pvm'], $attributes['user_id']);
foreach ($attributes as $ko => $vo) {
$arr = array();
foreach ($data as $model) {
$value = null;
if ($model->{$ko} > 0 and $model->{$ko} != '') {
$value = $model->{$ko};
}
if ($model->{$ko} == '') {
$arr[] = null;
} else {
$arr[] = (double) str_replace(",", ".", $value);
}
}
if ($ko == 'aamupaino') {
protected function yhteensaMittaus($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(pvm, 1) = '" . $k . "' ");
//YEARWEEK(pvm`, INTERVAL 1 DAY), 3)
} elseif ($kausi == 'kuukausi') {
$criteria->addCondition(" EXTRACT(YEAR_MONTH FROM `pvm`)='" . $k . "' ");
} else {
$criteria->addCondition(" pvm='" . $k . "' ");
}
$m = Mittaus::model()->findAll($criteria);
$attributes = Mittaus::model()->getAttributes();
unset($attributes['id'], $attributes['pvm'], $attributes['user_id']);
if (isset($m[0])) {
foreach ($attributes as $key => $val) {
$u = 0;
$return[$key] = '';
foreach ($m as $model) {
if ($model->{$key} > 0) {
$u++;
$return[$key] += $model->{$key};
}
}
if ($return[$key] > 0) {
$return[$key] = round($return[$key] / $u, 1);
}
}
}
return $return;
}
/**
* 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 Mittaus the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Mittaus::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
/* @var $model Mittaus */
/* @var $form CActiveForm */
if (isset($model->id)) {
$p = $model->pvm;
} else {
$p = date('Y-m-d', strtotime($_POST['pvm2']));
}
?>
<div class="row well form">
<?php
$criteria = new CDbCriteria();
$criteria->order = " id ASC ";
$criteria->condition = " user_id='" . Yii::app()->user->id . "' ";
$mit = Mittaus::model()->find($criteria);
if (isset($mit->user_id)) {
echo '<div class="link alert alert-default bg-primary poistaKaikkiTiedot">Mittaus päiväkirja aloitettu ' . date("d.m.Y", strtotime($mit->pvm)) . '.<br>Jos haluat aloittaa mittaukset alusta, niin paina tästä.</div>';
}
?>
<?php
$form = $this->beginWidget('CActiveForm', array('id' => 'mittaus-form', 'enableAjaxValidation' => false));
?>
<?php
echo $form->errorSummary($model);
?>
