PHP Dosya Yöneticisi

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

if(isset($_GET['duzenle_id'])){
		if($_POST){
      include '../sabit-metinler/'.$dil.'.php';
			$siparis_bilgi = $db->query("SELECT email, stok_dusur, telefon FROM siparis WHERE id = '{$_GET['duzenle_id']}' AND dil = '{$dil}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
			if(isset($_POST['kargo_adi']) AND isset($_POST['kargo_takip_kodu'])){
				$guncelle = $db->prepare("UPDATE siparis SET kargo_adi = ?, kargo_takip_kodu = ? WHERE id = ? LIMIT 1");
		        $guncelle = $guncelle->execute(array($_POST['kargo_adi'],$_POST['kargo_takip_kodu'],$_GET['duzenle_id']));
		        if($guncelle){
		        	$mesaj = array('İşlem Başarılı','Güncelleme İşleminiz Başarı İle Gerçekleşti','success');
		        	$mailbody = '<table>
                                  <tr>
                                    <td>'.$dil_sabit[135].'</td>
                                    <td>'.$_POST['kargo_adi'].'</td>
                                  </tr>
                                  <tr>
                                    <td>'.$dil_sabit[136].'</td>
                                    <td>'.$_POST['kargo_takip_kodu'].'</td>
                                  </tr>
                                </table>';
              email_gonder($siparis_bilgi['email'],$mailbody,$dil_sabit[134]);
              net_gsm($dil_sabit[135].': '.$_POST['kargo_adi'].' '.$dil_sabit[136].': '.$_POST['kargo_takip_kodu'],$siparis_bilgi['telefon']);
		        }else{
		        	$mesaj = array('İşlem Başarısız','Güncelleme İşlemi Sırasında Bir Hata Oluştu','error');
		        }
			}else if(isset($_POST['durum'])){
				if($_POST['durum'] == 0){
					$yeni_durum = $dil_sabit[24];
				}else{
					$s_durum = $db->query("SELECT * FROM siparis_etap WHERE id = '{$_POST['durum']}' AND dil = '{$dil}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
					$yeni_durum = $s_durum['baslik'];
				}
				$guncelle = $db->prepare("UPDATE siparis SET durum = ? WHERE id = ? LIMIT 1");
		        $guncelle = $guncelle->execute(array($_POST['durum'],$_GET['duzenle_id']));
		        if($guncelle){
		        	$mesaj = array('İşlem Başarılı','Güncelleme İşleminiz Başarı İle Gerçekleşti','success');
		        	$mailbody = '<table>
                                  <tr>
                                    <td>'.$dil_sabit[134].'</td>
                                    <td>'.$yeni_durum.'</td>
                                  </tr>
                                </table>';
              email_gonder($siparis_bilgi['email'],$mailbody,$dil_sabit[134]);
              net_gsm($dil_sabit[134].': '.$yeni_durum,$siparis_bilgi['telefon']);
		        }else{
		        	$mesaj = array('İşlem Başarısız','Güncelleme İşlemi Sırasında Bir Hata Oluştu','error');
		        }
			}else if(isset($_POST['stok_dusur'])){
				if(empty($siparis_bilgi['stok_dusur'])){
					$query = $db->query("SELECT * FROM siparis_urun WHERE dil = '{$dil}' AND siparis_id = '{$_GET['duzenle_id']}' ", PDO::FETCH_ASSOC);
          if($query->rowCount()){
              foreach( $query as $row ){
              	if(empty($row['varyant_key'])){
              		$urun = $db->query("SELECT stok FROM urun WHERE id = '{$row['urun_id']}'  LIMIT 1")->fetch(PDO::FETCH_ASSOC);
              		$yeni_stok = $urun['stok'] - $row['adet'];
              		$guncelle = $db->prepare("UPDATE urun SET stok = ? WHERE id = ? LIMIT 1");
    				$guncelle = $guncelle->execute(array($yeni_stok,$row['urun_id']));
              	}else{
              		$varyant_stok = $db->query("SELECT stok FROM urun_varyant_secenek_fiyat_stok WHERE varyant_key = '{$row['varyant_key']}'  LIMIT 1")->fetch(PDO::FETCH_ASSOC);
              		$yeni_stok = $varyant_stok['stok'] - $row['adet'];
              		$guncelle = $db->prepare("UPDATE urun_varyant_secenek_fiyat_stok SET stok = ? WHERE varyant_key = ? LIMIT 1");
    				$guncelle = $guncelle->execute(array($yeni_stok,$row['varyant_key']));
              	}
              }
              $mesaj = array('İşlem Başarılı','Güncelleme İşleminiz Başarı İle Gerçekleşti','success');
          }
          $guncelle = $db->prepare("UPDATE siparis SET stok_dusur = ? WHERE id = ? LIMIT 1");
    			$guncelle = $guncelle->execute(array(1,$_GET['duzenle_id']));
        }else{
        	$mesaj = array('İşlem Başarısız','Stok Düşürülme İşlemi Zaten Daha Önce Yapılmış','error');
        }
			}
		}

$siparis = $db->query("SELECT * FROM siparis WHERE id = '{$_GET['duzenle_id']}' AND dil = '{$dil}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
		if($siparis){
			?>
        	<script type="text/javascript">
        		$(function(){
	                $('select[name="durum"] option[value="<?php echo $siparis['durum']; ?>"]').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.'/admin/">';
		}
	}else{
		echo '<meta http-equiv="refresh" content="2;url='.$dil.'/admin/">';
	}

$_title = $dil_kontrol['baslik'].' - #'.$_GET['duzenle_id'].' Sipariş Detay';
	
?>
<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><br>
			
			<div class="row">
				<div class="col-md-5">
					<div class="card" style="border: 1px solid #ddd !important;">
						<form action="" method="post" style="float:left;width: 100%;">
							<div class="card-body">
								<div class="row">
									<div class="col-md-4">
										<input type="text" name="kargo_adi" class="form-control" value="<?php echo @$siparis['kargo_adi']; ?>" required placeholder="Kargo Adı">
									</div>
									<div class="col-md-5">
										<input type="text" name="kargo_takip_kodu" class="form-control" value="<?php echo @$siparis['kargo_takip_kodu']; ?>" required placeholder="Kargo Takip Kodu">
									</div>
									<div class="col-md-3">
										<button class="btn btn-indigo btn-with-icon" style="width: 100%;">Kaydet</button>
									</div>
								</div>
							</div>
						</form>
					</div>
				</div>
				<div class="col-md-4">
					<div class="card" style="border: 1px solid #ddd !important;">
						<form action="" method="post" style="float:left;width: 100%;">
							<div class="card-body">
								<div class="row">
									<div class="col-md-9">
										<select name="durum" class="form-control" required>
											<option value="0">İşleme Alınmadı</option>
											<?php
							                    $query = $db->query("SELECT * FROM siparis_etap WHERE dil = '{$siparis['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-md-3">
										<button class="btn btn-indigo btn-with-icon" style="width: 100%;">Kaydet</button>
									</div>
								</div>
							</div>
						</form>
					</div>
				</div>
				<?php if(empty($siparis['stok_dusur'])){ ?>
				<div class="col-md-3">
					<div class="card" style="border: 1px solid #ddd !important;">
						<form action="" method="post" style="float:left;width: 100%;">
							<div class="card-body">
								<div class="row">
									<div class="col-md-12">
										<button class="btn btn-indigo btn-with-icon" name="stok_dusur" style="width: 100%;">Ürünlerin Stoklarını Düşür</button>
									</div>
								</div>
							</div>
						</form>
					</div>
				</div>
				<?php } ?>
			</div>

<div class="table-responsive mb-0">
				<table class="table table-hover table-bordered mb-0 text-md-nowrap text-lg-nowrap text-xl-nowrap table-striped ">
					<thead>
						<tr>
							<th colspan="4" style="background: #fff !important;"><b style="font-size: 24px">Sipariş ID #<?php echo $siparis['id']; ?></b></th>
						</tr>
						<tr>
							<th><b>Ad</b></th>
							<td><?php echo $siparis['ad']; ?></td>
							<th><b>Soyad</b></th>
							<td><?php echo $siparis['soyad']; ?></td>
						</tr>
						<tr>
							<th><b>Telefon</b></th>
							<td><?php echo $siparis['telefon']; ?></td>
							<th><b>Email</b></th>
							<td><?php echo $siparis['email']; ?></td>
						</tr>
						<tr>
							<th><b>Tc</b></th>
							<td><?php echo $siparis['tc_kimlik']; ?></td>
							<th><b>Sipariş Key</b></th>
							<td><?php echo $siparis['siparis_key']; ?></td>
						</tr>
						<tr>
							<th><b>Fatura Adres</b></th>
							<td><?php echo $siparis['fatura_adres']; ?></td>
							<th><b>Sipariş Adres</b></th>
							<td><?php echo $siparis['siparis_adres']; ?></td>
						</tr>
						<?php if(!empty($siparis['vergi_numarasi']) AND !empty($siparis['vergi_dairesi']) AND !empty($siparis['vergi_adi'])){ ?>
						<tr>
							<th><b>Kurumsal Bilgiler</b></th>
							<td colspan="3">
								Vergi Numarası: <?php echo $siparis['vergi_numarasi']; ?><br>
								Vergi Dairesi: <?php echo $siparis['vergi_dairesi']; ?><br>
								Vergi Adı: <?php echo $siparis['vergi_adi']; ?><br>
							</td>
						</tr>
						<?php } ?>
	                    <?php if(!empty($siparis['kupon'])){ ?>
	                    <tr>
	                        <th><b>Kullanılan Kupon</b></th>
	                        <td colspan="3"><?php echo $siparis['kupon']; ?></td>
	                    </tr>
	                    <?php } ?>
	                    <tr>
	                        <th><b>Ödeme Yöntemi</b></th>
	                        <td colspan="3"><?php echo $odeme_yontemleri[$siparis['odeme_yontemi']]; ?></td>
	                    </tr>
						<?php if(!empty($siparis['kargo_adi']) AND !empty($siparis['kargo_takip_kodu'])){ ?>
						<tr>
							<th><b>Kargo Bilgileri</b></th>
							<td colspan="3">
								Kargo Adı: <?php echo $siparis['kargo_adi']; ?><br>
								Kargo Takip Kodu: <?php echo $siparis['kargo_takip_kodu']; ?><br>
							</td>
						</tr>
						<?php } ?>
						<tr>
							<th><b>Sipariş Tarihi</b></th>
							<td><?php echo date('Y-m-d H:i:s',$siparis['kayit_tarih']); ?></td>
							<th><b>Toplam Tutar (Ekstralar Dahil)</b></th>
							<td><?php echo fiyat_noktali($siparis['genel_toplam']); ?> TL</td>
						</tr>
					</thead>
				</table>
			</div>
			<br>
			<div class="table-responsive">
				<table class="table table-bordered mg-b-1 text-md-nowrap">
					<thead>
						<tr>
							<th>ID</th>
							<th>Resim</th>
							<th>Ürün Bilgileri</th>
							<th>Tutar</th>
							<th>Adet</th>
						</tr>
					</thead>
					<tbody>
						<?php
	                    $query = $db->query("SELECT * FROM siparis_urun WHERE dil = '{$dil}' AND siparis_id = '{$siparis['id']}' ", PDO::FETCH_ASSOC);
	                    if($query->rowCount()){
	                        foreach( $query as $row ){
	                        	$urun = $db->query("SELECT * FROM urun WHERE id = '{$row['urun_id']}'  LIMIT 1")->fetch(PDO::FETCH_ASSOC); 
                                $resim = $db->query("SELECT * FROM urun_resim WHERE urun_id = '{$row['urun_id']}' ORDER BY sira ASC LIMIT 1")->fetch(PDO::FETCH_ASSOC); 
								echo '<tr>
										<td>'.$row['id'].'</td>
										<td><img src="../upload/'.$resim['resim'].'" class="img-responsive"/></td>
										<td>'.$urun['baslik'].'<br>'.$row['varyant'].'</td>
										<td>'.fiyat_noktali($row['tutar']).' TL</td>
										<td>'.$row['adet'].'</td>
									</tr>';
							}
						}else{
							echo '<tr>
									<td colspan="4" class="text-center">
										<img src="assets/images/veriyok.svg" class="wd-15p ">
										<h5 class="mg-b-10 mg-t-15 tx-18">Veri Bulunamadı.</h5>
									</td>
								</tr>';
						}
						?>
					</tbody>
				</table>
				<?php if(!$_POST){ ?>
				<ul class="pagination pagination-circled" style="float:right;margin-top: 20px;">
					<?php Sayfala($top_sayfa,$_GET['sayfa_no'],$limit,$page_url); ?>
				</ul>
				<?php } ?>
			</div>
		</div>
	</div>
</div>
<style type="text/css">
	.table tr{background: #f1f6fb !important;}
	.table tr:nth-child(2n+1){background: #fff !important;}
	.table th b{color: #000;text-transform: capitalize !important;}
	.table tr th, .table tr td{font-size: 13px !important;}
	.table td{text-transform: lowercase !important;}
</style>

İptal

📁 PHP Dosya Yöneticisi

📝 siparis.php

📝 siparis.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)