<?php
include_once('header.php');

$getClass = $wpdb->get_results("select distinct(r.class_id), c.class_name from `wp_psy_ability_raw_score` as r INNER JOIN `wp_psy_ability_class` as c ON c.class_id=r.class_id order by c.class_id");

if(isset($_REQUEST["submit"])){
	unset($_SESSION['CLASS_ID']);
	$classId = $_REQUEST['class_name'];
	$_SESSION['CLASS_ID'] = $classId;
}
if($_SESSION['CLASS_ID']!=''){
	$classId = $_SESSION['CLASS_ID'];
	$getScoreQuery = "select r.ability_id, a.short_name, r.sten_score, r.raw_score_start, r.raw_score_end from `wp_psy_ability_raw_score` as r LEFT JOIN `wp_psy_ability` as a ON a.ability_id=r.ability_id where r.class_id='$classId' and a.status='1' order by r.ability_id, r.sten_score";
	$getScoreData = $wpdb->get_results($getScoreQuery);
}

?>

<style>
.modal-backdrop {
    z-index: 999!important;
}
table.dataTable.nowrap th, table.dataTable.nowrap td {
    white-space: nowrap !important;
}
.page-title{
	float: left;
    width: 100%;
}

</style>
<div class="page-inner">
    <div class="page-title">
		<div class="col-md-4">
			<h3>Psychometric Aptitude Test</h3>
			<div class="page-breadcrumb">
				<ol class="breadcrumb">
					<li><a href="dashboard">Home</a></li>
					<li class="active">Ability Raw/STEN Scores</li>
				</ol>
			</div>
		</div>
		<div class="col-md-8">
			<div class="navbar-right">
				<ul class="navul">
					<li><a href="apt-class">Class List</a></li>
					<li><a href="apt-ability">Ability List</a></li>
					<li><a href="apt-sten-desc">Ability STEN Scores</a></li>
					<li><a href="apt-sten-raw-score">Ability Raw/STEN Scores</a></li>
				</ul>	
			</div>
		</div>
    </div>
	
    <div id="main-wrapper">

        <div class="col-md-12" style="padding:0;">
            <div class="panel panel-white">
                    <div class="panel-body">
                        <div class="search p bg-light m-b-sm">
                            <form method="POST" data-default="150">
                                <div class="input-group">
                                   
									<select name="class_name" class="form-control input-search">
										<option value="">--Select Class--</option>
										<?php foreach($getClass as $cls){ ?>
										<option value="<?php echo $cls->class_id; ?>" <?php if($_SESSION['CLASS_ID']==$cls->class_id) echo "selected"; ?>><?php echo $cls->class_name; ?></option>
										<?php } ?>
									</select>
                                    <span class="input-group-btn">
                                    <button class="btn btn-success" type="submit" name="submit"><i class="fa fa-search"></i></button>
                                    </span>
                                </div><!-- Input Group -->
                            </form><!-- Search Form -->
                        </div>
					</div>
				</div>
			</div> 
			<div class="col-md-12" style="padding:0;">
				<div class="panel panel-info">
					<div class="panel-heading clearfix">
                        <h4 class="panel-title">STEN and Raw Score description</h4>
                    </div>
                    <div class="panel-body">
					<?php
//echo "<pre>".print_r($getScoreData, true)."</pre>";
//echo "<br>--<br>";

					?>
					</div>
				</div>
			</div>
    </div><!-- Main Wrapper -->


    <div class="page-footer">
        <p class="no-s">shinemetrics.com</p>
    </div>
</div><!-- Page Inner -->


<script type="text/javascript" charset="utf-8">
	jQuery.noConflict();
	function submitAprForm(){
		if(document.getElementById("descr").value==''){
			alert("Description can not empty");
			document.getElementById("descr").focus();
			event.preventDefault();
			return false;
		}
	}
</script>
<link href="assets/css/jquery.dataTables.min.css" rel="stylesheet">
<link href="assets/css/responsive.dataTables.min.css" rel="stylesheet">
<script src="assets/js/jquery.dataTables.min.js"></script>
<script src="assets/js/dataTables.responsive.min.js"></script>

<?php
include_once('footer.php');
?>