<?php
/**
 * dbDelta for the three tables + activation. dbDelta never drops a column or a
 * table, so installs that predate Phase 31 keep a dormant saddle_analytics_conversions
 * table and visitors.conversions / visitors.revenue (DEFAULT 0, never written)
 * until the Saddle Analytics migration removes them.
 */

defined( 'ABSPATH' ) || exit;

final class Saddle_Analytics_Install {

	public static function activate(): void {
		// A migrating site gets its tables BY the migration (renamed or copied);
		// creating empty ones first would force the slow copy path.
		if ( Saddle_Analytics_Migrate::queue_if_needed() ) {
			return;
		}
		self::create_tables();
		Saddle_Analytics_Cron::schedule();
		update_option( 'saddle_analytics_version', SADDLE_ANALYTICS_VERSION, false );
	}

	/**
	 * Activation hooks don't fire on plugin update — re-run dbDelta whenever
	 * the code version moves past the stored one, so schema changes migrate.
	 */
	public static function maybe_upgrade(): void {
		if ( SADDLE_ANALYTICS_VERSION !== get_option( 'saddle_analytics_version' ) ) {
			if ( Saddle_Analytics_Migrate::queue_if_needed() ) {
				return; // The migration's finish step creates the tables and stamps the version.
			}
			self::create_tables();
			update_option( 'saddle_analytics_version', SADDLE_ANALYTICS_VERSION, false );
		}
	}

	public static function tables(): array {
		global $wpdb;
		return array(
			'visitors' => $wpdb->prefix . 'saddle_analytics_visitors',
			'hits'     => $wpdb->prefix . 'saddle_analytics_hits',
			'crawlers' => $wpdb->prefix . 'saddle_analytics_crawlers',
		);
	}

	public static function create_tables(): void {
		global $wpdb;
		require_once ABSPATH . 'wp-admin/includes/upgrade.php';
		$t       = self::tables();
		$charset = $wpdb->get_charset_collate();

		dbDelta(
			"CREATE TABLE {$t['visitors']} (
			visitor_id char(32) NOT NULL,
			first_seen datetime NOT NULL,
			last_seen datetime NOT NULL,
			first_channel tinyint NOT NULL DEFAULT 0,
			first_referrer varchar(191) NULL,
			first_source varchar(100) NULL,
			first_medium varchar(100) NULL,
			first_campaign varchar(100) NULL,
			first_landing varchar(255) NULL,
			last_channel tinyint NOT NULL DEFAULT 0,
			last_referrer varchar(191) NULL,
			last_campaign varchar(100) NULL,
			country char(2) NULL,
			browser varchar(40) NULL,
			os varchar(40) NULL,
			device tinyint NULL,
			pageviews int unsigned NOT NULL DEFAULT 0,
			sessions int unsigned NOT NULL DEFAULT 0,
			PRIMARY KEY  (visitor_id),
			KEY first_channel_seen (first_channel,first_seen),
			KEY last_seen (last_seen),
			KEY first_seen (first_seen)
			) $charset;"
		);

		dbDelta(
			"CREATE TABLE {$t['hits']} (
			id bigint unsigned NOT NULL AUTO_INCREMENT,
			visitor_id char(32) NOT NULL,
			session_id char(32) NOT NULL,
			ts datetime NOT NULL,
			event_type tinyint NOT NULL DEFAULT 1,
			path varchar(255) NOT NULL DEFAULT '/',
			is_entry tinyint(1) NOT NULL DEFAULT 0,
			duration smallint unsigned NULL,
			target varchar(255) NULL,
			PRIMARY KEY  (id),
			KEY ts_event (ts,event_type),
			KEY visitor (visitor_id),
			KEY session_ts (session_id,ts),
			KEY event_session (event_type,session_id,ts)
			) $charset;"
		);

		// Phase 18: one row per bot per UTC day — the AI-crawler report's rollup.
		// UNIQUE(day, bot) makes the write a single INSERT … ON DUPLICATE KEY.
		dbDelta(
			"CREATE TABLE {$t['crawlers']} (
			id bigint unsigned NOT NULL AUTO_INCREMENT,
			day date NOT NULL,
			bot varchar(60) NOT NULL,
			purpose tinyint NOT NULL DEFAULT 0,
			hits int unsigned NOT NULL DEFAULT 0,
			PRIMARY KEY  (id),
			UNIQUE KEY day_bot (day,bot),
			KEY day (day)
			) $charset;"
		);
	}
}