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'];
$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["assesment_$index"]},";
}
$index++;
}
$emp_ids;
$assesment_ids;
if ($_POST['status'] == "APPROVED") {
$db->insert("INSERT INTO `bookings` (`date_booked`,`date_approved`,`safesure_users_id`,`clients_id`,`client_employees`,`assesments`,`status`) VALUES ('$booking_date','$date','{$_POST['users']}','{$_POST['clients']}','$emp_ids','$assesment_ids','DRAFT')");
} else {
$db->insert("INSERT INTO `bookings` (`date_booked`,`date_approved`,`safesure_users_id`,`clients_id`,`client_employees`,`assesments`,`status`) VALUES ('$booking_date','','{$_POST['users']}','{$_POST['clients']}','$emp_ids','$assesment_ids','DRAFT')");
}
echo "";
} else {
?>