Last 30 days of CDR as CSV with FreePBX bootstrap

cdrcsv.php

#!/usr/bin/env php
<?php
if (!@include_once(getenv('FREEPBX_CONF') ? getenv('FREEPBX_CONF') : '/etc/freepbx.conf')) {
  include_once('/etc/asterisk/freepbx.conf');
}
$outfile = '/tmp/report.csv';
$dbh = \FreePBX::Database();
$sql = "SELECT * FROM asteriskcdrdb.cdr WHERE date(calldate) >= date(now()-interval 30 day);";
$stmt = $dbh->prepare($sql);
$stmt->execute();
$ret = $stmt->fetchAll(\PDO::FETCH_ASSOC);
$colnames = array_keys($ret[0]);
$csv = fopen($outfile,'w+');
fputcsv($csv,$colnames);
foreach($ret as $row){
  fputcsv($csv,$row);
}
fclose($csv);

Requires FreePBX 12 or higher