<?php
include_once('site_id.php');
include_once('admin/include/initialize.inc.php');


$page_data = $Db->row("SELECT * FROM page_properties WHERE page_lang_id = ?", array($site_lang));


// İlan çekimi
$sql = "SELECT properties.*, property_texts.*, property_types.type_name, country_list.country_name AS country_name, city_list.city_name AS city_name, city_list.city_gps AS citygps, county_list.county_name AS county_name, currencies.curr_code AS curr_code, (SELECT SUM(hit_count) FROM hit_counter WHERE hit_counter.hit_page = property_id) AS hitstotal FROM properties LEFT JOIN property_texts ON property_texts.text_property_id = properties.property_id AND text_lang_id = :lang1 LEFT JOIN property_types ON property_types.type_type_id = properties.property_type AND type_lang_id = :lang2 LEFT JOIN country_list ON country_list.country_id = properties.property_country LEFT JOIN city_list ON city_list.city_id = properties.property_city LEFT JOIN county_list ON county_list.county_id = properties.property_county LEFT JOIN currencies ON currencies.curr_id = properties.property_currency WHERE properties.property_status = :stat1 AND (property_cross_show = :cross1 OR property_cross_show = :cross3) ";

$sqlcount_ = "SELECT property_id, property_lat, property_lon, property_front_photo FROM properties WHERE properties.property_status = :stat2 AND (properties.property_cross_show = :cross1 OR properties.property_cross_show = :cross3) ";

$prm['lang1']  = $site_lang;
$prm['lang2']  = $site_lang;
$prm['cross1'] = '1';
$prm['cross3'] = '3';
$prc['cross1'] = '1';
$prc['cross3'] = '3';
$prm['stat1']  = '2';
$prc['stat2']  = '2';
// İlan çekimi


// Filtreler
if (!empty($_GET)) {

unset($_SESSION['check_in']);
unset($_SESSION['check_out']);
unset($_SESSION['kapasite']);

if (isset($_GET['fiyat']) && !empty($_GET['fiyat'])) {

list($p_a, $p_b) = explode(' AND ', $_GET['fiyat']);

if ($kur == "1") {
$sql          .= " AND properties.property_dayprice_try BETWEEN :pria1 AND :pria2";
$sqlcount_    .= " AND properties.property_dayprice_try BETWEEN :prib1 AND :prib2";
}

if ($kur == "2") {
$sql          .= " AND properties.property_dayprice_usd BETWEEN :pria1 AND :pria2";
$sqlcount_    .= " AND properties.property_dayprice_usd BETWEEN :prib1 AND :prib2";
}

if ($kur == "3") {
$sql          .= " AND properties.property_dayprice_eur BETWEEN :pria1 AND :pria2";
$sqlcount_    .= " AND properties.property_dayprice_eur BETWEEN :prib1 AND :prib2";
}

if ($kur == "4") {
$sql          .= " AND properties.property_dayprice_gbp BETWEEN :pria1 AND :pria2";
$sqlcount_    .= " AND properties.property_dayprice_gbp BETWEEN :prib1 AND :prib2";
}

$prm['pria1']  = $p_a;
$prm['pria2']  = $p_b;
$prc['prib1']  = $p_a;
$prc['prib2']  = $p_b;

}

if (isset($_GET['kapasite']) && (!empty($_GET['kapasite'])) && $_GET['kapasite'] > 0) {
$sql        .= " AND property_capacity >= :kap_ ";
$sqlcount_  .= " AND property_capacity >= :kap_ ";
$prm['kap_'] = $_GET['kapasite'];
$prc['kap_'] = $_GET['kapasite'];
}

if (isset($_GET['oda']) && (!empty($_GET['oda'])) && $_GET['oda'] > 0) {
$sql        .= " AND property_rooms = :oda_ ";
$sqlcount_  .= " AND property_rooms = :oda_ ";
$prm['oda_'] = $_GET['oda'];
$prc['oda_'] = $_GET['oda'];
}

if (isset($_GET['yatak']) && (!empty($_GET['yatak'])) && $_GET['yatak'] > 0) {
$sql        .= " AND property_beds >= :yat_ ";
$sqlcount_  .= " AND property_beds >= :yat_ ";
$prm['yat_'] = $_GET['yatak'];
$prc['yat_'] = $_GET['yatak'];
}

if (isset($_GET['tip']) && (!empty($_GET['tip'])) && $_GET['tip'] > 0) {
$sql        .= " AND property_type = :tip_ ";
$sqlcount_  .= " AND property_type = :tip_ ";
$prm['tip_'] = $_GET['tip'];
$prc['tip_'] = $_GET['tip'];
}

if (isset($_GET['tarz']) && (!empty($_GET['tarz'])) && $_GET['tarz'] > 0) {
$tarzx       = ""; foreach ($_GET['tarz'] as $value) { $tarzx .= $value.","; } $tarzz = rtrim($tarzx, ",");
$sql        .= " AND property_classes IN (".$tarzz.") ";
$sqlcount_  .= " AND property_classes IN (".$tarzz.") ";
}

if ((isset($_GET['bolge']) && !empty($_GET['bolge']) && $_GET['bolge'] > 0) && (!isset($_GET['semt']) && !empty($_GET['semt']) OR $_GET['semt'] == 0 )) {
$sql        .= " AND property_county = :bol_ ";
$sqlcount_  .= " AND property_county = :bol_ ";
$prm['bol_'] = $_GET['bolge'];
$prc['bol_'] = $_GET['bolge'];

$get_city    = $Db->row("SELECT county_city_id FROM county_list WHERE county_id = ?", array($_GET['bolge']));
$get_loc     = $Db->row("SELECT city_gps FROM city_list WHERE city_id = ?", array($get_city['county_city_id']));
$zoom        = 8;
$geoloc      = $get_loc['city_gps'];
}

if ((isset($_GET['bolge']) && !empty($_GET['bolge']) && $_GET['bolge'] > 0) && (isset($_GET['semt']) && !empty($_GET['semt']) OR $_GET['semt'] > 0)) {
$sql        .= " AND property_district = :sem_ ";
$sqlcount_  .= " AND property_district = :sem_ ";
$prm['sem_'] = $_GET['semt'];
$prc['sem_'] = $_GET['semt'];

$get_city    = $Db->row("SELECT district_city_id FROM district_list WHERE district_id = ?", array($_GET['semt']));
$get_loc     = $Db->row("SELECT city_gps FROM city_list WHERE city_id = ?", array($get_city['district_city_id']));
$zoom        = 8;
$geoloc      = $get_loc['city_gps'];
}

}
// Filtreler


