{zadnji_podatki}⌚ {cas}, 🌡️ {temperatura} °C, 💦 {vlaga}%
EOT;
// THE THINGS NETWORK INPUT DATA - Janez Frančiškani Maribor naprimer
$txt = "";
if ($_SERVER["REQUEST_METHOD"] == "POST")
$txt .= file_get_contents("php://input");
//else $txt = '{"end_device_ids":{"device_id":"mb-bazilika","application_ids":{"application_id":"otx-room-monitor"},"dev_eui":"00D10CE4D3C0C0E2","join_eui":"70B3D57ED0034217","dev_addr":"260B3F7D"},"correlation_ids":["as:up:01FPBE6KP7HASWNPB9SRYPK60A","gs:conn:01FPB7528X0E05SNBMZ4PYHWPB","gs:up:host:01FPB7529CTRE04HSXH8YFHG41","gs:uplink:01FPBE6KFN8JR2Z62JBX002X2E","ns:uplink:01FPBE6KFPJA9NDHYYSAV1NXX5","rpc:/ttn.lorawan.v3.GsNs/HandleUplink:01FPBE6KFP2YAS50AKR3JTQ099","rpc:/ttn.lorawan.v3.NsAs/HandleUplink:01FPBE6KP77M854KBSA5R9HD3Z"],"received_at":"2021-12-07T21:53:39.017103922Z","uplink_message":{"session_key_id":"AX1xoN+DlCafy7mxmjvMDA==","f_port":1,"f_cnt":183,"frm_payload":"AawCWw==","decoded_payload":{"Humidity":60.3,"Temperature":12.799999999999997},"rx_metadata":[{"gateway_ids":{"gateway_id":"maribor-pohorje-gateway"},"time":"2021-12-07T21:53:38Z","timestamp":3839868996,"rssi":-113,"channel_rssi":-113,"snr":-12,"uplink_token":"ChsKGQoXbWFyaWJvci1wb2hvcmplLWdhdGV3YXkQxID/pg4aDAjir7+NBhCli/v/AiCgk5zQ4OwB"}],"settings":{"data_rate":{"lora":{"bandwidth":125000,"spreading_factor":12}},"coding_rate":"4/5","frequency":"867700000","timestamp":3839868996},"received_at":"2021-12-07T21:53:38.806260175Z","consumed_airtime":"1.318912s","locations":{"user":{"latitude":46.56012658084421,"longitude":15.649978816509249,"source":"SOURCE_REGISTRY"}},"version_ids":{"brand_id":"onethinx","model_id":"otx18","hardware_version":"18.02","firmware_version":"1.0","band_id":"EU_863_870"},"network_ids":{"net_id":"000013","tenant_id":"ttn","cluster_id":"ttn-eu1"}}}';
if (strlen ($txt)){
$data = json_decode ($txt, true);
$device = "mb-bazilika";
if (is_array($data)){
$id = $data["end_device_ids"]["device_id"];
$ts = iso8601_to_timestamp ($data["received_at"]);
@$temp = $data["uplink_message"]["decoded_payload"]["Temperature"];
@$hum = $data["uplink_message"]["decoded_payload"]["Humidity"];
if ($temp && $hum){
$sql = "INSERT INTO data VALUES (0, '{$id}', FROM_UNIXTIME({$ts}), {$temp}, {$hum});";
//echo $sql;
sql_query ($sql);
report($id);
}
}
//mb_send_mail ("matej.nastran@gmail.com", "The Things Network", $txt."\n\n".$sql, "From: iot@mase.si", "-f iot@mase.si");
die ();
//print_r ($data);
}
// SHELLY INPUT DATA
$temp = (float)($_GET["temp"] ?? 0.0);
$hum = (float)($_GET["hum"] ?? 0.0);
// novi shelly imajo bodisi samo hum ali samo temp parameter, stari pa vedno oba, zato za nove poiščem podatek v bazi
if (($temp != 0.0 || $hum != 0.0) && $shelly){
if ($hum == 0.0)
$hum = (float)get_value ("SELECT * FROM data WHERE device = '{$device}' AND hum > 0 ORDER BY ts DESC LIMIT 1;", "hum");
if ($temp == 0.0)
$temp = (float)get_value ("SELECT * FROM data WHERE device = '{$device}' AND temp > 0 ORDER BY ts DESC LIMIT 1;", "temp");
$ts = time();
$sql = "INSERT INTO data VALUES (0, '{$device}', FROM_UNIXTIME({$ts}), {$temp}, {$hum});";
//echo $sql;
sql_query ($sql);
report($device, $sql);
die ();
die ("Izvedel ".$sql);
}
if (!strlen($device))
die ("Nic ni tu za vas.");
/////////////////// od tu naprej pravilo stvari ne spreminjaš
if (!$json){
?>
Temperatura in vlaga v <?=$device;?>
NOW() ORDER BY ts;");
if (count($data) == 0)
die ("Ta naprava ne obstaja ali pa v zadnjih {$days} ni poslala podatkov!");
$t_data = $v_data = [];
foreach ($data as $row){
$t_data [] = "{x: moment(\"".date("Y-m-d H:i:s", $row["ts2"])."\"), y: {$row["temp"]}}";
$v_data [] = "{x: moment(\"".date("Y-m-d H:i:s", $row["ts2"])."\"), y: {$row["hum"]}}";
$last_row = $row;
}
//$html = str_replace (["{zadnji_podatki}", "{cas}", "{temperatura}", "{vlaga}"], [$iframe ? "" : "Zadnji podatki: ", dan_v_tednu($last_row["ts2"]).date (" G:i", $last_row["ts2"]), $last_row["temp"], $last_row["hum"]], $html);
if ($json){
$out = ["datetime"=>$last_row["ts"], "timestap"=>$last_row["ts2"], "temperature"=>$last_row["temp"], "humidity"=>$last_row["hum"]];
header('Content-Type: application/json; charset=utf-8');
die (json_encode ($out));
}
$html = str_replace (["{zadnji_podatki}", "{cas}", "{temperatura}", "{vlaga}"], [$iframe ? "" : "Zadnji podatki: ", date ("j. n. Y G:i", $last_row["ts2"]), $last_row["temp"], $last_row["hum"]], $html);
$dni = "";
$tmp = preg_replace ("@[\?&]days=\d+@mius", "", $_SERVER["REQUEST_URI"]);
foreach ([1, 3, 7, 14, 21, 30, 60, 90, 180, 365, 999] as $m){
$dni .= " {$m} ";
}
if (!$iframe) {
?>