<?
include_once("./common.inc.php");
$strFileName = "catalogue.php";

$arrQueryInfo = getAllParams();
$Country = $arrQueryInfo['Country'];
if($Country == "") $Country = 0;
$CountryId = $Country;
$City = $arrQueryInfo['City'];
$Type = $arrQueryInfo['Type'];
if ($Type == "") $Type = "0";
$Town = $arrQueryInfo['Town'];
if ($Town == "") $Town = "0";
$strTit3 = "Аренда недвижимости";

if($City != '') {
	$sqlCity = "SELECT `strContentRegion` FROM `tblcities` WHERE `id` = '" . $City . "'";
	$resultCity = query ($sqlCity);
	if(mysql_num_rows($resultCity) > 0) $rowCity = mysql_fetch_row($resultCity);
}

/*
if ($arrQueryInfo['boolSearch'] == "") $arrQueryInfo['boolSearch'] = "0";
if ($arrQueryInfo['lngPage'] > 1) $arrQueryInfo['boolSearch'] = "1";
*/
// контент
/*
if ($arrQueryInfo['boolSearch'] != "1") {

	if (preg_match("/^[0-9]+$/i", $Type) && ($Type > 0)) {

		if ( $Country =="") {
			$Country =="0";
		}
		
		$strWhere = "where CountryId = '" . $Country . "' and ingTipeCottage = '" . $Type . "' and boolStatus = '1'";
		$sql = "select * from tblcontent $strWhere";
		$resultContent = query ($sql);

		if ( mysql_num_rows($resultContent) > 0 ) { 
			$rowContent = mysql_fetch_assoc ($resultContent); 
		}
	}
} */

if (!empty($Country) && is_numeric($Country)) {

	if (!empty($Type) && is_numeric($Type)) {
	// с $City
		if (!empty($City) && is_numeric($City)) {

			// первый h1
			$strTit = $arrCottageRentTypeMnAAA["$Type"] . " " . $arrCountrySecondName["$Country"] . ", " . $arrCitySecondName["$City"] . " | " . $arrCottageRentTypeMnAAAA["$Type"] . " в аренду, " . $arrCountryName["$Country"] . ", " . $arrCityName["$City"];

			// тайтл
			$strTitle = $arrCottageRentTypeMnAAA["$Type"] . " " . $arrCountrySecondName["$Country"] . ", " . $arrCitySecondName["$City"] . ". Аренда " . $arrCottageRentTypeMnbbbb["$Type"] . " для отдыха " . $arrCityName["$City"] . ", " . $arrCountryName["$Country"];

			// второй h1
			$strTit2 = $arrCottageRentTypeMnAAA["$Type"] . " " . $arrCitySecondName["$City"];

			// под банером
			$strTit3 = "Аренда " . $arrCottageRentTypeMnPadej["$Type"] . " " . $arrCountrySecondName["$Country"];			
			$strKeywords =	$arrCottageRentTypeMn["$Type"] . " " .	$arrCountrySecondName["$Country"] . " " . $arrCountryName["$Country"] . " " . $arrCityName["$City"] . " " . $arrCitySecondName["$City"];
		}
	// без $City
		else {
			$strTit = "Аренда " . $arrCottageRentTypeMnbbbb["$Type"] . " " . $arrCountrySecondName["$Country"] . ". " . $arrCottageRentTypeMnAAA["$Type"] . " в аренду " . $arrCountryName["$Country"];
			$strTitle = "Аренда " . $arrCottageRentTypeMnPadej["$Type"] . " " . $arrCountrySecondName["$Country"] . ", каталог недвижимости, жилья. " . $arrCottageRentTypeAAAA["$Type"] . " " . $arrCountrySecondName["$Country"] . " в аренду";
			$strTit2 = "Аренда " . $arrCountrySecondName["$Country"];
			$strKeywords =	$arrCottageRentTypeMn["$Type"] . " " .	$arrCountrySecondName["$Country"] . " " . $arrCountryName["$Country"];
		} 
	}
	//  $Type нет
	else {
	// c $City
		if (!empty($City) && is_numeric($City)) {
			$strTitle = $arrCountryName["$Country"] . ", " . $arrCityName["$City"]  . ". Виллы, дома, коттеджи, апартаменты, квартиры в аренду " . $arrCitySecondName["$City"];
			$strTit2 = $strTitle;
			$strKeywords =	$arrCountrySecondName["$Country"] . " " . $arrCountryName["$Country"] . " " . $arrCityName["$City"] . " " . $arrCitySecondName["$City"];			
		}
	//	без $City
		else {
			$strTitle = "Аренда " . $arrCountrySecondName["$Country"] . ", недвижимость " . $arrCountrySecondName["$Country"] . " | виллы, дома, коттеджи, апартаменты, квартиры в аренду";
			$strTit2 = $strTitle;
			$strKeywords =	$arrCountrySecondName["$Country"];			
		}	
	}	
}

