X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fview%2FStatus.html;h=2ddf7e5a0266ec305bdf157fff851553dc7b428b;hb=513af819159383f127a731934e4b7aff67a846b7;hp=8dddd144e128b0c6ae701c99335ce04acf42f6ea;hpb=f231eae341e7f438a1a1eea9f4ddad8f0a7b4fb7;p=freeside.git diff --git a/httemplate/view/Status.html b/httemplate/view/Status.html index 8dddd144e..2ddf7e5a0 100644 --- a/httemplate/view/Status.html +++ b/httemplate/view/Status.html @@ -106,11 +106,6 @@ if ( _is_running('cdrd') ) { $s. 's'; } - $status{'CDR Processing'} = [ - { 'title' => 'Current processing delay', - 'value' => $delay, - }, - ]; my $pr_delay = FS::Record->scalar_sql(' SELECT AVG(end_date-start_date) @@ -129,19 +124,21 @@ if ( _is_running('cdrd') ) { $s. 's'; } - $status{'CDR Processing'} = [ - { 'title' => 'Average billing time', - 'value' => $pr_delay, - }, - ]; - my $24ago = time2str('%Y-%m-$d %X', time - 86400); + my $dayago = time2str('%Y-%m-%d %X', time - 86400); my $cdrs = FS::Record->scalar_sql(qq{ SELECT COUNT(*) FROM cdr WHERE ( freesidestatus IS NULL OR freesidestatus = '' ) - AND calldate > '$24ago' + AND calldate > '$dayago' }); + $status{'CDR Processing'} = [ + { 'title' => 'Current processing delay', + 'value' => $delay, + }, + { 'title' => 'Average billing time', + 'value' => $pr_delay, + }, { 'title' => 'Unprocessed CDRs (last 24 hours)', 'value' => $cdrs, },