<?php
	require_once('source/session.php');
	require_once('source/error.php');
	require_once('source/dbconfig.php');
	require_once('source/function.php');
	require_once('source/restrict_user.php');
	
	
	if($_GET['msg'] == "refered"){
		$msg = "<h5 class='alert alert-success'>Refered successfully</h5>";
	}else if($_GET['msg'] == "failed"){
		$msg = "<h5 class='alert alert-warning'>Something went wrong, please try again</h5>";
	}
?>

<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <meta name="description" content="">
  <meta name="author" content="">
  <title>BRITISH LEARNERS COLLEGE, OWERRI, IMO STATE: TAECHER DASHBOARD</title>
  <!-- Bootstrap core CSS-->
  <link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
  <!-- Custom fonts for this template-->
  <link href="vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
  <!-- Page level plugin CSS-->
  <link href="vendor/datatables/dataTables.bootstrap4.css" rel="stylesheet">
  <!-- Custom styles for this template-->
  <link href="css/sb-admin.css" rel="stylesheet">
  <link href="css/folder.css" rel="stylesheet">
  <link href="css/user_profile.css" rel="stylesheet">
  
  <!-- select-->
  <link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
  <style type="text/css">
  .GG1 {
	color: #09F;
}
  .style1 {color: #FFFFFF}
  </style>
</head>

<body class="fixed-nav sticky-footer bg-dark" id="page-top">
  <!-- Navigation-->
  <nav class="navbar navbar-expand-lg navbar-dark bg-dark fixed-top" id="mainNav">
<h4 style='color: LIME'><b>BRITISH LEARNERS COLLEGE, OWERRI, IMO STATE: TEACHER DASHBOARD </b></h4>  
<?php
            	
            	$rows = sql($DBH, "SELECT * FROM tbl_admin where status = ?", 
            	array("Active"), "rows");							
            	foreach($rows as $row)
            	{
            		$admin_name 		= $row['username'];
            	}
		
      if (isset($_SESSION['SESS_HASH_ADMIN'])) {
		$user_true 			 = "<h4 style='color: yellow'><!--<b>SCORE SHEET--></b></h4>";
		
}
		echo "$user_true ";
?>
    <button class="navbar-toggler navbar-toggler-right" type="button" data-toggle="collapse" data-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false" aria-label="Toggle navigation">
      <span class="navbar-toggler-icon"></span>
    </button>
     <div class="collapse navbar-collapse" id="navbarResponsive">
<ul class="navbar-nav navbar-sidenav" id="exampleAccordion">
  <li class="nav-item" data-toggle="tooltip" data-placement="right" title="Dashboard">
    <a class="nav-link" href="main.php">
      <i class="fa fa-dashboard" style="color: #3498db"></i>
      <span class="nav-link-text" style="color: white">Teacher Dashboard</span>
    </a>
  </li>
  <!--<li class="nav-item" data-toggle="tooltip" data-placement="right" title="Generate Score Sheet">
    <a class="nav-link" href="students.php">
      <i class="fa fa-clock-o" style="color: #3498db"></i>
      <span class="nav-link-text" style="color: white">Generate Score Sheet</span>
    </a>
  </li> -->
  <li class="nav-item" data-toggle="tooltip" data-placement="right" title="Download Broadsheet">
    <a class="nav-link" href="download_broadsheet.php">
      <i class="fa fa-download" style="color: blue"></i>
      <span class="nav-link-text" style="color: white">Download Broadsheet</span>
    </a>
  </li>
  <!--<li class="nav-item" data-toggle="tooltip" data-placement="right" title="Fill Attendance Sheet">
    <a class="nav-link" href="fill_attendance_sheet.php">
      <i class="fa fa-download" style="color: red"></i>
      <span class="nav-link-text" style="color: white">Download Specimen Excel Sheets</span>
    </a>
  </li> -->
  <li class="nav-item" data-toggle="tooltip" data-placement="right" title="Upload Tests (CA 1, C.A.2, EXAM)">
    <a class="nav-link" href="upload_ca1.php">
      <i class="fa fa-upload" style="color: orange"></i>
      <span class="nav-link-text" style="color: white">Upload Tests (CA 1, CA 2, EXAM)</span>
    </a>
  </li>
    <!--<li class="nav-item" data-toggle="tooltip" data-placement="right" title="Upload Tests (CA 2)">
    <a class="nav-link" href="upload_ca2.php">
      <i class="fa fa-upload" style="color: orange"></i>
      <span class="nav-link-text" style="color: white">Upload Tests (CA 2)</span>
    </a>
  </li>
    <li class="nav-item" data-toggle="tooltip" data-placement="right" title="Upload Tests (CA 3)">
    <a class="nav-link" href="upload_ca3.php">
      <i class="fa fa-upload" style="color: orange"></i>
      <span class="nav-link-text" style="color: white">Upload Tests (CA 3)</span>
    </a>
  
    <li class="nav-item" data-toggle="tooltip" data-placement="right" title="Upload Exams">
    <a class="nav-link" href="upload_exam.php">
      <i class="fa fa-upload" style="color: orange"></i>
      <span class="nav-link-text" style="color: white">Upload Exam Scores</span>
    </a></li>-->
  </li>
  <li class="nav-item" data-toggle="tooltip" data-placement="right" title="Fill Attendance Sheet">
    <a class="nav-link" href="upload_attendance.php">
      <i class="fa fa-upload" style="color: red"></i>
      <span class="nav-link-text" style="color: white">Upload Attendance Scores</span>
    </a>
  </li>
  <!--<li class="nav-item" data-toggle="tooltip" data-placement="right" title="Fill Attendance Sheet">
    <a class="nav-link" href="fill_attendance_sheet.php">
      <i class="fa fa-upload" style="color: red"></i>
      <span class="nav-link-text" style="color: white">Upload Exam Scores</span>
    </a>
  </li> -->
  <li class="nav-item" data-toggle="tooltip" data-placement="right" title="Upload Skills, Psychomotor, and others">
    <a class="nav-link" href="upload_skills.php">
      <i class="fa fa-upload" style="color: purple"></i>
      <span class="nav-link-text" style="color: white">Upload Skills, Psychomotor, and others</span>
    </a>
  </li>
  <li class="nav-item" data-toggle="tooltip" data-placement="right" title="Logout">
    <a class="nav-link" href="logout.php">
      <i class="fa fa-sign-out" style="color: #3498db"></i>
      <span class="nav-link-text" style="color: white">Logout</span>
    </a>
  </li>
</ul>
    </div>
  </nav>
  
  <div class="content-wrapper">
    <div class="container-fluid">
      <!-- Breadcrumbs-->
      <ol class="breadcrumb" style="background: ac39ac">
        <li class="breadcrumb-item">
          <a href="index.php" style="color: black; font-weight: bold">Teacher's Board</a>
          
        </li>
        <li class="breadcrumb-item active" style="color: black">Class Sudent/Pupil's Folder</li>
      </ol>
    <?php if(!empty($statusMsg)){
        echo '<div class="alert '.$statusMsgClass.'">'.$statusMsg.'</div>';
    } ?>
      <div class="row">
        <div class="col-lg-12">
          <!-- Example Bar Chart Card-->
      <ol class="breadcrumb"style="background: #bf40bf">
                                    
            <h4 style="color: white">Profile</h4>
                                    </ol>
            
            <br/><br/>
      <div class="row">
                
                <?php
                    //get records from database
                      
            	//AND status = ? "DONATED",
                $STH 			= $DBH->prepare("SELECT count(*) FROM tbl_student_results WHERE id >= ?");
            	$result 	   	= $STH->execute(array(1));
            	$count		  	= $STH->fetchColumn();
            	
            	if($count >= 1){
                           
		$rows = sql($DBH, "SELECT MIN(id) AS id, year FROM tbl_student_results  WHERE id >= ? GROUP BY year", 
            	array(1), "rows");
		foreach($rows as $row)
		{	
			$name	 		= $row['name'];
			$registration_no 		= $row['registration_no'];
			$test 			= $row['test'];
			$home_work 			= $row['home_work'];
			$project			= $row['project'];
			$exam			= $row['exam'];
			$t_total			= $row['total'];
			$t_grade			= $row['grade'];
			$position			= $row['position'];
			$t_subject			= $row['subject'];
			$t_class			= $row['class'];
			$t_year			= $row['year'];
			
		
			echo"
			
                    <div1><a href='students_term.php?id=$t_year' target='blank'>$t_year</a></div1>";
                    }
                    }else{
                    echo "
                    No Result(s) found.....";
                    }
                   
                    ?>
      </div>
    </div>
          </div>
    <!-- /.container-fluid-->
    <!-- /.content-wrapper-->
    <footer class="sticky-footer" style="background: GRAY">
      <div class="container">
        <div class="text-center"> <small><strong><span class="style2 style1">Copyright © 2023-2024 BRITISH LEARNERS COLLEGE, OWERRI, IMO STATE: All Rights Reserved!</span></strong></small> </div>
      </div>
    </footer>
    <!-- Scroll to Top Button-->
    <a class="scroll-to-top rounded" href="#page-top">
      <i class="fa fa-angle-up"></i>    </a>
    <!-- Logout Modal-->
    <div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
      <div class="modal-dialog" role="document">
        <div class="modal-content">
          <div class="modal-header">
            <h5 class="modal-title" id="exampleModalLabel">Ready to Leave?</h5>
            <button class="close" type="button" data-dismiss="modal" aria-label="Close">
              <span aria-hidden="true">×</span>            </button>
          </div>
          <div class="modal-body">Select "Logout" below if you are ready to end your current session.</div>
          <div class="modal-footer">
            <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
            <a class="btn btn-primary" href="Sign_in.php">Logout</a>          </div>
        </div>
      </div>
    </div>
    <!-- Bootstrap core JavaScript-->
    <script src="vendor/jquery/jquery.min.js"></script>
    <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
    <!-- Core plugin JavaScript-->
    <script src="vendor/jquery-easing/jquery.easing.min.js"></script>
    <!-- Page level plugin JavaScript-->
    <script src="vendor/chart.js/Chart.min.js"></script>
    <script src="vendor/datatables/jquery.dataTables.js"></script>
    <script src="vendor/datatables/dataTables.bootstrap4.js"></script>
    <!-- Custom scripts for all pages-->
    <script src="js/sb-admin.min.js"></script>
    <!-- Custom scripts for this page-->
    <script src="js/sb-admin-datatables.min.js"></script>
    <script src="js/sb-admin-charts.min.js"></script>
     
        <script>
			$(document).ready(function(e){
				$(".pass_mismatch").hide();
				$("#signup").submit(function(e){
					var p1 = $("input[name='password']").val();
					var p2 = $("input[name='password2']").val();
					
					$("input[name='password']").css("border","1px solid #cccccc");
					$("input[name='password2']").css("border","1px solid #cccccc");
					$(".pass_mismatch").hide();
						
					if(p1 != p2){
						$("input[name='password']").css("border","1px solid #f00");
						$("input[name='password2']").css("border","1px solid #f00");
						window.location.hash = '#signup';
						$(".pass_mismatch").slideDown();
						e.preventDefault();
					}
				});
				
			});
			
		</script>
  </div>
</body>
</html>
