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

$db = mdb2_open($dsn);

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

$input_encoding = 'ISO-8859-1';

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

$year_info = $years['1415'];

$year_id = 7; // FIXME

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

	if (strpos($line[2], '_') !== FALSE) {
		$grp_home = 0;
		$grp_name = substr($line[4], 0, 1).$line[2];
		$subj_abbrev = strstr($line[2], '_', TRUE);
		echo("cluster $grp_name, $subj_abbrev, ll {$line[0]}\n");
	} else continue; // stamklassen zijn al gevuld

	$grp_id = mdb2_single_val($db, "SELECT grp_id FROM grp WHERE grp_name = '%q'", $grp_name);
	if (!$grp_id) {
		// meh, cluster niet gevonden
		echo("grp $grp_name onbekend stamklas?\n");
		continue;
		/*echo("grp $grp_name onbekend, is het een alias?\n");
		$pos = strpos($grp_name, '_');
		echo("pos=$pos\n");
		$alias = substr($grp_name, 0, $pos).substr($grp_name, $pos + 1);
		$grp_id = mdb2_single_val($db, "SELECT grp_id FROM grp WHERE grp_name = '%q'", $alias);
		if (!$grp_id) {
			continue; // we gaan ervan uit dat het een stamklas is
		} else {
			echo("grp $grp_name heeft als alias $alias");
		}*/
	}

	$ppl_id = mdb2_single_val($db, "SELECT ppl_id FROM ppl WHERE ppl_login = '%q'", $line[0]);
	if (!$ppl_id) error_system("ppl {$line[0]} onbekend");

	$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]} )");
	}

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