Index: openacs-4/contrib/packages/project-manager/www/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/one-postgresql.xql,v
diff -u -r1.21 -r1.22
--- openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	26 Jan 2004 15:39:40 -0000	1.21
+++ openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	26 Feb 2004 15:15:41 -0000	1.22
@@ -86,12 +86,16 @@
         t.title,
 	to_char(t.end_date,'YYYY-MM-DD HH24:MI') as end_date,
 	to_char(t.earliest_start,'YYYY-MM-DD HH24:MI') as earliest_start,
+	t.earliest_start - current_date as days_to_earliest_start,
 	to_char(t.earliest_start,'J') as earliest_start_j,
 	to_char(t.earliest_finish,'YYYY-MM-DD HH24:MI') as earliest_finish,
+	t.earliest_finish - current_date as days_to_earliest_finish,
 	to_char(t.latest_start,'YYYY-MM-DD HH24:MI') as latest_start,
+	t.latest_start - current_date as days_to_latest_start,
 	to_char(t.latest_start,'J') as latest_start_j,
 	to_char(current_date,'J') as today_j,
 	to_char(t.latest_finish,'YYYY-MM-DD HH24:MI') as latest_finish,
+	t.latest_finish - current_date as days_to_latest_finish,
         u.first_names,
         u.last_name,
         t.percent_complete,
@@ -102,7 +106,7 @@
         t.estimated_hours_work_max,
         t.actual_hours_worked
 	FROM
-	(select * from pm_tasks_revisionsx LEFT JOIN pm_task_assignment ON item_id = task_id) t LEFT JOIN all_users u ON t.party_id = u.party_id, cr_items i LEFT JOIN pm_task_dependency d ON i.item_id = d.task_id
+	(select * from pm_tasks_revisionsx LEFT JOIN pm_task_assignment ON item_id = task_id) t LEFT JOIN persons u ON t.party_id = u.person_id, cr_items i LEFT JOIN pm_task_dependency d ON i.item_id = d.task_id
 	WHERE
         t.parent_id = :project_item_id and
         t.revision_id = i.live_revision 
@@ -150,6 +154,13 @@
 
   <fullquery name="custom_query">
     <querytext>
+        SELECT
+        p.customer_id
+        FROM
+	pm_projectsx p 
+        LEFT JOIN organizations c ON p.customer_id = c.organization_id 
+        WHERE 
+        p.project_id = :original_project_id
     </querytext>
   </fullquery>