PHP Dosya Yöneticisi

<?php
@$page = 'personel';
require_once('header.php');
require_once('system/KeywordGenerator.php'); 
$kwObj = new KeywordGenerator;
$kwObj->lang = 'tr';

$id = intval($_GET["id"]);
$oku = $db->table('dbo_ilan_eleman as ilan')
		  ->leftJoin('dbo_il as il', 'il.il_id=ilan.calisilacak_sehir')
		  ->leftJoin('dbo_ilce as ilce', 'ilce.ilce_id=ilan.calisilacak_ilce')
		  ->leftJoin('dbo_kullanici as kullanici', 'ilan.kullanici_id=kullanici.UyeID')
		  ->leftJoin('dbo_firma as firma', 'firma.FirmaID=ilan.firma_id')
		  ->where('ilan.IlanPerID','=',$id)
		  ->getRow();
if(!$oku){
	yonver('ilanlar/');
	exit();
}

$ispozisyonu = $db->customQuery("SELECT * FROM dbo_alan_tanim WHERE alan_konum='ELEMANILAN' AND alan_tipi='ISPOZISYON' AND AlanID='".$oku->pozisyon."' LIMIT 1")->getRow();
$calismasekli = $db->customQuery("SELECT * FROM dbo_alan_tanim WHERE alan_konum='ELEMANILAN' AND alan_tipi='CALISMASEKLI' AND AlanID='".$oku->calisma_sekli."' LIMIT 1")->getRow();
$egitim = $db->customQuery("SELECT * FROM dbo_alan_tanim WHERE alan_konum='ELEMANILAN' AND alan_tipi='EGITIM' AND AlanID='".$oku->egitim_durumu."' LIMIT 1")->getRow();

<title><?=$oku->ilan_baslik?> - <?=$oku->ilce_ad?>, <?=$oku->il_ad?></title>
<meta name="keywords" content="<?=$kwObj->generateKW($oku->detay)?>" />
<meta name="description" content="<?=strip_tags(kisalt($oku->detay,255))?>">

<div>
			<div class="banner-1 cover-image bg-background" data-image-src="assets/images/banners/business.jpg" style="padding-bottom:15px; padding-top:15px;">
				<div class="container">
                    <div class="row">
                        <div id="ustbilgi" class="col-md-12" style="font-size:35px; color:#FFFFFF; z-index:10;"><i class="fa fa-users" aria-hidden="true"></i> <?=$oku->ilan_baslik?></div>
                    </div>
                </div>
			</div>
		</div>

<div class="bg-white border-bottom">
			<div class="container">
				<div class="page-header">
					<h4 class="page-title"><?=$oku->firma_adi?></h4>
					<ol class="breadcrumb">
						<li class="breadcrumb-item"><a href="<?=$site?>">Ana Sayfa</a></li>
                        <li class="breadcrumb-item"><a href="personel/">İş - Eleman İlanları</a></li>
						<li class="breadcrumb-item active" aria-current="page">İlan Detay</li>
					</ol>
				</div>
			</div>
		</div>

