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