source: main/waeup.kofa/trunk/src/waeup/kofa/students/tests/test_browser.py @ 10636

Last change on this file since 10636 was 10636, checked in by Henrik Bettermann, 11 years ago

Add test to ensure that non-integer scores don't cause a traceback.

  • Property svn:keywords set to Id
File size: 176.1 KB
Line 
1## $Id: test_browser.py 10636 2013-09-22 04:09:57Z henrik $
2##
3## Copyright (C) 2011 Uli Fouquet & Henrik Bettermann
4## This program is free software; you can redistribute it and/or modify
5## it under the terms of the GNU General Public License as published by
6## the Free Software Foundation; either version 2 of the License, or
7## (at your option) any later version.
8##
9## This program is distributed in the hope that it will be useful,
10## but WITHOUT ANY WARRANTY; without even the implied warranty of
11## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
12## GNU General Public License for more details.
13##
14## You should have received a copy of the GNU General Public License
15## along with this program; if not, write to the Free Software
16## Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
17##
18"""
19Test the student-related UI components.
20"""
21import shutil
22import tempfile
23import pytz
24import base64
25from datetime import datetime, timedelta, date
26from StringIO import StringIO
27import os
28import grok
29from zc.async.testing import wait_for_result
30from zope.event import notify
31from zope.component import createObject, queryUtility, getUtility
32from zope.component.hooks import setSite, clearSite
33from zope.catalog.interfaces import ICatalog
34from zope.security.interfaces import Unauthorized
35from zope.securitypolicy.interfaces import IPrincipalRoleManager
36from zope.testbrowser.testing import Browser
37from hurry.workflow.interfaces import IWorkflowInfo, IWorkflowState
38from waeup.kofa.testing import FunctionalLayer, FunctionalTestCase
39from waeup.kofa.app import University
40from waeup.kofa.payments.interfaces import IPayer
41from waeup.kofa.students.interfaces import IStudentsUtils
42from waeup.kofa.students.student import Student
43from waeup.kofa.students.studylevel import StudentStudyLevel
44from waeup.kofa.university.faculty import Faculty
45from waeup.kofa.university.department import Department
46from waeup.kofa.interfaces import IUserAccount, IJobManager
47from waeup.kofa.authentication import LocalRoleSetEvent
48from waeup.kofa.hostels.hostel import Hostel, Bed, NOT_OCCUPIED
49from waeup.kofa.tests.test_async import FunctionalAsyncTestCase
50from waeup.kofa.browser.tests.test_pdf import samples_dir
51
52PH_LEN = 15911  # Length of placeholder file
53
54SAMPLE_IMAGE = os.path.join(os.path.dirname(__file__), 'test_image.jpg')
55SAMPLE_IMAGE_BMP = os.path.join(os.path.dirname(__file__), 'test_image.bmp')
56
57def lookup_submit_value(name, value, browser):
58    """Find a button with a certain value."""
59    for num in range(0, 100):
60        try:
61            button = browser.getControl(name=name, index=num)
62            if button.value.endswith(value):
63                return button
64        except IndexError:
65            break
66    return None
67
68class StudentsFullSetup(FunctionalTestCase):
69    # A test case that only contains a setup and teardown
70    #
71    # Complete setup for students handlings is rather complex and
72    # requires lots of things created before we can start. This is a
73    # setup that does all this, creates a university, creates PINs,
74    # etc.  so that we do not have to bother with that in different
75    # test cases.
76
77    layer = FunctionalLayer
78
79    def setUp(self):
80        super(StudentsFullSetup, self).setUp()
81
82        # Setup a sample site for each test
83        app = University()
84        self.dc_root = tempfile.mkdtemp()
85        app['datacenter'].setStoragePath(self.dc_root)
86
87        # Prepopulate the ZODB...
88        self.getRootFolder()['app'] = app
89        # we add the site immediately after creation to the
90        # ZODB. Catalogs and other local utilities are not setup
91        # before that step.
92        self.app = self.getRootFolder()['app']
93        # Set site here. Some of the following setup code might need
94        # to access grok.getSite() and should get our new app then
95        setSite(app)
96
97        # Add student with subobjects
98        student = createObject('waeup.Student')
99        student.firstname = u'Anna'
100        student.lastname = u'Tester'
101        student.reg_number = u'123'
102        student.matric_number = u'234'
103        student.sex = u'm'
104        student.email = 'aa@aa.ng'
105        student.phone = u'1234'
106        self.app['students'].addStudent(student)
107        self.student_id = student.student_id
108        self.student = self.app['students'][self.student_id]
109
110        # Set password
111        IUserAccount(
112            self.app['students'][self.student_id]).setPassword('spwd')
113
114        self.login_path = 'http://localhost/app/login'
115        self.container_path = 'http://localhost/app/students'
116        self.manage_container_path = self.container_path + '/@@manage'
117        self.add_student_path = self.container_path + '/addstudent'
118        self.student_path = self.container_path + '/' + self.student_id
119        self.manage_student_path = self.student_path + '/manage_base'
120        self.trigtrans_path = self.student_path + '/trigtrans'
121        self.clearance_path = self.student_path + '/view_clearance'
122        self.personal_path = self.student_path + '/view_personal'
123        self.edit_clearance_path = self.student_path + '/cedit'
124        self.manage_clearance_path = self.student_path + '/manage_clearance'
125        self.edit_personal_path = self.student_path + '/edit_personal'
126        self.manage_personal_path = self.student_path + '/manage_personal'
127        self.studycourse_path = self.student_path + '/studycourse'
128        self.payments_path = self.student_path + '/payments'
129        self.acco_path = self.student_path + '/accommodation'
130        self.history_path = self.student_path + '/history'
131
132        # Create 5 access codes with prefix'PWD'
133        pin_container = self.app['accesscodes']
134        pin_container.createBatch(
135            datetime.utcnow(), 'some_userid', 'PWD', 9.99, 5)
136        pins = pin_container['PWD-1'].values()
137        self.pwdpins = [x.representation for x in pins]
138        self.existing_pwdpin = self.pwdpins[0]
139        parts = self.existing_pwdpin.split('-')[1:]
140        self.existing_pwdseries, self.existing_pwdnumber = parts
141        # Create 5 access codes with prefix 'CLR'
142        pin_container.createBatch(
143            datetime.now(), 'some_userid', 'CLR', 9.99, 5)
144        pins = pin_container['CLR-1'].values()
145        pins[0].owner = u'Hans Wurst'
146        self.existing_clrac = pins[0]
147        self.existing_clrpin = pins[0].representation
148        parts = self.existing_clrpin.split('-')[1:]
149        self.existing_clrseries, self.existing_clrnumber = parts
150        # Create 2 access codes with prefix 'HOS'
151        pin_container.createBatch(
152            datetime.now(), 'some_userid', 'HOS', 9.99, 2)
153        pins = pin_container['HOS-1'].values()
154        self.existing_hosac = pins[0]
155        self.existing_hospin = pins[0].representation
156        parts = self.existing_hospin.split('-')[1:]
157        self.existing_hosseries, self.existing_hosnumber = parts
158
159        # Populate university
160        self.certificate = createObject('waeup.Certificate')
161        self.certificate.code = u'CERT1'
162        self.certificate.application_category = 'basic'
163        self.certificate.study_mode = 'ug_ft'
164        self.certificate.start_level = 100
165        self.certificate.end_level = 500
166        self.certificate.school_fee_1 = 40000.0
167        self.certificate.school_fee_2 = 20000.0
168        self.app['faculties']['fac1'] = Faculty(code=u'fac1')
169        self.app['faculties']['fac1']['dep1'] = Department(code=u'dep1')
170        self.app['faculties']['fac1']['dep1'].certificates.addCertificate(
171            self.certificate)
172        self.course = createObject('waeup.Course')
173        self.course.code = 'COURSE1'
174        self.course.semester = 1
175        self.course.credits = 10
176        self.course.passmark = 40
177        self.app['faculties']['fac1']['dep1'].courses.addCourse(
178            self.course)
179        self.app['faculties']['fac1']['dep1'].certificates['CERT1'].addCertCourse(
180            self.course, level=100)
181
182        # Configure university and hostels
183        self.app['hostels'].accommodation_states = ['admitted']
184        self.app['hostels'].accommodation_session = 2004
185        delta = timedelta(days=10)
186        self.app['hostels'].startdate = datetime.now(pytz.utc) - delta
187        self.app['hostels'].enddate = datetime.now(pytz.utc) + delta
188        self.app['configuration'].carry_over = True
189        configuration = createObject('waeup.SessionConfiguration')
190        configuration.academic_session = 2004
191        configuration.clearance_fee = 3456.0
192        configuration.transcript_fee = 4567.0
193        configuration.booking_fee = 123.4
194        configuration.maint_fee = 987.0
195        self.app['configuration'].addSessionConfiguration(configuration)
196
197        # Create a hostel with two beds
198        hostel = Hostel()
199        hostel.hostel_id = u'hall-1'
200        hostel.hostel_name = u'Hall 1'
201        self.app['hostels'].addHostel(hostel)
202        bed = Bed()
203        bed.bed_id = u'hall-1_A_101_A'
204        bed.bed_number = 1
205        bed.owner = NOT_OCCUPIED
206        bed.bed_type = u'regular_male_fr'
207        self.app['hostels'][hostel.hostel_id].addBed(bed)
208        bed = Bed()
209        bed.bed_id = u'hall-1_A_101_B'
210        bed.bed_number = 2
211        bed.owner = NOT_OCCUPIED
212        bed.bed_type = u'regular_female_fr'
213        self.app['hostels'][hostel.hostel_id].addBed(bed)
214
215        # Set study course attributes of test student
216        self.student['studycourse'].certificate = self.certificate
217        self.student['studycourse'].current_session = 2004
218        self.student['studycourse'].entry_session = 2004
219        self.student['studycourse'].current_verdict = 'A'
220        self.student['studycourse'].current_level = 100
221        # Update the catalog
222        notify(grok.ObjectModifiedEvent(self.student))
223
224        # Put the prepopulated site into test ZODB and prepare test
225        # browser
226        self.browser = Browser()
227        self.browser.handleErrors = False
228
229    def tearDown(self):
230        super(StudentsFullSetup, self).tearDown()
231        clearSite()
232        shutil.rmtree(self.dc_root)
233
234
235
236class StudentsContainerUITests(StudentsFullSetup):
237    # Tests for StudentsContainer class views and pages
238
239    layer = FunctionalLayer
240
241    def test_anonymous_access(self):
242        # Anonymous users can't access students containers
243        self.assertRaises(
244            Unauthorized, self.browser.open, self.container_path)
245        self.assertRaises(
246            Unauthorized, self.browser.open, self.manage_container_path)
247        return
248
249    def test_manage_access(self):
250        # Managers can access the view page of students
251        # containers and can perform actions
252        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
253        self.browser.open(self.container_path)
254        self.assertEqual(self.browser.headers['Status'], '200 Ok')
255        self.assertEqual(self.browser.url, self.container_path)
256        self.browser.getLink("Manage student section").click()
257        self.assertEqual(self.browser.headers['Status'], '200 Ok')
258        self.assertEqual(self.browser.url, self.manage_container_path)
259        return
260
261    def test_add_search_delete_students(self):
262        # Managers can add search and remove students
263        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
264        self.browser.open(self.manage_container_path)
265        self.browser.getLink("Add student").click()
266        self.assertEqual(self.browser.headers['Status'], '200 Ok')
267        self.assertEqual(self.browser.url, self.add_student_path)
268        self.browser.getControl(name="form.firstname").value = 'Bob'
269        self.browser.getControl(name="form.lastname").value = 'Tester'
270        self.browser.getControl(name="form.reg_number").value = '123'
271        self.browser.getControl("Create student record").click()
272        self.assertTrue('Registration number exists already'
273            in self.browser.contents)
274        self.browser.getControl(name="form.reg_number").value = '1234'
275        self.browser.getControl("Create student record").click()
276        self.assertTrue('Student record created' in self.browser.contents)
277
278        # Registration and matric numbers must be unique
279        self.browser.getLink("Manage").click()
280        self.browser.getControl(name="form.reg_number").value = '123'
281        self.browser.getControl("Save").click()
282        self.assertMatches('...Registration number exists...',
283                           self.browser.contents)
284        self.browser.getControl(name="form.reg_number").value = '789'
285        self.browser.getControl(name="form.matric_number").value = '234'
286        self.browser.getControl("Save").click()
287        self.assertMatches('...Matriculation number exists...',
288                           self.browser.contents)
289
290        # We can find a student with a certain student_id
291        self.browser.open(self.container_path)
292        self.browser.getControl("Search").click()
293        self.assertTrue('Empty search string' in self.browser.contents)
294        self.browser.getControl(name="searchtype").value = ['student_id']
295        self.browser.getControl(name="searchterm").value = self.student_id
296        self.browser.getControl("Search").click()
297        self.assertTrue('Anna Tester' in self.browser.contents)
298
299        # We can find a student in a certain session
300        self.browser.open(self.container_path)
301        self.browser.getControl(name="searchtype").value = ['current_session']
302        self.browser.getControl(name="searchterm").value = '2004'
303        self.browser.getControl("Search").click()
304        self.assertTrue('Anna Tester' in self.browser.contents)
305        # Session fileds require integer values
306        self.browser.open(self.container_path)
307        self.browser.getControl(name="searchtype").value = ['current_session']
308        self.browser.getControl(name="searchterm").value = '2004/2005'
309        self.browser.getControl("Search").click()
310        self.assertTrue('Only year dates allowed' in self.browser.contents)
311        self.browser.open(self.manage_container_path)
312        self.browser.getControl(name="searchtype").value = ['current_session']
313        self.browser.getControl(name="searchterm").value = '2004/2005'
314        self.browser.getControl("Search").click()
315        self.assertTrue('Only year dates allowed' in self.browser.contents)
316
317        # We can find a student in a certain study_mode
318        self.browser.open(self.container_path)
319        self.browser.getControl(name="searchtype").value = ['current_mode']
320        self.browser.getControl(name="searchterm").value = 'ug_ft'
321        self.browser.getControl("Search").click()
322        self.assertTrue('Anna Tester' in self.browser.contents)
323
324        # We can find a student in a certain department
325        self.browser.open(self.container_path)
326        self.browser.getControl(name="searchtype").value = ['depcode']
327        self.browser.getControl(name="searchterm").value = 'dep1'
328        self.browser.getControl("Search").click()
329        self.assertTrue('Anna Tester' in self.browser.contents)
330
331        # We can find a student by searching for all kind of name parts
332        self.browser.open(self.manage_container_path)
333        self.browser.getControl("Search").click()
334        self.assertTrue('Empty search string' in self.browser.contents)
335        self.browser.getControl(name="searchtype").value = ['fullname']
336        self.browser.getControl(name="searchterm").value = 'Anna Tester'
337        self.browser.getControl("Search").click()
338        self.assertTrue('Anna Tester' in self.browser.contents)
339        self.browser.open(self.manage_container_path)
340        self.browser.getControl(name="searchtype").value = ['fullname']
341        self.browser.getControl(name="searchterm").value = 'Anna'
342        self.browser.getControl("Search").click()
343        self.assertTrue('Anna Tester' in self.browser.contents)
344        self.browser.open(self.manage_container_path)
345        self.browser.getControl(name="searchtype").value = ['fullname']
346        self.browser.getControl(name="searchterm").value = 'Tester'
347        self.browser.getControl("Search").click()
348        self.assertTrue('Anna Tester' in self.browser.contents)
349        self.browser.open(self.manage_container_path)
350        self.browser.getControl(name="searchtype").value = ['fullname']
351        self.browser.getControl(name="searchterm").value = 'An'
352        self.browser.getControl("Search").click()
353        self.assertFalse('Anna Tester' in self.browser.contents)
354        self.browser.open(self.manage_container_path)
355        self.browser.getControl(name="searchtype").value = ['fullname']
356        self.browser.getControl(name="searchterm").value = 'An*'
357        self.browser.getControl("Search").click()
358        self.assertTrue('Anna Tester' in self.browser.contents)
359        self.browser.open(self.manage_container_path)
360        self.browser.getControl(name="searchtype").value = ['fullname']
361        self.browser.getControl(name="searchterm").value = 'tester'
362        self.browser.getControl("Search").click()
363        self.assertTrue('Anna Tester' in self.browser.contents)
364        self.browser.open(self.manage_container_path)
365        self.browser.getControl(name="searchtype").value = ['fullname']
366        self.browser.getControl(name="searchterm").value = 'Tester Ana'
367        self.browser.getControl("Search").click()
368        self.assertFalse('Anna Tester' in self.browser.contents)
369        self.browser.open(self.manage_container_path)
370        self.browser.getControl(name="searchtype").value = ['fullname']
371        self.browser.getControl(name="searchterm").value = 'Tester Anna'
372        self.browser.getControl("Search").click()
373        self.assertTrue('Anna Tester' in self.browser.contents)
374        # The old searchterm will be used again
375        self.browser.getControl("Search").click()
376        self.assertTrue('Anna Tester' in self.browser.contents)
377
378        # We can find suspended students
379        self.student.suspended = True
380        notify(grok.ObjectModifiedEvent(self.student))
381        self.browser.open(self.manage_container_path)
382        self.browser.getControl(name="searchtype").value = ['suspended']
383        self.browser.getControl("Search").click()
384        self.assertTrue('Anna Tester' in self.browser.contents)
385        self.browser.open(self.container_path)
386        self.browser.getControl(name="searchtype").value = ['suspended']
387        self.browser.getControl("Search").click()
388        self.assertTrue('Anna Tester' in self.browser.contents)
389
390        # The catalog is informed when studycourse objects have been
391        # edited
392        self.browser.open(self.studycourse_path + '/manage')
393        self.browser.getControl(name="form.current_session").value = ['2010']
394        self.browser.getControl(name="form.entry_session").value = ['2010']
395        self.browser.getControl(name="form.entry_mode").value = ['ug_ft']
396        self.browser.getControl("Save").click()
397
398        # We can find the student in the new session
399        self.browser.open(self.manage_container_path)
400        self.browser.getControl(name="searchtype").value = ['current_session']
401        self.browser.getControl(name="searchterm").value = '2010'
402        self.browser.getControl("Search").click()
403        self.assertTrue('Anna Tester' in self.browser.contents)
404
405        ctrl = self.browser.getControl(name='entries')
406        ctrl.getControl(value=self.student_id).selected = True
407        self.browser.getControl("Remove selected", index=0).click()
408        self.assertTrue('Successfully removed' in self.browser.contents)
409        self.browser.getControl(name="searchtype").value = ['student_id']
410        self.browser.getControl(name="searchterm").value = self.student_id
411        self.browser.getControl("Search").click()
412        self.assertTrue('No student found' in self.browser.contents)
413
414        self.browser.open(self.container_path)
415        self.browser.getControl(name="searchtype").value = ['student_id']
416        self.browser.getControl(name="searchterm").value = self.student_id
417        self.browser.getControl("Search").click()
418        self.assertTrue('No student found' in self.browser.contents)
419        return
420
421class OfficerUITests(StudentsFullSetup):
422    # Tests for Student class views and pages
423
424    def test_student_properties(self):
425        self.student['studycourse'].current_level = 100
426        self.assertEqual(self.student.current_level, 100)
427        self.student['studycourse'].current_session = 2011
428        self.assertEqual(self.student.current_session, 2011)
429        self.student['studycourse'].current_verdict = 'A'
430        self.assertEqual(self.student.current_verdict, 'A')
431        return
432
433    def test_studylevelmanagepage(self):
434        studylevel = StudentStudyLevel()
435        studylevel.level = 100
436        cert = self.app['faculties']['fac1']['dep1'].certificates['CERT1']
437        self.student['studycourse'].addStudentStudyLevel(
438            cert,studylevel)
439        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
440        self.browser.open(self.studycourse_path + '/100/manage')
441        self.assertEqual(self.browser.url, self.studycourse_path + '/100/manage')
442        self.assertEqual(self.browser.headers['Status'], '200 Ok')
443
444    def test_basic_auth(self):
445        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
446        self.browser.open('http://localhost/app')
447        self.browser.getLink("Logout").click()
448        self.assertTrue('You have been logged out' in self.browser.contents)
449        # But we are still logged in since we've used basic authentication here.
450        # Wikipedia says: Existing browsers retain authentication information
451        # until the tab or browser is closed or the user clears the history.
452        # HTTP does not provide a method for a server to direct clients to
453        # discard these cached credentials. This means that there is no
454        # effective way for a server to "log out" the user without closing
455        # the browser. This is a significant defect that requires browser
456        # manufacturers to support a "logout" user interface element ...
457        self.assertTrue('Manager' in self.browser.contents)
458
459    def test_basic_auth_base64(self):
460        auth_token = base64.b64encode('mgr:mgrpw')
461        self.browser.addHeader('Authorization', 'Basic %s' % auth_token)
462        self.browser.open(self.manage_container_path)
463        self.assertEqual(self.browser.headers['Status'], '200 Ok')
464
465    def test_manage_access(self):
466        # Managers can access the pages of students
467        # and can perform actions
468        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
469        self.browser.open(self.student_path)
470        self.assertEqual(self.browser.headers['Status'], '200 Ok')
471        self.assertEqual(self.browser.url, self.student_path)
472        self.browser.getLink("Trigger").click()
473        self.assertEqual(self.browser.headers['Status'], '200 Ok')
474        # Managers can trigger transitions
475        self.browser.getControl(name="transition").value = ['admit']
476        self.browser.getControl("Save").click()
477        # Managers can edit base
478        self.browser.open(self.student_path)
479        self.browser.getLink("Manage").click()
480        self.assertEqual(self.browser.url, self.manage_student_path)
481        self.assertEqual(self.browser.headers['Status'], '200 Ok')
482        self.browser.getControl(name="form.firstname").value = 'John'
483        self.browser.getControl(name="form.lastname").value = 'Tester'
484        self.browser.getControl(name="form.reg_number").value = '345'
485        self.browser.getControl(name="password").value = 'secret'
486        self.browser.getControl(name="control_password").value = 'secret'
487        self.browser.getControl("Save").click()
488        self.assertMatches('...Form has been saved...',
489                           self.browser.contents)
490        self.browser.open(self.student_path)
491        self.browser.getLink("Clearance Data").click()
492        self.assertEqual(self.browser.headers['Status'], '200 Ok')
493        self.assertEqual(self.browser.url, self.clearance_path)
494        self.browser.getLink("Manage").click()
495        self.assertEqual(self.browser.headers['Status'], '200 Ok')
496        self.assertEqual(self.browser.url, self.manage_clearance_path)
497        self.browser.getControl(name="form.date_of_birth").value = '09/10/1961'
498        self.browser.getControl("Save").click()
499        self.assertMatches('...Form has been saved...',
500                           self.browser.contents)
501
502        self.browser.open(self.student_path)
503        self.browser.getLink("Personal Data").click()
504        self.assertEqual(self.browser.headers['Status'], '200 Ok')
505        self.assertEqual(self.browser.url, self.personal_path)
506        self.browser.getLink("Manage").click()
507        self.assertEqual(self.browser.headers['Status'], '200 Ok')
508        self.assertEqual(self.browser.url, self.manage_personal_path)
509        self.browser.open(self.personal_path)
510        self.assertTrue('Updated' in self.browser.contents)
511        self.browser.getLink("Edit").click()
512        self.assertEqual(self.browser.headers['Status'], '200 Ok')
513        self.assertEqual(self.browser.url, self.edit_personal_path)
514        self.browser.getControl("Save").click()
515        # perm_address is required in IStudentPersonalEdit
516        self.assertMatches('...Required input is missing...',
517                           self.browser.contents)
518        self.browser.getControl(name="form.perm_address").value = 'My address!'
519        self.browser.getControl("Save").click()
520        self.assertMatches('...Form has been saved...',
521                           self.browser.contents)
522
523        # Managers can browse all subobjects
524        self.browser.open(self.student_path)
525        self.browser.getLink("Payments").click()
526        self.assertEqual(self.browser.headers['Status'], '200 Ok')
527        self.assertEqual(self.browser.url, self.payments_path)
528        self.browser.open(self.student_path)
529        self.browser.getLink("Accommodation").click()
530        self.assertEqual(self.browser.headers['Status'], '200 Ok')
531        self.assertEqual(self.browser.url, self.acco_path)
532        self.browser.open(self.student_path)
533        self.browser.getLink("History").click()
534        self.assertEqual(self.browser.headers['Status'], '200 Ok')
535        self.assertEqual(self.browser.url, self.history_path)
536        self.assertMatches('...Admitted by Manager...',
537                           self.browser.contents)
538        # Only the Application Slip does not exist
539        self.assertFalse('Application Slip' in self.browser.contents)
540        return
541
542    def test_manage_contact_student(self):
543        # Managers can contact student
544        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
545        self.student.email = None
546        self.browser.open(self.student_path)
547        self.browser.getLink("Send email").click()
548        self.browser.getControl(name="form.subject").value = 'Important subject'
549        self.browser.getControl(name="form.body").value = 'Hello!'
550        self.browser.getControl("Send message now").click()
551        self.assertTrue('An smtp server error occurred' in self.browser.contents)
552        self.student.email = 'xx@yy.zz'
553        self.browser.getControl("Send message now").click()
554        self.assertTrue('Your message has been sent' in self.browser.contents)
555        return
556
557    def test_manage_remove_department(self):
558        # Lazy student is studying CERT1
559        lazystudent = Student()
560        lazystudent.firstname = u'Lazy'
561        lazystudent.lastname = u'Student'
562        self.app['students'].addStudent(lazystudent)
563        student_id = lazystudent.student_id
564        student_path = self.container_path + '/' + student_id
565        lazystudent['studycourse'].certificate = self.certificate
566        notify(grok.ObjectModifiedEvent(lazystudent))
567        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
568        self.browser.open(student_path + '/studycourse')
569        self.assertTrue('CERT1' in self.browser.contents)
570        # After some years the department is removed
571        del self.app['faculties']['fac1']['dep1']
572        # So CERT1 does no longer exist and lazy student's
573        # certificate reference is removed too
574        self.browser.open(student_path + '/studycourse')
575        self.assertEqual(self.browser.headers['Status'], '200 Ok')
576        self.assertEqual(self.browser.url, student_path + '/studycourse')
577        self.assertFalse('CERT1' in self.browser.contents)
578        self.assertMatches('...<div>--</div>...',
579                           self.browser.contents)
580
581    def test_manage_upload_file(self):
582        # Managers can upload a file via the StudentClearanceManageFormPage
583        # The image is stored even if form has errors
584        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
585        self.browser.open(self.manage_clearance_path)
586        # No birth certificate has been uploaded yet
587        # Browsing the link shows a placerholder image
588        self.browser.open('birth_certificate')
589        self.assertEqual(
590            self.browser.headers['content-type'], 'image/jpeg')
591        self.assertEqual(len(self.browser.contents), PH_LEN)
592        # Create a pseudo image file and select it to be uploaded in form
593        # as birth certificate
594        self.browser.open(self.manage_clearance_path)
595        image = open(SAMPLE_IMAGE, 'rb')
596        ctrl = self.browser.getControl(name='birthcertificateupload')
597        file_ctrl = ctrl.mech_control
598        file_ctrl.add_file(image, filename='my_birth_certificate.jpg')
599        # The Save action does not upload files
600        self.browser.getControl("Save").click() # submit form
601        self.assertFalse(
602            '<a target="image" href="birth_certificate">'
603            in self.browser.contents)
604        # ... but the correct upload submit button does
605        image = open(SAMPLE_IMAGE)
606        ctrl = self.browser.getControl(name='birthcertificateupload')
607        file_ctrl = ctrl.mech_control
608        file_ctrl.add_file(image, filename='my_birth_certificate.jpg')
609        self.browser.getControl(
610            name='upload_birthcertificateupload').click()
611        # There is a correct <img> link included
612        self.assertTrue(
613            '<a target="image" href="birth_certificate">'
614            in self.browser.contents)
615        # Browsing the link shows a real image
616        self.browser.open('birth_certificate')
617        self.assertEqual(
618            self.browser.headers['content-type'], 'image/jpeg')
619        self.assertEqual(len(self.browser.contents), 2787)
620        # Reuploading a file which is bigger than 150k will raise an error
621        self.browser.open(self.manage_clearance_path)
622        # An image > 150K
623        big_image = StringIO(open(SAMPLE_IMAGE, 'rb').read() * 75)
624        ctrl = self.browser.getControl(name='birthcertificateupload')
625        file_ctrl = ctrl.mech_control
626        file_ctrl.add_file(big_image, filename='my_birth_certificate.jpg')
627        self.browser.getControl(
628            name='upload_birthcertificateupload').click()
629        self.assertTrue(
630            'Uploaded file is too big' in self.browser.contents)
631        # we do not rely on filename extensions given by uploaders
632        image = open(SAMPLE_IMAGE, 'rb') # a jpg-file
633        ctrl = self.browser.getControl(name='birthcertificateupload')
634        file_ctrl = ctrl.mech_control
635        # tell uploaded file is bmp
636        file_ctrl.add_file(image, filename='my_birth_certificate.bmp')
637        self.browser.getControl(
638            name='upload_birthcertificateupload').click()
639        self.assertTrue(
640            # jpg file was recognized
641            'File birth_certificate.jpg uploaded.' in self.browser.contents)
642        # File names must meet several conditions
643        bmp_image = open(SAMPLE_IMAGE_BMP, 'rb')
644        ctrl = self.browser.getControl(name='birthcertificateupload')
645        file_ctrl = ctrl.mech_control
646        file_ctrl.add_file(bmp_image, filename='my_birth_certificate.bmp')
647        self.browser.getControl(
648            name='upload_birthcertificateupload').click()
649        self.assertTrue('Only the following extensions are allowed'
650            in self.browser.contents)
651        # Managers can delete files
652        self.browser.getControl(name='delete_birthcertificateupload').click()
653        self.assertTrue(
654            'birth_certificate deleted' in self.browser.contents)
655
656        # Managers can upload a file via the StudentBaseManageFormPage
657        self.browser.open(self.manage_student_path)
658        image = open(SAMPLE_IMAGE_BMP, 'rb')
659        ctrl = self.browser.getControl(name='passportuploadmanage')
660        file_ctrl = ctrl.mech_control
661        file_ctrl.add_file(image, filename='my_photo.bmp')
662        self.browser.getControl(
663            name='upload_passportuploadmanage').click()
664        self.assertTrue('jpg file extension expected'
665            in self.browser.contents)
666        ctrl = self.browser.getControl(name='passportuploadmanage')
667        file_ctrl = ctrl.mech_control
668        image = open(SAMPLE_IMAGE, 'rb')
669        file_ctrl.add_file(image, filename='my_photo.jpg')
670        self.browser.getControl(
671            name='upload_passportuploadmanage').click()
672        self.assertTrue(
673            '<img align="middle" height="125px" src="passport.jpg" />'
674            in self.browser.contents)
675        # We remove the passport file again
676        self.browser.open(self.manage_student_path)
677        self.browser.getControl('Delete').click()
678        self.browser.open(self.student_path + '/clearance_slip.pdf')
679        self.assertEqual(self.browser.headers['Status'], '200 Ok')
680        self.assertEqual(self.browser.headers['Content-Type'],
681                         'application/pdf')
682
683    def test_manage_course_lists(self):
684        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
685        self.browser.open(self.student_path)
686        self.browser.getLink("Study Course").click()
687        self.assertEqual(self.browser.headers['Status'], '200 Ok')
688        self.assertEqual(self.browser.url, self.studycourse_path)
689        self.assertTrue('Undergraduate Full-Time' in self.browser.contents)
690        self.browser.getLink("Manage").click()
691        self.assertTrue('Manage study course' in self.browser.contents)
692        # Before we can select a level, the certificate must
693        # be selected and saved
694        self.browser.getControl(name="form.certificate").value = ['CERT1']
695        self.browser.getControl(name="form.current_session").value = ['2004']
696        self.browser.getControl(name="form.current_verdict").value = ['A']
697        self.browser.getControl(name="form.entry_mode").value = ['ug_ft']
698        self.browser.getControl("Save").click()
699        # Now we can save also the current level which depends on start and end
700        # level of the certificate
701        self.browser.getControl(name="form.current_level").value = ['100']
702        self.browser.getControl("Save").click()
703        # Managers can add and remove any study level (course list)
704        self.browser.getControl(name="addlevel").value = ['100']
705        self.browser.getControl("Add study level").click()
706        self.assertMatches(
707            '...You must select a session...', self.browser.contents)
708        self.browser.getControl(name="addlevel").value = ['100']
709        self.browser.getControl(name="level_session").value = ['2004']
710        self.browser.getControl("Add study level").click()
711        self.assertMatches('...<span>100</span>...', self.browser.contents)
712        self.assertEqual(self.student['studycourse']['100'].level, 100)
713        self.assertEqual(self.student['studycourse']['100'].level_session, 2004)
714        self.browser.getControl(name="addlevel").value = ['100']
715        self.browser.getControl(name="level_session").value = ['2004']
716        self.browser.getControl("Add study level").click()
717        self.assertMatches('...This level exists...', self.browser.contents)
718        self.browser.getControl("Remove selected").click()
719        self.assertMatches(
720            '...No study level selected...', self.browser.contents)
721        self.browser.getControl(name="val_id").value = ['100']
722        self.browser.getControl(name="level_session").value = ['2004']
723        self.browser.getControl("Remove selected").click()
724        self.assertMatches('...Successfully removed...', self.browser.contents)
725        # Removing levels is properly logged
726        logfile = os.path.join(
727            self.app['datacenter'].storage, 'logs', 'students.log')
728        logcontent = open(logfile).read()
729        self.assertTrue('zope.mgr - students.browser.StudyCourseManageFormPage '
730                        '- K1000000 - removed: 100' in logcontent)
731        # Add level again
732        self.browser.getControl(name="addlevel").value = ['100']
733        self.browser.getControl(name="level_session").value = ['2004']
734        self.browser.getControl("Add study level").click()
735
736        # Managers can view and manage course lists
737        self.browser.getLink("100").click()
738        self.assertMatches(
739            '...: Study Level 100 (Year 1)...', self.browser.contents)
740        self.browser.getLink("Manage").click()
741        self.browser.getControl(name="form.level_session").value = ['2002']
742        self.browser.getControl("Save").click()
743        self.browser.getControl("Remove selected").click()
744        self.assertMatches('...No ticket selected...', self.browser.contents)
745        ctrl = self.browser.getControl(name='val_id')
746        ctrl.getControl(value='COURSE1').selected = True
747        self.browser.getControl("Remove selected", index=0).click()
748        self.assertTrue('Successfully removed' in self.browser.contents)
749        # Removing course tickets is properly logged
750        logfile = os.path.join(
751            self.app['datacenter'].storage, 'logs', 'students.log')
752        logcontent = open(logfile).read()
753        self.assertTrue('zope.mgr - students.browser.StudyLevelManageFormPage '
754        '- K1000000 - removed: COURSE1 at 100' in logcontent)
755        self.browser.getLink("here").click()
756        self.browser.getControl(name="form.course").value = ['COURSE1']
757        self.course.credits = 100
758        self.browser.getControl("Add course ticket").click()
759        self.assertMatches(
760            '...Total credits exceed 50...', self.browser.contents)
761        self.course.credits = 10
762        self.browser.getControl("Add course ticket").click()
763        self.assertTrue('Successfully added' in self.browser.contents)
764        # We can do the same by adding the course on the manage page directly
765        del self.student['studycourse']['100']['COURSE1']
766        self.browser.getControl(name="course").value = 'COURSE1'
767        self.browser.getControl("Add course ticket").click()
768        self.assertTrue('Successfully added' in self.browser.contents)
769        self.browser.getLink("here").click()
770        self.browser.getControl(name="form.course").value = ['COURSE1']
771        self.browser.getControl("Add course ticket").click()
772        self.assertTrue('The ticket exists' in self.browser.contents)
773        self.browser.getControl("Cancel").click()
774        self.browser.getLink("COURSE1").click()
775        self.browser.getLink("Manage").click()
776        self.browser.getControl("Save").click()
777        self.assertTrue('Form has been saved' in self.browser.contents)
778        # Grade and weight have been determined
779        self.browser.open(self.studycourse_path + '/100/COURSE1')
780        self.assertFalse('Grade' in self.browser.contents)
781        self.assertFalse('Weight' in self.browser.contents)
782        self.student['studycourse']['100']['COURSE1'].score = 55
783        self.browser.open(self.studycourse_path + '/100/COURSE1')
784        self.assertTrue('Grade' in self.browser.contents)
785        self.assertTrue('Weight' in self.browser.contents)
786        self.assertEqual(self.student['studycourse']['100']['COURSE1'].grade, 'C')
787        self.assertEqual(self.student['studycourse']['100']['COURSE1'].weight, 3)
788        # We add another ticket to check if GPA will be correctly calculated
789        # (and rounded)
790        courseticket = createObject('waeup.CourseTicket')
791        courseticket.code = 'ANYCODE'
792        courseticket.title = u'Any TITLE'
793        courseticket.credits = 13
794        courseticket.score = 66
795        courseticket.semester = 1
796        courseticket.dcode = u'ANYDCODE'
797        courseticket.fcode = u'ANYFCODE'
798        self.student['studycourse']['100']['COURSE2'] = courseticket
799        self.browser.open(self.student_path + '/studycourse/100')
800        # total credits
801        self.assertEqual(self.student['studycourse']['100'].gpa_params_rectified[1], 23)
802        # weigheted credits = 3 * 10 + 4 * 13
803        self.assertEqual(self.student['studycourse']['100'].gpa_params_rectified[2], 82.0)
804        # sgpa = 82 / 23
805        self.assertEqual(self.student['studycourse']['100'].gpa_params_rectified[0], 3.565)
806        # Carry-over courses will be collected when next level is created
807        self.browser.open(self.student_path + '/studycourse/manage')
808        # Add next level
809        self.student['studycourse']['100']['COURSE1'].score = 10
810        self.browser.getControl(name="addlevel").value = ['200']
811        self.browser.getControl(name="level_session").value = ['2005']
812        self.browser.getControl("Add study level").click()
813        self.browser.getLink("200").click()
814        self.assertMatches(
815            '...: Study Level 200 (Year 2)...', self.browser.contents)
816        # Since COURSE1 has score 10 it becomes a carry-over course
817        # in level 200
818        self.assertEqual(
819            sorted(self.student['studycourse']['200'].keys()), [u'COURSE1'])
820        self.assertTrue(
821            self.student['studycourse']['200']['COURSE1'].carry_over)
822        # Passed and failed courses have been counted
823        self.assertEqual(
824            self.student['studycourse']['100'].passed_params,
825            (1, 1, 13, 10, ['COURSE1']))
826        self.assertEqual(
827            self.student['studycourse']['200'].passed_params,
828            (0, 0, 0, 0, []))
829        # And also cumulative params can be calculated. Meanwhile we have the
830        # following courses: COURSE1 and COURSE2 in level 100 and
831        # COURSE1 as carry-over course in level 200.
832        self.assertEqual(
833            self.student['studycourse']['100'].cumulative_params,
834            (2.261, 23, 52.0, 23, 13))
835        # COURSE1 in level 200 is not taken into consideration
836        # when calculating the gpa.
837        self.assertEqual(
838            self.student['studycourse']['200'].cumulative_params,
839            (2.261, 23, 52.0, 33, 13))
840        return
841
842    def test_gpa_calculation_with_carryover(self):
843        studylevel = createObject(u'waeup.StudentStudyLevel')
844        studylevel.level = 100
845        studylevel.level_session = 2005
846        self.student['studycourse'].entry_mode = 'ug_ft'
847        self.student['studycourse'].addStudentStudyLevel(
848            self.certificate, studylevel)
849        # First course has been added automatically.
850        # Set score above passmark.
851        studylevel['COURSE1'].score = studylevel['COURSE1'].passmark + 1
852        # GPA is 1.
853        self.assertEqual(self.student['studycourse']['100'].gpa_params_rectified[0], 1.0)
854        # Set score below passmark.
855        studylevel['COURSE1'].score = studylevel['COURSE1'].passmark - 1
856        # GPA is still 0.
857        self.assertEqual(self.student['studycourse']['100'].gpa_params_rectified[0], 0.0)
858        studylevel2 = createObject(u'waeup.StudentStudyLevel')
859        studylevel2.level = 200
860        studylevel2.level_session = 2006
861        self.student['studycourse'].addStudentStudyLevel(
862            self.certificate, studylevel2)
863        # Carry-over course has been autonatically added.
864        studylevel2['COURSE1'].score = 66
865        # The score of the carry-over course is now used for calculation of the
866        # GPA at level 100 ...
867        self.assertEqual(self.student['studycourse']['100'].gpa_params_rectified[0], 4.0)
868        # ... but not at level 200
869        self.assertEqual(self.student['studycourse']['200'].gpa_params_rectified[0], 0.0)
870        return
871
872    def test_manage_payments(self):
873        # Managers can add online school fee payment tickets
874        # if certain requirements are met
875        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
876        self.browser.open(self.payments_path)
877        IWorkflowState(self.student).setState('cleared')
878        self.browser.getLink("Add current session payment ticket").click()
879        self.browser.getControl(name="form.p_category").value = ['schoolfee']
880        self.browser.getControl("Create ticket").click()
881        self.assertMatches('...ticket created...',
882                           self.browser.contents)
883        ctrl = self.browser.getControl(name='val_id')
884        value = ctrl.options[0]
885        self.browser.getLink(value).click()
886        self.assertMatches('...Amount Authorized...',
887                           self.browser.contents)
888        self.assertEqual(self.student['payments'][value].amount_auth, 40000.0)
889        payment_url = self.browser.url
890
891        # The pdf payment slip can't yet be opened
892        #self.browser.open(payment_url + '/payment_slip.pdf')
893        #self.assertMatches('...Ticket not yet paid...',
894        #                   self.browser.contents)
895
896        # The same payment (with same p_item, p_session and p_category)
897        # can be initialized a second time if the former ticket is not yet paid.
898        self.browser.open(self.payments_path)
899        self.browser.getLink("Add current session payment ticket").click()
900        self.browser.getControl(name="form.p_category").value = ['schoolfee']
901        self.browser.getControl("Create ticket").click()
902        self.assertMatches('...Payment ticket created...',
903                           self.browser.contents)
904
905        # The ticket can be found in the payments_catalog
906        cat = queryUtility(ICatalog, name='payments_catalog')
907        results = list(cat.searchResults(p_state=('unpaid', 'unpaid')))
908        self.assertTrue(len(results), 1)
909        self.assertTrue(results[0] is self.student['payments'][value])
910
911        # Managers can approve the payment
912        self.assertEqual(len(self.app['accesscodes']['SFE-0']),0)
913        self.browser.open(payment_url)
914        self.browser.getLink("Approve payment").click()
915        self.assertMatches('...Payment approved...',
916                          self.browser.contents)
917        # Approval is logged in students.log ...
918        logfile = os.path.join(
919            self.app['datacenter'].storage, 'logs', 'students.log')
920        logcontent = open(logfile).read()
921        self.assertTrue(
922            'zope.mgr - students.browser.OnlinePaymentApprovePage '
923            '- K1000000 - schoolfee payment approved'
924            in logcontent)
925        # ... and in payments.log
926        logfile = os.path.join(
927            self.app['datacenter'].storage, 'logs', 'payments.log')
928        logcontent = open(logfile).read()
929        self.assertTrue(
930            '"zope.mgr",K1000000,%s,schoolfee,40000.0,AP,,,,,,\n' % value
931            in logcontent)
932
933        # The authorized amount has been stored in the access code
934        self.assertEqual(
935            self.app['accesscodes']['SFE-0'].values()[0].cost,40000.0)
936
937        # The catalog has been updated
938        results = list(cat.searchResults(p_state=('unpaid', 'unpaid')))
939        self.assertTrue(len(results), 0)
940        results = list(cat.searchResults(p_state=('paid', 'paid')))
941        self.assertTrue(len(results), 1)
942        self.assertTrue(results[0] is self.student['payments'][value])
943
944        # Payments can't be approved twice
945        self.browser.open(payment_url + '/approve')
946        self.assertMatches('...This ticket has already been paid...',
947                          self.browser.contents)
948
949        # Now the first ticket is paid and no more ticket of same type
950        # (with same p_item, p_session and p_category) can be added
951        self.browser.open(self.payments_path)
952        self.browser.getLink("Add current session payment ticket").click()
953        self.browser.getControl(name="form.p_category").value = ['schoolfee']
954        self.browser.getControl("Create ticket").click()
955        self.assertMatches(
956            '...This type of payment has already been made...',
957            self.browser.contents)
958
959        # Managers can open the pdf payment slip
960        self.browser.open(payment_url)
961        self.browser.getLink("Download payment slip").click()
962        self.assertEqual(self.browser.headers['Status'], '200 Ok')
963        self.assertEqual(self.browser.headers['Content-Type'], 'application/pdf')
964
965        # Managers can remove online school fee payment tickets
966        self.browser.open(self.payments_path)
967        self.browser.getControl("Remove selected").click()
968        self.assertMatches('...No payment selected...', self.browser.contents)
969        ctrl = self.browser.getControl(name='val_id')
970        value = ctrl.options[0]
971        ctrl.getControl(value=value).selected = True
972        self.browser.getControl("Remove selected", index=0).click()
973        self.assertTrue('Successfully removed' in self.browser.contents)
974
975        # Managers can add online clearance payment tickets
976        self.browser.open(self.payments_path + '/addop')
977        self.browser.getControl(name="form.p_category").value = ['clearance']
978        self.browser.getControl("Create ticket").click()
979        self.assertMatches('...ticket created...',
980                           self.browser.contents)
981
982        # Managers can approve the payment
983        self.assertEqual(len(self.app['accesscodes']['CLR-0']),0)
984        ctrl = self.browser.getControl(name='val_id')
985        value = ctrl.options[1] # The clearance payment is the second in the table
986        self.browser.getLink(value).click()
987        self.browser.open(self.browser.url + '/approve')
988        self.assertMatches('...Payment approved...',
989                          self.browser.contents)
990        expected = '''...
991        <td>
992          <span>Paid</span>
993        </td>...'''
994        self.assertMatches(expected,self.browser.contents)
995        # The new CLR-0 pin has been created
996        self.assertEqual(len(self.app['accesscodes']['CLR-0']),1)
997        pin = self.app['accesscodes']['CLR-0'].keys()[0]
998        ac = self.app['accesscodes']['CLR-0'][pin]
999        self.assertEqual(ac.owner, self.student_id)
1000        self.assertEqual(ac.cost, 3456.0)
1001
1002        # Managers can add online transcript payment tickets
1003        self.browser.open(self.payments_path + '/addop')
1004        self.browser.getControl(name="form.p_category").value = ['transcript']
1005        self.browser.getControl("Create ticket").click()
1006        self.assertMatches('...ticket created...',
1007                           self.browser.contents)
1008
1009        # Managers can approve the payment
1010        self.assertEqual(len(self.app['accesscodes']['TSC-0']),0)
1011        ctrl = self.browser.getControl(name='val_id')
1012        value = ctrl.options[2] # The clearance payment is the third in the table
1013        self.browser.getLink(value).click()
1014        self.browser.open(self.browser.url + '/approve')
1015        self.assertMatches('...Payment approved...',
1016                          self.browser.contents)
1017        expected = '''...
1018        <td>
1019          <span>Paid</span>
1020        </td>...'''
1021        self.assertMatches(expected,self.browser.contents)
1022        # The new CLR-0 pin has been created
1023        self.assertEqual(len(self.app['accesscodes']['TSC-0']),1)
1024        pin = self.app['accesscodes']['TSC-0'].keys()[0]
1025        ac = self.app['accesscodes']['TSC-0'][pin]
1026        self.assertEqual(ac.owner, self.student_id)
1027        self.assertEqual(ac.cost, 4567.0)
1028        return
1029
1030    def test_manage_balance_payments(self):
1031
1032        # Login
1033        #self.browser.open(self.login_path)
1034        #self.browser.getControl(name="form.login").value = self.student_id
1035        #self.browser.getControl(name="form.password").value = 'spwd'
1036        #self.browser.getControl("Login").click()
1037
1038        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
1039        self.browser.open(self.payments_path)
1040
1041        # Managers can add previous school fee payment tickets in any state.
1042        IWorkflowState(self.student).setState('courses registered')
1043        self.browser.open(self.payments_path)
1044        self.browser.getLink("Add balance payment ticket").click()
1045
1046        # Previous session payment form is provided
1047        self.assertEqual(self.student.current_session, 2004)
1048        self.browser.getControl(name="form.p_category").value = ['schoolfee']
1049        self.browser.getControl(name="form.balance_session").value = ['2004']
1050        self.browser.getControl(name="form.balance_level").value = ['300']
1051        self.browser.getControl(name="form.balance_amount").value = '-567.8'
1052        self.browser.getControl("Create ticket").click()
1053        self.assertMatches('...Amount must be greater than 0...',
1054                           self.browser.contents)
1055        self.browser.getControl(name="form.balance_amount").value = '0'
1056        self.browser.getControl("Create ticket").click()
1057        self.assertMatches('...Amount must be greater than 0...',
1058                           self.browser.contents)
1059        self.browser.getControl(name="form.balance_amount").value = '567.8'
1060        self.browser.getControl("Create ticket").click()
1061        self.assertMatches('...ticket created...',
1062                           self.browser.contents)
1063        ctrl = self.browser.getControl(name='val_id')
1064        value = ctrl.options[0]
1065        self.browser.getLink(value).click()
1066        self.assertMatches('...Amount Authorized...',
1067                           self.browser.contents)
1068        self.assertEqual(self.student['payments'][value].amount_auth, 567.8)
1069        # Payment attributes are properly set
1070        self.assertEqual(self.student['payments'][value].p_session, 2004)
1071        self.assertEqual(self.student['payments'][value].p_level, 300)
1072        self.assertEqual(self.student['payments'][value].p_item, u'Balance')
1073        self.assertEqual(self.student['payments'][value].p_category, 'schoolfee')
1074
1075    def test_manage_accommodation(self):
1076        logfile = os.path.join(
1077            self.app['datacenter'].storage, 'logs', 'students.log')
1078        # Managers can add online booking fee payment tickets and open the
1079        # callback view (see test_manage_payments)
1080        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
1081        self.browser.open(self.payments_path)
1082        self.browser.getLink("Add current session payment ticket").click()
1083        self.browser.getControl(name="form.p_category").value = ['bed_allocation']
1084        # If student is not in accommodation session, payment cannot be processed
1085        self.app['hostels'].accommodation_session = 2011
1086        self.browser.getControl("Create ticket").click()
1087        self.assertMatches('...Your current session does not match...',
1088                           self.browser.contents)
1089        self.app['hostels'].accommodation_session = 2004
1090        self.browser.getControl(name="form.p_category").value = ['bed_allocation']
1091        self.browser.getControl("Create ticket").click()
1092        ctrl = self.browser.getControl(name='val_id')
1093        value = ctrl.options[0]
1094        self.browser.getLink(value).click()
1095        self.browser.open(self.browser.url + '/approve')
1096        # The new HOS-0 pin has been created
1097        self.assertEqual(len(self.app['accesscodes']['HOS-0']),1)
1098        pin = self.app['accesscodes']['HOS-0'].keys()[0]
1099        ac = self.app['accesscodes']['HOS-0'][pin]
1100        self.assertEqual(ac.owner, self.student_id)
1101        parts = pin.split('-')[1:]
1102        sfeseries, sfenumber = parts
1103        # Managers can use HOS code and book a bed space with it
1104        self.browser.open(self.acco_path)
1105        self.browser.getLink("Book accommodation").click()
1106        self.assertMatches('...You are in the wrong...',
1107                           self.browser.contents)
1108        IWorkflowInfo(self.student).fireTransition('admit')
1109        # An existing HOS code can only be used if students
1110        # are in accommodation session
1111        self.student['studycourse'].current_session = 2003
1112        self.browser.getLink("Book accommodation").click()
1113        self.assertMatches('...Your current session does not match...',
1114                           self.browser.contents)
1115        self.student['studycourse'].current_session = 2004
1116        # All requirements are met and ticket can be created
1117        self.browser.getLink("Book accommodation").click()
1118        self.assertMatches('...Activation Code:...',
1119                           self.browser.contents)
1120        self.browser.getControl(name="ac_series").value = sfeseries
1121        self.browser.getControl(name="ac_number").value = sfenumber
1122        self.browser.getControl("Create bed ticket").click()
1123        self.assertMatches('...Hall 1, Block A, Room 101, Bed A...',
1124                           self.browser.contents)
1125        # Bed has been allocated
1126        bed1 = self.app['hostels']['hall-1']['hall-1_A_101_A']
1127        self.assertTrue(bed1.owner == self.student_id)
1128        # BedTicketAddPage is now blocked
1129        self.browser.getLink("Book accommodation").click()
1130        self.assertMatches('...You already booked a bed space...',
1131            self.browser.contents)
1132        # The bed ticket displays the data correctly
1133        self.browser.open(self.acco_path + '/2004')
1134        self.assertMatches('...Hall 1, Block A, Room 101, Bed A...',
1135                           self.browser.contents)
1136        self.assertMatches('...2004/2005...', self.browser.contents)
1137        self.assertMatches('...regular_male_fr...', self.browser.contents)
1138        self.assertMatches('...%s...' % pin, self.browser.contents)
1139        # Booking is properly logged
1140        logcontent = open(logfile).read()
1141        self.assertTrue('zope.mgr - students.browser.BedTicketAddPage '
1142            '- K1000000 - booked: hall-1_A_101_A' in logcontent)
1143        # Managers can relocate students if the student's bed_type has changed
1144        self.browser.getLink("Relocate student").click()
1145        self.assertMatches(
1146            "...Student can't be relocated...", self.browser.contents)
1147        self.student.sex = u'f'
1148        self.browser.getLink("Relocate student").click()
1149        self.assertMatches(
1150            "...Hall 1, Block A, Room 101, Bed B...", self.browser.contents)
1151        self.assertTrue(bed1.owner == NOT_OCCUPIED)
1152        bed2 = self.app['hostels']['hall-1']['hall-1_A_101_B']
1153        self.assertTrue(bed2.owner == self.student_id)
1154        self.assertTrue(self.student['accommodation'][
1155            '2004'].bed_type == u'regular_female_fr')
1156        # Relocation is properly logged
1157        logcontent = open(logfile).read()
1158        self.assertTrue('zope.mgr - students.browser.BedTicketRelocationPage '
1159            '- K1000000 - relocated: hall-1_A_101_B' in logcontent)
1160        # The payment object still shows the original payment item
1161        payment_id = self.student['payments'].keys()[0]
1162        payment = self.student['payments'][payment_id]
1163        self.assertTrue(payment.p_item == u'regular_male_fr')
1164        # Managers can relocate students if the bed's bed_type has changed
1165        bed1.bed_type = u'regular_female_fr'
1166        bed2.bed_type = u'regular_male_fr'
1167        notify(grok.ObjectModifiedEvent(bed1))
1168        notify(grok.ObjectModifiedEvent(bed2))
1169        self.browser.getLink("Relocate student").click()
1170        self.assertMatches(
1171            "...Student relocated...", self.browser.contents)
1172        self.assertMatches(
1173            "... Hall 1, Block A, Room 101, Bed A...", self.browser.contents)
1174        self.assertMatches(bed1.owner, self.student_id)
1175        self.assertMatches(bed2.owner, NOT_OCCUPIED)
1176        # Managers can't relocate students if bed is reserved
1177        self.student.sex = u'm'
1178        bed1.bed_type = u'regular_female_reserved'
1179        notify(grok.ObjectModifiedEvent(bed1))
1180        self.browser.getLink("Relocate student").click()
1181        self.assertMatches(
1182            "...Students in reserved beds can't be relocated...",
1183            self.browser.contents)
1184        # Managers can relocate students if booking has been cancelled but
1185        # other bed space has been manually allocated after cancellation
1186        old_owner = bed1.releaseBed()
1187        self.assertMatches(old_owner, self.student_id)
1188        bed2.owner = self.student_id
1189        self.browser.open(self.acco_path + '/2004')
1190        self.assertMatches(
1191            "...booking cancelled...", self.browser.contents)
1192        self.browser.getLink("Relocate student").click()
1193        # We didn't informed the catalog therefore the new owner is not found
1194        self.assertMatches(
1195            "...There is no free bed in your category regular_male_fr...",
1196            self.browser.contents)
1197        # Now we fire the event properly
1198        notify(grok.ObjectModifiedEvent(bed2))
1199        self.browser.getLink("Relocate student").click()
1200        self.assertMatches(
1201            "...Student relocated...", self.browser.contents)
1202        self.assertMatches(
1203            "... Hall 1, Block A, Room 101, Bed B...", self.browser.contents)
1204          # Managers can delete bed tickets
1205        self.browser.open(self.acco_path)
1206        ctrl = self.browser.getControl(name='val_id')
1207        value = ctrl.options[0]
1208        ctrl.getControl(value=value).selected = True
1209        self.browser.getControl("Remove selected", index=0).click()
1210        self.assertMatches('...Successfully removed...', self.browser.contents)
1211        # The bed has been properly released by the event handler
1212        self.assertMatches(bed1.owner, NOT_OCCUPIED)
1213        self.assertMatches(bed2.owner, NOT_OCCUPIED)
1214        return
1215
1216    def test_manage_workflow(self):
1217        # Managers can pass through the whole workflow
1218        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
1219        student = self.app['students'][self.student_id]
1220        self.browser.open(self.trigtrans_path)
1221        self.assertTrue(student.clearance_locked)
1222        self.browser.getControl(name="transition").value = ['admit']
1223        self.browser.getControl("Save").click()
1224        self.assertTrue(student.clearance_locked)
1225        self.browser.getControl(name="transition").value = ['start_clearance']
1226        self.browser.getControl("Save").click()
1227        self.assertFalse(student.clearance_locked)
1228        self.browser.getControl(name="transition").value = ['request_clearance']
1229        self.browser.getControl("Save").click()
1230        self.assertTrue(student.clearance_locked)
1231        self.browser.getControl(name="transition").value = ['clear']
1232        self.browser.getControl("Save").click()
1233        # Managers approve payment, they do not pay
1234        self.assertFalse('pay_first_school_fee' in self.browser.contents)
1235        self.browser.getControl(
1236            name="transition").value = ['approve_first_school_fee']
1237        self.browser.getControl("Save").click()
1238        self.browser.getControl(name="transition").value = ['reset6']
1239        self.browser.getControl("Save").click()
1240        # In state returning the pay_school_fee transition triggers some
1241        # changes of attributes
1242        self.browser.getControl(name="transition").value = ['approve_school_fee']
1243        self.browser.getControl("Save").click()
1244        self.assertEqual(student['studycourse'].current_session, 2005) # +1
1245        self.assertEqual(student['studycourse'].current_level, 200) # +100
1246        self.assertEqual(student['studycourse'].current_verdict, '0') # 0 = Zero = not set
1247        self.assertEqual(student['studycourse'].previous_verdict, 'A')
1248        self.browser.getControl(name="transition").value = ['register_courses']
1249        self.browser.getControl("Save").click()
1250        self.browser.getControl(name="transition").value = ['validate_courses']
1251        self.browser.getControl("Save").click()
1252        self.browser.getControl(name="transition").value = ['return']
1253        self.browser.getControl("Save").click()
1254        return
1255
1256    def test_manage_pg_workflow(self):
1257        # Managers can pass through the whole workflow
1258        IWorkflowState(self.student).setState('school fee paid')
1259        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
1260        student = self.app['students'][self.student_id]
1261        self.browser.open(self.trigtrans_path)
1262        self.assertTrue('<option value="reset6">' in self.browser.contents)
1263        self.assertTrue('<option value="register_courses">' in self.browser.contents)
1264        self.assertTrue('<option value="reset5">' in self.browser.contents)
1265        self.certificate.study_mode = 'pg_ft'
1266        self.browser.open(self.trigtrans_path)
1267        self.assertFalse('<option value="reset6">' in self.browser.contents)
1268        self.assertFalse('<option value="register_courses">' in self.browser.contents)
1269        self.assertTrue('<option value="reset5">' in self.browser.contents)
1270        return
1271
1272    def test_manage_import(self):
1273        # Managers can import student data files
1274        datacenter_path = 'http://localhost/app/datacenter'
1275        # Prepare a csv file for students
1276        open('students.csv', 'wb').write(
1277"""firstname,lastname,reg_number,date_of_birth,matric_number,email,phone,sex,password
1278Aaren,Pieri,1,1990-01-02,100000,aa@aa.ng,1234,m,mypwd1
1279Claus,Finau,2,1990-01-03,100001,aa@aa.ng,1234,m,mypwd1
1280Brit,Berson,3,1990-01-04,100001,aa@aa.ng,1234,m,mypwd1
1281""")
1282        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
1283        self.browser.open(datacenter_path)
1284        self.browser.getLink('Upload data').click()
1285        filecontents = StringIO(open('students.csv', 'rb').read())
1286        filewidget = self.browser.getControl(name='uploadfile:file')
1287        filewidget.add_file(filecontents, 'text/plain', 'students.csv')
1288        self.browser.getControl(name='SUBMIT').click()
1289        self.browser.getLink('Process data').click()
1290        button = lookup_submit_value(
1291            'select', 'students_zope.mgr.csv', self.browser)
1292        button.click()
1293        importerselect = self.browser.getControl(name='importer')
1294        modeselect = self.browser.getControl(name='mode')
1295        importerselect.getControl('Student Processor').selected = True
1296        modeselect.getControl(value='create').selected = True
1297        self.browser.getControl('Proceed to step 3').click()
1298        self.assertTrue('Header fields OK' in self.browser.contents)
1299        self.browser.getControl('Perform import').click()
1300        self.assertTrue('Processing of 1 rows failed' in self.browser.contents)
1301        self.assertTrue('Successfully processed 2 rows' in self.browser.contents)
1302        self.assertTrue('Batch processing finished' in self.browser.contents)
1303        open('studycourses.csv', 'wb').write(
1304"""reg_number,matric_number,certificate,current_session,current_level
13051,,CERT1,2008,100
1306,100001,CERT1,2008,100
1307,100002,CERT1,2008,100
1308""")
1309        self.browser.open(datacenter_path)
1310        self.browser.getLink('Upload data').click()
1311        filecontents = StringIO(open('studycourses.csv', 'rb').read())
1312        filewidget = self.browser.getControl(name='uploadfile:file')
1313        filewidget.add_file(filecontents, 'text/plain', 'studycourses.csv')
1314        self.browser.getControl(name='SUBMIT').click()
1315        self.browser.getLink('Process data').click()
1316        button = lookup_submit_value(
1317            'select', 'studycourses_zope.mgr.csv', self.browser)
1318        button.click()
1319        importerselect = self.browser.getControl(name='importer')
1320        modeselect = self.browser.getControl(name='mode')
1321        importerselect.getControl(
1322            'StudentStudyCourse Processor (update only)').selected = True
1323        modeselect.getControl(value='create').selected = True
1324        self.browser.getControl('Proceed to step 3').click()
1325        self.assertTrue('Update mode only' in self.browser.contents)
1326        self.browser.getControl('Proceed to step 3').click()
1327        self.assertTrue('Header fields OK' in self.browser.contents)
1328        self.browser.getControl('Perform import').click()
1329        self.assertTrue('Processing of 1 rows failed' in self.browser.contents)
1330        self.assertTrue('Successfully processed 2 rows'
1331                        in self.browser.contents)
1332        # The students are properly indexed and we can
1333        # thus find a student in  the department
1334        self.browser.open(self.manage_container_path)
1335        self.browser.getControl(name="searchtype").value = ['depcode']
1336        self.browser.getControl(name="searchterm").value = 'dep1'
1337        self.browser.getControl("Search").click()
1338        self.assertTrue('Aaren Pieri' in self.browser.contents)
1339        # We can search for a new student by name ...
1340        self.browser.getControl(name="searchtype").value = ['fullname']
1341        self.browser.getControl(name="searchterm").value = 'Claus'
1342        self.browser.getControl("Search").click()
1343        self.assertTrue('Claus Finau' in self.browser.contents)
1344        # ... and check if the imported password has been properly set
1345        ctrl = self.browser.getControl(name='entries')
1346        value = ctrl.options[0]
1347        claus = self.app['students'][value]
1348        self.assertTrue(IUserAccount(claus).checkPassword('mypwd1'))
1349        return
1350
1351    def test_handle_clearance_by_co(self):
1352        # Create clearance officer
1353        self.app['users'].addUser('mrclear', 'mrclearsecret')
1354        self.app['users']['mrclear'].email = 'mrclear@foo.ng'
1355        self.app['users']['mrclear'].title = 'Carlo Pitter'
1356        # Clearance officers need not necessarily to get
1357        # the StudentsOfficer site role
1358        #prmglobal = IPrincipalRoleManager(self.app)
1359        #prmglobal.assignRoleToPrincipal('waeup.StudentsOfficer', 'mrclear')
1360        # Assign local ClearanceOfficer role
1361        department = self.app['faculties']['fac1']['dep1']
1362        prmlocal = IPrincipalRoleManager(department)
1363        prmlocal.assignRoleToPrincipal('waeup.local.ClearanceOfficer', 'mrclear')
1364        IWorkflowState(self.student).setState('clearance started')
1365        # Login as clearance officer
1366        self.browser.open(self.login_path)
1367        self.browser.getControl(name="form.login").value = 'mrclear'
1368        self.browser.getControl(name="form.password").value = 'mrclearsecret'
1369        self.browser.getControl("Login").click()
1370        self.assertMatches('...You logged in...', self.browser.contents)
1371        # CO can see his roles
1372        self.browser.getLink("My Roles").click()
1373        self.assertMatches(
1374            '...<div>Academics Officer (view only)</div>...',
1375            self.browser.contents)
1376        #self.assertMatches(
1377        #    '...<div>Students Officer (view only)</div>...',
1378        #    self.browser.contents)
1379        # But not his local role ...
1380        self.assertFalse('Clearance Officer' in self.browser.contents)
1381        # ... because we forgot to notify the department that the local role
1382        # has changed
1383        notify(LocalRoleSetEvent(
1384            department, 'waeup.local.ClearanceOfficer', 'mrclear', granted=True))
1385        self.browser.open('http://localhost/app/users/mrclear/my_roles')
1386        self.assertTrue('Clearance Officer' in self.browser.contents)
1387        self.assertMatches(
1388            '...<a href="http://localhost/app/faculties/fac1/dep1">...',
1389            self.browser.contents)
1390        # CO can view the student ...
1391        self.browser.open(self.clearance_path)
1392        self.assertEqual(self.browser.headers['Status'], '200 Ok')
1393        self.assertEqual(self.browser.url, self.clearance_path)
1394        # ... but not other students
1395        other_student = Student()
1396        other_student.firstname = u'Dep2'
1397        other_student.lastname = u'Student'
1398        self.app['students'].addStudent(other_student)
1399        other_student_path = (
1400            'http://localhost/app/students/%s' % other_student.student_id)
1401        self.assertRaises(
1402            Unauthorized, self.browser.open, other_student_path)
1403        # Clearance is disabled for this session
1404        self.browser.open(self.clearance_path)
1405        self.assertFalse('Clear student' in self.browser.contents)
1406        self.browser.open(self.student_path + '/clear')
1407        self.assertTrue('Clearance is disabled for this session'
1408            in self.browser.contents)
1409        self.app['configuration']['2004'].clearance_enabled = True
1410        # Only in state clearance requested the CO does see the 'Clear' button
1411        self.browser.open(self.clearance_path)
1412        self.assertFalse('Clear student' in self.browser.contents)
1413        IWorkflowInfo(self.student).fireTransition('request_clearance')
1414        self.browser.open(self.clearance_path)
1415        self.assertTrue('Clear student' in self.browser.contents)
1416        self.browser.getLink("Clear student").click()
1417        self.assertTrue('Student has been cleared' in self.browser.contents)
1418        self.assertTrue('cleared' in self.browser.contents)
1419        self.browser.open(self.history_path)
1420        self.assertTrue('Cleared by Carlo Pitter' in self.browser.contents)
1421        # Hide real name.
1422        self.app['users']['mrclear'].public_name = 'My Public Name'
1423        self.browser.open(self.clearance_path)
1424        self.browser.getLink("Reject clearance").click()
1425        self.assertEqual(
1426            self.browser.url, self.student_path + '/reject_clearance')
1427        # Type comment why
1428        self.browser.getControl(name="form.officer_comment").value = """Dear Student,
1429You did not fill properly.
1430"""
1431        self.browser.getControl("Save comment").click()
1432        self.assertTrue('Clearance has been annulled' in self.browser.contents)
1433        url = ('http://localhost/app/students/K1000000/'
1434              'contactstudent?body=Dear+Student%2C%0AYou+did+not+fill+properly.'
1435              '%0A&subject=Clearance+has+been+annulled.')
1436        # CO does now see the prefilled contact form and can send a message
1437        self.assertEqual(self.browser.url, url)
1438        self.assertTrue('clearance started' in self.browser.contents)
1439        self.assertTrue('name="form.subject" size="20" type="text" '
1440            'value="Clearance has been annulled."'
1441            in self.browser.contents)
1442        self.assertTrue('name="form.body" rows="10" >Dear Student,'
1443            in self.browser.contents)
1444        self.browser.getControl("Send message now").click()
1445        self.assertTrue('Your message has been sent' in self.browser.contents)
1446        # The comment has been stored ...
1447        self.assertEqual(self.student.officer_comment,
1448            u'Dear Student,\nYou did not fill properly.\n')
1449        # ... and logged
1450        logfile = os.path.join(
1451            self.app['datacenter'].storage, 'logs', 'students.log')
1452        logcontent = open(logfile).read()
1453        self.assertTrue(
1454            'INFO - mrclear - students.browser.StudentRejectClearancePage - '
1455            'K1000000 - comment: Dear Student,<br>You did not fill '
1456            'properly.<br>\n' in logcontent)
1457        self.browser.open(self.history_path)
1458        self.assertTrue("Reset to 'clearance started' by My Public Name" in
1459            self.browser.contents)
1460        IWorkflowInfo(self.student).fireTransition('request_clearance')
1461        self.browser.open(self.clearance_path)
1462        self.browser.getLink("Reject clearance").click()
1463        self.browser.getControl("Save comment").click()
1464        self.assertTrue('Clearance request has been rejected'
1465            in self.browser.contents)
1466        self.assertTrue('clearance started' in self.browser.contents)
1467        # The CO can't clear students if not in state
1468        # clearance requested
1469        self.browser.open(self.student_path + '/clear')
1470        self.assertTrue('Student is in wrong state'
1471            in self.browser.contents)
1472        # The CO can go to his department throug the my_roles page ...
1473        self.browser.open('http://localhost/app/users/mrclear/my_roles')
1474        self.browser.getLink("http://localhost/app/faculties/fac1/dep1").click()
1475        # ... and view the list of students
1476        self.browser.getLink("Show students").click()
1477        self.browser.getControl(name="session").value = ['2004']
1478        self.browser.getControl(name="level").value = ['200']
1479        self.browser.getControl("Show").click()
1480        self.assertFalse(self.student_id in self.browser.contents)
1481        self.browser.getControl(name="session").value = ['2004']
1482        self.browser.getControl(name="level").value = ['100']
1483        self.browser.getControl("Show").click()
1484        self.assertTrue(self.student_id in self.browser.contents)
1485        # The comment is indicated by 'yes'
1486        self.assertTrue('<td><span>yes</span></td>' in self.browser.contents)
1487        # Check if the enquiries form is not pre-filled with officer_comment
1488        # (regression test)
1489        self.browser.getLink("Logout").click()
1490        self.browser.open('http://localhost/app/enquiries')
1491        self.assertFalse(
1492            'You did not fill properly'
1493            in self.browser.contents)
1494        # When a student is cleared the comment is automatically deleted
1495        IWorkflowInfo(self.student).fireTransition('request_clearance')
1496        IWorkflowInfo(self.student).fireTransition('clear')
1497        self.assertEqual(self.student.officer_comment, None)
1498
1499    def test_handle_courses_by_ca(self):
1500        # Create course adviser
1501        self.app['users'].addUser('mrsadvise', 'mrsadvisesecret')
1502        self.app['users']['mrsadvise'].email = 'mradvise@foo.ng'
1503        self.app['users']['mrsadvise'].title = u'Helen Procter'
1504        # Assign local CourseAdviser100 role for a certificate
1505        cert = self.app['faculties']['fac1']['dep1'].certificates['CERT1']
1506        prmlocal = IPrincipalRoleManager(cert)
1507        prmlocal.assignRoleToPrincipal('waeup.local.CourseAdviser100', 'mrsadvise')
1508        IWorkflowState(self.student).setState('school fee paid')
1509        # Login as course adviser
1510        self.browser.open(self.login_path)
1511        self.browser.getControl(name="form.login").value = 'mrsadvise'
1512        self.browser.getControl(name="form.password").value = 'mrsadvisesecret'
1513        self.browser.getControl("Login").click()
1514        self.assertMatches('...You logged in...', self.browser.contents)
1515        # CO can see his roles
1516        self.browser.getLink("My Roles").click()
1517        self.assertMatches(
1518            '...<div>Academics Officer (view only)</div>...',
1519            self.browser.contents)
1520        # But not his local role ...
1521        self.assertFalse('Course Adviser' in self.browser.contents)
1522        # ... because we forgot to notify the certificate that the local role
1523        # has changed
1524        notify(LocalRoleSetEvent(
1525            cert, 'waeup.local.CourseAdviser100', 'mrsadvise', granted=True))
1526        self.browser.open('http://localhost/app/users/mrsadvise/my_roles')
1527        self.assertTrue('Course Adviser 100L' in self.browser.contents)
1528        self.assertMatches(
1529            '...<a href="http://localhost/app/faculties/fac1/dep1/certificates/CERT1">...',
1530            self.browser.contents)
1531        # CA can view the student ...
1532        self.browser.open(self.student_path)
1533        self.assertEqual(self.browser.headers['Status'], '200 Ok')
1534        self.assertEqual(self.browser.url, self.student_path)
1535        # ... but not other students
1536        other_student = Student()
1537        other_student.firstname = u'Dep2'
1538        other_student.lastname = u'Student'
1539        self.app['students'].addStudent(other_student)
1540        other_student_path = (
1541            'http://localhost/app/students/%s' % other_student.student_id)
1542        self.assertRaises(
1543            Unauthorized, self.browser.open, other_student_path)
1544        # We add study level 110 to the student's studycourse
1545        studylevel = StudentStudyLevel()
1546        studylevel.level = 110
1547        self.student['studycourse'].addStudentStudyLevel(
1548            cert,studylevel)
1549        L110_student_path = self.studycourse_path + '/110'
1550        # The CA can neither see the Validate nor the Edit button
1551        self.browser.open(L110_student_path)
1552        self.assertFalse('Validate courses' in self.browser.contents)
1553        self.assertFalse('Edit' in self.browser.contents)
1554        IWorkflowInfo(self.student).fireTransition('register_courses')
1555        self.browser.open(L110_student_path)
1556        self.assertFalse('Validate courses' in self.browser.contents)
1557        self.assertFalse('Edit' in self.browser.contents)
1558        # Only in state courses registered and only if the current level
1559        # corresponds with the name of the study level object
1560        # the 100L CA does see the 'Validate' button but not
1561        # the edit button
1562        self.student['studycourse'].current_level = 110
1563        self.browser.open(L110_student_path)
1564        self.assertFalse('Edit' in self.browser.contents)
1565        self.assertTrue('Validate courses' in self.browser.contents)
1566        # But a 100L CA does not see the button at other levels
1567        studylevel2 = StudentStudyLevel()
1568        studylevel2.level = 200
1569        self.student['studycourse'].addStudentStudyLevel(
1570            cert,studylevel2)
1571        L200_student_path = self.studycourse_path + '/200'
1572        self.browser.open(L200_student_path)
1573        self.assertFalse('Edit' in self.browser.contents)
1574        self.assertFalse('Validate courses' in self.browser.contents)
1575        self.browser.open(L110_student_path)
1576        self.browser.getLink("Validate courses").click()
1577        self.assertTrue('Course list has been validated' in self.browser.contents)
1578        self.assertTrue('courses validated' in self.browser.contents)
1579        self.assertEqual(self.student['studycourse']['110'].validated_by,
1580            'Helen Procter')
1581        self.assertMatches(
1582            '<YYYY-MM-DD hh:mm:ss>',
1583            self.student['studycourse']['110'].validation_date.strftime(
1584                "%Y-%m-%d %H:%M:%S"))
1585        self.browser.getLink("Reject courses").click()
1586        self.assertTrue('Course list request has been annulled.'
1587            in self.browser.contents)
1588        urlmessage = 'Course+list+request+has+been+annulled.'
1589        self.assertEqual(self.browser.url, self.student_path +
1590            '/contactstudent?subject=%s' % urlmessage)
1591        self.assertTrue('school fee paid' in self.browser.contents)
1592        self.assertTrue(self.student['studycourse']['110'].validated_by is None)
1593        self.assertTrue(self.student['studycourse']['110'].validation_date is None)
1594        IWorkflowInfo(self.student).fireTransition('register_courses')
1595        self.browser.open(L110_student_path)
1596        self.browser.getLink("Reject courses").click()
1597        self.assertTrue('Course list request has been rejected'
1598            in self.browser.contents)
1599        self.assertTrue('school fee paid' in self.browser.contents)
1600        # CA does now see the contact form and can send a message
1601        self.browser.getControl(name="form.subject").value = 'Important subject'
1602        self.browser.getControl(name="form.body").value = 'Course list rejected'
1603        self.browser.getControl("Send message now").click()
1604        self.assertTrue('Your message has been sent' in self.browser.contents)
1605        # The CA does now see the Edit button and can edit
1606        # current study level
1607        self.browser.open(L110_student_path)
1608        self.browser.getLink("Edit").click()
1609        self.assertTrue('Edit course list of 100 (Year 1) on 1st probation'
1610            in self.browser.contents)
1611        # The CA can't validate courses if not in state
1612        # courses registered
1613        self.browser.open(L110_student_path + '/validate_courses')
1614        self.assertTrue('Student is in the wrong state'
1615            in self.browser.contents)
1616        # The CA can go to his certificate through the my_roles page
1617        self.browser.open('http://localhost/app/users/mrsadvise/my_roles')
1618        self.browser.getLink(
1619            "http://localhost/app/faculties/fac1/dep1/certificates/CERT1").click()
1620        # and view the list of students
1621        self.browser.getLink("Show students").click()
1622        self.browser.getControl(name="session").value = ['2004']
1623        self.browser.getControl(name="level").value = ['100']
1624        self.browser.getControl("Show").click()
1625        self.assertTrue(self.student_id in self.browser.contents)
1626
1627    def test_handle_courses_by_lecturer(self):
1628        # Create course lecturer
1629        self.app['users'].addUser('mrslecturer', 'mrslecturersecret')
1630        self.app['users']['mrslecturer'].email = 'mrslecturer@foo.ng'
1631        self.app['users']['mrslecturer'].title = u'Mercedes Benz'
1632        # Assign local Lecturer role for a certificate
1633        course = self.app['faculties']['fac1']['dep1'].courses['COURSE1']
1634        prmlocal = IPrincipalRoleManager(course)
1635        prmlocal.assignRoleToPrincipal('waeup.local.Lecturer', 'mrslecturer')
1636        # Login as lecturer
1637        self.browser.open(self.login_path)
1638        self.browser.getControl(name="form.login").value = 'mrslecturer'
1639        self.browser.getControl(name="form.password").value = 'mrslecturersecret'
1640        self.browser.getControl("Login").click()
1641        self.assertMatches('...You logged in...', self.browser.contents)
1642        # CO can see her roles
1643        self.browser.getLink("My Roles").click()
1644        self.assertMatches(
1645            '...<div>Academics Officer (view only)</div>...',
1646            self.browser.contents)
1647        # But not her local role ...
1648        self.assertFalse('Lecturer' in self.browser.contents)
1649        # ... because we forgot to notify the course that the local role
1650        # has changed
1651        notify(LocalRoleSetEvent(
1652            course, 'waeup.local.Lecturer', 'mrslecturer', granted=True))
1653        self.browser.open('http://localhost/app/users/mrslecturer/my_roles')
1654        self.assertTrue('Lecturer' in self.browser.contents)
1655        self.assertMatches(
1656            '...<a href="http://localhost/app/faculties/fac1/dep1/courses/COURSE1">...',
1657            self.browser.contents)
1658        # The lecturer can go to her course
1659        self.browser.getLink(
1660            "http://localhost/app/faculties/fac1/dep1/courses/COURSE1").click()
1661        # and view the list of students
1662        self.browser.getLink("Show students").click()
1663        self.browser.getControl(name="session").value = ['2004']
1664        self.browser.getControl(name="level").value = ['100']
1665        self.browser.getControl("Show").click()
1666        self.assertTrue('No student found.' in self.browser.contents)
1667        # No student in course so far
1668        self.assertFalse(self.student_id in self.browser.contents)
1669        studylevel = createObject(u'waeup.StudentStudyLevel')
1670        studylevel.level = 100
1671        studylevel.level_session = 2004
1672        self.student['studycourse'].addStudentStudyLevel(
1673            self.certificate, studylevel)
1674        # Now the student has registered the course and can
1675        # be seen by the lecturer.
1676        self.browser.open("http://localhost/app/faculties/fac1/dep1/courses/COURSE1/students")
1677        self.browser.getControl(name="session").value = ['2004']
1678        self.browser.getControl(name="level").value = ['100']
1679        self.browser.getControl("Show").click()
1680        self.assertTrue(self.student_id in self.browser.contents)
1681        # The course ticket can be linked with the course.
1682        self.assertEqual(
1683            self.student['studycourse']['100']['COURSE1'].course,
1684            self.course)
1685        # Lecturer can neither access the student ...
1686        self.assertRaises(
1687            Unauthorized, self.browser.open, self.student_path)
1688        # ... nor the respective course ticket since
1689        # editing course tickets by lecturers is not feasible.
1690        self.assertTrue('COURSE1' in self.student['studycourse']['100'].keys())
1691        course_ticket_path = self.student_path + '/studycourse/100/COURSE1'
1692        self.assertRaises(
1693            Unauthorized, self.browser.open, course_ticket_path)
1694        # Course results can be batch edited via the edit_courses view
1695        self.app['faculties']['fac1']['dep1'].score_editing_disabled = True
1696        self.browser.open("http://localhost/app/faculties/fac1/dep1/courses/COURSE1")
1697        self.browser.getLink("Update scores").click()
1698        self.assertTrue('Score editing disabled' in self.browser.contents)
1699        self.app['faculties']['fac1']['dep1'].score_editing_disabled = False
1700        self.browser.getLink("Update scores").click()
1701        self.assertTrue('Current academic session not set' in self.browser.contents)
1702        self.app['configuration'].current_academic_session = 2004
1703        self.browser.getLink("Update scores").click()
1704        self.assertFalse(
1705            '<input type="text" name="scores" class="span1" />'
1706            in self.browser.contents)
1707        IWorkflowState(self.student).setState('courses validated')
1708        # Student must be in state 'courses validated'
1709        self.browser.open(
1710            "http://localhost/app/faculties/fac1/dep1/courses/COURSE1/edit_scores")
1711        self.assertTrue(
1712            '<input type="text" name="scores" class="span1" />'
1713            in self.browser.contents)
1714        self.browser.getControl(name="scores", index=0).value = '55'
1715        self.browser.getControl("Update scores").click()
1716        # New score has been set
1717        self.assertEqual(
1718            self.student['studycourse']['100']['COURSE1'].score, 55)
1719        # Score editing has been logged
1720        logfile = os.path.join(
1721            self.app['datacenter'].storage, 'logs', 'students.log')
1722        logcontent = open(logfile).read()
1723        self.assertTrue('mrslecturer - students.browser.EditScoresPage - '
1724                        'K1000000 100/COURSE1 score updated (55)' in logcontent)
1725        # Non-integer scores won't be accepted
1726        self.browser.open(
1727            "http://localhost/app/faculties/fac1/dep1/courses/COURSE1/edit_scores")
1728        self.assertTrue('value="55" />' in self.browser.contents)
1729        self.browser.getControl(name="scores", index=0).value = 'abc'
1730        self.browser.getControl("Update scores").click()
1731        self.assertTrue('Error: Score(s) of Anna Tester have not be updated'
1732            in self.browser.contents)
1733
1734    def test_change_current_mode(self):
1735        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
1736        self.browser.open(self.clearance_path)
1737        self.assertFalse('Employer' in self.browser.contents)
1738        self.browser.open(self.manage_clearance_path)
1739        self.assertFalse('Employer' in self.browser.contents)
1740        self.student.clearance_locked = False
1741        self.browser.open(self.edit_clearance_path)
1742        self.assertFalse('Employer' in self.browser.contents)
1743        # Now we change the study mode of the certificate and a different
1744        # interface is used by clearance views.
1745        self.certificate.study_mode = 'pg_ft'
1746        # Invariants are not being checked here?!
1747        self.certificate.end_level = 100
1748        self.browser.open(self.clearance_path)
1749        self.assertTrue('Employer' in self.browser.contents)
1750        self.browser.open(self.manage_clearance_path)
1751        self.assertTrue('Employer' in self.browser.contents)
1752        self.browser.open(self.edit_clearance_path)
1753        self.assertTrue('Employer' in self.browser.contents)
1754
1755    def test_activate_deactivate_buttons(self):
1756        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
1757        self.browser.open(self.student_path)
1758        self.browser.getLink("Deactivate").click()
1759        self.assertTrue(
1760            'Student account has been deactivated.' in self.browser.contents)
1761        self.assertTrue(
1762            'Base Data (account deactivated)' in self.browser.contents)
1763        self.assertTrue(self.student.suspended)
1764        self.browser.getLink("Activate").click()
1765        self.assertTrue(
1766            'Student account has been activated.' in self.browser.contents)
1767        self.assertFalse(
1768            'Base Data (account deactivated)' in self.browser.contents)
1769        self.assertFalse(self.student.suspended)
1770        # History messages have been added ...
1771        self.browser.getLink("History").click()
1772        self.assertTrue(
1773            'Student account deactivated by Manager<br />' in self.browser.contents)
1774        self.assertTrue(
1775            'Student account activated by Manager<br />' in self.browser.contents)
1776        # ... and actions have been logged.
1777        logfile = os.path.join(
1778            self.app['datacenter'].storage, 'logs', 'students.log')
1779        logcontent = open(logfile).read()
1780        self.assertTrue('zope.mgr - students.browser.StudentDeactivatePage - '
1781                        'K1000000 - account deactivated' in logcontent)
1782        self.assertTrue('zope.mgr - students.browser.StudentActivatePage - '
1783                        'K1000000 - account activated' in logcontent)
1784
1785    def test_manage_student_transfer(self):
1786        # Add second certificate
1787        self.certificate2 = createObject('waeup.Certificate')
1788        self.certificate2.code = u'CERT2'
1789        self.certificate2.study_mode = 'ug_ft'
1790        self.certificate2.start_level = 999
1791        self.certificate2.end_level = 999
1792        self.app['faculties']['fac1']['dep1'].certificates.addCertificate(
1793            self.certificate2)
1794
1795        # Add study level to old study course
1796        studylevel = createObject(u'waeup.StudentStudyLevel')
1797        studylevel.level = 200
1798        self.student['studycourse'].addStudentStudyLevel(
1799            self.certificate, studylevel)
1800        studylevel = createObject(u'waeup.StudentStudyLevel')
1801        studylevel.level = 999
1802        self.student['studycourse'].addStudentStudyLevel(
1803            self.certificate, studylevel)
1804
1805        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
1806        self.browser.open(self.student_path)
1807        self.browser.getLink("Transfer").click()
1808        self.browser.getControl(name="form.certificate").value = ['CERT2']
1809        self.browser.getControl(name="form.current_session").value = ['2011']
1810        self.browser.getControl(name="form.current_level").value = ['200']
1811        self.browser.getControl("Transfer").click()
1812        self.assertTrue(
1813            'Current level does not match certificate levels'
1814            in self.browser.contents)
1815        self.browser.getControl(name="form.current_level").value = ['999']
1816        self.browser.getControl("Transfer").click()
1817        self.assertTrue('Successfully transferred' in self.browser.contents)
1818        # The catalog has been updated
1819        cat = queryUtility(ICatalog, name='students_catalog')
1820        results = list(
1821            cat.searchResults(
1822            certcode=('CERT2', 'CERT2')))
1823        self.assertTrue(results[0] is self.student)
1824        results = list(
1825            cat.searchResults(
1826            current_session=(2011, 2011)))
1827        self.assertTrue(results[0] is self.student)
1828        # Add study level to new study course
1829        studylevel = createObject(u'waeup.StudentStudyLevel')
1830        studylevel.level = 999
1831        self.student['studycourse'].addStudentStudyLevel(
1832            self.certificate, studylevel)
1833
1834        # Edit and add pages are locked for old study courses
1835        self.browser.open(self.student_path + '/studycourse/manage')
1836        self.assertFalse('The requested form is locked' in self.browser.contents)
1837        self.browser.open(self.student_path + '/studycourse_1/manage')
1838        self.assertTrue('The requested form is locked' in self.browser.contents)
1839
1840        self.browser.open(self.student_path + '/studycourse/start_session')
1841        self.assertFalse('The requested form is locked' in self.browser.contents)
1842        self.browser.open(self.student_path + '/studycourse_1/start_session')
1843        self.assertTrue('The requested form is locked' in self.browser.contents)
1844
1845        IWorkflowState(self.student).setState('school fee paid')
1846        self.browser.open(self.student_path + '/studycourse/add')
1847        self.assertFalse('The requested form is locked' in self.browser.contents)
1848        self.browser.open(self.student_path + '/studycourse_1/add')
1849        self.assertTrue('The requested form is locked' in self.browser.contents)
1850
1851        self.browser.open(self.student_path + '/studycourse/999/manage')
1852        self.assertFalse('The requested form is locked' in self.browser.contents)
1853        self.browser.open(self.student_path + '/studycourse_1/999/manage')
1854        self.assertTrue('The requested form is locked' in self.browser.contents)
1855
1856        self.browser.open(self.student_path + '/studycourse/999/validate_courses')
1857        self.assertFalse('The requested form is locked' in self.browser.contents)
1858        self.browser.open(self.student_path + '/studycourse_1/999/validate_courses')
1859        self.assertTrue('The requested form is locked' in self.browser.contents)
1860
1861        self.browser.open(self.student_path + '/studycourse/999/reject_courses')
1862        self.assertFalse('The requested form is locked' in self.browser.contents)
1863        self.browser.open(self.student_path + '/studycourse_1/999/reject_courses')
1864        self.assertTrue('The requested form is locked' in self.browser.contents)
1865
1866        self.browser.open(self.student_path + '/studycourse/999/add')
1867        self.assertFalse('The requested form is locked' in self.browser.contents)
1868        self.browser.open(self.student_path + '/studycourse_1/999/add')
1869        self.assertTrue('The requested form is locked' in self.browser.contents)
1870
1871        self.browser.open(self.student_path + '/studycourse/999/edit')
1872        self.assertFalse('The requested form is locked' in self.browser.contents)
1873        self.browser.open(self.student_path + '/studycourse_1/999/edit')
1874        self.assertTrue('The requested form is locked' in self.browser.contents)
1875
1876        # Revert transfer
1877        self.browser.open(self.student_path + '/studycourse_1')
1878        self.browser.getLink("Reactivate").click()
1879        self.browser.getControl("Revert now").click()
1880        self.assertTrue('Previous transfer reverted' in self.browser.contents)
1881        results = list(
1882            cat.searchResults(
1883            certcode=('CERT1', 'CERT1')))
1884        self.assertTrue(results[0] is self.student)
1885        self.assertEqual([i for i in self.student.keys()],
1886            [u'accommodation', u'payments', u'studycourse'])
1887
1888    def test_login_as_student(self):
1889        # StudentImpersonators can login as student
1890        # Create clearance officer
1891        self.app['users'].addUser('mrofficer', 'mrofficersecret')
1892        self.app['users']['mrofficer'].email = 'mrofficer@foo.ng'
1893        self.app['users']['mrofficer'].title = 'Harry Actor'
1894        prmglobal = IPrincipalRoleManager(self.app)
1895        prmglobal.assignRoleToPrincipal('waeup.StudentImpersonator', 'mrofficer')
1896        prmglobal.assignRoleToPrincipal('waeup.StudentsManager', 'mrofficer')
1897        # Login as student impersonator
1898        self.browser.open(self.login_path)
1899        self.browser.getControl(name="form.login").value = 'mrofficer'
1900        self.browser.getControl(name="form.password").value = 'mrofficersecret'
1901        self.browser.getControl("Login").click()
1902        self.assertMatches('...You logged in...', self.browser.contents)
1903        self.browser.open(self.student_path)
1904        self.browser.getLink("Login as").click()
1905        self.browser.getControl("Set password now").click()
1906        temp_password = self.browser.getControl(name='form.password').value
1907        self.browser.getControl("Login now").click()
1908        self.assertMatches(
1909            '...You successfully logged in as...', self.browser.contents)
1910        # We are logged in as student and can see the 'My Data' tab
1911        self.assertMatches(
1912            '...<a href="#" class="dropdown-toggle">My Data</a>...',
1913            self.browser.contents)
1914        self.browser.getLink("Logout").click()
1915        # The student can't login with the original password ...
1916        self.browser.open(self.login_path)
1917        self.browser.getControl(name="form.login").value = self.student_id
1918        self.browser.getControl(name="form.password").value = 'spwd'
1919        self.browser.getControl("Login").click()
1920        self.assertMatches(
1921            '...Your account has been temporarily deactivated...',
1922            self.browser.contents)
1923        # ... but with the temporary password
1924        self.browser.open(self.login_path)
1925        self.browser.getControl(name="form.login").value = self.student_id
1926        self.browser.getControl(name="form.password").value = temp_password
1927        self.browser.getControl("Login").click()
1928        self.assertMatches('...You logged in...', self.browser.contents)
1929        # Creation of temp_password is properly logged
1930        logfile = os.path.join(
1931            self.app['datacenter'].storage, 'logs', 'students.log')
1932        logcontent = open(logfile).read()
1933        self.assertTrue(
1934            'mrofficer - students.browser.LoginAsStudentStep1 - K1000000 - '
1935            'temp_password generated: %s' % temp_password in logcontent)
1936
1937    def test_transcripts(self):
1938        studylevel = createObject(u'waeup.StudentStudyLevel')
1939        studylevel.level = 100
1940        studylevel.level_session = 2005
1941        self.student['studycourse'].entry_mode = 'ug_ft'
1942        self.student['studycourse'].addStudentStudyLevel(
1943            self.certificate, studylevel)
1944        studylevel2 = createObject(u'waeup.StudentStudyLevel')
1945        studylevel2.level = 110
1946        studylevel2.level_session = 2006
1947        self.student['studycourse'].addStudentStudyLevel(
1948            self.certificate, studylevel2)
1949        # Add second course (COURSE has been added automatically)
1950        courseticket = createObject('waeup.CourseTicket')
1951        courseticket.code = 'ANYCODE'
1952        courseticket.title = u'Any TITLE'
1953        courseticket.credits = 13
1954        courseticket.score = 66
1955        courseticket.semester = 1
1956        courseticket.dcode = u'ANYDCODE'
1957        courseticket.fcode = u'ANYFCODE'
1958        self.student['studycourse']['110']['COURSE2'] = courseticket
1959        self.student['studycourse']['100']['COURSE1'].score = 55
1960        self.assertEqual(self.student['studycourse']['100'].gpa_params_rectified[0], 3.0)
1961        self.assertEqual(self.student['studycourse']['110'].gpa_params_rectified[0], 4.0)
1962        # Get transcript data
1963        td = self.student['studycourse'].getTranscriptData()
1964        self.assertEqual(td[0][0]['level_key'], '100')
1965        self.assertEqual(td[0][0]['sgpa'], 3.0)
1966        self.assertEqual(td[0][0]['level'].level, 100)
1967        self.assertEqual(td[0][0]['level'].level_session, 2005)
1968        self.assertEqual(td[0][0]['tickets_1'][0].code, 'COURSE1')
1969        self.assertEqual(td[0][1]['level_key'], '110')
1970        self.assertEqual(td[0][1]['sgpa'], 4.0)
1971        self.assertEqual(td[0][1]['level'].level, 110)
1972        self.assertEqual(td[0][1]['level'].level_session, 2006)
1973        self.assertEqual(td[0][1]['tickets_1'][0].code, 'ANYCODE')
1974        self.assertEqual(td[1], 3.57)
1975        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
1976        self.browser.open(self.student_path + '/studycourse/transcript')
1977        self.assertEqual(self.browser.headers['Status'], '200 Ok')
1978        self.assertTrue('Transcript' in self.browser.contents)
1979        # Officers can open the pdf transcript
1980        self.browser.open(self.student_path + '/studycourse/transcript.pdf')
1981        self.assertEqual(self.browser.headers['Status'], '200 Ok')
1982        self.assertEqual(self.browser.headers['Content-Type'], 'application/pdf')
1983        path = os.path.join(samples_dir(), 'transcript.pdf')
1984        open(path, 'wb').write(self.browser.contents)
1985        print "Sample PDF transcript.pdf written to %s" % path
1986
1987    def test_process_transcript_request(self):
1988        IWorkflowState(self.student).setState('transcript requested')
1989        notify(grok.ObjectModifiedEvent(self.student))
1990        self.student.transcript_comment = (
1991            u'On 07/08/2013 08:59:54 UTC K1000000 wrote:\n\nComment line 1 \n'
1992            'Comment line2\n\nDispatch Address:\nAddress line 1 \n'
1993            'Address line2\n\n')
1994        # Create transcript officer
1995        self.app['users'].addUser('mrtranscript', 'mrtranscriptsecret')
1996        self.app['users']['mrtranscript'].email = 'mrtranscript@foo.ng'
1997        self.app['users']['mrtranscript'].title = 'Ruth Gordon'
1998        prmglobal = IPrincipalRoleManager(self.app)
1999        prmglobal.assignRoleToPrincipal('waeup.TranscriptOfficer', 'mrtranscript')
2000        # Login as transcript officer
2001        self.browser.open(self.login_path)
2002        self.browser.getControl(name="form.login").value = 'mrtranscript'
2003        self.browser.getControl(name="form.password").value = 'mrtranscriptsecret'
2004        self.browser.getControl("Login").click()
2005        self.assertMatches('...You logged in...', self.browser.contents)
2006        # Officer can see his roles
2007        self.browser.getLink("My Roles").click()
2008        self.assertMatches(
2009            '...<div>Transcript Officer</div>...',
2010            self.browser.contents)
2011        # Officer can search for students in state 'transcripr requested'
2012        self.browser.open(self.container_path)
2013        self.browser.getControl(name="searchtype").value = ['transcript']
2014        self.browser.getControl("Search").click()
2015        self.assertTrue('Anna Tester' in self.browser.contents)
2016        self.browser.getLink("K1000000").click()
2017        self.browser.getLink("Manage transcript request").click()
2018        self.assertTrue(' UTC K1000000 wrote:<br><br>Comment line 1 <br>'
2019        'Comment line2<br><br>Dispatch Address:<br>Address line 1 <br>'
2020        'Address line2<br><br></p>' in self.browser.contents)
2021        self.browser.getControl(name="comment").value = (
2022            'Hello,\nYour transcript has been sent to the address provided.')
2023        self.browser.getControl("Save comment and mark as processed").click()
2024        self.assertTrue(
2025            'UTC mrtranscript wrote:\n\nHello,\nYour transcript has '
2026            'been sent to the address provided.\n\n'
2027            in self.student.transcript_comment)
2028        # The comment has been logged
2029        logfile = os.path.join(
2030            self.app['datacenter'].storage, 'logs', 'students.log')
2031        logcontent = open(logfile).read()
2032        self.assertTrue(
2033            'mrtranscript - students.browser.StudentTranscriptRequestProcessFormPage - '
2034            'K1000000 - comment: Hello,<br>'
2035            'Your transcript has been sent to the address provided'
2036            in logcontent)
2037
2038class StudentUITests(StudentsFullSetup):
2039    # Tests for Student class views and pages
2040
2041    def test_student_change_password(self):
2042        # Students can change the password
2043        self.student.personal_updated = datetime.utcnow()
2044        self.browser.open(self.login_path)
2045        self.browser.getControl(name="form.login").value = self.student_id
2046        self.browser.getControl(name="form.password").value = 'spwd'
2047        self.browser.getControl("Login").click()
2048        self.assertEqual(self.browser.url, self.student_path)
2049        self.assertTrue('You logged in' in self.browser.contents)
2050        # Change password
2051        self.browser.getLink("Change password").click()
2052        self.browser.getControl(name="change_password").value = 'pw'
2053        self.browser.getControl(
2054            name="change_password_repeat").value = 'pw'
2055        self.browser.getControl("Save").click()
2056        self.assertTrue('Password must have at least' in self.browser.contents)
2057        self.browser.getControl(name="change_password").value = 'new_password'
2058        self.browser.getControl(
2059            name="change_password_repeat").value = 'new_passssword'
2060        self.browser.getControl("Save").click()
2061        self.assertTrue('Passwords do not match' in self.browser.contents)
2062        self.browser.getControl(name="change_password").value = 'new_password'
2063        self.browser.getControl(
2064            name="change_password_repeat").value = 'new_password'
2065        self.browser.getControl("Save").click()
2066        self.assertTrue('Password changed' in self.browser.contents)
2067        # We are still logged in. Changing the password hasn't thrown us out.
2068        self.browser.getLink("Base Data").click()
2069        self.assertEqual(self.browser.url, self.student_path)
2070        # We can logout
2071        self.browser.getLink("Logout").click()
2072        self.assertTrue('You have been logged out' in self.browser.contents)
2073        self.assertEqual(self.browser.url, 'http://localhost/app')
2074        # We can login again with the new password
2075        self.browser.getLink("Login").click()
2076        self.browser.open(self.login_path)
2077        self.browser.getControl(name="form.login").value = self.student_id
2078        self.browser.getControl(name="form.password").value = 'new_password'
2079        self.browser.getControl("Login").click()
2080        self.assertEqual(self.browser.url, self.student_path)
2081        self.assertTrue('You logged in' in self.browser.contents)
2082        return
2083
2084    def test_setpassword(self):
2085        # Set password for first-time access
2086        student = Student()
2087        student.reg_number = u'123456'
2088        student.firstname = u'Klaus'
2089        student.lastname = u'Tester'
2090        self.app['students'].addStudent(student)
2091        setpassword_path = 'http://localhost/app/setpassword'
2092        student_path = 'http://localhost/app/students/%s' % student.student_id
2093        self.browser.open(setpassword_path)
2094        self.browser.getControl(name="ac_series").value = self.existing_pwdseries
2095        self.browser.getControl(name="ac_number").value = self.existing_pwdnumber
2096        self.browser.getControl(name="reg_number").value = '223456'
2097        self.browser.getControl("Set").click()
2098        self.assertMatches('...No student found...',
2099                           self.browser.contents)
2100        self.browser.getControl(name="reg_number").value = '123456'
2101        self.browser.getControl(name="ac_number").value = '999999'
2102        self.browser.getControl("Set").click()
2103        self.assertMatches('...Access code is invalid...',
2104                           self.browser.contents)
2105        self.browser.getControl(name="ac_number").value = self.existing_pwdnumber
2106        self.browser.getControl("Set").click()
2107        self.assertMatches('...Password has been set. Your Student Id is...',
2108                           self.browser.contents)
2109        self.browser.getControl("Set").click()
2110        self.assertMatches(
2111            '...Password has already been set. Your Student Id is...',
2112            self.browser.contents)
2113        existing_pwdpin = self.pwdpins[1]
2114        parts = existing_pwdpin.split('-')[1:]
2115        existing_pwdseries, existing_pwdnumber = parts
2116        self.browser.getControl(name="ac_series").value = existing_pwdseries
2117        self.browser.getControl(name="ac_number").value = existing_pwdnumber
2118        self.browser.getControl(name="reg_number").value = '123456'
2119        self.browser.getControl("Set").click()
2120        self.assertMatches(
2121            '...You are using the wrong Access Code...',
2122            self.browser.contents)
2123        # The student can login with the new credentials
2124        self.browser.open(self.login_path)
2125        self.browser.getControl(name="form.login").value = student.student_id
2126        self.browser.getControl(
2127            name="form.password").value = self.existing_pwdnumber
2128        self.browser.getControl("Login").click()
2129        self.assertEqual(self.browser.url, student_path)
2130        self.assertTrue('You logged in' in self.browser.contents)
2131        return
2132
2133    def test_student_login(self):
2134        # Student cant login if their password is not set
2135        self.student.password = None
2136        self.browser.open(self.login_path)
2137        self.browser.getControl(name="form.login").value = self.student_id
2138        self.browser.getControl(name="form.password").value = 'spwd'
2139        self.browser.getControl("Login").click()
2140        self.assertTrue(
2141            'You entered invalid credentials.' in self.browser.contents)
2142        # We set the password again
2143        IUserAccount(
2144            self.app['students'][self.student_id]).setPassword('spwd')
2145        # Students can't login if their account is suspended/deactivated
2146        self.student.suspended = True
2147        self.browser.open(self.login_path)
2148        self.browser.getControl(name="form.login").value = self.student_id
2149        self.browser.getControl(name="form.password").value = 'spwd'
2150        self.browser.getControl("Login").click()
2151        self.assertMatches(
2152            '...<div class="alert-message warning">'
2153            'Your account has been deactivated.</div>...', self.browser.contents)
2154        # If suspended_comment is set this message will be flashed instead
2155        self.student.suspended_comment = u'Aetsch baetsch!'
2156        self.browser.getControl(name="form.login").value = self.student_id
2157        self.browser.getControl(name="form.password").value = 'spwd'
2158        self.browser.getControl("Login").click()
2159        self.assertMatches(
2160            '...<div class="alert-message warning">Aetsch baetsch!</div>...',
2161            self.browser.contents)
2162        self.student.suspended = False
2163        # Students can't login if a temporary password has been set and
2164        # is not expired
2165        self.app['students'][self.student_id].setTempPassword(
2166            'anybody', 'temp_spwd')
2167        self.browser.open(self.login_path)
2168        self.browser.getControl(name="form.login").value = self.student_id
2169        self.browser.getControl(name="form.password").value = 'spwd'
2170        self.browser.getControl("Login").click()
2171        self.assertMatches(
2172            '...Your account has been temporarily deactivated...',
2173            self.browser.contents)
2174        # The student can login with the temporary password
2175        self.browser.open(self.login_path)
2176        self.browser.getControl(name="form.login").value = self.student_id
2177        self.browser.getControl(name="form.password").value = 'temp_spwd'
2178        self.browser.getControl("Login").click()
2179        self.assertMatches(
2180            '...You logged in...', self.browser.contents)
2181        # Student can view the base data
2182        self.browser.open(self.student_path)
2183        self.assertEqual(self.browser.headers['Status'], '200 Ok')
2184        self.assertEqual(self.browser.url, self.student_path)
2185        # When the password expires ...
2186        delta = timedelta(minutes=11)
2187        self.app['students'][self.student_id].temp_password[
2188            'timestamp'] = datetime.utcnow() - delta
2189        self.app['students'][self.student_id]._p_changed = True
2190        # ... the student will be automatically logged out
2191        self.assertRaises(
2192            Unauthorized, self.browser.open, self.student_path)
2193        # Then the student can login with the original password
2194        self.browser.open(self.login_path)
2195        self.browser.getControl(name="form.login").value = self.student_id
2196        self.browser.getControl(name="form.password").value = 'spwd'
2197        self.browser.getControl("Login").click()
2198        self.assertMatches(
2199            '...You logged in...', self.browser.contents)
2200
2201    def test_student_clearance(self):
2202        # Student cant login if their password is not set
2203        IWorkflowInfo(self.student).fireTransition('admit')
2204        self.browser.open(self.login_path)
2205        self.browser.getControl(name="form.login").value = self.student_id
2206        self.browser.getControl(name="form.password").value = 'spwd'
2207        self.browser.getControl("Login").click()
2208        self.assertMatches(
2209            '...You logged in...', self.browser.contents)
2210        # Admitted student can upload a passport picture
2211        self.browser.open(self.student_path + '/change_portrait')
2212        ctrl = self.browser.getControl(name='passportuploadedit')
2213        file_obj = open(SAMPLE_IMAGE, 'rb')
2214        file_ctrl = ctrl.mech_control
2215        file_ctrl.add_file(file_obj, filename='my_photo.jpg')
2216        self.browser.getControl(
2217            name='upload_passportuploadedit').click()
2218        self.assertTrue(
2219            '<img align="middle" height="125px" src="passport.jpg" />'
2220            in self.browser.contents)
2221        # Students can open admission letter
2222        self.browser.getLink("Base Data").click()
2223        self.browser.getLink("Download admission letter").click()
2224        self.assertEqual(self.browser.headers['Status'], '200 Ok')
2225        self.assertEqual(self.browser.headers['Content-Type'], 'application/pdf')
2226        # Student can view the clearance data
2227        self.browser.open(self.student_path)
2228        self.browser.getLink("Clearance Data").click()
2229        # Student can't open clearance edit form before starting clearance
2230        self.browser.open(self.student_path + '/cedit')
2231        self.assertMatches('...The requested form is locked...',
2232                           self.browser.contents)
2233        self.browser.getLink("Clearance Data").click()
2234        self.browser.getLink("Start clearance").click()
2235        self.student.email = None
2236        # Uups, we forgot to fill the email fields
2237        self.browser.getControl("Start clearance").click()
2238        self.assertMatches('...Not all required fields filled...',
2239                           self.browser.contents)
2240        self.browser.open(self.student_path + '/edit_base')
2241        self.browser.getControl(name="form.email").value = 'aa@aa.ng'
2242        self.browser.getControl("Save").click()
2243        self.browser.open(self.student_path + '/start_clearance')
2244        self.browser.getControl(name="ac_series").value = '3'
2245        self.browser.getControl(name="ac_number").value = '4444444'
2246        self.browser.getControl("Start clearance now").click()
2247        self.assertMatches('...Activation code is invalid...',
2248                           self.browser.contents)
2249        self.browser.getControl(name="ac_series").value = self.existing_clrseries
2250        self.browser.getControl(name="ac_number").value = self.existing_clrnumber
2251        # Owner is Hans Wurst, AC can't be invalidated
2252        self.browser.getControl("Start clearance now").click()
2253        self.assertMatches('...You are not the owner of this access code...',
2254                           self.browser.contents)
2255        # Set the correct owner
2256        self.existing_clrac.owner = self.student_id
2257        # clr_code might be set (and thus returns None) due importing
2258        # an empty clr_code column.
2259        self.student.clr_code = None
2260        self.browser.getControl("Start clearance now").click()
2261        self.assertMatches('...Clearance process has been started...',
2262                           self.browser.contents)
2263        self.browser.getControl(name="form.date_of_birth").value = '09/10/1961'
2264        self.browser.getControl("Save", index=0).click()
2265        # Student can view the clearance data
2266        self.browser.getLink("Clearance Data").click()
2267        # and go back to the edit form
2268        self.browser.getLink("Edit").click()
2269        # Students can upload documents
2270        ctrl = self.browser.getControl(name='birthcertificateupload')
2271        file_obj = open(SAMPLE_IMAGE, 'rb')
2272        file_ctrl = ctrl.mech_control
2273        file_ctrl.add_file(file_obj, filename='my_birth_certificate.jpg')
2274        self.browser.getControl(
2275            name='upload_birthcertificateupload').click()
2276        self.assertTrue(
2277            '<a target="image" href="birth_certificate">Birth Certificate Scan</a>'
2278            in self.browser.contents)
2279        # Students can open clearance slip
2280        self.browser.getLink("View").click()
2281        self.browser.getLink("Download clearance slip").click()
2282        self.assertEqual(self.browser.headers['Status'], '200 Ok')
2283        self.assertEqual(self.browser.headers['Content-Type'], 'application/pdf')
2284        # Students can request clearance
2285        self.browser.open(self.edit_clearance_path)
2286        self.browser.getControl("Save and request clearance").click()
2287        self.browser.getControl(name="ac_series").value = self.existing_clrseries
2288        self.browser.getControl(name="ac_number").value = self.existing_clrnumber
2289        self.browser.getControl("Request clearance now").click()
2290        self.assertMatches('...Clearance has been requested...',
2291                           self.browser.contents)
2292        # Student can't reopen clearance form after requesting clearance
2293        self.browser.open(self.student_path + '/cedit')
2294        self.assertMatches('...The requested form is locked...',
2295                           self.browser.contents)
2296
2297    def test_student_course_registration(self):
2298        # Student cant login if their password is not set
2299        IWorkflowInfo(self.student).fireTransition('admit')
2300        self.browser.open(self.login_path)
2301        self.browser.getControl(name="form.login").value = self.student_id
2302        self.browser.getControl(name="form.password").value = 'spwd'
2303        self.browser.getControl("Login").click()
2304        # Student can't add study level if not in state 'school fee paid'
2305        self.browser.open(self.student_path + '/studycourse/add')
2306        self.assertMatches('...The requested form is locked...',
2307                           self.browser.contents)
2308        # ... and must be transferred first
2309        IWorkflowState(self.student).setState('school fee paid')
2310        # Now students can add the current study level
2311        self.browser.getLink("Study Course").click()
2312        self.browser.getLink("Add course list").click()
2313        self.assertMatches('...Add current level 100 (Year 1)...',
2314                           self.browser.contents)
2315        self.browser.getControl("Create course list now").click()
2316        # A level with one course ticket was created
2317        self.assertEqual(self.student['studycourse']['100'].number_of_tickets, 1)
2318        self.browser.getLink("100").click()
2319        self.browser.getLink("Edit course list").click()
2320        self.browser.getLink("here").click()
2321        self.browser.getControl(name="form.course").value = ['COURSE1']
2322        self.browser.getControl("Add course ticket").click()
2323        self.assertMatches('...The ticket exists...',
2324                           self.browser.contents)
2325        self.student['studycourse'].current_level = 200
2326        self.browser.getLink("Study Course").click()
2327        self.browser.getLink("Add course list").click()
2328        self.assertMatches('...Add current level 200 (Year 2)...',
2329                           self.browser.contents)
2330        self.browser.getControl("Create course list now").click()
2331        self.browser.getLink("200").click()
2332        self.browser.getLink("Edit course list").click()
2333        self.browser.getLink("here").click()
2334        self.browser.getControl(name="form.course").value = ['COURSE1']
2335        self.course.credits = 100
2336        self.browser.getControl("Add course ticket").click()
2337        self.assertMatches(
2338            '...Total credits exceed 50...', self.browser.contents)
2339        self.course.credits = 10
2340        self.browser.getControl("Add course ticket").click()
2341        self.assertMatches('...The ticket exists...',
2342                           self.browser.contents)
2343        # Indeed the ticket exists as carry-over course from level 100
2344        # since its score was 0
2345        self.assertTrue(
2346            self.student['studycourse']['200']['COURSE1'].carry_over is True)
2347        # Students can open the pdf course registration slip
2348        self.browser.open(self.student_path + '/studycourse/200')
2349        self.browser.getLink("Download course registration slip").click()
2350        self.assertEqual(self.browser.headers['Status'], '200 Ok')
2351        self.assertEqual(self.browser.headers['Content-Type'], 'application/pdf')
2352        # Students can remove course tickets
2353        self.browser.open(self.student_path + '/studycourse/200/edit')
2354        self.browser.getControl("Remove selected", index=0).click()
2355        self.assertTrue('No ticket selected' in self.browser.contents)
2356        # No ticket can be selected since the carry-over course is a core course
2357        self.assertRaises(
2358            LookupError, self.browser.getControl, name='val_id')
2359        self.student['studycourse']['200']['COURSE1'].mandatory = False
2360        self.browser.open(self.student_path + '/studycourse/200/edit')
2361        # Course list can't be registered if total_credits exceeds max_credits
2362        self.student['studycourse']['200']['COURSE1'].credits = 60
2363        self.browser.getControl("Register course list").click()
2364        self.assertTrue('Maximum credits of 50 exceeded' in self.browser.contents)
2365        # Student can now remove the ticket
2366        ctrl = self.browser.getControl(name='val_id')
2367        ctrl.getControl(value='COURSE1').selected = True
2368        self.browser.getControl("Remove selected", index=0).click()
2369        self.assertTrue('Successfully removed' in self.browser.contents)
2370        # Removing course tickets is properly logged
2371        logfile = os.path.join(
2372            self.app['datacenter'].storage, 'logs', 'students.log')
2373        logcontent = open(logfile).read()
2374        self.assertTrue('K1000000 - students.browser.StudyLevelEditFormPage '
2375        '- K1000000 - removed: COURSE1 at 200' in logcontent)
2376        # They can add the same ticket using the edit page directly.
2377        # We can do the same by adding the course on the manage page directly
2378        self.browser.getControl(name="course").value = 'COURSE1'
2379        self.browser.getControl("Add course ticket").click()
2380        # Adding course tickets is logged
2381        logfile = os.path.join(
2382            self.app['datacenter'].storage, 'logs', 'students.log')
2383        logcontent = open(logfile).read()
2384        self.assertTrue('K1000000 - students.browser.StudyLevelEditFormPage - '
2385            'K1000000 - added: COURSE1|200|2004' in logcontent)
2386        # Course list can be registered
2387        self.browser.getControl("Register course list").click()
2388        self.assertTrue('Course list has been registered' in self.browser.contents)
2389        self.assertEqual(self.student.state, 'courses registered')
2390        # Students can view the transcript
2391        #self.browser.open(self.studycourse_path)
2392        #self.browser.getLink("Transcript").click()
2393        #self.browser.getLink("Academic Transcript").click()
2394        #self.assertEqual(self.browser.headers['Status'], '200 Ok')
2395        #self.assertEqual(self.browser.headers['Content-Type'], 'application/pdf')
2396        return
2397
2398    def test_postgraduate_student_access(self):
2399        self.certificate.study_mode = 'pg_ft'
2400        self.certificate.start_level = 999
2401        self.certificate.end_level = 999
2402        self.student['studycourse'].current_level = 999
2403        IWorkflowState(self.student).setState('school fee paid')
2404        self.browser.open(self.login_path)
2405        self.browser.getControl(name="form.login").value = self.student_id
2406        self.browser.getControl(name="form.password").value = 'spwd'
2407        self.browser.getControl("Login").click()
2408        self.assertTrue(
2409            'You logged in.' in self.browser.contents)
2410        # Now students can add the current study level
2411        self.browser.getLink("Study Course").click()
2412        self.browser.getLink("Add course list").click()
2413        self.assertMatches('...Add current level Postgraduate Level...',
2414                           self.browser.contents)
2415        self.browser.getControl("Create course list now").click()
2416        # A level with one course ticket was created
2417        self.assertEqual(self.student['studycourse']['999'].number_of_tickets, 0)
2418        self.browser.getLink("999").click()
2419        self.browser.getLink("Edit course list").click()
2420        self.browser.getLink("here").click()
2421        self.browser.getControl(name="form.course").value = ['COURSE1']
2422        self.browser.getControl("Add course ticket").click()
2423        self.assertMatches('...Successfully added COURSE1...',
2424                           self.browser.contents)
2425        # Postgraduate students can't register course lists
2426        self.browser.getControl("Register course list").click()
2427        self.assertTrue("your course list can't bee registered"
2428            in self.browser.contents)
2429        self.assertEqual(self.student.state, 'school fee paid')
2430        return
2431
2432    def test_student_clearance_wo_clrcode(self):
2433        IWorkflowState(self.student).setState('clearance started')
2434        self.browser.open(self.login_path)
2435        self.browser.getControl(name="form.login").value = self.student_id
2436        self.browser.getControl(name="form.password").value = 'spwd'
2437        self.browser.getControl("Login").click()
2438        self.student.clearance_locked = False
2439        self.browser.open(self.edit_clearance_path)
2440        self.browser.getControl(name="form.date_of_birth").value = '09/10/1961'
2441        self.browser.getControl("Save and request clearance").click()
2442        self.assertMatches('...Clearance has been requested...',
2443                           self.browser.contents)
2444
2445    def test_student_clearance_payment(self):
2446        # Login
2447        self.browser.open(self.login_path)
2448        self.browser.getControl(name="form.login").value = self.student_id
2449        self.browser.getControl(name="form.password").value = 'spwd'
2450        self.browser.getControl("Login").click()
2451
2452        # Students can add online clearance payment tickets
2453        self.browser.open(self.payments_path + '/addop')
2454        self.browser.getControl(name="form.p_category").value = ['clearance']
2455        self.browser.getControl("Create ticket").click()
2456        self.assertMatches('...ticket created...',
2457                           self.browser.contents)
2458
2459        # Students can't approve the payment
2460        self.assertEqual(len(self.app['accesscodes']['CLR-0']),0)
2461        ctrl = self.browser.getControl(name='val_id')
2462        value = ctrl.options[0]
2463        self.browser.getLink(value).click()
2464        payment_url = self.browser.url
2465        self.assertRaises(
2466            Unauthorized, self.browser.open, payment_url + '/approve')
2467        # In the base package they can 'use' a fake approval view.
2468        # XXX: I tried to use
2469        # self.student['payments'][value].approveStudentPayment() instead.
2470        # But this function fails in
2471        # w.k.accesscodes.accesscode.create_accesscode.
2472        # grok.getSite returns None in tests.
2473        self.browser.open(payment_url + '/fake_approve')
2474        self.assertMatches('...Payment approved...',
2475                          self.browser.contents)
2476        expected = '''...
2477        <td>
2478          <span>Paid</span>
2479        </td>...'''
2480        expected = '''...
2481        <td>
2482          <span>Paid</span>
2483        </td>...'''
2484        self.assertMatches(expected,self.browser.contents)
2485        payment_id = self.student['payments'].keys()[0]
2486        payment = self.student['payments'][payment_id]
2487        self.assertEqual(payment.p_state, 'paid')
2488        self.assertEqual(payment.r_amount_approved, 3456.0)
2489        self.assertEqual(payment.r_code, 'AP')
2490        self.assertEqual(payment.r_desc, u'Payment approved by Anna Tester')
2491        # The new CLR-0 pin has been created
2492        self.assertEqual(len(self.app['accesscodes']['CLR-0']),1)
2493        pin = self.app['accesscodes']['CLR-0'].keys()[0]
2494        ac = self.app['accesscodes']['CLR-0'][pin]
2495        self.assertEqual(ac.owner, self.student_id)
2496        self.assertEqual(ac.cost, 3456.0)
2497
2498        # Students can open the pdf payment slip
2499        self.browser.open(payment_url + '/payment_slip.pdf')
2500        self.assertEqual(self.browser.headers['Status'], '200 Ok')
2501        self.assertEqual(self.browser.headers['Content-Type'], 'application/pdf')
2502
2503        # The new CLR-0 pin can be used for starting clearance
2504        # but they have to upload a passport picture first
2505        # which is only possible in state admitted
2506        self.browser.open(self.student_path + '/change_portrait')
2507        self.assertMatches('...form is locked...',
2508                          self.browser.contents)
2509        IWorkflowInfo(self.student).fireTransition('admit')
2510        self.browser.open(self.student_path + '/change_portrait')
2511        image = open(SAMPLE_IMAGE, 'rb')
2512        ctrl = self.browser.getControl(name='passportuploadedit')
2513        file_ctrl = ctrl.mech_control
2514        file_ctrl.add_file(image, filename='my_photo.jpg')
2515        self.browser.getControl(
2516            name='upload_passportuploadedit').click()
2517        self.browser.open(self.student_path + '/start_clearance')
2518        parts = pin.split('-')[1:]
2519        clrseries, clrnumber = parts
2520        self.browser.getControl(name="ac_series").value = clrseries
2521        self.browser.getControl(name="ac_number").value = clrnumber
2522        self.browser.getControl("Start clearance now").click()
2523        self.assertMatches('...Clearance process has been started...',
2524                           self.browser.contents)
2525
2526    def test_student_schoolfee_payment(self):
2527        configuration = createObject('waeup.SessionConfiguration')
2528        configuration.academic_session = 2005
2529        self.app['configuration'].addSessionConfiguration(configuration)
2530        # Login
2531        self.browser.open(self.login_path)
2532        self.browser.getControl(name="form.login").value = self.student_id
2533        self.browser.getControl(name="form.password").value = 'spwd'
2534        self.browser.getControl("Login").click()
2535
2536        # Students can add online school fee payment tickets.
2537        IWorkflowState(self.student).setState('returning')
2538        self.browser.open(self.payments_path)
2539        self.assertRaises(
2540            LookupError, self.browser.getControl, name='val_id')
2541        self.browser.getLink("Add current session payment ticket").click()
2542        self.browser.getControl(name="form.p_category").value = ['schoolfee']
2543        self.browser.getControl("Create ticket").click()
2544        self.assertMatches('...ticket created...',
2545                           self.browser.contents)
2546        ctrl = self.browser.getControl(name='val_id')
2547        value = ctrl.options[0]
2548        self.browser.getLink(value).click()
2549        self.assertMatches('...Amount Authorized...',
2550                           self.browser.contents)
2551        self.assertEqual(self.student['payments'][value].amount_auth, 20000.0)
2552        # Payment session and will be calculated as defined
2553        # in w.k.students.utils because we set changed the state
2554        # to returning
2555        self.assertEqual(self.student['payments'][value].p_session, 2005)
2556        self.assertEqual(self.student['payments'][value].p_level, 200)
2557
2558        # Student is the payer of the payment ticket.
2559        payer = IPayer(self.student['payments'][value])
2560        self.assertEqual(payer.display_fullname, 'Anna Tester')
2561        self.assertEqual(payer.id, self.student_id)
2562        self.assertEqual(payer.faculty, 'fac1')
2563        self.assertEqual(payer.department, 'dep1')
2564
2565        # We simulate the approval
2566        self.assertEqual(len(self.app['accesscodes']['SFE-0']),0)
2567        self.browser.open(self.browser.url + '/fake_approve')
2568        self.assertMatches('...Payment approved...',
2569                          self.browser.contents)
2570
2571        # The new SFE-0 pin can be used for starting new session
2572        self.browser.open(self.studycourse_path)
2573        self.browser.getLink('Start new session').click()
2574        pin = self.app['accesscodes']['SFE-0'].keys()[0]
2575        parts = pin.split('-')[1:]
2576        sfeseries, sfenumber = parts
2577        self.browser.getControl(name="ac_series").value = sfeseries
2578        self.browser.getControl(name="ac_number").value = sfenumber
2579        self.browser.getControl("Start now").click()
2580        self.assertMatches('...Session started...',
2581                           self.browser.contents)
2582        self.assertTrue(self.student.state == 'school fee paid')
2583        return
2584
2585    def test_student_bedallocation_payment(self):
2586        # Login
2587        self.browser.open(self.login_path)
2588        self.browser.getControl(name="form.login").value = self.student_id
2589        self.browser.getControl(name="form.password").value = 'spwd'
2590        self.browser.getControl("Login").click()
2591        self.browser.open(self.payments_path)
2592        self.browser.open(self.payments_path + '/addop')
2593        self.browser.getControl(name="form.p_category").value = ['bed_allocation']
2594        self.browser.getControl("Create ticket").click()
2595        self.assertMatches('...ticket created...',
2596                           self.browser.contents)
2597        # Students can remove only online payment tickets which have
2598        # not received a valid callback
2599        self.browser.open(self.payments_path)
2600        ctrl = self.browser.getControl(name='val_id')
2601        value = ctrl.options[0]
2602        ctrl.getControl(value=value).selected = True
2603        self.browser.getControl("Remove selected", index=0).click()
2604        self.assertTrue('Successfully removed' in self.browser.contents)
2605
2606    def test_student_maintenance_payment(self):
2607        # Login
2608        self.browser.open(self.login_path)
2609        self.browser.getControl(name="form.login").value = self.student_id
2610        self.browser.getControl(name="form.password").value = 'spwd'
2611        self.browser.getControl("Login").click()
2612        self.browser.open(self.payments_path)
2613        self.browser.open(self.payments_path + '/addop')
2614        self.browser.getControl(name="form.p_category").value = ['hostel_maintenance']
2615        self.browser.getControl("Create ticket").click()
2616        self.assertMatches('...You have not yet booked accommodation...',
2617                           self.browser.contents)
2618        # We continue this test in test_student_accommodation
2619
2620    def test_student_previous_payments(self):
2621        configuration = createObject('waeup.SessionConfiguration')
2622        configuration.academic_session = 2000
2623        configuration.clearance_fee = 3456.0
2624        configuration.booking_fee = 123.4
2625        self.app['configuration'].addSessionConfiguration(configuration)
2626        configuration2 = createObject('waeup.SessionConfiguration')
2627        configuration2.academic_session = 2003
2628        configuration2.clearance_fee = 3456.0
2629        configuration2.booking_fee = 123.4
2630        self.app['configuration'].addSessionConfiguration(configuration2)
2631        configuration3 = createObject('waeup.SessionConfiguration')
2632        configuration3.academic_session = 2005
2633        configuration3.clearance_fee = 3456.0
2634        configuration3.booking_fee = 123.4
2635        self.app['configuration'].addSessionConfiguration(configuration3)
2636        self.student['studycourse'].entry_session = 2002
2637
2638        # Login
2639        self.browser.open(self.login_path)
2640        self.browser.getControl(name="form.login").value = self.student_id
2641        self.browser.getControl(name="form.password").value = 'spwd'
2642        self.browser.getControl("Login").click()
2643
2644        # Students can add previous school fee payment tickets in any state.
2645        IWorkflowState(self.student).setState('courses registered')
2646        self.browser.open(self.payments_path)
2647        self.browser.getLink("Add previous session payment ticket").click()
2648
2649        # Previous session payment form is provided
2650        self.assertEqual(self.student.current_session, 2004)
2651        self.browser.getControl(name="form.p_category").value = ['schoolfee']
2652        self.browser.getControl(name="form.p_session").value = ['2000']
2653        self.browser.getControl(name="form.p_level").value = ['300']
2654        self.browser.getControl("Create ticket").click()
2655        self.assertMatches('...The previous session must not fall below...',
2656                           self.browser.contents)
2657        self.browser.getControl(name="form.p_category").value = ['schoolfee']
2658        self.browser.getControl(name="form.p_session").value = ['2005']
2659        self.browser.getControl(name="form.p_level").value = ['300']
2660        self.browser.getControl("Create ticket").click()
2661        self.assertMatches('...This is not a previous session...',
2662                           self.browser.contents)
2663        # Students can pay current session school fee.
2664        self.browser.getControl(name="form.p_category").value = ['schoolfee']
2665        self.browser.getControl(name="form.p_session").value = ['2004']
2666        self.browser.getControl(name="form.p_level").value = ['300']
2667        self.browser.getControl("Create ticket").click()
2668        self.assertMatches('...ticket created...',
2669                           self.browser.contents)
2670        ctrl = self.browser.getControl(name='val_id')
2671        value = ctrl.options[0]
2672        self.browser.getLink(value).click()
2673        self.assertMatches('...Amount Authorized...',
2674                           self.browser.contents)
2675        self.assertEqual(self.student['payments'][value].amount_auth, 20000.0)
2676
2677        # Payment session is properly set
2678        self.assertEqual(self.student['payments'][value].p_session, 2004)
2679        self.assertEqual(self.student['payments'][value].p_level, 300)
2680
2681        # We simulate the approval
2682        self.browser.open(self.browser.url + '/fake_approve')
2683        self.assertMatches('...Payment approved...',
2684                          self.browser.contents)
2685
2686        # No AC has been created
2687        self.assertEqual(len(self.app['accesscodes']['SFE-0'].keys()), 0)
2688        self.assertTrue(self.student['payments'][value].ac is None)
2689
2690        # Current payment flag is set False
2691        self.assertFalse(self.student['payments'][value].p_current)
2692
2693        # Button and form are not available for students who are in
2694        # states up to cleared
2695        self.student['studycourse'].entry_session = 2004
2696        IWorkflowState(self.student).setState('cleared')
2697        self.browser.open(self.payments_path)
2698        self.assertFalse(
2699            "Add previous session payment ticket" in self.browser.contents)
2700        self.browser.open(self.payments_path + '/addpp')
2701        self.assertTrue(
2702            "No previous payment to be made" in self.browser.contents)
2703        return
2704
2705    def test_postgraduate_student_payments(self):
2706        configuration = createObject('waeup.SessionConfiguration')
2707        configuration.academic_session = 2005
2708        self.app['configuration'].addSessionConfiguration(configuration)
2709        self.certificate.study_mode = 'pg_ft'
2710        self.certificate.start_level = 999
2711        self.certificate.end_level = 999
2712        self.student['studycourse'].current_level = 999
2713        # Login
2714        self.browser.open(self.login_path)
2715        self.browser.getControl(name="form.login").value = self.student_id
2716        self.browser.getControl(name="form.password").value = 'spwd'
2717        self.browser.getControl("Login").click()
2718        # Students can add online school fee payment tickets.
2719        IWorkflowState(self.student).setState('cleared')
2720        self.browser.open(self.payments_path)
2721        self.browser.getLink("Add current session payment ticket").click()
2722        self.browser.getControl(name="form.p_category").value = ['schoolfee']
2723        self.browser.getControl("Create ticket").click()
2724        self.assertMatches('...ticket created...',
2725                           self.browser.contents)
2726        ctrl = self.browser.getControl(name='val_id')
2727        value = ctrl.options[0]
2728        self.browser.getLink(value).click()
2729        self.assertMatches('...Amount Authorized...',
2730                           self.browser.contents)
2731        # Payment session and level are current ones.
2732        # Postgrads have to pay school_fee_1.
2733        self.assertEqual(self.student['payments'][value].amount_auth, 40000.0)
2734        self.assertEqual(self.student['payments'][value].p_session, 2004)
2735        self.assertEqual(self.student['payments'][value].p_level, 999)
2736
2737        # We simulate the approval
2738        self.assertEqual(len(self.app['accesscodes']['SFE-0']),0)
2739        self.browser.open(self.browser.url + '/fake_approve')
2740        self.assertMatches('...Payment approved...',
2741                          self.browser.contents)
2742
2743        # The new SFE-0 pin can be used for starting session
2744        self.browser.open(self.studycourse_path)
2745        self.browser.getLink('Start new session').click()
2746        pin = self.app['accesscodes']['SFE-0'].keys()[0]
2747        parts = pin.split('-')[1:]
2748        sfeseries, sfenumber = parts
2749        self.browser.getControl(name="ac_series").value = sfeseries
2750        self.browser.getControl(name="ac_number").value = sfenumber
2751        self.browser.getControl("Start now").click()
2752        self.assertMatches('...Session started...',
2753                           self.browser.contents)
2754        self.assertTrue(self.student.state == 'school fee paid')
2755
2756        # Postgrad students do not need to register courses the
2757        # can just pay for the next session.
2758        self.browser.open(self.payments_path)
2759        # Remove first payment to be sure that we access the right ticket
2760        del self.student['payments'][value]
2761        self.browser.getLink("Add current session payment ticket").click()
2762        self.browser.getControl(name="form.p_category").value = ['schoolfee']
2763        self.browser.getControl("Create ticket").click()
2764        ctrl = self.browser.getControl(name='val_id')
2765        value = ctrl.options[0]
2766        self.browser.getLink(value).click()
2767        # Payment session has increased by one, payment level remains the same.
2768        # Returning Postgraduates have to pay school_fee_2.
2769        self.assertEqual(self.student['payments'][value].amount_auth, 20000.0)
2770        self.assertEqual(self.student['payments'][value].p_session, 2005)
2771        self.assertEqual(self.student['payments'][value].p_level, 999)
2772
2773        # Student is still in old session
2774        self.assertEqual(self.student.current_session, 2004)
2775
2776        # We do not need to pay the ticket if any other
2777        # SFE pin is provided
2778        pin_container = self.app['accesscodes']
2779        pin_container.createBatch(
2780            datetime.utcnow(), 'some_userid', 'SFE', 9.99, 1)
2781        pin = pin_container['SFE-1'].values()[0].representation
2782        sfeseries, sfenumber = pin.split('-')[1:]
2783        # The new SFE-1 pin can be used for starting new session
2784        self.browser.open(self.studycourse_path)
2785        self.browser.getLink('Start new session').click()
2786        self.browser.getControl(name="ac_series").value = sfeseries
2787        self.browser.getControl(name="ac_number").value = sfenumber
2788        self.browser.getControl("Start now").click()
2789        self.assertMatches('...Session started...',
2790                           self.browser.contents)
2791        self.assertTrue(self.student.state == 'school fee paid')
2792        # Student is in new session
2793        self.assertEqual(self.student.current_session, 2005)
2794        self.assertEqual(self.student['studycourse'].current_level, 999)
2795        return
2796
2797    def test_student_accommodation(self):
2798        # Login
2799        self.browser.open(self.login_path)
2800        self.browser.getControl(name="form.login").value = self.student_id
2801        self.browser.getControl(name="form.password").value = 'spwd'
2802        self.browser.getControl("Login").click()
2803
2804        # Students can add online booking fee payment tickets and open the
2805        # callback view (see test_manage_payments)
2806        self.browser.getLink("Payments").click()
2807        self.browser.getLink("Add current session payment ticket").click()
2808        self.browser.getControl(name="form.p_category").value = ['bed_allocation']
2809        self.browser.getControl("Create ticket").click()
2810        ctrl = self.browser.getControl(name='val_id')
2811        value = ctrl.options[0]
2812        self.browser.getLink(value).click()
2813        self.browser.open(self.browser.url + '/fake_approve')
2814        # The new HOS-0 pin has been created
2815        self.assertEqual(len(self.app['accesscodes']['HOS-0']),1)
2816        pin = self.app['accesscodes']['HOS-0'].keys()[0]
2817        ac = self.app['accesscodes']['HOS-0'][pin]
2818        parts = pin.split('-')[1:]
2819        sfeseries, sfenumber = parts
2820
2821        # Students can use HOS code and book a bed space with it ...
2822        self.browser.open(self.acco_path)
2823        # ... but not if booking period has expired ...
2824        self.app['hostels'].enddate = datetime.now(pytz.utc)
2825        self.browser.getLink("Book accommodation").click()
2826        self.assertMatches('...Outside booking period: ...',
2827                           self.browser.contents)
2828        self.app['hostels'].enddate = datetime.now(pytz.utc) + timedelta(days=10)
2829        # ... or student is not the an allowed state ...
2830        self.browser.getLink("Book accommodation").click()
2831        self.assertMatches('...You are in the wrong...',
2832                           self.browser.contents)
2833        IWorkflowInfo(self.student).fireTransition('admit')
2834        self.browser.getLink("Book accommodation").click()
2835        self.assertMatches('...Activation Code:...',
2836                           self.browser.contents)
2837        # Student can't used faked ACs ...
2838        self.browser.getControl(name="ac_series").value = u'nonsense'
2839        self.browser.getControl(name="ac_number").value = sfenumber
2840        self.browser.getControl("Create bed ticket").click()
2841        self.assertMatches('...Activation code is invalid...',
2842                           self.browser.contents)
2843        # ... or ACs owned by somebody else.
2844        ac.owner = u'Anybody'
2845        self.browser.getControl(name="ac_series").value = sfeseries
2846        self.browser.getControl(name="ac_number").value = sfenumber
2847        self.browser.getControl("Create bed ticket").click()
2848        self.assertMatches('...You are not the owner of this access code...',
2849                           self.browser.contents)
2850        ac.owner = self.student_id
2851        self.browser.getControl(name="ac_series").value = sfeseries
2852        self.browser.getControl(name="ac_number").value = sfenumber
2853        self.browser.getControl("Create bed ticket").click()
2854        self.assertMatches('...Hall 1, Block A, Room 101, Bed A...',
2855                           self.browser.contents)
2856
2857        # Bed has been allocated
2858        bed = self.app['hostels']['hall-1']['hall-1_A_101_A']
2859        self.assertTrue(bed.owner == self.student_id)
2860
2861        # BedTicketAddPage is now blocked
2862        self.browser.getLink("Book accommodation").click()
2863        self.assertMatches('...You already booked a bed space...',
2864            self.browser.contents)
2865
2866        # The bed ticket displays the data correctly
2867        self.browser.open(self.acco_path + '/2004')
2868        self.assertMatches('...Hall 1, Block A, Room 101, Bed A...',
2869                           self.browser.contents)
2870        self.assertMatches('...2004/2005...', self.browser.contents)
2871        self.assertMatches('...regular_male_fr...', self.browser.contents)
2872        self.assertMatches('...%s...' % pin, self.browser.contents)
2873
2874        # Students can open the pdf slip
2875        self.browser.open(self.browser.url + '/bed_allocation_slip.pdf')
2876        self.assertEqual(self.browser.headers['Status'], '200 Ok')
2877        self.assertEqual(self.browser.headers['Content-Type'], 'application/pdf')
2878
2879        # Students can't relocate themselves
2880        self.assertFalse('Relocate' in self.browser.contents)
2881        relocate_path = self.acco_path + '/2004/relocate'
2882        self.assertRaises(
2883            Unauthorized, self.browser.open, relocate_path)
2884
2885        # Students can't the Remove button and check boxes
2886        self.browser.open(self.acco_path)
2887        self.assertFalse('Remove' in self.browser.contents)
2888        self.assertFalse('val_id' in self.browser.contents)
2889
2890        # Students can pay maintenance fee now
2891        self.browser.open(self.payments_path)
2892        self.browser.open(self.payments_path + '/addop')
2893        self.browser.getControl(name="form.p_category").value = ['hostel_maintenance']
2894        self.browser.getControl("Create ticket").click()
2895        self.assertMatches('...Payment ticket created...',
2896                           self.browser.contents)
2897        return
2898
2899    def test_change_password_request(self):
2900        self.browser.open('http://localhost/app/changepw')
2901        self.browser.getControl(name="form.identifier").value = '123'
2902        self.browser.getControl(name="form.email").value = 'aa@aa.ng'
2903        self.browser.getControl("Send login credentials").click()
2904        self.assertTrue('An email with' in self.browser.contents)
2905
2906    def test_student_expired_personal_data(self):
2907        # Login
2908        IWorkflowState(self.student).setState('school fee paid')
2909        delta = timedelta(days=180)
2910        self.student.personal_updated = datetime.utcnow() - delta
2911        self.browser.open(self.login_path)
2912        self.browser.getControl(name="form.login").value = self.student_id
2913        self.browser.getControl(name="form.password").value = 'spwd'
2914        self.browser.getControl("Login").click()
2915        self.assertEqual(self.browser.url, self.student_path)
2916        self.assertTrue(
2917            'You logged in' in self.browser.contents)
2918        # Students don't see personal_updated field in edit form
2919        self.browser.open(self.edit_personal_path)
2920        self.assertFalse('Updated' in self.browser.contents)
2921        self.browser.open(self.personal_path)
2922        self.assertTrue('Updated' in self.browser.contents)
2923        self.browser.getLink("Logout").click()
2924        delta = timedelta(days=181)
2925        self.student.personal_updated = datetime.utcnow() - delta
2926        self.browser.open(self.login_path)
2927        self.browser.getControl(name="form.login").value = self.student_id
2928        self.browser.getControl(name="form.password").value = 'spwd'
2929        self.browser.getControl("Login").click()
2930        self.assertEqual(self.browser.url, self.edit_personal_path)
2931        self.assertTrue(
2932            'Your personal data record is outdated.' in self.browser.contents)
2933
2934    def test_setReturningData(self):
2935        utils = getUtility(IStudentsUtils)
2936        self.student['studycourse'].current_level = 600
2937        utils.setReturningData(self.student)
2938        # The new level exceeds the certificates end_level.
2939        # In this case current_level remains unchanged and no error is raised.
2940        self.assertEqual(self.student['studycourse'].current_level, 600)
2941
2942    def test_request_transcript(self):
2943        IWorkflowState(self.student).setState('graduated')
2944        self.browser.open(self.login_path)
2945        self.browser.getControl(name="form.login").value = self.student_id
2946        self.browser.getControl(name="form.password").value = 'spwd'
2947        self.browser.getControl("Login").click()
2948        self.assertMatches(
2949            '...You logged in...', self.browser.contents)
2950        # Create payment ticket
2951        self.browser.open(self.payments_path)
2952        self.browser.open(self.payments_path + '/addop')
2953        self.browser.getControl(name="form.p_category").value = ['transcript']
2954        self.browser.getControl("Create ticket").click()
2955        ctrl = self.browser.getControl(name='val_id')
2956        value = ctrl.options[0]
2957        self.browser.getLink(value).click()
2958        self.assertMatches('...Amount Authorized...',
2959                           self.browser.contents)
2960        self.assertEqual(self.student['payments'][value].amount_auth, 4567.0)
2961        # Student is the payer of the payment ticket.
2962        payer = IPayer(self.student['payments'][value])
2963        self.assertEqual(payer.display_fullname, 'Anna Tester')
2964        self.assertEqual(payer.id, self.student_id)
2965        self.assertEqual(payer.faculty, 'fac1')
2966        self.assertEqual(payer.department, 'dep1')
2967        # We simulate the approval and fetch the pin
2968        self.assertEqual(len(self.app['accesscodes']['TSC-0']),0)
2969        self.browser.open(self.browser.url + '/fake_approve')
2970        self.assertMatches('...Payment approved...',
2971                          self.browser.contents)
2972        pin = self.app['accesscodes']['TSC-0'].keys()[0]
2973        parts = pin.split('-')[1:]
2974        tscseries, tscnumber = parts
2975        # Student can use the pin to send the transcript request
2976        self.browser.open(self.student_path)
2977        self.browser.getLink("Request transcript").click()
2978        self.browser.getControl(name="ac_series").value = tscseries
2979        self.browser.getControl(name="ac_number").value = tscnumber
2980        self.browser.getControl(name="comment").value = 'Comment line 1 \nComment line2'
2981        self.browser.getControl(name="address").value = 'Address line 1 \nAddress line2'
2982        self.browser.getControl("Submit").click()
2983        self.assertMatches('...Transcript processing has been started...',
2984                          self.browser.contents)
2985        self.assertEqual(self.student.state, 'transcript requested')
2986        self.assertMatches(
2987            '... UTC K1000000 wrote:\n\nComment line 1 \n'
2988            'Comment line2\n\nDispatch Address:\nAddress line 1 \n'
2989            'Address line2\n\n', self.student.transcript_comment)
2990        # The comment has been logged
2991        logfile = os.path.join(
2992            self.app['datacenter'].storage, 'logs', 'students.log')
2993        logcontent = open(logfile).read()
2994        self.assertTrue(
2995            'K1000000 - students.browser.StudentTranscriptRequestPage - '
2996            'K1000000 - comment: Comment line 1 <br>Comment line2\n'
2997            in logcontent)
2998
2999class StudentRequestPWTests(StudentsFullSetup):
3000    # Tests for student registration
3001
3002    layer = FunctionalLayer
3003
3004    def test_request_pw(self):
3005        # Student with wrong number can't be found.
3006        self.browser.open('http://localhost/app/requestpw')
3007        self.browser.getControl(name="form.firstname").value = 'Anna'
3008        self.browser.getControl(name="form.number").value = 'anynumber'
3009        self.browser.getControl(name="form.email").value = 'xx@yy.zz'
3010        self.browser.getControl("Send login credentials").click()
3011        self.assertTrue('No student record found.'
3012            in self.browser.contents)
3013        # Anonymous is not informed that firstname verification failed.
3014        # It seems that the record doesn't exist.
3015        self.browser.open('http://localhost/app/requestpw')
3016        self.browser.getControl(name="form.firstname").value = 'Johnny'
3017        self.browser.getControl(name="form.number").value = '123'
3018        self.browser.getControl(name="form.email").value = 'xx@yy.zz'
3019        self.browser.getControl("Send login credentials").click()
3020        self.assertTrue('No student record found.'
3021            in self.browser.contents)
3022        # Even with the correct firstname we can't register if a
3023        # password has been set and used.
3024        self.browser.getControl(name="form.firstname").value = 'Anna'
3025        self.browser.getControl(name="form.number").value = '123'
3026        self.browser.getControl("Send login credentials").click()
3027        self.assertTrue('Your password has already been set and used.'
3028            in self.browser.contents)
3029        self.browser.open('http://localhost/app/requestpw')
3030        self.app['students'][self.student_id].password = None
3031        # The firstname field, used for verification, is not case-sensitive.
3032        self.browser.getControl(name="form.firstname").value = 'aNNa'
3033        self.browser.getControl(name="form.number").value = '123'
3034        self.browser.getControl(name="form.email").value = 'new@yy.zz'
3035        self.browser.getControl("Send login credentials").click()
3036        # Yeah, we succeded ...
3037        self.assertTrue('Your password request was successful.'
3038            in self.browser.contents)
3039        # We can also use the matric_number instead.
3040        self.browser.open('http://localhost/app/requestpw')
3041        self.browser.getControl(name="form.firstname").value = 'aNNa'
3042        self.browser.getControl(name="form.number").value = '234'
3043        self.browser.getControl(name="form.email").value = 'new@yy.zz'
3044        self.browser.getControl("Send login credentials").click()
3045        self.assertTrue('Your password request was successful.'
3046            in self.browser.contents)
3047        # ... and  student can be found in the catalog via the email address
3048        cat = queryUtility(ICatalog, name='students_catalog')
3049        results = list(
3050            cat.searchResults(
3051            email=('new@yy.zz', 'new@yy.zz')))
3052        self.assertEqual(self.student,results[0])
3053        logfile = os.path.join(
3054            self.app['datacenter'].storage, 'logs', 'main.log')
3055        logcontent = open(logfile).read()
3056        self.assertTrue('zope.anybody - students.browser.StudentRequestPasswordPage - '
3057                        '234 (K1000000) - new@yy.zz' in logcontent)
3058        return
3059
3060    def test_student_locked_level_forms(self):
3061
3062        # Add two study levels, one current and one previous
3063        studylevel = createObject(u'waeup.StudentStudyLevel')
3064        studylevel.level = 100
3065        self.student['studycourse'].addStudentStudyLevel(
3066            self.certificate, studylevel)
3067        studylevel = createObject(u'waeup.StudentStudyLevel')
3068        studylevel.level = 200
3069        self.student['studycourse'].addStudentStudyLevel(
3070            self.certificate, studylevel)
3071        IWorkflowState(self.student).setState('school fee paid')
3072        self.student['studycourse'].current_level = 200
3073
3074        self.browser.open(self.login_path)
3075        self.browser.getControl(name="form.login").value = self.student_id
3076        self.browser.getControl(name="form.password").value = 'spwd'
3077        self.browser.getControl("Login").click()
3078
3079        self.browser.open(self.student_path + '/studycourse/200/edit')
3080        self.assertFalse('The requested form is locked' in self.browser.contents)
3081        self.browser.open(self.student_path + '/studycourse/100/edit')
3082        self.assertTrue('The requested form is locked' in self.browser.contents)
3083
3084        self.browser.open(self.student_path + '/studycourse/200/ctadd')
3085        self.assertFalse('The requested form is locked' in self.browser.contents)
3086        self.browser.open(self.student_path + '/studycourse/100/ctadd')
3087        self.assertTrue('The requested form is locked' in self.browser.contents)
3088
3089        IWorkflowState(self.student).setState('courses registered')
3090        self.browser.open(self.student_path + '/studycourse/200/edit')
3091        self.assertTrue('The requested form is locked' in self.browser.contents)
3092        self.browser.open(self.student_path + '/studycourse/200/ctadd')
3093        self.assertTrue('The requested form is locked' in self.browser.contents)
3094
3095
3096class PublicPagesTests(StudentsFullSetup):
3097    # Tests for simple webservices
3098
3099    layer = FunctionalLayer
3100
3101    def test_paymentrequest(self):
3102        payment = createObject('waeup.StudentOnlinePayment')
3103        payment.p_category = u'schoolfee'
3104        payment.p_session = self.student.current_session
3105        payment.p_item = u'My Certificate'
3106        payment.p_id = u'anyid'
3107        self.student['payments']['anykey'] = payment
3108        # Request information about unpaid payment ticket
3109        self.browser.open('http://localhost/app/paymentrequest?P_ID=anyid')
3110        self.assertEqual(self.browser.contents, '-1')
3111        # Request information about paid payment ticket
3112        payment.p_state = u'paid'
3113        notify(grok.ObjectModifiedEvent(payment))
3114        self.browser.open('http://localhost/app/paymentrequest?P_ID=anyid')
3115        self.assertEqual(self.browser.contents,
3116            'FULL_NAME=Anna Tester&FACULTY=fac1&DEPARTMENT=dep1'
3117            '&PAYMENT_ITEM=My Certificate&PAYMENT_CATEGORY=School Fee'
3118            '&ACADEMIC_SESSION=2004/2005&MATRIC_NUMBER=234&REG_NUMBER=123'
3119            '&FEE_AMOUNT=0.0')
3120        self.browser.open('http://localhost/app/paymentrequest?NONSENSE=nonsense')
3121        self.assertEqual(self.browser.contents, '-1')
3122        self.browser.open('http://localhost/app/paymentrequest?P_ID=nonsense')
3123        self.assertEqual(self.browser.contents, '-1')
3124
3125class StudentDataExportTests(StudentsFullSetup, FunctionalAsyncTestCase):
3126    # Tests for StudentsContainer class views and pages
3127
3128    layer = FunctionalLayer
3129
3130    def wait_for_export_job_completed(self):
3131        # helper function waiting until the current export job is completed
3132        manager = getUtility(IJobManager)
3133        job_id = self.app['datacenter'].running_exports[0][0]
3134        job = manager.get(job_id)
3135        wait_for_result(job)
3136        return job_id
3137
3138    def test_faculties_export(self):
3139        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
3140        facs_path = 'http://localhost/app/faculties'
3141        self.browser.open(facs_path)
3142        self.browser.getLink("Export student data").click()
3143        self.browser.getControl("Configure new export").click()
3144        self.browser.getControl(name="exporter").value = ['bursary']
3145        self.browser.getControl(name="session").value = ['2004']
3146        self.browser.getControl(name="level").value = ['100']
3147        self.browser.getControl(name="mode").value = ['ug_ft']
3148        self.browser.getControl("Create CSV file").click()
3149
3150        # When the job is finished and we reload the page...
3151        job_id = self.wait_for_export_job_completed()
3152        self.browser.open(facs_path + '/exports')
3153        # ... the csv file can be downloaded ...
3154        self.browser.getLink("Download").click()
3155        self.assertEqual(self.browser.headers['content-type'],
3156            'text/csv; charset=UTF-8')
3157        self.assertTrue(
3158            'filename="WAeUP.Kofa_bursary_%s.csv' % job_id in
3159            self.browser.headers['content-disposition'])
3160        self.assertEqual(len(self.app['datacenter'].running_exports), 1)
3161        job_id = self.app['datacenter'].running_exports[0][0]
3162        # ... and discarded
3163        self.browser.open(facs_path + '/exports')
3164        self.browser.getControl("Discard").click()
3165        self.assertEqual(len(self.app['datacenter'].running_exports), 0)
3166        # Creation, downloading and discarding is logged
3167        logfile = os.path.join(
3168            self.app['datacenter'].storage, 'logs', 'datacenter.log')
3169        logcontent = open(logfile).read()
3170        self.assertTrue(
3171            'zope.mgr - students.browser.FacultiesExportJobContainerJobConfig '
3172            '- exported: bursary (2004, 100, ug_ft, None, None), job_id=%s'
3173            % job_id in logcontent
3174            )
3175        self.assertTrue(
3176            'zope.mgr - students.browser.ExportJobContainerDownload '
3177            '- downloaded: WAeUP.Kofa_bursary_%s.csv, job_id=%s'
3178            % (job_id, job_id) in logcontent
3179            )
3180        self.assertTrue(
3181            'zope.mgr - students.browser.ExportJobContainerOverview '
3182            '- discarded: job_id=%s' % job_id in logcontent
3183            )
3184
3185    def test_department_export(self):
3186        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
3187        dep1_path = 'http://localhost/app/faculties/fac1/dep1'
3188        self.browser.open(dep1_path)
3189        self.browser.getLink("Export student data").click()
3190        self.browser.getControl("Configure new export").click()
3191        self.browser.getControl(name="exporter").value = ['students']
3192        self.browser.getControl(name="session").value = ['2004']
3193        self.browser.getControl(name="level").value = ['100']
3194        self.browser.getControl(name="mode").value = ['ug_ft']
3195        self.browser.getControl("Create CSV file").click()
3196
3197        # When the job is finished and we reload the page...
3198        job_id = self.wait_for_export_job_completed()
3199        self.browser.open(dep1_path + '/exports')
3200        # ... the csv file can be downloaded ...
3201        self.browser.getLink("Download").click()
3202        self.assertEqual(self.browser.headers['content-type'],
3203            'text/csv; charset=UTF-8')
3204        self.assertTrue(
3205            'filename="WAeUP.Kofa_students_%s.csv' % job_id in
3206            self.browser.headers['content-disposition'])
3207        self.assertEqual(len(self.app['datacenter'].running_exports), 1)
3208        job_id = self.app['datacenter'].running_exports[0][0]
3209        # ... and discarded
3210        self.browser.open(dep1_path + '/exports')
3211        self.browser.getControl("Discard").click()
3212        self.assertEqual(len(self.app['datacenter'].running_exports), 0)
3213        # Creation, downloading and discarding is logged
3214        logfile = os.path.join(
3215            self.app['datacenter'].storage, 'logs', 'datacenter.log')
3216        logcontent = open(logfile).read()
3217        self.assertTrue(
3218            'zope.mgr - students.browser.DepartmentExportJobContainerJobConfig '
3219            '- exported: students (2004, 100, ug_ft, dep1, None), job_id=%s'
3220            % job_id in logcontent
3221            )
3222        self.assertTrue(
3223            'zope.mgr - students.browser.ExportJobContainerDownload '
3224            '- downloaded: WAeUP.Kofa_students_%s.csv, job_id=%s'
3225            % (job_id, job_id) in logcontent
3226            )
3227        self.assertTrue(
3228            'zope.mgr - students.browser.ExportJobContainerOverview '
3229            '- discarded: job_id=%s' % job_id in logcontent
3230            )
3231
3232    def test_certificate_export(self):
3233        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
3234        cert1_path = 'http://localhost/app/faculties/fac1/dep1/certificates/CERT1'
3235        self.browser.open(cert1_path)
3236        self.browser.getLink("Export student data").click()
3237        self.browser.getControl("Configure new export").click()
3238        self.browser.getControl(name="exporter").value = ['students']
3239        self.browser.getControl(name="session").value = ['2004']
3240        self.browser.getControl(name="level").value = ['100']
3241        self.browser.getControl("Create CSV file").click()
3242
3243        # When the job is finished and we reload the page...
3244        job_id = self.wait_for_export_job_completed()
3245        self.browser.open(cert1_path + '/exports')
3246        # ... the csv file can be downloaded ...
3247        self.browser.getLink("Download").click()
3248        self.assertEqual(self.browser.headers['content-type'],
3249            'text/csv; charset=UTF-8')
3250        self.assertTrue(
3251            'filename="WAeUP.Kofa_students_%s.csv' % job_id in
3252            self.browser.headers['content-disposition'])
3253        self.assertEqual(len(self.app['datacenter'].running_exports), 1)
3254        job_id = self.app['datacenter'].running_exports[0][0]
3255        # ... and discarded
3256        self.browser.open(cert1_path + '/exports')
3257        self.browser.getControl("Discard").click()
3258        self.assertEqual(len(self.app['datacenter'].running_exports), 0)
3259        # Creation, downloading and discarding is logged
3260        logfile = os.path.join(
3261            self.app['datacenter'].storage, 'logs', 'datacenter.log')
3262        logcontent = open(logfile).read()
3263        self.assertTrue(
3264            'zope.mgr - students.browser.CertificateExportJobContainerJobConfig '
3265            '- exported: students (2004, 100, None, None, CERT1), job_id=%s'
3266            % job_id in logcontent
3267            )
3268        self.assertTrue(
3269            'zope.mgr - students.browser.ExportJobContainerDownload '
3270            '- downloaded: WAeUP.Kofa_students_%s.csv, job_id=%s'
3271            % (job_id, job_id) in logcontent
3272            )
3273        self.assertTrue(
3274            'zope.mgr - students.browser.ExportJobContainerOverview '
3275            '- discarded: job_id=%s' % job_id in logcontent
3276            )
3277
3278    def test_course_export_students(self):
3279        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
3280        course1_path = 'http://localhost/app/faculties/fac1/dep1/courses/COURSE1'
3281        self.browser.open(course1_path)
3282        self.browser.getLink("Export student data").click()
3283        self.browser.getControl("Configure new export").click()
3284        self.browser.getControl(name="exporter").value = ['students']
3285        self.browser.getControl(name="session").value = ['2004']
3286        self.browser.getControl(name="level").value = ['100']
3287        self.browser.getControl("Create CSV file").click()
3288
3289        # When the job is finished and we reload the page...
3290        job_id = self.wait_for_export_job_completed()
3291        self.browser.open(course1_path + '/exports')
3292        # ... the csv file can be downloaded ...
3293        self.browser.getLink("Download").click()
3294        self.assertEqual(self.browser.headers['content-type'],
3295            'text/csv; charset=UTF-8')
3296        self.assertTrue(
3297            'filename="WAeUP.Kofa_students_%s.csv' % job_id in
3298            self.browser.headers['content-disposition'])
3299        self.assertEqual(len(self.app['datacenter'].running_exports), 1)
3300        job_id = self.app['datacenter'].running_exports[0][0]
3301        # ... and discarded
3302        self.browser.open(course1_path + '/exports')
3303        self.browser.getControl("Discard").click()
3304        self.assertEqual(len(self.app['datacenter'].running_exports), 0)
3305        # Creation, downloading and discarding is logged
3306        logfile = os.path.join(
3307            self.app['datacenter'].storage, 'logs', 'datacenter.log')
3308        logcontent = open(logfile).read()
3309        self.assertTrue(
3310            'zope.mgr - students.browser.CourseExportJobContainerJobConfig '
3311            '- exported: students (2004, 100, COURSE1), job_id=%s'
3312            % job_id in logcontent
3313            )
3314        self.assertTrue(
3315            'zope.mgr - students.browser.ExportJobContainerDownload '
3316            '- downloaded: WAeUP.Kofa_students_%s.csv, job_id=%s'
3317            % (job_id, job_id) in logcontent
3318            )
3319        self.assertTrue(
3320            'zope.mgr - students.browser.ExportJobContainerOverview '
3321            '- discarded: job_id=%s' % job_id in logcontent
3322            )
3323
3324    def test_course_export_coursetickets(self):
3325        # We add study level 100 to the student's studycourse
3326        studylevel = StudentStudyLevel()
3327        studylevel.level = 100
3328        studylevel.level_session = 2004
3329        self.student['studycourse'].addStudentStudyLevel(
3330            self.certificate,studylevel)
3331        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
3332        course1_path = 'http://localhost/app/faculties/fac1/dep1/courses/COURSE1'
3333        self.browser.open(course1_path)
3334        self.browser.getLink("Export student data").click()
3335        self.browser.getControl("Configure new export").click()
3336        self.browser.getControl(name="exporter").value = ['coursetickets']
3337        self.browser.getControl(name="session").value = ['2004']
3338        self.browser.getControl(name="level").value = ['100']
3339        self.browser.getControl("Create CSV file").click()
3340        # When the job is finished and we reload the page...
3341        job_id = self.wait_for_export_job_completed()
3342        self.browser.open(course1_path + '/exports')
3343        # ... the csv file can be downloaded ...
3344        self.browser.getLink("Download").click()
3345        self.assertEqual(self.browser.headers['content-type'],
3346            'text/csv; charset=UTF-8')
3347        self.assertTrue(
3348            'filename="WAeUP.Kofa_coursetickets_%s.csv' % job_id in
3349            self.browser.headers['content-disposition'])
3350        # ... and contains the course ticket COURSE1
3351        self.assertEqual(self.browser.contents,
3352            'automatic,carry_over,code,credits,dcode,fcode,level,'
3353            'level_session,mandatory,passmark,score,semester,title,'
3354            'student_id,certcode\r\n1,0,COURSE1,10,dep1,fac1,100,2004,1,40,,1,'
3355            'Unnamed Course,K1000000,CERT1\r\n')
3356
3357        self.assertEqual(len(self.app['datacenter'].running_exports), 1)
3358        job_id = self.app['datacenter'].running_exports[0][0]
3359        # Thew job can be discarded
3360        self.browser.open(course1_path + '/exports')
3361        self.browser.getControl("Discard").click()
3362        self.assertEqual(len(self.app['datacenter'].running_exports), 0)
3363        # Creation, downloading and discarding is logged
3364        logfile = os.path.join(
3365            self.app['datacenter'].storage, 'logs', 'datacenter.log')
3366        logcontent = open(logfile).read()
3367        self.assertTrue(
3368            'zope.mgr - students.browser.CourseExportJobContainerJobConfig '
3369            '- exported: coursetickets (2004, 100, COURSE1), job_id=%s'
3370            % job_id in logcontent
3371            )
3372        self.assertTrue(
3373            'zope.mgr - students.browser.ExportJobContainerDownload '
3374            '- downloaded: WAeUP.Kofa_coursetickets_%s.csv, job_id=%s'
3375            % (job_id, job_id) in logcontent
3376            )
3377        self.assertTrue(
3378            'zope.mgr - students.browser.ExportJobContainerOverview '
3379            '- discarded: job_id=%s' % job_id in logcontent
3380            )
3381
3382    def test_export_departmet_officers(self):
3383        # Create department officer
3384        self.app['users'].addUser('mrdepartment', 'mrdepartmentsecret')
3385        self.app['users']['mrdepartment'].email = 'mrdepartment@foo.ng'
3386        self.app['users']['mrdepartment'].title = 'Carlo Pitter'
3387        # Assign local role
3388        department = self.app['faculties']['fac1']['dep1']
3389        prmlocal = IPrincipalRoleManager(department)
3390        prmlocal.assignRoleToPrincipal('waeup.local.DepartmentOfficer', 'mrdepartment')
3391        # Login as department officer
3392        self.browser.open(self.login_path)
3393        self.browser.getControl(name="form.login").value = 'mrdepartment'
3394        self.browser.getControl(name="form.password").value = 'mrdepartmentsecret'
3395        self.browser.getControl("Login").click()
3396        self.assertMatches('...You logged in...', self.browser.contents)
3397        self.browser.open("http://localhost/app/faculties/fac1/dep1")
3398        self.browser.getLink("Export student data").click()
3399        self.browser.getControl("Configure new export").click()
3400        # Only the paymentsoverview exporter is available for department officers
3401        self.assertFalse('<option value="students">' in self.browser.contents)
3402        self.assertTrue(
3403            '<option value="paymentsoverview">' in self.browser.contents)
3404        self.browser.getControl(name="exporter").value = ['paymentsoverview']
3405        self.browser.getControl(name="session").value = ['2004']
3406        self.browser.getControl(name="level").value = ['100']
3407        self.browser.getControl("Create CSV file").click()
3408        self.assertTrue('Export started' in self.browser.contents)
3409        # Thew job can be discarded
3410        self.assertEqual(len(self.app['datacenter'].running_exports), 1)
3411        #job_id = self.app['datacenter'].running_exports[0][0]
3412        job_id = self.wait_for_export_job_completed()
3413        self.browser.open("http://localhost/app/faculties/fac1/dep1/exports")
3414        self.browser.getControl("Discard").click()
3415        self.assertEqual(len(self.app['datacenter'].running_exports), 0)
3416
3417    def test_export_bursary_officers(self):
3418        # Create bursary officer
3419        self.app['users'].addUser('mrbursary', 'mrbursarysecret')
3420        self.app['users']['mrbursary'].email = 'mrbursary@foo.ng'
3421        self.app['users']['mrbursary'].title = 'Carlo Pitter'
3422        prmglobal = IPrincipalRoleManager(self.app)
3423        prmglobal.assignRoleToPrincipal('waeup.BursaryOfficer', 'mrbursary')
3424        # Login as bursary officer
3425        self.browser.open(self.login_path)
3426        self.browser.getControl(name="form.login").value = 'mrbursary'
3427        self.browser.getControl(name="form.password").value = 'mrbursarysecret'
3428        self.browser.getControl("Login").click()
3429        self.assertMatches('...You logged in...', self.browser.contents)
3430        self.browser.getLink("Academics").click()
3431        self.browser.getLink("Export student data").click()
3432        self.browser.getControl("Configure new export").click()
3433        # Only the bursary exporter is available for bursary officers
3434        # not only at facultiescontainer level ...
3435        self.assertFalse('<option value="students">' in self.browser.contents)
3436        self.assertTrue('<option value="bursary">' in self.browser.contents)
3437        self.browser.getControl(name="exporter").value = ['bursary']
3438        self.browser.getControl(name="session").value = ['2004']
3439        self.browser.getControl(name="level").value = ['100']
3440        self.browser.getControl("Create CSV file").click()
3441        self.assertTrue('Export started' in self.browser.contents)
3442        # ... but also at other levels
3443        self.browser.open('http://localhost/app/faculties/fac1/dep1')
3444        self.browser.getLink("Export student data").click()
3445        self.browser.getControl("Configure new export").click()
3446        self.assertFalse('<option value="students">' in self.browser.contents)
3447        self.assertTrue('<option value="bursary">' in self.browser.contents)
3448        # Thew job can be discarded
3449        self.assertEqual(len(self.app['datacenter'].running_exports), 1)
3450        #job_id = self.app['datacenter'].running_exports[0][0]
3451        job_id = self.wait_for_export_job_completed()
3452        self.browser.open('http://localhost/app/faculties/exports')
3453        self.browser.getControl("Discard").click()
3454        self.assertEqual(len(self.app['datacenter'].running_exports), 0)
Note: See TracBrowser for help on using the repository browser.