Index: openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql	7 Apr 2005 11:26:30 -0000	1.9
+++ openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql	8 Aug 2006 21:26:45 -0000	1.10
@@ -3,6 +3,22 @@
 <queryset>
 <rdbms><type>postgresql</type><version>7.3</version></rdbms>
 
+<fullquery name="get_grades">      
+      <querytext>
+
+	select eg.grade_plural_name,
+	eg.grade_id,
+	eg.grade_item_id
+	from evaluation_grades eg, acs_objects ao
+	where exists (select 1 from cr_items
+           where live_revision = eg.grade_id) 
+	  and eg.grade_item_id = ao.object_id
+	  and ao.context_id in  ([join $list_of_package_ids ,])
+	order by grade_plural_name desc
+	
+      </querytext>
+</fullquery>
+
 <fullquery name="get_total_grade">      
       <querytext>
 
@@ -39,4 +55,23 @@
       </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>