public function getExportselected($id, Request $request)
{
Session::set('exportrec', $id);
$excelnm = "menu_" . date("d-m-Y");
Excel::create($excelnm, function ($excel) {
$excel->sheet('menus', function ($sheet) {
$sheet->mergeCells('A1:W1');
$sheet->row(1, function ($row) {
$row->setFontFamily('Comic Sans MS');
$row->setFontSize(30);
});
$sheet->row(1, array('Menu Report'));
$sheet->row(2, function ($row) {
$row->setFontFamily('Comic Sans MS');
$row->setFontSize(15);
$row->setFontWeight('bold');
});
$sheet->row(2, array('Record Details'));
/* getting data to display - in my case only one record */
$ids = Session::get('exportrec');
$newdatas = explode(",", $ids);
$gdatalist = $this->menu_gestion->getallrecords($newdatas);
$dataArr = array();
if (is_array($gdatalist) && count($gdatalist) > 0) {
$counter = 0;
foreach ($gdatalist as $kyy => $dataval) {
$dataArr[$counter]['Sl'] = $counter + 1;
$dataArr[$counter]['Name'] = $dataval['name'];
$dataArr[$counter]['Slug'] = $dataval['menu_slug'];
$dataArr[$counter]['Date'] = $dataval['updated_at'];
$counter++;
}
}
/* setting column names for data - you can of course set it manually */
$sheet->appendRow(array_keys($dataArr[0]));
/* column names */
/* getting last row number (the one we already filled and setting it to bold */
$sheet->row($sheet->getHighestRow(), function ($row) {
$row->setFontWeight('bold');
});
/* putting users data as next rows */
foreach ($dataArr as $user) {
$sheet->appendRow($user);
}
});
})->export('xls');
}
