public function downloadProjectWiseDetailedReport($sdate, $edate)
{
$timeEntryObj = new TimeEntry();
$timeEntries = $timeEntryObj->getProjectWiseDetailedReport($sdate, $edate);
Excel::create('Timesheet_ProjectWise_Detailed_Report_' . time(), function ($excel) use($timeEntries) {
//echo "ss<pre>";print_r($timeEntries);die;
$data = [];
foreach ($timeEntries as $entry) {
$data[] = ['Date' => $entry->createdDate, 'Project Name' => $entry->projectName, 'Client Name' => $entry->clientName, 'Time' => $entry->time, 'Total Time' => $entry->totalTime, 'Team' => $entry->team];
}
$excel->sheet('Sheet 1', function ($sheet) use($data) {
$last_row = count($data) + 1;
$sheet->fromArray($data);
foreach ($data as $k => $v) {
$row_num = $k + 2;
if (empty($v['Time'])) {
$sheet->row($row_num, function ($row) {
// call cell manipulation methods
$row->setBackground('#FFFF00');
});
$sheet->row($row_num, array($v['Date'], $v['Project Name'] . ' Total', $v['Client Name'], $v['Time'], $v['Total Time'], $v['Team']));
}
$sheet->row($last_row, array('', 'Total', '', '', $v['Total Time'], ''));
//Last row: total of all projects
$sheet->row($last_row, function ($row) {
// call cell manipulation methods
$row->setBackground('#0000FF');
});
}
});
})->download('xls');
}
