PHP Dosya Yöneticisi

<?php $blok="anasayfa";?>

<?php include 'inc/header.php';?>

</script>

<?php include 'inc/sidebar.php';?>

<?php include 'inc/navbar.php';?>

<h1 class="pd-0 mg-0 tx-20">Yönetici Paneli</h1>

</div>

<a class="breadcrumb-item" href="index.php"> Anasayfa</a>

<span class="breadcrumb-item active">Yönetici Paneli</span>

</div>

<?php

$iletisim = $dbh->query("SELECT * FROM contact WHERE id ", PDO::FETCH_ASSOC);

$sip = $dbh->query("SELECT * FROM product_order WHERE status=0 ", PDO::FETCH_ASSOC);

</div>

<h6 class="tx-facebook"><?=$iletisim->rowCount()?> Adet</h6>

<p class="tx-10 mg-t-10 mg-b-5 tx-gray-500 ">Bekleyen İletişim Talebi</p>

<div class="progress-bar bg-primary w-<?=$iletisim->rowCount()?>" role="progressbar" aria-valuenow="<?=$iletisim->rowCount()?>" aria-valuemin="0" aria-valuemax="100"></div>

</div>

</div>

<h6 class="tx-twitter"><?=$sip->rowCount()?> Adet</h6>

<p class="tx-10 mg-t-10 mg-b-5 tx-gray-500 ">Bekleyen Siparişler</p>

<div class="progress-bar bg-info w-<?=$iletisim->rowCount()?>" role="progressbar" aria-valuenow="<?=$iletisim->rowCount()?>" aria-valuemin="0" aria-valuemax="100"></div>

</div>

<h4 class="card-header-title">
      Ziyaretçi Analizi
    </h4>

</div>

</div>

Son 5 İletişim Talebi

</h4>

</div>

<?php
   $iletisimsorgu = $dbh->prepare("SELECT * FROM contact order by id desc LIMIT 7 ");
   $iletisimsorgu->execute();

while ($iletisimsonuc = $iletisimsorgu->fetch()) {

$id = $iletisimsonuc['id'];
    $name_surname = $iletisimsonuc['name_surname'];
    $title = $iletisimsonuc['title'];
    $date = $iletisimsonuc['date'];
    $phpdate = strtotime( $date );
    $mysqlday = date( 'd', $phpdate );
    $mysqlmonth = date( 'm', $phpdate );
    $mysqlyears = date( 'Y', $phpdate );
    $mysqlclock = date( 'H:i ', $phpdate ); 
    ?>

<div>

</div>

<div>

</div>

<span class="badge badge-outlined badge-primary" data-toggle="modal" data-target="#m_modal_<?=$iletisimsonuc['id'];?>">İncele</span>

</div>

</a>

<div class="modal" id="m_modal_<?=$iletisimsonuc['id'];?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel_2" aria-hidden="true">

</button>

</div>

<p>

<b>İsim Soyisim:</b> <?=$iletisimsonuc['name_surname'];?><br>  <br>

<b>Telefon Numarası:</b> <?=$iletisimsonuc['phone'];?><br><br>

<b>Mail Adresi:</b> <?=$iletisimsonuc['email'];?><br><br>

<b>Başlık:</b> <?=$iletisimsonuc['title'];?><br>
         <br>

<b><h6>Açıklama;</h6></b><br><?=$iletisimsonuc['description'];?>

</p>

</div>

</div>

<button type="button" class="btn btn-secondary" data-dismiss="modal">Kapat</button>

</div>

<?php } ?>

</div>

Bekleyen Son 5 Yeni Sipariş

</h4>

</div>

<?php
    $sipsorgu = $dbh->prepare("SELECT * FROM product_order order by id desc LIMIT 7");
    $sipsorgu->execute();

