<?
if (isset($_GET['serial_number'])) {
    $date = date('Y-m-d H:i', strtotime('+2 hours'));
    include "classes/db.class.php";
    $db = new db();
    // check if serial number is valid
    $check_serial_number_res = $db->exec_query('unit_registar', ['*'], '', '', '', '', "generated_serial = '{$_GET['serial_number']}'");
    if ($check_serial_number_res->num_rows > 0) {
        $unit_details = $check_serial_number_res->fetch_assoc();
        // get current numbers for unit and combine into string
        $operation_res = $db->exec_query('operations', ['*'], '', '', '', '', "unit_id = {$unit_details['record_id']} AND status = 0", "ORDER BY record_id ASC LIMIT 1");
        if ($operation_res->num_rows > 0) {
            $operation = $operation_res->fetch_assoc();
            echo $operation['operations'];
            $db->Update('operations', ['status', 'datetime_done'], [1, $date], "record_id = {$operation['record_id']}");
        }
        echo "";
    } else {
        echo "not_authorised";
    }
    if (isset($_GET['wifi'])) {
        $db->insert("INSERT INTO unit_state (unit_id, connection_state, `date`,`signal_strength`) VALUES ('{$unit_details['record_id']}', 'wifi','$date','{$_GET['wifi']}')");
    }
    if (isset($_GET['sim'])) {
        $db->insert("INSERT INTO unit_state (unit_id, connection_state, `date`,`signal_strength`) VALUES ('{$unit_details['record_id']}', 'sim','$date','{$_GET['sim']}')");
    }
    if (isset($_GET['log'])) {
        if ($_GET['log'] != "none") {
            $db->insert("INSERT INTO operations (`unit_id`, `operations`, `status`,`datetime_ini`,`datetime_done`) VALUES ('{$unit_details['record_id']}', '".str_replace(" 27","0",str_replace("none;","",$_GET['log']))."', 1,'$date','$date')");
        }
    }
} else {
    header('location: https://www.elegantwork.co.za');
}