Esempio n. 1
0
 /**
  * Get the position within a discussion where a post with a certain number
  * is. If the post with that number does not exist, the index of the
  * closest post to it will be returned.
  *
  * @param  integer  $discussionId
  * @param  integer  $number
  * @param  \Flarum\Core\Models\User|null  $user
  * @return integer
  */
 public function getIndexForNumber($discussionId, $number, User $user = null)
 {
     $query = Post::where('discussion_id', $discussionId)->where('time', '<', function ($query) use($discussionId, $number) {
         $query->select('time')->from('posts')->where('discussion_id', $discussionId)->whereNotNull('number')->take(1)->orderByRaw('ABS(CAST(number AS SIGNED) - ' . (int) $number . ')');
     });
     return $this->scopeVisibleForUser($query, $user)->count();
 }
Esempio n. 2
0
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     Discussion::unguard();
     Post::unguard();
     $faker = \Faker\Factory::create();
     $users = User::count();
     for ($i = 0; $i < 100; $i++) {
         $posts_count = $i == 1 ? 400 : rand(1, rand(1, rand(1, 100)));
         $discussion = Discussion::create(['title' => str_replace("'", '', rtrim($faker->realText(rand(20, 80)), '.')), 'start_time' => $faker->dateTimeThisYear, 'start_user_id' => rand(1, $users)]);
         $discussion->comments_count = $posts_count;
         $post = CommentPost::create(['discussion_id' => $discussion->id, 'number' => 1, 'time' => $discussion->start_time, 'user_id' => $discussion->start_user_id, 'content' => $faker->realText(rand(100, 1000))]);
         $discussion->start_post_id = $post->id;
         $discussion->last_time = $post->time;
         $discussion->last_user_id = $post->user_id;
         $discussion->last_post_id = $post->id;
         $discussion->last_post_number = $post->number;
         $discussion->number_index = $post->number;
         $lastPost = null;
         $count = $posts_count;
         $posts = [];
         $startTime = $discussion->start_time;
         $numberOffset = 0;
         for ($j = 0; $j < $count - 1; $j++) {
             if (rand(1, 100) == 1) {
                 $discussion->comments_count--;
                 $post = DiscussionRenamedPost::create(['discussion_id' => $discussion->id, 'time' => $startTime = date_add($startTime, date_interval_create_from_date_string('1 second')), 'user_id' => rand(1, $users), 'content' => json_encode(array($faker->realText(rand(20, 40)), $discussion->title))]);
             } else {
                 $edited = rand(1, 20) == 1;
                 $hidden = rand(1, 100) == 1;
                 if ($hidden) {
                     $discussion->comments_count--;
                 }
                 $post = CommentPost::create(['discussion_id' => $discussion->id, 'number' => $j + 2 + $numberOffset, 'time' => $startTime = date_add($startTime, date_interval_create_from_date_string('1 second')), 'user_id' => rand(1, $users), 'content' => $faker->realText(rand(50, 500)), 'edit_time' => $edited ? $startTime = date_add($startTime, date_interval_create_from_date_string('1 second')) : null, 'edit_user_id' => $edited ? rand(1, $users) : null, 'hide_time' => $hidden ? $startTime = date_add($startTime, date_interval_create_from_date_string('1 second')) : null, 'hide_user_id' => $hidden ? rand(1, $users) : null]);
                 $posts[] = $post;
                 if (!$lastPost or $post->time >= $lastPost->time) {
                     $lastPost = $post;
                 }
             }
             if (rand(1, 20) == 1) {
                 $numberOffset += rand(0, 3);
             }
         }
         // Update the discussion's last post details.
         if ($lastPost) {
             $discussion->last_time = $lastPost->time;
             $discussion->last_user_id = $lastPost->user_id;
             $discussion->last_post_id = $lastPost->id;
             $discussion->last_post_number = $lastPost->number;
         }
         $discussion->number_index = $j + 1 + $numberOffset;
         $discussion->save();
         // Give some users some random discussion state data.
         for ($j = rand(0, 100); $j < 100; $j++) {
             try {
                 DiscussionState::create(['discussion_id' => $discussion->id, 'user_id' => rand(1, $users), 'read_number' => rand(0, $posts_count - 1), 'read_time' => $faker->dateTimeBetween($discussion->start_time, 'now')]);
             } catch (\Illuminate\Database\QueryException $e) {
             }
         }
     }
     // Update user post and discussion counts.
     $prefix = DB::getTablePrefix();
     DB::table('users')->update(['discussions_count' => DB::raw('(SELECT COUNT(id) FROM ' . $prefix . 'discussions WHERE start_user_id = ' . $prefix . 'users.id)'), 'comments_count' => DB::raw('(SELECT COUNT(id) FROM ' . $prefix . 'posts WHERE user_id = ' . $prefix . 'users.id and type = \'comment\')')]);
 }
Esempio n. 3
0
 public function extend(Application $app)
 {
     Post::addType($this->class);
 }
Esempio n. 4
0
 public function registerPermissions()
 {
     $this->extend(new Permission('forum.view'), new Permission('forum.startDiscussion'), new Permission('discussion.rename'), new Permission('discussion.delete'), new Permission('discussion.reply'), new Permission('post.edit'), new Permission('post.delete'));
     Forum::grantPermission(function ($grant, $user, $permission) {
         return $user->hasPermission('forum.' . $permission);
     });
     Post::grantPermission(function ($grant, $user, $permission) {
         return $user->hasPermission('post' . $permission);
     });
     // Grant view access to a post only if the user can also view the
     // discussion which the post is in. Also, the if the post is hidden,
     // the user must have edit permissions too.
     Post::grantPermission('view', function ($grant) {
         $grant->whereCan('view', 'discussion');
     });
     Post::demandPermission('view', function ($demand) {
         $demand->whereNull('hide_user_id')->orWhereCan('edit');
     });
     // Allow a user to edit their own post, unless it has been hidden by
     // someone else.
     Post::grantPermission('edit', function ($grant, $user) {
         $grant->where('user_id', $user->id)->where(function ($query) use($user) {
             $query->whereNull('hide_user_id')->orWhere('hide_user_id', $user->id);
         });
         // @todo add limitations to time etc. according to a config setting
     });
     User::grantPermission(function ($grant, $user, $permission) {
         return $user->hasPermission('user.' . $permission);
     });
     // Grant view access to a user if the user can view the forum.
     User::grantPermission('view', function ($grant, $user) {
         $grant->whereCan('view', 'forum');
     });
     // Allow a user to edit their own account.
     User::grantPermission(['edit', 'delete'], function ($grant, $user) {
         $grant->where('id', $user->id);
     });
     Discussion::grantPermission(function ($grant, $user, $permission) {
         return $user->hasPermission('discussion.' . $permission);
     });
     // Grant view access to a discussion if the user can view the forum.
     Discussion::grantPermission('view', function ($grant, $user) {
         $grant->whereCan('view', 'forum');
     });
     // Allow a user to rename their own discussion.
     Discussion::grantPermission('rename', function ($grant, $user) {
         $grant->where('start_user_id', $user->id);
         // @todo add limitations to time etc. according to a config setting
     });
 }