TransWar File Browser

Path: C:\

<?php
ini_set('max_execution_time',1200); 
require_once 'phplot.php';
require_once 'prune_labels.php';
$Tmedia=$_GET['media'];
$Tminima= $_GET['minima'];
$Tmaxima=$_GET['maxima'];
function LoadData($file)
{
    $lines = file($file);
    $data = array();
    foreach($lines as $line)
        $data[] = explode(';',trim($line));
    return $data;
}

$plot = new PHPlot(850,175);
$data = LoadData('quali3.txt');
$inicio=$data[1][0];
$fim=$data[1][1];
$hrini=$data[2][0];
$hrfim=$data[2][1];
$data1 = DateTime::createFromFormat('d-m-Y', $inicio);
$data2 = DateTime::createFromFormat('d-m-Y', $fim);
$dia1=$data1->format('Y-m-d');
$dia2=$data2->format('Y-m-d');
$data1=$dia1.' '.$hrini.':00';
$data2=$dia2.' '.$hrfim.':00';
$term=$data[0][0];
require_once("../conexao_mysql.php");
$sql1 = "SELECT id_veic FROM veiculos where placa='$term'";
if ($query1 = mysqli_query($conn, $sql1))
{ 
	while($row1 = $query1->fetch_assoc()) {$id_veic=$row1['id_veic'];}
}else{echo 'não leu placa<br>';}
$sql = "SELECT FROM_UNIXTIME(dia_hora) as dia, umidade FROM leitura
where id_veic='$id_veic' and FROM_UNIXTIME(dia_hora) BETWEEN '$data1' and '$data2' and umidade>0  ORDER BY dia ASC";
if ($query = mysqli_query($conn, $sql)){
$eco= mysqli_num_rows($query);
}else{echo 'não leu<br>';}
$z=0;$tt=0;$minima=99;$maxima=0;
while($row = $query->fetch_assoc()) 
{	
	$grafico[$z][0]=strtotime($row['dia']);
	$grafico[$z][1]=0;
	$grafico[$z][2]=0;
	$grafico[$z][3]=$row['umidade'];
	$tt=$tt+$grafico[$z][3];
	if ($grafico[$z][3]<$minima){$minima=$grafico[$z][3];}
	if ($grafico[$z][3]>$maxima){$maxima=$grafico[$z][3];}
	$z++;

}
$media=$tt/$z;

$plot->SetDataValues($grafico);
$plot->SetXAxisPosition($maxima+1);
$plot->SetYTitle('Umidade %');
$plot->SetDataColors(array('blue', 'red', 'green'));
$plot->SetPlotType('lines');
$plot->SetLineWidths(2);
$plot->SetLineStyles(array('solid','solid','solid'));
$plot->SetYTickIncrement(5);
$plot->SetXTickPos('none');
$plot->SetXTickLabelPos('none');
$plot->SetXDataLabelPos('none');
$plot->SetPlotBorderType('left');
$plot->SetPlotAreaWorld(null, $minima, null, $maxima+1); // comentar essa linha se quiser tirar limites
$plot->SetPrintImage(false);
$plot->DrawGraph();

$imagem = $plot->EncodeImage('raw');
$fp = fopen("grafico2.png", "w");
fwrite($fp, $imagem);
fclose($fp);
echo "<script language='JavaScript'>window.close();window.open('RelatorioGrafico.php?media=".$Tmedia."&minima=".$Tminima."&maxima=".$Tmaxima."&Umedia=".$media."&Uminima=".$minima."&Umaxima=".$maxima."','_blank');</script>";
?>