<?php
require_once("common.php");

foreach(query_array("			##########################################################
					SELECT	*,
						REPLACE(
							DATE_FORMAT(CONCAT(date,' ',
								CASE
									WHEN NOT(ISNULL(dates.start))		THEN dates.start
									WHEN NOT(ISNULL(activities.start))	THEN activities.start
									ELSE ''
								END),'$date_format %k:%i'),

							DATE_FORMAT(NOW(),'$date_format'),
							'I dag') AS start
					FROM	$dates_query
					LEFT JOIN activities USING(activity)
					WHERE	date >= DATE(NOW())
					##########################################################") AS $event) {
	$months[substr($event->date,0,7)][$event->activity][] = $event;
}

echo "
				<table border=1>
					<tr>
						<th>*</th>
						<th>Primo</th>
						<th>Installfest</th>
						<th>Medio</th>
						<th>Linuxaften</th>
						<th>Ultimo</th>
					</tr>";
function print_std($field) {
	global $event_type;
	global $months;
	echo "
						<td valign='top'>";
	if ($events = $event_type[$field]) {
		$date = $events[0]->date." (".date("D",strtotime($events[0]->date)).")";
		//echo "<pre>".print_r($events,true)."</pre>";
		echo "$date<br>";
		unset($months[$month][$field]);
		unset($event_type[$field]);
	}
	echo "</td>";
}

foreach($months AS $month => $event_type) {
	switch_bgcolor();
	echo "<tr $bgcolor>
						<td>$month</td>";
	/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
	echo "
						<td>";
	foreach($event_type AS $field => $e) foreach($e AS $event)
		if (($event->date < $event_type["Installfest"][0]->date || !$event_type["Installfest"][0]->date) &&
			$event->activity != "Linuxaften") {
			$date = $event->date." (".date("D",strtotime($event->date)).")";
			echo "$date:<br><b>$event->activity</b><br>";
			unset($months[$month][$field]);
			unset($event_type[$field]);
		}
	echo "</td>";
	/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
	print_std("Installfest");
	/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
	echo "
						<td>";
	foreach($event_type AS $field => $e) foreach($e AS $event) if ($event->date < $event_type["Linuxaften"][0]->date) {
		$date = $event->date." (".date("D",strtotime($event->date)).")";
		echo "
						$date:<br><b>$event->activity</b><br>";
		unset($months[$month][$field]);
		unset($event_type[$field]);
	}
	echo "
						</td>";
	/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
	print_std("Linuxaften");
	/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
	echo "
						<td>";
	foreach($event_type AS $field => $e) foreach($e AS $event) if ($event->date > $event_type["Linuxaften"][0]->date) {
		$date = $event->date." (".date("D",strtotime($event->date)).")";
		echo "$date:<br><b>$event->activity</b><br>";
		unset($months[$month][$field]);
		unset($event_type[$field]);
	}
	echo "</td>";
	/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
	echo "
					</tr>";
	if (count($event_type)) {
		foreach($event_type AS $e) foreach($e AS $event) {
			$date = $event->date." (".date("D",strtotime($event->date)).")";
			echo "<tr $bgcolor>
						<td colspan=2>
							$date: $event->activity";
		//	echo "<pre>".print_r($event,true)."</pre>";
			echo "
						</td>";
			echo "
					</tr>";
		}
	}
}
echo "
				</table>";
//echo "<pre>".print_r($months,true)."</pre>";
