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

function conv($s) {
	$sr = array(
			"Monday"	=> "mandag",
			"Tuesday"	=> "tirsdag",
			"Wednesday"	=> "onsdag",
			"Thursday"	=> "torsdag",
			"Friday"	=> "fredag",
			"Saturday"	=> "lørdag",
			"Sunday"	=> "søndag",

			"January"	=> "januar",	"February"	=> "februar",	"March"		=> "marts",
			"April"		=> "april",	"May"		=> "maj",	"June"		=> "juni",
			"July"		=> "juli",	"August"	=> "august",	"September"	=> "september",
			"October"	=> "oktober",	"November"	=> "november",	"December"	=> "december",
			);
	return html_entity_decode(str_replace(array_keys($sr),$sr,$s));
}
$standard_query = "			##################################################
					SELECT	date,
						activity,
						location,
						IF(ISNULL(dates.start),		activities.start,		dates.start		) AS start,
						IF(ISNULL(dates.end),		activities.end,			dates.end		) AS end,
						IF(ISNULL(dates.title),		activities.title,		dates.title		) AS title,

						IF(ISNULL(dates.linux_in_mail),	activities.linux_in_mail,	dates.linux_in_mail	) AS linux_in_mail,
						IF(ISNULL(dates.other_in_mail),	activities.other_in_mail,	dates.other_in_mail	) AS other_in_mail,
						IF(ISNULL(dates.opraab),	activity_opraab.text,		event_opraab.text	) AS opraab,
						IF(ISNULL(dates.opraab),	activity_opraab.id,		event_opraab.id		) AS opraab_id,
						IF(ISNULL(dates.info),		activity_info.text,		event_info.text		) AS info,
						IF(ISNULL(dates.info),		activity_info.id,		event_info.id		) AS info_id
					FROM	dates
					LEFT JOIN activities USING(activity)
					LEFT JOIN event_text AS event_opraab	ON (dates	.opraab	= event_opraab		.id)
					LEFT JOIN event_text AS activity_opraab	ON (activities	.opraab	= activity_opraab	.id)
					LEFT JOIN event_text AS event_info	ON (dates	.info	= event_info		.id)
					LEFT JOIN event_text AS activity_info	ON (activities	.info	= activity_info		.id)
