PHP Dosya Yöneticisi

<?php
@$menu = 'firma-islemleri'; @$page = 'firma-liste';
require_once("header.php");
require_once("menu-left.php");
require_once("../include/class.upload.php");

$duzenid = intval($_GET["id"]);
$oku = $db->table('dbo_firma')->where('FirmaID','=',$duzenid)->getRow();
if(!$oku){
	yonver('firma-liste.html');
	exit();
}

if(isset($_POST['kaydet']) && admin_login_check($db) == true){

$image = new Upload($_FILES['firmalogo']);
	if ( $image->uploaded ) {
	$image->file_new_name_body = seo($_POST['firma_adi']);
	$image->allowed = array('image/jpeg','image/jpg','image/gif','image/png');
	$image->mime_check = true;
	$image->no_script = true;
	$image->Process( '../uploads/firmalogo/'.date("Y").'/'.date("m").'' );
	
	if (!file_exists('../uploads/firmalogo/'.date("Y").'/'.date("m").'/index.html')) { touch('../uploads/firmalogo/'.date("Y").'/'.date("m").'/index.html'); }
}
	
$data = [
    'firma_adi' 		=> $_POST['firma_adi'],
	'firma_kul_id'		=> intval($_POST['firma_kul_id']),
    'firma_yetkili'  	=> guvenlik($_POST['firma_yetkili']),
    'firma_sabit'		=> guvenlik($_POST['firma_sabit']),
	'firma_gsm'			=> guvenlik($_POST['firma_gsm']),
	'firma_fax'			=> guvenlik($_POST['firma_fax']),
	'firma_web'			=> guvenlik($_POST['firma_web']),
	'firma_aciklama'	=> $_POST['firma_aciklama'],
	'firma_mail'		=> guvenlik($_POST['firma_mail']),
	'firma_il'			=> guvenlik($_POST['firma_il']),
	'firma_ilce'		=> pasifguvenlik($_POST['firma_ilce']),
	'firma_adres'		=> guvenlik($_POST['firma_adres']),
	'firma_ana_kat_id'	=> implode(",",$_POST['kategori']),
	'firma_desc'		=> guvenlik($_POST['firma_desc']),
	'firma_meta'		=> guvenlik($_POST['firma_meta']),
	'firma_facebook'	=> guvenlik($_POST['firma_facebook']),
	'frma_twitter'		=> guvenlik($_POST['frma_twitter']),
	'firma_instagram'	=> guvenlik($_POST['firma_instagram']),
	'firma_durum'		=> '1',
	'firma_linkedin'	=> guvenlik($_POST['firma_linkedin']),
	'firma_lat'			=> guvenlik($_POST['lat']),
	'firma_lng'			=> guvenlik($_POST['long']),
	'firma_acil_kat'	=> guvenlik($_POST['firma_acil_kat'])
	];
	
	$isle = $db->table('dbo_firma')->where('FirmaID','=',$oku->FirmaID)->update($data);

if(!empty($image->file_dst_name) && !empty($_FILES['firmalogo'])){
		$resup = [ 'firma_logo' => date("Y").'/'.date("m").'/'.$image->file_dst_name ];
		$logo = $db->table('dbo_firma')->where('FirmaID','=',$oku->FirmaID)->update($resup);
	}

$insert = $oku->FirmaID;
/**********************************************************************************************/
$resims = seo($_POST['firma_adi']);
$resimler = array();
foreach ($_FILES['resim'] as $k => $l) {
   foreach ($l as $i => $v) {
      if (!array_key_exists($i, $resimler))
         $resimler[$i] = array();
            $resimler[$i][$k] = $v;
   }
}
$YuklenenResimler ='';
foreach ($resimler as $resim){
   $foo = new Upload($resim); 
   if ($foo->uploaded) {
      $foo->file_new_name_body = $resims;
	  $foo->allowed = array('image/jpeg','image/jpg','image/gif','image/png');
	  $foo->mime_check = true;
	  $foo->no_script = true;
      $foo->image_convert = 'jpg';
      $foo->Process( '../uploads/firmaresim/'.date("Y").'/'.date("m").'' );
	  
	  if (!file_exists('../uploads/firmaresim/'.date("Y").'/'.date("m").'/index.html')) { touch('../uploads/firmaresim/'.date("Y").'/'.date("m").'/index.html'); }
	  
   }
   $YuklenenResimler.=$foo->file_dst_name;
   
   $resdata = [
    'firma_id'	=> $insert,
    'resim_adi'	=> date("Y").'/'.date("m").'/'.$foo->file_dst_name
	];
	
	if(!empty($foo->file_dst_name) && !empty($_FILES['resim'])){
	$gonder = $db->table('dbo_firma_resimler')->insert($resdata);
	}
   
}

/*************************************************/
if(!empty($_POST["vidkod"])){
$VidKodCount = 0;
foreach($_POST["vidkod"] as $key=>$vidkodid)
{
    $data = [ 'firma_id'		=> $oku->FirmaID,
			  'firma_vid_ad'	=> guvenlik($_POST["vidadi"][$key]),
			  'firma_vid_kod'	=> guvenlik($_POST["vidkod"][$key])];
			  
	$kkayit = $db->table('dbo_firma_video')->insert($data);      
    if($kkayit) // data inserted, so it will return 1
    {
      $VidKodCount ++;
    }
}}
/*************************************************/

if($isle || $gonder || $logo || $kkayit){
		$bilgi = alert('success','Firma Düzenlendi','firma-liste.html',3);
		}else{
		$bilgi = alert('danger','Firma Düzenlenemdi!','firma-liste.html',3);
	}

}
?>
<link href="css/separate/vendor/tags_editor.min.css" rel='stylesheet' type='text/css'>
<link href="css/select2.min.css" rel="stylesheet" />
<link rel="stylesheet" href="../js/summernote/summernote.css"/>
<link rel="stylesheet" href="../js/summernote/editor.min.css">
<style>
#videoUpload-1 {
	display:none;
}
</style>
	<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">Firma Düzenleme İşlemi</small></h3>
						</div>
						<div class="tbl-cell tbl-cell-action" style="display:none;">
							<a href="#" class="btn btn-rounded">Add member</a>
						</div>
					</div>
				</div>
			</div>
		</header>

