<?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
///////////////////////////////////////////////////////////////////////////////////////////

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

////////////////////////////////
//Displaying lang button to select form 
////////////////////////////////

function display_lang_form_button() {
	global $cache_lang;
	$string = '<ul class="lang-form-buttons">';
	foreach($cache_lang as $lang) {
		if($lang['active'] == 1) {
			$string .= '<li data-codelang="'.stripslashes(htmlspecialchars($lang['code_lang'], ENT_QUOTES)).'"'.($lang['position'] == 1 ? ' class="selected"' : '').'><img src="'.URL.'/includes/language/flags/flag_'.stripslashes(htmlspecialchars($lang['code_lang'], ENT_QUOTES)).'.png" alt="'.stripslashes(htmlspecialchars($lang['code_lang'], ENT_QUOTES)).'" /></li>';
		}
	}
	$string .= '</ul>';
	echo $string;	
}

////////////////////////////////
//Displaying select categories
////////////////////////////////

function display_adm_cat($id, $language = 'search_cat')
{
	global $language_adm, $cache_lang, $cache_cat;
	
	echo '<select id="select_options" name="cat" onChange="GetNote();GetDisc();GetOpts();GetPayAds();DisplayOptions();DisplayNote();DisplayCalendar();DisplayFile();">';
	echo '<option value="0">'. $language_adm[$language] .'</option>';	
	
	foreach($cache_cat as $row)
	{	
		$id_cat = (int) $row['id_cat'];
		$par_cat = (int) $row['par_cat'];
		
		if(isset($row['name_cat_'. $_SESSION['lang']]))
		$name_cat = stripslashes(htmlspecialchars($row['name_cat_'. $_SESSION['lang']], ENT_QUOTES));
		
		if($par_cat == 0)
		{
			if(!empty($name_cat))
			echo '<option value="0" disabled class="select-cat uppercase">-- '. mb_strtoupper($name_cat) .' --</option>';
					
		}
    
		//Subcategories
		
		foreach($cache_cat as $row)
		{
			$id_subcat = (int) $row['id_cat'];
			$par_subcat = (int) $row['par_cat'];
			
			if(isset($row['name_cat_'. $_SESSION['lang']]))
			$name_subcat = stripslashes(htmlspecialchars($row['name_cat_'. $_SESSION['lang']], ENT_QUOTES));
			
			if($par_subcat == $id_cat) 
			{
				if($id == $id_subcat)
				echo '<option value="'. $id_subcat .'" selected="selected">'. $name_subcat .'</option>';
						
				else echo '<option value="'. $id_subcat .'">'. $name_subcat .'</option>';	
			}
		}
	}
	echo '</select>';
}

////////////////////////////////
//Displaying select rubric
////////////////////////////////

function display_adm_cat_rubric($id, $categories)
{
	global $language_adm, $cache_lang;
	
	echo '<select id="options" name="cat">';
	
	echo '<option value="0">'. $language_adm['select_rubric'] .'</option>';

	foreach($categories as $row)
	{	
		$id_cat = (int) $row['id_cat'];
		$par_cat = (int) $row['par_cat'];
		$name_cat = name_cat($id_cat, $_SESSION['lang'], $_SESSION['lang']);
		
		if($par_cat == 0) 
		{
			if(!empty($id) && $id == $id_cat)
			echo '<option value="'. $id_cat .'" class="uppercase" selected>'. mb_strtoupper($name_cat) .'</option>';
			
			else echo '<option value="'. $id_cat .'" class="uppercase">'. mb_strtoupper($name_cat) .'</option>';
		}
	}	
	echo '</select>';
}

////////////////////////////////
//Displaying select region
////////////////////////////////

function display_adm_reg_search($id, $reg, $language)
{	
	global $language_adm, $cache_lang;
	
	echo '<select id="form_county" name="reg" onchange="GetCounties();">
	<option value="0">'. $language .'</option>';

	foreach($reg as $row)
	{
		$id_reg = (int) $row['id_reg'];
		
		if(isset($row['name_reg_'. $_SESSION['lang']]))
		$name_reg = stripslashes(htmlspecialchars($row['name_reg_'. $_SESSION['lang']], ENT_QUOTES));
				  			
		if($id == $id_reg)
		echo '<option value="'. $id_reg .'" selected>'. $name_reg .'</option>';
				
		else echo '<option value="'. $id_reg .'">'. $name_reg .'</option>';	
	}	
	echo '</select>';			
}

