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