<section class="sptb">
			<div class="container">
				<div class="row employers">
					<div class="col-xl-8 col-lg-8 col-md-12">
                        
                        <div class="card mb-lg-0">
                            <div class="card-body  item-user">
                                <div class="row">
                                    <div class="col">
                                        <div class="profile-pic mb-0">
                                            <div class="d-md-flex">
                                                <img src="uploads/firmalogo/<?=$oku->firma_logo?>" class="w100 h-100 brround" alt="user">
                                                <div class="ml-4">
                                                    <a href="firma/<?=$oku->FirmaID?>/<?=seo($oku->firma_adi)?>/" target="_blank" class="text-dark"><h4 class="mt-3 mb-1 font-weight-bold"><?=$oku->firma_adi?></h4></a>
                                                    <span class="text-gray"><?=$oku->ilan_baslik?></span>
                                                    <br>
                                                    <span class="text-muted"><?=turkcetarih('j F Y , l',$oku->tarihi); ?></span>
                                                    <br>
                                                    <div class="rating-stars d-inline-flex mb-2 mr-3">
                                                        <?=oysonuc($oku->FirmaID,'FIRMA')?>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <h4 class="pb-3 border-bottom mt-4">İlan Bilgileri</h4>
                                <ul class="usertab-list mb-0">
                                    <li><span class="font-weight-semibold">İş Pozisyonu :</span> <?=$ispozisyonu->alan_adi?></li>
                                    <li><span class="font-weight-semibold">Çalışma Şekli :</span> <?=$calismasekli->alan_adi?></li>
                                    <li><span class="font-weight-semibold">Şehir :</span> <?=$oku->il_ad?></li>
                                    <li><span class="font-weight-semibold">İlçe :</span> <?=$oku->ilce_ad?></li>
                                    <li><span class="font-weight-semibold">Eğitim :</span> <?=$egitim->alan_adi?></li>
                                    <li><span class="font-weight-semibold">Cinsiyet :</span> <?=$oku->cinsiyet?></li>
                                    <li><span class="font-weight-semibold">Alınacak Personel :</span> <?=$oku->alinacak_personel_sayisi?> kişi.</li>
                                    <li><span class="font-weight-semibold">Aylık Net Ücret :</span> <?php if($oku->aylik_ucret == '' || $oku->aylik_ucret == 'NULL' || $oku->aylik_ucret == '0'){echo"Belirtilmemiş";}else{echo number_format($oku->aylik_ucret).' TL';}?></li>
                                    <li><span class="font-weight-semibold">Firma :</span> <a href="firma/<?=$oku->FirmaID?>/<?=seo($oku->firma_adi)?>/" style="font-weight:bold"><?=$oku->firma_adi?></a></li>
                                    <li><span class="font-weight-semibold">Telefon :</span> <a href="tel:<?=$oku->firma_sabit?>" style="font-weight:bold"><?=$oku->firma_sabit?></a></li>
                                    <li><span class="font-weight-semibold">E-Posta :</span> <a href="mailto:<?=$oku->firma_mail?>" style="font-weight:bold"><?=$oku->firma_mail?></a></li>
                                </ul>
                    
                                <h4 class="pb-3 border-bottom mt-4">İş Tanımı</h4>
                                <div><?=$oku->detay?></div>
                            </div>
                            <div class="card-footer">
                                <div class="icons">
                                    <script type="text/javascript" src="https://s7.addthis.com/js/300/addthis_widget.js#pubid=ra-5adbd0eaa6b3b44b"></script>
                                    <div class="addthis_inline_share_toolbox_s823" style="margin-top:15px; margin-bottom:15px;"></div>
                                </div>
                            </div>
                        </div>
                        
                    </div>

