public function exportPdf($ids = null)
{
$ids = explode(',', substr($ids, 0, -1));
$ids = array_unique($ids);
$model = Room::whereIn('id', $ids)->where('user_id', \Auth::user()->id)->get(['nom_salle', 'capacite_salle']);
Excel::create('La liste des salles', function ($excel) use($model, $ids) {
$excel->sheet('La liste des salles', function ($sheet) use($model, $ids) {
$sheet->fromModel($model);
$sheet->setAllBorders('thin');
$sheet->setFontFamily('OpenSans');
$sheet->setFontSize(13);
$sheet->setFontBold(false);
$sheet->setAllBorders('thin');
for ($i = 1; $i <= count($ids) + 1; $i++) {
$sheet->setHeight($i, 25);
$sheet->row($i, function ($rows) {
$rows->setFontColor('#556b7b');
$rows->setAlignment('center');
});
$sheet->cells('A' . $i . ':' . 'B' . $i, function ($cells) {
$cells->setValignment('middle');
$cells->setFontColor('#556b7b');
$cells->setFont(array('family' => 'OpenSans', 'size' => '13', 'bold' => false));
});
}
// normal header
$sheet->cells('A1:B1', function ($cells) {
$cells->setBackground('#e9f1f3');
$cells->setFontColor('#556b7b');
$cells->setFont(array('family' => 'OpenSans', 'size' => '15', 'bold' => true));
});
$sheet->row(1, array('Salle', 'Capacité de la Salle'));
});
})->export('pdf');
}
/**
* @param Requests\TimeslotRequest $request
* @return \stdClass
*/
public function getFormInput(Requests\TimeslotRequest $request)
{
$input = new \stdClass();
$input->day = Day::find($request->get('day_id'));
$input->begin = Carbon::createFromFormat('d-m-Y H:i:s', $request->get('begin'));
$input->end = Carbon::createFromFormat('d-m-Y H:i:s', $request->get('end'));
$roomIds = array_flatten($request->get('rooms'));
$roomIds = array_map('intval', $roomIds);
$input->rooms = Room::whereIn('id', $roomIds)->get();
return $input;
}
