modify('+1 day');
$periodo = new DatePeriod($start,new DateInterval('P1D'),$stop);
$data = [];
$timeStamps = [];
$tableRows = [];
foreach ($periodo as $data_corrente){
$giorno = $data_corrente->format("d");
$mese = $data_corrente->format("m");
$anno = $data_corrente->format("Y");
$SkPIP300 = str_pad($PIP300,6,'0',STR_PAD_LEFT);
$Tipo_Strumento = str_pad($Matricola_CALL,2,'0',STR_PAD_LEFT);
$Indirizzo = str_pad($ADDR_V,2,'0',STR_PAD_LEFT);
$file = "C:\\xampp\\htdocs\\archivi\\$anno\\$mese\\{$SkPIP300}_{$Tipo_Strumento}_{$Indirizzo}_{$giorno}{$mese}{$anno}.CSV";
if (!file_exists($file)) continue;
$handle = fopen($file,"r");
if ($handle){
while (($row = fgetcsv($handle,1000,";")) !== FALSE){
$timeStamps[] = $giorno.'/'.$mese.' '.$row[0];
$row[1] = (float)str_replace(',','.',$row[1]);
$row[2] = (float)str_replace(',','.',$row[2]);
$row[3] = (float)str_replace(',','.',$row[3]);
$data['Cloro Libero ppm'][] = ($row[1]==100 || $row[1]>5)?null:$row[1];
$data['pH'][] = ($row[2]==100 || $row[2]>8 || $row[2]<6)?null:$row[2];
$data['°C'][] = ($row[3]==100 || $row[3]>35 || $row[3]<25)?null:$row[3];
$cl_comb = "";
$redox = "";
if($Full){
$row[4] = (float)str_replace(',','.',$row[4]);
$row[5] = (float)str_replace(',','.',$row[5]);
$data['Cloro Combinato ppm'][] = ($row[4]==100 || $row[4]>5)?null:$row[4];
$data['Redox mV'][] = ($row[5]<0 || $row[5]>1000)?null:$row[5];
$cl_comb = $row[4];
$redox = $row[5];
}
$tableRows[] = [
'data' => $giorno.'/'.$mese.'/'.$anno,
'ora' => $row[0],
'cloro' => $row[1],
'ph' => $row[2],
'temp' => $row[3],
'cloro_comb' => $cl_comb,
'redox' => $redox
];
}
fclose($handle);
}
}
if(isset($_POST['download_csv'])){
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename="dati_impianto.csv"');
$output = fopen("php://output","w");
if($Full){
fputcsv($output,
["Data","Ora","Cloro libero","pH","Temperatura","Cloro combinato","Redox"],
";");
}else{
fputcsv($output,
["Data","Ora","Cloro libero","pH","Temperatura"],
";");
}
foreach($tableRows as $r){
if($Full){
fputcsv($output,
[$r['data'],$r['ora'],$r['cloro'],$r['ph'],$r['temp'],$r['cloro_comb'],$r['redox']],
";");
}else{
fputcsv($output,
[$r['data'],$r['ora'],$r['cloro'],$r['ph'],$r['temp']],
";");
}
}
fclose($output);
exit();
}
$chartSettings = [
'Cloro Libero ppm'=>['color'=>'blue','min'=>0,'max'=>5],
'pH'=>['color'=>'green','min'=>6,'max'=>8],
'°C'=>['color'=>'red','min'=>25,'max'=>35]
];
if($Full){
$chartSettings['Cloro Combinato ppm']=['color'=>'orange','min'=>0,'max'=>5];
$chartSettings['Redox mV']=['color'=>'purple','min'=>0,'max'=>1000];
}
?>
Grafici
$settings){
echo '';
echo '';
echo '
';
echo '';
}
?>
| Data |
Ora |
Cloro libero |
pH |
Temperatura |
Cloro combinato |
Redox |
";
echo "".$r['data']." | ";
echo "".$r['ora']." | ";
echo "".$r['cloro']." | ";
echo "".$r['ph']." | ";
echo "".$r['temp']." | ";
if($Full){
echo "".$r['cloro_comb']." | ";
echo "".$r['redox']." | ";
}
echo "";
}
?>