forked from her0satr/mitra_siakad
/
dwo.mnu.php
102 lines (92 loc) · 3.47 KB
/
dwo.mnu.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
<?php
function GetUserModule(){
global $strCantQuery;
$_LevelID = (isset($_SESSION['_LevelID'])) ? $_SESSION['_LevelID'] : '';
$_LoginID = (isset($_SESSION['_LoginID'])) ? $_SESSION['_LoginID'] : '';
$_arr = array();
$strLevelID = '.'.$_LevelID.'.';
$_sql = "select mg.MdlGrpID as GM
from mdl m
left outer join mdlgrp mg on m.MdlGrpID=mg.MdlGrpID
where m.Web='Y' and LOCATE('$strLevelID', m.LevelID)>0 and m.NA='N'
group by mg.Urutan";
$_sqlx = "select mg.mdlgrp, m.Level
from usermodul um
right join modul m on um.ModulID=m.ModulID
where m.InMenu='Y' and um.UserID='$_LoginID' or LOCATE($_LevelID, m.Level) group by m.GroupModul";
$_res = mysql_query($_sql) or die("Gagal: $_sql<br>".mysql_error());
while ($w = mysql_fetch_array($_res)) {
$_arr[] = $w['GM'];
}
return $_arr;
}
function GetModule($gm) {
$_ggl = "<p>Gagal menginisialisasi menu</p><p>Failed to initialised menus</p>";
$_Login = $_SESSION['_Login'];
$_LevelID = $_SESSION['_LevelID'];
$_snm = session_name(); $_sid = session_id();
$_arr = array();
$strLevel = ".$_LevelID.";
// ambil default
$_qy1 = "select m.*
from mdl m
where LOCATE('$strLevel', m.LevelID)>0 and m.Web='Y' and m.MdlGrpID='$gm' and m.NA='N'
order by m.Nama";
$_qyx = "select md.*
from modul md
where LOCATE('$_LevelID', md.Level)>0
and md.InMenu='Y'
and md.web='Y'
and md.GroupModul='$gm'
order by md.Modul";
$_rs1 = mysql_query($_qy1) or die($_ggl . mysql_error());
//echo "<div class='navigation' id='main-nav'><ul class='nav'>";
//echo "<ul>";
while ($_w1 = mysql_fetch_array($_rs1)) {
//echo "<a href=\"?mnux=$_w1[Script]&mdlid=$_w1[MdlID]&$_snm=$_sid\">$_w1[Nama]</a>\n";
//echo "<li><a href=\"?mnux=$_w1[Script]&mdlid=$_w1[MdlID]&$_snm=$_sid\">$_w1[Nama]</a></li>";
}
//echo "</ul>";
//echo "</ul></div>";
}
function StartMenu($arrMdl) {
$_ggl = "<p>Gagal menginisialisasi menu</p><p>Failed to initialised menus</p>";
$_Login = $_SESSION['_Login'];
$_LevelID = $_SESSION['_LevelID'];
$_snm = session_name(); $_sid = session_id();
$_arr = array();
$strLevel = ".$_LevelID.";
echo " ";
foreach ($arrMdl as $menu) {
$namamenu = getaField("mdlgrp","MdlGrpID = '$menu' and NA",'N',"Nama");
$IDS = getaField("mdlgrp","MdlGrpID = '$menu' and NA",'N',"MdlGrpID");
echo "<li class='has-sub'><a href='#'><span>$namamenu</span></a>";
//echo "<li class='round'><a title=$menu rel=$menu><span>$namamenu</span></a></li>";
$_qy1 = "select m.*
from mdl m
where LOCATE('$strLevel', m.LevelID)>0 and m.Web='Y' and m.MdlGrpID='$IDS' and m.NA='N'
order by m.Nama";
$_qyx = "select md.*
from modul md
where LOCATE('$_LevelID', md.Level)>0
and md.InMenu='Y'
and md.web='Y'
and md.GroupModul='$IDS'
order by md.Modul";
$_rs1 = mysql_query($_qy1) or die($_ggl . mysql_error());
//echo "<div class='navigation' id='main-nav'><ul class='nav'>";
echo "<ul>";
while ($_w1 = mysql_fetch_array($_rs1)) {
echo "<li><a href=\"?mnux=$_w1[Script]&mdlid=$_w1[MdlID]&$_snm=$_sid\">$_w1[Nama]</a></li>";
}
echo "</ul>";
}
echo "";
//echo "<div class=\"ddcolortabsline\"></div>";
}
function RunMenu(){
echo "<script type=\"text/javascript\">";
echo "tabdropdown.init(\"colortab\", 'auto')";
echo "</script>";
}
?>