<?php
/**
 * Activation, upgrades and database schema.
 *
 * @package AriConsent
 */

namespace AriConsent;

defined( 'ABSPATH' ) || exit;

/**
 * Creates and upgrades the consent log table.
 */
final class Installer {

	/**
	 * Runs on activation.
	 */
	public static function activate() {
		self::create_tables();
		update_option( 'ariconsent_db_version', ARICONSENT_DB_VERSION, false );
		if ( ! wp_next_scheduled( ConsentLog::CRON_HOOK ) ) {
			wp_schedule_event( time() + HOUR_IN_SECONDS, 'daily', ConsentLog::CRON_HOOK );
		}
		if ( ! wp_next_scheduled( Health::CRON_HOOK ) ) {
			wp_schedule_event( time() + DAY_IN_SECONDS, 'weekly', Health::CRON_HOOK );
		}
		if ( false === get_option( Settings::OPTION, false ) ) {
			add_option( Settings::OPTION, array(), '', true );
		}
	}

	/**
	 * Runs on deactivation.
	 */
	public static function deactivate() {
		wp_clear_scheduled_hook( ConsentLog::CRON_HOOK );
		wp_clear_scheduled_hook( Health::CRON_HOOK );
	}

	/**
	 * Upgrades when the stored DB version differs.
	 */
	public static function maybe_upgrade() {
		if ( get_option( 'ariconsent_db_version' ) !== ARICONSENT_DB_VERSION ) {
			self::activate();
		}
	}

	/**
	 * Creates the consent log table.
	 */
	public static function create_tables() {
		global $wpdb;
		require_once ABSPATH . 'wp-admin/includes/upgrade.php';

		$table   = ConsentLog::table();
		$charset = $wpdb->get_charset_collate();

		dbDelta(
			"CREATE TABLE {$table} (
			id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
			consent_id char(36) NOT NULL,
			created_at datetime NOT NULL,
			revision int(10) unsigned NOT NULL DEFAULT 1,
			action varchar(20) NOT NULL,
			categories text NOT NULL,
			snapshot char(64) NOT NULL DEFAULT '',
			PRIMARY KEY  (id),
			KEY consent_id (consent_id),
			KEY created_at (created_at)
		) {$charset};"
		);

		$snapshots = Snapshots::table();
		dbDelta(
			"CREATE TABLE {$snapshots} (
			id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
			hash char(64) NOT NULL,
			created_at datetime NOT NULL,
			content longtext NOT NULL,
			PRIMARY KEY  (id),
			UNIQUE KEY hash (hash)
		) {$charset};"
		);
	}
}