| Server IP : 79.136.114.73 / Your IP : 216.73.216.48 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/viewer/ |
Upload File : |
<?php
session_start();
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("energicontrol");
?>
<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">
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="box3">
<tr>
<td><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"));
$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 : [";
$timeSeries = array();
while ($row = mysql_fetch_assoc($result)){
$json_labels_t1 = $json_labels_t1 . "'".$row['Time']."',";
$timeSeries[] = $row['Time'];
}
$json_labels_t1 = $json_labels_t1 . "]";
$sql = "SELECT AVG(Value) as Value FROM tblEcoguard WHERE SensorType = 'T' and Time >= '$date' GROUP BY Time ORDER BY Time DESC ";
$result = mysql_query($sql);
$json_data_t = "data : [";
while ($row = mysql_fetch_assoc($result)){
$json_data_t = $json_data_t . $row['Value'].",";
}
$json_data_t = $json_data_t . "]";
$json_data_t9 = "data : [";
//THERMIA
$sql = "SELECT * FROM tblEcoguard WHERE Time >= '$date' and SensorName = '00016774'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$json_data_t9 = $json_data_t9 . $row['Value'].",";
$found = 1;
}
$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: 'Medeltemperatur',
backgroundColor: window.chartColors.color3,
borderColor: window.chartColors.color3,
<?php echo($json_data_t);?>,
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>