<?php

namespace Akantio\Woo\Support;

defined( 'ABSPATH' ) || exit;

/**
 * Creates/upgrades the plugin's own tables on activation. Versioned via an
 * option so a schema change only re-runs dbDelta() when it actually needs
 * to, instead of on every activation.
 */
class Activator {

	public const DB_VERSION = '1.0.0';

	private const DB_VERSION_OPTION = 'akantio_woo_db_version';

	public static function activate(): void {
		if ( get_option( self::DB_VERSION_OPTION ) === self::DB_VERSION ) {
			return;
		}

		self::createStockSyncsTable();

		update_option( self::DB_VERSION_OPTION, self::DB_VERSION );
	}

	/**
	 * akantio_pos_stock_syncs tracks which POS orders have already had their
	 * stock delta applied to WooCommerce — the "Stock-only Sync" mode's
	 * equivalent of OrderBuilder's pos_order_id-tagged order, since that mode
	 * never creates an order to tag (see StockSyncBuilder).
	 */
	private static function createStockSyncsTable(): void {
		global $wpdb;

		require_once ABSPATH . 'wp-admin/includes/upgrade.php';

		$table   = $wpdb->prefix . 'akantio_pos_stock_syncs';
		$charset = $wpdb->get_charset_collate();

		$sql = "CREATE TABLE {$table} (
			id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
			pos_order_id VARCHAR(191) NOT NULL,
			product_updates LONGTEXT NOT NULL,
			synced_at DATETIME NOT NULL,
			PRIMARY KEY  (id),
			UNIQUE KEY pos_order_id (pos_order_id)
		) {$charset};";

		dbDelta( $sql );
	}
}