source: WAeUP_SRP/trunk/Students.py @ 514

Last change on this file since 514 was 512, checked in by joachim, 18 years ago

fixed app_doc bug

  • Property svn:keywords set to Id
File size: 28.7 KB
RevLine 
[57]1#-*- mode: python; mode: fold -*-
[200]2# $Id: Students.py 512 2006-09-13 10:56:29Z 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'))
[393]195        return self.students.academics_contents()
[361]196    ###)
[382]197
[398]198    security.declareProtected(ModifyPortalContent,"loadFullTimeStudentsResultsFromCSV") ###(
[396]199    def loadFullTimeStudentsResultsFromCSV(self):
200        """load Fulltime Studentdata from CSV values"""
201        #return
[398]202        import transaction
203        tr_count = 0
204        name = 'short_full_time_results_2004_2005'
[396]205        no_import = False
206        if not no_import:
207            no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w")
208            no_import.write('"Matnumber","CosCode","Ansbook","CosStuatus","Session","Mat_Cos","Score","CarryLevel","Grade","Weight","Semster","Verdict","Level","id","GPA"\n')
209        logger = logging.getLogger('%s_import' % name)
210        logger.info('Start loading from %s.csv' % name)
211        students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
212        try:
213            results = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
214        except:
215            logger.error('Error reading %s.csv' % name)
216            return
[398]217        l = self.portal_catalog({'meta_type': "Course"})
218        courses = {}
219        for c in l:
220            courses[c.id] = c.getObject()
[396]221        for result in results:
222            sid = result.get('Matnumber')
[452]223            res = self.portal_catalog({'meta_type': "StudentClearance",
224                                     'matric_no': sid })
225            if not res:
[398]226                em = 'Student with ID %(Matnumber)s not found\n' % result
[396]227                logger.info(em)
228                no_import.write(em)
[398]229                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]230                continue
[452]231            sf = res[0].getObject().aq_parent
[454]232            result['StudentId'] = sf.getId()
[398]233            course = result.get('CosCode')
234            if course not in courses.keys():
235                em = 'Course with ID %(CosCode)s not found\n' % result
[396]236                logger.info(em)
237                no_import.write(em)
[398]238                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]239                continue
[398]240            level = result.get('Level')
[426]241            try:
[396]242                int(level)
243            except:
[398]244                em = 'Result for result with ID %(Matnumber)s Course %(CosCode)s Level is empty\n' % result
[396]245                logger.info(em)
246                no_import.write(em)
[398]247                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]248                continue
249            sc = getattr(sf,'study_course')
250            l = getattr(sc,level,None)
251            if l is None:
252                #self.log('Creating Department %(DeptCode)s = %(Description)s' % dep)
[454]253                logger.info('Creating Level %(Level)s for %(StudentId)s %(Matnumber)s' % result)
254                sc.invokeFactory('StudentStudyLevel', level)
[396]255                l = getattr(sc, level)
[464]256                l.invokeFactory('StudentSemester','first')
257                l.invokeFactory('StudentSemester','second')
[396]258                first_s = getattr(l,'first')
259                first_s.getContent().edit(mapping={'Title': 'First Semester'})
260                second_s = getattr(l,'second')
261                second_s.getContent().edit(mapping={'Title': 'Second Semester'})
[454]262            snr = result.get('Semster')
[396]263            semester = getattr(l,'first')
[398]264            if snr == "2":
[396]265                semester = getattr(l,'second')
[464]266            logger.info('Creating StudentCourseResult %(CosCode)s in Level %(Level)s for %(StudentId)s %(Matnumber)s' % result)
267            semester.invokeFactory('StudentCourseResult',course)
[398]268            ct = getattr(semester,course)
269            d = {}
[454]270            dlev = {}
[398]271            d['ansbook'] = result.get('Ansbook')
272            d['status'] = result.get('CosStuatus')
273            d['score'] = result.get('Score')
[454]274            dlev['session'] = result.get('Session')
275            dlev['carry_level'] = result.get('CarryLevel')
[398]276            d['grade'] = result.get('Grade')
[454]277            #d['weight'] = result.get('Weight')
278            dlev['verdict'] = result.get('Verdict')
279            #d['import_id'] = result.get('id')
280            #gpa = result.get('GPA').replace(',','.')
281            #d['gpa'] = float(gpa)
[398]282            ct.getContent().edit(mapping = d)
[454]283            l.getContent().edit(mapping = dlev)
[398]284            if tr_count > MAX_TRANS:
285                transaction.commit()
286                tr_count = 0
287            tr_count += 1
288        return self.students.academics_contents()
[426]289
[398]290###)
[396]291
[457]292    security.declareProtected(ModifyPortalContent,"loadJAMBFromCSV")###(
293    def loadJAMBFromCSV(self):
294        """load JAMB data from CSV values"""
295        #return
296        students_folder = self.portal_catalog({'meta_type': 'StudentsFolder'})[-1].getObject()
297        import transaction
298        tr_count = 0
[511]299        name = 'SampleJAMBDataII_short'
300        wftool = self.portal_workflow
[457]301        no_import = False
302        if not no_import:
303            no_import = open("%s/import/%s_not_imported.csv" % (i_home,name),"w")
304            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')
305        logger = logging.getLogger('%s_import' % name)
306        logger.info('Start loading from %s.csv' % name)
307        try:
308            result = csv.DictReader(open("%s/import/%s.csv" % (i_home,name),"rb"))
309        except:
310            logger.error('Error reading %s.csv' % name)
311            return
312        for jamb in result:
313            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)
314            jamb_reg_no = jamb.get('REG-NO')
[472]315            res = self.portal_catalog({'meta_type': "StudentApplication",
[457]316                                     'jamb_reg_no': jamb_reg_no })
317            if res:
318                em = 'Student with REG-NO %(REG-NO)s already exists\n' % jamb
319                logger.info(em)
320                no_import.write(em)
321                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)
322                continue
[511]323            jamb_name = jamb.get("NAME")
324            names = jamb_name.split()
325            letter = names[-1][0].upper()
326            sid = generateStudentId(letter)
[457]327            #self.log('Creating Faculty %(id)s = %(Title)s' % faculty)
328            not_created = True
329            while not_created:
330                try:
331                    students_folder.invokeFactory('Student', sid)
332                    not_created = False
333                except BadRequest:
[511]334                    sid = generateStudentId(letter)
[457]335            logger.info('%(tr_count)s: Creating Student with ID %(sid)s REG-NO %(jamb_reg_no)s ' % vars())
[511]336            student = getattr(self,sid)
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)
352            wftool.doActionFor(app,'open',dest_container=app)
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',
412                                     'Owner'),
413                             domains='',
414                             properties = None,)
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
[458]507class StudyLevel(CPSDocument): ###(
508    """
509    WAeUP StudyLevel containing the courses and students
510    """
511    meta_type = 'StudyLevel'
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
[472]520
[458]521InitializeClass(StudyLevel)
522
523def addStudyLevel(container, id, REQUEST=None, **kw):
524    """Add a StudyLevel."""
525    ob = StudyLevel(id, **kw)
526    return CPSBase_adder(container, ob, REQUEST=REQUEST)
527
528###)
529
[454]530class StudentStudyLevel(CPSDocument): ###(
531    """
532    WAeUP Student container for the various student data
533    """
534    meta_type = 'StudentStudyLevel'
535    portal_type = meta_type
536    security = ClassSecurityInfo()
537
538    security.declareProtected(View,"Title")
539    def Title(self):
540        """compose title"""
541        return "Level %s" % self.aq_parent.getId()
542
543    security.declareProtected(View,"gpa")
544    def gpa(self):
545        """calculate the gpa"""
546        sum = 0
547        course_count = 0
548        for semester in ('first','second'):
549            sf=getattr(self,semester)
550            for sc in sf.objectValues():
551                result = sc.getContent()
552                res = self.portal_catalog({'meta_type': 'Course',
553                                              'id': sc.aq_parent.id})
554                if len(res) != 1:
555                    continue
556                course = res[0].getObject().getContent()
557                sum += course.credits * ['F','E','D','C','B','A'].index(result.grade)
558                course_count += 1
559        if course_count:
560            return sum/course_count
561        return 0.0
[472]562
[454]563InitializeClass(StudentStudyLevel)
564
565def addStudentStudyLevel(container, id, REQUEST=None, **kw):
566    """Add a Students personal data."""
567    ob = StudentStudyLevel(id, **kw)
568    return CPSBase_adder(container, ob, REQUEST=REQUEST)
569
570###)
571
[362]572class StudentStudyCourse(CPSDocument): ###(
573    """
574    WAeUP Student container for the various student data
575    """
576    meta_type = 'StudentStudyCourse'
577    portal_type = meta_type
578    security = ClassSecurityInfo()
579
[364]580    security.declareProtected(View,"Title")
581    def Title(self):
582        """compose title"""
583        content = self.getContent()
[453]584        return "Study Course"
[362]585
586
587InitializeClass(StudentStudyCourse)
588
589def addStudentStudyCourse(container, id, REQUEST=None, **kw):
590    """Add a Students personal data."""
591    ob = StudentStudyCourse(id, **kw)
592    return CPSBase_adder(container, ob, REQUEST=REQUEST)
593
594###)
595
[472]596class StudentApplication(CPSDocument): ###(
[179]597    """
598    WAeUP Student container for the various student data
599    """
[472]600    meta_type = 'StudentApplication'
[179]601    portal_type = meta_type
602    security = ClassSecurityInfo()
603
[181]604    security.declareProtected(View,"Title")
605    def Title(self):
606        """compose title"""
[472]607        return "Application Data"
[179]608
[181]609
[472]610InitializeClass(StudentApplication)
[179]611
[472]612def addStudentApplication(container, id, REQUEST=None, **kw):
[179]613    """Add a Students eligibility data."""
[472]614    ob = StudentApplication(id, **kw)
[179]615    return CPSBase_adder(container, ob, REQUEST=REQUEST)
616
617###)
[181]618
[464]619class StudentSemester(CPSDocument): ###(
620    """
621    WAeUP StudentSemester containing the courses and students
622    """
623    meta_type = 'StudentSemester'
624    portal_type = meta_type
625    security = ClassSecurityInfo()
626
627InitializeClass(StudentSemester)
628
629def addStudentSemester(container, id, REQUEST=None, **kw):
630    """Add a StudentSemester."""
631    ob = StudentSemester(id, **kw)
632    return CPSBase_adder(container, ob, REQUEST=REQUEST)
633
634###)
635
[454]636class Semester(CPSDocument): ###(
[166]637    """
[454]638    WAeUP Semester containing the courses and students
[166]639    """
[454]640    meta_type = 'Semester'
[166]641    portal_type = meta_type
642    security = ClassSecurityInfo()
643
[454]644InitializeClass(Semester)
[166]645
[454]646def addSemester(container, id, REQUEST=None, **kw):
647    """Add a Semester."""
648    ob = Semester(id, **kw)
[166]649    return CPSBase_adder(container, ob, REQUEST=REQUEST)
650
651###)
652
[464]653class StudentCourseResult(CPSDocument): ###(
[89]654    """
[464]655    WAeUP StudentCourseResult
[89]656    """
[464]657    meta_type = 'StudentCourseResult'
[89]658    portal_type = meta_type
659    security = ClassSecurityInfo()
[472]660
[454]661    def getCourseEntry(self,cid):
[464]662        res = self.portal_catalog({'meta_type': "StudentCourse",
[454]663                                           'id': cid})
664        if res:
665            return res[-1]
666        else:
667            return None
[154]668
[454]669    security.declareProtected(View,"Title")
670    def Title(self):
671        """compose title"""
672        cid = self.getId()
673        ce = self.getCourseEntry(cid)
674        if ce:
675            return "%s" % ce.Title
676        return "No course with id %s" % cid
[152]677
[464]678InitializeClass(StudentCourseResult)
[454]679
[464]680def addStudentCourseResult(container, id, REQUEST=None, **kw):
681    """Add a StudentCourseResult."""
682    ob = StudentCourseResult(id, **kw)
[89]683    return CPSBase_adder(container, ob, REQUEST=REQUEST)
[139]684###)
685
Note: See TracBrowser for help on using the repository browser.