Exemple #1
0
}
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':
Exemple #2
0
<?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);
Exemple #3
0
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);
}