<?php
include "classes/db.class.php";
$db = new db();

if (isset($_GET['serial_number'])) {
    $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();
        $date = date('Y-m-d H:i', strtotime('+2 hours'));
        // Insert Trigger into operations table in database
        if($db->insert("INSERT INTO `operations` (`unit_id`, `datetime_ini`,`status`,`operations`) VALUES ('{$unit_details['record_id']}', '$date',0,'trigger_g')")){
            echo "OK";
        }
    }
}else{
    echo "SERIAL_NUMBER_NOT_FOUND";
}