1#@!#!123s

https 1#@!#!123s
: / home5 / ragvieco / www / admin /
Filename : home.php
back
<?php
	session_start();
	include_once 'function.php';

	
		$get_order = mysqli_query($connect,"SELECT * FROM order_cart_add where status = 'yes' ") or die(mysqli_error());
	    $tcount = mysqli_num_rows($get_order);
	    
	    
	      $get_pending_order = mysqli_query($connect,"SELECT * FROM order_cart_add where status = 'no' ") or die(mysqli_error());
	    $pocount = mysqli_num_rows($get_pending_order);
	    
	    

	    $result = mysqli_query($connect,"SELECT SUM(total) AS total_amount FROM order_cart_add ") or die(mysqli_error());
	   // $amountcount = mysqli_num_rows($get_amount);
	    
	    
	  
?>
<!DOCTYPE html>
<html lang="en">
	<head>
		<meta charset="utf-8" />
		<title>Dash Board | <?php echo $site_title; ?></title>
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<meta content="width=device-width, initial-scale=1" name="viewport" />
		<meta content="Preview page of Metronic Admin Theme #1 for statistics, charts, recent events and reports" name="description" />
		<meta content="" name="author" />
		<!-- BEGIN GLOBAL MANDATORY STYLES -->
		<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">     <link href="http://fonts.googleapis.com/css?family=Open+Sans:400,300,600,700&amp;subset=all" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/simple-line-icons/simple-line-icons.min.css" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/bootstrap-switch/css/bootstrap-switch.min.css" rel="stylesheet" type="text/css" />
		<!-- END GLOBAL MANDATORY STYLES -->
		<!-- BEGIN PAGE LEVEL PLUGINS -->
		<link href="assets/global/plugins/datatables/datatables.min.css" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/datatables/plugins/bootstrap/datatables.bootstrap.css" rel="stylesheet" type="text/css" />
		<!-- END PAGE LEVEL PLUGINS -->
		<!-- BEGIN THEME GLOBAL STYLES -->
		<link href="assets/global/css/components.min.css" rel="stylesheet" id="style_components" type="text/css" />
		<link href="assets/global/css/plugins.min.css" rel="stylesheet" type="text/css" />
		<!-- END THEME GLOBAL STYLES -->
		<!-- BEGIN THEME LAYOUT STYLES -->
		<link href="assets/layouts/layout/css/layout.min.css" rel="stylesheet" type="text/css" />
		<link href="assets/layouts/layout/css/themes/darkblue.min.css" rel="stylesheet" type="text/css" id="style_color" />
		<link href="assets/layouts/layout/css/custom.min.css" rel="stylesheet" type="text/css" />
		
		<link href="assets/global/plugins/select2/css/select2.min.css" rel="stylesheet" type="text/css" />
		<link href="assets/global/plugins/select2/css/select2-bootstrap.min.css" rel="stylesheet" type="text/css" />	    <!-- END PAGE LEVEL PLUGINS -->
		<style type="text/css">
		.dt-buttons {
		display: none;
		}
		</style>
		<script type="text/javascript">
		function delete_menu(idurl)
		{
		go_on = confirm("Are you sure ? ");
		if(go_on)
		{
		document.location.href=idurl;
		}
		}
		</script>
	</head>
	<!-- END HEAD -->
	<body class="page-header-fixed page-sidebar-closed-hide-logo page-content-white">
		<div class="page-wrapper">
			<!-- BEGIN HEADER -->
			<?php include("header.php");?>
			<!-- END HEADER -->
			<!-- BEGIN HEADER & CONTENT DIVIDER -->
			<div class="clearfix">
			</div>
			<!-- END HEADER & CONTENT DIVIDER -->
			<!-- BEGIN CONTAINER -->
			<div class="page-container">
				<!-- BEGIN SIDEBAR -->
				<div class="page-sidebar-wrapper">
					<!-- BEGIN SIDEBAR -->
					<!-- DOC: Set data-auto-scroll="false" to disable the sidebar from auto scrolling/focusing -->
					<!-- DOC: Change data-auto-speed="200" to adjust the sub menu slide up/down speed -->
					<?php include("menu.php");?>
					<!-- END SIDEBAR -->
					</div>			    <!-- END SIDEBAR -->
					<!-- BEGIN CONTENT -->
					<div class="page-content-wrapper">
						<!-- BEGIN CONTENT BODY -->
						<div class="page-content">
							<!-- END THEME PANEL -->
							<!-- BEGIN PAGE BAR -->
							<div class="page-bar">
								<ul class="page-breadcrumb">
									<li>
										<a href="index.php">Home
										</a>
										<i class="fa fa-circle">
										</i>
									</li>
									<li>
										<span>Dashboard
										</span>
									</li>
								</ul>
								
								
								
								<div class="page-toolbar">
									<div id="dashboard-report-range" class="pull-right tooltips btn btn-sm" data-container="body" data-placement="bottom" data-original-title="Change dashboard date range">
										<i class="icon-calendar">
										</i>&nbsp;
										<span class="thin uppercase hidden-xs">
										</span>&nbsp;
										<i class="fa fa-angle-down">
										</i>
										
									</div>
								</div>
							</div>
							
								
							
							
							<!-- END PAGE BAR -->
							<div class="portlet light bordered">
								<div class="portlet-title">
									<div class="caption">
										<i class="icon-social-dribbble font-blue-sharp">
										</i>
										<span class="caption-subject font-blue-sharp bold uppercase">RagviEcoBagsAndTextile
										</span>
									</div>
								</div>
								
								
								<div class="portlet-body">
									<div class="row">
									    
									    <div class="col-lg-3 col-md-3 col-sm-6 col-xs-12">
                                <a class="dashboard-stat dashboard-stat-v2 blue" href="ordered_customer.php">
                                    <div class="visual">
                                        <i class="fa fa-comments"></i>
                                    </div>
                                    <div class="details">
                                        <div class="number">
                                            <span data-counter="counterup" data-value="<?php echo $tcount; ?>"><?php echo $tcount; ?></span>
                                        </div>
                                        <div class="desc">Orders</div>
                                    </div>
                                </a>
                            </div>
                            
                            				    <div class="col-lg-3 col-md-3 col-sm-6 col-xs-12">
                                <a class="dashboard-stat dashboard-stat-v2 purple" href="ordered_customerp.php">
                                    <div class="visual">
                                        <i class="fa fa-comments"></i>
                                    </div>
                                    <div class="details">
                                        <div class="number">
                                            <span data-counter="counterup" data-value="<?php echo $pocount; ?>"><?php echo $pocount; ?></span>
                                        </div>
                                        <div class="desc"> Pending Orders</div>
                                    </div>
                                </a>
                            </div>
                            
         
                            
                            				    <div class="col-lg-3 col-md-3 col-sm-6 col-xs-12">
                                <a class="dashboard-stat dashboard-stat-v2 yellow" href="#">
                                    <div class="visual">
                                        <i class="fa fa-comments"></i>
                                    </div>
                                    <div class="details">
                                        <div class="number">
                                            <span data-counter="counterup" data-value="<?php echo $amountcount; ?>">
                                                
                                                <?php
                                                if ($result) {
    // Fetch the result row
    $row = mysqli_fetch_assoc($result);
    
    // Access the sum value
    $totalAmount = $row['total_amount'];
    
    // Print the sum
    echo  $totalAmount;
} else {
    // Query failed
    echo "Error executing query: " . mysqli_error($connect);
}
                                                
                                      ?>          
                                                
                                                </span>
                                        </div>
                                        <div class="desc">Total Amount</div>
                                    </div>
                                </a>
                            </div>
                            </div>
                            <br>
        
									
								</div>
								
								
								<div class="portlet-body">
									<div class="row">
									</div>
								</div>
							</div>
							
							<!--  -->
							
							<div class="clearfix">
							</div>
							<!-- BEGIN PAGE TITLE-->
							<div class="clearfix">
							</div>
						</div>
						<!-- END CONTENT BODY -->
					</div>
					<!-- END CONTENT -->
					<!-- END QUICK SIDEBAR -->
				</div>
				<!-- END CONTAINER -->
				<!-- BEGIN FOOTER -->
				<?php include("footer.php");?>			  <!-- END FOOTER -->
				</div>
				<!-- BEGIN QUICK NAV -->
				<div class="quick-nav-overlay">
				</div>
				<!-- END QUICK NAV -->>
				<!-- BEGIN CORE PLUGINS -->
				<script src="assets/global/plugins/jquery.min.js" type="text/javascript">
				</script>
				<script src="assets/global/plugins/bootstrap/js/bootstrap.min.js" type="text/javascript">
				</script>
				<script src="assets/global/plugins/js.cookie.min.js" type="text/javascript">
				</script>
				<script src="assets/global/plugins/jquery-slimscroll/jquery.slimscroll.min.js" type="text/javascript">
				</script>
				<script src="assets/global/plugins/jquery.blockui.min.js" type="text/javascript">
				</script>
				<script src="assets/global/plugins/bootstrap-switch/js/bootstrap-switch.min.js" type="text/javascript">
				</script>
				<!-- END CORE PLUGINS -->
				<!-- BEGIN PAGE LEVEL PLUGINS -->
				<script src="assets/global/scripts/datatable.js" type="text/javascript">
				</script>
				<script src="assets/global/plugins/datatables/datatables.min.js" type="text/javascript">
				</script>
				<script src="assets/global/plugins/datatables/plugins/bootstrap/datatables.bootstrap.js" type="text/javascript">
				</script>
				<!-- END PAGE LEVEL PLUGINS -->
				<!-- BEGIN THEME GLOBAL SCRIPTS -->
				<script src="assets/global/scripts/app.min.js" type="text/javascript">
				</script>
				<!-- END THEME GLOBAL SCRIPTS -->
				<!-- BEGIN PAGE LEVEL SCRIPTS -->
				<script src="assets/pages/scripts/table-datatables-colreorder.min.js" type="text/javascript">
				</script>
				<!-- END PAGE LEVEL SCRIPTS -->
				<!-- BEGIN THEME LAYOUT SCRIPTS -->
				<script src="assets/layouts/layout/scripts/layout.min.js" type="text/javascript">
				</script>
				<script src="assets/layouts/layout/scripts/demo.min.js" type="text/javascript">
				</script>
				<script src="assets/layouts/global/scripts/quick-sidebar.min.js" type="text/javascript">
				</script>
				<script src="assets/layouts/global/scripts/quick-nav.min.js" type="text/javascript">
				</script>
				<!-- END THEME LAYOUT SCRIPTS -->
				<!-- Google Code for Universal Analytics -->
			</body>
		</html>