<?php include("includes/db_config.php");?>
<!DOCTYPE html>
<html lang="en-IN">
<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>Orange Groceries</title>
	<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
	<?php include("includes/css.php")?>
</head>

<body class="hold-transition skin-blue sidebar-mini">
    <div class="wrapper">
        <?php include("includes/header.php");?>
            <?php include("includes/sidebar.php");?>
                <div class="content-wrapper">
                    <!-- Content Header (Page header) -->
                    <section class="content-header">
                        <h1>
                    Dashboard
                    <small>Control panel</small>
                </h1>
                        <ol class="breadcrumb">
                            <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
                            <li class="active">Dashboard</li>
                        </ol>
                    </section>
                    <!-- Main content -->
                    <section class="content">
                        <div class="row">
                           <div class="col-lg-3 col-xs-6"> 

                                <div class="small-box bg-green">
                                    <?php $sql="select count(*) as num from product where added_by='admin'";
                                         $res=mysqli_query($conn,$sql);
                                        $row= mysqli_fetch_array($res)
                                    ?>
                                    <div class="inner">
                                        <h3><?php echo $row['num']; ?></h3>
                                        <p>Products</p>
                                    </div>
                                    <div class="icon"> <i class="fa fa-first-order text-white"></i> </div> <a href="products.php" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a> </div>
                            </div>
							 <div class="col-lg-3 col-xs-6"> 
                                <div class="small-box bg-aqua">
                                    <?php $sql1="select count(*) as count from addto_cart where invoice_id='0' GROUP BY order_no";
                                         $res1=mysqli_query($conn,$sql1);
                                        $row1= mysqli_fetch_array($res1)
                                    ?>
                                    <div class="inner">
                                        <h3><?php echo $row1['count']; ?></h3>
                                        <p>Order </p>
                                    </div>
                                    <div class="icon"> <i class="fa fa-shopping-basket text-white"></i> </div> <a href="product-order-details.php" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a> </div>
                            </div> 
							
                        </div>
                    </section>
                    <!-- /.content -->
                </div>
                <!-- /.content-wrapper -->
                <?php include("includes/footer.php");?>
                    <div class="control-sidebar-bg"></div>
    </div>
    <?php include("includes/js.php");?>
</body>

</html>