|
From: Ulf E. <ulf...@us...> - 2005-08-22 20:44:23
|
Update of /cvsroot/phpbt/phpbt In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv21276/phpbt Modified Files: include.php query.php Log Message: RFE #784058 - show number of comments, attachments and/or votes in buglist Index: include.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/include.php,v retrieving revision 1.137 retrieving revision 1.138 diff -u -r1.137 -r1.138 --- include.php 22 Aug 2005 20:30:56 -0000 1.137 +++ include.php 22 Aug 2005 20:44:16 -0000 1.138 @@ -109,7 +109,10 @@ 'component_name' => 'Component', 'os_name' => 'OS', 'browser_string' => 'Browser', - 'close_date' => 'Closed Date' + 'close_date' => 'Closed Date', + 'comments' => 'Comments', + 'attachments' => 'Attachments', + 'votes' => 'Votes' ); $default_db_fields = array('bug_id', 'title', 'reporter', 'owner', Index: query.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/query.php,v retrieving revision 1.104 retrieving revision 1.105 diff -u -r1.104 -r1.105 --- query.php 22 Aug 2005 20:40:08 -0000 1.104 +++ query.php 22 Aug 2005 20:44:16 -0000 1.105 @@ -298,7 +298,10 @@ 'component_name' => 'component.component_name', 'os_name' => 'os.os_name', 'browser_string' => 'browser_string', - 'close_date' => 'close_date' + 'close_date' => 'close_date', + 'comments' => 'count(distinct comment.comment_id) as comments', + 'attachments' => 'count(distinct attachment.attachment_id) as attachments', + 'votes' => 'count(distinct vote.user_id) as votes' ); $db_headers = array( @@ -324,7 +327,10 @@ 'site_name' => 'site.sort_order', 'browser_string' => 'browser_string', 'resolution_name' => 'resolution.sort_order', - 'close_date' => 'close_date' + 'close_date' => 'close_date', + 'comments' => 'comments', + 'attachments' => 'attachments', + 'votes' => 'votes' ); extract($_GET); @@ -348,7 +354,7 @@ $order = $_SESSION['queryinfo']['order']; $sort = $_SESSION['queryinfo']['sort']; } else { - $order = 'bug_id'; + $order = 'b.bug_id'; $sort = 'asc'; } } |