|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /var/www/html/pathumthani_eoffice/application/agenda/ |
Upload File : |
<?
session_start();
include("../../config/config.inc.php");
include("function/function.php");
if(!isset($session_username)){
header("Location: login.php");
}
if($action == "SAVE"){
$strSQL_save = "INSERT INTO tbl_main_menu(name_menu,status_menu)VALUES('$name_menu','$status')";
//echo $strSQL_save;
$Result_save = mysql_db_query($dbname,$strSQL_save);
if($Result_save){
echo "
<script language=\"javascript\">
alert(\"ทำการบันทึกข้อมูลเสร็จสิ้น\\n \");
location.href='add_group_menu.php?action=FormADD';
</script>
";
exit();
}
}
if($action == "SAVE_EDIT"){
$strSQL_up = "UPDATE tbl_main_menu SET name_menu='$name_menu', status_menu='$status' WHERE id_menu='$id_menu'";
$Result_up = mysql_db_query($dbname,$strSQL_up);
if($Result_up){
echo "
<script language=\"javascript\">
alert(\"ทำการบันทึกข้อมูลเสร็จสิ้น\\n \");
location.href='add_group_menu.php?action=FormADD';
</script>
";
exit();
}
}
if($action == "DEL"){
$strSQL_check = "SELECT * FROM tbl_subject WHERE id_menu='$id_menu'";
$Result_check = mysql_db_query($dbname,$strSQL_check);
$num_check = mysql_num_rows($Result_check);
if($num_check < 1){
$strSQL_del = "DELETE FROM tbl_main_menu WHERE id_menu='$id_menu'";
$Result_del = mysql_db_query($dbname,$strSQL_del);
if($Result_del){
echo "
<script language=\"javascript\">
alert(\"ลบรายการเรียบร้อยแล้ว\\n \");
location.href='add_group_menu.php?action=FormADD';
</script>
";
exit();
}
}else{
echo "
<script language=\"javascript\">
alert(\" ไม่สามารถลบรายการได้เนื่องจากมีข้อมูลย่อยในกลุ่มเมนูหลัก \\n \");
location.href='add_group_menu.php?action=FormADD';
</script>
";
exit();
}
}
?>
<html>
<head>
<title><?=$show_title?></title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<LINK href="common/style.css" rel=stylesheet>
<script language='javascript' src='daily_popcalendar.js'></script>
<script language='javascript' src='displayelement.js'></script>
<script language='javascript' src='sorttable.js'></script>
<script language='javascript' src='jquery.js'></script>
<script language="javascript">
<style type="text/css">
.page {
font : 9px tahoma;
font-weight : bold;
color : #0280D5;
padding : 1px 3px 1px 3px;
}
.pagelink {
font : 9px tahoma;
font-weight : bold;
color : #000000;
text-decoration : underline;
padding : 1px 3px 1px 3px;
}
.go {
BORDER: #59990e 1px solid;
PADDING-RIGHT: 0.38em;
PADDING-LEFT: 0.38em;
FONT-WEIGHT: bold;
FONT-SIZE: 105%;
BACKGROUND: url(../hr3/hr_report/images/hdr_bg.png) #6eab26 repeat-x 0px -90px;
FLOAT: left;
PADDING-BOTTOM: 0px;
COLOR: #fff;
MARGIN-RIGHT: 0.38em;
PADDING-TOP: 0px;
HEIGHT: 1.77em
}
#bf .go {
FLOAT: none
}
.go:hover {
BORDER: #3f8e00 1px solid;
BACKGROUND: url(../hr3/hr_report/images/hdr_bg.png) #63a218 repeat-x 0px -170px;
}
.q {
BORDER-RIGHT: #5595CC 1px solid;
PADDING-RIGHT: 0.7em;
BORDER-TOP: #5595CC 1px solid;
PADDING-LEFT: 0.7em;
FONT-WEIGHT: normal; FONT-SIZE: 105%;
FLOAT: left;
PADDING-BOTTOM: 0px;
MARGIN: 0px 0.38em 0px 0px;
BORDER-LEFT: #5595CC 1px solid;
WIDTH: 300px;
PADDING-TOP: 0.29em;
BORDER-BOTTOM: #5595CC 1px solid;
HEIGHT: 1.39em
}
.tabberlive .tabbertab {
background-color:#FFFFFF;
height:200px;
}
</style>
<style type="text/css">
<!--
.header1 { font-family:"MS Sans Serif", Tahoma, Arial;
font-size:1em;
font-weight:bold;
color: #FFFFFF;
}
.main { font-family:"MS Sans Serif", Tahoma, Arial;
font-size:0.8em;
color:#FF0000;
font-weight:bold;
}
.normal { font-family:"MS Sans Serif", Tahoma, Arial;
font-size:0.8em;
}
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.style1 {color: #FF0000}
-->
</style>
<SCRIPT LANGUAGE="JavaScript">
function CheckForm(){
missinginfo = "";
missinginfo1 = "";
if (document.form.subject.value == "") {missinginfo1 += "\n- กรุณากรอก เรื่องร้องเรียน "; }
if (document.form.subject_no_in.value == "") {missinginfo1 += "\n- กรุณากรอก เลขที่หนังสือ "; }
if (document.form.date_start.value == "") {missinginfo1 += "\n- กรุณากรอก วันเริ่มต้น "; }
if (document.form.date_end.value == "") {missinginfo1 += "\n- กรุณากรอก สิ้นสุด "; }
if (missinginfo1 != "") {
missinginfo += "ไม่สามารถบันทึกข้อมูลได้ เนื่องจาก \n";
missinginfo +="_____________________________\n";
missinginfo = missinginfo + missinginfo1 ;
missinginfo += "\n___________________________";
missinginfo += "\nกรุณาตรวจสอบ อีกครั้ง";
alert(missinginfo);
return false;
}
}
</SCRIPT>
<script language="javascript">
function popWindow(url, w, h){
var popup = "Popup";
if(w == "") w = 420;
if(h == "") h = 300;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=no,resizable=no,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
function popWindow1(url, w, h){
var popup = "Popup";
if(w == "") w = 420;
if(h == "") h = 300;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=no,resizable=no,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
function popWindow2(url, w, h){
var popup = "Popup";
if(w == "") w = 420;
if(h == "") h = 300;
var newwin = window.open(url, popup,'location=0,status=no,scrollbars=no,resizable=no,width=' + w + ',height=' + h + ',top=20');
newwin.focus();
}
</script>
<script language="javascript">
function clearselect()
{
document.post.salary_day.disabled=true;
document.post.salary_month.disabled=true;
document.post.salary_year.disabled=true;
document.post.label_date.disabled=true;
if (document.post.salary_day.value!="")
{
document.post.salary_day.value="";
document.post.salary_day.disabled=true;
}
if (document.post.salary_month.value!="")
{
document.post.salary_month.value="";
document.post.salary_month.disabled=true;
}
if (document.post.salary_year.value!="")
{
document.post.salary_year.value="";
document.post.salary_year.disabled=true;
}
if (document.post.label_date.value!="")
{
document.post.label_date.value="";
document.post.label_date.disabled=true;
}
}
</script>
</head>
<body >
<? include("header_menu.php");?>
<table width="100%" border="0" cellpadding="0" cellspacing="0" style="filter:progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr='#144C85', EndColorStr='#FFFFFF');">
<tr>
<td align="center" valign="top" bgcolor="#000000">
<? if($action == "FormADD"){?>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td colspan="4" align="left" bgcolor="#B0C6E6"><b><a href="login_admin.php"><img src="../../images_sys/home.gif" alt="กลับหน้าหลัก" border="0"></a> เพิ่มกลุ่มเมนู</b></td>
</tr>
<tr>
<td width="7%" align="center" bgcolor="#B0C6E6"><strong>ลำดับ</strong></td>
<td width="74%" align="center" bgcolor="#B0C6E6"><strong>ชื่อกลุ่มเมนู</strong></td>
<td width="11%" align="center" bgcolor="#B0C6E6"><strong>สถานะ</strong></td>
<td width="8%" align="center" bgcolor="#B0C6E6">
<input name="btnADD" type="button" onClick="location.href='add_group_menu.php?action=FADD'" value=" เพิ่ม "> </td>
</tr>
<?
$strSQL = "SELECT * FROM tbl_main_menu ORDER BY id_menu ASC";
$Result = mysql_db_query($dbname,$strSQL);
$i=0;
while($Rs = mysql_fetch_object($Result)){
$bg = ($i%2)?'#F1F1F1':'#FFFFFF';$i++;
?>
<tr bgcolor="<?=$bg?>">
<td align="center"><?=$i?></td>
<td align="left"><?=$Rs->name_menu?></td>
<td align="center"> <? if($Rs->status_menu == '1'){ echo "<img src='images/approve.gif' border='0' alt='เปิดการแสดงผล'>"; }else{ echo "<img src='images/unapprove.png' border='0' alt='ปิดการแสดงผล'>";}?></td>
<td align="center">
<a href="add_group_menu.php?action=FEDIT&id_menu=<?=$Rs->id_menu?>"><img src="images/edit_project.gif" alt="แก้ไขรายการ" width="20" height="20" border="0" ></a>
<a href="add_group_menu.php?action=DEL&id_menu=<?=$Rs->id_menu?>"><img src="images/delete.gif" alt="ลบรายการ" width="20" height="20" border="0"></a> </td>
</tr>
<?
}
?>
</table>
<?
}
?> </td>
</tr>
<form name="form1" method="post" action="?">
<input type="hidden" name="action" value="SAVE">
<tr>
<td align="center" valign="top" bgcolor="#000000">
<?
if($action == "FADD"){
?>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td colspan="2" align="left" bgcolor="#B0C6E6"><strong>เพิ่มกลุ่มเมนู</strong></td>
</tr>
<tr>
<td width="26%" align="right" bgcolor="#B0C6E6">ชื่อกลุ่มเมนู</td>
<td width="74%" align="left" bgcolor="#FFFFFF"><label>
<input type="text" name="name_menu">
</label></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">สถานะเมนู</td>
<td align="left" bgcolor="#FFFFFF"><label>
<input name="status" type="radio" value="1" checked="checked">
แสดงเมนู
</label>
<label>
<input name="status" type="radio" value="0">
ไม่แสดงเมนู</label></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6"> </td>
<td align="left" bgcolor="#FFFFFF"><label>
<input type="submit" name="Submit" value="ตกลง">
</label>
<label>
<input type="reset" name="reste" value="ล้างข้อมูล">
</label>
<label>
<input type="button" name="btnBack" value="ย้อนกลับ" onClick="location.href='add_group_menu.php?action=FormADD'">
</label></td>
</tr>
</table>
<?
}
?> </td>
</tr>
</form>
<form name="form2" method="post" action="?">
<input type="hidden" name="action" value="SAVE_EDIT">
<tr>
<td align="center" valign="top" bgcolor="#000000">
<?
if($action == "FEDIT"){
$strSQLE = "SELECT * FROM tbl_main_menu WHERE id_menu='$id_menu'";
$Result_E = mysql_db_query($dbname,$strSQLE);
$Rs_E = mysql_fetch_object($Result_E);
?>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td colspan="2" align="left" bgcolor="#B0C6E6"><strong>แก้ไขกลุ่มเมนู</strong></td>
</tr>
<tr>
<td width="26%" align="right" bgcolor="#B0C6E6">ชื่อกลุ่มเมนู</td>
<td width="74%" align="left" bgcolor="#FFFFFF"><label>
<input type="text" name="name_menu" value="<?=$Rs_E->name_menu?>">
</label></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6">สถานะเมนู</td>
<td align="left" bgcolor="#FFFFFF"><label>
<input name="status" type="radio" value="1" <? if($Rs_E->status_menu == '1'){ echo "checked";}?>>
แสดงเมนู </label>
<label>
<input name="status" type="radio" value="0" <? if($Rs_E->status_menu == '0'){ echo "checked";} ?>>
ไม่แสดงเมนู</label></td>
</tr>
<tr>
<td align="right" bgcolor="#B0C6E6"> </td>
<td align="left" bgcolor="#FFFFFF"><label>
<input type="hidden" name="id_menu" value="<?=$Rs_E->id_menu?>">
<input type="submit" name="Submit2" value="ตกลง">
</label>
<label>
<input type="reset" name="reste2" value="ล้างข้อมูล">
</label>
<label>
<input type="button" name="btnBack" value="ย้อนกลับ" onClick="location.href='add_group_menu.php?action=FormADD'">
</label></td>
</tr>
</table>
<?
}
?> </td>
</tr>
</form>
</table>
</body>
</html>