PHP Dosya Yöneticisi

<?php

include_once 'config.php';
include_once 'classes/class-ticket.php';

$islem = new ticket($db);

$meta_baslik="Destek Biletleri | ".$ayarcek['site_baslik'];
include'header.php';
if (isset($_POST['ticketsilme'])) {
	if ($islem->silme("ticket","ticket_id",$_POST['ticket_id'])) {
		le(s,$_POST['silinecekbaslik']." başlıklı destek biletini sildi.");
		header("location:destek-biletleri.php?durum=ok");
		exit;
	} else {
		header("location:destek-biletleri.php?durum=no");
		exit;
	}
}

<?php if (yetkikontrol()): ?>
	<div class="container-fluid">
		<div class="row">
			
			<div class="col-lg-3 col-md-6 col-sm-6 col-12">
				<div class="card card-statistic-1 shadow">
					<div class="card-icon bg-primary">
						<i class="fas fa-life-ring"></i>
					</div>
					<div class="card-wrap">
						<div class="card-header">
							<h4>Toplam Ticket Sayısı</h4>
						</div>
						<div class="card-body">
							<?php echo $crud->satirsayisi("ticket","ticket_id","","hepsi") ?>
						</div>
					</div>
				</div>
			</div>

<div class="col-lg-3 col-md-6 col-sm-6 col-12">
				<div class="card card-statistic-1 shadow">
					<div class="card-icon bg-info">
						<i class="fas fa-user-clock"></i>
					</div>
					<div class="card-wrap">
						<div class="card-header">
							<h4>Cevap Bekleyen Ticket</h4>
						</div>
						<div class="card-body">
							<?php echo $crud->satirsayisi("ticket","ticket_durum","1") ?>
						</div>
					</div>
				</div>
			</div>

<div class="col-lg-3 col-md-6 col-sm-6 col-12">
				<div class="card card-statistic-1 shadow">
					<div class="card-icon bg-warning">
						<i class="fas fa-hourglass-half"></i>
					</div>
					<div class="card-wrap">
						<div class="card-header">
							<h4>Bekleyen Ticket</h4>
						</div>
						<div class="card-body">
							<?php echo $crud->satirsayisi("ticket","ticket_durum","3") ?>
						</div>
					</div>
				</div>
			</div>

<div class="col-lg-3 col-md-6 col-sm-6 col-12">
				<div class="card card-statistic-1 shadow">
					<div class="card-icon bg-danger">
						<i class="fas fa-door-closed"></i>
					</div>
					<div class="card-wrap">
						<div class="card-header">
							<h4>Kapalı Ticket Sayısı</h4>
						</div>
						<div class="card-body">
							<?php echo $crud->satirsayisi("ticket","ticket_durum","0") ?>
						</div>
					</div>
				</div>
			</div>                  
		</div>
	</div>
<?php endif ?>

<div class="container-fluid">
	<div class="row">
		<div class="col-md-11 mx-auto">
			<div class="card card-primary br-1 shadow mb-4">
				<div class="card-header py-3">
					<h6 class="m-0 font-weight-bold text-primary">Destek Biletleri</h6>
				</div>
				<div class="card-body" style="width: 100%">
					
					<button type="button"class="btn btn-sm btn-info icon-split secenekler">
						<span class="icon text-white-65">
							<i class="fas fa-edit"></i>
						</span>
						<span class="text">Seçenekler</span>
					</button>

<div class="tabloust" style="margin-bottom: 10px;">
						
						<button type="button" id="hepsi" style="margin-bottom: 5px;" class="btn btn-sm btn-info icon-split">
							<span class="icon text-white-65">
								<i class="fas fa-edit"></i>
							</span>
							<span class="text">Hepsi</span>
						</button>

<button type="button" id="kapali" style="margin-bottom: 5px;" class="btn btn-sm btn-danger icon-split">
							<span class="icon text-white-65">
								<i class="fas fa-power-off"></i>
							</span>
							<span class="text">Kapalı Biletler</span>
						</button>

<button type="button" id="musteri-yanit" style="margin-bottom: 5px;" class="btn btn-sm btn-success icon-split">
							<span class="icon text-white-65">
								<i class="fas fa-clock"></i>
							</span>
							<span class="text">Firma Yanıtı</span>
						</button>

<button type="button" id="gorevli-yanit" style="margin-bottom: 5px;" class="btn btn-sm btn-primary icon-split">
							<span class="icon text-white-65">
								<i class="fas fa-circle-notch"></i>
							</span>
							<span class="text">Görevli Yanıtı</span>
						</button>

<button type="button" id="acelesiyok" style="margin-bottom: 5px;" class="btn btn-sm btn-warning icon-split">
							<span class="icon text-white-65">
								<i class="fas fa-hourglass-start"></i>
							</span>
							<span class="text">Acelesi Yok</span>
						</button>

<span class="dropdown no-arrow">
							<button data-toggle="dropdown" aria-expanded="false" type="button" id="aktarmagizleme" style="margin-left: 4px; margin-bottom: 5px;" class="btn btn-sm btn-primary icon-split dropdown-toggle"><span class="icon text-white-65"><i class="fas fa-file-export"></i></span><span class="text">Dışa Aktar</span>
							</button>

