OpenACS / openacs-4 / contrib / packages / project-manager / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 8
Last Commit: 14 Jun
Commits this week: 0
Total Lines of Code (LoC): 0
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 06 Feb 2004
7:37 pm

jader

Fixed bug in creation of pm_tasks_xrefs table

Options
    • -1
    • +1
    ./project-manager-table-create.sql
12:57 am

jader

Lots of changes!

First of all, one user reported that a view was breaking because

customer_id wasn't a part of the projects table. I'm trying one other

thing that might work.

Add a proc for creating tasks

Add sorting columns in list builder views

Add in status values for tasks, procs to get standard status values

Tasks page now shows own tasks by default, option to show other people's tasks.

Lots more debugging, but some of the new functionality hasn't been

tested much yet.

Options
    • -0
    • +0
    ./project-manager-create.sql
    • -10
    • +14
    ./project-manager-custom-create.sql
    • -2
    • +2
    ./project-manager-custom-drop.sql
    • -2
    • +15
    ./project-manager-drop.sql
    • -12
    • +18
    ./project-manager-functions-create.sql
    • -17
    • +47
    ./project-manager-table-create.sql
  7. … 31 more files in changeset.
Wednesday 04 Feb 2004
9:17 pm

jader

Version 0.7d upgrade not supported (need to use the drop and create script)

Many many updates and fixes and improvements, too numerous really to mention.

Options
    • -0
    • +0
    ./project-manager-create.sql
    • -1
    • +3
    ./project-manager-custom-create.sql
    • -4
    • +2
    ./project-manager-custom-drop.sql
    • -10
    • +53
    ./project-manager-drop.sql
    • -51
    • +44
    ./project-manager-functions-create.sql
    • -28
    • +43
    ./project-manager-table-create.sql
  7. … 34 more files in changeset.
Monday 26 Jan 2004
4:39 pm

jeffd

merge of changes between oacs-5-0-0b4 and oacs-5-0-0-final to HEAD

Options
    • -2
    • +3
    ./project-manager-create.sql
    • -0
    • +31
    ./project-manager-custom-create.sql
    • -0
    • +13
    ./project-manager-custom-drop.sql
    • -1
    • +1
    ./project-manager-drop.sql
    • -1
    • +1
    ./project-manager-functions-create.sql
    • -0
    • +64
    ./project-manager-notifications-create.sql
    • -0
    • +92
    ./project-manager-notifications-drop.sql
    • -5
    • +13
    ./project-manager-table-create.sql
  9. … 279 more files in changeset.
Saturday 10 Jan 2004
2:04 am

jader

Many many updates:

Added in basic notifications (no UI) for when tasks are created

Reduced the number of pages required for task create from 3 to 2 when dependencies

are being created.

