コード例 #1
0
</div>
<div style="left:155px; top:-9px" class="label"><?php 
echo $string['studentsmark'];
?>
</div>
<div style="left:60px; top:-9px; width:160px" class="label"><?php 
echo $string['medianclassmark'];
?>
</div>
</div>

<div style="position:absolute; top:0; left:0; width:100%">
<?php 
$demo = is_demo($userObject);
$student_details = UserUtils::get_user_details($userID, $mysqli);
$name = demo_replace($student_details['title'], $demo) . ' ' . demo_replace($student_details['surname'], $demo) . ', ' . demo_replace($student_details['first_names'], $demo) . ' (' . demo_replace($student_details['student_id'], $demo) . ')';
echo "<table class=\"header\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" style=\"font-size:90%\">\n";
echo "<tr><th><div style=\"padding-left:10px; font-size:200%; font-weight:bold\">" . $propertyObj->get_paper_title() . "</div><div style=\"padding-left:10px\">{$name}</div></th></tr>\n";
echo "</table>\n<ol>";
// Get the questions on the paper
$q_no = 1;
$result = $mysqli->prepare("SELECT q_id, theme, leadin, q_type FROM questions, papers WHERE papers.paper = ? AND papers.question = questions.q_id AND q_type != 'info' ORDER BY screen, display_pos");
$result->bind_param('i', $paperID);
$result->execute();
$result->bind_result($q_id, $theme, $leadin, $q_type);
while ($result->fetch()) {
    echo "<li>{$leadin}";
    if (substr(strtolower($leadin), -4) == '</p>') {
    } elseif (substr(strtolower($leadin), -6) == '</div>') {
        echo '<br />';
    } else {
コード例 #2
0
if ($result->num_rows == 0) {
    header("HTTP/1.0 404 Not Found");
    $msg = sprintf($string['furtherassistance'], $configObject->get('support_email'), $configObject->get('support_email'));
    $notice->display_notice_and_exit($mysqli, $string['pagenotfound'], $msg, $string['pagenotfound'], '../artwork/page_not_found.png', '#C00000', true, true);
}
$result->close();
$start_seconds = substr($started, 0, 2) * 60 * 60 + substr($started, 3, 2) * 60 + substr($started, 6, 2);
$updated = substr($updated, 0, 2) * 60 * 60 + substr($updated, 3, 2) * 60 + substr($updated, 6, 2);
$time_spent = $updated - $start_seconds;
$result = $mysqli->prepare("SELECT username, title, initials, surname FROM users WHERE id = ?");
$result->bind_param('i', $userID);
$result->execute();
$result->bind_result($tmp_username, $title, $initials, $surname);
$result->fetch();
$result->close();
$student_name = $title . ' ' . demo_replace($initials, $demo) . ' ' . demo_replace($surname, $demo);
$textsize = 100;
$font = 'Arial';
if ($userObject->is_special_needs()) {
    // Look up special_needs data
    $textsize = $userObject->get_textsize($textsize);
    $font = $userObject->get_font($font);
}
$textsize -= 10;
?>
<!DOCTYPE html>
<html>
<head>
  <meta http-equiv="X-UA-Compatible" content="IE=edge" />
  <meta http-equiv="content-type" content="text/html;charset=<?php 
echo $configObject->get('cfg_page_charset');
コード例 #3
0
ファイル: assessment_boolean.php プロジェクト: vinod-co/centa
 $result->bind_result($student_id, $username, $uID, $title, $surname, $first_names, $grade, $gender, $year, $started, $question_ID, $user_answer, $q_type, $screen, $settings);
 $old_username = '';
 while ($result->fetch()) {
     if ($old_username != $username or $old_started != $started) {
         $rowID++;
     }
     $log_array[$rowID][$screen][$question_ID] = $user_answer;
     $log_array[$rowID]['student_id'] = demo_replace_number($student_id, $demo);
     $log_array[$rowID]['userID'] = $uID;
     $log_array[$rowID]['username'] = $username;
     $log_array[$rowID]['course'] = $grade;
     $log_array[$rowID]['year'] = $year;
     $log_array[$rowID]['started'] = $started;
     $log_array[$rowID]['title'] = $title;
     $log_array[$rowID]['surname'] = demo_replace($surname, $demo);
     $log_array[$rowID]['first_names'] = demo_replace($first_names, $demo);
     $log_array[$rowID]['name'] = str_replace("'", "", $surname) . ',' . $first_names;
     $log_array[$rowID]['gender'] = $gender;
     $log_array[$rowID]['$questionID'] = json_decode($settings, true);
     $user_no++;
     $old_username = $username;
     $old_started = $started;
 }
 $result->close();
 $sortby = 'name';
 $ordering = 'asc';
 $log_array = array_csort($log_array, $sortby, $ordering);
 //********************************
 $exclusions = new Exclusion($paperID, $mysqli);
 $exclusions->load();
 // Get any questions to exclude.
コード例 #4
0
ファイル: view_form.php プロジェクト: vinod-co/centa
    $notice->display_notice_and_exit($mysqli, $string['pagenotfound'], $msg, $string['pagenotfound'], '../artwork/page_not_found.png', '#C00000', true, true);
}
$killer_questions = new Killer_question($paperID, $mysqli);
$killer_questions->load();
$killed = false;
// Get the module ID and calendar year of the OSCE station.
$result = $mysqli->prepare("SELECT username, title, surname, first_names, grade, yearofstudy, student_id FROM (users, sid) WHERE users.id = ? AND users.id = sid.userID");
$result->bind_param('i', $userID);
$result->execute();
$result->bind_result($username, $title, $surname, $first_names, $grade, $year, $student_id);
$result->fetch();
$result->close();
$original_username = $username;
if (isset($demo) and $demo == true) {
    $surname = demo_replace($surname, $demo);
    $first_names = demo_replace($first_names, $demo);
    $student_id = demo_replace_number($student_id, $demo);
}
$paper_title = $propertyObj->get_paper_title();
$bgcolor = $propertyObj->get_bgcolor();
$fgcolor = $propertyObj->get_fgcolor();
$labelcolor = $propertyObj->get_labelcolor();
$themecolor = $propertyObj->get_themecolor();
$marking = $propertyObj->get_marking();
?>
<html>
  <head>
  <meta http-equiv="X-UA-Compatible" content="IE=edge" />
  <meta http-equiv="content-type" content="text/html;charset=<?php 
echo $configObject->get('cfg_page_charset');
?>
コード例 #5
0
ファイル: search.php プロジェクト: vinod-co/centa
            echo '<td>' . $string[$lowertitle] . '</td>';
        } else {
            echo '<td></td>';
        }
    } else {
        echo '<td></td>';
    }
    if ($tmp_first_names == '') {
        $tmp_first_names = ' ';
    }
    if ($tmp_surname == '') {
        $tmp_surname = ' ';
    }
    echo '<td>' . demo_replace($tmp_surname, $demo, true, $tmp_surname[0]) . '</td>';
    echo '<td>' . demo_replace($tmp_first_names, $demo, true, $tmp_first_names[0]) . '</td>';
    echo '<td>' . demo_replace($tmp_username, $demo, false) . '</td>';
    if (strpos($tmp_roles, 'Student') !== false) {
        if ($tmp_student_id == NULL) {
            echo '<td class="fn">' . $string['unknown'] . '</td>';
        } else {
            echo '<td>' . demo_replace_number($tmp_student_id, $demo) . '</td>';
        }
    } elseif (strpos($tmp_roles, 'Staff') !== false) {
        echo "<td>Staff</td>";
    } else {
        echo "<td class=\"fn\">" . $string['na'] . "</td>";
    }
    echo "<td>{$tmp_yearofstudy}</td>";
    echo "<td>{$tmp_grade}</td></tr>\n";
    $x++;
}
コード例 #6
0
ファイル: details.php プロジェクト: vinod-co/centa
<body>
<?php 
$user_details = UserUtils::get_user_details($userID, $mysqli);
if ($user_details === false) {
    $msg = sprintf($string['furtherassistance'], $configObject->get('support_email'), $configObject->get('support_email'));
    $notice->display_notice_and_exit($mysqli, $string['pagenotfound'], $msg, $string['pagenotfound'], '../artwork/page_not_found.png', '#C00000', true, true);
}
require '../tools/colour_picker/colour_picker.inc';
require '../include/user_search_options.inc';
require '../include/toprightmenu.inc';
echo draw_toprightmenu();
if ($demo == true) {
    // Hide the personal details.
    $user_details['surname'] = demo_replace($user_details['surname'], $demo);
    $user_details['first_names'] = demo_replace($user_details['first_names'], $demo);
    $user_details['initials'] = demo_replace($user_details['initials'], $demo);
    $user_details['student_id'] = demo_replace_number($user_details['student_id'], $demo);
    $user_details['email'] = demo_replace_username($user_details['email'], $demo);
}
$course_details = CourseUtils::get_course_details_by_name($user_details['grade'], $mysqli);
if ($user_details['user_deleted'] == '') {
    $bg_color = '#EEF4FF';
} else {
    $bg_color = '#FFC0C0';
}
?>
<div id="content">
<table cellpadding="0" cellspacing="0" border="0" style="background-color:<?php 
echo $bg_color;
?>
; width:100%; line-height:175%; padding-bottom:10px">
コード例 #7
0
ファイル: class_totals.class.php プロジェクト: vinod-co/centa
 /**
  * Load user data from the log tables and store.
  * Calls 'writeUserResults' to write into an array.
  */
 private function load_results()
 {
     if ($this->studentsonly == 0) {
         $roles_sql = '';
     } else {
         $roles_sql = " AND (users.roles = 'Student' OR users.roles = 'graduate')";
     }
     $data_array = array();
     $metadataids = array();
     // Load started records from 'log_metadata'.
     if ($this->paper_type == '2') {
         $time_int = 2;
     } else {
         $time_int = 0;
     }
     $result = $this->db->prepare("SELECT\n                                    log_metadata.id,\n                                    users.id,\n                                    username,\n                                    roles,\n                                    year,\n                                    title,\n                                    surname,\n                                    initials,\n                                    first_names,\n                                    email,\n                                    gender,\n                                    ipaddress,\n                                    lab_name,\n                                    student_id,\n                                    attempt,\n                                    DATE_FORMAT(started, '{$this->config->get('cfg_long_date_time')}') AS display_started,\n                                    started,\n                                    student_grade\n                                  FROM\n                                    log_metadata,\n                                    users\n                                  LEFT JOIN\n                                    sid\n                                  ON\n                                    users.id = sid.userID\n                                  WHERE\n                                    log_metadata.userID = users.id AND\n                                    paperID = ? AND\n                                    grade LIKE ? {$roles_sql} AND\n                                    DATE_ADD(started, INTERVAL {$time_int} MINUTE) >= ?\n                                    AND started <= ?");
     $result->bind_param('isss', $this->paperID, $this->repcourse, $this->startdate, $this->enddate);
     $result->execute();
     $result->bind_result($metadataID, $userID, $username, $roles, $year, $title, $surname, $initials, $first_names, $email, $gender, $ipaddress, $lab_name, $student_id, $attempt, $display_started, $started, $student_grade);
     while ($result->fetch()) {
         $tmp_name = trim(str_replace("'", "", $surname) . ',' . $first_names);
         if ($lab_name == '') {
             $room = '<span style="color:#808080">&lt;unknown&gt;</span>';
         } else {
             $room = $lab_name;
         }
         if ($this->demo) {
             $surname = demo_replace($surname, true, true, $surname[0]);
             $initials = demo_replace($initials, true, true, $initials[0]);
             $first_names = demo_replace($first_names, true, true, $first_names[0]);
             $email = demo_replace($email);
             $student_id = demo_replace_number($student_id);
         }
         $this->user_results[$metadataID] = array('metadataID' => $metadataID, 'userID' => $userID, 'username' => $username, 'roles' => $roles, 'year' => $year, 'title' => $title, 'surname' => $surname, 'initials' => $initials, 'first_names' => $first_names, 'name' => $tmp_name, 'email' => $email, 'gender' => $gender, 'ipaddress' => $ipaddress, 'room' => $room, 'student_id' => $student_id, 'attempt' => $attempt, 'visible' => true, 'display_started' => $display_started, 'started' => $started, 'student_grade' => $student_grade, 'mark' => 0, 'percent' => 0, 'questions' => 0, 'duration' => 0, 'marking_complete' => true, 'module' => '', 'paper_type' => $this->paper_type);
         $metadataids[] = $metadataID;
     }
     $result->close();
     if (count($metadataids) == 0) {
         $this->user_results = array();
         return false;
     }
     $i = 0;
     $old_screen = 0;
     $old_duration = 0;
     $old_metadataID = 0;
     $user_duration = 0;
     $marking_complete = 1;
     $tmp_mark = 0;
     $tmp_user_mark_array = array();
     $log_data = array();
     $tmp_array = array();
     // Load 'logX' data.
     if ($this->paper_type == '0' or $this->paper_type == '1') {
         $result = $this->db->prepare("(SELECT log0.id, metadataID, 0 AS paper_type, questions.q_id, screen, duration, user_answer, q_type, mark FROM log0, questions WHERE log0.q_id = questions.q_id AND metadataID IN (" . implode(',', $metadataids) . ")) UNION ALL (SELECT log1.id, metadataID, 1 AS paper_type, questions.q_id, screen, duration, user_answer, q_type, mark FROM log1, questions WHERE log1.q_id = questions.q_id AND metadataID IN (" . implode(',', $metadataids) . ")) ORDER BY metadataID, screen");
     } elseif ($this->paper_type == '5') {
         $result = $this->db->prepare("SELECT log{$this->paper_type}.id, metadataID, {$this->paper_type} AS paper_type, questions.q_id, 1 AS screen, 0 AS duration, NULL AS user_answer, q_type, mark FROM log{$this->paper_type}, questions WHERE log{$this->paper_type}.q_id = questions.q_id AND metadataID IN (" . implode(',', $metadataids) . ")");
     } else {
         $result = $this->db->prepare("SELECT log{$this->paper_type}.id, metadataID, {$this->paper_type} AS paper_type, questions.q_id, screen, duration, user_answer, q_type, mark FROM log{$this->paper_type}, questions WHERE log{$this->paper_type}.q_id = questions.q_id AND metadataID IN (" . implode(',', $metadataids) . ") ORDER BY metadataID, screen");
     }
     $result->execute();
     $result->bind_result($log_id, $metadataID, $paper_type, $q_id, $screen, $duration, $user_answer, $q_type, $mark);
     while ($result->fetch()) {
         $userID = $this->user_results[$metadataID]['userID'];
         if ($this->repmodule != '' and !isset($this->user_modules[$userID]['idMod'])) {
             continue;
             // This user is not on the module set in repmodule so don't put them in the array.
         }
         // We have passed the check this students should be displayed.
         $this->user_results[$metadataID]['visible'] = true;
         if ($old_screen != $screen or $old_metadataID != $metadataID) {
             $user_duration += $old_duration;
         }
         if ($old_metadataID != $metadataID and $old_metadataID != 0) {
             if (isset($this->user_modules[$userID]['idMod'])) {
                 $this->user_results[$metadataID]['module'] = $this->user_modules[$userID]['idMod'];
             } else {
                 // No module details set for this user.  Perhaps it is an unassigned guest user account.
                 $this->user_results[$metadataID]['module'] = '';
             }
             // Write the user results for the user that was iterated over previously using $old_metadataID
             $this->writeUserResults($old_metadataID, $tmp_mark, $tmp_user_mark_array, $user_duration, $marking_complete);
             $tmp_mark = 0;
             $tmp_user_mark_array = array();
             $user_duration = 0;
             $marking_complete = 1;
         } else {
             if (!$old_metadataID) {
                 // This is the first record being iterated over so $old_metadataID is set to 0.
                 if (isset($this->user_modules[$userID]['idMod'])) {
                     $this->user_results[$metadataID]['module'] = $this->user_modules[$userID]['idMod'];
                 } else {
                     // No module details set for this user.  Perhaps it is an unassigned guest user account.
                     $this->user_results[$metadataID]['module'] = '';
                 }
             }
         }
         $this->user_results[$metadataID]['questions']++;
         $this->user_results[$metadataID]['paper_type'] = $paper_type;
         $single_mark = $this->getUserMark($q_id, $userID, $user_answer, $mark, $tmp_user_mark_array);
         $tmp_mark += $single_mark;
         if ($q_type == 'textbox' and !is_numeric($mark)) {
             $this->unmarked_textbox = true;
             $marking_complete = 0;
         }
         if ($q_type == 'enhancedcalc' and !is_numeric($mark)) {
             $this->unmarked_enhancedcalc = true;
             $marking_complete = 0;
         }
         $old_duration = $duration;
         $old_screen = $screen;
         $old_metadataID = $metadataID;
         $log_data[$i]['paper_type'] = $paper_type;
         $log_data[$i]['adjmark'] = $single_mark;
         $log_data[$i]['id'] = $log_id;
         $i++;
     }
     $result->close();
     if ($old_metadataID != 0) {
         if ($this->repmodule == '' or isset($this->user_modules[$userID]['idMod']) and $this->user_modules[$userID]['idMod'] == $this->repmodule) {
             $user_duration += $old_duration;
             $this->writeUserResults($old_metadataID, $tmp_mark, $tmp_user_mark_array, $user_duration, $marking_complete);
         }
     }
     // Re-index the array.
     $tmp_array = $this->user_results;
     unset($this->user_results);
     $i = 0;
     foreach ($tmp_array as $metID => $row) {
         $this->user_results[$i] = $row;
         $i++;
     }
     if ($this->recache and count($log_data) > 0) {
         $this->db->autocommit(false);
         $log_query = $this->db->prepare("UPDATE log{$paper_type} SET adjmark = ? WHERE id = ?");
         foreach ($log_data as $individual_log_data) {
             $paper_type = $individual_log_data['paper_type'];
             $adjmark = $individual_log_data['adjmark'];
             $log_id = $individual_log_data['id'];
             $log_query->bind_param('di', $adjmark, $log_id);
             $log_query->execute();
         }
         $log_query->close();
         $this->db->commit();
         $this->db->autocommit(true);
     }
 }
