$chart->growWithPoint(key($point), $newp); next($point); } } else { //show chart for a specific course $cid = course_code_to_id($u_course_id); $result = Database::get()->queryArray("SELECT " . $date_what . " SUM(hits) AS cnt FROM actions_daily WHERE course_id = $cid AND $date_where $date_group ORDER BY day ASC"); $chart = new Plotter(); $chart->setTitle($langVisits); switch ($u_interval) { case "summary": foreach ($result as $$row) { $chart->growWithPoint($langSummary, $row->cnt); } break; case "daily": foreach ($result as $$row) { $chart->growWithPoint($row->date, $row->cnt); } break; case "weekly": foreach ($result as $$row) { $chart->growWithPoint($row->week_start . ' - ' . $row->week_end, $row->cnt); } break; case "monthly": foreach ($result as $$row) { $chart->growWithPoint($langMonths[$row->month], $row->cnt);
} $chart_error = $langNoStatistics; break; case "duration": $chart = new Plotter(400, 300); $chart->setTitle($langFavourite); $result = Database::get()->queryArray("SELECT module_id, SUM(duration) AS tot_dur FROM actions_daily WHERE $date_where $user_where AND course_id = ?d AND module_id > 0 GROUP BY module_id", $terms, $course_id); foreach ($result as $row) { $mid = $row->module_id; if ($mid == MODULE_ID_UNITS) { // course inits $chart->growWithPoint($langCourseUnits, $row->tot_dur); } else { // other modules $chart->growWithPoint($modules[$mid]['title'], $row->tot_dur); } } $chart_error = $langDurationExpl; break; } if (isset($_POST['btnUsage'])) { $chart->normalize(); $tool_content .= $chart->plot($chart_error); } $letterlinks = ''; $result = Database::get()->queryArray("SELECT LEFT(a.surname, 1) AS first_letter
$date_where = " (start_date BETWEEN '$u_date_start' AND '$u_date_end') "; $query = "SELECT MONTH(start_date) AS month, YEAR(start_date) AS year, SUM(login_sum) AS visits FROM loginout_summary WHERE $date_where GROUP BY MONTH(start_date)"; $result = Database::get()->queryArray($query); if (count($result) > 0) { $chart = new Plotter(); $chart->setTitle($langOldStats); //add points to chart foreach ($result as $row) { $mont = $langMonths[$row->month]; $chart->growWithPoint($mont . " - " . $row->year, $row->visits); } $tool_content .= "<p>" . $langVisits . "</p>" . $chart->plot(); } else { $tool_content .= "<div class='alert alert-warning'>$langNoStatistics</div>"; } $tool_content .= '<div class="form-wrapper"><form class="form-horizontal" role="form" method="post">'; $tool_content .= "<div class='input-append date form-group' id='user_date_start' data-date = '" . q($user_date_start) . "' data-date-format='dd-mm-yyyy'> <label class='col-sm-2 control-label'>$langStartDate:</label> <div class='col-xs-10 col-sm-9'> <input class='form-control' name='user_date_start' type='text' value = '" . q($user_date_start) . "'> </div> <div class='col-xs-2 col-sm-1'> <span class='add-on'><i class='fa fa-times'></i></span> <span class='add-on'><i class='fa fa-calendar'></i></span>
function show_assignment($id, $display_graph_results = false) { global $tool_content, $m, $langBack, $langNoSubmissions, $langSubmissions, $langEndDeadline, $langWEndDeadline, $langNEndDeadline, $langDays, $langDaysLeft, $langGradeOk, $course_code, $webDir, $urlServer, $langGraphResults, $m, $course_code, $themeimg, $works_url, $course_id, $langDelWarnUserAssignment, $langAutoJudgeShowWorkResultRpt; $row = Database::get()->querySingle("SELECT *, CAST(UNIX_TIMESTAMP(deadline)-UNIX_TIMESTAMP(NOW()) AS SIGNED) AS time\n FROM assignment\n WHERE course_id = ?d AND id = ?d", $course_id, $id); $nav[] = $works_url; assignment_details($id, $row); $rev = @($_REQUEST['rev'] == 1) ? ' DESC' : ''; if (isset($_REQUEST['sort'])) { if ($_REQUEST['sort'] == 'am') { $order = 'am'; } elseif ($_REQUEST['sort'] == 'date') { $order = 'submission_date'; } elseif ($_REQUEST['sort'] == 'grade') { $order = 'grade'; } elseif ($_REQUEST['sort'] == 'filename') { $order = 'file_name'; } else { $order = 'surname'; } } else { $order = 'surname'; } $result = Database::get()->queryArray("SELECT * FROM assignment_submit AS assign, user\n WHERE assign.assignment_id = ?d AND user.id = assign.uid\n ORDER BY ?s ?s", $id, $order, $rev); $num_results = count($result); if ($num_results > 0) { if ($num_results == 1) { $num_of_submissions = $m['one_submission']; } else { $num_of_submissions = sprintf("{$m['more_submissions']}", $num_results); } $gradeOccurances = array(); // Named array to hold grade occurances/stats $gradesExists = 0; foreach ($result as $row) { $theGrade = $row->grade; if ($theGrade) { $gradesExists = 1; if (!isset($gradeOccurances[$theGrade])) { $gradeOccurances[$theGrade] = 1; } else { if ($gradesExists) { ++$gradeOccurances[$theGrade]; } } } } if (!$display_graph_results) { $result = Database::get()->queryArray("SELECT assign.id id, assign.file_name file_name,\n assign.uid uid, assign.group_id group_id,\n assign.submission_date submission_date,\n assign.grade_submission_date grade_submission_date,\n assign.grade grade, assign.comments comments,\n assign.grade_comments grade_comments,\n assignment.deadline deadline\n FROM assignment_submit AS assign, user, assignment\n WHERE assign.assignment_id = ?d AND assign.assignment_id = assignment.id AND user.id = assign.uid\n ORDER BY ?s ?s", $id, $order, $rev); $tool_content .= "\n <form action='{$_SERVER['SCRIPT_NAME']}?course={$course_code}' method='post'>\n <input type='hidden' name='grades_id' value='{$id}' />\n <p><div class='sub_title1'>{$langSubmissions}:</div><p>\n <p>{$num_of_submissions}</p>\n <table width='100%' class='sortable'>\n <tr>\n <th width='3'> </th>"; sort_link($m['username'], 'username'); sort_link($m['am'], 'am'); sort_link($m['filename'], 'filename'); sort_link($m['sub_date'], 'date'); sort_link($m['grade'], 'grade'); $tool_content .= "</tr>"; $i = 1; foreach ($result as $row) { //is it a group assignment? if (!empty($row->group_id)) { $subContentGroup = "{$m['groupsubmit']} " . "<a href='../group/group_space.php?course={$course_code}&group_id={$row->group_id}'>" . "{$m['ofgroup']} " . gid_to_name($row->group_id) . "</a>"; } else { $subContentGroup = ''; } $uid_2_name = display_user($row->uid); $stud_am = Database::get()->querySingle("SELECT am FROM user WHERE id = ?d", $row->uid)->am; if ($i % 2 == 1) { $row_color = "class='even'"; } else { $row_color = "class='odd'"; } $filelink = empty($row->file_name) ? ' ' : "<a href='{$_SERVER['SCRIPT_NAME']}?course={$course_code}&get={$row->id}'>" . q($row->file_name) . "</a>"; $late_sub_text = (int) $row->deadline && $row->submission_date > $row->deadline ? '<div style="color:red;">$m[late_submission]</div>' : ''; $tool_content .= "\n <tr {$row_color}>\n <td align='right' width='4' rowspan='2' valign='top'>{$i}.</td>\n <td>{$uid_2_name}</td>\n <td width='85'>" . q($stud_am) . "</td>\n <td width='180'>{$filelink}\n <a href='{$_SERVER['SCRIPT_NAME']}?course={$course_code}&id={$id}&as_id={$row->id}' onClick='return confirmation(\"{$langDelWarnUserAssignment}\");'>\n <img src='{$themeimg}/delete.png' title='{$m['WorkDelete']}' />\n </a>\n </td>\n <td width='100'>" . nice_format($row->submission_date, TRUE) . $late_sub_text . "</td>\n <td width='5'>\n <div align='center'><input type='text' value='{$row->grade}' maxlength='3' size='3' name='grades[{$row->id}]'></div>\n </td>\n </tr>\n <tr {$row_color}>\n <td colspan='5'>\n <div>{$subContentGroup}</div>"; if (trim($row->comments != '')) { $tool_content .= "<div style='margin-top: .5em;'><b>{$m['comments']}:</b> " . q($row->comments) . '</div>'; } //professor comments $gradelink = "grade_edit.php?course={$course_code}&assignment={$id}&submission={$row->id}"; $reportlink = "work_result_rpt.php?course={$course_code}&assignment={$id}&submission={$row->id}"; if (trim($row->grade_comments)) { $label = $m['gradecomments'] . ':'; $icon = 'edit.png'; $comments = "<div class='smaller'>" . standard_text_escape($row->grade_comments) . "</div>"; } else { $label = $m['addgradecomments']; $icon = 'add.png'; $comments = ''; } if ($row->grade_comments || $row->grade != '') { $comments .= "<div class='smaller'><i>({$m['grade_comment_date']}: " . nice_format($row->grade_submission_date) . ")</i></div>"; } $tool_content .= "<div style='padding-top: .5em;'><a href='{$gradelink}'><b>{$label}</b></a>\n\t\t\t\t <a href='{$gradelink}'><img src='{$themeimg}/{$icon}'></a>\n\t\t\t\t {$comments}\n\t\t\t\t <a href='{$reportlink}'><b>{$langAutoJudgeShowWorkResultRpt}</b></a>\n </td>\n </tr>"; $i++; } //END of Foreach $tool_content .= "</table>\n <p class='smaller right'><img src='{$themeimg}/email.png' alt='' >\n {$m['email_users']}: <input type='checkbox' value='1' name='email'></p>\n <p><input class='btn btn-primary' type='submit' name='submit_grades' value='{$langGradeOk}'></p>\n </form>"; } else { // display pie chart with grades results if ($gradesExists) { // Used to display grades distribution chart $graded_submissions_count = Database::get()->querySingle("SELECT COUNT(*) AS count FROM assignment_submit AS assign, user\n WHERE assign.assignment_id = ?d AND user.id = assign.uid AND\n assign.grade <> ''", $id)->count; $chart = new Plotter(); $chart->setTitle("{$langGraphResults}"); foreach ($gradeOccurances as $gradeValue => $gradeOccurance) { $percentage = round(100.0 * $gradeOccurance / $graded_submissions_count, 2); $chart->growWithPoint("{$gradeValue} ({$percentage}%)", $percentage); } $tool_content .= $chart->plot(); } } } else { $tool_content .= "\n <p class='sub_title1'>{$langSubmissions}:</p>\n <div class='alert alert-warning'>{$langNoSubmissions}</div>"; } }
function show_assignment($id, $display_graph_results = false) { global $tool_content, $m, $langBack, $langNoSubmissions, $langSubmissions, $langEndDeadline, $langWEndDeadline, $langNEndDeadline, $langWorkOnlineText, $langDays, $langDaysLeft, $langGradeOk, $course_code, $webDir, $urlServer, $langGraphResults, $m, $course_code, $themeimg, $works_url, $course_id, $langDelWarnUserAssignment, $langQuestionView, $langDelete, $langEditChange, $langAutoJudgeShowWorkResultRpt; $assign = Database::get()->querySingle("SELECT *, CAST(UNIX_TIMESTAMP(deadline)-UNIX_TIMESTAMP(NOW()) AS SIGNED) AS time FROM assignment WHERE course_id = ?d AND id = ?d", $course_id, $id); $nav[] = $works_url; assignment_details($id, $assign); $rev = (@($_REQUEST['rev'] == 1)) ? 'DESC' : 'ASC'; if (isset($_REQUEST['sort'])) { if ($_REQUEST['sort'] == 'am') { $order = 'am'; } elseif ($_REQUEST['sort'] == 'date') { $order = 'submission_date'; } elseif ($_REQUEST['sort'] == 'grade') { $order = 'grade'; } elseif ($_REQUEST['sort'] == 'filename') { $order = 'file_name'; } else { $order = 'surname'; } } else { $order = 'surname'; } $result1 = Database::get()->queryArray("SELECT * FROM assignment_submit AS assign, user WHERE assign.assignment_id = ?d AND user.id = assign.uid ORDER BY ?s ?s", $id, $order, $rev); $num_results = count($result1); if ($num_results > 0) { if ($num_results == 1) { $num_of_submissions = $m['one_submission']; } else { $num_of_submissions = sprintf("$m[more_submissions]", $num_results); } $gradeOccurances = array(); // Named array to hold grade occurances/stats $gradesExists = 0; foreach ($result1 as $row) { $theGrade = $row->grade; if ($theGrade) { $gradesExists = 1; if (!isset($gradeOccurances[$theGrade])) { $gradeOccurances[$theGrade] = 1; } else { if ($gradesExists) { ++$gradeOccurances[$theGrade]; } } } } if (!$display_graph_results) { $result = Database::get()->queryArray("SELECT assign.id id, assign.file_name file_name, assign.uid uid, assign.group_id group_id, assign.submission_date submission_date, assign.grade_submission_date grade_submission_date, assign.grade grade, assign.comments comments, assign.grade_comments grade_comments, assignment.grading_scale_id grading_scale_id, assignment.deadline deadline FROM assignment_submit AS assign, user, assignment WHERE assign.assignment_id = ?d AND assign.assignment_id = assignment.id AND user.id = assign.uid ORDER BY $order $rev", $id); $tool_content .= " <form action='$_SERVER[SCRIPT_NAME]?course=$course_code' method='post' class='form-inline'> <input type='hidden' name='grades_id' value='$id' /> <br> <div class='margin-bottom-thin'> <b>$langSubmissions:</b> $num_results </div> <div class='table-responsive'> <table class='table-default'> <tbody> <tr class='list-header'> <th width='3'> </th>"; sort_link($m['username'], 'username'); sort_link($m['am'], 'am'); $assign->submission_type ? $tool_content .= "<th>$langWorkOnlineText</th>" : sort_link($m['filename'], 'filename'); sort_link($m['sub_date'], 'date'); sort_link($m['grade'], 'grade'); $tool_content .= "<th width='5%' class='text-center'><i class='fa fa-cogs'></i></th></tr>"; $i = 1; foreach ($result as $row) { //is it a group assignment? if (!empty($row->group_id)) { $subContentGroup = "$m[groupsubmit] " . "<a href='../group/group_space.php?course=$course_code&group_id=$row->group_id'>" . "$m[ofgroup] " . gid_to_name($row->group_id) . "</a>"; } else { $subContentGroup = ''; } $uid_2_name = display_user($row->uid); $stud_am = Database::get()->querySingle("SELECT am FROM user WHERE id = ?d", $row->uid)->am; if ($assign->submission_type) { $filelink = "<a href='#' class='onlineText btn btn-xs btn-default' data-id='$row->id'>$langQuestionView</a>"; } else { $filelink = empty($row->file_name) ? ' ' : ("<a href='$_SERVER[SCRIPT_NAME]?course=$course_code&get=$row->id'>" . q($row->file_name) . "</a>"); } if(Session::has("grades")) { $grades = Session::get('grades'); $grade = $grades[$row->id]['grade']; } else { $grade = $row->grade; } if ($row->grading_scale_id) { $serialized_scale_data = Database::get()->querySingle('SELECT scales FROM grading_scale WHERE id = ?d AND course_id = ?d', $row->grading_scale_id, $course_id)->scales; $scales = unserialize($serialized_scale_data); $scale_options = "<option value> - </option>"; $scale_values = array_value_recursive('scale_item_value', $scales); if (!in_array($grade, $scale_values) && !is_null($grade)) { $grade = closest($grade, $scale_values)['value']; } foreach ($scales as $scale) { $scale_options .= "<option value='$scale[scale_item_value]'".($scale['scale_item_value'] == $grade ? " selected" : "").">$scale[scale_item_name]</option>"; } $grade_field = " <select name='grades[$row->id][grade]' class='form-control' id='scales'> $scale_options </select>"; } else { $grade_field = "<input class='form-control' type='text' value='$grade' name='grades[$row->id][grade]' maxlength='4' size='3'>"; } $late_sub_text = $row->deadline && $row->submission_date > $row->deadline ? "<div style='color:red;'><small>$m[late_submission]</small></div>" : ''; $tool_content .= " <tr> <td align='right' width='4' rowspan='2' valign='top'>$i.</td> <td>${uid_2_name}</td> <td width='85'>" . q($stud_am) . "</td> <td class='text-center' width='180'> $filelink </td> <td width='100'>" . nice_format($row->submission_date, TRUE) .$late_sub_text. "</td> <td width='5'> <div class='form-group ".(Session::getError("grade.$row->id") ? "has-error" : "")."'> $grade_field <span class='help-block'>".Session::getError("grade.$row->id")."</span> </div> </td> <td class='option-btn-cell'>". action_button(array( array( 'title' => $langEditChange, 'url' => "grade_edit.php?course=$course_code&assignment=$id&submission=$row->id", 'level' => 'primary', 'icon' => 'fa-edit' ), array( 'title' => $langDelete, 'url' => "$_SERVER[SCRIPT_NAME]?course=$course_code&id=$id&as_id=$row->id", 'class' => 'delete', 'icon' => 'fa-times', 'confirm' => $langDelWarnUserAssignment ) ))." </td> </tr> <tr> <td colspan='6'> <div>$subContentGroup</div>"; if (trim($row->comments != '')) { $tool_content .= "<div style='margin-top: .5em;'>" . q($row->comments) . '</div>'; } //professor comments if ($row->grade_comments || $row->grade != '') { $comments = "<br><div class='label label-primary'>" . nice_format($row->grade_submission_date) . "</div>"; } if (trim($row->grade_comments)) { $label = '<b>'.$m['gradecomments'] . '</b>:'; $comments .= " <span>" . standard_text_escape($row->grade_comments) . "</span>"; } else { $label = ''; $comments = ''; } $tool_content .= "<div style='padding-top: .5em;'>$label $comments "; if(AutojudgeApp::getAutojudge()->isEnabled()) { $reportlink = "work_result_rpt.php?course=$course_code&assignment=$id&submission=$row->id"; $tool_content .= "<a href='$reportlink'><b>$langAutoJudgeShowWorkResultRpt</b></a>"; } $tool_content .= " </td> </tr>"; $i++; } //END of Foreach $tool_content .= " </tbody> </table> </div> <div class='form-group'> <div class='col-xs-12'> <div class='checkbox'> <label> <input type='checkbox' value='1' name='email'> $m[email_users] </label> </div> </div> </div> <div class='pull-right'> <button class='btn btn-primary' type='submit' name='submit_grades'>$langGradeOk</button> </div> </form>"; } else { // display pie chart with grades results if ($gradesExists) { // Used to display grades distribution chart $graded_submissions_count = Database::get()->querySingle("SELECT COUNT(*) AS count FROM assignment_submit AS assign, user WHERE assign.assignment_id = ?d AND user.id = assign.uid AND assign.grade <> ''", $id)->count; $chart = new Plotter(); $chart->setTitle("$langGraphResults"); if ($assign->grading_scale_id) { $serialized_scale_data = Database::get()->querySingle('SELECT scales FROM grading_scale WHERE id = ?d AND course_id = ?d', $assign->grading_scale_id, $course_id)->scales; $scales = unserialize($serialized_scale_data); $scale_values = array_value_recursive('scale_item_value', $scales); } foreach ($gradeOccurances as $gradeValue => $gradeOccurance) { $percentage = round((100.0 * $gradeOccurance / $graded_submissions_count),2); if ($assign->grading_scale_id) { $key = closest($gradeValue, $scale_values, true)['key']; $gradeValue = $scales[$key]['scale_item_name']; } $chart->growWithPoint("$gradeValue ($percentage%)", $percentage); } $tool_content .= $chart->plot(); } } } else { $tool_content .= " <p class='sub_title1'>$langSubmissions:</p> <div class='alert alert-warning'>$langNoSubmissions</div>"; } }
} $course_code_result = null; foreach ($course_codes as $code) { Database::get()->queryFunc("SELECT SUM(hits) AS cnt FROM actions_daily WHERE user_id = ?d AND course_id =?d", function($row) use (&$totalHits, &$hits, $code) { $totalHits += $row->cnt; $hits[$code] = $row->cnt; }, $u, course_code_to_id($code)); } } $tool_content .= "<b>$totalHits</b></p>"; $chart = new Plotter(220, 200); $chart->setTitle($langCourseVisits); foreach ($hits as $code => $count) { $chart->growWithPoint(q($course_names[$code]), $count); } $tool_content .= $chart->plot(); // End of chart display; chart unlinked at end of script. $tool_content .= "<p>$langLastUserVisits " . q($info) . "</p>"; $tool_content .= "<div class='table-responsive'><table class='table-default'> <tr> <th class='text-left'> $langDate</th> <th class='text-center'>$langAction</th> </tr>"; $Action["LOGIN"] = "******"; $Action["LOGOUT"] = "<font color='#FF0000'>$langLogout</font>"; Database::get()->queryFunc("SELECT * FROM loginout WHERE id_user = '******' ORDER by idLog DESC LIMIT 15", function($r) use (&$i, &$tool_content, $Action) { $when = $r->when; $action = $r->action;