<div class="dropdown-menu" aria-labelledby="aktarmagizleme">
								<a class="dropdown-item"> 
									<button type="button" onclick="fnAction('copy');" title="asdsad" attr="Tabloyu Kopyala" class="btn btn-sm icon-split btn-dark">
										<span class="icon text-white-65">
											<i class="fas fa-copy"></i>
										</span>
										<span class="text">Kopyala</span>
									</button>
								</a>
								<a class="dropdown-item" title="">  
									<button type="button" onclick="fnAction('excel');" attr="Excel Formatında Dışa Aktar" class="btn btn-sm icon-split btn-success">
										<span class="icon text-white-65">
											<i class="fas fa-file-excel"></i>
										</span>
										<span class="text">Excel</span>
									</button>
								</a>
								<a class="dropdown-item">
									<button type="button" onclick="fnAction('pdf');" attr="PDF Formatında Dışa Aktar" class="btn btn-sm icon-split btn-danger">
										<span class="icon text-white-65">
											<i class="fas fa-file-pdf"></i>
										</span>
										<span class="text">PDF</span>
									</button>
								</a>
								<a class="dropdown-item">
									<button type="button" onclick="fnAction('csv');" attr="CSV Formatında Dışa Aktar" class="btn btn-sm icon-split btn-primary">
										<span class="icon text-white-65">
											<i class="fas fa-file-csv"></i>
										</span>
										<span class="text">CSV</span>
									</button>
								</a>
							</div>
						</span>
						
					</div>
					<div class="table-responsive">
						<table class="table table-bordered" id="tickettablosu" width="100%" cellspacing="0">
							<thead>
								<tr> 
									<th>No</th>
									<th>Firma</th>
									<th>Konu</th>
									<th>Durum</th>	
									<th>Aciliyet</th>	
									<th>Son Yanıt</th>	
									<th>Teknik Departman</th> 
									<th>İşlemler</th>
								</tr>
							</thead>
							
							<tbody>
								<?php 
								$say=0;
								if (yetkikontrol(h)) {
									$sql="SELECT * FROM ticket LEFT JOIN firma ON firma.firma_id=ticket.ticket_firma ORDER BY ticket_son_yanit_tarih DESC";
								} else {
									$sql="SELECT * FROM ticket LEFT JOIN firma ON firma.firma_id=ticket.ticket_firma WHERE ticket_firma={$_SESSION['yetkili_firma']} ORDER BY ticket_son_yanit_tarih DESC";
								}
								foreach ($islem->cok($sql) as $ticket) { 
									$say++;
									?>
									<tr>
										<td><?php echo $say; ?></td>
										<td><?php echo $ticket['isim'] ?></td>
										<td><?php echo $ticket['ticket_konu']; ?></td>
										<td><?php 
										if ($ticket['ticket_durum']==0) {
											echo "<span class='badge badge-danger'>Kapalı</span>";
										} elseif ($ticket['ticket_durum']==1) {
											echo "<span class='badge badge-success'>Firma Yanıtladı</span>";
										} elseif ($ticket['ticket_durum']==2) {
											echo "<span class='badge badge-primary'>Görevli Yanıtladı</span>";
										} elseif ($ticket['ticket_durum']==3) {
											echo "<span class='badge badge-warning'>Beklemede</span>";
										}
										?></td>
										<td class="text-center"><?php 
										if ($ticket['ticket_aciliyet']=="Acil") {
											echo "<span class='badge badge-danger'>Acil</span>";
										} else {
											echo $ticket['ticket_aciliyet'];
										}
										?></td>
										
										<td class="text-center"><?php 
										if ($ticket['ticket_son_yanit_tarih']=="0000-00-00 00:00:00") {
											echo "---";
										} else {
											echo $ticket['ticket_son_yanit_tarih'];
										}
										?></td>
										<td class="text-center"><?php 
										if ($ticket['ticket_departman']==0) {
											echo "<span class='badge badge-secondary'>Genel Sorun</span>";
										} elseif ($ticket['ticket_departman']==1) {
											echo "<span class='badge badge-warning'>Şikayet/Kullanıcı Bildirme</span>";
										} elseif ($ticket['ticket_departman']==2) {
											echo "<span class='badge badge-info'>Teknik Destek</span>";
										}
										?></td>
										<td>
											<div class="d-flex justify-content-center">
												<a href="destek-bileti?ticket_id=<?php echo $ticket['ticket_id'] ?>">
													<button type="button" class="btn btn-primary btn-icon icon-left btn-sm"><i class="fas fa-edit"></i>Yanıtla</button>	
												</a>									
												<?php if (yetkikontrol()): ?>
													<form class="ml-1" action="" method="POST" accept-charset="utf-8">
														<input type="hidden" name="silinecekbaslik" value="<?php echo $ticket['isim'] ?>">
														<input type="hidden" name="ticket_id" value="<?php echo $ticket['ticket_id'] ?>">
														<button type="submit" name="ticketsilme" class="btn btn-danger btn-icon btn-sm silmebutonu"><i class="fas fa-trash"></i></button>
													</form>
												<?php endif ?>		
											</div>
										</td>
									</tr>
								<?php } ?>
							</tbody>
							<tfoot>
								<tr> 
									<th>No</th>
									<th>Firma</th>
									<th>Konu</th>
									<th>Durum</th>	
									<th>Aciliyet</th>	
									<th>Son Yanıt</th>	
									<th>Teknik Departman</th>						
									<th>İşlemler</th>
								</tr>
							</tfoot>
							
						</table>
					</div>
				</div>
			</div>
		</div>
	</div>