while ($sipsonuc = $sipsorgu->fetch()) {

$id = $sipsonuc['id'];
      $sipno = $sipsonuc['sipno'];
      $name_surname = $sipsonuc['name_surname'];
      $email = $sipsonuc['email'];
      $phone = $sipsonuc['phone'];
      $sip = json_decode($sipsonuc['sip']);
      $tutar = $sipsonuc['amount'];
      $city = $sipsonuc['city'];
      $adres = $sipsonuc['adress'];
      $note = $sipsonuc['note'];
      $tip = $sipsonuc['odeme_tip'];
      $payment = $sipsonuc['payment'];
      $history = $sipsonuc['history'];
      $phpdate = strtotime( $history );
      $mysqldayxxxxx = date( 'd', $phpdate );
      $mysqlmonthxxxx = date( 'm', $phpdate );
      $mysqlyearsxxxxxx = date( 'Y', $phpdate );
      $mysqlclockxxxxxxx = date( 'H:i', $phpdate );
      ?>

<div>

</div>

</div>

<p class="tx-12 mg-b-0 tx-gray-500 tx-normal"><?php if ($payment==1) {echo "<font color='green'>Ödendi</font>";}else{echo"<font color='red'>Ödenmedi</font>";} ?> -

<?php if ($tip==2) {echo " <span class='badge badge-outlined badge-success'>Kapıda Ödeme</span>";}elseif ($tip==1) {echo " <span class='badge badge-outlined badge-success'>Havale Eft</span>";}else{echo " <span class='badge badge-outlined badge-primary'>Online Ödeme</span>";} ?>

</p>

<span class="badge badge-outlined badge-danger" data-toggle="modal" data-target="#m_modal_55<?=$id;?>"  data-toggle="tooltip" data-trigger="hover" data-placement="left" title="" data-original-title="Detay Görüntüle">İncele</span>

</div>

</a>

<div class="modal" id="m_modal_55<?=$id;?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLongTitle_1" aria-hidden="true">
 <div class="modal-dialog" role="document">
   <div class="modal-content">
     <div class="modal-header">
       <h5 class="modal-title" id="exampleModalLongTitle_1"><?php echo $dil["siparis_bilgileri"];?></h5>
       <button type="button" class="close" data-dismiss="modal" aria-label="Close">
         <span aria-hidden="true"><i class="ion-ios-close-empty"></i></span>
       </button>
     </div>
     <div class="modal-body section-to-print"> 
       <p>
        <b>#<?=$sipno;?> / <?=$mysqldayxxxxx?>.<?=$mysqlmonthxxxx?>.<?=$mysqlyearsxxxxxx?> - <?=$mysqlclockxxxxxxx?></b><br>
        <b><center><?php echo $dil["odeme_bilgileri"];?>;</center></b><br><?php if ($tip==2) {echo "<button class='btn btn-outline-success btn-block mg-b-10'>Online Ödeme</button>";}else{echo "<button class='btn btn-outline-blue btn-block mg-b-10'>Kapıda Ödeme</button>";} ?>
        <?php if ($payment==1) {echo "<button class='btn btn-success btn-block mg-b-10'>Ödendi</button>";}else{echo"<button class='btn btn-danger btn-block mg-b-10'>Ödenmedi</button>";} ?><br>
        <b><?php echo $dil["isim_soyisim"];?>:</b> <?=$name_surname;?><br>  
        <b><?php echo $dil["telefon"];?>:</b> <?=$phone;?><br>
        <b><?php echo $dil["email"];?>:</b> <?=$email;?><br>
        <b><?php echo $dil["adres"];?>:</b> <?=$city;?> - <?=$adres?><br>
        <br>
        <b><?php echo $dil["siparis_no"];?>:</b> #<?=$sipno;?><br>
        <b><?php echo $dil["toplam_tutar"];?>:</b> <?=$tutar;?> TL<br>
        <b><center><h6><?php echo $dil["siparisler"];?>;</h6></center></b><br>

<?php 
        $_SESSION['sepett']=$sip;
        foreach ($_SESSION['sepett'] as $siparis => $siparisdetay) {
          $array=$siparisdetay;

$urun_getir = $dbh -> prepare("SELECT * FROM product WHERE id = ?");
          $urun_getir-> execute(array($siparisdetay->urunid));
          $urun = $urun_getir->fetch(PDO::FETCH_ASSOC);
          $fiyat = $urun["product_price"];
          $ekstraistek=0;
          $porsyon="";
          if($siparisdetay->menu_porsiyon>0){
            $porsyon = $dbh -> prepare("SELECT * FROM product_serving WHERE id = ?");
            $porsyon-> execute(array($siparisdetay->menu_porsiyon));
            $porsyon = $porsyon->fetch(PDO::FETCH_ASSOC);
            $pfiyat = $porsyon["serving_price"]* $array->qty;
            $ekstraistek+= $pfiyat;
          }  
          $siparisdetayekstra=implode("|", $siparisdetay->extra);
                    ////
          $toplam = $fiyat * $array->qty + $ekstraistek;  
          $toplam2 += $toplam;

echo $porsyon["serving_name"] ." ". $urun["product_name"]." <b> x ".$array->qty." Adet </b> <br> Toplam Tutar: ".$toplam." TL<br> --------<br>";

}

?>
        <br>
        <b><h6>Not;</h6></b><?=$note;?>

</p>

</div>
   </div>
   <div class="modal-footer">
     <div class="btn-group mg-t-10">
       <div class="btn-group">
        <button type="button" class="btn btn-warning dropdown-toggle" data-toggle="dropdown" aria-expanded="false"> <i data-feather="settings" height="15px"></i> İşlemler</button>
        <div class="dropdown-menu">
         <a class="dropdown-item tx-13" href="#"><i data-feather="info" height="15px"></i> Bekliyor</a>
         <a class="dropdown-item tx-13" href="#"><i data-feather="refresh-ccw" height="15px"></i> Hazırlanıyor</a>
         <a class="dropdown-item tx-13" href="#"><i data-feather="check" height="15px"></i> Tamamlandı</a>
         <a class="dropdown-item tx-13" href="#"><i data-feather="x-circle" height="15px"></i> İptal Edildi</a>
       </div>
     </div> 
     <button type="button" class="btn btn-primary yazdir"> <i data-feather="printer" height="15px"></i> <?php echo $dil["yazdır"];?></button> 
     <button type="button" class="btn btn-secondary" data-dismiss="modal"><i data-feather="x" height="15px"></i> <?php echo $dil["kapat"];?></button>
   </div>
 </div>
</div>
</div>
</div>

<?php } ?>

