Index: openacs-4/packages/tasks/www/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/tasks/www/index.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/tasks/www/index.xql	30 Nov 2005 16:06:53 -0000	1.3.2.2
@@ -0,0 +1,105 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="tasks_pagination_old">
+      <querytext>
+    select pt.task_id
+      from cr_items ci,
+           pm_tasks_revisions ptr,
+           pm_tasks pt left join pm_process_instance ppi on (pt.process_instance = ppi.instance_id ),
+           cr_revisions cr,
+           acs_objects ao,
+           ( select task_id, party_id
+               from pm_task_assignment
+              where party_id in ( select parties.party_id
+                                    from parties left join cr_items on (parties.party_id = cr_items.item_id) left join cr_revisions on (cr_items.latest_revision = cr_revisions.revision_id ) , group_distinct_member_map
+                                   where parties.party_id = group_distinct_member_map.member_id
+                                     and group_distinct_member_map.group_id = '11428599'
+                                     [contact::search_clause -and -search_id $search_id -query $query -party_id "parties.party_id" -revision_id "revision_id"] )
+                and role_id = '1' ) assigned_tasks
+     where ci.parent_id = :project_id
+       and ci.item_id = pt.task_id
+       and ci.live_revision = ptr.task_revision_id
+       and ci.live_revision = cr.revision_id
+       and pt.status = 1
+       and ptr.end_date is not null
+       and pt.deleted_p = 'f'
+       and pt.task_id = assigned_tasks.task_id 
+       and pt.task_id = ao.object_id
+       and CASE WHEN ao.creation_user = assigned_tasks.party_id THEN
+                CASE WHEN assigned_tasks.party_id = :user_id THEN 'f'::boolean ELSE 't'::boolean END
+                ELSE 't'::boolean END
+       and ptr.end_date < ( now() + :tasks_interval || ' days'::interval )
+    [template::list::orderby_clause -orderby -name tasks]
+      </querytext>
+</fullquery>
+
+<fullquery name="tasks_count_old">
+      <querytext>
+    select count(*)
+      from cr_items ci,
+           pm_tasks_revisions ptr,
+           pm_tasks pt left join pm_process_instance ppi on (pt.process_instance = ppi.instance_id ),
+           cr_revisions cr,
+           acs_objects ao,
+           ( select task_id, party_id
+               from pm_task_assignment
+              where party_id in ( select parties.party_id
+                                    from parties left join cr_items on (parties.party_id = cr_items.item_id) left join cr_revisions on (cr_items.latest_revision = cr_revisions.revision_id ) , group_distinct_member_map
+                                   where parties.party_id = group_distinct_member_map.member_id
+                                     and group_distinct_member_map.group_id = '11428599'
+                                     [contact::search_clause -and -search_id $search_id -query $query -party_id "parties.party_id" -revision_id "revision_id"] )
+                and role_id = '1' ) assigned_tasks
+     where ci.parent_id = :project_id
+       and ci.item_id = pt.task_id
+       and ci.live_revision = ptr.task_revision_id
+       and ci.live_revision = cr.revision_id
+       and pt.status = 1
+       and ptr.end_date is not null
+       and pt.deleted_p = 'f'
+       and pt.task_id = assigned_tasks.task_id 
+       and pt.task_id = ao.object_id
+       and CASE WHEN ao.creation_user = assigned_tasks.party_id THEN
+                CASE WHEN assigned_tasks.party_id = :user_id THEN 'f'::boolean ELSE 't'::boolean END
+                ELSE 't'::boolean END
+       and ptr.end_date < ( now() + :tasks_interval || ' days'::interval )
+      </querytext>
+</fullquery>
+
+<fullquery name="tasks_select_old">      
+      <querytext>
+    select pt.task_id,
+           tasks__relative_date(ptr.end_date) as end_date,
+           CASE WHEN ptr.end_date < now() THEN 't'::boolean ELSE 'f'::boolean END as overdue_p,
+           cr.title,
+           ptr.priority,
+           contact__name(assigned_tasks.party_id,:name_order) as contact_name,
+           assigned_tasks.party_id,
+           ppi.name as process,
+           ppi.process_id as process_id
+      from cr_items ci,
+           pm_tasks_revisions ptr,
+           pm_tasks pt left join pm_process_instance ppi on (pt.process_instance = ppi.instance_id ),
+           cr_revisions cr,
+           acs_objects ao,
+           pm_task_assignment as assigned_tasks
+     where ci.parent_id = :project_id
+       and ci.item_id = pt.task_id
+       and ci.live_revision = ptr.task_revision_id
+       and ci.live_revision = cr.revision_id
+       and pt.status = 1
+       and ptr.end_date is not null
+       and pt.deleted_p = 'f'
+       and pt.task_id = assigned_tasks.task_id 
+       and pt.task_id = ao.object_id
+       and CASE WHEN ao.creation_user = assigned_tasks.party_id THEN
+                CASE WHEN assigned_tasks.party_id = :user_id THEN 'f'::boolean ELSE 't'::boolean END
+                ELSE 't'::boolean END
+       and ptr.end_date < ( now() + :tasks_interval || ' days'::interval )
+    [template::list::page_where_clause -and -name tasks -key pt.task_id]
+    [template::list::orderby_clause -orderby -name tasks]
+      </querytext>
+</fullquery>
+
+ 
+</queryset>