Index: openacs-4/packages/evaluation/www/admin/tasks/task-add-edit.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/tasks/task-add-edit.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/evaluation/www/admin/tasks/task-add-edit.xql	4 Apr 2005 18:22:36 -0000	1.2
+++ openacs-4/packages/evaluation/www/admin/tasks/task-add-edit.xql	8 Aug 2006 21:26:43 -0000	1.3
@@ -5,20 +5,54 @@
 <fullquery name="get_grade_info">      
       <querytext>
 
-		select grade_plural_name, 
-		grade_name, 
-		weight as grade_weight,
-		grade_item_id
-		 from evaluation_grades where grade_id = :grade_id
+		select eg.grade_plural_name, (select count(et.task_id) from evaluation_tasks et, cr_items cri where
+	        et.grade_item_id = eg.grade_item_id and et.task_id=cri.live_revision) as tasks_counter,
+		eg.grade_name, 
+		eg.weight as grade_weight,
+		eg.grade_item_id
+		from evaluation_grades eg
+		where eg.grade_id = :grade_id
+	
+      </querytext>
+</fullquery>
 
+<fullquery name="select_grade_types">      
+      <querytext>
+	select eg.grade_name, 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 eg.grade_plural_name desc
+
       </querytext>
 </fullquery>
+	    
+<fullquery name="update_points">      
 
+      <querytext>
+	update evaluation_tasks set points=:points,perfect_score=:perfect_score,relative_weight=:relative_weight,forums_related_p=:forums_related_p where task_id=:revision_id
+
+      </querytext>
+</fullquery>
+
+<fullquery name="get_grade_tasks">      
+      <querytext>
+		select * from evaluation_tasks et where
+	        et.grade_item_id = :grade_item_id and et.task_id=(select live_revision from cr_items where item_id=et.task_item_id) 
+      </querytext>
+</fullquery>
+<fullquery name="update_tasks">      
+      <querytext>
+	update evaluation_tasks set relative_weight=:relative_weight where task_id=:task_id
+      </querytext>
+</fullquery>
+
 <fullquery name="task_info">      
       <querytext>
 
 		select et.task_name, et.description, to_char(et.due_date,'YYYY-MM-DD HH24:MI:SS') as due_date_ansi, 
-		       et.weight, et.number_of_members, et.online_p, et.late_submit_p, et.requires_grade_p
+		       et.weight, et.number_of_members, et.online_p, et.late_submit_p, et.requires_grade_p,(select points from evaluation_tasks where task_id=:task_id) as points,(select perfect_score from evaluation_tasks where task_id=:task_id)  as perfect_score,(select forums_related_p from evaluation_tasks where task_id=:task_id) as forums_related_p
 		from evaluation_tasksi et
 		where task_id = :task_id