From 8d45c8fc94b1ee7c8b1779075b8f332fb137b8d3 Mon Sep 17 00:00:00 2001
From: horus
Date: Tue, 13 Dec 2022 14:38:18 +0100
Subject: Franzis Änderungen eingepflegt.

---
 functions.php | 35 +++++++++++++++++++++++++++++++----
 1 file changed, 31 insertions(+), 4 deletions(-)

(limited to 'functions.php')

diff --git a/functions.php b/functions.php
index d600f34..e31ce0f 100644
--- a/functions.php
+++ b/functions.php
@@ -56,10 +56,16 @@ function renderSubmission($db) {
 
 		if ( "mit_fleisch" ==  $_REQUEST[$id . "_essenwahl"]) {
 			$stmt = $db->prepare("UPDATE gästeliste SET essenwahl = ? WHERE id = ?");
-			$stmt->execute(array(1, $id));
+			$stmt->execute(array(0, $id));
+		} else if ( "vegan" ==  $_REQUEST[$id . "_essenwahl"] ) {
+			$stmt = $db->prepare("UPDATE gästeliste SET essenwahl = ? WHERE id = ?");
+			$stmt->execute(array(2, $id));
+		} else if ( "kinder" ==  $_REQUEST[$id . "_essenwahl"] ) {
+			$stmt = $db->prepare("UPDATE gästeliste SET essenwahl = ? WHERE id = ?");
+			$stmt->execute(array(3, $id));
 		} else {
 			$stmt = $db->prepare("UPDATE gästeliste SET essenwahl = ? WHERE id = ?");
-			$stmt->execute(array(0, $id));
+			$stmt->execute(array(1, $id));
 		}
 	}
 
@@ -90,12 +96,33 @@ function getGästeId($db, $familien_id) {
 }
 
 function getData($db, $familien_id = null) {
+	$query = "
+		SELECT
+			short_link,
+			bemerkungsfeld,
+			kommt_mit_auto,
+			auto_freie_plätze,gästeliste.id as id,
+			name,
+			familien_id,
+			essenwahl,
+			zusage
+		FROM
+			familie
+		JOIN
+			gästeliste on familie.id = gästeliste.familien_id
+		WHERE
+	";
+
 	if ( is_null($familien_id) ) {
-		$stmt = $db->prepare("SELECT short_link,bemerkungsfeld,kommt_mit_auto,auto_freie_plätze,gästeliste.id as id, name, familien_id, essenwahl, zusage FROM familie JOIN gästeliste on familie.id = gästeliste.familien_id WHERE short_link = ?");
+
+		$stmt = $db->prepare( $query . " short_link = ?");
 		$stmt->execute(array(ltrim($_SERVER["REQUEST_URI"],"/")));
+
 	} else {
-		$stmt = $db->prepare("SELECT short_link,bemerkungsfeld,kommt_mit_auto,auto_freie_plätze,gästeliste.id as id, name, familien_id, essenwahl, zusage FROM familie JOIN gästeliste on familie.id = gästeliste.familien_id WHERE familien_id = ?");
+
+		$stmt = $db->prepare( $query . " familien_id = ?");
 		$stmt->execute(array($familien_id));
+
 	}
 	return $stmt->fetchAll();
 }
-- 
cgit v1.2.3