📁 PHP Dosya Yöneticisi
/
/
home
/
demodesigncom
/
sikayetscripti.demodesign.com.tr
/
panel
📝
destek-biletleri.php
← Geri Dön
<?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; } } ?> <link href="assets/modules/datatables/dataTables.bootstrap4.min.css" rel="stylesheet"> <?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%"> <!--Tablo filtreleme butonları mobilde gizlendiğinde gözükecek buton--> <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;"> <!--Tablo filtreleme butonları bölümü giriş--> <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="acil" style="margin-bottom: 5px;" class="btn btn-sm btn-danger icon-split"> <span class="icon text-white-65"> <i class="fas fa-hourglass-start"></i> </span> <span class="text">Acil</span> </button> <button type="button" id="orta" style="margin-bottom: 5px;" class="btn btn-sm btn-info icon-split"> <span class="icon text-white-65"> <i class="fas fa-hourglass-start"></i> </span> <span class="text">Orta</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> <!--Tablo filtreleme butonları bölümü çıkış--> <!--Tabloyu excel-pdf-csv olarak dışa aktarma butonlarının olduğu alan giriş--> <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> <!--Tabloyu excel-pdf-csv olarak dışa aktarma butonlarının olduğu alan çıkış--> </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> <!--While döngüsü ile veritabanında ki verilerin tabloya çekilme işlemi giriş--> <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> <!--While döngüsü ile veritabanında ki verilerin tabloya çekilme işlemi çıkış--> </table> </div> </div> </div> </div> </div> </div> <!--Datatables çıkış--> <?php include'footer.php' ?> <script> var dataTables = $('#tickettablosu').DataTable({ initComplete: function () { this.api().columns([1,3,4,6]).every( function () { var column = this; var select = $('<select class="filtre"><option value=""></option></select>') .appendTo( $(column.footer()).empty() ) .on( 'change', function () { var val = $.fn.dataTable.util.escapeRegex( $(this).val() ); 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>
💾 Kaydet
İptal
📝 Yeniden Adlandır
İptal
Kaydet
🔐 Dosya İzinleri (chmod)
İzin Değeri:
Hızlı Seçim:
777
755
644
600
777
= Herkes okur/yazar/çalıştırır
755
= Sahip tam, diğerleri okur/çalıştırır
644
= Sahip okur/yazar, diğerleri okur
600
= Sadece sahip okur/yazar
İptal
Uygula