 
 <div class="content-wrapper">
    <section class="content-header"> 
      <div class="container-fluid"> 
        <div class="row mb-2">
          <div class="col-sm-6">
            <h5><strong>Admin Panel</strong></h5>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="#">Home</a></li> 
              <li class="breadcrumb-item active">Dashboard</li>
            </ol>
          </div>

        </div>
        <hr>
      </div><!-- /.container-fluid --> 
    </section>
 
   <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <div class="row">
          <div class="col-md-3 col-sm-6 col-12">
            <div class="info-box">
              <span class="info-box-icon bg-info"><i class="far fa-envelope"></i></span>
                <?php  
                  $invoice = mysqli_query($conn,"SELECT count(invoice_id) as Training  FROm  exam_invoice ");
                  $invoice = mysqli_fetch_array($invoice); 
                  ?>
              <div class="info-box-content">
                <span class="info-box-text">Invoices</span>
                <span class="info-box-number"><?php echo $invoice['Training']; ?></span>
              </div>
              <!-- /.info-box-content -->
            </div>
            <!-- /.info-box -->
          </div>
          <!-- /.col -->
          <div class="col-md-3 col-sm-6 col-12">
            <div class="info-box">
              <span class="info-box-icon bg-success"><i class="far fa-flag"></i></span>
               <?php   
                  $enroll = mysqli_query($conn,"SELECT count(student_id) as Training  FROm  student_soes WHERE course !='Disable'");
                  $enroll = mysqli_fetch_array($enroll); 
                  ?>
              <div class="info-box-content">
                <span class="info-box-text">Enrolled Trainee</span>
                <span class="info-box-number"><?php echo $enroll['Training']; ?></span>
              </div>
              <!-- /.info-box-content -->
            </div>
            <!-- /.info-box -->
          </div>
          <!-- /.col -->
          <div class="col-md-3 col-sm-6 col-12">
            <div class="info-box">
              <span class="info-box-icon bg-warning"><i class="far fa-copy"></i></span>
              <?php   
                  $as_course = mysqli_query($conn,"SELECT count(subject_to_class_id) as Training  FROm  subject_to_class_soes ");
                  $as_course = mysqli_fetch_array($as_course); 
                  ?>
              <div class="info-box-content">
                <span class="info-box-text">Course</span>
                <span class="info-box-number"><?php echo $as_course['Training']; ?></span>
              </div>
              <!-- /.info-box-content -->
            </div>
            <!-- /.info-box -->
          </div>
          <!-- /.col -->
          <div class="col-md-3 col-sm-6 col-12">
            <div class="info-box">
              <span class="info-box-icon bg-danger"><i class="far fa-star"></i></span>
               <?php   
                  $ass_trainer = mysqli_query($conn,"SELECT count(student_to_class_id) as Train  FROm  student_to_class_soes");
                  $ass_trainer = mysqli_fetch_array($ass_trainer); 
                  ?>
              <div class="info-box-content">
                <span class="info-box-text">Trainer</span>
                <span class="info-box-number"><?php echo $ass_trainer['Train']; ?></span>
              </div>
              <!-- /.info-box-content -->
            </div>
            <!-- /.info-box -->
          </div>
          <!-- /.col -->
        </div>
        <h5 class="mb-2">Info Orbital</h5>
        <hr>
         <div class="row">
          <div class="col-lg-3 col-6">
            <!-- small card -->
            <div class="small-box bg-info">
              <div class="inner">
                <?php  
                  $place="Training";
                  $Trainer = mysqli_query($conn,"SELECT count(student_id) as Training  FROm  student_soes");
                  $Trainer = mysqli_fetch_array($Trainer); 
                  ?>
                <h3><?php echo $Trainer['Training']; ?></h3>  
                <p>Total Student</p>
              </div>
              <div class="icon">
                <i class="fas fa-users"></i>
              </div>  
              <a href="admin.php?page=trainer" class="small-box-footer">
                <i class="fas fa-arrow-circle-right"></i>
              </a> 
            </div>
          </div>
          <!-- ./col -->
          <div class="col-lg-3 col-6">
            <!-- small card -->
            <div class="small-box bg-info">
              <div class="inner"> 
                <?php  
                  $place="facilitator";
                  $selected = mysqli_query($conn,"SELECT count(Role) as fac  FROm  user WHERE Role LIKE '%$place%'");
                  $sel = mysqli_fetch_array($selected); 
                  ?>
                <h3><?php echo $sel['fac']; ?></h3>  
                <p>Total Facilitator</p>
              </div>
              <div class="icon">
                <i class="fas fa-edit"></i>
              </div> 
              <a href="admin.php?page=facilitator" class="small-box-footer">
                <i class="fas fa-arrow-circle-right"></i>
              </a> 
            </div>
          </div>
          <!-- ./col -->
          <!-- ./col -->
          <div class="col-lg-3 col-6">
            <!-- small card -->
            <div class="small-box bg-info">
              <div class="inner">
               <?php  
                  $place="user";
                  $selected = mysqli_query($conn,"SELECT count(Role) as user  FROm  user WHERE Role LIKE '%$place%'");
                  $sel = mysqli_fetch_array($selected); 
                  ?>
                <h3><?php echo $sel['user']; ?></h3>   
                <p>Labs Users</p>
              </div>
              <div class="icon">
                <i class="fas fa-users"></i>
              </div> 
                <a href="admin.php?page=donate" class="small-box-footer">
                <i class="fas fa-arrow-circle-right"></i>
              </a> 
            </div>
          </div>
          <!-- ./col -->
          
          <div class="col-lg-3 col-6">
            <!-- small card -->
            <div class="small-box bg-info">
              <div class="inner">
                <?php  
                  $place="CYBER/TR/";
                  $selected = mysqli_query($conn,"SELECT count(class_id) as comment  FROM class_soes");
                  $sel = mysqli_fetch_array($selected); 
                  ?>
                <h3><?php echo $sel['comment']; ?></h3> 
                <p>classes</p>
              </div>
              <div class="icon">
                <i class="fas fa-users"></i>
              </div>  
                <a href="admin.php?page=class" class="small-box-footer">
                 <i class="fas fa-arrow-circle-right"></i>
              </a> 
            </div>
          </div>   
        </div> 
       <div class="row">
          <div class="col-lg-3 col-6">
            <!-- small card -->
            <div class="small-box bg-primary">
              <div class="inner">
                <?php  
                  $place="Training";
                  $selected = mysqli_query($conn,"SELECT count(Role) as Training  FROm  user WHERE Role LIKE '%$place%'");
                  $sel = mysqli_fetch_array($selected); 
                  ?>
                <h3><?php echo $sel['Training']; ?></h3>  
                <p>Courses</p>
              </div>
              <div class="icon">
                <i class="fas fa-users"></i>
              </div>  
              <a href="admin.php?page=trainer" class="small-box-footer">
                <i class="fas fa-arrow-circle-right"></i>
              </a> 
            </div>
          </div>
          <!-- ./col -->
          <div class="col-lg-3 col-6">
            <!-- small card -->
            <div class="small-box bg-warning">
              <div class="inner"> 
                <?php  
                  $place="CYBER/Fc/";
                  $selected = mysqli_query($conn,"SELECT count(roll_number) as fac  FROm  user WHERE roll_number LIKE '%$place%'");
                  $sel = mysqli_fetch_array($selected); 
                  ?>
                <h3><?php echo $sel['fac']; ?></h3>  
                <p>Exams</p>
              </div>
              <div class="icon">
                <i class="fas fa-edit"></i>
              </div> 
              <a href="admin.php?page=facilitator" class="small-box-footer">
                info <i class="fas fa-arrow-circle-right"></i>
              </a> 
            </div>
          </div>
          <!-- ./col -->
          <!-- ./col -->
          <div class="col-lg-3 col-6">
            <!-- small card -->
            <div class="small-box bg-info">
              <div class="inner">
              <?php  
                  $place="CYBER/TR/";
                  $selected = mysqli_query($conn,"SELECT count(ID) as donate  FROm  donate");
                  $sel = mysqli_fetch_array($selected); 
                  ?>
                <h3><?php echo $sel['donate']; ?></h3>   
                <p>Quizes</p>
              </div>
              <div class="icon">
                <i class="fas fa-users"></i>
              </div> 
                <a href="admin.php?page=donate" class="small-box-footer">
                 <i class="fas fa-arrow-circle-right"></i>
              </a> 
            </div>
          </div>
          <!-- ./col -->
          
          <div class="col-lg-3 col-6">
            <!-- small card -->
            <div class="small-box bg-secondary">
              <div class="inner">
                <?php  
                  $place="CYBER/TR/";
                  $selected = mysqli_query($conn,"SELECT COUNT(exam_id) as Total 
                  FROM exam_soes 
                  WHERE exam_result_datetime IS NOT NULL");
                  $sel = mysqli_fetch_array($selected); 
                  ?>
                <h3><?php echo $sel['Total']; ?></h3> 
                <p>Today's Results</p>
              </div>
              <div class="icon">
                <i class="fas fa-users"></i>
              </div>  
                <a href="admin.php?page=email" class="small-box-footer">
                <i class="fas fa-arrow-circle-right"></i>
              </a> 
            </div>
          </div>   
        </div>
        
    </section> 
     <a id="back-to-top" href="#" class="btn btn-primary back-to-top" role="button" aria-label="Scroll to top">
      <i class="fas fa-chevron-up"></i>
    </a>
  </div> 
<script src="../stp_con/jquery/jquery.min.js"></script> 
<script src="../stp_con/bootstrap/js/bootstrap.bundle.min.js"></script> 
<script src="../stp_con/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script> 
<script src="../assets/js/adminlte.min.js"></script>   
<script src="../stp_con/opace-progress/pace.min.js"></script>
</body>
</html> 
 