<?php

declare(strict_types=1);

namespace MPBC;

use MPBC\Data\Repository;
use MPBC\Post_Type\Post_Types;

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

final class Database {
	private const OPTION_DB_VERSION = 'mpbc_db_version';

	public function __construct() {
		$property_post_type = Post_Types::PROPERTY_POST_TYPE;

		// Create table with the first property
		add_action( "save_post_{$property_post_type}", array( $this, 'on_data_entry' ), 10, 3 );

		// Drop tables when deleting a site
		add_filter( 'wpmu_drop_tables', array( $this, 'filter_site_custom_tables' ), 10, 2 );
	}

	/**
	 * @access private
	 */
	public function on_data_entry( int $post_id, \WP_Post $post, bool $is_update ): void {
		if ( ! $is_update ) { // Is new post
			$this->check_db();
		}
	}

	private function check_db(): void {
		$db_version = get_option( self::OPTION_DB_VERSION );
		$plugin_version = mpbc()->get_version();
	
		if ( $db_version === false ) {
			$this->create_tables();

			add_option( self::OPTION_DB_VERSION, $plugin_version );

			do_action( 'mpbc_first_init' );

		} elseif ( $db_version !== $plugin_version ) {
			update_option( self::OPTION_DB_VERSION, $plugin_version );
		}
	}

	private function create_tables(): void {
		Repository\Time_Slot_Repository::create_table();
		Repository\Price_Repository::create_table();
		Repository\Unit_Availability_Repository::create_table();
		Repository\Reserved_Slot_Repository::create_table();
	}

	/**
	 * @access private
	 */
	public function filter_site_custom_tables( array $tables, int $blog_id ): array {
		switch_to_blog( $blog_id );

		if ( $this->has_custom_tables() ) {
			$tables[] = Repository\Time_Slot_Repository::get_table_name();
			$tables[] = Repository\Price_Repository::get_table_name();
			$tables[] = Repository\Unit_Availability_Repository::get_table_name();
			$tables[] = Repository\Reserved_Slot_Repository::get_table_name();
		}

		restore_current_blog();

		return $tables;
	}

	public function has_custom_tables(): bool {
		return get_option( self::OPTION_DB_VERSION ) !== false;
	}
}