exec_query('safesure_users', ['*'], '', '', '', '', "record_id = {$_SESSION['user_id']}");
$user_data = $user_re->fetch_assoc();
$string_arr = [];
foreach (explode(',', $user_data['clients_multi']) as $value) {
$string_arr[] = ' record_id = ' . $value;
}
$string = implode(' OR ', $string_arr);
$clients_res = $db->exec_query('clients', ['*'], '', '', '', '', "$string", "ORDER BY clients_name ASC");
$clients_data = '';
while ($clients = $clients_res->fetch_assoc()) {
$clients_data = $clients_data . "";
}
$string_arr2 = [];
foreach (explode(',', $user_data['clients_multi']) as $value) {
$string_arr2[] = "clients_multi LIKE '%" . $value . "%'";
}
$string2 = implode(' OR ', $string_arr2);
$users_res = $db->exec_query('safesure_users', ['*'], '', '', '', '', "user_type_id = 2 AND ($string2)", "ORDER BY safesure_users_name ASC");
$users_data = '';
while ($users = $users_res->fetch_assoc()) {
$users_data = $users_data . "";
}
$asses_res = $db->exec_query('assesments', ['*'], '', '', '', '', '1', "ORDER BY assesments_name ASC");
$assesments_data = "";
while ($ass = $asses_res->fetch_assoc()) {
$assesments_data = $assesments_data . "'";
}
$contractors_res = $db->exec_query('client_sites', ['*'], '', '', '', '', '1', "ORDER BY client_sites_name ASC");
$contractors = '';
while ($contract = $contractors_res->fetch_assoc()) {
$contractors .= "";
}
$WebApp->pageHeading('ADD BOOKING');
?>