";
$next_install_fest = query_array($standard_query."
					WHERE	date > now() AND activity LIKE '%Installfest'
					ORDER BY date
					LIMIT	1
					##################################################")[0];
$next_events = query_array($standard_query."
					WHERE	SUBSTRING(activity,1,6) != 'AFLYST'	AND
						NOW() < date AND date < DATE_ADD(NOW(), INTERVAL 3 MONTH)
					ORDER BY date
					##################################################");
$titles = $linux_events_text = $other_events_text = $opraab = $info = array();
$medtag_alt = 1;
foreach($next_events AS $event) {
//	if (date("Ymd",$event->date) != "20210503")
	foreach(array("activity", "title", "opraab", "info", ) AS $field)
		$event->$field 	= iconv("ISO-8859-1", "UTF-8", $event->$field);
//	print_r($event);
	if (	($medtag_alt && ($event->linux_in_mail || $event->other_in_mail)) ||
				($event->linux_in_mail > 1 || $event->other_in_mail > 1)) {

		if ($event->date != $next_install_fest->date) {
			$var = ($event->linux_in_mail ? "linux" : "other")."_events_text";
			$$var[] = "\t".conv(
							date("l",strtotime($event->date))." d. ".date("d, F",strtotime($event->date)).
							(substr($event->start,0,5) != "00:00"
								? " ".substr($event->start,0,5)
								: "").
							": ".
							$event->activity.
							""
						);
			if (strpos("x".$event->activity,"Installfest")) {
				$lidt_laengere_ude_i_fremtiden = count($linux_events_text);
				$linux_events_text["fremtiden"] = "\nLidt længere ude i fremtiden:\n";
				$medtag_alt = 0;
				continue;
			}
			$lidt_laengere_ude_i_fremtiden = 0;
		}
		$sr = array(
				"|"		=> "\n",
				"--DATO--"	=> conv(date("l",strtotime($event->date))." d. ".date("d. F",strtotime($event->date))),
				);
		if ($event->opraab)	$opraab[$event->opraab_id]	= str_replace(array_keys($sr), $sr, $event->opraab	);
		if ($event->info)	$info[$event->info_id]		= str_replace(array_keys($sr), $sr, $event->info	);
		if ($event->title)	$titles[]			= str_replace(array_keys($sr), $sr, $event->title	);
	}
}
if ($lidt_laengere_ude_i_fremtiden)
	unset($linux_events_text[$lidt_laengere_ude_i_fremtiden]);
//print_r($next_events);
//print_r($other_events);
//print_r($other_events_text);

//echo "111111111111111111111111111111111111111111\r\n";
//print_r($next_install_fest); print_r($next_events); die();

if (count($opraab)) $opraab[] = "\n\n";
if (count($info)) $info[] = "\n\n";

ksort($info);

echo json_encode(array(
			"next_installparty" => $next_install_fest->date,
		//	"x-subject" => "Husk ".$next_install_fest->activity." i AlsLUG lørdag den ".conv(date("d. F",strtotime($next_install_fest->date))),
			"subject" => "[AlsLUG] Kommende aktiviteter: ".join(" - ",$titles),
			"x-linux" => $linux_events_text,
			"x-other" => $other_events_text,
			"body" => join("\n",array(
				"Hej %recipient_name%!",
				"",
				"Så er det igen tid til ".
								$next_install_fest->activity.
												" i AlsLUG, hvor du kan få hjælp og tips til din linux-pc.",
				"",
				"	lørdag den ".
						conv(date("d. F",strtotime($next_install_fest->date))).
							" kl ".substr($next_install_fest->start,0,5)."-".
										substr($next_install_fest->end,0,5).
				(substr($next_install_fest->activity,0,6) == "ONLINE"
					? ""
					: join("\n",array(
								" (eller senere hvis vi ikke er færdig med arbejdet)",
								"",
								"i vores lokale på",
								"",
								"	Bakkensbro Aktivitets- og KulturCenter ( Ullerup gl skole )",
								"	Bakkensbro 6, ( Indkørsel via Rosenvej )",
								"	Ullerup",
								"	6400 Sønderborg",
								"",
								"",
								))),
				(file_exists($additional_file = "additional_in_monthly_mail/".date("Y-m-d",strtotime($next_install_fest->date)).".txt")
					? file_get_contents($additional_file)."\n\n\n"
					: ""),
				"",
					join("\n\n\n",$opraab),
				"** Har du brug for assistance til din linux-pc, kan vi også hjælpe disse dage: **",
				"",
					join("\n",$linux_events_text),
				"",
				"Der kan være planlagt ting der skal klares først, inden vi kan hjælpe.",
				"",
				"",
				"",
				"",
				"",
				"** Vi har andre aktiviteter på følgende dage: **",
				"",
					join("\n",$other_events_text),
				"",
				"",
				"",
				"",
				"",
					join("\n\n\n",$info),
				"Vel mødt !",
				"",
				"-- ",
				"Bestyrelsen",
				"AlsLUG - Alssund Linux Brugergruppe",
				"www.alslug.dk",
				"",
				"",
				"Hvis du ikke ønsker at modtage mails fra AlsLUG fremover, kan du afmelde dem på denne link:",
				"%unsubscribe_url%",
				"Du udmeldes, og dine data fjernes fra vores medlemskartotek.",
			)),
		),JSON_PRETTY_PRINT);

//echo "222222222222222222222222222222222222222222\r\n";

/*
recipient                    %recipient%
recipient_email              %recipient_email%
recipient_name               %recipient_name%
recipient_fname              %recipient_fname%
recipient_lname              %recipient_lname%
unsubscribe_url              %unsubscribe_url%
mailing_list_unsubscribe_url %mailing_list_unsubscribe_url%
unsubscribe_email            %unsubscribe_email%
*/