////////////////////////////////////////////////////////////////
// Average Values
//
/* get average Temperature value */
$temp = $MyData->getSerieAverage("Temperature");
/* format average to 3 decimal places */
$T_Average = number_format($temp, 1);
/* get average Humidity value */
$temp = $MyData->getSerieAverage("Humidity");
/* format average to 1 decimal places */
$H_Average = number_format($temp, 1);
////////////////////////////////////////////////////////////////
// Standard Deviation Values
//
/* get Standard Deviation Temperature Value */
$temp = $MyData->getStandardDeviation("Temperature");
/* Format SD to 3 decimal places */
$T_StandardDeviation = number_format($temp, 1);
/* get Standard Deviation Humidity Value */
$temp = $MyData->getStandardDeviation("Humidity");
/* Format SD to 1 decimal places */
$H_StandardDeviation = number_format($temp, 1);
////////////////////////////////////////////////////////////////
// Minimum Values
//
/* Get minimum Temperature value */
$temp = $MyData->getMin("Temperature");
/* Get minimum Temperature value */
$T_Minimum = number_format($temp, 1);
/* Get minimum Humidity value */
$temp = $MyData->getMin("Humidity");
/* Set the default font */
$myPicture->setFontProperties(array("FontName" => "../fonts/pf_arma_five.ttf", "FontSize" => 6));
/* Define the chart area */
$myPicture->setGraphArea(60, 50, 670, 200);
/* Draw the scale */
$scaleSettings = array("LabelSkip" => 9, "GridR" => 200, "GridG" => 200, "GridB" => 200, "DrawSubTicks" => TRUE, "CycleBackground" => TRUE);
$myPicture->drawScale($scaleSettings);
/* Turn on Antialiasing */
$myPicture->Antialias = TRUE;
$myPicture->setShadow(TRUE, array("X" => 1, "Y" => 1, "R" => 0, "G" => 0, "B" => 0, "Alpha" => 10));
/* Draw the line chart */
$myPicture->drawPlotChart(array("PlotSize" => 2));
/* Compute the serie average and standard deviation */
$Average = $MyData->getSerieAverage("Probe 1");
/* Compute the serie standard deviation */
$StandardDeviation = $MyData->getStandardDeviation("Probe 1");
/* Draw a threshold area */
$myPicture->setShadow(FALSE);
$myPicture->drawThresholdArea($Average - $StandardDeviation, $Average + $StandardDeviation, array("R" => 100, "G" => 100, "B" => 200, "Alpha" => 10));
$myPicture->setShadow(TRUE);
/* Draw the serie average */
$myPicture->drawThreshold($Average, array("WriteCaption" => TRUE, "Caption" => "Average value", "AxisID" => 0));
/* Draw the standard deviation boundaries */
$ThresholdSettings = array("WriteCaption" => TRUE, "CaptionAlign" => CAPTION_RIGHT_BOTTOM, "Caption" => "SD", "AxisID" => 0, "R" => 0, "G" => 0, "B" => 0);
$myPicture->drawThreshold($Average + $StandardDeviation, $ThresholdSettings);
$myPicture->drawThreshold($Average - $StandardDeviation, $ThresholdSettings);
/* Write the coefficient of variation */
$CoefficientOfVariation = round($MyData->getCoefficientOfVariation("Probe 1"), 1);
$myPicture->setFontProperties(array("FontName" => "../fonts/pf_arma_five.ttf", "FontSize" => 6));
$myPicture->drawText(610, 46, "coefficient of variation : " . $CoefficientOfVariation, array("Align" => TEXT_ALIGN_BOTTOMMIDDLE));
/* Render the picture (choose the best way) */
$value2 = $row[0];
$sql = "SELECT Nota FROM notas" . $curso . " WHERE N_Id_Escolar = '{$value2}' \n AND id_asignatura = '{$asignatura}';";
$result = mysqli_query($conn, $sql) or die("Error en el sql");
$series[$value] = array();
while ($row = mysqli_fetch_array($result, MYSQLI_NUM)) {
$series[$value][] = $row[0];
}
}
$myData = new pData();
$html = "<table border='1'>\n <tr>\n <th>Alumno</th>\n <th>Nota media</th>\n <th>Desviación estándar</th>\n <th>Mediana</th>\n <th>Nota más alta</th>\n </tr>";
foreach ($series as $key => $value) {
$myData->addPoints($value, $key);
$media = round($myData->getSerieAverage($key), 2);
$maxima = $myData->getMax($key);
$mediana = $myData->getSerieMedian($key);
$desviacion = round($myData->getStandardDeviation($key), 2);
$html .= "<tr><td>{$key}</td><td>{$media}</td>" . "<td>{$desviacion}</td><td>{$mediana}</td>" . "<td>{$maxima}</td></tr>";
}
$html .= "</table>";
echo $html;
}
?>
</div>
</div>
</div>
</div>
<!-- Pie de página -->
<div class="container-fluid bg-4 text-center" id='foot01'></div>
<script src="script/script.js"></script>
