????JFIF??x?x????'
Server IP : 79.136.114.73 / Your IP : 3.144.252.203 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/appsrv.astacus.se/digitaltwin/sensors/strandis/ |
Upload File : |
<?php session_start(); $link = mysql_connect ("localhost", "root", "root123"); mysql_select_db ("energicontrol"); $date_from = date('Y-m-d',strtotime("- 1 days")); $sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00038898' ORDER BY SensorName, SensorType, Time DESC LIMIT 1"; $result = mysql_query($sql); while ($row = mysql_fetch_assoc($result)){ $Outdoor = round($row['Value'],1); } $sql = "SELECT DISTINCT(SensorName), Value, Time FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND tblEcoguard.SensorType = 'T' ORDER BY Time DESC"; // $sql = "SELECT * FROM tblEcoguard, tblRoomInfo WHERE tblRoomInfo.SensorId = tblEcoguard.SensorName AND Time LIKE '".$date_from."%' AND Level = 'Plan 0' AND tblEcoguard.SensorType = 'T' GROUP BY SensorName ORDER BY Time DESC"; $result = mysql_query($sql); $plan0_x = 0; $plan1_x = 0; $plan2_x = 0; $plan3_x = 0; $Temp_Plan0 = 0; $Temp_Plan1 = 0; $Temp_Plan2 = 0; $Temp_Plan3 = 0; $Volume = 0; while ($row = mysql_fetch_assoc($result)){ $sql = "SELECT * FROM tblRoomInfo WHERE SensorId = '".$row['SensorName']."'"; $result2 = mysql_query($sql); while ($row2 = mysql_fetch_assoc($result2)){ if($row2["Level"] == "Plan 0"){ $plan0_x++; $Temp_Plan0 += $row["Value"]; } if($row2["Level"] == "Plan 1"){ $plan1_x++; $Temp_Plan1 += $row["Value"]; } if($row2["Level"] == "Plan 2"){ $plan2_x++; $Temp_Plan2 += $row["Value"]; } if($row2["Level"] == "Plan 3"){ $plan3_x++; $Temp_Plan3 += $row["Value"]; } } } $sql = "SELECT * FROM tblRoomInfo WHERE SensorType = 'T' "; $result2 = mysql_query($sql); while ($row2 = mysql_fetch_assoc($result2)){ $Volume += $row2["Volume"]; } $Temp_Plan0 = round($Temp_Plan0 / $plan0_x,1); $Temp_Plan1 = round($Temp_Plan1 / $plan1_x,1); $Temp_Plan2 = round($Temp_Plan2 / $plan2_x,1); $Temp_Plan3 = round($Temp_Plan3 / $plan3_x,1); $Temp_PlanAVG = round(($Temp_Plan0 + $Temp_Plan1 + $Temp_Plan2 + $Temp_Plan3)/4,1); $Volume = round($Volume); ?> <html> <head> <meta charset="utf-8"> <title>Namnlöst dokument</title> </head> <body bgcolor="#000000"> <?php echo($sql);?> <br> <br> <table width="1255" height="758" border="1" background="images/background.PNG" align="center"> <tbody> <tr> <td><table width="78%" border="0" align="center"> <tbody> <tr> <td width="26%" height="249"> <p align="right"><span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 40px; color: black"> <br> <br> <br> <?php echo($Temp_Plan3);?> °C</span><br> <br> <span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 40px; color: black"> <?php echo($Temp_Plan2);?> °C</span><br> <br> <span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 40px; color: black"><?php echo($Temp_Plan1);?> °C</span><br><br></p> </td> <td width="42%"><p><br> <br> </p> <p> </p> <p align="right"><br></p></td> <td width="32%" align="center" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 40px;color: blue"><?php echo($Outdoor);?> °C</td> </tr> <tr> <td align="right"><span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 40px; color: black"><?php echo($Temp_Plan0);?> °C<br> <br> <br> AVG: <?php echo($Temp_PlanAVG);?> °C<br> <br> </span> Volume: <?php echo($Volume);?> m³<br> Temperaturskillnad: <?php echo($Temp_PlanAVG - $Outdoor);?> °C<br> ENERGI: <?php echo(round(($Temp_PlanAVG - $Outdoor)*0.0036*$Volume));?> kWh </td> <td align="right" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 40px; color: green"> </td> <td> </td> </tr> <tr> <td> </td> <td><p> </p> <p> </p> <p> </p> <p> </p> <p> </p></td> <td> </td> </tr> </tbody> </table></td> </tr> </tbody> </table> </body> </html>