File manager

File manager - Edit - /home/autoph/public_html/tasks/exam_portal.php.tar

Back
home/autoph/public_html/portal/exam_portal.php��0000644��00000032272�15025031134�0015623 0��ustar�00��<?php include 'core/init.php'; $empID = $user_data['emp_id']; protected_page(); mysql_query('SET NAMES utf8'); mysql_query("SET NAMES 'utf8'"); mysql_query("SET CHARACTER SET utf8"); $trainingID = $_GET['tid']; $examID = $_GET['xid']; $examType = $_GET['examType']; $title = mysql_result(mysql_query("SELECT `title` FROM `pod_training_list` WHERE `id`='$trainingID' "),0); ?> <!DOCTYPE html> <html> <head> <title>EMPLOYEES PORTAL</title> <meta charset="utf-8"> <link rel="stylesheet" href="css/portal.css"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="./ajs/vendors/bower_components/bootstrap/dist/css/bootstrap.min.css"> <link rel="stylesheet" href="./ThemeFancy/theme.css" type="text/css"> <script type="text/javascript" src="./ThemeFancy/theme.js"></script> <link rel="stylesheet" href="css/jquery/css/jquery-ui.css"> <link rel="stylesheet" href="/resources/demos/style.css"> <script src="ajs/vendors/jQueryUI/jquery-1.12.4.js"></script> <script src="ajs/vendors/jQueryUI/jquery-ui.js"></script> <style> body { position: relative; background:black; } #section1 {padding-top:50px;height:730px;color: #000; background-color: #fff;} #section2 {padding-top:50px;height:500px;color: #fff; background-color: #A9F5A9;} #section3 {padding-top:50px;height:500px;color: #fff; background-color: #E6E6E6;} #section4 {padding-top:50px;height:500px;color: #fff; background-color: #A9F5A9;} #section41 {padding-top:50px;height:500px;color: #fff; background-color: #A9F5A9;} #section42 {padding-top:50px;height:500px;color: #fff; background-color: #E6E6E6;} #section43 {padding-top:50px;height:500px;color: #fff; background-color: #A9F5A9;} </style> <script> $(document).ready(function(){ $('[data-toggle="popover"]').popover(); }); </script> </head> <body data-spy="scroll" data-target=".navbar" data-offset="50" > <?php //CHECK IF ALL PRE-TEST HAS BEEN OPENED OR ANSWER //COUNT NUMBER OF EXAM FROM EXAM_CONTENT AND COMPARE IT TO ANSWERED EXAM $chkPreExamExist = mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_exam_taken` WHERE `training_id`='$trainingID' AND `employee_id`='$empID' AND `type`='PRE'"),0); $chkExamCount = mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_exam_contents` WHERE `training_id`='$trainingID'"),0); if($chkPreExamExist===$chkExamCount){ $myFname = mysql_result(mysql_query("SELECT `u_fname` FROM `c_users` WHERE `emp_id`='$empID'"),0); $myLname = mysql_result(mysql_query("SELECT `u_lname` FROM `c_users` WHERE `emp_id`='$empID'"),0); $fullName =$myFname ." ".$myLname; $title = mysql_result(mysql_query("SELECT `title` FROM `pod_training_list` WHERE `id`='$trainingID' "),0); $chkIfExist =mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_training_enrollees` WHERE `training_id`='$trainingID' AND `employee_id`='$empID'"),0); if($chkIfExist > 0){ }else{ $tID =$_GET['tid']; $sql="INSERT INTO `pod_training_enrollees` (`id`,`employee_id`,`training_id`,`title`,`emp_name`,`date_access`,`time_access`) VALUES('','$empID','$trainingID','$title','$fullName','$toDate','$currentTime')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); } } } if(isset($_GET['trn'])){ $examID = $_GET['xid']; $trainingID = $_GET['tid']; $xmTitle=mysql_result(mysql_query("SELECT `title` FROM `pod_exam_contents` WHERE `id`='$examID'"),0); $xmType =mysql_result(mysql_query("SELECT `type` FROM `pod_exam_contents` WHERE `id`='$examID'"),0); $chkContent =$_GET['trn']; switch($xmType){ case 'MULTIPLE CHOICE': include 'includes/exam/pod_exam_multiple_choice_exam_form.php'; break; //start of code case 'TRUE OR FALSE': include 'includes/exam/pod_exam_true_false_exam_form.php'; break; //======================================================================================= case 'MATCHING TYPE': include 'includes/exam/pod_exam_matching_type_form.php'; break; //======================================================================================= case 'ESSAY': include 'includes/exam/pod_exam_essay_form.php'; break; //======================================================================================= case 'ENUMERATION': include 'includes/exam/pod_exam_enumerate_exam_form.php'; break; //======================================================================================= case 'IDENTIFICATION': include 'includes/exam/pod_exam_identification_exam_form.php'; break; //======================================================================================= } } ?> <nav class="navbar navbar-inverse navbar-fixed-top"> <div class="container-fluid"> <div class="navbar-header"> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#myNavbar"> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> <a class="navbar-brand" href="#">NAME OF EMPLOYEE</a> </div> <div> <div class="collapse navbar-collapse" id="myNavbar"> <ul class="nav navbar-nav"> <li><a href="myportal.php?window=1">My Profile</a></li> <li><a href="myportal.php?window=2">TECH Updates</a></li> <li><a href="myportal.php?window=3">Training Section</a></li> <li><a href="myportal.php?window=4">The Human Resource</a></li> <li><a href="myportal.php?window=5">Legal Section</a></li> <li><a href="myportal.php?window=6">Corplan</a></li> <li><a href="myportal.php?window=7">Office of Executive</a></li> <li><a href="logmeout.php">LOGOUT</a></li> </ul> </div> </div> </div> </nav> <center> <table style="height:100%;width:100%;background:white;border-collapse:collapse"> <td valign='top' colspan='2' style='height:94%;width:100%;background:white;'> <!--====================================================================================--> <?php $getContent = mysql_query("SELECT * FROM `pod_exam_contents` WHERE `training_id`='$trainingID' ORDER BY `id` ASC "); echo "<table style='width:100%'>"; echo "<tr style =';background:white'>"; echo "<td style='width:10%;background:gray'>"; echo "</td>"; echo "<td style='width:80%;background:gray;height:600px;border:0px solid red'>"; echo "<div id='div' style='padding:10px;float:left;margin:5px;margin-top:40px;width:99%;height:500px;border:0px solid red;background:white; border-radius:5px;box-shadow:3px 3px 5px #cacaca;overflow:auto;min-width:600px'>"; //echo "PRE=-EXAM ". $chkPreExamExist; //echo "<br>EXAM COUNT ". $chkExamCount; echo "<p style='font-family:Calibri;font-size:25px;padding:5px' class='lightGradient'>List of required ".$_GET['type']."-TEST </p>"; while($row=mysql_fetch_array($getContent)){ $trn = $row['type']; $examID = $row['id']; switch($trn){ case 'MULTIPLE CHOICE': $getCount = mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_exam_multiple_choice` WHERE `exam_id`='".$row['id']."'"),0); break; //start of code case 'TRUE OR FALSE': $getCount = mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_exam_true_false` WHERE `exam_id`='".$row['id']."'"),0); break; //======================================================================================= case 'MATCHING TYPE': $getCount = mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_exam_matching_type` WHERE `exam_id`='".$row['id']."'"),0); break; //======================================================================================= case 'ESSAY': $getCount = mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_exam_essay` WHERE `exam_id`='".$row['id']."'"),0); break; //======================================================================================= case 'ENUMERATION': $getCount = mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_exam_enumeration` WHERE `exam_id`='".$row['id']."'"),0); break; //======================================================================================= case 'IDENTIFICATION': $getCount = mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_exam_identification` WHERE `exam_id`='".$row['id']."'"),0); break; //======================================================================================= } $checkExpiredDate = mysql_result(mysql_query("SELECT `date_finished` FROM `pod_exam_taken` WHERE `employee_id`='$empID' AND `exam_id`='$examID' AND `type`='$examType'"),0); $checkAnswer = mysql_result(mysql_query("SELECT COUNT('id') FROM `pod_exam_true_false_answer` WHERE `exam_id`='".$row['id']."' AND `employee_id`='$empID' AND `ex_type`='$examType'"),0); $myScore= mysql_result(mysql_query("SELECT SUM(`score`) FROM `pod_exam_true_false_answer` WHERE `exam_id`='".$row['id']."' AND `employee_id`='$empID' AND `score`='1' AND AND `type`='$examType'"),0); $rating = $myScore / $getCount * 100; echo "<div style='border-bottom:1px dashed lightgray;float:left;font-family:Calibri Light;font-size:24px;width:46%;margin-left:20px;margin-top:15px;'>"; echo "<p style='line-height:70%;font-family:Calibri Light;font-size:18px;font-weight:bold;margin:0px'>".ucfirst(strtolower($row['type']))."<br><b style='font-family:Calibri Light;font-size:12px;font-weight:normal'>". ucfirst(strtolower($row['title'])) ."</b> <br> <b style='font-family:Calibri Light;font-size:11px;padding-top:5px;color:blue;font-weight:normal'>Questions: ".$getCount." \| Time Limit: ".$row['time_limit']." minutes</b><br></b>"; $currentDateTime = date("m/d/Y H:i:s"); //echo $examType . " / ". $checkExpiredDate; if($currentDateTime >=$checkExpiredDate && !empty($checkExpiredDate)){ echo "<input type='button' value='Start' style='width:60px;font-family:Calibri Light;font-size:12px;border:1px solid lightgray;color:gray;padding:3px;border-radius:3px;font-weight:normal' class='lightGradient'> <b style='font-family:Calibri Light;font-size:12px;padding-top:5px;color:gray;font-weight:normal'><br>CLOSED. Taken last ".$row['date']." with score of ".number_format($myScore,0,'.',',') ." out of ".number_format($getCount,0,'.',',')." or ".number_format($rating,1,'.',',')." % Accuracy Rate </b><br><br>"; }else{ if($checkAnswer==0){ echo "<a href='exam_portal.php?tid=".$_GET['tid']."&content=true&xid=".$row['id']."&trn=".$row['type']."&pg=1&nu=".$row['time_limit']."&examType=".$_GET['examType']."'><input type='button' value='Start' style='width:60px;font-family:Calibri Light;font-size:12px;border:1px solid lightgray;color:green;padding:3px;border-radius:3px;font-weight:bold' class='lightGradient'></a> <b style='font-family:Calibri Light;font-size:12px;padding-top:5px;color:red;font-weight:normal'><br>NOT TAKEN YET. Please start when ready</b><br>"; }else if($checkAnswer===$getCount){ echo "<input type='button' value='Start' style='width:60px;font-family:Calibri Light;font-size:12px;border:1px solid lightgray;color:gray;padding:3px;border-radius:3px;font-weight:normal' class='lightGradient'> <b style='font-family:Calibri Light;font-size:12px;padding-top:5px;color:gray;font-weight:normal'><br>COMPLETED. Taken last ".$row['date']." with score of ".number_format($myScore,0,'.',',') ." out of ".number_format($getCount,0,'.',',')." or ".number_format($rating,1,'.',',')." % Accuracy Rate </b>"; }else{ echo "<a href='exam_portal.php?tid=".$_GET['tid']."&content=true&xid=".$row['id']."&trn=".$row['type']."&pg=1&nu=".$row['time_limit']."&examType=".$_GET['examType']."'><input type='button' value='Start' style='width:60px;font-family:Calibri Light;font-size:12px;border:1px solid lightgray;color:green;padding:3px;border-radius:3px;font-weight:bold' class='lightGradient'></a> <b style='font-family:Calibri Light;font-size:12px;padding-top:5px;color:red;font-weight:normal'><br>INCOMPLETE: Partially answered. Please start when ready</b>"; } } echo "</div>"; } echo "</div>"; echo "</td>"; echo "<td style='width:10%;background:gray'>"; echo "</td>"; echo "</tr>"; echo "</table>"; //======================================================================================= ?> <!--====================================================================================--> </td> </tr> <tr> <td colspan='2' style='background:black;height:10px;font-size:10px;color:gray;'> </td> </tr> </table> </center> </body> </html> ��

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings