public function postStore()
{
$sid = \Input::get('id');
/*
* Validate
*/
$rules = array('email' => 'required|unique:mailinglists,email' . (isset($sid) ? ',' . $sid : ''), 'first_name' => 'required', 'last_name' => 'required');
$validation = \Validator::make(\Input::all(), $rules);
if ($validation->passes()) {
$email = \Input::get('email');
$first_name = \Input::get('first_name');
$last_name = \Input::get('last_name');
$active = \Input::get('active') == '' ? false : true;
$mailinglist = isset($sid) ? Mailinglist::find($sid) : new Mailinglist();
// No such id
if ($mailinglist == null) {
$errors = new \Illuminate\Support\MessageBag();
$errors->add('storeError', "We are having problem editing this entry. It may have already been deleted.");
return redirect('admin/mailinglists')->withErrors($errors);
}
$mailinglist->email = $email;
$mailinglist->first_name = $first_name;
$mailinglist->last_name = $last_name;
$mailinglist->active = $active;
$mailinglist->save();
} else {
if (isset($sid)) {
return redirect('admin/mailinglists/edit/' . $sid)->withErrors($validation)->withInput();
} else {
return redirect('admin/mailinglists/create')->withErrors($validation)->withInput();
}
}
return redirect('admin/mailinglists');
}
public function postMailinglist()
{
$input_start_date = \Input::get('start_date');
if ($input_start_date == "") {
$input_start_date = "01/01/1900";
}
$start_date = \DateTime::createFromFormat('d/m/Y', $input_start_date);
$input_end_date = \Input::get('end_date');
if ($input_end_date == "") {
$end_date = new \DateTime("NOW");
} else {
$end_date = \DateTime::createFromFormat('d/m/Y', $input_end_date);
}
$data = Mailinglist::where('updated_at', '>=', $start_date)->where('updated_at', '<=', $end_date)->orderBy('email')->get();
if (count($data) == 0) {
$errors = new \Illuminate\Support\MessageBag();
$errors->add('downloadError', "There's no data within the dates specified.");
return \Redirect::to('admin/mailinglists')->withErrors($errors);
}
\Excel::create('Redmin_Mailinglist_Report', function ($excel) use($data) {
$excel->sheet('Mailinglist Report', function ($sheet) use($data) {
$sheet->loadView('redminportal::reports/mailinglist')->with('data', $data);
});
})->download('csv');
}
public function getDelete($sid)
{
// Find the mailinglist using the user id
$mailinglist = Mailinglist::find($sid);
// Delete the mailinglist
if ($mailinglist == null) {
$errors = new \Illuminate\Support\MessageBag();
$errors->add('deleteError', "We are having problem deleting this entry. It may have already been deleted.");
return redirect('admin/mailinglists')->withErrors($errors);
}
$mailinglist->delete();
return redirect('admin/mailinglists');
}
