<?php

/**
 * Kunena Component
 *
 * @package       Kunena.Framework
 * @subpackage    Forum.Topic.User
 *
 * @copyright     Copyright (C) 2008 - @currentyear@ Kunena Team. All rights reserved.
 * @license       https://www.gnu.org/copyleft/gpl.html GNU/GPL
 * @link          https://www.kunena.org
 **/

namespace Kunena\Forum\Libraries\Forum\Topic\User;

\defined('_JEXEC') or die();

use Exception;
use Joomla\CMS\Factory;
use Joomla\CMS\Table\Table;
use Joomla\Database\DatabaseDriver;
use Joomla\Database\DatabaseInterface;
use Joomla\Database\Exception\ExecutionFailureException;
use Kunena\Forum\Libraries\Error\KunenaError;
use Kunena\Forum\Libraries\Forum\Message\KunenaMessage;
use Kunena\Forum\Libraries\Forum\Topic\KunenaTopic;
use Kunena\Forum\Libraries\Forum\Topic\KunenaTopicHelper;
use Kunena\Forum\Libraries\User\KunenaUserHelper;
use Kunena\Forum\Libraries\Tables\KunenaUserTopics;

/**
 * Class \Kunena\Forum\Libraries\Forum\Topic\TopicUser
 *
 * @property int    $user_id
 * @property int    $topic_id
 * @property int    $category_id
 * @property int    $posts
 * @property int    $last_post_id
 * @property int    $owner
 * @property int    $favorite
 * @property int    $subscribed
 * @property string $params
 *
 * @since   Kunena 6.0
 */
class KunenaTopicUser
{
    /**
    * @var     string
    * @since   Kunena 6.4
    */
    public $typeAlias;
    
    /**
     * @var     integer
     * @since   Kunena 6.4
     */
    public $user_id;
    
    /**
     * @var     integer
     * @since   Kunena 6.4
     */
    public $topic_id;
    
    /**
     * @var     integer
     * @since   Kunena 6.4
     */
    public $categoryId;
    
    /**
     * @var     string
     * @since   Kunena 6.4
     */
    public $posts;
    
    /**
     * @var     integer
     * @since   Kunena 6.4
     */
    public $last_post_id;
    
    /**
     * @var     string
     * @since   Kunena 6.4
     */
    public $owner;
    
    /**
     * @var     string
     * @since   Kunena 6.4
     */
    public $favorite;
    
    /**
     * @var     string
     * @since   Kunena 6.4
     */
    public $subscribed;
    
    /**
     * @var     string
     * @since   Kunena 6.4
     */
    public $params;
    
    /**
     * @var     integer
     * @since   Kunena 6.4
     */
    public $category_id;

    /**
     * @var     boolean
     * @since   Kunena 6.0
     */
    protected $_exists = false;

    /**
     * @var     DatabaseDriver|null
     * @since   Kunena 6.0
     */
    protected $_db = null;

    /**
     * @param   mixed  $user   user
     *
     * @param   mixed  $topic  topic
     *
     * @throws  Exception
     * @since   Kunena 6.0
     *
     * @internal
     */
    public function __construct($topic = null, $user = null)
    {
        $topic = KunenaTopicHelper::get($topic);

        // Always fill empty data
        $this->_db = Factory::getContainer()->get('DatabaseDriver');

        // Create the table object
        $table = $this->getTable();

        // Lets bind the data
        $this->bind($table->getProperties());
        $this->_exists     = false;
        $this->topic_id    = $topic->id;
        $this->category_id = $topic->category_id;
        $this->user_id     = KunenaUserHelper::get($user)->userid;
    }

    /**
     * Method to get the topics table object.
     *
     * @param   string  $type    Topics table name to be used.
     * @param   string  $prefix  Topics table prefix to be used.
     *
     * @return  boolean|Table
     *
     * @since   Kunena 6.0
     */
    public function getTable($type = 'Kunena\\Forum\\Libraries\\Tables\\', $prefix = 'KunenaUserTopics')
    {
        static $tabletype = null;

        // Set a custom table type is defined
        if ($tabletype === null || $type != $tabletype ['name'] || $prefix != $tabletype ['prefix']) {
            $tabletype ['name']   = $type;
            $tabletype ['prefix'] = $prefix;
        }

        // Create the KunenaUserTopics table object
        $db = Factory::getContainer()->get(DatabaseInterface::class);
        $tableObject = new KunenaUserTopics($db);

        return $tableObject;
    }

    /**
     * @param   mixed  $id      id
     * @param   mixed  $user    user
     * @param   bool   $reload  reload
     *
     * @return  KunenaTopicUser
     *
     * @throws  Exception
     * @since   Kunena 6.0
     */
    public static function getInstance($id = null, $user = null, $reload = false): KunenaTopicUser
    {
        return KunenaTopicUserHelper::get($id, $user, $reload);
    }

    /**
     * @return  void
     *
     * @throws  Exception
     * @since   Kunena 6.0
     */
    public function reset(): void
    {
        $this->topic_id = 0;
        $this->load();
    }

