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;
//=======================================================================================
}
}
?>
";
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 "
";
echo "
".ucfirst(strtolower($row['type']))." ".
ucfirst(strtolower($row['title']))
." Questions: ".$getCount."
|
Time Limit: ".$row['time_limit']." minutes ";
$currentDateTime = date("m/d/Y H:i:s");
//echo $examType . " / ". $checkExpiredDate;
if($currentDateTime >=$checkExpiredDate && !empty($checkExpiredDate)){
echo "
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
";
}else{
if($checkAnswer==0){
echo " NOT TAKEN YET. Please start when ready ";
}else if($checkAnswer===$getCount){
echo "
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
";
}else{
echo " INCOMPLETE: Partially answered. Please start when ready";
}
}
echo "