/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(RolesRequest $request) { $role = new UserRole(); $role->name = $request['name']; $slug = preg_replace('/\\s+/', '-', $request['name']); $role->slug = $slug; $role->created_by = \Auth::user()->id; $role->save(); \Session::flash('success', 'well done! Role ' . $request['name'] . ' has been successfully added!'); return redirect()->back(); }
/** * Create a new user instance after a valid registration. * * @param array $data * @return User */ public function create(array $data) { User::unguard(); $user = User::create(['name' => $data['name'], 'email' => $data['email'], 'phone' => $data['phone'], 'password' => bcrypt($data['password'])]); User::reguard(); $role = new UserRole(); $role->user_id = $user->id; $role->role_id = 2; $role->save(); /** * Send a welcome message */ $message = "Hi " . $data['name'] . ". Your account has been activated. Have a good day"; send_message($data['phone'], $message); /** * Send email for account creation */ Mail::send('emails.register', compact('user'), function ($message) use($user) { $message->from(get_option('sent_from'), get_option('app')); $message->to($user->email, $user->name)->subject(get_option('app') . ' Registration Successful'); }); return $user; }
/** * Show the form for creating a new resource. * * @return Response */ public function create(Request $request) { if ($request->method() == 'POST') { $this->validate($request, $this->user_rule); $user = $request->except('_token', 'confirm_password', 'roles'); $user['password'] = bcrypt($request->input('password')); $user['created_at'] = current_time(); $user['phone'] = remove_symbols($request->input('phone')); User::unguard(); $addUser = User::create($user); User::reguard(); if ($addUser) { $role = new UserRole(); $role->user_id = $addUser->id; $role->role_id = $request->input('roles'); $role->save(); return redirect()->back()->with('success', 'New user added'); } else { return redirect()->back()->with('error', 'Failed to add user'); } } else { return view('backend.users.add'); } }
/** * Imports users and creates roles based on addition data in that row. * * @return void */ public function importInfinityRolesAndBoards() { # BORROW SEEDERS require base_path() . "/database/seeds/OptionSeeder.php"; require base_path() . "/database/seeds/PermissionSeeder.php"; require base_path() . "/database/seeds/RoleSeeder.php"; # DESTROY SEQUENCE if (DB::connection() instanceof \Illuminate\Database\PostgresConnection) { $this->comment("\tDropping role sequence."); DB::statement("DROP SEQUENCE IF EXISTS roles_role_id_seq CASCADE;"); } $PermissionSeeder = new \PermissionSeeder(); $PermissionSeeder->setCommand($this); $PermissionSeeder->run(); $PermissionGroupSeeder = new \PermissionGroupSeeder(); $PermissionGroupSeeder->setCommand($this); $PermissionGroupSeeder->run(); $OptionSeeder = new \OptionSeeder(); $OptionSeeder->setCommand($this); $OptionSeeder->run(); $OptionGroupSeeder = new \OptionGroupSeeder(); $OptionGroupSeeder->setCommand($this); $OptionGroupSeeder->run(); $RoleSeeder = new \RoleSeeder(); $RoleSeeder->setCommand($this); $RoleSeeder->runMaster(); $RolePermissionSeeder = new \RolePermissionSeeder(); $RolePermissionSeeder->setCommand($this); $RolePermissionSeeder->run(); \Artisan::call('cache:clear'); # REPAIR SEQUENCE if (DB::connection() instanceof \Illuminate\Database\PostgresConnection) { $this->comment("\tCreating role_id sequence again."); DB::statement("CREATE SEQUENCE roles_role_id_seq;"); $pgSeqNext = DB::table('roles')->select(DB::raw("(MAX(\"role_id\") + 1) AS next"))->pluck("next"); DB::statement("ALTER SEQUENCE roles_role_id_seq OWNED BY \"roles\".\"role_id\" RESTART WITH {$pgSeqNext};"); DB::statement("ALTER TABLE roles ALTER COLUMN role_id SET DEFAULT nextval('roles_role_id_seq');"); } # THEIR TABLES $tBoardsTable = $this->tcon->table("boards")->join('board_create', 'boards.uri', '=', 'board_create.uri')->select('boards.*', 'board_create.time'); $tModsTable = $this->tcon->table("mods"); # BEGIN USER IMPORT $this->info("\tImporting Users ..."); $userAdmin = null; $userBoardRelationships = []; $usersImported = 0; $tModsTable->chunk(100, function ($mods) use(&$userAdmin, &$userBoardRelationships, &$usersImported) { $this->line("\t\tHandling 100 users ..."); foreach ($mods as $mod) { # CREATE USER $user = new User(['username' => $mod->username, 'email' => property_exists($mod, "email") ? $mod->email ?: null : null, 'password' => null, 'password_legacy' => json_encode(['hasher' => "Vichan", 'hash' => $mod->password, 'salt' => $mod->salt])]); // 8chan has an issue with duplicates. try { $saved = $user->save(); } catch (\Exception $e) { $saved = false; } if ($saved) { ++$usersImported; # REMEMBER ROLES if ($mod->boards) { // TODO // Pull these values from config when formal importer created. switch ($mod->type) { // Janitor (Disabled) case 10: // Disabled // Disabled case 99: $this->comment("\t\tMod {$user->username} is disabled."); break; // Board volunteer // Board volunteer case 19: // Board owner // Board owner case 20: if (!isset($userBoardRelationships[$mod->boards])) { $userBoardRelationships[$mod->boards] = []; } $userBoardRelationships[$mod->boards][$user->user_id] = $mod->type; break; // Global volunteer // Global volunteer case 25: $this->comment("\t\tSetting {$user->username} to Global Mod."); $user->roles()->attach(Role::ID_MODERATOR); break; // Admin // Admin case 30: $this->comment("\t\tSetting {$user->username} to Global Admin."); $user->roles()->attach(Role::ID_ADMIN); $userAdmin = $userAdmin ?: $user; break; // Not identified! // Not identified! default: $this->error("\t\tMod {$user->username} has invalid mod type {$mod->type}."); break; } } } } }); $this->info("\tImported {$usersImported} users(s)."); if (!$userAdmin) { $this->comment("\tFailed to import an admin. This may cause problems."); } unset($mods, $mod, $user); # BEGIN BOARD IMPORT $this->info("\tImporting Boards ..."); $boardsImported = 0; $tBoardsTable->chunk(100, function ($boards) use(&$boardsImported, $userAdmin, $userBoardRelationships) { $this->line("\t\tHandling 100 boards ..."); foreach ($boards as $tBoard) { // We have an array like [board_uri => [ user_id => user_role ]] in the user import. // This fetches the first key of the biggest item. $boardOwner = []; if (isset($userBoardRelationships[$tBoard->uri])) { $boardOwner = array_keys($userBoardRelationships[$tBoard->uri], max($userBoardRelationships[$tBoard->uri])); } // Or it defaults to our admin. if (!isset($boardOwner[0])) { $this->comment("\t\t/{$tBoard->uri}/ has no known owner, assuming it is {$userAdmin->username}."); $boardOwner = $userAdmin->user_id; } else { $boardOwner = isset($boardOwner) ? $boardOwner[0] : $userAdmin->user_id; } $hBoard = new Board(['board_uri' => $tBoard->uri, 'title' => $tBoard->title, 'description' => $tBoard->subtitle, 'created_at' => new Carbon($tBoard->time), 'created_by' => $boardOwner, 'operated_by' => $boardOwner, 'posts_total' => $tBoard->posts_total, 'is_indexed' => !!$tBoard->indexed, 'is_overboard' => !!$tBoard->indexed, 'is_worksafe' => !!$tBoard->sfw]); if ($hBoard->save()) { ++$boardsImported; if (!$tBoard->public_bans || !$tBoard->public_logs || $tBoard->public_logs == 2) { $role = Role::getAnonymousRoleForBoard($hBoard); $perms = []; if (!$tBoard->public_bans) { $perms[] = ['permission_id' => "board.bans", 'value' => false]; } if (!$tBoard->public_logs || $tBoard->public_logs == 2) { $perms[] = ['permission_id' => "board.logs", 'value' => false]; } $role->permissionAssignments()->createMany($perms); } } else { $this->error("Failed to save /{$hBoard->board_uri}/."); } } }); $this->info("\tImported {$boardsImported} board(s)."); unset($boards, $tBoard, $hBoard); # BEGIN ROLE CONFIGURATION $this->info("\tCreating roles ..."); $roleBoardVols = 0; $roleBoardOwners = 0; $roleBoardSkips = 0; // Okay, so apparently sometimes there are users that own boards that don't exist. // We cannot crate roles for these boards, so lets prune useless data. $boardsWeCareAbout = Board::select('board_uri')->whereIn('board_uri', array_keys($userBoardRelationships))->get()->pluck('board_uri'); if ($boardsWeCareAbout->count() != count($userBoardRelationships)) { $this->comment("\t\tThere are " . (count($userBoardRelationships) - $boardsWeCareAbout->count()) . " board(s) which users own that do not exist!"); } foreach ($boardsWeCareAbout as $board) { $ownerRole = null; $janitorRole = null; $roles = $userBoardRelationships[$board]; foreach ($roles as $mod => $role) { // TODO // Pull these values from config when formal importer created. switch ($role) { // Board volunteer case 19: $janitorRole = $janitorRole ?: Role::getJanitorRoleForBoard($board); $userRole = new UserRole(['user_id' => $mod, 'role_id' => $janitorRole->role_id]); if ($userRole->save()) { ++$roleBoardVols; } break; // Board owner // Board owner case 20: $ownerRole = $ownerRole ?: Role::getOwnerRoleForBoard($board); $userRole = new UserRole(['user_id' => $mod, 'role_id' => $ownerRole->role_id]); if ($userRole->save()) { ++$roleBoardOwners; } break; default: $this->line("\t\tI don't know what to do with role {$role} for user id {$mod} in {$board}."); break; } } } $this->info("\t\tCreated {$roleBoardOwners} owner(s) and {$roleBoardVols} janitor(s) "); $this->info("\t\tPulled roles from " . count($userBoardRelationships) . " boards with relationships."); unset($board, $roles, $mod, $role, $userRole, $janitorRole, $ownerRole); }
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(UpdateUserRequest $request, $id) { $user = User::findOrFail($id); $new_user_roles = $request->get('roles'); if (sizeof($new_user_roles)) { $user->detachAllRoles(); foreach ($new_user_roles as $nur) { $new_user_role = new UserRole(); $new_user_role->role_id = $nur; $new_user_role->user_id = $id; $new_user_role->save(); } } $user->fill($request->all()); $user->save(); return \Redirect::route('admin.users.index'); }