📁 PHP Dosya Yöneticisi
/
/
home
/
demodesigncom
/
sikayetscripti.demodesign.com.tr
/
panel
📝
siparisler.php
← Geri Dön
<?php include'header.php'; if (isset($_POST['siparissilme'])) { if ($crud->silme("siparis","sip_id",$_POST['sip_id'])) { $detay=$_SESSION['kul_isim']." kullanıcısı ".date('Y.m.d H:i:s')." tarihinde <b>".@$_POST['silinecekbaslik']."</b> başlıklı siparişi sildi."; $crud->log("s",$detay); header("location:siparisler?durum=ok"); exit; } else { header("location:siparisler?durum=no"); exit; } } ?> <div class="container-fluid"> <div class="row"> <div class="col-md-12"> <div class="card card-primary br-1 mt-4 shadow mb-4"> <div class="card-header py-3"> <h6 class="m-0 font-weight-bold text-primary">Siparişler</h6> </div> <div class="card-body" style="width: 100%"> <button type="button"class="btn btn-sm btn-info icon-split mobilgoster"> <span class="icon text-white-65"> <i class="fas fa-edit"></i> </span> <span class="text">Seçenekler</span> </button> <!--Tablo filtreleme butonları mobilde gizlendiğinde gözükecek buton--> <!--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;" class="btn btn-sm btn-primary icon-split dropdown-toggle mb-2"> <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" href="#"> <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" href="#"><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" href="#"><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 class=""> <table class="table table-bordered table-hover" id="dataTable" width="100%" cellspacing="0"> <thead> <tr> <th>#</th> <th>Kod</th> <th>Ücret</th> <th>Firma</th> <th>Başlık</th> <th>Durum</th> <th>Üyelik Türü</th> <th>Ödenme Tarihi</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()) { $kosul=""; } else { $kosul=" WHERE siparis.fir_id={$_SESSION['yetkili_firma']} "; } $sonuc=$islem->cok("SELECT siparis.*,firma.isim,firma.firma_id,uyelik.* FROM siparis LEFT JOIN firma ON firma.firma_id=siparis.fir_id LEFT JOIN uyelik ON uyelik.uyelik_id=siparis.sip_uyelik $kosul ORDER BY sip_id DESC "); foreach ($sonuc as $key => $value) {$say++?> <tr> <td><?php echo $say; ?></td> <td><?php echo $value['sip_kod'] ?></td> <td><?php echo $value['sip_ucret'] ?></td> <td><?php echo $value['isim']; ?></td> <td><?php echo $value['sip_baslik']; ?></td> <td><?php if ($value['sip_durum']==2) { echo "<span class='badge badge-success'>Ödendi</span>"; } else if ($value['sip_durum']==1) { echo "<span class='badge badge-danger'>Ödeme Başarısız</span>"; } else { echo "<span class='badge badge-warning'>Beklemede</span>"; } ?></td> <td><?php echo $value['uyelik_isim']; ?></td> <td><?php echo $value['odeme_tarihi']; ?></td> <td> <div class="d-flex justify-content-center"> <?php if (yetkikontrol()): ?> <form action="siparisduzenle" method="POST"> <input type="hidden" name="sip_id" value="<?php echo $value['sip_id'] ?>"> <button type="submit" name="duzenleme" class="btn btn-success btn-sm icon-split"> <span class="icon text-white-60"> <i class="fas fa-edit"></i> </span> </button> </form> <form class="mx-2" action="" method="POST"> <input type="hidden" name="silinecekbaslik" value="<?php echo $value['sip_baslik'] ?>"> <input type="hidden" name="sip_id" value="<?php echo $value['sip_id']?>"> <button type="submit" name="siparissilme" class="btn btn-danger btn-sm icon-split silmebutonu"> <span class="icon text-white-60"> <i class="fas fa-trash"></i> </span> </button> </form> <?php endif ?> <a href="destek-bileti-olustur?firma_id=<?php echo $value['firma_id'] ?>" class="btn btn-warning btn-sm"><i class="far fa-life-ring"></i></a> </div> </td> </tr> <?php } ?> </tbody> <tfoot> <tr> <th>#</th> <th>Kod</th> <th>Ücret</th> <th>Firma</th> <th>Başlık</th> <th>Durum</th> <th>Üyelik Türü</th> <th>Ödenme Tarihi</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> <?php include'footer.php' ?> <script> var dataTables = $('#dataTable').DataTable({ "ordering": true, "searching": true, "lengthChange": true, "info": true, colReorder: true, stateSave: true, responsive: { details: true }, initComplete: function () { this.api().columns([2,3,5,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>' ) }); }); }, stateSaveParams: function (settings, data) { data.search.search = ""; console.log(data); delete data.search; delete data.columns; delete data.order; console.log(data); }, dom: "<'row mobilgizleexport gizlemeyiac'<'col-md-6'l><'col-md-6'f><'col-md-4 d-none d-print-block'B>>rtip", buttons: [ { extend: 'copyHtml5', className: 'kopyalama-buton' }, { extend: 'excelHtml5', className: 'excel-buton' }, { extend: 'pdfHtml5', className: 'pdf-buton' }, { extend: 'csvHtml5', className: 'csv-buton' } ] }); </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