| 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 : /var/www/appsrv.astacus.se/energicontrol/skanninge/ |
Upload File : |
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
$mysqli = new mysqli("www.astacus.se", "carlhoffstedt", "Astacus2020!", "ostenssons_skanninge");
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Namnlöst dokument</title>
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<script src="js/package/dist/utils.js"></script>
<style>
table, th, td {
font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', 'Helvetica', 'Arial', 'sans-serif';
font-size: 8px;
border-collapse: collapse;
}
</style>
</head>
<body>
<center>
</center>
<canvas id="myChart" width="100%" height="100%"></canvas>
<?php
$from = date("Y-m-d",strtotime("-1 days"))." 00:00:00";
$sql = "SELECT * FROM CAREL WHERE CAREL.Timestamp >= '".$from."' order by CAREL.Timestamp";
$result = $mysqli->query($sql);
$json_labels_t = "[";
$labels_arr = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->Timestamp;
$json_labels_t = $json_labels_t . "'". $timestamp ."',";
$labels_arr[] = $timestamp;
}
$json_labels_t = $json_labels_t . "]";
$sql = "SELECT * FROM CAREL WHERE CAREL.Timestamp >= '".$from."' order by CAREL.Timestamp";
$result = $mysqli->query($sql);
$arr1 = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->Timestamp;
$value = $obj->GasCoolerpressure;
$arr1[] = array($timestamp,$value);
}
$sql = " SELECT * FROM VS11_LOG WHERE VS11_LOG.Timestamp >= '".$from."' order by VS11_LOG.Timestamp";
$result = $mysqli->query($sql);
$arr2 = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->Timestamp;
$value = $obj->RUM1GT41;
$arr2[] = array($timestamp,$value);
}
$sql = " SELECT * FROM VS11_LOG WHERE VS11_LOG.Timestamp >= '".$from."' order by VS11_LOG.Timestamp";
$result = $mysqli->query($sql);
$arr5 = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->Timestamp;
$value = $obj->RUM1GT42;
$arr5[] = array($timestamp,$value);
}
$sql = "SELECT * FROM VS11_LOG WHERE VS11_LOG.Timestamp >= '".$from."' order by VS11_LOG.Timestamp";
$result = $mysqli->query($sql);
$arr3 = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->Timestamp;
$value = $obj->AS01GT41;
$arr3[] = array($timestamp,$value);
}
$sql = " SELECT * FROM SWEGON_LOGG WHERE SWEGON_LOGG.Timestamp >= '".$from."' AND UNIT = 206 order by SWEGON_LOGG.Timestamp";
$result = $mysqli->query($sql);
$arr4 = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->Timestamp;
$value = $obj->airsuplly_temp/100;
$arr4[] = array($timestamp,$value);
}
$sql = " SELECT * FROM SWEGON_LOGG WHERE SWEGON_LOGG.Timestamp >= '".$from."' AND UNIT = 206 order by SWEGON_LOGG.Timestamp";
$result = $mysqli->query($sql);
$arr6 = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->Timestamp;
$value = $obj->exhaust_temp/100;
$arr6[] = array($timestamp,$value);
}
$sql = " SELECT * FROM ELPATRON_VS11 WHERE ELPATRON_VS11.Timestamp >= '".$from."' order by ELPATRON_VS11.Timestamp";
$result = $mysqli->query($sql);
$arr7 = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->Timestamp;
$value = $obj->CURRENT_VOLTAGE;
$arr7[] = array($timestamp,$value);
}
$sql = " SELECT * FROM SWEGON_LOGG WHERE SWEGON_LOGG.Timestamp >= '".$from."' AND UNIT = 206 order by SWEGON_LOGG.Timestamp";
$result = $mysqli->query($sql);
$arr8 = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->Timestamp;
$value = $obj->airflow_supply/1000;
$arr8[] = array($timestamp,$value);
}
$sql = " SELECT * FROM VENTILATION_VS11 WHERE VENTILATION_VS11.Timestamp >= '".$from."' order by VENTILATION_VS11.Timestamp";
$result = $mysqli->query($sql);
$arr9 = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->Timestamp;
$value = $obj->CURRENT_VOLTAGE;
$arr9[] = array($timestamp,$value);
}
$sql = " SELECT * FROM VENTILATION_VS12 WHERE VENTILATION_VS12.Timestamp >= '".$from."' order by VENTILATION_VS12.Timestamp";
$result = $mysqli->query($sql);
$arr10 = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->Timestamp;
$value = $obj->CURRENT_VOLTAGE;
$arr10[] = array($timestamp,$value);
}
$json_data_t1 = "data : [";
$json_data_t2 = "data : [";
$json_data_t3 = "data : [";
$json_data_t4 = "data : [";
$json_data_t5 = "data : [";
$json_data_t6 = "data : [";
$json_data_t7 = "data : [";
$json_data_t8 = "data : [";
$json_data_t9 = "data : [";
$json_data_t10 = "data : [";
foreach ($labels_arr as &$value) {
$f1 = false;
foreach ($arr1 as &$v1) {
if($v1[0] == $value){
$json_data_t1 = $json_data_t1 . $v1[1].",";
$f1 = true;
}
}
if($f1 == false){
$json_data_t1 = $json_data_t1 .",";
}
$f1 = false;
foreach ($arr2 as &$v1) {
if($v1[0] == $value){
$json_data_t2 = $json_data_t2 . $v1[1].",";
$f1 = true;
}
}
if($f1 == false){
$json_data_t2 = $json_data_t2 .",";
}
$f1 = false;
foreach ($arr3 as &$v1) {
if($v1[0] == $value){
$json_data_t3 = $json_data_t3 . $v1[1].",";
$f1 = true;
}
}
if($f1 == false){
$json_data_t3 = $json_data_t3 .",";
}
$f1 = false;
foreach ($arr4 as &$v1) {
if($v1[0] == $value){
$json_data_t4 = $json_data_t4 . $v1[1].",";
$f1 = true;
}
}
if($f1 == false){
$json_data_t4 = $json_data_t4 .",";
}
$f1 = false;
foreach ($arr5 as &$v1) {
if($v1[0] == $value){
$json_data_t5 = $json_data_t5 . $v1[1].",";
$f1 = true;
}
}
if($f1 == false){
$json_data_t5 = $json_data_t5 .",";
}
$f1 = false;
foreach ($arr6 as &$v1) {
if($v1[0] == $value){
$json_data_t6 = $json_data_t6 . $v1[1].",";
$f1 = true;
}
}
if($f1 == false){
$json_data_t6 = $json_data_t6 .",";
}
$f1 = false;
foreach ($arr7 as &$v1) {
if($v1[0] == $value){
$json_data_t7 = $json_data_t7 . $v1[1].",";
$f1 = true;
$v7 = $v1[1];
}
}
if($f1 == false){
$json_data_t7 = $json_data_t7. $v7.",";
}
$f1 = false;
foreach ($arr8 as &$v1) {
if($v1[0] == $value){
$json_data_t8 = $json_data_t8 . $v1[1].",";
$f1 = true;
}
}
if($f1 == false){
$json_data_t8 = $json_data_t8 .",";
}
$f1 = false;
foreach ($arr9 as &$v1) {
if($v1[0] == $value){
$json_data_t9 = $json_data_t9 . $v1[1].",";
$f1 = true;
$v9 = $v1[1];
}
}
if($f1 == false){
$json_data_t9 = $json_data_t9 .$v9.",";
}
$f1 = false;
foreach ($arr10 as &$v1) {
if($v1[0] == $value){
$json_data_t10 = $json_data_t10 . $v1[1].",";
$f1 = true;
$v10 = $v1[1];
}
}
if($f1 == false){
$json_data_t10 = $json_data_t10 . $v10.",";
}
}
$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 . "]";
$json_data_t7 = $json_data_t7 . "]";
$json_data_t8 = $json_data_t8 . "]";
$json_data_t9 = $json_data_t9 . "]";
$json_data_t10 = $json_data_t10 . "]";
?>
<script>
const labels = <?php echo($json_labels_t);?>;
const data = {
labels: labels,
datasets: [
{
label: 'Gas cooler presure',
<?php echo($json_data_t1);?>,
borderColor: '#FF0000',
backgroundColor: '#FF0000',
stepped: false,
fill: false,
yAxisID: 'y'
},
{
label: 'Kassalinjen',
<?php echo($json_data_t2);?>,
borderColor: '#00FFF0',
backgroundColor: '#00FFF0',
stepped: false,
fill: false,
yAxisID: 'y1'
},
{
label: 'Butiken',
<?php echo($json_data_t5);?>,
borderColor: '#CFFFF0',
backgroundColor: '#CFFFF0',
stepped: false,
fill: false,
yAxisID: 'y1'
},
{
label: 'Utetemp',
<?php echo($json_data_t3);?>,
borderColor: '#0000FF',
backgroundColor: '#0000FF',
stepped: false,
fill: false,
yAxisID: 'y1'
},
{
label: 'Tilluftstemp',
<?php echo($json_data_t4);?>,
borderColor: '#00FF00',
backgroundColor: '#00FF00',
stepped: false,
fill: false,
yAxisID: 'y1'
},
{
label: 'Frånluftstemp',
<?php echo($json_data_t6);?>,
borderColor: '#00FFCC',
backgroundColor: '#00FFCC',
stepped: false,
fill: false,
yAxisID: 'y1'
},
{
label: 'Elpanna (V)',
<?php echo($json_data_t7);?>,
borderColor: '#c1c674',
backgroundColor: '#c1c674',
stepped: true,
type: 'line',
fill: false,
yAxisID: 'y3'
},
{
label: 'VS11 (V)',
<?php echo($json_data_t9);?>,
borderColor: '#eaf715',
backgroundColor: '#eaf715',
stepped: true,
type: 'line',
fill: false,
yAxisID: 'y3'
},
{
label: 'VS12 (V)',
<?php echo($json_data_t10);?>,
type: 'line',
borderColor: '#f7aa15',
backgroundColor: '#f7aa15',
stepped: true,
fill: false,
yAxisID: 'y3'
},
{
label: 'Luftflöde tilluft',
<?php echo($json_data_t8);?>,
borderColor: '#00BBDA',
backgroundColor: '#00BBDA',
stepped: false,
fill: false,
yAxisID: 'y4'
},
]
};
const config = {
maintainAspectRatio: true,
type: 'line',
data: data,
options: {
responsive: true,
plugins: {
title: {
display: true,
text: 'Östenssons Skänninge',
},
},
scales: {
y: {
type: 'linear',
position: 'left',
stack: 'demo',
stackWeight: 4,
},
y1: {
type: 'linear',
position: 'left',
stack: 'demo',
stackWeight: 3,
}
,
y3: {
type: 'linear',
position: 'left',
stack: 'demo',
stackWeight: 2,
}
,
y4: {
type: 'linear',
position: 'left',
stack: 'demo',
stackWeight: 1,
}
}
},
};
const myChart = new Chart(
document.getElementById('myChart'),
config
);
</script>
</div>
</body>
</html>