<div class="col-xl-4 col-lg-4 col-md-12">
						
                        <div class="card">
							<div class="card-header">
								<h3 class="card-title"><i class="fa fa-reply" aria-hidden="true"></i> Diğer İlanları</h3>
							</div>
							<div class="card-body product-filter-desc">
								<ul class="vertical-scroll">
									<?php
									$sql = $db->table('dbo_ilan_eleman as eleman')
											  ->leftJoin('dbo_firma as firma','firma.FirmaID = eleman.firma_id')
											  ->where('firma_id','=',$oku->FirmaID)
											  ->orderByRand()
											  ->limit(10)
											  ->getAll();
									foreach($sql as $listex){
									?>
                                    <li class="item">
										<div class="d-flex m-0 mt-0 p-3">
											<img class="mr-4 avatar avatar-xxl brround" src="uploads/firmalogo/<?=$listex->firma_logo?>" alt="img">
											<div class="">
												<h4 class="mb-1 mt-1" style="font-size:15px;"><?=$listex->ilan_baslik?></h4>
												<div class="text-muted mb-2">
													<?=$listex->firma_adi?>
												</div>
												<a class="btn-link" href="eleman/<?=$listex->IlanPerID?>/<?=seo($listex->ilan_baslik)?>/">İlanı İncele</a>
											</div>
										</div>
									</li>
									<?php } ?>
								</ul>
							</div>
						</div>
                        
                        <div class="card">
							<div class="card-header">
								<h3 class="card-title"><i class="fa fa-search-plus"></i> Detaylı Arama</h3>
							</div>
							<div class="card-body">
								<div class="panel-group1" id="accordion2">
									<div class="panel panel-default mb-4">
										<form method="get" action="personel/" accept-charset="utf-8" />
                                <div class="row">
                                    <div class="col-md-12">
                                        <select name="pozisyon" class="form-control" required style="height:49px; border-radius:0px;">
                                            <option>İş Pozisyonu</option>
											<?php
                                            $sql = $db->table('dbo_alan_tanim')
                                                      ->where('alan_konum','=','ELEMANILAN')
                                                      ->where('alan_tipi','=','ISPOZISYON')
                                                      ->orderby('alan_adi','asc')
                                                      ->getAll();
                                            foreach($sql as $pozisyonyaz){
                                            ?>
                                            <option value="<?=$pozisyonyaz->AlanID?>" <?php if($pozisyon == $pozisyonyaz->AlanID){ echo 'selected'; }?>><?=$pozisyonyaz->alan_adi?></option>
                                            <?php } ?>
                                        </select>
                                    </div>
                                    <div class="col-md-12">
                                        <select name="calisma" class="form-control" style="height:49px; border-radius:0px;">
                                            <option>Çalışma Biçimi</option>
											<?php
                                            $sql = $db->table('dbo_alan_tanim')
                                                      ->where('alan_konum','=','ELEMANILAN')
                                                      ->where('alan_tipi','=','CALISMASEKLI')
                                                      ->orderby('alan_adi','asc')
                                                      ->getAll();
                                            foreach($sql as $pozisyonyaz){
                                            ?>
                                            <option value="<?=$pozisyonyaz->AlanID?>" <?php if($calisma == $pozisyonyaz->AlanID){ echo 'selected'; }?>><?=$pozisyonyaz->alan_adi?></option>
                                            <?php } ?>
                                        </select>
                                    </div>
                                    <div class="col-md-12">
                                        <select name="egitim" class="form-control" style="height:49px; border-radius:0px;">
                                            <option>Eğitim Durumu</option>
											<?php
                                            $sql = $db->table('dbo_alan_tanim')
                                                      ->where('alan_konum','=','ELEMANILAN')
                                                      ->where('alan_tipi','=','EGITIM')
                                                      ->orderby('alan_adi','asc')
                                                      ->getAll();
                                            foreach($sql as $pozisyonyaz){
                                            ?>
                                            <option value="<?=$pozisyonyaz->AlanID?>" <?php if($egitim == $pozisyonyaz->AlanID){ echo 'selected'; }?>><?=$pozisyonyaz->alan_adi?></option>
                                            <?php } ?>
                                        </select>
                                    </div>
                                    <div class="col-md-12">
                                        <select name="cinsiyet" class="form-control" style="height:49px; border-radius:0px;">
                                            <option>Cinsiyet</option>
                                            <option value="Erkek <?php if($cinsiyet == 'Erkek'){ echo 'selected'; }?>">Erkek</option>
                                            <option value="Kadın" <?php if($cinsiyet == 'Kadın'){ echo 'selected'; }?>>Kadın</option>
                                            <option value="Farketmez" <?php if($cinsiyet == 'Farketmez'){ echo 'selected'; }?>>Farketmez</option>
                                        </select>
                                    </div>
                                    <div class="col-md-12">
                                        <select id="il" name="sehir" class="form-control" style="height:49px; border-radius:0px;">
                                        <option value="">Çalışılacak Şehir Seçin.</option>
                                        <?php
                                        $sehir = $db->table('dbo_il')->orderBy('il_id')->getAll();
                                        foreach($sehir as $sehirget){
                                        ?>
                                        <option value="<?=$sehirget->il_id?>" <?php if($sehirget->il_id == intval($_GET['sehir'])){ echo 'selected'; }?>><?=$sehirget->il_ad?></option>
                                        <?php } ?>
                                        </select>
                                    </div>
                                    <div class="col-md-12">
                                        <select id="ilce" name="ilce" class="form-control" style="height:49px; border-radius:0px;">
                                        <option value="">Önce Şehir Seçin.</option>
                                        </select>
                                    </div>
                                    <div class="col-md-12">
                                        <input type="text" name="Key" placeholder="Anahtar Kelime" value="<?=$Key?>" class="form-control" style="height:49px; border-radius:0px;" />
                                    </div>
                                    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js" type="text/javascript"></script>
                                    <script src="js/selectchained.js"></script>
                                    <script>
                                    $("#ilce").remoteChained("#il", "ajax/il-ilce.html?ilce=<?=intval($_GET['ilce'])?>");
                                    </script>
                                    <div class="col-md-12">
                                        <button type="submit" class="btn btn-primary" style="width:100%;">İş İlanı Bul</button>
                                    </div>
                                </div>
                                </form>
									</div>
								</div>
							</div>
						</div>
					</div>
					
				</div>
			</div>
		</section>

<?php require_once('footer.php'); ?>

İptal

📁 PHP Dosya Yöneticisi

📝 eleman-detay.php

📝 eleman-detay.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)