$dateto) $datefrom = $dateto;
$lineColors = array("#0b62a4", "#7A92A3", "#4da74d", "#afd8f8", "#edc240", "#cb4b4b", "#9440ed",
"#62a40b", "#92A37A", "#a74d4d", "#d8f8af", "#c240ed", "#4b4bcb", "#40ed94",
"#a40b62", "#A37A92", "#4d4da7", "#f8afd8", "#40edc2", "#4bcb4b", "#ed9440"); // copied from morris.js
?>
";
if($debug) echo "\n/* resultsql:".@sprintf(str_replace('?', '%s', str_replace(' ',' ', $resultsql)), ...$params)." ";
if(!$qryresult = mysqli_prepared_query($link, $resultsql, $types, $params, __FILE__, __LINE__)) reporterror(get_error(), $resultsql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__, $params);
if($debug) echo "*/\n";
$sum = 0;
$count = 0;
foreach($qryresult as $result_array){
$sum += texttonumber($result_array['resultFriendly'], $test_array['testFormat']);
$count++;
$testText = $test_array['testText'];
}
//if($count!=0 && $sum!=0){
//https://krud.no-ip.org/prodbase/trends.php?p=0&l=0&g=47&t=1067&from=2016-01-01&to=2017-07-25
if($count > 0){
$average = $sum / $count;
if($debug) echo "\n/* ".$sum."/".$count."=".$average." */\n";
if($average >= 0){ //dont want -1
echo ", '".$test_array['testID']."':".number_format($average, $test_array['testRound'],'.',''); //dont want commas
$table .= "| ".number_format($average, $test_array['testRound'])."".number_format($average, $test_array['testRound'])." | ";
$csv .= number_format($average, $test_array['testRound']).",";
//if($average < $ymin) $ymin = $average;
}else{
//echo ", '".$test_array['testID']."':0";
$table .= "-- | ";
$csv .= "-,";
}
if($average < $ymin) $ymin = $average;
if($average > $ymax) $ymax = $average;
}else{
//echo "\n/* count is zero */\n";
$table .= " | ";
}
}
$table .= "";
$csv .= "\r\n";
echo "},";
}
//write csv
if($csv_file = fopen("file.csv", "w")){
fwrite($csv_file, $csv);
fclose($csv_file);
}
?>],
// The name of the data record attribute that contains x-values.
xkey: 'date',
smooth: false,
// A list of names of data record attributes that contain y-values.
ykeys: [],
xlabels: 'day',
// Labels for the ykeys -- will be displayed when you hover over the chart.
labels: [],
= ?
";
if($debug) echo "\n/* limitsql:".@sprintf(str_replace('?', '%s', str_replace(' ',' ', $limitsql)), ...$params)." ";
if(!$qrylimit = mysqli_prepared_query($link, $limitsql, "iiiss", array(clean($_GET['t']), clean($_GET['p']), clean($_GET['l']), clean($_GET['from']), clean($_GET['to'])), __FILE__, __LINE__)) reporterror(get_error(), $limitsql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__);
if($debug) echo "*/\n";
if(mysqli_prepared_num_rows($qrylimit)>0){
$limit_array = $qrylimit[0];
echo "goals: [".$limit_array['limitLow'].",".$limit_array['limitHigh']."], goalLineColors: ['#FF7F00', '#FF0000'],";
//if($limit_array['limitLow'] < $ymin) $ymin = $limit_array['limitLow'];
}
}
if($ymin < 1) $ymin = 0; //this is to stop silly rounding errors. some points were 12.99999999999999999
//if($ymin != 1000000) echo "ymin: ".floor($ymin).",";
?>
ymin: ,
ymax: ,
xLabelFormat: function(day){
var d = new Date(day);
return d.getDate() + '/' + (d.getMonth() + 1) + '/' + d.getFullYear();
},
hideHover: 'auto'
});