<?
require_once('phplib/phplib.php');
check_admin();

$db = mdb2_open($dsn);

if ($_POST['order_by'] == 'workshop') {
	$order_by = 'workshop, ';
} else if ($_POST['order_by'] == 'basisschool') {
	$order_by = 'basisschool, ';
} else {
	$order_by = '';
}

$list = mdb2_query($db, <<<EOQ
SELECT inschrijving_id id,
	$concat_begin naam1 $concat_cont ' ' $concat_cont naam2 $concat_cont ' ' $concat_cont  naam0 $concat_end naam,
	email, tel, route_title route, timeslot_start timeslot
FROM ouders
JOIN routes USING (route_id)
JOIN timeslots USING (timeslot_id)
WHERE timestamp_delete IS NULL
ORDER BY ${order_by}naam0, naam1, naam2, timestamp_create
EOQ
);

/* we'll send a .csv file */
header("Content-type: text/csv");

/* some red tape to avoid bugs and weird errormessages in IE */
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: public");
header('Content-Disposition: attachment; filename=export.csv;');

$file = fopen('php://output', 'w');
if (!$file) fatal_error('unable to open output');
fputcsv($file, array('id', 'naam', 'email', 'tel', 'route', 'start'), ';', '"');

if (!($row = $list->fetchRow(MDB2_FETCHMODE_ORDERED))) {
	/* geen inschrijvingen ?!?! */
	exit;
}

do {
	$row[1] = iconv('UTF-8', 'ISO-8859-1', htmldec($row[1]));
	$row[2] = iconv('UTF-8', 'ISO-8859-1', htmldec($row[2]));
	$row[3] = iconv('UTF-8', 'ISO-8859-1', htmldec($row[3]));
	fputcsv($file, $row, ';', '"');
} while (($row = $list->fetchRow(MDB2_FETCHMODE_ORDERED)));

?>