exec_query('clients', ['*'], '', '', '', '', "1", "ORDER BY clients_name ASC"); $clients_data = ''; while ($clients = $clients_res->fetch_assoc()) { $clients_data = $clients_data . ""; } $users_res = $db->exec_query('safesure_users', ['*'], '', '', '', '', "user_type_id = 2", "ORDER BY safesure_users_name ASC"); $users_data = ''; while ($users = $users_res->fetch_assoc()) { $users_data = $users_data . ""; } $asses_res = $db->exec_query('assessments', ['*'], '', '', '', '', '1', "ORDER BY assessments_name ASC"); $assessments_data = ""; while ($ass = $asses_res->fetch_assoc()) { $assessments_data = $assessments_data . "'"; } $test_res = $db->exec_query('tests', ['*'], '', '', '', '', '1', "ORDER BY test_name ASC"); $tests_data = ""; while ($test = $test_res->fetch_assoc()) { $tests_data = $tests_data . "'"; } $booking_res = $db->exec_query('bookings', ['*'], '', '', '', '', "record_id = '{$_GET['record_id']}'"); $WebApp->pageHeading('ATTENDENCE REGISTER'); ?>
fetch_assoc()) { $clients_id = $booking['clients_id']; ?>
' />

0) { $emp_res = $db->exec_query('client_employees', ['*'], '', '', '', '', "record_id = $emp"); $employee = $emp_res->fetch_assoc(); ?> ' readonly /> ' readonly />
NAME (SEARCHABLE) SURNAME OCUPATION ASSESSMENT TEST ATTENDANCE
' /> ' /> ' class='input' /> ' class='input' /> = 1) { $assesses = $db->exec_query('assesses', ['*'], '', '', '', '', "booking = {$_GET['record_id']} AND assessments_id = {$ass[$index_ass_tests]} AND client_employees_id = {$employee['record_id']}", "order by record_id ASC"); $asses_res = $db->exec_query('assessments', ['*'], '', '', '', '', '1', "ORDER BY assessments_name ASC"); if ($assesses->num_rows != 0) { while ($assessment = $assesses->fetch_assoc()) { ?>

PASSED
FAILED

2nd ATTEMPT

3rd ATTEMPT

NO
exec_query('tests_sec', ['*'], '', '', '', '', "booking = {$_GET['record_id']} AND test_id = {$tests[$index_ass_tests]} AND client_employees_id = {$employee['record_id']}", "order by record_id ASC"); if ($test_sec->num_rows != 0) { while ($test_a = $test_sec->fetch_assoc()) { ?>

PASSED
FAILED

2nd ATTEMPT

3rd ATTEMPT

NO

ATTENDANCE REGISTAR NOTES