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

check_admin_sql();

$db = mdb2_open($dsn);

$fp = fopen_or_fail($_POST['file']);

header('Content-Type: text/plain');
header('Content-Disposition: inline; filename=info.txt');

$years = array (
	'0809' => 1,
	'0910' => 2,
	'1011' => 3,
	'1112' => 4,
	'1213' => 5,
	'1314' => 6
);

while (($line = fgetcsv($fp, 0, ';')) !== false) {
	if (!$line) continue;
	if ($line[0] == 'NULL') continue;
	//print_r($line);
	$grp_id = mdb2_single_val($db, "SELECT grp_id FROM grp WHERE grp_name = '%q'", $line[1]);
	if (!$grp_id) fatal_error("groep {$line[1]} niet gevonden");
	if (!($year_id = $years[$line[2]])) fatal_error("onbekend schooljaar");

	if (mdb2_exec_error($db, ($server_type == 'sqlsrv')?-1:MDB2_ERROR_CONSTRAINT, "INSERT INTO grp2subj ( grp_id, subj_id ) VALUES ( $grp_id, %i )", $line[0])) 
		$grp2subj_id = mdb2_single_val($db, $last_insert_id);
	else $grp2subj_id = mdb2_single_val($db, "SELECT grp2subj_id FROM grp2subj WHERE grp_id = $grp_id AND subj_id = %i", $line[0]);
	if (!$grp2subj_id) {
		print_r($line);
		fatal_error("grp2subj_id niet gemaakt of gevonden?");
}
	mdb2_exec($db, "INSERT INTO year2grp2subj ( year_id, grp2subj_id ) VALUES ( $year_id, $grp2subj_id )");
}

header('Location: index.php');
?>