public function lists() { $user = Sentry::getUser(); $lists = Addressbook::with('subscribers')->orderBy('id', 'desc')->get(); return View::make('dashboard.lists', array('user' => $user, 'lists' => $lists)); }
public function export_list_csv($id) { $list = Addressbook::with(array('subscribers' => function ($query) { $query->orderBy('first_name', 'asc'); }))->find($id); $file_name = date('Y_m_d_H_i') . '_' . $list->name . '_list' . '.csv'; $file = fopen('exports/' . $file_name, 'w'); $field_names = false; foreach ($list->subscribers as $row) { if (!$field_names) { $allkeys = array_keys($row->toArray()); $trimmedkeys = array_slice($allkeys, 0, 7); fputcsv($file, $trimmedkeys); $field_names = true; } $allvalues = array_values($row->toArray()); $trimmedvalues = array_slice($allvalues, 0, 7); fputcsv($file, $trimmedvalues); } fclose($file); $path = 'exports/' . $file_name; return Redirect::to($path); //Response::json(array('file' => $path)); }