PHP Dosya Yöneticisi

<?php 
require_once 'header.php';
yetkilimi(e);

if (!isset($_GET['tur'])) {
	$tur="line";
} else {
	$tur=$_GET['tur'];
}

<div class="container-fluid">
	<div class="row mb-4">
		<div class="col-md-6 mx-auto bg-primary br-1 text-white p-4">
			<label>Grafik Türü</label>
			<select onchange="tur(this)" name="tur" class="form-control">
				<option <?php slc($tur,"line") ?> value="line">Line</option>
				<option <?php slc($tur,"bar") ?> value="bar">Bar</option>
				<option <?php slc($tur,"pie") ?> value="pie">Pie</option>
				<option <?php slc($tur,"doughnut") ?> value="doughnut">Doughnut</option>
				<option <?php slc($tur,"polarArea") ?> value="polarArea">PolarArea</option>
			</select>
		</div>	
	</div>
	<div class="row">
		<div class="col-md-6">
			<div class="card card-primary br-1">
				<div class="card-header">
					<h4><b>Şikayet</b> Sayısı </h4>
				</div>
				<div class="card-body">
					<canvas id="sikayet_eklenme_grafik"></canvas>
				</div>
			</div>
		</div>

<div class="col-md-6">
			<div class="card card-primary br-1">
				<div class="card-header">
					<h4><b>Teşekkür</b> Sayısı </h4>
				</div>
				<div class="card-body">
					<canvas id="tesekkur_eklenme_grafik"></canvas>
				</div>
			</div>
		</div>
	</div>

<div class="row">
		<div class="col-md-6">
			<div class="card card-primary br-1">
				<div class="card-header">
					<h4><b>Şikayet Cevaplanma</b> Sayısı </h4>
				</div>
				<div class="card-body">
					<canvas id="sikayet_cevaplanma_grafik"></canvas>
				</div>
			</div>
		</div>

<div class="col-md-6">
			<div class="card card-primary br-1">
				<div class="card-header">
					<h4><b>İncelenme</b> Sayısı </h4>
				</div>
				<div class="card-body">
					<canvas id="incelenme_sayisi_grafik"></canvas>
				</div>
			</div>
		</div>
	</div>

