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

                <div class="filter">
                  <a class="icon" href="courses-add" data-bs-toggle="tooltip" data-bs-placement="top" title="Add New Course"><i class="bi bi-plus-circle "></i></a>
                  <a class="icon" href="courses-list" data-bs-toggle="tooltip" data-bs-placement="top" title="Course List"><i class="bi bi-menu-button-wide-fill"></i></a>
                </div>

                <div class="card-body">
                  <h5 class="card-title"><strong>Course</strong> <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">
                    <a href="courses-list" data-bs-toggle="tooltip" data-bs-placement="top" title="Course List" ><i class="bi bi-book"></i>  </a>
                    </div>
                    <div class="ps-3">
                      <h6>
<?php 
$sql = $con->query("SELECT count(`product_id`) as `gtotal` FROM product where user_id='".$_SESSION['id']."' ");
$row = $sql->fetch_assoc();
echo $row['gtotal'];
?>  / 

<?php 
$sql = $con->query("SELECT sum(`quantity`) as `gtotal` FROM product where user_id='".$_SESSION['id']."' ");
$row = $sql->fetch_assoc();
echo $row['gtotal'];
?>
					  </h6>
                      <span class="text-primary small pt-1 fw-bold">
					  
 <?php 
$sql = $con->query("select sum(buy_rate) as TotalBuy from product where user_id='".$_SESSION['id']."' ");
$row = $sql->fetch_assoc(); 
echo $row['TotalBuy'];
?>  / - Taka
  

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

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

                <div class="filter">
                  <a class="icon" href="student-add" data-bs-toggle="tooltip" data-bs-placement="top" title="Add New Student"><i class="bi bi-plus-circle "></i></a>
                  <a class="icon" href="students-dues-paid" data-bs-toggle="tooltip" data-bs-placement="top" title="Due Paid"><i class="bi bi-person-check-fill"></i></a>
                  <a class="icon" href="student-list" data-bs-toggle="tooltip" data-bs-placement="top" title="Student List"><i class="bi bi-menu-button-wide-fill "></i></a>
                </div>

                <div class="card-body">
                  <h5 class="card-title"><strong> Students </strong>  <span>| <a href="students-only-dues">Dues</a> </span></h5>

                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                    <a href="student-list" data-bs-toggle="tooltip" data-bs-placement="top" title="Student List"> <i class="bi bi-people"></i></a> 
                    </div>
                    <div class="ps-3">
                      <h6>
<?php 
$sql = $con->query("SELECT count(`customer_id`) as `gtotal` FROM `customer` WHERE member_id='".$_SESSION['id']."' and status=1 ");
$row = $sql->fetch_assoc();
echo $row['gtotal'];
?> / 

<span class="text-danger">
<?php 
$sql = $con->query("SELECT count(`customer_id`) as `CustTotalDue` FROM `orders_dues` WHERE recent_due !=0 and user_id='".$_SESSION['id']."' ");
$row = $sql->fetch_assoc();
echo $row['CustTotalDue'];
?>
</span>

					  </h6>
                      <span class="text-danger small pt-1 fw-bold"> 
					  <?php 
$sql = $con->query("SELECT sum(`recent_due`) as `TotalDue` FROM `orders_dues` WHERE user_id='".$_SESSION['id']."' ");
$row = $sql->fetch_assoc();
echo $row['TotalDue'];
?>
					  </span> <span class="text-muted small pt-2 ps-1">Taka</span>

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

              </div>
            </div> 

           
            <div class="col-xxl-3 col-md-6">
              <div class="card info-card revenue-card">

                <div class="filter">
                  <a class="icon" href="orders-retail?o=add" data-bs-toggle="tooltip" data-bs-placement="top" title="New Invoice"><i class="bi bi-plus-circle "></i></a>
                  <a class="icon" href="orders-retail?o=manord" data-bs-toggle="tooltip" data-bs-placement="top" title="Invoice List"><i class="bi bi-menu-button-wide-fill "></i></a>
                </div>

                <div class="card-body">
                  <h5 class="card-title"><strong>  Bill </strong>   <span> | Invoice </span></h5>

                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                    <a href="orders-retail?o=manord" data-bs-toggle="tooltip" data-bs-placement="top" title="Invoice List"> <i class="bi bi-list-check"></i></a>
                    </div>
                    <div class="ps-3">
                      <h6>
<?php 
$sql = $con->query("SELECT count(`order_id`) as `gtotal` FROM `orders` WHERE user_id='".$_SESSION['id']."' ");
$row = $sql->fetch_assoc();
echo $row['gtotal'];
?>
					  </h6>
                      <span class="text-success small pt-1 fw-bold"> 
					   <?php 
$sql = $con->query("SELECT count(`order_id`) as `TodayInv` FROM `orders` WHERE order_date='$date' and  user_id='".$_SESSION['id']."' ");
$row = $sql->fetch_assoc();
echo $row['TodayInv'];
?>  / 

  <?php 
$sql = $con->query("SELECT sum(`today_total`) as `TotalSale` FROM `orders` WHERE order_date='$date' and  user_id='".$_SESSION['id']."' ");
$row = $sql->fetch_assoc();
echo $row['TotalSale'];
?>.tk


					  </span> <span class="text-muted small pt-2 ps-1">Today</span>

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

              </div>
            </div> 

			
			   <div class="col-xxl-3 col-md-6">
              <div class="card info-card customers-card">

                 <div class="filter">
                  <a class="icon" href="office-exp-add" data-bs-toggle="tooltip" data-bs-placement="top" title="Add New Expense"><i class="bi bi-plus-circle "></i></a>
                  <a class="icon" href="office-exp-list" data-bs-toggle="tooltip" data-bs-placement="top" title="Expense List"><i class="bi bi-menu-button-wide-fill"></i></a>
                </div>

                <div class="card-body">
                  <h5 class="card-title"><strong>Expense </strong> <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">
                    <a href="office-exp-list" data-bs-toggle="tooltip" data-bs-placement="top" title="Expense List"> <i class="bi bi-file-earmark-minus-fill text-danger"></i></a>
                    </div>
                    <div class="ps-3">
                      <h6>
<?php 
$sql = $con->query("SELECT count(`id`) as `gtotal` FROM `expense` WHERE user_id='".$_SESSION['id']."' ");
$row = $sql->fetch_assoc();
echo $row['gtotal'];
?>
					  </h6>
                      <span class="text-danger small pt-1 fw-bold"> 
					   <?php 
$sql = $con->query("SELECT count(`id`) as `TodayExp` FROM `expense` WHERE entry_date='$date' and  user_id='".$_SESSION['id']."' ");
$row = $sql->fetch_assoc();
echo $row['TodayExp'];
?>  / 

  <?php 
$sql = $con->query("SELECT sum(`expense_cost`) as `TotalExp` FROM `expense` WHERE entry_date='$date' and  user_id='".$_SESSION['id']."' ");
$row = $sql->fetch_assoc();
echo $row['TotalExp'];
?>.tk


					  </span> <span class="text-muted small pt-2 ps-1">Today</span>

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

              </div>
            </div> 

			
			</div>
</div> 