</div>

Son Eklenen 10 Ürün

</h4>

</div>

<tr>

<th class="border-0">Ürün Görseli</th>

<th class="border-0">Ürün Fiyatı</th>

<th class="border-0 text-right">İşlem</th>

</tr>

</thead>

<tbody>

<?php
   $urunsorgu = $dbh->prepare("SELECT * FROM product order by id desc LIMIT 7");
   $urunsorgu->execute();

while ($urunsonuc = $urunsorgu->fetch()) {

$id = $urunsonuc['id'];
    $foto = $urunsonuc['foto'];
    $product_name = $urunsonuc['product_name'];
    $product_price = $urunsonuc['product_price'];
    $parent = $urunsonuc['parent'];
    $date = $urunsonuc['date'];
    $phpdate = strtotime( $date );
    $mysqldayxxxxxx = date( 'd', $phpdate );
    $mysqlmonthxxxxx = date( 'm', $phpdate );
    $mysqlyearsxxxxxxx = date( 'Y', $phpdate );
    $mysqlclockxxxxxxxx = date( 'H:i', $phpdate );
    $check = $dbh->query("SELECT * FROM menu_categories WHERE id = '".$parent."' ", PDO::FETCH_ASSOC);
    if ($check->rowCount()) {
      foreach ($check as $check) {
      }

$kategori = $check["categories_name"];
    }
    ?>

<tr>

<img src="../img/<?=$urunsonuc['foto'];?>" alt="" class="img-fluid rounded">

</td>

<td>

<p class="mb-0 tx-12">Ürün Kategorisi: <a href="#"><?=$kategori?></a></p>

<div>

<p class="mb-0 tx-12">Eklenme Tarihi: <a href="#"><?=$mysqldayxxxxxx?>.<?=$mysqlmonthxxxxx?>.<?=$mysqlyearsxxxxxxx?> <?=$mysqlclockxxxxxxxx?></a></p>

</div>

</td>

<td>

</td>

<a href="urun-duzenle.php?id=<?=$urunsonuc['id'];?>" class="btn btn-outline-primary btn-icon mg-r-5"  data-toggle="tooltip" data-trigger="hover" data-placement="left" title="" data-original-title="Ürün Düzenle"><div><i class="fa fa-cog"></i></div></a>

</td>

</tr>

<?php } ?>

</tbody>

</table>

</div>

</div>

</div>

<?php include 'inc/footer.php';?>

?>
  var options = {

series: [{
      name: "Ziyaretciler",
      data: ['<?
      $sayilar=[];
      $tarihler=[];
      foreach ($strows as  $value) {
       $sayilar[]=$value["sayisi"];
       $tarihler[]=$value["tarih"];
     }
     echo implode("','",$sayilar);
     ?>']
   }],
   chart: {
    height: 350,
    type: 'line',
    zoom: {
      enabled: false
    }
  },
  dataLabels: {
    enabled: false
  },
  stroke: {
    curve: 'straight'
  },
  title: {
    text: '',
    align: 'left'
  },
  grid: {
    row: {
            colors: ['#f3f3f3', 'transparent'], // takes an array which will be repeated on columns
            opacity: 0.5
          },
        },
        xaxis: {
          categories: ['<?
          echo implode("','",$tarihler);
          ?>'],
        },
        yaxis:{
         floating: false,
         decimalsInFloat: undefined,
         labels: {
          "formatter": function (val) {
            return val.toFixed(0)
          }
        }
      }
    };

var chart = new ApexCharts(document.querySelector("#zoomableTimeSces"), options);
    chart.render();

</script>

İptal

📁 PHP Dosya Yöneticisi

📝 index.php

📝 index.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)