Context navigation

source: WAeUP_SRP/trunk/Students.py @ 458

Last change on this file since 458 was 458, checked in by joachim, 19 years ago
moved StudyLevel? class from Academics.py back to Students.py, cause this Change broke existing StudyLevel? Objects.
Property svn:keywords set to `Id`
File size: 26.3 KB

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

Note: See TracBrowser for help on using the repository browser.

Download in other formats: