
<?php ob_start(); ?>
<!DOCTYPE html>
<html lang="en">

<head>
<?php   require_once 'head_link.php'; ?>


</head>

<body>
 
<?php   require_once 'header1.php'; ?> 

<?php  require_once 'sidebar.php'; ?>

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

 <!--    <div class="pagetitle">
      <h1>Dashboard</h1>
      <nav>
        <ol class="breadcrumb">
          <li class="breadcrumb-item"><a href="index.html">Home</a></li>
          <li class="breadcrumb-item active">Dashboard</li>
        </ol>
      </nav>
    </div> -->

    <section class="section dashboard">
      <div class="row">
	  
        <div class="col-lg-12">
          <div class="row">
			
			
			  <div class="col-xxl-3 col-md-3">
              <div class="card info-card sales-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>

                    <li><a class="dropdown-item" href="#">Today</a></li>
                    <li><a class="dropdown-item" href="#">This Month</a></li>
                    <li><a class="dropdown-item" href="#">This Year</a></li>
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Total Clients <span> |  All</span></h5>

                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-list"></i>
                    </div>
                    <div class="ps-3">
                      <h6>
					  <?php 
$sql = $con->query("SELECT count(`userid`) as `gtotal` FROM user   where access_level=4  ");
$row = $sql->fetch_assoc();
echo $row['gtotal'];
?>
					  </h6>
                     
                    </div>
                  </div>
                </div>

              </div>
            </div>
			
	        
			 <div class="col-xxl-3 col-md-3">
              <div class="card info-card sales-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>

                    <li><a class="dropdown-item" href="#">Today</a></li>
                    <li><a class="dropdown-item" href="#">This Month</a></li>
                    <li><a class="dropdown-item" href="#">This Year</a></li>
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Active Clients <span> | Total</span></h5>

                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-list"></i>
                    </div>
                    <div class="ps-3">
                      <h6>
					  <?php 
$sql = $con->query("SELECT count(`userid`) as `gtotal` FROM user   where access_level=4  ");
$row = $sql->fetch_assoc();
echo $row['gtotal'];
?>
					  </h6>
                     
                    </div>
                  </div>
                </div>

              </div>
            </div>
			
			
				 <div class="col-xxl-3 col-md-3">
              <div class="card info-card sales-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>

                    <li><a class="dropdown-item" href="#">Today</a></li>
                    <li><a class="dropdown-item" href="#">This Month</a></li>
                    <li><a class="dropdown-item" href="#">This Year</a></li>
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Free Trails <span> | Total</span></h5>

                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-list"></i>
                    </div>
                    <div class="ps-3">
                      <h6>
					  <?php 
$sql = $con->query("SELECT count(`userid`) as `gtotal` FROM user   where access_level=4  ");
$row = $sql->fetch_assoc();
echo $row['gtotal'];
?>
					  </h6>
                     
                    </div>
                  </div>
                </div>

              </div>
            </div>
			
         
 			 <div class="col-xxl-3 col-md-3">
              <div class="card info-card sales-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>

                    <li><a class="dropdown-item" href="#">Today</a></li>
                    <li><a class="dropdown-item" href="#">This Month</a></li>
                    <li><a class="dropdown-item" href="#">This Year</a></li>
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Paid Clients <span> | Total</span></h5>

                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-list"></i>
                    </div>
                    <div class="ps-3">
                      <h6>
					  <?php 
$sql = $con->query("SELECT count(`userid`) as `gtotal` FROM user   where access_level=4  ");
$row = $sql->fetch_assoc();
echo $row['gtotal'];
?>
					  </h6>
                     
                    </div>
                  </div>
                </div>

              </div>
            </div>
			
			
			
			</div>
</div> 
			
			
 <div class="col-lg-8">
<div class="row">			

<?php  // require_once 'dash-task.php'; ?>           
<?php  // require_once 'dash-cash-report.php'; ?>           
<?php //  require_once 'dash-report.php'; ?>  
<?php // require_once 'dash-rec-sales.php'; ?>  





            <!-- Top Selling -->
       
          </div>
        </div><!-- End Left side columns -->

        <!-- Right side columns -->
        <div class="col-lg-4">
		
		 <div class="card mb-3 text-center">
            <div class="row g-0">              
              <div class="col-md-12">
                <div class="card-body">
				  
                </div>
              </div>
            </div>
          </div> 
		  
		  <div class="card mb-3">
            <div class="row g-0">
              <div class="col-md-4 text-center p-2">
               <img src="../<?php if ($srow['photo']==""){echo "img/profile.jpg"; } else {echo $srow['photo'];} ?>" width="70%" class="rounded-circle">
              </div>
              <div class="col-md-8">
                <div class="card-body"><br>
				
				<?php
								$dq=mysqli_query($con,"select * from stuff 
								left join `user` on user.userid=stuff.userid  
								where  user.userid=22  ");
								while($dqrow=mysqli_fetch_array($dq)){
									$did=$dqrow['userid'];
								?>
			        
							
                  		<b><span style="font-size:22px;"> <?php echo $dqrow['business_name']; ?></span></b><br>		  
                  		<b><span style="font-size:15px;"> 
					    <?php echo $dqrow['business_address']; ?>
						</span></b>		  
			

			<?php
								}
							?>	   			  
                </div>
              </div>
            </div>
          </div> 
		  
		  <div class="card mb-3">
            <div class="row g-0">
              <div class="col-md-4 text-center p-2">
                <i style="font-size:65px;" class="bi bi-clock-history text-primary"></i>
              </div>
              <div class="col-md-8">
                <div class="card-body text-center"><br>
                  		<b><span style="font-size:28px;"> <?php include('time.php'); ?></span></b><br>		  
                  		<b><span style="font-size:18px;"> 
						<?php date_default_timezone_set("Asia/Dhaka");
         $date = new DateTime();
         echo $date->format('l - F j, Y');
         ?> </span></b>		  
				   			  
                </div>
              </div>
            </div>
          </div> 
		   
		   <?php // require_once 'more-fals/budget-traffic.php'; ?>  
		   
       
        </div> 

      </div>
    </section>

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

  <!-- ======= Footer ======= -->
   <?php  //require_once '../includes/footer.php'; ?>
   
   <?php  require_once 'footer1.php'; ?>