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

$getAbScQuery = "SELECT s.id, s.ability_id, s.sten_scores, s.description, s.status, a.full_name, a.short_name FROM `wp_psy_ability_sten_desc` as s LEFT JOIN `wp_psy_ability` as a ON a.ability_id=s.ability_id order by s.id";
$getAbScData = $wpdb->get_results($getAbScQuery);

if(isset($_REQUEST["editAbiltyScore"])){
	$abid = $_POST['abid'];
	$descr = $_POST['descr'];
	if($abid!='' && $descr!=''){
		$updateQuery = $wpdb->query("update `wp_psy_ability_sten_desc` set description='$descr' where id='$abid'");
		echo '<meta http-equiv="refresh" content="0">';
	}
}
?>

<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 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-info">
                <div class="panel-heading clearfix">
                    <h4 class="panel-title">Ability STEN Scores</h4>
                </div>
                <div class="panel-body">
                    <div class="table-responsive">
						<table class="display " id="userList" style="font-size: 13px;">
							<thead>
								<tr>
									<th>Id</th>
									<th>Ability</th>
									<th>STEN Score</th>
									<th>Description</th>
									<th>Status</th>
									<th>Action</th>
								</tr>
							</thead>
							<tbody>
							<?php 
							$i=1;
							foreach($getAbScData as $scrs){ 
							?>
								<tr>
									<td><?php echo $i; ?></td>
									<td><?php echo $scrs->full_name; ?> (<?php echo $scrs->short_name; ?>)</td>
									<td><?php echo $scrs->sten_scores; ?></td>
									<td><?php echo $scrs->description; ?></td>
									<td><?php echo $scrs->status; ?></td>
									<td><i class="fa fa-edit" title="Edit Details" style="cursor:pointer;" data-toggle="modal" data-id="<?php echo $scrs->id; ?>" data-target="#editAbilityScoreModal"></i></td>
								</tr>
							<?php $i++; } ?>
							</tbody>
						</table>
					</div>
				</div>
			</div>
        </div>        
    </div><!-- Main Wrapper -->

	<!-------------------edit ability modal---------------->
	<div class="modal fade" id="editAbilityScoreModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content" style="border: 3px solid #ccc;">
                <div class="modal-header" style="padding: 5px 10px 0px 0px; height: 20px;">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                </div>
                <div class="modal-body" id="edit_ability_score_modal"></div>
            </div>
        </div>
    </div>

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


<script type="text/javascript" charset="utf-8">
	jQuery.noConflict();
    jQuery(function($) {
        $('#userList').dataTable({
            "bPaginate": true,
            "iDisplayLength": 100,
            "lengthMenu": [[50, 100, 500, 1000 ], [50, 100, 500, 1000]]
        });
		
		jQuery('#editAbilityScoreModal').on('show.bs.modal', function (event) {
			var button = $(event.relatedTarget);
			var abid = button.data('id');
			//alert(abid);
				var url = "/counselor/apt-sten-desc-edit.php";
				jQuery.ajax({
					url: url,
					type:'POST',
					data: {abid:abid},
					success:function(data){
						document.getElementById("edit_ability_score_modal").innerHTML = data;
					}
				});
		});
	});
	
	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');
?>