#Montana#

<?
	$pFolder				= "emlak_img/";
	$pSmallFolder		= "emlak_img/small/";
	include "includes/SimpleImage.php";
	
	if(empty($_SESSION['sort']['type']))	$_SESSION['sort']['type']=1;
	
	if($_SESSION['sort']['type'] == 1){
		$sortField	="e_id";
		$sortType	="ASC";
	
	} else if($_SESSION['sort']['type'] == 2){
		$sortField	="title";
		$sortType	="ASC";
	
	} else if($_SESSION['sort']['type'] == 3){
		$sortField	="title";
		$sortType	="DESC";
	
	} else if($_SESSION['sort']['type'] == 4){
		$sortField	="fiyat";
		$sortType	="ASC";
	
	} else if($_SESSION['sort']['type'] == 5){
		$sortField	="fiyat";
		$sortType	="DESC";
	}
	
	if(!empty($_GET['search_page'])){
		if($_GET['search_page'] == "main"){
			$_GET['catID']			= 0;
			$_GET['satis_turu']	= 0;
			$_GET['il_id']			= 0;
			$_GET['min_fiyat']	= 0;
			$_GET['max_fiyat']	= 0;
			
			
			if(intval($_GET['catID1']) > 0)			$_GET['catID']				=intval($_GET['catID1']);
			if(intval($_GET['catID2']) > 0)			$_GET['catID']				=intval($_GET['catID2']);
			
			if(intval($_GET['satis_turu1']) > 0)	$_GET['satis_turu']		=intval($_GET['satis_turu1']);
			if(intval($_GET['satis_turu2']) > 0)	$_GET['satis_turu']		=intval($_GET['satis_turu2']);
			
			if(intval($_GET['il_id1']) > 0)			$_GET['il_id']				=intval($_GET['il_id1']);
			if(intval($_GET['il_id2']) > 0)			$_GET['il_id']				=intval($_GET['il_id2']);
			
			if(intval($_GET['min_fiyat1']) > 0)		$_GET['min_fiyat']		=intval($_GET['min_fiyat1']);
			if(intval($_GET['min_fiyat2']) > 0)		$_GET['min_fiyat']		=intval($_GET['min_fiyat2']);
			
			if(intval($_GET['max_fiyat1']) > 0)		$_GET['max_fiyat']		=intval($_GET['max_fiyat1']);
			if(intval($_GET['max_fiyat2']) > 0)		$_GET['max_fiyat']		=intval($_GET['max_fiyat2']);
		}
	}

/*		arrayToScr($_GET);
	Array
	(
		 [page] => emlak_list
		 [baslik] => konut
		 [catID] => 1
		 [word] => dubleks
		 [satis_turu] => 1
		 [il_id] => 
		 [odasayisi] => 3
		 [banyosayisi] => 3
		 [binayasi] => 2011-2007
		 [taban] => 3
		 [fiyataraligi] => 7
	)
	*/
?>

<section class="detaybaslik-sec">
   <div class="detaymask">
      <div class="container">
         <div class="row clearfix">
            <div class="col-lg-12">
               <h1><? echo $strEmlakCat[intval($_GET['catID'])]?></h1>
               <div class="detayneresi">
                  <ul class="breadcrumb">
                     <li><a href="<?=BASE_URL?>index.html"><? echo $strMain?></a></li>
                     <li><a href="javascript:;"><?=EMLAK_LIST?></a></li>
                     <li class="active"><? echo $strEmlakCat[intval($_GET['catID'])]?></li>
                  </ul>
               </div>
            </div>
         </div>
      </div>
   </div>
