<?php
/**
 * Activation, deactivation and database schema.
 *
 * @package Tidelist
 */

namespace Tidelist\Install;

use Tidelist\Data\AccountRepository;
use Tidelist\Data\ListingRepository;
use Tidelist\Jobs\DailyMaintenance;
use Tidelist\Log\DbLogger;
use Tidelist\Settings\Settings;

/**
 * Activation, deactivation and database schema.
 */
final class Installer {

	const DB_VERSION        = 5;
	const DB_VERSION_OPTION = 'tidelist_db_version';

	/**
	 * Plugin activation: create tables and default settings (dry-run ON).
	 */
	public static function activate(): void {
		self::create_tables();
		add_option( Settings::OPTION, Settings::defaults(), '', 'no' );
		update_option( self::DB_VERSION_OPTION, self::DB_VERSION, false );
		set_transient( 'tidelist_activation_redirect', 1, MINUTE_IN_SECONDS ); // Opens the first-run guide once.
	}

	/**
	 * Plugin deactivation: stop scheduled jobs. Data and settings are kept.
	 */
	public static function deactivate(): void {
		if ( function_exists( 'as_unschedule_all_actions' ) ) {
			as_unschedule_all_actions( DailyMaintenance::HOOK, array(), DailyMaintenance::GROUP );
		}
	}

	/**
	 * Runs schema updates after a plugin update.
	 */
	public static function maybe_upgrade(): void {
		if ( (int) get_option( self::DB_VERSION_OPTION, 0 ) < self::DB_VERSION ) {
			self::activate();
		}
	}

	/**
	 * Creates or updates the plugin's own tables.
	 */
	private static function create_tables(): void {
		global $wpdb;
		require_once ABSPATH . 'wp-admin/includes/upgrade.php';

		$charset_collate = $wpdb->get_charset_collate();
		$log_table       = DbLogger::table();

		dbDelta(
			"CREATE TABLE {$log_table} (
				id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
				created_at datetime NOT NULL,
				level varchar(10) NOT NULL,
				channel varchar(30) NOT NULL,
				message text NOT NULL,
				context longtext NULL,
				PRIMARY KEY  (id),
				KEY created_at (created_at),
				KEY level (level)
			) {$charset_collate};"
		);
		dbDelta( ListingRepository::schema( $charset_collate ) );
		dbDelta( AccountRepository::schema( $charset_collate ) );
	}
}