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));
}
