X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/9af5722a81d1999243ac3a3d51d3cf3c3256d86a..ebadc5e4019929d4e1686516160ee01a114d9b8a:/WEB-INF/lib/ttChartHelper.class.php diff --git a/WEB-INF/lib/ttChartHelper.class.php b/WEB-INF/lib/ttChartHelper.class.php index 7a4d2584..528fcdb0 100644 --- a/WEB-INF/lib/ttChartHelper.class.php +++ b/WEB-INF/lib/ttChartHelper.class.php @@ -77,7 +77,7 @@ class ttChartHelper { where l.status = 1 and l.duration > 0 and l.user_id = $user_id $q_period group by l.task_id"; } elseif (CHART_CLIENTS == $chart_type) { // Data for clients. - $sql = "select coalesce(c.name, 'NULL') as name, sum(time_to_sec(l.duration)) as time from tt_log l + $sql = "select c.name as name, sum(time_to_sec(l.duration)) as time from tt_log l left join tt_clients c on (c.id = l.client_id) where l.status = 1 and l.duration > 0 and l.user_id = $user_id $q_period group by l.client_id"; }