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

$arrQueryInfo = getAllParams();
$CountryId = $arrQueryInfo['CountryId'];
if($CountryId == "") $CountryId = 0;
$CottCityId = $arrQueryInfo['CottCityId'];
$TypeId = $arrQueryInfo['TypeId'];

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

	if (!empty($TypeId) && is_numeric($TypeId)) {
	// с $CottCityId
		if (!empty($CottCityId) && is_numeric($CottCityId)) {
			$strTitle = $arrCottageRentTypeMnAAA["$TypeId"] . " " . $arrCitySecondName["$CottCityId"] . ". Аренда " . $arrCottageRentTypeMnIdA["$TypeId"] . " " . $arrCountrySecondName["$CountryId"] . ". " . $arrCottageRentTypeMnA["$TypeId"] . " " . $arrCountrySecondName["$CountryId"];
			$strKeywords =	$arrCottageRentTypeMn["$TypeId"] . " " .	$arrCountrySecondName["$CountryId"] . " " . $arrCountryName["$CountryId"] . " " . $arrCityName["$CottCityId"] . " " . $arrCitySecondName["$CottCityId"];
		}
	// без $CottCityId
		else {
		/*	$strTitle = $arrCottageRentTypeMnAAA["$TypeId"] . " " . $arrCountrySecondName["$CountryId"] . ". Аренда " . $arrCottageRentTypeMnIdA[$TypeId] . " " . $arrCountrySecondName["$CountryId"] . ". " . $arrCottageRentTypeMnA["$TypeId"] . " для отдыха " . $arrCountrySecondName["$CountryId"]; */
			$strTitle = $arrCottageRentTypeMnAAA["$TypeId"] . " " . $arrCountrySecondName["$CountryId"] . ". Аренда " . $arrCottageRentTypeMnIdA["$TypeId"] . " " . $arrCountrySecondName["$CountryId"] . ". " . $arrCottageRentTypeMnAAAA["$TypeId"] . " " . $arrCountrySecondName["$CountryId"] . " в аренду";
			$strKeywords =	$arrCottageRentTypeMn["$TypeId"] . " " .	$arrCountrySecondName["$CountryId"] . " " . $arrCountryName["$CountryId"];
		} 
	}
	//  $TypeId нет
	else {
	// c $CottCityId
		if (!empty($CottCityId) && is_numeric($CottCityId)) {
			$strTitle = "Недвижимость " . $arrCountrySecondName["$CountryId"] . " " . $arrCitySecondName["$CottCityId"]  . ". Виллы коттеджи дома квартиры " . $arrCitySecondName["$CottCityId"] ;
			$strKeywords =	$arrCountrySecondName["$CountryId"] . " " . $arrCountryName["$CountryId"] . " " . $arrCityName["$CottCityId"] . " " . $arrCitySecondName["$CottCityId"];			
		}
	//	без $CottCityId
		else {
			$strTitle = "Недвижимость " . $arrCountrySecondName["$CountryId"] . ". Аренда вилл коттеджей домов квартир " . $arrCountrySecondName["$CountryId"];
			$strKeywords =	$arrCountrySecondName["$CountryId"] . " " . $arrCountryName["$CountryId"];			
		}	
	}	
}

else {
// $CountryId нет 
	if (!empty($TypeId) && is_numeric($TypeId)) {
		$strTitle = "Аренда " . $arrCottageRentTypeMnIdA["$TypeId"] . ", аренда " . $arrCottageRentTypeMnPad["$TypeId"] . ". " . $arrCottageRentTypeMnA["$TypeId"] . " в аренду";
		$strKeywords =	$arrCottageRentTypeMn["$TypeId"];		
	}
	else {
		$strTitle =  'Аренда вилл, аренда домов, аренда коттеджей, аренда апартаментов, аренда квартир, аренда недвижимости';
		$strKeywords =	"виллы коттеджи дома квартиры апартаменты";
	}
}


