Forum OpenACS Q&A: Re: Project-manager integration with logger

Collapse
Posted by Jade Rubick on
Here are my notes on the integration:

Integration:

1) Added in a table pm_task_logger_proj_map

2) Added in a column to pm_projects: logger_project. This is a link to
  the logger project.

3) Copied files from /logger/www/lib to project manager. Customized
  them so that they would show the right context bar, and so that
  links would be correct. A better solution would be to change logger
  so that it can offer <includes> that have correct links for
  packages that include it.

  Note: the pm_projects table denormalizes the values it gets from
  logger, and I haven't made any code changes to logger. So in the
  following situation, there is a bug: a) create a project in
  project-manager. b) go to logger, and associate the project with
  that instance. c) log hours from logger d) look at the project in
  project-manager. Until the project is edited, or a task under the
  project is edited, or another log entry is made from
  project-manager, the Hours completed will not include the hours
  entered from logger.

4) Modified pm::project::new proc so that creating a new
  project-manager project also creates a logger project, and so that
  that ID is stored in the pm_projects table.

5) Added an include in the www/one.adp that shows last 30 days of
  logger entries for a project. Links to add in new entries, to edit
  entries, and to delete entries. ***Deleting entries does not work
  right now.***

6) Added logged time to task-one page. Use pm_task_logger_proj_map table.
  Show logged time on the task-one page.

  Note: People can log as many hours as they want to projects, and
  that doesn't affect the hours completed statistic for the
  project. The hours completed statistic is based on hours project
  and hours logged on TASKS.

7) Edited log.tcl and log.adp files so that edits made from tasks are
  linked to tasks. They also update the denormalized tables in
  pm_tasks_revisions, and pm_projects.

8) Modified task-add-edit so that you can add an entry while editing a
  task.

9) Changed entries-table to show tasks instead of projects (you know
  projects based on the context).