X-Git-Url: https://git.infodrom.org/?p=misc%2Fkostenrechnung;a=blobdiff_plain;f=lib%2Fmenu.php;h=d9ddca913c6a91a49e7d668a6a5fb3449e071935;hp=60701d8006854c133d7d6c47539c19fcd9d27f74;hb=b1213d882cf9905af8301c3c409c487bd317505c;hpb=6ea10b78194f73099e998f10ed255077a8fad597
diff --git a/lib/menu.php b/lib/menu.php
index 60701d8..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['fname'], $row['menutitle']);
+ $ret .= sprintf('- %s
', $row['fname'],
+ empty($row['title']) ? '' : ' title="'.$row['title'].'"',
+ $row['menutitle']);
}
$ret .= '
';
$ret .= '';