Changeset 1065 for WAeUP_SRP/trunk/skins/waeup_student/search_students.py

Timestamp:

15 Dec 2006, 13:42:56 (18 years ago)

Author:

joachim

Message:

improved search, modify studycourse, patchfor attribute error

File:

• WAeUP_SRP/trunk/skins/waeup_student/search_students.py (modified) (10 diffs)

WAeUP_SRP/trunk/skins/waeup_student/search_students.py

@@ -15 +15 @@
 form = request.form
 fget = form.get
-wftool = context.portal_workflow
+#wftool = context.portal_workflow
 mtool = context.portal_membership
 member = mtool.getAuthenticatedMember()
-roles = member.getRolesInContext(context)
-students_folder = context.portal_url.getPortalObject().campus.students
+#roles = member.getRolesInContext(context)
+lt = context.portal_layouts
+#pr = context.portal_registration
+path_info = request.get('PATH_INFO').split('/')
 try:
     from Products.AdvancedQuery import Eq, Between, Le,In
     evalAdvancedQuery = context.portal_catalog.evalAdvancedQuery
+    aq_students = context.students_catalog.evalAdvancedQuery
 except:
     evalAdvancedQuery = None
@@ -37 +40 @@
                       "StudentStudyLevel",)
 
-student_objects = student_subobjects + ("Student",)
-
-info = {}
+#student_objects = student_subobjects + ("Student",)
+student_objects = ("Student",)
+
+user_info = {}
 items = []
-wf = context.portal_workflow
-#student_wf_states = wf.waeup_student_wf.states.keys()
-#info['wf_states'] = student_wf_states
-#info['wf_states'][0] = " ----- "
-lt = context.portal_layouts
-pr = context.portal_registration
-path_info = request.get('PATH_INFO').split('/')
 validate = request.has_key("cpsdocument_edit_button")
 
 state = "all"
+user_info['member'] = str(member)
+user_info['departments'] = []
+user_info['faculties'] = []
+#from Products.zdb import set_trace
+#set_trace()
+co_view = False
 if "ClearanceOfficers" in member.getGroups():
     state = "clearance_requested"
+    only_review = False
+    co_view = True
+    query = In('portal_type',('Faculty',)) &\
+             In('localUsersWithRoles', ("user:%s" % member,))
+    res = evalAdvancedQuery(query)
+    faculties = []
+    if res:
+        faculties = [f.getId for f in res]
+    user_info['faculties'] = faculties
+    query = In('portal_type',('Department',)) &\
+             In('localUsersWithRoles', ("user:%s" % member,))
+    res = evalAdvancedQuery(query)
+    departments = []
+    if res:
+        departments = [f.getId for f in res]
+    user_info['departments'] = departments
 default = {'search_mode': 'name',
         'review_state': state,
@@ -70 +89 @@
                              psm = psm,
                              #psm = "%s, %s" % (psm,ds),
+                             info = user_info,
                              students = [],
                              allowed = True,
@@ -90 +110 @@
                              psm = psm,
                              #psm = "%s, %s" % (psm,ds),
+                             info = user_info,
                              students = items,
                              allowed = True,
@@ -104 +125 @@
 if len(term) > 0:
     if what == "student_id":
+        students_folder = context.portal_url.getPortalObject().campus.students
         query_step = 1
         if hasattr(students_folder,term.strip()):
@@ -135 +157 @@
                 pl = r.getPath().split('/')
                 search_set.append(pl[pl.index('students') + 1])
+elif co_view:
+    #from Products.zdb import set_trace
+    #set_trace()
+    only_review = False
+    query = In('faculty',faculties) | In('department',departments) 
+    res = aq_students(query)
+    search_set = [r.id for r in res]
+##        res = context.students_catalog(faculty=faculties[0],)
+##        res = context.students_catalog(faculty=faculties,department=departments)
+#set_trace()
 if with_review:
     query_step += 10
-    review_res = evalAdvancedQuery(In('portal_type',student_objects) & Eq('review_state',state))
+    #review_res = evalAdvancedQuery(('portal_type',student_objects) & Eq('review_state',state))
+    review_res = evalAdvancedQuery(Eq('review_state',state))
 review_set = []
 if review_res:
     for r in review_res:
-        pl = r.getPath().split('/')
-        review_set.append(pl[pl.index('students') + 1])
+        #pl = r.getPath().split('/')
+        #review_set.append(pl[pl.index('students') + 1])
+        review_set.append(r.getId)
 all = []
+#set_trace()
 if only_review:
     all = review_set
@@ -152 +187 @@
 else:
     all = search_set
-for a in all[:500]:
-    if a in items:
-        continue
-    items.append(a)
+##for a in all[:50]:
+##    if a in items:
+##        continue
+##    items.append(a)
+items = all[:500]
 students = []
-items.sort()
-co_view = False
+#items.sort()
+
 if items:
     for item in items:
@@ -166 +202 @@
         for field in stcat.schema() + stcat.indexes():
             info[field] = getattr(record, field)
-        if "ClearanceOfficers" in member.getGroups():
-            co_view = True
-            res = context.portal_catalog(portal_type='Student', id = item)
-            if len(res) != 1:
-                continue
-            droles = member.getRolesInContext(res[0].getObject())
-            info['review_state'] = res[0].review_state
-            if "ClearanceOfficer" in droles:
-                students.append(info)
+##        if "ClearanceOfficers" in member.getGroups():
+##            co_view = True
+##            res = context.portal_catalog(portal_type='Student', id = item)
+##            if len(res) != 1:
+##                continue
+##            droles = member.getRolesInContext(res[0].getObject())
+##            info['review_state'] = res[0].review_state
+##            if "ClearanceOfficer" in droles:
+##                students.append(info)
         else:
             students.append(info)
@@ -180 +216 @@
     return context.search_students_form(rendered = rend,
                              psm = "",
+                             info = user_info,
                              students = students,
                              allowed = True,
@@ -186 +223 @@
 return context.search_students_form(rendered = rend,
                              psm = "No student found!",
+                             info = user_info,
                              students = students,
                              allowed = True,