include_once("./common.inc.php");
$strFileName = "cott_new.php";
$CountryId = getParam('CountryId');
$CottCityId = getParam('CottCityId');
if ( '' != $CountryId && $CountryId > 0)
{
if ( '' != $CottCityId && $CottCityId > 0) {
$strTitle = "Новые поступления на сайте apartment.su " . $arrCountrySecondName["$CountryId"] . " " . $arrCitySecondName["$CottCityId"] . ". Аренда домов, вилл, коттеджей, апартаментов, квартир";
}
else {
$strTitle = "Новые поступления на сайте apartment.su " . $arrCountrySecondName["$CountryId"] . ". Аренда домов, вилл, коттеджей, апартаментов, квартир";
}
}
else
{
$strTitle = "Новые поступления, новые предложения по аренде вилл, коттеджей, апартаментов и домов";
$strTit = "Новые поступления";
}
$strKeywords = $strTitle . " " . $arrCityName["$CottCityId"] . " " . $arrCountryName["$CountryId"];
$strDescription = $strTitle;
$strAlt = $strTitle;
include_once("./header.inc.php");
?>
|
 |
Новые поступления |
// Pagination
$lngRecordsPerPage = 10;
$lngPagesLimit = 11;
$strWhere = " where boolCottageStatus='1' and newArrivalDay > 0";
if ( '' != $CountryId && $CountryId > 0)
{
$strWhere = $strWhere . " and CountryId ='" . $CountryId . "' ";
}
if ( '' != $CottCityId && $CottCityId > 0)
{
$strWhere = $strWhere . " and LocationId ='" . $CottCityId . "' ";
}
$sql = "select count(tblcottagerent.id) as count_id from tblcottagerent $strWhere ";
$paginationInfo = getPaginationCatalog ($sql, $strFileName, $lngRecordsPerPage, $lngPagesLimit, array("lngCityId" => $lngCityId, "CountryId" => $CountryId, "CottCityId" => $CottCityId ) );
//! Pagination
$sql = "select * from tblcottagerent $strWhere order by curCottagePrice asc limit $paginationInfo[lngStartLimit], $lngRecordsPerPage ";
$result = query($sql);
if ( '' != $CountryId ) { ?>Страны : Все страны | | Все города
if ( count ($arrTableCity["$CountryId"]) > 0 ) {
$boolContinue = 1;
echo '';
while ($boolContinue) {
echo '';
for ($j = 1; $j <= 4; $j++)
{
list($ingCity, $arrNameCities ) = each($arrTableCity["$CountryId"]);
echo '';
}
echo '
';
}
echo '
';
}
}
else {
$boolContinue = 1;
echo '';
while ($boolContinue)
{
echo "";
for ($j = 1; $j <= 4; $j++)
{
list($ingCountries, $NameCountries) = each($arrTableCountry);
echo '';
}
echo '
';
}
echo '
';
}
if (num_rows($result) == 0) {
/*?>
*/
?>
}
?>
if ("1 " != $paginationInfo["strPagination"]) { ?>
}
require_once 'Mobile_Detect.php';
$detect = new Mobile_Detect;
if($detect->isMobile() && !$detect->isTablet()) {
$i = 1;
while($row = fetch_array($result)) {
?>
| include ("./table.inc.php");?> |
}
} else {
?>
$c = 0;
while($row = fetch_array($result)) {
?>
| include ("./table.inc.php");?> |
|
$c++;
if($c%2 == 0) echo '
';
}
?>
}
?>
if ("1 " != $paginationInfo["strPagination"]) { ?>
}
// информация о стране
/*
if ( '' != $CountryId && $CountryId > 0) {
$strTableName = "tblinfocountry";
//$strWhere = "where lngNewsType IN (" . join(",", array_keys($arrNewsType)) . ") and dteNewsAdd < NOW() ";
$strWhere = "where CountryId ='" . $CountryId . "' and boolArticleStatus = '1' ";
$sql = "select * from $strTableName $strWhere order by dteArticleAdd";
$resultInfo = query ($sql);
if ( mysql_num_rows($resultInfo) > 0 ) { ?>
| - полезная информация о стране : |
 |
while ($rowInfo = mysql_fetch_assoc ( $resultInfo) ) { ?>
} ?>
|
}
} */
include_once("./footer.inc.php");
?>