public function postIndex(Request $request, $sid, $mode) { if ($mode == 'Delete') { // use DB facade to delete the row matching $sid \App\Salesperson::destroy($sid); $request->session()->flash('message', 'Employee ID ' . $request->input('employee_id') . ' Deleted'); } else { $this->validate($request, ['employeeID' => 'required|min:5', 'lastName' => 'required|min:2', 'firstName' => 'required|min:2', 'street1' => 'required|min:5', 'city' => 'required|min:2', 'state' => 'required|size:2', 'zipCode' => 'required', 'email' => 'email', 'hireDate' => 'required|date', 'terminationDate' => 'date']); // create a model and set the values, then session_save_path if ($mode == 'Edit') { // get the model from the db $salespeople = \App\Salesperson::where('id', '=', $sid)->get(); $salesperson = $salespeople->first(); } else { // instantiate a new model $salesperson = new \App\Salesperson(); } // now set the model attributes $salesperson->employee_id = $request->input('employeeID'); $salesperson->last_name = $request->input('lastName'); $salesperson->first_name = $request->input('firstName'); $salesperson->street1 = $request->input('street1'); $salesperson->street2 = $request->input('street2'); $salesperson->city = $request->input('city'); $salesperson->state = $request->input('state'); $salesperson->zip_code = $request->input('zipCode'); $salesperson->email = $request->input('email'); $salesperson->hire_date = $request->input('hireDate'); $salesperson->termination_date = $request->input('terminationDate'); if ($mode == 'Edit') { $salesperson->id = $sid; } $salesperson->save(); $request->session()->flash('message', 'Salesperson ID ' . $salesperson->employee_id . ' Updated / Added'); } $scol = $request->session()->get('scol'); $sord = $request->session()->get('sord'); $sord = $sord == 'A' ? 'D' : 'A'; $request->session()->put('sord', $sord); // need to refresh the salespeople collection after changes $salespeople = \App\Salesperson::orderBy('employee_id')->get(); // now put the collection in the session variable $request->session()->put('salespeople', $salespeople); // now direct to the sort route to retain the sort the user had before editing return redirect('salespeople/sort/' . $scol); }