Index: /main/waeup.kofa/trunk/src/waeup/kofa/students/tests/test_webservices.py
===================================================================
--- /main/waeup.kofa/trunk/src/waeup/kofa/students/tests/test_webservices.py	(revision 16390)
+++ /main/waeup.kofa/trunk/src/waeup/kofa/students/tests/test_webservices.py	(revision 16391)
@@ -213,4 +213,47 @@
 <value><string>my adviser</string></value>
 <value><double>12.12</double></value>
+</data></array></value>
+</data></array></value>
+</param>
+</params>
+</methodResponse>
+"""
+        xmlout = self.XMLRPC_post(REQUEST_XML)
+        self.assertEqual(xmlout, RESPONSE_XML)
+        return
+
+    def test_get_students_by_department(self):
+        self.setup_student(self.student)
+        server = ServerProxy('http://mgr:mgrpw@localhost/app')
+        result = server.get_students_by_department('fac1','dep1', '2012')
+        self.assertEqual(result, [['COURSE1', 100, 2012, 'K1000000', '234', 'Anna Tester']])
+        result = server.get_students_by_department('fac1','dep1')
+        self.assertEqual(result, [['COURSE1', 100, 2012, 'K1000000', '234', 'Anna Tester']])
+        result = server.get_students_by_department('fac1','dep2')
+        self.assertEqual(result, None)
+        REQUEST_XML = """\
+<?xml version="1.0"?>
+<methodCall>
+<methodName>get_students_by_department</methodName>
+<params>
+<param>
+<value><string>fac1</string></value>
+<value><string>dep1</string></value>
+</param>
+</params>
+</methodCall>"""
+        RESPONSE_XML = """\
+<?xml version='1.0'?>
+<methodResponse>
+<params>
+<param>
+<value><array><data>
+<value><array><data>
+<value><string>COURSE1</string></value>
+<value><int>100</int></value>
+<value><int>2012</int></value>
+<value><string>K1000000</string></value>
+<value><string>234</string></value>
+<value><string>Anna Tester</string></value>
 </data></array></value>
 </data></array></value>
Index: /main/waeup.kofa/trunk/src/waeup/kofa/students/webservices.py
===================================================================
--- /main/waeup.kofa/trunk/src/waeup/kofa/students/webservices.py	(revision 16390)
+++ /main/waeup.kofa/trunk/src/waeup/kofa/students/webservices.py	(revision 16391)
@@ -152,4 +152,41 @@
                 amount
                 ))
+        return list(set(hitlist))
+
+    @grok.require('waeup.xmlrpc')
+    def get_students_by_department(self, faccode=None, depcode=None, session=None):
+        """A webservice to pull student's registered courses in a department.
+        """
+        try:
+            session = int(session)
+        except (TypeError, ValueError):
+            pass
+        sessionsearch = True
+        if session in (None, ''):
+            sessionsearch = False
+        try:
+            department =self.context['faculties'][faccode][depcode]
+        except KeyError:
+            return None
+        courses = department.courses.keys()
+        cat = queryUtility(ICatalog, name='coursetickets_catalog')
+        hitlist = []
+        for course in courses:
+            if sessionsearch:
+                coursetickets = cat.searchResults(
+                    session=(session, session),
+                    code=(course, course))
+            else:
+                coursetickets = cat.searchResults(
+                    code=(course, course))
+            for c_ticket in coursetickets:
+                hitlist.append((
+                    c_ticket.code,
+                    c_ticket.level,
+                    c_ticket.level_session,
+                    c_ticket.student.student_id,
+                    c_ticket.student.matric_number,
+                    c_ticket.student.display_fullname,
+                    ))
         return list(set(hitlist))
 
