| Server IP : 79.136.114.73 / Your IP : 13.59.90.172 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/ |
Upload File : |
<?php
$link = mysql_connect ("localhost", "root", "root123");
mysql_select_db ("energicontrol");
?>
<html>
<head>
<meta charset="UTF-8">
<title>Astaucs Digital Twin Portal</title>
<meta name="viewport" content="initial-scale=1,maximum-scale=1,user-scalable=no">
<link href="https://api.mapbox.com/mapbox-gl-js/v2.4.1/mapbox-gl.css" rel="stylesheet">
<script src="https://api.mapbox.com/mapbox-gl-js/v2.4.1/mapbox-gl.js"></script>
<script>
function iframe_call(link){
document.getElementById("rutan").src = link;
//window.scrollTo(0, 550);
}
function iframe_call2(link){
document.getElementById("rutan2").src = link;
//window.scrollTo(0, 550);
}
</script>
<style>
.rcorners { border-radius: 10px;
background: #0063b5;
padding: 10px;
height: 30px;
}
.rcorners2 {
border-radius: 10px;
background: #DDDDDD;
padding: 10px;
height: 30px;
font-size: 18px;
color: #000000;
}
.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 leftmargin="0" marginheight="0" topmargin="0">
<table width="100%" border="0" style="position: absolute; top: 0; bottom: 0; left: 0; right: 0; font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif; color: #FFFFFF;">
<tbody>
<tr>
<td width="250" rowspan="2" align="left" valign="top" bgcolor="#2F2F2F" ><a href="start2.php"><img src="images/astacus_wide_original.png" width="200" style="margin-top: 10px;" alt=""/></a>
<hr color="#6B6B6B">
<table width="100%" border="0">
<tbody>
<tr>
<td align="center" valign="middle"> </td>
<td align="left" valign="middle"><strong><span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif; color: #FFFFFF">PROFIL</span></strong></td>
</tr>
<tr>
<td height="34" align="center" valign="middle"><img src="images/icon_profil.png" width="20" height="20" alt=""/></td>
<td align="left" valign="middle"><span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif; color: #CECECE"><a href="profil.php" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif; color: #CECECE;">Visa profil</a></span></td>
</tr>
<tr>
<td height="31" align="center" valign="middle"><img src="images/icon_exit.png" width="20" height="20" alt=""/></td>
<td align="left" valign="middle"><span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif; color: #CECECE;"><a href="exit.php" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif; color: #CECECE;">Logga ut </a></span></td>
</tr>
<tr>
<td width="21%" align="center" valign="top"><br>
<br>
<br>
<br></td>
<td width="79%"><p style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif; color: #CECECE;"> </p>
<p style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif; color: #CECECE;"><br>
<br>
</p></td>
</tr>
</tbody>
</table>
<hr color="#6B6B6B">
<table width="100%" border="0" height="200">
<tbody>
<tr>
<td align="center" valign="top"> </td>
<td><span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif; color: #FFFFFF"><strong>FASTIGHETER</strong></span></td>
</tr>
<tr>
<td height="37" align="center" valign="middle"><img src="images/icon_list.png" width="20" height="20" alt=""/></td>
<td valign="middle"><span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif; color: #CECECE;"><span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif; color: #CECECE"><a href="list.php" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif; color: #CECECE;">Visa lista</a></span><br>
</span></td>
</tr>
<tr>
<td height="32" align="center" valign="middle"><img src="images/icon_clobe.png" width="20" height="20" alt=""/></td>
<td valign="middle"><span style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif; color: #CECECE;"><a href="map.php" style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, sans-serif; color: #CECECE;">Visa karta</a></span></td>
</tr>
<tr>
<td height="39" align="center" valign="middle"> </td>
<td valign="middle"> </td>
</tr>
<tr>
<td width="21%" height="135" align="center" valign="top"> </td>
<td width="79%"></td>
</tr>
</tbody>
</table>
<hr color="#6B6B6B">
<p>
<center>
</center>
</p>
<p> </p>
<p></p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p></td>
<td width="*" height="45" align="center">
<table width="100%" border="0">
<tbody>
<tr>
<td width="6%"><a href="javascript:history.back(-1);"><img src="images/back.png" width="40" height="40" alt=""/></a></td>
<td width="94%" align="center"><span style="font-size: 36px; color: #000000">Digital Twin - Objekt</span></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr style="height: 25%; font-size: 12px;">
<td align="center" valign="top" bgcolor="#ECECEC">
<br>
<?php if($_GET["id"] == 1){?>
<table width="100%" border="0" class="rcorners">
<tbody>
<tr>
<td valign="middle" ><table width="91%" border="0" align="left">
<tbody>
<tr>
<td width="6%" rowspan="2" align="center" valign="middle"><img src="images/house.png" width="50" height="50" alt=""/></td>
<td width="29%" rowspan="2" align="center" valign="top" style="font-size: 18px"><h2>Skänninge</h2></td>
<td width="10%" height="18" style="font-size: 14px">Fastighet: </td>
<td width="20%" style="font-size: 14px">Manegen 1</td>
<td width="9%" style="font-size: 14px">Adress:</td>
<td width="26%" style="font-size: 14px">Mjölbygatan 32</td>
</tr>
<tr>
<td style="font-size: 14px">Tjänster:</td>
<td style="font-size: 14px">Energy Viewer, Termisk filmning</td>
<td style="font-size: 14px">Typ:</td>
<td style="font-size: 14px">Butik</td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table>
<br>
<table width="90%" border="0" class="rcorners2">
<tbody>
<tr>
<td><table width="99%" border="0" align="left">
<tbody>
<tr>
<td width="1%"></td>
<td width="38%"><p><img src="images/skanninge.JPG" width="400" alt=""/></p>
<p> </p>
<p> </p>
<p> </p></td>
<td width="30%" valign="top"><p><br>
<br>
</p>
<p><a href="http://111.93.24.58:3000/?urn=dXJuOmFkc2sub2JqZWN0czpvcy5vYmplY3Q6YXN0YWN1c19idWNrZXQvMzMzMzQtQS00MC1WLTFfMjAyMjEyMTIucnZ0"
target="popup"
onclick="window.open('http://111.93.24.58:3000/?urn=dXJuOmFkc2sub2JqZWN0czpvcy5vYmplY3Q6YXN0YWN1c19idWNrZXQvMzMzMzQtQS00MC1WLTFfMjAyMjEyMTIucnZ0','popup','width=1200'); return false;"></a><br>
</p></td>
<td width="31%" valign="top" style="color: #000000"><p><img src="images/forge_skanninge.JPG" alt="" width="404" height="292"/></p>
<p><center>
<a href="http://111.93.24.58:3000/?urn=dXJuOmFkc2sub2JqZWN0czpvcy5vYmplY3Q6YXN0YWN1c19idWNrZXQvMzMzMzQtQS00MC1WLTFfMjAyMjEyMTIucnZ0"
target="popup"
onclick="window.open('http://111.93.24.58:3000/?urn=dXJuOmFkc2sub2JqZWN0czpvcy5vYmplY3Q6YXN0YWN1c19idWNrZXQvMzMzMzQtQS00MC1WLTFfMjAyMjEyMTIucnZ0','popup','width=1200'); return false;">Öppna Energy Viewer</a><br>
</center> </p></td>
</tr>
</tbody>
</table>
<p> </p>
<p>
<?php
if($_GET['daysback'] == ""){
$daysback = 14;
}else{
$daysback = $_GET['daysback'];
}
$date = date("Y-m-d H:00:00",strtotime("-$daysback days"));
$lables = array();
for ($x = 0; $x <= 24*$daysback; $x++) {
$lables[] = date("Y-m-d H:00:00",strtotime("-$daysback days +$x hours"));
}
$json_labels_t1 = "labels : [";
foreach ($lables as &$value) {
$json_labels_t1 = $json_labels_t1 . "'".$value ."',";
}
$json_labels_t1 = $json_labels_t1 . "]";
$data = array();
$sql = "SELECT * FROM tblEcoguard WHERE Time >= '".$date."' and Time LIKE '%00:00' and (SensorName = '00686423' or SensorName = '00686424' or SensorName = '00686425' or SensorName = '00686426' or SensorName = '00686427' or SensorName = '00038898') and (SensorType = 'T' or SensorType = 'OT')";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$arr = array();
$arr[] = $row['Time'];
$arr[] = $row['SensorName'];
$arr[] = $row['Value'];
$data[] = $arr;
}
$avg_data1 = 0;
$avg_data2 = 0;
$avg_data3 = 0;
$avg_data4 = 0;
$avg_data5 = 0;
$avg_data6 = 0;
$max_data1 = -100;
$max_data2 = -100;
$max_data3 = -100;
$max_data4 = -100;
$max_data5 = -100;
$max_data6 = -100;
$min_data1 = 100;
$min_data2 = 100;
$min_data3 = 100;
$min_data4 = 100;
$min_data5 = 100;
$min_data6 = 100;
$x_data1 = 0;
$x_data2 = 0;
$x_data3 = 0;
$x_data4 = 0;
$x_data5 = 0;
$x_data6 = 0;
$json_data_t1 = "data : [";
$json_data_t2 = "data : [";
$json_data_t3 = "data : [";
$json_data_t4 = "data : [";
$json_data_t5 = "data : [";
$json_data_t6 = "data : [";
$found_1 = 0;$found_2 = 0;$found_3 = 0;$found_4 = 0;$found_5 = 0;$found_6 = 0;
foreach ($lables as &$lables_value) {
foreach ($data as &$value) {
if($value[1] == "00686423") {
if($value[0] == $lables_value){
$json_data_t1 = $json_data_t1 . $value[2].",";
$found_1 = 1;
$avg_data1 += $value[2];
$x_data1++;
if($value[2] > $max_data1){
$max_data1 = $value[2];
}
if($value[2] < $min_data1){
$min_data1 = $value[2];
}
}
}
if($value[1] == "00686424") {
if($value[0] == $lables_value){
$json_data_t2 = $json_data_t2 . $value[2].",";
$found_2 = 1;
$avg_data2 += $value[2];
$x_data2++;
if($value[2] > $max_data2){
$max_data2 = $value[2];
}
if($value[2] < $min_data2){
$min_data2 = $value[2];
}
}
}
if($value[1] == "00686425") {
if($value[0] == $lables_value){
$json_data_t3 = $json_data_t3 . $value[2].",";
$found_3 = 1;
$avg_data3 += $value[2];
$x_data3++;
if($value[2] > $max_data3){
$max_data3 = $value[2];
}
if($value[2] < $min_data3){
$min_data3 = $value[2];
}
}
}
if($value[1] == "00686426") {
if($value[0] == $lables_value){
$json_data_t4 = $json_data_t4 . $value[2].",";
$found_4 = 1;
$avg_data4 += $value[2];
$x_data4++;
if($value[2] > $max_data4){
$max_data4 = $value[2];
}
if($value[2] < $min_data4){
$min_data4 = $value[2];
}
}
}
if($value[1] == "00686427") {
if($value[0] == $lables_value){
$json_data_t5 = $json_data_t5 . $value[2].",";
$found_5 = 1;
$avg_data5 += $value[2];
$x_data5++;
if($value[2] > $max_data5){
$max_data5 = $value[2];
}
if($value[2] < $min_data5){
$min_data5 = $value[2];
}
}
}
if($value[1] == "00038898") {
if($value[0] == $lables_value){
$json_data_t6 = $json_data_t6 . $value[2].",";
$found_6 = 1;
$avg_data6 += $value[2];
$x_data6++;
if($value[2] > $max_data6){
$max_data6 = $value[2];
}
if($value[2] < $min_data6){
$min_data6 = $value[2];
}
}
}
}
if($found_1 == 0){
$json_data_t1 = $json_data_t1 . ",";
}else{
$found_1 = 0;
}
if($found_2 == 0){
$json_data_t2 = $json_data_t2 . ",";
}else{
$found_2 = 0;
}
if($found_3 == 0){
$json_data_t3 = $json_data_t3 . ",";
}else{
$found_3 = 0;
}
if($found_4 == 0){
$json_data_t4 = $json_data_t4 . ",";
}else{
$found_4 = 0;
}
if($found_5 == 0){
$json_data_t5 = $json_data_t5 . ",";
}else{
$found_5 = 0;
}
if($found_6 == 0){
$json_data_t6 = $json_data_t6 . ",";
}else{
$found_6 = 0;
}
}
$json_data_t1 = $json_data_t1 . "]";
$json_data_t2 = $json_data_t2 . "]";
$json_data_t3 = $json_data_t3 . "]";
$json_data_t4 = $json_data_t4 . "]";
$json_data_t5 = $json_data_t5 . "]";
$json_data_t6 = $json_data_t6 . "]";
$avg_data1 = round($avg_data1/$x_data1,1);
$avg_data2 = round($avg_data2/$x_data2,1);
$avg_data3 = round($avg_data3/$x_data3,1);
$avg_data4 = round($avg_data4/$x_data4,1);
$avg_data5 = round($avg_data5/$x_data5,1);
$avg_data6 = round($avg_data6/$x_data6,1);
?>
<p></p>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<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>
<center>Visa: <a href="object.php?id=1&daysback=30">senaste månaden</a> | <a href="object.php?id=1&daysback=7">senaste veckan</a> | <a href="object.php?id=1&daysback=3">senaste 3 dagarna</a> | <a href="object.php?id=1&daysback=1">senaste dygnet</a> </center>
<div id="canvas-holder3" style="width:100%"></div>
<div style="width:100%;">
<canvas id="canvas3"></canvas>
</div>
<p><br>
Medeltemperatur, min och max för vald period: <br>
<table width="800" border="0">
<tbody>
<tr>
<td width="186">Utrymme:</td>
<td width="335">Medeltemperatur:</td>
<td width="218">Min:</td>
<td width="43">Max:</td>
</tr>
<tr>
<td>Butik:</td>
<td><?php echo($avg_data1);?>°C</td>
<td><?php echo(round($min_data1,1));?>°C</td>
<td><?php echo(round($max_data1,1));?>°C</td>
</tr>
<tr>
<td>Varumottagning:</td>
<td><?php echo($avg_data2);?>°C</td>
<td><?php echo(round($min_data2,1));?>°C</td>
<td><?php echo(round($max_data2,1));?>°C</td>
</tr>
<tr>
<td>Mejeri:</td>
<td><?php echo($avg_data3);?>°C</td>
<td><?php echo(round($min_data3,1));?>°C</td>
<td><?php echo(round($max_data3,1));?>°C</td>
</tr>
<tr>
<td>Teknik:</td>
<td><?php echo($avg_data4);?>°C</td>
<td><?php echo(round($min_data4,1));?>°C</td>
<td><?php echo(round($max_data4,1));?>°C</td>
</tr>
<tr>
<td>Personal:</td>
<td><?php echo($avg_data5);?>°C</td>
<td><?php echo(round($min_data5,1));?>°C</td>
<td><?php echo(round($max_data5,1));?>°C</td>
</tr>
<tr>
<td>Utomhustemp:</td>
<td><?php echo($avg_data6);?>°C</td>
<td><?php echo(round($min_data6,1));?>°C</td>
<td><?php echo(round($max_data6,1));?>°C</td>
</tr>
</tbody>
</table>
<br>
<br>
<script>
window.onload=function(){
var originalLineDraw = Chart.controllers.line.prototype.draw;
Chart.helpers.extend(Chart.controllers.line.prototype, {
draw: function() {
originalLineDraw.apply(this, arguments);
var chart = this.chart;
var ctx = chart.chart.ctx;
var index = chart.config.data.lineAtIndex;
if (index) {
var xaxis = chart.scales['x-axis-0'];
var yaxis = chart.scales['y-axis-0'];
ctx.save();
ctx.beginPath();
ctx.moveTo(xaxis.getPixelForValue(undefined, index), yaxis.top);
ctx.strokeStyle = '#ff0000';
ctx.lineTo(xaxis.getPixelForValue(undefined, index), yaxis.bottom);
ctx.stroke();
ctx.restore();
}
}
});
var config3 = {
type: 'line',
data: {
<?php echo($json_labels_t1);?>,
datasets: [{
label: 'Butik',
backgroundColor: window.chartColors.color3,
borderColor: window.chartColors.color3,
<?php echo($json_data_t1);?>,
fill: false,
},{
label: 'Varumottagning',
backgroundColor: window.chartColors.color4,
borderColor: window.chartColors.color4,
<?php echo($json_data_t2);?>,
fill: false,
},{
label: 'Mejeri',
backgroundColor: window.chartColors.color6,
borderColor: window.chartColors.color6,
<?php echo($json_data_t3);?>,
fill: false,
},{
label: 'Teknik',
backgroundColor: window.chartColors.color12,
borderColor: window.chartColors.color12,
<?php echo($json_data_t4);?>,
fill: false,
},{
label: 'Personal',
backgroundColor: window.chartColors.color13,
borderColor: window.chartColors.color13,
<?php echo($json_data_t5);?>,
fill: false,
},{
label: 'Utomhustemp i Motala',
backgroundColor: window.chartColors.color14,
borderColor: window.chartColors.color14,
<?php echo($json_data_t6);?>,
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'
}
}]
}
}
};
var ctx3 = document.getElementById('canvas3').getContext('2d');
var chart3 = new Chart(ctx3, config3);
window.myLine = chart3;
}
</script>
</p></td>
</tr>
</tbody>
</table>
<br>
<h1 class="rubrik"></h1>
<p></p></td>
</tr>
</table></p>
<p><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
</p>
</td>
</tr>
</tbody>
</table>
<?php }else if($_GET["id"] == 2) {?>
<table width="90%" border="0" class="rcorners">
<tbody>
<tr>
<td><table width="91%" border="0" align="left">
<tbody>
<tr>
<td width="6%" rowspan="2" align="center" valign="middle"><img src="images/house.png" width="50" height="50" alt=""/></td>
<td width="29%" rowspan="2" align="center" valign="top" style="font-size: 18px"><h2>Borensberg</h2></td>
<td width="10%" height="18" style="font-size: 14px">Fastighet: </td>
<td width="20%" style="font-size: 14px">Brunneby-hälla 1:287</td>
<td width="9%" style="font-size: 14px">Adress:</td>
<td width="26%" style="font-size: 14px">Hamnvägen 1</td>
</tr>
<tr>
<td style="font-size: 14px">Tjänster:</td>
<td style="font-size: 14px">Energy Viewer, Termisk filmning</td>
<td style="font-size: 14px">Typ:</td>
<td style="font-size: 14px">Butik</td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table>
<br>
<table width="90%" border="0" class="rcorners2">
<tbody>
<tr>
<td><table width="99%" border="0" align="left">
<tbody>
<tr>
<td width="1%"></td>
<td width="38%"><p><img src="images/borensberg.JPG" width="400" alt=""/></p>
<p> </p>
<p> </p>
<p> </p></td>
<td width="30%" valign="top"><br>
<br> <br></td>
<td width="31%" valign="top" style="color: #000000"><img src="images/forge_borensberg.JPG" alt="" width="404" height="292"/><br>
<center> <a href="http://111.93.24.58:3000/?urn=dXJuOmFkc2sub2JqZWN0czpvcy5vYmplY3Q6YXN0YWN1c19idWNrZXQvMzMzMzUtQS00MC1WLTFfMjAxMjEyMTRfMS5ydnQ="
target="popup"
onclick="window.open('http://111.93.24.58:3000/?urn=dXJuOmFkc2sub2JqZWN0czpvcy5vYmplY3Q6YXN0YWN1c19idWNrZXQvMzMzMzUtQS00MC1WLTFfMjAxMjEyMTRfMS5ydnQ=','popup','width=1200'); return false;"><br>
Öppna Energy Viewer</a> </center></td>
</tr>
</tbody>
</table>
<?php
if($_GET['daysback'] == ""){
$daysback = 14;
}else{
$daysback = $_GET['daysback'];
}
$date = date("Y-m-d H:00:00",strtotime("-$daysback days"));
$lables = array();
for ($x = 0; $x <= 24*$daysback; $x++) {
$lables[] = date("Y-m-d H:00:00",strtotime("-$daysback days +$x hours"));
}
$json_labels_t1 = "labels : [";
foreach ($lables as &$value) {
$json_labels_t1 = $json_labels_t1 . "'".$value ."',";
}
$json_labels_t1 = $json_labels_t1 . "]";
$data = array();
$sql = "SELECT * FROM tblEcoguard WHERE Time >= '".$date."' and Time LIKE '%00:00' and (SensorName = '00686450' or SensorName = '00686735' or SensorName = '00686734' or SensorName = '00686732' or SensorName = '00686733' or SensorName = '00038898') and (SensorType = 'T' or SensorType = 'OT')";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)){
$arr = array();
$arr[] = $row['Time'];
$arr[] = $row['SensorName'];
$arr[] = $row['Value'];
$data[] = $arr;
}
$avg_data1 = 0;
$avg_data2 = 0;
$avg_data3 = 0;
$avg_data4 = 0;
$avg_data5 = 0;
$avg_data6 = 0;
$max_data1 = -100;
$max_data2 = -100;
$max_data3 = -100;
$max_data4 = -100;
$max_data5 = -100;
$max_data6 = -100;
$min_data1 = 100;
$min_data2 = 100;
$min_data3 = 100;
$min_data4 = 100;
$min_data5 = 100;
$min_data6 = 100;
$x_data1 = 0;
$x_data2 = 0;
$x_data3 = 0;
$x_data4 = 0;
$x_data5 = 0;
$x_data6 = 0;
$json_data_t1 = "data : [";
$json_data_t2 = "data : [";
$json_data_t3 = "data : [";
$json_data_t4 = "data : [";
$json_data_t5 = "data : [";
$json_data_t6 = "data : [";
$found_1 = 0;$found_2 = 0;$found_3 = 0;$found_4 = 0;$found_5 = 0;$found_6 = 0;
foreach ($lables as &$lables_value) {
foreach ($data as &$value) {
if($value[1] == "00686450") {
if($value[0] == $lables_value){
$json_data_t1 = $json_data_t1 . $value[2].",";
$found_1 = 1;
$avg_data1 += $value[2];
$x_data1++;
if($value[2] > $max_data1){
$max_data1 = $value[2];
}
if($value[2] < $min_data1){
$min_data1 = $value[2];
}
}
}
if($value[1] == "00686735") {
if($value[0] == $lables_value){
$json_data_t2 = $json_data_t2 . $value[2].",";
$found_2 = 1;
$avg_data2 += $value[2];
$x_data2++;
if($value[2] > $max_data2){
$max_data2 = $value[2];
}
if($value[2] < $min_data2){
$min_data2 = $value[2];
}
}
}
if($value[1] == "00686734") {
if($value[0] == $lables_value){
$json_data_t3 = $json_data_t3 . $value[2].",";
$found_3 = 1;
$avg_data3 += $value[2];
$x_data3++;
if($value[2] > $max_data3){
$max_data3 = $value[2];
}
if($value[2] < $min_data3){
$min_data3 = $value[2];
}
}
}
if($value[1] == "00686732") {
if($value[0] == $lables_value){
$json_data_t4 = $json_data_t4 . $value[2].",";
$found_4 = 1;
$avg_data4 += $value[2];
$x_data4++;
if($value[2] > $max_data4){
$max_data4 = $value[2];
}
if($value[2] < $min_data4){
$min_data4 = $value[2];
}
}
}
if($value[1] == "00686733") {
if($value[0] == $lables_value){
$json_data_t5 = $json_data_t5 . $value[2].",";
$found_5 = 1;
$avg_data5 += $value[2];
$x_data5++;
if($value[2] > $max_data5){
$max_data5 = $value[2];
}
if($value[2] < $min_data5){
$min_data5 = $value[2];
}
}
}
if($value[1] == "00038898") {
if($value[0] == $lables_value){
$json_data_t6 = $json_data_t6 . $value[2].",";
$found_6 = 1;
$avg_data6 += $value[2];
$x_data6++;
if($value[2] > $max_data6){
$max_data6 = $value[2];
}
if($value[2] < $min_data6){
$min_data6 = $value[2];
}
}
}
}
if($found_1 == 0){
$json_data_t1 = $json_data_t1 . ",";
}else{
$found_1 = 0;
}
if($found_2 == 0){
$json_data_t2 = $json_data_t2 . ",";
}else{
$found_2 = 0;
}
if($found_3 == 0){
$json_data_t3 = $json_data_t3 . ",";
}else{
$found_3 = 0;
}
if($found_4 == 0){
$json_data_t4 = $json_data_t4 . ",";
}else{
$found_4 = 0;
}
if($found_5 == 0){
$json_data_t5 = $json_data_t5 . ",";
}else{
$found_5 = 0;
}
if($found_6 == 0){
$json_data_t6 = $json_data_t6 . ",";
}else{
$found_6 = 0;
}
}
$json_data_t1 = $json_data_t1 . "]";
$json_data_t2 = $json_data_t2 . "]";
$json_data_t3 = $json_data_t3 . "]";
$json_data_t4 = $json_data_t4 . "]";
$json_data_t5 = $json_data_t5 . "]";
$json_data_t6 = $json_data_t6 . "]";
$avg_data1 = round($avg_data1/$x_data1,1);
$avg_data2 = round($avg_data2/$x_data2,1);
$avg_data3 = round($avg_data3/$x_data3,1);
$avg_data4 = round($avg_data4/$x_data4,1);
$avg_data5 = round($avg_data5/$x_data5,1);
$avg_data6 = round($avg_data6/$x_data6,1);
?>
<center>Visa: <a href="object.php?id=2&daysback=30">senaste månaden</a> | <a href="object.php?id=2&daysback=7">senaste veckan</a> | <a href="object.php?id=2&daysback=3">senaste 3 dagarna</a> | <a href="object.php?id=2&daysback=1">senaste dygnet</a> </center>
<p><div id="canvas-holder3" style="width:100%"></div>
<div style="width:100%;">
<canvas id="canvas3"></canvas>
</div></p>
<p><br>
Medeltemperatur, min och max för vald period: <br>
</p>
<table width="800" border="0">
<tbody>
<tr>
<td width="186">Utrymme:</td>
<td width="335">Medeltemperatur:</td>
<td width="218">Min:</td>
<td width="43">Max:</td>
</tr>
<tr>
<td>Butik:</td>
<td><?php echo($avg_data1);?>°C</td>
<td><?php echo(round($min_data1,1));?>°C</td>
<td><?php echo(round($max_data1,1));?>°C</td>
</tr>
<tr>
<td>Varumottagning:</td>
<td><?php echo($avg_data2);?>°C</td>
<td><?php echo(round($min_data2,1));?>°C</td>
<td><?php echo(round($max_data2,1));?>°C</td>
</tr>
<tr>
<td>Mejeri:</td>
<td><?php echo($avg_data3);?>°C</td>
<td><?php echo(round($min_data3,1));?>°C</td>
<td><?php echo(round($max_data3,1));?>°C</td>
</tr>
<tr>
<td>Teknik:</td>
<td><?php echo($avg_data4);?>°C</td>
<td><?php echo(round($min_data4,1));?>°C</td>
<td><?php echo(round($max_data4,1));?>°C</td>
</tr>
<tr>
<td>Personal:</td>
<td><?php echo($avg_data5);?>°C</td>
<td><?php echo(round($min_data5,1));?>°C</td>
<td><?php echo(round($max_data5,1));?>°C</td>
</tr>
<tr>
<td>Utomhustemp:</td>
<td><?php echo($avg_data6);?>°C</td>
<td><?php echo(round($min_data6,1));?>°C</td>
<td><?php echo(round($max_data6,1));?>°C</td>
</tr>
</tbody>
</table>
<p><br>
<script>
window.onload=function(){
var originalLineDraw = Chart.controllers.line.prototype.draw;
Chart.helpers.extend(Chart.controllers.line.prototype, {
draw: function() {
originalLineDraw.apply(this, arguments);
var chart = this.chart;
var ctx = chart.chart.ctx;
var index = chart.config.data.lineAtIndex;
if (index) {
var xaxis = chart.scales['x-axis-0'];
var yaxis = chart.scales['y-axis-0'];
ctx.save();
ctx.beginPath();
ctx.moveTo(xaxis.getPixelForValue(undefined, index), yaxis.top);
ctx.strokeStyle = '#ff0000';
ctx.lineTo(xaxis.getPixelForValue(undefined, index), yaxis.bottom);
ctx.stroke();
ctx.restore();
}
}
});
var config3 = {
type: 'line',
data: {
<?php echo($json_labels_t1);?>,
datasets: [{
label: 'Butik',
backgroundColor: window.chartColors.color3,
borderColor: window.chartColors.color3,
<?php echo($json_data_t1);?>,
fill: false,
},{
label: 'Varumottagning',
backgroundColor: window.chartColors.color4,
borderColor: window.chartColors.color4,
<?php echo($json_data_t2);?>,
fill: false,
},{
label: 'Mejeri',
backgroundColor: window.chartColors.color6,
borderColor: window.chartColors.color6,
<?php echo($json_data_t3);?>,
fill: false,
},{
label: 'Bageri',
backgroundColor: window.chartColors.color12,
borderColor: window.chartColors.color12,
<?php echo($json_data_t4);?>,
fill: false,
},{
label: 'Personal',
backgroundColor: window.chartColors.color13,
borderColor: window.chartColors.color13,
<?php echo($json_data_t5);?>,
fill: false,
},{
label: 'Utomhustemp i Motala',
backgroundColor: window.chartColors.color14,
borderColor: window.chartColors.color14,
<?php echo($json_data_t6);?>,
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'
}
}]
}
}
};
var ctx3 = document.getElementById('canvas3').getContext('2d');
var chart3 = new Chart(ctx3, config3);
window.myLine = chart3;
}
</script>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
</p></td>
</tr>
</tbody>
</table>
<?php }else if($_GET["id"] == 3) {?>
<table width="90%" border="0" class="rcorners">
<tbody>
<tr>
<td>
<table width="91%" border="0" align="left">
<tbody>
<tr>
<td width="6%" rowspan="2" align="center" valign="middle"><img src="images/house.png" width="50" height="50" alt=""/></td>
<td width="29%" rowspan="2" align="center" valign="top" style="font-size: 18px">Strandvägen 3</td>
<td width="10%" height="18" style="font-size: 16px">Fastighet: </td>
<td width="20%" style="font-size: 16px">Kungsfisket 1</td>
<td width="9%" style="font-size: 16px">Adress:</td>
<td width="26%" style="font-size: 16px">Strandvägen 3</td>
</tr>
<tr>
<td style="font-size: 16px">Storlek:</td>
<td style="font-size: 16px">550 kvm</td>
<td style="font-size: 16px">Typ:</td>
<td style="font-size: 16px">Kontor</td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table>
<br>
<table width="90%" border="0" class="rcorners2">
<tbody>
<tr>
<td><table width="99%" border="0" align="left">
<tbody>
<tr>
<td width="1%"></td>
<td width="38%"><br> <img src="images/strand.png" width="254" alt=""/></td>
<td width="30%" valign="top"><br>
<img src="images/truview.png" width="200" alt=""/><br>
<br>
<img src="images/forge.png" width="200" alt=""/></td>
<td width="31%" valign="top" style="color: #000000"><br>
<strong>Ladda ner: </strong><br>
<a href="http://appsrv.astacus.se/digitaltwin/upload/strand/400.rvt">Revit 2020 (RVT)</a> 105 Mb<br>
<a href="http://appsrv.astacus.se/digitaltwin/upload/strand/400.ifc">Generisk IFC</a> 53 Mb<br>
<br>
<a href="#">RCP/RCS</a> 15 Gb<br>
<a href="#">LAS</a> 10 Gb<br>
<a href="#">IMP</a> 55 Gb</td>
</tr>
</tbody>
</table>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<hr>
<table width="90%" border="0" align="left">
<tbody>
<tr>
<td width="1%"></td>
<td width="42%" valign="top"><strong>Truview:</strong><br>
<a href="#rutan" onClick="iframe_call('http://truview.astacus.se/embed/map/61794c7a23ccde1a44b7a191?tools=true&minimap=true');">PLAN 2</a>
<p><br>
</a> </p></td>
<td width="33%" valign="top"><strong>Energiviewer:</strong><br>
<a href="#rutan" onClick="iframe_call('http://192.168.30.120:3000/?urn=dXJuOmFkc2sub2JqZWN0czpvcy5vYmplY3Q6N3N1cHZ5YnRhZ3BhczAxbWZ3cnpvdDRxcmg1YWxmMGctdGVzdF9idWNrZXQvU3RyYW5kdmElQ0MlODhnZW4lMjAzJTIwLSUyMFNFTlNPUkVSJTIwTkVXJTIwSDE2LnJ2dA==');">Viewer</a><br>
<br>
<br>
<br></td>
<td width="24%" valign="top" style="color: #000000"><strong>Rumsförteckning:</strong><br> <br></td>
</tr>
</tbody>
</table>
<br></td>
</tr>
</tbody>
</table>
<?php }else if($_GET["id"] == 4) {?>
<table width="90%" border="0" align="center">
<tbody>
<tr>
<td><table width="100%" border="0" class="rcorners">
<tbody>
<tr>
<td><table width="91%" border="0" align="left">
<tbody>
<tr>
<td width="6%" rowspan="2" align="center" valign="middle"><img src="images/house.png" width="50" height="50" alt=""/></td>
<td width="29%" rowspan="2" align="center" valign="top" style="font-size: 18px">Postgatan 16</td>
<td width="10%" height="18" style="font-size: 14px">Fastighet: </td>
<td width="20%" style="font-size: 14px">Nordstaden 17:7</td>
<td width="9%" style="font-size: 14px">Adress:</td>
<td width="26%" style="font-size: 14px">Postgatan 16</td>
</tr>
<tr>
<td style="font-size: 14px">Storlek:</td>
<td style="font-size: 14px"> </td>
<td style="font-size: 14px">Typ:</td>
<td style="font-size: 14px">Kontor</td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table>
<br>
<table width="90%" border="0" class="rcorners2">
<tbody>
<tr>
<td><table width="99%" border="0" align="left">
<tbody>
<tr>
<td width="1%"></td>
<td width="38%"><br> <img src="images/postgatan.png" width="254" alt=""/></td>
<td width="30%" valign="top"><br>
<img src="images/truview.png" width="200" alt=""/><br>
<br></td>
<td width="31%" valign="top" style="color: #000000"><br>
<strong>Ladda ner: </strong><br></td>
</tr>
</tbody>
</table>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<hr>
<table width="90%" border="0" align="left">
<tbody>
<tr>
<td width="1%"></td>
<td width="42%" valign="top"><strong>Truview:</strong><br>
<a href="#rutan" onClick="iframe_call('http://appsrv.astacus.se/digitaltwin/pannellum/');">PLAN 4</a>
<p><br>
</a> </p></td>
<td width="33%" valign="top"><strong>Forge:</strong><br>
<br>
<br>
<br>
<br></td>
<td width="24%" valign="top" style="color: #000000"><strong>Rumsförteckning:</strong><br> <br></td>
</tr>
</tbody>
</table>
<br></td>
</tr>
</tbody>
</table>
<?php }?>
<p><iframe src="blank.php" width="90%" height="1224px" id="rutan" frameborder="0"></iframe></p>
<p><hr></p>
<p><iframe src="blank.php" width="90%" height="1224px" id="rutan2" frameborder="0"></iframe></p>
<p></p>
<p> </p>
<p> </p>
<p> </p>
<p> </p></td>
</tr>
</tbody>
</table>
</body>
</html>
<script>
var h = window.screen.availHeight;
document.getElementById("rutan").height = h*0.95;
</script>