<div class="container-fluid">
        <?=@$bilgi?>
        <form id="form_validation" method="POST" action="" enctype="multipart/form-data">
			<div class="col-lg-6">
                <section class="card">
                    <header class="card-header">
                        Firma Bilgileri
                    </header>
                    <div class="card-block">
                            <fieldset class="form-group">
                                <label class="form-label">Firma Kullanıcı</label>
                                <select name="firma_kul_id" type="text" class="form-control" required>
                                <option value="">Kullanıcı Seçin.</option>
                                <option value="0" <?php if($oku->firma_kul_id == 0){ echo "selected"; }?>>Manuel Ekleme</option>
                                <?php
                                $kullanici = $db->table('dbo_kullanici')->orderBy('uye_adi_soyadi','asc')->getAll();
                                foreach($kullanici as $kullaniciget){
                                ?>
                                <option value="<?=$kullaniciget->UyeID?>" <?php if($oku->firma_kul_id == $kullaniciget->UyeID){ echo "selected"; }?>>#<?=$kullaniciget->UyeID?> <?=$kullaniciget->uye_adi_soyadi?> - <?=$kullaniciget->uye_mail?></option>
                                <?php } ?>
                                </select>
                            </fieldset>
                            <fieldset class="form-group">
                                <label class="form-label">Firma Adı</label>
                                <input name="firma_adi" type="text" value="<?=$oku->firma_adi?>" class="form-control" required>
                            </fieldset>
                            <fieldset class="form-group">
                                <label class="form-label">Firma Yetkili Adı</label>
                                <input name="firma_yetkili" type="text" value="<?=$oku->firma_yetkili?>" class="form-control" required>
                            </fieldset>
                            
                            <div class="row">
                            	<div class="col-md-4">
                                    <fieldset class="form-group">
                                        <label class="form-label">Firma Telefon (Sabit)</label>
                                        <input type="text" name="firma_sabit" value="<?=$oku->firma_sabit?>" class="form-control" maxlength="11">
                                        <small class="text-muted">Örnek: 02221112222</small>
                                    </fieldset>
                            	</div>
                                <div class="col-md-4">
                                    <fieldset class="form-group">
                                        <label class="form-label">Firma Telefon (GSM)</label>
                                        <input type="text" name="firma_gsm" value="<?=$oku->firma_gsm?>" class="form-control" maxlength="11">
                                        <small class="text-muted">Örnek: 02221112222</small>
                                    </fieldset>
                            	</div>
                                <div class="col-md-4">
                                    <fieldset class="form-group">
                                        <label class="form-label">Firma Telefon (Fax)</label>
                                        <input type="text" name="firma_fax" value="<?=$oku->firma_fax?>" class="form-control" maxlength="11">
                                        <small class="text-muted">Örnek: 02221112222</small>
                                    </fieldset>
                            	</div>
                            </div>
                            <div class="row">
                            	<div class="col-md-6">
                                <fieldset class="form-group">
                                    <label class="form-label">Firma Kategori</label>
                                    <select name="kategori[]" type="text" class="js-example-basic-multiple form-control" multiple="multiple" required>
									<?php
                                    $grup = $db->table('dbo_sektorler')->where('sektor_tip','=','SEKTOR')->where('sektor_acil','!=','E')->getAll();
                                    foreach($grup as $grupget){
                                        echo "<optgroup label='".$grupget->sektor_adi."'>" ;
                                    $kat = $db->table('dbo_sektorler_alt')->where('sektoralt_ust','=',$grupget->sektor_id)->getAll();
                                    foreach($kat as $katget){
                                    $katlar = explode(',', $oku->firma_ana_kat_id);
                                    ?>
                                    <option value="<?=$katget->sektoralt_id?>" <?php if(in_array($katget->sektoralt_id, $katlar)) { echo 'selected'; } ?>><?=$katget->sektoralt_adi?></option>
                                    <?php } echo  "</optgroup>"; } ?>
                                    </select>
                                    </fieldset>
                                </div>
                                <div class="col-md-6">
                                    <fieldset class="form-group">
                                        <label class="form-label">Acil Hizmet</label>
                                        <select name="firma_acil_kat" type="text" class="form-control" required>
                                        <option value="0" <?php if($oku->firma_acil_kat == 0){ echo "selected"; } ?>>Acil Hizmet Vermiyor</option>
                                        <?php
                                        $acil = $db->table('dbo_sektorler')
												   ->where('sektor_tip','=','SEKTOR')
												   ->orderBy('sektor_adi','asc')
												   ->where('sektor_acil','=','E')
												   ->getAll();
                                        foreach($acil as $acilget){
                                        ?>
                                        <option value="<?=$acilget->sektor_id?>" <?php if($acilget->sektor_id == $oku->firma_acil_kat){ echo "selected"; } ?>><?=$acilget->sektor_adi?></option>
                                        <?php } ?>
                                        </select>
                                    </fieldset>
                            	</div>
                                <div class="col-md-6">
                                    <fieldset class="form-group">
                                        <label class="form-label">Firma Web Sitesi (URL)</label>
                                        <input type="text" name="firma_web" value="<?=$oku->firma_web?>" class="form-control">
                                        <small class="text-muted">Örnek: http://www.alanadi.com</small>
                                    </fieldset>
                            	</div>
                                <div class="col-md-6">
                                    <fieldset class="form-group">
                                        <label class="form-label">Firma Mail Adresi</label>
                                        <input name="firma_mail" type="email" value="<?=$oku->firma_mail?>" class="form-control" required>
                                    </fieldset>
                            	</div>
                            </div>
                            <div class="row">
                            	<div class="col-md-6">
                                    <fieldset class="form-group">
                                        <label class="form-label">Firma Şehir</label>
                                        <select id="il" name="firma_il" type="text" class="form-control" required>
                                        <option value="">Şehir Seçin.</option>
                                        <?php
                                        $sehir = $db->table('dbo_il')->select('*')->orderBy('il_id')->getAll();
                                        foreach($sehir as $sehirget){
                                        ?>
                                        <option value="<?=$sehirget->il_id?>" <?php if($sehirget->il_id == $oku->firma_il){ echo "selected"; } ?>><?=$sehirget->il_ad?></option>
                                        <?php } ?>
                                        </select>
                                    </fieldset>
                            	</div>
                                <div class="col-md-6">
                                    <fieldset class="form-group">
                                        <label class="form-label">Firma İlçe</label>
                                        <select id="ilce" name="firma_ilce" type="text" class="form-control" required>
                                        <option value="">Önce Şehir Seçin.</option>
                                        </select>
                                    </fieldset>
                                    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js" type="text/javascript"></script>
                                    <script src="../js/selectchained.js" type="text/javascript"></script>
                                    <script type="text/javascript">
                                    $("#ilce").remoteChained("#il", "../ajax/il-ilce.html?ilce=<?=$oku->firma_ilce?>");
                                    </script>
                            	</div>
                                <div class="col-md-3">
                                <fieldset class="form-group">
                                    <label class="form-label">Firma Facebook</label>
                                    <input name="firma_facebook" type="text" value="<?=$oku->firma_facebook?>" class="form-control">
                                </fieldset>
                                </div>
                                <div class="col-md-3">
                                    <fieldset class="form-group">
                                        <label class="form-label">Firma Twitter</label>
                                        <input name="frma_twitter" type="text" value="<?=$oku->frma_twitter?>" class="form-control">
                                    </fieldset>
                                </div>
                                <div class="col-md-3">
                                    <fieldset class="form-group">
                                        <label class="form-label">Firma Instagram</label>
                                        <input name="firma_instagram" type="text" value="<?=$oku->firma_instagram?>" class="form-control">
                                    </fieldset>
                                </div>
                                <div class="col-md-3">
                                    <fieldset class="form-group">
                                        <label class="form-label">Firma LinkedIn</label>
                                        <input name="firma_linkedin" type="text" value="<?=$oku->firma_linkedin?>" class="form-control">
                                    </fieldset>
                                </div>
                                <div class="col-md-12">
                                <fieldset class="form-group" style="margin-bottom:5px; padding-bottom:0px;">
                                    <label class="form-label">Firma Adresi</label>
                                    <textarea type="text" name="firma_adres" class="form-control" rows="5" required><?=$oku->firma_adres?></textarea>
                                </fieldset>
                                </div>
                            </div>
                    </div>
                </section>
            </div>
            
            <div class="col-lg-6">
                <section class="card">
                    <header class="card-header">
                        Diğer Bilgiler
                    </header>
                    <div class="card-block">
                         <div class="row">
                         	<div class="col-md-6">
                            <fieldset class="form-group">
                                <label class="form-label">Firma Logo</label>
                                <input type="file" name="firmalogo" size="50" class="form-control btn btn-primary"/>
                             </fieldset>
                            </div>
                            <div class="col-md-6">
                            <fieldset class="form-group">
                                <label class="form-label">Firma Resimleri (Max 1Mb.)</label>
                                <input type="file" name="resim[]" size="50" class="form-control btn btn-primary" multiple/>
                             </fieldset>
                            </div>
                            <div class="col-md-12">
                            <fieldset class="form-group">
                                <label class="form-label">Firma Description (Kısa Açıklama)</label>
                                <textarea type="text" name="firma_desc" rows="4" class="form-control" required><?=$oku->firma_desc?></textarea>
                            </fieldset>
                            </div>
                            <div class="col-md-12">
                            <fieldset class="form-group">
                                <label class="form-label">Firma Anahtar Kelime (Virgül İle Ayırın)</label>
                                <textarea id="tags-editor-textarea" type="text" name="firma_meta" class="form-control" required><?=$oku->firma_meta?></textarea>
                            </fieldset>
                            </div>
                            <div class="col-md-12">
                            <fieldset class="form-group">
                            <label class="form-label">Firma Harita Konumu <span style="font-size:10px;">( Aşağıdaki kutucuğa tıklayarak konumu yakınlaştırabilirsiniz. )</span></label>
                            <input id="sehir" type="text" class="form-control" placeholder="Haritada konum arayın, adres ya da il - ilçe yazın..." style="border-radius:0px; margin-bottom:5px;">
                            <div id="map" style="width:100%; height:300px;"></div>
                            </fieldset>
                            </div>
                            <div class="col-md-6"><input id="lat" name="lat" value="<?=$oku->firma_lat?>" class="form-control" readonly></div>
                            <div class="col-md-6"><input id="long" name="long" value="<?=$oku->firma_lng?>" class="form-control" readonly></div>
                         </div>
                    </div>
                </section>
            </div>
            
            <div class="col-lg-12">
                <section class="card">
                <header class="card-header">
                      Firma Resimleri
                </header>
                    <div class="card-block">
                        <?php
						$resim = $db->table('dbo_firma_resimler')->where('firma_id','=',$oku->FirmaID)->getAll();
						foreach($resim as $resimget){
						?>
                        <div class="col-md-1 col-sm-1 col-xs-6">
                        	<p>
                            <img src='<?=$site?>/thumb.php?src=./uploads/firmaresim/<?=$resimget->resim_adi?>&size=100X100' />
                        	<a id="<?=$resimget->FirmaResID?>" class="frrssil btn btn-primary" style="border-radius:0px; width:100%;">Resmi Sil</a>
                        	</p>
                        </div>
                        <?php } ?>
                    </div>
                </section>
            </div>
            
            <div class="col-lg-12">
                <section class="card">
                    <header class="card-header">
                        Videolar
                    </header>
                    <div class="card-block">
                         <div class="opt-form row">
                         	<div class="col-md-6">
                                <fieldset class="form-group">
                                <label class="form-label">Video Adı</label>
                                <input id="box1" name="vidadi[]" type="text" class="form-control">
                                </fieldset>
                            </div>
                            <div class="col-md-5">
                                <fieldset class="form-group">
                                <label class="form-label">Video URL</label>
                                <input id="box1" name="vidkod[]" placeholder="Youtube." type="text" class="form-control">
                                </fieldset>
                            </div>
                            <div class="col-md-1">
                                <fieldset class="form-group">
                                <label class="form-label">İşlem</label>
                                <input type="button" class="btnDel btn btn-danger" value="Sil" disabled="disabled" />
                                </fieldset>
                            </div>
                         </div>
                         <div class="col-md-1" style="padding-left:0px;">
                            <fieldset class="form-group">
                            <input type="button" id="btnAdd" class="btn btn-primary" value="Yeni Alan Ekle" />
                            </fieldset>
                        </div>
                    </div>
                </section>
            </div>
            
            <div class="col-lg-12">
                <section class="card">
                    <header class="card-header">
                        Video Liste
                    </header>
                    <div class="card-block">
                    	<?php
						$kalkis = $db->table('dbo_firma_video')
									 ->where('firma_id','=',$oku->FirmaID)
									 ->where('firma_vid_kod','!=','')
									 ->getAll();
						foreach($kalkis as $liste){
						?>
                         <div class="ksilinecek row">
                         	<div class="col-md-6">
                                <fieldset class="form-group">
                                <label class="form-label">Video Adı</label>
                                <input id="box1" value="<?=$liste->firma_vid_ad?>" type="text" class="form-control" readonly>
                                </fieldset>
                            </div>
                            <div class="col-md-5">
                                <fieldset class="form-group">
                                <label class="form-label">Video URL</label>
                                <input id="box1" value="<?=$liste->firma_vid_kod?>" placeholder="Youtube." type="text" class="form-control" readonly>
                                </fieldset>
                            </div>
                            <div class="col-md-1">
                                <fieldset class="form-group">
                                <label class="form-label">İşlem</label>
                                <input id="<?=$liste->FirVidID?>" type="button" class="KDel btn btn-danger" value="Sil" />
                                </fieldset>
                            </div>
                         </div>
                         <?php } ?>
                    </div>
                </section>
            </div>
            
            <div class="col-lg-12">
                <section class="card">
                    <div class="card-block">
                         <fieldset class="form-group">
                        	<label class="form-label">Firma Tanıtım</label>
                            <textarea id="summernote" class="fr-box fr-basic fr-top" name="firma_aciklama"><?=$oku->firma_aciklama?></textarea>
                         </fieldset>
                    </div>
                </section>
            </div>
            
            <div class="col-lg-12">
                <section class="card">
                    <div class="card-block">
                        <fieldset class="form-group" style="margin-bottom:0px;">
                            <button type="submit" name="kaydet" class="btn">Bilgileri Kaydet</button>
                        </fieldset>
                    </div>
                </section>
            </div>
            </form>
		</div>
	</div>
