} if (isset($_GET["dev"])) { $deviceName = filter_var($_GET["dev"], FILTER_SANITIZE_STRING); } if (isset($_GET["lat"])) { $lat = filter_var($_GET["lat"], FILTER_SANITIZE_STRING); } if (isset($_GET["lng"])) { $lng = filter_var($_GET["lng"], FILTER_SANITIZE_STRING); } if (isset($_GET["name"])) { $name = filter_var($_GET["name"], FILTER_SANITIZE_STRING); } $mailSubject = "RASPI RELE BIT:{$bit} {$deviceName}"; $mailBody = "<b>Aktivita:</b> RASPI RELE BIT<BR>\n <b>Device:</b> {$deviceName} <BR>\n <b>Datum:</b> " . date("d.m.Y H:i:s") . "<BR>\n <b>BIT :</b> {$bit} <BR>\n <b>IP:</b> {$ip}"; $HTTPAnswer = new HTTPAnswer(); $oMySQL = new MySQL('temperature', $GLOBALS["dblogin"], $GLOBALS["dbpwd"], $GLOBALS["dbhost"], 3306); $Gpio = new GPIO($oMySQL); switch ($act) { default: break; case 'getlocation': $HTTPAnswer->HTTPAnswer(HTTP_ANSWER_STATUS_200, $Gpio->getLocationOnJson(), true); break; case 'savelocation': $Gpio->saveLocation($lat, $lng, $name); break; case 'readallevents': $HTTPAnswer->HTTPAnswer(HTTP_ANSWER_STATUS_200, $Gpio->getAllEventsOnJson(), true); break; case 'readall':
<?php include_once 'globals.php'; include_once 'class/class.HTTPAnswer.php'; include_once 'class/class.MySQL.php'; $HTTPAnswer = new HTTPAnswer(); $oMySQL = new MySQL('temperature', $dblogin, $dbpwd, $dbhost, 3306); function getRequiredTemp($oMySQL, $sensorName) { $Sql = "SELECT TT.Temp reqTemp FROM sensors S \n\tJOIN time_temp TT ON S.id = TT.SensorID\n\tWHERE WEEKDAY(NOW())+1 = TT.Day \n\tAND TIME(NOW()) BETWEEN TT.TimeFrom AND TT.TimeTo\n\tAND S.name = '{$sensorName}';"; $Res = $oMySQL->ExecuteSQL($Sql); return $Res['reqTemp']; } $Sql = "SELECT temp01 oby,temp02 ven,temp03 krb,temp04 pod,temp11 aku, temp08 pokt, temp09 pokn FROM temp ORDER BY timestamp DESC LIMIT 1"; $Res = $oMySQL->ExecuteSQL($Sql); $retval['temp'][] = array('name' => 'Venek', 'act' => $Res['ven'], 'req' => getRequiredTemp($oMySQL, 'temp02')); $retval['temp'][] = array('name' => 'Obyvak', 'act' => $Res['oby'], 'req' => getRequiredTemp($oMySQL, 'temp01')); $retval['temp'][] = array('name' => 'Tom', 'act' => $Res['pokt'], 'req' => getRequiredTemp($oMySQL, 'temp08')); $retval['temp'][] = array('name' => 'Nela', 'act' => $Res['pokn'], 'req' => getRequiredTemp($oMySQL, 'temp09')); $retval['temp'][] = array('name' => 'Krb', 'act' => $Res['krb'], 'req' => getRequiredTemp($oMySQL, 'temp03')); $retval['temp'][] = array('name' => 'Podlaha', 'act' => $Res['pod'], 'req' => getRequiredTemp($oMySQL, 'temp04')); $retval['temp'][] = array('name' => 'Aku', 'act' => $Res['aku'], 'req' => getRequiredTemp($oMySQL, 'temp11')); $HTTPAnswer->HTTPAnswer(HTTP_ANSWER_STATUS_200, json_encode($retval), true);
require_once "globals.php"; if (isset($_GET["id"])) { $id = filter_var($_GET["id"], FILTER_SANITIZE_STRING); } if (isset($_GET["value"])) { $value = filter_var($_GET["value"], FILTER_SANITIZE_STRING); } if (isset($_GET["desc"])) { $desc = filter_var($_GET["desc"], FILTER_SANITIZE_STRING); } if (isset($_POST["id"])) { $id = filter_var($_POST["id"], FILTER_SANITIZE_STRING); } if (isset($_POST["value"])) { $value = filter_var($_POST["value"], FILTER_SANITIZE_STRING); } if (isset($_POST["desc"])) { $desc = filter_var($_POST["desc"], FILTER_SANITIZE_STRING); } $oMySQL = new MySQL($dbname, $dblogin, $dbpwd, $dbhost); $Mail = new PHPMailer(); $HTTPAnswer = new HTTPAnswer(); $temp = round($value, 1); //echo "CALL insert_value('$desc','$id',$value)"; $res = $oMySQL->ExecuteSQL("CALL insert_value('{$desc}','{$id}',{$value})"); if (!$res) { echo $oMySQL->lastError; } else { //echo "DATA_OK"; $HTTPAnswer->HTTPAnswer(HTTP_ANSWER_STATUS_200, "1|DATA_OK", true); }