File: /var/www/selfanalyse/counselor/emu-personality-tests.php
<?php
include_once('header.php');
include_once('../wp-config.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;
$curdate = date('Y-m-d', strtotime('+5 hour +30 minute'));
if (isset($_SESSION['filter_per'])) {
$subquery = $_SESSION['filter_per'];
$text = $_SESSION['text_per'];
} else {
$subquery = "and t.status='Y'";
$text = "of Personality Test with test status <span class='label label-success'>Completed</span>";
}
if (isset($_REQUEST['filter'])) {
$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') {
$_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') {
$_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";
}
}
$_SESSION['filter_per'] = $subquery;
$_SESSION['text_per'] = $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-PER' $subquery order by t.test_taken_id desc";
$getTestData = $wpdb->get_results($getTestQuery);
?>
<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">Personality 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">
<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>
<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>
<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">Personality 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>
<th>View</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
foreach ($getTestData as $tst) {
$status = $tst->status;
if ($status == 'Y') {
$link = 'emu-personality-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>
<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'); ?>