$strKeywords = $strKeywords . " аренда недвижимость в аренду";
$strDescription = 'Аренда в Европе - агентство недвижимости. Аренда и продажа недвижимости: виллы, коттеджи, дома, квартиры, апартаменты. ' . $strTitle;

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

	if (eregi("^[0-9]+$", $TypeId) && ($TypeId > 0)) {

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

		if ( mysql_num_rows($resultContent) > 0 ) { 
			$rowContent = mysql_fetch_assoc ($resultContent); 
		}
	}
} */
/*
//поиск по ID
if (!empty($arrQueryInfo['id_search'])) {
	$id = $arrQueryInfo['id_search'];
	if ( eregi("^[0-9]+$", $id) && ($id > 0) )
	{
		$sql = "select COUNT(*) from tblcottagerent, tblagency where tblcottagerent.id='" . $id . "' and tblagency.id=tblcottagerent.AgencyId and tblcottagerent.boolCottageStatus='1' and tblcottagerent.boolPrivateCatalog='0'";
		$result = query($sql);
		$row = mysql_fetch_row($result);
		if ($row[0] == 1)
		{
			$Loc = "Location: /cottage_rent.php?id={$id}";
			header($Loc);
		}
	}
}

$strTitle  = getStrZag();
$strKeywords = $strTitle;
$strDescription = $strTitle;
$strAlt = $strTitle;
$findme    = ' Аренда';
$pos1 = stripos($strTitle, $findme);
$strTitle2 = substr("$strTitle", 0, $pos1);
$CottCityId = $arrQueryInfo['CottCityId'];
if ( "" != $CottCityId ) {
$strTitle2 = $strTitle2 . " " . $arrCitySecondName[$CottCityId];
}
*/
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 = "";

		$CountryId = $arrQueryInfo['CountryId'];
		$CottCityId = $arrQueryInfo['CottCityId'];

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

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

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

		if (!empty($arrQueryInfo['lngCottagePlaces']) && is_numeric($arrQueryInfo['lngCottagePlaces'])) {
			$strWhere .= " AND lngCottagePlaces>='" . $arrQueryInfo['lngCottagePlaces'] . "' ";
		}
		
		if (!empty($arrQueryInfo['lngCottagePlacesTo']) && is_numeric($arrQueryInfo['lngCottagePlacesTo'])) {
			$strWhere .= " AND lngCottagePlaces<='" . $arrQueryInfo['lngCottagePlacesTo'] . "' ";
		}

		if (!empty($arrQueryInfo['lngCottageBedrooms']) && is_numeric($arrQueryInfo['lngCottageBedrooms'])) {
			$strWhere .= " AND lngCottageBedrooms>='" . $arrQueryInfo['lngCottageBedrooms'] . "' ";
		}
		
		if (!empty($arrQueryInfo['lngCottageBedroomsTo']) && is_numeric($arrQueryInfo['lngCottageBedroomsTo'])) {
			$strWhere .= " AND lngCottageBedrooms<='" . $arrQueryInfo['lngCottageBedroomsTo'] . "' ";
		}

		if (!empty($arrQueryInfo['lngPrice']) && is_numeric($arrQueryInfo['lngPrice'])) {
			$strWhere .= " AND curCottagePrice>='" . $arrQueryInfo['lngPrice'] . "' AND CurrencyId=1";
		}
		
		if (!empty($arrQueryInfo['lngPriceTo']) && is_numeric($arrQueryInfo['lngPriceTo'])) {
			$strWhere .= " AND curCottagePrice<='" . $arrQueryInfo['lngPriceTo'] . "' AND CurrencyId=1";
		}
		else {
			$strWhere .= " AND curCottagePrice<='100000' AND CurrencyId=1";		
		}

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

		if (!empty($arrQueryInfo['dblCottageHouseSquare']) && is_numeric($arrQueryInfo['dblCottageHouseSquare'])) {
			$strWhere .= " AND ldblCottageHouseSquare>='" . $arrQueryInfo['dblCottageHouseSquare'] . "' ";
		}
		
		if (!empty($arrQueryInfo['IngPool']) && is_numeric($arrQueryInfo['IngPool'])) {
			$strWhere .= " AND IngPool='" . $arrQueryInfo['IngPool'] . "' ";
		}
		
		if ($strWhere != "")
			$strWhere .= " AND boolPrivateCatalog='0' ";

