week, 1, 0), week, dag, lesuur EOQ ); //echo(sprint_table($result2)); $select = ''; $join = ''; $count = 0; $th = ''; $th2 = ''; while ($row = mysql_fetch_array($result2)) { mysql_query_safe("INSERT IGNORE INTO cijfers (notitie_id, ppl_id) SELECT {$row[0]}, ppl_id FROM ppl JOIN ppl2grp USING (ppl_id) JOIN grp2vak USING (grp_id) WHERE grp2vak_id = '$grp2vak_id'"); $select .= ", l$count.cijfer {$row[1]}"; $join .=<<{$row[1]}\n"; $selected[0] = $selected[1] = $selected[2] = $selected[3] = ''; if ($row['periode_id'] == 'per1') $selected[1] = ' selected'; else if ($row['periode_id'] == 'per2') $selected[2] = ' selected'; else if ($row['periode_id'] == 'per3') $selected[3] = ' selected'; else $selected[0] = ' selected'; $th2 .= '123'."\n"; $nid[$count] = $row[0]; $count++; } $result_per1 = mysql_query_safe(<<setPrintHeader(0); $pdf->setPrintFooter(0); $pdf->SetMargins(0, 0, 0); $pdf->AddPage(); $pdf->SetAutoPageBreak(0); $mm_per_pt = 0.352777778; $a4_l_width = 297; $a4_l_height = 210; $a4_l_marg_top = 60; $a4_l_marg_bottom = 10; $a4_l_marg_left = 10; $a4_l_marg_right = 10; $baselinefactor = 1.2; $maxfontsize = 16*$mm_per_pt; $firstcolumn = 30; if ($baselinefactor*$maxfontsize*$num + $a4_l_marg_top + $a4_l_marg_bottom > $a4_l_height) { $maxfontsize = ($a4_l_height - $a4_l_marg_top - $a4_l_marg_bottom)/($num*$baselinefactor); } $pdf->SetFont('Times','',$maxfontsize/$mm_per_pt); $curr_x = $a4_l_marg_left; for ($i = 0; $i < $num; $i++) { $pdf->SetXY($curr_x, $a4_l_marg_top + $i*$maxfontsize*$baselinefactor); $pdf->Cell(15, $baselinefactor*$maxfontsize, mysql_result($result, $i, 1), 0, 0, 'R'); $customfontsize = $maxfontsize; while ($pdf->GetStringWidth(htmlspecialchars_decode(mysql_result($result, $i, 2), ENT_QUOTES)) > $firstcolumn) { $customfontsize *= 0.9; $pdf->SetFont('Times','',$customfontsize/$mm_per_pt); } $pdf->Cell($firstcolumn, $baselinefactor*$maxfontsize, htmlspecialchars_decode(mysql_result($result, $i, 2), ENT_QUOTES)); $pdf->SetFont('Times','',$maxfontsize/$mm_per_pt); for ($j = 3; $j < $count + 3; $j++) { $pdf->Cell(10, $baselinefactor*$maxfontsize, mysql_result($result, $i, $j), 0, 0, 'R'); } } /* we'll send a .pdf file */ header("Content-type: application/pdf"); /* some red tape to avoid bugs and weird errormessages in IE */ header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Cache-Control: public"); $pdf->Output(); /*gen_html_header('Cijferinvoer', <<

	periode:
nummer	naam	per1	per2	per3	rap1	rap2	rap3

*/