| |
47 |
47 |
et.task_id as revision_id, |
| |
48 |
48 |
nvl(round(cr.content_length/1024,0),0) as content_length, |
| |
49 |
49 |
et.late_submit_p, |
| |
50 |
50 |
crmt.label as pretty_mime_type |
| |
51 |
51 |
from cr_revisions cr, |
| |
52 |
52 |
evaluation_tasksi et, |
| |
53 |
53 |
cr_items cri, |
| |
54 |
54 |
cr_mime_types crmt |
| |
55 |
55 |
where cr.revision_id = et.revision_id |
| |
56 |
56 |
and grade_item_id = :grade_item_id |
| |
57 |
57 |
and cri.live_revision = et.task_id |
| |
58 |
58 |
and et.mime_type = crmt.mime_type |
| |
59 |
59 |
$assignments_orderby |
| |
60 |
60 |
|
| |
61 |
61 |
</querytext> |
| |
62 |
62 |
</fullquery> |
| |
63 |
63 |
|
| |
64 |
64 |
<fullquery name="compare_due_date"> |
| |
65 |
65 |
<querytext> |
| |
66 |
66 |
|
| |
67 |
|
select 1 from dual where :due_date > now() |
| |
|
67 |
select 1 from dual where :due_date > sysdate |
| |
68 |
68 |
|
| |
69 |
69 |
</querytext> |
| |
70 |
70 |
</fullquery> |
| |
71 |
71 |
|
| |
72 |
72 |
<fullquery name="get_group_id"> |
| |
73 |
73 |
<querytext> |
| |
74 |
74 |
|
| |
75 |
75 |
select nvl((select etg2.group_id from evaluation_task_groups etg2, |
| |
76 |
76 |
evaluation_tasks et2, |
| |
77 |
77 |
acs_rels map |
| |
78 |
78 |
where map.object_id_one = etg2.group_id |
| |
79 |
79 |
and map.object_id_two = :user_id |
| |
80 |
80 |
and etg2.task_item_id = et2.task_item_id |
| |
81 |
81 |
and et2.task_id = :task_id),0) |
| |
82 |
82 |
from evaluation_tasks et3 |
| |
83 |
83 |
where et3.task_id = :task_id |
| |
84 |
84 |
|
| |
85 |
85 |
-- select evaluation__party_id(:user_id,:task_id) |
| |
86 |
86 |
|
| |
87 |
87 |
</querytext> |