</div>

<?php include'footer.php' ?>

column
					.search( val ? '^'+val+'$' : '', true, false )
					.draw();
				});

column.data().unique().sort().each( function ( d, j ) {
					var val = $('<div/>').html(d).text();
					
					if (val.length>29) {
						filtremetin =  val.substr(0,30)+"...";
					} else {
						filtremetin=val;
					}
					select.append( '<option value="' + val + '">' + filtremetin + '</option>' )
				});

});
		},
		"ordering": true,  
		"searching": true, 
		"lengthChange": true,
		"info": true,
		dom: "<'row tablearama tabloust'<'col-md-6'l><'col-md-6'f><'col-md-4 d-none d-print-block'B>>rtip",
		buttons: [
		{
			extend: 'copyHtml5', 
			className: 'kopyalama-buton',
			messageBottom: 'Aksoyhlc Ürün Satış Yazılımı Tarafından Üretilmiştir'
		},
		{
			extend: 'excelHtml5', 
			className: 'excel-buton',
			messageBottom: 'Aksoyhlc Ürün Satış Yazılımı Tarafından Üretilmiştir'
		},
		{
			extend: 'pdfHtml5',
			className: 'pdf-buton',
			messageBottom: 'Aksoyhlc Ürün Satış Yazılımı Tarafından Üretilmiştir'
		},
		{
			extend: 'csvHtml5',
			className: 'csv-buton',
			messageBottom: 'Aksoyhlc Ürün Satış Yazılımı Tarafından Üretilmiştir'
		}
		]
	});
	 //Sonradan yapılan butona tıklandığında asıl dışa aktarma butonunun çalışması
	 function fnAction(action) {
	 	switch (action) {
	 		case "excel":
	 		$('.excel-buton').trigger('click');
	 		break;
	 		case "pdf":
	 		$('.pdf-buton').trigger('click');
	 		break;
	 		case "copy":
	 		$('.kopyalama-buton').trigger('click');
	 		break;
	 		case "csv":
	 		$('.csv-buton').trigger('click');
	 		break;
	 	}
	 }
  //Tablo filtreleme işlemleri
  $('#hepsi').on('click', function () {
  	dataTables
  	.columns()
  	.search( '' )
  	.columns( '.sold_out' )
  	.search( 'YES' )
  	.draw();
  	dataTables.column(3).search("").draw();
  }); 
  $('#kapali').on('click', function () {
  	dataTables
  	.columns()
  	.search( '' )
  	.columns( '.sold_out' )
  	.search( 'YES' )
  	.draw();
  	dataTables.column(3).search("Kapalı").draw();
  }); 
  $('#musteri-yanit').on('click', function () {
  	dataTables
  	.columns()
  	.search( '' )
  	.columns( '.sold_out' )
  	.search( 'YES' )
  	.draw();
  	dataTables.column(3).search("Firma Yanıtladı").draw();
  }); 
  $('#gorevli-yanit').on('click', function () {
  	dataTables
  	.columns()
  	.search( '' )
  	.columns( '.sold_out' )
  	.search( 'YES' )
  	.draw();
  	dataTables.column(3).search("Görevli Yanıtladı").draw();
  }); 
  $('#beklemede').on('click', function () {
  	dataTables
  	.columns()
  	.search( '' )
  	.columns( '.sold_out' )
  	.search( 'YES' )
  	.draw();
  	dataTables.column(3).search("Beklemede").draw();
  }); 
  $('#acil').on('click', function () {
  	dataTables
  	.columns()
  	.search( '' )
  	.columns( '.sold_out' )
  	.search( 'YES' )
  	.draw();
  	dataTables.column(4).search("Acil").draw();
  }); 
  $('#orta').on('click', function () {
  	dataTables
  	.columns()
  	.search( '' )
  	.columns( '.sold_out' )
  	.search( 'YES' )
  	.draw();
  	dataTables.column(4).search("Orta").draw();
  }); 
  $('#acelesiyok').on('click', function () {
  	dataTables
  	.columns()
  	.search( '' )
  	.columns( '.sold_out' )
  	.search( 'YES' )
  	.draw();
  	dataTables.column(4).search("Acelesi Yok").draw();
  }); 
</script>

İptal

📁 PHP Dosya Yöneticisi

📝 destek-biletleri.php

📝 destek-biletleri.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)