PHP Dosya Yöneticisi

<?php 
include_once 'panel/config.php';

$meta_baslik=$ayarcek['site_baslik'];
$meta_aciklama=$ayarcek['site_aciklama'];
$meta_anahtar_kelime=@$ayarcek['site_anahtar_kelime'];
$meta_one_cikan=$ayarcek['site_link']."/img/genel/".$ayarcek['site_one_cikan'];
$ekmeta='<meta name="robots" content="all,follow"/>  <meta property="og:type" content="website"/>';
require 'header.php'; ?>

<?php require_once 'header-top.php'; ?>

<div id="kayan-firmalar" class="owl-carousel owl-theme" style="margin-top: -3rem">
  <?php foreach ($crud->cok("SELECT logo,isim,link FROM firma WHERE durum=1 ORDER BY RAND() LIMIT 10") as $key => $value): ?>
    <div class="item m-2 mt-4">
      <a href="marka/<?php echo $value['link'] ?>">
        <div class="futures-version-2-box shadow-sm">
          <img alt="<?php echo $value['isim'] ?>" class="text-center" src="<?php echo yol."/img/firma/".$value['logo']  ?>" style="height: 75px;display: initial;max-width: 100%; width: auto; ">
                        
        </div>
      </a>
    </div>
  <?php endforeach ?>
</div>

<div class="col-md-6 side-text-right-container animate__animated animate__backInLeft wow">
        <h2 class="side-text-right-title">Şikayetçiyim Nasıl Çalışır?</h2>
        <p class="side-text-right-text"><?php echo $ayarcek['nasil_calisir_metni'] ?><p>
          <a class="side-text-right-button" href="sikayet-olustur">Şikayet Oluştur</a>
        </div>

<img src="img/nasil.svg" alt="<?php echo $ayarcek['site_link'] ?> Nasıl Çalışır?">

</div>

