Changeset 3084 for WAeUP_SRP/base/skins/waeup_utilities/ti_71fc_resolve.py

Timestamp:

1 Feb 2008, 12:15:11 (17 years ago)

Author:

joachim

Message:

use portal_catalog instead of students_catalog to find levels

File:

• WAeUP_SRP/base/skins/waeup_utilities/ti_71fc_resolve.py (modified) (2 diffs)

WAeUP_SRP/base/skins/waeup_utilities/ti_71fc_resolve.py

@@ -28 +28 @@
 from Products.AdvancedQuery import Eq, Between, Le,In
 aq_students = context.students_catalog.evalAdvancedQuery
+aq_portal = context.portal_catalog_real.evalAdvancedQuery
 students_folder = context.portal_url.getPortalObject().campus.students
 
@@ -37 +38 @@
     response.setHeader('Content-type','text/html; charset=ISO-8859-15')
     response.write("%s<br>\n\r" % s)
-levels = ("110","210")
-query = In('level',levels)
-student_records = aq_students(query)
-logger.info('found %d students with levels %s' % (len(student_records), " ".join(levels)))
+levels_to_look_for = ("110","210")
+# query = In('level',levels_to_look_for)
+# student_records = aq_students(query)
+# logger.info('found %d students with levels %s' % (len(student_records), " ".join(levels_to_look_for)))
+# students = {}
+# for student_record in student_records:
+#     students[student_record.id] = student_record.level
+query = In('id',levels_to_look_for) & Eq('portal_type','StudentStudyLevel')
+levels= aq_portal(query)
+logger.info('found %d students with levels %s' % (len(levels), " ".join(levels_to_look_for)))
 students = {}
-for student_record in student_records:
-    students[student_record.id] = student_record.level
+for level in levels:
+    student_id = level.getPath().split('/')[-3]
+    students[student_id] = level.getId
 
 for student_id,level in students.items():