<?php
session_start();
include ("function_sql_query.php");
include ("function_form.php");
echo"<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>";
echo"<link href='ccs/style.php' rel='stylesheet' type='text/css'>";
echo "<title>จัดการเมนู</title>";
import_request_variables('pG', 'p_');
if($p_test!="")						{	     $test=trim($p_test);								}
if($p_id_top!="")				 	{    	 $id_top=trim($p_id_top);					}
if($p_id_pic!="")				 		{    	 $id_pic=trim($p_id_pic);						}
if($p_id_show!="")				{    	 $id_show=trim($p_id_show);				}
if($p_id_del!="")				 	{    	 $id_del=trim($p_id_del);						}
if($p_id_order!="")				{    	 $id_order=trim($p_id_order);				}
if($p_check_up!="")				{    	 $check_up=trim($p_check_up);		}
if($p_name!="")				 		{    	 $name=trim($p_name);						}


if($_SESSION[web_name]=="")		$_SESSION[web_name]=$web_name;
include("../$_SESSION[web_name]/connect.php");
if($oncheck==1){	
	?>
		<script language="JavaScript"> 
			window.opener.location.href='../index.php';
			window.close();
		</script>
<?php
}
// ############################################## เมนูย่อย

// ซ่อน - แสดง ข้อมูล
if($id_pic!="" and $id_show==1){ 
		 $sql="UPDATE `cms_link_picture` SET `status` = '0'  WHERE id_pic ='$id_pic'";
		$result=mysql_query($sql) or die(mysql_error());
}if($id_pic!="" and $id_show==2){
		$sql="UPDATE `cms_link_picture` SET `status` = '1'  WHERE id_pic ='$id_pic'";
		$result=mysql_query($sql) or die(mysql_error());
}
//  เลื่อนตำแหน่งเมนู ขึ้น-ลง 
if($id_pic!="" and $id_order!=""){
		$sql="SELECT * FROM `cms_link_picture` WHERE  id_pic='$id_pic'";
		$re=mysql_query($sql) or die(mysql_error());
		$data=mysql_fetch_array($re);
			if($id_order==1){		$up=$data[position]-1; }
			if($id_order==2){		$up=$data[position]+1; }
		// แก้ไขเลื่อนขึ้น
		$sql="UPDATE `cms_link_picture` SET position='$up' WHERE id_pic ='$data[id_pic]'";
		$re=mysql_query($sql) or die(mysql_error());
		// แก้ไขเลื่อนลง
		$sql="UPDATE `cms_link_picture` SET position='$data[position]'  WHERE id_pic!='$data[id_pic]' and position='$up'";
		$re=mysql_query($sql) or die(mysql_error());
}
// ลบข้อมูลทุกอย่างใน โมดูล
if($id_del!="" and $id_top!=""){
	//cms_link_picture 
	$sql="SELECT id_pic ,pic_name FROM cms_link_picture WHERE id_pic='$id_del'";
	$re=mysql_query($sql);
	while($data=mysql_fetch_array($re)){
			if($data[pic_name]!="")		{			unlink("../$_SESSION[web_name]/module_picture/$data[pic_name]");		}
				$sql = "delete from cms_link_picture where id_pic='$data[id_pic]'";			
				$result = mysql_query($sql) or die(mysql_error());
	}
}
// ############################################# เมนูหลัก
// แก้ไขเมนูหลัก
if($id_top!="" and $check_up=='2'){
	$sql="UPDATE `cms_menu_top` SET  name='$name'  WHERE `id_top` ='$id_top'";
	$result=query($sql);
}
echo "<fieldset><legend>จัดการเมนู</legend>";
// ####################### แก้ไขชื่อเมนูหลัก #############################
echo "<br><table width='95%' border='0' align='center' cellpadding='1' cellspacing='1'>";
echo "<tr bgcolor='$datatm[color]'><td colspan='2' align=left><b>แก้ไขชื่อเมนูหลัก</b></td></tr>";
echo "<tr height=10><td colspan='2' align=center></td></tr>";
$sql="SELECT * FROM cms_menu_top WHERE id_top='$id_top'";
$result=mysql_query($sql);
$data=mysql_fetch_array($result);
echo"<FORM METHOD=POST ACTION='manage_header_piclink.php?id_top=$id_top'>";
echo "    <tr>";
echo "     <td width='50%' align=center>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;<INPUT TYPE='text' NAME='name' value='$data[name]'></td> ";
echo "		<td width='20%'>";
echo"		<INPUT TYPE='submit' value='แก้ไขข้อมูล' onmouseover=this.style.cursor='hand'>";
echo	"	<INPUT TYPE='hidden' name='check_up' value='2'>";
echo"</td>";
echo "  </tr>";
echo "<tr height=10><td colspan='2' align=center></td></tr>";
echo"</FORM>";
echo "</table>";