////////////////////////////////
//Displaying select counties
////////////////////////////////

function display_adm_couties_search($id, $reg, $counties, $language)
{	
	global $cache_lang;
	
	echo '<select id="form_reg" name="county">
	<option value="0">'. $language .'</option>';

	foreach($counties as $row)
	{
		$id_county = (int) $row['id_county'];
		$par_reg = (int) $row['par_reg'];
		
		if(isset($row['name_county_'. $_SESSION['lang']]))
		$name_county = stripslashes(htmlspecialchars($row['name_county_'. $_SESSION['lang']], ENT_QUOTES));
		
		else $name_county = 'No';
				  	
		if($par_reg == $reg)	
		{
			if($id == $id_county)
			echo '<option value="'. $id_county .'" selected>'. $name_county .'</option>';
					
			else echo '<option value="'. $id_county .'">'. $name_county .'</option>';
		}
	}	
	echo '</select>';			
}

////////////////////////////////
//Displaying select number of results
////////////////////////////////

function display_adm_num_results($result)
{	
	global $language_adm;
	
	echo '<select name="result">
	<option value="0">'. $language_adm['search_result'] .'</option>';

	?>
	<option value="10" <?php if($result == 10) echo 'selected'; ?> >10</option>';
	<option value="25" <?php if($result == 25) echo 'selected'; ?> >25</option>';
	<option value="50" <?php if($result == 50) echo 'selected'; ?> >50</option>';
	<option value="100" <?php if($result == 100) echo 'selected'; ?> >100</option>';
	<option value="200" <?php if($result == 200) echo 'selected'; ?> >200</option>';
	<?php
				
	echo '</select>';			
}

////////////////////////////////
//Displaying select language
////////////////////////////////

function display_adm_lang($result)
{	
	global $language_adm, $cache_lang;
	
	echo '<select name="lang_adv">
	<option value="0">'. $language_adm['select_lang'] .'</option>';
	
	foreach($cache_lang as $lang)
	{
		$code_lang = stripslashes(htmlspecialchars($lang['code_lang'], ENT_QUOTES));
		$name_lang = stripslashes(htmlspecialchars($lang['name_lang'], ENT_QUOTES));
		
		?>
		<option value="<?php echo $code_lang; ?>" <?php if(!empty($result) && $result == $code_lang) echo 'selected'; ?> ><?php echo ucfirst($name_lang); ?></option>
		<?php
	}

	echo '</select>';	
}

////////////////////////////////
//Displaying value for research "around me"
////////////////////////////////

function display_adm_value_around($value_around)
{	
	global $language_adm;
	
	echo '<select name="value_around">';
	
	?>
	<option value="metric" <?php if(isset($_POST['value_around']) && $_POST['value_around'] == 'metric') echo 'selected'; elseif(!isset($_POST['value_around']) && $value_around == 'metric') echo 'selected'; ?> >Km</option>';
	<option value="imperial" <?php if(isset($_POST['value_around']) && $_POST['value_around'] == 'imperial') echo 'selected'; elseif(!isset($_POST['value_around']) && $value_around == 'imperial') echo 'selected'; ?> >Miles</option>';
	<?php
				
	echo '</select>';			
}

//////////////////////////////////////////////////
//Display digital options
//////////////////////////////////////////////////

