[57] | 1 | #-*- mode: python; mode: fold -*- |
---|
[200] | 2 | # $Id: Students.py 512 2006-09-13 10:56:29Z joachim $ |
---|
[45] | 3 | from Globals import InitializeClass |
---|
| 4 | from AccessControl import ClassSecurityInfo |
---|
[164] | 5 | from AccessControl.SecurityManagement import newSecurityManager |
---|
[429] | 6 | from zExceptions import BadRequest |
---|
[502] | 7 | from Products.ZCatalog.ZCatalog import ZCatalog |
---|
[47] | 8 | from Products.CMFCore.utils import UniqueObject, getToolByName |
---|
[45] | 9 | from Products.CMFCore.permissions import View |
---|
| 10 | from Products.CMFCore.permissions import ModifyPortalContent |
---|
[154] | 11 | from Products.CPSCore.CPSBase import CPSBase_adder, CPSBaseFolder |
---|
| 12 | #from Products.CPSCore.CPSBase import CPSBaseDocument as BaseDocument |
---|
| 13 | from Products.CPSDocument.CPSDocument import CPSDocument |
---|
| 14 | from Products.CPSCore.CPSBase import CPSBaseBTreeFolder as BaseBTreeFolder |
---|
[164] | 15 | from Products.CPSCore.CPSMembershipTool import CPSUnrestrictedUser |
---|
[361] | 16 | from Products.WAeUP_SRP.Academics import makeCertificateCode |
---|
[362] | 17 | import logging |
---|
| 18 | import csv,re |
---|
| 19 | import Globals |
---|
| 20 | p_home = Globals.package_home(globals()) |
---|
| 21 | i_home = Globals.INSTANCE_HOME |
---|
[398] | 22 | MAX_TRANS = 1000 |
---|
[154] | 23 | |
---|
[511] | 24 | def 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] | 32 | def 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] | 41 | class 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 | |
---|
| 374 | InitializeClass(StudentsFolder) |
---|
| 375 | |
---|
| 376 | def 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] | 382 | class 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] | 448 | InitializeClass(Student) |
---|
| 449 | |
---|
| 450 | def 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] | 457 | class 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] | 473 | InitializeClass(StudentPersonal) |
---|
| 474 | |
---|
| 475 | def 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] | 482 | class 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 | |
---|
| 498 | InitializeClass(StudentClearance) |
---|
| 499 | |
---|
| 500 | def 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] | 507 | class 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] | 521 | InitializeClass(StudyLevel) |
---|
| 522 | |
---|
| 523 | def 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] | 530 | class 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] | 563 | InitializeClass(StudentStudyLevel) |
---|
| 564 | |
---|
| 565 | def 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] | 572 | class 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 | |
---|
| 587 | InitializeClass(StudentStudyCourse) |
---|
| 588 | |
---|
| 589 | def 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] | 596 | class 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] | 610 | InitializeClass(StudentApplication) |
---|
[179] | 611 | |
---|
[472] | 612 | def 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] | 619 | class 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 | |
---|
| 627 | InitializeClass(StudentSemester) |
---|
| 628 | |
---|
| 629 | def 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] | 636 | class 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] | 644 | InitializeClass(Semester) |
---|
[166] | 645 | |
---|
[454] | 646 | def 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] | 653 | class 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] | 678 | InitializeClass(StudentCourseResult) |
---|
[454] | 679 | |
---|
[464] | 680 | def 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 | |
---|