<?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` WHERE `id_tbdata_filedoc`='$del_id' AND `tbdata_filedoc`='data_plan' ";
        $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_plan` WHERE `id_plan`='$del_id' AND `name_plan`='$del_name' ";  
                $qr_del = $con_db_administrator->query($sql_del);
                if(!$qr_del){ 	
                    echo "<SCRIPT type='text/javascript'>
                            alert(' เกิดข้อผิดพลาด! ไม่สามารถลบข้อมูลได้ [1]');
                            window.location.replace('../Plan?view=$link');
                        </SCRIPT>";
                    exit;
                }else{	
                    echo "<SCRIPT type='text/javascript'>
                            alert('ลบข้อมูล [ $del_name ] สำเร็จ');
                            window.location.replace('../Plan?view=$link');
                        </SCRIPT>";
                    exit;
                }
        }else{
            $sql_del = " DELETE FROM `data_plan` WHERE `id_plan`='$del_id' AND `name_plan`='$del_name' ";  
            $qr_del = $con_db_administrator->query($sql_del);
            if(!$qr_del){ 	
                echo "<SCRIPT type='text/javascript'>
                        alert(' เกิดข้อผิดพลาด! ไม่สามารถลบข้อมูลได้ [2]');
                        window.location.replace('../Plan?view=$link');
                    </SCRIPT>";
                exit;
            }else{	
                $sql_delfile = " SELECT `path_filedoc` FROM `data_filedoc` WHERE `id_tbdata_filedoc`='$del_id' AND `tbdata_filedoc`='data_plan' ";
                $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'];
                    $del_pathfile = '../../../'.$delfile;
                    @unlink($del_pathfile);
                }

                $sql_delsqlfile = " DELETE FROM `data_filedoc` WHERE `id_tbdata_filedoc`='$del_id' AND `tbdata_filedoc`='data_plan' ";  
                $qr_delsqlfile = $con_db_administrator->query($sql_delsqlfile);
                if(!$qr_delsqlfile){ 	
                    echo "<SCRIPT type='text/javascript'>
                            alert(' เกิดข้อผิดพลาด! ไม่สามารถลบข้อมูลได้ [3]');
                            window.location.replace('../Plan?view=$link');
                        </SCRIPT>";
                    exit;
                }else{	
                    echo "<SCRIPT type='text/javascript'>
                            alert('ลบข้อมูล สำเร็จ');
                            window.location.replace('../Plan?view=$link');
                        </SCRIPT>";
                    exit;
                }
            }
        }
                    // $sql_del = " DELETE FROM `data_plan` WHERE `id_plan`='$del_id' AND `name_plan`='$del_name' ";  
                    // $qr_del = $con_db_administrator->query($sql_del);
                    // if(!$qr_del){ 	
                    //     echo "<SCRIPT type='text/javascript'>
                    //             alert(' เกิดข้อผิดพลาด! ไม่สามารถลบข้อมูลได้');
                    //             window.location.replace('../$link');
                    //         </SCRIPT>";
                    //     exit;
                    // }else{	
                    //     $sql_del_filedoc = " DELETE FROM `data_filedoc` WHERE `tbdata_filedoc`='data_plan' AND `id_tbdata_filedoc`='$del_id' ";  
                    //     $qr_del_filedoc = $con_db_administrator->query($sql_del_filedoc);
                    //     echo "<SCRIPT type='text/javascript'>
                    //             alert('ลบข้อมูล [ $del_name ] สำเร็จ');
                    //             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);
?>