PHP Dosya Yöneticisi

<?php
@$menu = 'onay-islemleri'; @$page = 'onay-ilan';
require_once("header.php");
require_once("menu-left.php");

/************************************************************************************************************************/
if(isset($_GET["sil"]) && admin_login_check($db) == true){ 
	$silid= intval($_GET["sil"]);
		
		$sql1 = $db->table('dbo_ilan')->where('id', '=', $silid)->getAll();
			foreach($sql1 as $sql1resim){
				unlink("../uploads/ilanlar/".$sql1resim->ilan_kapak);
		}
		
		$sql2 = $db->table('dbo_ilan_resim')->where('ilanid', '=', $silid)->getAll();
			foreach($sql2 as $sql2resim){
				unlink("../uploads/ilanlar/".$sql2resim->resim_adi);
		}
		
		$sql3 = $db->table('custom_fields')->where('ilanId', '=', $silid)->delete();
		
		$isle = $db->table('dbo_ilan')->where('id', '=', $silid)->delete();
		
		if($isle){
			$bilgi = alert('success','İlan Silindi','ilan-onay.html',3);
			}else{
			$bilgi = alert('danger','İlan Silinemedi!','ilan-onay.html',3);
		}
}
/************************************************************************************************************************/
if(isset($_GET["onay"]) && admin_login_check($db) == true){ 
	$onayid= intval($_GET["onay"]);
		
		$data = [ 'ilanonay' => 'Aktif' ];
		
		$isle = $db->table('dbo_ilan')->where('id', '=', $onayid)->update($data);
		
		if($isle){
			$bilgi = alert('success','İlan Onaylandı','ilan-onay.html',3);
			}else{
			$bilgi = alert('danger','İlan Onaylanamadı!','ilan-onay.html',3);
		}
}
/************************************************************************************************************************/
?>
<link rel="stylesheet" href="css/lib/bootstrap-table/bootstrap-table.min.css">
	<div class="page-content">
		<header class="page-content-header">
			<div class="container-fluid">
				<div class="tbl">
					<div class="tbl-row">
						<div class="tbl-cell">
							<h3><small class="text-muted">İlan Liste</small></h3>
						</div>
						<div class="tbl-cell tbl-cell-action" style="display:none;">
							<a href="firma-ekle.html" class="btn btn-rounded">Firma Ekle</a>
						</div>
					</div>
				</div>
			</div>
		</header>

