<?php

session_start() ;
require_once 'include/dbcon.php';
$regno = $_SESSION['rgno'] ;
$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) ;
	$names = $row['studentname'] ;
	$gender = $row['gender'] ;
	$imgs = $row['avatar'] ;
}

if(isset($_POST['first']))
{
$msg = array() ;
$pin = $_SESSION['pin'] ;
$regno = $_SESSION['rgno'] ;
$_SESSION["schsesion"] = trim($_POST['schsession']);
$_SESSION["term"] = 'FIRST TERM' ;
$classid = $_SESSION["classid"] ;
//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 >= 15) $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))  header("location: resultsheet/basicsheet.php");
 	
}


if(isset($_POST['second']))
{
$msg = array() ;
$pin = $_SESSION['pin'] ;
$regno = $_SESSION['rgno'] ;
$_SESSION["schsesion"] = trim($_POST['schsession']);
$_SESSION["term"] = 'SECOND TERM' ;
$classid = $_SESSION["classid"] ;
//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 >= 15) $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))  header("location: resultsheet/basicsheet.php");
 		
}

if(isset($_POST['third']))
{
$msg = array() ;
$pin = $_SESSION['pin'] ;
$regno = $_SESSION['rgno'] ;
$_SESSION["schsesion"] = trim($_POST['schsession']);
$_SESSION["term"] = 'THIRD TERM' ;
$classid = $_SESSION["classid"] ;
//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 >= 15) $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))  header("location: resultsheet/basicsheet.php");
 		
}

// check annual
if(isset($_POST['annual']))
{
	$msg = array() ;
$pin = $_SESSION['pin'] ;
$regno = $_SESSION['rgno'] ;
$_SESSION["schsesion"] = trim($_POST['schsession']);
$_SESSION["term"] = 'ANNUAL TERM' ;
$classid = $_SESSION["classid"] ;
//mysql_select_db("$database", $conn);
$schyear = $_SESSION["schsesion"] ;
$classid = $_SESSION["classid"] ;
//$term = $_SESSION["term"] ;

$sqlc = $DBcon->prepare(" select * from marks where (stregno =:rg and acad_session =:yr) 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["getresultcm"] = $resultnoc ;
 }
else
$msg[] = 'Sorry Your Result is not ready, 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 >= 15) $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)) header("location: resultsheet/pjsheet.php");
	
}


if(isset($_POST['mock']))
{
$msg = array() ;
$pin = $_SESSION['pin'] ;
$regno = $_SESSION['rgno'] ;
$_SESSION["schsesion"] = trim($_POST['schsession']);
$_SESSION["term"] = 'MOCK' ;
$classid = $_SESSION["classid"] ;
//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 >= 15) $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))  header("location: resultsheet/mock.php");
 		
}

?>
<!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">
    <meta name="author" content="irstheme">

    <title> Result Portal </title>

     <!-- Icon fonts -->
    <link href="assets/css/themify-icons.css" rel="stylesheet">
    <link href="assets/css/flaticon.css" rel="stylesheet">

    <!-- Bootstrap core CSS -->
    <link href="assets/css/bootstrap.min.css" rel="stylesheet">

    <!-- Plugins for this template -->
    <link href="assets/css/animate.css" rel="stylesheet">
    <link href="assets/css/owl.carousel.css" rel="stylesheet">
    <link href="assets/css/owl.theme.css" rel="stylesheet">
    <link href="assets/css/slick.css" rel="stylesheet">
    <link href="assets/css/slick-theme.css" rel="stylesheet">
    <link href="assets/css/swiper.min.css" rel="stylesheet">
    <link href="assets/css/owl.transitions.css" rel="stylesheet">
    <link href="assets/css/odometer-theme-default.css" rel="stylesheet">
    <link href="assets/css/jquery.fancybox.css" rel="stylesheet">
    <link href="assets/css/style.css" rel="stylesheet">

    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->

</head>

