<?
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' => array( mktime(0, 0, 0, 8, 1, 2008), mktime(0, 0, 0, 8, 1, 2009) ),
	'0910' => array( mktime(0, 0, 0, 8, 1, 2009), mktime(0, 0, 0, 8, 1, 2010) ),
	'1011' => array( mktime(0, 0, 0, 8, 1, 2010), mktime(0, 0, 0, 8, 1, 2011) ),
	'1112' => array( mktime(0, 0, 0, 8, 1, 2011), mktime(0, 0, 0, 8, 1, 2012) ),
	'1213' => array( mktime(0, 0, 0, 8, 1, 2012), mktime(0, 0, 0, 8, 1, 2013) )
);

while (($line = fgetcsv($fp, 0, ';')) !== false) {
	if (!$line) continue;

	$grp2subj_id = mdb2_single_val($db, "SELECT grp2subj_id FROM grp2subj JOIN grp ON grp.grp_id = grp2subj.grp_id WHERE grp_name = '%q' AND subj_id = %i", $line[2], $line[1]);
	if (!$grp2subj_id) fatal_error("grp2subj {$line[1]} {$line[2]} niet gevonden");
	if (!($year_info = $years[$line[3]])) fatal_error("onbekend schooljaar");

	mdb2_exec($db, "INSERT INTO ppl2grp2subj ( ppl_id, grp2subj_id, ppl_enter, ppl_exit ) VALUES ( %i, $grp2subj_id, {$year_info[0]}, {$year_info[1]} )", $line[0]);
}

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