|
From: Benjamin C. <bc...@us...> - 2002-12-17 13:25:13
|
Update of /cvsroot/phpbt/phpbt/inc/db
In directory sc8-pr-cvs1:/tmp/cvs-serv12656/inc/db
Modified Files:
Tag: phpbt-0_9_0
pgsql.php
Log Message:
Fixes for bug #650899 - Cleanup queries
Index: pgsql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v
retrieving revision 1.20
retrieving revision 1.20.2.1
diff -u -r1.20 -r1.20.2.1
--- pgsql.php 30 Sep 2002 18:02:06 -0000 1.20
+++ pgsql.php 17 Dec 2002 13:25:10 -0000 1.20.2.1
@@ -146,7 +146,7 @@
'and b.component_id = component.component_id '.
'and b.project_id = project.project_id %s '.
'order by %s %s, bug_id asc',
- 'report-resbyeng-1' => 'select email as "Assigned To", '.
+ 'report-resbyeng-1' => 'select u.email as "Assigned To", '.
'sum(case when resolution_id = 0 then 1 else 0 end) as "Open"',
'report-resbyeng-2' => "select resolution_name, ",
'report-resbyeng-3' => "', sum(case when resolution_id = '",
@@ -157,13 +157,13 @@
'left join '.TBL_AUTH_USER.' u on assigned_to = user_id %s '.
'group by assigned_to, u.email',
'join-where' => 'where',
- 'admin-list-components' => 'select c.component_id, component_name, '.
- 'c.created_date, active, count(bug_id) as bug_count '.
+ 'admin-list-components' => 'select c.component_id, c.component_name, '.
+ 'c.created_date, c.active, count(bug_id) as bug_count '.
'from '.TBL_COMPONENT.' c left join '.TBL_BUG.' b using(component_id) '.
'where c.project_id = %s '.
'group by c.component_id, c.component_name, c.created_date, c.active',
- 'admin-list-versions' => 'select v.version_id, version_name, '.
- 'v.created_date, active, count(bug_id) as bug_count '.
+ 'admin-list-versions' => 'select v.version_id, v.version_name, '.
+ 'v.created_date, v.active, count(bug_id) as bug_count '.
'from '.TBL_VERSION.' v left join '.TBL_BUG.' b using(version_id) '.
'where v.project_id = %s '.
'group by v.version_id, v.version_name, v.created_date, v.active',
|