</section>
<div class="container">
   <div class="row clearfix">
      <aside class="col-lg-3 col-md-3 col-sm-4 col-xs-12 sol-blok">
         <button type="button" class="btn btn-block btn-danger btn-block hidden visible-xs" data-toggle="collapse" data-target="#frmListeSol"><?=$btn_search_filter?></button>
         <form id="frmListeSol" name="frmListeSol" method="get" class="ara-form collapse navbar-collapse" style="background-color:#f7f7f7; padding: 5px; border:1px solid #ddd;">
            <div class="form-group">
               <label class="text-center"> <?=$strSearch_word?> </label>
               <input name="word" id="word" class="form-control" value="<? echo addslashes($_GET['word'])?>" >
            </div>
            <div class="form-group">
               <label class="text-center"><?=$strEmlakTuru?></label>
               <select name="catID" id="catID" class="form-control emlaktipi">
                  <? fnListEmlakCat(intval($_GET['catID']))?>
               </select>
            </div>
            <div class="form-group">
               <label class="text-center"><?=$strSatisTuru?></label>
               <select name="satis_turu" id="satis_turu" class="form-control emlakdurumu">
                  <? fnListEmlakSatisTuru(intval($_GET['satis_turu']));?>
               </select>
            </div>
            <div class="form-group">
               <label class="text-center"><?=$strSearchCity?></label>
               <select name="il_id" id="il_id" class="form-control emlaksehir">
                  <? fnListEmlakSehir(intval($_GET['il_id']));?>
               </select>
            </div>
            <div class="form-group">
               <label class="text-center"><?=$strOdaSayisi?></label>
               <select name="oda_sayisi" id="oda_sayisi" class="form-control odasayisi" style="width:150px;">
                  <? echo fnListOdaSayisi(intval($_GET['oda_sayisi']))?>
               </select>
            </div>
            <div class="form-group">
               <label class="text-center"><?=$strBanyoSayisi?></label>
               <select name="banyo_sayisi" id="banyo_sayisi" class="form-control banyosayisi">
                  <? echo fnListBanyoSayisi(intval($_GET['banyo_sayisi']))?>
               </select>
            </div>
            <div class="form-group">
               <label class="text-center"><?=$strBinaYasi?></label>
               <select name="binayasi" class="form-control binayasi">
                  <option value="1" 	<? if(intval($_GET['binayasi'])==1) 	echo "selected";?>>0-1 YIL</option>
                  <option value="2" 	<? if(intval($_GET['binayasi'])==2) 	echo "selected";?>>2-5 YIL</option>
                  <option value="3" 	<? if(intval($_GET['binayasi'])==3) 	echo "selected";?>>6-10 YIL</option>
                  <option value="4"		<? if(intval($_GET['binayasi'])==4) 	echo "selected";?>>11-15 YIL</option>
                  <option value="5" 	<? if(intval($_GET['binayasi'])==5) 	echo "selected";?>>16 YIL ++</option>
               </select>
            </div>
            <div class="form-group">
               <label class="text-center"><?=$strMetrekare?></label>
               <select name="taban" id="taban" class="form-control metrekare">
                  <option value="1" <? if(intval($_GET['taban']==1)) 			echo "selected";?>>40-80</option>
                  <option value="2" <? if(intval($_GET['taban']==2)) 			echo "selected";?>>81-120</option>
                  <option value="3" <? if(intval($_GET['taban']==3)) 			echo "selected";?>>121-200</option>
                  <option value="4" <? if(intval($_GET['taban']==4)) 			echo "selected";?>>201-400</option>
                  <option value="5" <? if(intval($_GET['taban']==5)) 			echo "selected";?>>400 ++</option>
               </select>
            </div>
            <div class="form-group">
               <label class="text-center"><?=$strSearchPrice?></label>
               <div class="form-group">
                  <div class="row">
                     <div class="col-sm-6">
                        <input name="min_fiyat" type="text" class="form-control" id="min_fiyat" placeholder="Min <? echo $_SESSION['kur']?>" value="<? if(intval($_GET['min_fiyat']) > 0) echo intval($_GET['min_fiyat'])?>">
                     </div>
                     <div class="col-sm-6">
                        <input name="max_fiyat" type="text" class="form-control" id="max_fiyat" placeholder="Max <? echo $_SESSION['kur']?>" value="<? if(intval($_GET['max_fiyat']) > 0) echo intval($_GET['max_fiyat'])?>">
                     </div>
                  </div>
               </div>
            </div>
            <div class="clearfix"> </div>
            <input type="hidden" id="">
            <br>
            <br>
            <input type="submit" class="btn btn-load btn-block" value="<?=$emlakSearch?>">
            <input name="_token" id="_token" type="hidden" value="<? echo $_SESSION['_token']?>">
         </form>
      </aside>
      <main class="content col-lg-9 col-md-9 col-sm-8 col-xs-12">
         <div class="row clearfix siralamacont">
            <div class="col-sm-10 col-xs-8 ara-input">
               <button class="btn hidden visible-xs collapsed" type="button" data-toggle="collapse" data-target="#siralaid" aria-expanded="true"><?=$sortTitle?> <span class="caret"></span></button>
               <div class="collapse navbar-collapse" id="siralaid">
                  <div class="siralama">
                  	<a href="javascript:;" class="emlak_sort <? if($_SESSION['sort']['type'] == 1) echo 'active';?>" id="emlaksort_1"><?=$sortByDate?></a> 
                     <a href="javascript:;" class="emlak_sort <? if($_SESSION['sort']['type'] == 2) echo 'active';?>" id="emlaksort_2"><?=$sortAtoZ?></a> 
                     <a href="javascript:;" class="emlak_sort <? if($_SESSION['sort']['type'] == 3) echo 'class="active"';?>" id="emlaksort_3"><?=$sortZtoA?></a> 
                     <a href="javascript:;" class="emlak_sort <? if($_SESSION['sort']['type'] == 4) echo 'class="active"';?>" id="emlaksort_4"><?=$sortUcuzToPahali?></a> 
                     <a href="javascript:;" class="emlak_sort <? if($_SESSION['sort']['type'] == 5) echo 'class="active"';?>" id="emlaksort_5"><?=$sortPahaliToUcuz?></a>
                  </div>
               </div>
            </div>
            <div class="col-sm-2 col-xs-4 ara-input">
               <div class="product-filter">
                  <div class="view-change"> <a href="javascript();" class="gridyap active"> <i class="fa fa-th" aria-hidden="true"></i> </a> <a href="javascript();" class="listyap"><i class="fa fa-list"></i></a></div>
               </div>
            </div>
         </div>
         <div id="product-cont" class="urunler product-grid">
            <div class="row clearfix">
               <?
					
					/*		arrayToScr($_GET);
					Array
					(
						 [page] => emlak_list
						 [baslik] => konut
						 								[catID] => 1
						 [word] => dubleks
						 								[satis_turu] => 1
						 								[il_id] => 
						 [odasayisi] => 3
						 [banyosayisi] => 3
						 								[binayasi] => 2011-2007
						 								[taban] => 3
						 [fiyataraligi] => 7
					)
					*/
	$StrSQL= "SELECT e_id, emlak_turu, sub_type, title, spot, belde, fiyat, indirimli_fiyat, para_turu, satis_turu, create_date, update_date,   
		(SELECT resim 	FROM emlak_img WHERE e_id=emlak.e_id AND is_default='1' ORDER BY img_id LIMIT 0,1) AS emlak_img ,
		(SELECT resim 	FROM emlak_img WHERE e_id=emlak.e_id ORDER BY img_id LIMIT 0,1) AS emlak_first ,
		(SELECT il 		FROM il 			WHERE il_id=emlak.il_id) AS emlak_il ,
		(SELECT ilce 	FROM ilce 		WHERE ilce_id=emlak.ilce_id) AS emlak_ilce 
			FROM emlak WHERE lang='".$_SESSION['lang']."' AND status='1' ";
							
							
			if(intval($_GET['catID']) > 0)				$StrSQL	.= " AND emlak_turu	='".intval($_GET['catID'])."'";
			if(intval($_GET['satis_turu']) > 0)			$StrSQL	.= " AND satis_turu	='".intval($_GET['satis_turu'])."'";
			if(intval($_GET['il_id']) > 0)				$StrSQL	.= " AND il_id			='".intval($_GET['il_id'])."'";
			if(intval($_GET['ilce_id']) > 0)				$StrSQL	.= " AND ilce_id		='".intval($_GET['ilce_id'])."'";
			if(intval($_GET['oda_sayisi']) > 0)			$StrSQL	.= " AND ilce_id		='".intval($_GET['oda_sayisi'])."'";
			if(intval($_GET['banyo_sayisi']) > 0)		$StrSQL	.= " AND banyo_sayisi='".intval($_GET['banyo_sayisi'])."'";
			
			if(intval($_GET['binayasi']) > 0){
				if(intval($_GET['binayasi']) == 1)		$StrSQL	.= " AND (yapim_yili BETWEEN ".(date("Y")-1)."  AND ".(date("Y")-0).") " ;
				if(intval($_GET['binayasi']) == 2)		$StrSQL	.= " AND (yapim_yili BETWEEN ".(date("Y")-5)."  AND ".(date("Y")-2).") " ;
				if(intval($_GET['binayasi']) == 3)		$StrSQL	.= " AND (yapim_yili BETWEEN ".(date("Y")-10)." AND ".(date("Y")-6).") " ;
				if(intval($_GET['binayasi']) == 4)		$StrSQL	.= " AND (yapim_yili BETWEEN ".(date("Y")-15)." AND ".(date("Y")-11).") ";
				if(intval($_GET['binayasi']) == 5)		$StrSQL	.= " AND (yapim_yili < ".(date("Y")-16).") " ;
			}
			
			if(intval($_GET['taban']) > 0){
				if(intval($_GET['taban']) == 1)			$StrSQL	.= " AND (taban BETWEEN 40  AND 80) " ;
				if(intval($_GET['taban']) == 2)			$StrSQL	.= " AND (taban BETWEEN 81 AND 120) " ;
				if(intval($_GET['taban']) == 3)			$StrSQL	.= " AND (taban BETWEEN 121 AND 200) ";
				if(intval($_GET['taban']) == 4)			$StrSQL	.= " AND (taban BETWEEN 201 AND 400) ";
				if(intval($_GET['taban']) == 5)			$StrSQL	.= " AND (taban > 400 " ;
			}
			
			if(strlen(addslashes($_GET['word'])) > 0){
																	$StrSQL	.=" (	(title LIKE '%".addslashes($_GET['word'])."%') OR 
																						(spot LIKE '%".addslashes($_GET['word'])."%') OR 
																						(konu LIKE '%".addslashes($_GET['word'])."%') OR 
																						(emlak_no LIKE '".addslashes($_GET['word'])."')";
			}
			
			$StrSQL	.=" ORDER BY ".$sortField." ".$sortType;
			//oda_sayisi
			//arrayToScr($StrSQL)."<br>";
			$query	= mysql_db_query($db_name,$StrSQL) or die ($strMysqlError);
			$arrEmlak= array();

