<?php
include("includes/db_config.php");

/*if(isset($_GET['id']))
{
	//var_dump($_GET);exit();
$id = $_GET['id'];
$sql="
DELETE FROM sub_sub_category
WHERE id={$_GET['id']}";
$res=mysqli_query($conn,$sql) or die(mysqli_error());

}
echo "<script>window.location.href='sub-sub-category.php'</script>";
*/
if(isset($_GET['id']))
{
	//var_dump($_GET);exit();
	$id = $_GET['id'];
    $sql_sscats="select sub_sub_category.*,category.cat_name,sub_category.sub_category_name,sub_category.id as scat,sub_category.subcat_banner from sub_sub_category join category on sub_sub_category.category_id=category.id join sub_category on sub_sub_category.sub_category_id=sub_category.id  where sub_sub_category.id='$id'";
    $result_sscats = mysqli_query($conn, $sql_sscats);
    $res_sscats = mysqli_fetch_array($result_sscats);
	$name = strtolower(str_replace(" ", "-", $res_sscats['cat_name']));
	$sub_name = strtolower(str_replace(" ", "-", $res_sscats['sub_category_name']));
	$sub_sub_name = strtolower(str_replace(" ", "-", $res_sscats['sub_sub_cat_name']));
	if(file_exists('../'.$name.'/'.$sub_name)) {
        $dir = "../$name/$sub_name/$sub_sub_name";
        $dir = new RecursiveDirectoryIterator($dir, FilesystemIterator::SKIP_DOTS); 
        $dir = new RecursiveIteratorIterator($dir,RecursiveIteratorIterator::CHILD_FIRST); 
        foreach ( $dir as $file ) {  
            $file->isDir() ?  rmdir($file) : unlink($file); 
        } 
        $dir = "../$name/$sub_name/$sub_sub_name";
        if(rmdir($dir)){
            $sql="
				DELETE FROM sub_sub_category
				WHERE id={$_GET['id']}";
            if (mysqli_query($conn,$sql)) {
                echo "  <script> 
                            alert('Your Sub Sub Category have successfully Deleted!!!'); 
                            location.replace('sub-sub-category.php');
                        </script>";
            } else {
                echo "  <script> 
                            alert('Something went wrong, please try again!!!'); 
                            location.replace('sub-sub-category.php');
                        </script>";
            }
        }
    } else{
    	$sql="
			DELETE FROM sub_sub_category
			WHERE id={$_GET['id']}";
        if (mysqli_query($conn,$sql)) {
            echo "  <script> 
                        alert('Your Sub Category have successfully Deleted!!!'); 
                        location.replace('sub-category.php');
                    </script>";
        } else {
            echo "  <script> 
                        alert('Something went wrong, please try again!!!'); 
                        location.replace('sub-category.php');
                    </script>";
        }
    }
}
?>