1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
| include("pChart/class/pData.class.php");
include("pChart/class/pDraw.class.php");
include("pChart/class/pImage.class.php");
$myData = new pData();
$db = '../DataBase.db';
$table = "domos";
$base= new SQLite3($db);
$cur_date=get_Datetime_Now();
$sub_date=sub_days($cur_date,$delta);
$requete = "SELECT date,Hum,temp FROM $table WHERE date > '$sub_date'";
$resultat = $base->query($requete);
$date=""; $temperature="";
while($donnees = $resultat->fetchArray()){
$date[] = date('d - H:i',(strtotime($donnees["date"])));
$temperature[] = $donnees["temp"];
$humidite[] = $donnees["Hum"];
}
$myData->addPoints($date,"Timestamp");
$myData->addPoints($temperature,"Temperature");
$myData->addPoints($humidite,"Humidite");
$myData->setAbscissa("Timestamp");
$myData->setXAxisName(0,"Time");
$myData->setXAxisDisplay(1,AXIS_FORMAT_TIME,"d/m - H:i");
$myData->setAxisName(0,"Temperature");
$myData->setAxisUnit(0,"°C");
$myData->setAxisName(1,"Humidite");
$myData->setAxisPosition(1,AXIS_POSITION_RIGHT);
$myData->setAxisUnit(1,"%");
$myData->setSerieOnAxis("Humidite", 1);
$serieSettingsTemp = array("R"=>229,"G"=>11,"B"=>11,"Alpha"=>80);
$serieSettingsHum = array("R"=>11,"G"=>11,"B"=>229,"Alpha"=>80);
$myData->setPalette("Temperature",$serieSettingsTemp);
$myData->setPalette("Humidite",$serieSettingsHum);
$myPicture = new pImage(1300,500,$myData);
$myPicture->setFontProperties(array("FontName"=>"pChart/fonts/Forgotte.ttf","FontSize"=>9));
$myPicture->setGraphArea(50,10,1300,400);
$myPicture->drawScale(array("LabelSkip"=>1,"DrawYLines"=>array(0),"Pos"=>SCALE_POS_LEFTRIGHT));
$myPicture->drawLineChart(array("DisplayValues"=>FALSE));
$myPicture->Render("Stats/graph.png"); |
Partager