<?php
namespace Strikewise\Install;

use Strikewise\History\Repository;
use Strikewise\Sync\Reconciler;

defined( 'ABSPATH' ) || exit;

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

	const DB_VERSION        = '1';
	const OPTION_DB_VERSION = 'strikewise_db_version';

	public static function activate(): void {
		LegacyName::migrate();
		self::create_table();
		// Record the starting prices of all products once WooCommerce's scheduler is ready.
		update_option( Reconciler::OPTION_SEED_PENDING, '1', false );
	}

	public static function deactivate(): void {
		Reconciler::unschedule_all();
	}

	public static function maybe_upgrade(): void {
		if ( get_option( self::OPTION_DB_VERSION ) !== self::DB_VERSION ) {
			LegacyName::migrate();
			self::create_table();
		}
	}

	private static function create_table(): void {
		global $wpdb;

		require_once ABSPATH . 'wp-admin/includes/upgrade.php';

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

		// dbDelta needs two spaces after PRIMARY KEY and one field per line.
		dbDelta(
			"CREATE TABLE {$table} (
  id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  product_id bigint(20) unsigned NOT NULL,
  parent_id bigint(20) unsigned NOT NULL DEFAULT 0,
  currency char(3) NOT NULL,
  price decimal(19,4) NOT NULL,
  regular_price decimal(19,4) DEFAULT NULL,
  is_reduced tinyint(1) NOT NULL DEFAULT 0,
  valid_from datetime NOT NULL,
  valid_to datetime DEFAULT NULL,
  source varchar(20) NOT NULL,
  user_id bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY  (id),
  KEY product_time (product_id,currency,valid_from),
  KEY parent_id (parent_id),
  KEY valid_to (valid_to)
) {$charset};"
		);

		update_option( self::OPTION_DB_VERSION, self::DB_VERSION, false );
	}
}