<?php
require_once('session_backend_administrator.php');
header('Content-Type: text/html; charset=UTF-8');
date_default_timezone_set("Asia/Bangkok"); 

if($STT_login=="admin_login_true"){

    if(isset($_GET['id']) && isset($_GET['name']) ) {

        $del_id = $con_db_administrator->real_escape_string($_GET['id']);
        $del_name = $con_db_administrator->real_escape_string($_GET['name']);
        $link = $con_db_administrator->real_escape_string($_GET['link']);

        $sql_cdata = " SELECT COUNT(*) FROM `data_filedoc_subdatafile` WHERE `id_tbdata_filedoc_subdatafile`='$del_id' ";
        $qr_cdata = mysqli_query($con_db_administrator, $sql_cdata) or trigger_error("SQL", E_USER_ERROR);
        $rs_cdata = mysqli_fetch_row($qr_cdata);
        $cdel_file = $rs_cdata[0];

        if($cdel_file==0){
                $sql_del = " DELETE FROM `data_subdatafile` WHERE `id_subdatafile`='$del_id' ";  
                $qr_del = $con_db_administrator->query($sql_del);
                if(!$qr_del){ 	
                    echo "<SCRIPT type='text/javascript'>
                            alert(' เกิดข้อผิดพลาด! ไม่สามารถลบข้อมูลได้ [1]');
                            window.location.replace('../$link');
                        </SCRIPT>";
                    exit;
                }else{	
                    echo "<SCRIPT type='text/javascript'>
                            alert('ลบข้อมูล [ $del_name ] สำเร็จ');
                            window.location.replace('../$link');
                        </SCRIPT>";
                    exit;
                }
        }else{
            $sql_del = " DELETE FROM `data_subdatafile` WHERE `id_subdatafile`='$del_id' ";  
            $qr_del = $con_db_administrator->query($sql_del);
            if(!$qr_del){ 	
                echo "<SCRIPT type='text/javascript'>
                        alert(' เกิดข้อผิดพลาด! ไม่สามารถลบข้อมูลได้ [2]');
                        window.location.replace('../$link');
                    </SCRIPT>";
                exit;
            }else{	
                $sql_delfile = " SELECT `path_filedoc_subdatafile` FROM `data_filedoc_subdatafile` WHERE `id_tbdata_filedoc_subdatafile`='$del_id' ";
                $qr_delfile = mysqli_query($con_db_administrator,$sql_delfile) or die( mysqli_error($con_db_administrator));
                while($rs_delfile = mysqli_fetch_array($qr_delfile)){
                    $delfile = $rs_delfile['path_filedoc_subdatafile'];
                    $del_pathfile = '../../../'.$delfile;
                    @unlink($del_pathfile);
                }

                $sql_delsqlfile = " DELETE FROM `data_filedoc_subdatafile` WHERE `id_tbdata_filedoc_subdatafile`='$del_id' ";  
                $qr_delsqlfile = $con_db_administrator->query($sql_delsqlfile);
                if(!$qr_delsqlfile){ 	
                    echo "<SCRIPT type='text/javascript'>
                            alert(' เกิดข้อผิดพลาด! ไม่สามารถลบข้อมูลได้ [3]');
                            window.location.replace('../$link');
                        </SCRIPT>";
                    exit;
                }else{	
                    echo "<SCRIPT type='text/javascript'>
                            alert('ลบข้อมูล สำเร็จ');
                            window.location.replace('../$link');
                        </SCRIPT>";
                    exit;
                }
            }
        }
        
    }else{
        echo "<SCRIPT type='text/javascript'>
            alert('เกิดข้อผิดพลาด! ไม่พบข้อมูลที่ต้องการลบ');
            window.location.replace(document.referrer);
        </SCRIPT>";
        exit;
    }

}else{
    echo "<SCRIPT type='text/javascript'>
        alert('กรุณาเข้าสู่ระบบ');
        window.location.replace('../../index');
    </SCRIPT>";
    exit;
}
mysqli_close($con_db_administrator);
?>