From 2bae0d446ca10af926bef522b0ecec343b9bfa37 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Wed, 3 Sep 2003 22:10:51 +0000
Subject: [PATCH] Included assignment_get_participants() function. Please check
 it before continue with other modules.

---
 mod/assignment/lib.php | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)

diff --git a/mod/assignment/lib.php b/mod/assignment/lib.php
index 71f31433ea..9e36202199 100644
--- a/mod/assignment/lib.php
+++ b/mod/assignment/lib.php
@@ -500,4 +500,31 @@ function assignment_print_upload_form($assignment) {
     echo "</DIV>";
 }
 
+function assignment_get_participants($assignmentid) {
+//Returns the users with data in one assignment
+//(users with records in assignment_submissions, students and teachers)
+
+    global $CFG;
+
+    //Get students
+    $students = get_records_sql("SELECT DISTINCT u.* 
+                                 FROM {$CFG->prefix}user u,
+                                      {$CFG->prefix}assignment_submissions a
+                                 WHERE a.assignment = '$assignmentid' and
+                                       u.id = a.userid");
+    //Get teachers
+    $teachers = get_records_sql("SELECT DISTINCT u.*
+                                 FROM {$CFG->prefix}user u,       
+                                      {$CFG->prefix}assignment_submissions a       
+                                 WHERE a.assignment = '$assignmentid' and
+                                       u.id = a.teacher");
+
+    //Add teachers to students
+    foreach ($teachers as $teacher) {
+        $students[$teacher->id] = $teacher;
+    }
+    //Return students array (it contains an array of unique users)
+    return ($students);
+}
+
 ?>
-- 
2.39.5