// ############################# แสดงเมนูย่อย #############################
echo "<table width='95%' border='0' align='center' cellpadding='1' cellspacing='1' bgcolor='eeeeee'>";
echo "<tr><td colspan='2' align=left><b>แสดงรูปภาพ</b></td></tr>";
echo "    <tr>";
echo "     <td width='50%' align=center bgcolor='dddddd'><b>รูปภาพ</b></td> ";
echo "		<td width='25%' align=center bgcolor='dddddd' colspan=2><b>จัดการ</b></td>";
echo "  </tr>";

$sql="SELECT * FROM `cms_link_picture` WHERE id_top='$data[id_top]' order by position asc";
$result=mysql_query($sql);
$count_l=1;
while($data=mysql_fetch_array($result)){
echo"<FORM METHOD=POST ACTION='manage_header_piclink.php?id_top=$id_top&id_pic=$data[id_pic]&id_top=$id_top'>";
echo "    <tr>";
// ประเภท
		$mod_pic = select_query_data("pic_name","cms_link_picture","id_pic",$data["id_pic"]);
		echo "		<td align=center><img src='../$_SESSION[web_name]/module_picture/$mod_pic'></td>";
// จัดการ
		echo "		<td align=center>";
		$sql_num="SELECT count(*) FROM `cms_link_picture` WHERE id_top='$data[id_top]' order by position asc";
		$re_num=mysql_query($sql_num);
		$data_num=mysql_fetch_array($re_num);

				// Up 
				if($count_l>1)	{
					echo "<a href='manage_header_piclink.php?id_pic=$data[id_pic]&id_order=1&id_top=$id_top'><img src='../coremain/images/up.gif' border='0' title='เลื่อนขึ้น'></a>"; 
					}else {
					print "&nbsp;&nbsp; &nbsp;&nbsp;";					
					}
				// Down
					if($count_l<$data_num[0])	{ 
					echo "<a href='manage_header_piclink.php?id_pic=$data[id_pic]&id_order=2&id_top=$id_top'><img src='../coremain/images/down.gif' border='0' title='เลื่อนลง'></a> "; 
					}else {
					print "&nbsp;&nbsp; &nbsp;&nbsp;";
					}

				// show -hide
					if($data[status]=="1")	
					echo "<a href='manage_header_piclink.php?id_pic=$data[id_pic]&id_show=1&id_top=$id_top' title='ซ่อนข้อมูล'><img src='../coremain/images/show.gif' border='0'></a> ";
					else													
					echo "<a href='manage_header_piclink.php?id_pic=$data[id_pic]&id_show=2&id_top=$id_top' title='แสดงข้อมูล'><img src='../coremain/images/hide.gif' border='0'></a> ";

				// Del
					echo " <a href='manage_header_piclink.php?id_del=$data[id_pic]&id_top=$id_top'><img src='../coremain/images/del1.gif' border='0' title='ลบข้อมูล'  onclick='return goURLdel();'></a><br>";
		echo"</td>";
echo "  </tr>";
$count_l++;
echo"</FORM>";
}

echo "</table>";
// ปิดหน้าต่าง

echo "<center><INPUT TYPE='button' value='ปิดหน้านี้'  onmouseover=this.style.cursor='hand' onclick ='closed_page();'></center>";


echo "</fieldset>";
?>


<script language="javascript">
		function checkadd() {
		if(document.add.namemenu.value=="") {
		alert("กรุณากรอก ชื่อเมนูย่อย!") ;
		document.add.namemenu.focus() ;
		return false ;
		}
		else if(document.add.module.value=="0") {
		alert("กรุณาเลือกประเภทโมดูล!") ;
		document.add.module.focus() ;
		return false ;
		}
		else 
		return true ;
		}
</script>


<script language="JavaScript">
<!--
function goURLdel() {
var blnLink
blnLink = confirm("Click OK เพื่อยืนยันการลบข้อมูล?")
if (!blnLink) { return false; }
return true;
}
//-->	
</script>
<script language="javascript">
function closed_page(){
			window.opener.location.href='../index.php';
			window.close();
}


</script>