Mercurial > bms / file diff

--- a/www/includes/global.inc.php	Fri Aug 31 15:18:20 2018 +0200
+++ b/www/includes/global.inc.php	Sat Sep 01 22:24:09 2018 +0200
@@ -51,11 +51,13 @@
   <script src="jqwidgets/jqxcore.js"></script>
   <script src="jqwidgets/jqxwindow.js"></script>
   <script src="jqwidgets/jqxmenu.js"></script>
+  <script src="jqwidgets/jqxtabs.js"></script>
   <script src="jqwidgets/jqxdata.js"></script>
   <script src="jqwidgets/jqxdata.export.js"></script>
   <script src="jqwidgets/jqxbuttons.js"></script>
   <script src="jqwidgets/jqxscrollbar.js"></script>
   <script src="jqwidgets/jqxgrid.js"></script>
+  <script src="jqwidgets/jqxgrid.grouping.js"></script>
   <script src="jqwidgets/jqxgrid.edit.js"></script>
   <script src="jqwidgets/jqxgrid.sort.js"></script>
   <script src="jqwidgets/jqxgrid.pager.js"></script>
@@ -119,41 +121,8 @@
      </li>
      <li>Recepten
       <ul>
-<?php
-$result = mysqli_query($connect, "SELECT DISTINCT style_guide FROM recipes ORDER BY style_guide");
-while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
-    $guide = $row['style_guide'];
-    echo '       <li>' . $guide . PHP_EOL;
-    echo '        <ul>'.PHP_EOL;
-    $result2 = mysqli_query($connect, "SELECT DISTINCT style_letter FROM recipes WHERE style_guide='".$guide."' ORDER BY style_letter");
-    while($row2 = mysqli_fetch_array($result2, MYSQLI_ASSOC)) {
-	$letter = $row2['style_letter'];
-	echo '         <li>' . $letter . PHP_EOL;
-        echo '          <ul>'.PHP_EOL;
-	$result3 = mysqli_query($connect, "SELECT DISTINCT style_name FROM recipes WHERE style_guide='".$guide."' and style_letter='".$letter."' ORDER BY style_name");
-	while ($row3 =  mysqli_fetch_array($result3, MYSQLI_ASSOC)) {
-	    $name = $row3['style_name'];
-	    echo '           <li>' . $name . PHP_EOL;
-	    echo '            <ul>'.PHP_EOL;
-	    $result4 = mysqli_query($connect, "SELECT DISTINCT record,name FROM recipes WHERE style_guide='".$guide."' and style_letter='".$letter."' and style_name='".$name."'ORDER BY name");
-	    while ($row4 =  mysqli_fetch_array($result4, MYSQLI_ASSOC)) {
-		echo '             <li><a href="recipe.php?record='.$row4['record'].'">' . $row4['name'] . '</a></li>' . PHP_EOL;
-	    }
-	    mysqli_free_result($result4);
-	    echo '            </ul>'.PHP_EOL;
-	    echo '           </li>' . PHP_EOL;
-	}
-	mysqli_free_result($result3);
-	echo '          </ul>'.PHP_EOL;
-	echo '         </li>'.PHP_EOL;
-    }
-    mysqli_free_result($result2);
-    echo '        </ul>'.PHP_EOL;
-    echo '       </li>'.PHP_EOL;
-}
-mysqli_free_result($result);
-?>
-       <li>Nieuw</li>
+       <li><a href="recipes.php">Recepten</a></li>
+       <li>Import</li>
       </ul>
      </li>
      <li>Inventaris