exec_query('client_login_token', ['*'], '', '', '', '', "token = '$token' AND status != 0");
if ($result->num_rows > 0) {
$date = date('Y-m-d H:i', strtotime("+2 hours"));
$booking_date = str_replace("T", " ", $_POST['booking_date_time']);
$_POST['clients'];
$_POST['users'];
$_POST['row_count'];
$_POST['status'];
if ($_POST['clients'] == "Elegant Work Group") {
$client_sites_id = 2;
} else if ($_POST['clients'] == "Evander Gold Mine") {
$client_sites_id = 1;
} else if ($_POST['clients'] == "Inyoni Site") {
$client_sites_id = 3;
} else {
$client_sites_id = " ";
}
$index = 1;
$emp_ids = '';
$assesment_ids = '';
while ($index <= $_POST['row_count']) {
if (strlen($_POST["emp_name_$index"]) > 1) {
if ($_POST["is_emp_$index"] == 'n') {
$record_id = $db->insert("INSERT INTO `client_employees` (`client_employees_name`,`surname`,`clients_id`,`i_doc_passport`,`occupation`) VALUES ('{$_POST["emp_name_$index"]}','{$_POST["emp_sur_$index"]}','{$_POST['clients']}','{$_POST["emp_id_$index"]}','{$_POST["emp_occ_$index"]}')");
} else {
$record_id = $_POST["is_emp_$index"];
}
$emp_ids = $emp_ids . "$record_id,";
$assesment_ids = $assesment_ids . "{$_POST["assessment_$index"]},";
}
$index++;
}
$emp_ids;
$assesment_ids;
if ($_POST['status'] == "APPROVED") {
$record_id = $db->insert("INSERT INTO `bookings` (`date_booked`,`date_approved`,`safesure_users_id`,`clients_id`,`client_employees`,`assessments`,`status`,`client_sites_id`) VALUES ('$booking_date','$date','{$_POST['users']}','{$_POST['clients']}','$emp_ids','$assesment_ids','DRAFT',`$client_sites_id`)");
$db->query("UPDATE `bookings` SET booking_number = $record_id WHERE record_id = $record_id");
} else {
$record_id = $db->insert("INSERT INTO `bookings` (`date_booked`,`date_approved`,`safesure_users_id`,`clients_id`,`client_employees`,`assessments`,`status`,`client_sites_id`) VALUES ('$booking_date','','{$_POST['users']}','{$_POST['clients']}','$emp_ids','$assesment_ids','DRAFT',`$client_sites_id`)");
$db->query("UPDATE `bookings` SET booking_number = $record_id WHERE record_id = $record_id");
}
// echo "";
} else {
?>