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

$db = mdb2_open($dsn);

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

$input_encoding = 'ISO-8859-1';
$schooljaar = '1415';

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) ),
	'1314' => array( mktime(0, 0, 0, 8, 1, 2013), mktime(0, 0, 0, 8, 1, 2014) ),
	'1415' => array( mktime(0, 0, 0, 8, 1, 2014), mktime(0, 0, 0, 8, 1, 2015) )
);

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

        $naam0 = htmlenc(iconv($input_encoding, "UTF-8", trim($line[1])));
        $naam1 = htmlenc(iconv($input_encoding, "UTF-8", trim($line[7])));
        $login = htmlenc(iconv($input_encoding, "UTF-8", trim($line[0])));

	//exit;
	//
	$ppl_id = mdb2_single_val($db, "SELECT ppl_id FROM ppl WHERE ppl_login = '%q'", $login);
	if (!$ppl_id) {
		mdb2_exec($db, "INSERT INTO ppl ( ppl_login, ppl_surname, ppl_forename, ppl_prefix ) VALUES ( '%q', '%q', '%q', '' )", $login, $naam1, $naam0);
		$ppl_id = mdb2_single_val($db, $last_insert_id);
	}
	
	// stamklas
	$grp_id = mdb2_single_val($db, "SELECT grp_id FROM grp WHERE grp_name = '%q'", $line[9]);
	if (!$grp_id) {
		mdb2_exec($db, "INSERT INTO grp ( grp_name, grp_home ) VALUES ( '%q', 1 )", $line[9]);
		$grp_id = mdb2_single_val($db, $last_insert_id);
	}

	if (!($year_info = $years[$schooljaar])) fatal_error("onbekend schooljaar");

	$ppl2grp_id = mdb2_single_val($db, "SELECT ppl2grp_id FROM ppl2grp WHERE ppl_id = $ppl_id AND grp_id = $grp_id AND ppl_enter = {$year_info[0]} AND ppl_exit = {$year_info[1]}");
	if (!$ppl2grp_id) {
		mdb2_exec($db, "INSERT INTO ppl2grp ( ppl_id, grp_id, ppl_enter, ppl_exit ) VALUES ( $ppl_id, $grp_id, {$year_info[0]}, {$year_info[1]} )");
	}
	echo("$naam1 $naam0 ($login) ppl_id=$ppl_id, in klas {$line[9]} grp_id=$grp_id\n");

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