<?php
/** Add Phase 10 binding, integrity and idempotency fields to external documents. @package Leanmerce\CommerceCompliance */
namespace Leanmerce\CommerceCompliance\Infrastructure\Database\Migration;

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

use Leanmerce\CommerceCompliance\Infrastructure\Database\MigrationInterface;
use Leanmerce\CommerceCompliance\Infrastructure\Database\TableNames;
final class EnhancePhase10ExternalDocuments implements MigrationInterface {
	public function version(): int {
		return 3; }
	public function run(): bool {
		global $wpdb;
		if ( ! isset( $wpdb ) || ! method_exists( $wpdb, 'get_charset_collate' ) ) {
			return true; }
		if ( ! function_exists( 'dbDelta' ) ) {
			$upgrade_file = ABSPATH . 'wp-admin/includes/upgrade.php';
			if ( is_readable( $upgrade_file ) ) {
				require_once $upgrade_file; }
		}
		if ( ! function_exists( 'dbDelta' ) ) {
			return false; }
		$table   = $wpdb->prefix . TableNames::EXTERNAL_DOCUMENTS;
		$collate = $wpdb->get_charset_collate();
		dbDelta(
			"CREATE TABLE {$table} (
            id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
            uuid char(36) NOT NULL,
            order_id bigint(20) unsigned NOT NULL,
            snapshot_id bigint(20) unsigned NULL,
            snapshot_hash char(64) NULL,
            provider varchar(96) NOT NULL,
            document_type varchar(64) NOT NULL,
            external_id varchar(191) NULL,
            issue_date datetime NULL,
            source_kind varchar(32) NOT NULL DEFAULT 'reference',
            storage_key varchar(255) NULL,
            external_reference varchar(255) NULL,
            mime_type varchar(128) NULL,
            file_hash char(64) NULL,
            file_size bigint(20) unsigned NULL,
            status varchar(32) NOT NULL DEFAULT 'registered',
            idempotency_key char(64) NULL,
            metadata_json longtext NULL,
            created_at datetime NOT NULL,
            PRIMARY KEY  (id),
            UNIQUE KEY uuid (uuid),
            UNIQUE KEY idempotency_key (idempotency_key),
            KEY order_id (order_id),
            KEY snapshot_id (snapshot_id),
            KEY provider (provider),
            KEY provider_external (provider,external_id)
        ) {$collate};"
		); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Internal allowlisted table name.
		return true;
	}
}