Index: openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-add-edit-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql 4 Aug 2003 22:40:21 -0000 1.5
+++ openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql 21 Aug 2003 22:34:43 -0000 1.6
@@ -8,8 +8,9 @@
'$task_title($i)',
'$description($i)',
to_timestamp(now(),'YYYY MM DD HH24 MI SS'),
- to_timestamp(now(),'YYYY MM DD HH24 MI SS'),
'0',
+ '$estimated_hours_work_min($i)',
+ '$estimated_hours_work_max($i)',
now(),
:user_id,
:peeraddr,
@@ -18,24 +19,6 @@
-
-
- select pm_task__new_task_revision (
- :task_id,
- :project_item_id,
- :task_title,
- :description,
- to_timestamp(:start_date,'YYYY MM DD HH24 MI SS'),
- to_timestamp(:end_date,'YYYY MM DD HH24 MI SS'),
- :percent_complete,
- now(),
- :user_id,
- :peeraddr,
- :package_id
- );
-
-
-
select
@@ -45,9 +28,10 @@
t.description,
t.name,
t.parent_id,
- to_char(t.start_date,'YYYY MM DD') as start_date,
to_char(t.end_date,'YYYY MM DD') as end_date,
- t.percent_complete
+ t.percent_complete,
+ t.estimated_hours_work_min,
+ t.estimated_hours_work_max
FROM
pm_tasks_revisionsx t, cr_items i
WHERE