function display_digital($cat, $array, $e)
{
	global $language_adm, $cache_cat_opts, $cache_lang, $infos;
	
	foreach($array as $row)
	{
		$id_cat = (int) $row['id_cat'];
		$id_cat_opt_digital = (int) $row['id_cat_opt'];
		
		$name_cat_opt = '';
		$unit_cat_opt = '';
		$optional = '';
		
		foreach($cache_cat_opts as $opt)
		{
			$id_cat_opt = (int) $opt['id_cat_opt'];
			$type_cat_opt = (int) $opt['type_cat_opt'];
			
			if($type_cat_opt != 1)
			continue;
			
			if($id_cat_opt_digital == $id_cat_opt)
			{
				foreach($cache_lang as $l => $row)
				{
					$code_lang = stripslashes(htmlspecialchars($row['code_lang'], ENT_QUOTES));
					
					if(isset($opt['name_cat_opt_'. $code_lang]))
					$name_cat_opt = stripslashes(htmlspecialchars($opt['name_cat_opt_'. $code_lang], ENT_QUOTES));
					
					if(isset($opt['unit_cat_opt_'. $code_lang]))
					$unit_cat_opt = stripslashes(htmlspecialchars($opt['unit_cat_opt_'. $code_lang], ENT_QUOTES));
					
					break;
				}
				
				$optional = (int) $opt['optional'];
				
				break;
			}
		}
		
		if(isset($_POST['digital_'. $id_cat_opt_digital]))
		$value = stripslashes(htmlspecialchars($_POST['digital_'.$id_cat_opt_digital], ENT_QUOTES));
		
		elseif(isset($infos['digital_'. $id_cat_opt_digital]))
		$value = stripslashes(htmlspecialchars($infos['digital_'. $id_cat_opt_digital], ENT_QUOTES));

		else $value = '';
		
		if($id_cat == $cat)
		{
			?>
			<div class="flex-container div-form">
				<p class="title"><?php echo $name_cat_opt; ?></p>
				<div>
				<?php
					
					if(isset($e[$id_cat_opt_digital]))
					echo '<input type="text" id="digital_'. $id_cat_opt_digital .'" class="form_error" name="digital_'. $id_cat_opt_digital .'" placeholder="'. $name_cat_opt .'" value="'. $value .'" />';
					
					else echo '<input type="text" id="digital_'. $id_cat_opt_digital .'" name="digital_'. $id_cat_opt_digital .'" placeholder="'. $name_cat_opt .'" value="'. $value .'" />';
				
					if(!empty($unit_cat_opt) && $optional == 1)
					echo '<span><span>'. $unit_cat_opt .'</span> <span>'. $language_adm['page_opts_crea_dig_opt'] .'</span></span>';
					
					elseif(!empty($unit_cat_opt))
					echo '<span>'. $unit_cat_opt .'</span>';
					
					elseif($optional == 1)
					echo '<span>'. $language_adm['page_opts_crea_dig_opt'] .'</span>';
				?>
				</div>
			</div>
			<?php
		}
	}
}

//////////////////////////////////////////////////
//Display data options
//////////////////////////////////////////////////

