<?php include("header.php"); ?>
<?php include("nav_bar.php"); ?>
<?php include("nav_left.php"); ?>

<?php
$overallproducts=mysqli_query($conn,"SELECT count(*) as overallproducts from tbl_projects");
$row = mysqli_fetch_row($overallproducts);
$overallproducts = $row[0];

$overallitems=mysqli_query($conn,"SELECT count(*) as overallitems from tbl_blogs");
$row = mysqli_fetch_row($overallitems);
$overallitems = $row[0];

?>
 <!-- Notification --> 
		<div class="main">
			<!-- MAIN CONTENT -->
			<div class="main-content">
				<div class="container-fluid">
					<!-- OVERVIEW -->
					<div class="panel panel-headline">
						<div class="panel-heading">
							<h3 class="panel-title">Dashboard</h3>
							<p class="panel-subtitle"></p>
						</div>
						<div class="panel-body">
							<div class="col-md-12" style="margin-top: 10px;">
							<div class="row"> 
								<div class="col-md-3">
									<div class="metric">
										<span class="icon"><i class="lnr lnr-tag"></i></span>
										<p>
											<span class="customer_number number"><?=$overallproducts;?></span>
											<span class="title">Projects</span>
										</p>
									</div>
								</div>
								<div class="col-md-3">
									<div class="metric">
										<span class="icon"><i class="lnr lnr-tag"></i></span>
										<p>
											<span class="customer_number number"><?=$overallitems;?></span>
											<span class="title">Blogs</span>
										</p>
									</div>
								</div>

							</div>
						</div>
						</div>
					</div>
					<!-- END OVERVIEW -->


				</div>

			</div>
		</div>
<?php include("footer.php"); ?>
<script>
$('#filter_search').on('click',function(){
	FilterDate();
});
$('.reset').on('click',function(){
	$('#from_date').val('');
	$('#to_date').val('');
	FilterDate();
});
$(document).ready(function(){
	FilterDate();
});
function FilterDate(){
	var from_date = $('#from_date').val();
		var to_date = $('#to_date').val();
        $.ajax({
            type:'POST',
            url:'get_dashboard_data.php',
            dataType: "json",
            data:{from_date:from_date,to_date:to_date},
            success:function(data){
				console.log(data);
				$('.customer_number').text(data.customers);
				$('.order_number').text(data.orders);
				$('.sales_number').text(data.sales);

            }
        });
}
</script>