</div>
   </div>
 </section>
 <div class="container mt-4">
   <h5 class="text-left baslik">Son <b>Eklenen</b> Şikayetler</h5>
 </div>
 <div class="ust-ticker animate__animated animate__fadeInUp wow py-2">
  <?php foreach ($crud->cok("SELECT sikayet.*,firma.isim,kullanicilar.kul_isim,kullanicilar.kul_logo,firma.link as firma_link FROM sikayet 
    INNER JOIN firma ON firma.firma_id=sikayet.firma
    INNER JOIN kullanicilar ON kullanicilar.kul_id=sikayet.ekleyen
    WHERE sikayet.durum=1 
    ORDER BY sikayet.eklenme_tarihi DESC LIMIT 10
    ") as $key => $value): ?>
    <div  class="col-md-4 col-sm-6">
      <div class="bg-white golge-sm br-1 p-4 w-b">
        <div class="row">
          <div class="d-flex mr-auto">
            <div class="ml-2 mr-2">
              <img alt="kullanıcı" src="img/profil/<?php echo $value['kul_logo'] ?>" style="height: 40px; width:40px">
            </div>
            <div>
              <div><?php echo $value['kul_isim'] ?></div>
              <div class="text-left">
                <a href="marka/<?php echo $value['firma_link'] ?>">
                  <?php echo $value['isim'] ?>
                </a>
              </div>
            </div>
          </div>
          <div class="ml-auto">
           <b><?php echo $value['incelenme_sayisi'] ?></b> Görüntülenme 
         </div>
       </div>
       <a href="sikayet/<?php echo $value['link'] ?>" class="">
        <div class="w-100">
          <b class="mt-2 fs-25 "><?php echo mb_substr($value['baslik'], 0,70); echo (strlen($value['baslik'])>70) ? "..." : "" ; ?></b>
        </div>
      </a>
    </div>
  </div>
<?php endforeach ?>
</div>

<div class="container mt-4">
 <h5 class="text-left baslik">Son <b>Cevaplanan</b> Şikayetler</h5>
</div>
<div class="alt-ticker animate__animated animate__fadeInUp wow py-2" style="display: none;">
  <?php foreach ($crud->cok("SELECT sikayet.*,firma.isim,kullanicilar.kul_isim,kullanicilar.kul_logo,firma.link as firma_link FROM sikayet 
    INNER JOIN firma ON firma.firma_id=sikayet.firma
    INNER JOIN kullanicilar ON kullanicilar.kul_id=sikayet.ekleyen
    WHERE sikayet.durum=1 AND cevap_durum=1 
    ORDER BY cevap_tarihi DESC LIMIT 10
    ") as $key => $value): ?>
    <div  class="col-md-4">
      <div class="bg-white golge-sm br-1 p-4  w-b">
        <div class="row">
          <div class="d-flex mr-auto">
            <div class="ml-2 mr-2">
              <img alt="kullanıcı" src="img/profil/<?php echo $value['kul_logo'] ?>" style="height: 40px; width:40px">
            </div>
            <div>
              <div><?php echo $value['kul_isim'] ?></div>
              <div class="text-left"><a href="marka/<?php echo $value['firma_link'] ?>"><?php echo $value['isim'] ?></a></div>
            </div>
          </div>
          <div class="ml-auto">
            <b><?php echo $value['incelenme_sayisi'] ?></b> Görüntülenme
          </div>
        </div>
        <a href="sikayet/<?php echo $value['link'] ?>" class="">
          <b class="mt-2 fs-25"><?php echo mb_substr($value['baslik'], 0,70); echo (strlen($value['baslik'])>70) ? "..." : "" ; ?></b>
        </a>
      </div>
    </div>
  <?php endforeach ?>
</div>

<section class="mt-3 position-relative">
  <div class="container
  ">
  <div class="banner-servers-box">
    <div class="counter-placeholder"></div>
    <div class="banner-text-left">
      <h5>Marka Değerlendirmeleri</h5>
      <p>Teşekkür - Şikayet Sayıları, Çözümlenen Şikayetler Ve Kullanıcı Değerlendirmeleri</p>
    </div>
    <a class="benchmarks-link" href="#">Şikayetçiyim</a>
  </div>

<div class="row justify-content-left server-tabls-head">
    <div class="col-md-2 mx-auto text-center">Logo</div>
    <div class="col-md-2 mx-auto text-center">İsim</div>
    <div class="col-md-2 mx-auto text-center">Toplam Şikayet</div>
    <div class="col-md-2 mx-auto text-center">Çözülen Şikayet</div>
    <div class="col-md-2 mx-auto text-center">Teşekkür</div>
    <div class="col-md-2 mx-auto text-center">Değerlendirme</div>
  </div>

<?php foreach ($crud->cok("SELECT * FROM firma ORDER BY RAND() LIMIT 10") as $key => $firma): ?>

<?php

$toplam_sikayet=$crud->tek("SELECT COUNT(sikayet_id) as sonuc FROM `sikayet` WHERE tur=0 AND durum=1 AND firma={$firma['firma_id']}")['sonuc'];
    $cozulen_sikayet=$crud->tek("SELECT COUNT(sikayet_id) as sonuc FROM `sikayet` WHERE tur=0 AND durum=2 AND firma={$firma['firma_id']}")['sonuc'];
    $toplam_tesekkur=$crud->tek("SELECT COUNT(sikayet_id) as sonuc FROM `sikayet` WHERE tur=1 AND durum!=0 AND firma={$firma['firma_id']}")['sonuc'];

<div class="row justify-content-left server-tabls-row golge-sm my-3 animate__animated animate__bounceInLeft wow" style="padding: 8px;">
      <div class="col-md-2">
        <span class="server-spects-for-mobile">Logo</span>
        <a href="<?php echo yol."/marka/".$firma['link'] ?>"><img alt="<?php echo $firma['isim'] ?>" class="text-center" src="<?php echo yol."/img/firma/".$firma['logo']  ?>" style="max-height: 45px;display: initial;max-width: 100%; width: auto;"></a>
      </div>
      <div class="col-md-2 d-flex align-items-center "><a href="<?php echo yol."/marka/".$firma['link'] ?>" class=""><span class="server-spects-for-mobile mr-auto">İsim: </span> <b class="mx-auto"><?php echo $firma['isim'] ?></b></a></div>
      <div class="col-md-2 d-flex align-items-center "><span class="server-spects-for-mobile mr-auto">Toplam Şikayet: </span> <b class="mx-auto"><?php echo sayi_format($toplam_sikayet) ?></b></div>
      <div class="col-md-2 d-flex align-items-center "><span class="server-spects-for-mobile mr-auto">Çözülen Şikayet: </span> <b class="mx-auto"><?php echo $cozulen_sikayet ?></b></div>
      <div class="col-md-2 d-flex align-items-center "><span class="server-spects-for-mobile mr-auto">Teşekkür: </span> <b class="mx-auto"><?php echo $toplam_tesekkur ?></b></div>
      <div class="col-md-2 d-flex align-items-center "><a class="server-order-button" href="<?php echo yol."/marka/".$firma['link'] ?>">Detaylı Bilgi</a></div>
    </div>
  <?php endforeach ?>

</div>

</div>
</section>

<div class="container-fluid">
    <div class="row justify-content-around">
      <div class="animate__animated animate__jackInTheBox wow col-md-5" style="background:#f2f7fb; padding: 2rem; border-radius: 1rem">
        <h4 class="baslik-2 mb-3">Son 1 <b>Ayda</b> En Çok <b>İncelenen</b> Şikayetler</h4>

<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' GROUP BY sikayet.baslik ORDER BY toplam DESC LIMIT 5") as $key => $value): ?>

<div class="col-md-12">
              <div class="futures-version-2-box shadow-sm p-3 my-1">
                <div class="row">
                  <div class="col-md-1">
                    <a href="marka/<?php echo $value['link'] ?>"><img style="height: 40px;width: 40px;border-radius: 100%;border: 2px solid gray;padding: 3px;" src="img/firma/<?php echo $value['logo'] ?>" alt="<?php echo $value['isim'] ?>"></a>
                  </div>
                  <div class="col-md-11">
                   <a href="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="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 class="animate__animated animate__jackInTheBox wow col-md-5" style="background:#f2f7fb; padding: 2rem; border-radius: 1rem">
      <h4 class="baslik-2 mb-3">Son 1 <b>Haftada</b> En Çok <b>İncelenen</b> Şikayetler</h4>

<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' GROUP BY sikayet.baslik ORDER BY toplam DESC LIMIT 5") as $key => $value): ?>

<div class="col-md-12">
            <div class="futures-version-2-box shadow-sm p-3 my-1 ">
              <div class="row">
                <div class="col-md-1">
                  <a href="marka/<?php echo $value['link'] ?>"><img style="height: 40px;width: 40px;border-radius: 100%;border: 2px solid gray;padding: 3px;" src="img/firma/<?php echo $value['logo'] ?>" alt="<?php echo $value['isim'] ?>"></a>
                </div>
                <div class="col-md-11">
                 <a href="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="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>

</section>

<?php if ($ayarcek['anasayfa_istatistik']==1): ?>
  <section class="mt-3 p-4 sayilarla-arkaplan">
    <div class="container">
      <h5 class="baslik-2 text-center">Sayılarla <b>Şikayetçiyim</b></h5>

<div class="row justify-content-center mt-4">
        <div class="col-md-3 mb-3">
          <div class="sayi-alani golge-sm">
            <div><i class="fas fa-pencil-alt"></i></div>
            <span class="fs-25"><b>Şikayet Sayısı</b></span> 
            <br>
            <span class="sayi fs-25"><?php echo sayi_format($crud->tek("SELECT COUNT(sikayet_id) as sonuc FROM sikayet WHERE tur=0")['sonuc']) ?></span>
          </div>                 
        </div>

<div class="col-md-3 mb-3">
          <div class="sayi-alani golge-sm">
            <div><i class="fas fa-users"></i></div>
            <span class="fs-25"><b>Üye Sayısı</b></span> 
            <br>
            <span class="sayi fs-25"><?php echo sayi_format($crud->tek("SELECT COUNT(kul_id) as sonuc FROM kullanicilar")['sonuc']) ?></span>
          </div>                 
        </div>

<div class="col-md-3 mb-3">
          <div class="sayi-alani golge-sm">
            <div><i class="fas fa-building"></i></div>
            <span class="fs-25"><b>Marka Sayısı</b></span> 
            <br>
            <span class="sayi fs-25"><?php echo sayi_format($crud->tek("SELECT COUNT(firma_id) as sonuc FROM firma")['sonuc']) ?></span>
          </div>                 
        </div>

<div class="col-md-3 mb-3">
          <div class="sayi-alani golge-sm">
            <div><i class="fas fa-building"></i></div>
            <span class="fs-25"><b>Şikayet İnceleme</b></span> 
            <br>
            <span class="sayi fs-25"><?php echo sayi_format($crud->tek("SELECT SUM(incelenme_sayisi) as sonuc FROM sikayet")['sonuc']) ?></span>
          </div>                 
        </div>
      </div>
    </div>
  </section>  
<?php endif ?>

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

İptal

📁 PHP Dosya Yöneticisi

📝 index.php

📝 index.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)