<?php
/**
 * Activation / deactivation: seed options, create the AI-crawler hit log table.
 *
 * @package AICitare
 */

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

class AICitare_Activator {

	public static function activate() {
		// Seed options only if absent (don't clobber existing data).
		// Start with an EMPTY page dataset — real posts are populated on the
		// first scan. The demo dataset only appears when Demo data is enabled.
		if ( false === get_option( AICITARE_OPT_PAGES ) ) {
			add_option( AICITARE_OPT_PAGES, array() );
		}
		if ( false === get_option( AICITARE_OPT_FIXED ) ) {
			add_option( AICITARE_OPT_FIXED, array() );
		}
		if ( false === get_option( AICITARE_OPT_BOTS ) ) {
			add_option( AICITARE_OPT_BOTS, AICitare_Data::default_bots() );
		}
		if ( false === get_option( AICITARE_OPT_SETTINGS ) ) {
			add_option( AICITARE_OPT_SETTINGS, AICitare_Data::default_settings() );
		}
		if ( false === get_option( AICITARE_OPT_HISTORY ) ) {
			add_option( AICITARE_OPT_HISTORY, AICitare_Data::default_history() );
		}

		self::create_tables();
		update_option( 'aicitare_db_ver', self::DB_VERSION );

		// Schedule the recurring background scan (spec: async background scans).
		if ( ! wp_next_scheduled( 'aicitare_daily_scan' ) ) {
			wp_schedule_event( time() + DAY_IN_SECONDS, 'daily', 'aicitare_daily_scan' );
		}
		if ( ! wp_next_scheduled( 'aicitare_weekly_visibility' ) ) {
			wp_schedule_event( time() + WEEK_IN_SECONDS, 'weekly', 'aicitare_weekly_visibility' );
		}
		if ( ! wp_next_scheduled( 'aicitare_monthly_report' ) ) {
			wp_schedule_event( time() + 30 * DAY_IN_SECONDS, 'aicitare_monthly', 'aicitare_monthly_report' );
		}
		// Demo mode is off by default — populate real data with an initial scan shortly after activation.
		wp_schedule_single_event( time() + 10, 'aicitare_daily_scan' );

		// Refresh rewrite rules so /llms.txt is served.
		flush_rewrite_rules();

		AICitare_Log::add( 'activated', 'Plugin activated (v' . AICITARE_VERSION . ')' );
	}

	public static function deactivate() {
		foreach ( array( 'aicitare_daily_scan', 'aicitare_weekly_visibility', 'aicitare_monthly_report' ) as $hook ) {
			$ts = wp_next_scheduled( $hook );
			if ( $ts ) {
				wp_unschedule_event( $ts, $hook );
			}
		}
		flush_rewrite_rules();
	}

	/**
	 * Danger Zone: wipe all plugin-collected data and return to a fresh-install
	 * state (scans, scores, history, logs, AI-visibility data, and the content
	 * blocks the plugin injected into posts). User posts themselves are kept.
	 */
	public static function reset() {
		global $wpdb;

		$options = array(
			AICITARE_OPT_PAGES, AICITARE_OPT_FIXED, AICITARE_OPT_BOTS, AICITARE_OPT_SETTINGS,
			AICITARE_OPT_HISTORY, 'aicitare_page_hist', 'aicitare_gsc', 'aicitare_docker_cutoff',
			'aicitare_citations_live', 'aicitare_vis_checked', 'aicitare_engine_status',
			'aicitare_answers', 'aicitare_vis_history', 'aicitare_competitors',
			'aicitare_share', 'aicitare_discovered', 'aicitare_prompts',
		);
		foreach ( $options as $o ) {
			delete_option( $o );
		}

		// Empty the custom tables (keep the schema).
		self::create_tables();
		foreach ( array( 'aicitare_bot_hits', 'aicitare_logs', 'aicitare_ai_refs' ) as $t ) {
			$table = $wpdb->prefix . $t;
			$wpdb->query( "TRUNCATE TABLE {$table}" ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- table name is $wpdb->prefix + a hardcoded literal; cannot be a bound parameter.
		}

		// Link-check transients.
		$wpdb->query( "DELETE FROM {$wpdb->options} WHERE option_name LIKE '\_transient\_aicitare_lnk2\_%' OR option_name LIKE '\_transient\_timeout\_aicitare_lnk2\_%'" ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter

		// Content blocks the plugin injected into posts.
		foreach ( array( '_aicitare_import_source', '_aicitare_rephrase_source', '_aicitare_faq', '_aicitare_pros', '_aicitare_cons', '_aicitare_table', '_aicitare_rating', '_aicitare_rating_count', '_aicitare_reviewer', '_aicitare_price', '_aicitare_currency' ) as $mk ) {
			delete_post_meta_by_key( $mk );
		}

		// Re-seed a clean first-install state.
		add_option( AICITARE_OPT_PAGES, array() );
		add_option( AICITARE_OPT_FIXED, array() );
		add_option( AICITARE_OPT_BOTS, AICitare_Data::default_bots() );
		add_option( AICITARE_OPT_SETTINGS, AICitare_Data::default_settings() );

		AICitare_Log::add( 'reset', 'All plugin data reset to first-install state' );
	}

	/** Custom table for real AI-crawler hit logging (mod_5 in the spec). */
	public static function create_tables() {
		global $wpdb;
		require_once ABSPATH . 'wp-admin/includes/upgrade.php';
		$charset = $wpdb->get_charset_collate();
		$table   = $wpdb->prefix . 'aicitare_bot_hits';

		$sql = "CREATE TABLE {$table} (
			id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
			bot_name VARCHAR(80) NOT NULL DEFAULT '',
			url VARCHAR(255) NOT NULL DEFAULT '',
			user_agent VARCHAR(255) NOT NULL DEFAULT '',
			ip VARCHAR(64) NOT NULL DEFAULT '',
			hit_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
			PRIMARY KEY  (id),
			KEY bot_name (bot_name),
			KEY hit_at (hit_at)
		) {$charset};";

		dbDelta( $sql );

		$logs = $wpdb->prefix . 'aicitare_logs';
		$sql2 = "CREATE TABLE {$logs} (
			id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
			action VARCHAR(60) NOT NULL DEFAULT '',
			detail VARCHAR(255) NOT NULL DEFAULT '',
			log_user VARCHAR(60) NOT NULL DEFAULT '',
			created_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
			PRIMARY KEY  (id),
			KEY created_at (created_at)
		) {$charset};";

		dbDelta( $sql2 );

		$refs = $wpdb->prefix . 'aicitare_ai_refs';
		$sql3 = "CREATE TABLE {$refs} (
			id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
			source VARCHAR(40) NOT NULL DEFAULT '',
			url VARCHAR(255) NOT NULL DEFAULT '',
			ref_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
			PRIMARY KEY  (id),
			KEY source (source),
			KEY ref_at (ref_at)
		) {$charset};";

		dbDelta( $sql3 );
	}

	/**
	 * DB/schema version. Bump when tables or rewrite rules change so existing
	 * installs upgrade on the next admin load (activation hooks don't run on update).
	 */
	const DB_VERSION = '2';

	/** Run pending migrations for already-active installs (called on plugins_loaded). */
	public static function maybe_upgrade() {
		if ( get_option( 'aicitare_db_ver' ) === self::DB_VERSION ) {
			return;
		}
		self::create_tables();
		flush_rewrite_rules();
		update_option( 'aicitare_db_ver', self::DB_VERSION );
	}
}