<?
include('phplib/phplib.php');
include('common.php');

check_personeel();

define('LEERLING', 1);
define('DOCENT', 2);
define('LOKAAL', 3);
define('LESGROEP', 4);
define('STAMKLAS', 5);
define('VAK', 6);
define('CATEGORIE',7);

$file_id = mdb2_single_val($db, <<<EOQ
SELECT file_id FROM $roosterdb.files
WHERE file_type = 1 AND file_status = 1
ORDER BY file_time DESC
LIMIT 1
EOQ
);

$date = date('Ymd');

$and = '';
$toets_tp = '';
if (!isset($_GET['toets_tp'])) error_system("impossible");

$toets_tp = $_GET['toets_tp'];
if ($toets_tp == 'TP1' || $toets_tp == 'TP2' || $toets_tp == 'TP3') {
	$and = ' AND toets_tp = \''.$toets_tp.'\'';
} else error_system("impossible value for toets_tp");

$toetsen = mdb2_query($db, <<<EOQ
SELECT CONCAT(toets_target, ' ', subj_abbrev, ' ',
		IF(toets_soort = 'VT', 'VT', IF(toets_soort = 'PO', 'PO', 'ST')),
		toets_nummer,
		IF(toets_omschrijving = '', '', CONCAT(' ', toets_omschrijving)),
		CASE WHEN toets_lokaal = 'COMPUTERLOKAAL' THEN ' (COM)' WHEN toets_lokaal = 'KIJKLUISTERLOKAAL' THEN ' (kltlok)' ELSE '' END) formule
FROM toets
JOIN toets2subj USING (toets_id)
JOIN $kldv.subj USING (subj_id)
WHERE year_id = $year_id$and
-- AND ( toets_soort = 'VT' OR toets_soort = 'STGEENHER' )
AND ( toets_soort = 'VT' )
ORDER BY formule
EOQ
);

$filename = "her-vts-$toets_tp-".date("YmdHis").'.txt';
header('Content-type: text/csv');

/* 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");
header('Content-Disposition: attachment; filename='.$filename.';');

while (($row = $toetsen->fetchRow(MDB2_FETCHMODE_ASSOC))) {
	echo($row['formule']."\n");
}