Index: openacs-4/packages/evaluation/lib/evaluations-chunk-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/lib/Attic/evaluations-chunk-oracle.xql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/evaluation/lib/evaluations-chunk-oracle.xql 7 Apr 2005 11:26:58 -0000 1.2
+++ openacs-4/packages/evaluation/lib/evaluations-chunk-oracle.xql 4 Oct 2005 17:45:42 -0000 1.2.2.1
@@ -37,4 +37,48 @@
+
+
+ select 1 from dual where :due_date > sysdate
+
+
+
+
+
+
+ select et.task_name,
+ round(et.weight,2) as task_weight,
+ et.task_id, nvl(perfect_score,0) as perfect_score, online_p
+ from evaluation_tasksi et, cr_items cri
+ where grade_item_id = :grade_item_id
+ and cri.live_revision = et.task_id
+ $evaluations_orderby
+
+
+
+
+
+
+
+ select et.task_name,
+ et.task_item_id,
+ et.weight as t_weight,
+ eg.weight as g_weight,
+ round((et.weight*eg.weight)/100,2) as task_weight,
+ et.number_of_members,
+ et.online_p,
+ et.due_date,
+ et.late_submit_p,
+ et.task_id, nvl(perfect_score,0) as perfect_score
+ from evaluation_grades eg,
+ evaluation_tasksi et,
+ cr_items cri
+ where eg.grade_id = :grade_id
+ and eg.grade_item_id = et.grade_item_id
+ and cri.live_revision = et.task_id
+ $evaluations_orderby
+
+
+
+