Changes between Version 1 and Version 2 of AdminTips

Timestamp:

2011-12-22T01:10:54Z (14 years ago)

Author:

Pan Luo

Comment:

--

AdminTips

@@ -12 +12 @@
     );
 }}}
+
+=== Submit for those students ===
+{{{
+#!sql
+INSERT INTO evaluation_submissions 
+    SELECT NULL,EVENTID, group_events.id, user_id,1,NOW(),'A',1,NOW(),NULL,NOW() 
+    FROM groups 
+    LEFT JOIN groups_members ON groups.id = groups_members.group_id 
+    LEFT JOIN group_events ON group_events.group_id = groups.id 
+    WHERE course_id = COURSEID AND user_id IN 
+          SELECT id FROM users 
+          WHERE id IN 
+          (SELECT distinct(evaluator) FROM evaluation_mixevals WHERE event_id = EVENTID AND evaluator NOT IN 
+              (SELECT distinct(submitter_id) FROM evaluation_submissions WHERE event_id = EVENTID)
+          );;
+}}}