| Server IP : 79.136.114.73 / Your IP : 3.15.18.157 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/energicontrol/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);
}
/// get room temp
$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00613873' ORDER BY SensorName, SensorType, Time DESC LIMIT 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$R005 = round($row['Value'],1);
}
$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00613872' ORDER BY SensorName, SensorType, Time DESC LIMIT 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$R004 = round($row['Value'],1);
}
$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00613868' ORDER BY SensorName, SensorType, Time DESC LIMIT 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$R001 = round($row['Value'],1);
}
$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00614154' ORDER BY SensorName, SensorType, Time DESC LIMIT 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$R002 = round($row['Value'],1);
}
$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00613940' ORDER BY SensorName, SensorType, Time DESC LIMIT 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$R109 = round($row['Value'],1);
}
$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00613939' ORDER BY SensorName, SensorType, Time DESC LIMIT 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$R101 = round($row['Value'],1);
}
$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00613880' ORDER BY SensorName, SensorType, Time DESC LIMIT 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$R104 = round($row['Value'],1);
}
$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00613932' ORDER BY SensorName, SensorType, Time DESC LIMIT 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$R304 = round($row['Value'],1);
}
$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00613931' ORDER BY SensorName, SensorType, Time DESC LIMIT 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$R302A = round($row['Value'],1);
}
$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00613930' ORDER BY SensorName, SensorType, Time DESC LIMIT 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$R302 = round($row['Value'],1);
}
$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00614164' ORDER BY SensorName, SensorType, Time DESC LIMIT 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$R202 = round($row['Value'],1);
}
$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00614165' ORDER BY SensorName, SensorType, Time DESC LIMIT 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$R201 = round($row['Value'],1);
}
$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '".$date_from."%' AND SensorType LIKE '%T' AND SensorName = '00614163' ORDER BY SensorName, SensorType, Time DESC LIMIT 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$R204 = 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";
$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);
$sensor_04004991 = 0;
$sensor_04005000 = 0;
$sql = "SELECT * FROM tblEcoguard WHERE SensorType = 'CO2' AND SensorName = '04004991' ORDER BY Time DESC LIMIT 1;";
$res = mysql_query($sql);
while ($row = mysql_fetch_assoc($res)){
$sensor_04004991 = $row['Value'];
$t_04004991 = $row['Time'];
}
$sql = "SELECT * FROM tblEcoguard WHERE SensorType = 'CO2' AND SensorName = '04005000' ORDER BY Time DESC LIMIT 1;";
$res = mysql_query($sql);
while ($row = mysql_fetch_assoc($res)){
$sensor_04005000 = $row['Value'];
$t_04005000 = $row['Time'];
}
?>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="refresh" content="120">
<title>Namnlöst dokument</title>
<style type="text/css">
.rubrik { font-family: Verdana, Geneva, sans-serif;
text-align: left;
}
</style>
<style type="text/css">
.rubrik {
font-family: Verdana, Geneva, sans-serif;
text-align: left;
}
.text {
font-family: Verdana, Geneva, sans-serif;
}
.text {
font-size: 14px;
}
#form1 {
}
.bold {
font-weight: bold;
}
.bold {
font-family: Verdana, Geneva, sans-serif;
}
.bold {
font-size: 14px;
}
#box2 {
background: white;
height: 100%;
width: 100%;
margin: -500px 0px;
-webkit-animation-name: move;
-webkit-animation-duration: 30s;
-webkit-animation-iteration-count: infinite;
-webkit-animation-direction: up;
-webkit-animation-timing-function: linear;
}
#box2:hover {
-webkit-animation-play-state: paused;
}
@-webkit-keyframes move {
0% {
margin-top: 0%;
}
100% {
margin-top: 100%;
}
}
</style>
<script src="js/Chart.bundle.js"></script>
<script src="js/utils.js"></script>
</head>
<body bgcolor="#FFFFFF">
<p> </p>
<p> </p>
<table width="1114" height="758" border="1" background="images/HUS3.jpg" align="center">
<tbody>
<tr>
<td valign="top"><br>
<table width="1100" border="0" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif'; font-size: 20px; color: black">
<tbody>
<tr>
<td width="72"> </td>
<td width="22"> </td>
<td width="10"> </td>
<td width="84"> </td>
<td width="67"> </td>
<td width="41"> </td>
<td width="33"> </td>
<td width="47"> </td>
<td width="47"> </td>
<td width="47"> </td>
<td width="47"> </td>
<td width="47"> </td>
<td width="47"> </td>
<td width="47"> </td>
<td width="47"> </td>
<td width="47"> </td>
<td width="47"> </td>
<td width="47"> </td>
<td width="30"> </td>
<td width="142" > </td>
</tr>
<tr>
<td> </td>
<td style="font-size: 14px" > </td>
<td> </td>
<td style="font-size: 14px"> </td>
<td> </td>
<td></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"><?php echo($Outdoor);?>°C</td>
<td> </td>
</tr>
<tr style="font-size: 8px">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="41"> </td>
<td style="font-size: 14px"> </td>
<td> </td>
<td style="font-size: 14px"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"> <?php echo($Temp_Plan3);?>°C</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"><?php echo($R304);?>°C</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"><?php echo($R302A);?>°C</td>
<td> </td>
<td> </td>
<td> </td>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"><?php echo($R302);?>°C</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"> <?php echo($Temp_Plan2);?>°C</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"><?php echo($R202);?>°C</td>
<td> </td>
<td> </td>
<td> </td>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"><?php echo($R201);?>°C</td>
<td> </td>
<td> </td>
<td> </td>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"><?php echo($R204);?>°C</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td > </td>
</tr>
<tr style="font-size: 2px">
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr style="font-size: 2px">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"> <?php echo($Temp_Plan1);?>°C</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td><span style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"><?php echo($R109);?>°C</span></td>
<td> </td>
<td> </td>
<td> </td>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"><?php echo($R101);?>°C</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"><?php echo($R104);?>°C</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </span></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td><span style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"><?php echo($R005);?>°C</span></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"> <?php echo($Temp_Plan0);?>°C</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"><?php echo($R004);?>°C</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"><?php echo($R001);?>°C</td>
<td> </td>
<td> </td>
<td style="background-clip: padding-box;border-radius: 5px;background-color: #FFF;border: 5px solid white;"><?php echo($R002);?>°C</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table>
<p> </p>
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="box3">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td width="14%">Periodisering: </td>
<td width="86%"> </td>
</tr>
</tbody>
</table>
<br>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td><div id="canvas-holder4" style="width:100%"></div>
<div style="width:100%;">
<canvas id="canvas4"></canvas>
</div>
<br>
<br>
<script>
<?php
$date = date("Y-m-d",strtotime("-5 days"));
// $date = "'2022-03-15' and Time <= '2022-03-22'";
$sql = "SELECT Distinct(Time) FROM tblEcoguard WHERE Time LIKE '%00:00' and Time >= '$date' and SensorType = 'T'";
$result = mysql_query($sql);
$json_labels_t1 = "labels : [";
while ($row = mysql_fetch_assoc($result)){
$json_labels_t1 = $json_labels_t1 . "'".$row['Time']."',";
}
$json_labels_t1 = $json_labels_t1 . "]";
$sql = "SELECT * FROM tblEcoguard WHERE Time LIKE '%00:00' and Time >= '$date' and SensorName = '00613880' and SensorType = 'T'";
$result = mysql_query($sql);
$json_data_t = "data : [";
// $json_labels_t1 = "labels : [";
while ($row = mysql_fetch_assoc($result)){
$json_data_t = $json_data_t . $row['Value'].",";
// $json_labels_t1 = $json_labels_t1 . "'".$row['Time']."',";
}
$json_data_t = $json_data_t . "]";
//$json_labels_t1 = $json_labels_t1 . "]";
$sql = "SELECT * FROM tblEcoguard WHERE `Time` LIKE '%00:00' and Time >= '$date' and SensorName = '00614163' and SensorType = 'T'";
$result = mysql_query($sql);
$json_data_t3 = "data : [";
$array_t = array();
$array_lable = array();
while ($row = mysql_fetch_assoc($result)){
$json_data_t3 = $json_data_t3 . $row['Value'].",";
}
$json_data_t3 = $json_data_t3 . "]";
$sql = "SELECT * FROM tblEcoguard WHERE `Time` LIKE '%00:00' and Time >= '$date' and SensorName = '00614164' and SensorType = 'T'";
$result = mysql_query($sql);
$json_data_t4 = "data : [";
while ($row = mysql_fetch_assoc($result)){
$json_data_t4 = $json_data_t4 . $row['Value'].",";
}
$json_data_t4 = $json_data_t4 . "]";
$sql = "SELECT * FROM tblEcoguard WHERE `Time` LIKE '%00:00' and Time >= '$date' and SensorName = '00613940' and SensorType = 'T'";
$result = mysql_query($sql);
$json_data_t7 = "data : [";
while ($row = mysql_fetch_assoc($result)){
$json_data_t7 = $json_data_t7 . $row['Value'].",";
}
$json_data_t7 = $json_data_t7 . "]";
//THERMIA
$sql = "SELECT * FROM tblEcoguard WHERE `Time` LIKE '%00:00' and Time >= '$date' and SensorName = '00016774'";
$result = mysql_query($sql);
$json_data_t9 = "data : [";
while ($row = mysql_fetch_assoc($result)){
$json_data_t9 = $json_data_t9 . $row['Value'].",";
}
$json_data_t9 = $json_data_t9 . "]";
//UTE NORR
$sql = "SELECT * FROM tblEcoguard WHERE `Time` LIKE '%00:00' and Time >= '$date' and SensorName = '23000682' and SensorType = 'OT'";
$result = mysql_query($sql);
$json_data_t20 = "data : [";
while ($row = mysql_fetch_assoc($result)){
$json_data_t20 = $json_data_t20 . $row['Value'].",";
}
$json_data_t20 = $json_data_t20 . "]";
//UTE SÖDER
$sql = "SELECT * FROM tblEcoguard WHERE `Time` LIKE '%00:00' and Time >= '$date' and SensorName = '23000636' and SensorType = 'OT'";
$result = mysql_query($sql);
$json_data_t21 = "data : [";
while ($row = mysql_fetch_assoc($result)){
$json_data_t21 = $json_data_t21 . $row['Value'].",";
}
$json_data_t21 = $json_data_t21 . "]";
//UTE SÖDER
$sql = "SELECT * FROM tblForcast WHERE timeSeries >= '$date'";
$result = mysql_query($sql);
$json_data_t22 = "data : [";
while ($row = mysql_fetch_assoc($result)){
$json_data_t22 = $json_data_t22 . $row['t'].",";
}
$json_data_t22 = $json_data_t22 . "]";
$sql = "SELECT * FROM tblForcast WHERE timeSeries >= '$date'";
$result = mysql_query($sql);
$json_data_t23 = "data : [";
while ($row = mysql_fetch_assoc($result)){
$json_data_t23 = $json_data_t23 . $row['tcc_mean'].",";
}
$json_data_t23 = $json_data_t23 . "]";
$sql = "SELECT * FROM tblNordpool WHERE startTime >= '".$date." T00:00:00Z' and area = 'SE3' order by startTime";
// echo($sql);
$result = mysql_query($sql);
$json_data_t24 = "data : [";
while ($row = mysql_fetch_assoc($result)){
$json_data_t24 = $json_data_t24 .($row['value']/1000)*1.25.",";
}
$json_data_t24 = $json_data_t24 . "]";
?>
var config4 = {
type: 'line',
data: {
<?php echo($json_labels_t1);?>,
datasets: [{
label: 'RUM 104 (Carina)',
backgroundColor: window.chartColors.color3,
borderColor: window.chartColors.color3,
<?php echo($json_data_t);?>,
fill: false,
},{
label: 'RUM 204 (Barbera)',
backgroundColor: window.chartColors.color4,
borderColor: window.chartColors.color4,
<?php echo($json_data_t3);?>,
fill: false,
},{
label: 'RUM 202 (Carl)',
backgroundColor: window.chartColors.color6,
borderColor: window.chartColors.color6,
<?php echo($json_data_t4);?>,
fill: false,
},{
label: 'RUM 109 (Köket)',
backgroundColor: window.chartColors.color12,
borderColor: window.chartColors.color12,
<?php echo($json_data_t7);?>,
fill: false,
},{
label: 'Elförbrukning Thermia Diplomat',
backgroundColor: window.chartColors.color13,
borderColor: window.chartColors.color13,
<?php echo($json_data_t9);?>,
fill: false,
},{
label: 'Utetemp Söder',
backgroundColor: window.chartColors.color6,
borderColor: window.chartColors.color6,
<?php echo($json_data_t20);?>,
fill: false,
},{
label: 'Utetemp Norr',
backgroundColor: window.chartColors.color1,
borderColor: window.chartColors.color1,
<?php echo($json_data_t21);?>,
fill: false,
},{
label: 'Prognos Norr',
backgroundColor: window.chartColors.color2,
borderColor: window.chartColors.color2,
<?php echo($json_data_t22);?>,
fill: false,
},{
label: 'Molnighet',
backgroundColor: window.chartColors.color3,
borderColor: window.chartColors.color3,
<?php echo($json_data_t23);?>,
fill: false,
},{
label: 'ELPRIS',
backgroundColor: window.chartColors.color4,
borderColor: window.chartColors.color4,
<?php echo($json_data_t24);?>,
fill: false,
}]
},
options: {
responsive: true,
title: {
display: true,
text: 'Historik'
},
tooltips: {
mode: 'index',
intersect: false,
},
hover: {
mode: 'nearest',
intersect: true
},
scales: {
xAxes: [{
display: true,
scaleLabel: {
display: true,
labelString: 'Datum'
}
}],
yAxes: [{
display: true,
scaleLabel: {
display: true,
labelString: 'Mätvärden'
}
}]
}
}
};
</script></td>
</tr>
</tbody>
</table>
<br>
<h1 class="rubrik"></h1>
<p></p></td>
</tr>
</table>
<script>
var ctx4 = document.getElementById('canvas4').getContext('2d');
var chart4 = new Chart(ctx4, config4);
window.myLine = chart4;
</script>
<p></p>
<p> </p>
<p> </p>
<p> </p>
</body>
</html>