<?php

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

class AIEO_DMM_Supplier_Extras extends AIEO_DMM_Module_Base {

    public function get_id()       { return 'supplier_extras'; }
    public function get_icon()     { return 'building'; }
    public function get_label()    { return __('Supplier metadata', 'ai-eshop-optimizer'); }
    public function get_priority() { return 79; }
    public function get_group()    { return 'visuals'; }

    
    public function get_tabs() {
        return array(
            'commercial' => array('label' => __('Commercial', 'ai-eshop-optimizer'), 'icon' => 'banknote'),
            'related'    => array('label' => __('Related', 'ai-eshop-optimizer'), 'icon' => 'link'),
        );
    }

    
    public function get_tab_base_url() {
        $tax = AIEO_DMM_Supplier_Extras_Data::managed_taxonomies();
        $tax = !empty($tax) ? (string) reset($tax) : 'supplier';
        return admin_url('edit-tags.php?taxonomy=' . rawurlencode($tax));
    }

    public function register_hooks() {
        
        
        
        
        
        add_action('init', array($this, 'register_supplier_taxonomy'), 9);

        
        $migrator_file = AIEO_DIR . 'includes/dmm/migrators/class-aieo-dmm-supplier-pods-migrator.php';
        if (file_exists($migrator_file)) {
            require_once $migrator_file;
            if (class_exists('AIEO_DMM_Supplier_Pods_Migrator')) {
                AIEO_DMM_Supplier_Pods_Migrator::register();
            }
        }

        
        add_filter('aieo_dmm_related_tab_taxonomies', array($this, 'register_supplier_in_related_tab'));
        
        
        
        add_filter('aieo_dmm_related_tab_axes', array($this, 'register_supplier_axis'));
        
        
        add_filter('aieo_dmm_related_tab_axes_for_source', array($this, 'limit_supplier_axes'), 10, 2);
        
        
        
        
        
        
        if (class_exists('AIEO_DMM_Related_Tab')) {
            add_action('edited_supplier',  array('AIEO_DMM_Related_Tab', 'on_term_save'), 10, 2);
            add_action('created_supplier', array('AIEO_DMM_Related_Tab', 'on_term_save'), 10, 2);
        }

        if (!is_admin()) { return; }

        
        
        
        
        add_action('admin_enqueue_scripts', array($this, 'enqueue_term_admin_assets'));

        foreach (AIEO_DMM_Supplier_Extras_Data::managed_taxonomies() as $tax) {
            add_action($tax . '_edit_form_fields', array($this, 'render_term_extras'), 1, 2);
            add_action('edited_'  . $tax,         array($this, 'save_term_extras'),    10, 2);
            add_action('created_' . $tax,         array($this, 'save_term_extras'),    10, 2);
        }
    }

    
    public function enqueue_term_admin_assets($hook) {
        if ($hook !== 'term.php') { return; }
        $tax = isset($_GET['taxonomy']) ? sanitize_key(wp_unslash($_GET['taxonomy'])) : ''; 
        if (!in_array($tax, AIEO_DMM_Supplier_Extras_Data::managed_taxonomies(), true)) { return; }

        wp_enqueue_media();
 wp_enqueue_editor(); 
        wp_enqueue_style(
            'aieo-dmm-category-extras-admin',
            AIEO_URI . 'assets/css/aieo-dmm-category-extras-admin.css',
            array(), AIEO_VERSION
        );
        wp_enqueue_script(
            'aieo-dmm-category-extras-admin',
            AIEO_URI . 'assets/js/aieo-dmm-category-extras-admin.js',
            array('jquery'), AIEO_VERSION, true
        );
        wp_localize_script('aieo-dmm-category-extras-admin', 'aieoCategoryExtras', array(
            'ajaxurl' => admin_url('admin-ajax.php'),
            'nonce'   => wp_create_nonce(AIEO_DMM::NONCE_ACTION),
            'i18n'    => array(
                'noResults' => __('No matches.', 'ai-eshop-optimizer'),
                'searching' => __('Searching…', 'ai-eshop-optimizer'),
                'pickImage' => __('Select image', 'ai-eshop-optimizer'),
                'useImage'  => __('Use this image', 'ai-eshop-optimizer'),
            ),
        ));
    }

