File: /var/www/selfanalyse/counselor/emu-aptitude-tests.php
<?php
include_once('header.php');
include_once('../wp-config.php');
include_once('sten_score_functions.php');
$PSY_EXAMS = $wpdb->prefix . PSY_EXAMS;
$PSY_ABILITY = $wpdb->prefix . PSY_ABILITY;
$PSY_SP_QUESTION = $wpdb->prefix . PSY_SP_QUESTION;
$PSY_STATES = $wpdb->prefix . PSY_STATES;
$PSY_USERS_DETAILS = $wpdb->prefix . PSY_USERS_DETAILS;
$PSY_ABILITY_RAW_SCORE = $wpdb->prefix . PSY_ABILITY_RAW_SCORE;
$PSY_TEST_GEN_TEST_TAKEN = $wpdb->prefix . PSY_TEST_GEN_TEST_TAKEN;
$PSY_TEST_GEN_TEST_TAKEN_QUESTION_ANSWER = $wpdb->prefix . PSY_TEST_GEN_TEST_TAKEN_QUESTION_ANSWER;
$getEmuexams = $wpdb->get_results("SELECT exam_category_id, category_name FROM $PSY_EXAMS where category_name LIKE '%Aptitude%' and exam_category_id !='48282'");
$curdate = date('Y-m-d', strtotime('+5 hour +30 minute'));
if (isset($_SESSION['filter_apt'])) {
$subquery = $_SESSION['filter_apt'];
$text = $_SESSION['text_apt'];
} else {
$subquery = "and t.exam_category_id='48459' and t.status='Y'";
$text = "of Full Aptitude Test with test status <span class='label label-success'>Completed</span>";
}
if (isset($_REQUEST['filter'])) {
$exam_id = $_REQUEST['exam_id'];
$test_status = $_REQUEST['test_status'];
if ($test_status == 'A') {
$showTest = '';
} else {
$showTest = "and t.status='$test_status'";
}
switch ($test_status) {
case "Y":
$showBtn = "<span class='label label-success'>Completed</span>";
break;
case "N":
$showBtn = "<span class='label label-warning'>Pending</span>";
break;
default:
$showBtn = "<span class='label label-primary'>All</span>";
}
$_SESSION['SEARCH_TYPE'] = $_REQUEST['search_type'];
if ($_REQUEST['search_type'] == '1') {
if ($_REQUEST['date'] != '' && $exam_id != 'NOT') {
$_SESSION['ONDATE'] = $_REQUEST['date'];
$_SESSION['EXAM'] = $exam_id;
$date = date('Y-m-d', strtotime($_REQUEST['date']));
$exam = $wpdb->get_var("SELECT category_name FROM $PSY_EXAMS where exam_category_id='$exam_id'");
$text = "of " . $exam . " with test status ".$showBtn." On the date " . $date;
$subquery = "and date(t.start_date)='$date' and t.exam_category_id='$exam_id' $showTest";
} else {
$_SESSION['ONDATE'] = $_REQUEST['date'];
$date = date('Y-m-d', strtotime($_REQUEST['date']));
$text = "On the date " . $date. " with test status ".$showBtn;
$subquery = "and date(t.start_date)='$date' $showTest";
}
} else if ($_REQUEST['search_type'] == '2') {
if ($_REQUEST['fromdate'] != '' && $_REQUEST['todate'] != '' && $exam_id != 'NOT') {
$_SESSION['FROMDATE'] = $_REQUEST['fromdate'];
$_SESSION['TODATE'] = $_REQUEST['todate'];
$_SESSION['EXAM'] = $exam_id;
$fromdate = date('Y-m-d', strtotime($_REQUEST['fromdate']));
$todate = date('Y-m-d', strtotime($_REQUEST['todate']));
$exam = $wpdb->get_var("SELECT category_name FROM $PSY_EXAMS where exam_category_id='$exam_id'");
$text = "of " . $exam . " with test status ".$showBtn." from date " . $fromdate . " to " . $todate;
$subquery = "and (date(t.start_date) >='$fromdate' AND date(t.start_date) <= '$todate') and t.exam_category_id='$exam_id' $showTest";
} else {
$_SESSION['FROMDATE'] = $_REQUEST['fromdate'];
$_SESSION['TODATE'] = $_REQUEST['todate'];
$fromdate = date('Y-m-d', strtotime($_REQUEST['fromdate']));
$todate = date('Y-m-d', strtotime($_REQUEST['todate']));
$text = "from date " . $fromdate . " to " . $todate. " with test status ".$showBtn;
$subquery = "and (date(t.start_date) >='$fromdate' AND date(t.start_date) <= '$todate') $showTest";
}
} else {
$_SESSION['EXAM'] = $exam_id;
$exam = $wpdb->get_var("SELECT category_name FROM $PSY_EXAMS where exam_category_id='$exam_id'");
$text = "of " . $exam . " with test status ".$showBtn;
$subquery = "and t.exam_category_id='$exam_id' $showTest";
}
}
$_SESSION['filter_apt'] = $subquery;
$_SESSION['text_apt'] = $text;
$getTestQuery = "SELECT t.test_taken_id, t.user_id, t.class_id,t.exam_category_id, t.total_questions, t.answer_selected, t.start_date, t.test_type,t.status, u.first_name, u.mobile_number, u.email_address, e.category_name, u.date_of_birth, u.gender_id,s.state_name FROM $PSY_TEST_GEN_TEST_TAKEN as t LEFT JOIN $PSY_USERS_DETAILS as u ON u.user_id=t.user_id LEFT JOIN $PSY_EXAMS as e ON e.exam_category_id=t.exam_category_id LEFT JOIN $PSY_STATES as s on s.state_id=u.state_id where t.test_type='EMU-APT' $subquery order by t.test_taken_id desc";
$getTestData = $wpdb->get_results($getTestQuery);
$exam_category_id = $_SESSION['EXAM'];
if($exam_category_id !=''){
$getTopics = $wpdb->get_results("SELECT e.category_name,e.exam_category_id from $PSY_EXAMS as e where e.parent_id='$exam_category_id' order by e.exam_category_id");
} else{
$getTopics = $wpdb->get_results("SELECT e.category_name,e.exam_category_id from $PSY_EXAMS as e where e.parent_id='48459' order by e.exam_category_id");
}
?>
<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%;
}
.excel {
float: right;
color: #fff;
}
</style>
<div class="page-inner">
<div class="page-title">
<div class="col-md-4">
<h3> EMU Tests </h3>
<div class="page-breadcrumb">
<ol class="breadcrumb">
<li><a href="dashboard">Home</a></li>
<li class="active">Aptitude Tests</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>-->
</ul>
</div>
</div>
</div>
<div id="main-wrapper">
<div class="row">
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Search Filter</font>
</h4>
</div>
<div class="spacer"></div>
<div class="panel-body">
<form class="form-inline" method="post" onSubmit="return validateFirst();">
<div class="form-group">
<select name="exam_id" class="form-control" id="exam_id">
<option value="NOT">--Exam--</option>
<?php foreach ($getEmuexams as $ms) { ?>
<option value="<?php echo $ms->exam_category_id; ?>"><?php echo $ms->category_name; ?></option>
<?php } ?>
</select>
</div>
<div class="form-group">
<select name="test_status" class="form-control" id="exam_id">
<option value="A">--Test Status--</option>
<option value="A">All</option>
<option value="Y">Completed</option>
<option value="N">Pending</option>
</select>
</div>
<div class="form-group">
<input type="radio" class="form-control" value="1" name="search_type">
<input type="text" name="date" id="date" class="form-control" placeholder="On Date">
</div>
<div class="form-group">
<input type="radio" class="form-control" value="2" name="search_type">
<input type="text" name="fromdate" id="fromdate" class="form-control" placeholder="From Date">
<input type="text" name="todate" id="todate" class="form-control" placeholder="To Date">
</div>
<input class="btn btn-info" type="submit" value="Filter" name="filter" />
</form>
</div>
</div>
</div>
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading clearfix">
<h4 class="panel-title">Aptitude Test List - <?php echo $text; ?></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>Name</th>
<th>Email</th>
<th>Mobile</th>
<th>D O B</th>
<th>Gender</th>
<th>State</th>
<th>Test Date</th>
<th>Test Name</th>
<?php foreach ($getTopics as $t) {
$ab = $wpdb->get_row("SELECT short_name,full_name FROM $PSY_ABILITY where FIND_IN_SET($t->exam_category_id,ref_id)");
?>
<th title="<?php echo $ab->full_name ?>"><?php echo $ab->short_name ?></th>
<?php } ?>
<th>View</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
foreach ($getTestData as $tst) {
$status = $tst->status;
if($status == 'Y'){
$link = 'emu-aptitude-report';
} else {
$link = '#';
}
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $tst->first_name; ?></td>
<td><?php echo $tst->email_address; ?></td>
<td><?php echo $tst->mobile_number; ?></td>
<td><?php echo $tst->date_of_birth; ?></td>
<td><?php echo $tst->gender_id; ?></td>
<td><?php echo $tst->state_name; ?></td>
<td><?php echo $tst->start_date; ?></td>
<td><?php echo $tst->category_name; ?></td>
<?php
foreach ($getTopics as $sub) {
$subject = $sub->exam_category_id;
$class_id = $tst->class_id;
$test_id = $tst->test_taken_id;
$rawscore = emuAptitudeTest($subject, $class_id, $test_id);
?>
<td><?php echo $rawscore; ?></td>
<?php } ?>
<td>
<?php if($status == 'Y'){ ?>
<a href="<?php echo $link; ?>?testId=<?php echo $tst->test_taken_id; ?>&student_id=<?php echo $tst->user_id; ?>" target="_blank">
<i class="fa fa-eye" title="View Test Report" style="cursor:pointer;"></i>
</a>
<?php } else { } ?>
</td>
</tr>
<?php $i++;
} ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Main Wrapper -->
<div class="page-footer">
<p class="no-s">selfanalyse.com</p>
</div>
</div>
<!-- Page Inner -->
<link href="assets/css/jquery.dataTables.min.css" rel="stylesheet">
<link href="assets/css/responsive.dataTables.min.css" rel="stylesheet">
<link rel="stylesheet" type="text/css" href="assets/plugins/jquery-ui/jquery-ui.css" />
<script src="assets/js/jquery.dataTables.min.js"></script>
<script src="assets/js/dataTables.responsive.min.js"></script>
<script type="text/javascript" charset="utf-8">
jQuery.noConflict();
jQuery(document).ready(function() {
jQuery("#date").datepicker({
changeMonth: true,
changeYear: true,
dateFormat: 'yy-mm-dd'
});
jQuery("#todate").datepicker({
changeMonth: true,
changeYear: true,
dateFormat: 'yy-mm-dd'
});
jQuery("#fromdate").datepicker({
changeMonth: true,
changeYear: true,
dateFormat: 'yy-mm-dd'
});
});
jQuery(function($) {
$('#userList').dataTable({
"bPaginate": true,
"iDisplayLength": 50,
"responsive": true,
"lengthMenu": [
[10, 20, 50, 100, 500, 1000],
[10, 20, 50, 100, 500, 1000]
],
"order": [
[0, "asc"]
]
});
});
</script>
<?php include_once('footer.php'); ?>