Index: openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-one-postgresql.xql,v
diff -u -r1.11 -r1.12
--- openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql	22 Aug 2003 00:27:33 -0000	1.11
+++ openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql	4 Sep 2003 22:45:23 -0000	1.12
@@ -41,7 +41,12 @@
         t.item_id,
         t.title as task_title,
         t.description,
-	to_char(t.end_date,'MM/DD/YYYY') as end_date,
+	to_char(t.end_date,'Mon DD ''YY') as end_date,
+	to_char(t.earliest_start,'Mon DD ''YY') as earliest_start,
+	to_char(t.earliest_finish,'Mon DD ''YY') as earliest_finish,
+	to_char(t.latest_start,'Mon DD ''YY') as latest_start,
+	to_char(t.latest_finish,'Mon DD ''YY') as latest_finish,
+        t.latest_start-t.end_date as slack_time,
         t.percent_complete,
         i.live_revision
 	FROM
@@ -75,44 +80,44 @@
     </querytext>
   </fullquery>
 
-  <fullquery name="consts_query">
+  <fullquery name="dependency_query">
     <querytext>
 	SELECT
         t.title as task_title,
 	to_char(t.end_date,'MM/DD/YYYY') as end_date,
         t.percent_complete,
         i.live_revision,
-        c.parent_task_id,
-        c.const_type
+        d.parent_task_id,
+        d.dependency_type
 	FROM
-	pm_tasks_revisionsx t, cr_items i, pm_task_constraints c
+	pm_tasks_revisionsx t, cr_items i, pm_task_dependency d
 	WHERE
-        c.task_id        = :task_id and
-        c.parent_task_id = t.item_id and 
+        d.task_id        = :task_id and
+        d.parent_task_id = t.item_id and 
         t.revision_id    = i.live_revision and
         t.item_id        = i.item_id
-        [template::list::orderby_clause -name consts -orderby]
+        [template::list::orderby_clause -name dependency -orderby]
     </querytext>
   </fullquery>
 
-  <fullquery name="consts2_query">
+  <fullquery name="dependency2_query">
     <querytext>
 	SELECT
         t.title as task_title,
 	to_char(t.end_date,'MM/DD/YYYY') as end_date,
         t.percent_complete,
         i.live_revision,
-        c.parent_task_id,
-        c.const_type,
-        c.task_id
+        d.parent_task_id,
+        d.dependency_type,
+        d.task_id
 	FROM
-	pm_tasks_revisionsx t, cr_items i, pm_task_constraints c
+	pm_tasks_revisionsx t, cr_items i, pm_task_dependency d
 	WHERE
-        c.task_id        = t.item_id and
-        c.parent_task_id = :task_id and 
+        d.task_id        = t.item_id and
+        d.parent_task_id = :task_id and 
         t.revision_id    = i.live_revision and
         t.item_id        = i.item_id
-        [template::list::orderby_clause -name consts2 -orderby]
+        [template::list::orderby_clause -name dependency2 -orderby]
     </querytext>
   </fullquery>
 </queryset>