<?
include('common.php');
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');

$year_id = 8; // 1516

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

	print_r($line);

	if (!($subj_id = mdb2_single_val($db, "SELECT subj_id FROM $kldv.subj WHERE subj_abbrev = '%q'", $line[0]))) error_system("vak {$line[0]} bestaat niet");

	if ($line[2] != "1516") error_system("verkeerde schooljaar {$line[2]}, we verwachten 1516"); // pas $year_id aan als je dit aanpast!

	switch ($line[3]) {
	case "4 HAVO":
		$type = 'H';
		if ($line[1] < 1 || $line[1] > 3) error_system("periode {$line[1]} is onmogelijk in {$line[3]}");
		break;
	case "4 VWO":
		$type = 'V';
		if ($line[1] < 1 || $line[1] > 3) error_system("periode {$line[1]} is onmogelijk in {$line[3]}");
		break;
	case "5 HAVO":
		$type = 'H';
		if ($line[1] < 4 || $line[1] > 6) error_system("periode {$line[1]} is onmogelijk in {$line[3]}");
		break;
	case "5 VWO":
		$type = 'V';
		if ($line[1] < 4 || $line[1] > 6) error_system("periode {$line[1]} is onmogelijk in {$line[3]}");
		break;
	case "6 VWO":
		$type = 'V';
		if ($line[1] < 6 || $line[1] > 9) error_system("periode {$line[1]} is onmogelijk in {$line[3]}");
		break;
	default:
		error_system("onmogelijke leerjaaropl ".$line[3]);
	}

	echo("$subj_id\n");
	
	if (isset($line[4])) 
	mdb2_exec($db, "INSERT INTO ptas ( pta_period, pta_target, year_id, subj_id, shortdesc ) VALUES ( %i, '$type', $year_id, $subj_id, '%q' )", $line[1], $line[4]);
	else
	mdb2_exec($db, "INSERT INTO ptas ( pta_period, pta_target, year_id, subj_id ) VALUES ( %i, '$type', $year_id, $subj_id )", $line[1]);

	//echo(strtotime($line[5])."\n");
	//mdb2_exec($db, "INSERT INTO rex ( rex_id, ppl_id, subj_id, period_id, info, timestamp ) VALUES ( %i, %i, %i, %i, '%q', %i )",
	//	$line[0], $line[1], $line[2], $line[3], $line[4], strtotime($line[5]));
}

//header('Location: '.$location.'admin_sql.php');
?>