<?
if (isset($_GET['serial_number'])) {
    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
        $numbers_res = $db->exec_query('authorised_numbers', ['*'], '', '', '', '', "unit_id = {$unit_details['record_id']} AND status = 1");
        if ($numbers_res->num_rows > 0) {
            $numebrs_string = "";
            while ($numbers = $numbers_res->fetch_assoc()) {
                $numebrs_string .= ' ' . $numbers['cell_number'] . " ,";
            }
            echo "//" . $numebrs_string . "|";
        }
        echo "";
    } else {
        echo "not_authorised";
    }

  
} else {
    header('location: https://www.elegantwork.co.za');
}