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

$test_id = 16;
$testtype_id = 4;

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

	if ($line[0] == 'leerlingnummer') {
		$legend = $line;
		continue;
	}

	if ($line[1] == '') continue;

	if (!($ppl_id = mdb2_single_val($db, "SELECT ppl_id FROM $kldv.ppl WHERE ppl_login = '%q'", $line[0]))) error_system('leerling niet gevonden');
	echo("found $ppl_id {$line[0]}\n");
	$time = strtotime($line[1]);
	$readin = array_combine($legend, $line);
	array_shift($readin);
	array_shift($readin);

	mdb2_exec($db, "INSERT INTO results ( ppl_id, test_id, timestamp ) VALUES ( $ppl_id, $test_id, $time )");
	$result_id = mdb2_single_val($db, $last_insert_id);
	foreach ($readin as $key => $value) {
		$row = mdb2_single_assoc($db, "SELECT * FROM testtype2scoretype JOIN scoretypes ON scoretypes.scoretype_id = testtype2scoretype.scoretype_id WHERE testtype_id = $testtype_id AND scoretype_name = '%q'", $key);
		if (!$row) error_system('import fail unable to find scoretype '.$key);
		switch ($row['scoretype_conv']) {
		case 'MINSEC':
			preg_match('/^([0-9]+):([0-9]+):([0-9]+)$/', $value, $matches);
			$value = 60*(60*$matches[1] + $matches[2]) + $matches[3];
			break;
		case 'RANGE:0,100':
		case 'ENUM:"A","B","C","D","E"':
		case 'ENUM:"-","Schoolse lezer","Probleemlezer","Compenserende lezer"':
		case 'ENUM:"naar 1F","1F","naar 2F","2F","naar 3F","3F"':
			break;
		default:
			error_system('import error');
			break;
		}
		mdb2_exec($db, "INSERT INTO scores ( scoretype_id, result_id ) VALUES ( {$row['scoretype_id']}, $result_id )");
		$score_id = mdb2_single_val($db, $last_insert_id);
		switch ($row['scoretype_sqltype']) {
		case 'INTEGER':
			mdb2_exec($db, "INSERT INTO scores_INTEGER ( score_id, score ) VALUES ( $score_id, %i )", $value);
			break;
		case 'VARCHAR32':
			mdb2_exec($db, "INSERT INTO scores_VARCHAR32 ( score_id, score ) VALUES ( $score_id, '%q' )", $value);
			break;
		}
	}
	//print_r($readin);
	//exit;
	//preg_match('/^([0-9]+):([0-9]+):([0-9]+)$/', $line[0], $matches);
	//$elapsed = 60*(60*$matches[1] + $matches[2]) + $matches[3];
	//print_r($matches);
	//echo('elapsed '.$elapsed."\n");
	//echo("\n".date('c', strtotime($line[1])).' '.$ppl_id."\n");
}

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