<?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']);
        $del_img = $con_db_administrator->real_escape_string($_GET['img']);
        $del_filedoc = "../../../".$del_img;

                        $sql_del = " DELETE FROM `data_group` WHERE `id_group`='$del_id' AND `name_group`='$del_name' ";  
                        $qr_del = $con_db_administrator->query($sql_del);
                        if(!$qr_del){ 	
                            echo "<SCRIPT type='text/javascript'>
                                    alert(' เกิดข้อผิดพลาด! ไม่สามารถลบข้อมูลได้');
                                    window.location.replace('../ChartGroupMain');
                                </SCRIPT>";
                            exit;
                        }else{	
                            @unlink($del_filedoc);

                            $sql_del_pst = " DELETE FROM `data_position` WHERE `id_group_position`='$del_id' AND `name_group_position`='$del_name' ";  
                            $qr_del_pst = $con_db_administrator->query($sql_del_pst);

                            $sql_delfile = " SELECT `img_profile` FROM `data_profile` WHERE `id_group_profile`='$del_id' AND `name_group_profile`='$del_name' ";
                            $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['img_profile'];
                                $del_pathfile = '../../../'.$delfile;
                                @unlink($del_pathfile);
                            }

                            $sql_del_pf = " DELETE FROM `data_profile` WHERE `id_group_profile`='$del_id' AND `name_group_profile`='$del_name' ";  
                            $qr_del_pf = $con_db_administrator->query($sql_del_pf);

                            echo "<SCRIPT type='text/javascript'>
                                    alert('ลบข้อมูล สำเร็จ!');
                                    window.location.replace('../ChartGroupMain');
                                </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);
?>