X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fview%2FStatus.html;h=2ddf7e5a0266ec305bdf157fff851553dc7b428b;hb=b57377d091b08fe8874d362d885361cc8380ca69;hp=6b1cc6de206699c3abb633382e3538fda0c006d3;hpb=1183e25b1f1da42774fb8d51f9f6b808ef7fad2b;p=freeside.git diff --git a/httemplate/view/Status.html b/httemplate/view/Status.html index 6b1cc6de2..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,20 +124,22 @@ 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' => 'Unprocessed CDRs', + { 'title' => 'Current processing delay', + 'value' => $delay, + }, + { 'title' => 'Average billing time', + 'value' => $pr_delay, + }, + { 'title' => 'Unprocessed CDRs (last 24 hours)', 'value' => $cdrs, }, ];