File: //proc/thread-self/root/proc/thread-self/cwd/emu-aptitude-test/print_page.php
<?php
/**
*
* Title : Test Report
* Developer : Rohit Kashyap
* Date : 04 Mar,2020
* Description : User test report and their sten score with highchart.
*/
// ini_set('dsiplay_errors', 1);
// error_reporting(E_ALL);
include_once('../wp-config.php');
global $wpdb;
$PSY_SP_QUESTION = $wpdb->prefix . PSY_SP_QUESTION;
$PSY_EXAMS = $wpdb->prefix . PSY_EXAMS;
$PSY_ABILITY = $wpdb->prefix . PSY_ABILITY;
$PSY_ABILITY_CLASS = $wpdb->prefix . PSY_ABILITY_CLASS;
$PSY_USERS_DETAILS = $wpdb->prefix . PSY_USERS_DETAILS;
$PSY_ABILITY_RAW_SCORE = $wpdb->prefix . PSY_ABILITY_RAW_SCORE;
$PSY_ABILITY_STEN_DESC = $wpdb->prefix . PSY_ABILITY_STEN_DESC;
$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;
$user_id = $_REQUEST['student_id'];
$testID = $_REQUEST['testId'];
$curDate = date('Y-m-d H:i:s');
if ($testID != '' && is_numeric($testID) && strlen($testID) <= 5 && is_numeric($user_id) && $user_id != '') {
$checkTest = $wpdb->get_var("SELECT count(test_taken_id) FROM $PSY_TEST_GEN_TEST_TAKEN where test_taken_id='$testID' and user_id='$user_id' and test_type='EMU-APT' and status='Y'");
if ($checkTest != '0') {
$userData = $wpdb->get_row("SELECT ud.first_name,ud.last_name,ud.date_of_birth,ud.gender_id,ud.email_address,ud.mobile_number FROM $PSY_USERS_DETAILS as ud where user_id='$user_id'");
$studentName = $userData->first_name . ' ' . $userData->last_name;
$dob = date('d F, Y', strtotime($userData->date_of_birth));
$gender = $userData->gender_id;
$email = $userData->email_address;
$mobile = $userData->mobile_number;
$getTestDetails = $wpdb->get_row("SELECT tt.total_questions,tt.class_id,tt.exam_category_id,tt.start_date,tt.finish_date,e.category_name,cl.class_name,e.sectional_instruction FROM $PSY_TEST_GEN_TEST_TAKEN as tt LEFT JOIN $PSY_EXAMS as e on e.exam_category_id=tt.exam_category_id LEFT JOIN $PSY_ABILITY_CLASS as cl on cl.class_id=tt.class_id where tt.test_taken_id='$testID' and tt.status='Y'");
$class_id = $getTestDetails->class_id != '0' ? $getTestDetails->class_id : '9';
$class = $getTestDetails->class_name;
$dateAttempt = date('d F, Y', strtotime($getTestDetails->start_date));
$finish_date = date('Y-m-d H:i:s', strtotime($getTestDetails->finish_date));
$hourdiff = round((strtotime($curDate) - strtotime($finish_date)) / 3600, 1);
$exam_id = $getTestDetails->exam_category_id;
$getsubject = $wpdb->get_results("SELECT e.category_name,e.exam_category_id from $PSY_EXAMS as e where e.parent_id='$exam_id' order by e.exam_category_id");
?>
<!DOCTYPE html>
<html <?php language_attributes(); ?>>
<head>
<title>Aptitude Test Report - ThinkEmu</title>
<link rel="icon" href="/wp-content/themes/psychometrics/images/emu.ico" type="image/x-icon" />
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.1.0/css/all.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/highcharts.js"></script>
<script src="js/highcharts-3d.js"></script>
</head>
<style>
@import url(https://fonts.googleapis.com/css?family=Lato);
body {
font-family: 'Lato', sans-serif;
}
.bold-txt {
font-weight: bold;
color: #000;
}
.col-md-2 {
width: 13.666667% !important;
}
/* MARGIN CSS */
.mt-20 {
margin-top: 20px
}
.mb-20 {
margin-bottom: 20px
}
table {
border-collapse: collapse;
border-spacing: 0;
width: 100%;
border: 1px solid #ddd;
}
th,
td {
text-align: left;
padding: 8px;
}
.header-logo {
float: right;
}
.chart-header-box {
float: left;
width: 100%;
border-radius: 4px;
background: #fff;
padding: 10px;
border-bottom: 1px solid #cecece;
}
.chart-header-box h4 {
font-size: 16px;
}
.intro-box {
margin: 0;
padding-left: 14px;
background: #fff;
padding: 10px;
float: left;
width: 100%;
}
.intro-box h2 {
margin: 0;
color: #464646;
font-weight: 600;
font-size: 24px;
padding: 0 0 20px;
}
.one-circle-box {
border-radius: 50%;
text-align: center;
padding: 24px 0;
width: 140px;
margin: 0 auto;
}
.one-circle-box i {
font-size: 28px;
}
.chart-box {
border: 1px solid #cccccc;
box-shadow: 0 2px 4px 2px #c7c7c7;
margin: 2em 0;
}
#container {
/* height: 550px; */
}
.highcharts-data-table table {
font-family: Verdana, sans-serif;
border-collapse: collapse;
border: 1px solid #EBEBEB;
margin: 10px auto;
text-align: center;
width: 100%;
max-width: 500px;
}
.highcharts-data-table caption {
padding: 1em 0;
font-size: 1.2em;
color: #555;
}
.highcharts-data-table th {
font-weight: 600;
padding: 0.5em;
}
.highcharts-data-table td,
.highcharts-data-table th,
.highcharts-data-table caption {
padding: 0.5em;
}
.highcharts-data-table thead tr,
.highcharts-data-table tr:nth-child(even) {
background: #f8f8f8;
}
.highcharts-data-table tr:hover {
background: #f1f7ff;
}
svg:not(:root) {
overflow: visible !important;
}
.highcharts-container {
overflow: visible !important;
}
.intro-box h5 {
margin: 0;
color: #fff;
font-size: 18px;
padding: 10px;
text-align: center;
background: #f1802b;
}
.ability-desc-box h2 {
margin: 0;
color: #464646;
font-weight: 600;
font-size: 20px;
padding: 30px 0 10px;
}
.intro-box p {
margin: 0;
font-size: 16px;
}
.ability-desc-box {
border-bottom: 1px solid #434348;
padding-bottom: 20px;
}
.sten-score {
border: 1px solid #b1b1b1;
box-shadow: 0 2px 4px 2px #9a9a9a;
padding: 10px;
margin-top: 1em;
/* background: #90ed7d; */
}
.sten-score h3 {
font-size: 18px;
margin: 0;
padding-bottom: 10px;
}
.description-ul {
padding: 20px;
}
.description-ul li {
list-style: decimal;
color: #000;
margin-bottom: 20px;
font-size: 15px;
}
.test-head {
font-size: 26px !important;
padding-bottom: 10px;
}
.chart-header-box h6 {
margin: 0;
font-size: 17px;
padding: 10px 0 30px;
line-height: 24px;
font-weight: 600;
}
.back-home-btn {
font-size: 14px;
background: #0085f7;
padding: 10px;
display: table;
margin: 0 auto;
color: #fff;
cursor: pointer;
border-radius: 4px;
font-weight: bold;
}
.fb-share {
background: #3b5998;
border-radius: 3px;
font-weight: 600;
padding: 5px 8px;
float: right;
position: relative;
top: -4px;
display: inline-flex;
}
.fb-share:hover {
cursor: pointer;
background: #213A6F
}
.fb-share svg {
width: 18px;
fill: white;
vertical-align: middle;
border-radius: 2px
}
.fb-share span {
vertical-align: middle;
color: white;
font-size: 14px;
padding: 0 3px
}
/* aptitude-test CSS */
#btnBack {
float: left;
margin-bottom: 12px;
background: #f53e10;
border: none;
color: #fff;
padding: 4px 10px;
font-weight: 600;
border-radius: 4px;
}
#btnPrint {
float: right;
margin-bottom: 12px;
background: #154479;
border: none;
color: #fff;
padding: 4px 10px;
font-weight: 600;
border-radius: 4px;
}
/* END aptitude-test CSS */
</style>
<body>
<!-- TOP TABLE SECTION -->
<section style="background: #f1f1f1;padding: 2em 0;">
<div class="container">
<!----User details--->
<div class="row">
<div class="chart-header-box" style="margin-bottom: 2em;">
<div class="col-md-8">
<h4 class="test-head"><?php echo $getTestDetails->category_name; ?></h4>
<h4>Name : <span style="font-weight: bold;"> <?php echo $studentName; ?> </span>, <span> Class :</span> <span style="font-weight: bold;"><?php echo $class ?></span></h4>
<h4>Date : <span style="font-weight: bold;"><?php echo $dateAttempt; ?></span></h4>
</div>
<div class="col-md-4">
<img class="header-logo" src="https://selfanalyse.com/wp-content/themes/psychometrics/images/emu-logo.png" alt="">
</div>
</div>
</div>
<?php
//if ($curDate >= $tomorrow) {
?>
<!----First Page Content--->
<div class="row">
<div class="intro-box print-view-box">
<?php if ($hourdiff >= 1) { ?>
<form action="/emu-aptitude-test/pdf.php" method="post">
<input type="hidden" name="test" value="<?php echo $testID; ?>">
<button id="btnPrint" type="submit">View as PDF</button>
</form>
<?php } else { ?>
<button id="btnPrint" type="button">Report will be available after one hour</button>
<?php } ?>
<div class="col-md-12">
<h3>ABOUT PSYCHOMETRIC TESTS</h3>
<p>Psychometric tests tell us a lot about ourselves. They can be particularly helpful when we are making an important decision such as, choosing a career, a course or a stream. </p>
<p>Psychometric tests are designed to assess the cognitive abilities and personality traits of an individual. Knowing our own strengths and weaknesses help us in choosing the career/course most suited for us, or to reveal the abilities we need to develop in order to be successful in the careers we want to choose.</p>
<p>Psychometric tests are of two types:<ul>
<li>Test for abilities or aptitude</li>
<li>Test for personality</li>
</ul>
</p>
<p>Abilities or aptitude describe our strengths and weaknesses. For example, some people sing very well. We would say that their ‘ability’ to sing is high. Now that person can become a professional singer much more easily than a person who does not have that ability. Similarly, all of us have different levels of ability for numbers, for language, for reasoning and logic, for mechanics etc. These different abilities are more or less beneficial in success in different fields or careers.</p>
</div>
</div>
</div>
</div>
</section>
<!-- END TOP TABLE SECTION -->
<div style="display: none;">
<?php
$path = '/var/www/selfanalyse/emu-aptitude-test/pdf-html/pdf-' . $testID . '.html';
if (file_exists($path)) {
echo "exist";
} else {
ob_start();
include_once('pdf_content.php');
$html = ob_get_contents();
file_put_contents('/var/www/selfanalyse/emu-aptitude-test/pdf-html/pdf-' . $testID . '.html', $html);
ob_flush();
}
?>
</div>
</body>
<?php
} else {
?>
<script>
window.location.href = 'http://www.thinkemu.com'
</script>
<?php
}
} else {
?>
<script>
window.location.href = 'http://www.thinkemu.com'
</script>
<?php
}
?>