<?php
session_start() ;
require_once 'include/dbcon.php';
$regno = $_SESSION['rgno'] ;
$classid = $_SESSION["classid"] ;
$lvs =  $_SESSION["classid"] ;
  $lv = substr("$lvs",0,2);
$sql = $DBcon->prepare("select * from students where regno =:reg") ;
$sql->bindparam(":reg",$regno) ;
$sql->execute() ;
if($sql->rowcount() > 0)
{
	$row = $sql->FETCH(PDO::FETCH_ASSOC) ;
	$fnames = $row['surname'] ;
		$mnames = $row['middlename'] ;
			$lnames = $row['lastname'] ;
				$names = $fnames.'&nbsp;'.$mnames.'&nbsp;'.$lnames ;
	$gender = $row['gender'] ;
	$imgs = $row['avatar'] ;
}

if(isset($_POST['first']))
{
$msg = array() ;
$pin = $_SESSION['pin'] ;
$regno = $_SESSION['rgno'] ;
$_SESSION["schsesion"] = trim($_POST['yr']);
$_SESSION["term"] = 'FIRST TERM' ;
$classid = $_SESSION["classid"] ;
$lvs = $_SESSION["lvs"] ;
//mysql_select_db("$database", $conn);
$schyear = $_SESSION["schsesion"] ;
$classid = $_SESSION["classid"] ;
$term = $_SESSION["term"] ;
//$level = substr($classid, 0, 7);
//$level1 = substr($classid, 0, 2);
//check pin validity

$sql1 = $DBcon->prepare("select * from pinassociate where PINCODE =:p") ;
$sql1->bindparam(':p', $pin) ;
$sql1->execute() ;
$rc = $sql1->rowcount() ;

if($rc > 0)
 
{
	
$row1 = $sql1->FETCH(PDO::FETCH_ASSOC) ;
 $pin = $row1['PINCODE'] ;
 $owner = $row1['REGNO'] ;
 $numbused = $row1['NOUSED'] ;
 $tm = $row1['TERM'] ;
 $yr = $row1['acadsession'] ;
   //check reg no
if($numbused >= 5) $msg[] = 'You have used this Pin above its Limit please buy another Card' ;
if($term != $tm)  $msg[] = 'You have used this Pin to Check another Term Result, Please Get another Card' ;
if($yr != $schyear) $msg[] = 'You have used this Pin to Check another Session Result, Please Get another Card' ;
  }// end if access, i.e, if pin exist
  if(empty($msg))
{

$sqlc = $DBcon->prepare(" select * from marks where (stregno =:rg and acad_session =:yr) and (term =:tm and stclass = :cs)") ;
$sqlc->bindparam(':rg', $regno) ;
$sqlc->bindparam(':yr', $schyear) ;
$sqlc->bindparam(':tm', $term) ;
$sqlc->bindparam(':cs', $classid) ;
$sqlc->execute() ;
$rcx = $sqlc->rowcount() ;
//$resultc = mysql_query($sqlc) or die('Error: ' . mysql_error());
if($rcx > 0) 
{
  $rowc = $sqlc->FETCH(PDO::FETCH_ASSOC) ;
  $resultnoc = $rowc['stregno'] ;
  $_SESSION["getresultc"] = $resultnoc ;
 }
else
$msg[] = 'Sorry, Your Result is not Ready or Make Sure you entered correct Information' ; 
}
 if(empty($msg)) 
 {
	 if($lv == 'JS')header("location: resultsheet/basicsheet.php");
	if($lv == 'SS') header("location: resultsheet/basicsheet.php");
	 //else header("location: resultsheet/basicsheet.php");
	 
 }
 	
}


