/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update($id) { $input = Input::all(); $rules = array('tool_name' => 'required', 'acc_name' => 'required', 'emp_id' => 'required', 'emp_name' => 'required', 'access' => 'required'); $messages = array('tool_name.required' => 'Tool Name is required !', 'emp_id.required' => 'Employee ID is required !', 'emp_name.required' => 'Employee Name is required !', 'access.required' => 'Please select an accesibility !'); $validation = Validator::make($input, $rules, $messages); if ($validation->passes()) { $toolname = Accounts::select('account_name')->where('id', '=', Input::get('acc_name'))->get(); foreach ($toolname as $key => $tool) { $accName = $tool->account_name; } $employees = Employee::where('emp_id', '=', $id)->select('tools.emp_id as id', 'tools.emp_name as emp_name', 'tools.acc_id as acc_id', 'tools.access as access', 'tools.tool_name as tool_name')->get(); $employees->emp_id = Input::get('emp_id'); $employees->emp_name = Input::get('emp_name'); $employees->acc_id = Input::get('acc_name'); $employees->tool_name = Input::get('tool_name'); $employees->access = Input::get('access'); //$employees->save(); DB::table('tools')->where('emp_id', $id)->update(array('emp_name' => $employees->emp_name, 'acc_id' => $employees->acc_id, 'tool_name' => $employees->tool_name, 'access' => $employees->access)); return Redirect::to('/employees'); } else { return Redirect::to('/employees/' . $id . '/edit')->withErrors($validation); } }