mod/workshop/view.php

   1 <?php  // $Id$
   2
   3 /*************************************************
   4     ACTIONS handled are:
   5
   6     displayfinalgrade (for students)
   7     notavailable (for students)
   8     studentsview
   9     submitexample
  10     teachersview
  11     showdescription
  12     showallsubmissions
  13
  14 ************************************************/
  15
  16     require("../../config.php");
  17     require("lib.php");
  18     require("locallib.php");
  19
  20     $id     = required_param('id', PARAM_INT);    // Course Module ID
  21     $action = optional_param('action', '', PARAM_ALPHA);
  22     $sort   = optional_param('sort', 'lastname', PARAM_ALPHA);
  23     $dir    = optional_param('dir', 'ASC', PARAM_ALPHA);
  24
  25     $timenow = time();
  26
  27     // get some useful stuff...
  28     if (! $cm = get_coursemodule_from_id('workshop', $id)) {
  29         error("Course Module ID was incorrect");
  30     }
  31     if (! $course = get_record("course", "id", $cm->course)) {
  32         error("Course is misconfigured");
  33     }
  34     if (! $workshop = get_record("workshop", "id", $cm->instance)) {
  35         error("Course module is incorrect");
  36     }
  37
  38     require_login($course->id, false, $cm);
  39     $context = get_context_instance(CONTEXT_MODULE, $cm->id);
  40
  41     $strworkshops = get_string("modulenameplural", "workshop");
  42     $strworkshop  = get_string("modulename", "workshop");
  43     $straction = ($action) ? '-> '.get_string($action, 'workshop') : '';
  44
  45     // ...and if necessary set default action
  46     if (workshop_is_teacher($workshop)) {
  47         if (empty($action)) { // no action specified, either go straight to elements page else the admin page
  48             // has the assignment any elements
  49             if (count_records("workshop_elements", "workshopid", $workshop->id) >= $workshop->nelements) {
  50                 $action = "teachersview";
  51             }
  52             else {
  53                 redirect("assessments.php?action=editelements&id=$cm->id");
  54             }
  55         }
  56     } else { // it's a student then
  57         if (!$cm->visible) {
  58             notice(get_string("activityiscurrentlyhidden"));
  59         }
  60         if ($timenow < $workshop->submissionstart) {
  61             $action = 'notavailable';
  62         } else if (!$action) {
  63             if ($timenow < $workshop->assessmentend) {
  64                 $action = 'studentsview';
  65             } else {
  66                 $action = 'displayfinalgrade';
  67             }
  68         }
  69     }
  70
  71     // ...display header...
  72     $navlinks = array();
  73     $navlinks[] = array('name' => $strworkshops, 'link' => "index.php?id=$course->id", 'type' => 'activity');
  74     $navlinks[] = array('name' => format_string($workshop->name,true), 'link' => "view.php?id=$cm->id", 'type' => 'activityinstance');
  75     if ($straction) {
  76         $navlinks[] = array('name' => $straction, 'link' => '', 'type' => 'title');
  77     }
  78     $navigation = build_navigation($navlinks);
  79
  80     print_header_simple(format_string($workshop->name), "", $navigation,
  81                   "", "", true, update_module_button($cm->id, $course->id, $strworkshop), navmenu($course, $cm));
  82
  83
  84     // ...log activity...
  85     add_to_log($course->id, "workshop", "view", "view.php?id=$cm->id", $workshop->id, $cm->id);
  86
  87     if ($action == 'studentsview' and !workshop_is_student($workshop)) {
  88         $action = 'showdescription';
  89     }
  90
  91     /****************** display final grade (for students) ************************************/
  92     if ($action == 'displayfinalgrade' ) {
  93         require_capability('mod/workshop:participate', $context);
  94
  95         print_heading("<b><a href=\"view.php?id=$cm->id&amp;action=showdescription\">".
  96                 get_string("showdescription", 'workshop')."</a></b>");
  97         // show the final grades as stored in the tables...
  98         if ($submissions = workshop_get_user_submissions($workshop, $USER)) { // any submissions from user?
  99             print_heading(get_string("displayoffinalgrades", "workshop"));
 100             echo "<div class=\"boxaligncenter\"><table border=\"1\" width=\"90%\"><tr>";
 101             echo "<td><b>".get_string("submissions", "workshop")."</b></td>";
 102             if ($workshop->wtype) {
 103                 echo "<td align=\"center\"><b>".get_string("assessmentsdone", "workshop")."</b></td>";
 104                 echo "<td align=\"center\"><b>".get_string("gradeforassessments", "workshop")."</b></td>";
 105             }
 106             echo "<td align=\"center\"><b>".get_string("teacherassessments", "workshop",
 107                         $course->teacher)."</b></td>";
 108             if ($workshop->wtype) {
 109                 echo "<td align=\"center\"><b>".get_string("studentassessments", "workshop",
 110                         $course->student)."</b></td>";
 111             }
 112             echo "<td align=\"center\"><b>".get_string("gradeforsubmission", "workshop")."</b></td>";
 113             echo "<td align=\"center\"><b>".get_string("overallgrade", "workshop")."</b></td></tr>\n";
 114             foreach ($submissions as $submission) {
 115                 $grade = workshop_submission_grade($workshop, $submission);
 116                 echo "<tr><td>".workshop_print_submission_title($workshop, $submission)."</td>\n";
 117                 if ($workshop->wtype) {
 118                     echo "<td align=\"center\">".workshop_print_user_assessments($workshop, $USER, $gradinggrade)."</td>";
 119                     echo "<td align=\"center\">$gradinggrade</td>";
 120                 }
 121                 echo "<td align=\"center\">".workshop_print_submission_assessments($workshop,
 122                             $submission, "teacher")."</td>";
 123                 if ($workshop->wtype) {
 124                     echo "<td align=\"center\">".workshop_print_submission_assessments($workshop,
 125                             $submission, "student")."</td>";
 126                 }
 127                 echo "<td align=\"center\">$grade</td>";
 128                 echo "<td align=\"center\">".number_format($gradinggrade + $grade, 1)."</td></tr>\n";
 129             }
 130             echo "</table></div><br clear=\"all\" />\n";
 131             workshop_print_key($workshop);
 132         } else {
 133             print_heading(get_string('nowork', 'workshop'));
 134         }
 135         if ($workshop->showleaguetable) {
 136             workshop_print_league_table($workshop);
 137         }
 138     }
 139
 140
 141     /****************** assignment not available (for students)***********************/
 142     elseif ($action == 'notavailable') {
 143         print_heading(get_string("notavailable", "workshop"));
 144     }
 145
 146     /****************** student's view could be in 1 of 4 stages ***********************/
 147     elseif ($action == 'studentsview') {
 148         require_capability('mod/workshop:participate', $context);
 149
 150         // is a password needed?
 151         if ($workshop->usepassword) {
 152             $correctpass = false;
 153             if (isset($_POST['userpassword'])) {
 154                 if ($workshop->password == md5(trim($_POST['userpassword']))) {
 155                     $USER->workshoploggedin[$workshop->id] = true;
 156                     $correctpass = true;
 157                 }
 158             } elseif (isset($USER->workshoploggedin[$workshop->id])) {
 159                 $correctpass = true;
 160             }
 161
 162             if (!$correctpass) {
 163                 print_simple_box_start("center");
 164                 echo "<form id=\"password\" method=\"post\" action=\"view.php\">\n";
 165                 echo "<input type=\"hidden\" name=\"id\" value=\"$cm->id\" />\n";
 166                 echo "<table cellpadding=\"7px\">";
 167                 if (isset($_POST['userpassword'])) {
 168                     echo "<tr align=\"center\" style='color:#DF041E;'><td>".get_string("wrongpassword", "workshop").
 169                         "</td></tr>";
 170                 }
 171                 echo "<tr align=\"center\"><td>".get_string("passwordprotectedworkshop", "workshop", format_string($workshop->name)).
 172                     "</td></tr>";
 173                 echo "<tr align=\"center\"><td>".get_string("enterpassword", "workshop").
 174                     " <input type=\"password\" name=\"userpassword\" /></td></tr>";
 175
 176                 echo "<tr align=\"center\"><td>";
 177                 echo "<input type=\"button\" value=\"".get_string("cancel").
 178                     "\" onclick=\"parent.location='../../course/view.php?id=$course->id';\">  ";
 179                 echo "<input type=\"button\" value=\"".get_string("continue").
 180                     "\" onclick=\"document.password.submit();\" />";
 181                 echo "</td></tr></table>";
 182                 print_simple_box_end();
 183                 exit();
 184             }
 185         }
 186         workshop_print_assignment_info($workshop);
 187
 188         // if the student has not yet submitted show the full description
 189         if (!record_exists('workshop_submissions', 'workshopid', $workshop->id, 'userid', $USER->id)) {
 190             print_box(format_text($workshop->description, $workshop->format), 'generalbox', 'intro');
 191         } else {
 192             print_heading("<b><a href=\"view.php?id=$cm->id&amp;action=showdescription\">".
 193                 get_string("showdescription", 'workshop')."</a></b>");
 194         }
 195
 196         // in Stage 1? - are there any teacher's submissions? and...
 197         // ...has student assessed the required number of the teacher's submissions
 198         if ($workshop->ntassessments and (!workshop_test_user_assessments($workshop, $USER))) {
 199             print_heading(get_string("pleaseassesstheseexamplesfromtheteacher", "workshop",
 200                         $course->teacher));
 201             workshop_list_teacher_submissions($workshop, $USER);
 202         }
 203         // in stage 2? - submit own first attempt
 204         else {
 205             if ($workshop->ntassessments) {
 206                 // show assessment of the teacher's examples, there may be feedback from teacher
 207                 print_heading(get_string("yourassessmentsofexamplesfromtheteacher", "workshop",
 208                             $course->teacher));
 209                 workshop_list_teacher_submissions($workshop, $USER);
 210             }
 211             // has user submitted anything yet?
 212             if (!workshop_get_user_submissions($workshop, $USER)) {
 213                 if ($timenow < $workshop->submissionend) {
 214                     // print upload form
 215                     print_heading(get_string("submitassignmentusingform", "workshop").":");
 216                     workshop_print_upload_form($workshop);
 217                 } else {
 218                     print_heading(get_string("submissionsnolongerallowed", "workshop"));
 219                 }
 220             }
 221             // in stage 3? - grade other student's submissions, resubmit and list all submissions
 222             else {
 223                 // is self assessment used in this workshop?
 224                 if ($workshop->includeself) {
 225                     // prints a table if there are any submissions which have not been self assessed yet
 226                     workshop_list_self_assessments($workshop, $USER);
 227                 }
 228                 // if peer assessments are being done then show some  to assess...
 229                 if ($workshop->nsassessments and ($workshop->assessmentstart < $timenow and $workshop->assessmentend > $timenow)) {
 230                     workshop_list_student_submissions($workshop, $USER);
 231                 }
 232                 // ..and any they have already done (and have gone cold)...
 233                 if (workshop_count_user_assessments($workshop, $USER, "student")) {
 234                     print_heading(get_string("yourassessments", "workshop"));
 235                     workshop_list_assessed_submissions($workshop, $USER);
 236                 }
 237                 // list any assessments by teachers
 238                 if (workshop_count_teacher_assessments_by_user($workshop, $USER) and ($timenow > $workshop->releasegrades)) {
 239                     print_heading(get_string("assessmentsby", "workshop", $course->teachers));
 240                     workshop_list_teacher_assessments_by_user($workshop, $USER);
 241                 }
 242                 // ... and show peer assessments
 243                 if (workshop_count_peer_assessments($workshop, $USER)) {
 244                     print_heading(get_string("assessmentsby", "workshop", $course->students));
 245                     workshop_list_peer_assessments($workshop, $USER);
 246                 }
 247                 // list previous submissions
 248                 print_heading(get_string("yoursubmissions", "workshop"));
 249                 workshop_list_user_submissions($workshop, $USER);
 250
 251                 // are resubmissions allowed and the workshop is in submission/assessment phase?
 252                 if ($workshop->resubmit and ($timenow > $workshop->assessmentstart and $timenow < $workshop->submissionend)) {
 253                     // see if there are any cold assessments of the last submission
 254                     // if there are then print upload form
 255                     if ($submissions = workshop_get_user_submissions($workshop, $USER)) {
 256                         foreach ($submissions as $submission) {
 257                             $lastsubmission = $submission;
 258                             break;
 259                         }
 260                         $n = 0; // number of cold assessments (not include self assessments)
 261                         if ($assessments = workshop_get_assessments($lastsubmission)) {
 262                             foreach ($assessments as $assessment) {
 263                                 if ($assessment->userid <> $USER->id) {
 264                                     $n++;
 265                                 }
 266                             }
 267                         }
 268                         if ($n) {
 269                             echo "<hr size=\"1\" noshade=\"noshade\" />";
 270                             print_heading(get_string("submitrevisedassignment", "workshop").":");
 271                             workshop_print_upload_form($workshop);
 272                             echo "<hr size=\"1\" noshade=\"noshade\" />";
 273                         }
 274                     }
 275                 }
 276             }
 277         }
 278     }
 279
 280
 281     /****************** submission of example by teacher only***********************/
 282     elseif ($action == 'submitexample') {
 283
 284         require_capability('mod/workshop:manage', $context);
 285
 286         // list previous submissions from teacher
 287         workshop_list_user_submissions($workshop, $USER);
 288
 289         echo "<hr size=\"1\" noshade=\"noshade\" />";
 290
 291         // print upload form
 292         print_heading(get_string("submitexampleassignment", "workshop").":");
 293         workshop_print_upload_form($workshop);
 294
 295         print_heading("<a $CFG->frametarget href=\"view.php?id=$cm->id\">".get_string("cancel")."</a>");
 296     }
 297
 298
 299     /****************** teacher's view - display admin page  ************/
 300     elseif ($action == 'teachersview') {
 301
 302         require_capability('mod/workshop:manage', $context);
 303
 304         // automatically grade assessments if workshop has examples and/or peer assessments
 305         if ($workshop->gradingstrategy and ($workshop->ntassessments or $workshop->nsassessments)) {
 306             workshop_grade_assessments($workshop);
 307         }
 308
 309         $context = get_context_instance(CONTEXT_MODULE, $cm->id);
 310
 311         /// find out current groups mode
 312         $groupmode = groups_get_activity_groupmode($cm);
 313         $currentgroup = groups_get_activity_group($cm, true);
 314         groups_print_activity_menu($cm, "view.php?id=$cm->id");
 315
 316         /// Print admin links
 317         echo "<table width=\"100%\"><tr><td>";
 318         echo "<a href=\"submissions.php?id=$cm->id&amp;action=adminlist\">".
 319             get_string("administration")."</a>\n";
 320
 321         echo '</td></tr>';
 322
 323         echo '<tr><td>';
 324         workshop_print_assignment_info($workshop);
 325         print_heading("<a href=\"view.php?id=$cm->id&amp;action=showdescription\">".
 326                get_string("showdescription", 'workshop')."</a>");
 327         echo '</td></tr>';
 328
 329         /// Print grade tables /////////////////////////////////////////////////
 330
 331         // display the teacher's submissions
 332         if ($workshop->ntassessments) {
 333             $table->head = array(get_string("examplesubmissions", "workshop"),
 334                 get_string("assessmentsby", "workshop", $course->teachers),
 335                 get_string("assessmentsby", "workshop", $course->students));
 336             $table->data = array();
 337             if ($submissions = workshop_get_teacher_submissions($workshop)) {
 338                 foreach ($submissions as $submission) {
 339                     $teacherassessments = workshop_print_submission_assessments($workshop, $submission, "teacher");
 340                     // If not yet assessed, show assess link
 341                     if ($teacherassessments == '&nbsp;') {
 342                         $teacherassessments = '<a href="assess.php?id='.
 343                             $cm->id.'&amp;sid='.$submission->id.'">'.get_string('assess', 'workshop').'</a>';
 344                     }
 345                     $title = workshop_print_submission_title($workshop, $submission).
 346                         " <a href=\"submissions.php?action=editsubmission&amp;id=$cm->id&amp;sid=$submission->id\">".
 347                         "<img src=\"$CFG->pixpath/t/edit.gif\" ".
 348                         'class="iconsmall" alt="'.get_string('edit').'" /></a>'.
 349                         " <a href=\"submissions.php?action=confirmdelete&amp;id=$cm->id&amp;sid=$submission->id\">".
 350                         "<img src=\"$CFG->pixpath/t/delete.gif\" ".
 351                         'class="iconsmall" alt="'.get_string('delete', 'workshop').'" /></a>';
 352                     $table->data[] = array($title, $teacherassessments,
 353                         workshop_print_submission_assessments($workshop, $submission, "student"));
 354                 }
 355             }
 356             // Put in a submission link
 357             $table->data[] = array("<b><a href=\"view.php?id=$cm->id&amp;action=submitexample\">".
 358                 get_string("submitexampleassignment", "workshop")."</a></b>".
 359                 helpbutton("submissionofexamples", get_string("submitexampleassignment", "workshop"), "workshop", true, false, '', true),
 360                 '&nbsp;', '&nbsp;');
 361             print_table($table);
 362             workshop_print_key($workshop);
 363         }
 364
 365         // Get all the students
 366         if (!$users = workshop_get_students($workshop)) {
 367             echo ('</table>');
 368             print_heading(get_string("nostudentsyet"));
 369             print_footer($course);
 370             exit;
 371         }
 372
 373         if (!empty($CFG->enablegroupings) && !empty($cm->groupingid) && !empty($users)) {
 374             $groupingusers = groups_get_grouping_members($cm->groupingid, 'u.id', 'u.id');
 375             foreach($users as $key => $user) {
 376                 if (!isset($groupingusers[$user->id])) {
 377                     unset($users[$key]);
 378                 }
 379             }
 380         }
 381
 382         /// Now prepare table with student assessments and submissions
 383         $tablesort->data = array();
 384         $tablesort->sortdata = array();
 385         foreach ($users as $user) {
 386             // skip if student not in group
 387             if ($currentgroup) {
 388                 if (!groups_is_member($currentgroup, $user->id)) {
 389                     continue;
 390                 }
 391             }
 392             if ($submissions = workshop_get_user_submissions($workshop, $user)) {
 393                 foreach ($submissions as $submission) {
 394                     $data = array();
 395                     $sortdata = array();
 396
 397                     $data[] = "<a name=\"userid$user->id\" href=\"{$CFG->wwwroot}/user/view.php?id=$user->id&amp;course=$course->id\">".
 398                         fullname($user).'</a>';
 399                     $sortdata['firstname'] = $user->firstname;
 400                     $sortdata['lastname'] = $user->lastname;
 401
 402                     if ($workshop->wtype) {
 403                         $data[] = workshop_print_user_assessments($workshop, $user, $gradinggrade);
 404
 405                         $data[] = $gradinggrade;
 406                         $sortdata['agrade'] = $gradinggrade;
 407                     }
 408
 409                     $data[] = workshop_print_submission_title($workshop, $submission).
 410                         " <a href=\"submissions.php?action=adminamendtitle&amp;id=$cm->id&amp;sid=$submission->id\">".
 411                         "<img src=\"$CFG->pixpath/t/edit.gif\" ".
 412                         'class="iconsmall" alt="'.get_string('amendtitle', 'workshop').'" /></a>'.
 413                         " <a href=\"submissions.php?action=confirmdelete&amp;id=$cm->id&amp;sid=$submission->id\">".
 414                         "<img src=\"$CFG->pixpath/t/delete.gif\" ".
 415                         'class="iconsmall" alt="'.get_string('delete', 'workshop').'" /></a>';
 416                     $sortdata['title'] = $submission->title;
 417
 418                     $data[] = userdate($submission->timecreated, get_string('datestr', 'workshop'));
 419                     $sortdata['date'] = $submission->timecreated;
 420
 421                     if (($tmp = workshop_print_submission_assessments($workshop, $submission, "teacher")) == '&nbsp;') {
 422                         $data[] = '<a href="assess.php?id='.
 423                             $cm->id.'&amp;sid='.$submission->id.'">'.get_string('assess', 'workshop').'</a>';
 424                         $sortdata['tassmnt'] = -1;
 425                     } else {
 426                         $data[] = $tmp;
 427                         $sortdata['tassmnt'] = 1; // GWD still have to fix this
 428                     }
 429
 430                     if ($workshop->wtype) {
 431                         $data[] = workshop_print_submission_assessments($workshop, $submission, "student");
 432                     }
 433
 434                     $grade = workshop_submission_grade($workshop, $submission);
 435                     $data[] = $grade;
 436                     $sortdata['sgrade'] = $grade;
 437
 438                     if ($workshop->wtype) {
 439                         $data[] = number_format($gradinggrade + $grade, 1);
 440                         $sortdata['ograde'] = $gradinggrade + $grade;
 441                     }
 442
 443                     $tablesort->data[] = $data;
 444                     $tablesort->sortdata[] = $sortdata;
 445                 }
 446             }
 447         }
 448
 449         function workshop_sortfunction($a, $b) {
 450            global $sort, $dir;
 451            if ($dir == 'ASC') {
 452                return ($a[$sort] > $b[$sort]);
 453            } else {
 454                return ($a[$sort] < $b[$sort]);
 455            }
 456         }
 457         uasort($tablesort->sortdata, 'workshop_sortfunction');
 458         $table->data = array();
 459         foreach($tablesort->sortdata as $key => $row) {
 460             $table->data[] = $tablesort->data[$key];
 461         }
 462
 463         if ($workshop->wtype) {
 464             $table->align = array ('left', 'center', 'center', 'left', 'center', 'center', 'center', 'center', 'center', 'center');
 465             $columns = array('firstname', 'lastname', 'agrade', 'title', 'date', 'tassmnt', 'sgrade', 'ograde');
 466         } else {
 467             $table->align = array ('left', 'left', 'center', 'center', 'center', 'center');
 468             $columns = array('firstname', 'lastname', 'title', 'date', 'tassmnt', 'ograde');
 469         }
 470         $table->width = "95%";
 471
 472         foreach ($columns as $column) {
 473             $string[$column] = get_string("$column", 'workshop');
 474             if ($sort != $column) {
 475                 $columnicon = '';
 476                 $columndir = 'ASC';
 477             } else {
 478                 $columndir = $dir == 'ASC' ? 'DESC':'ASC';
 479                 if ($column == 'lastaccess') {
 480                     $columnicon = $dir == 'ASC' ? 'up':'down';
 481                 } else {
 482                     $columnicon = $dir == 'ASC' ? 'down':'up';
 483                 }
 484                 $columnicon = " <img src=\"$CFG->pixpath/t/$columnicon.gif\" alt=\"$columnicon\" />";
 485
 486             }
 487             $$column = "<a href=\"view.php?id=$id&amp;sort=$column&amp;dir=$columndir\">".$string[$column]."</a>$columnicon";
 488         }
 489
 490         if ($workshop->wtype) {
 491             $table->head = array ("$firstname / $lastname", get_string("assmnts", "workshop"), $agrade,
 492                 $title, $date, $tassmnt, get_string('passmnts', 'workshop'), $sgrade, $ograde);
 493         } else {
 494             $table->head = array ("$firstname / $lastname", $title, $date, $tassmnt, $ograde);
 495         }
 496
 497         echo '<tr><td>';
 498         print_table($table);
 499         echo '</td></tr>';
 500         echo '<tr><td>';
 501         workshop_print_key($workshop);
 502         echo '</td></tr>';
 503
 504         // grading grade analysis
 505         unset($table);
 506         $table->head = array (get_string("count", "workshop"), get_string("mean", "workshop"),
 507             get_string("standarddeviation", "workshop"), get_string("maximum", "workshop"),
 508             get_string("minimum", "workshop"));
 509         $table->align = array ("center", "center", "center", "center", "center");
 510         $table->size = array ("*", "*", "*", "*", "*");
 511         $table->cellpadding = 2;
 512         $table->cellspacing = 0;
 513         if ($currentgroup) {
 514             $stats = get_record_sql("SELECT COUNT(*) as count, AVG(gradinggrade) AS mean,
 515                     STDDEV(gradinggrade) AS stddev, MIN(gradinggrade) AS min, MAX(gradinggrade) AS max
 516                     FROM {$CFG->prefix}groups_members g, {$CFG->prefix}workshop_assessments a
 517                     WHERE g.groupid = $currentgroup AND a.userid = g.userid AND a.timegraded > 0
 518                     AND a.workshopid = $workshop->id");
 519         } elseif (!empty($cm->groupingid) && !empty($CFG->enablegroupings)) {
 520             $stats = get_record_sql("SELECT COUNT(*) as count, AVG(gradinggrade) AS mean,
 521                     STDDEV(gradinggrade) AS stddev, MIN(gradinggrade) AS min, MAX(gradinggrade) AS max
 522                     FROM {$CFG->prefix}workshop_assessments a
 523                     INNER JOIN {$CFG->prefix}groups_members g ON a.userid = g.userid
 524                     INNER JOIN {$CFG->prefix}groupings_groups gg ON g.groupid = gg.groupid
 525                     WHERE gg.groupingid = {$cm->groupingid} AND a.timegraded > 0
 526                     AND a.workshopid = $workshop->id");
 527         } else { // no group/all participants
 528             $stats = get_record_sql("SELECT COUNT(*) as count, AVG(gradinggrade) AS mean,
 529                     STDDEV(gradinggrade) AS stddev, MIN(gradinggrade) AS min, MAX(gradinggrade) AS max
 530                     FROM {$CFG->prefix}workshop_assessments a
 531                     WHERE a.timegraded > 0 AND a.workshopid = $workshop->id");
 532         }
 533         $table->data[] = array($stats->count, number_format($stats->mean * $workshop->gradinggrade / 100, 1),
 534                 number_format($stats->stddev * $workshop->gradinggrade /100, 1),
 535                 number_format($stats->max * $workshop->gradinggrade / 100, 1),
 536                 number_format($stats->min* $workshop->gradinggrade / 100, 1));
 537         echo '<tr><td>';
 538         print_heading(get_string("gradinggrade", "workshop")." ".get_string("analysis", "workshop"));
 539         print_table($table);
 540         echo '</td></tr>';
 541
 542         if ($workshop->showleaguetable and time() > $workshop->assessmentend) {
 543             workshop_print_league_table($workshop);
 544             if ($workshop->anonymous) {
 545                 echo "<p>".get_string("namesnotshowntostudents", "workshop", $course->students)."</p>\n";
 546             }
 547         }
 548         echo '</table>';
 549     }
 550
 551
 552     /****************** show description  ************/
 553     elseif ($action == 'showdescription') {
 554         workshop_print_assignment_info($workshop);
 555         print_box(format_text($workshop->description, $workshop->format), 'generalbox', 'intro');
 556         if (isset($_SERVER["HTTP_REFERER"])) {
 557             print_continue(htmlentities($_SERVER["HTTP_REFERER"]));
 558         } else {
 559             print_continue("$CFG->wwwroot/course/view.php?id=$cm->id");
 560         }
 561     }
 562
 563
 564     /****************** teacher's view - list all submissions  ************/
 565     elseif ($action == 'allsubmissions') {
 566         require_capability('mod/workshop:manage', $context);
 567
 568         if ($submissions = get_records('workshop_submissions', 'workshopid', $workshop->id)) {
 569             foreach($submissions as $submission) {
 570                 $user = get_record('user', 'id', $submission->userid);
 571                 print_heading('"'.$submission->title.'" '.get_string('by', 'workshop').' '.fullname($user));
 572                 workshop_print_submission($workshop, $submission);
 573             }
 574         }
 575     }
 576
 577
 578     /*************** no man's land **************************************/
 579     else {
 580         error("Fatal Error: Unknown Action: ".$action."\n");
 581     }
 582
 583
 584     print_footer($course);
 585
 586 ?>