//if ( $strTitle != "" ) {echo "<h1 style='color: #FF0000; display: inline; FONT-WEIGHT: bolder;'>$strTitle2</h1>";} else {echo "Поиск";} 

/*
if ( "" != $rowContent['strTitle'] ) {
	$strTitle = nl2br($rowContent['strTitle']);
//	$strTitle = ereg_replace ("&", "&amp;", $strTitle);
	$strTitle = ereg_replace ("/>", ">", $strTitle);
	echo "<div class='content'>" . $strTitle . "</div>";
} */

		if (!empty($strWhere)) {
			// Pagination
			$lngRecordsPerPage = 8;
			$lngPagesLimit = 11;

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

			$paginationInfo = getPaginationCatalog ($sql, "partner/ext_search.php", $lngRecordsPerPage, $lngPagesLimit, array("CountryId" => $arrQueryInfo['CountryId'], "TypeId" => $arrQueryInfo['TypeId'], "CottCityId"=>$arrQueryInfo['CottCityId'], "IngPool"=>$arrQueryInfo['IngPool'], "NoteId"=>$arrQueryInfo['NoteId']) );
			//! Pagination

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

			$result = query($sql);

			if ( (num_rows($result) == 0) || $arrQueryInfo['id_search'] ) {
			
				$countrySql = "select * from tblcountries WHERE boolCountryStatus='1' ORDER BY lngViewPriority, strCountryName";
	
	$countryResult = mysql_query ($countrySql, $db);

	while ( $row = mysql_fetch_assoc($countryResult) )
	{
		$arrCountries[$row['id']] = $row;
	}

 
if ( '' != $CountryId ) { ?><p class="text2"><b>Страны :</b> <a class="a_common" href="">Все страны</a> | <font color='red'></font> | <a class="a_common" href='?CountryId='><b>Все города</b></a></p><? }


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

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

			for ($j = 1; $j <= 4; $j++)
			{
				list($ingCountriesName, $arrNameCountries) = each($arrCountries);
				echo '<td width="25%" class="td_citymenu">';
				 
			 if ($arrNameCountries["strCountryName"] != "")  {
			 
			 		if ($arrQueryInfo['TypeId'] != "") {
			 				echo " <a href='" . $strFileName . "?CountryId=" . $arrNameCountries["id"]."&TypeId=".$arrQueryInfo['TypeId']."&NoteId=".$arrQueryInfo['NoteId']."&IngPool=" . $arrQueryInfo['IngPool'] . "'>" . $arrCottageRentTypeMnAAA[$arrQueryInfo['TypeId']] . " " .	$arrNameCountries["strCountrySecondName"] . "</a>";
					}
					else {		 
			  				echo " <a href='" . $strFileName . "?CountryId=" . $arrNameCountries["id"]."&TypeId=".$arrQueryInfo['TypeId']."&NoteId=".$arrQueryInfo['NoteId']."&IngPool=" . $arrQueryInfo['IngPool'] . "'>" .	$arrNameCountries["strCountryName"] . "</a>";
					} 
			 }

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

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

		$citySql = "select * from tblcities where boolShowRent='1' and lngCountryId ='" . $CountryId . "' order by strCitySecondName ASC";
	
	$cityResult = mysql_query ($citySql, $db);
	
	while ( $row = mysql_fetch_assoc($cityResult) )
	{
		$arrCities[$row['id']] = $row;
	}	

	if ( count ($arrCities) > 0 )
	{ 
		$boolContinue = 1;
?>
		<table border="0" width="99%" cellspacing="1"  cellpadding="0"  >
<?
	while ($boolContinue)
	{
?>
		  <tr>
<?
			for ($j = 1; $j <= 4; $j++)
			{
				list($ingCityName, $arrNameCities ) = each($arrCities);
?>
             <td width="25%" class="td_citymenu"><? 
			 if ($arrNameCities["strCityName"] != "")  { 
             		if ($arrNameCities["id"] == $CottCityId)  { 
					echo " <font style='color:red; font-family: verdana; font-size: 10px; padding-left:1px;'> " .	$arrNameCities["strCityName"] . "</font>"; 
					}
					else {  echo " <a href='" . $strFileName . "?CountryId=" . $CountryId."&CottCityId=".$arrNameCities['id'] . "'> " .	$arrNameCities['strCityName'] . "</a>";						
					}		
             } 
			 else { $boolContinue = 0;} ?></td>
<?
			}
?>
          </tr>
<?
	}
?>
        </table>
<?
	}
}
?>
<br><div style="color: #FF0000; font-size:11px; font-family:Verdana; font-weight:700">Не нашли то, что искали? <br><br>
<?
if ( "" != $CountryId ) { ?>
<a style="color: #006600; text-decoration:underline;" href="http://www.apartment.su/ext_search.php?CountryId=">>> посмотрите все предложения  <<</a><br><br>
<?
}

else { ?>
<a style="color: #006600; text-decoration:underline;" href="http://www.apartment.su/ext_search.php">>> посмотрите все наши предложения <<</a><br><br>
<?
}
?>
<br><br> <a href="http://www.apartment.su/contact.php#zakaz" target="_blank" style="text-decoration:underline; color: #006600">>> или заполните заявку online <<</a><br><br><br></div>
<?
			} else {
//	$countrySql = "select * from tblcountries where boolShowRent=1 order by strCountryName ASC";
	$countrySql = "select * from tblcountries WHERE boolCountryStatus='1' ORDER BY lngViewPriority, strCountryName";
	
	$countryResult = mysql_query ($countrySql, $db);

	while ( $row = mysql_fetch_assoc($countryResult) )
	{
		$arrCountries[$row['id']] = $row;
	}

 
if ( '' != $CountryId ) { ?><p class="text2"><b>Страны :</b>  <a class="a_common" href=''>Все страны</a> | <font color='red'></font> | <a class="a_common" href='?CountryId=&lngCityId=&TypeId=&NoteId='><b>Все города</b></a></p><? }


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

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

			for ($j = 1; $j <= 4; $j++)
			{
				list($ingCountriesName, $arrNameCountries) = each($arrCountries);
				echo '<td width="25%" class="td_citymenu">';
				 
			 if ($arrNameCountries["strCountryName"] != "")  {
			 
			 		if ($arrQueryInfo['TypeId'] != "") {
			 				echo " <a href='" . $strFileName . "?CountryId=" . $arrNameCountries["id"]."&TypeId=".$arrQueryInfo['TypeId']."&NoteId=".$arrQueryInfo['NoteId']."&IngPool=" . $arrQueryInfo['IngPool'] . "'>" . $arrCottageRentTypeMnAAA[$arrQueryInfo['TypeId']] . " " .	$arrNameCountries["strCountrySecondName"] . "</a>";
					}
					else {		 
			  				echo " <a href='" . $strFileName . "?CountryId=" . $arrNameCountries["id"]."&TypeId=".$arrQueryInfo['TypeId']."&NoteId=".$arrQueryInfo['NoteId']."&IngPool=" . $arrQueryInfo['IngPool'] . "'>" .	$arrNameCountries["strCountryName"] . "</a>";
					} 
			 }

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

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

		$citySql = "select * from tblcities where boolShowRent='1' and lngCountryId ='" . $CountryId . "' order by strCitySecondName ASC";
	
	$cityResult = mysql_query ($citySql, $db);
	
	while ( $row = mysql_fetch_assoc($cityResult) )
	{
		$arrCities[$row['id']] = $row;
	}	

	if ( count ($arrCities) > 0 )
	{ 
		$boolContinue = 1;
?>
		<table border="0" width="99%" cellspacing="1"  cellpadding="0"  >
<?
	while ($boolContinue)
	{
?>
		  <tr>
<?
			for ($j = 1; $j <= 4; $j++)
			{
				list($ingCityName, $arrNameCities ) = each($arrCities);
?>
             <td width="25%" class="td_citymenu"><? 
			 if ($arrNameCities["strCityName"] != "")  { 
             		if ($arrNameCities["id"] == $CottCityId)  { 
					echo " <font style='color:red; font-family: verdana; font-size: 10px; padding-left:1px;'> " .	$arrNameCities["strCityName"] . "</font>"; 
					}
					else {  echo " <a href='" . $strFileName . "?CountryId=" . $CountryId."&CottCityId=".$arrNameCities['id']."&TypeId=".$arrQueryInfo['TypeId']."&NoteId=". $arrQueryInfo['NoteId'] . "&IngPool=" . $arrQueryInfo['IngPool'] . "'> " .	$arrNameCities['strCityName'] . "</a>";						
					}		
             } 
			 else { $boolContinue = 0;} ?></td>
<?
			}
?>
          </tr>
<?
	}
?>
        </table>
<?
	}
}
?>
<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>
<?
}

/*
if ( "" != $rowContent['strShortContent'] ) {
	$strShortContent = nl2br($rowContent['strShortContent']);
//	$strShortContent = ereg_replace ("&", "&amp;", $strShortContent);
	$strShortContent = ereg_replace ("/>", ">", $strShortContent);	
	echo "<div class='content'>" . $strShortContent . "<br>";
} */

	$i = 1;
	while ( $row = fetch_array($result) ) {
		if ($i%2 == 1) {
?>
              <table border="0" width="100%" cellspacing="4" cellpadding="0">
                <tr>
<?
		}
?>
             <td class="td_commontext" width="50%" valign="top">
<? include ("../table.inc5.php");?>			               
            </td>
<?
		if ($i%2 == 0) {
?>
        </tr>
      </table>
<?
		}
		$i++;
	}

	if ($i%2 == 0) {
?>
        <td width="50%">&nbsp;</td>
        </tr>
      </table>
<?
	}
if ("<a class='cen'>1</a>&nbsp;" != $paginationInfo["strPagination"]) { ?>
<table border="0">
              <tr>
                <td class="td_pages"></td>
              </tr>
</table>
<?
} 
	}
		} 
