PHP Dosya Yöneticisi

<?php 
include'header.php';
yetkikontrol(e);

if (isset($_POST['firmasilme'])) {
  if ($crud->silme("firma","firma_id",$_POST['firma_id'])) {
   le(s,$_POST['silinecekbaslik']." isimli firmayı sildi.");
   header("location:firmalar?durum=ok");
   exit;
 } else {
   header("location:firmalar?durum=no");
   exit;
 }
}
?>

<div class="container-fluid">

<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">Markalar/Firmalar</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>
      
      
      <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>

<div class="">
      <table class="table table-bordered table-hover" id="dataTable" width="100%" cellspacing="0">
        <thead>
          <tr> 
            <th>No</th>
            <th>Logo</th>
            <th>İsim</th>
            <th>Yetkili</th>
            <th>Kategori</th>
            <th>Şikayet Sayısı</th>
            <th>İncelenme</th>
            <th>Durum</th>
            <th>Üyelik Türü</th>
            <th>İşlemler</th>
          </tr>
        </thead>
        
        <tbody>
         <?php 
         $say=0;
         $sonuc=$islem->cok("
          SELECT firma.*,kategori.*,kullanicilar.kul_isim,kullanicilar.kul_id,uyelik.* FROM firma 
          LEFT JOIN kategori ON kategori.kat_id=firma.kategori 
          LEFT JOIN kullanicilar ON kullanicilar.kul_id=firma.yetkili 
          LEFT JOIN uyelik ON uyelik.uyelik_id=firma.uyelik_turu 
          ");
          foreach ($sonuc as $key => $value) {$say++?>
           <tr>
            <td><?php echo $say; ?></td>
            <td><img src="<?php echo yol ?>/img/firma/<?php echo $value['logo'] ?>" style="width: 40px"></td>
            <td><?php echo $value['isim']; ?></td>
            <td><a href="kullanici?kul_id=<?php echo $value['kul_id'] ?>" class="btn-link font-weight-bold"><?php echo $value['kul_isim']; ?></a></td>
            <td><?php echo $value['kat_isim']; ?></td>
            <td><?php echo sayi_format($crud->tek("SELECT COUNT(sikayet_id) as sayi FROM sikayet WHERE firma={$value['firma_id']}")['sayi']) ?></td>
            <td><?php echo $value['incelenme_sayisi']; ?></td>
            <td>
              <?php if ($value['durum']==0): ?>
                Pasif
                <?php else: ?>
                  Aktif
                <?php endif ?>
              </td>
              <td><?php echo $value['uyelik_isim']; ?></td>
              <td>

<a href="sikayetler?firma=<?php echo $value['firma_id'] ?>" class="btn btn-info btn-sm mr-2">Şikayetler</a>

<a href="<?php echo yol ?>/marka/<?php echo $value['link'] ?>" class="btn btn-info btn-sm" target="_blank">
                  <i class="fas fa-eye"></i>
                </a>

<a href="destek-bileti-olustur?firma_id=<?php echo $value['firma_id'] ?>" class="btn btn-warning btn-sm ml-2"><i class="far fa-life-ring"></i></a>

</div>
            </td>   
          </tr>
        <?php } ?>
      </tbody>
      <tfoot>
        <tr> 
          <th>No</th>
          <th>Logo</th>
          <th>İsim</th>
          <th>Yetkili</th>
          <th>Kategori</th>
          <th>Şikayet Sayısı</th>
          <th>İncelenme</th>
          <th>Durum</th>
          <th>Üyelik Türü</th>
          <th>İşlemler</th>
        </tr>
      </tfoot>
      
    </table>
  </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>' )
        });

});
    },

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>

İptal

📁 PHP Dosya Yöneticisi

📝 firmalar.php

📝 firmalar.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)