<?php require_once("footer.php"); ?>
<script src="js/jquery.validate.js"></script>
<script src="js/form-validation.js"></script>
<script src="js/select2.min.js"></script>
<script type='text/javascript' src="js/lib/jquery-tag-editor/jquery.tag-editor.min.js"></script>
<script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?key=<?=ayar('googlemap_key')?>&libraries=places"></script>
<script type='text/javascript' src='../js/gmap.js'></script>
<script src="../js/summernote/summernote.min.js"></script>
<script src="../js/summernote/lang/summernote-tr-TR.js"></script>
<script>
$(document).ready(function () {
    var $summernote = $('#summernote').summernote({
        height: 300,
		  toolbar: [
			['style', ['style', 'paragraph']],
			['fontsize', ['fontsize']],
			['font', ['bold', 'italic', 'underline', 'strikethrough', 'clear']],
			['fontname', ['fontname']],
			['color', ['color']],
			['para', ['ul', 'ol', 'paragraph']],
			['height', ['height']],
			['insert', ['picture', 'video', 'link', 'hr']],
			['table', ['table']]
		  ],
		lang: 'tr-TR',
        callbacks: {
            onImageUpload: function (files) {
                sendFile($summernote, files[0]);
            }
        }
    });
});

}
</script>
<script>
	$(function() {
		$('#tags-editor-textarea').tagEditor();
	});
</script>
<script>
$(document).ready(function() {
    $('.js-example-basic-multiple').select2();
});
</script>
<script type="text/javascript">
$(document).ready(function() {
	var inputs = 1; 
	
	$('#btnAdd').click(function() {
		$('.btnDel:disabled').removeAttr('disabled');
		var c = $('.opt-form:first').clone(true);
			c.children(':text').attr('name','input'+ (++inputs) );
		$('.opt-form:last').after(c);
	});
	
	$('.btnDel').click(function() {
		if (confirm('Alan Silinsinmi?')) {
			--inputs;
			$(this).closest('.opt-form').remove();
			$('.btnDel').attr('disabled',($('.opt-form').length  < 2));
		}
	});
	
	
});
</script>

İptal

📁 PHP Dosya Yöneticisi

📝 firma-duzenle.php

📝 firma-duzenle.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)