<?
include('config.php');
include('common.php');

$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;

	$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_info = $years[$line[2]])) fatal_error("onbekend schooljaar");

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

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