PHP Dosya Yöneticisi

<?php
	if(!in_array(1,$yetki)){
		?>
		<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">
						<center>[$_title] Genel Özet Sayfasını Görme Yetkiniz Bulunmuyor.</center>
					</div>
				</div>
			</div>
		</div>
		<?php
	}else{
		$online = $db->query("SELECT sum(genel_toplam) as toplam FROM siparis  WHERE odeme_yontemi = 1")->fetch(PDO::FETCH_ASSOC);
		$banka = $db->query("SELECT sum(genel_toplam) as toplam FROM siparis  WHERE odeme_yontemi = 2")->fetch(PDO::FETCH_ASSOC);
		$kapida_nakit = $db->query("SELECT sum(genel_toplam) as toplam FROM siparis  WHERE odeme_yontemi = 3")->fetch(PDO::FETCH_ASSOC);
		$kapda_kredi = $db->query("SELECT sum(genel_toplam) as toplam FROM siparis  WHERE odeme_yontemi = 4")->fetch(PDO::FETCH_ASSOC);

$bugun_baslangic = strtotime(date('Y-m-d'));
		$bugun_bitis = strtotime(date('Y-m-d').' 23:59:00');
		$bugun_satis = $db->query("SELECT sum(genel_toplam) as toplam FROM siparis WHERE kayit_tarih > '{$bugun_baslangic}' AND kayit_tarih < '{$bugun_bitis}'")->fetch(PDO::FETCH_ASSOC);

$buhafta_baslangic = strtotime(date("o-\WW"));
		$buhafta_bitis = strtotime("+6 days 23:59:59", $buhafta_baslangic);
		$buhafta_satis = $db->query("SELECT sum(genel_toplam) as toplam FROM siparis WHERE kayit_tarih > '{$buhafta_baslangic}' AND kayit_tarih < '{$buhafta_bitis}'")->fetch(PDO::FETCH_ASSOC);

$buay_baslangic = strtotime(date("Y-m-d", mktime(0, 0, 0, date("m"), 1, date("Y", strtotime("-1 month")))));
		$buay_bitis = strtotime(date("Y-m-d", mktime(0, 0, 0, date("m"), date("t", strtotime("+1 month")), date("Y", strtotime("+1 month")))));
		$buay_satis = $db->query("SELECT sum(genel_toplam) as toplam FROM siparis WHERE kayit_tarih > '{$buay_baslangic}' AND kayit_tarih < '{$buay_bitis}'")->fetch(PDO::FETCH_ASSOC);

$genel_satis = $db->query("SELECT sum(genel_toplam) as toplam FROM siparis")->fetch(PDO::FETCH_ASSOC);
		?>
		<div class="col-xl-12">
			<div class="main-content-body">
				<div class="row row-sm" style="margin-bottom: 40px;">
					<div class="col-md-6">
						<div class="row">
							<div class="col-md-12">
								<div class="project-card">
									<div class="kutu_dis">
										<div class="my-auto primary ozet">
											<i class="ti-pulse"></i>
											<h6>Bugün Yapılan Satış</h6>
											<h5><?php echo fiyat_noktali($bugun_satis['toplam']); ?> TL</h5>
										</div>
									</div>
									<div class="kutu_dis">
										<div class="my-auto danger ozet">
											<i class="ti-pie-chart"></i>
											<h6>Bu Hafta Yapılan Satış</h6>
											<h5><?php echo fiyat_noktali($buhafta_satis['toplam']); ?> TL</h5>
										</div>
									</div>
									<div class="kutu_dis">
										<div class="my-auto success ozet">
											<i class="ti-bar-chart"></i>
											<h6>Bu Ay Yapılan Satış</h6>
											<h5><?php echo fiyat_noktali($buay_satis['toplam']); ?> TL</h5>
										</div>
									</div>
									<div class="kutu_dis">
										<div class="my-auto warning ozet">
											<i class="ti-stats-up"></i>
											<h6>Genel Yapılan Satış</h6>
											<h5><?php echo fiyat_noktali($genel_satis['toplam']); ?> TL</h5>
										</div>
									</div>
								</div>
							</div>
						</div>
					</div>
					<div class="col-md-6">
						<div class="row">
							<div class="col-md-12">
								<div class="project-card">
									<div class="kutu_dis">
										<div class="my-auto primary ozet">
											<i class="fa fa-credit-card"></i>
											<h6>Kredi Kartı Satış Tutarı (Genel)</h6>
											<h5><?php echo fiyat_noktali($online['toplam']); ?> TL</h5>
										</div>
									</div>
									<div class="kutu_dis">
										<div class="my-auto danger ozet">
											<i class="fa fa-university"></i>
											<h6>Banka Havalesi Satış Tutarı (Genel)</h6>
											<h5><?php echo fiyat_noktali($banka['toplam']); ?> TL</h5>
										</div>
									</div>
									<div class="kutu_dis">
										<div class="my-auto success ozet">
											<i class="las la-money-bill"></i>
											<h6>Kapıda Nakit Satış Tutarı (Genel)</h6>
											<h5><?php echo fiyat_noktali($kapida_nakit['toplam']); ?> TL</h5>
										</div>
									</div>
									<div class="kutu_dis">
										<div class="my-auto warning ozet">
											<i class="las la-wallet"></i>
											<h6>Kapıda Kredi.K Satış Tutarı (Genel)</h6>
											<h5><?php echo fiyat_noktali($kapda_kredi['toplam']); ?> TL</h5>
										</div>
									</div>
								</div>
							</div>
						</div>
					</div>
				</div>
				<div class="row row-sm mt-3">
					<div class="col-md-12">
						<div class="card">
							<div class="card-body pt-5">
								<center>
									<div class="baslik baslik_renk1" style="left: calc(50% - 180px);">Son 10 İşleme Alınmamış Siparişiniz</div>
								</center>
								<div class="table-responsive">
									<table class="table table-bordered mg-b-1 text-md-nowrap">
										<thead>
											<tr>
												<th>ID</th>
												<th>Dil</th>
												<th>Ad</th>
												<th>Soyad</th>
												<th>Telefon</th>
												<th>Email</th>
												<th>Sipariş Adres</th>
												<th>Genel Toplam</th>
												<th>Ödeme Yöntemi</th>
												<th>Sipariş Tarihi</th>
												<th>Detay</th>
											</tr>
										</thead>
										<tbody>
											<?php
						                    $query = $db->query("SELECT * FROM siparis WHERE durum = 0 ORDER BY id DESC LIMIT 10", PDO::FETCH_ASSOC);
						                    if($query->rowCount()){
						                        foreach( $query as $row ){
													echo '<tr>
															<td>'.$row['id'].'</td>
															<td style="text-transform:uppercase">'.$row['dil'].'</td>
															<td>'.$row['ad'].'</td>
															<td>'.$row['soyad'].'</td>
															<td>'.$row['telefon'].'</td>
															<td>'.$row['email'].'</td>
															<td>'.$row['siparis_adres'].'</td>
															<td>'.fiyat_noktali($row['genel_toplam']).' TL</td>
															<td>
																'.$odeme_yontemleri[$row['odeme_yontemi']].'<br>';
																if($row['odeme_yontemi'] == 1){
																	if($row['kredi_karti_odeme_durumu'] == 0){
																		echo '<b style="color:red">Ödeme Yapılmamış</b>';
																	}else{
																		echo '<b style="color:green">Ödeme Alındı</b>';
																	}
																}
															echo '</td>
															<td>'.date('Y-m-d H:i:s',$row['kayit_tarih']).'</td>
															<td><a href="'.$row['dil'].'/siparis/duzenle/'.$row['id'].'" class="btn btn-info btn-sm text-white"><i class="fe fe-edit"></i> Detay</a></td>
														</tr>';
												}
											}else{
												echo '<tr>
														<td colspan="11" 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>
								</div>
							</div>
						</div>
					</div>
				</div>
				<div class="row row-sm mt-3">
					<div class="col-md-12">
						<div class="card">
							<div class="card-body pt-5">
								<center>
									<div class="baslik baslik_renk2" style="left: calc(50% - 138px);">Son 10 Kayıt Olan Kullanıcı</div>
								</center>
								<div class="table-responsive">
									<table class="table table-bordered mg-b-1 text-md-nowrap">
										<thead>
											<tr>
												<th>ID</th>
												<th>Ad</th>
												<th>Soyad</th>
												<th>Telefon</th>
												<th>Email</th>
												<th>Adres</th>
												<th>Kayıt Tarihi</th>
												<th>Sepeti Gör</th>
												<th>Sipariş Geçmişi</th>
												<th>Düzenle</th>
											</tr>
										</thead>
										<tbody>
											<?php
						                    $query = $db->query("SELECT * FROM musteri ORDER BY id DESC LIMIT 10", PDO::FETCH_ASSOC);
						                    if($query->rowCount()){
						                        foreach( $query as $row ){
													echo '<tr>
															<td>'.$row['id'].'</td>
															<td>'.$row['ad'].'</td>
															<td>'.$row['soyad'].'</td>
															<td>'.$row['telefon'].'</td>
															<td>'.$row['email'].'</td>
															<td>'.$row['siparis_adres'].'</td>
															<td>'.date('Y-m-d H:is',$row['kayit_tarih']).'</td>
															<td><a href="musteri-sepeti?id='.$row['id'].'" class="btn btn-danger btn-sm text-white">Sepeti Gör</a></td>
															<td><a href="musteri-gecmisi?id='.$row['id'].'" class="btn btn-danger btn-sm text-white">Sipariş Geçmişi</a></td>
															<td><a href="musteri-duzenle?id='.$row['id'].'" class="btn btn-info btn-sm text-white"><i class="fe fe-edit"></i> Düzenle</a></td>
														</tr>';
												}
											}else{
												echo '<tr>
														<td colspan="11" 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>
								</div>
							</div>
						</div>
					</div>
				</div>
				<div class="row row-sm mt-3">
					<div class="col-md-12">
						<div class="card">
							<div class="card-body pt-5">
								<center>
									<div class="baslik baslik_renk3" style="left: calc(50% - 120px);">En Çok Satılan 10 Ürün</div>
								</center>
								<div class="table-responsive">
									<table class="table table-bordered mg-b-1 text-md-nowrap">
										<thead>
											<tr>
												<th>Ürün ID</th>
												<th>Satış Sayısı</th>
												<th>Resim</th>
												<th>Ad</th>
												<th>Ürünü Gör</th>
												<th>Stok Kodu</th>
												<th>Stok</th>
												<th>Piyasa Fiyatı</th>
												<th>Fiyat</th>
												<th>Kargo Ücreti</th>
												<th>Kur</th>
												<th>Düzenle</th>
											</tr>
										</thead>
										<tbody>
											<?php
											$siralama = array();
											$query = $db->query("SELECT * FROM siparis_urun GROUP BY urun_id ASC", PDO::FETCH_ASSOC);
									        if($query->rowCount()){
									            foreach( $query as $row ){
									            	$toplam = $db->query("SELECT sum(adet) as toplam FROM siparis_urun WHERE urun_id = '{$row['urun_id']}'")->fetch(PDO::FETCH_ASSOC);
									            	$siralama[$row['urun_id']] =  $toplam['toplam'];
									            }
									        }
									        arsort($siralama);
									        $ilk_on = 1;
									        foreach($siralama as $id => $sira){
					                        	$row = $db->query("SELECT * FROM urun WHERE id = '{$id}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
					                        	$resim = $db->query("SELECT * FROM urun_resim WHERE urun_id = '{$id}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
												echo '<tr>
													<td>'.$row['id'].'</td>
													<td><span class="badge badge-primary-gradient">'.$sira.' Satış</span></td>
													<td><img src="../upload/'.$resim['resim'].'" class="h-60 w-60"></td>
													<td>'.$row['baslik'].'</td>
													<td><a href="'.$site.$row['dil'].'/urun/'.$row['link'].'" target="_blank">Ürünü Gör</a></td>
													<td>'.$row['stok_kodu'].'</td>
													<td>'.$row['stok'].'</td>
													<td>'.$row['piyasa_fiyat'].'</td>
													<td>'.$row['fiyat'].'</td>
													<td>'.$row['kargo_fiyat'].'</td>
													<td>'.$kur_tipi[$row['kur_tipi']].'</td>
													<td><a href="'.$row['dil'].'/urun/duzenle/'.$row['id'].'" class="btn btn-info btn-sm text-white"><i class="fe fe-edit"></i> Düzenle</a></td>
												</tr>';
												if($ilk_on == 10){
													break;
												}
												$ilk_on++;
											}
											?>
										</tbody>
									</table>
								</div>
							</div>
						</div>
					</div>
				</div>
				<div class="row row-sm mt-3">
					<div class="col-md-12">
						<div class="card">
							<div class="card-body pt-5">
								<center>
									<div class="baslik baslik_renk4" style="left: calc(50% - 138px);">En Çok Görüntülenen 10 Ürün</div>
								</center>
								<div class="table-responsive">
									<table class="table table-bordered mg-b-1 text-md-nowrap">
										<thead>
											<tr>
												<th>ID</th>
												<th>Görüntülenme</th>
												<th>Resim</th>
												<th>Ad</th>
												<th>Ürünü Gör</th>
												<th>Stok Kodu</th>
												<th>Stok</th>
												<th>Piyasa Fiyatı</th>
												<th>Fiyat</th>
												<th>Kargo Ücreti</th>
												<th>Kur</th>
												<th>Düzenle</th>
											</tr>
										</thead>
										<tbody>
											<?php
						                    $query = $db->query("SELECT * FROM urun ORDER BY goruntulenme DESC LIMIT 10", PDO::FETCH_ASSOC);
						                    if($query->rowCount()){
						                        foreach( $query as $row ){
						                        	$resim = $db->query("SELECT * FROM urun_resim WHERE urun_id = '{$row['id']}' ORDER BY sira ASC LIMIT 1")->fetch(PDO::FETCH_ASSOC);
													echo '<tr>
															<td>'.$row['id'].'</td>
															<td><span class="badge badge-primary-gradient">'.$row['goruntulenme'].' İncelenme</span></td>
															<td><img src="../upload/'.$resim['resim'].'" class="h-60 w-60"></td>
															<td>'.$row['baslik'].'</td>
															<td><a href="'.$site.$row['dil'].'/urun/'.$row['link'].'" target="_blank">Ürünü Gör</a></td>
															<td>'.$row['stok_kodu'].'</td>
															<td>'.$row['stok'].'</td>
															<td>'.$row['piyasa_fiyat'].'</td>
															<td>'.$row['fiyat'].'</td>
															<td>'.$row['kargo_fiyat'].'</td>
															<td>'.$kur_tipi[$row['kur_tipi']].'</td>
															<td><a href="'.$row['dil'].'/urun/duzenle/'.$row['id'].'" class="btn btn-info btn-sm text-white"><i class="fe fe-edit"></i> Düzenle</a></td>
														</tr>';
												}
											}else{
												echo '<tr>
														<td colspan="12" 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>
								</div>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
		<style type="text/css">
			.ozet{width: 100%; text-align: center; color: #fff;}
			.ozet h5{font-size: 25px;}
			.ozet i{font-size: 25px; opacity: 1 !important; background: #fff; color: #2eb382 !important; margin: 0px; padding: 10px 10px; margin-bottom: 10px; display: inline-block; border-radius: 100%;box-shadow: 0px 0px 10px #5d5c608a;}
			.baslik{margin-bottom: 20px; font-size: 15px; padding: 9px 20px; position: absolute; top: -20px;color: #fff;border-radius: 10px;}
			.baslik_renk1{background-image: linear-gradient(45deg, #ff5858 0%, #f09819 100%);}
			.baslik_renk2{background: linear-gradient(45deg, #f53c5b, #fb768c);}
			.baslik_renk3{background: linear-gradient(45deg, #3858f9, #8e79fd);}
			.baslik_renk4{background: linear-gradient(to top, #0ba360 0%, #3cba92 100%);}
			.project-card{background: #fff; padding-left: 20px; padding-top: 20px;border-radius: 10px;}
			.project-card .kutu_dis{width: calc(50% - 20px); margin-right: 20px; float: left; margin-bottom: 20px;}
		</style>
		<?php
	}
?>

İptal

📁 PHP Dosya Yöneticisi

📝 anasayfa.php

📝 anasayfa.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)