else {
// $Country нет 
	if (!empty($Type) && is_numeric($Type)) {
		$strTitle = "Аренда " . $arrCottageRentTypeMnId["$Type"] . ". " .  $arrCottageRentTypeMnA["$Type"] . ", жилье, невижимость в аренду";
		$strTit = "Аренда " . $arrCottageRentTypeMnId["$Type"] . ". Недвижимость в аренду";
		$strKeywords =	$strTit;		
	}
	else {
		$strTitle =  'Аренда жилья, недвижимости. Виллы, дома, коттеджи, квартиры в аренду';
		$strTit = "Аренда вилл, домов, коттеджей, квартир. Недвижимость в аренду";
		$strKeywords =	$strTit;
	}
}

if($titlecontent2["$Country"]["$Type"] != '') {
	$strTitle = $titlecontent2["$Country"]["$Type"];
}

if($Town != 0) {
	$strTitle =  $arrTownName["$Town"] . ", " . $arrCountryName["$Country"] . ". Аренда виллы, дома, коттеджа, апартаментов, квартиры";
	$strTit2 = $arrTownName["$Town"] . ' аренда вилл, домов, коттеджей, апартаментов, квартир';
}
$strKeywords = $strKeywords . " аренда недвижимость в аренду";
$strDescription = 'Агентство недвижимости «Аренда в Европе» предлагает сервис по аренде, продаже недвижимости: виллы, дома, коттеджи, квартиры, апартаменты | ' . $strTit2;

include_once("./header.inc.php");
?>
<table border="0" width="100%" cellpadding="0" cellspacing="0">
	<tr>
		<td class="td_commontext_razdel" width="100%"></td>
	</tr>
	<tr>
		<td bgcolor="#B6B6B6"><img border="0" src="img/line_center.gif" width="16" height="3" alt=""></td>
	</tr>
	<tr>
		<td><h1 style='color: #FF0000;'></h1></td>
    </tr>
</table>
<?
$strWhere = "";

		if (!empty($Town) && is_numeric($Town)) {
			$strWhere .= " AND TownId='" . $Town . "' ";
		}

		if (!empty($City) && is_numeric($City)) {
			$strWhere .= " AND LocationId='" . $City . "' ";
		}

		if (!empty($arrQueryInfo['Country']) && is_numeric($arrQueryInfo['Country'])) {
			$strWhere .= " AND CountryId='" . $arrQueryInfo['Country'] . "' ";
		}

		if (!empty($arrQueryInfo['Type']) && is_numeric($arrQueryInfo['Type'])) {
			$strWhere .= " AND TypeId='" . $arrQueryInfo['Type'] . "' ";
		}

/*		if (!empty($arrQueryInfo['NoteId']) && is_numeric($arrQueryInfo['NoteId'])) {
			$strWhere .= " AND NoteId='" . $arrQueryInfo['NoteId'] . "' ";
		}
		
		if (!empty($arrQueryInfo['IngPool']) && is_numeric($arrQueryInfo['IngPool'])) {
			$strWhere .= " AND IngPool='" . $arrQueryInfo['IngPool'] . "' ";
		}*/
		
		if ($strWhere != "")
			$strWhere .= " AND boolPrivateCatalog='0' ";


