Add cleaned flag

[misc/kostenrechnung] / lib / menu.php

diff --git a/lib/menu.php b/lib/menu.php
index 030633b..d9ddca9 100644 (file)
--- a/lib/menu.php
+++ b/lib/menu.php
@@ -13,8 +13,10 @@ function menu()
   $ret .= '<li><a href="./" title="Zurück zur Hauptseite">Start</a></li>';
   $ret .= '<li><a href="./?logout=true" title="Abmelden">Logout</a></li>';
 
-  $sql = "SELECT mask,menutitle,name FROM sys_mask "
+  $sql = "SELECT fname,menutitle,sys_menu.name,title FROM sys_mask "
     . "JOIN sys_menu ON sys_mask.menu = sys_menu.id "
+    . "JOIN sys_group_mask ON sys_mask.id = sys_group_mask.mask "
+    . "WHERE sys_group_mask.gid = ".$_SESSION['sys']['group']." "
     . "ORDER BY sys_menu.priority,sys_menu.name,sys_mask.priority,sys_mask.menutitle";
   $sth = pg_query($sql);
 
@@ -28,7 +30,9 @@ function menu()
        $ret .= '<ul>';
        $menu = $row['name'];
       }
-      $ret .= sprintf('<li><a href="./?mask=%s">%s</a></li>', $row['mask'], $row['menutitle']);
+      $ret .= sprintf('<li><a href="./?mask=%s"%s>%s</a></li>', $row['fname'],
+                     empty($row['title']) ? '' : ' title="'.$row['title'].'"',
+                     $row['menutitle']);
     }
     $ret .= '</ul>';
     $ret .= '</li>';