comparison: www/includes/global.inc.php
www/includes/global.inc.php
- changeset 50
- 6d94167c2697
- parent 48
- bdd1ec9b9c06
- child 51
- 7224109adfe1
equal
deleted
inserted
replaced
| 49:4d27a7fb1265 | 50:6d94167c2697 |
|---|---|
| 49 </script> | 49 </script> |
| 50 <script src="js/jquery-1.11.1.min.js"></script> | 50 <script src="js/jquery-1.11.1.min.js"></script> |
| 51 <script src="jqwidgets/jqxcore.js"></script> | 51 <script src="jqwidgets/jqxcore.js"></script> |
| 52 <script src="jqwidgets/jqxwindow.js"></script> | 52 <script src="jqwidgets/jqxwindow.js"></script> |
| 53 <script src="jqwidgets/jqxmenu.js"></script> | 53 <script src="jqwidgets/jqxmenu.js"></script> |
| 54 <script src="jqwidgets/jqxtabs.js"></script> | |
| 54 <script src="jqwidgets/jqxdata.js"></script> | 55 <script src="jqwidgets/jqxdata.js"></script> |
| 55 <script src="jqwidgets/jqxdata.export.js"></script> | 56 <script src="jqwidgets/jqxdata.export.js"></script> |
| 56 <script src="jqwidgets/jqxbuttons.js"></script> | 57 <script src="jqwidgets/jqxbuttons.js"></script> |
| 57 <script src="jqwidgets/jqxscrollbar.js"></script> | 58 <script src="jqwidgets/jqxscrollbar.js"></script> |
| 58 <script src="jqwidgets/jqxgrid.js"></script> | 59 <script src="jqwidgets/jqxgrid.js"></script> |
| 60 <script src="jqwidgets/jqxgrid.grouping.js"></script> | |
| 59 <script src="jqwidgets/jqxgrid.edit.js"></script> | 61 <script src="jqwidgets/jqxgrid.edit.js"></script> |
| 60 <script src="jqwidgets/jqxgrid.sort.js"></script> | 62 <script src="jqwidgets/jqxgrid.sort.js"></script> |
| 61 <script src="jqwidgets/jqxgrid.pager.js"></script> | 63 <script src="jqwidgets/jqxgrid.pager.js"></script> |
| 62 <script src="jqwidgets/jqxgrid.filter.js"></script> | 64 <script src="jqwidgets/jqxgrid.filter.js"></script> |
| 63 <script src="jqwidgets/jqxgrid.selection.js"></script> | 65 <script src="jqwidgets/jqxgrid.selection.js"></script> |
| 117 </li> | 119 </li> |
| 118 <li>Productie | 120 <li>Productie |
| 119 </li> | 121 </li> |
| 120 <li>Recepten | 122 <li>Recepten |
| 121 <ul> | 123 <ul> |
| 122 <?php | 124 <li><a href="recipes.php">Recepten</a></li> |
| 123 $result = mysqli_query($connect, "SELECT DISTINCT style_guide FROM recipes ORDER BY style_guide"); | 125 <li>Import</li> |
| 124 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | |
| 125 $guide = $row['style_guide']; | |
| 126 echo ' <li>' . $guide . PHP_EOL; | |
| 127 echo ' <ul>'.PHP_EOL; | |
| 128 $result2 = mysqli_query($connect, "SELECT DISTINCT style_letter FROM recipes WHERE style_guide='".$guide."' ORDER BY style_letter"); | |
| 129 while($row2 = mysqli_fetch_array($result2, MYSQLI_ASSOC)) { | |
| 130 $letter = $row2['style_letter']; | |
| 131 echo ' <li>' . $letter . PHP_EOL; | |
| 132 echo ' <ul>'.PHP_EOL; | |
| 133 $result3 = mysqli_query($connect, "SELECT DISTINCT style_name FROM recipes WHERE style_guide='".$guide."' and style_letter='".$letter."' ORDER BY style_name"); | |
| 134 while ($row3 = mysqli_fetch_array($result3, MYSQLI_ASSOC)) { | |
| 135 $name = $row3['style_name']; | |
| 136 echo ' <li>' . $name . PHP_EOL; | |
| 137 echo ' <ul>'.PHP_EOL; | |
| 138 $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"); | |
| 139 while ($row4 = mysqli_fetch_array($result4, MYSQLI_ASSOC)) { | |
| 140 echo ' <li><a href="recipe.php?record='.$row4['record'].'">' . $row4['name'] . '</a></li>' . PHP_EOL; | |
| 141 } | |
| 142 mysqli_free_result($result4); | |
| 143 echo ' </ul>'.PHP_EOL; | |
| 144 echo ' </li>' . PHP_EOL; | |
| 145 } | |
| 146 mysqli_free_result($result3); | |
| 147 echo ' </ul>'.PHP_EOL; | |
| 148 echo ' </li>'.PHP_EOL; | |
| 149 } | |
| 150 mysqli_free_result($result2); | |
| 151 echo ' </ul>'.PHP_EOL; | |
| 152 echo ' </li>'.PHP_EOL; | |
| 153 } | |
| 154 mysqli_free_result($result); | |
| 155 ?> | |
| 156 <li>Nieuw</li> | |
| 157 </ul> | 126 </ul> |
| 158 </li> | 127 </li> |
| 159 <li>Inventaris | 128 <li>Inventaris |
| 160 <ul> | 129 <ul> |
| 161 <li><a href="inv_suppliers.php">Leveranciers</a></li> | 130 <li><a href="inv_suppliers.php">Leveranciers</a></li> |