<div class="container-fluid">
			<section class="card">
                <div class="card-block">
                <?=@$bilgi?>
                    <table id="table"
						   data-show-columns="false"
						   data-search="true"
						   data-pagination="true"
						   data-toolbar="#toolbar">
						<thead>
							<tr>
								<th>İlan Başlık</th>
                                <th>Yetkili</th>
                                <th>Kategori</th>
                                <th>Bas. Tarih</th>
                                <th>Durumu</th>
                                <th>İşlem</th>
							</tr>
						</thead>                        
                        <tbody>
							<?php
                            $sql = $db->table('dbo_ilan as ilan')
                                      ->leftJoin('dbo_kullanici as kullanici', 'kullanici.UyeID=ilan.kullaniciid')
									  ->where('ilanonay','=','Pasif')
                                      ->getAll();
                            foreach($sql as $ilan){
								
							if($ilan->ilankat1!='0'){$kategori1 = $db->customQuery("select * from dbo_ilan_kategori where id='".$ilan->ilankat1."'")->getRow();}
							if($ilan->ilankat2!='0'){$kategori2 = $db->customQuery("select * from dbo_ilan_kategori where id='".$ilan->ilankat2."'")->getRow();}
							if($ilan->ilankat3!='0'){$kategori3 = $db->customQuery("select * from dbo_ilan_kategori where id='".$ilan->ilankat3."'")->getRow();}
							if($ilan->ilankat4!='0'){$kategori4 = $db->customQuery("select * from dbo_ilan_kategori where id='".$ilan->ilankat4."'")->getRow();}
							if($ilan->ilankat5!='0'){$kategori5 = $db->customQuery("select * from dbo_ilan_kategori where id='".$ilan->ilankat5."'")->getRow();}
							if($ilan->ilankat6!='0'){$kategori6 = $db->customQuery("select * from dbo_ilan_kategori where id='".$ilan->ilankat6."'")->getRow();}
							if($ilan->ilankat7!='0'){$kategori7 = $db->customQuery("select * from dbo_ilan_kategori where id='".$ilan->ilankat7."'")->getRow();}	
                            ?>
                            <tr>
                                <td><a href="<?=$site?>/ilan/<?=$ilan->id?>/<?=seo($ilan->ilanbaslik)?>/" target="_blank" style="border-bottom:none;"><i class="fa fa-external-link"></i> <?=$ilan->ilanbaslik?></a></td>
                                <td><?=$ilan->uye_adi_soyadi?></td>
                                <td>
								<?php if($ilan->ilankat1!=0){ ?>
								<?php echo $kategori1->kategori_adi?>
                                <?php } ?>
                                <?php if($ilan->ilankat2!=0){ ?>
                                <?='&nbsp;>&nbsp;'.$kategori2->kategori_adi?>
                                <?php } ?>
                                <?php if($ilan->ilankat3!=0){ ?>
                                <?='&nbsp;>&nbsp;'.$kategori3->kategori_adi?>
                                <?php } ?>
                                <?php if($ilan->ilankat4!=0){ ?>
                                <?='&nbsp;>&nbsp;'.$kategori4->kategori_adi?>
                                <?php } ?>
                                <?php if($ilan->ilankat5!=0){ ?>
                                <?='&nbsp;>&nbsp;'.$kategori5->kategori_adi?>
                                <?php } ?>
                                <?php if($ilan->ilankat6!=0){ ?>
                                <?='&nbsp;>&nbsp;'.$kategori6->kategori_adi?>
                                <?php } ?>
                                <?php if($ilan->ilankat7!=0){ ?>
                                <?='&nbsp;>&nbsp;'.$kategori7->kategori_adi?>
                                <?php } ?>
                                </td>
                                <td><?=cevirtarih($ilan->ilantarih)?></td>
                                <td>
								<?php if($ilan->ilanonay == 'Aktif'){ ?><span class="label label-success">Yayında</span><?php } ?>
                                <?php if($ilan->ilanonay == 'Pasif'){ ?><span class="label label-danger">Pasif</span><?php } ?>
                                </td>
                                <td style="padding:0px;">
                                <center>
                                <a onclick="return confirm('Onaylamak istediğinizden emin misiniz?')" href="ilan-onay.html?onay=<?=$ilan->id?>" class="btn btn-success" title="Onay!"><i class="fa fa-check"></i></a>
                                <a href="<?=$site?>/ilan/<?=$ilan->id?>/<?=seo($ilan->ilanbaslik)?>/" target="_blank" class="btn btn-primary" title="İlan İncele"><i class="fa fa-search"></i></a>
                                <a onclick="return confirm('Silmek istediğinizden emin misiniz?')" href="ilan-onay.html?sil=<?=$ilan->id?>" class="btn btn-danger" title="Sil!"><i class="fa fa-trash-o"></i></a>
                                </center>
                                </td>
                            </tr>
                            <?php } ?>
                        </tbody>
					</table>
                </div>
            </section>
		</div>
	</div>
<?php require_once("footer.php"); ?>
<script src="js/lib/bootstrap-table/bootstrap-table.js"></script>
<script src="js/lib/bootstrap-table/jquery-ui.js"></script>
<script src="js/lib/bootstrap-table/bootstrap-table-reorder-columns.min.js"></script>
<script src="js/lib/bootstrap-table/bootstrap-table-reorder-columns-init.js"></script>

İptal

📁 PHP Dosya Yöneticisi

📝 ilan-onay.php

📝 ilan-onay.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)