pageHeading('BOOKINGS DASHBOARD'); // get user info $user_res = $db->exec_query('safesure_users', ['*'], '', '', '', '', "record_id = {$_SESSION['user_id']}"); $user_data = $user_res->fetch_assoc(); $string_arr = []; foreach (explode(',', $user_data['clients_multi']) as $value) { $string_arr[] = ' clients_id = ' . $value; } $string = implode(' OR ', $string_arr); $res = $db->exec_query('bookings', ['*'], '', '', '', '', "status != 'NOT APPROVED' AND ($string) AND status != 'DONE'", "ORDER BY record_id DESC"); echo "
"; while ($row = $res->fetch_assoc()) { ?> "; ?>
BOOKING DATE STATUS DONE ASSESOR CLIENT
' /> ' /> ' /> exec_query('safesure_users', ['*'], '', '', '', '', "record_id = {$row['safesure_users_id']}"); $assesor = $user_res->fetch_assoc(); ?> ' /> exec_query('clients', ['*'], '', '', '', '', "record_id = {$row['clients_id']}"); $client = $client_res->fetch_assoc(); ?> ' />