<?php
if ( ! defined( 'ABSPATH' ) ) {
    exit;
}

/**
 * Repeatable data migrations for upgrades from earlier 7S Video & Music Gallery releases.
 */
final class SG7G_Upgrade {
    private const VALIDATION_SCHEMA = '4';

    public static function init(): void {
        add_action( 'admin_init', array( __CLASS__, 'run' ), 5 );
    }

    public static function run(): void {
        if ( ! current_user_can( 'manage_options' ) ) {
            return;
        }

        $installed_version = (string) get_option( 'sg7g_plugin_version', '' );

        if ( SG7G_VERSION !== $installed_version ) {
            SG7G_Settings::install_defaults();
            self::migrate_typography_groups();
            self::migrate_sharing_defaults();
            self::migrate_likes_default();
            self::migrate_homepage_defaults();
            self::migrate_featured_area_title_size();
            self::migrate_restored_home_layouts();
            self::prune_retired_settings();
            update_option( 'sg7g_plugin_version', SG7G_VERSION, false );
        }

        self::revalidate_sources();
    }

    /** Enable the new likes feature on upgrades without changing other settings. */
    private static function migrate_likes_default(): void {
        $settings = get_option( 'sg7g_settings', array() );
        if ( ! is_array( $settings ) || array_key_exists( 'show_likes', $settings ) ) {
            return;
        }

        $settings['show_likes'] = 1;
        update_option( 'sg7g_settings', $settings, false );
    }

    /** Add the redesigned home-page controls without changing saved choices. */
    private static function migrate_homepage_defaults(): void {
        $settings = get_option( 'sg7g_settings', array() );
        if ( ! is_array( $settings ) ) {
            return;
        }

        $defaults = SG7G_Settings::defaults();
        $changed  = false;
        foreach ( array( 'show_popular', 'popular_title', 'popular_period', 'popular_count', 'popular_like_color', 'card_title_limit' ) as $key ) {
            if ( ! array_key_exists( $key, $settings ) ) {
                $settings[ $key ] = $defaults[ $key ];
                $changed = true;
            }
        }

        if ( $changed ) {
            update_option( 'sg7g_settings', $settings, false );
        }
    }

    /**
     * Preserve earlier shared title typography when the controls become field-specific.
     */
    private static function migrate_typography_groups(): void {
        $settings = get_option( 'sg7g_settings', array() );
        if ( ! is_array( $settings ) ) {
            return;
        }

        $changed = false;

        if ( ! array_key_exists( 'single_title_font', $settings ) ) {
            $settings['single_title_font'] = (string) ( $settings['title_font'] ?? 'editorial_serif' );
            $changed = true;
        }

        if ( ! array_key_exists( 'single_title_weight', $settings ) ) {
            $settings['single_title_weight'] = absint( $settings['title_weight'] ?? 600 );
            $changed = true;
        }

        if ( ! array_key_exists( 'body_weight', $settings ) ) {
            $settings['body_weight'] = 400;
            $changed = true;
        }

        if ( $changed ) {
            update_option( 'sg7g_settings', $settings, false );
        }
    }

    /**
     * Add sharing keys that did not exist in earlier saved settings without
     * overriding choices that an administrator has already made.
     */
    private static function migrate_sharing_defaults(): void {
        $settings = get_option( 'sg7g_settings', array() );
        if ( ! is_array( $settings ) ) {
            return;
        }

        $defaults = SG7G_Settings::defaults();
        $keys = array(
            'show_sharing',
            'share_facebook',
            'share_x',
            'share_whatsapp',
            'share_telegram',
            'share_linkedin',
            'share_reddit',
            'share_pinterest',
            'share_copy',
        );
        $changed = false;

        foreach ( $keys as $key ) {
            if ( ! array_key_exists( $key, $settings ) ) {
                $settings[ $key ] = (int) ( $defaults[ $key ] ?? 1 );
                $changed = true;
            }
        }

        if ( $changed ) {
            update_option( 'sg7g_settings', $settings, false );
        }
    }


    /** Add the independent featured-area heading size on upgrades. */
    private static function migrate_featured_area_title_size(): void {
        $settings = get_option( 'sg7g_settings', array() );
        if ( ! is_array( $settings ) || array_key_exists( 'featured_area_title_size', $settings ) ) {
            return;
        }

        $settings['featured_area_title_size'] = 32;
        update_option( 'sg7g_settings', $settings, false );
    }


