webadmin.php

/home/banprang/domains/plai.go.th/public_html/coremain/manage_header_piclink.php

<?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>