$Query = ' SELECT time*1000 as time, DAYOFYEAR(FROM_UNIXTIME(`time`)) as `d`, AVG(`temperature`) as `temp` FROM `' . PREFIX . 'training` WHERE !ISNULL(`temperature`) AND `time` BETWEEN UNIX_TIMESTAMP(\'' . (int) $Year . '-01-01\') AND UNIX_TIMESTAMP(\'' . ((int) $Year + 1) . '-01-01\')-1 GROUP BY `d` ORDER BY `d` ASC'; $Data = DB::getInstance()->query($Query)->fetchAll(); foreach ($Data as $dat) { $Temperatures[$dat['time']] = $Temperature->format((int) $dat['temp'], false); } $Plot = new Plot("year" . $Year, 780, 240); $Plot->Data[] = array('label' => __('Temperatures') . ' ' . $Year, 'data' => $Temperatures); $Plot->setMarginForGrid(5); $Plot->setXAxisAsTime(); $Plot->setXAxisLimitedTo($Year); $Plot->addYAxis(1, 'left'); $Plot->addYUnit(1, $Temperature->unit(), 0); $Plot->setYTicks(1, 5, 0); $Plot->addThreshold('y', 0); $Plot->addMarkingArea('y', -99, 0); $Plot->showPoints(2); $Plot->smoothing(false); if (empty($Data)) { $Plot->raiseError(__('No data available.')); } $Plot->outputJavaScript();
if ($Plugin->Configuration()->value('use_weight')) { $Plot->Data[] = array('label' => __('Weight'), 'color' => '#008', 'data' => $Weights); } if ($Plugin->Configuration()->value('use_pulse')) { $Plot->Data[] = array('label' => __('Resting HR'), 'color' => '#800', 'data' => $HRrests, 'yaxis' => 2); } $Plot->setMarginForGrid(5); $Plot->setXLabels($Labels); $Plot->setXAxisTimeFormat('%m/%y'); $Plot->setXAxisMaxToToday(); $Plot->Options['xaxis']['labelWidth'] = 50; //$Plot->Options['xaxis']['tickLength'] = 3; $Plot->Options['series']['curvedLines']['fit'] = true; $Plot->addYAxis(1, 'left'); $Plot->addYUnit(1, 'kg', 1); $Plot->setYTicks(1, 2, 0); $Plot->addYAxis(2, 'right', false); $Plot->addYUnit(2, 'bpm', 0); $Plot->setYTicks(2, 1, 0); if ($Wunschgewicht > 1) { $Plot->addThreshold('y1', $Wunschgewicht); $Plot->addMarkingArea('y1', $Wunschgewicht, 0); } if (empty($Data)) { $Plot->raiseError(__('No data available.')); } elseif (min(min($Weights), min($HRrests)) == 0 || count($Weights) <= 1) { $Plot->setZeroPointsToNull(); $Plot->lineWithPoints(); $Plot->Options['series']['curvedLines']['apply'] = false; } $Plot->outputJavaScript(true);
$Plot->setXAxisAsTime(); if (!$All && !$lastHalf && !$lastYear) { $Plot->setXAxisLimitedTo($Year); } $Plot->addYAxis(1, 'left'); $Plot->setYTicks(1, 1); if (Configuration::Trimp()->showInPercent()) { $Plot->addYUnit(1, '%'); $Plot->setYLimits(1, 0, 100); } $Plot->addYAxis(2, 'right'); $Plot->setYTicks(2, 1, 1); $Plot->addYAxis(3, 'right'); $Plot->setYLimits(3, 0, $maxTrimp * 2); $Plot->showAsBars(3, 1, 2); $Plot->showAsPoints(4); $Plot->smoothing(false); if (($lastHalf || $lastYear) && !$DataFailed) { $Plot->addMarkingArea('x', Plot::dayOfYearToJStime($StartYear, $HighestIndex - 30 - $AddDays + $StartDayInYear + 1), $index, 'rgba(255,255,255,0.3)'); //'rgba(200,200,200,0.5)'); } $Plot->setGridAboveData(); if ($All) { $Plot->setTitle(__('Shape for all years')); } else { $Plot->setTitle(__('Shape') . ' ' . $Year); } if ($DataFailed) { $Plot->raiseError(__('No data available.')); } $Plot->outputJavaScript();
$Plot->setYTicks(1, 1); if ($showInPercent) { $Plot->addYUnit(1, '%'); $Plot->setYLimits(1, 0, 100); } $Plot->addYAxis(2, 'right'); $Plot->setYTicks(2, 1, 1); $Plot->addYAxis(3, 'right'); $Plot->setYLimits(3, 0, $maxTrimp * 2); if ($perfmodel == 'banister') { $Plot->showAsBars(4, 1, 2); $Plot->showAsPoints(5); } else { $Plot->showAsBars(3, 1, 2); $Plot->showAsPoints(4); } $Plot->smoothing(false); if (($lastHalf || $lastYear) && !$DataFailed) { $Plot->addMarkingArea('x', time() . '000', $index, 'rgba(255,255,255,0.3)'); //'rgba(200,200,200,0.5)'); } $Plot->setGridAboveData(); if ($All) { $Plot->setTitle(__('Shape for all years')); } else { $Plot->setTitle(__('Shape') . ' ' . $Year); } if ($DataFailed) { $Plot->raiseError(__('No data available.')); } $Plot->outputJavaScript();