    /** Keep restored home layouts compatible while standardizing Most Liked to four columns. */
    private static function migrate_restored_home_layouts(): void {
        $settings = get_option( 'sg7g_settings', array() );
        if ( ! is_array( $settings ) ) {
            return;
        }

        $changed = false;
        if ( 'spotlight' === (string) ( $settings['featured_layout'] ?? '' ) ) {
            $settings['featured_layout'] = 'editorial_1_4';
            $changed = true;
        }


        $popular_count = absint( $settings['popular_count'] ?? 8 );
        if ( ! in_array( $popular_count, array( 4, 8, 12 ), true ) ) {
            $settings['popular_count'] = $popular_count <= 4 ? 4 : ( $popular_count <= 8 ? 8 : 12 );
            $changed = true;
        }

        if ( $changed ) {
            update_option( 'sg7g_settings', $settings, false );
        }
    }

    /** Remove retired setting keys so upgrades do not carry dead options. */
    private static function prune_retired_settings(): void {
        $settings = get_option( 'sg7g_settings', array() );
        if ( ! is_array( $settings ) ) {
            return;
        }

        $defaults = SG7G_Settings::defaults();
        $clean    = array_intersect_key( $settings, $defaults );

        if ( $clean !== $settings ) {
            update_option( 'sg7g_settings', $clean, false );
        }
    }

    private static function revalidate_sources(): void {
        if ( self::VALIDATION_SCHEMA === (string) get_option( 'sg7g_validation_schema', '' ) ) {
            return;
        }

        $post_ids = get_posts(
            array(
                'post_type'      => 'sg7g_media',
                'post_status'    => array( 'publish', 'draft', 'pending', 'private', 'future' ),
                'posts_per_page' => 50,
                'fields'         => 'ids',
                'orderby'        => 'ID',
                'order'          => 'ASC',
                // phpcs:ignore WordPress.DB.SlowDBQuery.slow_db_query_meta_query -- One-time migration query for legacy validation data.
                'meta_query'     => array(
                    'relation' => 'OR',
                    array(
                        'key'     => '_sg7g_validation_schema',
                        'compare' => 'NOT EXISTS',
                    ),
                    array(
                        'key'     => '_sg7g_validation_schema',
                        'value'   => self::VALIDATION_SCHEMA,
                        'compare' => '!=',
                    ),
                ),
            )
        );

        foreach ( $post_ids as $post_id ) {
            $post_id = absint( $post_id );
            $type    = (string) get_post_meta( $post_id, '_sg7g_media_type', true );
            $source  = (string) get_post_meta( $post_id, '_sg7g_source', true );
            $url     = (string) get_post_meta( $post_id, '_sg7g_source_url', true );
            $file_id = absint( get_post_meta( $post_id, '_sg7g_file_id', true ) );

            if ( ! in_array( $type, array( 'video', 'audio' ), true ) ) {
                $detected = $url ? SG7G_Meta_Boxes::detect_source( $url ) : array();
                $type     = ! empty( $detected['type'] ) ? (string) $detected['type'] : ( str_starts_with( (string) get_post_mime_type( $file_id ), 'audio/' ) ? 'audio' : 'video' );
            }

            $sources = SG7G_Meta_Boxes::sources();
            if ( ! isset( $sources[ $type ][ $source ] ) ) {
                $detected = $url ? SG7G_Meta_Boxes::detect_source( $url ) : array();
                $source   = ! empty( $detected['source'] ) ? (string) $detected['source'] : ( 'audio' === $type ? 'local_audio' : 'local_video' );
            }

            update_post_meta( $post_id, '_sg7g_media_type', $type );
            update_post_meta( $post_id, '_sg7g_source', $source );

            $validation = SG7G_Meta_Boxes::validate_source( $type, $source, $url, $file_id );
            update_post_meta( $post_id, '_sg7g_source_valid', is_wp_error( $validation ) ? 0 : 1 );
            update_post_meta( $post_id, '_sg7g_validation_schema', self::VALIDATION_SCHEMA );

            if ( is_wp_error( $validation ) ) {
                update_post_meta( $post_id, '_sg7g_source_error', $validation->get_error_message() );
            } else {
                delete_post_meta( $post_id, '_sg7g_source_error' );
            }
        }

        if ( count( $post_ids ) < 50 ) {
            update_option( 'sg7g_validation_schema', self::VALIDATION_SCHEMA, false );
        }
    }
}