<div class="row">
		<div class="col-md-6">
			<div class="card card-primary br-1 shadow-sm">
				<div class="card-header">
					<h5 class="text-primary">En Çok İncelenen Şikayetler</h5>
				</div>
				<div class="card-body">
					<table class="table table-hover table-bordered">
						<thead>
							<tr>
								<th>Başlık</th>
								<th>İncelenme Sayısı</th>
								<th>Beğeni sayısı</th>
								<th>Kaydetme sayısı</th>
							</tr>
						</thead>
						<tbody>
							<?php foreach ($crud->cok("SELECT * FROM sikayet WHERE firma={$_SESSION['yetkili_firma']} AND durum=1 AND tur=0 ORDER BY incelenme_sayisi DESC LIMIT 5") as $key => $value): ?>
								<tr>
									<td><a class="font-weight-bold text-primary" href="<?php echo yol."/sikayet/".$value['link'] ?>"><?php echo $value['baslik'] ?></a></td>
									<td><?php echo $value['incelenme_sayisi'] ?></td>
									<td><?php echo $crud->tek("SELECT COUNT(sikayet) as sayi FROM sikayet_begeni 
										INNER JOIN sikayet ON sikayet.sikayet_id=sikayet_begeni.sikayet 
										WHERE sikayet.firma={$_SESSION['yetkili_firma']} AND sikayet={$value['sikayet_id']}")['sayi'] ?></td>
									<td><?php echo $crud->tek("SELECT COUNT(sikayet) as sayi FROM sikayet_favori 
										INNER JOIN sikayet ON sikayet.sikayet_id=sikayet_favori.sikayet 
										WHERE sikayet.firma={$_SESSION['yetkili_firma']} AND sikayet={$value['sikayet_id']}")['sayi'] ?></td>
									</tr>
								<?php endforeach ?>
							</tbody>
						</table>
					</div>
				</div>
			</div>

<div class="col-md-6">
				<div class="card card-primary br-1 shadow-sm">
					<div class="card-header">
						<h5 class="text-primary">En Çok Beğenilen Şikayetler</h5>
					</div>
					<div class="card-body">
						<table class="table table-hover table-bordered">
							<thead>
								<tr>
									<th>Başlık</th>
									<th>Beğeni sayısı</th>
									<th>İncelenme Sayısı</th>
									<th>Kaydetme sayısı</th>
								</tr>
							</thead>
							<tbody>
								<?php foreach ($crud->cok("SELECT * FROM sikayet WHERE firma={$_SESSION['yetkili_firma']} AND durum=1 AND tur=0 ORDER BY begeni DESC LIMIT 5") as $key => $value): ?>
									<tr>
										<td><a class="font-weight-bold text-primary" href="<?php echo yol."/sikayet/".$value['link'] ?>"><?php echo $value['baslik'] ?></a></td>
										<td><?php echo $crud->tek("SELECT COUNT(sikayet) as sayi FROM sikayet_begeni 
											INNER JOIN sikayet ON sikayet.sikayet_id=sikayet_begeni.sikayet 
											WHERE sikayet.firma={$_SESSION['yetkili_firma']} AND sikayet={$value['sikayet_id']}")['sayi'] ?></td>
											<td><?php echo $value['incelenme_sayisi'] ?></td>
											<td><?php echo $crud->tek("SELECT COUNT(sikayet) as sayi FROM sikayet_favori 
												INNER JOIN sikayet ON sikayet.sikayet_id=sikayet_favori.sikayet 
												WHERE sikayet.firma={$_SESSION['yetkili_firma']} AND sikayet={$value['sikayet_id']}")['sayi'] ?></td>
											</tr>
										<?php endforeach ?>
									</tbody>
								</table>
							</div>
						</div>
					</div>
				</div>

</div>

<div class="container-fluid">
				<div class="row justify-content-around">
					<div class="col-md-6">
						<div class="card card-primary br-1 shadow">
							
						<div class="card-header">
							<h4 class="">Son 1 <b>Ayda</b> En Çok <b>İncelenen</b> Şikayetler</h4>
						</div>

<div class="card-body">
							<div class="row ">
							<?php 
							$simdi=date("Y-m-d");
							$baslangic=date("Y-m-d",strtotime($simdi." -1 month"));

foreach ($crud->cok("SELECT sikayet.baslik,sikayet.link as sikayet_link,sikayet.firma,sikayet.sikayet_id,firma.firma_id,firma.isim,firma.link,firma.logo,SUM(sikayet_incelenme.incelenme_sayisi) as toplam FROM sikayet_incelenme 
								INNER JOIN sikayet ON sikayet.sikayet_id=sikayet_incelenme.sikayet 
								INNER JOIN firma ON firma.firma_id=sikayet.firma  
								WHERE tarih BETWEEN '$baslangic' AND '$simdi' 
								AND sikayet.firma={$_SESSION['yetkili_firma']}
								GROUP BY sikayet.baslik ORDER BY toplam DESC LIMIT 5") as $key => $value): ?>

<div class="col-md-12 animate__animated animate__jackInTheBox wow">
									<div class="futures-version-2-box shadow-sm p-3 my-1">
										<div class="row">
											<div class="col-md-1">
												<a href="<?php echo yol ?>/marka/<?php echo $value['link'] ?>"><img style="height: 40px;width: 40px;border-radius: 100%;border: 2px solid gray;padding: 3px;" src="<?php echo yol ?>/img/firma/<?php echo $value['logo'] ?>" alt=""></a>
											</div>
											<div class="col-md-11">
												<a href="<?php echo yol ?>/sikayet/<?php echo $value['sikayet_link'] ?>">
													<div class="row">
														<div class="col-md-12 ">
															<span class="font-weight-bold"><?php echo $value['baslik'] ?></span>
														</div>
													</div>
												</a>
												<div class="row">
													<div class="col-md-6 text-left">
														<a href="<?php echo yol ?>/marka/<?php echo $value['link'] ?>"><?php echo $value['isim'] ?></a>
													</div>
													<div class="col-md-6 text-md-right">
														<span class="font-weight-bold"><?php echo sayi_format($value['toplam']) ?></span> Kez İncelendi
													</div>
												</div>

</div>
										</div>
									</div>
								</div>

<?php endforeach ?>
						</div>
						</div>

</div>
					</div>
					<div class="col-md-6">
						<div class="card card-primary br-1 shadow">
							<div class="card-header">
								<h4 class="">Son 1 <b>Haftada</b> En Çok <b>İncelenen</b> Şikayetler</h4>
							</div>

<div class="card-body">
								<div class="row">
									<?php 
									$simdi=date("Y-m-d");
									$baslangic=date("Y-m-d",strtotime($simdi." -1 week"));

foreach ($crud->cok("SELECT sikayet.baslik,sikayet.link as sikayet_link,sikayet.firma,sikayet.sikayet_id,firma.firma_id,firma.isim,firma.link,firma.logo,SUM(sikayet_incelenme.incelenme_sayisi) as toplam FROM sikayet_incelenme 
										INNER JOIN sikayet ON sikayet.sikayet_id=sikayet_incelenme.sikayet 
										INNER JOIN firma ON firma.firma_id=sikayet.firma  
										WHERE tarih BETWEEN '$baslangic' AND '$simdi' 
										AND sikayet.firma={$_SESSION['yetkili_firma']}
										GROUP BY sikayet.baslik ORDER BY toplam DESC LIMIT 5") as $key => $value): ?>

<div class="col-md-12 animate__animated animate__jackInTheBox wow">
											<div class="futures-version-2-box shadow-sm p-3 my-1">
												<div class="row">
													<div class="col-md-1">
														<a href="<?php echo yol ?>/marka/<?php echo $value['link'] ?>"><img style="height: 40px;width: 40px;border-radius: 100%;border: 2px solid gray;padding: 3px;" src="<?php echo yol ?>/img/firma/<?php echo $value['logo'] ?>" alt=""></a>
													</div>
													<div class="col-md-11">
														<a href="<?php echo yol ?>/sikayet/<?php echo $value['sikayet_link'] ?>">
															<div class="row">
																<div class="col-md-12 ">
																	<span class="font-weight-bold"><?php echo $value['baslik'] ?></span>
																</div>
															</div>
														</a>
														<div class="row">
															<div class="col-md-6 text-left">
																<a href="<?php echo yol ?>/marka/<?php echo $value['link'] ?>"><?php echo $value['isim'] ?></a>
															</div>
															<div class="col-md-6 text-md-right">
																<span class="font-weight-bold"><?php echo sayi_format($value['toplam']) ?></span> Kez İncelendi
															</div>
														</div>

</div>
												</div>
											</div>
										</div>

<?php endforeach ?>
								</div>
							</div>

</div>
					</div>
				</div>
			</div>

<?php 
			$sikayet_eklenme_grafik=array();	
			for ($i=1; $i < 13; $i++) { 
				if (strlen($i)==1) {
					$i="0".$i;
				}
				$tarih=date("Y-").$i;
				$sonuc=$crud->tek("SELECT COUNT(sikayet_id) as sayi FROM sikayet WHERE tur=0 AND firma={$_SESSION['yetkili_firma']} AND eklenme_tarihi BETWEEN '$tarih-01 00:00:00' AND '$tarih-31 23:59:59'")['sayi'];

if (strlen($sonuc)==0) {
					array_push($sikayet_eklenme_grafik,0);
				} else {
					array_push($sikayet_eklenme_grafik,$sonuc);
				}
			}
			?>

<?php 
			$tesekkur_eklenme_grafik=array();	
			for ($i=1; $i < 13; $i++) { 
				if (strlen($i)==1) {
					$i="0".$i;
				}
				$tarih=date("Y-").$i;
				$sonuc=$crud->tek("SELECT COUNT(sikayet_id) as sayi FROM sikayet WHERE tur=1 AND firma={$_SESSION['yetkili_firma']} AND eklenme_tarihi BETWEEN '$tarih-01 00:00:00' AND '$tarih-31 23:59:59'")['sayi'];

if (strlen($sonuc)==0) {
					array_push($tesekkur_eklenme_grafik,0);
				} else {
					array_push($tesekkur_eklenme_grafik,$sonuc);
				}
			}
			?>

<?php 
			$sikayet_cevaplanma_grafik=array();	
			for ($i=1; $i < 13; $i++) { 
				if (strlen($i)==1) {
					$i="0".$i;
				}
				$tarih=date("Y-").$i;
				$sonuc=$crud->tek("SELECT COUNT(sikayet_id) as sayi FROM sikayet WHERE firma={$_SESSION['yetkili_firma']} AND cevap_tarihi BETWEEN '$tarih-01 00:00:00' AND '$tarih-31 23:59:59'")['sayi'];

if (strlen($sonuc)==0) {
					array_push($sikayet_cevaplanma_grafik,0);
				} else {
					array_push($sikayet_cevaplanma_grafik,$sonuc);
				}
			}
			?>

<?php 
			$incelenme_sayisi_grafik=array();	
			for ($i=1; $i < 13; $i++) { 
				if (strlen($i)==1) {
					$i="0".$i;
				}
				$tarih=date("Y-").$i;
				$sonuc=$crud->tek("SELECT SUM(incelenme_sayisi) as sayi FROM firma_incelenme WHERE fir_id={$_SESSION['yetkili_firma']} AND tarih BETWEEN '$tarih-01' AND '$tarih-31'")['sayi'];

if (strlen($sonuc)==0) {
					array_push($incelenme_sayisi_grafik,0);
				} else {
					array_push($incelenme_sayisi_grafik,$sonuc);
				}
			}

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

var renk_1 = [];
				var renk_2 = [];
				var renk_3 = [];
				var renk_4 = [];

var dynamicColors = function() {
					var r = Math.floor(Math.random() * 255);
					var g = Math.floor(Math.random() * 255);
					var b = Math.floor(Math.random() * 255);
					return "rgb(" + r + "," + g + "," + b + ")";
				};

/*****************************************************************************/

veriler = $.parseJSON('<?php echo json_encode($sikayet_eklenme_grafik) ?>');;

for(var item in veriler) {
					renk_1.push(dynamicColors());
				}

var sikayet_eklenme = document.getElementById("sikayet_eklenme_grafik").getContext('2d');
				var sikayet_eklenme_grafik = new Chart(sikayet_eklenme, {
					type: '<?php echo $tur ?>',
					data: {
						labels: ["Ocak", "Şubat", "Mart", "Nisan", "Mayıs", "Haziran", "Temmuz", "Ağustos", "Eylül", "Ekim", "Kasım", "Aralık"],
						datasets: [
						{

label: 'Sayi',
							data: <?php echo "[".implode(",", $sikayet_eklenme_grafik)."]" ?>,
							borderWidth: 2,
							backgroundColor: '#6a7194',
							borderColor: '#6a7194',
							borderWidth: 2.5,
							pointBackgroundColor: '#ffffff',
							pointRadius: 4,
							<?php if($tur=="pie" OR $tur=="doughnut" OR $tur=="polarArea" OR $tur=="radar"){echo "backgroundColor: renk_1,borderColor:'#ffffff',";} ?>
						}				
						]
					},
					<?php if($tur=="line" OR $tur=="bar" OR $tur=="radar"){echo "options:{
						legend: {
							display: false
						},
					},";} ?>

});

/*****************************************************************************/

veriler = $.parseJSON('<?php echo json_encode($tesekkur_eklenme_grafik) ?>');;

for(var item in veriler) {
					renk_2.push(dynamicColors());
				}

var tesekkur_eklenme = document.getElementById("tesekkur_eklenme_grafik").getContext('2d');
				var tesekkur_eklenme_grafik = new Chart(tesekkur_eklenme, {
					type: '<?php echo $tur ?>',
					data: {
						labels: ["Ocak", "Şubat", "Mart", "Nisan", "Mayıs", "Haziran", "Temmuz", "Ağustos", "Eylül", "Ekim", "Kasım", "Aralık"],
						datasets: [
						{

label: 'Sayi',
							data: <?php echo "[".implode(",", $tesekkur_eklenme_grafik)."]" ?>,
							borderWidth: 2,
							backgroundColor: '#04ada9',
							borderColor: '#04ada9',
							borderWidth: 2.5,
							pointBackgroundColor: '#ffffff',
							pointRadius: 4,
							<?php if($tur=="pie" OR $tur=="doughnut" OR $tur=="polarArea" OR $tur=="radar"){echo "backgroundColor: renk_2,borderColor:'#ffffff',";} ?>
						}				
						]
					},
					<?php if($tur=="line" OR $tur=="bar" OR $tur=="radar"){echo "options:{
						legend: {
							display: false
						},
					},";} ?>
				});

/*****************************************************************************/

veriler = $.parseJSON('<?php echo json_encode($sikayet_cevaplanma_grafik) ?>');;

for(var item in veriler) {
					renk_3.push(dynamicColors());
				}

var sikayet_cevaplanma = document.getElementById("sikayet_cevaplanma_grafik").getContext('2d');
				var sikayet_cevaplanma_grafik = new Chart(sikayet_cevaplanma, {
					type: '<?php echo $tur ?>',
					data: {
						labels: ["Ocak", "Şubat", "Mart", "Nisan", "Mayıs", "Haziran", "Temmuz", "Ağustos", "Eylül", "Ekim", "Kasım", "Aralık"],
						datasets: [
						{

label: 'Sayi',
							data: <?php echo "[".implode(",", $sikayet_cevaplanma_grafik)."]" ?>,
							borderWidth: 2,
							backgroundColor: '#6A937B',
							borderColor: '#6A937B',
							borderWidth: 2.5,
							pointBackgroundColor: '#ffffff',
							pointRadius: 4,
							<?php if($tur=="pie" OR $tur=="doughnut" OR $tur=="polarArea" OR $tur=="radar"){echo "backgroundColor: renk_3,borderColor:'#ffffff',";} ?>
						}				
						]
					},
					<?php if($tur=="line" OR $tur=="bar" OR $tur=="radar"){echo "options:{
						legend: {
							display: false
						},
					},";} ?>
				});

/*****************************************************************************/

veriler = $.parseJSON('<?php echo json_encode($incelenme_sayisi_grafik) ?>');;

for(var item in veriler) {
					renk_4.push(dynamicColors());
				}

var incelenme_sayisi = document.getElementById("incelenme_sayisi_grafik").getContext('2d');
				var incelenme_sayisi_grafik = new Chart(incelenme_sayisi, {
					type: '<?php echo $tur ?>',
					data: {
						labels: ["Ocak", "Şubat", "Mart", "Nisan", "Mayıs", "Haziran", "Temmuz", "Ağustos", "Eylül", "Ekim", "Kasım", "Aralık"],
						datasets: [
						{

label: 'Sayi',
							data: <?php echo "[".implode(",", $incelenme_sayisi_grafik)."]" ?>,
							borderWidth: 2,
							backgroundColor: '#BF6B7D',
							borderColor: '#BF6B7D',
							borderWidth: 2.5,
							pointBackgroundColor: '#ffffff',
							pointRadius: 4,
							<?php if($tur=="pie" OR $tur=="doughnut" OR $tur=="polarArea" OR $tur=="radar"){echo "backgroundColor: renk_4,borderColor:'#ffffff',";} ?>
						}				
						]
					},
					<?php if($tur=="line" OR $tur=="bar" OR $tur=="radar"){echo "options:{
						legend: {
							display: false
						},
					},";} ?>
				});

function tur(kendisi) {
					window.location.href = "firma_rapor?tur="+$(kendisi).val();
				}

</script>

İptal

📁 PHP Dosya Yöneticisi

📝 firma_rapor.php

📝 firma_rapor.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)