<?php
/**
 * R2 (F2.5): the conscious-activation gate for the noindex/nofollow "wake
 * up" documented in ABDS_SEO_Policy_Engine's own class docblock. Before
 * this release, _abds_seo_noindex/_abds_seo_nofollow post meta (written
 * years ago by a competitor-plugin migration, for sites that ran one) sat
 * completely inert — nothing read it back out. F2.5's print_meta_robots()
 * is the first real consumer, so any site with migrated data starts
 * genuinely noindexing/nofollowing those pages the moment this release
 * activates — a real behavior change on a live site, not a UI change.
 *
 * Same versioned-flag shape as ABDS_SEO_Activator's own
 * CAPS_VERSION_OPTION/CAPS_VERSION/maybe_upgrade_caps() pattern: the
 * ACKNOWLEDGED_OPTION stores the acknowledged VERSION (not a bare bool),
 * so a future ACTIVATION_VERSION bump (a later "wake up more sleeping
 * data" release) automatically re-shows the notice instead of staying
 * silently dismissed by an old acknowledgment.
 *
 * @package ABDS_SEO
 */

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

/**
 * Detects and gates the noindex/nofollow migrated-data activation.
 */
class ABDS_SEO_Noindex_Activation {

	const ACTIVATION_VERSION_OPTION = 'abds_seo_noindex_activation_version';
	const ACTIVATION_VERSION        = '1';
	const ACKNOWLEDGED_OPTION       = 'abds_seo_noindex_activation_acknowledged';
	const PENDING_COUNT_OPTION      = 'abds_seo_noindex_activation_pending_count';

	/**
	 * Runs once per ACTIVATION_VERSION: counts affected posts and either
	 * auto-acknowledges (nothing to warn about — a fresh install or a site
	 * that never ran a migration) or records the count for the notice to
	 * show. Hooked to plugins_loaded, same as maybe_upgrade_caps().
	 */
	public static function maybe_flag_pending_activation(): void {
		if ( get_option( self::ACTIVATION_VERSION_OPTION ) === self::ACTIVATION_VERSION ) {
			return;
		}

		update_option( self::ACTIVATION_VERSION_OPTION, self::ACTIVATION_VERSION );

		$count = self::count_affected_posts();

		if ( 0 === $count ) {
			update_option( self::ACKNOWLEDGED_OPTION, self::ACTIVATION_VERSION );
			delete_option( self::PENDING_COUNT_OPTION );
			return;
		}

		update_option( self::PENDING_COUNT_OPTION, $count );
	}

	/**
	 * Whether the notice/review screen should still show: there was
	 * migrated data to warn about, and the site owner hasn't acknowledged
	 * this exact ACTIVATION_VERSION yet.
	 *
	 * @return bool
	 */
	public static function is_pending(): bool {
		return self::ACTIVATION_VERSION !== get_option( self::ACKNOWLEDGED_OPTION );
	}

	/**
	 * The cached affected-post count computed by maybe_flag_pending_activation().
	 *
	 * @return int
	 */
	public static function pending_count(): int {
		return (int) get_option( self::PENDING_COUNT_OPTION, 0 );
	}

	/**
	 * Marks this ACTIVATION_VERSION as acknowledged — the notice and review
	 * screen stop showing until a future version bump.
	 */
	public static function acknowledge(): void {
		update_option( self::ACKNOWLEDGED_OPTION, self::ACTIVATION_VERSION );
	}

	/**
	 * Counts published posts (public post types only) carrying either
	 * migrated flag. Computed once by maybe_flag_pending_activation() and
	 * cached in PENDING_COUNT_OPTION — not re-queried on every admin
	 * request.
	 *
	 * @return int
	 */
	protected static function count_affected_posts(): int {
		global $wpdb;

		$post_types = array_keys( ABDS_SEO_Taxonomy_Helper::public_post_types() );
		if ( array() === $post_types ) {
			return 0;
		}

		$placeholders = implode( ',', array_fill( 0, count( $post_types ), '%s' ) );

		// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare -- table names are $wpdb->posts/$wpdb->postmeta, not user input; {$placeholders} is a dynamically-built but fixed-count "%s,%s,..." list phpcs can't statically count, real args supplied via $post_types just below.
		$sql = "SELECT COUNT(DISTINCT p.ID) FROM {$wpdb->posts} p"
			. " INNER JOIN {$wpdb->postmeta} pm ON pm.post_id = p.ID"
			. " WHERE p.post_status = 'publish' AND p.post_type IN ({$placeholders})"
			. " AND ( ( pm.meta_key = '_abds_seo_noindex' AND pm.meta_value = '1' ) OR ( pm.meta_key = '_abds_seo_nofollow' AND pm.meta_value = '1' ) )";

		// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- $sql is prepared just below; this runs once per ACTIVATION_VERSION (gated above), its result cached in PENDING_COUNT_OPTION, not on every request.
		return (int) $wpdb->get_var( $wpdb->prepare( $sql, $post_types ) );
	}

	/**
	 * The affected posts themselves, paginated, for the review screen.
	 *
	 * @param int $paged Current page, 1-indexed.
	 * @return WP_Query
	 */
	public static function affected_posts_query( int $paged = 1 ): WP_Query {
		$post_types = array_keys( ABDS_SEO_Taxonomy_Helper::public_post_types() );

		return new WP_Query(
			array(
				'post_type'      => array() !== $post_types ? $post_types : array( 'post' ),
				'post_status'    => 'publish',
				'posts_per_page' => 20,
				'paged'          => max( 1, $paged ),
				'orderby'        => 'title',
				'order'          => 'ASC',
				'meta_query'     => array( // phpcs:ignore WordPress.DB.SlowDBQuery.slow_db_query_meta_query -- one-time review screen for a bounded, already-migrated dataset, not a hot path.
					'relation' => 'OR',
					array(
						'key'   => '_abds_seo_noindex',
						'value' => '1',
					),
					array(
						'key'   => '_abds_seo_nofollow',
						'value' => '1',
					),
				),
			)
		);
	}
}