VAATWASSER
";
}
if ($ExTime !=nil){
echo "set ".$ExTime."
";
}
else{
echo "Geen programma";
}
//echo $nu;
$SQL_TIME ="Select Query1.Device, Query1.MomentPHP As MomentPHPFrom, Query1.MomentVis As MomentVisFrom, Query1.Omsch As Omschr,SensiHome.TijdInstellingen.MomentPHP As MomentPHPTO, SensiHome.TijdInstellingen.MomentVis As MomentVisTo, SensiHome.TijdInstellingen.TijdInstId From SensiHome.TijdInstellingen Inner Join (Select SensiHome.TimeSlots.Device, SensiHome.TimeSlots.TimeSetFrom, SensiHome.TimeSlots.Omsch, SensiHome.TimeSlots.Volgorde, SensiHome.TimeSlots.TimeSetTo, SensiHome.TijdInstellingen.MomentVis, SensiHome.TijdInstellingen.MomentPHP From SensiHome.TijdInstellingen Right Join SensiHome.TimeSlots On SensiHome.TijdInstellingen.TijdInstId = SensiHome.TimeSlots.TimeSetFrom) Query1 On SensiHome.TijdInstellingen.TijdInstId = Query1.TimeSetTo";
$result_time = mysqli_query($cxn,$SQL_TIME)
or die ("Could not execute query 'result_time'");
$rij=array();
while ($rij=mysqli_fetch_array($result_time)) {
$Sum_WindFC = "";
$Start ="";
$OSum ="";
$Device=($rij["Device"]);
$Omsch=($rij["Omschr"]);
//echo $Omsch;
$TimeFrom=($rij["MomentPHPFrom"]);
//echo "From :".$TimeFrom."
";
$TimeFrom = date("Y-m-d H:i:s ", strtotime(".$TimeFrom."));
$TimeTo=($rij["MomentPHPTO"]);
//echo "To :".$TimeTo."
";
$TimeTo = date("Y-m-d H:i:s ", strtotime(".$TimeTo."));
$TimeVisFrom=($rij["MomentVisFrom"]);
$TimeVisTo=($rij["MomentVisTo"]);
//echo $TimeFrom."
";
//echo $TimeTo."
";
//echo $time;
$q_SQL = "SELECT * FROM Devices WHERE DeviceName = 'DISHWASHER'";
$result = mysqli_query($cxn,$q_SQL)
or die ("Could not execute query");
echo "
";
$rij=array();
while ($rij=mysqli_fetch_array($result)) {
$Cycle=($rij["CycleTime"]);
$DeviceId=($rij["DeviceTableId"]);
$ChipId=($rij["ChipId"]);
$DeviceIp=($rij["DeviceIp"]);
$DeviceName=($rij["DeviceName"]);
$CycleWh=($rij["CycleWh"]);
}
$Cycle1 = ($Cycle * 60 * 2);
//echo $Cycle1;
if ($TimeFrom == $TimeTo)
$TimeTo = date('Y-m-d H:i:s', strtotime ($TimeTo)+($Cycle1));
//echo $TimeTo."
";
$q_SQL2 = "SELECT * FROM Wind WHERE WindDateTime <= DATE_SUB('".$TimeTo."', INTERVAL ".$Cycle." MINUTE) and WindDateTime > '".$TimeFrom."'";
//echo $q_SQL2."
";
$result2 = mysqli_query($cxn,$q_SQL2)
or die ("Could not execute query 2");
echo "
";
$rij2=array();
while ($rij=mysqli_fetch_array($result2)) {
$WindDateTime=($rij["WindDateTime"]);
$WindFC=($rij["WindFC"]);
//echo $WindDateTime;
//echo "
";
//echo $WindFC;
//echo "
";
$q_SQL3 = "SELECT SUM(WindFC) AS Sum_WindFC, WindDateTime AS WindDateTimeRes FROM Wind WHERE WindDateTime >= '".$WindDateTime."' AND WindDateTime < DATE_ADD('".$WindDateTime."', INTERVAL ".$Cycle." MINUTE)";
//echo $q_SQL3;
$result3 = mysqli_query($cxn,$q_SQL3)
or die ("Could not execute query 3");
//echo "
";
$rij3=array();
while ($rij=mysqli_fetch_array($result3)) {
$WindDateTimeRes=($rij["WindDateTimeRes"]);
$Sum_WindFC=($rij["Sum_WindFC"]);
//echo $Sum_WindFC ." ";
//echo $WindDateTimeRes;
//echo "
";
if ($Sum_WindFC > $OSum){
$OSum = $Sum_WindFC;
//echo "Osum : ".$OSum." ";
$Start = $WindDateTimeRes;
//echo "VarStart :" .$Start."
";
}
}
}
//echo $OSum;
$kwh = round($OSum*1.1/4);
//echo $kwh;
//echo "
";
$StartDisp = date('H:i', strtotime ($Start));
//echo "Start Switch : ". $Start."
";
$Cycle = ($Cycle * 60 +900);
//echo $Cycle;
$Stop = date('Y-m-d H:i:s', strtotime ($Start)+($Cycle));
//echo $date;
if ($CycleWh>=$kwh)
$st="id='gobuttonR'";
elseif ($CycleWh<$kwh)
$st="id='gobuttonG'";
if ($kwh != nil) {
$put ="'".$Omsch." ".$kwh ." kWh - ".$StartDisp."'";
echo "";
}
}
echo"
";
?>