PHP Dosya Yöneticisi

<?php
	if(!in_array(3,$yetki)){
		die('<meta http-equiv="refresh" content="0;url='.$site.'admin">');
	}

$_title = $dil_kontrol['baslik'].' - Ürün';

if($_POST){

if(isset($_GET['duzenle_id']) AND !isset($_GET['kopyala'])){
			$guncelle = $db->prepare("UPDATE urun SET baslik = ?, link = ?, kisa_aciklama = ?, stok_kodu = ?, stok = ?, marka_id = ?, piyasa_fiyat = ?, fiyat = ?, kargo_fiyat = ?, kdv = ?, aciklama = ?, kur_tipi = ?, durum = ?, kategori_id = ?, etiket = ? WHERE id = ? AND dil = ? LIMIT 1");
	        $guncelle = $guncelle->execute(array($_POST['baslik'],sef($_POST['link']),$_POST['kisa_aciklama'],$_POST['stok_kodu'],$_POST['stok'],$_POST['marka_id'],$_POST['piyasa_fiyat'],$_POST['fiyat'],$_POST['kargo_fiyat'],$_POST['kdv'],$_POST['aciklama'],$_POST['kur_tipi'],$_POST['durum'],$_POST['kategori_id'],$_POST['etiket'],$_GET['duzenle_id'],$dil));
	        $urun_id = $_GET['duzenle_id'];
	        if($guncelle){
	        	$mesaj = array('İşlem Başarılı','Güncelleme İşleminiz Başarı İle Gerçekleşti','success');
	        	$db->exec("DELETE FROM urun_resim WHERE dil = '{$dil}' AND urun_id = '{$urun_id}' ");
	        	$db->exec("DELETE FROM urun_varyant WHERE dil = '{$dil}' AND urun_id = '{$urun_id}' ");
	        	$db->exec("DELETE FROM urun_varyant_secenek WHERE dil = '{$dil}' AND urun_id = '{$urun_id}' ");
	        	$db->exec("DELETE FROM urun_varyant_secenek_fiyat_stok WHERE dil = '{$dil}' AND urun_id = '{$urun_id}' ");
	        }else{
	        	$mesaj = array('İşlem Başarısız','Güncelleme İşlemi Sırasında Bir Hata Oluştu','error');
	        }
		}else{
			$ekle = $db->prepare("INSERT INTO urun SET dil = ?, baslik = ?, link = ?, kisa_aciklama = ?, stok_kodu = ?, stok = ?, marka_id = ?, piyasa_fiyat = ?, fiyat = ?, kargo_fiyat = ?, kdv = ?, aciklama = ?, kur_tipi = ?, goruntulenme = ?, durum = ?, kategori_id = ?, etiket = ?");
	        $ekle = $ekle->execute(array($dil,$_POST['baslik'],sef($_POST['link']),$_POST['kisa_aciklama'],$_POST['stok_kodu'],$_POST['stok'],$_POST['marka_id'],$_POST['piyasa_fiyat'],$_POST['fiyat'],$_POST['kargo_fiyat'],$_POST['kdv'],$_POST['aciklama'],$_POST['kur_tipi'],0,$_POST['durum'],$_POST['kategori_id'],$_POST['etiket']));
	        $urun_id = $db->lastInsertId();
	        if($ekle){
	        	$mesaj = array('İşlem Başarılı','Veri Ekleme İşleminiz Başarı İle Gerçekleşti','success');
	        }else{
	        	$mesaj = array('İşlem Başarısız','Veri Ekleme İşlemi Sırasında Bir Hata Oluştu','error');
	        }
		}
	
		if($urun_id > 0){

if(!empty($_POST['resim'])){
				$i = 0;
				foreach($_POST['resim'] as $resim){
					$ekle = $db->prepare("INSERT INTO urun_resim SET dil = ?, urun_id = ?, resim = ?, sira = ?");
			        $ekle = $ekle->execute(array($dil,$urun_id,$resim,$_POST['resim_sira'][$i]));
					$i++;
				}
			}

if(!empty($_POST['varyant_sayisi']) AND $_POST['varyant_sayisi'] > 0){
				$varyant = array();
				for ($i = 0; $i <= $_POST['varyant_sayisi']; $i++) { 
					if(!empty($_POST['varyant_'.$i]) AND isset($_POST['varyant_'.$i])){
						if(!empty($_POST['altvaryant_'.$i]) AND isset($_POST['altvaryant_'.$i])){
							$ekle = $db->prepare("INSERT INTO urun_varyant SET dil = ?, urun_id = ?, baslik = ?");
			        		$ekle = $ekle->execute(array($dil,$urun_id,$_POST['varyant_'.$i][0]));
			        		$varyant_id = $db->lastInsertId();
							$altvaryant = array();
							foreach($_POST['altvaryant_'.$i] as $alt_varyant){
								$ekle = $db->prepare("INSERT INTO urun_varyant_secenek SET dil = ?, urun_id = ?, urun_vayant_id = ?, baslik = ?");
			        			$ekle = $ekle->execute(array($dil,$urun_id,$varyant_id,$alt_varyant));
								$altvaryant[] = $alt_varyant;
							}
							$varyant[] = $altvaryant;
						}
					}
				}

$i = 0;
				foreach(ticifastcomtr_kombinasyon($varyant) as $veri){
					$varyant_key = '';
					foreach($veri as $v){
						$altvaryant_id = $db->query("SELECT * FROM urun_varyant_secenek WHERE dil = '{$dil}' AND urun_id = '{$urun_id}' AND baslik = '{$v}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
		        		$varyant_key .= $altvaryant_id['id'].'-';
		        	}
		        	if(empty($_POST['varyant_fiyat'][$i]) OR !isset($_POST['varyant_fiyat'][$i])){ $_POST['varyant_fiyat'][$i] = 0; }
		        	if(empty($_POST['varyant_stok'][$i]) OR !isset($_POST['varyant_stok'][$i])){ $_POST['varyant_stok'][$i] = 0; }
		        	$ekle = $db->prepare("INSERT INTO urun_varyant_secenek_fiyat_stok SET dil = ?, urun_id = ?, varyant_key = ?, fiyat = ?, stok = ?");
			        $ekle = $ekle->execute(array($dil,$urun_id,$varyant_key,$_POST['varyant_fiyat'][$i],$_POST['varyant_stok'][$i]));
					$i++;
				}

}
		}

if(isset($_GET['kopyala'])){
			echo '<meta http-equiv="refresh" content="2;url='.$dil.'/'.$sayfa.'/duzenle/'.$urun_id.'">';
		}

}

if(isset($_GET['duzenle_id'])){
		$duzenle = $db->query("SELECT * FROM urun WHERE id = '{$_GET['duzenle_id']}' AND dil = '{$dil}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
		if($duzenle){
			?>
			<script type="text/javascript">
				$(function(){
		            $('select[name="marka_id"] option[value="<?php echo $duzenle['marka_id']; ?>"]').attr('selected','select');
		            $('select[name="kdv"] option[value="<?php echo $duzenle['kdv']; ?>"]').attr('selected','select');
		            $('select[name="kur_tipi"] option[value="<?php echo $duzenle['kur_tipi']; ?>"]').attr('selected','select');
		            $('select[name="durum"] option[value="<?php echo $duzenle['durum']; ?>"]').attr('selected','select');
		            $('select[name="kategori_id"] option[value="<?php echo $duzenle['kategori_id']; ?>"]').attr('selected','select');
		            $('select[name="etiket"] option[value="<?php echo $duzenle['etiket']; ?>"]').attr('selected','select');
				});
			</script>
			<?php
		}else{
			$mesaj = array('İşlem Başarısız','Veri Bulunamadı','error');
			echo '<meta http-equiv="refresh" content="2;url='.$dil.'/'.$sayfa.'">';
		}
	}
?>

<div class="col-md-12 col-xl-12 col-xs-12 col-sm-12">
	<div class="card">
		<div class="card-body">
			<div class="main-content-label mg-b-5">
				[$_title] Genel Bilgileri
			</div>
			<p style="margin: 0px;">Ekleme, Güncelleme ve Silme İşlemleri Bu Sayfada Yapılmaktadır.</p>
			<?php include 'inc/dil-yonlendirici.php'; ?>
		</div>
	</div>
</div>

<div class="col-xl-12">
	<div class="card mg-b-20">
		<div class="card-header pb-0">
			<div class="d-flex justify-content-between">
				<h4 class="card-title mg-b-2 mt-2">[$_title] Ekleme ve Güncelleme Formu</h4>
			</div>
		</div>
		<div class="card-body">
			<form action="" method="post" id="urun_formu">
				<div class="col-md-12 col-xl-12 col-xs-12 col-sm-12">
			  		<div class="row row-sm">
						<div class="col-lg-4 mg-b-20">
							<label>Ürün Adı</label>
							<input type="text" class="form-control" name="baslik" value="<?php echo @$duzenle['baslik']; ?>" data-sef-in placeholder="Ürün Adı Giriniz" required>
						</div>
						<div class="col-lg-4 mg-b-20">
							<label>Ürün Linki</label>
							<input type="text" class="form-control" name="link" value="<?php echo @$duzenle['link']; ?>" data-sef-out placeholder="Ürün Linki" required>
						</div>
						<div class="col-lg-4 mg-b-20">
							<label>Kısa Açıklaması</label>
							<input type="text" class="form-control" name="kisa_aciklama" value="<?php echo @$duzenle['kisa_aciklama']; ?>" placeholder="Kısa Açıklaması" required>
						</div>
					</div>
					<div class="row row-sm">
						<div class="col-lg-3 mg-b-20">
							<label>Stok Kodu</label>
							<input type="text" class="form-control" name="stok_kodu" value="<?php echo @$duzenle['stok_kodu']; ?>" placeholder="Stok Kodu">
						</div>
						<div class="col-lg-3 mg-b-20">
							<label>Stok Sayısı (Varyantsız Ürünler İçin)</label>
							<input type="text" class="form-control" name="stok" value="<?php echo @$duzenle['stok']; ?>" placeholder="Stok Sayısı" value="">
						</div>
						<div class="col-lg-3 mg-b-20">	
							<label>Ürün Markası</label>
							<select class="form-control select2" name="marka_id">
								<option value="0">Markasız Ürün</option>
								<?php
				                    $query = $db->query("SELECT * FROM marka WHERE dil = '{$dil}' ORDER BY id ASC", PDO::FETCH_ASSOC);
				                    if($query->rowCount()){
				                        foreach($query as $row){
				                        	echo '<option value="'.$row['id'].'">'.$row['baslik'].'</option>';
				                        }
				                    }
			                    ?>
							</select>
						</div>
						<div class="col-lg-3 mg-b-20">	
							<label>Satış Kur Tipi</label>
							<select class="form-control select2" name="kur_tipi">
								<option value="1">TL</option>
								<option value="2">$</option>
								<option value="3">€</option>
							</select>
						</div>
					</div>
					<div class="row row-sm">
						<div class="col-lg-3 mg-b-20">
							<label>Piyasa Fiyatı</label>
							<input type="text" class="form-control" name="piyasa_fiyat" value="<?php echo @$duzenle['piyasa_fiyat']; ?>" placeholder="Piyasa Fiyatı">
						</div>
						<div class="col-lg-3 mg-b-20">
							<label>Satış Fiyatı</label>
							<input type="text" class="form-control" name="fiyat" value="<?php echo @$duzenle['fiyat']; ?>" placeholder="Satış Fiyatı" required>
						</div>
						<div class="col-lg-3 mg-b-20">
							<label>Kargo Fiyatı</label>
							<input type="text" class="form-control" name="kargo_fiyat" value="<?php echo @$duzenle['kargo_fiyat']; ?>" placeholder="Kargo Fiyatı" required>
						</div>
						<div class="col-lg-3 mg-b-20">
							<label>Kdv</label>
							<select class="form-control select2" name="kdv">
								<option value="0">0</option>
								<option value="1">1</option>
								<option value="8">8</option>
								<option value="18">18</option>
							</select>
						</div>
					</div>
					<div class="row row-sm">
						<div class="col-lg-4 mg-b-20">
							<label>Kategori Seçimi</label>
							<select class="form-control select2" required name="kategori_id">
								<option value="">Kategori Seçiniz</option>
								<?php
			                    $query = $db->query("SELECT * FROM kategori WHERE dil = '{$dil}' ORDER BY sira ASC", PDO::FETCH_ASSOC);
			                    if($query->rowCount()){
			                        foreach( $query as $row ){
			                        	echo '<option value="'.$row['id'].'">#'.$row['id'].' '.$row['baslik'].'</option>';
			                        }
			                    }
			                    ?>
							</select>
						</div>
						<div class="col-lg-4 mg-b-20">
							<label>Etiket Seçimi</label>
							<select class="form-control select2" required name="etiket">
								<option value="0">Etiketsiz</option>
								<?php
			                    $query = $db->query("SELECT * FROM etiket WHERE dil = '{$dil}'", PDO::FETCH_ASSOC);
			                    if($query->rowCount()){
			                        foreach( $query as $row ){
			                        	echo '<option value="'.$row['id'].'">#'.$row['id'].' '.$row['baslik'].'</option>';
			                        }
			                    }
			                    ?>
							</select>
						</div>
						<div class="col-lg-4 mg-b-20">
							<label>Satış Durumu</label>
							<select class="form-control select2" name="durum">
								<option value="1">Aktif</option>
								<option value="0">Pasif</option>
							</select>
						</div>
					</div>
					<div class="row row-sm">
						<div class="col-lg-12 mg-b-20">
							<label>Ürün Açıklaması</label>
							<textarea class="ckeditor" name="aciklama"><?php echo @$duzenle['aciklama']; ?></textarea>
						</div>
					</div>
					<div class="row row-sm">
						<div class="col-lg-4 offset-md-4 mg-b-20">
							<button type="button" class="btn btn-success btn-with-icon btn-block" data-varyant-ekle><i class="side-menu__icon fe fe-list"></i> Varyant Ekle</button>
						</div>
					</div>
					<div id="varyant" style="margin-bottom: 20px;">
						
						<?php
						$varyant_sayisi = 0;
						if(isset($_GET['duzenle_id'])){
							$varyant = $db->query("SELECT id, baslik FROM urun_varyant WHERE dil = '{$dil}' AND urun_id = '{$_GET['duzenle_id']}' ", PDO::FETCH_ASSOC);
							if($varyant->rowCount()){
								foreach( $varyant as $v ){
						?>
						<div class="row" data-varyant-dis="<?php echo $varyant_sayisi; ?>">
							<div class="col-lg-6 mg-b-20">
								<input type="text" class="form-control" name="varyant_<?php echo $varyant_sayisi; ?>[]" value="<?php echo $v['baslik']; ?>" placeholder="Varyant Başlığı">
							</div>
							<div class="col-lg-3 mg-b-20">
								<button type="button" class="btn btn-success btn-with-icon btn-block" data-altvaryant-ekle="<?php echo $varyant_sayisi; ?>"><i class="side-menu__icon fe fe-list"></i> Alt Varyant Ekle</button>
							</div>
							<div class="col-lg-3 mg-b-20">
								<button type="button" class="btn btn-danger btn-with-icon btn-block" data-varyant-sil="<?php echo $varyant_sayisi; ?>">Sil</button>
							</div>
							<div class="col-md-12 row" data-altvaryant-alan="<?php echo $varyant_sayisi; ?>">
								<?php
								$alt_varyant = $db->query("SELECT baslik FROM urun_varyant_secenek WHERE dil = '{$dil}' AND urun_id = '{$_GET['duzenle_id']}' AND urun_vayant_id = '{$v['id']}' ", PDO::FETCH_ASSOC);
								if($alt_varyant->rowCount()){
									$altvaryant_sayisi = 0;
									foreach( $alt_varyant as $av ){
								?>
								<div class="col-lg-3 mg-b-20" data-altvaryant-dis="<?php echo $altvaryant_sayisi; ?>">
									<input type="text" class="form-control" name="altvaryant_<?php echo $varyant_sayisi; ?>[]" value="<?php echo $av['baslik']; ?>" placeholder="Alt Varyant Başlığı">
								</div>
								<div class="col-lg-1 mg-b-20" data-altvaryant-dis="<?php echo $altvaryant_sayisi; ?>">
									<button type="button" class="btn btn-danger btn-with-icon btn-block" data-altvaryant-alan-id="<?php echo $varyant_sayisi; ?>" data-altvaryant-sil="<?php echo $altvaryant_sayisi; ?>">Sil</button>
								</div>
								<?php 
										$altvaryant_sayisi++;
									} 
								}
								?>
							</div>
						</div>
						<?php 	
								$varyant_sayisi++;
								} 
							}
						}
						?>

</div>
					<div class="row row-sm" id="stokfiyat" style="margin-bottom: 20px;"></div>
					<div class="row row-sm" id="resimler">
						<?php
							$i = 0;
							if(isset($_GET['duzenle_id'])){
								$resimler = $db->query("SELECT resim, sira FROM urun_resim WHERE dil = '{$dil}' AND urun_id = '{$_GET['duzenle_id']}' ORDER BY sira ASC", PDO::FETCH_ASSOC);
								if($resimler->rowCount()){
									foreach( $resimler as $resim ){
										echo '<div class="col-md-3" data-resim-dis-id="'.$i.'">
						                        <div class="uploaddis pasif" style="float:left;">
						                          <div class="yuklendi">
						                              <img src="../upload/'.$resim['resim'].'" style="width:100%">
						                              <div class="icon" data-resim-sil-id="'.$i.'"><span class="las la-trash"></span></div>
						                              <input type="hidden" name="resim[]" value="'.$resim['resim'].'" required="">
						                              <input type="text" class="form-control" name="resim_sira[]" placeholder="Sıra" value="'.$resim['sira'].'">
						                          </div>
						                        </div>
						                    </div>';
							            $i++;
									}
								}
							}
						?>
					</div>
					<div class="row row-sm">
						<div class="col-lg-4 offset-md-4 mg-b-20">
							<div class="uploaddis aktif" data-id="2" style="margin:0 auto;">
				              <div class="upload1">
				                <span class="metin" style="width: 100%;float: left;">Ürün Fotoğrafı Yükle</span>
				                <div class="icon"><span class="las la-cloud-upload-alt" data-id="2"></span></div>
				              </div>
				            </div>
						</div>
					</div>
					<div class="row row-sm">
						<div class="col-md-12">
							<center><button class="btn btn-indigo btn-with-icon"><i class="typcn typcn-edit"></i> Değişiklikleri Kaydet</button></center>
						</div>
					</div>
				</div>
				<div id="queue"></div>
				<input type="hidden" name="varyant_sayisi" value="<?php echo $varyant_sayisi; ?>">
			</form>
		</div>
	</div>
</div>

<?php if(isset($_GET['kopyala']) AND !$_POST){ ?>
			setTimeout(function() { 
		        $('#urun_formu').submit();
		    }, 1000);
		<?php } ?>

$('.etiket').select2({
		    tags: true,
		    tokenSeparators: [',', ' ']
		})
		
		<?php
			if(isset($_GET['duzenle_id'])){
				?>
				fiyat_stok();
				<?php
			}
		?>
		$('[data-varyant-ekle]').click(function(){
			var varyant_sayisi = $('[data-varyant-dis]').length + 1;
			$('[name="varyant_sayisi"]').val(varyant_sayisi);
			$('#varyant').append('<div class="row" data-varyant-dis="'+varyant_sayisi+'">\
					<div class="col-lg-6 mg-b-20">\
						<input type="text" class="form-control" name="varyant_'+varyant_sayisi+'[]" placeholder="Varyant Başlığı">\
					</div>\
					<div class="col-lg-3 mg-b-20">\
						<button type="button" class="btn btn-success btn-with-icon btn-block" data-altvaryant-ekle="'+varyant_sayisi+'"><i class="side-menu__icon fe fe-list"></i> Alt Varyant Ekle</button>\
					</div>\
					<div class="col-lg-3 mg-b-20">\
					<button type="button" class="btn btn-danger btn-with-icon btn-block" data-varyant-sil="'+varyant_sayisi+'">Sil</button>\
					</div>\
					<div class="col-md-12 row" data-altvaryant-alan="'+varyant_sayisi+'"></div>\
				</div>');
			fiyat_stok();
		});

$(document).on('click','[data-varyant-sil]', function(){
			$('[data-varyant-dis="'+$(this).attr('data-varyant-sil')+'"]').remove();
			fiyat_stok();
		});
		
		$(document).on('click','[data-altvaryant-ekle]', function(){
			var altvaryant_sayisi = $('[data-altvaryant-alan="'+$(this).attr('data-altvaryant-ekle')+'"] input').length;
			$('[data-varyant-dis="'+$(this).attr('data-altvaryant-ekle')+'"] [data-altvaryant-alan="'+$(this).attr('data-altvaryant-ekle')+'"]').append('<div class="col-lg-3 mg-b-20" data-altvaryant-dis="'+altvaryant_sayisi+'">\
					<input type="text" class="form-control" name="altvaryant_'+$(this).attr('data-altvaryant-ekle')+'[]" placeholder="Alt Varyant Başlığı">\
					</div>\
					<div class="col-lg-1 mg-b-20" data-altvaryant-dis="'+altvaryant_sayisi+'">\
					<button type="button" class="btn btn-danger btn-with-icon btn-block" data-altvaryant-alan-id="'+$(this).attr('data-altvaryant-ekle')+'" data-altvaryant-sil="'+altvaryant_sayisi+'">Sil</button>\
					</div>');
			fiyat_stok();
		});

$(document).on('click','[data-altvaryant-sil]', function(){
			$('[data-altvaryant-alan="'+$(this).attr('data-altvaryant-alan-id')+'"] [data-altvaryant-dis="'+$(this).attr('data-altvaryant-sil')+'"]').remove();
			fiyat_stok();
		});

$(document).on('keyup','[placeholder="Alt Varyant Başlığı"]', function(){
			fiyat_stok();
		});

});
</script>

İptal

📁 PHP Dosya Yöneticisi

📝 urun.php

📝 urun.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)