function display_data($cat, $array, $e)
{
	global $language_adm, $cache_val_data, $cache_cat_opts, $cache_lang, $infos;
	
	$i = 1;
	
	foreach ($array as $row)
	{ 
		$id_cat = (int) $row['id_cat'];
		$id_cat_opt_data = (int) $row['id_cat_opt'];
		
		foreach($cache_cat_opts as $opt)
		{
			$id_cat_opt = (int) $opt['id_cat_opt'];
			$type_cat_opt = (int) $opt['type_cat_opt'];
			
			if($type_cat_opt != 2)
			continue;
			
			if($id_cat_opt_data == $id_cat_opt)
			{
				foreach($cache_lang as $row)
				{
					$code_lang = stripslashes(htmlspecialchars($row['code_lang'], ENT_QUOTES));
					
					$name_cat_opt = '';
						
					if(isset($opt['name_cat_opt_'. $code_lang]))
					$name_cat_opt = stripslashes(htmlspecialchars($opt['name_cat_opt_'. $code_lang], ENT_QUOTES));
					
					break;
				}
				
				$optional = (int) $opt['optional'];
				
				break;
			}
		}
		
		if($id_cat == $cat)
		{
			$error = (isset($e[$id_cat_opt_data])) ? ' form_error' : '';
			
			?>
			<div class="flex-container div-form">
				<p class="title"><?php echo $name_cat_opt; ?></p>
				<div>
				<?php
					
					echo '<select id="options_child_'. $i .'" name="data_'. $id_cat_opt_data .'" class="'. $error .'" onchange="DisplayOptionsChild('. $i .');">
					<option value="0">'. $name_cat_opt .'</option>';
					
					foreach($cache_val_data as $row)
					{
						$id_val_data = (int) $row['id_val_data'];
						$id_opt_data = (int) $row['id_cat_opt'];
						
						foreach($cache_lang as $v)
						{
							$code_lang = stripslashes(htmlspecialchars($v['code_lang'], ENT_QUOTES));
							
							$val_data = '';
							
							if(isset($row['val_data_'. $code_lang]))
							$val_data = stripslashes(htmlspecialchars($row['val_data_'. $code_lang], ENT_QUOTES));
							
							break;
						}
						
						if($id_cat_opt_data == $id_opt_data)
						{
							if(isset($_POST['data_'. $id_cat_opt_data]) && $_POST['data_'. $id_cat_opt_data] == $id_val_data)
							echo '<option value="'. $_POST['data_'. $id_cat_opt_data] .'" selected>'. $val_data .'</option>';
							
							elseif(!isset($_POST[$id_cat_opt_data]) && isset($infos['data_'. $id_cat_opt_data]) && $infos['data_'. $id_cat_opt_data] == $id_val_data)
							echo '<option value="'. $infos['data_'. $id_cat_opt_data] .'" selected>'. $val_data .'</option>';
							
							else echo '<option value="'. $id_val_data .'">'. $val_data .'</option>';
						}
					}
					
					echo '</select>';
				
					if($optional == 1)
					echo '<span class="info">'. $language_adm['page_opts_crea_dig_opt'] .'</span>';
					
				?>
				</div>
			</div>
			<?php
			
			echo '<div id="options_child_form_'. $i .'">';
			
			if(isset($_POST['data_'. $id_cat_opt_data]))
			display_child_data($_POST['data_'. $id_cat_opt_data], $cache_cat_opts, $e);
			
			elseif(isset($infos['data_'. $id_cat_opt_data]))
			display_child_data($infos['data_'. $id_cat_opt_data], $cache_cat_opts, $e);
			
			echo '</div>';
		}
		
		$i++;
	}
}

//////////////////////////////////////////////////
//Display data child options
//////////////////////////////////////////////////