    public function register_supplier_in_related_tab(array $taxonomies) {
        if (!in_array('supplier', $taxonomies, true)) {
            $taxonomies[] = 'supplier';
        }
        return $taxonomies;
    }

    
    public function register_supplier_axis(array $axes) {
        if (!isset($axes['supplier'])) {
            $axes['supplier'] = array('term', 'supplier', __('Related suppliers', 'ai-eshop-optimizer'), 'term:supplier');
        }
        return $axes;
    }

    
    public function limit_supplier_axes($axes, $source) {
        if ($source === 'supplier') {
            return array_intersect_key((array) $axes, array('product_brand' => true));
        }
        return $axes;
    }

    
    public function register_supplier_taxonomy() {
        if (taxonomy_exists('supplier')) {
            return;
        }
        register_taxonomy('supplier', array('product'), array(
            'labels' => array(
                'name'              => __('Suppliers', 'ai-eshop-optimizer'),
                'singular_name'     => __('Supplier', 'ai-eshop-optimizer'),
                'menu_name'         => __('Suppliers', 'ai-eshop-optimizer'),
                'all_items'         => __('All Suppliers', 'ai-eshop-optimizer'),
                'search_items'      => __('Search Suppliers', 'ai-eshop-optimizer'),
                'edit_item'         => __('Edit Supplier', 'ai-eshop-optimizer'),
                'update_item'       => __('Update Supplier', 'ai-eshop-optimizer'),
                'add_new_item'      => __('Add New Supplier', 'ai-eshop-optimizer'),
                'new_item_name'     => __('New Supplier Name', 'ai-eshop-optimizer'),
                'not_found'         => __('No suppliers found.', 'ai-eshop-optimizer'),
            ),
            'public'             => false,
            'publicly_queryable' => false,
            'show_ui'            => true,
            'show_in_menu'       => true,   
            'show_admin_column'  => false,
            'show_in_rest'       => true,
            'hierarchical'       => false,
            'query_var'          => false,
            'rewrite'            => false,
            'capabilities'       => array(
                'manage_terms' => 'manage_woocommerce',
                'edit_terms'   => 'manage_woocommerce',
                'delete_terms' => 'manage_woocommerce',
                'assign_terms' => 'edit_products',
            ),
        ));
    }

