X-Git-Url: https://git.infodrom.org/?p=misc%2Fkostenrechnung;a=blobdiff_plain;f=lib%2Fmenu.php;h=d9ddca913c6a91a49e7d668a6a5fb3449e071935;hp=8bb5d605defcd9ef55cb88e7e47706fae8760b2f;hb=deaf08b6e3fc5c35d139b83db7f4951f4685eb30;hpb=ac616a398c89bd2abce24de81ab4e6dd032eaee3
diff --git a/lib/menu.php b/lib/menu.php
index 8bb5d60..d9ddca9 100644
--- a/lib/menu.php
+++ b/lib/menu.php
@@ -13,8 +13,10 @@ function menu()
$ret .= '
Start';
$ret .= 'Logout';
- $sql = "SELECT fname,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 .= '';
$menu = $row['name'];
}
- $ret .= sprintf('- %s
', $row['mask'], $row['menutitle']);
+ $ret .= sprintf('- %s
', $row['fname'],
+ empty($row['title']) ? '' : ' title="'.$row['title'].'"',
+ $row['menutitle']);
}
$ret .= '
';
$ret .= '';