source: main/kofacustom.nigeria/trunk/src/kofacustom/nigeria/students/tests/test_browser.py @ 13671

Last change on this file since 13671 was 13634, checked in by Henrik Bettermann, 9 years ago

Rename bursary.
  • Property svn:keywords set to Id
File size: 21.5 KB
Line 
1## $Id: test_browser.py 13634 2016-01-18 17:22:05Z 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##
18import os
19import shutil
20import tempfile
21from time import time
22from datetime import datetime, timedelta
23from StringIO import StringIO
24from hurry.workflow.interfaces import IWorkflowState, IWorkflowInfo
25from zope.component.hooks import setSite, clearSite
26from zope.component import getUtility, createObject
27from zope.interface import verify
28from zope.securitypolicy.interfaces import IPrincipalRoleManager
29from waeup.kofa.app import University
30from waeup.kofa.students.tests.test_browser import (
31    StudentsFullSetup, SAMPLE_IMAGE)
32from waeup.kofa.testing import FunctionalTestCase
33from waeup.kofa.interfaces import (
34    IExtFileStore, IFileStoreNameChooser)
35from waeup.kofa.schoolgrades import ResultEntry
36from waeup.kofa.students.batching import StudentProcessor
37from waeup.kofa.students.interfaces import IStudentsUtils
38from waeup.kofa.browser.tests.test_pdf import samples_dir
39from kofacustom.nigeria.students.batching import NigeriaStudentProcessor
40from kofacustom.nigeria.testing import FunctionalLayer
41from kofacustom.nigeria.utils.utils import NigeriaKofaUtils
42from kofacustom.nigeria.students.interfaces import (
43    INigeriaStudentStudyCourse, INigeriaStudent,
44    INigeriaStudentStudyLevel, INigeriaCourseTicket)
45
46
47STUDENT_SAMPLE_DATA = open(
48    os.path.join(os.path.dirname(__file__), 'sample_student_data.csv'),
49    'rb').read()
50
51STUDENT_HEADER_FIELDS = STUDENT_SAMPLE_DATA.split(
52    '\n')[0].split(',')
53
54class StudentProcessorTest(FunctionalTestCase):
55    """Perform some batching tests.
56    """
57
58    layer = FunctionalLayer
59
60    def setUp(self):
61        super(StudentProcessorTest, self).setUp()
62        # Setup a sample site for each test
63        app = University()
64        self.dc_root = tempfile.mkdtemp()
65        app['datacenter'].setStoragePath(self.dc_root)
66
67        # Prepopulate the ZODB...
68        self.getRootFolder()['app'] = app
69        # we add the site immediately after creation to the
70        # ZODB. Catalogs and other local utilities are not setup
71        # before that step.
72        self.app = self.getRootFolder()['app']
73        # Set site here. Some of the following setup code might need
74        # to access grok.getSite() and should get our new app then
75        setSite(app)
76
77        self.processor_base = StudentProcessor()
78        self.processor = NigeriaStudentProcessor()
79        self.workdir = tempfile.mkdtemp()
80        self.csv_file = os.path.join(self.workdir, 'sample_student_data.csv')
81        open(self.csv_file, 'wb').write(STUDENT_SAMPLE_DATA)
82
83    def tearDown(self):
84        super(StudentProcessorTest, self).tearDown()
85        shutil.rmtree(self.workdir)
86        shutil.rmtree(self.dc_root)
87        clearSite()
88        return
89
90    def test_import(self):
91        num, num_warns, fin_file, fail_file = self.processor.doImport(
92            self.csv_file, STUDENT_HEADER_FIELDS)
93        #print open(fail_file).read()
94        self.assertEqual(num_warns,0)
95        assert len(self.app['students'].keys()) == 3
96        # Also fst_sit_results have been properly imported (tested only here!)
97        self.assertEqual(
98            self.app['students']['K1000000'].fst_sit_results[0].__dict__,
99            {'grade': 'A1', 'subject': 'visual_art'})
100        self.assertEqual(
101            self.app['students']['K1000000'].fst_sit_results[1].__dict__,
102            {'grade': 'C6', 'subject': 'applied_electricity'})
103        shutil.rmtree(os.path.dirname(fin_file))
104
105
106class StudentUITests(StudentsFullSetup):
107    """Tests for customized student class views and pages
108    """
109
110    layer = FunctionalLayer
111
112    def setUp(self):
113        super(StudentUITests, self).setUp()
114
115    def test_classes(self):
116        # Let's see if objects created in the customized
117        # portal really implement the customized interfaces
118        verify.verifyObject(INigeriaStudent, self.student)
119        verify.verifyObject(
120            INigeriaStudentStudyCourse, self.student['studycourse'])
121        studylevel = createObject(u'waeup.StudentStudyLevel')
122        verify.verifyObject(INigeriaStudentStudyLevel, studylevel)
123        ticket = createObject(u'waeup.CourseTicket')
124        verify.verifyObject(INigeriaCourseTicket, ticket)
125        IWorkflowState(self.student).setState('returning')
126        # Let's see if next_session_allowed works as expected
127        # A, ug_ft, 100
128        self.assertTrue(self.student['studycourse'].next_session_allowed)
129        # Zero, ug_ft, 100
130        self.student['studycourse'].current_verdict = '0' # Zero!
131        self.assertTrue(self.student['studycourse'].next_session_allowed)
132        # Zero, ug_ft, 200
133        self.student['studycourse'].current_level = 200
134        self.assertFalse(self.student['studycourse'].next_session_allowed)
135        # Zero, de_ft, 200
136        self.student['studycourse'].certificate.study_mode = 'de_ft'
137        self.assertTrue(self.student['studycourse'].next_session_allowed)
138        # Zero, ph_ft, 300
139        self.student['studycourse'].certificate.study_mode = 'ph_ft'
140        self.student['studycourse'].current_level = 300
141        self.assertTrue(self.student['studycourse'].next_session_allowed)
142        # Zero, ph_ft, 400
143        self.student['studycourse'].current_level = 400
144        self.assertFalse(self.student['studycourse'].next_session_allowed)
145
146        # Now we convert the certificate into a postgraduate certificate
147        IWorkflowState(self.student).setState('school fee paid')
148        self.certificate.study_mode = 'pg_ft'
149        # ... and voila next session registration is allowed
150        self.assertTrue(self.student['studycourse'].next_session_allowed)
151
152    def test_manage_access(self):
153        self.student.nationality = u'DE'
154        # Managers can access the pages of students
155        # and can perform actions
156        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
157        # The student created in the base package is an ug student
158        self.browser.open(self.student_path)
159        self.browser.getLink("Clearance Data").click()
160        self.assertEqual(self.browser.headers['Status'], '200 Ok')
161        self.assertEqual(self.browser.url, self.clearance_path)
162        self.browser.getLink("Manage").click()
163        self.assertEqual(self.browser.headers['Status'], '200 Ok')
164        self.assertEqual(self.browser.url, self.manage_clearance_path)
165        self.browser.getControl(name="form.date_of_birth").value = '09/10/1961'
166        self.browser.getControl("Save").click()
167        self.assertMatches('...Form has been saved...',
168                           self.browser.contents)
169        self.assertMatches('...First Sitting Record...',
170                           self.browser.contents)
171        # Managers can open clearance slip of ug students
172        self.browser.open(self.student_path + '/clearance_slip.pdf')
173        self.assertEqual(self.browser.headers['Status'], '200 Ok')
174        self.assertEqual(self.browser.headers['Content-Type'], 'application/pdf')
175        # There is no pg field in the clearance form
176        self.assertFalse('Second Higher Education Record'
177            in self.browser.contents)
178        # Now we change the study mode ...
179        self.certificate.study_mode = 'pg_ft'
180        self.browser.open(self.clearance_path)
181        # ... and additional pg clearance fields appear
182        self.assertMatches('...Second Higher Education Record...',
183                           self.browser.contents)
184        # But also fields from the ug form are displayed
185        self.assertMatches('...First Sitting Record...',
186                           self.browser.contents)
187        # Managers can open clearance slip of pg students
188        self.browser.open(self.student_path + '/clearance_slip.pdf')
189        self.assertEqual(self.browser.headers['Status'], '200 Ok')
190        self.assertEqual(self.browser.headers['Content-Type'], 'application/pdf')
191        # Managers can edit personal data. No fields are required.
192        self.browser.open(self.manage_personal_path)
193        self.browser.getControl("Save").click()
194        self.assertMatches('...Form has been saved...',
195                           self.browser.contents)
196
197    def test_logging(self):
198        self.student.nationality = u'DE'
199        valid_subj = NigeriaKofaUtils().EXAM_SUBJECTS_DICT.keys()[0]
200        valid_grade = NigeriaKofaUtils().EXAM_GRADES[0][0]
201        result_entry = ResultEntry(valid_subj, valid_grade)
202        self.student.fst_sit_results = [result_entry,]
203        # Managers can access the pages of students
204        # and can perform actions
205        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
206        # The student created in the base package is an ug student
207        self.browser.open(self.student_path)
208        self.browser.getLink("Clearance Data").click()
209        self.browser.getLink("Manage").click()
210        self.browser.getControl("Save").click()
211        logfile = os.path.join(
212            self.app['datacenter'].storage, 'logs', 'students.log')
213        logcontent = open(logfile).read()
214        self.assertFalse('saved: fst_sit_results' in logcontent)
215
216    def test_student_access(self):
217        # Students can edit clearance data
218        IWorkflowState(self.student).setState('cleared')
219        self.browser.open(self.login_path)
220        self.browser.getControl(name="form.login").value = self.student_id
221        self.browser.getControl(name="form.password").value = 'spwd'
222        self.browser.getControl("Login").click()
223        # Even in state admitted students can't change the portait if
224        # application slip exists.
225        IWorkflowState(self.student).setState('admitted')
226        self.browser.open(self.student_path)
227        self.assertTrue('Change portrait' in self.browser.contents)
228        file_store = getUtility(IExtFileStore)
229        applicant_slip = 'My application slip'
230        file_id = IFileStoreNameChooser(self.student).chooseName(
231            attr="application_slip.pdf")
232        file_store.createFile(file_id, StringIO(applicant_slip))
233        self.browser.open(self.student_path)
234        self.assertFalse('Change portrait' in self.browser.contents)
235        self.browser.open(self.student_path + '/change_portrait')
236        self.assertTrue('The requested form is locked' in self.browser.contents)
237
238        # Student can view and edit clearance data if clearance has started ...
239        IWorkflowInfo(self.student).fireTransition('start_clearance')
240        self.student.officer_comment = u'Fill properly'
241        self.browser.getLink("Clearance Data").click()
242        self.assertTrue("Officer's Comment" in self.browser.contents)
243        # Students can't edit officer's comment
244        self.browser.getLink("Edit").click()
245        self.assertFalse("Officer's Comment" in self.browser.contents)
246        self.assertTrue('Save' in self.browser.contents)
247        # ... and request clearance if nationality field has been filled.
248        self.browser.getControl("Save and request clearance").click()
249        self.assertMatches('...Required input is missing...',
250                           self.browser.contents)
251        self.student.nationality = u'DE'
252        self.browser.open(self.edit_clearance_path)
253        self.browser.getControl("Save and request clearance").click()
254        self.assertMatches('...Clearance has been requested...',
255                           self.browser.contents)
256
257        # Students can edit personal data. Some fields are required.
258        self.browser.open(self.personal_path)
259        self.assertTrue('Updated' in self.browser.contents)
260        self.browser.getLink("Edit").click()
261        self.assertEqual(self.browser.headers['Status'], '200 Ok')
262        self.assertEqual(self.browser.url, self.edit_personal_path)
263        self.browser.getControl("Save").click()
264        self.assertMatches('...Required input is missing...',
265                           self.browser.contents)
266        self.browser.getControl(name="form.perm_address").value = 'My address!'
267        self.browser.getControl("Save").click()
268        self.assertMatches('...Required input is missing...',
269                           self.browser.contents)
270        # Ok, let's give up and fill the rest.
271        self.browser.getControl(name="form.next_kin_name").value = 'My Mutti'
272        self.browser.getControl(name="form.next_kin_relation").value = 'mother'
273        self.browser.getControl(name="form.next_kin_address").value = 'sweet home'
274        self.browser.getControl(name="form.next_kin_phone.country").value = ['+234']
275        self.browser.getControl(name="form.next_kin_phone.ext").value = '45678'
276        self.browser.getControl("Save").click()
277        self.assertMatches('...Form has been saved...',
278                           self.browser.contents)
279
280    def test_manage_upload_file(self):
281        # Managers can upload a file via the StudentClearanceManageFormPage
282        # The image is stored even if form has errors
283        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
284        self.browser.open(self.manage_clearance_path)
285        # Managers can add and delete a file
286        self.browser.open(self.manage_clearance_path)
287        image = open(SAMPLE_IMAGE, 'rb')
288        ctrl = self.browser.getControl(name='birthcertificateupload')
289        file_ctrl = ctrl.mech_control
290        file_ctrl.add_file(image, filename='my_acceptance_letter.jpg')
291        self.browser.getControl(
292            name='upload_acceptanceletterupload').click()
293        # Uups, we used the wrong 'Browse' field
294        self.assertFalse(
295            '<a target="image" href="acc_let">'
296            in self.browser.contents)
297        ctrl = self.browser.getControl(name='acceptanceletterupload')
298        file_ctrl = ctrl.mech_control
299        image.seek(0)
300        file_ctrl.add_file(image, filename='my_acceptance_letter.jpg')
301        self.browser.getControl(
302            name='upload_acceptanceletterupload').click()
303        self.assertTrue(
304            'http://localhost/app/students/K1000000/acc_let'
305            in self.browser.contents)
306        self.browser.getControl(
307            name='delete_acceptanceletterupload').click()
308        self.assertTrue(
309            'acc_let deleted'
310            in self.browser.contents)
311
312    def test_student_expired_personal_data(self):
313        # Login
314        IWorkflowState(self.student).setState('school fee paid')
315        delta = timedelta(days=180)
316        self.student.personal_updated = datetime.utcnow() - delta
317        self.browser.open(self.login_path)
318        self.browser.getControl(name="form.login").value = self.student_id
319        self.browser.getControl(name="form.password").value = 'spwd'
320        self.browser.getControl("Login").click()
321        self.assertEqual(self.browser.url, self.student_path)
322        self.assertTrue(
323            'You logged in' in self.browser.contents)
324        # Students don't see personal_updated field in edit form
325        self.browser.open(self.edit_personal_path)
326        self.assertFalse('Updated' in self.browser.contents)
327        self.browser.open(self.personal_path)
328        self.assertTrue('Updated' in self.browser.contents)
329        self.browser.getLink("Logout").click()
330        delta = timedelta(days=181)
331        self.student.personal_updated = datetime.utcnow() - delta
332        self.browser.open(self.login_path)
333        self.browser.getControl(name="form.login").value = self.student_id
334        self.browser.getControl(name="form.password").value = 'spwd'
335        self.browser.getControl("Login").click()
336        self.assertEqual(self.browser.url, self.edit_personal_path)
337        self.assertTrue(
338            'Your personal data record is outdated.' in self.browser.contents)
339
340    def test_lga_nationality(self):
341        self.student.nationality = u'DE'
342        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
343        self.browser.open(self.manage_clearance_path)
344        self.browser.getControl(name="form.lga").value = ['abia_aba_north']
345        self.browser.getControl("Save").click()
346        self.assertTrue(
347            'Nationalty and LGA are contradictory.' in self.browser.contents)
348        self.browser.getControl(name="form.nationality").value = ['NG']
349        self.browser.getControl("Save").click()
350        self.assertTrue(
351            'Form has been saved' in self.browser.contents)
352
353    def test_financial_clearance(self):
354        self.app['users'].addUser('mrbursary', 'mrbursarysecret')
355        self.app['users']['mrbursary'].email = 'mrbursary@foo.ng'
356        self.app['users']['mrbursary'].title = u'Carlo Pitter'
357        # Clearance officers needs to get
358        # the StudentsOfficer site role
359        prmglobal = IPrincipalRoleManager(self.app)
360        prmglobal.assignRoleToPrincipal('waeup.StudentsOfficer', 'mrbursary')
361        # Assign BursaryOfficer role
362        prmglobal.assignRoleToPrincipal('waeup.BursaryOfficer', 'mrbursary')
363        # Login
364        self.browser.open(self.login_path)
365        self.browser.getControl(name="form.login").value = 'mrbursary'
366        self.browser.getControl(name="form.password").value = 'mrbursarysecret'
367        self.browser.getControl("Login").click()
368        # BO can see his roles
369        self.browser.getLink("My Roles").click()
370        self.assertMatches(
371            '...<div>Bursary Officer</div>...',
372            self.browser.contents)
373        # BO can view student record
374        self.browser.open(self.student_path)
375        prmglobal.assignRoleToPrincipal('waeup.BursaryOfficer', 'mrbursary')
376        self.browser.open(self.student_path)
377        # BO can see clearance button ...
378        self.assertTrue(
379            'Clear student financially' in self.browser.contents)
380        # ... but not withdraw button
381        self.assertFalse(
382            'Withdraw financial clearance' in self.browser.contents)
383        # BO can clear student
384        self.browser.getLink("Clear student financially").click()
385        self.assertTrue(
386            'Student has been financially cleared' in self.browser.contents)
387        # Name of BO and date have been stored
388        self.assertEqual(self.student.financially_cleared_by, 'Carlo Pitter')
389        self.assertMatches(
390            '<YYYY-MM-DD hh:mm:ss>',
391            self.student.financial_clearance_date.strftime(
392                "%Y-%m-%d %H:%M:%S"))
393        # BO can't see clearance button ...
394        self.assertFalse(
395            'Clear student financially' in self.browser.contents)
396        # ... but withdraw button and can withdraw clearance
397        self.browser.getLink("Withdraw financial clearance").click()
398        self.assertTrue(
399            'Financial clearance withdrawn' in self.browser.contents)
400        # Name of BO and date have been deleted
401        self.assertEqual(self.student.financially_cleared_by, None)
402        self.assertEqual(self.student.financial_clearance_date, None)
403        # Clearance is logged
404        logfile = os.path.join(
405            self.app['datacenter'].storage, 'logs', 'students.log')
406        logcontent = open(logfile).read()
407        self.assertTrue(
408            'mrbursary - kofacustom.nigeria.students.browser.ClearStudentFinancially'
409            ' - K1000000 - financially cleared' in logcontent)
410        self.assertTrue(
411            'mrbursary - kofacustom.nigeria.students.browser.WithdrawFinancialClearance'
412            ' - K1000000 - financial clearance withdrawn' in logcontent)
413        # Clearance is also stored in the history
414        self.browser.open(self.history_path)
415        self.assertMatches(
416            '...2016-01-16 15:50:48 WAT - Financially cleared by Carlo Pitter...',
417            self.browser.contents)
418        self.assertMatches(
419            '...2016-01-16 15:50:48 WAT - Financial clearance withdrawn by Carlo Pitter...',
420            self.browser.contents)
421
422    def test_bursary_pdf_slip(self):
423        payment1 = createObject(u'waeup.StudentOnlinePayment')
424        timestamp = ("%d" % int(time()*10000))[1:]
425        payment1.p_id = "LSCNEW-2-4153206270" # the longest possible p_id
426        payment1.p_category = 'schoolfee'
427        payment1.p_item = u'My School Fee'
428        payment1.p_session = 2015
429        payment1.p_level = 100
430        payment1.p_current = True
431        payment1.amount_auth = 23456.9
432        payment1.approve()
433        payment2 = createObject(u'waeup.StudentOnlinePayment')
434        timestamp = ("%d" % int(time()*10000))[1:]
435        payment2.p_id = "p%s" % timestamp
436        payment2.p_category = 'clearance'
437        payment2.p_item = u'My Clearance Fee'
438        payment2.p_session = 2015
439        payment2.p_level = 100
440        payment2.p_current = True
441        payment2.amount_auth = 5678.6
442        payment2.approve()
443        self.student['payments'][payment1.p_id] = payment1
444        self.student['payments'][payment2.p_id] = payment2
445        self.browser.addHeader('Authorization', 'Basic mgr:mgrpw')
446        self.browser.open(self.student_path + '/clear_financially')
447        self.browser.getLink("Download financial clearance slip").click()
448        self.assertEqual(self.browser.headers['Status'], '200 Ok')
449        self.assertEqual(self.browser.headers['Content-Type'],
450                         'application/pdf')
451        path = os.path.join(samples_dir(), 'financial_clearance_slip.pdf')
452        open(path, 'wb').write(self.browser.contents)
453        print "Sample PDF financial_clearance_slip.pdf written to %s" % path
454        return
Note: See TracBrowser for help on using the repository browser.