<?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')
	{	
		 $check=$obj->query("select sectionid from stores where storeid in ($str_rest_refs)");
	    while($result=$obj->fetchNextObject($check))
	    {
	       
	           $section=$result->sectionid; 
	           if($section==1)
	           {
	                $section='grocery';
             $parameter='grocery-store';
             clearlaravelcache($section,$parameter);
	           }
	    }
		$sql="delete from stores where storeid in ($str_rest_refs)"; 
		$obj->query($sql);
	  	$sql="delete from store_delivery where storeid in ($str_rest_refs)"; 
		$obj->query($sql);
		
		$sess_msg='Selected record(s) deleted successfully';
		$_SESSION['sess_msg']=$sess_msg;
    }
	elseif($Submit=='Make Latest')
	{	
		$sql="update $tbl_product set latest=1 where id in ($str_rest_refs)";
		$obj->query($sql);
		$sess_msg='Selected record(s) activated successfully';
		$_SESSION['sess_msg']=$sess_msg;
	}
	elseif($Submit=='Remove Latest')
	{	
		$sql="update $tbl_product set latest=0 where id in ($str_rest_refs)";
		$obj->query($sql);
		$sess_msg='Selected record(s) activated successfully';
		$_SESSION['sess_msg']=$sess_msg;
	}
	elseif($Submit=='Activate')
	{	
	     $check=$obj->query("select sectionid from stores where storeid in ($str_rest_refs)");
	    while($result=$obj->fetchNextObject($check))
	    {
	       
	           $section=$result->sectionid; 
	           if($section==1)
	           {
	                $section='grocery';
             $parameter='grocery-store';
             clearlaravelcache($section,$parameter);
	           }
	    }
	    
		$sql="update stores set in_stock='1', status='1' where storeid in ($str_rest_refs)";
		$obj->query($sql);
		$sess_msg='Selected record(s) activated successfully';
		$_SESSION['sess_msg']=$sess_msg;
	}
	elseif($Submit=='Deactivate')
	{		
	    
	     $check=$obj->query("select sectionid from stores where storeid in ($str_rest_refs)");
	    while($result=$obj->fetchNextObject($check))
	    {
	       
	           $section=$result->sectionid; 
	           if($section==1)
	           {
	                $section='grocery';
             $parameter='grocery-store';
             clearlaravelcache($section,$parameter);
	           }
	    }
	    
		 $sql="update stores set in_stock='0', status='0' where storeid 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: storelist.php");
	exit();
	
?>