function display_child_data($id_val, $array, $e)
{
	global $language_adm, $cache_val_data, $cache_lang, $cache_cat_opts, $infos;
	
	$id_val_data = 0;
	
	foreach($cache_val_data as $v)
	{
		$id_val_data = (int) $v['id_val_data'];
		$par_cat_opt = (int) $v['par_cat_opt'];
		
		if($id_val_data != $id_val)
		continue;
		
		else break;
	}
	
	if($id_val_data == $id_val)
	{
		foreach($array as $row)
		{
			$id_cat_opt = (int) $row['id_cat_opt'];
			$child_cat_opt = (int) $row['child_cat_opt'];
			$type_cat_opt = (int) $row['type_cat_opt'];
			
			if($type_cat_opt != 2 || $child_cat_opt != 1 || $par_cat_opt != $id_cat_opt)
			continue;
			
			foreach($cache_lang as $v)
			{
				$code_lang = stripslashes(htmlspecialchars($v['code_lang'], ENT_QUOTES));
				
				$name_cat_opt = '';
				
				if(isset($row['name_cat_opt_'. $code_lang]))
				$name_cat_opt = stripslashes(htmlspecialchars($row['name_cat_opt_'. $code_lang], ENT_QUOTES));
				
				break;
			}
			
			$optional = (int) $row['optional'];
			
			$error = (isset($e[$id_cat_opt])) ? ' form_error' : '';
			
			?>
			<div class="flex-container div-form">
				<p class="title"><?php echo $name_cat_opt; ?></p>
				<div>
				<?php
					
					echo '<select id="options_child_'. $id_cat_opt .'" name="data_'. $id_cat_opt .'" class="'. $error .'" onchange="DisplayOptionsChild('. $id_cat_opt .');">
					<option value="0">'. $name_cat_opt .'</option>';
			
					foreach($cache_val_data as $row)
					{
						$id_val_data = (int) $row['id_val_data'];
						$id_opt_data = (int) $row['id_cat_opt'];
						
						foreach($cache_lang as $v)
						{
							$code_lang = stripslashes(htmlspecialchars($v['code_lang'], ENT_QUOTES));
							
							$val_data = '';
								
							if(isset($row['val_data_'. $code_lang]))
							$val_data = stripslashes(htmlspecialchars($row['val_data_'. $code_lang], ENT_QUOTES));
							
							break;
						}
						
						if($id_opt_data == $id_cat_opt)
						{
							if(isset($_POST['data_'. $id_cat_opt]) && $_POST['data_'. $id_cat_opt] == $id_val_data)
							echo '<option value="'. $_POST['data_'. $id_cat_opt] .'" selected>'. $val_data .'</option>';
							
							elseif(!isset($_POST['data_'. $id_cat_opt]) && isset($infos['data_'. $id_cat_opt]) && $infos['data_'. $id_cat_opt] == $id_val_data)
							echo '<option value="'. $infos['data_'. $id_cat_opt] .'" selected>'. $val_data .'</option>';
							
							else echo '<option value="'. $id_val_data .'">'. $val_data .'</option>';
						}
					}
					
					echo '</select>';
				
					if($optional == 1)
					echo '<span class="info">'. $language_adm['page_opts_crea_dig_opt'] .'</span>';
					
				?>
				</div>
			</div>
			<?php
				
			echo '<div id="options_child_form_'. $id_cat_opt .'">';

			if(isset($_POST['data_'. $id_cat_opt]))
			display_child_data($_POST['data_'. $id_cat_opt], $cache_cat_opts, $e);
			
			elseif(isset($infos['data_'. $id_cat_opt]))
			display_child_data($infos['data_'. $id_cat_opt], $cache_cat_opts, $e);
			
			echo '</div>';
		}
	}
}

//////////////////////////////////////////////////
//Display checkbox options
//////////////////////////////////////////////////

function display_checkbox($cat, $array, $e)
{
	global $language_adm, $cache_val_check, $cache_cat_opts, $cache_lang, $infos;
	
	foreach($array as $row)
	{ 
		$id_sea_check = (int) $row['id_sea_check'];
		$id_cat = (int) $row['id_cat'];
		$id_cat_opt_check = (int) $row['id_cat_opt'];
		
		foreach($cache_cat_opts as $opt)
		{
			$id_cat_opt = (int) $opt['id_cat_opt'];
			$type_cat_opt = (int) $opt['type_cat_opt'];
			
			if($type_cat_opt != 3)
			continue;
			
			if($id_cat_opt_check == $id_cat_opt)
			{
				foreach($cache_lang as $row)
				{
					$code_lang = stripslashes(htmlspecialchars($row['code_lang'], ENT_QUOTES));
					
					$name_cat_opt = '';
						
					if(isset($opt['name_cat_opt_'. $code_lang]))
					$name_cat_opt = stripslashes(htmlspecialchars($opt['name_cat_opt_'. $code_lang], ENT_QUOTES));
					
					break;
				}
				
				break;
			}
		}
		
		if($id_cat == $cat)
		{
			echo '<div class="flex-container div-form title"><p class="title">'. $name_cat_opt .'</p></div>';
			
			$i = 0;
			
			foreach($cache_val_check as $row)
			{
				$id_val_check = (int) $row['id_val_check'];
				$id_opt_check = (int) $row['id_cat_opt'];
				
				foreach($cache_lang as $v)
				{
					$code_lang = stripslashes(htmlspecialchars($v['code_lang'], ENT_QUOTES));
					
					$val_check = '';
						
					if(isset($row['val_check_'. $code_lang]))
					$val_check = stripslashes(htmlspecialchars($row['val_check_'. $code_lang], ENT_QUOTES));
					
					break;
				}
				
				if($id_cat_opt_check == $id_opt_check)
				{
					echo '<div class="flex-container div-form">';
					
					if(isset($_POST['check_'. $id_val_check]) && $_POST['check_'. $id_val_check] == $id_val_check)
					{
					?> 
						<label class="title" for="<?php echo 'check_'. $id_val_check; ?>"><?php echo ucfirst($val_check); ?></label>
						<div class="label">
							<input type="checkbox" id="<?php echo 'check_'. $id_val_check; ?>" name="<?php echo 'check_'. $id_val_check; ?>" value="<?php echo $_POST['check_'. $id_val_check]; ?>" checked />
							<label for="<?php echo 'check_'. $id_val_check; ?>"></label>
						</div>
					<?php
					}
					elseif(count($_POST) == 0 && isset($infos['check_'. $id_val_check]) && $infos['check_'. $id_val_check] == $id_val_check)
					{
					?> 
						<label class="title" for="<?php echo 'check_'. $id_val_check; ?>"><?php echo ucfirst($val_check); ?></label>
						<div class="label">
							<input type="checkbox" id="<?php echo 'check_'. $id_val_check; ?>" name="<?php echo 'check_'. $id_val_check; ?>" value="<?php echo $infos['check_'. $id_val_check]; ?>" checked />
							<label for="<?php echo 'check_'. $id_val_check; ?>"></label>
						</div>
					<?php
					}
					else
					{
					?>
						<label class="title" for="<?php echo 'check_'. $id_val_check; ?>"><?php echo ucfirst($val_check); ?></label>
						<div class="label">
							<input type="checkbox" id="<?php echo 'check_'. $id_val_check; ?>" name="<?php echo 'check_'. $id_val_check; ?>" value="<?php echo $id_val_check; ?>" />
							<label for="<?php echo 'check_'. $id_val_check; ?>"></label>
						</div>
					<?php
					}
					
					echo '</div>';
					
					$i++;
				}
			}
		}
	}
}