// Pagination
$lngRecordsPerPage = 10;
$lngPagesLimit = 11;

$sql = "select count(tblcottagerent.id) as count_id from tblcottagerent WHERE boolCottageStatus='1' $strWhere ";

$paginationInfo = getPaginationCatalog ($sql, $strFileName, $lngRecordsPerPage, $lngPagesLimit, array("Country" => $arrQueryInfo['Country'], "Type" => $arrQueryInfo['Type'], "City"=>$arrQueryInfo['City'], "Town"=>$arrQueryInfo['Town']) );
//! Pagination

$sql = "SELECT * FROM tblcottagerent WHERE boolCottageStatus='1' $strWhere ORDER BY curCottagePrice ASC LIMIT $paginationInfo[lngStartLimit], $lngRecordsPerPage ";

$result = query($sql);

if ( '' != $Country ) { ?><p class="text2"><b>Страны :</b> <a class="a_common" href='https://www.apartment.su/'>Все страны</a> | <font color='red'></font> | <a class="a_common" href='https://www.apartment.su/?Country=&Type='><b>Все города</b></a></p><? 

	if ( count ($arrTableCity["$Country"]) > 0 ) {
	 
		$boolContinue = 1;
		echo '<table border="0" width="99%" cellspacing="1"  cellpadding="0">';

		while ($boolContinue) {
			echo '<tr>';
	
			for ($j = 1; $j <= 4; $j++)
			{
				list($ingCity, $arrNameCities ) = each($arrTableCity["$Country"]);
				echo '<td width="25%" class="td_citymenu">';

				 if ($arrNameCities != "")  { 
						if ($ingCity == $City)  { 
						echo " <font style='color:red; font-size: 12px; padding-left:1px;'> " .	$arrNameCities . "</font>"; 
						}
						else {  echo " <a href='https://www.apartment.su/" . $strFileName . "?Country=" . $Country."&City=".$ingCity."&Type=".$arrQueryInfo['Type']."'> " .	$arrNameCities . "</a>";						
						}		
				 } 
				 else { $boolContinue = 0;} 
				 echo '</td>';

			}
	
			echo '</tr>';
	
		}
		
		echo '</table>';
	}
}

else {
		$boolContinue = 1;
		echo '<table border="0" width="100%" cellspacing="1"  cellpadding="0">';

	while ($boolContinue)
	{
		echo "<tr>";

			for ($j = 1; $j <= 4; $j++)
			{
				list($ingCountries, $NameCountries) = each($arrTableCountry);
				echo '<td width="25%" class="td_citymenu">';
				 
			 if ($NameCountries != "")  {
			 
  				echo " <a href='https://www.apartment.su/" . $strFileName . "?Country=" . $ingCountries."&Type=".$arrQueryInfo['Type']."'>" .	$arrCountryName["$ingCountries"] . "</a>";
			 }

			 else { $boolContinue = 0;} echo '</td>';
			}
	echo '</tr>';
	}
echo '</table>';
}


if (num_rows($result) == 0) { ?>
<br><div style="color: #FF0000; font-weight:700">Не нашли то, что искали? <br><br>
<?
	if ( "" != $Country ) { ?>
		<a style="color: #006600; text-decoration:underline;" href="https://www.apartment.su/?Country=">>> Вы можете посмотреть все предложения  <<</a><br><br><?
	}

	else { ?>
		<a style="color: #006600; text-decoration:underline;" href="https://www.apartment.su/">>> Вы можете посмотреть все наши предложения <<</a><br><br><?
	} ?>
 <? /*<br><br> <a href="https://www.apartment.su/contact.php#zakaz" target="_blank" style="text-decoration:underline; color: #006600">>> или заполните заявку в свободной форме online <<</a><br><br><br> */ ?></div> <?
}

