| Server IP : 79.136.114.73 / Your IP : 3.135.218.109 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/meo/app/ |
Upload File : |
<?php
include '../setup.php';
$mysqli = new mysqli("www.astacus.se", "carlhoffstedt", "Astacus2020!", "ostenssons_skanninge");
if($_GET['day'] == ""){
$day = 0;
$show_date = date("Y-m-d");
}else{
$day = $_GET['day'];
$show_date = date("Y-m-d", strtotime("$day days"));
}
if($_GET['day'] == ""){
$day1 = -1;
$day2 = +1;
}else{
$day1 = $_GET['day']-1;
$day2 = $_GET['day']+1;
}
?>
<!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>
<a href="?day=<?php echo($day1);?>"><-- <?php echo(date("Y-m-d",strtotime(($day-1)." day")));?></a> | <strong><?php echo($show_date);?></strong> | <a href="?day=<?php echo($day2);?>"><?php echo(date("Y-m-d",strtotime(($day+1)." day")));?> --></a>
</center>
<div align="center">
<br>
<div style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif';font-size: 28px">
Medeltemp: <span id="medeltemp"></span> | Utetemp: <span id="utetemp"></span> | Gas Cooler pressure: <span id="presure"></span>
</div>
<canvas id="myChart" width="100%"></canvas>
</div>
<?php
$from = date("Y-m-d",strtotime("$day1 days"))." 00:00:00";
$to = date("Y-m-d",strtotime("$day2 days"))." 24:00:00";
$extra = "and VS11_LOG.Timestamp LIKE '%:00:00' ";
$extra1 = "and CAREL.Timestamp LIKE '%:00:00' ";
if($_GET['zoom'] == "true"){
$extra = "";
$extra1 = "";
}
$sql = "SELECT VS11_LOG.RUM1GT42 as RUM1GT42, VS11_LOG.RUM1GT41 as RUM1GT41, VS11_LOG.MEDELGT41GT42 as MEDELGT41GT42, VS11_LOG.AS01GT41 as AS01GT41, VS11_LOG.CURRENT_VOLTAGE as CURRENT_VOLTAGE_VS11, VS11_LOG.VS11GT42 as VS11GT42, VS11_LOG.Timestamp as Timestamp_VS11, CO2_TRYCK.CURRENT_VOLTAGE as CURRENT_VOLTAGE_CO2, ELPATRON_VS11.CURRENT_VOLTAGE as CURRENT_VOLTAGE_EL, VS11_LOG.VS12GT11 as VS12GT11, SWEGON.VALUE as SWEGON FROM VS11_LOG, CO2_TRYCK, ELPATRON_VS11, SWEGON WHERE CO2_TRYCK.Timestamp = VS11_LOG.Timestamp and ELPATRON_VS11.Timestamp = VS11_LOG.Timestamp and SWEGON.Timestamp = VS11_LOG.Timestamp and VS11_LOG.Timestamp >= '".$from."' and VS11_LOG.Timestamp <= '".$to."' $extra order by VS11_LOG.Timestamp";
$result = $mysqli->query($sql);
$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 : [";
$json_data_t11 = "data : [";
$json_data_t12 = "data : [";
$json_labels_t = "[";
$x = 0;
$medeltemp = 0;
$utetemp = 0;
while($obj = $result->fetch_object()){
$labels = substr($obj->Timestamp_VS11,0,strlen("2023-05-17 11:30"));
$json_labels_t = $json_labels_t . "'". $labels ."',";
$json_data_t7 = $json_data_t7 . $obj->RUM1GT42.",";
$json_data_t8 = $json_data_t8 . $obj->RUM1GT41.",";
$json_data_t2 = $json_data_t2 . $obj->MEDELGT41GT42.",";
$json_data_t3 = $json_data_t3 . $obj->AS01GT41.",";
$medeltemp = $obj->MEDELGT41GT42;
$utetemp = $obj->AS01GT41;
$json_data_t4 = $json_data_t4 . $obj->CURRENT_VOLTAGE_VS11.",";
$json_data_t5 = $json_data_t5 . $obj->VS11GT42.",";
$json_data_t9 = $json_data_t9 . $obj->CURRENT_VOLTAGE_CO2.",";
$json_data_t10 = $json_data_t10 . $obj->CURRENT_VOLTAGE_EL.",";
$json_data_t11 = $json_data_t11 . $obj->VS12GT11.",";
if($obj->SWEGON > 2){
$json_data_t12 = $json_data_t12 . "'3000 l/s',";
}else{
$json_data_t12 = $json_data_t12 . "'1000 l/s',";
}
}
$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 . "]";
$json_data_t11 = $json_data_t11 . "]";
$json_data_t12 = $json_data_t12 . "]";
$json_labels_t = $json_labels_t . "]";
// POWER /////////////////////////////////////////////////////////////////////////////
$sql = "SELECT * FROM VS11_LOG WHERE VS11_LOG.Timestamp >= '".$from."' and VS11_LOG.Timestamp <= '".$to."' $extra order by VS11_LOG.Timestamp";
$result = $mysqli->query($sql);
$json_data_t13 = "data : [";
$json_data_t14 = "data : [";
$PowerKM_old = 0;
$PowerGOLD_old = 0;
$timestamps = array();
while($obj = $result->fetch_object()){
$PowerKM = $obj->PowerKM;
$Diff = $PowerKM - $PowerKM_old;
$PowerKM_old = $PowerKM;
if( $Diff < 0 || $Diff > 90){
$Diff = 0;
}
$json_data_t13 = $json_data_t13 . $Diff.",";
$PowerGOLD = $obj->PowerLA1;
$Diff1 = $PowerGOLD - $PowerGOLD_old;
$PowerGOLD_old = $PowerGOLD;
if( $Diff1 < 0 || $Diff1 > 3){
$Diff1 = 0;
}
$json_data_t14 = $json_data_t14 . $Diff1.",";
$timestamps[] = $obj->Timestamp;
}
$json_data_t13 = $json_data_t13 . "]";
$json_data_t14 = $json_data_t14 . "]";
/// CAREL /////////////////////////////////////////////////////////////////////////////
$sql = "SELECT * FROM CAREL WHERE CAREL.Timestamp >= '".$from."' and CAREL.Timestamp <= '".$to."' $extra1 order by CAREL.Timestamp";
$result = $mysqli->query($sql);
$json_data_t15 = "data : [";
$json_data_t16 = "data : [";
$json_data_t17 = "data : [";
$json_data_t18 = "data : [";
$json_data_t19 = "data : [";
$json_data_t20 = "data : [";
$json_data_t21 = "data : [";
$json_data_t22 = "data : [";
/* $first_data = "2023-05-24 12:00:00";
$str = "";
foreach ($timestamps as &$times) {
if($times == $first_data){
break;
}else{
$str = $str . "0,";
}
}
if( $str != ""){
$str = substr($str,0, strlen($str) -2);
}
*/
$x = 0;
$presure = 0;
while($obj = $result->fetch_object()){
if($x == 0){
$json_data_t15 = $json_data_t15 . $str ;
$json_data_t16 = $json_data_t16 . $str ;
$json_data_t17 = $json_data_t17 . $str ;
$json_data_t18 = $json_data_t18 . $str ;
$json_data_t19 = $json_data_t19 . $str ;
$x++;
}
$GasCoolerpressure = $obj->GasCoolerpressure;
$L1Suctionsetpoint = $obj->L1Suctionsetpoint;
$L1Suctionpressure = $obj->L1Suctionpressure;
$L2Suctionsetpoint = $obj->L2Suctionsetpoint;
$L2Suctionpressure = $obj->L2Suctionpressure;
$L1Gascooleroutlettemperature = $obj->L1Gascooleroutlettemperature;
$L1Externaltemperature = $obj->L1Externaltemperature;
$L1Activefanspowerpercent = $obj->L1Activefanspowerpercent;
$presure = $GasCoolerpressure;
$json_data_t15 = $json_data_t15 . $GasCoolerpressure.",";
$json_data_t16 = $json_data_t16 . $L1Suctionsetpoint.",";
$json_data_t17 = $json_data_t17 . $L1Suctionpressure.",";
$json_data_t18 = $json_data_t18 . $L2Suctionsetpoint.",";
$json_data_t19 = $json_data_t19 . $L2Suctionpressure.",";
$json_data_t20 = $json_data_t20 . $L1Gascooleroutlettemperature.",";
$json_data_t21 = $json_data_t21 . $L1Externaltemperature.",";
$json_data_t22 = $json_data_t22 . $L1Activefanspowerpercent.",";
}
$json_data_t15 = $json_data_t15 . "]";
$json_data_t16 = $json_data_t16 . "]";
$json_data_t17 = $json_data_t17 . "]";
$json_data_t18 = $json_data_t18 . "]";
$json_data_t19 = $json_data_t19 . "]";
$json_data_t20 = $json_data_t20 . "]";
$json_data_t21 = $json_data_t21 . "]";
$json_data_t22 = $json_data_t22 . "]";
?>
<script>
const labels = <?php echo($json_labels_t);?>;
const data = {
labels: labels,
datasets: [
{
label: 'MEDELGT41GT42',
<?php echo($json_data_t2);?>,
borderColor: '#FF0000',
backgroundColor: '#FF0000',
stepped: false,
fill: false,
yAxisID: 'y'
}, {
label: 'AS01GT41',
<?php echo($json_data_t3);?>,
borderColor: '#00FF00',
backgroundColor: '#00FF00',
stepped: false,
fill: false,
yAxisID: 'y'
}, {
label: 'VS11-LA1',
<?php echo($json_data_t4);?>,
borderColor: '#0000FF',
backgroundColor: '#0000FF',
stepped: false,
fill: false,
yAxisID: 'y3'
}, {
label: 'CO2-TRYCK',
<?php echo($json_data_t9);?>,
borderColor: '#00a8ff',
backgroundColor: '#00a8ff',
stepped: false,
fill: false,
yAxisID: 'y3'
}, {
label: 'ELPATRON',
<?php echo($json_data_t10);?>,
borderColor: '#78d1ff',
backgroundColor: '#78d1ff',
stepped: false,
fill: false,
yAxisID: 'y3'
},{
label: 'VS11GT42',
<?php echo($json_data_t5);?>,
borderColor: '#FF00FF',
backgroundColor: '#FF00FF',
stepped: false,
fill: false,
yAxisID: 'y'
},{
label: 'VS12GT11',
<?php echo($json_data_t11);?>,
borderColor: '#fc88fb',
backgroundColor: '#fc88fb',
stepped: false,
fill: false,
yAxisID: 'y'
},{
label: 'RUM1GT41',
<?php echo($json_data_t8);?>,
borderColor: '#FFD000',
backgroundColor: '#FFD000',
stepped: false,
fill: false,
yAxisID: 'y'
},{
label: 'RUM1GT42',
<?php echo($json_data_t7);?>,
borderColor: '#FFF000',
backgroundColor: '#FFF000',
stepped: false,
fill: false,
yAxisID: 'y'
},{
label: 'POWER GOLD',
<?php echo($json_data_t14);?>,
borderColor: '#FF0FF0',
backgroundColor: '#FF0FF0',
stepped: true,
fill: true,
yAxisID: 'y4'
},
{
label: 'POWER KM',
<?php echo($json_data_t13);?>,
borderColor: '#FF0000',
backgroundColor: '#FF0000',
stepped: true,
fill: true,
yAxisID: 'y4'
},
{
label: 'SWEGON',
<?php echo($json_data_t12);?>,
borderColor: '#FFF000',
backgroundColor: '#FFF000',
stepped: true,
fill: false,
yAxisID: 'y2'
},
{
label: 'Gas Cooler pressure',
<?php echo($json_data_t15);?>,
borderColor: '#008e11',
backgroundColor: '#008e11',
stepped: true,
fill: false,
yAxisID: 'y5'
},
{
label: 'L1 - Suctionset point',
<?php echo($json_data_t16);?>,
borderColor: '#00c417',
backgroundColor: '#00c417',
stepped: true,
fill: false,
yAxisID: 'y5'
},
{
label: 'L1 - Suction pressure',
<?php echo($json_data_t17);?>,
borderColor: '#19d32f',
backgroundColor: '#19d32f',
stepped: true,
fill: false,
yAxisID: 'y5'
},
{
label: 'L2 - Suctionset point',
<?php echo($json_data_t18);?>,
borderColor: '#54ed66',
backgroundColor: '#54ed66',
stepped: true,
fill: false,
yAxisID: 'y5'
},
{
label: 'L2 - Suction pressure',
<?php echo($json_data_t19);?>,
borderColor: '#99ffa5',
backgroundColor: '#99ffa5',
stepped: true,
fill: false,
yAxisID: 'y5'
},
{
label: 'L1 - Active fans power percent',
<?php echo($json_data_t22);?>,
borderColor: '#990000',
backgroundColor: '#990000',
stepped: true,
fill: false,
yAxisID: 'y5'
},
{
label: 'L1 External temperature',
<?php echo($json_data_t21);?>,
borderColor: '#99ffa5',
backgroundColor: '#99ffa5',
stepped: true,
fill: false,
yAxisID: 'y5'
},
{
label: 'L1 - Gas cooler outlet temperature',
<?php echo($json_data_t20);?>,
borderColor: '#99ffa5',
backgroundColor: '#99ffa5',
stepped: true,
fill: false,
yAxisID: 'y5'
}
]
};
const config = {
maintainAspectRatio: true,
type: 'line',
data: data,
options: {
responsive: true,
plugins: {
title: {
display: true,
text: 'Östenssons Skänninge',
},
},
scales: {
y2: {
type: 'category',
labels: ['3000 l/s', '1000 l/s'],
offset: true,
position: 'left',
stack: 'demo',
stackWeight: 1,
},
y: {
type: 'linear',
position: 'left',
stack: 'demo',
stackWeight: 2,
}, y4: {
type: 'linear',
position: 'left',
stack: 'demo',
stackWeight: 4,
}, y5: {
type: 'linear',
position: 'left',
stack: 'demo',
stackWeight: 5,
barThickness: 20
},
y3: {
type: 'linear',
position: 'left',
stack: 'demo',
stackWeight: 2,
}
}
},
};
const myChart = new Chart(
document.getElementById('myChart'),
config
);
</script>
<table width="97%" border="0" align="center" bordercolor="#000000" >
<tbody>
<tr>
<td width="5"></td>
<td width="*">
<table width="100%" border="0" align="center">
<tbody>
<tr >
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<div style="font-family: 'Gill Sans', 'Gill Sans MT', 'Myriad Pro', 'DejaVu Sans Condensed', Helvetica, Arial, 'sans-serif';">
<center>
<script>
document.getElementById("medeltemp").innerHTML = "<?php echo($medeltemp);?> °C";
document.getElementById("utetemp").innerHTML = "<?php echo($utetemp);?> °C";
document.getElementById("presure").innerHTML = "<?php echo($presure);?> barg/psig";
</script>>
</center>
</div>
<center>ASTACUS AB</center>
</body>
</html>