while($row = mysql_fetch_assoc($query)){
				if((intval($_GET['min_fiyat']) > 0) && (intval($_GET['max_fiyat']) > 0)){
					
					if(intval($row['indirimli_fiyat']) == 0){
						if((fnEmlakFiyat($row['fiyat'],$row['para_turu']) > $_GET['min_fiyat']) && (fnEmlakFiyat($row['fiyat'],$row['para_turu']) < $_GET['max_fiyat'])){
							$arrEmlak[]	= $row;
						}
					} else {
						if((fnEmlakFiyat($row['indirimli_fiyat'],$row['para_turu']) > $_GET['min_fiyat']) && (fnEmlakFiyat($row['indirimli_fiyat'],$row['para_turu']) < $_GET['max_fiyat'])){
							$arrEmlak[]	= $row;
						}
					}

} else if((intval($_GET['min_fiyat']) > 0)) {
					if(intval($row['indirimli_fiyat']) == 0){
						if(fnEmlakFiyat($row['fiyat'],$row['para_turu']) > $_GET['min_fiyat'])
							$arrEmlak[]	= $row;						
					} else {
						if(fnEmlakFiyat($row['indirimli_fiyat'],$row['para_turu']) > $_GET['min_fiyat'])
							$arrEmlak[]	= $row;	
					}

} else if((intval($_GET['max_fiyat']) > 0)){
					if(intval($row['indirimli_fiyat']) == 0){
						if(fnEmlakFiyat($row['fiyat'],$row['para_turu']) < $_GET['max_fiyat'])
							$arrEmlak[]	= $row;
					} else {
						if(fnEmlakFiyat($row['indirimli_fiyat'],$row['para_turu']) < $_GET['max_fiyat'])
							$arrEmlak[]	= $row;
					}

} else {
						$arrEmlak[]	= $row;
				}
			}