else {

?><script type="text/javascript" src="javascript/preview.js"></script>
<script type="text/javascript" src="javascript/loader.js"></script><DIV id="preview_div" style="DISPLAY: none; Z-INDEX: 110; POSITION: absolute"></DIV>
<?
if ("<a class='cen'>1</a>&nbsp;" != $paginationInfo["strPagination"]) { ?>
<table border="0"><tr><td class="td_pages"></td></tr></table>
<?
}


require_once 'Mobile_Detect.php';
$detect = new Mobile_Detect;

if($detect->isMobile() && !$detect->isTablet()) {

  $i = 1;
  while($row = fetch_array($result)) {

    ?>

    <table border="0" width="100%" cellspacing="4" cellpadding="0">
    	<tr>
    		<td class="td_commontext" width="100%" valign="top"><? include ("./table.inc7.php");?></td>
    	</tr>
    </table>

    <?

  }

} else {

  ?>

  <style type="text/css">
  <!--
  .desc_icons img {
  }

  .desc_icons td {
    padding-right: 10px;
  }
  .desc_icons span {
    font-size: 14px;
  }

  -->
  </style>

  <table>
    <tr>

  <?

  $c = 0;
  while($row = fetch_array($result)) {

    ?>

    <td valign="top">
      <table border="0" width="50%" cellspacing="4" cellpadding="0">
      	<tr>
      		<td class="td_commontext" width="100%" valign="top"><? include ("./table.inc7.php");?></td>
      	</tr>
      </table>

    </td>

    <?

    $c++;
    if($c%2 == 0) echo '</tr><tr>';

  }

  ?>

    </tr>
  </table>

  <?

}

if ("<a class='cen'>1</a>&nbsp;" != $paginationInfo["strPagination"]) { ?>
<table border="0"><tr><td class="td_pages"></td></tr></table><?
} 
}
/*
if ($arrQueryInfo['boolSearch'] != "1" && "" != $arrcontent3["$Country"]["$Type"]) {
	$strContent = nl2br($arrcontent3["$Country"]["$Type"]); 
	echo "<p class='content'>" . $strContent . "</div>";
} */
/*	
if ($arrQueryInfo['boolSearch'] != "1" && "" != $arrcontent3["$Country"]["$Type"]) {

	if ( $rowContent['boolUseJavaEditor'] == "0" ) {
		$strContent = nl2br($arrcontent3["$Country"]["$Type"]);
	}
	else {
		$strContent = $arrcontent3["$Country"]["$Type"];
	}
	
//	$strContent = ereg_replace ("&", "&amp;", $strContent);
//	$strContent = ereg_replace ("/>", ">", $strContent);
	echo "<p class='content'>" . $strContent . "</div>";
} */  	


// контент из базы
/*$sql = "select * from tblcontent where CountryId = '" . $Country . "' and ingTipeCottage = '" . $Type . "' and boolStatus = '1'";
$resultContent = query ($sql);
if ( mysql_num_rows($resultContent) > 0 ) { 
	$rowContent = mysql_fetch_assoc ($resultContent); 
}
if ( "" != $rowContent['strShortContent'] ) echo "<br><div class='content'>" . $rowContent['strShortContent'] . "<br>";*/


// регионы
/*if ($rowCity[0] != '') {
	echo "<br><div class='content'>" . $rowCity[0] . "</div><br>";
}	
elseif ("" != $arrcontent2["$Country"]["$Type"] && "" == $arrQueryInfo['lngPage']) {
	$strShortContent = nl2br($arrcontent2["$Country"]["$Type"]);
	echo "<br><div class='content'>" . $strShortContent . "</div>"; 
}*/


if ($rowCity[0] != '') {
	echo "<div class='content'>" . $rowCity[0] . "</div><br>";
}	

// контент
//if ("" != $arrcontent2["$Country"]["$Type"] && "" == $arrQueryInfo['lngPage']) echo "<div class='content'>" . $arrcontent2["$Country"]["$Type"] . "</div>"; 
if ("" != $arrcontent2["$Country"]["$Type"]) echo "<div class='content'>" . $arrcontent2["$Country"]["$Type"] . "</div>"; 

include_once("./footer.inc.php");