<?php
/**
 * Compact administrator-facing System Impact summary.
 *
 * This class is loaded only from the admin bootstrap. It reads existing bounded
 * storage/job state and does not create its own persistent state or background
 * work.
 */

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

class AI_O_Optimiser_System_Impact {

	/** Register the compact Settings summary. */
	public function __construct() {
		add_action( 'admin_notices', array( $this, 'render' ), 20 );
	}

	/**
	 * Build a bounded read-only snapshot for the Settings UI and tests.
	 *
	 * @return array
	 */
	public static function snapshot() {
		$storage = class_exists( 'AI_O_Optimiser_DB' ) ? AI_O_Optimiser_DB::storage_report() : array();
		$storage = is_array( $storage ) ? $storage : array();
		$storage = self::supplement_storage_report( $storage );
		$tables  = isset( $storage['tables'] ) && is_array( $storage['tables'] ) ? $storage['tables'] : array();

		$aggregate = isset( $storage['aggregate_state'] ) && is_array( $storage['aggregate_state'] )
			? $storage['aggregate_state']
			: ( class_exists( 'AI_O_Optimiser_DB' ) ? AI_O_Optimiser_DB::aggregate_state() : array() );
		$aggregate = is_array( $aggregate ) ? $aggregate : array();
		$aggregate_total = max( 0, (int) ( $aggregate['max_id'] ?? 0 ) );
		$aggregate_done  = min( $aggregate_total, max( 0, (int) ( $aggregate['last_id'] ?? 0 ) ) );
		$aggregate_pct   = $aggregate_total > 0
			? min( 100, (int) round( ( $aggregate_done / $aggregate_total ) * 100 ) )
			: ( ! empty( $aggregate['complete'] ) ? 100 : 0 );

		$metadata_job = get_option( 'ai_o_optimiser_metadata_scan_job', array() );
		$metadata_job = is_array( $metadata_job ) ? $metadata_job : array();
		$metadata_status = ! empty( $metadata_job['status'] ) ? sanitize_key( (string) $metadata_job['status'] ) : 'idle';
		$metadata_total = max( 0, (int) ( $metadata_job['total'] ?? 0 ) );
		$metadata_done  = min( $metadata_total > 0 ? $metadata_total : PHP_INT_MAX, max( 0, (int) ( $metadata_job['processed'] ?? 0 ) ) );
		$metadata_pct   = $metadata_total > 0 ? min( 100, (int) round( ( $metadata_done / $metadata_total ) * 100 ) ) : 0;
		if ( 'completed' === $metadata_status ) {
			$metadata_pct = 100;
		}

		$schema_report = class_exists( 'AI_O_Optimiser_Schema_Review' ) ? AI_O_Optimiser_Schema_Review::report() : get_option( 'ai_o_optimiser_schema_review_cache', array() );
		$schema_report = is_array( $schema_report ) ? $schema_report : array();
		$coverage      = isset( $schema_report['coverage'] ) && is_array( $schema_report['coverage'] ) ? $schema_report['coverage'] : array();
		$schema_total  = max( 0, (int) ( $coverage['total'] ?? 0 ) );
		$schema_done   = min( $schema_total > 0 ? $schema_total : PHP_INT_MAX, max( 0, (int) ( $coverage['scanned'] ?? 0 ) ) );
		$schema_pct    = $schema_total > 0 ? min( 100, (int) round( ( $schema_done / $schema_total ) * 100 ) ) : 0;
		$schema_status = empty( $schema_report['checked_at'] ) ? 'not_checked' : ( ! empty( $coverage['complete'] ) ? 'complete' : 'partial' );

		$cleanup_next = wp_next_scheduled( 'ai_o_optimiser_daily_cleanup' );

		return array(
			'storage' => array(
				'total_bytes'         => max( 0, (int) ( $storage['total_bytes'] ?? 0 ) ),
				'table_bytes'         => max( 0, (int) ( $storage['table_bytes'] ?? 0 ) ),
				'schema_option_bytes' => max( 0, (int) ( $storage['schema_option_bytes'] ?? 0 ) ),
				'option_bytes'        => max( 0, (int) ( $storage['option_bytes'] ?? ( $storage['schema_option_bytes'] ?? 0 ) ) ),
				'tables'              => $tables,
				'raw_rows'            => isset( $tables['ai_o_optimiser_crawler_log']['rows'] ) ? max( 0, (int) $tables['ai_o_optimiser_crawler_log']['rows'] ) : 0,
				'aggregate_rows'      => isset( $tables['ai_o_optimiser_visibility_daily']['rows'] ) ? max( 0, (int) $tables['ai_o_optimiser_visibility_daily']['rows'] ) : 0,
				'metadata_rows'       => isset( $tables['ai_o_optimiser_metadata_queue']['rows'] ) ? max( 0, (int) $tables['ai_o_optimiser_metadata_queue']['rows'] ) : 0,
			),
			'visibility_migration' => array(
				'complete'   => ! empty( $aggregate['complete'] ),
				'processed'  => $aggregate_done,
				'total'      => $aggregate_total,
				'progress'   => $aggregate_pct,
				'updated_at' => isset( $aggregate['updated_at'] ) ? sanitize_text_field( (string) $aggregate['updated_at'] ) : '',
			),
			'metadata_scan' => array(
				'status'     => $metadata_status,
				'processed'  => $metadata_done,
				'total'      => $metadata_total,
				'progress'   => $metadata_pct,
				'queued'     => max( 0, (int) ( $metadata_job['created'] ?? 0 ) ),
				'errors'     => max( 0, (int) ( $metadata_job['errors'] ?? 0 ) ),
				'updated_at' => isset( $metadata_job['updated_at'] ) ? sanitize_text_field( (string) $metadata_job['updated_at'] ) : '',
			),
			'schema_audit' => array(
				'status'     => $schema_status,
				'processed'  => $schema_done,
				'total'      => $schema_total,
				'progress'   => $schema_pct,
				'overall'    => isset( $schema_report['overall'] ) ? sanitize_key( (string) $schema_report['overall'] ) : 'not_checked',
				'checked_at' => isset( $schema_report['checked_at'] ) ? sanitize_text_field( (string) $schema_report['checked_at'] ) : '',
			),
			'cleanup' => array(
				'scheduled' => (bool) $cleanup_next,
				'next'      => $cleanup_next ? (int) $cleanup_next : 0,
			),
		);
	}


