Index: openacs-4/contrib/packages/project-manager/www/process-task-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/process-task-add-edit-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/project-manager/www/process-task-add-edit-postgresql.xql	15 Sep 2003 23:09:57 -0000	1.1
+++ openacs-4/contrib/packages/project-manager/www/process-task-add-edit-postgresql.xql	3 Oct 2003 22:21:45 -0000	1.2
@@ -1,44 +1,55 @@
 <?xml version="1.0"?>
 <queryset>
-  <fullquery name="new_task_item">
+  <fullquery name="edit_task">
     <querytext>
-	select pm_task__new_task_item (
-                null,
-		:project_item_id,
-                '$task_title($i)',
-                '$description($i)',
-                [project_manager::project::util::datenvl -value [set end_date_$i] -value_if_null "null," -value_if_not_null "to_timestamp('[set end_date_$i]','YYYY MM DD HH24 MI SS'),"]
-                '0',
-                '$estimated_hours_work($i)',
-                '$estimated_hours_work_min($i)',
-                '$estimated_hours_work_max($i)',
-		now(),
-		:user_id,
-		:peeraddr,
-		:package_id
-	);
+        update
+        pm_process_task 
+        set 
+        process_task_id          = :process_task_id,
+        process_id               = :process_id,
+        one_line                 = :one_line,
+        description              = :desc,
+        estimated_hours_work     = :work,
+        estimated_hours_work_min = :work_min,
+        estimated_hours_work_max = :work_max
     </querytext>
   </fullquery>
 
   <fullquery name="task_query">
     <querytext>
       select
-        t.task_revision_id,
-        t.title as task_title,
-        t.item_id,
+        current_timestamp
+	FROM
+	dual
+    </querytext>
+  </fullquery>
+
+  <fullquery name="get_old_tasks">
+    <querytext>
+        select
+        t.process_id,
+        t.one_line as task_title,
         t.description,
-        t.name,
-        t.parent_id,
-	to_char(t.end_date,'YYYY MM DD') as end_date,
-        t.percent_complete,
         t.estimated_hours_work,
         t.estimated_hours_work_min,
         t.estimated_hours_work_max
-	FROM
-	pm_tasks_revisionsx t, cr_items i
+  	FROM
+	pm_process_task t LEFT JOIN pm_process_task_dependency d ON d.process_task_id = t.process_task_id
         WHERE
-        t.item_id = :task_id and
-        t.revision_id = i.live_revision
+        t.process_task_id in ([join $process_task_id ","])
     </querytext>
   </fullquery>
+
+  <fullquery name="get_project_id">
+    <querytext>
+        SELECT
+        p.project_id
+        FROM
+        pm_projectsx p, cr_items i
+        WHERE
+        p.item_id = :project_item_id and 
+        p.revision_id = i.live_revision
+    </querytext>
+  </fullquery>
+
 </queryset>