//////////////////////////////////////////////////
//Display fields
//////////////////////////////////////////////////

function display_fields($cat, $array, $e)
{
	global $language_adm, $cache_val_check, $cache_cat_opts, $cache_lang, $infos;
	
	foreach($array as $v)
	{	
		$id_field = (int) $v['id_field'];
		$id_cat = (int) $v['id_cat'];
		$type = (int) $v['type'];
		$optional = $v['optional'];
		
		foreach($cache_lang as $row)
		{
			$code_lang = stripslashes(htmlspecialchars($row['code_lang'], ENT_QUOTES));
			
			$name_field = '';
			
			if(isset($v['name_field_'. $code_lang]))
			$name_field = stripslashes(htmlspecialchars($v['name_field_'. $code_lang], ENT_QUOTES));
			
			break;
		}	
		
		$placehoder = ($type != 3) ? $name_field : 'http://';
		
		if($id_cat == $cat)
		{
		?>
		<div class="flex-container div-form">
			<p class="title"><?php echo $name_field; ?></p>
			<div>
				<input type="text" id="<?php echo 'field_'. $id_field; ?>" class="input_long <?php if(isset($e[$id_field])) echo 'form_error'; ?>" name="<?php echo 'field_'. $id_field; ?>" placeholder="<?php echo $placehoder; ?>" value="<?php if(isset($_POST['field_'. $id_field])) echo htmlspecialchars($_POST['field_'. $id_field]); elseif(!empty($infos['field_'. $id_field])) echo htmlspecialchars($infos['field_'. $id_field]); ?>" /> <?php if($optional == 0) echo '<span class="info">'. $language_adm['page_opts_crea_dig_opt'] .'</span>'; ?>
			</div>
		</div>
		<?php
		}
	}
}

//////////////////////////////////////////////////
//Display years
//////////////////////////////////////////////////

function display_years($name, $date_start, $nb_years_end)
{
	$selected = '';
	
	echo '<select name="'. $name .'">';
	
	for($i=$date_start - $nb_years_end; $i<=$date_start; $i++)
	{
		$selected = (isset($_GET[$name]) && $_GET[$name] == $i) ? ' selected' : ((!isset($_GET[$name]) && $i == $date_start) ? ' selected' : '');
		
		echo '<option value="'. $i .'"'. $selected .'>'. $i .'</option>'; 
	}
	
	echo '</select>';
}