// Group ek
$sql       .= " GROUP BY properties.property_id ";
$sqlcount_ .= " GROUP BY properties.property_id ";
// Group ek


// Sıralama
if (empty($_GET['siralama'])) {
$sql .= " ORDER BY property_id ASC ";
}

if (!empty($_GET['siralama']) && $_GET['siralama'] == "enson") {
$sql .= " ORDER BY property_id DESC ";
}

if (!empty($_GET['siralama']) && $_GET['siralama'] == "ucuzdan" ) {
if ($kur == "1") { $sql .= " ORDER BY property_dayprice_try ASC "; }
if ($kur == "2") { $sql .= " ORDER BY property_dayprice_usd ASC "; }
if ($kur == "3") { $sql .= " ORDER BY property_dayprice_eur ASC "; }
if ($kur == "4") { $sql .= " ORDER BY property_dayprice_gbp ASC "; }
}

if (!empty($_GET['siralama']) && $_GET['siralama'] == "pahalidan" ) {
if ($kur == "1") { $sql .= " ORDER BY property_dayprice_try DESC "; }
if ($kur == "2") { $sql .= " ORDER BY property_dayprice_usd DESC "; }
if ($kur == "3") { $sql .= " ORDER BY property_dayprice_eur DESC "; }
if ($kur == "4") { $sql .= " ORDER BY property_dayprice_gbp DESC "; }
}

if (!empty($_GET['siralama']) && $_GET['siralama'] == "populer") {
$sql .= " ORDER BY hitstotal DESC ";
}

if (!empty($_GET['siralama']) && $_GET['siralama'] == "indirimli") {
$sql .= " ORDER BY property_isDiscounted DESC ";
}
// Sıralama


// Harita ortalama
if (empty($geoloc)) { $zoom = 8; $geoloc = "37.041816, 27.433661"; }
// Harita ortalama


// Harita sayaç
$total_result = $Db->query($sqlcount_,$prc);
// Harita sayaç


// Paging
$per_page    = 12;
$start       = 0;
$end         = $per_page;
$total_pages = ceil(count($total_result) / $per_page);

if (!empty($_GET['sayfa'])) {

if (isset($_GET['sayfa']) && is_numeric($_GET['sayfa'])) {

if (empty($_GET['sayfa'])) { $_GET['sayfa'] = 1; }
$show_page = $_GET['sayfa'];

if(!is_numeric($show_page)) { $show_page = 0; }

if ($show_page > 0 && $show_page <= $total_pages) {
$start = ($show_page - 1) * $per_page;
$end   = $start + $per_page;
} else {
$start = 0;
$end   = $per_page;
}

}

} else {

$show_page = 0;

}

if (!is_numeric($show_page)) { $show_page = 0; }

$num_rows     = ceil(count($total_result));
$page_amount2 = ceil($num_rows / $per_page);
$page_amount  = $page_amount2 - 1;
$page         = $show_page;

