<?php
///////////////////////////////////////////////////////////////////////////////////////////
///Script PHP/MYSQL of management of classifieds ads developed by Script PAG
///Script PAG all rights reserved. Use under license. http://www.script-pag.com
///////////////////////////////////////////////////////////////////////////////////////////

############################################################

require_once __DIR__.'/includes_adm/all_fns_adm.php';

///////////////////////////////////
//Check if the super admin is connected
//////////////////////////////////
	
if(!empty($_SESSION['valid_admin']))
$valid_admin = $_SESSION['valid_admin'];

if(!check_super_admin())
redirect('index.php');

///////////////////////////////////
//Validation of the action
//////////////////////////////////

if(!empty($_GET['act']))
{
	if($_GET['act'] >= 1 && $_GET['act'] <= 4)
	$act = (int) $_GET['act'];
	
	else $act = 0;
}
else $act = 0;

///////////////////////////////////
//Validation of the categorie
//////////////////////////////////

$id_cat = (!empty($_GET['id_cat'])) ? (int) $_GET['id_cat'] : 0;
$par_cat = (!empty($_GET['par_cat'])) ? (int) $_GET['par_cat'] : 0;

///////////////////////////////////
//Select searche engine and title values
//////////////////////////////////

if($act != 1 && $act != 2)
{
	$action = (isset($_GET['id_cat'])) ? 'cat.php?id_cat='. (int) $_GET['id_cat'] .'&amp;act=4&amp;menu=4' : 'cat.php?act=4&amp;menu=4';
	$href = (isset($_GET['id_cat'])) ? 'cat.php?id_cat='. (int) $_GET['id_cat'] .'&amp;act=1&amp;menu=4' : 'cat.php?act=1&amp;menu=4';
	$href_name = (isset($_GET['id_cat'])) ? $language_adm['page_list_cat_add_subcat'] : $language_adm['page_list_cat_add_cat'];
	
	$name_cat_lang_add = '';
	
	if(isset($_GET['id_cat']))
	{
		foreach($cache_lang as $row)
		{
			$code_lang = stripslashes(htmlspecialchars($row['code_lang'], ENT_QUOTES));
			$name_cat_lang = (isset($cache_cat[$_GET['id_cat']]['name_cat_'. $code_lang])) ? stripslashes(htmlspecialchars($cache_cat[$_GET['id_cat']]['name_cat_'. $code_lang], ENT_QUOTES)) : '';
			$position = (int) $row['position'];
			$active = (int) $row['active'];
			
			if($active == 1 && !empty($name_cat_lang))
			$name_cat_lang_add = $name_cat_lang;
			
			if($position == 1)
			break;
		}
	}
}

///////////////////////////////////
//Initializing variable $error
//////////////////////////////////

$error = '';

///////////////////////////////////
//Add category or subcategory
//////////////////////////////////

if($act == 1)
{
	//Get action form
	$action = (!empty($_GET['id_cat'])) ? 'cat.php?id_cat='. (int) $_GET['id_cat'] .'&amp;act='. $act .'&amp;menu=4' : 'cat.php?act='. $act .'&amp;menu=4';	
	
	$par_cat = (!empty($_POST['id_cat'])) ? (int) $_POST['id_cat'] : 0;
	$redirect = (!empty($par_cat)) ? '&id_cat='. $par_cat .'&succes=2' : '&succes=1';
	
	if(count($_POST) > 0 && !isset($_POST['lang']))
	{
		foreach($cache_lang as $v)
		{
			$id_lang = (int) $v['id_lang'];
			$active = (int) $v['active'];
			
			if($active == 1 && empty($_POST['name_'. $id_lang]))
			$error = 1;
		}
		 
		if(empty($error))
		{
			create_cat($_POST, $par_cat);
			create_cache_cat();
			$conn = null;
				
			redirect("cat.php?menu=4". $redirect);
		}
	}
}

///////////////////////////////////
//Update category or subcategory
//////////////////////////////////

elseif(!empty($_POST['id_cat']) && $act == 2)
{
	$id_cat = (int) $_POST['id_cat'];
	$redirect = (!empty($par_cat)) ? '&id_cat='. $par_cat .'&succes=4' : '&succes=3';
	
	if(count($_POST) > 0 && !isset($_POST['lang']))
	{
		foreach($cache_lang as $v)
		{
			$id_lang = (int) $v['id_lang'];
			$active = (int) $v['active'];
			
			if($active == 1 && empty($_POST['name_'. $id_lang]))
			$error = 1;
		}
		 
		if(empty($error))
		{
			update_cat($id_cat, $par_cat, $_POST);
			create_cache_cat();
			$conn = null;
				
			redirect("cat.php?menu=4". $redirect);
		}
	}
}

///////////////////////////////////
//Delete category or subcategory
//////////////////////////////////

if(!empty($_GET['id_cat']) && isset($_GET['par_cat']) && $act == 3)
{
	$par_cat = (int) $_GET['par_cat'];
	$redirect = (!empty($par_cat)) ? '&id_cat='. $par_cat .'&succes=6' : '&succes=5';
	
	delete_cat_search_opt($id_cat, $par_cat);
	delete_cat($id_cat, $par_cat);
	create_cache_cat();
	create_cache_search_price();
	create_cache_search_digital();
	create_cache_search_data();
	create_cache_search_check();
	$conn = null;
				
	redirect("cat.php?menu=4". $redirect);
}

///////////////////////////////////
//Delete all categories or subcategories
//////////////////////////////////

if(!empty($_POST['check_all']) && $act == 4)
{
	if(count($_POST['check_all']) > 1)
	$redirect = (!empty($id_cat)) ? '&id_cat='. $id_cat .'&succes=8' : '&succes=7';
	
	else $redirect = (!empty($id_cat)) ? '&id_cat='. $id_cat .'&succes=6' : '&succes=5';
	
	$array = $_POST['check_all'];
	
	if(!empty($id_cat))
	{
		foreach($array as $id_cat)
		{
			delete_cat_search_opt($id_cat, 1);
		}
		
		delete_all_subcat($array);
	}
	else 
	{
		foreach($array as $id_cat)
		{
			delete_cat_search_opt($id_cat, 0);
			delete_cat($id_cat, 0);
		}
	}
	
	create_cache_cat();
	create_cache_search_price();
	create_cache_search_digital();
	create_cache_search_data();
	create_cache_search_check();
	$conn = null;
				
	redirect("cat.php?menu=4". $redirect);
}

///////////////////////////////////
//Close database connexion
//////////////////////////////////

$conn = null;

///////////////////////////////////
//Display view
//////////////////////////////////

$view = array();

if($act == 1)
$view[] = 'template_adm/tpl_cat_crea_adm.php';

elseif($act == 2) 
$view[] = 'template_adm/tpl_cat_mod_adm.php';

else $view[] = 'template_adm/tpl_cat_adm.php';
	
require_once __DIR__.'/template_adm/tpl_layout_adm.php';