public function run() { $detalle_usuarios = [['id_rol' => 1, 'id' => 1], ['id_rol' => 4, 'id' => 1]]; foreach ($detalle_usuarios as $detalle) { DetalleUsuario::create($detalle); } }
protected function getRole($user) { $result = DetalleUsuario::join('roles', function ($join) { $join->on('detalle_usuario.id_rol', '=', 'roles.id_rol'); })->where('detalle_usuario.id', $user->id)->get(['roles.abbr']); $rolkind = ''; foreach ($result as $rol) { $rolkind = $rol->abbr; break; } return $rolkind; }
/** * @param Request $request * @return $this|\Illuminate\Http\RedirectResponse */ public function store(Request $request) { $validator = Validator::make($request->all(), ['name' => 'required', 'username' => 'required|min:8', 'email' => 'required|email', 'sex' => 'required', 'password' => 'required|same:password_confirmation', 'password_confirmation' => 'required', 'roles' => 'required', 'departamento' => 'required']); if ($validator->fails()) { return redirect(route('newindex'))->withErrors($validator)->withInput(); } $isError = false; try { DB::beginTransaction(); $user = new Users(); $user->name = $request->name; $user->username = $request->username; $user->email = $request->email; $user->sex = $request->sex; $user->password = Hash::make($request->password); $user->id_departamento = $request->departamento; $user->save(); foreach ($request->roles as $rol) { $role = new DetalleUsuario(); $role->id_rol = $rol; $role->id = $user->id; $role->save(); } DB::commit(); } catch (\Exception $e) { $isError = true; \Debugbar::addException($e); DB::rollBack(); } if ($isError) { session()->flash('danger', 'Error al crear usuario'); return back(); } else { session()->flash('success', 'El usuario fue guardado exitosamente'); return back(); } }