$sql         .= " LIMIT " . $start . "," . $per_page;
// Paging


// İlanları çek
$listings = $Db->query($sql,$prm);
// İlanları çek


// Gelen tarih varmı
if (!empty($_GET['check_in']))   { $_SESSION["check_in"]   = $_GET['check_in']; }
if (!empty($_GET['check_out']))  { $_SESSION["check_out"]  = $_GET['check_out']; }
if (!empty($_GET['kapasite']))   { $_SESSION["kapasite"]   = $_GET['kapasite']; }
// Gelen tarih varmı


### Hitcounter
$pagename = "Türkçe İlanlar";
include_once("hit_counter.php");
### Hitcounter

?>


<!DOCTYPE html>
<html lang="tr">

<head>

<meta charset="utf-8">
<title><?php echo $page_data['page_title']; ?></title>
<meta name="description" content="<?php echo $page_data['page_description']; ?>">
<meta name="keywords" content="<?php echo $page_data['page_keywords']; ?>">
<meta name="viewport" content="width=device-width, initial-scale=1.0">

<?php include_once("head_meta.php"); ?>

<style>.form-control[disabled], .form-control[readonly], fieldset[disabled] {background-color:#fff;}</style>

</head>

<body>

<?php include_once("header.php"); ?>

<section>
<div id="map-canvas" class="hidden-xs"></div>
</section>

<section class="slice animate-hover-slide">
<div class="w-section inverse blog-grid">
<div class="container">
<div class="row">


<!-- Sol Bölüm -->
<div class="col-md-8">

<div class="row">

<?php if (!empty($listings)) { foreach ($listings AS $listing) {

// gelen tarih varsa fiyat hesaplama işlemi
if ((!empty($_GET['check_in'])) && (!empty($_GET['check_out']))) {

$fdate1 = date("Y-m-d", strtotime($_GET['check_in']));
$fdate2 = date("Y-m-d", strtotime($_GET['check_out']));

$price_list = $Db->query("SELECT * FROM property_prices WHERE price_date >= ? AND price_date < ? AND price_property_id = ? ", array($fdate1,$fdate2,$listing['property_id']));

$aryRange = array();
$total    = 0;
$conditionError = "";
while ($fdate1 < $fdate2) {
array_push($aryRange,$fdate1);
$tm = strtotime(date("Y-m-d", strtotime($fdate1)) . " +1 day");
$fdate1 = date('Y-m-d',$tm);
}

$dStart = new DateTime($_GET['check_in']);
$dEnd   = new DateTime($_GET['check_out']);
$dDiff  = $dStart->diff($dEnd);

foreach($aryRange as $day) {
if(!empty($price_list)) {
foreach($price_list as $price){

if($price['price_date'] == $day) {

if($price['price_condition'] == 1) {
$total = $total + $price['price_value'];
} else {
$conditionError = $conditionError . ",".$day;
}

}

}
}
}

if(count($aryRange) > count($price_list)) {

$missingTotal = (count($aryRange)- count($price_list)) * $listing['property_price'];
$reelTotal = $missingTotal + $total;

if ($kur == "4") {
if ($listing['property_currency'] == "4") { $reelTotal = $reelTotal; }
if ($listing['property_currency'] == "1") { $reelTotal = $reelTotal / $currency['rate_buy_gbp']; }
if ($listing['property_currency'] == "2") { $reelTotal = $reelTotal * $currency['rate_buy_usd'] / $currency['rate_buy_gbp']; }
if ($listing['property_currency'] == "3") { $reelTotal = $reelTotal * $currency['rate_buy_eur'] / $currency['rate_buy_gbp']; }
}

elseif ($kur == "2") {
if ($listing['property_currency'] == "4") { $reelTotal = $reelTotal * $currency['rate_buy_gbp'] / $currency['rate_buy_usd']; }
if ($listing['property_currency'] == "1") { $reelTotal = $reelTotal / $currency['rate_buy_usd']; }
if ($listing['property_currency'] == "2") { $reelTotal = $reelTotal; }
if ($listing['property_currency'] == "3") { $reelTotal = $reelTotal * $currency['rate_buy_eur'] / $currency['rate_buy_usd']; }
}

elseif ($kur == "3") {
if ($listing['property_currency'] == "4") { $reelTotal = $reelTotal * $currency['rate_buy_gbp'] / $currency['rate_buy_eur']; }
if ($listing['property_currency'] == "1") { $reelTotal = $reelTotal / $currency['rate_buy_eur']; }
if ($listing['property_currency'] == "2") { $reelTotal = $reelTotal * $currency['rate_buy_usd'] / $currency['rate_buy_eur']; }
if ($listing['property_currency'] == "3") { $reelTotal = $reelTotal; }
}

elseif ($kur == "1") {
if ($listing['property_currency'] == "4") { $reelTotal = $reelTotal * $currency['rate_buy_gbp']; }
if ($listing['property_currency'] == "1") { $reelTotal = $reelTotal; }
if ($listing['property_currency'] == "2") { $reelTotal = $reelTotal * $currency['rate_buy_usd']; }
if ($listing['property_currency'] == "3") { $reelTotal = $reelTotal * $currency['rate_buy_eur']; }
}

$genelToplam = $missingTotal + $total;
if(!empty($listing['property_week_discount'])) {
if(count($aryRange) > 6 && count($aryRange) < 29 ) {
$genelToplam = ($genelToplam / $listing['property_week_discount']) ;
}
}
if(!empty($listing['property_month_discount'])) {
if( count($aryRange) > 29 ) {
$genelToplam = ($genelToplam / $listing['property_month_discount']) ;
}
}

$selectedtotal = round($reelTotal);
}

else

{
if ($kur == "4") {
if ($listing['property_currency'] == "4") { $total = $total; }
if ($listing['property_currency'] == "1") { $total = $total / $currency['rate_buy_gbp']; }
if ($listing['property_currency'] == "2") { $total = $total * $currency['rate_buy_usd'] / $currency['rate_buy_gbp']; }
if ($listing['property_currency'] == "3") { $total = $total * $currency['rate_buy_eur'] / $currency['rate_buy_gbp']; }
}

elseif ($kur == "2") {
if ($listing['property_currency'] == "4") { $total = $total * $currency['rate_buy_gbp'] / $currency['rate_buy_usd']; }
if ($listing['property_currency'] == "1") { $total = $total / $currency['rate_buy_usd']; }
if ($listing['property_currency'] == "2") { $total = $total; }
if ($listing['property_currency'] == "3") { $total = $total * $currency['rate_buy_eur'] / $currency['rate_buy_usd']; }
}

elseif ($kur == "3") {
if ($listing['property_currency'] == "4") { $total = $total * $currency['rate_buy_gbp'] / $currency['rate_buy_eur']; }
if ($listing['property_currency'] == "1") { $total = $total / $currency['rate_buy_eur']; }
if ($listing['property_currency'] == "2") { $total = $total * $currency['rate_buy_usd'] / $currency['rate_buy_eur']; }
if ($listing['property_currency'] == "3") { $total = $total; }
}

elseif ($kur == "1") {
if ($listing['property_currency'] == "4") { $total = $total * $currency['rate_buy_gbp']; }
if ($listing['property_currency'] == "1") { $total = $total; }
if ($listing['property_currency'] == "2") { $total = $total * $currency['rate_buy_usd']; }
if ($listing['property_currency'] == "3") { $total = $total * $currency['rate_buy_eur']; }
}

if(!empty($listing['property_week_discount'])) {
if(count($aryRange) > 6 && count($aryRange) < 29 ) {
$total = ($total / $listing['property_week_discount']) ;
}
}
if(!empty($listing['property_month_discount'])) {
if( count($aryRange) > 29 ) {
$total = ($genelToplam / $listing['property_month_discount']) ;
}
}

$selectedtotal = round($total);
}

}
// gelen tarih varsa fiyat hesaplama işlemi


$file = IMAGE_PATH."properties/".$listing['property_id']."/".$listing['property_front_photo'];

if (file_exists($file)) {
$h_img = IMAGE_FOLDER."properties/".$listing['property_id']."/".$listing['property_front_photo'];
} else {
$h_img = IMAGE_FOLDER."no_photo.jpg";
}


?>

<div class="col-md-6">
<div class="w-box">
<figure>

<a href="<?php echo $selectedlang['lang_url']."/".$listing['text_slug']; ?>/" target="_blank">
<img src="<?php echo $h_img; ?>" class="img-responsive" alt="<?php echo $listing['text_name']; ?>">
<?php if (!empty($conditionError)) { echo '<span class="not_aval">'.$translate['trans_047'].'</span>'; } ?>
<?php if ($listing['property_isDiscounted'] == 2 && empty($conditionError)) { echo '<span class="date-over"><strong>'.$translate['trans_048'].'</strong></span>'; } ?>
</a>

<h2 data-toggle="tooltip" data-placement="bottom" title="<?php echo $listing['text_name']; ?>"><?php echo mb_substr($listing['text_name'], 0, 28,'UTF-8')." ..."; ?></h2>

<h5 class="font-size11"><?php echo $listing['country_name']." | ".$listing['city_name']." | ".$listing['county_name']; ?></h5>

<ul class="osman">
<li class="hamdi"><i class="nuri fa fa-home"></i> <small class="sule"><?php echo $listing['property_rooms']; ?> <span class="hidden-xs"><?php echo $translate['trans_049']; ?></span></small></li>
<li class="hamdi"><i class="nuri fa fa-user"></i> <small class="sule"><?php echo $listing['property_capacity']; ?> <span class="hidden-xs"><?php echo $translate['trans_050']; ?></span></small></li>
<li class="hamdi"><i class="nuri fa fa-bed"></i> <small class="sule"><?php echo $listing['property_beds']; ?> <span class="hidden-xs"><?php echo $translate['trans_051']; ?></span></small></li>
<li class="hamdi"><i class="nuri fa fa-bath"></i> <small class="sule"><?php echo $listing['property_baths']; ?> <span class="hidden-xs"><?php echo $translate['trans_052']; ?></span></small></li>
</ul>

<span class="w-footer">
<span class="pull-left jale">
<?php
if (!empty($conditionError)) { echo $translate['trans_047']; } else {
if (!empty($selectedtotal)) { echo number_format($selectedtotal * $listing['property_commission'])." ".strtoupper($kurcode)." / ".$dDiff->days.' <small class="displayinline">'.$translate['trans_053'].'</small>'; } else {
if ($kur == "1") { echo number_format($listing['property_dayprice_try'] * $listing['property_commission'])." ".strtoupper($kurcode)." / ".$translate['trans_071']." <small class='displayinline'>".$translate['trans_054']."</small>"; }
if ($kur == "2") { echo number_format($listing['property_dayprice_usd'] * $listing['property_commission'])." ".strtoupper($kurcode)." / ".$translate['trans_071']." <small class='displayinline'>".$translate['trans_054']."</small>"; }
if ($kur == "3") { echo number_format($listing['property_dayprice_eur'] * $listing['property_commission'])." ".strtoupper($kurcode)." / ".$translate['trans_071']." <small class='displayinline'>".$translate['trans_054']."</small>"; }
if ($kur == "4") { echo number_format($listing['property_dayprice_gbp'] * $listing['property_commission'])." ".strtoupper($kurcode)." / ".$translate['trans_071']." <small class='displayinline'>".$translate['trans_054']."</small>"; }
} }
?>
</span>
<a href="<?php echo $selectedlang['lang_url']."/".$listing['text_slug']; ?>/" class="btn btn-xs btn-two pull-right" target="_blank"><?php echo $translate['trans_055']; ?></a>
<span class="clearfix"></span>
</span>

</figure>
</div>
</div>

<?php } } else {

echo "<h4 class='sule'><div class='alert alert-danger' role='alert'>".$translate['trans_056']."</div></h4>"; } ?>

</div>

<div class=""><?php if (!empty($listings)) { pagingTR($urlsetted); } ?></div>

</div>
<!-- Sol Bölüm -->


<!-- Sağ Bölüm -->
<div class="col-md-4">


<div class="widget widget_X1">
<h4 class="widget-heading widget_X2"><?php echo $translate['trans_057']; ?></h4>

<form id="new_search" method="GET">

<div class="col-md-12">

<div class="row">

<div class="col-md-12">
<label><?php echo $translate['trans_058']; ?></label>
<select name="bolge" id="bolge" class="form-control input-lg">
<option value="0"><?php echo $translate['trans_070']; ?></option>
<?php if (!empty($city_list)) { foreach ($city_list as $city) { $coun_list = $Db->query("SELECT properties.property_county, county_list.county_name FROM properties LEFT JOIN county_list ON county_list.county_id = properties.property_county WHERE properties.property_county != ? AND properties.property_city = ? GROUP BY property_county ", array('0',$city['city_id'])); ?>
<optgroup label="<?php echo $city['city_name']; ?>">
<?php if (!empty($coun_list)) { foreach ($coun_list as $coun) { ?>
<option <?php if (!empty($_GET['bolge'])) { if ($coun['property_county'] == $_GET['bolge']) { echo 'selected="selected"'; } } ?> value="<?php echo $coun['property_county']; ?>"><?php echo $coun['county_name']; ?></option>
<?php } } ?>
</optgroup>
<?php } } ?>
</select>
</div>

</div>

<br>

<div class="row">

<div class="col-md-12">
<label><?php echo $translate['trans_058']; ?></label>
<select name="semt" id="semt" class="form-control input-lg">
<option value="0"><?php echo $translate['trans_070']; ?></option>
</select>
</div>

</div>

<br>

<div class="row">

<div class="col-md-6 col-xs-6">
<label><?php echo $translate['trans_020']; ?></label>
<input type="text" name="check_in" id="check_in" class="form-control input-lg" placeholder="<?php echo $translate['trans_020']; ?>" value="<?php if (!empty($_GET['check_in'])) { echo $_GET['check_in']; } ?>" readonly>
</div>

<div class="col-md-6 col-xs-6">
<label><?php echo $translate['trans_022']; ?></label>
<input type="text" name="check_out" id="check_out" class="form-control input-lg" placeholder="<?php echo $translate['trans_022']; ?>" value="<?php if (!empty($_GET['check_out'])) { echo $_GET['check_out']; } ?>" readonly>
</div>

</div>

<br>

<div class="row">

<div class="col-md-6 col-xs-6">
<label><?php echo $translate['trans_050']; ?></label>
<select name="kapasite" class="form-control input-lg">
<?php for ($x = 1; $x <= 20; $x++) { ?>
<option <?php if (!empty($_GET['kapasite'])) { if ($_GET['kapasite'] == $x) { echo 'selected=""selected'; } } ?> value="<?php echo $x; ?>"><?php echo $x; ?></option>
<?php } ?>
</select>
</div>

<div class="col-md-6 col-xs-6 margin-top23">
<button type="submit" id="submit_form" class="btn btn-three btn-lg pull-right"> <i class="fa fa-search"></i> <?php echo $translate['trans_060']; ?></button>
</div>

</div>

</div>

</form>

</div>


<form id="filter" method="GET">

<div class="widget widget_X1">
<h4 class="widget-heading widget_X2"><?php echo $translate['trans_061']; ?></h4>

<div class="col-md-12">

<div class="row">

<div class="col-md-12">
<select name="siralama" id="orderby" class="form-control input-lg">
<option <?php if (isset($_GET['siralama']) && (!empty($_GET['siralama']))) { if ($_GET['siralama'] == "") { echo 'selected="selected"'; } } ?> value=""><?php echo $translate['trans_070']; ?></option>
<option <?php if (isset($_GET['siralama']) && (!empty($_GET['siralama']))) { if ($_GET['siralama'] == "ucuzdan") { echo 'selected="selected"'; } } ?> value="ucuzdan"><?php echo $translate['trans_062']; ?></option>
<option <?php if (isset($_GET['siralama']) && (!empty($_GET['siralama']))) { if ($_GET['siralama'] == "pahalidan") { echo 'selected="selected"'; } } ?> value="pahalidan"><?php echo $translate['trans_063']; ?></option>
<option <?php if (isset($_GET['siralama']) && (!empty($_GET['siralama']))) { if ($_GET['siralama'] == "enson") { echo 'selected="selected"'; } } ?> value="enson"><?php echo $translate['trans_064']; ?></option>
<option <?php if (isset($_GET['siralama']) && (!empty($_GET['siralama']))) { if ($_GET['siralama'] == "populer") { echo 'selected="selected"'; } } ?> value="populer"><?php echo $translate['trans_065']; ?></option>
<option <?php if (isset($_GET['siralama']) && (!empty($_GET['siralama']))) { if ($_GET['siralama'] == "indirimli") { echo 'selected="selected"'; } } ?> value="indirimli"><?php echo $translate['trans_066']; ?></option>
</select>
</div>

</div>

</div>

</div>

<div class="widget widget_X1">
<h4 class="widget-heading widget_X2"><?php echo $translate['trans_067']; ?></h4>

<div class="col-md-12">

<div class="row">

<div class="col-md-12 col-xs-6">
<label><?php echo $translate['trans_049']; ?></label>
<select name="oda" class="form-control input-lg">
<option <?php if (isset($_GET['oda']) && (!empty($_GET['oda']))) { if ($_GET['oda'] == "") { echo 'selected="selected"'; } } ?> value=""><?php echo $translate['trans_059']; ?></option>
<?php for ($x = 1; $x <= 20; $x++) { ?>
<option <?php if (isset($_GET['oda']) && (!empty($_GET['oda']))) { if ($_GET['oda'] == $x) { echo 'selected="selected"'; } } ?> value="<?php echo $x; ?>"><?php echo $x; ?></option>
<?php } ?>
</select>

<br class="hidden-xs">

</div>

<div class="col-md-12 col-xs-6">
<label><?php echo $translate['trans_051']; ?></label>
<select name="yatak" class="form-control input-lg">
<option <?php if (isset($_GET['yatak']) && (!empty($_GET['yatak']))) { if ($_GET['yatak'] == "") { echo 'selected="selected"'; } } ?> value=""><?php echo $translate['trans_059']; ?></option>
<?php for ($x = 1; $x <= 20; $x++) { ?>
<option <?php if (isset($_GET['yatak']) && (!empty($_GET['yatak']))) { if ($_GET['yatak'] == $x) { echo 'selected="selected"'; } } ?> value="<?php echo $x; ?>"><?php echo $x; ?></option>
<?php } ?>
</select>

<br class="hidden-xs">

</div>

<div class="col-md-12 col-xs-6">
<label><?php echo $translate['trans_068']; ?></label>
<select name="tip" class="form-control input-lg">
<option <?php if (isset($_GET['tip']) && (!empty($_GET['tip']))) { if ($_GET['tip'] == "") { echo 'selected="selected"'; } } ?> value=""><?php echo $translate['trans_059']; ?></option>
<?php
$property_types = $Db->query("SELECT type_type_id,type_name FROM property_types WHERE type_lang_id = ?", array($site_lang));
if (!empty($property_types)) { foreach ($property_types as $type) {
?>
<option <?php if (isset($_GET['tip']) && (!empty($_GET['tip']))) { if ($_GET['tip'] == $type['type_type_id']) { echo 'selected="selected"'; } } ?> value="<?php echo $type['type_type_id']; ?>"><?php echo $type['type_name']; ?></option>
<?php } } ?>
</select>

<br class="hidden-xs">

</div>

<div class="col-md-12 col-xs-6">
<label><?php echo $translate['trans_163']; ?></label>
<div class="">
<?php
if (!empty($tarzz)) { $tarzz = explode(",", $tarzz); }
$property_classes = $Db->query("SELECT class_class_id,class_name FROM property_classes WHERE class_lang_id = ?", array($site_lang));
if (!empty($property_classes)) { foreach ($property_classes as $class) {
?>
<label class="checkbox">
<input <?php if( !empty($tarzz) && in_array($class['class_class_id'], $tarzz)) {echo 'checked="checked"';} ?> type="checkbox" name="tarz[]" value="<?php echo $class['class_class_id']; ?>"><?php echo $class['class_name']; ?>
</label>
<?php } } ?>
</div>

<br class="hidden-xs">

</div>

<div class="col-md-12 col-xs-6">
<label><?php echo $translate['trans_069']; ?></label>
<select name="fiyat" class="form-control input-lg">
<option <?php if (isset($_GET['fiyat']) && $_GET['fiyat'] == "0 AND 25000")    { echo 'selected="selected"';} ?> value="0 AND 25000"><?php echo $translate['trans_059']; ?></option>
<option <?php if (isset($_GET['fiyat']) && $_GET['fiyat'] == "0 AND 300")      { echo 'selected="selected"';} ?> value="0 AND 300">0-300</option>
<option <?php if (isset($_GET['fiyat']) && $_GET['fiyat'] == "300 AND 500")    { echo 'selected="selected"';} ?> value="300 AND 500">300-500</option>
<option <?php if (isset($_GET['fiyat']) && $_GET['fiyat'] == "500 AND 750")    { echo 'selected="selected"';} ?> value="500 AND 750">500-750</option>
<option <?php if (isset($_GET['fiyat']) && $_GET['fiyat'] == "750 AND 1000")   { echo 'selected="selected"';} ?> value="750 AND 1000">750-1000</option>
<option <?php if (isset($_GET['fiyat']) && $_GET['fiyat'] == "1000 AND 25000") { echo 'selected="selected"';} ?> value="1000 AND 25000">1000+</option>
</select>

<br class="hidden-xs">

</div>

<div class="col-md-12 col-xs-6 margin-top23">
<button type="submit" id="submit_filter" class="btn btn-three btn-lg pull-right btn-block"><i class="fa fa-search"></i> <?php echo $translate['trans_072']; ?></button>
</div>

</div>

</div>

</div>

<input name="bolge" type="hidden" value="<?php if (isset($_GET['bolge']) && (!empty($_GET['bolge']))) { echo $_GET['bolge']; } ?>">
<input name="semt" type="hidden" value="<?php if (isset($_GET['semt']) && (!empty($_GET['semt']))) { echo $_GET['semt']; } ?>">
<input name="check_in" type="hidden" value="<?php if (isset($_GET['check_in']) && (!empty($_GET['check_in']))) { echo $_GET['check_in']; } ?>">
<input name="check_out" type="hidden" value="<?php if (isset($_GET['check_out']) && (!empty($_GET['check_out']))) { echo $_GET['check_out']; } ?>">
<input name="kapasite" type="hidden" value="<?php if (isset($_GET['kapasite']) && (!empty($_GET['kapasite']))) { echo $_GET['kapasite']; } ?>">

</form>

<?php include_once("widget_call_now.php"); ?>

</div>
<!-- Sağ Bölüm -->


</div>
</div>
</div>
</section>

<?php include_once("footer.php"); ?>

<?php include_once("footer_scripts.php"); ?>

<script src="https://maps.googleapis.com/maps/api/js?key=<?php echo $sitesettings['site_google_maps_key']; ?>"></script>
<script src="<?php echo SITE_URL ;?>js/markerclusterer.js"></script>
<script src="<?php echo SITE_URL;?>ilanlar.js"></script>

<script>
var markers = [
<?php
$x       = 1;
$len     = count($total_result);
foreach ($total_result as $loc) {
if (!empty($loc['property_lat']) && !empty($loc['property_lon'])) {
$file_m  = IMAGE_PATH."properties/".$loc['property_id']."/".$loc['property_front_photo'];
if (file_exists($file_m)) {
$h_img_m = IMAGE_FOLDER."properties/".$loc['property_id']."/".$loc['property_front_photo'];
} else {
$h_img_m = IMAGE_FOLDER."no_photo.jpg";
} ?>
[
<?php echo $loc['property_lat'].", ".$loc['property_lon']; ?>,
"<img width=150px src='<?php echo $h_img_m; ?>'>",
"<a href='<?php echo $selectedlang['lang_url']."/id_control.php?id=".$loc['property_id'];?>/' class='btn btn-block btn-primary' target='_blank'><?php echo $translate['trans_055']; ?></a>"
]<?php if($x < $len) { echo ","; } ?>
<?php $x++; } } ?>
];

/// MAP
var map             = null;
var markerclusterer = null;
var infowindow      = new google.maps.InfoWindow();
var gmarkers        = [];
function createMarker(latlng, info) {
var marker          = new google.maps.Marker({
position: latlng,
map: map
});
google.maps.event.addListener(marker, 'click', function() {
infowindow.setContent(info);
infowindow.open(map,marker);
});
gmarkers.push(marker);
}
function myclick(i) {
google.maps.event.trigger(gmarkers[i], "click");
}

function initialize() {
var myOptions = {
zoom: <?php echo $zoom; ?>,
styles: [
{"featureType": "administrative","elementType": "all","stylers": [{"visibility": "on"},{"lightness": 33}]},
{"featureType": "landscape","elementType": "all","stylers": [{"color": "#f2e5d4"}]},
{"featureType": "poi.park","elementType": "geometry","stylers": [{"color": "#c5dac6"}]},
{"featureType": "poi.park","elementType": "labels","stylers": [{"visibility": "on"},{"lightness": 20}]},
{"featureType": "road","elementType": "all","stylers": [{"lightness": 20}]},
{"featureType": "road.highway","elementType": "geometry","stylers": [{"color": "#c5c6c6"}]},
{"featureType": "road.arterial","elementType": "geometry","stylers": [{"color": "#e4d7c6"}]},
{"featureType": "road.local","elementType": "geometry","stylers": [{"color": "#fbfaf7"}]},
{"featureType": "water","elementType": "all","stylers": [{"visibility": "on"},{"color": "#acbcc9"}]}
],
center: new google.maps.LatLng(<?php echo $geoloc; ?>),
mapTypeControl: true,
navigationControl: false,
streetViewControl: false,
draggable : true,
scrollwheel: false,
mapTypeId: google.maps.MapTypeId.ROADMAP
};
map = new google.maps.Map(document.getElementById("map-canvas"), myOptions);
google.maps.event.addListener(map, 'click', function() {
infowindow.close();
});
for (var i = 0; i < markers.length; i++) {
var point = new google.maps.LatLng( markers[i][0], markers[i][1]);
var marker = createMarker( point, "<div class='scrollFix'> " + markers[i][2] + markers[i][3] + "</div>") ;
}
markerCluster = new MarkerClusterer(map, gmarkers);
}
google.maps.event.addDomListener(window, 'load', initialize);
/// MAP

$("select#bolge").change(function() {
var aaa1 = '<option value="0"><?php echo $translate['trans_070']; ?></option>';
$("select#semt").html(aaa1);
var bolge_id = $("select#bolge option:selected").attr('value');
var data_semt = "";
$.get('<?php echo SITE_URL; ?>admin/include/Api_search.php',{"bolge": bolge_id},
function(data) {
data_semt = '<option value="0"><?php echo $translate['trans_070']; ?></option>';
$.each(data, function(i, item) {
data_semt = data_semt + '<option value="' + item.property_district + '">' + item.district_name + '</option>';
});
$("select#semt").html(data_semt);
},'json');
});

<?php if (!empty($_GET['bolge'])) { ?>
$( document ).ready(function() {
var bolge_id  = <?php echo $_GET['bolge']; ?>;
var data_semt = "";
$.get('<?php echo SITE_URL; ?>admin/include/Api_search.php',{"bolge": bolge_id},
function(data) {
data_semt = '<option value="0"><?php echo $translate['trans_070']; ?></option>';
$.each(data, function(i, item) {
data_semt = data_semt + '<option ';
if (item.property_district == <?php if (!empty($_GET['semt']) OR $_GET['semt'] != NULL OR $_GET['semt'] != 0) { echo $_GET['semt']; } else { echo "0"; } ?>) { data_semt = data_semt + ' selected="selected" '; }
data_semt = data_semt + ' value="' + item.property_district + '">' + item.district_name + ' </option>';
});
$("select#semt").html(data_semt);
},'json');
});
<?php } ?>
</script>

</body>
</html>

<?php ob_end_flush(); ?>