<?php

namespace FootyRoom\Repositories;

use DateTime;
use FootyRoom\Core\ForumPost\ForumPost;
use FootyRoom\Support\AutoMapper;
use Illuminate\Database\Connection;

class ForumPostRepository
{
    /**
     * @var \Illuminate\Database\Connection
     */
    protected $mysql;

    /**
     * Constructor.
     *
     * @param \Illuminate\Database\Connection $mysql
     */
    public function __construct(Connection $mysql)
    {
        $this->mysql = $mysql;
    }

    /**
     * Finds post by id.
     *
     * @param int $id
     *
     * @return \FootyRoom\Core\ForumPost\ForumPost
     */
    public function findById($id)
    {
        $postDto = $this->mysql

        ->table('wp_posts')
        ->join('wp_term_relationships', 'wp_posts.id', '=', 'wp_term_relationships.object_id')
        ->select([
            'id',
            'post_title as title',
            'post_name as slug',
            'post_author as userId',
            'post_title as title',
            'comment_status as discussionStatus',
            'post_status as status',
            'term_taxonomy_id as categoryId',
            'post_content as content',
            'post_date as date',
            'guid',
        ])
        ->where('ID', '=', $id)
        ->first();

        if (!$postDto) {
            return null;
        }

        $postDto->date = new DateTime($postDto->date);

        $post = AutoMapper::map($postDto, ForumPost::class);

        return $post;
    }

    /**
     * Finds forum posts by title.
     *
     * @param string $q
     * @param int $offset
     * @param int $limit
     *
     * @return object[]|null
     */
    public function findByTitle($q, $offset, $limit)
    {
        return $this->mysql

        ->table('wp_posts AS p')
        ->select(['id', 'post_title as title', 'post_name as slug', 'comment_count as commentCount'])
        ->join('wp_term_relationships AS tr', 'p.id', '=', 'tr.object_id')
        ->join('wp_terms AS t', 'tr.term_taxonomy_id', '=', 't.term_id')
        ->where('p.post_status', '=', 'publish')
        ->where('p.post_type', '=', 'post')
        ->where('p.post_title', 'LIKE', "%$q%")
        ->where('t.term_group', '=', 100)
        ->orderBy('p.id', 'desc')
        ->offset($offset)
        ->limit($limit)
        ->get();
    }

    /**
     * Saves new forum post.
     *
     * @param \FootyRoom\Core\ForumPost\ForumPost $post
     *
     * @return \FootyRoom\Core\ForumPost\ForumPost | null
     */
    public function create(ForumPost $post)
    {
        $options = [
            'post_status' => $post->isPublished() ? 'publish' : 'draft',
            'post_type' => 'post',
            'post_author' => $post->getUserId(),
            'post_name' => $post->getSlug(),
            'ping_status' => '',
            'post_parent' => 0,
            'post_password' => '',
            'post_content' => '',
            'post_title' => $post->getTitle(),
            'post_date' => $post->getDate()->format('c'),
            'post_date_gmt' => $post->getDate()->format('c'),
        ];

        $postId = $this->mysql

        ->table('wp_posts')
        ->insertGetId($options);

        AutoMapper::setValue($post, 'id', $postId);

        // Associate this post with its category.
        $this->assignCategory($post->getId(), $post->getCategoryId());

        return $post;
    }

    /**
     * Update post's status.
     *
     * @param \FootyRoom\Core\ForumPost\ForumPost $post
     */
    public function updateStatus(ForumPost $post)
    {
        $this->mysql

        ->table('wp_posts')
        ->where('id', '=', $post->getId())
        ->update([
            'post_status' => $post->isPublished() ? 'publish' : 'draft',
        ]);
    }

    /*
     * Updates settings of a specified forum post.
     *
     * @param \FootyRoom\Core\ForumPost\ForumPost $post
     */
    public function updateSettings(ForumPost $post)
    {
        if (!$post->isSticky()) {
            $sticky = 0;
        } else {
            $sticky = $post->isLocalSticky() ? 1 : 5;
        }

        $update = [
            'sticky' => $sticky,
            'post_name' => $post->getSlug(),
            'comment_status' => $post->isDiscussionOpen() ? 'open' : 'closed',
            'post_title' => $post->getTitle(),
            'post_author' => $post->getUserId(),
            'post_status' => $post->isPublished() ? 'publish' : 'draft',
        ];

        $this->mysql

        ->table('wp_posts')
        ->where('id', '=', $post->getId())
        ->update($update);

        // Associate this post with its category.
        $this->updateCategory($post->getId(), $post->getCategoryId());
    }

    /**
     * Update category of existing post.
     *
     * @param int $postId
     * @param int $categoryId
     */
    protected function updateCategory($postId, $categoryId)
    {
        $this->mysql

        ->table('wp_term_relationships')
        ->where('object_id', '=', $postId)
        ->update([
            'term_taxonomy_id' => $categoryId,
        ]);
    }

    /**
     * Assign category to new post.
     *
     * @param int $postId
     * @param int $categoryId
     */
    protected function assignCategory($postId, $categoryId)
    {
        $this->mysql

        ->table('wp_term_relationships')
        ->insert([
            'object_id' => $postId,
            'term_taxonomy_id' => $categoryId,
        ]);
    }

    /**
     * Increment posts comment count.
     *
     * @param int $postId
     */
    public function incrementCommentCount($postId)
    {
        $this->mysql

        ->table('wp_posts')
        ->where('ID', '=', $postId)
        ->increment('comment_count');
    }
}