$s. 's';
}
- $status{'CDR Processing'} = [
- { 'title' => 'Current processing delay',
- 'value' => $delay,
- },
- ];
my $pr_delay = FS::Record->scalar_sql('
SELECT AVG(end_date-start_date)
$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,
},