<?php 
session_start();
ob_start();
include("branch_connection.php");

$sujpath="./";
?>
<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>Projects</title>
    <!-- Tell the browser to be responsive to screen width -->
    <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
    <!-- Bootstrap 3.3.5 -->
    <link rel="stylesheet" href="<?php echo $sujpath; ?>bootstrap/css/bootstrap.min.css">
    <!-- Font Awesome -->
     <link rel="stylesheet" href="<?php echo $sujpath; ?>font-awesome/font-awesome.min.css">
    <!-- Ionicons -->
    <link rel="stylesheet" href="<?php echo $sujpath; ?>font-awesome/ionicons.min.css">
    <!-- Theme style -->
    <link rel="stylesheet" href="<?php echo $sujpath; ?>dist/css/AdminLTE.min.css">
    <!-- AdminLTE Skins. Choose a skin from the css/skins
         folder instead of downloading all of them to reduce the load. -->
    <link rel="stylesheet" href="<?php echo $sujpath; ?>dist/css/skins/_all-skins.min.css">
    <!-- iCheck -->
    <!-- bootstrap wysihtml5 - text editor -->
    <link rel="stylesheet" href="<?php echo $sujpath; ?>plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.min.css">
    
      <link href="assets/css/style2.css" rel="stylesheet" />
      
  </head>
  <body class="hold-transition skin-blue sidebar-mini">
    <div class="wrapper">
   <?php include("head.php");
         include("left.php"); ?> 
      <!-- Content Wrapper. Contains page content -->
      <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>
            Projects 
           <small>- Control panel</small> 
          </h1>  
          <ol class="breadcrumb">
            <li><a href="../index.php"><i class="fa fa-dashboard"></i>Main Home</a></li>
           </ol>
        </section>

       
       
        <!-- Main content -->
        <section class="content">
          <!-- Small boxes (Stat box) -->
    
              <!-- small box -->
        
        
        
        
        
        
        <div class="row" style="  margin-top: 25px; ">
    <?php
// Assuming $con is your database connection
$sq1 = mysqli_query($conn, "SELECT COUNT(*) AS totorders FROM `marketing_order` WHERE status='Order Confirmed'");
$rs1 = mysqli_fetch_array($sq1);
?> 

<div class="col-md-3 col-sm-3 col-xs-6">
    <div class="dashboard-div-wrapper bk-clr-one">
        <i class="fa fa-desktop dashboard-div-icon"></i>
        <div class="progress progress-striped active">
            <div class="progress-bar progress-bar-warning" role="progressbar" aria-valuenow="80" aria-valuemin="0" aria-valuemax="100" style="width: 80%">
            </div>
        </div>
        <h5>Orders Confirmed (<b><?php echo $rs1['totorders']; ?></b>)</h5>
    </div>
</div>

     <?php
     $sq2 = mysqli_query($conn, "SELECT COUNT(*) AS totrec FROM `p_receipts` ");
     $rs2 = mysqli_fetch_array($sq2);
     ?>        
                
                 <div class="col-md-3 col-sm-3 col-xs-6" >
                    <div class="dashboard-div-wrapper bk-clr-two">
                        <i  class="fa fa-edit dashboard-div-icon" ></i>
                        <div class="progress progress-striped active">
  <div class="progress-bar progress-bar-danger" role="progressbar" aria-valuenow="70" aria-valuemin="0" aria-valuemax="100" style="width: 70%">
  </div>
                           
</div>
                         <h5>Receipts (<b><?php echo $rs2['totrec']; ?></b>)</h5>
                    </div>
                </div>
     <?php
     $sq3 = mysqli_query($conn, "SELECT COUNT(*) AS totvou FROM `p_domain` ");
     $rs3 = mysqli_fetch_array($sq3);
     ?>         
                 <div class="col-md-3 col-sm-3 col-xs-6">
                    <div class="dashboard-div-wrapper bk-clr-three">
                        <i  class="fa fa-file-pdf-o dashboard-div-icon" ></i>
                        <div class="progress progress-striped active">
  <div class="progress-bar progress-bar-success" role="progressbar" aria-valuenow="40" aria-valuemin="0" aria-valuemax="100" style="width: 40%">
  </div>
                           
</div>
                         <h5>Domains (<b><?php echo $rs3['totvou']; ?></b>)</h5>
                    </div>
                </div>
                    <?php
                        $sq1 = mysqli_query($conn, "SELECT COUNT(*) AS totorders FROM `marketing_order` WHERE status='Order Confirmed'");
                        $rs1 = mysqli_fetch_array($sq1);
                 ?>        
                <div class="col-md-3 col-sm-3 col-xs-6" >
                    <div class="dashboard-div-wrapper bk-clr-four">
                        <i  class="fa fa-users dashboard-div-icon" ></i>
                        <div class="progress progress-striped active">
  <div class="progress-bar progress-bar-primary" role="progressbar" aria-valuenow="50" aria-valuemin="0" aria-valuemax="100" style="width: 50%">
  </div>
                           
</div>
                         <h5>Customers (<b><?php echo $rs1['totorders']; ?></b>)</h5>
                    </div>
                </div>
                
                
                
              </div>
        
        
        
        
        
        
        
        
     
          <!-- Main row -->



        </section><!-- /.content -->
    </div><!-- /.content-wrapper -->
</div>
	 <?php include("footer.php"); ?>
	<!-- jQuery 2.1.4 -->
    <script src="<?php echo $sujpath; ?>plugins/jQuery/jQuery-2.1.4.min.js"></script>
     <!-- Bootstrap 3.3.5 -->
    <script src="<?php echo $sujpath; ?>bootstrap/js/bootstrap.min.js"></script>
    <!-- Morris.js charts -->
    <script src="<?php echo $sujpath; ?>dist/js/app.min.js"></script>
  </body>
</html>
