OpenSencillo  2016.106
Long live the simplicity of PHP
 All Data Structures Namespaces Files Functions Pages
menu.generator.menugen.php
1 <?php
12 class menuGen
13 {
14  protected $mysqlObject;
15  protected $href;
16  protected $name;
17  protected $protocol;
18  protected $page;
19  protected $language;
20  protected $perm;
21  protected $maxLevelQuery;
22 
23  public $maxLevel = array();
24 
25  public function __construct($mysqlObject,$protocol,$page,$language,$perm)
26  {
27  $this->mysqlObject = $mysqlObject;
28  $this->protocol = $protocol;
29  $this->page = $page;
30  $this->language = $language;
31  $this->perm = $perm;
32 
33  $this->maxLevelQuery = $this->mysqlObject->query("SELECT MAX(`level_id`) AS maxlevel FROM `categories` LIMIT 1");
34 
35  while($data = mysql_fetch_assoc($this->maxLevelQuery)){
36  $this->maxLevel[] = $data;
37  }
38  }
39 
53  public function addItemToMenu($cBase,$cSubBase,$priority,$perm,$lang,$cName,$cHref,$cTitle,$cImage,$cImageAlt)
54  {
55  $name = $this->name;
56  $this->mysqlObject->dbCreateTable(array(
57  $name=>array(
58  'id'=>"''",
59  'category_id'=>$cBase,
60  'subcategory_id'=>$cSubBase,
61  'sort'=>$priority,
62  'perm'=>$perm,
63  'lang'=>$lang,
64  'category_name'=>"'$cName'",
65  'category_href'=>"'$cHref'",
66  'category_title'=>"'$cTitle'",
67  'category_img'=>"'$cImage'",
68  'category_img_alt'=>"'$cImageAlt'"
69  )
70  ));
71  $this->mysqlObject->execute();
72  }
73 
78  public function createMenu($name)
79  {
80  $this->name = $name;
81  $this->mysqlObject->dbCreateTable(array(
82  $name=>array(
83  'id'=>array('type'=>'int','auto_increment'=>true,'primary_key'=>true),
84  'category_id'=>array('type'=>'int'),
85  'subcategory_id'=>array('type'=>'int'),
86  'sort'=>array('type'=>'int'),
87  'perm'=>array('type'=>'int(4)'),
88  'lang'=>array('type'=>'int(4)'),
89  'category_name'=>array('type'=>'varchar(250)'),
90  'category_href'=>array('type'=>'varchar(250)'),
91  'category_title'=>array('type'=>'varchar(250)'),
92  'category_img'=>array('type'=>'varchar(250)'),
93  'category_img_alt'=>array('type'=>'varchar(250)')
94  )
95  ));
96  $this->mysqlObject->execute();
97  }
98 
103  public function switchMenu($name)
104  {
105  $this->name = $name;
106  }
107 
117  public function generateMenu($subcategory, $level)
118  {
119  $db = $this->name;
120  $query = $this->mysqlObject->query("SELECT menu.category_id, menu.category_name, menu.category_href, menu.sort, menu.lang, menu.perm, Deriv1.count FROM " . "`" .$db. "`" . " menu LEFT OUTER JOIN (SELECT subcategory_id, COUNT(*) AS count FROM ". "`" .$db. "`". " GROUP BY subcategory_id) Deriv1 ON menu.category_id = Deriv1.subcategory_id WHERE menu.subcategory_id=".$subcategory." AND menu.lang=".$this->language." AND menu.perm=".$this->perm." ORDER BY menu.sort ASC");
121  $arr[] = "<ul class='menu-ul-level-".$level."'>";
122  while($data = mysql_fetch_assoc($query))
123  {
124  $this->href = $this->protocol.'://'.$_SERVER['SERVER_NAME']."/".$data['category_href'];
125  //if there are subcategories
126  if($data['count'] > 0)
127  {
128  $arr[] = "<li class='menu-li-level-".$level."'><a class='menu-a-level-".$level."' href='".$this->href."'>".$data['category_name']."</a>";
129  $arr[] = $this->generateMenu($data['category_id'], $level + 1);
130  $arr[] = "</li>";
131  //no subcategories
132  }
133  elseif($data['count'] == 0)
134  {
135  $arr[] = "<li class='menu-li-level-".$level."'><a class='menu-a-level-".$level."' href='".$this->href."'>".$data['category_name']."</a></li>";
136  }
137  }
138  $arr[] = "</ul>";
139  return implode("\n", $arr);
140  }
141 
153  public function generateMenuLevel($level, $limit, $page){
154  $db = $this->name;
155 
156  $page = explode('/', $page);
157 
158  //level 1 menu
159  if($level == 1){
160  $level_1_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `level_id` = 1 ORDER BY sort");
161 
162  $arr[] = "<ul>";
163  while ($data = mysql_fetch_assoc($level_1_query)){
164  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$data['category_href']."/".$limit.">".$data['category_name']."</a></li>";
165  }
166  $arr[] = "</ul>";
167 
168  return implode("\n", $arr);
169  }
170 
171  //level 1-2 menu
172  if($level == 2){
173  $level_1_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `level_id` = 1 ORDER BY sort");
174 
175  $arr[] = "<ul>";
176  while ($level_1 = mysql_fetch_assoc($level_1_query)){
177  $level_2_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_1['category_id']." ORDER BY sort");
178 
179  //level 1 page selected
180  if($level_1['category_href'] == $page[1]){
181  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_1['category_href']."/".$limit."><b>".$level_1['category_name']."</b></a>";
182 
183  while ($level_2 = mysql_fetch_assoc($level_2_query)){
184  $arr[] = "<ul>";
185  //level 1 page selected has subcategories
186  if($level_2['category_href'].substr($page[1])){
187 
188  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_2['category_href']."/".$limit.">".$level_2['category_name']."</a></li>";
189  }
190  $arr[] = "</ul>";
191  }
192  } else {
193  //level 1 page not selected
194  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_1['category_href']."/".$limit.">".$level_1['category_name']."</a></li>";
195  }
196  }
197  $arr[] = "</ul>";
198 
199  return implode("\n", $arr);
200  }
201 
202  //level 1-3 menu
203  if($level == 3){
204  $level_1_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `level_id` = 1 ORDER BY sort");
205 
206  $arr[] = "<ul>";
207  while ($level_1 = mysql_fetch_assoc($level_1_query)){
208  $level_2_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_1['category_id']." ORDER BY sort");
209 
210  //level 1 page selected
211  if($level_1['category_href'] == $page[1]){
212  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_1['category_href']."/".$limit."><b>".$level_1['category_name']."</b></a>";
213 
214  while ($level_2 = mysql_fetch_assoc($level_2_query)){
215  $arr[] = "<ul>";
216  //level 1 page selected has subcategories
217  if($level_2['category_href'].substr($page[1])){
218  $level_3_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_2['category_id']." ORDER BY sort");
219 
220  //level 2 page selected
221  if($level_2['category_href'] == $page[1]."/".$page[2]){
222  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_2['category_href']."/".$limit."><b>".$level_2['category_name']."</b></a>";
223 
224  while ($level_3 = mysql_fetch_assoc($level_3_query)){
225 
226  $arr[] = "<ul>";
227  //level 2 page selected has subcategories
228  if($level_3['category_href'].substr($page[1]."/".$page[2])){
229  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_3['category_href']."/".$limit.">".$level_3['category_name']."</a></li>";
230  }
231  $arr[] = "</ul>";
232  }
233  } else {
234  //level 2 page not selected
235  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_2['category_href']."/".$limit.">".$level_2['category_name']."</a></li>";
236  }
237  }
238  $arr[] = "</ul>";
239  }
240  } else {
241  //level 1 page not selected
242  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_1['category_href']."/".$limit.">".$level_1['category_name']."</a></li>";
243  }
244  }
245  $arr[] = "</ul>";
246 
247  return implode("\n", $arr);
248  }
249 
250  //level 1-4 menu
251  if($level == 4){
252  $level_1_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `level_id` = 1 ORDER BY sort");
253 
254  $arr[] = "<ul>";
255  while ($level_1 = mysql_fetch_assoc($level_1_query)){
256  $level_2_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_1['category_id']." ORDER BY sort");
257 
258  //level 1 page selected
259  if($level_1['category_href'] == $page[1]){
260  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_1['category_href']."/".$limit."><b>".$level_1['category_name']."</b></a>";
261 
262  while ($level_2 = mysql_fetch_assoc($level_2_query)){
263  $arr[] = "<ul>";
264  //level 1 page selected has subcategories
265  if($level_2['category_href'].substr($page[1])){
266  $level_3_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_2['category_id']." ORDER BY sort");
267 
268  //level 2 page selected
269  if($level_2['category_href'] == $page[1]."/".$page[2]){
270  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_2['category_href']."/".$limit."><b>".$level_2['category_name']."</b></a>";
271 
272  while ($level_3 = mysql_fetch_assoc($level_3_query)){
273 
274  $arr[] = "<ul>";
275  //level 2 page selected has subcategories
276  if($level_3['category_href'].substr($page[1]."/".$page[2])){
277  $level_4_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_3['category_id']." ORDER BY sort");
278 
279  //level 3 page selected
280  if($level_3['category_href'] == $page[1]."/".$page[2]."/".$page[3]){
281  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_3['category_href']."/".$limit."><b>".$level_3['category_name']."</b></a>";
282 
283  while ($level_4 = mysql_fetch_assoc($level_4_query)){
284 
285  $arr[] = "<ul>";
286  //level 3 page selected has subcategories
287  if($level_4['category_href'].substr($page[1]."/".$page[2]."/".$page[3])){
288  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_4['category_href']."/".$limit.">".$level_4['category_name']."</a></li>";
289  }
290  $arr[] = "</ul>";
291  }
292  } else {
293  //level 3 page not selected
294  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_3['category_href']."/".$limit.">".$level_3['category_name']."</a></li>";
295  }
296  }
297  $arr[] = "</ul>";
298  }
299  } else {
300  //level 2 page not selected
301  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_2['category_href']."/".$limit.">".$level_2['category_name']."</a></li>";
302  }
303  }
304  $arr[] = "</ul>";
305  }
306  } else {
307  //level 1 page not selected
308  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_1['category_href']."/".$limit.">".$level_1['category_name']."</a></li>";
309  }
310  }
311  $arr[] = "</ul>";
312 
313  return implode("\n", $arr);
314  }
315 
316  //level 1-5 menu
317  if($level == 5){
318  $level_1_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `level_id` = 1 ORDER BY sort");
319 
320  $arr[] = "<ul>";
321  while ($level_1 = mysql_fetch_assoc($level_1_query)){
322  $level_2_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_1['category_id']." ORDER BY sort");
323 
324  //level 1 page selected
325  if($level_1['category_href'] == $page[1]){
326  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_1['category_href']."/".$limit."><b>".$level_1['category_name']."</b></a>";
327 
328  while ($level_2 = mysql_fetch_assoc($level_2_query)){
329  $arr[] = "<ul>";
330  //level 1 page selected has subcategories
331  if($level_2['category_href'].substr($page[1])){
332  $level_3_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_2['category_id']." ORDER BY sort");
333 
334  //level 2 page selected
335  if($level_2['category_href'] == $page[1]."/".$page[2]){
336  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_2['category_href']."/".$limit."><b>".$level_2['category_name']."</b></a>";
337 
338  while ($level_3 = mysql_fetch_assoc($level_3_query)){
339 
340  $arr[] = "<ul>";
341  //level 2 page selected has subcategories
342  if($level_3['category_href'].substr($page[1]."/".$page[2])){
343  $level_4_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_3['category_id']." ORDER BY sort");
344 
345  //level 3 page selected
346  if($level_3['category_href'] == $page[1]."/".$page[2]."/".$page[3]){
347  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_3['category_href']."/".$limit."><b>".$level_3['category_name']."</b></a>";
348 
349  while ($level_4 = mysql_fetch_assoc($level_4_query)){
350 
351  $arr[] = "<ul>";
352  //level 3 page selected has subcategories
353  if($level_4['category_href'].substr($page[1]."/".$page[2]."/".$page[3])){
354  $level_5_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_4['category_id']." ORDER BY sort");
355 
356  //level 4 page selected
357  if($level_4['category_href'] == $page[1]."/".$page[2]."/".$page[3]."/".$page[4]){
358  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_4['category_href']."/".$limit."><b>".$level_4['category_name']."</b></a>";
359 
360  while ($level_5 = mysql_fetch_assoc($level_5_query)){
361 
362  $arr[] = "<ul>";
363  //level 4 page selected has subcategories
364  if($level_5['category_href'].substr($page[1]."/".$page[2]."/".$page[3]."/".$page[4])){
365  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_5['category_href']."/".$limit.">".$level_5['category_name']."</a></li>";
366  }
367  $arr[] = "</ul>";
368  }
369  } else {
370  //level 4 page not selected
371  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_4['category_href']."/".$limit.">".$level_4['category_name']."</a></li>";
372  }
373  }
374  $arr[] = "</ul>";
375  }
376  } else {
377  //level 3 page not selected
378  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_3['category_href']."/".$limit.">".$level_3['category_name']."</a></li>";
379  }
380  }
381  $arr[] = "</ul>";
382  }
383  } else {
384  //level 2 page not selected
385  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_2['category_href']."/".$limit.">".$level_2['category_name']."</a></li>";
386  }
387  }
388  $arr[] = "</ul>";
389  }
390  } else {
391  //level 1 page not selected
392  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_1['category_href']."/".$limit.">".$level_1['category_name']."</a></li>";
393  }
394  }
395  $arr[] = "</ul>";
396 
397  return implode("\n", $arr);
398  }
399 
400  //level 1-6 menu
401  if($level == 6){
402  $level_1_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `level_id` = 1 ORDER BY sort");
403 
404  $arr[] = "<ul>";
405  while ($level_1 = mysql_fetch_assoc($level_1_query)){
406  $level_2_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_1['category_id']." ORDER BY sort");
407 
408  //level 1 page selected
409  if($level_1['category_href'] == $page[1]){
410  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_1['category_href']."/".$limit."><b>".$level_1['category_name']."</b></a>";
411 
412  while ($level_2 = mysql_fetch_assoc($level_2_query)){
413  $arr[] = "<ul>";
414  //level 1 page selected has subcategories
415  if($level_2['category_href'].substr($page[1])){
416  $level_3_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_2['category_id']." ORDER BY sort");
417 
418  //level 2 page selected
419  if($level_2['category_href'] == $page[1]."/".$page[2]){
420  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_2['category_href']."/".$limit."><b>".$level_2['category_name']."</b></a>";
421 
422  while ($level_3 = mysql_fetch_assoc($level_3_query)){
423 
424  $arr[] = "<ul>";
425  //level 2 page selected has subcategories
426  if($level_3['category_href'].substr($page[1]."/".$page[2])){
427  $level_4_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_3['category_id']." ORDER BY sort");
428 
429  //level 3 page selected
430  if($level_3['category_href'] == $page[1]."/".$page[2]."/".$page[3]){
431  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_3['category_href']."/".$limit."><b>".$level_3['category_name']."</b></a>";
432 
433  while ($level_4 = mysql_fetch_assoc($level_4_query)){
434 
435  $arr[] = "<ul>";
436  //level 3 page selected has subcategories
437  if($level_4['category_href'].substr($page[1]."/".$page[2]."/".$page[3])){
438  $level_5_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_4['category_id']." ORDER BY sort");
439 
440  //level 4 page selected
441  if($level_4['category_href'] == $page[1]."/".$page[2]."/".$page[3]."/".$page[4]){
442  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_4['category_href']."/".$limit."><b>".$level_4['category_name']."</b></a>";
443 
444  while ($level_5 = mysql_fetch_assoc($level_5_query)){
445 
446  $arr[] = "<ul>";
447  //level 4 page selected has subcategories
448  if($level_5['category_href'].substr($page[1]."/".$page[2]."/".$page[3]."/".$page[4])){
449  $level_6_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_5['category_id']." ORDER BY sort");
450 
451  //level 5 page selected
452  if($level_5['category_href'] == $page[1]."/".$page[2]."/".$page[3]."/".$page[4]."/".$page[5]){
453  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_5['category_href']."/".$limit."><b>".$level_5['category_name']."</b></a>";
454 
455  while ($level_6 = mysql_fetch_assoc($level_6_query)){
456 
457  $arr[] = "<ul>";
458  //level 5 page selected has subcategories
459  if($level_6['category_href'].substr($page[1]."/".$page[2]."/".$page[3]."/".$page[4]."/".$page[5])){
460  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_6['category_href']."/".$limit.">".$level_6['category_name']."</a></li>";
461  }
462  $arr[] = "</ul>";
463  }
464  } else {
465  //level 5 page not selected
466  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_5['category_href']."/".$limit.">".$level_5['category_name']."</a></li>";
467  }
468  }
469  $arr[] = "</ul>";
470  }
471  } else {
472  //level 4 page not selected
473  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_4['category_href']."/".$limit.">".$level_4['category_name']."</a></li>";
474  }
475  }
476  $arr[] = "</ul>";
477  }
478  } else {
479  //level 3 page not selected
480  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_3['category_href']."/".$limit.">".$level_3['category_name']."</a></li>";
481  }
482  }
483  $arr[] = "</ul>";
484  }
485  } else {
486  //level 2 page not selected
487  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_2['category_href']."/".$limit.">".$level_2['category_name']."</a></li>";
488  }
489  }
490  $arr[] = "</ul>";
491  }
492  } else {
493  //level 1 page not selected
494  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_1['category_href']."/".$limit.">".$level_1['category_name']."</a></li>";
495  }
496  }
497  $arr[] = "</ul>";
498 
499  return implode("\n", $arr);
500  }
501 
502  //level 1-7 menu
503  if($level == 7){
504  $level_1_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `level_id` = 1 ORDER BY sort");
505 
506  $arr[] = "<ul>";
507  while ($level_1 = mysql_fetch_assoc($level_1_query)){
508  $level_2_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_1['category_id']." ORDER BY sort");
509 
510  //level 1 page selected
511  if($level_1['category_href'] == $page[1]){
512  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_1['category_href']."/".$limit."><b>".$level_1['category_name']."</b></a>";
513 
514  while ($level_2 = mysql_fetch_assoc($level_2_query)){
515  $arr[] = "<ul>";
516  //level 1 page selected has subcategories
517  if($level_2['category_href'].substr($page[1])){
518  $level_3_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_2['category_id']." ORDER BY sort");
519 
520  //level 2 page selected
521  if($level_2['category_href'] == $page[1]."/".$page[2]){
522  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_2['category_href']."/".$limit."><b>".$level_2['category_name']."</b></a>";
523 
524  while ($level_3 = mysql_fetch_assoc($level_3_query)){
525 
526  $arr[] = "<ul>";
527  //level 2 page selected has subcategories
528  if($level_3['category_href'].substr($page[1]."/".$page[2])){
529  $level_4_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_3['category_id']." ORDER BY sort");
530 
531  //level 3 page selected
532  if($level_3['category_href'] == $page[1]."/".$page[2]."/".$page[3]){
533  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_3['category_href']."/".$limit."><b>".$level_3['category_name']."</b></a>";
534 
535  while ($level_4 = mysql_fetch_assoc($level_4_query)){
536 
537  $arr[] = "<ul>";
538  //level 3 page selected has subcategories
539  if($level_4['category_href'].substr($page[1]."/".$page[2]."/".$page[3])){
540  $level_5_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_4['category_id']." ORDER BY sort");
541 
542  //level 4 page selected
543  if($level_4['category_href'] == $page[1]."/".$page[2]."/".$page[3]."/".$page[4]){
544  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_4['category_href']."/".$limit."><b>".$level_4['category_name']."</b></a>";
545 
546  while ($level_5 = mysql_fetch_assoc($level_5_query)){
547 
548  $arr[] = "<ul>";
549  //level 4 page selected has subcategories
550  if($level_5['category_href'].substr($page[1]."/".$page[2]."/".$page[3]."/".$page[4])){
551  $level_6_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_5['category_id']." ORDER BY sort");
552 
553  //level 5 page selected
554  if($level_5['category_href'] == $page[1]."/".$page[2]."/".$page[3]."/".$page[4]."/".$page[5]){
555  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_5['category_href']."/".$limit."><b>".$level_5['category_name']."</b></a>";
556 
557  while ($level_6 = mysql_fetch_assoc($level_6_query)){
558 
559  $arr[] = "<ul>";
560  //level 5 page selected has subcategories
561  if($level_6['category_href'].substr($page[1]."/".$page[2]."/".$page[3]."/".$page[4]."/".$page[5])){
562  $level_7_query = $this->mysqlObject->query("SELECT * FROM "."`".$db."`"." WHERE `subcategory_id` = ".$level_6['category_id']." ORDER BY sort");
563 
564  //level 6 page selected
565  if($level_6['category_href'] == $page[1]."/".$page[2]."/".$page[3]."/".$page[4]."/".$page[5]."/".$page[6]){
566  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_6['category_href']."/".$limit."><b>".$level_6['category_name']."</b></a>";
567 
568  while ($level_7 = mysql_fetch_assoc($level_7_query)){
569 
570  $arr[] = "<ul>";
571  //level 6 page selected has subcategories
572  if($level_7['category_href'].substr($page[1]."/".$page[2]."/".$page[3]."/".$page[4]."/".$page[5]."/".$page[6])){
573  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_7['category_href']."/".$limit.">".$level_7['category_name']."</a></li>";
574  }
575  $arr[] = "</ul>";
576  }
577  } else {
578  //level 6 page not selected
579  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_6['category_href']."/".$limit.">".$level_6['category_name']."</a></li>";
580  }
581  }
582  $arr[] = "</ul>";
583  }
584  } else {
585  //level 5 page not selected
586  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_5['category_href']."/".$limit.">".$level_5['category_name']."</a></li>";
587  }
588  }
589  $arr[] = "</ul>";
590  }
591  } else {
592  //level 4 page not selected
593  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_4['category_href']."/".$limit.">".$level_4['category_name']."</a></li>";
594  }
595  }
596  $arr[] = "</ul>";
597  }
598  } else {
599  //level 3 page not selected
600  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_3['category_href']."/".$limit.">".$level_3['category_name']."</a></li>";
601  }
602  }
603  $arr[] = "</ul>";
604  }
605  } else {
606  //level 2 page not selected
607  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_2['category_href']."/".$limit.">".$level_2['category_name']."</a></li>";
608  }
609  }
610  $arr[] = "</ul>";
611  }
612  } else {
613  //level 1 page not selected
614  $arr[] = "<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".'http://'.$_SERVER['SERVER_NAME']."/produkty/".$level_1['category_href']."/".$limit.">".$level_1['category_name']."</a></li>";
615  }
616  }
617  $arr[] = "</ul>";
618 
619  return implode("\n", $arr);
620  }
621 
622  }
623 
624 
631  public function generateMenuAllLevels($page){
632 
633  $page = explode('/', PAGE);
634 
635  switch($page){
636  //menu level 2
637  case 'produkty/'.$page[1].'/'.$page[2]:
638  echo $this->generateMenuLevel("categories", 2, "0-10", PAGE);
639  break;
640 
641  //menu level 3
642  case 'produkty/'.$page[1].'/'.$page[2].'/'.$page[3]:
643  echo $this->generateMenuLevel("categories", 3, "0-10", PAGE);
644  break;
645 
646  //menu level 4
647  case 'produkty/'.$page[1].'/'.$page[2].'/'.$page[3].'/'.$page[4]:
648  echo $this->generateMenuLevel("categories", 4, "0-10", PAGE);
649  break;
650 
651  //menu level 5
652  case 'produkty/'.$page[1].'/'.$page[2].'/'.$page[3].'/'.$page[4].'/'.$page[5]:
653  echo $this->generateMenuLevel("categories", 5, "0-10", PAGE);
654  break;
655 
656  //menu level 6
657  case 'produkty/'.$page[1].'/'.$page[2].'/'.$page[3].'/'.$page[4].'/'.$page[5].'/'.$page[6]:
658  echo $menuGen->generateMenuLevel("categories", 6, "0-10", PAGE);
659  break;
660 
661  //menu level 7
662  case 'produkty/'.$page[1].'/'.$page[2].'/'.$page[3].'/'.$page[4].'/'.$page[5].'/'.$page[6].'/'.$page[7]:
663  echo $menuGen->generateMenuLevel("categories", 7, "0-10", PAGE);
664  break;
665 
666  //menu level 1
667  default: echo $this->generateMenuLevel("categories", 1, "0-10", PAGE);
668  }
669  }
670 }
671 ?>