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

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

$db = mdb2_open($dsn);

$herinfo = get_herinfo($db);

//print_r($herinfo);

$period_id = $herinfo['period_id'];
$buiten_beschouwing = get_buiten_beschouwing($db, $period_id);
$samenvoegen = get_samenvoegen($db, $herinfo['period_id']);
$toetsen = get_toetsen_from_db($db, $period_id, $buiten_beschouwing, $samenvoegen);

//print_r($toetsen);

$collections = array();
make_collections($collections, $toetsen);
$rooster2 = get_rooster($db, $period_id);

//print_r($rooster2);

/*
$momentsinfo = mdb2_all_assoc_rekey($db, <<<EOQ
SELECT moments.moment_id, moments.moment_date, moments.moment_time_start, moments.moment_time_end, TIME_TO_SEC(TIMEDIFF(moments.moment_time_end, moments.moment_time_start)) DIV 60 duur, GROUP_CONCAT(bla.moment_id)
FROM moments
JOIN (
	SELECT * FROM moments WHERE period_id = 23
) AS bla ON bla.moment_date = moments.moment_date AND bla.moment_time_start < moments.moment_time_end AND bla.moment_time_end > moments.moment_time_start
WHERE moments.period_id = 23
GROUP BY moments.moment_id
EOQ
);

print_r($momentsinfo);
 */

$moments = get_moments($db, $period_id);

$momentinfos = get_momentinfos($moments);
set_colors_from_rooster2($toetsen, $rooster2, $momentinfos['to_color']);

//print_r($toetsen);
$ret = check_consistent_and(true, $toetsen, $collections, $momentinfos);

if ($ret) {
	echo("ok\n");
} else {
	echo("NAK\n");
}

//print_r($momentinfos);

$conflicts = get_conflicts($db, 24);

print_r($conflicts);

//echo("duur 5 ".get_duur($momentinfos, 5)."\n");

?>