if(isset($_POST['second']))
{
$msg = array() ;
$pin = $_SESSION['pin'] ;
$regno = $_SESSION['rgno'] ;
$_SESSION["schsesion"] = trim($_POST['yr']);
$_SESSION["term"] = 'SECOND TERM' ;
$classid = $_SESSION["classid"] ;
$lvs = $_SESSION["lvs"] ;
//mysql_select_db("$database", $conn);
$schyear = $_SESSION["schsesion"] ;
$classid = $_SESSION["classid"] ;
$term = $_SESSION["term"] ;
//$level = substr($classid, 0, 7);
//$level1 = substr($classid, 0, 2);
//check pin validity

$sql1 = $DBcon->prepare("select * from pinassociate where PINCODE =:p") ;
$sql1->bindparam(':p', $pin) ;
$sql1->execute() ;
$rc = $sql1->rowcount() ;

if($rc > 0)
 
{
	
$row1 = $sql1->FETCH(PDO::FETCH_ASSOC) ;
 $pin = $row1['PINCODE'] ;
 $owner = $row1['REGNO'] ;
 $numbused = $row1['NOUSED'] ;
 $tm = $row1['TERM'] ;
 $yr = $row1['acadsession'] ;
   //check reg no
if($numbused >= 5) $msg[] = 'You have used this Pin above its Limit please buy another Card' ;
if($term != $tm)  $msg[] = 'You have used this Pin to Check another Term Result, Please Get another Card' ;
if($yr != $schyear) $msg[] = 'You have used this Pin to Check another Session Result, Please Get another Card' ;
  }// end if access, i.e, if pin exist
  if(empty($msg))
{

$sqlc = $DBcon->prepare(" select * from marks where (stregno =:rg and acad_session =:yr) and (term =:tm and stclass = :cs)") ;
$sqlc->bindparam(':rg', $regno) ;
$sqlc->bindparam(':yr', $schyear) ;
$sqlc->bindparam(':tm', $term) ;
$sqlc->bindparam(':cs', $classid) ;
$sqlc->execute() ;
$rcx = $sqlc->rowcount() ;
//$resultc = mysql_query($sqlc) or die('Error: ' . mysql_error());
if($rcx > 0) 
{
  $rowc = $sqlc->FETCH(PDO::FETCH_ASSOC) ;
  $resultnoc = $rowc['stregno'] ;
  $_SESSION["getresultc"] = $resultnoc ;
 }
else

$msg[] = 'Sorry, Your Result is not Ready or Make Sure you entered correct Information' ; 
}
 
 if(empty($msg)) 
 {
	 if($lv == 'JS')header("location: resultsheet/basicsheet.php");
	if($lv == 'SS') header("location: resultsheet/basicsheet.php");
	 //else header("location: resultsheet/basicsheet.php");
 }
 		
}

if(isset($_POST['third']))
{
$msg = array() ;
$pin = $_SESSION['pin'] ;
$regno = $_SESSION['rgno'] ;
$_SESSION["schsesion"] = trim($_POST['yr']);
$_SESSION["term"] = 'THIRD TERM' ;
$classid = $_SESSION["classid"] ;
//mysql_select_db("$database", $conn);
$schyear = $_SESSION["schsesion"] ;
$classid = $_SESSION["classid"] ;
$term = $_SESSION["term"] ;
$lvs = $_SESSION["lvs"] ;
//$level = substr($classid, 0, 7);
//$level1 = substr($classid, 0, 2);
//check pin validity

$sql1 = $DBcon->prepare("select * from pinassociate where PINCODE =:p") ;
$sql1->bindparam(':p', $pin) ;
$sql1->execute() ;
$rc = $sql1->rowcount() ;

if($rc > 0)
 
{
	
$row1 = $sql1->FETCH(PDO::FETCH_ASSOC) ;
 $pin = $row1['PINCODE'] ;
 $owner = $row1['REGNO'] ;
 $numbused = $row1['NOUSED'] ;
 $tm = $row1['TERM'] ;
 $yr = $row1['acadsession'] ;
   //check reg no
if($numbused >= 5) $msg[] = 'You have used this Pin above its Limit please buy another Card' ;
//if($term != $tm)  $msg[] = 'You have used this Pin to Check another Term Result, Please Get another Card' ;
if($yr != $schyear) $msg[] = 'You have used this Pin to Check another Session Result, Please Get another Card' ;
  }// end if access, i.e, if pin exist
  if(empty($msg))
{

$sqlc = $DBcon->prepare(" select * from marks where (stregno =:rg and acad_session =:yr) and (term =:tm and stclass = :cs)") ;
$sqlc->bindparam(':rg', $regno) ;
$sqlc->bindparam(':yr', $schyear) ;
$sqlc->bindparam(':tm', $term) ;
$sqlc->bindparam(':cs', $classid) ;
$sqlc->execute() ;
$rcx = $sqlc->rowcount() ;
//$resultc = mysql_query($sqlc) or die('Error: ' . mysql_error());
if($rcx > 0) 
{
  $rowc = $sqlc->FETCH(PDO::FETCH_ASSOC) ;
  $resultnoc = $rowc['stregno'] ;
  $_SESSION["getresultc"] = $resultnoc ;
 }
else
$msg[] = 'Sorry, Your Result is not Ready or Make Sure you entered correct Information' ; 
}
 
 if(empty($msg)) 
 {
	  if($lv == 'JS')header("location: resultsheet/basicsheet.php");
	if($lv == 'SS') header("location: resultsheet/basicsheet.php");
	 //else header("location: resultsheet/basicsheet.php");
	 
 }
 		
}