/*
if ( "" != $rowContent['strTitle'] ) {
	$strTitle = nl2br($rowContent['strTitle']);
//	$strTitle = ereg_replace ("&", "&amp;", $strTitle);
	$strTitle = ereg_replace ("/>", ">", $strTitle);
	echo "<div class='content'>" . $strTitle . "</div>";
}

if ( "" != $rowContent['strShortContent'] ) {
	$strShortContent = nl2br($rowContent['strShortContent']);
//	$strShortContent = ereg_replace ("&", "&amp;", $strShortContent);
	$strShortContent = ereg_replace ("/>", ">", $strShortContent);	
	echo "<div class='content'>" . $strShortContent . "<br>";
}
	
if ( "" != $rowContent['strContent'] ) {

	if ( $rowContent['boolUseJavaEditor'] == "0" ) {
		$strContent = nl2br($rowContent['strContent']);
	}
	else {
		$strContent = $rowContent['strContent'];
	}
	
//	$strContent = ereg_replace ("&", "&amp;", $strContent);
	$strContent = ereg_replace ("/>", ">", $strContent);
	echo "<p class='content'>" . $strContent . "</div>";
}	
*/
/*if ("" != $arrcontent2["$CountryId"]["$TypeId"] && "" == $arrQueryInfo['lngPage']) {
	$strShortContent = nl2br($arrcontent2["$CountryId"]["$TypeId"]);
	echo "<br><div class='content'>" . $strShortContent . "</div>"; 
}*/
/*
if (eregi("^[0-9]+$", $TypeId) && ($TypeId > 0)) {

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

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

if ( "" != $rowContent['strShortContent'] ) {
	$strShortContent = nl2br($rowContent['strShortContent']);
	echo "<br><div class='content'>" . $strShortContent . "<br>";
} */
include_once("../footer.inc.php");
?>