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.11 -r1.12 --- openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql 10 Oct 2003 22:51:04 -0000 1.11 +++ openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql 11 Dec 2003 21:39:44 -0000 1.12 @@ -2,48 +2,48 @@ - SELECT + SELECT t.process_task_id as process_tid, t.one_line, t.description, t.estimated_hours_work, t.estimated_hours_work_min, t.estimated_hours_work_max, d.dependency_id - FROM + FROM pm_process_task t LEFT JOIN pm_process_task_dependency d ON t.process_task_id = d.process_task_id - WHERE - t.process_id = :process_id + WHERE + t.process_id = :process_id ORDER BY t.process_task_id - select pm_task__new_task_item ( + select pm_task__new_task_item ( null, - :project_item_id, + :project_item_id, :p_task_title, :p_description, [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', :p_work, :p_work_min, :p_work_max, - current_timestamp, - :user_id, - :peeraddr, - :package_id - ); + current_timestamp, + :user_id, + :peeraddr, + :package_id + ); - select pm_task__new_task_revision ( + select pm_task__new_task_revision ( :p_task_item_id, - :project_item_id, + :project_item_id, :p_task_title, :p_description, [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'),"] @@ -52,20 +52,20 @@ :p_work_min, :p_work_max, :p_hours, - current_timestamp, - :user_id, - :peeraddr, - :package_id - ); + current_timestamp, + :user_id, + :peeraddr, + :package_id + ); select current_timestamp - FROM - dual + FROM + dual @@ -77,15 +77,15 @@ t.item_id, t.description, t.name, - to_char(t.end_date,'YYYY MM DD') as end_date, + 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, d.parent_task_id, t.actual_hours_worked - FROM - pm_tasks_revisionsx t, + FROM + pm_tasks_revisionsx t, cr_items i LEFT JOIN pm_task_dependency d ON i.item_id = d.task_id WHERE t.item_id in ([join $task_id ","]) and