<?php
require_once __DIR__ . '/config.php';

$now       = date('YmdHis');
$dayname   = strtolower(date('l'));
$time      = date('Hi');
$input     = parseInput();
$plate     = $input['plate'];
$direction = $input['direction'];
$device    = $input['device'];

$log = implode(';', [$now, $plate, $direction, $device]);

if ($time < '0700' || $time > '2359') {
    writeLog('rijsdaal.txt', $log . ";$dayname;outOfOfficeHours;noaction");
    die();
}

$log .= ";$dayname;$time";

if ($direction !== 'Approach') {
    writeLog('rijsdaal.txt', $log . ';no action');
    die();
}

$conn = dbConnect();
$stmt = mysqli_prepare($conn, 'SELECT 1 FROM lp WHERE lpcontent = ? AND lplocation = 2 LIMIT 1');
mysqli_stmt_bind_param($stmt, 's', $plate);
mysqli_stmt_execute($stmt);
mysqli_stmt_store_result($stmt);
$allowed = mysqli_stmt_num_rows($stmt) > 0;
mysqli_stmt_close($stmt);

$status = $allowed ? 'allowed' : 'denied';

if ($allowed) {
    $log .= ';ALLOWED';
    $log .= ';' . triggerRelay('http://172.17.13.40/leds.cgi?state=P0010&led=0');
} else {
    $log .= ';NOT allowed';
}

$ins = mysqli_prepare($conn, 'INSERT INTO logs (time, lp, device, status) VALUES (?, ?, ?, ?)');
mysqli_stmt_bind_param($ins, 'ssss', $now, $plate, $device, $status);
$log .= mysqli_stmt_execute($ins) ? ';dbok' : ';' . mysqli_error($conn);
mysqli_stmt_close($ins);

mysqli_close($conn);
writeLog('rijsdaal.txt', $log);