/**
* 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();
}
/**
* 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\')')]);
}
public function extend(Application $app)
{
Post::addType($this->class);
}
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
});
}