    public function render_term_extras($term, $taxonomy) {
        if (!is_object($term) || !isset($term->term_id)) { return; }
        if (!in_array($taxonomy, AIEO_DMM_Supplier_Extras_Data::managed_taxonomies(), true)) { return; }

        $row = AIEO_DMM_Supplier_Extras_Data::get($taxonomy, (int) $term->term_id);
        ?>
        <tr class="form-field aieo-ce-panel-row">
            <th colspan="2" style="padding:0;">
                <div class="aieo-ce-panel" data-aieo-ce-panel data-term-id="<?php echo (int) $term->term_id; ?>" data-taxonomy="<?php echo esc_attr($taxonomy); ?>">
                    <?php wp_nonce_field('aieo_se_term_edit_' . (int) $term->term_id, 'aieo_se_nonce'); ?>
                    <div class="aieo-ce-panel-head">
                        <h2><?php esc_html_e('Rooster One Supplier Extras', 'ai-eshop-optimizer'); ?></h2>
                        <p class="description"><?php esc_html_e('Stored in wp_aieo_dmm_supplier_extras + wp_aieo_dmm_term_relations. Replaces the Pods supplier fields.', 'ai-eshop-optimizer'); ?></p>
                    </div>

                    <nav class="aieo-ce-tabs" role="tablist">
                        <button type="button" class="aieo-ce-tab is-active" data-aieo-ce-tab="commercial" role="tab" aria-selected="true"><?php esc_html_e('Commercial', 'ai-eshop-optimizer'); ?></button>
                        <button type="button" class="aieo-ce-tab"           data-aieo-ce-tab="related"    role="tab" aria-selected="false"><?php esc_html_e('Related', 'ai-eshop-optimizer'); ?></button>
                    </nav>

                    <!-- ── Tab: Commercial ───────────────────────────────── -->
                    <div class="aieo-ce-tabpanel is-active" data-aieo-ce-pane="commercial" role="tabpanel">
                        <div class="aieo-ce-grid-2">
                            <div class="aieo-ce-field">
                                <label for="aieo-se-email"><?php esc_html_e('Email (orders / accounts)', 'ai-eshop-optimizer'); ?></label>
                                <input type="email" id="aieo-se-email" name="aieo_se[email]" value="<?php echo esc_attr((string) $row['email']); ?>" class="regular-text" />
                            </div>
                            <div class="aieo-ce-field">
                                <label for="aieo-se-owner"><?php esc_html_e('Internal owner (WP user)', 'ai-eshop-optimizer'); ?></label>
                                <?php wp_dropdown_users(array(
                                    'name'              => 'aieo_se[supplier_owner_user_id]',
                                    'id'                => 'aieo-se-owner',
                                    'selected'          => (int) ($row['supplier_owner_user_id'] ?? 0),
                                    'show_option_none'  => __('— none —', 'ai-eshop-optimizer'),
                                    'option_none_value' => 0,
                                    'capability'        => 'manage_woocommerce',
                                )); ?>
                                <p class="description"><?php esc_html_e('The internal user accountable for this supplier. Staff with shop-management rights are listed.', 'ai-eshop-optimizer'); ?></p>
                            </div>
                        </div>
                        <div class="aieo-ce-grid-2">
                            <div class="aieo-ce-field">
                                <label for="aieo-se-lead-time"><?php esc_html_e('Lead time (days)', 'ai-eshop-optimizer'); ?></label>
                                <input type="number" id="aieo-se-lead-time" name="aieo_se[lead_time_days]" value="<?php echo $row['lead_time_days'] !== null ? (int) $row['lead_time_days'] : ''; ?>" min="0" class="small-text" />
                                <p class="description"><?php esc_html_e('Typical days from PO to delivery.', 'ai-eshop-optimizer'); ?></p>
                            </div>
                            <div class="aieo-ce-field">
                                <label for="aieo-se-payment-terms"><?php esc_html_e('Payment terms (days)', 'ai-eshop-optimizer'); ?></label>
                                <input type="number" id="aieo-se-payment-terms" name="aieo_se[payment_terms_days]" value="<?php echo $row['payment_terms_days'] !== null ? (int) $row['payment_terms_days'] : ''; ?>" min="0" class="small-text" />
                                <p class="description"><?php esc_html_e('Net-N invoice terms (e.g. 30 = net-30).', 'ai-eshop-optimizer'); ?></p>
                            </div>
                        </div>
                        <div class="aieo-ce-grid-2">
                            <div class="aieo-ce-field">
                                <label for="aieo-se-discount"><?php esc_html_e('Special discount (%)', 'ai-eshop-optimizer'); ?></label>
                                <input type="number" id="aieo-se-discount" name="aieo_se[special_discount_pct]" value="<?php echo esc_attr((string) number_format((float) $row['special_discount_pct'], 2, '.', '')); ?>" min="0" max="100" step="0.01" class="small-text" />
                                <p class="description"><?php esc_html_e('Operator-negotiated baseline discount on this supplier\'s catalogue.', 'ai-eshop-optimizer'); ?></p>
                            </div>
                            <div class="aieo-ce-field">
                                <label for="aieo-se-vat"><?php esc_html_e('VAT number', 'ai-eshop-optimizer'); ?></label>
                                <input type="text" id="aieo-se-vat" name="aieo_se[vat_code]" value="<?php echo esc_attr((string) $row['vat_code']); ?>" class="regular-text" />
                            </div>
                        </div>

                        <!-- ERP identity + contact: the fields the ERP master record carries. -->
                        <div class="aieo-ce-grid-2">
                            <div class="aieo-ce-field">
                                <label for="aieo-se-erp-id"><?php esc_html_e('ERP id', 'ai-eshop-optimizer'); ?></label>
                                <input type="text" id="aieo-se-erp-id" name="aieo_se[erp_id]" value="<?php echo esc_attr((string) $row['erp_id']); ?>" class="regular-text" />
                                <p class="description"><?php esc_html_e('The supplier\'s id in the ERP. Filled by the legacy-table migration; edit only if the ERP record changed.', 'ai-eshop-optimizer'); ?></p>
                            </div>
                            <div class="aieo-ce-field">
                                <label for="aieo-se-erp-sku"><?php esc_html_e('ERP supplier code', 'ai-eshop-optimizer'); ?></label>
                                <input type="text" id="aieo-se-erp-sku" name="aieo_se[erp_sku_code]" value="<?php echo esc_attr((string) $row['erp_sku_code']); ?>" class="regular-text" />
                            </div>
                        </div>
                        <div class="aieo-ce-grid-2">
                            <div class="aieo-ce-field">
                                <label for="aieo-se-addr1"><?php esc_html_e('Address', 'ai-eshop-optimizer'); ?></label>
                                <input type="text" id="aieo-se-addr1" name="aieo_se[address_line_1]" value="<?php echo esc_attr((string) $row['address_line_1']); ?>" class="regular-text" />
                            </div>
                            <div class="aieo-ce-field">
                                <label for="aieo-se-region"><?php esc_html_e('Region', 'ai-eshop-optimizer'); ?></label>
                                <input type="text" id="aieo-se-region" name="aieo_se[address_region]" value="<?php echo esc_attr((string) $row['address_region']); ?>" class="regular-text" />
                            </div>
                        </div>
                        <div class="aieo-ce-grid-2">
                            <div class="aieo-ce-field">
                                <label for="aieo-se-city"><?php esc_html_e('City', 'ai-eshop-optimizer'); ?></label>
                                <input type="text" id="aieo-se-city" name="aieo_se[address_city]" value="<?php echo esc_attr((string) $row['address_city']); ?>" class="regular-text" />
                            </div>
                            <div class="aieo-ce-field">
                                <label for="aieo-se-postal"><?php esc_html_e('Postal code', 'ai-eshop-optimizer'); ?></label>
                                <input type="text" id="aieo-se-postal" name="aieo_se[address_postal_code]" value="<?php echo esc_attr((string) $row['address_postal_code']); ?>" class="regular-text" />
                            </div>
                        </div>
                        <div class="aieo-ce-grid-2">
                            <div class="aieo-ce-field">
                                <label for="aieo-se-tel1"><?php esc_html_e('Telephone', 'ai-eshop-optimizer'); ?></label>
                                <input type="text" id="aieo-se-tel1" name="aieo_se[tel_1]" value="<?php echo esc_attr((string) $row['tel_1']); ?>" class="regular-text" />
                            </div>
                            <div class="aieo-ce-field">
                                <label for="aieo-se-tel2"><?php esc_html_e('Telephone 2 / fax', 'ai-eshop-optimizer'); ?></label>
                                <input type="text" id="aieo-se-tel2" name="aieo_se[tel_2]" value="<?php echo esc_attr((string) $row['tel_2']); ?>" class="regular-text" style="width:48%;" />
                                <input type="text" id="aieo-se-fax" name="aieo_se[fax]" value="<?php echo esc_attr((string) $row['fax']); ?>" class="regular-text" style="width:48%;" placeholder="<?php esc_attr_e('fax', 'ai-eshop-optimizer'); ?>" />
                            </div>
                        </div>
                        <div class="aieo-ce-grid-2">
                            <div class="aieo-ce-field">
                                <label for="aieo-se-url"><?php esc_html_e('Website', 'ai-eshop-optimizer'); ?></label>
                                <input type="url" id="aieo-se-url" name="aieo_se[corporate_url]" value="<?php echo esc_attr((string) $row['corporate_url']); ?>" class="regular-text" />
                            </div>
                            <div class="aieo-ce-field">
                                <label for="aieo-se-corp-email"><?php esc_html_e('Corporate email', 'ai-eshop-optimizer'); ?></label>
                                <input type="email" id="aieo-se-corp-email" name="aieo_se[corporate_email]" value="<?php echo esc_attr((string) $row['corporate_email']); ?>" class="regular-text" />
                                <p class="description"><?php esc_html_e('The company\'s general address from the ERP; the orders/accounts email above is the one your team actually writes to.', 'ai-eshop-optimizer'); ?></p>
                            </div>
                        </div>
                        <div class="aieo-ce-field aieo-ce-rich-field">
                            <label for="aieo_se_notes"><?php esc_html_e('Internal notes', 'ai-eshop-optimizer'); ?></label>
                            <?php wp_editor(
                                (string) $row['notes'],
                                'aieo_se_notes',
                                array(
                                    'textarea_name' => 'aieo_se[notes]',
                                    'textarea_rows' => 5,
                                    'media_buttons' => false,
                                    'teeny'         => true,
                                    'quicktags'     => true,
                                )
                            ); ?>
                            <p class="description"><?php esc_html_e('Operator notes (private). Not shown to customers.', 'ai-eshop-optimizer'); ?></p>
                        </div>
                    </div>

                    <!-- ── Tab: Related ──────────────────────────────────── -->
                    <div class="aieo-ce-tabpanel" data-aieo-ce-pane="related" role="tabpanel">
                        <?php
                        
                        
                        
                        $aieo_se_map = $GLOBALS['wpdb']->prefix . 'aieo_dmm_supplier_sku_map';
                        if (function_exists('aieo_dmm_table_exists') && aieo_dmm_table_exists($aieo_se_map)) {
                            $aieo_se_n = (int) $GLOBALS['wpdb']->get_var($GLOBALS['wpdb']->prepare(
                                "SELECT COUNT(*) FROM `{$aieo_se_map}` WHERE supplier_term_id = %d",
                                (int) $term->term_id
                            ));
                            echo '<p class="description" style="margin-bottom:14px;">' . esc_html(sprintf(
                                
                                _n('%d product SKU is mapped to this supplier from the ERP catalogue.', '%d product SKUs are mapped to this supplier from the ERP catalogue.', $aieo_se_n, 'ai-eshop-optimizer'),
                                $aieo_se_n
                            )) . '</p>';
                        }
                        if (class_exists('AIEO_DMM_Related_Tab')) {
                            AIEO_DMM_Related_Tab::render($taxonomy, (int) $term->term_id);
                        } else {
                            echo '<p>' . esc_html__('Related-tab component unavailable.', 'ai-eshop-optimizer') . '</p>';
                        }
                        ?>
                    </div>
                </div>
            </th>
        </tr>
        <?php
    }

