<?php
declare(strict_types=1);
namespace App\Controllers\Forum;
use App\Classes\Validator;
use App\Controllers\BaseController;
use App\Models\Flood;
use App\Models\Forum;
use App\Models\Post;
use App\Models\Topic;
use App\Models\Vote;
use App\Models\VoteAnswer;
use Illuminate\Database\Capsule\Manager as DB;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Query\JoinClause;
use Illuminate\Http\Request;
class ForumController extends BaseController
{
/**
* Главная страница
*
* @return string
*/
public function index(): string
{
$forums = Forum::query()
->where('parent_id', 0)
->with('lastTopic.lastPost.user')
->with('children')
->orderBy('sort')
->get();
if ($forums->isEmpty()) {
abort('default', __('forums.empty_forums'));
}
return view('forums/index', compact('forums'));
}
/**
* Страница списка тем
*
* @param int $id
*
* @return string
*/
public function forum(int $id): string
{
/** @var Forum $forum */
$forum = Forum::query()->with('parent', 'children.lastTopic.lastPost.user')->find($id);
if (! $forum) {
abort(404, __('forums.forum_not_exist'));
}
$user = getUser();
$topics = Topic::query()
->where('forum_id', $forum->id)
->when($user, static function (Builder $query) use ($user) {
$query->select('topics.*', 'bookmarks.count_posts as bookmark_posts')
->leftJoin('bookmarks', static function (JoinClause $join) use ($user) {
$join->on('topics.id', 'bookmarks.topic_id')
->where('bookmarks.user_id', $user->id);
});
})
->orderByDesc('locked')
->orderByDesc('updated_at')
->with('lastPost.user')
->paginate(setting('forumtem'));
return view('forums/forum', compact('forum', 'topics'));
}
/**
* Создание новой темы
*
* @param Request $request
* @param Validator $validator
* @param Flood $flood
*
* @return string
*/
public function create(Request $request, Validator $validator, Flood $flood): string
{
$fid = int($request->input('fid'));
$forums = Forum::query()
->where('parent_id', 0)
->with('children')
->orderBy('sort')
->get();
if ($forums->isEmpty()) {
abort('default', __('forums.empty_forums'));
}
if (! $user = getUser()) {
abort(403);
}
if ($request->isMethod('post')) {
$title = $request->input('title');
$msg = $request->input('msg');
$vote = empty($request->input('vote')) ? 0 : 1;
$question = $request->input('question');
$answers = (array) $request->input('answers');
/** @var Forum $forum */
$forum = Forum::query()->find($fid);
$validator->equal($request->input('token'), $_SESSION['token'], __('validator.token'))
->notEmpty($forum, ['fid' => 'Форума для новой темы не существует!'])
->false($flood->isFlood(), ['msg' => __('validator.flood', ['sec' => $flood->getPeriod()])])
->length($title, 3, 50, ['title' => __('validator.text')])
->length($msg, 5, setting('forumtextlength'), ['msg' => __('validator.text')]);
if ($forum) {
$validator->empty($forum->closed, ['fid' => __('forums.forum_closed')]);
}
if ($vote) {
$validator->length($question, 5, 100, ['question' => __('validator.text')]);
$answers = array_unique(array_diff($answers, ['']));
foreach ($answers as $answer) {
if (utfStrlen($answer) > 50) {
$validator->addError(['answers' => __('votes.answer_wrong_length')]);
break;
}
}
$validator->between(count($answers), 2, 10, ['answers' => __('votes.answer_not_enough')]);
}
/* TODO: Сделать проверку поиска похожей темы */
if ($validator->isValid()) {
$title = antimat($title);
$msg = antimat($msg);
$user->increment('allforum');
$user->increment('point');
$user->increment('money', 5);
/** @var Topic $topic */
$topic = Topic::query()->create([
'forum_id' => $forum->id,
'title' => $title,
'user_id' => getUser('id'),
'count_posts' => 1,
'created_at' => SITETIME,
'updated_at' => SITETIME,
]);
/** @var Post $post */
$post = Post::query()->create([
'topic_id' => $topic->id,
'user_id' => getUser('id'),
'text' => $msg,
'created_at' => SITETIME,
'ip' => getIp(),
'brow' => getBrowser(),
]);
Topic::query()->where('id', $topic->id)->update(['last_post_id' => $post->id]);
$forum->update([
'count_topics' => DB::connection()->raw('count_topics + 1'),
'count_posts' => DB::connection()->raw('count_posts + 1'),
'last_topic_id' => $topic->id,
]);
// Обновление родительского форума
if ($forum->parent->id) {
$forum->parent->update([
'last_topic_id' => $topic->id
]);
}
// Создание голосования
if ($vote) {
/** @var Vote $vote */
$vote = Vote::query()->create([
'title' => $question,
'topic_id' => $topic->id,
'created_at' => SITETIME,
]);
$prepareAnswers = [];
foreach ($answers as $answer) {
$prepareAnswers[] = [
'vote_id' => $vote->id,
'answer' => $answer
];
}
VoteAnswer::query()->insert($prepareAnswers);
}
clearCache(['statForums', 'recentTopics']);
$flood->saveState();
setFlash('success', __('forums.topic_success_created'));
redirect('/topics/'.$topic->id);
} else {
setInput($request->all());
setFlash('danger', $validator->getErrors());
}
}
return view('forums/topic_create', compact('forums', 'fid'));
}
/**
* RSS всех топиков
*
* @return string
*/
public function rss(): string
{
$topics = Topic::query()
->where('closed', 0)
->with('lastPost.user')
->orderByDesc('updated_at')
->limit(15)
->get();
if ($topics->isEmpty()) {
abort('default', __('forums.topics_not_created'));
}
return view('forums/rss', compact('topics'));
}
/**
* RSS постов
*
* @param int $id
*
* @return string
*/
public function rssPosts(int $id): string
{
/** @var Topic $topic */
$topic = Topic::query()->find($id);
if (! $topic) {
abort(404, __('forums.topic_not_exist'));
}
$posts = Post::query()
->where('topic_id', $topic->id)
->orderByDesc('created_at')
->with('user')
->limit(15)
->get();
return view('forums/rss_posts', compact('topic', 'posts'));
}
/**
* Последние темы
*
* @return string
*/
public function topTopics(): string
{
$topics = Topic::query()
->orderByDesc('count_posts')
->orderByDesc('updated_at')
->with('forum', 'user', 'lastPost.user')
->limit(100)
->get()
->all();
$topics = paginate($topics, setting('forumtem'));
return view('forums/top', compact('topics'));
}
/**
* Последние сообщения
*
* @param Request $request
*
* @return string
*/
public function topPosts(Request $request): string
{
$period = int($request->input('period'));
$posts = Post::query()
->when($period, static function (Builder $query) use ($period) {
return $query->where('created_at', '>', strtotime('-' . $period . ' day', SITETIME));
})
->orderByDesc('rating')
->orderByDesc('created_at')
->with('topic', 'user')
->limit(100)
->get()
->all();
$posts = paginate($posts, setting('forumpost'), ['period' => $period]);
return view('forums/top_posts', compact('posts', 'period'));
}
}