function checkSolarTemp() { global $minSolar; $sql = query("SELECT sensorId FROM sensoren where name = 'Solar'"); $row = fetch($sql); $temp = getSensorTemp($row[sensorId]); logToFile("Skript: Prüfe Solartemperatur - Solarpanel IST: {$temp} Min.: {$minSolar}"); if ($minSolar > $temp) { //logToFile("Skript: Solar EIN - Solarpanel IST: $temp Min.: $minSolar"); return 1; } else { //logToFile("Skript: Solar AUS - Solarpanel IST: $temp Min.: $minSolar"); return 0; } }
function getPoolTemp() { $sql = query("SELECT sensorId FROM sensoren where name = 'Pool'"); $row = fetch($sql); $temp = getSensorTemp($row[sensorId]); return $temp; }
<?php include "funktionen.php"; $sensor = $_GET["sensor"]; $action = $_GET[action]; //echo "tets"; $sensors = explode(",", $sensor); $count = 0; $count1 = 0; if ($action == "file") { foreach ($sensors as $value) { if ($count == 0) { $output = $output . getSensorTemp($value); } else { $output = $output . "," . getSensorTemp($value); } $count++; } echo $output; } if ($action == "database") { // echo "database"; $output = ""; foreach ($sensors as $sensor) { $sql = query("SELECT value FROM logtemp WHERE iid = '" . $sensor . "' ORDER BY id DESC LIMIT 1"); $row = fetch($sql); //var_dump($row); //echo $row["value"] . "<br>"; // $output = $output . "," . $row['value']; if ($count == 0) { $output = $output . sprintf("%1\$.2f", $row['value']);
<?php include "funktionen.php"; $sql = query("SELECT * FROM sensoren"); //var_dump($sql); while ($sensor = fetch($sql)) { $sensors[$sensor[name]] = getSensorTemp($sensor[sensorId]); $temp = getSensorTemp($sensor[sensorId]); $sql1 = query("SELECT value FROM logtemp WHERE name= '" . $sensor[name] . "' ORDER BY id DESC LIMIT 1"); $temp_1h = fetch($sql1); //var_dump($temp_1h); $diff = $temp - $temp_1h[0]; $diff = sprintf("%1\$.2f", $diff); //echo $sensor[name] . " - 1h: " . $temp_1h[0] . " - aktuell: " . $temp . " diff:" . $diff . "<br>" ; $update = query("UPDATE temptrend SET {$sensor['name']} = '" . $diff . "' "); logSensortemp($sensor[name], $sensor[sensorId], $temp); } //$cpu_temperature = round(exec("cat /sys/class/thermal/thermal_zone0/temp ") / 1000, 2); //logSensortemp("Raspberry","1",$cpu_temperature);