1 files changed, 91 insertions, 0 deletions
diff --git a/Bachelor/Entwicklung webbasierter Anwendungen/Praktikum5_6/k-lieferzustand.php b/Bachelor/Entwicklung webbasierter Anwendungen/Praktikum5_6/k-lieferzustand.php
new file mode 100644
index 0000000..3d55af5
--- /dev/null
+++ b/Bachelor/Entwicklung webbasierter Anwendungen/Praktikum5_6/k-lieferzustand.php
@@ -0,0 +1,91 @@
+<?php
+	include ("classes.inc");
+	session_start();
+	$Con=mysql_connect('localhost','ewa','ewa',3306)
+		or die('Could not connect: ' . mysql_error());
+	mysql_select_db('ewa') or die('Could not select database');
+	$sid = session_id();
+	$query = "SELECT b.AuftragNr,b.SessionId, p.Bezeichnung, b.Lieferadresse, b.Zustand
+		FROM t_bestellung b 
+		NATURAL JOIN t_pizza p
+		WHERE b.SessionId = '$sid'
+		";
+	$result = mysql_query($query) or die('Query failed: ' . mysql_error());
+	
+	$n=0;
+	while($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
+		$KDBest[$n] = new Bestellung($line[AuftragNr],
+														$line[SessionId],
+														$line[Lieferadresse],
+														$line[Bezeichnung],
+														$line[Zustand]
+														);
+		$n++;
+	}
+?>
+
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
+     "http://www.w3.org/TR/html4/strict.dtd">
+<html>
+<head>
+	<title>Kunde (Lieferzustand)</title>
+	<link rel="stylesheet" type="text/css" href="formats.css">
+	<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
+</head>
+
+<body>
+	  <h1>Kunde (Lieferzustand)</h1>
+	  <table>
+	  		 <tr>
+			 <td>
+			 </td>
+			 </tr>
+			 <tr>
+			 	 <td class="dummy">
+				 </td>
+			 	 <td>im Ofen
+				 </td>
+			 	 <td>fertig
+				 </td>
+			 	 <td>unterwegs
+				 </td>
+			 </tr>
+			 <?php
+			 if (is_array($KDBest))
+			 {
+			 	foreach($KDBest as $aktBest)
+			 	{
+			 		$aktZustand = $aktBest->getzustand();
+			 		$nr = $aktBest->getauftnr();
+			 		$tmpName = $aktBest->getpiz_name();
+			 		echo "<tr>";
+			 		echo "<td>$tmpName</td>";
+					if ($aktZustand == 'imOfen') {
+				 		echo "<td><input type=\"radio\" name=\"nr$nr\" CHECKED DISABLED></td>\n";
+				 		echo "<td><input type=\"radio\" name=\"nr$nr\" DISABLED></td>\n";
+				 		echo "<td><input type=\"radio\" name=\"nr$nr\" DISABLED></td>\n";
+				 	}
+				 	else if ($aktZustand == 'bestellt') { 
+			 	 		echo "<td><input type=\"radio\" name=\"nr$nr\" DISABLED></td>\n";
+			 	 		echo "<td><input type=\"radio\" name=\"nr$nr\" DISABLED></td>\n";
+			 	 		echo "<td><input type=\"radio\" name=\"nr$nr\" DISABLED></td>\n";
+			 	 	} else if ($aktZustand == 'fertig') {
+				 		echo "<td><input type=\"radio\" name=\"nr$nr\" DISABLED></td>\n";
+				 		echo "<td><input type=\"radio\" name=\"nr$nr\" CHECKED DISABLED></td>\n";
+				 		echo "<td><input type=\"radio\" name=\"nr$nr\" DISABLED></td>\n";
+				 	} else if ($aktZustand == 'unterwegs') {
+				 		echo "<td><input type=\"radio\" name=\"nr$nr\" DISABLED></td>\n";
+				 		echo "<td><input type=\"radio\" name=\"nr$nr\" DISABLED></td>\n";
+				 		echo "<td><input type=\"radio\" name=\"nr$nr\" CHECKED DISABLED></td>\n";
+				 	} else {
+				 		echo "<td><input type=\"radio\" name=\"nr$nr\" DISABLED></td>\n";
+			 	 		echo "<td><input type=\"radio\" name=\"nr$nr\" DISABLED></td>\n";
+			 	 		echo "<td><input type=\"radio\" name=\"nr$nr\" DISABLED></td>\n";
+			 	 	}
+					echo "</tr>";
+				}
+			 }
+			 ?>
+	  </table>
+</body>
+</html>
+\ No newline at end of file