1 files changed, 31 insertions, 4 deletions

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();
 }