<?php
namespace JVBase\managers;

if (!defined('ABSPATH')) {
	exit; // Exit if accessed directly
}
/**
 * Response Manager
 *
 * Handles a responses
 * TODO
 */
class ResponseManager
{
	protected CustomTable $response;
	protected KarmaManager $karma;

	public function __construct()
	{
		$this->defineTables();
	}
	protected function defineTables():void
	{
		$table = CustomTable::for('responses');

		$table->setColumns([
			'id'		=> 'bigint(20) unsigned NOT NULL AUTO_INCREMENT',
			'item_id'	=> "{$table->getPostIDType()} NOT NULL",
			'type'		=> 'varchar(50) NOT NULL',
			'user_id'	=> "{$table->getUserIdType()} NOT NULL",
			'parent_id'	=> 'bigint(20) unsigned DEFAULT 0',
			'response'	=> 'text NOT NULL',
			'upvotes'	=> 'int NOT NULL DEFAULT 0',
			'downvotes'	=> 'int NOT NULL DEFAULT 0',
			'karma'		=> 'int NOT NULL DEFAULT 0',
			'status'	=> "ENUM('publish', 'hidden','flagged','deleted') DEFAULT 'publish'",
			'is_user_deleted' => 'tinyint(1) DEFAULT 0',
			'created_at'=> 'datetime DEFAULT CURRENT_TIMESTAMP',
			'updated_at'=> 'datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP',
		]);

		$table->setKeys([
			['key' => 'PRIMARY', 'value' => '`id`'],
			'`item_lookup` (`item_id`)',
			'`user_lookup` (`user_id`)',
			'`parent_lookup` (`parent_id`)',
			'`karma` (`karma`)',
			'`upvote` (`upvotes`)',
			'`downvote` (`downvotes`)',
		]);

		$base = BASE;
		$table->setConstraints([
			"CONSTRAINT `{$base}responses_item` FOREIGN KEY (`item_id`)
			REFERENCES `{$table->getPostTable()}` (`ID`) ON DELETE CASCADE",
		]);
		$table->defineTable();

		$this->response = $table;

		$this->karma = KarmaManager::for('responses', 'responses');
	}

}