source: WAeUP_SRP/trunk/Students.py @ 575

Last change on this file since 575 was 572, checked in by joachim, 18 years ago

search for students ready for testing, update waeup_student_wf first

  • Property svn:keywords set to Id
File size: 28.2 KB
RevLine 
[57]1#-*- mode: python; mode: fold -*-
[200]2# $Id: Students.py 572 2006-09-27 17:03:31Z joachim $
[45]3from Globals import InitializeClass
4from AccessControl import ClassSecurityInfo
[164]5from AccessControl.SecurityManagement import newSecurityManager
[429]6from zExceptions import BadRequest
[502]7from Products.ZCatalog.ZCatalog import ZCatalog
[47]8from Products.CMFCore.utils import UniqueObject, getToolByName
[45]9from Products.CMFCore.permissions import View
10from Products.CMFCore.permissions import ModifyPortalContent
[154]11from Products.CPSCore.CPSBase import CPSBase_adder, CPSBaseFolder
12#from Products.CPSCore.CPSBase import CPSBaseDocument as BaseDocument
13from Products.CPSDocument.CPSDocument import CPSDocument
14from Products.CPSCore.CPSBase import CPSBaseBTreeFolder as BaseBTreeFolder
[164]15from Products.CPSCore.CPSMembershipTool import CPSUnrestrictedUser
[361]16from Products.WAeUP_SRP.Academics import makeCertificateCode
[362]17import logging
18import csv,re
19import Globals
20p_home = Globals.package_home(globals())
21i_home = Globals.INSTANCE_HOME
[398]22MAX_TRANS = 1000
[154]23
[511]24def generateStudentId(letter):
[422]25    import random
[423]26    r = random
[511]27    if letter not in ('ABCDEFGIHKLMNOPQRSTUVWXY'):
28        letter= r.choice('ABCDEFGHKLMNPQRSTUVWXY')
29    return "%c%d" % (letter,r.randint(99999,1000000))
30    #return "%c%d" % (r.choice('ABCDEFGHKLMNPQRSTUVWXY'),r.randint(99999,1000000))
[422]31
[502]32def getStudentByRegNo(self,reg_no):
33    """search student by JAMB Reg No and return StudentFolder"""
34    search = ZCatalog.searchResults(self.portal_catalog,{'meta_type': 'StudentApplication',
35                                  'jamb_reg_no': reg_no,
36                                  })
37    if len(search) < 1:
38        return None
39    return search[0].getObject().aq_parent
40
[361]41class StudentsFolder(CPSDocument): ###(
42    """
43    WAeUP container for the various WAeUP containers data
44    """
[362]45    meta_type = 'StudentsFolder'
[361]46    portal_type = meta_type
47    security = ClassSecurityInfo()
[154]48
[361]49    security.declareProtected(ModifyPortalContent,"loadFullTimeStudentsFromCSV")###(
50    def loadFullTimeStudentsFromCSV(self):
51        """load Fulltime Studentdata from CSV values"""
52        #return
[398]53        import transaction
54        tr_count = 0
[361]55        name = 'short_full_time'
56        no_import = False
[395]57        if not no_import:
58            no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w")
59            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')
[361]60        logger = logging.getLogger('%s_import' % name)
61        logger.info('Start loading from %s.csv' % name)
62        students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
63        try:
64            students = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
65        except:
66            logger.error('Error reading %s.csv' % name)
67            return
[422]68        l = self.portal_catalog({'meta_type': "StudentClearance",})
69        matrics = []
[361]70        for s in l:
[422]71            matrics.append(s.getObject().getContent().matric_no)
[423]72        print matrics
[361]73        l = self.portal_catalog({'meta_type': "Certificate"})
74        certs = {}
75        for c in l:
[362]76            certs[c.id] = c.getObject()
[361]77        for student in students:
[393]78            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)
[361]79            sid = student.get('MatricNo')
[396]80            if sid == "":
81                em = 'Empty MatricNo\n'
82                logger.info(em)
83                no_import.write(em)
84                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)
85                continue
[361]86            certcode = makeCertificateCode(student.get('CourseMajor'))
87            if certcode not in certs.keys():
[393]88                em = 'Certificate with ID %s %s not found\n' % (certcode, student.get('CourseMajor'))
[361]89                logger.info(em)
[393]90                no_import.write(em)
91                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)
[361]92                continue
[395]93            level = student.get('StudentLevel')
[426]94            try:
[395]95                int(level)
96            except:
97                em = 'Student with ID %(MatricNo)s StudentLevel is empty\n' % student
98                logger.info(em)
99                no_import.write(em)
100                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)
101                continue
[422]102            matric_no = student.get('MatricNo')
103            if matric_no not in matrics:
104                matrics.append(matric_no)
105                sid = generateStudentId()
[361]106                #self.log('Creating Faculty %(id)s = %(Title)s' % faculty)
[426]107                logger.info('%(tr_count)s: Creating Student with ID %(sid)s Matric_no %(matric_no)s ' % vars())
[429]108                not_created = True
109                while not_created:
110                    try:
111                        students_folder.invokeFactory('Student', sid)
112                        not_created = False
113                    except BadRequest:
114                        sid = generateStudentId()
115                logger.info('%(tr_count)s: Creating Student with ID %(sid)s Matric_no %(matric_no)s ' % vars())
[361]116                s = getattr(self,sid)
[502]117                self.portal_registration.addMember(sid,
118                                                   'uNsEt' ,
119                                                   roles=('Member',
120                                                          'Student',))
[472]121                s.invokeFactory('StudentApplication','application')
122                da = {'Title': 'Application Data'}
[361]123                s.invokeFactory('StudentPersonal','personal')
[446]124                da['jamb_reg_no'] = student.get('EntryRegNo')
[362]125                sp = s.personal
[361]126                d = {'Title': 'Personal Data'}
[422]127                s.invokeFactory('StudentClearance','clearance')
[427]128                sc = s.clearance
[422]129                dc = {'Title': 'Clearance Data'}
130                dc['matric_no'] = matric_no
[472]131                lga = student.get('State') + ' / ' + student.get('LGA')
[427]132                dc['lga'] = lga
[422]133                dc['nationality'] = student.get('Nationality')
134                dc['email'] = student.get('Emailaddress')
[361]135                d['firstname'] = student.get('FirstName')
136                d['middlename'] = student.get('MiddleName')
[362]137                d['lastname'] = student.get('Lastname')
[361]138                d['former_surname'] = student.get('FormerSurname')
[362]139                d['sex'] = student.get('Sex') == 'F'
[422]140                d['perm_address'] = student.get('PermanentAddress')
141                d['perm_city'] = student.get('PermanentAddressCity')
[361]142                d['campus_address'] = student.get('CampusAddress')
143                d['phone'] = student.get('PhoneNumber')
[472]144                s.application.getContent().edit(mapping=da)
[362]145                sp.getContent().edit(mapping=d)
[422]146                sc.getContent().edit(mapping=dc)
[362]147                #
148                # Study Course
149                #
150                s.invokeFactory('StudentStudyCourse','study_course')
151                sc = s.study_course
152                d = {}
[422]153                #d['matricel_no'] = student.get('MatricNo')
154                #d['entry_reg_no'] = student.get('EntryRegNo')
155                #d['faculty'] = student.get('Faculty')
156                #d['department'] = student.get('Dept')
[453]157                d['study_course'] = certcode
[454]158                css = student.get('CurrentSession') or '2004-2005'
159                cs = int(css.split('-')[0]) - 2000
160                cl = int(student.get('StudentLevel'))/100
161                d['entry_session'] = "200%s" % (cs - cl)
[362]162                sc.getContent().edit(mapping=d)
[364]163                #
164                # Level
165                #
166                l = getattr(sc,level,None)
167                if l is None:
168                    #self.log('Creating Department %(DeptCode)s = %(Description)s' % dep)
169                    logger.info('Creating Level %(StudentLevel)s for %(fullname)s' % student)
[454]170                    sc.invokeFactory('StudentStudyLevel', level)
[364]171                    l = getattr(sc, level)
172                    certificate = certs[certcode]
173                    cert_level = getattr(certificate,level,None)
174                    if cert_level is None:
175                        logger.info('Level %(level)s not in %(certcode)s' % vars())
176                    l.getContent().edit(mapping={'Title': "Level %s" % level})
[464]177                    l.invokeFactory('StudentSemester','first')
178                    l.invokeFactory('StudentSemester','second')
[364]179                    first_s = getattr(l,'first')
180                    first_s.getContent().edit(mapping={'Title': 'First Semester'})
181                    second_s = getattr(l,'second')
182                    second_s.getContent().edit(mapping={'Title': 'Second Semester'})
[361]183            else:
[393]184                em = 'Student with ID %(MatricNo)s %(fullname)s already exists\n' % student
[361]185                logger.info(em)
[393]186                no_import.write(em)
187                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)
[398]188            if tr_count > MAX_TRANS:
[422]189                transaction.commit()
190                em = 'Transaction commited\n' % student
[398]191                logger.info(em)
192                tr_count = 0
193            tr_count += 1
[423]194        return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
[361]195    ###)
[382]196
[398]197    security.declareProtected(ModifyPortalContent,"loadFullTimeStudentsResultsFromCSV") ###(
[396]198    def loadFullTimeStudentsResultsFromCSV(self):
199        """load Fulltime Studentdata from CSV values"""
200        #return
[398]201        import transaction
202        tr_count = 0
203        name = 'short_full_time_results_2004_2005'
[396]204        no_import = False
205        if not no_import:
206            no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w")
207            no_import.write('"Matnumber","CosCode","Ansbook","CosStuatus","Session","Mat_Cos","Score","CarryLevel","Grade","Weight","Semster","Verdict","Level","id","GPA"\n')
208        logger = logging.getLogger('%s_import' % name)
209        logger.info('Start loading from %s.csv' % name)
210        students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
211        try:
212            results = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
213        except:
214            logger.error('Error reading %s.csv' % name)
215            return
[398]216        l = self.portal_catalog({'meta_type': "Course"})
217        courses = {}
218        for c in l:
219            courses[c.id] = c.getObject()
[396]220        for result in results:
221            sid = result.get('Matnumber')
[452]222            res = self.portal_catalog({'meta_type': "StudentClearance",
223                                     'matric_no': sid })
224            if not res:
[398]225                em = 'Student with ID %(Matnumber)s not found\n' % result
[396]226                logger.info(em)
227                no_import.write(em)
[398]228                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)
[396]229                continue
[452]230            sf = res[0].getObject().aq_parent
[454]231            result['StudentId'] = sf.getId()
[398]232            course = result.get('CosCode')
233            if course not in courses.keys():
234                em = 'Course with ID %(CosCode)s not found\n' % result
[396]235                logger.info(em)
236                no_import.write(em)
[398]237                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)
[396]238                continue
[398]239            level = result.get('Level')
[426]240            try:
[396]241                int(level)
242            except:
[398]243                em = 'Result for result with ID %(Matnumber)s Course %(CosCode)s Level is empty\n' % result
[396]244                logger.info(em)
245                no_import.write(em)
[398]246                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)
[396]247                continue
248            sc = getattr(sf,'study_course')
249            l = getattr(sc,level,None)
250            if l is None:
251                #self.log('Creating Department %(DeptCode)s = %(Description)s' % dep)
[454]252                logger.info('Creating Level %(Level)s for %(StudentId)s %(Matnumber)s' % result)
253                sc.invokeFactory('StudentStudyLevel', level)
[396]254                l = getattr(sc, level)
[464]255                l.invokeFactory('StudentSemester','first')
256                l.invokeFactory('StudentSemester','second')
[396]257                first_s = getattr(l,'first')
258                first_s.getContent().edit(mapping={'Title': 'First Semester'})
259                second_s = getattr(l,'second')
260                second_s.getContent().edit(mapping={'Title': 'Second Semester'})
[454]261            snr = result.get('Semster')
[396]262            semester = getattr(l,'first')
[398]263            if snr == "2":
[396]264                semester = getattr(l,'second')
[464]265            logger.info('Creating StudentCourseResult %(CosCode)s in Level %(Level)s for %(StudentId)s %(Matnumber)s' % result)
266            semester.invokeFactory('StudentCourseResult',course)
[398]267            ct = getattr(semester,course)
268            d = {}
[454]269            dlev = {}
[398]270            d['ansbook'] = result.get('Ansbook')
271            d['status'] = result.get('CosStuatus')
272            d['score'] = result.get('Score')
[454]273            dlev['session'] = result.get('Session')
274            dlev['carry_level'] = result.get('CarryLevel')
[398]275            d['grade'] = result.get('Grade')
[454]276            #d['weight'] = result.get('Weight')
277            dlev['verdict'] = result.get('Verdict')
278            #d['import_id'] = result.get('id')
279            #gpa = result.get('GPA').replace(',','.')
280            #d['gpa'] = float(gpa)
[398]281            ct.getContent().edit(mapping = d)
[454]282            l.getContent().edit(mapping = dlev)
[398]283            if tr_count > MAX_TRANS:
284                transaction.commit()
285                tr_count = 0
286            tr_count += 1
287        return self.students.academics_contents()
[426]288
[398]289###)
[396]290
[457]291    security.declareProtected(ModifyPortalContent,"loadJAMBFromCSV")###(
292    def loadJAMBFromCSV(self):
293        """load JAMB data from CSV values"""
294        #return
295        students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
296        import transaction
297        tr_count = 0
[572]298        name = 'SampleJAMBDataII'
[511]299        wftool = self.portal_workflow
[457]300        no_import = False
301        if not no_import:
302            no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w")
303            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')
304        logger = logging.getLogger('%s_import' % name)
305        logger.info('Start loading from %s.csv' % name)
306        try:
307            result = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
308        except:
309            logger.error('Error reading %s.csv' % name)
310            return
311        for jamb in result:
312            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)
313            jamb_reg_no = jamb.get('REG-NO')
[472]314            res = self.portal_catalog({'meta_type': "StudentApplication",
[457]315                                     'jamb_reg_no': jamb_reg_no })
316            if res:
317                em = 'Student with REG-NO %(REG-NO)s already exists\n' % jamb
318                logger.info(em)
319                no_import.write(em)
320                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)
321                continue
[511]322            jamb_name = jamb.get("NAME")
323            names = jamb_name.split()
324            letter = names[-1][0].upper()
325            sid = generateStudentId(letter)
[457]326            #self.log('Creating Faculty %(id)s = %(Title)s' % faculty)
327            not_created = True
328            while not_created:
329                try:
330                    students_folder.invokeFactory('Student', sid)
331                    not_created = False
332                except BadRequest:
[511]333                    sid = generateStudentId(letter)
[457]334            logger.info('%(tr_count)s: Creating Student with ID %(sid)s REG-NO %(jamb_reg_no)s ' % vars())
[511]335            student = getattr(self,sid)
[519]336            student.manage_setLocalRoles(sid, ['Owner',])
[511]337            student.invokeFactory('StudentApplication','application')
[472]338            da = {'Title': 'Application Data'}
[457]339            da["jamb_reg_no"] = jamb.get("REG-NO")
[511]340            da["jamb_lastname"] = jamb_name
[457]341            da["jamb_sex"] = jamb.get("SEX")
342            da["jamb_state"] = jamb.get("STATE")
343            da["jamb_lga"] = jamb.get("LGA")
344            da["jamb_score"] = jamb.get("AGGREGATE")
345            da["jamb_first_cos"] = jamb.get("COURSE1")
346            da["jamb_second_cos"] = jamb.get("COURSE2")
347            da["jamb_first_uni"] = jamb.get("UNIV1")
348            da["jamb_second_uni"] = jamb.get("UNIV2")
[511]349            app = student.application
350            app_doc = app.getContent()
351            app_doc.edit(mapping=da)
[539]352            #wftool.doActionFor(app,'open',dest_container=app)
[511]353            app.manage_setLocalRoles(sid, ['Owner',])
354            student.getContent().createSubObjects()
[457]355        return self.REQUEST.RESPONSE.redirect("%s" % self.REQUEST.get('URL1'))
356    ###)
[426]357
[472]358
[511]359    security.declareProtected(View,"fixOwnership")
360    def fixOwnership(self):
361        """fix Ownership"""
362        for s in self.portal_catalog(meta_type = 'Student'):
363            student = s.getObject()
364            sid = s.getId
365            import pdb;pdb.set_trace()
366            student.application.manage_setLocalRoles(sid, ['Owner',])
367            student.personal.manage_setLocalRoles(sid, ['Owner',])
368           
[364]369    security.declareProtected(View,"Title")
370    def Title(self):
371        """compose title"""
[382]372        return "Student Section"
[361]373
374InitializeClass(StudentsFolder)
375
376def addStudentsFolder(container, id, REQUEST=None, **kw):
377    """Add a Student."""
378    ob = StudentsFolder(id, **kw)
379    return CPSBase_adder(container, ob, REQUEST=REQUEST)
380###)
381
[57]382class Student(CPSDocument): ###(
383    """
[154]384    WAeUP Student container for the various student data
[57]385    """
386    meta_type = 'Student'
387    portal_type = meta_type
388    security = ClassSecurityInfo()
[154]389
[152]390    security.declareProtected(View,"Title")
391    def Title(self):
392        """compose title"""
[153]393        reg_nr = self.getId()[1:]
[362]394        data = getattr(self,'personal',None)
[152]395        if data:
396            content = data.getContent()
397            return "%s %s" % (content.firstname,content.lastname)
[472]398        data = getattr(self,'application',None)
[464]399        if data:
400            content = data.getContent()
401            return "%s" % (content.jamb_lastname)
[152]402        return self.title
[154]403
[511]404    security.declarePrivate('makeStudentMember') ###(
405    def makeStudentMember(self,sid,password='uNsEt'):
406        """make the student a member"""
407        membership = self.portal_membership
408        membership.addMember(sid,
409                             password ,
410                             roles=('Member',
411                                     'Student',
[522]412                                     ),
[511]413                             domains='',
[522]414                             properties = {'memberareaCreationFlag': False,},)
[511]415        member = membership.getMemberById(sid)
416        self.portal_registration.afterAdd(member, sid, password, None)
417        self.manage_setLocalRoles(sid, ['Owner',])
418
419###)
420
421    security.declareProtected(View,'createSubObjects') ###(
422    def createSubObjects(self):
423        """make the student a member"""
424        dp = {'Title': 'Personal Data'}
[512]425        app_doc = self.application.getContent()
426        names = app_doc.jamb_lastname.split()
[511]427        if len(names) == 3:
428            dp['firstname'] = names[0].capitalize()
429            dp['middlename'] = names[1].capitalize()
430            dp['lastname'] = names[2].capitalize()
431        elif len(names) == 2:
432            dp['firstname'] = names[0].capitalize()
433            dp['lastname'] = names[1].capitalize()
434        else:
435            dp['lastname'] = app_doc.jamb_lastname
[512]436        dp['sex'] = app_doc.jamb_sex == 'F'
437        dp['lga'] = "%s/%s" % (app_doc.jamb_state,app_doc.jamb_lga )
[511]438        proxy = self.aq_parent
439        proxy.invokeFactory('StudentPersonal','personal')
440        per = proxy.personal
441        per_doc = per.getContent()
[512]442        per_doc.edit(mapping = dp)
[511]443        per.manage_setLocalRoles(self.getId(), ['Owner',])
444        self.portal_workflow.doActionFor(per,'open',dest_container=per)
445       
446###)
447
[57]448InitializeClass(Student)
449
450def addStudent(container, id, REQUEST=None, **kw):
451    """Add a Student."""
452    ob = Student(id, **kw)
453    return CPSBase_adder(container, ob, REQUEST=REQUEST)
454
455###)
[91]456
[89]457class StudentPersonal(CPSDocument): ###(
458    """
[154]459    WAeUP Student container for the various student data
[89]460    """
461    meta_type = 'StudentPersonal'
462    portal_type = meta_type
463    security = ClassSecurityInfo()
[152]464
465    security.declareProtected(View,"Title")
466    def Title(self):
467        """compose title"""
468        content = self.getContent()
[364]469        #return "Personal Data for %s %s" % (content.firstname,content.lastname)
470        return "Personal Data"
[152]471
[154]472
[89]473InitializeClass(StudentPersonal)
474
475def addStudentPersonal(container, id, REQUEST=None, **kw):
476    """Add a Students personal data."""
477    ob = StudentPersonal(id, **kw)
478    return CPSBase_adder(container, ob, REQUEST=REQUEST)
479
480###)
481
[423]482class StudentClearance(CPSDocument): ###(
483    """
484    WAeUP Student container for the various student data
485    """
486    meta_type = 'StudentClearance'
487    portal_type = meta_type
488    security = ClassSecurityInfo()
489
490    security.declareProtected(View,"Title")
491    def Title(self):
492        """compose title"""
493        content = self.getContent()
494        #return "Clearance Data for %s %s" % (content.firstname,content.lastname)
495        return "Clearance Data"
496
497
498InitializeClass(StudentClearance)
499
500def addStudentClearance(container, id, REQUEST=None, **kw):
501    """Add a Students personal data."""
502    ob = StudentClearance(id, **kw)
503    return CPSBase_adder(container, ob, REQUEST=REQUEST)
504
505###)
506
[454]507class StudentStudyLevel(CPSDocument): ###(
508    """
509    WAeUP Student container for the various student data
510    """
511    meta_type = 'StudentStudyLevel'
512    portal_type = meta_type
513    security = ClassSecurityInfo()
514
515    security.declareProtected(View,"Title")
516    def Title(self):
517        """compose title"""
518        return "Level %s" % self.aq_parent.getId()
519
520    security.declareProtected(View,"gpa")
521    def gpa(self):
522        """calculate the gpa"""
523        sum = 0
524        course_count = 0
525        for semester in ('first','second'):
526            sf=getattr(self,semester)
527            for sc in sf.objectValues():
528                result = sc.getContent()
529                res = self.portal_catalog({'meta_type': 'Course',
530                                              'id': sc.aq_parent.id})
531                if len(res) != 1:
532                    continue
533                course = res[0].getObject().getContent()
534                sum += course.credits * ['F','E','D','C','B','A'].index(result.grade)
535                course_count += 1
536        if course_count:
537            return sum/course_count
538        return 0.0
[472]539
[454]540InitializeClass(StudentStudyLevel)
541
542def addStudentStudyLevel(container, id, REQUEST=None, **kw):
543    """Add a Students personal data."""
544    ob = StudentStudyLevel(id, **kw)
545    return CPSBase_adder(container, ob, REQUEST=REQUEST)
546
547###)
548
[362]549class StudentStudyCourse(CPSDocument): ###(
550    """
551    WAeUP Student container for the various student data
552    """
553    meta_type = 'StudentStudyCourse'
554    portal_type = meta_type
555    security = ClassSecurityInfo()
556
[364]557    security.declareProtected(View,"Title")
558    def Title(self):
559        """compose title"""
560        content = self.getContent()
[453]561        return "Study Course"
[362]562
563
564InitializeClass(StudentStudyCourse)
565
566def addStudentStudyCourse(container, id, REQUEST=None, **kw):
567    """Add a Students personal data."""
568    ob = StudentStudyCourse(id, **kw)
569    return CPSBase_adder(container, ob, REQUEST=REQUEST)
570
571###)
572
[472]573class StudentApplication(CPSDocument): ###(
[179]574    """
575    WAeUP Student container for the various student data
576    """
[472]577    meta_type = 'StudentApplication'
[179]578    portal_type = meta_type
579    security = ClassSecurityInfo()
580
[181]581    security.declareProtected(View,"Title")
582    def Title(self):
583        """compose title"""
[472]584        return "Application Data"
[179]585
[181]586
[472]587InitializeClass(StudentApplication)
[179]588
[472]589def addStudentApplication(container, id, REQUEST=None, **kw):
[179]590    """Add a Students eligibility data."""
[472]591    ob = StudentApplication(id, **kw)
[179]592    return CPSBase_adder(container, ob, REQUEST=REQUEST)
593
594###)
[181]595
[565]596##class StudentSemester(CPSDocument): ###(
597##    """
598##    WAeUP StudentSemester containing the courses and students
599##    """
600##    meta_type = 'StudentSemester'
601##    portal_type = meta_type
602##    security = ClassSecurityInfo()
603##
604##InitializeClass(StudentSemester)
605##
606##def addStudentSemester(container, id, REQUEST=None, **kw):
607##    """Add a StudentSemester."""
608##    ob = StudentSemester(id, **kw)
609##    return CPSBase_adder(container, ob, REQUEST=REQUEST)
610##
611#####)
[464]612
[565]613##class Semester(CPSDocument): ###(
614##    """
615##    WAeUP Semester containing the courses and students
616##    """
617##    meta_type = 'Semester'
618##    portal_type = meta_type
619##    security = ClassSecurityInfo()
620##
621##InitializeClass(Semester)
622##
623##def addSemester(container, id, REQUEST=None, **kw):
624##    """Add a Semester."""
625##    ob = Semester(id, **kw)
626##    return CPSBase_adder(container, ob, REQUEST=REQUEST)
627##
628#####)
629##
[464]630
631class StudentCourseResult(CPSDocument): ###(
[89]632    """
[464]633    WAeUP StudentCourseResult
[89]634    """
[464]635    meta_type = 'StudentCourseResult'
[89]636    portal_type = meta_type
637    security = ClassSecurityInfo()
[472]638
[454]639    def getCourseEntry(self,cid):
[464]640        res = self.portal_catalog({'meta_type': "StudentCourse",
[454]641                                           'id': cid})
642        if res:
643            return res[-1]
644        else:
645            return None
[154]646
[454]647    security.declareProtected(View,"Title")
648    def Title(self):
649        """compose title"""
650        cid = self.getId()
651        ce = self.getCourseEntry(cid)
652        if ce:
653            return "%s" % ce.Title
654        return "No course with id %s" % cid
[152]655
[464]656InitializeClass(StudentCourseResult)
[454]657
[464]658def addStudentCourseResult(container, id, REQUEST=None, **kw):
659    """Add a StudentCourseResult."""
660    ob = StudentCourseResult(id, **kw)
[89]661    return CPSBase_adder(container, ob, REQUEST=REQUEST)
[139]662###)
663
Note: See TracBrowser for help on using the repository browser.