1 | #-*- mode: python; mode: fold -*- |
---|
2 | # $Id: Students.py 362 2006-08-05 18:24:53Z joachim $ |
---|
3 | from Globals import InitializeClass |
---|
4 | from AccessControl import ClassSecurityInfo |
---|
5 | from AccessControl.SecurityManagement import newSecurityManager |
---|
6 | |
---|
7 | from Products.CMFCore.utils import UniqueObject, getToolByName |
---|
8 | from Products.CMFCore.permissions import View |
---|
9 | from Products.CMFCore.permissions import ModifyPortalContent |
---|
10 | from Products.CPSCore.CPSBase import CPSBase_adder, CPSBaseFolder |
---|
11 | #from Products.CPSCore.CPSBase import CPSBaseDocument as BaseDocument |
---|
12 | from Products.CPSDocument.CPSDocument import CPSDocument |
---|
13 | from Products.CPSCore.CPSBase import CPSBaseBTreeFolder as BaseBTreeFolder |
---|
14 | from Products.CPSCore.CPSMembershipTool import CPSUnrestrictedUser |
---|
15 | from Products.WAeUP_SRP.Academics import makeCertificateCode |
---|
16 | import logging |
---|
17 | import csv,re |
---|
18 | import Globals |
---|
19 | p_home = Globals.package_home(globals()) |
---|
20 | i_home = Globals.INSTANCE_HOME |
---|
21 | |
---|
22 | class StudentsFolder(CPSDocument): ###( |
---|
23 | """ |
---|
24 | WAeUP container for the various WAeUP containers data |
---|
25 | """ |
---|
26 | meta_type = 'StudentsFolder' |
---|
27 | portal_type = meta_type |
---|
28 | security = ClassSecurityInfo() |
---|
29 | |
---|
30 | security.declareProtected(ModifyPortalContent,"loadFullTimeStudentsFromCSV")###( |
---|
31 | def loadFullTimeStudentsFromCSV(self): |
---|
32 | """load Fulltime Studentdata from CSV values""" |
---|
33 | #return |
---|
34 | name = 'short_full_time' |
---|
35 | no_import = False |
---|
36 | logger = logging.getLogger('%s_import' % name) |
---|
37 | logger.info('Start loading from %s.csv' % name) |
---|
38 | students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject() |
---|
39 | try: |
---|
40 | students = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb")) |
---|
41 | except: |
---|
42 | logger.error('Error reading %s.csv' % name) |
---|
43 | return |
---|
44 | l = self.portal_catalog({'meta_type': "Student"}) |
---|
45 | studs = {} |
---|
46 | for s in l: |
---|
47 | studs[s.id] = s.getObject() |
---|
48 | l = self.portal_catalog({'meta_type': "Certificate"}) |
---|
49 | certs = {} |
---|
50 | for c in l: |
---|
51 | certs[c.id] = c.getObject() |
---|
52 | for student in students: |
---|
53 | logger.info('processing "%(MatricNo)s","%(EntryRegNo)s","%(CurrentSession)s","%(StudentLevel)s","%(fullname)s","%(FirstName)s","%(MiddleName)s","%(Lastname)s","%(FormerSurname)s","%(Sex)s","%(Nationality)s","%(State)s","%(LGA)s","%(PermanentAddress)s","%(PermanentAddressCity)s","%(CampusAddress)s","%(PhoneNumber)s","%(Emailaddress)s","%(Mode)s","%(CourseMajor)s","%(Faculty)s","%(Dept)s"' % student) |
---|
54 | sid = student.get('MatricNo') |
---|
55 | certcode = makeCertificateCode(student.get('CourseMajor')) |
---|
56 | s = studs.get(sid,None) |
---|
57 | if certcode not in certs.keys(): |
---|
58 | em = 'Certificate with ID %s %s not found' % (certcode, student.get('CourseMajor')) |
---|
59 | if not no_import: |
---|
60 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
61 | no_import.write('"MatricNo","EntryRegNo","CurrentSession","StudentLevel","fullname","FirstName","MiddleName","Lastname","FormerSurname","Sex","Nationality","State","LGA","PermanentAddress","PermanentAddressCity","CampusAddress","PhoneNumber","Emailaddress","Mode","CourseMajor","Faculty","Dept"\n') |
---|
62 | logger.info(em) |
---|
63 | no_import.write('"%(MatricNo)s","%(EntryRegNo)s","%(CurrentSession)s","%(StudentLevel)s","%(fullname)s","%(FirstName)s","%(MiddleName)s","%(Lastname)s","%(FormerSurname)s","%(Sex)s","%(Nationality)s","%(State)s","%(LGA)s","%(PermanentAddress)s","%(PermanentAddressCity)s","%(CampusAddress)s","%(PhoneNumber)s","%(Emailaddress)s","%(Mode)s","%(CourseMajor)s","%(Faculty)s","%(Dept)s"' % student) |
---|
64 | continue |
---|
65 | if s is None: |
---|
66 | #self.log('Creating Faculty %(id)s = %(Title)s' % faculty) |
---|
67 | logger.info('Creating Student with ID %(MatricNo)s %(fullname)s' % student) |
---|
68 | students_folder.invokeFactory('Student', sid) |
---|
69 | s = getattr(self,sid) |
---|
70 | s.invokeFactory('StudentPersonal','personal') |
---|
71 | sp = s.personal |
---|
72 | d = {'Title': 'Personal Data'} |
---|
73 | d['matricel_no'] = student.get('MatricNo') |
---|
74 | d['entry_reg_no'] = student.get('EntryRegNo') |
---|
75 | d['fullname'] = student.get('fullname') |
---|
76 | d['firstname'] = student.get('FirstName') |
---|
77 | d['middlename'] = student.get('MiddleName') |
---|
78 | d['lastname'] = student.get('Lastname') |
---|
79 | d['former_surname'] = student.get('FormerSurname') |
---|
80 | d['sex'] = student.get('Sex') == 'F' |
---|
81 | d['nationality'] = student.get('Nationality') |
---|
82 | d['state'] = student.get('State') |
---|
83 | d['lga'] = student.get('LGA') |
---|
84 | d['street'] = student.get('PermanentAddress') |
---|
85 | d['city'] = student.get('PermanentAddressCity') |
---|
86 | d['campus_address'] = student.get('CampusAddress') |
---|
87 | d['phone'] = student.get('PhoneNumber') |
---|
88 | d['email'] = student.get('Emailaddress') |
---|
89 | sp.getContent().edit(mapping=d) |
---|
90 | # |
---|
91 | # Study Course |
---|
92 | # |
---|
93 | s.invokeFactory('StudentStudyCourse','study_course') |
---|
94 | sc = s.study_course |
---|
95 | d = {} |
---|
96 | d['matricel_no'] = student.get('MatricNo') |
---|
97 | d['entry_reg_no'] = student.get('EntryRegNo') |
---|
98 | d['faculty'] = student.get('Faculty') |
---|
99 | d['department'] = student.get('Dept') |
---|
100 | d['course_major'] = certcode |
---|
101 | css = student.get('CurrentSession') or '2004-2005' |
---|
102 | cs = int(css.split('-')[0]) - 2000 |
---|
103 | cl = int(student.get('StudentLevel'))/100 |
---|
104 | d['entry_session'] = "200%s" % (cs - cl) |
---|
105 | sc.getContent().edit(mapping=d) |
---|
106 | else: |
---|
107 | em = 'Faculty with ID %(MatricNo)s %(fullname)s already exists' % student |
---|
108 | if not no_import: |
---|
109 | no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w") |
---|
110 | no_import.write('"MatricNo","EntryRegNo","CurrentSession","StudentLevel","fullname","FirstName","MiddleName","Lastname","FormerSurname","Sex","Nationality","State","LGA","PermanentAddress","PermanentAddressCity","CampusAddress","PhoneNumber","Emailaddress","Mode","CourseMajor","Faculty","Dept"\n') |
---|
111 | logger.info(em) |
---|
112 | no_import.write('"%(MatricNo)s","%(EntryRegNo)s","%(CurrentSession)s","%(StudentLevel)s","%(fullname)s","%(FirstName)s","%(MiddleName)s","%(Lastname)s","%(FormerSurname)s","%(Sex)s","%(Nationality)s","%(State)s","%(LGA)s","%(PermanentAddress)s","%(PermanentAddressCity)s","%(CampusAddress)s","%(PhoneNumber)s","%(Emailaddress)s","%(Mode)s","%(CourseMajor)s","%(Faculty)s","%(Dept)s"' % student) |
---|
113 | return self.students.folder_contents() |
---|
114 | ###) |
---|
115 | |
---|
116 | InitializeClass(StudentsFolder) |
---|
117 | |
---|
118 | def addStudentsFolder(container, id, REQUEST=None, **kw): |
---|
119 | """Add a Student.""" |
---|
120 | ob = StudentsFolder(id, **kw) |
---|
121 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
122 | ###) |
---|
123 | |
---|
124 | class Student(CPSDocument): ###( |
---|
125 | """ |
---|
126 | WAeUP Student container for the various student data |
---|
127 | """ |
---|
128 | meta_type = 'Student' |
---|
129 | portal_type = meta_type |
---|
130 | security = ClassSecurityInfo() |
---|
131 | |
---|
132 | security.declareProtected(View,"Title") |
---|
133 | def Title(self): |
---|
134 | """compose title""" |
---|
135 | reg_nr = self.getId()[1:] |
---|
136 | data = getattr(self,'personal',None) |
---|
137 | if data is None: |
---|
138 | data = getattr(self,'jamb',None) |
---|
139 | if data: |
---|
140 | content = data.getContent() |
---|
141 | return "%s %s" % (content.firstname,content.lastname) |
---|
142 | return self.title |
---|
143 | |
---|
144 | def Description(self): |
---|
145 | """compose description""" |
---|
146 | data = getattr(self,'PERSONAL',None) |
---|
147 | if data is None: |
---|
148 | return "none" |
---|
149 | if data: |
---|
150 | content = data.getContent() |
---|
151 | return "%s" % (content.description) |
---|
152 | return self.description |
---|
153 | |
---|
154 | security.declareProtected(View,"setScratchCardData") |
---|
155 | def setScratchCardData(self,ident,ds): |
---|
156 | """set this data """ |
---|
157 | dict = {'%s_sc_pin' % ident : ds.get('sc_pin'), |
---|
158 | '%s_sc_id' % ident : ds.get('sc_id'), |
---|
159 | '%s_sc_value' % ident : ds.get('sc_value'), |
---|
160 | '%s_date' % ident : ds.get('sc_date'), |
---|
161 | } |
---|
162 | |
---|
163 | old_user = self.portal_membership.getAuthenticatedMember() |
---|
164 | if self.portal_membership.isAnonymousUser(): |
---|
165 | tmp_user = CPSUnrestrictedUser('s%(jamb_id)s' % ds, '', |
---|
166 | ['StudentManager'], '') |
---|
167 | tmp_user = tmp_user.__of__(self.acl_users) |
---|
168 | newSecurityManager(None, tmp_user) |
---|
169 | #print str(dict) |
---|
170 | self.edit(mapping=dict) |
---|
171 | newSecurityManager(None, old_user) |
---|
172 | |
---|
173 | security.declareProtected(View,"memberIsOwner") |
---|
174 | def memberIsOwner(self): |
---|
175 | """is the current user the owner""" |
---|
176 | member = self.portal_membership.getAuthenticatedMember() |
---|
177 | #print member, self.getId(),self.aq_parent.getId() |
---|
178 | if self.aq_parent.getId() == str(member): |
---|
179 | return True |
---|
180 | return False |
---|
181 | |
---|
182 | security.declareProtected(View,"accommodationIsBooked") |
---|
183 | def accommodationIsBooked(self): |
---|
184 | """is the accommodation booked""" |
---|
185 | if self.accommodation_sc_pin != '': |
---|
186 | return True |
---|
187 | return False |
---|
188 | |
---|
189 | security.declareProtected(View,"accommodationIsPayed") |
---|
190 | def accommodationIsPayed(self): |
---|
191 | """is the accommodation payed""" |
---|
192 | if self.hostel_fee_sc_pin != '': |
---|
193 | return True |
---|
194 | return False |
---|
195 | |
---|
196 | security.declareProtected(View,"isRegisteredForCurrentLevel") |
---|
197 | def isRegisteredForCurrentLevel(self): |
---|
198 | """is the student registered for the current level""" |
---|
199 | for l in self.aq_parent.objectValues(): |
---|
200 | if l.portal_type == 'StudyLevel': |
---|
201 | return True |
---|
202 | return False |
---|
203 | |
---|
204 | InitializeClass(Student) |
---|
205 | |
---|
206 | def addStudent(container, id, REQUEST=None, **kw): |
---|
207 | """Add a Student.""" |
---|
208 | ob = Student(id, **kw) |
---|
209 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
210 | |
---|
211 | ###) |
---|
212 | |
---|
213 | class StudentPersonal(CPSDocument): ###( |
---|
214 | """ |
---|
215 | WAeUP Student container for the various student data |
---|
216 | """ |
---|
217 | meta_type = 'StudentPersonal' |
---|
218 | portal_type = meta_type |
---|
219 | security = ClassSecurityInfo() |
---|
220 | |
---|
221 | security.declareProtected(View,"Title") |
---|
222 | def Title(self): |
---|
223 | """compose title""" |
---|
224 | content = self.getContent() |
---|
225 | return "Personal Data for %s %s" % (content.firstname,content.lastname) |
---|
226 | |
---|
227 | |
---|
228 | InitializeClass(StudentPersonal) |
---|
229 | |
---|
230 | def addStudentPersonal(container, id, REQUEST=None, **kw): |
---|
231 | """Add a Students personal data.""" |
---|
232 | ob = StudentPersonal(id, **kw) |
---|
233 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
234 | |
---|
235 | ###) |
---|
236 | |
---|
237 | class StudentStudyCourse(CPSDocument): ###( |
---|
238 | """ |
---|
239 | WAeUP Student container for the various student data |
---|
240 | """ |
---|
241 | meta_type = 'StudentStudyCourse' |
---|
242 | portal_type = meta_type |
---|
243 | security = ClassSecurityInfo() |
---|
244 | |
---|
245 | ## security.declareProtected(View,"Title") |
---|
246 | ## def Title(self): |
---|
247 | ## """compose title""" |
---|
248 | ## content = self.getContent() |
---|
249 | ## return "StudyCourse Data for %s %s" % (content.firstname,content.lastname) |
---|
250 | |
---|
251 | |
---|
252 | InitializeClass(StudentStudyCourse) |
---|
253 | |
---|
254 | def addStudentStudyCourse(container, id, REQUEST=None, **kw): |
---|
255 | """Add a Students personal data.""" |
---|
256 | ob = StudentStudyCourse(id, **kw) |
---|
257 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
258 | |
---|
259 | ###) |
---|
260 | |
---|
261 | class StudentEligibility(CPSDocument): ###( |
---|
262 | """ |
---|
263 | WAeUP Student container for the various student data |
---|
264 | """ |
---|
265 | meta_type = 'StudentEligibility' |
---|
266 | portal_type = meta_type |
---|
267 | security = ClassSecurityInfo() |
---|
268 | |
---|
269 | security.declareProtected(View,"Title") |
---|
270 | def Title(self): |
---|
271 | """compose title""" |
---|
272 | return "Eligibility Data" |
---|
273 | |
---|
274 | |
---|
275 | InitializeClass(StudentEligibility) |
---|
276 | |
---|
277 | def addStudentEligibility(container, id, REQUEST=None, **kw): |
---|
278 | """Add a Students eligibility data.""" |
---|
279 | ob = StudentEligibility(id, **kw) |
---|
280 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
281 | |
---|
282 | ###) |
---|
283 | |
---|
284 | class StudentDocuments(CPSDocument): ###( |
---|
285 | """ |
---|
286 | WAeUP Student container for the various student data |
---|
287 | """ |
---|
288 | meta_type = 'StudentDocuments' |
---|
289 | portal_type = meta_type |
---|
290 | security = ClassSecurityInfo() |
---|
291 | |
---|
292 | security.declareProtected(View,"Title") |
---|
293 | def Title(self): |
---|
294 | """compose title""" |
---|
295 | content = self.getContent() |
---|
296 | return "Scanned Documents" |
---|
297 | |
---|
298 | |
---|
299 | InitializeClass(StudentDocuments) |
---|
300 | |
---|
301 | def addStudentDocuments(container, id, REQUEST=None, **kw): |
---|
302 | """Add a Students documents""" |
---|
303 | ob = StudentDocuments(id, **kw) |
---|
304 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
305 | |
---|
306 | ###) |
---|
307 | |
---|
308 | class Jamb(CPSDocument): ###( |
---|
309 | """ |
---|
310 | WAeUP Jamb containing the courses and students |
---|
311 | """ |
---|
312 | meta_type = 'Jamb' |
---|
313 | portal_type = meta_type |
---|
314 | security = ClassSecurityInfo() |
---|
315 | |
---|
316 | security.declareProtected(View,"Title") |
---|
317 | def Title(self): |
---|
318 | """compose title""" |
---|
319 | content = self.getContent() |
---|
320 | return "JAMB Data for %s %s" % (content.firstname,content.lastname) |
---|
321 | |
---|
322 | security.declareProtected(View,"setOwnership") |
---|
323 | def setOwnership(self,member_id): |
---|
324 | """set ownership""" |
---|
325 | pm = getattr(self,'portal_membership') |
---|
326 | member = pm.getMemberById(member_id) |
---|
327 | self.changeOwnership(member) |
---|
328 | |
---|
329 | InitializeClass(Jamb) |
---|
330 | |
---|
331 | def addJamb(container, id, REQUEST=None, **kw): |
---|
332 | """Add a Jamb.""" |
---|
333 | ob = Jamb(id, **kw) |
---|
334 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
335 | |
---|
336 | ###) |
---|
337 | |
---|
338 | class StudyLevel(CPSDocument): ###( |
---|
339 | """ |
---|
340 | WAeUP StudyLevel containing the courses and students |
---|
341 | """ |
---|
342 | meta_type = 'StudyLevel' |
---|
343 | portal_type = meta_type |
---|
344 | security = ClassSecurityInfo() |
---|
345 | |
---|
346 | InitializeClass(StudyLevel) |
---|
347 | |
---|
348 | def addStudyLevel(container, id, REQUEST=None, **kw): |
---|
349 | """Add a StudyLevel.""" |
---|
350 | ob = StudyLevel(id, **kw) |
---|
351 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
352 | |
---|
353 | ###) |
---|
354 | |
---|
355 | class Semester(CPSDocument): ###( |
---|
356 | """ |
---|
357 | WAeUP Semester containing the courses and students |
---|
358 | """ |
---|
359 | meta_type = 'Semester' |
---|
360 | portal_type = meta_type |
---|
361 | security = ClassSecurityInfo() |
---|
362 | |
---|
363 | InitializeClass(Semester) |
---|
364 | |
---|
365 | def addSemester(container, id, REQUEST=None, **kw): |
---|
366 | """Add a Semester.""" |
---|
367 | ob = Semester(id, **kw) |
---|
368 | return CPSBase_adder(container, ob, REQUEST=REQUEST) |
---|
369 | |
---|
370 | ###) |
---|
371 | |
---|