#!/usr/bin/php5
<?
function apache_note() {
}

require_once('common.php');
require_once('phplib/phplib.php');

$db = mdb2_open($dsn);

if (count($argv) != 2) error_system("1 argument nodig!");

/* moment_id, grp_id, toets, lok, surv
 */
if (!($fp = fopen($argv[1], 'r'))) error_system("file {$argv[1]} kan niet worden geopend");

if (($legend = fgetcsv($fp, 0, ';')) == false) error_system("unable to read first line of file");

$revlegend = array();

foreach ($legend as $idx => $column) {
	if (trim($column) == '') continue;
	$revlegend[$column] = $idx;
}

print_r($revlegend);

$herinfo = get_herinfo($db);

$count = mdb2_single_val($db, "SELECT COUNT(*) FROM roosterdetail WHERE period_id = {$herinfo['period_id']}");
if ($count) error_system("er staat al een rooster in het systeem");

print_r($herinfo);

if (!isset($revlegend['grp_id']) || !isset($revlegend['moment_id']) || !isset($revlegend['toets']) || !isset($revlegend['lok']) || !isset($revlegend['surv'])) error_system('bestand incompleet');

while ($row = fgetcsv($fp, 0, ';')) {
	mdb2_exec($db, "INSERT INTO roosterdetail (grp_id, moment_id, activiteit, lok, surv, period_id) VALUES ( %i, %i, '%q', '%q', '%q', {$herinfo['period_id']} )",
		$row[$revlegend['grp_id']],
		$row[$revlegend['moment_id']],
		$row[$revlegend['toets']],
		$row[$revlegend['lok']],
		$row[$revlegend['surv']]);
	//print_r($row);
}

fclose($fp);
?>