<?php session_start();
include("../include/config.php");
include("../include/functions.php"); 
validate_admin();
$arr =$_POST['ids'];
//print_r($_REQUEST);

$Submit =$_POST['what'];

if(count($arr)>0){
	$str_rest_refs=implode(",",$arr);
	if($Submit=='Delete')
	{	
	    $sql="delete from $tbl_gchildsubcat where cat_id in ($str_rest_refs)"; 
		$obj->query($sql);
	    $sql="delete from $tbl_childsubcategory where cat_id in ($str_rest_refs)"; 
		$obj->query($sql);
	    $sql="delete from $tbl_subcategory where cat_id in ($str_rest_refs)"; 
		$obj->query($sql);  
	    $imageArr=$obj->query("select photo,icon from $tbl_category where id in ($str_rest_refs) "); 
		while($resultImage=$obj->fetchNextObject($imageArr)){
		@unlink("../upload_images/category/".$resultImage->photo); 
		@unlink("../upload_images/category/tiny/".$resultImage->photo);
		@unlink("../upload_images/category/thumb/".$resultImage->photo);
		@unlink("../upload_images/category/icon/".$resultImage->photo);
		}
	    $sql="delete from $tbl_category where id in ($str_rest_refs)"; 
		$obj->query($sql);
		$sess_msg='Selected record(s) deleted successfully';
		$_SESSION['sess_msg']=$sess_msg;
    }
	elseif($Submit=='Activate')
	{	
		$sql="update $tbl_category set status=1 where id in ($str_rest_refs)";
		$obj->query($sql);
		$sess_msg='Selected record(s) activated successfully';
		$_SESSION['sess_msg']=$sess_msg;
	}
	elseif($Submit=='Deactivate')
	{		
		 $sql="update $tbl_category set status=0 where id in ($str_rest_refs)";
		$obj->query($sql);
		$sess_msg='Selected record(s) deactivated successfully';
		$_SESSION['sess_msg']=$sess_msg;
	}
		
	}
	
else{
	$sess_msg="Please select check box";
	$_SESSION['sess_msg']=$sess_msg;
	header("location: ".$_SERVER['HTTP_REFERER']);
	exit();
	}
	header("location: category-list.php");
	exit();
	
?>