Index: openacs-4/packages/bug-tracker/bug-tracker.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/bug-tracker.info,v diff -u -r1.23 -r1.23.2.1 --- openacs-4/packages/bug-tracker/bug-tracker.info 25 Feb 2005 17:08:11 -0000 1.23 +++ openacs-4/packages/bug-tracker/bug-tracker.info 7 Nov 2005 19:40:53 -0000 1.23.2.1 @@ -7,7 +7,7 @@ <initial-install-p>f</initial-install-p> <singleton-p>f</singleton-p> - <version name="1.4d3" url="http://openacs.org/repository/download/apm/bug-tracker-1.4d3.apm"> + <version name="1.5d2" url="http://openacs.org/repository/download/apm/bug-tracker-1.5d2.apm"> <owner url="mailto:lars@collaboraid.biz">Lars Pind</owner> <summary>Tracks bugs and features, versions and maintainers, in software projects.</summary> <release-date>2003-02-28</release-date> @@ -16,7 +16,7 @@ Contains the best of SDM, Bugzilla, FogBUGZ, and bughost.com.</description> <maturity>0</maturity> - <provides url="bug-tracker" version="1.4d3"/> + <provides url="bug-tracker" version="1.5d2"/> <requires url="acs-content-repository" version="5.2.0d2"/> <requires url="acs-kernel" version="5.2.0d2"/> <requires url="acs-tcl" version="5.2.0d1"/> Index: openacs-4/packages/bug-tracker/sql/oracle/bug-tracker-create-tables.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/oracle/bug-tracker-create-tables.sql,v diff -u -r1.2 -r1.2.8.1 --- openacs-4/packages/bug-tracker/sql/oracle/bug-tracker-create-tables.sql 28 Mar 2003 10:10:44 -0000 1.2 +++ openacs-4/packages/bug-tracker/sql/oracle/bug-tracker-create-tables.sql 7 Nov 2005 19:40:53 -0000 1.2.8.1 @@ -28,6 +28,9 @@ references cr_folders(folder_id), root_keyword_id integer constraint bt_projects_keyword_fk + references cr_keywords(keyword_id), + component_keyword_id integer + constraint bt_component_keyword_fk references cr_keywords(keyword_id) ); @@ -311,3 +314,17 @@ create index bt_patch_bug_map_patch_id_idx on bt_patch_bug_map(patch_id); create index bt_patch_bug_map_bug_id_idx on bt_patch_bug_map(bug_id); + +create table bt_keyword_component_map ( + keyword_id integer + constraint bt_component_keyword_fk + references cr_keywords(keyword_id), + component_id integer + constraint bt_patches_components_fk + references bt_components(component_id), + constraint bt_keyword_component_map_pk + primary key (keyword_id, component_id) +); + +create index bt_keyword_component_map_keyword_idx on bt_keyword_component_map(keyword_id); +create index bt_keyword_component_map_component_idx on bt_keyword_component_map(component_id); Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/sql/oracle/upgrade-1.4-1.4.1.sql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/sql/oracle/upgrade-1.5d1-1.5d2.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql,v diff -u -r1.15 -r1.15.2.1 --- openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql 30 Mar 2005 18:18:18 -0000 1.15 +++ openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-create.sql 7 Nov 2005 19:40:53 -0000 1.15.2.1 @@ -20,9 +20,14 @@ references cr_folders(folder_id), root_keyword_id integer constraint bt_projects_keyword_fk + references cr_keywords(keyword_id), + component_keyword_id integer + constraint bt_component_keyword_fk references cr_keywords(keyword_id) ); + +-- this function (bt_project__new) is deprecated since the project creation in handled as a TCL API create or replace function bt_project__new( integer -- package_id ) returns integer @@ -35,6 +40,7 @@ v_creation_ip varchar; v_folder_id integer; v_keyword_id integer; + v_component_keyword_id integer; begin select count(*) into v_count @@ -838,7 +844,20 @@ create index bt_patch_bug_map_patch_id_idx on bt_patch_bug_map(patch_id); create index bt_patch_bug_map_bug_id_idx on bt_patch_bug_map(bug_id); +create table bt_keyword_component_map ( + keyword_id integer + constraint bt_component_keyword_fk + references cr_keywords(keyword_id), + component_id integer + constraint bt_patches_components_fk + references bt_components(component_id), + constraint bt_keyword_component_map_pk + primary key (keyword_id, component_id) +); + +create index bt_keyword_component_map_keyword_idx on bt_keyword_component_map(keyword_id); +create index bt_keyword_component_map_component_idx on bt_keyword_component_map(component_id); + -- AutoSubmition functionality \i auto-error-report.sql - Index: openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-drop.sql,v diff -u -r1.8 -r1.8.2.1 --- openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-drop.sql 25 Feb 2005 17:08:11 -0000 1.8 +++ openacs-4/packages/bug-tracker/sql/postgresql/bug-tracker-drop.sql 7 Nov 2005 19:40:53 -0000 1.8.2.1 @@ -48,6 +48,7 @@ drop table bt_default_keywords; +drop table bt_keyword_component_map; drop table bt_components; drop table bt_versions; drop table bt_projects; Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/sql/postgresql/upgrade-1.4-1.4.1.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/bug-tracker/tcl/bug-tracker-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-tracker-procs.tcl,v diff -u -r1.32.2.1 -r1.32.2.2 --- openacs-4/packages/bug-tracker/tcl/bug-tracker-procs.tcl 22 Sep 2005 05:13:06 -0000 1.32.2.1 +++ openacs-4/packages/bug-tracker/tcl/bug-tracker-procs.tcl 7 Nov 2005 19:40:53 -0000 1.32.2.2 @@ -123,6 +123,7 @@ page:optional f_state:optional f_fix_for_version:optional + f_distribution:optional f_component:optional orderby:optional {format "table"} @@ -145,6 +146,7 @@ set export_vars { f_state f_fix_for_version + f_distribution f_component orderby format @@ -843,6 +845,30 @@ } +ad_proc bug_tracker::assignee_get_options { + -workflow_id + -include_unknown:boolean + -include_undecided:boolean +} { + Returns an option list containing all users that have submitted or assigned to a bug. + Used for the add bug form. Added because the workflow api requires a case_id. + (an item to evaluate is refactoring workflow to provide an assignee widget without a case_id) +} { + + set assignee_list [db_list_of_lists assignees {}] + + if { $include_unknown_p } { + set assignee_list [concat { { "Unknown" "" } } $assignee_list] + } + + if { $include_undecided_p } { + set assignee_list [concat { { "Undecided" "" } } $assignee_list] + } + + return $assignee_list +} + + ad_proc bug_tracker::versions_p { {-package_id ""} } { @@ -1376,3 +1402,12 @@ -package_id $package_id \ -workflow_id $workflow_id]] } + +ad_proc bug_tracker::get_component_keyword { + {-package_id:required} +} { + @param package_id The package (project) to select from +} { + return [db_string get_component_keyword { select component_keyword_id from bt_projects where project_id = :package_id }] +} + Index: openacs-4/packages/bug-tracker/tcl/bug-tracker-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-tracker-procs.xql,v diff -u -r1.6 -r1.6.2.1 --- openacs-4/packages/bug-tracker/tcl/bug-tracker-procs.xql 25 Feb 2005 17:08:11 -0000 1.6 +++ openacs-4/packages/bug-tracker/tcl/bug-tracker-procs.xql 7 Nov 2005 19:40:54 -0000 1.6.2.1 @@ -161,7 +161,6 @@ order by parent.heading, child.heading </querytext> </fullquery> - <fullquery name="bug_tracker::project_delete.min_bug_id"> <querytext> select min(bug_id) @@ -171,14 +170,14 @@ </fullquery> <fullquery name="bug_tracker::project_new.bt_projects_insert"> - <querytext> insert into bt_projects - (project_id, folder_id, root_keyword_id) + (project_id, folder_id, root_keyword_id, component_keyword_id) values - (:project_id, :folder_id, :keyword_id) + (:project_id, :folder_id, :keyword_id, :component_keyword_id) </querytext> </fullquery> + <fullquery name="bug_tracker::project_new.bt_components_insert"> <querytext> insert into bt_components Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/distro-component-add.adp'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/distro-component-add.tcl'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/distro-component-delete.tcl'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/distro-delete.tcl'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/distro-edit.adp'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/distro-edit.tcl'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/distros-oracle.xql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/distros-postgresql.xql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.1.4.1 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/distros.tcl'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/bug-tracker/www/admin/index.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/admin/index.adp,v diff -u -r1.8 -r1.8.2.1 --- openacs-4/packages/bug-tracker/www/admin/index.adp 20 Apr 2004 14:19:36 -0000 1.8 +++ openacs-4/packages/bug-tracker/www/admin/index.adp 7 Nov 2005 19:40:54 -0000 1.8.2.1 @@ -85,6 +85,17 @@ </tr> <tr bgcolor="#cccccc"> <td colspan="3"> + Distributions + </td> + <td align="center"> + <a href="distros"><img src="../graphics/Edit16.gif" width="16" height="16" border="0" alt="Edit"></a> + </td> + <td align="center"> + + </td> + </tr> + <tr bgcolor="#cccccc"> + <td colspan="3"> #bug-tracker.Permissions# </td> <td align="center">