<?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['type']) && isset($_GET['link']) ) {

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

            $sql_cdata = " SELECT COUNT(*) FROM `data_filedoc_complain` WHERE `id_tbdata_filedoc_complain`='$del_id' AND `typedata_filedoc_complain`='$del_type' ";
            $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_complain` WHERE `id_complain`='$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('ลบข้อมูล สำเร็จ');
                                window.location.replace('../$link');
                            </SCRIPT>";
                        exit;
                    }
            }else{
                $sql_del = " DELETE FROM `data_complain` WHERE `id_complain`='$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_complain` FROM `data_filedoc_complain` WHERE `id_tbdata_filedoc_complain`='$del_id' AND `typedata_filedoc_complain`='$del_type' ";
                    $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_complain'];
                        $del_pathfile = '../../../'.$delfile;
                        @unlink($del_pathfile);
                    }
    
                    $sql_delsqlfile = " DELETE FROM `data_filedoc_complain` WHERE `id_tbdata_filedoc_complain`='$del_id' AND `typedata_filedoc_complain`='$del_type' ";  
                    $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);
?>