<?php  
  session_start();
  $_SESSION['active'] = 'dashboard';
  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>
    <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  appointment_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  appointment_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> 
  <?php  include "footer.php" ?>