public function downloadReport() { Excel::create('Timesheet_Report_' . time(), function ($excel) { $timeEntryObj = new TimeEntry(); $timeEntries = $timeEntryObj->getManagerTrackerReport(); $data = []; foreach ($timeEntries as $entry) { $data[] = ['date' => Carbon::parse($entry->created_at)->toDateString(), 'description' => $entry->description, 'time' => $entry->time, 'username' => $entry->username, 'projectName' => $entry->projectName, 'clientName' => $entry->clientName, 'tags' => $entry->tags]; } $excel->sheet('Sheet 1', function ($sheet) use($data) { $sheet->fromArray($data); }); })->download('xls'); }
/** * * @param Request $request * @return mixed */ public function getFilterReport(Request $request) { $timeEntryObj = new TimeEntry(); return $timeEntryObj->getManagerTrackerReport(); }