|
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_news/ |
Upload File : |
<?
session_start();
include "config/config.inc.php";
include("function/function.php");
if(!isset($session_username)){
header("Location: login.php");
}
include("header_menu.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" type="text/css" rel="stylesheet" />
<script language='javascript' src='daily_popcalendar.js'></script>
<script language='javascript' src='displayelement.js'></script>
<style type="text/css">
<!--
body { margin: 0px 0px; padding: 0px 0px}
a:link { color: #005CA2; text-decoration: none}
a:visited { color: #005CA2; text-decoration: none}
a:active { color: #0099FF; text-decoration: underline}
a:hover { color: #0099FF; text-decoration: underline}
-->
</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 style="filter:progid:DXImageTransform.Microsoft.Gradient(GradientType=0, StartColorStr='#FFFFFF', EndColorStr='#FFFFFF');">
<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/back.jpg" alt="กลับหน้าหลัก" border="0"></a> เพิ่มกลุ่มเมนู</b></td>
</tr>
<tr>
<td width="7%" align="center" bgcolor="#B0C6E6">ลำดับ</td>
<td width="74%" align="center" bgcolor="#B0C6E6">ชื่อกลุ่มเมนู</td>
<td width="11%" align="center" bgcolor="#B0C6E6">สถานะ</td>
<td width="8%" align="center" bgcolor="#B0C6E6">
<input type="button" name="btnADD" value=" เพิ่ม " onClick="location.href='add_group_menu.php?action=FADD'"> </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>