    public function save_term_extras($term_id, $tt_id = 0) {
        $term_id = (int) $term_id;
        if (!$term_id) { return; }
        if (empty($_POST['aieo_se_nonce']) || !wp_verify_nonce(
            sanitize_key(wp_unslash($_POST['aieo_se_nonce'])),
            'aieo_se_term_edit_' . $term_id
        )) { return; }
        if (empty($_POST['aieo_se']) || !is_array($_POST['aieo_se'])) { return; }

        $term = get_term($term_id);
        if (!$term || is_wp_error($term)) { return; }
        if (!in_array($term->taxonomy, AIEO_DMM_Supplier_Extras_Data::managed_taxonomies(), true)) { return; }

        $raw = wp_unslash($_POST['aieo_se']);
        if (!is_array($raw)) { return; }

        $patch = array();
        foreach (array(
            'email', 'lead_time_days', 'payment_terms_days', 'special_discount_pct',
            'supplier_owner_user_id', 'notes',
            'erp_id', 'erp_sku_code', 'vat_code',
            'address_line_1', 'address_region', 'address_city', 'address_postal_code',
            'tel_1', 'tel_2', 'fax', 'corporate_url', 'corporate_email',
        ) as $field) {
            if (isset($raw[$field])) { $patch[$field] = $raw[$field]; }
        }

        AIEO_DMM_Supplier_Extras_Data::save($term->taxonomy, $term_id, $patch);
    }

