Index: openacs-4/packages/bug-tracker/www/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/index.tcl,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/bug-tracker/www/index.tcl 9 Dec 2002 21:24:22 -0000 1.12
+++ openacs-4/packages/bug-tracker/www/index.tcl 2 Jan 2003 17:21:49 -0000 1.13
@@ -170,19 +170,21 @@
# Get stats
#
-db_multirow -extend { name name_url } by_status by_status {
+db_multirow -extend { name name_url stat_name header } stats by_status {
select b.status as unique_id,
count(b.bug_id) as num_bugs
from bt_bugs b
where b.project_id = :package_id
group by unique_id
order by bt_bug__status_sort_order(b.status)
} {
- set name "[bug_tracker::status_pretty $unique_id] Bugs"
+ set header "All bugs by status:"
+ set stat_name "Status"
+ set name "[bug_tracker::status_pretty $unique_id]"
set name_url "?[export_vars { { filter.status $unique_id } }]"
}
-db_multirow -extend { name name_url stat_name } stats stats_by_bug_type {
+db_multirow -extend { name name_url stat_name header } -append stats stats_by_bug_type {
select b.bug_type as unique_id,
count(b.bug_id) as num_bugs
from bt_bugs b
@@ -191,12 +193,13 @@
group by unique_id
order by bt_bug__bug_type_sort_order(b.bug_type)
} {
+ set header "Open bugs summary:"
set stat_name "Type of bug"
set name [bug_tracker::bug_type_pretty $unique_id]
set name_url "?[export_vars { { filter.bug_type $unique_id } }]"
}
-db_multirow -extend { name_url stat_name } -append stats stats_by_fix_for_version {
+db_multirow -extend { name_url stat_name header } -append stats stats_by_fix_for_version {
select b.fix_for_version as unique_id,
v.version_name as name,
count(b.bug_id) as num_bugs
@@ -207,6 +210,7 @@
group by unique_id, v.anticipated_freeze_date, name
order by v.anticipated_freeze_date, name
} {
+ set header "Open bugs summary:"
set stat_name "Fix For"
if { [empty_string_p $unique_id] } {
set name "Undecided"
@@ -216,7 +220,7 @@
set stat_name_val "Severity"
-db_multirow -extend { name_url stat_name } -append stats stats_by_severity {
+db_multirow -extend { name_url stat_name header } -append stats stats_by_severity {
select b.severity as unique_id,
p.sort_order || ' - ' || p.severity_name as name,
count(b.bug_id) as num_bugs
@@ -227,13 +231,14 @@
group by unique_id, name
order by name
} {
+ set header "Open bugs summary:"
set stat_name $stat_name_val
set name_url "?[export_vars { { filter.severity $unique_id } }]"
}
set stat_name_val "Priority"
-db_multirow -extend { name_url stat_name } -append stats stats_by_priority {
+db_multirow -extend { name_url stat_name header } -append stats stats_by_priority {
select b.priority as unique_id,
p.sort_order || ' - ' || p.priority_name as name,
count(b.bug_id) as num_bugs
@@ -244,11 +249,12 @@
group by unique_id, name
order by name
} {
+ set header "Open bugs summary:"
set stat_name $stat_name_val
set name_url "?[export_vars { { filter.priority $unique_id } }]"
}
-db_multirow -extend { name_url stat_name } -append stats stats_by_assignee {
+db_multirow -extend { name_url stat_name header } -append stats stats_by_assignee {
select b.assignee as unique_id,
assignee.first_names || ' ' || assignee.last_name as name,
count(b.bug_id) as num_bugs
@@ -259,14 +265,15 @@
group by unique_id, name
order by name
} {
+ set header "Open bugs summary:"
set stat_name "Assigned To"
if { [empty_string_p $unique_id] } {
set name "Unassigned"
}
set name_url "?[export_vars -url { { filter.assignee $unique_id } }]"
}
-db_multirow -extend { name_url stat_name } -append stats stats_by_actionby {
+db_multirow -extend { name_url stat_name header } -append stats stats_by_actionby {
select o.creation_user as unique_id,
submitter.first_names || ' ' || submitter.last_name as name,
count(b.bug_id) as num_bugs
@@ -278,11 +285,12 @@
group by unique_id, name
order by name
} {
+ set header "Open bugs summary:"
set stat_name "To Be Verified By"
set name_url "?[export_vars -url { { filter.status resolved } { filter.actionby $unique_id } }]"
}
-db_multirow -extend { name_url stat_name } -append stats stats_by_component {
+db_multirow -extend { name_url stat_name header } -append stats stats_by_component {
select coalesce('com/'||c.url_name||'/', trim(to_char(c.component_id,'99999999'))) as unique_id,
c.component_name as name,
count(b.bug_id) as num_bugs
@@ -293,6 +301,7 @@
group by unique_id, name
order by name
} {
+ set header "Open bugs summary:"
set stat_name "Components"
if { [string match "com/*" $unique_id] } {
set name_url "[ad_conn package_url]$unique_id"