コード例 #8
0
ファイル: finish.php プロジェクト: vinod-co/centa
    $temp_userID = $userObject->get_user_ID();
    $tmp_title = $userObject->get_title();
    $tmp_initials = $userObject->get_initials();
    $tmp_surname = $userObject->get_surname();
    $tmp_student_id = '';
}
$old_q_id = 0;
$old_screen = 0;
if (!isset($_GET['q_id'])) {
    echo $top_table_html;
    echo '<tr><td><div class="paper">' . $paper_title . '</div>';
    if ($userObject->has_role('External Examiner')) {
        echo '<span style="margin-left:5px; font-size:90%; color:white; font-weight:bold">' . $string['student'] . ' ' . $tmp_student_id . '</span>';
    } elseif ($paper_type < 2 or $userObject->has_role(array('Staff', 'Admin', 'SysAdmin', 'External Examiner'))) {
        echo '<span style="margin-left:5px; font-size:90%; color:white; font-weight:bold">' . $string['answersscreen'];
        $tmp_student_name = $tmp_title . ' ' . demo_replace($tmp_surname, $demo) . ', ' . demo_replace($tmp_initials, $demo);
        $tmp_student_id = demo_replace_number($tmp_student_id, $demo);
        echo ' ' . $tmp_student_name;
        if ($tmp_student_id != '') {
            echo " ({$tmp_student_id})";
        }
        echo '</span>';
    }
    echo '</td>';
    echo $logo_html;
    echo '</table>';
}
// Get any marking override for the paper
$overrides = array();
$sql = "SELECT m.q_id, title, surname, date_marked, new_mark_type, adjmark\n          FROM marking_override m INNER JOIN users u ON m.marker_id = u.id\n          INNER JOIN log{$log_type} l ON m.log_id = l.id\n          WHERE user_id = ? AND paper_id = ?";
$result = $mysqli->prepare($sql);