// check annual
if(isset($_POST['annual']))
{
	$msg = array() ;
$pin = $_SESSION['pin'] ;
$regno = $_SESSION['rgno'] ;
$_SESSION["schsesion"] = trim($_POST['yr']);
$_SESSION["term"] = 'ANNUAL TERM' ;
$classid = $_SESSION["classid"] ;
//mysql_select_db("$database", $conn);
$schyear = $_SESSION["schsesion"] ;
//$classid = $_SESSION["classid"] ;
//$term = $_SESSION["term"] ;
$lvs = $_SESSION["lvs"] ;

$sqlc = $DBcon->prepare(" select * from marks where (stregno =:rg and acad_session =:yr) and (stclass = :cs and term = 'THIRD TERM' )") ;
$sqlc->bindparam(':rg', $regno) ;
$sqlc->bindparam(':yr', $schyear) ;
//$sqlc->bindparam(':tm', $term) ;
$sqlc->bindparam(':cs', $classid) ;
$sqlc->execute() ;
$rcx = $sqlc->rowcount() ;
//$resultc = mysql_query($sqlc) or die('Error: ' . mysql_error());
if($rcx > 0) 
{
  $rowc = $sqlc->FETCH(PDO::FETCH_ASSOC) ;
  $resultnoc = $rowc['stregno'] ;
  $_SESSION["getresultcm"] = $resultnoc ;
 }
else
$msg[] = 'Sorry Your 3rd Term  Result is not ready, you can view Cumulative Now, check back next week' ;

//check pin
$sql1 = $DBcon->prepare("select * from pinassociate where PINCODE =:p") ;
$sql1->bindparam(':p', $pin) ;
$sql1->execute() ;
$rc = $sql1->rowcount() ;

if($rc > 0)
 
{
	
$row1 = $sql1->FETCH(PDO::FETCH_ASSOC) ;
 $pin = $row1['PINCODE'] ;
 $owner = $row1['REGNO'] ;
 $numbused = $row1['NOUSED'] ;
// $tm = $row1['TERM'] ;
 $yr = $row1['acadsession'] ;
   //check reg no
if($numbused >= 5) $msg[] = 'You have used this Pin above its Limit please buy another Card' ;
//if($term != $tm)  $msg[] = 'You have used this Pin to Check another Term Result, Please Get another Card' ;
if($yr != $schyear) $msg[] = 'You have used this Pin to Check another Session Result, Please Get another Card' ;
  }// end if access, i.e, if pin exist

if(empty($msg)) 
 {
	 //if($lvs == 'PRIMARY') header("location: resultsheet/pcheader.php");
	 //else
	 header("location: resultsheet/pjsheet.php");
	 
 }
	
}

?>
<!DOCTYPE html>
<html dir="ltr" lang="en">

<!-- index-mp-layout102:13-->
<head>

<!-- Meta Tags -->
<meta name="viewport" content="width=device-width,initial-scale=1.0"/>
<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
<meta name="description" content="Dr Alutu College" />
<meta name="keywords" content="academy, course, education, education, learning," />


<!-- Page Title -->
<title>Dr Alutu College</title>

<!-- Favicon and Touch Icons -->
<link href="images/favicon.png" rel="shortcut icon" type="image/png">
<link href="images/apple-touch-icon.png" rel="apple-touch-icon">
<link href="images/apple-touch-icon-72x72.png" rel="apple-touch-icon" sizes="72x72">
<link href="images/apple-touch-icon-114x114.png" rel="apple-touch-icon" sizes="114x114">
<link href="images/apple-touch-icon-144x144.png" rel="apple-touch-icon" sizes="144x144">

<!-- Stylesheet -->
<link href="css/bootstrap.min.css" rel="stylesheet" type="text/css">
<link href="css/jquery-ui.min.css" rel="stylesheet" type="text/css">
<link href="css/animate.css" rel="stylesheet" type="text/css">
<link href="css/css-plugin-collections.css" rel="stylesheet"/>
<!-- CSS | menuzord megamenu skins -->
<link id="menuzord-menu-skins" href="css/menuzord-skins/menuzord-rounded-boxed.css" rel="stylesheet"/>
<!-- CSS | Main style file -->
<link href="css/style-main.css" rel="stylesheet" type="text/css">
<!-- CSS | Preloader Styles -->
<link href="css/preloader.css" rel="stylesheet" type="text/css">
<!-- CSS | Custom Margin Padding Collection -->
<link href="css/custom-bootstrap-margin-padding.css" rel="stylesheet" type="text/css">
<!-- CSS | Responsive media queries -->
<link href="css/responsive.css" rel="stylesheet" type="text/css">
<!-- CSS | Style css. This is the file where you can place your own custom css code. Just uncomment it and use it. -->
<!-- <link href="css/style.css" rel="stylesheet" type="text/css"> -->

