<?php
namespace JVBase\managers;

use JVBase\registrar\Registrar;

if (!defined('ABSPATH')) {
	exit; // Exit if accessed directly
}
/**
 * Forum Manager
 * TODO
 * Handles a forum functionality
 */
class ForumManager
{
	protected CustomTable $relationships;
	protected CustomTable $forum;
	protected KarmaManager $karma;

	public function __construct()
	{
		$this->defineTables();
		$this->registerHooks();
	}
	public function registerHooks():void
	{
		add_action('jvbDefineRegistrar', [$this, 'registerForum']);
		add_action('jvbDefineRegistrarFields', [$this, 'registerForumFields']);
		add_action('plugins_loaded', [$this, 'registerForum'], 1);
		add_action('plugins_loaded', [$this, 'registerForum'], 2);
	}
		public function registerForum():void
		{
			Registrar::forPost('jvbforum', 'Post', 'Posts')
				->setIcon('note')
				->make([
					'public'	=> false,
					'taxonomies' => [
						'topic'
					]
				]);

			Registrar::forTerm('jvbtopic', 'Topic', 'Topics')
				->setIcon('folder')
				->make([
					'hierarchical' => true,
					'for'	=> ['jvbforum']
				]);
		}
		public function registerForumFields():void
		{
			$forum = Registrar::getInstance('jvbforum');
			$fields = $forum->fields();

			$topic = Registrar::getInstance('jvbtopic');
			$topicFields = $topic->fields();
		}


	protected function defineTables():void
	{
		$this->definedRelationshipsTable();
		$this->karma = KarmaManager::for('forum', 'post');
	}
		protected function definedRelationshipsTable():void
		{
			$table = CustomTable::for('forum_relationship');

			$table->setColumns([
				'id'	=> 'bigint(20) unsigned NOT NULL AUTO_INCREMENT',
				'term_id'	=> "{$table->getTermIDType()} NOT NULL",
				'user_id'	=> "{$table->getUserIDType()} NOT NULL",
				'profile_id'=> "{$table->getPostIDType()} NOT NULL",
				'forum_count'	=> 'int(10) unsigned NOT NULL',
				'last_post_date'=> 'datetime DEFAULT NULL',
				'updated_at'	=> 'timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'
			]);

			$table->setKeys([
				['key' => 'PRIMARY', 'value' => '(`id`)'],
				['key' => 'UNIQUE', 'value' => '`term_user` (`term_id`, `user_id`)'],
				'`term_id` (`term_id`)',
				'`user_id` (`user_id`)',
				'`profile_id` (`profile_id`)',
			]);
			$base = BASE;
			$table->setConstraints([
				"CONSTRAINT `{$base}fr_term_forum_term` FOREIGN KEY (`term_id`)
				REFERENCES `{$table->getTermTable()}` (`term_id`) ON DELETE CASCADE",
				"CONSTRAINT `{$base}fr_term_forum_user` FOREIGN KEY (`user_id`)
				REFERENCES `{$table->getUserTable()}` (`ID`) ON DELETE CASCADE",
				"CONSTRAINT `{$base}fr_term_news_profile` FOREIGN KEY (`profile_id`)
				REFERENCES `{$table->getPostTable()}` (`ID`) ON DELETE CASCADE",
			]);

			$table->defineTable();
			$this->relationships = $table;
		}
}