<?php ob_start();
session_start();
include("header.php"); 
	
	if($_SESSION["uid"]=="")
	{
		header('location:login.php');

    exit();
		
	}	?>
<link type="text/css" rel="stylesheet" href="css/sb-admin.css">
<style>
td{border:1px solid;}
</style>
<section class="header_back_inner"></section>
<input type="hidden" id="cbt_id" value="<?= $cbt_id?>">

	<div align="center" class="inner-mid-section">
	 <div class="container">
	<h2 class="demoHeaders"><span>TEST REPORT FORMAT (CBT)</span></h2>
		<?php 
		$user_id=$_SESSION['uid'];
		$cbt_id=$_GET['cbt_id'];
		$results=mysql_query("SELECT s1.subject as subject1, s2.subject as subject2, s3.subject as subject3, s4.subject as subject4, cbt.*  from `cbt_results` cbt join `exam_subject_master` s1 on cbt.sub1=s1.id join `exam_subject_master` s2 on cbt.sub2=s2.id join `exam_subject_master` s3 on cbt.sub3=s3.id join `exam_subject_master` s4 on cbt.sub4=s4.id where `cbt`.`u_id`=".$user_id." and `cbt`.`id`=".$cbt_id." ORDER BY cbt.date DESC");

?>
<?php 
$row_result=mysql_fetch_array(mysql_query("SELECT * FROM `cbt_results` WHERE id='".$cbt_id."'"));
$subject_result=mysql_fetch_array(mysql_query("SELECT * FROM `exam_subject_master` WHERE id='".$row_result['subject_id']."'"));
?>
        <div class="test_report_section">
        
        	<div class="test_date">
				<?php while($result = mysql_fetch_array($results)){	
					//print_r($result);
					 $p1=round($result["res1"]/$result["noq1"]*100,2);
					 $p2=round($result["res2"]/$result["noq2"]*100,2);
					 $p3=round($result["res3"]/$result["noq3"]*100,2);
					 $p4=round($result["res4"]/$result["noq4"]*100,2);
					 $cbt_id = $result['id'];
					 $tot=round(($p1+p2+$p3+$p4)/4,2);
				echo '<p>Test Date: <span>'.date('d-m-Y', strtotime($result["date"])).'  '.date('h:m A', strtotime($result["date"])).'</span></p>			
				<p>Subject: <span>'.$result["subject1"].','.$result["subject2"].','.$result["subject3"].','.$result["subject4"].'</span></p>			
					<p>Score: <span>'.$tot.'%'.'</span></p>'; 
					
            }?>			
            </div>
			 <div class="report_analyse_sec">
            
            	<h2>Topic Analysis: <span>this comprises of all the topics the questions in the papers belong to (% correct).</span></h2>
                
                <div class="topic_analyse_box">
                
                	<ul>
			<?php
					$result_sql=mysql_query("select * from cbt_result_details where cbt_id=".$cbt_id."");
					while($results=mysql_fetch_array($result_sql)) 
					{						
					     $topic_res=mysql_query("SELECT * FROM `exam_question_answers_reasons` WHERE `id`='".$results['q_id']."' AND `correct_ans`='".$results['ans']."'");
						
					$s=mysql_num_rows($topic_res);
					while($topic_results=mysql_fetch_array($topic_res)) 
					{	
				     $topic_results['topic_id'];
					 $topic_name=mysql_fetch_array(mysql_query("SELECT * FROM `exam_topic` WHERE `id`='".$topic_results['topic_id']."'"));
					?>
					
					<?php
					if($topic_name['name']!="")
					{	
					?>
					
					<li><?=$topic_name['name']?>=<?=($s/$row_result['no_questions'])*100?>%</li>
					<?php
					}else
					{						
					?>
					N/A
                    <?php
					}
					}
                   }
                  ?>
				   
                    </ul>
                
                </div>
				    <div class="clear"></div>
				</div> 
			
			
            <h3>We recommend extra studies on these subtopics</h3>
            
            <!--<div class="report_subject_section">
			<?php $results=mysql_query("SELECT s1.subject as subject1, s2.subject as subject2, s3.subject as subject3, s4.subject as subject4, cbt.*  from `cbt_results` cbt join `exam_subject_master` s1 on cbt.sub1=s1.id join `exam_subject_master` s2 on cbt.sub2=s2.id join `exam_subject_master` s3 on cbt.sub3=s3.id join `exam_subject_master` s4 on cbt.sub4=s4.id where `cbt`.`u_id`=".$user_id." and `cbt`.`id`=".$cbt_id." ORDER BY cbt.date DESC");?>
            <?php while($result = mysql_fetch_array($results)){	
					//print_r($result);
					 $p1=round($result["res1"]/$result["noq1"]*100,2);
					 $p2=round($result["res2"]/$result["noq2"]*100,2);
					 $p3=round($result["res3"]/$result["noq3"]*100,2);
					 $p4=round($result["res4"]/$result["noq4"]*100,2);
					 echo '<h4>'.$result["subject1"].'&nbsp;'.$p1.'%</h4><h4>'.$result["subject2"].'&nbsp;'.$p2.'%</h4><h4>'.$result["subject3"].'&nbsp;'.$p3.'%</h4><h4>'.$result["subject4"].'&nbsp;'.$p4.'%</h4>';
			} ?>
            </div>-->
			 <div class="report_subject_section">
				<!--<h4>Sub Topics</h4>-->
			    <ul>
            <?php $test1=mysql_query("select * from cbt_result_details where cbt_id=".$cbt_id."");
					while($test=mysql_fetch_array($test1)) 
					{		
						 //print_r($test);
					     $sub_topics=mysql_query("SELECT * FROM `exam_question_answers_reasons` WHERE `id`='".$test['q_id']."' AND `correct_ans`!='".$test['ans']."'"); 
					$s=mysql_num_rows($sub_topics);
					while($sub_topic=mysql_fetch_array($sub_topics)) 
					{	
				     
					 $sub_topic_name=mysql_fetch_array(mysql_query("SELECT * FROM `exam_sub_topic` WHERE `id`='".$sub_topic['sub_topic_id']."'"));
					//print_r($sub_topic_name);
					?>
					<li><?php echo $sub_topic_name['name']; ?>=<?=($s/$row_result['no_questions'])*100?>%</li>
					<?php 
					}
					}					
			?>
				</ul>
			</div>
            
            <div class="clear"></div>
            
            <div class="recommend_box_sec">
            
            	<h4>Recommended Textbooks as recommended by JAMB</h4>
                
                <ul>
                 <?php $book_results = mysql_query("select * from exam_subject_master"); 
					   while($book_result = mysql_fetch_array($book_results)){
						  // print_r($book_result);
						   if($book_result['recommended_textbooks']!=""){
							echo '<li>'.$book_result['subject'].'
									<ul>
										<li>'.$book_result['recommended_textbooks'].'</li>
									</ul>
								</li>';
						}
					   }
				 ?>
                </ul>
            
            </div>
        
        </div>
    
	</div>     
	<div class="clear"></div>
	
    </div>
	<?php include("footer.php"); ?>