//arrayToScr($arrEmlak);
			
			if(count($arrEmlak) > 0){
				foreach($arrEmlak as $key => $value){
					$eTitle	= str_replace(" m2 "," m<sup>2</sup> ",$value['title']);
					$eTitle	= str_replace(" M2 "," m<sup>2</sup> ",$eTitle);
				
					if(isset($value['emlak_img'])){
						if(file_exists($rootDir."/images/".$pFolder.$value['emlak_img'])){
							if(!file_exists($rootDir."/images/".$pSmallFolder.$value['emlak_img'])){
								$objImage 	= new SimpleImage();
								$objImage->ImageToFit($value['emlak_img'],IMG_SMALL_WIDTH,IMG_SMALL_HEIGHT,"images/".$pFolder,"images/".$pSmallFolder);
							}
						}
					} else {
						if(file_exists($rootDir."/images/".$pFolder.$value['emlak_first'])){
							if(!file_exists($rootDir."/images/".$pSmallFolder.$value['emlak_first'])){
								$objImage 	= new SimpleImage();
								$objImage->ImageToFit($value['emlak_first'],IMG_SMALL_WIDTH,IMG_SMALL_HEIGHT,"images/".$pFolder,"images/".$pSmallFolder);
							}
						}
					}
			?>
               <div class="urun-col">
                  <div class="onecikan-cont">
                     <div class="one-fotocont"> <img src="<?=TBASE?>images/<? if(isset($value['emlak_img'])) echo $pSmallFolder.$value['emlak_img']; else echo $pSmallFolder.$value['emlak_first'];?>" class="img-responsive center-block">
                        <div class="one-tur"><? echo $strEmlakSatisTuru[$value['satis_turu']]?></div>
                        <? if(intval($value['indirimli_fiyat']) > 0){?>
                        <div class="salebadge"> <img src="<?=BASE?>images/salebadge_<? echo $_SESSION['lang']?>.png" class="img-responsive"> </div>
                        <? }?>
                        <? if($ctrlCephe == 1){?>
                        <div class="compasmain">
                           <div class="compass2-cont">
                              <div class="compass2"> <img src="<?=BASE?>images/pusula/kuzeyc.png" class="kuzeyc 	<? if($arrCephe[0] == 1) echo "active";?>" alt=""> <img src="<?=BASE?>images/pusula/doguc.png" class="doguc 	<? if($arrCephe[1] == 1) echo "active";?>" alt=""> <img src="<?=BASE?>images/pusula/guneyc.png" class="guneyc 	<? if($arrCephe[2] == 1) echo "active";?>" alt=""> <img src="<?=BASE?>images/pusula/batic.png" class="batic 	<? if($arrCephe[3] == 1) echo "active";?>" alt=""> </div>
                           </div>
                        </div>
                        <? }?>
                        <div class="one-hover">
                           <p> <? echo $value['spot']?></p>
                        </div>
                     </div>
                     <div class="one-detay">
                        <div class="one-baslik"> <? echo $eTitle?> </div>
                        <div class="modaladres"> <? echo $value['emlak_ilce']." ".$value['emlak_il']." ".$value['belde']?></div>
                        <div class="m-cins"><? echo $strEmlakSatisTuru[$value['satis_turu']]." - ".$strEmlakCat[$value['emlak_turu']]?></div>
                        <div class="one-fiyat">
                           <? 
											if(intval($value['indirimli_fiyat']) == 0){
												echo number_format(fnEmlakFiyat($value['fiyat'],$value['para_turu']),0,",",".")." ".$_SESSION['kur'];
											} else {
												echo '<span style="text-decoration:line-through; color:#F59499;">'.number_format(fnEmlakFiyat($value['fiyat'],$value['para_turu']),0,",",".").'</span> '.number_format(fnEmlakFiyat($value['indirimli_fiyat'],$value['para_turu']),0,",",".")." ".$_SESSION['kur'];
											}
										?>
                        </div>
                        <ul class="tarih-link">
                           <li> <span><? echo fnMakeDate($value['update_date'])?></span> </li>
                           <li class="one-detaylink"> <a class="btn btn-line" href="<?=BASE_URL?>emlak/<? echo fnUrlTitle(stripslashes($value['title'])."-".$value['e_id'])?>.html"> <?=$btn_detail?> </a> </li>
                        </ul>
                     </div>
                  </div>
               </div>
               <?	}
						}
					?>
            </div>
         </div>
      </main>
   </div>
</div>
<script type="text/javascript">
  $(function(){ 
		$('.emlak_sort').click(function(){
			var arrSort = $(this).attr('id').split("_"); 
			var sortType = arrSort[1];

var dataSort = 'action=sort&Type=' + sortType; //
			
			$.ajax({
				  type : "POST",
				  url : jsBase + "load_sort_emlak.php",
				  data: dataSort,
				  success:function(){
						location.reload(); 
				  }
			 });
		});
  });
</script>