projects
/
misc
/
kostenrechnung
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Limit menu items to permitted ones according to group
[misc/kostenrechnung]
/
lib
/
menu.php
diff --git
a/lib/menu.php
b/lib/menu.php
index
60701d8
..
e20b4d0
100644
(file)
--- a/
lib/menu.php
+++ b/
lib/menu.php
@@
-15,6
+15,8
@@
function menu()
$sql = "SELECT fname,menutitle,name FROM sys_mask "
. "JOIN sys_menu ON sys_mask.menu = sys_menu.id "
$sql = "SELECT fname,menutitle,name 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);
. "ORDER BY sys_menu.priority,sys_menu.name,sys_mask.priority,sys_mask.menutitle";
$sth = pg_query($sql);