From 9ca302560c008f2ba8c66032a958f4c3d6d179e6 Mon Sep 17 00:00:00 2001 From: skodak Date: Mon, 20 Aug 2007 22:18:18 +0000 Subject: [PATCH] MDL-10846 Sorting submitted assignments by status makes all assignments disappear --- mod/assignment/lib.php | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/mod/assignment/lib.php b/mod/assignment/lib.php index fd24b3db37..bf7c5ad61b 100644 --- a/mod/assignment/lib.php +++ b/mod/assignment/lib.php @@ -794,7 +794,7 @@ class assignment_base { $select = 'SELECT u.id, u.firstname, u.lastname, u.picture, s.id AS submissionid, s.grade, s.submissioncomment, - s.timemodified, s.timemarked '; + s.timemodified, s.timemarked, (s.timemarked > 0 AND s.timemarked>=s.timemodified) AS status '; $sql = 'FROM '.$CFG->prefix.'user u '. 'LEFT JOIN '.$CFG->prefix.'assignment_submissions s ON u.id = s.userid AND s.assignment = '.$this->assignment->id.' '. @@ -1107,7 +1107,7 @@ class assignment_base { $select = 'SELECT u.id, u.firstname, u.lastname, u.picture, s.id AS submissionid, s.grade, s.submissioncomment, - s.timemodified, s.timemarked '; + s.timemodified, s.timemarked, (s.timemarked > 0 AND s.timemarked >= s.timemodified) AS status '; $sql = 'FROM '.$CFG->prefix.'user u '. 'LEFT JOIN '.$CFG->prefix.'assignment_submissions s ON u.id = s.userid AND s.assignment = '.$this->assignment->id.' '. @@ -1126,7 +1126,6 @@ class assignment_base { foreach ($ausers as $auser) { /// Calculate user status - $auser->status = ($auser->timemarked > 0) && ($auser->timemarked >= $auser->timemodified); $picture = print_user_picture($auser->id, $course->id, $auser->picture, false, true); if (empty($auser->submissionid)) { -- 2.39.5