source: WAeUP_SRP/trunk/Students.py @ 1080

Last change on this file since 1080 was 1065, checked in by joachim, 18 years ago

improved search, modify studycourse, patchfor attribute error
  • Property svn:keywords set to Id
File size: 57.5 KB
Line 
1#-*- mode: python; mode: fold -*-
2# $Id: Students.py 1065 2006-12-15 13:42:56Z joachim $
3from string import Template
4from Globals import InitializeClass
5from AccessControl import ClassSecurityInfo
6from AccessControl.SecurityManagement import newSecurityManager
7from zExceptions import BadRequest
8from Products.ZCatalog.ZCatalog import ZCatalog
9from Products.CMFCore.utils import UniqueObject, getToolByName
10from Products.CMFCore.permissions import View
11from Products.CMFCore.permissions import ModifyPortalContent
12from Products.CPSCore.CPSBase import CPSBase_adder, CPSBaseFolder
13#from Products.CPSCore.CPSBase import CPSBaseDocument as BaseDocument
14from Products.CPSDocument.CPSDocument import CPSDocument
15from Products.CPSCore.CPSBase import CPSBaseBTreeFolder as BaseBTreeFolder
16from Products.CPSCore.CPSMembershipTool import CPSUnrestrictedUser
17from Products.WAeUP_SRP.Academics import makeCertificateCode
18import logging
19import csv,re,os
20import Globals
21p_home = Globals.package_home(globals())
22i_home = Globals.INSTANCE_HOME
23MAX_TRANS = 1000
24import DateTime
25import PIL.Image
26from StringIO import StringIO
27
28def makeCertificateCode(code): ###(
29    code = code.replace('.','')
30    code = code.replace('(','')
31    code = code.replace(')','')
32    code = code.replace('/','')
33    code = code.replace(' ','')
34    code = code.replace('_','')
35    return code
36
37###)
38
39def getInt(s): ###(
40    try:
41        return int(s)
42    except:
43        return 0
44
45def getFloat(s):
46    try:
47        return float(s)
48    except:
49        return 0.0
50
51###)
52
53def getStudentByRegNo(self,reg_no): ###(
54    """search student by JAMB Reg No and return StudentFolder"""
55    search = ZCatalog.searchResults(self.portal_catalog,{'meta_type': 'StudentApplication',
56                                  'SearchableText': reg_no,
57                                  })
58    if len(search) < 1:
59        return None
60    return search[0].getObject().aq_parent
61
62###)
63
64class StudentsFolder(CPSDocument): ###(
65    """
66    WAeUP container for the various WAeUP containers data
67    """
68    meta_type = 'StudentsFolder'
69    portal_type = meta_type
70    security = ClassSecurityInfo()
71
72    security.declareProtected(ModifyPortalContent,"loadFullTimeStudentsFromCSV")###(
73    def loadFullTimeStudentsFromCSV(self):
74        """load Fulltime Studentdata from CSV values"""
75        import transaction
76        import random
77        tr_count = 0
78        name = 'short_full_time'
79        no_import = False
80        if not no_import:
81            no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w")
82            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')
83        logger = logging.getLogger('%s_import' % name)
84        logger.info('Start loading from %s.csv' % name)
85        pwlist  = []
86        pwlist.append('"student_id","firstname","middlename","lastname","matric_no","jamb_reg_no","access_code"')
87        pwl_template = Template('"$student_id","$firstname","$middlename","$lastname","$matric_no","$jamb_reg_no","$access_code"')
88        students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
89        try:
90            students = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
91        except:
92            logger.error('Error reading %s.csv' % name)
93            return
94        l = self.portal_catalog({'meta_type': "StudentClearance",})
95        matrics = []
96        for s in l:
97            matrics.append(s.getObject().getContent().matric_no)
98        print matrics
99        l = self.portal_catalog({'meta_type': "Certificate"})
100        certs = {}
101        for c in l:
102            ca,ac,fa,dep_id,co,certcode = c.relative_path.split('/')
103            cid = "%(dep_id)s_%(certcode)s" % vars()
104            certs[cid] = c.getObject()
105        for student in students:
106            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"\n' % student)
107            sid = student.get('MatricNo')
108            if sid == "":
109                em = 'Empty MatricNo\n'
110                logger.info(em)
111                no_import.write(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"\n' % student)
113                continue
114            certcode = makeCertificateCode(student.get('CourseMajor'))
115            dep_id = student.get('Dept')
116            fac_id = student.get('Faculty')
117            cid = "%(dep_id)s_%(certcode)s" % vars()
118            if cid not in certs.keys():
119                em = 'Certificate with ID %s %s not found\n' % (certcode, student.get('CourseMajor'))
120                logger.info(em)
121                no_import.write(em)
122                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"\n' % student)
123                continue
124            certificate_doc = certs[cid].getContent()
125            level = student.get('StudentLevel')
126            try:
127                int(level)
128            except:
129                em = 'Student with ID %(MatricNo)s StudentLevel is empty\n' % student
130                logger.info(em)
131                no_import.write(em)
132                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"\n' % student)
133                continue
134            matric_no = student.get('MatricNo')
135            if matric_no not in matrics:
136                matrics.append(matric_no)
137                sid = self.generateStudentId(student.get('Lastname')[0])
138                #self.log('Creating Faculty %(id)s = %(Title)s' % faculty)
139                students_folder.invokeFactory('Student', sid)
140                logger.info('%(tr_count)s: Creating Student with ID %(sid)s Matric_no %(matric_no)s ' % vars())
141                student_obj = getattr(self,sid)
142                access_code = "%d" % random.randint(1000000000,9999999999)
143                student_obj.getContent().makeStudentMember(sid,access_code,)
144                pwl_dict = {'student_id': sid,'access_code':access_code}
145                student_obj.invokeFactory('StudentApplication','application')
146                application = student_obj.application
147                da = {'Title': 'Application Data'}
148                student_obj.invokeFactory('StudentPersonal','personal')
149                da['jamb_reg_no'] = student.get('EntryRegNo')
150                personal = student_obj.personal
151                dp = {'Title': 'Personal Data'}
152                student_obj.invokeFactory('StudentClearance','clearance')
153                clearance = student_obj.clearance
154                dc = {'Title': 'Clearance/Eligibility Record'}
155                dc['matric_no'] = matric_no
156                state = student.get('State')
157                lga = student.get('LGA')
158                if state and lga:
159                    lga =  state + ' / ' + lga
160                else:
161                    lga = "None"
162                dc['lga'] = lga
163                dc['nationality'] = student.get('Nationality')
164                dc['email'] = student.get('Emailaddress')
165                dp['firstname'] = student.get('FirstName')
166                dp['middlename'] = student.get('MiddleName')
167                dp['lastname'] = student.get('Lastname')
168                dp['former_surname'] = student.get('FormerSurname')
169                dp['sex'] = student.get('Sex') == 'F'
170                dp['perm_address'] = student.get('PermanentAddress')
171                dp['perm_city'] = student.get('PermanentAddressCity')
172                dp['campus_address'] = student.get('CampusAddress')
173                dp['phone'] = student.get('PhoneNumber')
174                application.getContent().edit(mapping=da)
175                personal.getContent().edit(mapping=dp)
176                clearance.getContent().edit(mapping=dc)
177                #
178                # Study Course
179                #
180                student_obj.invokeFactory('StudentStudyCourse','study_course')
181                studycourse = student_obj.study_course
182                dsc = {}
183                from_certificate = ['title',
184                                   'max_elect',
185                                   'max_pass',
186                                   'n_core',
187                                   'nr_years',
188                                   'probation_credits',
189                                   'promotion_credits',
190                                   'start_level',
191                                  ]
192                for f in from_certificate:
193                    dsc[f] = getattr(certificate_doc,f)
194                dsc['faculty'] = fac_id
195                dsc['department'] = dep_id
196                dsc['study_course'] = certcode
197                css = student.get('CurrentSession') or '2004-2005'
198                cs = int(css.split('-')[0]) - 2000
199                cl = int(student.get('StudentLevel') or '100')/100
200                dsc['entry_session'] = "200%s" % (cs - cl)
201                dsc['clr_ac_pin'] = access_code
202                studycourse.getContent().edit(mapping=dsc)
203                #
204                # Level
205                #
206##                l = getattr(studycourse,level,None)
207##                if 0 and l is None:
208##                    #self.log('Creating Department %(DeptCode)s = %(Description)s' % dep)
209##                    logger.info('Creating Level %(StudentLevel)s for %(fullname)s' % student)
210##                    studycourse.invokeFactory('StudentStudyLevel', level)
211##                    l = getattr(studycourse, level)
212##                    certificate = certs[certcode]
213##                    cert_level = getattr(certificate,level,None)
214##                    if cert_level is None:
215##                        logger.info('Level %(level)s not in %(certcode)s' % vars())
216##                    l.getContent().edit(mapping={'Title': "Level %s" % level})
217            else:
218                em = 'Student with ID %(MatricNo)s %(fullname)s already exists\n' % student
219                logger.info(em)
220                no_import.write(em)
221                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"\n' % student)
222                continue
223            if tr_count > MAX_TRANS:
224                transaction.commit()
225                em = 'Transaction commited\n' % student
226                logger.info(em)
227                tr_count = 0
228            tr_count += 1
229            pwl_dict.update(dc)
230            pwl_dict.update(da)
231            pwl_dict.update(dp)
232            wftool = self.portal_workflow
233            pwlist.append(pwl_template.substitute(pwl_dict))
234            wftool.doActionFor(student_obj,'clear_and_validate')
235            student_obj.manage_setLocalRoles(sid, ['Owner',])
236            wftool.doActionFor(application,'close')
237            application.manage_setLocalRoles(sid, ['Owner',])
238            wftool.doActionFor(clearance,'close')
239            clearance.manage_setLocalRoles(sid, ['Owner',])
240            wftool.doActionFor(personal,'close')
241            personal.manage_setLocalRoles(sid, ['Owner',])
242            wftool.doActionFor(studycourse,'close_for_edit')
243            studycourse.manage_setLocalRoles(sid, ['Owner',])
244        open("%s/import/pwlist-%s.csv" % (i_home,name),"w+").write('\n'.join(pwlist))
245        return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
246    ###)
247
248    security.declareProtected(ModifyPortalContent,"loadPumeResultsFromCSV")###(
249    def loadPumeResultsFromCSV(self):
250        """load Fulltime Studentdata from CSV values into pumeresults catalog"""
251        import transaction
252        import random
253        from pdb import set_trace
254        csv_d = {'jamb_reg_no': "RegNumber",
255                 'status': "Admission Status",
256                 'name': "Name",
257                 'score': "Score",
258                 'sex': "Sex",
259                 'faculty': "Faculty",
260                 'department': "Dept",
261                 'course': "Course",
262                 'course_code_org': "Course Code",
263                 }
264        csv_fields = [f[1] for f in csv_d.items()]
265        tr_count = 0
266        total = 0
267        #name = 'pup_new'
268        name = 'pup_update'
269        update = name.endswith('update')
270        no_import = []
271        s = ','.join(['"%s"' % fn for fn in csv_fields])
272        no_import.append('%s' % s)
273        current = DateTime.DateTime().strftime("%d-%m-%y_%H_%M_%S")
274        no_import_name = "%s/import/%s_not_imported_%s.csv" % (i_home,name,current)
275        open(no_import_name,"w").write('\n'.join(no_import))
276        no_import = []
277        logger = logging.getLogger('%s_import' % name)
278        starttime = DateTime.now()
279        logger.info('Start loading from %s.csv' % name)
280        try:
281            result = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
282        except:
283            logger.error('Error reading %s.csv' % name)
284            return
285        pume = self.portal_pumeresults
286        format = ','.join(['"%%(%s)s"' % fn for fn in csv_fields])
287        eduplicate = '"dupplicate",%s' % format
288        added = 'added ,%s' % format
289        for jamb in result:
290            dict = {}
291            #set_trace()
292            for f,fn in csv_d.items():
293                dict[f] = jamb.get(csv_d[f])
294            res = pume(jamb_reg_no=jamb.get(csv_d['jamb_reg_no']))
295            if len(res) > 0:
296                if update:
297                    try:
298                        pume.modifyRecord(**dict)
299                    except ValueError:
300                        logger.info(eduplicate % jamb)
301                        continue
302                    except KeyError:
303                        pume.addRecord(**dict)
304                        logger.info(added % jamb)
305                        continue
306                else:
307                    data = res[0]
308                    if data.name != jamb.get(csv_d['name']):
309                        #set_trace()
310                        logger.info(eduplicate % jamb)
311                        #em = 'Student with REG-NO %(jamb_reg_no)s already exists\n' % dict
312                        #logger.info(em)
313                        dd = {}
314                        for f,fn in csv_d.items():
315                            dd[fn] = getattr(data,f)
316                        no_import.append(eduplicate % dd)
317                        no_import.append(eduplicate % jamb)
318                    continue
319            try:
320                pume.addRecord(**dict)
321            except ValueError:
322                logger.info(eduplicate % jamb)
323                #em = 'Student with REG-NO %(jamb_reg_no)s already exists\n' % dict
324                #logger.info(em)
325                no_import.append(eduplicate % jamb)
326        logger.info('End loading from %s.csv' % name)
327        if len(no_import) > 1:
328            open(no_import_name,"w+").write('\n'.join(no_import))
329        return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
330    ###)
331
332    security.declareProtected(ModifyPortalContent,"createNewStudents")###(
333    def createNewStudents(self):
334        """load Fulltime Studentdata from CSV values"""
335        import transaction
336        import random
337        #from pdb import set_trace
338        wftool = self.portal_workflow
339        students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
340        csv_d = {'jamb_reg_no': "RegNumber",
341                 'jamb_lastname': "Name",
342                 'session': "Session",
343                 'pume_tot_score': "PUME SCORE",
344                 'jamb_score': "JambScore",
345                 'jamb_sex': "Sex",
346                 'jamb_state': "State",
347##                 'jamb_first_cos': "AdminCourse",
348                 'faculty': "AdminFaculty",
349                 'course_code': "AdmitCoscode",
350                 'stud_status':"AdmitStatus",
351                 'department': "AdmitDept",
352                 'jamb_lga': "LGA",
353                 'app_email': "email",
354                 'app_mobile': "PhoneNumbers",
355                 }
356        csv_fields = [f[1] for f in csv_d.items()]
357        tr_count = 0
358        total = 0
359        #name = 'pume_results'
360        name = 'Admitted'
361        no_import = []
362        s = ','.join(['"(%s)"' % fn for fn in csv_fields])
363        no_import.append('"Error",%s' % s)
364        format = '"%(Error)s",' + ','.join(['"%%(%s)s"' % fn for fn in csv_fields])
365        no_certificate = "no certificate %s" % format
366        open("%s/import/%s_not_imported.csv" % (i_home,name),"w").write(
367                    '\n'.join(no_import))
368        logger = logging.getLogger('%s_import' % name)
369        logger.info('Start loading from %s.csv' % name)
370        l = self.portal_catalog({'meta_type': "Certificate"})
371        certs = {}
372        cert_docs = {}
373        for f in l:
374            certs[f.getId] = f.getObject().getContent()
375        try:
376            result = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
377        except:
378            logger.error('Error reading %s.csv' % name)
379            return
380        for jamb in result:
381            jamb['Error'] = "Processing "
382            logger.info(format % jamb)
383            jamb_reg_no = jamb.get(csv_d['jamb_reg_no'])
384            res = self.portal_catalog({'portal_type': "StudentApplication",
385                                     'SearchableText': jamb_reg_no })
386            if res:
387                em = 'Student with RegNo %s already exists\n' % jamb_reg_no
388                logger.info(em)
389                jamb['Error'] = "Student exists"
390                no_import.append(format % jamb)
391                continue
392            cert_id = makeCertificateCode(jamb.get(csv_d['course_code']))
393            if cert_id not in certs.keys():
394                em = 'No Certificate with ID %s \n' % cert_id
395                logger.info(em)
396                jamb['Error'] = "No Certificate %s" % cert_id
397                no_import.append( format % jamb)
398                continue
399            cert_doc = certs[cert_id]
400            catalog_entry = {}
401            catalog_entry['jamb_reg_no'] = jamb_reg_no
402            jamb_name = jamb.get(csv_d['jamb_lastname'])
403            jamb_name.replace('>','')
404            jamb_name.replace('<','')
405            names = jamb_name.split()
406            letter = names[-1][0].upper()
407            sid = self.generateStudentId(letter)
408            not_created = True
409            while not_created:
410                try:
411                    students_folder.invokeFactory('Student', sid)
412                    not_created = False
413                except BadRequest:
414                    sid = self.generateStudentId(letter)
415            catalog_entry['id'] = sid
416            tr_count += 1
417            logger.info('%(total)s+%(tr_count)s: Creating Student with ID %(sid)s REG-NO %(jamb_reg_no)s ' % vars())
418            student = getattr(self,sid)
419            student.manage_setLocalRoles(sid, ['Owner',])
420            student.invokeFactory('StudentPume','pume')
421            dp = {'Title': 'Pume Data'}
422            student.invokeFactory('StudentApplication','application')
423            da = {'Title': 'Application Data'}
424            da["jamb_lastname"] = jamb_name
425            da_fields = ('jamb_reg_no',
426                         'jamb_sex',
427                         #'jamb_state',
428                         'jamb_score',
429##                         'jamb_first_cos',
430                         'jamb_sex',
431                         'jamb_state',
432                         'jamb_lga',
433                         'app_email',
434                         'app_mobile',
435                         )
436            for f in da_fields:
437                da[f] = jamb.get(csv_d[f])
438            catalog_entry['email'] = jamb.get(csv_d['app_email'])
439            app = student.application
440            app_doc = app.getContent()
441            picture ="%s/import/pictures/%s.jpg" % (i_home,jamb_reg_no)
442            #import pdb;pdb.set_trace()
443            if os.path.exists(picture):
444                file = open(picture)
445                if False:
446                    img = PIL.Image.open(file)
447                    img.thumbnail((150,200),
448                                  resample=PIL.Image.ANTIALIAS)
449                    # We now need a buffer to write to. It can't be the same
450                    # as the inbuffer as the PNG writer will write over itself.
451                    outfile = StringIO()
452                    img.save(outfile, format=img.format)
453                else:
454                    outfile = file.read()
455                app_doc.manage_addFile('passport',
456                                       file=outfile,
457                                       title="%s.jpg" % jamb_reg_no)
458            app.getContent().edit(mapping=da)
459            app.manage_setLocalRoles(sid, ['Owner',])
460            #wftool.doActionFor(app,'close')
461            dp_fields = (
462                         #'pume_eng_score',
463                         #'pume_gen_score',
464                         'pume_tot_score',
465                         )
466            dp['pume_tot_score'] = jamb.get(csv_d['pume_tot_score']) or "No Option Shaded"
467            pume = student.pume
468            pume.getContent().edit(mapping=dp)
469            #wftool.doActionFor(pume,'close')
470            pume.manage_setLocalRoles(sid, ['Owner',])
471            #student.getContent().createSubObjects()
472            dp = {}
473            if len(names) == 3:
474                dp['firstname'] = names[0].capitalize()
475                dp['middlename'] = names[1].capitalize()
476                dp['lastname'] = names[2].capitalize()
477            elif len(names) == 2:
478                dp['firstname'] = names[0].capitalize()
479                dp['middlename'] = ''
480                dp['lastname'] = names[1].capitalize()
481            else:
482                dp['firstname'] = ''
483                dp['middlename'] = ''
484                dp['lastname'] = jamb_name
485            dp['sex'] = jamb.get(csv_d['jamb_sex']) == 'F'
486            catalog_entry['sex'] = dp['sex']
487            catalog_entry['name'] = "%(firstname)s %(middlename)s %(lastname)s" % dp
488            student.invokeFactory('StudentPersonal','personal')
489            per = student.personal
490            per_doc = per.getContent()
491            per_doc.edit(mapping = dp)
492            per.manage_setLocalRoles(sid, ['Owner',])
493            if jamb.get(csv_d['stud_status']) == "Admitted":
494                wftool.doActionFor(student,'pume_pass')
495                wftool.doActionFor(student,'admit')
496            else:
497                wftool.doActionFor(student,'pume_fail')
498                wftool.doActionFor(student,'reject_admission')
499                continue
500            #
501            # Clearance
502            #
503            student.invokeFactory('StudentClearance','clearance')
504            #wftool.doActionFor(student.clearance,'open')
505            dp = {'Title': 'Clearance/Eligibility Record'}
506            student.clearance.manage_setLocalRoles(sid, ['Owner',])
507            #
508            # Study Course
509            #
510            student.invokeFactory('StudentStudyCourse','study_course')
511            study_course = student.study_course
512            dsc = {}
513            from_certificate = ['title',
514                               'max_elect',
515                               'max_pass',
516                               'n_core',
517                               'nr_years',
518                               'probation_credits',
519                               'promotion_credits',
520                               'start_level',
521                              ]
522            for f in from_certificate:
523                dsc[f] = getattr(cert_doc,f)
524            dsc['faculty'] = jamb.get(csv_d['faculty'])
525            dsc['department'] = jamb.get(csv_d['department'])
526            catalog_entry['faculty'] = jamb.get(csv_d['faculty'])
527            catalog_entry['department'] = jamb.get(csv_d['department'])
528            catalog_entry['course'] = cert_id
529            catalog_entry['level'] = getattr(cert_doc,'start_level')
530            dsc['study_course'] = cert_id
531            dsc['entry_session'] = jamb.get(csv_d['session'])
532            study_course.getContent().edit(mapping=dsc)
533            self.students_catalog.addRecord(**catalog_entry)
534            if tr_count > MAX_TRANS:
535                if len(no_import) > 1:
536                    open("%s/import/%s_not_imported.csv" % (i_home,name),"w+").write(
537                             '\n'.join(no_import))
538                    no_import = []
539                em = '%d transactions commited\n' % tr_count
540                transaction.commit()
541                logger.info(em)
542                total += tr_count
543                tr_count = 0
544        return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
545    ###)
546
547    security.declareProtected(ModifyPortalContent,"updateStudyCourse")###(
548    def updateStudyCourse(self):
549        """update StudyCourse from CSV values"""
550        import transaction
551        import random
552        from pdb import set_trace
553        wftool = self.portal_workflow
554        students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
555        csv_d = {'jamb_reg_no': "RegNumber",
556                 'jamb_lastname': "Name",
557                 'session': "Session",
558                 'pume_tot_score': "PUME SCORE",
559                 'jamb_score': "JambScore",
560                 'jamb_sex': "Sex",
561                 'jamb_state': "State",
562##                 'jamb_first_cos': "AdminCourse",
563                 'faculty': "AdminFaculty",
564                 'course_code': "AdmitCoscode",
565                 'stud_status':"AdmitStatus",
566                 'department': "AdmitDept",
567                 'jamb_lga': "LGA",
568                 'app_email': "email",
569                 'app_mobile': "PhoneNumbers",
570                 }
571        csv_fields = [f[1] for f in csv_d.items()]
572        tr_count = 0
573        total = 0
574        #name = 'pume_results'
575        name = 'StudyCourseChange'
576        no_import = []
577        s = ','.join(['"(%s)"' % fn for fn in csv_fields])
578        no_import.append('"Error",%s' % s)
579        format = '"%(Error)s",' + ','.join(['"%%(%s)s"' % fn for fn in csv_fields])
580        no_certificate = "no certificate %s" % format
581        open("%s/import/%s_not_imported.csv" % (i_home,name),"w").write(
582                    '\n'.join(no_import))
583        logger = logging.getLogger('%s_import' % name)
584        logger.info('Start loading from %s.csv' % name)
585        l = self.portal_catalog({'meta_type': "Certificate"})
586        try:
587            result = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
588        except:
589            logger.error('Error reading %s.csv' % name)
590            return
591        for jamb in result:
592            jamb['Error'] = "Processing "
593            logger.info(format % jamb)
594            jamb_reg_no = jamb.get(csv_d['jamb_reg_no'])
595            res = self.portal_catalog({'portal_type': "StudentApplication",
596                                     'SearchableText': jamb_reg_no })
597            if not res:
598                em = 'Student with RegNo %s does not exists\n' % jamb_reg_no
599                logger.info(em)
600                jamb['Error'] = "Student not exists"
601                no_import.append(format % jamb)
602                continue
603            sid = res[0].getPath().split('/')[-2]
604            cert_id = makeCertificateCode(jamb.get(csv_d['course_code']))
605            res = self.portal_catalog(portal_type = "Certificate", id = cert_id)
606            if not res:
607                em = 'No Certificate with ID %s \n' % cert_id
608                logger.info(em)
609                jamb['Error'] = "No Certificate %s" % cert_id
610                no_import.append( format % jamb)
611                continue
612            cert_brain = res[0]
613            catalog_entry = {}
614            student = getattr(self,sid)
615            #
616            # Study Course
617            #
618            study_course = student.study_course
619            dsc = {}
620            cert_pl = cert_brain.getPath().split('/')
621            catalog_entry['id'] = sid
622            catalog_entry['faculty'] = cert_pl[-4]
623            catalog_entry['department'] = cert_pl[-3]
624            catalog_entry['course'] = cert_id
625            dsc['study_course'] = cert_id
626            study_course.getContent().edit(mapping=dsc)
627            self.students_catalog.modifyRecord(**catalog_entry)
628            if tr_count > 10:
629                if len(no_import) > 1:
630                    open("%s/import/%s_not_imported.csv" % (i_home,name),"w+").write(
631                             '\n'.join(no_import))
632                    no_import = []
633                em = '%d transactions commited\n' % tr_count
634                transaction.commit()
635                logger.info(em)
636                total += tr_count
637                tr_count = 0
638            tr_count += 1
639        return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
640    ###)
641
642    security.declareProtected(ModifyPortalContent,"OLDloadPumeResultsFromCSV")###(
643    def OLDloadPumeResultsFromCSV(self):
644        """load Fulltime Studentdata from CSV values"""
645        import transaction
646        import random
647        wftool = self.portal_workflow
648        students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
649        csv_d = {'jamb_reg_no': "JAMBRegno",
650                 'jamb_lastname': "Name",
651                 'pume_options': "Options",
652                 'session': "Session",
653                 'days': "Days",
654                 'response': "Responce",
655                 'wrong': "Wrong",
656                 'pume_eng_score': "EngScore",
657                 'pume_gen_score': "GenScore",
658                 'pume_tot_score': "Score",
659                 'batch': "Batch",
660                 'serial': "SerialNo",
661                 'jamb_score': "JambScore",
662                 'omitted':"Omitted",
663                 'search_key': "SearchKey",
664                 'jamb_sex': "Sex",
665                 'fac1': "Fac1",
666                 'fac2': "Fac2",
667                 'jamb_first_cos': "CourseofStudy",
668                 'stud_status':"StudStatus",
669                 'registered': "Registered",
670                 'jamb_state': "State",
671                 'eng_fail': "EngFail",
672                 'gen_fail': "GenFail",
673                 'un_ans_eng': "UnAnsEng",
674                 'un_ans_eng': "UnAnsGen",
675                 'total_ans': "TotalUnAns",
676                 'dept': "Dept",
677                 'jamb_second_cos': "Course2",
678                 'jamb_third_cos': "course3",
679                 }
680        csv_fields = [f[1] for f in csv_d.items()]
681        tr_count = 0
682        name = 'pume_results'
683        no_import = []
684        s = ','.join(['"(%s)"' % fn for fn in csv_fields])
685        no_import.append('%s\n' % s)
686        logger = logging.getLogger('%s_import' % name)
687        logger.info('Start loading from %s.csv' % name)
688        try:
689            result = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
690        except:
691            logger.error('Error reading %s.csv' % name)
692            return
693        for jamb in result:
694            format = ','.join(['"%%(%s)s"' % fn for fn in csv_fields])
695            processing = "processing %s" % format
696            logger.info(processing % jamb)
697            jamb_reg_no = jamb.get(csv_d['jamb_reg_no'])
698            #import pdb;pdb.set_trace()
699            res = self.portal_catalog({'portal_type': "StudentApplication",
700                                     'jamb_reg_no': jamb_reg_no })
701            if res:
702                em = 'Student with REG-NO %s already exists\n' % jamb_reg_no
703                logger.info(em)
704                no_import.append(em)
705                no_import.append(format % jamb)
706                continue
707            cert_id = jamb.get(csv_d['jamb_first_cos']).upper()
708            res = self.portal_catalog({'portal_type': "Certificate",
709                                     'id': cert_id })
710            if len(res) < 1:
711                em = 'No Certificate with ID %s \n' % cert_id
712                logger.info(em)
713                no_import.append(em)
714                no_import.append(format % jamb)
715                continue
716            cert = res[0].getObject()
717            cert_path = res[0].getPath()
718            cert_doc = cert.getContent()
719            jamb_name = jamb.get(csv_d['jamb_lastname'])
720            jamb_name.replace('>','')
721            names = jamb_name.split()
722            letter = names[-1][0].upper()
723            sid = self.generateStudentId(letter)
724            not_created = True
725            while not_created:
726                try:
727                    students_folder.invokeFactory('Student', sid)
728                    not_created = False
729                except BadRequest:
730                    sid = self.generateStudentId(letter)
731            logger.info('%(tr_count)s: Creating Student with ID %(sid)s REG-NO %(jamb_reg_no)s ' % vars())
732            student = getattr(self,sid)
733            student.manage_setLocalRoles(sid, ['Owner',])
734            student.invokeFactory('StudentClearance','clearance')
735            #wftool.doActionFor(student.clearance,'open')
736            dp = {'Title': 'Clearance/Eligibility Record'}
737            student.clearance.manage_setLocalRoles(sid, ['Owner',])
738            student.invokeFactory('StudentPume','pume')
739            dp = {'Title': 'Pume Data'}
740            student.invokeFactory('StudentApplication','application')
741            da = {'Title': 'Application Data'}
742            da["jamb_lastname"] = jamb_name
743            da_fields = ('jamb_reg_no',
744                         'jamb_sex',
745                         'jamb_state',
746                         'jamb_score',
747                         'jamb_first_cos',
748                         'jamb_sex',
749                         'jamb_state',
750                         'jamb_first_cos',
751                         'jamb_second_cos',
752                         )
753            for f in da_fields:
754                da[f] = jamb.get(csv_d[f])
755            app = student.application
756            app.getContent().edit(mapping=da)
757            app.manage_setLocalRoles(sid, ['Owner',])
758            #wftool.doActionFor(app,'close')
759            dp_fields = (
760                         'pume_eng_score',
761                         'pume_gen_score',
762                         'pume_tot_score',
763                         )
764            for f in dp_fields:
765                dp[f] = float(jamb.get(csv_d[f]))
766            pume = student.pume
767            pume.getContent().edit(mapping=dp)
768            #wftool.doActionFor(pume,'close')
769            pume.manage_setLocalRoles(sid, ['Owner',])
770            #
771            # Study Course
772            #
773            student.invokeFactory('StudentStudyCourse','study_course')
774            study_course = student.study_course
775            dsc = {}
776            from_certificate = ['title',
777                               'max_elect',
778                               'max_pass',
779                               'n_core',
780                               'nr_years',
781                               'probation_credits',
782                               'promotion_credits',
783                               'start_level',
784                              ]
785            for f in from_certificate:
786                dsc[f] = getattr(cert_doc,f)
787            cpl = cert_path.split('/')
788            dsc['faculty'] = cpl[-4]
789            dsc['department'] = cpl[-3]
790            dsc['study_course'] = cert_id
791            dsc['entry_session'] = jamb.get(csv_d['session'])
792            study_course.getContent().edit(mapping=dsc)
793            student.getContent().createSubObjects()
794            if dp['pume_tot_score']>49:
795                wftool.doActionFor(student,'pume_pass')
796                wftool.doActionFor(student,'admit')
797            else:
798                wftool.doActionFor(student,'pume_fail')
799                wftool.doActionFor(student,'reject_admission')
800            if len(no_import) > 1:
801                open("%s/import/%s_not_imported.csv" % (i_home,name),"w").write(
802                     '\n'.join(no_import))
803        return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
804    ###)
805
806    security.declareProtected(ModifyPortalContent,"loadFullTimeStudentsResultsFromCSV") ###(
807    def loadFullTimeStudentsResultsFromCSV(self):
808        """load Fulltime Studentdata from CSV values"""
809        #return
810        level_wf_actions = {}
811        level_wf_actions["SUCCESSFUL STUDENT"] = "pass_A"
812        level_wf_actions["STUDENT WITH CARRYOVER COURSES"] = "pass_B"
813        level_wf_actions["STUDENT FOR PROBATION"] = "probate_C"
814        level_wf_actions["STUDENT ON PROBATION/TRANSFER"] = "reject_D"
815        import transaction
816        wftool = self.portal_workflow
817        tr_count = 0
818        name = 'short_full_time_results_2004_2005'
819        no_import = False
820        if not no_import:
821            no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w")
822            no_import.write('"Matnumber","CosCode","Ansbook","CosStuatus","Session","Mat_Cos","Score","CarryLevel","Grade","Weight","Semster","Verdict","Level","id","GPA"\n')
823        logger = logging.getLogger('%s_import' % name)
824        logger.info('Start loading from %s.csv' % name)
825        students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
826        try:
827            results = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
828        except:
829            logger.error('Error reading %s.csv' % name)
830            return
831        l = self.portal_catalog({'meta_type': "Course"})
832        courses = {}
833        for c in l:
834            courses[c.id] = c.getObject()
835        level_changed = False
836        student_changed = False
837        sid = ''
838        #import pdb;pdb.set_trace()
839        for result in results:
840            temp_sid = result.get('Matnumber')
841            if temp_sid != sid:
842                student_changed = True
843                res = self.portal_catalog({'meta_type': "StudentClearance",
844                                         'SearchableText': temp_sid })
845                if not res:
846                    em = 'Student with ID %(Matnumber)s not found\n' % result
847                    logger.info(em)
848                    no_import.write(em)
849                    no_import.write('"%(Matnumber)s","%(CosCode)s","%(Ansbook)s","%(CosStuatus)s","%(Session)s","%(Mat_Cos)s","%(Score)s","%(CarryLevel)s","%(Grade)s","%(Weight)s","%(Semster)s","%(Verdict)s","%(Level)s","%(id)s","%(GPA)s"\n' % result)
850                    continue
851                elif len(res) > 1:
852                    em = 'More than one Student with ID %(Matnumber)s found\n' % result
853                    logger.info(em)
854                    no_import.write(em)
855                    no_import.write('"%(Matnumber)s","%(CosCode)s","%(Ansbook)s","%(CosStuatus)s","%(Session)s","%(Mat_Cos)s","%(Score)s","%(CarryLevel)s","%(Grade)s","%(Weight)s","%(Semster)s","%(Verdict)s","%(Level)s","%(id)s","%(GPA)s"\n' % result)
856                    continue
857                sid = temp_sid
858                sf = res[0].getObject().aq_parent
859                sc = getattr(sf,'study_course')
860                level = ''
861            else:
862                student_changed = False
863            course = result.get('CosCode')
864            if course not in courses.keys():
865                em = 'Course with ID %(CosCode)s not found\n' % result
866                logger.info(em)
867                no_import.write(em)
868                no_import.write('"%(Matnumber)s","%(CosCode)s","%(Ansbook)s","%(CosStuatus)s","%(Session)s","%(Mat_Cos)s","%(Score)s","%(CarryLevel)s","%(Grade)s","%(Weight)s","%(Semster)s","%(Verdict)s","%(Level)s","%(id)s","%(GPA)s"\n' % result)
869                continue
870            course_doc = courses[course].getContent()
871            temp_level = result.get('Level')
872            student_id = sf.getId()
873            result['StudentId'] = student_id
874            if temp_level != level:
875                try:
876                    int(temp_level)
877                except:
878                    em = 'Result with ID %(Matnumber)s Course %(CosCode)s Level is empty\n' % result
879                    logger.info(em)
880                    no_import.write(em)
881                    no_import.write('"%(Matnumber)s","%(CosCode)s","%(Ansbook)s","%(CosStuatus)s","%(Session)s","%(Mat_Cos)s","%(Score)s","%(CarryLevel)s","%(Grade)s","%(Weight)s","%(Semster)s","%(Verdict)s","%(Level)s","%(id)s","%(GPA)s"\n' % result)
882                    continue
883                level_changed = True
884                if 'dlev' in vars().keys():
885                    wftool.doActionFor(l,level_wf_actions[dlev['verdict']])
886                level = temp_level
887                l = getattr(sc,level,None)
888                if l is None:
889                    logger.info('Creating Level %(Level)s for %(StudentId)s %(Matnumber)s' % result)
890                    sc.invokeFactory('StudentStudyLevel', level)
891                    l = getattr(sc, level)
892                    l.manage_setLocalRoles(student_id, ['Owner',])
893            else:
894                level_changed = False
895            cr = getattr(l,course,None)
896            if cr is None:
897                logger.info('Creating Course %(CosCode)s for %(StudentId)s %(Matnumber)s in Level %(Level)s' % result)
898                l.invokeFactory('StudentCourseResult',course)
899            cr = getattr(l,course)
900            dcr = {}
901            from_course = ['title',
902                           'credits',
903                           'passmark',
904                           ]
905            for f in from_course:
906                dcr[f] = getattr(course_doc,f)
907            dlev = {}
908            dcr['ansbook'] = result.get('Ansbook')
909            dcr['semester'] = getInt(result.get('Semster'))
910            dcr['status'] = result.get('CosStuatus')
911            dcr['score'] = getInt(result.get('Score'))
912            dlev['session'] = result.get('Session')
913            dcr['carry_level'] = result.get('CarryLevel')
914            dcr['grade'] = result.get('Grade')
915            dcr['weight'] = result.get('Weight')
916            dlev['verdict'] = result.get('Verdict')
917            dcr['import_id'] = result.get('id')
918            gpa = result.get('GPA').replace(',','.')
919            dlev['imported_gpa'] = getFloat(gpa)
920            cr.getContent().edit(mapping = dcr)
921            cr.manage_setLocalRoles(student_id, ['Owner',])
922            l.getContent().edit(mapping = dlev)
923            if tr_count > MAX_TRANS:
924                transaction.commit()
925                tr_count = 0
926            tr_count += 1
927            wftool.doActionFor(cr,'close')
928        wftool.doActionFor(l,level_wf_actions[dlev['verdict']])
929        return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
930
931###)
932
933    security.declareProtected(ModifyPortalContent,"loadJAMBFromCSV")###(
934    def loadJAMBFromCSV(self):
935        """load JAMB data from CSV values"""
936        #return
937        students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
938        import transaction
939        tr_count = 0
940        name = 'SampleJAMBDataII'
941        wftool = self.portal_workflow
942        no_import = False
943        if not no_import:
944            no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w")
945            no_import.write('REG-NO,NAME,SEX,STATE,LGA,ENG-SCORE,SUBJ1,SUBJ1-SCORE,SUBJ2,SUBJ2-SCORE,SUBJ3,SUBJ3-SCORE,AGGREGATE,UNIV1,FACULTY1,COURSE1,UNIV2,FACULTY2,COURSE2')
946        logger = logging.getLogger('%s_import' % name)
947        logger.info('Start loading from %s.csv' % name)
948        try:
949            result = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
950        except:
951            logger.error('Error reading %s.csv' % name)
952            return
953        for jamb in result:
954            logger.info('processing %(REG-NO)s,%(NAME)s,%(SEX)s,%(STATE)s,%(LGA)s,%(ENG-SCORE)s,%(SUBJ1)s,%(SUBJ1-SCORE)s,%(SUBJ2)s,%(SUBJ2-SCORE)s,%(SUBJ3)s,%(SUBJ3-SCORE)s,%(AGGREGATE)s,%(UNIV1)s,%(FACULTY1)s,%(COURSE1)s,%(UNIV2)s,%(FACULTY2)s,%(COURSE2)s\n' % jamb)
955            jamb_reg_no = jamb.get('REG-NO')
956            res = self.portal_catalog({'meta_type': "StudentApplication",
957                                     'jamb_reg_no': jamb_reg_no })
958            if res:
959                em = 'Student with REG-NO %(REG-NO)s already exists\n' % jamb
960                logger.info(em)
961                no_import.write(em)
962                no_import.write('%(REG-NO)s,%(NAME)s,%(SEX)s,%(STATE)s,%(LGA)s,%(ENG-SCORE)s,%(SUBJ1)s,%(SUBJ1-SCORE)s,%(SUBJ2)s,%(SUBJ2-SCORE)s,%(SUBJ3)s,%(SUBJ3-SCORE)s,%(AGGREGATE)s,%(UNIV1)s,%(FACULTY1)s,%(COURSE1)s,%(UNIV2)s,%(FACULTY2)s,%(COURSE2)s\n' % jamb)
963                continue
964            jamb_name = jamb.get("NAME")
965            jamb_name.replace('>','')
966            names = jamb_name.split()
967            letter = names[-1][0].upper()
968            sid = self.generateStudentId(letter)
969            not_created = True
970            while not_created:
971                try:
972                    students_folder.invokeFactory('Student', sid)
973                    not_created = False
974                except BadRequest:
975                    sid = self.generateStudentId(letter)
976            logger.info('%(tr_count)s: Creating Student with ID %(sid)s REG-NO %(jamb_reg_no)s ' % vars())
977            student = getattr(self,sid)
978            student.manage_setLocalRoles(sid, ['Owner',])
979            student.invokeFactory('StudentApplication','application')
980            da = {'Title': 'Application Data'}
981            da["jamb_reg_no"] = jamb.get("REG-NO")
982            da["jamb_lastname"] = jamb_name
983            da["jamb_sex"] = jamb.get("SEX")
984            da["jamb_state"] = jamb.get("STATE")
985            da["jamb_lga"] = jamb.get("LGA")
986            da["jamb_score"] = jamb.get("AGGREGATE")
987            da["jamb_first_cos"] = jamb.get("COURSE1")
988            da["jamb_second_cos"] = jamb.get("COURSE2")
989            da["jamb_first_uni"] = jamb.get("UNIV1")
990            da["jamb_second_uni"] = jamb.get("UNIV2")
991            app = student.application
992            app_doc = app.getContent()
993            app_doc.edit(mapping=da)
994            #wftool.doActionFor(app,'open',dest_container=app)
995            app.manage_setLocalRoles(sid, ['Owner',])
996            student.getContent().createSubObjects()
997        return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
998    ###)
999
1000
1001    security.declareProtected(View,"fixOwnership")
1002    def fixOwnership(self):
1003        """fix Ownership"""
1004        for s in self.portal_catalog(meta_type = 'Student'):
1005            student = s.getObject()
1006            sid = s.getId
1007            import pdb;pdb.set_trace()
1008            student.application.manage_setLocalRoles(sid, ['Owner',])
1009            student.personal.manage_setLocalRoles(sid, ['Owner',])
1010
1011    security.declareProtected(View,"Title")
1012    def Title(self):
1013        """compose title"""
1014        return "Student Section"
1015
1016    def generateStudentId(self,letter): ###(
1017        import random
1018        r = random
1019        if letter not in ('ABCDEFGIHKLMNOPQRSTUVWXY'):
1020            letter= r.choice('ABCDEFGHKLMNPQRSTUVWXY')
1021        students = self.portal_catalog(meta_type = "StudentsFolder")[-1]
1022        sid = "%c%d" % (letter,r.randint(99999,1000000))
1023        while hasattr(students, sid):
1024            sid = "%c%d" % (letter,r.randint(99999,1000000))
1025        return sid
1026        #return "%c%d" % (r.choice('ABCDEFGHKLMNPQRSTUVWXY'),r.randint(99999,1000000))
1027    ###)
1028
1029InitializeClass(StudentsFolder)
1030
1031def addStudentsFolder(container, id, REQUEST=None, **kw):
1032    """Add a Student."""
1033    ob = StudentsFolder(id, **kw)
1034    return CPSBase_adder(container, ob, REQUEST=REQUEST)
1035###)
1036
1037class Student(CPSDocument): ###(
1038    """
1039    WAeUP Student container for the various student data
1040    """
1041    meta_type = 'Student'
1042    portal_type = meta_type
1043    security = ClassSecurityInfo()
1044
1045    security.declareProtected(View,"Title")
1046    def Title(self):
1047        """compose title"""
1048        reg_nr = self.getId()[1:]
1049        data = getattr(self,'personal',None)
1050        if data:
1051            content = data.getContent()
1052            return "%s %s" % (content.firstname,content.lastname)
1053        data = getattr(self,'application',None)
1054        if data:
1055            content = data.getContent()
1056            return "%s" % (content.jamb_lastname)
1057        return self.title
1058
1059    security.declarePrivate('makeStudentMember') ###(
1060    def makeStudentMember(self,sid,password='uNsEt'):
1061        """make the student a member"""
1062        membership = self.portal_membership
1063        membership.addMember(sid,
1064                             password ,
1065                             roles=('Member',
1066                                     'Student',
1067                                     ),
1068                             domains='',
1069                             properties = {'memberareaCreationFlag': False,
1070                                           'homeless': True},)
1071        member = membership.getMemberById(sid)
1072        self.portal_registration.afterAdd(member, sid, password, None)
1073        self.manage_setLocalRoles(sid, ['Owner',])
1074
1075###)
1076
1077    security.declareProtected(View,'createSubObjects') ###(
1078    def createSubObjects(self):
1079        """make the student a member"""
1080        dp = {'Title': 'Personal Data'}
1081        app_doc = self.application.getContent()
1082        names = app_doc.jamb_lastname.split()
1083        if len(names) == 3:
1084            dp['firstname'] = names[0].capitalize()
1085            dp['middlename'] = names[1].capitalize()
1086            dp['lastname'] = names[2].capitalize()
1087        elif len(names) == 2:
1088            dp['firstname'] = names[0].capitalize()
1089            dp['lastname'] = names[1].capitalize()
1090        else:
1091            dp['lastname'] = app_doc.jamb_lastname
1092        dp['sex'] = app_doc.jamb_sex == 'F'
1093        dp['lga'] = "%s/%s" % (app_doc.jamb_state,app_doc.jamb_lga )
1094        proxy = self.aq_parent
1095        proxy.invokeFactory('StudentPersonal','personal')
1096        per = proxy.personal
1097        per_doc = per.getContent()
1098        per_doc.edit(mapping = dp)
1099        per.manage_setLocalRoles(proxy.getId(), ['Owner',])
1100        #self.portal_workflow.doActionFor(per,'open',dest_container=per)
1101
1102###)
1103
1104InitializeClass(Student)
1105
1106def addStudent(container, id, REQUEST=None, **kw):
1107    """Add a Student."""
1108    ob = Student(id, **kw)
1109    return CPSBase_adder(container, ob, REQUEST=REQUEST)
1110
1111###)
1112
1113class StudentAccommodation(CPSDocument): ###(
1114    """
1115    WAeUP Student container for the various student data
1116    """
1117    meta_type = 'StudentAccommodation'
1118    portal_type = meta_type
1119    security = ClassSecurityInfo()
1120
1121    security.declareProtected(View,"Title")
1122    def Title(self):
1123        """compose title"""
1124        content = self.getContent()
1125        #return "Accommodation Data for %s %s" % (content.firstname,content.lastname)
1126        return "Accommodation Data for Session %s" % content.session
1127
1128
1129InitializeClass(StudentAccommodation)
1130
1131def addStudentAccommodation(container, id, REQUEST=None, **kw):
1132    """Add a Students personal data."""
1133    ob = StudentAccommodation(id, **kw)
1134    return CPSBase_adder(container, ob, REQUEST=REQUEST)
1135
1136###)
1137
1138class StudentPersonal(CPSDocument): ###(
1139    """
1140    WAeUP Student container for the various student data
1141    """
1142    meta_type = 'StudentPersonal'
1143    portal_type = meta_type
1144    security = ClassSecurityInfo()
1145
1146    security.declareProtected(View,"Title")
1147    def Title(self):
1148        """compose title"""
1149        content = self.getContent()
1150        #return "Personal Data for %s %s" % (content.firstname,content.lastname)
1151        return "Personal Data"
1152
1153
1154InitializeClass(StudentPersonal)
1155
1156def addStudentPersonal(container, id, REQUEST=None, **kw):
1157    """Add a Students personal data."""
1158    ob = StudentPersonal(id, **kw)
1159    return CPSBase_adder(container, ob, REQUEST=REQUEST)
1160
1161###)
1162
1163class StudentClearance(CPSDocument): ###(
1164    """
1165    WAeUP Student container for the various student data
1166    """
1167    meta_type = 'StudentClearance'
1168    portal_type = meta_type
1169    security = ClassSecurityInfo()
1170
1171    security.declareProtected(View,"Title")
1172    def Title(self):
1173        """compose title"""
1174        content = self.getContent()
1175        #return "Clearance/Eligibility Record for %s %s" % (content.firstname,content.lastname)
1176        return "Clearance/Eligibility Record"
1177
1178
1179InitializeClass(StudentClearance)
1180
1181def addStudentClearance(container, id, REQUEST=None, **kw):
1182    """Add a Students personal data."""
1183    ob = StudentClearance(id, **kw)
1184    return CPSBase_adder(container, ob, REQUEST=REQUEST)
1185
1186###)
1187
1188class StudentStudyLevel(CPSDocument): ###(
1189    """
1190    WAeUP Student container for the various student data
1191    """
1192    meta_type = 'StudentStudyLevel'
1193    portal_type = meta_type
1194    security = ClassSecurityInfo()
1195
1196    security.declareProtected(View,"Title")
1197    def Title(self):
1198        """compose title"""
1199        return "Level %s" % self.aq_parent.getId()
1200
1201##    security.declarePublic("gpa")
1202##    def gpa(self):
1203##        """calculate the gpa"""
1204##        sum = 0
1205##        course_count = 0
1206##        for sc in self.objectValues():
1207##            result = sc.getContent()
1208##            if not result.grade:
1209##                continue
1210##            res = self.portal_catalog({'meta_type': 'Course',
1211##                                          'id': sc.aq_parent.id})
1212##            if len(res) != 1:
1213##                continue
1214##            course = res[0].getObject().getContent()
1215##            sum += course.credits * ['F','E','D','C','B','A'].index(result.grade)
1216##            course_count += 1
1217##        if course_count:
1218##            return sum/course_count
1219##        return 0.0
1220
1221InitializeClass(StudentStudyLevel)
1222
1223def addStudentStudyLevel(container, id, REQUEST=None, **kw):
1224    """Add a Students personal data."""
1225    ob = StudentStudyLevel(id, **kw)
1226    return CPSBase_adder(container, ob, REQUEST=REQUEST)
1227
1228###)
1229
1230class StudentStudyCourse(CPSDocument): ###(
1231    """
1232    WAeUP Student container for the various student data
1233    """
1234    meta_type = 'StudentStudyCourse'
1235    portal_type = meta_type
1236    security = ClassSecurityInfo()
1237
1238    security.declareProtected(View,"Title")
1239    def Title(self):
1240        """compose title"""
1241        content = self.getContent()
1242        return "Study Course"
1243
1244
1245InitializeClass(StudentStudyCourse)
1246
1247def addStudentStudyCourse(container, id, REQUEST=None, **kw):
1248    """Add a Students personal data."""
1249    ob = StudentStudyCourse(id, **kw)
1250    return CPSBase_adder(container, ob, REQUEST=REQUEST)
1251
1252###)
1253
1254class StudentApplication(CPSDocument): ###(
1255    """
1256    WAeUP Student container for the various student data
1257    """
1258    meta_type = 'StudentApplication'
1259    portal_type = meta_type
1260    security = ClassSecurityInfo()
1261
1262    security.declareProtected(View,"Title")
1263    def Title(self):
1264        """compose title"""
1265        return "Application Data"
1266
1267
1268InitializeClass(StudentApplication)
1269
1270def addStudentApplication(container, id, REQUEST=None, **kw):
1271    """Add a Students eligibility data."""
1272    ob = StudentApplication(id, **kw)
1273    return CPSBase_adder(container, ob, REQUEST=REQUEST)
1274###)
1275
1276
1277class StudentPume(CPSDocument): ###(
1278    """
1279    WAeUP Student container for the various student data
1280    """
1281    meta_type = 'StudentPume'
1282    portal_type = meta_type
1283    security = ClassSecurityInfo()
1284
1285    security.declareProtected(View,"Title")
1286    def Title(self):
1287        """compose title"""
1288        return "PUME Results"
1289
1290
1291InitializeClass(StudentPume)
1292
1293def addStudentPume(container, id, REQUEST=None, **kw):
1294    """Add a Students PUME data."""
1295    ob = StudentPume(id, **kw)
1296    return CPSBase_adder(container, ob, REQUEST=REQUEST)
1297###)
1298
1299##class StudentSemester(CPSDocument): ###(
1300##    """
1301##    WAeUP StudentSemester containing the courses and students
1302##    """
1303##    meta_type = 'StudentSemester'
1304##    portal_type = meta_type
1305##    security = ClassSecurityInfo()
1306##
1307##InitializeClass(StudentSemester)
1308##
1309##def addStudentSemester(container, id, REQUEST=None, **kw):
1310##    """Add a StudentSemester."""
1311##    ob = StudentSemester(id, **kw)
1312##    return CPSBase_adder(container, ob, REQUEST=REQUEST)
1313##
1314#####)
1315
1316##class Semester(CPSDocument): ###(
1317##    """
1318##    WAeUP Semester containing the courses and students
1319##    """
1320##    meta_type = 'Semester'
1321##    portal_type = meta_type
1322##    security = ClassSecurityInfo()
1323##
1324##InitializeClass(Semester)
1325##
1326##def addSemester(container, id, REQUEST=None, **kw):
1327##    """Add a Semester."""
1328##    ob = Semester(id, **kw)
1329##    return CPSBase_adder(container, ob, REQUEST=REQUEST)
1330##
1331#####)
1332
1333class StudentCourseResult(CPSDocument): ###(
1334    """
1335    WAeUP StudentCourseResult
1336    """
1337    meta_type = 'StudentCourseResult'
1338    portal_type = meta_type
1339    security = ClassSecurityInfo()
1340
1341    def getCourseEntry(self,cid):
1342        res = self.portal_catalog({'meta_type': "Course",
1343                                           'id': cid})
1344        if res:
1345            return res[-1]
1346        else:
1347            return None
1348
1349    security.declareProtected(View,"Title")
1350    def Title(self):
1351        """compose title"""
1352        cid = self.aq_parent.getId()
1353        ce = self.getCourseEntry(cid)
1354        if ce:
1355            return "%s" % ce.Title
1356        return "No course with id %s" % cid
1357
1358InitializeClass(StudentCourseResult)
1359
1360def addStudentCourseResult(container, id, REQUEST=None, **kw):
1361    """Add a StudentCourseResult."""
1362    ob = StudentCourseResult(id, **kw)
1363    return CPSBase_adder(container, ob, REQUEST=REQUEST)
1364###)
1365
1366# Backward Compatibility StudyLevel
1367
1368from Products.WAeUP_SRP.Academics import StudyLevel
1369
1370from Products.WAeUP_SRP.Academics import addStudyLevel
1371
Note: See TracBrowser for help on using the repository browser.