<?php
/**
 * Moves data stored under the WP Pro Admin era names to the adminkeep ones.
 *
 * 1.1.0 was the first release on wordpress.org and still stored everything under the previous
 * product's prefix. 1.2.0 renamed it all. A site that ran 1.1.0 arrives here with its settings,
 * its Keep URL redirects, live-draft pointers and replaced-file records under names nothing reads
 * any more; this carries them across once.
 *
 * The old option rows are the trigger and are deleted last, so an interrupted run is simply run
 * again on the next request and a finished one costs two cached option misses.
 *
 * @package Adminkeep
 */

namespace Adminkeep;

use Adminkeep\Service\PathRedirectStore;

defined( 'ABSPATH' ) || exit;

/**
 * One-time rename of stored names.
 */
class LegacyNames {

	/**
	 * Settings option as 1.1.0 wrote it.
	 */
	const OLD_SETTINGS = 'wp_pro_admin_settings';

	/**
	 * Keep URL schema-version option as 1.1.0 wrote it.
	 */
	const OLD_REDIRECT_SCHEMA = 'wp_pro_admin_redirect_schema';

	/**
	 * Replaced-media cleanup cron hook as 1.1.0 scheduled it.
	 */
	const OLD_CLEANUP_HOOK = 'wp_pro_admin_cleanup_replaced_media';

	/**
	 * Post-meta keys: new name => name 1.1.0 wrote.
	 *
	 * @var array<string, string>
	 */
	const OLD_META = array(
		'_adminkeep_live_draft_of' => '_wppa_live_draft_of',
		'_adminkeep_replaced_file' => '_wppa_replaced_file',
	);

	/**
	 * Keep URL table as 1.1.0 created it.
	 *
	 * @return string
	 */
	public static function old_table() {
		global $wpdb;

		return $wpdb->prefix . 'wppa_path_redirects';
	}

	/**
	 * Carry everything across, if there is anything to carry.
	 *
	 * @return bool Whether a migration ran.
	 */
	public static function maybe_migrate() {
		$old_settings = get_option( self::OLD_SETTINGS, null );
		$old_schema   = get_option( self::OLD_REDIRECT_SCHEMA, null );

		if ( null === $old_settings && null === $old_schema ) {
			return false;
		}

		if ( is_array( $old_settings ) && false === get_option( Settings::OPTION ) ) {
			update_option( Settings::OPTION, $old_settings, true );
		}

		if ( null !== $old_schema ) {
			self::move_table( $old_schema );
		}

		self::move_meta();

		wp_clear_scheduled_hook( self::OLD_CLEANUP_HOOK );

		// Last, and only once the settings are readable under the new name: these rows are what
		// makes the next request try again.
		if ( ! is_array( $old_settings ) || is_array( get_option( Settings::OPTION ) ) ) {
			delete_option( self::OLD_SETTINGS );
		}

		delete_option( self::OLD_REDIRECT_SCHEMA );

		Settings::flush_cache();

		return true;
	}

	/**
	 * Rename the Keep URL table, keeping every redirect.
	 *
	 * A new table that already holds rows is never replaced: those redirects were recorded by
	 * this version and the old table is left where it is rather than merged blind.
	 *
	 * @param mixed $old_schema Schema version stored under the old option name.
	 * @return void
	 */
	private static function move_table( $old_schema ) {
		global $wpdb;

		$old = self::old_table();
		$new = PathRedirectStore::table();

		$suppressed = $wpdb->suppress_errors( true );

		// Plugin-owned tables; names are $wpdb->prefix plus a literal, and DDL has no prepared form.
		// phpcs:disable WordPress.DB.DirectDatabaseQuery, WordPress.DB.PreparedSQL, PluginCheck.Security.DirectDB.UnescapedDBParameter
		if ( false !== get_option( PathRedirectStore::VERSION_OPTION ) ) {
			$rows = $wpdb->get_var( "SELECT COUNT(*) FROM {$new}" );

			if ( null !== $rows && (int) $rows > 0 ) {
				$wpdb->suppress_errors( $suppressed );
				return;
			}

			$wpdb->query( "DROP TABLE IF EXISTS {$new}" );
			delete_option( PathRedirectStore::VERSION_OPTION );
		}

		// ALTER ... RENAME rather than RENAME TABLE: the latter refuses temporary tables.
		$renamed = $wpdb->query( "ALTER TABLE {$old} RENAME TO {$new}" );
		// phpcs:enable

		$wpdb->suppress_errors( $suppressed );

		if ( false !== $renamed ) {
			update_option( PathRedirectStore::VERSION_OPTION, (int) $old_schema, false );
		}
	}

	/**
	 * Rename the two post-meta keys in place.
	 *
	 * @return void
	 */
	private static function move_meta() {
		global $wpdb;

		foreach ( self::OLD_META as $new_key => $old_key ) {
			// phpcs:ignore WordPress.DB.DirectDatabaseQuery, WordPress.DB.SlowDBQuery
			$wpdb->update( $wpdb->postmeta, array( 'meta_key' => $new_key ), array( 'meta_key' => $old_key ), array( '%s' ), array( '%s' ) );
		}
	}
}