/**
* @return mixed
*/
public function getEmailDropsChart()
{
$dataTableRows = Emaildrop::select(DB::raw("DATE_FORMAT(created_at, '%Y-%m-%d') as Date, COUNT('id') AS Count"))->groupBy(DB::raw("DATE_FORMAT(created_at, '%Y-%m-%d')"))->orderby('Date', 'asc')->take(100)->get();
$dataTableColumns = [['date', 'Date'], ['number', 'Count']];
$name = 'emaildrops';
$title = 'Droped by custom rule';
$dateFormat = 'Y-m-d';
return (new Chart\LineChartController())->createLineChart($name, $title, $dataTableColumns, $dataTableRows, $dateFormat);
}
public function getEmailDropsData()
{
$emailDrops = Emaildrop::select(['id', 'created_at', 'recipient', 'sender', 'subject'])->orderby('id', 'desc')->limit(200)->get();
return Datatables::of($emailDrops)->editColumn('created_at', '{!! $created_at->diffForHumans() !!}')->editColumn('id', '<a href="{{ URL::secure(\'/admin/emaildrop\', $id)}}">{{$id}}</a>')->make(true);
}
