exec_query('tests_sec', ['*'], '', '', '', '', "record_id = {$_GET['id']}"); $tests_sec = $test_sec_res->fetch_assoc(); $test_res = $db->exec_query('tests', ['*'], '', '', '', '', '1', "ORDER BY test_name ASC"); $test = $test_res->fetch_assoc(); $test_questions_res = $db->exec_query('test_questions', ['*'], '', '', '', '', "test_id = {$test['record_id']}"); $test_questions = $test_questions_res->fetch_assoc(); $test_answers_res = $db->exec_query('test_answers', ['*'], '', '', '', '', "test_question_id = {$test_questions['record_id']}"); $test_answers = $test_answers_res->fetch_assoc(); $candidate_res = $db->exec_query('client_employees', ['*'], '', '', '', '', "record_id = {$tests_sec['client_employees_id']}"); $candidate = $candidate_res->fetch_assoc(); $client_res = $db->exec_query('clients', ['*'], '', '', '', '', "record_id = {$tests_sec['clients_id']}", 'ORDER BY clients_name ASC'); $client = $client_res->fetch_assoc(); $padding = '10px'; $date_now = date('Y-m-d H:i', strtotime("+ 2 Hours")); $html .= "

SAFETY & TRAINING PRACTITIONERS

{$test['test_name']}

{$test['test_description']}

Candidate: $candidate[client_employees_name]

Client: $client[clients_name]

NQF LEVEL: $test[nqf_level]

Credits : $test[credits]

Date: $date_now
"; $questions_res = $db->exec_query('tests_questions_sec', ['*'], '', '', '', '', "tests_sec_id = {$tests_sec['record_id']}", ''); while ($questions = $questions_res->fetch_assoc()) { $html .= " "; $answer_res = $db->exec_query('tests_answers_sec', ['*'], '', '', '', '', "tests_questions_sec_id = {$questions['record_id']}"); $answers_index = 1; $anser_nyc = 0; $anser_c = 0; while ($answers = $answer_res->fetch_assoc()) { $html .= " "; $anser_c++; } else { $html .= " "; $anser_nyc++; } $html .= " "; $answers_index++; } $html .= "

$questions[questions]

YES

NO

COMMENTS

CORRECT ANSWER

$answers_index

$answers[answer]

 "; if ($answers['option'] == "1") { $html .= "

X

X

$answers[comment]

 "; if ($test_answers['option'] == 1) { $html .= "

YES

"; } else { $html .= "

NO

"; } $html .= "

TOTAL

$anser_c

$anser_nyc


"; } $html .= "

RECOMMENDATIONS FOR IMPROVEMENT RELATED TO OPERATING TECHNIQUES

$tests_sec[notes]
"; $html .= "

FINAL TEST - ACCEPTANCE

"; if ($tests_sec['results'] == 'C') { $html .= " "; } else { $html .= " "; } $html .= "

RESULT

ASSESSOR’S NAME

ASSESSOR’S SIGNATURE

DATE

C

NYC

$candidate[client_employees_name]

 		$tests_sec[date]

X

X

$test_candidate[client_employees_name]

 		$tests_sec[date]


I declare that I am in good health and medically fit to undergo this training session and do not suffer from any of the following conditions:

1

Uncontrolled Epilepsy.

2

Liability to sudden attacks of disabling giddiness of fainting due to Hypertension or any other causes

3

Any form of mental disorder or defect referred to in section 2(1) and classified in (section 3 of the Mental Disorder act 38 of 1916).

4

Addiction to narcotic drugs and/or addiction to excessive intoxicating liquor.

5

Any condition causing poor muscular co-ordination.

6

Uncontrolled Diabetes Mellitus.

7

Any other disease or disability including vision, which is likely to render me incapable of effective operating the class of machine which the certificate of competence referred and without endangering the public or fellow workers.

8

Vision deficiencies or impairment.

I fully understand the above and was under no pressure or obligation to sign this document.


Signed at ________________________________ on this __________day of __ _______________20_________


"; echo $html;