Advertisement
Guest User

Untitled

a guest
Mar 20th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.08 KB | None | 0 0
  1. public function export($id)
  2. {
  3.     $headers = array(
  4.         "Content-type" => "text/csv",
  5.         "Content-Disposition" => "attachment; filename=file.csv",
  6.         "Pragma" => "no-cache",
  7.         "Cache-Control" => "must-revalidate, post-check=0, pre-check=0",
  8.         "Expires" => "0"
  9.     );
  10.  if (Repas::where('numsem', $id)->exists()) {
  11.             $repasdelasem = Repas::where('numsem', $id)->first();
  12.             $idsem = $repasdelasem->numsem;
  13.             $repas = Repas::where('numsem', $idsem)->get();
  14.     $columns = array('Jour', 'Date', 'Petit Dejeuner', 'Collation matin ', 'Dejeuner', 'Gouter', 'Diner');
  15.  
  16.     $callback = function() use ($repas, $columns)
  17.     {
  18.         $file = fopen('php://output', 'w');
  19.         fputcsv($file, $columns);
  20.  
  21.         foreach($repas as $repasjour) {
  22.          
  23.             fputcsv($file, array($repasdujour->jour, $repasdujour->date, $repasdujour->petitdej, $repasdujour->colmat, $repasdujour->dejeune, $repasdujour->gouter, $repasdujour->diner ));
  24.         }
  25.         fclose($file);
  26.     };
  27. }
  28.     return Response::stream($callback, 200, $headers);
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement