Index: openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet.xql	8 Apr 2005 08:15:30 -0000	1.1
@@ -0,0 +1,40 @@
+<?xml version="1.0"?>
+
+<queryset>
+
+<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="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>