/** * @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); }