📁 PHP Dosya Yöneticisi
/
/
home
/
demodesigncom
/
firmarehberiv1.demodesign.com.tr
📝
ilan-idet.php
← Geri Dön
<?php $ids = $_GET['id']; $b = $db->customQuery("SELECT * FROM dbo_ilan_kategori WHERE id='$id'")->getRow(); $ktt = str_replace('amp;','&',$b->kategori_adi); function CallWithFilter($GetCall) { $suankiadres="http://".str_replace("www.","",$_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"]); $yeniadres=preg_replace("/&sayfa=(.*)/", "", $suankiadres); $adres=explode("&Filtered=",$yeniadres); $new_adres=$adres[0]; if($GetCall!=''){ $WithFilter="&Filtered=".$GetCall; }else{ $WithFilter=""; } echo $new_adres.$WithFilter; } $order_type=guvenlik(@$_GET['sira']); if($order_type=='dateup'){ $order="dbo_ilan.ilantarih DESC"; }elseif($order_type=='datedown'){ $order="dbo_ilan.ilantarih ASC"; }elseif($order_type=='pricedown'){ $order="dbo_ilan.ilanfiyat DESC"; }elseif($order_type=='priceup'){ $order="dbo_ilan.ilanfiyat ASC"; }else{ $order="dbo_ilan.ilantarih DESC"; } $limit_get=guvenlik(@$_GET['limit']); if($limit_get<=50 and $limit_get>=10 and !empty($limit_get)){ $limit=$limit_get; }elseif(empty($limit)){ $limit=10; } $field_kategori=$k1; $field_kategori2=$k2; $field_kategori3=$k3; $field_kategori4=$k4; $field_kategori5=$k5; $field_kategori6=$k6; $field_kategori7=$k7; $WithFilter_g=guvenlik(@$_GET['Filtered']); ?> <script> function sequance(type){ <?php function check_url($text){ if(strstr($_SERVER['REQUEST_URI'],$text)){ $order_url=preg_replace("/&".$text."=[a-z-0-9]+/i","",$_SERVER['REQUEST_URI']); $order_go=$order_url; }else{ $order_url=$_SERVER['REQUEST_URI']; $order_go=$order_url; } return $order_go; } ?> window.location="<?=check_url('sira');?>&sira="+type; } </script> <div class="item2-gl-nav d-flex" style="background:#FFFFFF; margin-bottom:15px;"> <div class="col-md-8 col-xs-12" style="float:left; text-align:left;"> <h6 class="mb-0 mt-2"> <i class="fa fa-list" aria-hidden="true"></i> <?php if(@$k1!=0){ ?><?=$katz1->kategori_adi?> <i class="fa fa-angle-right"></i> <?php }?> <?php if(@$k2!=0){ ?><?=$katz2->kategori_adi?> <i class="fa fa-angle-right"></i> <?php }?> <?php if(@$k3!=0){ ?><?=$katz3->kategori_adi?> <i class="fa fa-angle-right"></i> <?php }?> <?php if(@$k4!=0){?><?=$katz4->kategori_adi?> <i class="fa fa-angle-right"></i> <?php }?> <?php if(@$k5!=0){?><?=$katz5->kategori_adi?> <i class="fa fa-angle-right"></i> <?php }?> <?php if(@$k6!=0){?><?=$katz6->kategori_adi?> <i class="fa fa-angle-right"></i> <?php }?> <?php if(@$k7!=0){?><?=$katz7->kategori_adi?><?php } ?> ilanları. </h6> </div> <div class="col-md-4 col-xs-12" style="float:right; text-align:right;"> <div class="d-flex"> <label class="mr-2 mt-1 mb-sm-1">Sıralama:</label> <select class="form-control select-sm w-70" onchange="sequance(this.options[selectedIndex].value);" style="font-size:12px;"> <option value="dateup"<? if($order_type=='dateup'){ }?>>Gelişmiş Sıralama</option> <option value="dateup"<? if($order_type=='dateup'){?> selected<? }?>>Tarihe Göre (Önce yeni)</option> <option value="datedown"<? if($order_type=='datedown'){?> selected<? }?>>Tarihe Göre (Önce eski)</option> <option value="priceup"<? if($order_type=='priceup'){?> selected<? }?>>Fiyata Göre (Önce en düşük)</option> <option value="pricedown"<? if($order_type=='pricedown'){?> selected<? }?>>Fiyata Göre (Önce en yüksek)</option> </select> </div> </div> <div class="clearfix"></div> </div> <div class="container-fluid"> <?php $fieldCallType="withfilter"; include("user/modules/ilan/ilan-alanlar.php"); ?> <div class="clearfix"></div> <?php $seolink = seo($b->kategori_adi); if(!empty($WithFilter_g)){ $explode_filter=explode("?",$WithFilter_g); $ek=" and custom_fields.field_name='".$explode_filter[0]."' and custom_fields.field_value='".$explode_filter[1]."'"; }else{ $ek=""; } if(!empty($k2)){ $kategori2=" and dbo_ilan.ilankat2='$k2'"; }else{ $kategori2=""; } if(!empty($k3)){ $kategori3=" and dbo_ilan.ilankat3='$k3'"; }else{ $kategori3=""; } if(!empty($k4)){ $kategori4=" and dbo_ilan.ilankat4='$k4'"; }else{ $kategori4=""; } if(!empty($k5)){ $kategori5=" and dbo_ilan.ilankat5='$k5'"; }else{ $kategori5=""; } if(!empty($k6)){ $kategori6=" and dbo_ilan.ilankat6='$k6'"; }else{ $kategori6=""; } if(!empty($k7)){ $kategori7=" and dbo_ilan.ilankat7='$k7'"; }else{ $kategori7=""; } $fieldCallType="search_post"; include("user/modules/ilan/ilan-alanlar.php"); $sehir=guvenlik($_GET['il']); $ilce=guvenlik($_GET['ilce']); $semt=guvenlik($_GET['semt']); $mahalle=guvenlik($_GET['mahalle']); $fiyat_1=guvenlik($_GET['fiyat_1']); $fiyat_2=guvenlik($_GET['fiyat_2']); $search=guvenlik($_GET['search']); if(!empty($sehir) and is_numeric($sehir)){ $add_query_to_sql.=" AND ilanil='".$sehir."'"; } if(!empty($ilce) and is_numeric($ilce)){ $add_query_to_sql.=" AND ilanilce='".$ilce."'"; } if(!empty($semt) and is_numeric($semt)){ $add_query_to_sql.=" AND ilansemt='".$semt."'"; } if(!empty($mahalle) and is_numeric($mahalle)){ $add_query_to_sql.=" AND ilanmahalle='".$mahalle."'"; } if(!empty($fiyat_1) and !empty($fiyat_2)){ $add_query_to_sql.=" AND ilanfiyat BETWEEN '".$fiyat_1."' AND '".$fiyat_2."'"; } if(!empty($search)){ $add_query_to_sql.=" AND (ilanbaslik LIKE '%".$search."%')"; } foreach ($field_values as $field_name => $field_value) { if(!empty($field_value)){ $add_query_to_sql.=$field_value; }} $kategori_sql=$kategori2.$kategori3.$kategori4.$kategori5.$kategori6.$kategori7; $sql_text = "SELECT * FROM dbo_ilan LEFT JOIN custom_fields ON custom_fields.ilanId=dbo_ilan.id WHERE dbo_ilan.ilankat1='$k1'".$kategori_sql." AND dbo_ilan.ilanonay = 'Aktif'".$ek.$add_query_to_sql." group by dbo_ilan.id ORDER BY dbo_ilan.ust_siradayim DESC,".$order; $sayfa_get = guvenlik($_GET['sayfa']); if(!empty($sayfa_get) and is_numeric($sayfa_get)){ $sayfa=($sayfa_get-1)*$limit; }else{ $sayfa=0; } $sql = $db->customQuery($sql_text." LIMIT $sayfa, ".$limit)->getAll(); $sayfa = $db->customQuery($sql_text)->getAll(); $topla = $db->numRows(); $toplam_kayit=$topla; if ($toplam_kayit==0){ echo bilgi('danger','Seçtiğiniz kriterlere uygun ilan bulunamadı!'); }else{ ?> <?php $i=1; foreach($sql as $a){ $ilanresim = $db->customQuery("SELECT * FROM dbo_ilan_resim WHERE ilanid='".$a->id."'")->getRow(); $il = $db->customQuery("SELECT * FROM dbo_il where il_id='".$a->ilanil."' LIMIT 1")->getRow(); $ilce = $db->customQuery("SELECT * FROM dbo_ilce where ilce_id='".$a->ilanilce."' LIMIT 1")->getRow(); ?> <?php if($a->ust_siradayim=='1'){ ?> <div id="ilanlist" class="row adv adv-color" onclick="location.href='ilan/<?=$a->id?>/<?=seo($a->ilanbaslik)?>/';" style="cursor: pointer; <?php if($a->kalinyazi_cerceve==1){echo "font-weight:bold;background:#D4FFD5;";} ?>"> <?php if(!empty($ilanresim->resim_adi)){ ?> <div class="col-md-2"><a href="ilan/<?=$a->id?>/<?=seo($a->ilanbaslik)?>/"><img src="uploads/ilanlar/<?=$ilanresim->resim_adi?>" class="img-thumbnail" width="100"></a></div> <?php }else{ ?> <div class="col-md-2"><a href="ilan/<?=$a->id?>/<?=seo($a->ilanbaslik)?>/"><img src="uploads/varsayilan.jpg" class="img-thumbnail" width="100"></a></div> <?php } ?> <div class="col-md-7"><strong style="font-size:14px"><?=$a->ilanbaslik?></strong> <br><span style="font-size:12px"><?=$il->il_ad?> / <?=$ilce->ilce_ad?> - <i class="fa fa-clock-o" aria-hidden="true"></i> <?=cevirtarih($a->ilantarih)?></span> <br> </div> <div class="col-md-3" style="text-align:center; padding:5px"><a href="ilan/<?=$a->id?>/<?=seo($a->ilanbaslik)?>/" class="btn btn-primary" style="border-radius:0px;"><?=number_format($a->ilanfiyat)?> <?=$a->ilankur?></a></div> </div> <?php } ?> <?php if($a->ust_siradayim !=1){ ?> <div id="ilanlist" class="row adv adv-color" onclick="location.href='ilan/<?=$a->id?>/<?=seo($a->ilanbaslik)?>/';" style="cursor: pointer; <?php if($a->kalinyazi_cerceve==1){echo "font-weight:bold;background:#D4FFD5;";} ?>"> <?php if(!empty($ilanresim->resim_adi)){ ?> <div class="col-md-2"><a href="ilan/<?=$a->id?>/<?=seo($a->ilanbaslik)?>/"><img src="uploads/ilanlar/<?=$ilanresim->resim_adi?>" class="img-thumbnail" width="100"></a></div> <?php }else{ ?> <div class="col-md-2"><a href="ilan/<?=$a->id?>/<?=seo($a->ilanbaslik)?>/"><img src="uploads/varsayilan.jpg" class="img-thumbnail" width="100"></a></div> <?php } ?> <div class="col-md-7"><strong style="font-size:14px"><?=$a->ilanbaslik?></strong> <br><span style="font-size:12px"><?=$il->il_ad?> / <?=$ilce->ilce_ad?> - <i class="fa fa-clock-o" aria-hidden="true"></i> <?=cevirtarih($a->ilantarih)?></span> <br> </div> <div class="col-md-3" style="text-align:center; padding:5px;"><a href="ilan/<?=$a->id?>/<?=seo($a->ilanbaslik)?>/" class="btn btn-primary" style="border-radius:0px;"><?=number_format($a->ilanfiyat)?> <?=$a->ilankur?></a></div> </div> <?php } ?> <?php $i++;} ?> <?php } ?> <div class="col-md-12"> <div class="row"> <div class="center-block text-center"> <ul class="pagination mb-0"> <?php require_once('system/class.paginate.php'); $sayfalama= new paginate(); $sayfalama->sayfa=intval($_GET['sayfa']); $sayfalama->toplam=$toplam_kayit; $sayfalama->sayfa_basina=$limit; $sayfalama->type=0; $sayfalama->degisken='sayfa'; $sayfalama->hazirla(); echo $sayfalama->sayfala(); unset($sayfalama); ?> </ul> </div> </div> </div> </div>
💾 Kaydet
İptal
📝 Yeniden Adlandır
İptal
Kaydet
🔐 Dosya İzinleri (chmod)
İzin Değeri:
Hızlı Seçim:
777
755
644
600
777
= Herkes okur/yazar/çalıştırır
755
= Sahip tam, diğerleri okur/çalıştırır
644
= Sahip okur/yazar, diğerleri okur
600
= Sadece sahip okur/yazar
İptal
Uygula