	/** Add newer Local/Schema stores without forcing AI_O_Optimiser_DB's legacy report API to change. */
	private static function supplement_storage_report( $storage ) {
		global $wpdb;
		$resources_file = AI_O_Optimiser_PLUGIN_DIR . 'includes/ai-o-optimiser-owned-resources.php';
		$resources = file_exists( $resources_file ) ? require $resources_file : array();
		$storage['tables'] = isset( $storage['tables'] ) && is_array( $storage['tables'] ) ? $storage['tables'] : array();
		$storage['table_bytes'] = max( 0, (int) ( $storage['table_bytes'] ?? 0 ) );
		$schema_table = $wpdb->prefix . 'ai_o_optimiser_schema_activity';
		if ( ! isset( $storage['tables']['ai_o_optimiser_schema_activity'] ) && AI_O_Optimiser_Persistence::table_exists( $schema_table ) ) {
			$status = $wpdb->get_row( $wpdb->prepare( 'SHOW TABLE STATUS LIKE %s', $wpdb->esc_like( $schema_table ) ), ARRAY_A ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- Diagnostic schema metadata is fetched once on the System Impact screen.
			$bytes = is_array( $status ) ? (int) ( ( $status['Data_length'] ?? 0 ) + ( $status['Index_length'] ?? 0 ) ) : 0;
			$rows = (int) AI_O_Optimiser_Persistence::cached_var( 'schema_activity_row_count', $wpdb->prepare( 'SELECT COUNT(*) FROM %i', $schema_table ), 60 );
			$storage['tables']['ai_o_optimiser_schema_activity'] = array( 'table' => $schema_table, 'rows' => $rows, 'bytes' => $bytes );
			$storage['table_bytes'] += $bytes;
		}
		$option_bytes = 0;
		foreach ( isset( $resources['material_options'] ) && is_array( $resources['material_options'] ) ? $resources['material_options'] : array() as $option ) {
			$value = get_option( (string) $option, null );
			if ( null !== $value ) { $option_bytes += strlen( maybe_serialize( $value ) ); }
		}
		$storage['option_bytes'] = $option_bytes;
		$storage['total_bytes'] = $storage['table_bytes'] + $option_bytes;
		return $storage;
	}

	/** Render only on the canonical Settings screen. */
	public function render() {
		$page = isset( $_GET['page'] ) ? sanitize_key( wp_unslash( $_GET['page'] ) ) : ''; // phpcs:ignore WordPress.Security.NonceVerification.Recommended -- screen routing only.
		if ( 'ai-o-optimiser-settings' !== $page || ! current_user_can( AI_O_Optimiser_SENSITIVE_CAPABILITY ) ) {
			return;
		}

		$state = self::snapshot();
		$storage = $state['storage'];
		$migration = $state['visibility_migration'];
		$metadata = $state['metadata_scan'];
		$schema = $state['schema_audit'];
		$cleanup = $state['cleanup'];
		$attention = $storage['total_bytes'] > ( 75 * MB_IN_BYTES ) || ! $cleanup['scheduled'];
		?>
		<div class="ai-o-optimiser-wrap ai-o-optimiser-system-impact-wrap">
			<section id="ai-o-optimiser-system-impact" class="ai-o-optimiser-panel ai-o-optimiser-system-impact">
				<div class="ai-o-optimiser-section-heading-row">
					<div>
						<h2><?php esc_html_e( 'System impact', 'ai-o-optimiser' ); ?></h2>
						<p class="description"><?php esc_html_e( 'A compact view of AI-O Optimiser storage, long-running work and cleanup. These figures describe plugin resource state; they are not traffic or AI-visibility metrics.', 'ai-o-optimiser' ); ?></p>
					</div>
					<span class="ai-o-optimiser-badge <?php echo esc_attr( $attention ? 'ai-o-optimiser-badge-context' : 'ai-o-optimiser-badge-allowed' ); ?>"><?php echo $attention ? esc_html__( 'Review', 'ai-o-optimiser' ) : esc_html__( 'Bounded', 'ai-o-optimiser' ); ?></span>
				</div>

				<div class="ai-o-optimiser-status-grid ai-o-optimiser-status-grid-4">
					<div class="ai-o-optimiser-card">
						<span class="ai-o-optimiser-card-label"><?php esc_html_e( 'Estimated AI-O Optimiser storage', 'ai-o-optimiser' ); ?></span>
						<strong class="ai-o-optimiser-card-value"><?php echo esc_html( size_format( $storage['total_bytes'], 2 ) ); ?></strong>
						<span class="ai-o-optimiser-card-sub"><?php echo esc_html( sprintf( /* translators: Placeholder values are replaced with contextual values shown in this message. */
							__( '%1$s raw rows · %2$s aggregate rows', 'ai-o-optimiser' ), number_format_i18n( $storage['raw_rows'] ), number_format_i18n( $storage['aggregate_rows'] ) ) ); ?></span>
					</div>
					<div class="ai-o-optimiser-card">
						<span class="ai-o-optimiser-card-label"><?php esc_html_e( 'Visibility retention', 'ai-o-optimiser' ); ?></span>
						<strong class="ai-o-optimiser-card-value"><?php echo ! empty( $migration['complete'] ) ? esc_html__( 'Compact', 'ai-o-optimiser' ) : esc_html( $migration['progress'] . '%' ); ?></strong>
						<span class="ai-o-optimiser-card-sub"><?php echo ! empty( $migration['complete'] ) ? esc_html__( 'Historic backfill complete', 'ai-o-optimiser' ) : esc_html( sprintf( /* translators: Placeholder values are replaced with contextual values shown in this message. */
							__( '%1$s / %2$s historic rows aggregated', 'ai-o-optimiser' ), number_format_i18n( $migration['processed'] ), number_format_i18n( $migration['total'] ) ) ); ?></span>
					</div>
					<div class="ai-o-optimiser-card">
						<span class="ai-o-optimiser-card-label"><?php esc_html_e( 'Metadata Scan', 'ai-o-optimiser' ); ?></span>
						<strong class="ai-o-optimiser-card-value"><?php echo esc_html( self::status_label( $metadata['status'] ) ); ?></strong>
						<span class="ai-o-optimiser-card-sub"><?php echo $metadata['total'] > 0 ? esc_html( sprintf( /* translators: Placeholder values are replaced with contextual values shown in this message. */
							__( '%1$s%% · %2$s / %3$s checked', 'ai-o-optimiser' ), number_format_i18n( $metadata['progress'] ), number_format_i18n( $metadata['processed'] ), number_format_i18n( $metadata['total'] ) ) ) : esc_html__( 'No active saved scan', 'ai-o-optimiser' ); ?></span>
					</div>
					<div class="ai-o-optimiser-card">
						<span class="ai-o-optimiser-card-label"><?php esc_html_e( 'Schema audit coverage', 'ai-o-optimiser' ); ?></span>
						<strong class="ai-o-optimiser-card-value"><?php echo esc_html( self::status_label( $schema['status'] ) ); ?></strong>
						<span class="ai-o-optimiser-card-sub"><?php echo $schema['total'] > 0 ? esc_html( sprintf( /* translators: Placeholder values are replaced with contextual values shown in this message. */
							__( '%1$s%% · %2$s / %3$s covered', 'ai-o-optimiser' ), number_format_i18n( $schema['progress'] ), number_format_i18n( $schema['processed'] ), number_format_i18n( $schema['total'] ) ) ) : esc_html__( 'No saved audit coverage yet', 'ai-o-optimiser' ); ?></span>
					</div>
				</div>

				<p class="description">
					<strong><?php esc_html_e( 'Cleanup:', 'ai-o-optimiser' ); ?></strong>
					<?php if ( $cleanup['scheduled'] ) : ?>
						<?php echo esc_html( sprintf( /* translators: Placeholder values are replaced with contextual values shown in this message. */
							__( 'daily retention is scheduled; next WordPress event %s.', 'ai-o-optimiser' ), wp_date( 'j M, g:i a', $cleanup['next'], wp_timezone() ) ) ); ?>
					<?php else : ?>
						<?php esc_html_e( 'the daily retention event is not currently scheduled. Review cron/activation state before relying on automatic cleanup.', 'ai-o-optimiser' ); ?>
					<?php endif; ?>
					<?php echo ' ' . esc_html( sprintf( /* translators: Placeholder values are replaced with contextual values shown in this message. */
						__( 'Metadata Queue currently stores %s rows.', 'ai-o-optimiser' ), number_format_i18n( $storage['metadata_rows'] ) ) ); ?>
				</p>

				<details>
					<summary><strong><?php esc_html_e( 'Storage breakdown', 'ai-o-optimiser' ); ?></strong></summary>
					<table class="widefat striped" style="margin-top:10px">
						<thead><tr><th><?php esc_html_e( 'Store', 'ai-o-optimiser' ); ?></th><th><?php esc_html_e( 'Rows', 'ai-o-optimiser' ); ?></th><th><?php esc_html_e( 'Approx. size', 'ai-o-optimiser' ); ?></th></tr></thead>
						<tbody>
						<?php foreach ( $storage['tables'] as $key => $table ) : ?>
							<tr><td><code><?php echo esc_html( $key ); ?></code></td><td><?php echo esc_html( number_format_i18n( (int) ( $table['rows'] ?? 0 ) ) ); ?></td><td><?php echo esc_html( size_format( (int) ( $table['bytes'] ?? 0 ), 2 ) ); ?></td></tr>
						<?php endforeach; ?>
							<tr><td><?php esc_html_e( 'Material plugin options', 'ai-o-optimiser' ); ?></td><td>—</td><td><?php echo esc_html( size_format( $storage['option_bytes'], 2 ) ); ?></td></tr>
						</tbody>
					</table>
				</details>
			</section>
		</div>
		<?php
	}

	/** @return string */
	private static function status_label( $status ) {
		$labels = array(
			'idle'        => __( 'Idle', 'ai-o-optimiser' ),
			'running'     => __( 'Running', 'ai-o-optimiser' ),
			'paused'      => __( 'Paused', 'ai-o-optimiser' ),
			'completed'   => __( 'Complete', 'ai-o-optimiser' ),
			'complete'    => __( 'Complete', 'ai-o-optimiser' ),
			'cancelled'   => __( 'Cancelled', 'ai-o-optimiser' ),
			'partial'     => __( 'Partial', 'ai-o-optimiser' ),
			'not_checked' => __( 'Not checked', 'ai-o-optimiser' ),
		);
		return isset( $labels[ $status ] ) ? $labels[ $status ] : ucfirst( str_replace( '_', ' ', (string) $status ) );
	}
}