/**
* @param array $postIds
*
* @return mixed
*/
public function getPostsByIds(array $postIds)
{
$unviewableForums = $this->permissionChecker->getUnviewableIdsForContent('forum');
return $this->postModel->whereIn('id', $postIds)->whereHas('topic', function ($query) use($unviewableForums) {
$query->whereNotIn('forum_id', $unviewableForums);
})->with(['author', 'topic'])->get();
}
private function recountUsers()
{
$this->info('Recounting user counters...');
$users = User::all();
foreach ($users as $user) {
$user->num_posts = Post::where('user_id', '=', $user->id)->count();
$user->num_topics = Topic::where('user_id', '=', $user->id)->count();
$user->save();
}
$this->info('Done' . PHP_EOL);
}
/**
* @param int $pid
*
* @return string
*/
public static function getPostLink($pid)
{
$post = Post::find($pid);
return route('topics.showPost', [$post->topic->slug, $post->topic->id, $post->id]);
}
/**
* @param Post $post
* @param Topic $topic
*/
public function movePostToTopic(Post $post, Topic $topic)
{
$post->topic->decrement('num_posts');
$post->topic->forum->decrement('num_posts');
$post->topic_id = $topic->id;
$post->save();
$topic->increment('num_posts');
$topic->forum->increment('num_posts');
$topic->update(['last_post_id' => $post->id]);
$topic->forum->update(['last_post_id' => $post->id, 'last_post_user_id' => $post->author->id]);
}
/**
* @param int $id
* @param Request $request
* @param Breadcrumbs $breadcrumbs
*
* @return \Illuminate\View\View
*/
public function results($id, Request $request, Breadcrumbs $breadcrumbs)
{
// TODO: sorts
$search = $this->searchRepository->find($id);
if (!$search) {
throw new NotFoundHttpException();
}
$breadcrumbs->setCurrentRoute('search.results', $search);
$orderBy = $request->get('orderBy');
$orderDir = $request->get('orderDir');
if (!isset($this->sorts[$orderBy])) {
$orderBy = 'postdate';
}
if ($orderDir != 'asc') {
$orderDir = 'desc';
}
$urlDirs = [];
foreach ($this->sorts as $sortName => $sort) {
$urlDirs[$sortName] = $sort['asc'];
}
if ($orderDir == $urlDirs[$orderBy]) {
if ($urlDirs[$orderBy] == 'desc') {
$urlDirs[$orderBy] = 'asc';
} else {
$urlDirs[$orderBy] = 'desc';
}
}
if ($search->as_topics) {
$results = Topic::whereIn('id', explode(',', $search->topics))->with(['lastPost', 'author', 'lastPost.author'])->orderBy($this->sorts[$orderBy]['name'], $this->sorts[$orderBy][$orderDir])->paginate(10);
} else {
$results = Post::whereIn('id', explode(',', $search->posts))->with(['topic', 'author'])->orderBy($this->sorts[$orderBy]['name'], $this->sorts[$orderBy][$orderDir])->paginate(10);
}
if ($search->as_topics) {
return view('search.result_topics', compact('results', 'search', 'orderDir', 'orderBy', 'urlDirs'));
} else {
return view('search.result_posts', compact('results', 'search'));
}
}
/**
* @return \Illuminate\View\View
*/
public function queue()
{
$topics = Topic::where('approved', 0)->get();
$posts = Post::where('approved', 0)->get();
return view('moderation.queue', ['queued_topics' => $topics, 'queued_posts' => $posts])->withActive('queue');
}