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
103
104
105
106
107
108
109
110
111
|
<?php
//------------------------------------------------------------------------------------------------------
$rowPerPage =200;
$thisFile=basename($PHP_SELF);
if((!$page)||($page==1)){
$page=1;
$startRow=0;
}else{
$startRow=($page-1)*$rowPerPage;
}
//------------------------------------------------------------------
if($_POST['action']=='Delete'){
$query="DELETE FROM tbl_menu_grant WHERE id = '".$_POST['EditID']."' ";
mysql_query($query);
}
//-----------------------------------------------------------------
if($_POST['action']=='addMenu'){
$query="INSERT INTO `tbl_menu_grant` ( `id` ,`user_id` ,`menu_id` ,`action`) "
." VALUES "
." ('' , '".$_GET['userID']."' , '".$_POST['MenuSelect']."', '2' )";
mysql_query($query);
}
$query = "SELECT * FROM `tbl_admin_user` WHERE id = '".$_GET['userID']."' ";
$result =mysql_query($query);
$data=mysql_fetch_assoc($result);
$query="SELECT * FROM tbl_menu_admin WHERE mainCateId='0' AND category_group='1' ORDER BY number ASC ";
$resultMenu=mysql_query($query);
$query="SELECT g.*, b.cate_name FROM tbl_menu_grant g LEFT JOIN tbl_menu_admin b ON g.menu_id=b.id WHERE g.user_id= '".$_GET['userID']."' ";
$resultDataMenu=mysql_query($query);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link href="style.css" rel="stylesheet" type="text/css" />
<script language="javascript">
function addMenu(){
if(document.form1.MenuSelect.value=='xx'){
alert('กรุณาเลือกเมนู') ;
return false;
}else{
document.form1.action.value='addMenu';
document.form1.submit();
}
}
//--------------------------
function DeleteThis(ids,bgimg){
if(confirm('ต้องการลบรายการนี้')){
document.form1.EditID.value=ids;
document.form1.action.value = 'Delete';
//document.form1.backgroundImg.value = bgimg;
document.form1.submit();
}else{
return false;
}
}
</script>
</head>
<body> <form action="<?php $PHP_SELF?>" method="post" name="form1" >
<table width="100%" border="0" cellspacing="3" cellpadding="3">
<tr>
<td colspan="2" class="txt10-black"><span class="kbank"><img src="images/black_icon/32x32/users.png" alt="" width="32" height="32" hspace="5" vspace="5" align="absmiddle" />User : <?php echo $data['admin_name']?>
<input type="hidden" name="action" id="action" />
<input type="hidden" name="EditID" id="EditID" />
</span></td>
</tr>
<tr>
<td width="5%"> </td>
<td width="95%" class="txt10-black">กรุณาเลือกเมนู
<select name="MenuSelect" >
<option value="xx">---เลือกเมนูใช้งาน---</option>
<?php while($menu=mysql_fetch_assoc($resultMenu)){?>
<option value="<?php echo $menu['id']?>"> <?php echo $menu['cate_name']?></option>
<?php } ?>
</select>
<input type="submit" name="button" id="button" value="เพิ่ม" onclick="addMenu()" /></td>
</tr>
<tr>
<td> </td>
<td><table width="522" border="0">
<tr>
<td width="4%"> </td>
<td width="90%"> </td>
<td width="6%"> </td>
</tr>
<?php while($data=mysql_fetch_assoc($resultDataMenu)){ ?>
<tr class="txt10-black">
<td bgcolor="#F0F0F0"><img src="images/black_icon/16x16/app_window.png" width="16" height="16" /></td>
<td height="25" bgcolor="#F0F0F0"> <?php echo $data['cate_name']?></td>
<td align="center" bgcolor="#FFFFCC">
<a href="#" onclick=" DeleteThis('<?php echo $data['id']?>','bgimg')"><img src="images/black_icon/16x16/delete.png" width="16" height="16" border="0" /></a></td>
</tr>
<?php } ?>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></td>
</tr>
</table> </form>
</body>
</html>
|