<?php

require_once("/usr/lib/wangerin/standard_functions.php");

function quote($s) { return ($s ? "\"".
					iconv(	"ISO-8859-1/"."/IGNORE",	"UTF-8",	$s).
													"\"" : ""); }

$pre_where = "\r\n\t\t\t\t\tactivity LIKE '";

foreach(query("		###############################################
			SELECT	*,
				IF(ISNULL(	dates.start	),	activities.start,	dates.start	) AS start,
				IF(ISNULL(	dates.end	),	activities.end,		dates.end	) AS end,
				CASE
					WHEN activity = 'Installfest'	THEN '2nd saturday of each month'
					WHEN activity = 'Linuxaften'	THEN 'rolling weekdays 1-2 times each month'
				END AS remark
			FROM	dates
			LEFT JOIN activities USING(activity)
			LEFT JOIN locations USING(location)
			WHERE	DATE(NOW()) <= date AND date <= DATE(DATE_ADD(NOW(),INTERVAL 2 MONTH))	AND
				NOT(ISNULL(lat)) AND
				NOT(ISNULL(lon)) AND
				(".$pre_where.
						join("' OR".$pre_where,array(
										"Installfest",
										"Linuxaften",
										"Udstilling %",
												))."'
				)
			ORDER BY date
			###############################################") AS $event) {
//	print_r($event);
	echo join("; ",array(
				"ENTRY_TYPE=".			quote("EVENT"),						// /k
				"ENTRY_OPTIONS=".		quote("CONTACT_US"),					//

				"email_organizer=".		quote($_SERVER["PATH_INFO"] == "/f3c298fad65cc4c607ac9f448ba6e1dfbfb072f00f66c7d5de04268fb5c6cfa7"
									? "linux-events.org@services.alslug.dk" : ""),	// /m
				"fediverse=".			quote(""),
				"name_organizer=".		quote("AlsLUG"),					// /m
				"presenter=".			quote("AlsLUG - Alssung Linux Usergroup"),		// /m
				"presentation=".		quote($event["activity"]),				// /m
				"link_presenter=".		quote("https:/"."/www.alslug.dk"),			// /m
				"link_presentation=".		quote(""),						//

				"country=".			quote("Danmark"),					// /m
				"city=".			quote($event["city"]),					// /m
				"location=".			quote($event["addr"]),					//
				"LAT=".				quote($event["lat"]),					// /m
				"LON=".				quote($event["lon"]),					// /m

				"event_date=".			quote($event["date"]),					// /m
				"event_date_to=".		quote(""),
				"event_time_from_to=".		quote(substr($event["start"],0,5)."-".substr($event["end"],0,5)),
				"remark=".			quote($event["remark"]),
			//	"needs=".			quote("( if possible due to COVID-19 - please check https:/"."/www.alslug.dk/ for details )"
			//						//	."( testing linux-events in progress - ".date("Y-m-d")." )"
			//															),
				"extras=".			quote(""),
				"promise=".			quote("ACCEPT"),					// /k /m
				"link_navigation=".		quote(""),
				"link_public_transport=".	quote(""),

				))."\r\n\r\n";
}