| Server IP : 79.136.114.73 / Your IP : 18.217.162.18 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/shellyctr/ |
Upload File : |
<?php
//ini_set('display_errors', 1);
//ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
$Username = "carl.hoffstedt@astacus.se";
$mysqli = new mysqli("www.astacus.se", "carlhoffstedt", "Astacus2020!", "ShellyCTR");
$sql = "SELECT * FROM tblBuilding where Username = '".$Username."'";
$result = $mysqli->query($sql);
while($obj = $result->fetch_object()){
$WantedTemp = $obj->WantedTemp;
$MinimumTemp = $obj->MinimumTemp;
}
$sql = "SELECT * FROM tblNordpool order by endTime desc LIMIT 1";
$result = $mysqli->query($sql);
while($obj = $result->fetch_object()){
$latest_date = substr($obj->endTime,0,10);
}
$percent_off = $_GET['off_procent'];
$percent_on = $_GET['on_procent'];
$area = $_GET['area'];
$day = $_GET['day'];
$sql = "SELECT * FROM tblPriceControl, tblUsers WHERE tblPriceControl.Username = tblUsers.Username and tblUsers.Username = '".$Username."'";
$result = $mysqli->query($sql);
while($obj = $result->fetch_object()){
$percent_off = $obj->Percent_off;
$percent_on = $obj->Percent_on;
$area = $obj->Area;
$lat = $obj->lat;
$lon = $obj->lon;
$Controltype = $obj->Controltype;
}
if($percent_on == "1"){
$add_on = 1;
}
if($percent_off == "1"){
$add_off = 1;
}
if($day == ""){
$day = 0;
}
?>
<?php
$from = date("Y-m-d",strtotime("+1 days"))." 00:00:00";
$to = date("Y-m-d",strtotime("+1 days"))." 24:00:00";
// Ta reda på medeltemperaturen i morgon
$sql = "SELECT AVG(t_effective) as t_effective_average FROM tblSMHI WHERE endTime >= '".$from."' and endTime <= '".$to."' and Username = '".$Username."'";
$result = $mysqli->query($sql);
while($obj = $result->fetch_object()){
$t_effective_average = $obj->t_effective_average;
}
echo("<br>Wanted temp: ".$WantedTemp);
echo("<br>Minimum temp: ".$MinimumTemp);
$Diff_temp = ($WantedTemp -$MinimumTemp);
echo("<br>Diff temp: ". $Diff_temp);
echo("<br>t_effective_average: ".$t_effective_average);
$sql = "SELECT AVG(Diff_per_hour) as Diff_per_hour FROM tblDIFF where t_effective >= ".($t_effective_average-3)." and t_effective <= ".($t_effective_average+3)."";
$result = $mysqli->query($sql);
while($obj = $result->fetch_object()){
$Diff_per_hour = $obj->Diff_per_hour;
}
if($Diff_per_hour == ""){
$Diff_per_hour = 0.25;
}
echo("<br>Diff_per_hour : ".$Diff_per_hour );
echo("<br>Vi klarar oss i : ".($Diff_temp / $Diff_per_hour) ." hr vilket motsvarar avstängt i: ".(($Diff_temp / $Diff_per_hour)/24)*100)." %";
$percent_on = 1-(($Diff_temp / $Diff_per_hour)/24);
$percent_off = (($Diff_temp / $Diff_per_hour)/24);
$sql = "SELECT DISTINCT(endTime) FROM tblNordpool WHERE endTime >= '".$from."' and endTime <= '".$to."' order by endTime";
$result = $mysqli->query($sql);
$json_labels_t = "[";
$labels_arr = array();
$tariff_arr = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->endTime;
$json_labels_t = $json_labels_t . "'". $timestamp ."',";
$labels_arr[] = $timestamp;
$month = date("n",strtotime($timestamp)); //1-12
$hour = date("G",strtotime($timestamp)); // 0-24
if($month >= 11 || $month <= 3){
if($hour >= 6 && $hour < 22){
$tariff = 0.536;
}else{
$tariff = 0.20;
}
}else{
$tariff = 0.20;
}
$tariff_arr[] = $tariff;
}
$json_labels_t = $json_labels_t . "'". str_replace("23:00:00","24:00:00",$timestamp) ."',";
$json_labels_t = $json_labels_t . "]";
$moms = 1.25;
$sql = "SELECT * FROM tblNordpool WHERE endTime >= '".$from."' and endTime <= '".$to."' and area = 'SE1' order by endTime";
$result = $mysqli->query($sql);
$arr1 = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->endTime;
$value = ($obj->value/1000 + $tariff)*$moms;
$arr1[] = array($timestamp,$value);
}
$arr1[] = array($timestamp,$value);
$sql = "SELECT * FROM tblNordpool WHERE endTime >= '".$from."' and endTime <= '".$to."' and area = 'SE2' order by endTime";
$result = $mysqli->query($sql);
$arr2 = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->endTime;
$value = ($obj->value/1000 + $tariff)*$moms;
$arr2[] = array($timestamp,$value);
}
$arr2[] = array($timestamp,$value);
$sql = "SELECT * FROM tblNordpool WHERE endTime >= '".$from."' and endTime <= '".$to."' and area = 'SE3' order by endTime";
$result = $mysqli->query($sql);
$arr3 = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->endTime;
$value = ($obj->value/1000 + $tariff)*$moms;
$arr3[] = array($timestamp,$value);
}
$arr3[] = array($timestamp,$value);
$sql = "SELECT * FROM tblNordpool WHERE endTime >= '".$from."' and endTime <= '".$to."' and area = 'SE4' order by endTime";
$result = $mysqli->query($sql);
$arr4 = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->endTime;
$value = ($obj->value/1000 + $tariff)*$moms;
$arr4[] = array($timestamp,$value);
}
$arr4[] = array($timestamp,$value);
$json_data_t1 = "data : [";
$json_data_t2 = "data : [";
$json_data_t3 = "data : [";
$json_data_t4 = "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 .",";
}
}
$json_data_t1 = $json_data_t1 . "]";
$json_data_t2 = $json_data_t2 . "]";
$json_data_t3 = $json_data_t3 . "]";
$json_data_t4 = $json_data_t4 . "]";
////////////
if($area == ""){
$area = 3;
}
if($percent_off == ""){
$percent_off = 0.2;
}
if($percent_on == ""){
$percent_on = 0.2;
}
if($percent_on == "1"){
$add_on = 1;
}
if($percent_off == "1"){
$add_off = 1;
}
$nbr_hrs_off = round((24*$percent_off))+$add_off;
$nbr_hrs_on = round((24*$percent_on))+$add_on;
$arr_use = $arr3;
if($area == 1){
$arr_use = $arr1;
$json_data_t1 = $json_data_t1;
}else if($area == 2){
$arr_use = $arr2;
$json_data_t1 = $json_data_t2;
}else if($area == 3){
$arr_use = $arr3;
$json_data_t1 = $json_data_t3;
}else if($area == 4){
$arr_use = $arr4;
$json_data_t1 = $json_data_t4;
}
$sum = 0;
foreach ($arr_use as &$v1) {
$sum +=$v1[1];
}
$average = $sum/count($arr_use);
$arr_off = array();
$arr_on = array();
foreach ($arr_use as &$v1) {
$arr_off[] = $v1[1];
$arr_on[] = $v1[1];
}
rsort($arr_off);
$largest = array_slice($arr_off, 0, $nbr_hrs_off);
sort($arr_on);
$smallest = array_slice($arr_on, 0, $nbr_hrs_on);
$onoff_arr5 = array();
$json_data_t5 = "data : [";
$f1 = false;
foreach ($arr_use as &$v1) {
if(in_array($v1[1],$largest)){
$json_data_t5 = $json_data_t5 . "'OFF',";
$f1 = true;
$onoff_arr5[] = 0;
}else{
$json_data_t5 = $json_data_t5 . "'ON',";
$onoff_arr5[] = 1;
}
}
if($f1 == false){
$json_data_t5 = $json_data_t5 .",";
}
$json_data_t5 = $json_data_t5 . "]";
$onoff_arr6 = array();
$json_data_t6 = "data : [";
$f1 = false;
foreach ($arr_use as &$v1) {
if(in_array($v1[1],$smallest)){
$json_data_t6 = $json_data_t6 . "'ON',";
$f1 = true;
$onoff_arr6[] = 1;
}else{
$json_data_t6 = $json_data_t6 . "'OFF',";
$onoff_arr6[] = 0;
}
}
if($f1 == false){
$json_data_t6 = $json_data_t6 .",";
}
$json_data_t6 = $json_data_t6 . "]";
$json_data_t7 = "data : [";
$f1 = false;
foreach ($arr_use as &$v1) {
$json_data_t7 = $json_data_t7 . $average.",";
}
if($f1 == false){
$json_data_t7 = $json_data_t7 .",";
}
$json_data_t7 = $json_data_t7 . "]";
$onoff_arr8 = array();
$json_data_t8 = "data : [";
$f1 = false;
foreach ($arr_use as &$v1) {
if($v1[1] < $average){
$json_data_t8 = $json_data_t8 . "'ON',";
$f1 = true;
$onoff_arr8[] = 1;
}else{
$json_data_t8 = $json_data_t8 . "'OFF',";
$onoff_arr8[] = 0;
}
}
if($f1 == false){
$json_data_t8 = $json_data_t8 .",";
}
$json_data_t8 = $json_data_t8 . "]";
?>
<?php
$sql = "SELECT * FROM tblSMHI WHERE endTime >= '".$from."' and endTime <= '".$to."' and Username = '".$Username."' order by endTime";
$result = $mysqli->query($sql);
$json_labels_t2 = "[";
$json_data_ws = "data : [";
$json_data_t = "data : [";
$json_data_t_effective = "data : [";
$json_data_tcc_mean = "data : [";
$json_data_tcc_mean_array = array();
$json_data_t_effective_array = array();
while($obj = $result->fetch_object()){
$timestamp = $obj->startTime;
$json_labels_t2 = $json_labels_t2 . "'". $timestamp ."',";
$json_data_t = $json_data_t . $obj->t.",";
$json_data_ws = $json_data_ws . $obj->ws.",";
$json_data_t_effective = $json_data_t_effective . $obj->t_effective.",";
$json_data_t_effective_array[] = $obj->t_effective;
if($obj->tcc_mean >= 5){
$sol = "'OFF'";
$json_data_tcc_mean_array[] = 0;
}else{
$sol = "'ON'";
$json_data_tcc_mean_array[] = 1;
}
$json_data_tcc_mean = $json_data_tcc_mean . $sol.",";
}
$json_data_t = $json_data_t . "]";
$json_data_ws = $json_data_ws . "]";
$json_data_t_effective = $json_data_t_effective . "]";
$json_data_tcc_mean = $json_data_tcc_mean ."]";
$json_labels_t2 = $json_labels_t2 . "'". str_replace("23:00:00","24:00:00",$timestamp) ."',";
$json_labels_t2 = $json_labels_t2 . "]";
$onoff_arr = array();
if($Controltype == 1){
$onoff_arr = $onoff_arr5;
}else if($Controltype == 2){
$onoff_arr = $onoff_arr6;
}else if($Controltype == 3){
$onoff_arr = $onoff_arr8;
}
$json_data_t_effective_ohmigo = array();
$x = 0;
foreach ($json_data_t_effective_array as &$t_effective) {
// Om solen skiner mycket, höj ute temperaturen, men bara under de varma månaderna, låt säga april - oktober
$addtemp = 0;
$v5 = "";
if($json_data_tcc_mean_array[$x] == 1){
if($x > 8 && $x <= 15){
if(date("n") >= 4 && date("n") <= 9 ) {
$addtemp += 2;
echo("<br>Om solen skiner mycket, höj ute temperaturen<br>");
$v5 = "SUN";
}
}
}
$v6 = "";
// Sänk temperaturen ute de billigaste timmarna på dygnet
if($onoff_arr6[$x] == 1){
$addtemp -= 2;
$v5 = "CHEAP";
echo("<br>Sänk temperaturen ute de billigaste timmarna på dygnet<br>");
}
$controltype = 0;
if($onoff_arr[$x] == 1){
$json_data_t_effective_ohmigo[] = array(date("Y-m-d",strtotime("+1 days")),$controltype,$Username,$labels_arr[$x],($json_data_t_effective_array[$x]+$addtemp),$v5,$v6,'');
}else{
$json_data_t_effective_ohmigo[] = array(date("Y-m-d",strtotime("+1 days")),$controltype,$Username,$labels_arr[$x],($json_data_t_effective_array[$x]+20+$addtemp),$v5,$v6,'EXPENSIVE');
}
$x++;
}
//print_r($json_data_t_effective_ohmigo);
foreach ($json_data_t_effective_ohmigo as &$v1) {
$sql = "DELETE FROM tblWeatherControl WHERE Username = '".$v1[2]."' and Controldate = '".date("Y-m-d",strtotime("+1 days"))."';";
$mysqli->query($sql);
echo($sql."<br>");
}
$sql = "";
foreach ($json_data_t_effective_ohmigo as &$v1) {
$sql = "INSERT INTO tblWeatherControl VALUES(null,'".$v1[0]."',".$v1[1].",'".$v1[2]."','".$v1[3]."','".$v1[4]."','".$v1[5]."','".$v1[6]."','".$v1[7]."');";
$mysqli->query($sql);
echo($sql."<br>");
}
?>