public function events()
{
if (!env('student')) {
redirect('m=login');
}
$updisciplineId = val($_REQUEST, 'updisciplineId');
$learningMode = val($_REQUEST, 'learningMode');
if (empty($updisciplineId) || empty($learningMode)) {
throw new Exception('Missed required param', 404);
}
$updiscipline = entry_sql('SELECT * FROM updiscipline WHERE updisciplineId=:updisciplineId', array(':updisciplineId' => $updisciplineId));
if (empty($updiscipline)) {
throw new Exception('Updiscipline not found', 404);
}
$groupPeriod = entry_sql('SELECT gp.* FROM group_history gh INNER JOIN group_period gp USING(groupPeriodId) WHERE gh.studentId=:studentId AND gp.sersemester=:sersemester', array('studentId' => studentId(), 'sersemester' => $updiscipline['sersemester']));
if (empty($groupPeriod)) {
throw new Exception('Cannot detect groupPeriod', 404);
}
$events = entries_sql('SELECT * FROM event WHERE updisciplineId=:updisciplineId AND groupPeriodId=:groupPeriodId AND learningMode=:learningMode', array('groupPeriodId' => $groupPeriod['groupPeriodId'], 'updisciplineId' => $updiscipline['updisciplineId'], 'learningMode' => $learningMode));
array_walk($events, function (&$event, $k, $studentId) {
$event['c'] = material::i($event['instanceType'])->c();
$event['grade'] = material::i($event['instanceType'])->get_grade($event['instanceId'], $studentId);
}, studentId());
env('breadcrumbs', array(array(lng('up:disciplines'), '/?c=up'), array($updiscipline['disciplineName'], '/?c=up&m=events&updisciplineId=' . $updisciplineId . '&learningMode=' . $learningMode), lng('up:events')));
tpl('up/events', array('updiscipline' => $updiscipline, 'events' => $events, 'result' => entry_sql('SELECT * FROM result WHERE studentId=:studentId AND updisciplineId=:updisciplineId AND learningMode=:learningMode', array('studentId' => studentId(), 'updisciplineId' => $updiscipline['updisciplineId'], 'learningMode' => $learningMode))));
}
function entry_sql($query, $params)
{
$entries = entries_sql($query, $params);
if (count($entries) > 1) {
throw new Exception('DB error: fetched more than one row in query "' . $query . '"');
}
return reset($entries);
}
public function finishAttempt($quizAttemptId)
{
$qsessarr = entries_sql('SELECT * FROM question_session WHERE quizAttemptId=:quizAttemptId', array('quizAttemptId' => $quizAttemptId));
$maxGrade = 0;
$gotGrade = 0;
foreach ($qsessarr as $qsess) {
$q = entry_sql('SELECT * FROM question WHERE questionId=:questionId', array('questionId' => $qsess['questionId']));
$maxGrade += $q['maxGrade'];
$gotGrade += $qsess['grade'];
}
$attemptCoef = empty($maxGrade) ? 1 : $gotGrade / $maxGrade;
return entry_change('quiz_attempt', array('status' => STATUS_COMPLETE, 'grade' => $attemptCoef, 'timeChange' => date('Y-m-d H:i:s'), 'timeFinish' => date('Y-m-d H:i:s')), array('quizAttemptId' => $quizAttemptId));
}
<?php
trigger_reg('material.graded', function ($codeOrName, $id, $studentId) {
global $CFG;
$code = is_numeric($codeOrName) ? $codeOrName : array_search($codeOrName, $CFG->material);
if (!is_numeric($code)) {
throw new Exception('Cannot detect meterial type of "' . $codeOrName . '"', 500);
}
$updisciplines = entries_sql('SELECT ud.*,e.groupPeriodId,e.learningMode FROM event e, updiscipline ud, group_period gp, group_history gh
WHERE e.updisciplineId=ud.updisciplineId AND ud.upId=gp.upId AND gp.groupPeriodId=gh.groupPeriodId AND e.instanceType=:type AND e.instanceId=:id AND gh.studentId=:studentId', array('type' => $code, 'id' => $id, 'studentId' => $studentId));
foreach ($updisciplines as $upd) {
$events = entries_sql('SELECT * FROM event WHERE updisciplineId=:updisciplineId AND groupPeriodId=:groupPeriodId AND learningMode=:learningMode', array('groupPeriodId' => $upd['groupPeriodId'], 'updisciplineId' => $upd['updisciplineId'], 'learningMode' => $upd['learningMode']));
$result = array_reduce($events, function ($r, $e) {
$r['sum'] += $e['weight'];
$r['got'] += $e['weight'] * val(material::i($e['instanceType'])->get_grade($e['instanceId'], $r['studentId']), 'coef', 0);
return $r;
}, array('studentId' => $studentId, 'sum' => 0, 'got' => 0));
if (empty($result['sum'])) {
continue;
}
entry_change('result', array('grade' => $result['got'] / $result['sum'] * 100), array('studentId' => $studentId, 'updisciplineId' => $upd['updisciplineId'], 'learningMode' => $upd['learningMode']));
}
});
public function attempt()
{
if (!env('student')) {
redirect('m=login');
}
$quizId = val($_REQUEST, 'id', -1);
$attemptId = val($_REQUEST, 'attemptId', -1);
$page = val($_REQUEST, 'page', 1);
$complete = val($_REQUEST, 'complete');
$pro = val($_REQUEST, 'pro');
if (!empty($pro)) {
env('modepro', true);
}
$now = date('Y-m-d H:i:s');
if (val(env('event'), 'instanceId') != $quizId) {
throw new Exception('Cannot fetch event', 404);
}
$quiz = entry_sql('SELECT * FROM quiz WHERE quizId=:quizId', array('quizId' => $quizId));
if (empty($quiz)) {
throw new Exception('Cannot find quiz "' . $id . '"', 404);
}
if ($attemptId == 0) {
// create new attempt
$attemptId = material::i('quiz')->startAttempt($quiz);
redirect('c=quiz&m=attempt&id=' . $quizId . '&attemptId=' . $attemptId);
}
$attempt = entry_sql('SELECT * FROM quiz_attempt WHERE quizAttemptId=:quizAttemptId AND quizId=:quizId AND studentId=:studentId', array('quizAttemptId' => $attemptId, 'quizId' => $quizId, 'studentId' => studentId()));
if (empty($attempt)) {
throw new Exception('Attempt "' . $attemptId . '" not found', 404);
}
if ($attempt['status'] != STATUS_INPROC) {
throw new Exception('Attempt is not available anymore', 403);
}
if (!empty($quiz['timeLimit']) && date('Y-m-d H:i:s', strtotime($attempt['timeStart']) + $quiz['timeLimit']) < $now) {
// if time expired
material::i('quiz')->finishAttempt($attemptId);
redirect('c=quiz&id=' . $quiz['quizId'] . '&eventId=' . val(env('event'), 'eventId'));
}
$questions = entries_sql('SELECT * FROM question_session WHERE quizAttemptId=:quizAttemptId ORDER BY num', array('quizAttemptId' => $attemptId));
$perpage = 1;
$numl = $page * $perpage;
$numf = $numl - $perpage;
$qresponses = val($_REQUEST, 'question', array());
foreach ($questions as &$qsess) {
$qobj = question::i($qsess['questionId']);
$qresponse = val($qresponses, $qsess['questionId']);
if (!empty($qresponse)) {
$qgrade = $qobj->get_grade($qresponse);
$qsess['grade'] = $qobj->get_grade($qresponse);
$qsess['response'] = json_encode($qresponse);
$qsess['status'] = STATUS_ANSWER;
entry_change('question_session', $qsess, array('questionSessionId' => $qsess['questionSessionId']));
entry_change('quiz_attempt', array('timeChange' => date('Y-m-d H:i:s')), array('quizAttemptId' => $attemptId));
}
if ($qsess['num'] > $numf && $qsess['num'] <= $numl) {
// render only questions of the page
$qsess['qhtml'] = $qobj->render(json_decode($qsess['response']));
}
$qsess['page'] = ceil($qsess['num'] / $perpage);
}
env('breadcrumbs', array_merge($this->_up_breadcrumbs(env('event')), array(lng('quiz:attempt'))));
if (!empty($complete)) {
material::i('quiz')->finishAttempt($attemptId);
trigger_exe('material.graded', array('quiz', $quizId, studentId()));
redirect('c=quiz&id=' . $quiz['quizId'] . '&eventId=' . val(env('event'), 'eventId'));
}
tpl('quiz/attempt', array('page' => $page, 'quiz' => $quiz, 'attempt' => $attempt, 'questions' => $questions));
}