<?php
  
  session_start();
 $_SESSION['active'] = 'Dashboard';

  include('include/header.php');
  $booking = booking_data();
  
?>

  <main id="main" class="main">

    <div class="pagetitle">
      <h1>DASHBOARD</h1>
      <nav>
        <ol class="breadcrumb">
          <li class="breadcrumb-item"><a href="dashboard.php">Home</a></li>
          <li class="breadcrumb-item active">Dashboard</li>
        </ol>
      </nav>
    </div><!-- End Page Title -->

    <section class="section dashboard">
      <div class="row">

        <div class="col-lg-8">
          <div class="row">
             <?php
                 $row = mysqli_fetch_array($booking);
                 $cdata = date('Y-m-d H:i:s', strtotime($row['create_date'] . ' -1 day'));
              ?>
            <div class="col-xxl-4 col-md-6">
              <div class="card info-card sales-card">
                <div class="card-body">
                  <h5 class="card-title">Total <span>| Appoinments</span></h5>

                  <div class="d-flex align-items-center">
                    
                    <div class="ps-3">
                         <?php
                         $select_data = executework("SELECT * FROM  appoinment_report");
                         $count = mysqli_num_rows($select_data);
                      ?>
                      <h6><?= $count?></h6>
                    </div>
                  </div>
                </div>

              </div>
            </div>



           <div class="col-xxl-4 col-md-6">
              <div class="card info-card sales-card">
                <div class="card-body">
                  <h5 class="card-title">Today <span>| Appoinments</span></h5>

                  <div class="d-flex align-items-center">
                  
                     <?php
                          $todaydate=date('Y-m-d');
                         $select_todaydate = executework("SELECT * FROM  appoinment_report where app_date = '".$todaydate."'");
                         $count_data = mysqli_num_rows($select_todaydate);
                         if($count_data >0)
                         {
                           $cnt = $count_data;
                         }
                         else
                         {
                           $cnt =0;
                         }
                         
                          
                      ?>
                      <h6><?= $cnt?></h6>
                    </div>
                  </div>
                </div>

              </div>
            </div>


            </div>
        </div>
        </div>
    </section>

  </main><!-- End #main -->

  <!-- ======= Footer ======= -->
 <footer id="footer" class="footer">
    <div class="copyright">
      &copy; Copyright <strong><span>DentalAdmin</span></strong>. All Rights Reserved
    </div>
    <div class="credits">
      <!-- All the links in the footer should remain intact. -->
      <!-- You can delete the links only if you purchased the pro version. -->
      <!-- Licensing information: https://bootstrapmade.com/license/ -->
      <!-- Purchase the pro version with working PHP/AJAX contact form: https://bootstrapmade.com/nice-admin-bootstrap-admin-html-template/ -->
      Designed by <a href="http://www.siimatechnologies.com/" target="_blank">Siima Technologies</a>
    </div>
  </footer><!-- End Footer -->

  <a href="#" class="back-to-top d-flex align-items-center justify-content-center"><i class="bi bi-arrow-up-short"></i></a>

  <!-- Vendor JS Files -->
  <script src="assets/vendor/apexcharts/apexcharts.min.js"></script>
  <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
  <script src="assets/vendor/chart.js/chart.min.js"></script>
  <script src="assets/vendor/echarts/echarts.min.js"></script>
  <script src="assets/vendor/quill/quill.min.js"></script>
  <script src="assets/vendor/simple-datatables/simple-datatables.js"></script>
  <script src="assets/vendor/tinymce/tinymce.min.js"></script>
  <script src="assets/vendor/php-email-form/validate.js"></script>

  <!-- Template Main JS File -->
  <script src="assets/js/main.js"></script>

</body>

</html>