Index: openacs-4/packages/evaluation/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/index-postgresql.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/evaluation/www/index-postgresql.xql	10 Sep 2004 19:16:30 -0000	1.6
+++ openacs-4/packages/evaluation/www/index-postgresql.xql	11 Sep 2004 00:49:21 -0000	1.7
@@ -21,7 +21,7 @@
 <fullquery name="get_total_grade">      
       <querytext>
 
-        select coalesce(sum((ese.grade*et.weight*eg.weight)/10000),0) as grade
+        select coalesce(sum(round((ese.grade*et.weight*eg.weight)/10000,2)),0) as grade
         from evaluation_grades eg, evaluation_tasks et, evaluation_student_evals ese, acs_objects ao, cr_items cri1, cr_items cri2, cr_items cri3
         where et.task_item_id = ese.task_item_id
 		  and et.grade_item_id = eg.grade_item_id
@@ -55,5 +55,24 @@
       </querytext>
 </fullquery>
 
+<fullquery name="max_possible_grade">      
+      <querytext>
+
+    select sum(round(et.weight*eg.weight/100,2))
+    from evaluation_tasks et,
+    evaluation_grades eg,
+    cr_items cri1,
+    cr_items cri2,
+    acs_objects ao
+    where et.grade_item_id = eg.grade_item_id
+    and cri1.live_revision = eg.grade_id
+    and cri2.live_revision = et.task_id
+    and et.requires_grade_p = 't'
+    and ao.object_id = eg.grade_item_id
+    and ao.context_id = :package_id
+
+      </querytext>
+</fullquery>
+
 </queryset>