<?php
/**
 * Physical database names for the site's logical application tables.
 *
 * @package ABeCeBooking
 */

namespace ABeCe\Booking\Infrastructure\Database;

use InvalidArgumentException;
use RuntimeException;

/** Authoritative table registry; legacy mode is confined to historical migration work. */
final class Tables {

	public const LOGICAL = array(
		'sports',
		'resources',
		'resource_blocks',
		'seasons',
		'membership_types',
		'members',
		'memberships',
		'bookings',
		'booking_participants',
		'booking_history',
		'notifications',
		'opening_hours',
		'schedule_exceptions',
		'price_lists',
		'price_rules',
		'credit_accounts',
		'credit_transactions',
		'payment_transactions',
		'cancellation_policies',
		'cancellation_rules',
		'external_contacts',
		'usage_limit_rules',
		'customer_restrictions',
		'booking_series',
	);

	private static bool $legacy = false;

	/**
	 * Resolve a fixed logical name. Never accepts a raw request SQL identifier.
	 *
	 * @param \wpdb  $wpdb Database connection with the actual site prefix.
	 * @param string $logical Application table identifier.
	 * @return string
	 */
	public static function name( \wpdb $wpdb, string $logical ): string {
		if ( ! in_array( $logical, self::LOGICAL, true ) ) {
			throw new InvalidArgumentException( 'Unknown ABeCe Booking logical table.' );
		}
		self::validate_prefix( $wpdb );
		return $wpdb->prefix . ( self::$legacy ? 'asb_' : 'abece_booking_' ) . $logical;
	}

	/**
	 * Return every logical-to-physical mapping, in immutable registry order.
	 *
	 * @param \wpdb $wpdb Site database connection.
	 * @return array<string, string>
	 */
	public static function all( \wpdb $wpdb ): array {
		$names = array();
		foreach ( self::LOGICAL as $logical ) {
			$names[ $logical ] = self::name( $wpdb, $logical );
		}
		return $names;
	}

	/**
	 * Explicit historical names for preflight and the versioned transition only.
	 *
	 * @param \wpdb $wpdb Site database connection.
	 * @return array<string, string>
	 */
	public static function legacy( \wpdb $wpdb ): array {
		return self::historical( static fn() => self::all( $wpdb ) );
	}

	/**
	 * Scope immutable migrations 1–12 without making runtime reads ambiguous.
	 *
	 * @param callable $operation Historical migration operation.
	 * @return mixed
	 */
	public static function historical( callable $operation ): mixed {
		$previous     = self::$legacy;
		self::$legacy = true;
		try {
			return $operation();
		} finally {
			self::$legacy = $previous;
		}
	}

	/**
	 * Reject long prefixes before creating or renaming any table.
	 *
	 * @param \wpdb $wpdb Site database connection.
	 * @return void
	 */
	public static function validate_prefix( \wpdb $wpdb ): void {
		if ( ! preg_match( '/^[A-Za-z0-9_]+$/D', $wpdb->prefix ) || strlen( $wpdb->prefix ) > 29 ) {
			throw new RuntimeException( __( 'ABeCe Booking requires a WordPress database prefix of at most 29 letters, digits or underscores. No tables were renamed.', 'abece-booking' ) );
		}
	}

	/**
	 * Database/site-specific lock names with a bounded MySQL identifier length.
	 *
	 * @param \wpdb  $wpdb Site database connection.
	 * @param string $scope Fixed application lock scope.
	 * @param string $identity Optional typed customer or operation identity.
	 * @return string
	 */
	public static function lock( \wpdb $wpdb, string $scope, string $identity = '' ): string {
		if ( ! in_array( $scope, array( 'schema', 'resources', 'prices', 'season', 'member_link', 'privacy', 'customer', 'geocoding', 'page' ), true ) ) {
			throw new InvalidArgumentException( 'Unknown ABeCe Booking lock scope.' );
		}
		return 'abece_booking_' . $scope . '_' . substr( hash( 'sha256', DB_NAME . ':' . $wpdb->prefix . ':' . $identity ), 0, 32 );
	}
}