bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

halohalo bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

<?php
	error_reporting(0);
	session_start(); // Use session variable on this page. This function must put on the top of page.
	include "dbc.php"; 
	page_protect();
	$id=$_SESSION['raga_id'];
	?>
    <?php include "header.php";?>
          <div class="main-bar">
            <h3>
              <i class="fa fa-dashboard"></i>&nbsp; Dashboard</h3>
          </div>
        </header>
      </div>
      
      
      <?php include "admin_admin.php";?>
      <div id="content">
        <div class="outer">
          <div class="inner bg-light lter">
          <?php if (checkAdmin()) { ?>
          
            <div class="text-center">
              <ul class="stats_box">
                
                <?php 
  					$total_ords = mysqli_num_rows(mysqli_query($link,"select * from shopping_tbl group by `order_id`"));
  					$pending_ords = mysqli_num_rows(mysqli_query($link,"select * from shopping_tbl where order_status='Pending' group by `order_id`"));
  					$processed_ords = mysqli_num_rows(mysqli_query($link,"select * from shopping_tbl where order_status='Processed' group by `order_id`"));
  					$outfordelivery_ords = mysqli_num_rows(mysqli_query($link,"select * from shopping_tbl where order_status='Out For Delivery' group by `order_id`"));
  					$completed_ords = mysqli_num_rows(mysqli_query($link,"select * from shopping_tbl where order_status='Complete' group by `order_id`"));
  					$cancelled_ords = mysqli_num_rows(mysqli_query($link,"select * from shopping_tbl where order_status='Cancelled' group by `order_id`"));
				?>
                <li>
                  <div class="sparkline pie_week"><i class="fa fa-money fa-2x"></i></div>
                  <div class="stat_text">
                    <strong class="clrled">Total Orders</strong>
                    <strong><a href="view_orders.php"><?php echo $total_ords;?></a></strong> 
                    
                  </div>
                </li>
                
                <li>
                  <div class="sparkline pie_week"><i class="fa fa-money fa-2x"></i></div>
                  <div class="stat_text">
                    <strong class="clrled">Pending Orders</strong>
                    <strong><a href="view_orders.php?status=Pending"><?php echo $pending_ords;?></a></strong> 
                    
                  </div>
                </li>
                
                <li>
                  <div class="sparkline pie_week"><i class="fa fa-money fa-2x"></i></div>
                  <div class="stat_text">
                    <strong class="clrled">Processed Orders</strong>
                    <strong><a href="view_orders.php?status=Processed"><?php echo $processed_ords;?></a></strong> 
                    
                  </div>
                </li>
                
                <li>
                  <div class="sparkline pie_week"><i class="fa fa-money fa-2x"></i></div>
                  <div class="stat_text">
                    <strong class="clrled">Out For Delivery Orders</strong>
                    <strong><a href="view_orders.php?status=Out For Delivery"><?php echo $outfordelivery_ords;?></a></strong> 
                    
                  </div>
                </li>
                
                <li>
                  <div class="sparkline pie_week"><i class="fa fa-money fa-2x"></i></div>
                  <div class="stat_text">
                    <strong class="clrled">Completed Orders</strong>
                    <strong><a href="view_orders.php?status=Complete"><?php echo $completed_ords;?></a></strong> 
                    
                  </div>
                </li>
                
                <li>
                  <div class="sparkline pie_week"><i class="fa fa-money fa-2x"></i></div>
                  <div class="stat_text">
                    <strong class="clrled">Cancelled Orders</strong>
                    <strong><a href="view_orders.php?status=Cancelled"><?php echo $cancelled_ords;?></a></strong> 
                    
                  </div>
                </li>
                </ul>
                <ul class="stats_box">
                <?php 
  					$total_prods = mysqli_num_rows(mysqli_query($link,"select * from product_tbl"));
  					$active_prods = mysqli_num_rows(mysqli_query($link,"select * from product_tbl where status='Active'"));
  					$inactive_prods = mysqli_num_rows(mysqli_query($link,"select * from product_tbl where status='Disabled'"));
  					$instock_prods = mysqli_num_rows(mysqli_query($link,"select * from product_tbl where stock_avail='In Stock'"));
  					$outofstock_prods = mysqli_num_rows(mysqli_query($link,"select * from product_tbl where stock_avail='Out Of Stock'"));
  				?>	
                
                <li>
                  <div class="sparkline pie_week"><i class="fa fa-cube fa-2x"></i></div>
                  <div class="stat_text">
                    <strong class="clrled">Total Products</strong>
                    <strong><a href="view_product.php"><?php echo $total_prods;?></a></strong> 
                    
                  </div>
                </li>
                
                <li>
                  <div class="sparkline pie_week"><i class="fa fa-cube fa-2x"></i></div>
                  <div class="stat_text">
                    <strong class="clrled">Active Products</strong>
                    <strong><a href="view_product.php"><?php echo $active_prods;?></a></strong> 
                    
                  </div>
                </li>
                
                <li>
                  <div class="sparkline pie_week"><i class="fa fa-cube fa-2x"></i></div>
                  <div class="stat_text">
                    <strong class="clrled">Inactive Products</strong>
                    <strong><a href="view_product.php"><?php echo $inactive_prods;?></a></strong> 
                    
                  </div>
                </li>
                
                <li>
                  <div class="sparkline pie_week"><i class="fa fa-cube fa-2x"></i></div>
                  <div class="stat_text">
                    <strong class="clrled">In Stock Products</strong>
                    <strong><a href="view_product.php"><?php echo $instock_prods;?></a></strong> 
                    
                  </div>
                </li>
                
                <li>
                  <div class="sparkline pie_week"><i class="fa fa-cube fa-2x"></i></div>
                  <div class="stat_text">
                    <strong class="clrled">Out Of Stock Products</strong>
                    <strong><a href="view_product.php"><?php echo $outofstock_prods;?></a></strong> 
                    
                  </div>
                </li>
				  
              </ul>
            </div>
            <?php } ?>
            
          </div>
        </div>
      </div>
      
      
      <?php include "right-side.php";?>
    </div>
<?php include "footer.php";?>
</body>
</html>