<?php
session_start();
if(isset($_SESSION['email']))
{
require_once('sidebar.php');
require_once('header.php');
require_once("database.php");
$query="SELECT COUNT(*) FROM  order_information  WHERE status='Delivered'";
$total_booking=db::getCell($query);
$query="SELECT COUNT(*) FROM  order_information WHERE NOT status='Delivered'";
$active_order=db::getCell($query);
?>
  <div class="content" >
        <div class="content">
          <div class="container-fluid" style="margin-top:-40px">
            <div class="row">
              <div class="col-md-12">
                <div class="card " style="min-height:550px">
                <div class="card-header card-header-info"   >
                <h4 class="card-title ">Dashboard</h4>
                </div>
                    <div class=" card-body row">
                        <div class="col-lg-4 col-sm-4 col-md-4" >
                        <div class="card bg-teal-400" style="background-color:#F44538">
                                        <div class="card-body">
										<div class="d-flex">
											<h3  class="card-title " style="color:white" >Total Cuisine</h3>
										</div>
					                	
					                	<div style="color:white">
                                            <h5>96</h5> 
										</div>
									</div>
                                            </div>
                                    </div>
                                     <div class="col-lg-4 col-sm-4 col-md-4" >
                                         <a href="Delivered_ordered.php">
                                        <div class="card bg-teal-400" style="background-color:#F44538">
                                        <div class="card-body">
										<div class="d-flex">
											<h3 class="card-title " style="color:whitw" >Delivered Orders</h3>
										</div>
					                	
					                	<div style="color:white">
                                       <h4><?php echo $total_booking ?></h4>
                                            </div>
									</div>
                                            </div>
                                            </a>
                                    </div>
                                     <div class="col-lg-4 col-sm-4 col-md-4" >
                                         <a href="active_order.php">
                                        <div class="card bg-teal-400" style="background-color:#F44538">
                                        <div class="card-body">
										<div class="d-flex">
											<h3  class="card-title " style="color:white" >Active Bookings</h3>
										 
					                	</div>
					                	
					                	<div style="color:white">
                                            <h4><?php echo $active_order ?></h4> 
										</div>
									</div>
                                            </div></a>
                                    </div>
                                    <div class="col-md-12">
              <!--<div class="card ">-->
              <!--  <div class="card-header card-header-text card-header-rose">-->
              <!--    <div class="card-text" style="background:#E93E21">-->
              <!--      <h4 class="card-title">Custom Skin &amp; Settings Map</h4>-->
              <!--    </div>-->
              <!--  </div>-->
              <!--  <div class="card-body ">-->
              <!--    <h4 class="card-title"></h4>-->
              <!--    <iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d2519.713571762574!2d4.365194915560442!3d50.836469167355986!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x47c3c48f8e9d1fbd%3A0xc4bdb01484648f1d!2sShezan!5e0!3m2!1sen!2s!4v1598596766435!5m2!1sen!2s" style="width:100%" height="450" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>-->
              <!--  </div>-->
              <!--</div>-->
            </div>
                                    
                    </div>
                    
                    
                 
                          </div>
                          </div>
                        </div>
           
              
                      </div>
                    </div>
                  </div>

<?php
    include ("footer.php");
    }
else
{
   echo "<script>
            window.location.href = 'login.php';
            </script>";
}
?>