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 10043)
+++ /main/waeup.kofa/trunk/src/waeup/kofa/students/tests/test_webservices.py	(revision 10044)
@@ -171,7 +171,15 @@
         self.assertEqual(result, None)
         result = server.get_students_by_course('CRS1', '2012')
-        self.assertEqual(result, [['K1000000', '234', 'my adviser'],])
+        self.assertEqual(result, [['K1000000', '234', 'my adviser', 0],])
         result = server.get_students_by_course('CRS1')
-        self.assertEqual(result, [['K1000000', '234', 'my adviser'],])
+        self.assertEqual(result, [['K1000000', '234', 'my adviser', 0],])
+        payment = StudentOnlinePayment()
+        payment.p_id = 'my-id'
+        payment.p_session = 2012
+        payment.amount_auth = 12.12
+        payment.p_state = u'paid'
+        self.student['payments']['my-payment'] = payment
+        result = server.get_students_by_course('CRS1')
+        self.assertEqual(result, [['K1000000', '234', 'my adviser', 12.12],])
         REQUEST_XML="""\
 <?xml version="1.0"?>
@@ -195,4 +203,5 @@
 <value><string>234</string></value>
 <value><string>my adviser</string></value>
+<value><double>12.12</double></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 10043)
+++ /main/waeup.kofa/trunk/src/waeup/kofa/students/webservices.py	(revision 10044)
@@ -109,5 +109,5 @@
     def get_students_by_course(self, course=None, session=None):
         """2. What STUDENTS registered (student id / matric no)
-        for course Z in session Y?
+        for course Z in session Y and did they pay school fee?
 
         """
@@ -130,9 +130,17 @@
             return None
         hitlist = []
-        for ticket in coursetickets:
+        for c_ticket in coursetickets:
+            amount = 0
+            for p_ticket in c_ticket.student['payments'].values():
+                if p_ticket.p_state == 'paid' and \
+                    p_ticket.p_category == 'schoolfee' and \
+                    p_ticket.p_session == c_ticket.__parent__.level_session:
+                    amount = p_ticket.amount_auth
             hitlist.append((
-                ticket.student.student_id,
-                ticket.student.matric_number,
-                ticket.__parent__.validated_by))
+                c_ticket.student.student_id,
+                c_ticket.student.matric_number,
+                c_ticket.__parent__.validated_by,
+                amount
+                ))
         return list(set(hitlist))
 