<!-- Revolution Slider 5.x CSS settings -->
<link  href="js/revolution-slider/css/settings.css" rel="stylesheet" type="text/css"/>
<link  href="js/revolution-slider/css/layers.css" rel="stylesheet" type="text/css"/>
<link  href="js/revolution-slider/css/navigation.css" rel="stylesheet" type="text/css"/>

<!-- CSS | Theme Color -->
<link href="css/colors/theme-skin-color-set-1.css" rel="stylesheet" type="text/css">

<!-- external javascripts -->
<script src="js/jquery-2.2.4.min.js"></script>
<script src="js/jquery-ui.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<!-- JS | jquery plugin collection for this theme -->
<script src="js/jquery-plugin-collection.js"></script>

<!-- Revolution Slider 5.x SCRIPTS -->
<script src="js/revolution-slider/js/jquery.themepunch.tools.min.js"></script>
<script src="js/revolution-slider/js/jquery.themepunch.revolution.min.js"></script>

<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
  <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
  <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body class="">
<div id="wrapper" class="clearfix">
  <!-- preloader -->
  <div id="preloader">
    <div id="spinner">
      <img alt="" src="images/preloaders/5.gif">
    </div>
    <div id="disable-preloader" class="btn btn-default btn-sm">Disable Preloader</div>
  </div>
  <?php include('header.php') ; ?>
 <!-- Start main-content -->
  <div class="main-content">
   <!-- Section: home -->
        <section class="inner-header divider parallax layer-overlay overlay-dark-5" data-bg-img="images/bg/bg6.jpg">
      <div class="container pt-70 pb-20">
        <!-- Section Content -->
        <div class="section-content">
          <div class="row">
            <div class="col-md-12">
              <h2 class="title text-white text-center">Profile Page</h2>
              <ol class="breadcrumb text-left text-black mt-10">
                <li><a href="#">Home</a></li>
             <li class="active text-gray-silver">Profile Page</li>
              </ol>
            </div>
          </div>
        </div>
      </div>
    </section>
    <br/> <br/>
    <div class="container">
    <div class="row">
    <div class="col-md-4">
    <div class="alert alert-success">
    <center> 
    <p style="font-size:16px;">
    <h3>Personal Profile</h3>
    <label><strong>STUDENT NAME</strong></label>
    <br/> <br/>
    <?php if(isset($names)) echo $names ; ?>
    <br/> <br/>
    <label><strong>REG NUMBER</strong></label> <br/> <br/>
    <?php if(isset($regno)) echo $regno ; ?>
     <br/> <br/>
      <?php  echo $lv ; ?>
       <br/> <br/>
      <?php  echo $classid; ?>
     </p>
    </center>
    </div>
    </div>
    <div class="col-md-4">
    <div class="alert alert-warning">
    <center> 
    <h3>Personal Profile</h3>
    <img src="student.png" width="60%" height="200px" />
    <br/><br/>
    <input type="submit" value="UPDATE PICTURE" class="btn btn-dark" />
    </center>
    </div>
    </div>
    <div class="col-md-4">
    <div class="alert alert-danger">
    <h3>View and Print Result</h3>
        <p>
        <form name="form"  method="post" action="" >
        <center>
        
        <?php
if (isset($msg)) {
  echo '<ul>';
  foreach ($msg as $item)
   {
    echo "<li>$item</li>";
	}
  echo '</ul>';
  }

?>
<br/>
        Select Academic Year<br/>
          <select name="yr" required class="form-control"  >
          <option> </option>
           <option>2015/2018 </option>
          <option>2016/2017</option>
        <option>2017/2018</option>
        <option>2018/2019</option>
        <option>2019/2020</option>
        <option>2020/2021</option>
        <option>2021/2022</option>
        <option>2022/2023</option>
        <option>2023/2024</option>
        <option>2024/2025</option>
           <option>2025/2026</option>
             <option>2026/2027</option>
          </select><br/><br/>
          
          <input type="submit" name="first" style="width:90%" class=" btn btn-danger"  value="FIRST TERM" /><br/><br/>
          
          <input type="submit" name="second" style="width:90%" class=" btn btn-primary"  value="SECOND TERM" /><br/><br/>
          <input type="submit" name="third" style="width:90%" class=" btn btn-success"  value="THIRD TERM" /><br/><br/>
           <input type="submit" name="annual" style="width:90%" class=" btn btn-dark"  value="CUMULATIVE" /><br/><br/>
           </center>
          </form>
        
        </p>
    </div>
    </div>
    </div>
    </div>
    
  </div>
 <?php include('footer.php') ; ?>
  <a class="scrollToTop" href="#"><i class="fa fa-angle-up"></i></a> 
  </div>
  <!-- Footer Scripts --> 
<!-- JS | Custom script for all pages --> 
<script src="js/custom.js"></script>
</body>
</html>