<? require_once "../application_top.php";
$userid = $_SESSION['useridsess']? $_SESSION['useridsess']:"";
$action = (isset($_REQUEST['action']) && ($_REQUEST['action']))? $_REQUEST['action'] : 0;
$id = (isset($_REQUEST['id']) && ($_REQUEST['id']))? decode($_REQUEST['id']) : 0;
$filename = (isset($_REQUEST['pic']) && ($_REQUEST['pic']))? $_REQUEST['pic'] : 0;

if($action == "execSt"){
	if($id){
		$newstat = $_REQUEST['newstatus'];
		$updateArr = array(
			'istatus' => $_REQUEST['newstatus']
		);
		$db->where('adminid',$id);
		$db->update('adminlogin',$updateArr);
		$_SESSION['msg'] = "Status changed successfully!";		
	}
}
if($action == "prdstatus"){
	if($id){
		$newstat = $_REQUEST['newstatus'];
		$updateArr = array(
			'istatus' => $_REQUEST['newstatus']
		);
		$db->where('pid',$id);
		$db->update('products',$updateArr);
		$_SESSION['msg'] = "Status changed successfully!";		
	}
}
if($action == "prddelete"){
	$db->where('pid',$id);
	$rowprd = $db->getOne('products');
	if($rowprd){
		for($i=1;$i<=4;$i++){
			if($rowprd['pic'.$i]){
				@unlink("../images/products/".$rowprd['pic'.$i]);
			}
		}
	}
	$db->where('pid',$id);
	$db->delete('products');
	$_SESSION['msg'] = "Product Deleted";
}

if($action == "adminstatus"){
	if($id){
		$newstat = $_REQUEST['newstatus'];
		$updateArr = array(
			'istatus' => $_REQUEST['newstatus']
		);
		$db->where('adminid',$id);
		$db->update('adminlogin',$updateArr);
		$_SESSION['msg'] = "Status changed successfully!";		
	}
}
if($action == "delExec"){
	if($id){
		$db->where('adminid',$id);
		$rowexec = $db->getOne('adminlogin');
		if($rowexec){
			if($rowexec['pic1']){
				unlink('../images/users/'.$rowexec['pic1']);
			}
		}
		$db->where('adminid',$id);
		$db->delete('adminlogin');
		$_SESSION['msg'] = "Executive deleted";
	}
}

if($action == "deleteadmin"){
	if($id){
		$db->where('adminid',$id);
		$db->delete('adminlogin');
		$_SESSION['msg'] = "User Deleted";
	}
}
if($action == "custstatus"){
	if($id){
		$newstat = $_REQUEST['newstatus'];
		$updateArr = array(
			'istatus' => $_REQUEST['newstatus']
		);
		$db->where('userid',$id);
		$db->update('register',$updateArr);
		$_SESSION['msg'] = "Status changed successfully!";		
	}
}
if($action == "deletecust"){
	if($id){
		$db->where('userid',$id);
		$db->delete('register');
		$_SESSION['msg'] = "Customer Deleted";
	}
}
if($action == "catdel"){
	if($id){
		$db->where('catid',$id);
		$db->delete('categories');
		$db->where('catid',$id);
		$db->delete('subcategories');		
		$_SESSION['msg'] = "Category Deleted";
	}
}

if($action == "catistatus"){
	if($id){
		$newstat = $_REQUEST['newstatus'];
		$updateArr = array(
			'istatus' => $_REQUEST['newstatus']
		);
		$db->where('catid',$id);
		$db->update('categories',$updateArr);
		$_SESSION['msg'] = "Status changed successfully!";		
	}
}
if($action == "subcatistatus"){
	if($id){
		$newstat = $_REQUEST['newstatus'];
		$updateArr = array(
			'istatus' => $_REQUEST['newstatus']
		);
		$db->where('subcatid',$id);
		$db->update('subcategories',$updateArr);
		$_SESSION['msg'] = "Status changed successfully!";		
	}
}

if($action=='subcatdelete'){
	$db->where('subcatid',$id);
	$db->delete('subcategories');
	$_SESSION['msg'] = "SubCategory Deleted";
}

header("location:".$_SERVER['HTTP_REFERER']);exit;
?>