/**
* Checks to see if a student is already being assessed by this user
* @param type $studentID
* @param type $examID
* @param type $userID
*/
public function checkAssessment($examID, $userID)
{
// print("$examID, $userID");
global $CFG;
try {
$conn = new PDO("mysql:host={$CFG->db};dbname={$CFG->schema}", $CFG->dbuser, $CFG->dbuserpass);
} catch (PDOException $e) {
die('<data><error>failed connecting to database</error><detail>' . $e->getMessage() . '</detail></data>');
}
//$conn = mysqli_connect($CFG->db, $CFG->dbuser, $CFG->dbuserpass, $CFG->schema) or die('<data><error>failed connecting to database</error><detail>' . mysqli_error($conn) . '</detail></data>');
// is this examiner already marking someone?
$query = "SELECT * FROM {$CFG->schema}.student_exam_sessions WHERE form_ID = :examID AND created_by_ID = :userID AND status <> 'complete'";
$stmt = $conn->prepare($query);
// print($query);
$stmt->bindValue(':examID', $examID, PDO::PARAM_INT);
$stmt->bindValue(':userID', $userID, PDO::PARAM_INT);
// $result = mysqli_query($conn, $query) or die('<data><error>checkAssessment query failed</error><detail>' . mysqli_error($conn) . $query . '</detail></data>');
$stmt->execute() or die('<data><error>checkAssessment query failed</error><detail>' . $stmt->errorInfo() . $query . '</detail></data>');
if ($stmt->rowCount() > 0) {
// print('Got a result');
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$reportslib = new ReportsLib();
return $reportslib->getReportForStudentSession($row['ID']);
}
} else {
return "<data></data>";
}
}
$enumLib = new EnumLib();
$returnStr = $enumLib->getActiveExamInstances($_REQUEST['site']);
break;
case 'showsignatureimage':
include 'lib/ReportsLib.php';
$reportslib = new ReportsLib();
$thumb = $reportslib->displaySignature($_REQUEST['session_ID']);
header('Content-type: image/jpeg');
imagejpeg($thumb);
imagedestroy($thumb);
break;
case 'getreportforsession':
include 'lib/ReportsLib.php';
include 'lib/EnumLib.php';
$reportslib = new ReportsLib();
$returnStr = $reportslib->getReportForStudentSession($_REQUEST['session_ID']);
break;
case 'getreportforsessionaspdf':
include 'lib/EnumLib.php';
include 'lib/mpdf60/mpdf.php';
include 'lib/ReportsLib.php';
$reportslib = new ReportsLib();
$reportslib->getReportForStudentSessionAsPDF($_REQUEST['session_ID'], isset($_REQUEST['showoverall']) ? $_REQUEST['showoverall'] == 'true' : false);
break;
case 'getreportforexamasexcel':
include 'lib/PHPExcel.php';
include 'lib/ReportsLib.php';
include 'lib/EnumLib.php';
$enumlib = new EnumLib();
$overview = simplexml_load_string($enumlib->getExamInstanceOverviewByID($_REQUEST['exam_ID']));
$reportslib = new ReportsLib();
