Index: openacs-4/packages/evaluation/www/view/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/view/index.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/evaluation/www/view/index.xql	22 Dec 2004 22:06:41 -0000	1.3
+++ openacs-4/packages/evaluation/www/view/index.xql	8 Aug 2006 21:26:43 -0000	1.4
@@ -2,6 +2,40 @@
 
 <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, cr_items cri
+		where cri.live_revision = eg.grade_id
+          and eg.grade_item_id = ao.object_id
+   		  and ao.context_id = :package_id
+		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>
+
 <fullquery name="revision_info">      
       <querytext>
 	select cri.content_type, cri.name
@@ -10,4 +44,6 @@
  	and crr.revision_id = :revision_id
       </querytext>
 </fullquery>
+
 </queryset>
+