// ---- topic
$where_sqls = 'subject_module_id=' . $module_id . '';
if ($expmode < 2) {
$where_sqls .= ' AND subject_id=' . $subject_id . '';
}
$sqls = F_select_subjects_sql($where_sqls);
if ($rs = F_db_query($sqls, $db)) {
while ($ms = F_db_fetch_array($rs)) {
$subject_id = $ms['subject_id'];
$subject_name = $ms['subject_name'];
$subject_description = F_decode_tcecode($ms['subject_description']);
//$subject_enabled = F_getBoolean($ms['subject_enabled']);
// --- start page data ---
$pdf->AddPage();
// set barcode
$pdf->setBarcode($subject_id);
$pdf->SetFillColor(204, 204, 204);
$pdf->SetLineWidth(0.1);
$pdf->SetDrawColor(0, 0, 0);
// print document name (title)
$pdf->SetFont(PDF_FONT_NAME_DATA, 'B', PDF_FONT_SIZE_DATA * K_TITLE_MAGNIFICATION);
$pdf->Cell(0, $main_cell_height * K_TITLE_MAGNIFICATION, $doc_title, 1, 1, 'C', 1);
$pdf->Ln(5);
// --- display subject info ---
$pdf->SetFont(PDF_FONT_NAME_DATA, 'B', PDF_FONT_SIZE_DATA * HEAD_MAGNIFICATION);
$pdf->Cell($page_width, $data_cell_height * HEAD_MAGNIFICATION, '' . $module_name . ' :: ' . $subject_name . '', 1, 1, $defalign, 1);
$pdf->SetFont(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA);
$pdf->writeHTMLCell(0, $data_cell_height, PDF_MARGIN_LEFT, $pdf->GetY(), $subject_description, 1, 1);
// --- end subject info ---
$pdf->Ln(5);
// ---- questions
$sqluc = 'SELECT testuser_comment FROM ' . K_TABLE_TEST_USER . ' WHERE testuser_id=' . $testuser_id . '';
if ($ruc = F_db_query($sqluc, $db)) {
if ($muc = F_db_fetch_array($ruc)) {
$testuser_comment = F_decode_tcecode($muc['testuser_comment']);
}
} else {
F_display_db_error();
}
$test_end_time = $m['test_end_time'];
// Set backlink QR-Code
$pdf->setTCExamBackLink(K_PATH_URL . 'admin/code/tce_show_result_user.php?testuser_id=' . $testuser_id . '&test_id=' . $test_id . '&user_id=' . $user_id);
// ------------------------------------------------------------
// --- start page data ---
$pdf->AddPage();
// set barcode
$pdf->setBarcode($test_id . ':' . $user_id . ':' . $test_start_time);
$pdf->SetFillColor(204, 204, 204);
$pdf->SetLineWidth(0.1);
$pdf->SetDrawColor(0, 0, 0);
// print document name (title)
$pdf->SetFont(PDF_FONT_NAME_DATA, 'B', PDF_FONT_SIZE_DATA * K_TITLE_MAGNIFICATION);
$pdf->Cell(0, $main_cell_height * K_TITLE_MAGNIFICATION, $doc_title, 1, 1, 'C', 1);
$pdf->Ln(5);
// display user info
// add a bookmark
//$pdf->Bookmark($user_lastname.' '.$user_firstname.' ('.$user_name.'), '.$test_score.' '.F_formatPdfPercentage($test_score / $test_max_score), 0, 0);
// calculate some sizes
$user_elements = 4;
$user_data_cell_width = round($page_width / $user_elements, 2);
// print table headings
$pdf->SetFont(PDF_FONT_NAME_DATA, 'B', PDF_FONT_SIZE_DATA);
// subject ID
$sql_questions_order_by = ' ORDER BY question_subject_id';
break;
}
// NOTE: PDF tests are always random
for ($item = 1; $item <= $test_num; $item++) {
// generate $test_num tests
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// data to be printed as QR-Code to be later used as input from scanner/image
$barcode_test_data = array();
$barcode_test_data[0] = $test_id;
// --- start page data ---
$pdf->AddPage();
$test_ref = $test_id . ':' . $item . ':' . date(K_TIMESTAMP_FORMAT);
// set barcode
$pdf->setBarcode($test_ref);
$pdf->SetFillColor(204, 204, 204);
$pdf->SetLineWidth(0.1);
$pdf->SetDrawColor(0, 0, 0);
$pdf->SetTextColor(0, 0, 0);
// print document name (title)
$pdf->SetFont(PDF_FONT_NAME_DATA, 'B', PDF_FONT_SIZE_DATA * K_TITLE_MAGNIFICATION);
$pdf->Cell(0, $main_cell_height * K_TITLE_MAGNIFICATION, $doc_title, 1, 1, 'C', 1);
$pdf->SetTextColor(255, 0, 0);
$pdf->SetFont(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA);
$pdf->Cell(0, 5, '[' . $test_ref . ']', 0, 1, 'C', false, '', 0, false, 'T', 'M');
$pdf->SetTextColor(0, 0, 0);
//$pdf->Ln(5);
// display user info input boxes
// calculate some sizes
$user_elements = 4;
// set document signature
$pdf->setSignature(K_DIGSIG_CERTIFICATE, K_DIGSIG_PRIVATE_KEY, K_DIGSIG_PASSWORD, K_DIGSIG_EXTRA_CERTS, K_DIGSIG_CERT_TYPE, array('Name' => K_DIGSIG_NAME, 'Location' => K_DIGSIG_LOCATION, 'Reason' => K_DIGSIG_REASON, 'ContactInfo' => K_DIGSIG_CONTACT));
}
// calculate some sizes
$cell_height_ratio = K_CELL_HEIGHT_RATIO + 0.1;
$page_width = $pdf->getPageWidth() - PDF_MARGIN_LEFT - PDF_MARGIN_RIGHT;
$data_cell_height = round($cell_height_ratio * PDF_FONT_SIZE_DATA / $pdf->getScaleFactor(), 2);
$main_cell_height = round($cell_height_ratio * PDF_FONT_SIZE_MAIN / $pdf->getScaleFactor(), 2);
$data_cell_width = round($page_width / $page_elements, 2);
$data_cell_width_third = round($data_cell_width / 3, 2);
$data_cell_width_half = round($data_cell_width / 2, 2);
// ------------------------------------------------------------
// --- start page data ---
$pdf->AddPage();
// set barcode
$pdf->setBarcode($user_id . ':' . date('YmdHis'));
$pdf->SetFillColor(204, 204, 204);
$pdf->SetLineWidth(0.1);
$pdf->SetDrawColor(0, 0, 0);
// print document name (title)
$pdf->SetFont(PDF_FONT_NAME_DATA, 'B', PDF_FONT_SIZE_DATA * K_TITLE_MAGNIFICATION);
$pdf->Cell(0, $main_cell_height * K_TITLE_MAGNIFICATION, $doc_title, 1, 1, 'C', 1);
$pdf->Ln(5);
// display user info
// calculate some sizes
$user_elements = 5;
$user_data_cell_width = round($page_width / $user_elements, 2);
// print table headings
$pdf->SetFont(PDF_FONT_NAME_DATA, 'B', PDF_FONT_SIZE_DATA);
$pdf->Cell($user_data_cell_width, $data_cell_height, $l['w_lastname'], 1, 0, 'C', true, '', 1);
$pdf->Cell($user_data_cell_width, $data_cell_height, $l['w_firstname'], 1, 0, 'C', true, '', 1);