<body>

    <!-- start page-wrapper -->
    <div class="page-wrapper">

        <!-- start preloader -->
        <div class="preloader">
            <div class="sk-folding-cube">
                <div class="sk-cube1 sk-cube"></div>
                <div class="sk-cube2 sk-cube"></div>
                <div class="sk-cube4 sk-cube"></div>
                <div class="sk-cube3 sk-cube"></div>
            </div>
        </div>
        <!-- end preloader -->
        <?php include("header.php") ; ?>
         <!-- start page-title -->
        <section class="page-title" style="background-image:url(assets/images/page-title.png);">
            <div class="container">
                <div class="row">
                    <div class="col col-xs-12" style="background-color:#000; height:50px; font-size:24px; color:#fff; padding-top:10px; border-radius:10px;" >
                        Result Dashboard
                    </div>
                </div> <!-- end row -->
            </div> <!-- end container -->
        </section>        
        <!-- end page-title -->

           <!-- start case-studies-section -->
        <section class="recent-blog-section section-padding" style="margin-top:0px; padding-top:10px;">
            <div class="container clearfix" style="margin-top:0px; padding-top:1px;">
                <div class="row clearfix" style="margin-top:0px; padding-top:1px;">
                
                  <div class="col col-md-5">
                 
                
                                <h3>Instruction</h3>
                                
                                   <p style="text-align:justify; font-family:Baskerville, 'Palatino Linotype', Palatino, 'Century Schoolbook L', 'Times New Roman', serif;" >
            To view results, simply select the academic year of the result you want to view and click the corresponding button to the term you want to view, click Cumulative button to view annual results.<br/>
                Note: Always make sure that the Reg number and name display under student detail section are yours before printing your result. If not logout and Login with correct data to make sure you do print some one else result.
            
                                   </p>
                       <div style="" >
        <h5 style="border-bottom: 1px dotted #31A7E3; padding-bottom: 5px">Student Details</h5>
        <p style="font-size:18px;">
       Your Name is:<br/><?php if(isset($names)) echo $names ; ?><br/>
        Your RegNo is:<br/><?php if(isset($regno)) echo $regno ; ?><br/>
        <?php //if(isset($gender)) echo $gender ; ?><br/>
       
       </p>
        
        
    </div>
                    </div>
                
                 <div class="col col-md-7" style="margin-top:0px;padding-top:1px;">
                        <div class="recent-cases-thumbs-outer" style="margin-top:0px;padding-top:1px;">
                            <h2><span class="theme_color">VIEW AND PRINT </span>RESULT</h2>
                            <div class="recent-case-thumb " >
                                <div class="content">
                                    <div class="post">
                                       <center>
        <div>        
       <?php
if (isset($msg)) {
  echo '<ul>';
  foreach ($msg as $item)
   {
    echo "<li>$item</li>";
	}
  echo '</ul>';
  }

?>
</div><br/>
 </center>                                      
                   <form action="" name="form" method="post">
          SELECT ACADEMIC YEAR<br/>
        <select class="art-button" name="schsession" style="width:70%; min-height:40px; font-size:16px; font-weight:bold; font-family:Baskerville, 'Palatino Linotype', Palatino, 'Century Schoolbook L', 'Times New Roman', serif;  border-radius:10px;" required >
       <option></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>
        </select><br/><br/>
             
             
        <input type="submit" name="first" value="FIRST TERM" class="art-button" style="width:70%; min-height:50px; font-size:16px; background-color:#D01114; font-weight:bold; font-family:Baskerville,'Palatino Linotype', Palatino, 'Century Schoolbook L', 'Times New Roman', serif; color:#FFFFFF;" /><br/><br/>
        <input type="submit" name="second" value="SECOND TERM"  class="art-button" style="width:70%; min-height:50px; background-color:#228A08; font-size:16px; color:#FFFFFF; font-weight:bold; font-family:Baskerville, 'Palatino Linotype', Palatino, 'Century Schoolbook L', 'Times New Roman', serif;" /><br/><br/>
        <input type="submit" name="third"  value="THIRD TERM" class="art-button" style="width:70%; min-height:50px; background-color:#1E1377; color:#FFFFFF; font-size:16px; font-weight:bold; font-family:Baskerville, 'Palatino Linotype', Palatino, 'Century Schoolbook L', 'Times New Roman', serif;" /><br/><br/>
        
        <input type="submit" name="mock"  value="MOCK EXAM" class="art-button" style="width:70%; min-height:50px; background-color:#1C3D06; font-size:16px; font-weight:bold; color:#FFFFFF; font-family:Baskerville, 'Palatino Linotype', Palatino, 'Century Schoolbook L', 'Times New Roman', serif;" /><br/><br/>
        
        <input type="submit" name="annual"  value="CUMULATIVE" class="art-button" style="width:70%; min-height:50px; background-color:#000; color:#FFFFFF; font-size:16px; font-weight:bold; font-family:Baskerville, 'Palatino Linotype', Palatino, 'Century Schoolbook L', 'Times New Roman', serif;" />
        </form>
                                            
                                       
                                    </div>
                                    
                                </div>
                                
                            </div>
                                                       
                        </div>
                    </div>
                                        
                
                </div>
            </div>
            <!-- end container -->
        </section>
         <!-- start cta-section-s2 -->
         <?php include("footer.php") ; ?>
        
        </div>
         <!-- All JavaScript files
    ================================================== -->
    <script src="assets/js/jquery.min.js"></script>
    <script src="assets/js/bootstrap.min.js"></script>

    <!-- Plugins for this template -->
    <script src="assets/js/jquery-plugin-collection.js"></script>

    <!-- Custom script for this template -->
    <script src="assets/js/script.js"></script>
</body>
</html>