source: WAeUP_SRP/branches/regebro-noskins/skins/waeup_pins/search_pins.py @ 13386

Last change on this file since 13386 was 1401, checked in by joachim, 18 years ago

fix the levels
add verdict to students_catalog
add current_verdict to student_study_course
add the same fixes to makeStudentData (not yet tested)

File size: 4.9 KB
Line 
1## Script (Python) "search_pins"
2##bind container=container
3##bind context=context
4##bind namespace=
5##bind script=script
6##bind subpath=traverse_subpath
7##parameters=REQUEST
8##title=
9##
10# $Id: search_students.py 911 2006-11-20 15:11:29Z henrik $
11"""
12list Students for ClearanceOfficers
13"""
14
15request = REQUEST
16wftool = context.portal_workflow
17mtool = context.portal_membership
18member = mtool.getAuthenticatedMember()
19roles = member.getRolesInContext(context)
20pincat = context.portal_pins
21students = context.portal_url.getPortalObject().campus.students
22def check_hostel_pins(term):
23    items = pincat(prefix_batch = term)
24    not_found = []
25    #from Products.zdb import set_trace;set_trace()
26    for item in items:
27        if item.student == '':
28            continue
29        student = getattr(students,item.student,None)
30        if student is None:
31            not_found.append(item)
32        elif not "accommodation_2006" in student.objectIds():
33            not_found.append(item)
34        else:
35            acco = student.accommodation_2006
36            acco_doc = acco.getContent()
37            pin = "".join(str(acco_doc.acco_res_sc_pin).split('-'))
38            if pin != item.pin:
39                not_found.append(item)
40    return not_found
41       
42def set_used_pins(items, from_cat=False):
43    l = []
44    for i in items:
45        item = {}
46        if from_cat:
47            sno = i.student
48            prefix = i.prefix_batch
49            serial = i.serial
50            pin = i.pin
51        else:
52            sno = i['student']
53            prefix = i.get('prefix_batch')
54            serial = i.get('serial')
55            pin = i.get('pin')
56        item['student'] = sno
57        item['prefix'] = prefix
58        item['serial'] = serial
59        if len(sno) > 0:
60            item['pin'] = pin
61        else:
62            if str(member) in ('henrik','joachim'):
63                item['pin'] = "%s" % (pin,)
64            else:
65                item['pin'] = "%s%s****%s" % (i.prefix_batch,pin[-10:-7],pin[-3:])
66        if len(sno)==10:
67            #res = context.portal_catalog(SearchableText=sno,portal_type='StudentApplication')
68            res = context.students_catalog(jamb_reg_no=sno.upper())
69            if len(res) > 0:
70                if sno.startswith('disabled'):
71                    item['student_url'] = None
72                else:
73                    item['student_url'] = "%s/campus/students/%s" % (context.portal_url(),res[0].id)
74                item['student_id'] = res[0].id
75            else:
76                item['student_url'] = None
77                item['student_id'] = ''
78        elif sno:
79            if sno.startswith('disabled'):
80                item['student_url'] = None
81            else:
82                item['student_url'] = '%s/campus/students/%s' % (context.portal_url(),item['student'])
83            item['student_id'] = item['student']
84        else:
85            item['student_url'] = ''
86            item['student_id'] = "not used"
87        l.append(item)
88    return l
89
90lt = context.portal_layouts
91validate = request.has_key("cpsdocument_edit_button")
92default = {'search_mode': 'student',}
93rend,psm,ds = lt.renderLayout(layout_id= 'scratch_card_search',
94                      schema_id= 'student_search',
95                      context=context,
96                      mapping=validate and request,
97                      ob=default,
98                      layout_mode='edit',
99                      formaction="search_pins",
100                      commit = False,
101                      )
102info = {}
103info['used'] = []
104#from Products.zdb import set_trace;set_trace()
105if context.portal_type == "ScratchCardBatch":
106    info['batch_doc'] = context.getContent()
107    info['used'] = set_used_pins(info['batch_doc'].getUsedPins())
108    info['unused'] = info['batch_doc'].getUnusedPins()
109    info['nr_used'] = info['batch_doc'].getNumberOfUsedPins()
110    view = context.batch_view
111elif context.portal_type == "ScratchCardBatchesFolder":
112    view = context.pins_view
113if psm == '':
114    return view(rendered = rend,
115                psm = psm,
116                #psm = "%s, %s" % (psm,ds),
117                info = info,
118                allowed = True,
119                )
120what = ds.get('search_mode')
121term = ds.get('search_string')
122if term != "":
123    if what == 'student' :
124        items_1 = pincat(student = term.upper())
125        items_2 = pincat(student = term.lower())
126        items = items_1 + items_2
127    elif what == 'pin':
128        if context.portal_type == "ScratchCardBatch" and term == "HOS1":
129            items = check_hostel_pins(term)
130        else:
131            items = pincat(pin = term.upper())
132    elif what == 'serial':
133        try:
134            snr = int(term.strip())
135            items = pincat(serial = snr)
136        except ValueError:
137            psm = "invalid number"
138            items = []
139            pass
140    else:
141        items = []
142       
143info['used'] = set_used_pins(items,from_cat=True)
144
145return view(rendered = rend,
146            psm = psm,
147            #psm = "%s, %s" % (psm,ds),
148            info = info,
149            allowed = True,
150            )
151
Note: See TracBrowser for help on using the repository browser.