public function isUniqueSlug($slug) { $notes = Note::all(); foreach ($notes as $note) { if ($note->slug == $slug) { return false; } } return true; }
echo $_SERVER['HTTP_X_FORWARDED_PROTO']; ?> <br/> PERMISSIONS: <?php echo $_SERVER['HTTP_X_SANDSTORM_PERMISSIONS']; ?> <br/> <br/> Amount of users: <?php echo User::all()->count(); ?> <br/> Amount of notebooks: <?php echo Notebook::all()->count(); ?> <br/> Amount of tags: <?php echo Tag::all()->count(); ?> <br/> Amount of notes: <?php echo Note::all()->count(); ?> <br/> <br/> Amount of Init Steps: <?php echo DB::table('migrations')->where('batch', '=', 1)->count(); ?> <br/> </p>
public function destroy() { $id = Auth::user()->id; $usertodelete = User::find($id); $usernotes = DB::table('notes')->where('user_id', $id); $allnotes = Note::all(); $allsheets = Sheet::all(); $allmeetups = Meetup::all(); $usermeetups = DB::table('meetups')->where('admin_id', $id); $userattending = DB::table('attendees')->where('attendee_id', $id); $usercomments = DB::table('meetcoms')->where('attendee_id', $id); $usernotecomments = DB::table('notecoms')->where('collaborator_id', $id); $usersheetcomments = DB::table('sheetcoms')->where('collaborator_id', $id); $sheetids = []; $meetupids = []; $noteids = []; $usercomments->delete(); $usernotecomments->delete(); $usersheetcomments->delete(); // Collects all notes that the user has made foreach ($allnotes as $note) { if ($note->user_id == $id) { array_push($noteids, $note->id); } } // Deletes all collaborators from any notes the user has made foreach ($noteids as $notes) { $othernotecom = DB::table('notecoms')->where('note_id', $note); $othernotecom->delete(); } // Collects all sheets that the user has made foreach ($allsheets as $sheet) { if ($sheet->user_id == $id) { array_push($sheetids, $sheet->id); } } // deletes all lines and collaboration from others in every sheet the user has made foreach ($sheetids as $sheets) { $userline = DB::table('lines')->where('sheet_id', $sheets); $othersheetcom = DB::table('sheetcoms')->where('sheet_id', $sheets); $userline->delete(); $othersheetcom->delete(); } // Collects all meetups that the user is the admin of foreach ($allmeetups as $meetup) { if ($meetup->admin_id == $id) { array_push($meetupids, $meetup->id); } } // Removes all attendees from all meetups that the user is a part of. foreach ($meetupids as $meetups) { $peopleattending = DB::table('attendees')->where('meetup_id', $meetups); $peopleattending->delete(); } $userattending->delete(); $usernotes->delete(); $userssheets = DB::table('sheets')->where('user_id', $id); $userssheets->delete(); $usermeetups->delete(); $usertodelete->delete(); Session::flash('successMessage', 'Goodbye Forever'); return Redirect::action('UsersController@showlogin'); }
public function checkSandstormUsers() { if (Config::get('paperwork.emergency_export') && DB::table('migrations')->where('batch', '=', 1)->count() == Config::get('paperwork.emergency_export_count')) { $credentials = ["username" => "sandstorm_dummy", "password" => "sandstorm_dummy"]; if (Auth::attempt($credentials)) { $settings = Setting::where('user_id', '=', Auth::user()->id)->first(); Session::put('ui_language', $settings->ui_language); return View::make('user.emergency_export'); } } else { // get permission via HTTP_X_SANDSTORM header $sandstorm_permissions = $_SERVER['HTTP_X_SANDSTORM_PERMISSIONS']; // Only when we are admin, we check and create users if ($sandstorm_permissions == "admin,write,read") { // check for admin user if (User::where('username', '=', 'sandstorm_admin')->count() == 0) { $sandstorm_admin = User::create(Input::except('_token', 'password_confirmation', 'ui_language')); if ($sandstorm_admin) { //make the first user an admin $sandstorm_admin->firstname = "sandstorm_admin"; $sandstorm_admin->lastname = " "; $sandstorm_admin->username = "******"; $sandstorm_admin->password = "******"; $sandstorm_admin->is_admin = 1; $sandstorm_admin->save(); $setting_sandstorm_admin = Setting::create(['ui_language' => 'en', 'user_id' => $sandstorm_admin->id]); } } else { $sandstorm_admin = User::where('username', '=', 'sandstorm_admin'); } // Then the read & write user if (User::where('username', '=', 'sandstorm_readwrite')->count() == 0) { $sandstorm_readwrite = User::create(Input::except('_token', 'password_confirmation', 'ui_language')); if ($sandstorm_readwrite) { $sandstorm_readwrite->firstname = "sandstorm_readwrite"; $sandstorm_readwrite->lastname = " "; $sandstorm_readwrite->username = "******"; $sandstorm_readwrite->password = "******"; $sandstorm_readwrite->save(); $setting_sandstorm_readwrite = Setting::create(['ui_language' => 'en', 'user_id' => $sandstorm_readwrite->id]); } } else { $sandstorm_readwrite = User::where('username', '=', 'sandstorm_readwrite'); } // Then the read only user if (User::where('username', '=', 'sandstorm_readonly')->count() == 0) { $sandstorm_readonly = User::create(Input::except('_token', 'password_confirmation', 'ui_language')); if ($sandstorm_readonly) { $sandstorm_readonly->firstname = "sandstorm_readonly"; $sandstorm_readonly->lastname = " "; $sandstorm_readonly->username = "******"; $sandstorm_readonly->password = "******"; $sandstorm_readonly->save(); $setting_sandstorm_readonly = Setting::create(['ui_language' => 'en', 'user_id' => $sandstorm_readonly->id]); } } else { $sandstorm_readonly = User::where('username', '=', 'sandstorm_readonly'); } } // Now that the required users are there we create the default if (Notebook::all()->count() == 0 && Tag::all()->count() == 0 && Note::all()->count() == 0) { // Notebook ... $notebookCreate = new Notebook(); $notebookCreate->title = Lang::get('notebooks.welcome_notebook_title'); $notebookCreate->save(); $notebookCreate->users()->attach($sandstorm_readonly->id, ['umask' => PaperworkHelpers::UMASK_READONLY]); $notebookCreate->users()->attach($sandstorm_readwrite->id, ['umask' => PaperworkHelpers::UMASK_READWRITE]); $notebookCreate->users()->attach($sandstorm_admin->id, ['umask' => PaperworkHelpers::UMASK_OWNER]); // Tag ... $tagCreate = new Tag(); $tagCreate->title = Lang::get('notebooks.welcome_note_tag'); $tagCreate->visibility = 1; $tagCreate->user_id = $sandstorm_admin->id; $tagCreate->save(); // Note ... $noteCreate = new Note(); $versionCreate = new Version(['title' => Lang::get('notebooks.welcome_note_title'), 'content' => Lang::get('notebooks.welcome_note_content'), 'content_preview' => mb_substr(strip_tags(Lang::get('notebooks.welcome_note_content')), 0, 255), 'user_id' => $sandstorm_admin->id]); $versionCreate->save(); $noteCreate->version()->associate($versionCreate); $noteCreate->notebook_id = $notebookCreate->id; $noteCreate->save(); $noteCreate->users()->attach($sandstorm_readonly->id, ['umask' => PaperworkHelpers::UMASK_READONLY]); $noteCreate->users()->attach($sandstorm_readwrite->id, ['umask' => PaperworkHelpers::UMASK_READWRITE]); $noteCreate->users()->attach($sandstorm_admin->id, ['umask' => PaperworkHelpers::UMASK_OWNER]); $noteCreate->tags()->sync([$tagCreate->id]); } // login if ($sandstorm_permissions == "read") { $credentials = ["username" => "sandstorm_readonly", "password" => "sandstorm_readonly"]; } if ($sandstorm_permissions == "write,read") { $credentials = ["username" => "sandstorm_readwrite", "password" => "sandstorm_readwrite"]; } if ($sandstorm_permissions == "admin,write,read") { $credentials = ["username" => "sandstorm_admin", "password" => "sandstorm_admin"]; } if (Auth::attempt($credentials)) { $settings = Setting::where('user_id', '=', Auth::user()->id)->first(); Session::put('ui_language', $settings->ui_language); return Redirect::route("/"); } } }
/** * Display a listing of the resource. * * @return Response */ public function index() { $notes1 = Note::all(); return View::make('notes.index')->with('notes', $notes1); }
/** * Display a listing of notes * * @return Response */ public function index() { $notes = Note::all(); return View::make('notes.index', compact('notes')); }