    public function render_subtab() {
        
        
        
        
        global $wpdb;
        $supplier_count = (int) $wpdb->get_var('SELECT COUNT(*) FROM ' . AIEO_DMM_Supplier_Extras_Data::table());
        $directory      = $this->supplier_directory();
        $has_pods       = class_exists('AIEO_DMM_Supplier_Pods_Migrator') && AIEO_DMM_Supplier_Pods_Migrator::has_pods_source();

        list($open, $close) = AIEO_DMM_UI::card(array(
            'anchor'      => 'supplier-extras-overview',
            'icon'        => 'circle-question-mark',
            'title'       => __('Supplier metadata', 'ai-eshop-optimizer'),
            'description' => __('Pods-free per-supplier metadata. Edit individual suppliers at WooCommerce → Products → Suppliers → click a supplier. Related Brands are stored bidirectionally in wp_aieo_dmm_term_relations.', 'ai-eshop-optimizer'),
            'col'         => 2,
        ));
        echo $open; 
        echo '<div class="rooster-admin-stats">';
        echo \Rooster\Admin\Ui::stat(__('Supplier metadata rows', 'ai-eshop-optimizer'), number_format_i18n($supplier_count)); 
        echo '</div>';
        if (empty($directory)) {
            
            $empty = \Rooster\Admin\States::state(
                'first-use',
                array(
                    'title'   => __('No suppliers yet. Create them at Products → Suppliers, or let a feed source create one.', 'ai-eshop-optimizer'),
                    'compact' => true,
                )
            );
            echo $empty; 
        }
        if (!$has_pods) {
            
            echo \Rooster\Admin\Guidance::text(__('Pods is not active here. Edit suppliers directly on each supplier term-edit screen.', 'ai-eshop-optimizer')); 
        }
        echo $close; 

        if (!empty($directory)) {
            $this->render_supplier_directory($directory);
        }

        if ($has_pods) {
            $audit = AIEO_DMM_Supplier_Pods_Migrator::audit();
            $nonce = wp_create_nonce('aieo_supplier_pods_migrate');
            $ajax  = admin_url('admin-ajax.php');

            
            
            list($open, $close) = AIEO_DMM_UI::card(array(
                'anchor'      => 'supplier-extras-pods-supplier-extras-migrator',
                'icon'        => 'import',
                'title'       => __('Migrate suppliers from Pods', 'ai-eshop-optimizer'),
                'description' => __('Copies supplier fields from the Pods pod into Supplier Extras in batches, and shows how many supplier terms are already migrated.', 'ai-eshop-optimizer'),
                'col'         => 2,
            ));
            echo $open; 
            echo '<p>';
            echo sprintf(
                
                esc_html__('Pods is active on `%1$s`. %2$d supplier terms total, %3$d already migrated.', 'ai-eshop-optimizer'),
                esc_html($audit['taxonomy']),
                (int) $audit['supplier_terms'],
                (int) $audit['already_migrated']
            );
            echo '</p>';
            $job = \Rooster\Admin\States::job(array(
                'id'        => 'aieo-supplier-pods-job',
                'state'     => 'idle',
                'run'       => __('Run migration', 'ai-eshop-optimizer'),
                'run_attrs' => array('id' => 'aieo-supplier-pods-run'),
            ));
            echo $job; 
            ?>
            <script>
            document.addEventListener('DOMContentLoaded', function(){
                var btn = document.getElementById('aieo-supplier-pods-run');
                if (!btn) return;
                var block = document.getElementById('aieo-supplier-pods-job');
                var NONCE = <?php echo wp_json_encode($nonce); ?>;
                var AJAX  = <?php echo wp_json_encode($ajax); ?>;
                // Where the job is, told to the block (the chrome's script is loaded by now).
                function show(o) { var st = window.roosterAdmin && window.roosterAdmin.states; if (st && block) { st.job(block, o); } }
                function failed() { show({state: 'failed', title: 'Failed.', error: ''}); }
                btn.addEventListener('click', function(){
                    show({state: 'running', value: 0, label: 'Migrating…'});
                    var fd = new FormData();
                    fd.append('action', 'aieo_supplier_pods_migrate_run');
                    fd.append('nonce', NONCE);
                    fetch(AJAX, {method:'POST',credentials:'same-origin',body:fd}).then(function(r){return r.json();}).then(function(j){
                        if (!j || !j.success) { failed(); return; }
                        var d = j.data || {};
                        show({state: 'done', result: 'Done. Migrated ' + (d.migrated|0) + ' / ' + (d.processed|0), facts: d.errors && d.errors.length ? [d.errors.length + ' errors'] : []});
                        if (d.errors && d.errors.length) console.warn(d.errors);
                    }).catch(failed);
                });
            });
            </script>
            <?php
            echo $close; 
        }

        $this->render_legacy_tables_card();
    }

    
    private function supplier_directory() {
        global $wpdb;
        $tax   = AIEO_DMM_Supplier_Extras_Data::managed_taxonomies();
        $tax   = !empty($tax) ? (string) reset($tax) : 'supplier';
        $limit = 500;
        $terms = taxonomy_exists($tax)
            ? get_terms(array('taxonomy' => $tax, 'hide_empty' => false, 'number' => $limit, 'orderby' => 'name'))
            : array();
        if (is_wp_error($terms) || empty($terms)) {
            return null;
        }
        $total = (int) wp_count_terms(array('taxonomy' => $tax, 'hide_empty' => false));

        
        $extras = array();
        foreach ((array) $wpdb->get_results($wpdb->prepare(
            'SELECT * FROM ' . AIEO_DMM_Supplier_Extras_Data::table() . ' WHERE taxonomy = %s', $tax
        ), ARRAY_A) as $r) { $extras[(int) $r['term_id']] = $r; }

        $brand_counts = array();
        $be = $wpdb->prefix . 'aieo_dmm_brand_extras';
        if (aieo_dmm_table_exists($be)) {
            foreach ((array) $wpdb->get_results("SELECT supplier_term_id, COUNT(*) n FROM `{$be}` WHERE supplier_term_id IS NOT NULL GROUP BY supplier_term_id", ARRAY_A) as $r) {
                $brand_counts[(int) $r['supplier_term_id']] = (int) $r['n'];
            }
        }
        $sku_counts = array();
        $map = $wpdb->prefix . 'aieo_dmm_supplier_sku_map';
        if (aieo_dmm_table_exists($map)) {
            foreach ((array) $wpdb->get_results("SELECT supplier_term_id, COUNT(*) n FROM `{$map}` WHERE supplier_term_id IS NOT NULL GROUP BY supplier_term_id", ARRAY_A) as $r) {
                $sku_counts[(int) $r['supplier_term_id']] = (int) $r['n'];
            }
        }

        
        
        $rows = array();
        foreach ($terms as $term) {
            $tid = (int) $term->term_id;
            $row = $extras[$tid] ?? array();
            $rows[] = array(
                'tid'      => $tid,
                'name'     => (string) $term->name,
                'edit'     => (string) get_edit_term_link($tid, $tax),
                'erp_id'   => (string) ($row['erp_id'] ?? ''),
                'email'    => (string) ($row['email'] ?? ''),
                'lead'     => (isset($row['lead_time_days']) && '' !== $row['lead_time_days'] && null !== $row['lead_time_days']) ? (int) $row['lead_time_days'] : null,
                'payment'  => (isset($row['payment_terms_days']) && '' !== $row['payment_terms_days'] && null !== $row['payment_terms_days']) ? (int) $row['payment_terms_days'] : null,
                'brands'   => $brand_counts[$tid] ?? null,
                'skus'     => $sku_counts[$tid] ?? null,
                'products' => (int) $term->count > 0 ? (int) $term->count : null,
            );
        }
        return array('rows' => $rows, 'limit' => (int) $limit, 'total' => (int) $total);
    }

    
    private function render_supplier_directory(array $directory) {
        $limit = (int) $directory['limit'];
        $total = (int) $directory['total'];
        list($open, $close) = AIEO_DMM_UI::card(array(
            'anchor'      => 'supplier-extras-directory',
            'icon'        => 'table',
            'title'       => __('Supplier directory', 'ai-eshop-optimizer'),
            'description' => __('Every supplier and how much of the catalogue it reaches. Click a name to edit it — the fields live on the supplier term screen at Products → Suppliers.', 'ai-eshop-optimizer'),
            'footnote'    => $total > $limit
                ? __('The full list is at Products → Suppliers.', 'ai-eshop-optimizer')
                : '',
            'flush'       => true,
            'span'        => 'all',
        ));
        echo $open; 
        echo '<p class="description"><a href="' . esc_url(add_query_arg(array('page' => AIEO_DMM::MENU_SLUG, 'dmm_tab' => 'suppliers'), admin_url('admin.php'))) . '">' . esc_html__('The Suppliers page edits every field of every supplier in one place.', 'ai-eshop-optimizer') . '</a></p>';
        
        AIEO_Table::card(array(
            'wrap'     => false,
            'page_id'  => $this->get_id(),
            'row_key'  => 'tid',
            'rows'     => $directory['rows'],
            'cap'      => $limit,
            'total'    => $total,
            'capped'   => $total > $limit,
            'columns'  => array(
                array('key' => 'name', 'label' => __('Supplier', 'ai-eshop-optimizer'), 'type' => 'link', 'format' => array('href' => 'edit')),
                array('key' => 'erp_id', 'label' => __('ERP id', 'ai-eshop-optimizer'), 'type' => 'code'),
                array('key' => 'email', 'label' => __('Email', 'ai-eshop-optimizer')),
                array('key' => 'lead', 'label' => __('Lead time (days)', 'ai-eshop-optimizer'), 'type' => 'integer'),
                array('key' => 'payment', 'label' => __('Payment terms (days)', 'ai-eshop-optimizer'), 'type' => 'integer'),
                array('key' => 'brands', 'label' => __('Brands', 'ai-eshop-optimizer'), 'type' => 'integer'),
                array('key' => 'skus', 'label' => __('Mapped SKUs', 'ai-eshop-optimizer'), 'type' => 'integer'),
                array('key' => 'products', 'label' => __('Products (direct)', 'ai-eshop-optimizer'), 'type' => 'integer'),
            ),
        ));
        echo $close; 
    }

    
    private function render_legacy_tables_card() {
        if (!class_exists('AIEO_DMM_Supplier_Pods_Migrator') || !AIEO_DMM_Supplier_Pods_Migrator::has_legacy_tables()) {
            return;
        }
        $audit = AIEO_DMM_Supplier_Pods_Migrator::audit();
        $nonce = wp_create_nonce('aieo_supplier_pods_migrate');
        $ajax  = admin_url('admin-ajax.php');
        $legacy = (array) ($audit['legacy'] ?? array());
        $label_map = array(
            'supplier_fields'     => __('Supplier fields (Pods)', 'ai-eshop-optimizer'),
            'supplier_sku_fields' => __('Supplier fields with ERP link (Pods)', 'ai-eshop-optimizer'),
            'erp_master'          => __('ERP supplier master', 'ai-eshop-optimizer'),
            'store_sales'         => __('Store sales rows carrying a supplier name', 'ai-eshop-optimizer'),
            'preorders'           => __('Preorder history', 'ai-eshop-optimizer'),
        );

        
        
        list($open, $close) = AIEO_DMM_UI::card(array(
            'anchor'      => 'supplier-extras-legacy-tables',
            'icon'        => 'database',
            'title'       => __('Migrate the legacy supplier tables', 'ai-eshop-optimizer'),
            'description' => __('The old implementation\'s raw tables still exist in the database, even though Pods itself is gone. This reads them directly and lands everything in the new schema: supplier fields and the ERP identity into Supplier metadata (only filling blanks, never overwriting your edits), per-SKU supplier names into the SKU map, and the preorder history into the preorder log. Safe to run again — nothing is copied twice.', 'ai-eshop-optimizer'),
            'col'         => 2,
        ));
        echo $open; 
        
        
        $legacy_rows = array();
        foreach ($label_map as $key => $label) {
            $n = $legacy[$key] ?? null;
            $legacy_rows[] = array(
                '_id'   => (string) $key,
                'label' => $label,
                'value' => $n === null
                    ? array('html' => '<span class="description">' . esc_html__('table absent', 'ai-eshop-optimizer') . '</span>')
                    : number_format_i18n((int) $n),
            );
        }
        $legacy_rows[] = array(
            '_id'   => 'already_in_new_schema',
            'label' => __('Already in the new schema', 'ai-eshop-optimizer'),
            'value' => sprintf(
                
                __('%1$s suppliers with an ERP identity · %2$s SKU-map rows · %3$s preorder rows', 'ai-eshop-optimizer'),
                number_format_i18n((int) ($audit['extras_with_erp_identity'] ?? 0)),
                number_format_i18n((int) ($audit['sku_map_rows'] ?? 0)),
                number_format_i18n((int) ($audit['legacy_preorders_migrated'] ?? 0))
            ),
        );
        echo \Rooster\Admin\Ui::table( 
            array(
                array('key' => 'label', 'label' => __('Legacy table', 'ai-eshop-optimizer'), 'type' => 'text'),
                array('key' => 'value', 'label' => __('Rows', 'ai-eshop-optimizer'), 'type' => 'text'),
            ),
            $legacy_rows,
            array('id' => 'aieo-supplier-legacy-counts', 'caption' => __('Legacy supplier tables', 'ai-eshop-optimizer'))
        );
        $job = \Rooster\Admin\States::job(array(
            'id'        => 'aieo-supplier-legacy-job',
            'state'     => 'idle',
            'run'       => __('Migrate legacy tables', 'ai-eshop-optimizer'),
            'run_attrs' => array('id' => 'aieo-supplier-legacy-run'),
        ));
        echo $job; 
        ?>
        <script>
        document.addEventListener('DOMContentLoaded', function(){
            var btn = document.getElementById('aieo-supplier-legacy-run');
            if (!btn) return;
            var block = document.getElementById('aieo-supplier-legacy-job');
            var NONCE = <?php echo wp_json_encode($nonce); ?>;
            var AJAX  = <?php echo wp_json_encode($ajax); ?>;
            // Where the job is, told to the block (the chrome's script is loaded by now).
            function show(o) { var st = window.roosterAdmin && window.roosterAdmin.states; if (st && block) { st.job(block, o); } }
            function failed() { show({state: 'failed', title: 'Failed.', error: ''}); }
            btn.addEventListener('click', function(){
                show({state: 'running', value: 0, label: 'Migrating…'});
                var fd = new FormData();
                fd.append('action', 'aieo_supplier_legacy_migrate_run');
                fd.append('nonce', NONCE);
                fetch(AJAX, {method:'POST',credentials:'same-origin',body:fd}).then(function(r){return r.json();}).then(function(j){
                    if (!j || !j.success) { failed(); return; }
                    var d = j.data || {};
                    show({state: 'done', result: 'Done', facts: [
                        'fields: ' + ((d.fields&&d.fields.filled)|0) + '/' + ((d.fields&&d.fields.rows)|0),
                        'erp: ' + ((d.erp&&d.erp.filled)|0) + '/' + ((d.erp&&d.erp.rows)|0) + ' (' + ((d.erp&&d.erp.unmatched)|0) + ' unmatched)',
                        'sku map: +' + ((d.sku_map&&d.sku_map.inserted)|0),
                        'preorders: +' + ((d.preorders&&d.preorders.migrated)|0) + ' (' + ((d.preorders&&d.preorders.already)|0) + ' already)'
                    ]});
                }).catch(failed);
            });
        });
        </script>
        <?php
        echo $close; 
    }
}