<?php

header('Content-type: application/json');

define('DB_DIR', getenv('DB_DIR'));

function store_sqlite3($data) {
    $db_path = DB_DIR.'/location-'.date('Y-m').'.db';
    $db = new SQLite3($db_path);

    $db->exec('
        CREATE TABLE IF NOT EXISTS history(
            tst INTEGER PRIMARY KEY,
            lat FLOAT,
            lon FLOAT,
            acc INTEGER
        )
    ');

    $stm = $db->prepare('
        INSERT INTO history(
            tst,
            lat,
            lon,
            acc
        )
        VALUES (
            :tst,
            :lat,
            :lon,
            :acc
        )
    ');
    $stm->bindValue(':tst', $data['tst'], SQLITE3_INTEGER);
    $stm->bindValue(':lat', $data['lat'], SQLITE3_FLOAT);
    $stm->bindValue(':lon', $data['lon'], SQLITE3_FLOAT);
    $stm->bindValue(':acc', $data['acc'], SQLITE3_INTEGER);
    $res = $stm->execute();
}

function store_raw($data) {
    $db_path = DB_DIR.'/location-'.date('Y-m').'.raw';
    file_put_contents($db_path, serialize($data), FILE_APPEND);
}

$payload = file_get_contents("php://input");
$data = @json_decode($payload, true);

if ('location' == $data['_type']) {
    store_raw($data);
    store_sqlite3($data);
}

print json_encode([]);
?>