From 571b41a53adbdb3777c209b83b7670aafad493e1 Mon Sep 17 00:00:00 2001 From: "lpsolit%gmail.com" <> Date: Thu, 22 Dec 2005 02:45:14 +0000 Subject: [PATCH] =?utf8?q?Bug=20320291:=20[PostgreSQL]=20The=20'percentage?= =?utf8?q?=20complete'=20column=20cannot=20be=20displayed=20-=20Patch=20by?= =?utf8?q?=20Fr=C3=A9d=C3=A9ric=20Buclin=20=20r=3Djoel?= =?utf8?q?=20a=3Djustdave?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- buglist.cgi | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/buglist.cgi b/buglist.cgi index 0c70a88546..f41f683191 100755 --- a/buglist.cgi +++ b/buglist.cgi @@ -527,7 +527,13 @@ DefineColumn("keywords" , "bugs.keywords" , "Keywords" DefineColumn("estimated_time" , "bugs.estimated_time" , "Estimated Hours" ); DefineColumn("remaining_time" , "bugs.remaining_time" , "Remaining Hours" ); DefineColumn("actual_time" , "(SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id)) AS actual_time", "Actual Hours"); -DefineColumn("percentage_complete","(100*((SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id))/((SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id))+bugs.remaining_time))) AS percentage_complete", "% Complete"); +DefineColumn("percentage_complete", + "(CASE WHEN (SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id)) " . + " + bugs.remaining_time = 0.0 " . + "THEN 0.0 " . + "ELSE 100*((SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id)) " . + " /((SUM(ldtime.work_time)*COUNT(DISTINCT ldtime.bug_when)/COUNT(bugs.bug_id)) + bugs.remaining_time)) " . + "END) AS percentage_complete" , "% Complete"); DefineColumn("relevance" , "relevance" , "Relevance" ); DefineColumn("deadline" , $dbh->sql_date_format('bugs.deadline', '%Y-%m-%d') . " AS deadline", "Deadline"); -- 2.47.2