    /**
     * Method to load a \Kunena\Forum\Libraries\Forum\Topic\TopicUser object by id.
     *
     * @param   int    $topic_id  Topic id to be loaded.
     * @param   mixed  $user      user
     *
     * @return  boolean  True on success
     *
     * @throws  Exception
     * @since   Kunena 6.0
     */
    public function load($topic_id = null, $user = null): bool
    {
        if ($topic_id === null) {
            $topic_id = $this->topic_id;
        }

        if ($user === null && $this->user_id !== null) {
            $user = $this->user_id;
        }

        $user = KunenaUserHelper::get($user);

        // Create the table object
        $table = $this->getTable();

        // Load the KunenaTable object based on id
        if ($topic_id) {
            $this->_exists = $table->load(['user_id' => $user->userid, 'topic_id' => $topic_id]);
        } else {
            $this->_exists = false;
        }

        // Assuming all is well at this point lets bind the data
        $this->bind($table->getProperties());

        return $this->_exists;
    }

    /**
     * Method to delete the \Kunena\Forum\Libraries\Forum\Topic\TopicUser object from the database.
     *
     * @return  boolean  True on success.
     *
     * @throws  Exception
     * @since   Kunena 6.0
     */
    public function delete(): bool
    {
        if (!$this->exists()) {
            return true;
        }

        // Create the table object
        $table = $this->getTable();

        try {
            $result = $table->delete(['topic_id' => $this->topic_id, 'user_id' => $this->user_id]);
        } catch (Exception $e) {
            throw new Exception($e->getMessage());
        }

        $this->_exists = false;

        return $result;
    }

    /**
     * @param   null|bool  $exists  exists
     *
     * @return  boolean
     *
     * @since   Kunena 6.0
     */
    public function exists($exists = null): bool
    {
        $return = $this->_exists;

        if ($exists !== null) {
            $this->_exists = $exists;
        }

        return $return;
    }

    /**
     * @param   KunenaMessage|null  $message    message
     * @param   int                 $postDelta  postdelta
     *
     * @return bool
     *
     * @throws \Exception
     *@since   Kunena 6.0
     */
    public function update(?KunenaMessage $message = null, int $postDelta = 0): bool
    {
        $this->posts       += $postDelta;
        $this->category_id = $this->getTopic()->category_id;

        if ($message && !$message->hold && $message->thread == $this->topic_id) {
            if ($message->parent == 0) {
                $this->owner = 1;
            }

            if ($this->last_post_id < $message->id) {
                $this->last_post_id = $message->id;
            }
        } elseif (!$message || (($message->hold || $message->thread != $this->topic_id) && $this->last_post_id == $message->id)) {
            $query = $this->_db->createQuery();
            $query->select('COUNT(*) AS posts, MAX(id) AS last_post_id, MAX(IF(parent=0,1,0)) AS owner')
                ->from($this->_db->quoteName('#__kunena_messages'))
                ->where($this->_db->quoteName('userid') . ' = ' . $this->_db->quote($this->user_id))
                ->andWhere($this->_db->quoteName('thread') . ' = ' . $this->_db->quote($this->topic_id))
                ->andWhere($this->_db->quoteName('moved') . ' = 0')
                ->andWhere($this->_db->quoteName('hold') . ' = 0')
                ->group('userid, thread');
            $query->setLimit(1);
            $this->_db->setQuery($query);

            try {
                $info = $this->_db->loadAssocList();
            } catch (ExecutionFailureException $e) {
                KunenaError::displayDatabaseError($e);

                return false;
            }

            if ($info) {
                $this->bind($info);
            }
        }

        return $this->save();
    }

    /**
     * @return  KunenaTopic
     *
     * @throws  Exception
     * @since   Kunena 6.0
     */
    public function getTopic(): KunenaTopic
    {
        return KunenaTopicHelper::get($this->topic_id);
    }

    /**
     * @param   array  $data    data
     * @param   array  $ignore  ignore
     *
     * @return  void
     *
     * @since   Kunena 6.0
     */
    public function bind(array $data, array $ignore = []): void
    {
        $data = array_diff_key($data, array_flip($ignore));
        foreach ((array) $data as $property => $value) {
            $this->$property = $value;
        }
    }

    /**
     * Method to save the \Kunena\Forum\Libraries\Forum\Topic\TopicUser object to the database.
     *
     * @param   bool  $updateOnly  Save the object only if not a new topic.
     *
     * @return  boolean  True on success.
     *
     * @throws  Exception
     * @since   Kunena 6.0
     */
    public function save($updateOnly = false): bool
    {
        // Create the topics table object
        $table = $this->getTable();

        $properties = [
            'user_id'      => $this->user_id,
            'topic_id'     => $this->topic_id,
            'category_id'  => $this->category_id,
            'posts'        => $this->posts,
            'last_post_id' => $this->last_post_id,
            'owner'        => $this->owner,
            'favorite'     => $this->favorite,
            'subscribed'   => $this->subscribed,
            'params'       => $this->params
        ];

        $table->bind($properties);
        $table->exists($this->_exists);

        // Check and store the object.
        if (!$table->check()) {
            return false;
        }

        // Are we creating a new topic
        $isnew = !$this->_exists;

        // If we aren't allowed to create new topic return
        if ($isnew && $updateOnly) {
            return true;
        }

        // Store the topic data in the database
        try {
            $result = $table->store();
        } catch (Exception $e) {
            throw new Exception($e->getMessage());
        }

        // Fill up \Kunena\Forum\Libraries\Forum\Topic\TopicUser object in case we created a new topic.
        if ($result && $isnew) {
            $this->load();
        }

        return $result;
    }
}