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

$getAbQuery = "SELECT a.* FROM `wp_psy_ability` as a order by a.ability_id";
$getAbData = $wpdb->get_results($getAbQuery);

if(isset($_REQUEST["editAbilty"])){
	$abid = $_POST['abid'];
	$descr = $_POST['descr'];
	if($abid!='' && $descr!=''){
		$updateQuery = $wpdb->query("update `wp_psy_ability` set description='$descr' where ability_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 List</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 List</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 Id</th>
									<th>Type</th>
									<th>Short Name</th>
									<th>Full Name</th>
									<th>Order</th>
									<th>Description</th>
									<th>Status</th>
									<th>Action</th>
								</tr>
							</thead>
							<tbody>
							<?php 
							$i=1;
							foreach($getAbData as $ablt){ 
							?>
								<tr>
									<td><?php echo $i; ?></td>
									<td><?php echo $ablt->ability_id; ?></td>
									<td><?php echo $ablt->parent; ?></td>
									<td><?php echo $ablt->short_name; ?></td>
									<td><?php echo $ablt->full_name; ?></td>
									<td><?php echo $ablt->display_order; ?></td>
									<td><?php echo $ablt->description; ?></td>
									<td><?php echo $ablt->status; ?></td>
									<td><i class="fa fa-edit" title="Edit Details" style="cursor:pointer;" data-toggle="modal" data-id="<?php echo $ablt->ability_id; ?>" data-target="#editAbilityModal"></i></td>
								</tr>
							<?php $i++; } ?>
							</tbody>
						</table>
					</div>
				</div>
			</div>
        </div>        
    </div><!-- Main Wrapper -->

	<!-------------------edit ability modal---------------->
	<div class="modal fade" id="editAbilityModal" 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_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": 50,
            "lengthMenu": [[10,20, 50, 100, 500, 1000 ], [10,20, 50, 100, 500, 1000]]
        });
		
		jQuery('#editAbilityModal').on('show.bs.modal', function (event) {
			var button = $(event.relatedTarget);
			var abid = button.data('id');
			//alert(abid);
				var url = "/counselor/apt-ability-edit.php";
				jQuery.ajax({
					url: url,
					type:'POST',
					data: {abid:abid},
					success:function(data){
						document.getElementById("edit_ability_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');
?>