<?php
	$oh = db_query("SELECT * FROM ".$db_prefix."_menu_admin WHERE ordnung = '0' OR box = '0' ");
	if(mysqli_num_rows($oh) > 0){
		head("Links ohne Zuordnung");
		echo '
			<table class="table">
				<tr>
					<td>Name</td>
					<td>Link</td>
					<td>OZ</td>
					<td>Box</td>
					<td></td>
				</tr>';
		while($ohne = mysqli_fetch_array($oh)){
		echo'
			<form method="post" action="">
			<input type="hidden" name="id" value="'.$ohne['id'].'">
				<tr>
					<td><input type="text" class="form-control" name="name" value="'.$ohne['name'].'"></td>
					<td>
						<div class="input-group">
							<div class="input-group-addon">content/</div>
							<input type="text" name="link" class="form-control" id="beispielFeldSumme" placeholder="Link zur Datei">
							<div class="input-group-addon">.php</div>
						</div>
					</td>
					<td><input type="text" class="form-control" name="ordnung" size="3" value="'.$ohne['ordnung'].'"></td>
					<td>
						<select class="form-control" name="box">';
						$bo = db_query("SELECT * FROM ".$db_prefix."_box_admin");
						while($boxen = mysqli_fetch_array($bo)){
							echo '<option value="'.$boxen['id'].'">'.$boxen['name'].'</option>';
						}
						echo '</select>
					</td>
					<td><input type="submit" class="btn btn-success" name="admin_link_zuordnen_neu" value="Bearbeiten">&nbsp;&nbsp;<input type="submit" class="btn btn-danger" name="admin_link_zuordnen_loschen" value="L&ouml;schen"></td>
				</tr>
			</form>';
		}
		echo '</table>';
		foot();
	}
	
	head("Neuen Link eintragen");
		echo '
				<form method="post" action="">
					<table class="table">
						<tr>
							<td>Pfad zur Datei</td>
							<td>
								<div class="input-group">
									<div class="input-group-addon">content/</div>
									<input type="text" name="link" class="form-control" id="beispielFeldSumme" placeholder="Link zur Datei">
									<div class="input-group-addon">.php</div>
								</div>
							</td>
						</tr>
						<tr>
							<td>Name des Links (F&uuml;r User sichtbar)</td>
							<td><input type="text" class="form-control" name="name"></td>
						</tr>
						<tr>
							<td>Box in der der Link stehen soll</td>
							<td>
								<select class="form-control" name="box">';
									$bo = db_query("SELECT * FROM ".$db_prefix."_box_admin");
									while($boxen = mysqli_fetch_array($bo)){
										echo '<option value="'.$boxen['id'].'">'.$boxen['name'].'</option>';
									}
							echo '</select>
							</td>
						</tr>
						<tr>
							<td>Ordnungszahl f&uuml;r Box</td>
							<td><input type="text" class="form-control" name="ordnung"></td>
						</tr>
						<tr>
							<td></td>
							<td><input type="submit" class="btn btn-default" name="admin_menue_neu_save"></td>
						</tr>
					</table>
				</form>';
	foot();
	
	head("&Uuml;bersicht Men&uuml;s");
		$bo = db_query("SELECT * FROM ".$db_prefix."_box_admin");
		while($boxen = mysqli_fetch_array($bo)){
			echo '<u><b>'.$boxen['name'].'</u></b>
					<table class="table">
						<tr>
							<td>Name</td>
							<td>Link</td>
							<td>OZ</td>
							<td>Box</td>
							<td></td>
						</tr>';
				$me = db_query("SELECT * FROM ".$db_prefix."_menu_admin WHERE box = '".$boxen['id']."' ");
				while($menu = mysqli_fetch_array($me)){
					echo'
						<form method="post" action="">
						<input type="hidden" name="id" value="'.$menu['id'].'">
							<tr>
								<td><input type="text" name="name" value="'.$menu['name'].'"></td>
								<td><input type="text" name="link" value="'.$menu['link'].'"></td>
								<td><input type="text" name="ordnung" size="3" value="'.$menu['ordnung'].'"></td>
								<td>
									<select name="box">';
										$mebo = db_query("SELECT * FROM ".$db_prefix."_box_admin");
										while($meboxen = mysqli_fetch_array($mebo)){
											echo '<option value="'.$meboxen['id'].'" '; if($menu['box'] == $meboxen['id']) {echo'SELECTED';} echo '>'.$meboxen['name'].'</option>';
										}
								echo '</select>
								</td>
								<td><button type="submit" name="admin_link_bearbeiten" class="btn btn-success glyphicon glyphicon-ok-circle"></button>&nbsp;&nbsp;<button type="submit" name="admin_link_loschen" class="btn btn-danger glyphicon glyphicon-remove-circle"></button></td>
							</tr>
						</form>';
				}
			echo '</table>';
		}
	foot();