Set up ability to add dependencies between newly created tasks (checks for loops so

they don't depend on each other)

Finished adding in basic categorization. UI could be improved, but it works.

Many minor UI updates.

Added in some functions that I had neglected to commit earlier.

Note that this still has a bug in the all_users view. It should be all_users_all, I

believe.

Options
    • -2
    • +3
    ./project-manager-create.sql
    • -3
    • +6
    ./project-manager-drop.sql
    • -1
    • +9
    ./project-manager-functions-create.sql
    • -0
    • +64
    ./project-manager-notifications-create.sql
    • -0
    • +92
    ./project-manager-notifications-drop.sql
    • -5
    • +11
    ./project-manager-table-create.sql
  7. … 21 more files in changeset.
2:04 am

jader

file project-manager-notifications-create.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./project-manager-notifications-create.sql
2:04 am

jader

file project-manager-notifications-drop.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./project-manager-notifications-drop.sql
Saturday 13 Dec 2003
2:19 am

jader

Add in categorization, add in ability to customize projects

table. Many bugfixes

Options
    • -0
    • +0
    ./project-manager-create.sql
    • -0
    • +31
    ./project-manager-custom-create.sql
    • -0
    • +13
    ./project-manager-custom-drop.sql
    • -6
    • +3
    ./project-manager-drop.sql
    • -9
    • +1
    ./project-manager-functions-create.sql
    • -0
    • +2
    ./project-manager-table-create.sql
  7. … 33 more files in changeset.
2:19 am

jader

file project-manager-custom-create.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./project-manager-custom-create.sql
2:19 am

jader

file project-manager-custom-drop.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./project-manager-custom-drop.sql
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -151
    • +159
    ./project-manager-drop.sql
    • -298
    • +302
    ./project-manager-functions-create.sql
    • -7
    • +30
    ./project-manager-table-create.sql
  4. … 596 more files in changeset.
Friday 05 Dec 2003
2:09 am

jader

Added in preliminary categories support. Now relies upon categories.

Options
    • -0
    • +0
    ./project-manager-create.sql
    • -0
    • +0
    ./project-manager-drop.sql
    • -0
    • +0
    ./project-manager-functions-create.sql
    • -31
    • +0
    ./project-manager-table-create.sql
  5. … 28 more files in changeset.
Thursday 04 Dec 2003
10:00 pm

jader

Added in tasks page (to see a list of tasks assigned to you or others).

Added in data model support for project statuses.

Updated various items to get in line with 5.0

Quite a few small bugfixes.

Options
    • -1
    • +1
    ./project-manager-create.sql
    • -151
    • +159
    ./project-manager-drop.sql
    • -298
    • +302
    ./project-manager-functions-create.sql
    • -6
    • +60
    ./project-manager-table-create.sql
  5. … 36 more files in changeset.
Wednesday 26 Nov 2003
2:33 pm

jeffd

fix the __name methods so the user admin pages dont break

Options
    • -4
    • +4
    ./project-manager-functions-create.sql
Saturday 04 Oct 2003
12:21 am

jader

Added in processes. Still only half-working

Options
    • -84
    • +90
    ./project-manager-table-create.sql
  2. … 22 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -90
    • +83
    ./project-manager-table-create.sql
  2. … 275 more files in changeset.
Tuesday 16 Sep 2003
1:09 am

jader

Started adding in processes.

Options
    • -1
    • +19
    ./project-manager-drop.sql
    • -0
    • +108
    ./project-manager-table-create.sql
  3. … 10 more files in changeset.
Friday 12 Sep 2003
7:58 pm

jader

Added in constraints for uniqueness on several tables

Options
    • -5
    • +15
    ./project-manager-table-create.sql
3:20 am

jader

Let me see...

Options
    • -10
    • +13
    ./project-manager-drop.sql
    • -80
    • +77
    ./project-manager-table-create.sql
  3. … 24 more files in changeset.
Friday 29 Aug 2003
2:35 am

jader

Changed constraints to be called dependencies. Begin allowing null values

for dates in tasks. General cleanup of a lot of the interface. Added in

some more parameters to control what is shown to the user. Task view page

is currently broken. Fixed data model for tasks so it is more in line with

optional PERT graphs.

Options
    • -5
    • +5
    ./project-manager-drop.sql
    • -50
    • +56
    ./project-manager-functions-create.sql
    • -26
    • +83
    ./project-manager-table-create.sql
  4. … 18 more files in changeset.
Friday 22 Aug 2003
11:06 pm

jader

Fixed date code for projects. Started adding in project status info into index.

Options
    • -1
    • +1
    ./project-manager-table-create.sql
  2. … 4 more files in changeset.
2:27 am

jader

Project view page now shows more information on pertinent tasks. Style

sheet modified slightly to shrink left column. Converted part of

project view page to list-builder, added in summation at bottom of

table.

Options
    • -1
    • +1
    ./project-manager-table-create.sql
  2. … 6 more files in changeset.
12:34 am

jader

Added in time estimates for tasks, parameter to specify whether or not

to use minimum and maximum time estimates or not, denormalized columns

for projects on status, took out start date for tasks.

Options
    • -25
    • +29
    ./project-manager-functions-create.sql
    • -14
    • +53
    ./project-manager-table-create.sql
  3. … 14 more files in changeset.
Thursday 14 Aug 2003
12:52 am

jader

Drop script now correctly drops the main content folder for projects.

Options
    • -38
    • +27
    ./project-manager-drop.sql
Wednesday 13 Aug 2003
8:56 pm

jader

Added in data model for task and project assignments. Took out

project_name from pm_projects_revisions table -- it is now in

cr_revisions.title. Added in a sequence for project IDs.

Options
    • -1
    • +11
    ./project-manager-drop.sql
    • -15
    • +11
    ./project-manager-functions-create.sql
    • -3
    • +132
    ./project-manager-table-create.sql
  4. … 4 more files in changeset.
Friday 08 Aug 2003
1:08 am

jader

Added in task constraints, including icons for constraints.

Options
    • -2
    • +2
    ./project-manager-drop.sql
    • -7
    • +15
    ./project-manager-table-create.sql
  3. … 16 more files in changeset.
Wednesday 06 Aug 2003
10:22 pm

jader

Bumped a version, now includes parameters for names for project, task,

assignee, watcher. Also tweaked the UI a bit based on comments from irc.

Options
    • -5
    • +6
    ./project-manager-functions-create.sql
  2. … 11 more files in changeset.
Friday 01 Aug 2003
10:51 pm

jader

Added in data model for task constraints.

Tasks can be added en masse now

However, editing tasks no longer works.

Options
    • -34
    • +41
    ./project-manager-drop.sql
    • -0
    • +33
    ./project-manager-table-create.sql
  3. … 4 more files in changeset.
Thursday 31 Jul 2003
1:36 am

jader

Tasks now can be edited.

Options
    • -4
    • +3
    ./project-manager-functions-create.sql
  2. … 8 more files in changeset.
Wednesday 30 Jul 2003
10:42 pm

jader

Added in tasks, fixed bugs/added in functionality to edit projects,

removed content repository folder for each project (only one folder

per instance now), add in style sheet, rename files in line with

openacs conventions.

Options
    • -1
    • +1
    ./project-manager-create.sql
    • -27
    • +71
    ./project-manager-drop.sql
    • -114
    • +407
    ./project-manager-functions-create.sql
    • -16
    • +75
    ./project-manager-table-create.sql
  5. … 17 more files in changeset.