<?php

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

class AIEO_DMM_Tools extends AIEO_DMM_Module_Base {

    
    const OPTION_KEY = 'aieo_dmm_tools_settings';

    
    const OPTION_CAPS = 'aieo_dmm_per_page_caps';

    public function get_id()       { return 'tools'; }
    public function get_icon()     { return 'table'; }
    public function get_label()    { return __('Reports &amp; Lookups', 'ai-eshop-optimizer'); }
    public function get_priority() { return 10; } 
    public function get_group()    { return 'tools'; }

    
    public function get_tools() {
        return array(
            'brand_metabox_enhance' => array(
                'label'   => __('Searchable + alphabetised Brands metabox', 'ai-eshop-optimizer'),
                'desc'    => __('On the product edit page, sort the Brands list A→Z and add a live search filter above it. Fixes the WP/Woo metabox\'s popular-first-then-by-ID order which is painful with hundreds of brands.', 'ai-eshop-optimizer'),
                'default' => 1,
            ),
        );
    }

    public function register_hooks() {
        add_action('wp_ajax_aieo_dmm_tools_save',           array($this, 'ajax_save'));
        add_action('wp_ajax_aieo_dmm_tools_save_branding',  array($this, 'ajax_save_branding'));
        add_action('wp_ajax_aieo_dmm_tools_save_caps',      array($this, 'ajax_save_caps'));
        add_action('wp_ajax_aieo_dmm_tools_save_quiet',     array($this, 'ajax_save_quiet'));
        add_action('wp_ajax_aieo_dmm_tools_save_stock_hold', array($this, 'ajax_save_stock_hold'));

        
        
        
        
        if (is_admin()) {
            add_filter('get_user_option_edit_orders_per_page',     array($this, 'cap_orders_per_page'));
            add_filter('get_user_option_edit_shop_order_per_page', array($this, 'cap_orders_per_page'));
            add_filter('get_user_option_edit_product_per_page',    array($this, 'cap_products_per_page'));
        }

        
        
        add_action('wp_ajax_aieo_dmm_tools_sku_lookup',     array($this, 'ajax_sku_lookup'));
        add_action('wp_ajax_aieo_dmm_tools_barcode_lookup', array($this, 'ajax_barcode_lookup'));

        
        
        
        
        
        
        
        

        
        
        
        
        add_action('admin_enqueue_scripts', array($this, 'enqueue_brand_metabox_tool'));
    }

    
    public function enqueue_admin_assets() {
        $css = 'assets/css/aieo-tools-admin.css';
        wp_enqueue_style('aieo-tools-admin', AIEO_URI . $css, array(), file_exists(AIEO_DIR . $css) ? (string) filemtime(AIEO_DIR . $css) : '1');
    }

    
    public function get_settings() {
        $stored = get_option(self::OPTION_KEY, array());
        if (!is_array($stored)) { $stored = array(); }
        $defaults = array();
        foreach ($this->get_tools() as $slug => $info) {
            $defaults[$slug] = !empty($info['default']) ? 1 : 0;
        }
        return array_merge($defaults, $stored);
    }

    public function is_enabled($slug) {
        $cfg = $this->get_settings();
        return !empty($cfg[$slug]);
    }

    
    public function get_caps() {
        $stored = get_option(self::OPTION_CAPS, array());
        if (!is_array($stored)) { $stored = array(); }
        $defaults = array(
            'orders_max'   => 200,
            'products_max' => 200,
        );
        $merged = array_merge($defaults, $stored);
        $merged['orders_max']   = max(0, (int) $merged['orders_max']);
        $merged['products_max'] = max(0, (int) $merged['products_max']);
        return $merged;
    }

    
    public function cap_orders_per_page($result) {
        $caps = $this->get_caps();
        $max  = (int) $caps['orders_max'];
        if ($max <= 0) { return $result; }
        $val = (int) $result;
        if ($val <= 0) { return $result; } 
        return $val > $max ? $max : $val;
    }

    
    public function cap_products_per_page($result) {
        $caps = $this->get_caps();
        $max  = (int) $caps['products_max'];
        if ($max <= 0) { return $result; }
        $val = (int) $result;
        if ($val <= 0) { return $result; }
        return $val > $max ? $max : $val;
    }

    
    public function ajax_save_caps() {
        AIEO_DMM::verify_ajax_request();
        if (!current_user_can('install_plugins')) {
            wp_send_json_error(array('message' => __('Insufficient permissions.', 'ai-eshop-optimizer')));
        }
        $orders   = isset($_POST['orders_max'])   ? max(0, (int) $_POST['orders_max'])   : 200;
        $products = isset($_POST['products_max']) ? max(0, (int) $_POST['products_max']) : 200;
        
        $orders   = min(10000, $orders);
        $products = min(10000, $products);
        update_option(self::OPTION_CAPS, array(
            'orders_max'   => $orders,
            'products_max' => $products,
        ), false);
        wp_send_json_success(array(
            'message'      => __('Per-page caps saved. Operators see the new ceiling on their next list-table render.', 'ai-eshop-optimizer'),
            'orders_max'   => $orders,
            'products_max' => $products,
        ));
    }

    public function enqueue_brand_metabox_tool($hook) {
        
        
        $screen = function_exists('get_current_screen') ? get_current_screen() : null;
        if (!$screen || $screen->post_type !== 'product') { return; }
        if (!in_array($hook, array('post.php', 'post-new.php'), true)) { return; }
        if (!$this->is_enabled('brand_metabox_enhance')) { return; }

        $handle = 'aieo-tools-brand-metabox';
        wp_enqueue_script(
            $handle,
            plugins_url('assets/js/aieo-tools-brand-metabox.js', AIEO_FILE),
            array(),
            defined('AIEO_VERSION') ? AIEO_VERSION : '1.0',
            true
        );
        wp_localize_script($handle, 'aieoToolsBrand', array(
            'placeholder' => __('Search brands…', 'ai-eshop-optimizer'),
            'noResults'   => __('No brands match.', 'ai-eshop-optimizer'),
        ));
    }

    public function ajax_save() {
        AIEO_DMM::verify_ajax_request();
        $patch = array();
        $tools = $this->get_tools();
        foreach ($tools as $slug => $info) {
            $patch[$slug] = !empty($_POST[$slug]) ? 1 : 0;
        }
        update_option(self::OPTION_KEY, $patch, false);
        wp_send_json_success(array('message' => __('Tools settings saved.', 'ai-eshop-optimizer')));
    }

    
    public function ajax_save_quiet() {
        AIEO_DMM::verify_ajax_request();
        $norm = static function ($v, $def) {
            $v = trim((string) $v);
            if (preg_match('/^(\d{1,2}):(\d{2})$/', $v, $m) && (int) $m[1] <= 23 && (int) $m[2] <= 59) {
                return sprintf('%02d:%02d', (int) $m[1], (int) $m[2]);
            }
            return $def;
        };
        $start = $norm(isset($_POST['quiet_start']) ? wp_unslash($_POST['quiet_start']) : '', '22:00');
        $end   = $norm(isset($_POST['quiet_end'])   ? wp_unslash($_POST['quiet_end'])   : '', '09:00');
        AIEO_DMM_Settings::update(array(
            'contact_quiet_start' => $start,
            'contact_quiet_end'   => $end,
        ));
        wp_send_json_success(array(
            'message'     => __('Quiet hours saved — applied to web-push now, and to newsletters / non-transactional email going forward.', 'ai-eshop-optimizer'),
            'quiet_start' => $start,
            'quiet_end'   => $end,
        ));
    }

    
    public function ajax_save_stock_hold() {
        AIEO_DMM::verify_ajax_request();
        $raw = isset($_POST['stock_reservation_minutes']) ? wp_unslash($_POST['stock_reservation_minutes']) : '';
        $min = max(0, min(10080, (int) $raw)); 
        AIEO_DMM_Settings::update(array('stock_reservation_minutes' => $min));
        wp_send_json_success(array(
            'message' => 0 === $min
                ? __('Saved. WooCommerce\'s own hold value is now used unchanged.', 'ai-eshop-optimizer')
                : sprintf(
                    
                    __('Saved. Checkout now reserves stock for at most %d minutes. Unpaid-order cancellation is unchanged.', 'ai-eshop-optimizer'),
                    $min
                ),
            'minutes' => $min,
        ));
    }

    
    private function render_fee_guard_card() {
        global $wpdb;

        $stats = get_option('aieo_fee_guard_stats', array());
        if (!is_array($stats)) { $stats = array(); }
        $total = isset($stats['total']) ? (int) $stats['total'] : 0;

        list($open, $close) = AIEO_DMM_UI::card(array(
            'anchor'      => 'tools-payment-fee-guard',
            'icon'        => 'credit-card',
            'title'       => __('Payment Fee Guard', 'ai-eshop-optimizer'),
            'description' => __('Keeps a payment-method surcharge, such as the cash-on-delivery fee, in step with the payment method the order was actually placed with. The block checkout works out the surcharge before it knows which method the customer finally chose, so an order can be created without a surcharge it should carry, or carrying one it should not. Every order is checked and corrected before the customer is charged, on the block checkout, the classic checkout, and when someone returns to pay for an order whose payment failed the first time.', 'ai-eshop-optimizer'),
            'col'         => 2,
        ));
        echo $open; 
        
        echo self::why(__('Orders your staff create by hand are never touched, so phone orders keep whatever you entered.', 'ai-eshop-optimizer')); 

        if ($total < 1) {
            $notice = \Rooster\Admin\Ui::notice(
                esc_html__('The guard is active and checking every order.', 'ai-eshop-optimizer'),
                'success',
                array(
                    'title'  => __('No corrections have been needed yet.', 'ai-eshop-optimizer'),
                    'inline' => true,
                )
            );
            echo $notice; 
            echo $close; 
            return;
        }

        $labels = array(
            'added'         => __('Surcharge added to an order that was missing it', 'ai-eshop-optimizer'),
            'corrected'     => __('Wrong amount corrected', 'ai-eshop-optimizer'),
            'removed'       => __('Surcharge removed from an order that should not carry one', 'ai-eshop-optimizer'),
            'deduplicated'  => __('Duplicate surcharge lines collapsed into one', 'ai-eshop-optimizer'),
        );

        $fix_rows = array();
        foreach ($labels as $key => $label) {
            $n = isset($stats[$key]) ? (int) $stats[$key] : 0;
            if ($n < 1) { continue; }
            $fix_rows[] = array('what' => $label, 'n' => number_format_i18n($n));
        }
        echo \Rooster\Admin\Ui::table( 
            array(
                array('key' => 'what', 'label' => __('Correction', 'ai-eshop-optimizer'), 'type' => 'text'),
                array('key' => 'n', 'label' => __('Orders', 'ai-eshop-optimizer'), 'type' => 'num'),
            ),
            $fix_rows,
            array(
                'id'           => 'aieo-tools-surcharge-stats',
                'totals'       => array('n' => number_format_i18n($total)),
                'totals_label' => esc_html__('Total orders corrected', 'ai-eshop-optimizer'),
            )
        );

        if (!empty($stats['last_gmt'])) {
            echo '<p class="description">'
                . esc_html(sprintf(
                    
                    __('Most recent correction: %s', 'ai-eshop-optimizer'),
                    (string) $stats['last_gmt']
                ))
                . '</p>';
        }

        
        
        
        $recent = isset($stats['recent']) && is_array($stats['recent']) ? $stats['recent'] : array();
        if ($recent) {
            echo '<p><strong>' . esc_html__('Most recent corrections', 'ai-eshop-optimizer') . '</strong></p>';
            $recent_rows = array();
            $methods     = array();
            foreach ($recent as $i => $r) {
                if (!is_array($r)) { continue; }
                $oid    = isset($r['order_id']) ? (int) $r['order_id'] : 0;
                $act    = isset($r['action']) ? (string) $r['action'] : '';
                $method = isset($r['method']) ? (string) $r['method'] : '';
                $what   = isset($labels[$act]) ? $labels[$act] : $act;
                $gmt    = isset($r['gmt']) ? (string) $r['gmt'] : '';
                $link   = $oid && function_exists('wc_get_order') && wc_get_order($oid)
                    ? admin_url('admin.php?page=wc-orders&action=edit&id=' . $oid)
                    : '';
                if ('' !== $method) { $methods[$method] = $method; }
                $recent_rows[] = array(
                    '_id'    => (string) $i,
                    
                    '_attrs' => array(
                        'data-ra-f'    => array('payment_method' => array($method)),
                        'data-ra-s'    => array('order' => $oid, 'gmt' => $gmt, 'method' => $method, 'what' => $what, '_id' => (int) $i),
                        'data-ra-text' => '#' . $oid . ' ' . $method . ' ' . $what,
                    ),
                    'order'  => $link ? array('title' => '#' . $oid, 'url' => $link) : '#' . $oid,
                    'gmt'    => $gmt,
                    'method' => $method,
                    'what'   => $what,
                );
            }
            ksort($methods, SORT_NATURAL | SORT_FLAG_CASE);
            $fg_sort = static function ($key, $type) {
                return array('sort' => 'none', 'sort_type' => $type, 'sort_url' => add_query_arg(array('fg_orderby' => $key, 'fg_order' => 'asc')));
            };
            echo \Rooster\Admin\Ui::table( 
                array(
                    array('key' => 'order', 'label' => __('Order', 'ai-eshop-optimizer'), 'type' => 'text') + $fg_sort('order', 'number'),
                    array('key' => 'gmt', 'label' => __('When (UTC)', 'ai-eshop-optimizer'), 'type' => 'date') + $fg_sort('gmt', 'date'),
                    array('key' => 'method', 'label' => __('Payment method', 'ai-eshop-optimizer'), 'type' => 'text') + $fg_sort('method', 'text'),
                    array('key' => 'what', 'label' => __('What changed', 'ai-eshop-optimizer'), 'type' => 'text') + $fg_sort('what', 'text'),
                ),
                $recent_rows,
                array(
                    'id'      => 'aieo-tools-surcharge-recent',
                    'caption' => __('Most recent corrections', 'ai-eshop-optimizer'),
                    'local'   => array('size' => 0, 'prefix' => 'fg_'),
                    'filters' => count($methods) > 1 ? array(
                        array('key' => 'payment_method', 'label' => __('Payment method', 'ai-eshop-optimizer'), 'options' => $methods, 'any' => __('Any payment method', 'ai-eshop-optimizer')),
                    ) : array(),
                )
            );
        }

        echo $close; 
    }

    
    private function render_stock_reservation_card($nonce, $ajax) {
        $minutes = (int) AIEO_DMM_Settings::get('stock_reservation_minutes', 60);
        $wc_hold = (int) get_option('woocommerce_hold_stock_minutes', 60);

        $anchor = 'tools-stock-reservation-window';
        list($open, $close) = AIEO_DMM_UI::card(array(
            'anchor'      => $anchor,
            'icon'        => 'timer',
            'title'       => __('Checkout stock reservation', 'ai-eshop-optimizer'),
            'description' => __('How long a checkout in progress may hold stock. When a shopper reaches checkout, WooCommerce reserves their items so nobody else can buy them mid-payment. If the shopper abandons the payment, that reservation stays behind and can block the next customer — and, on the last unit of a product, it blocks the original shopper too when they come back to try again.', 'ai-eshop-optimizer'),
            'col'         => 2,
            'footer'      => self::save_footer($anchor, array('label' => __('Save reservation window', 'ai-eshop-optimizer'))),
        ));
        echo $open; 
        
        
        
        $why = __('Why this is here and not in WooCommerce: the WooCommerce field %2$s uses ONE number for four different jobs — reserving stock at checkout, deciding when an unpaid order is cancelled, scheduling that cancellation, and holding coupons. Shops that accept bank transfer set it high on purpose so customers have days to pay. Yours is set to %1$d minutes. Lowering it there to shorten a stock hold would also start cancelling unpaid bank-transfer orders that soon. This setting changes only the reservation, through the supported WooCommerce filter, and leaves your Hold stock value and your cancellation window exactly as they are.', 'ai-eshop-optimizer');
        echo self::why(sprintf($why, $wc_hold, __('WooCommerce > Settings > Products > Inventory > Hold stock (minutes)', 'ai-eshop-optimizer')), '', __('Why not in WooCommerce?', 'ai-eshop-optimizer')); 
        echo self::why(__('This only ever shortens the reservation, never lengthens it. Set it to 0 to switch it off and use the WooCommerce value unchanged.', 'ai-eshop-optimizer'), '', __('Can it make the hold longer?', 'ai-eshop-optimizer')); 
        ob_start();
        echo '<p>';
        echo '<label for="aieo-stock-hold-minutes">' . esc_html__('Reserve stock for at most', 'ai-eshop-optimizer') . '</label> '
            . '<span class="rooster-admin-unit"><input type="number" min="0" max="10080" step="1" id="aieo-stock-hold-minutes" name="stock_reservation_minutes" class="rooster-admin-input rooster-admin-input--xs" value="' . esc_attr((string) $minutes) . '">'
            . '<span class="rooster-admin-unit__text">' . esc_html__('minutes', 'ai-eshop-optimizer') . '</span></span>';
        echo '</p>';
        echo self::form('aieo_dmm_tools_save_stock_hold', $anchor); 
        echo $close; 
    }

    
    private function render_quiet_hours_card($nonce, $ajax) {
        $start = (string) AIEO_DMM_Settings::get('contact_quiet_start', '22:00');
        $end   = (string) AIEO_DMM_Settings::get('contact_quiet_end',   '09:00');
        $anchor = 'tools-quiet-hours-customer-contact-window';
        list($open, $close) = AIEO_DMM_UI::card(array(
            'anchor'      => $anchor,
            'icon'        => 'moon',
            'title'       => __('Quiet hours: marketing messages', 'ai-eshop-optimizer'),
            'description' => __('No non-transactional message is sent during these hours (Europe/Athens). This is the GLOBAL window — it governs web-push now and newsletters / marketing email going forward. Transactional mail (order confirmations etc.) is never affected. Set the two times equal to disable quiet hours.', 'ai-eshop-optimizer'),
            'col'         => 2,
            'footer'      => self::save_footer($anchor, array('label' => __('Save quiet hours', 'ai-eshop-optimizer'))),
        ));
        echo $open; 
        
        
        ob_start();
        echo '<p class="rooster-admin-row">';
        echo '<label for="aieo-quiet-start">' . esc_html__('From', 'ai-eshop-optimizer') . '</label> <input type="time" id="aieo-quiet-start" name="quiet_start" class="rooster-admin-input" value="' . esc_attr($start) . '">';
        echo '<label for="aieo-quiet-end">' . esc_html__('To', 'ai-eshop-optimizer') . '</label> <input type="time" id="aieo-quiet-end" name="quiet_end" class="rooster-admin-input" value="' . esc_attr($end) . '">';
        echo '</p>';
        echo self::form('aieo_dmm_tools_save_quiet', $anchor); 
        echo $close; 
    }

    public function render_subtab() {
        

        
        
        
        
        
        
        
        
        rooster_admin_band_open(array('cols' => 2));

        $aieo_dmm_i = AIEO_DMM::instance();
        $aieo_mine  = method_exists($aieo_dmm_i, 'get_module') ? $aieo_dmm_i->get_module('my_settings') : null;
        if ($aieo_mine instanceof AIEO_DMM_Module_Base) {
            $aieo_mine->render_subtab();
        }

        $cfg   = $this->get_settings();
        $tools = $this->get_tools();
        $nonce = wp_create_nonce(AIEO_DMM::NONCE_ACTION);
        $ajax  = admin_url('admin-ajax.php');

        
        

        
        
        $this->render_branding_card($nonce, $ajax);

        
        
        
        
        
        
        
        
        $this->render_per_page_caps_card($nonce, $ajax);

        
        
        $this->render_stock_reservation_card($nonce, $ajax);

        
        
        
        $this->render_fee_guard_card();

        
        
        $this->render_quiet_hours_card($nonce, $ajax);

        
        
        
        $anchor = 'tools-overview';
        list($open, $close) = AIEO_DMM_UI::card(array(
            'anchor'      => $anchor,
            'title'       => __('Tools', 'ai-eshop-optimizer'),
            'description' => __('Optional admin-side conveniences. Each tool has its own on/off toggle — they\'re independent of the rest of Rooster One and add no overhead when disabled.', 'ai-eshop-optimizer'),
            'col'         => 1,
            'footer'      => self::save_footer($anchor, array('label' => __('Save tools', 'ai-eshop-optimizer'))),
        ));
        echo $open; 

        ob_start();
        foreach ($tools as $slug => $info) {
            $on = !empty($cfg[$slug]);
            echo \Rooster\Admin\Ui::toggle($slug, (bool) $on, array('hidden' => false, 'id' => 'aieo-tool-' . $slug, 'label' => (string) $info['label'], 'attrs' => array('data-aieo-tool-slug' => $slug, 'aria-describedby' => 'aieo-tool-' . $slug . '-desc'))); 
            
            
            echo \Rooster\Admin\Guidance::text((string) $info['desc'], 'guidance', array('id' => 'aieo-tool-' . $slug . '-desc')); 
        }
        echo self::form('aieo_dmm_tools_save', $anchor, false, __('Reload any open product editor to apply.', 'ai-eshop-optimizer')); 

        echo $close; 

        
        
        $this->render_documentation_card();

        
        
        
        
        
        
        

        
        self::print_saved_js();

        
        $this->render_lookup_cards($nonce, $ajax);

        
        
        
        
        
        $this->render_wpdt_pages_card($nonce, $ajax);

        rooster_admin_band_close();
    }

    
    
    private function render_documentation_card() {
        if (!class_exists('AIEO_Docs_Registry') || !class_exists('AIEO_Capability_Registry')) { return; }

        $cov   = AIEO_Docs_Registry::coverage();
        $state = AIEO_Docs_Registry::stale();
        $stats = AIEO_Capability_Registry::stats();

        list($open, $close) = AIEO_DMM_UI::card(array(
            'anchor'      => 'tools-documentation-coverage',
            'icon'        => 'book-open-check',
            'title'       => __('Documentation coverage', 'ai-eshop-optimizer'),
            
            
            
            'description' => __('How much of Rooster One the manual on rooster.systems covers, and what changed after its pages were published.', 'ai-eshop-optimizer'),
            'col'         => 1,
        ));
        echo $open; 

        
        echo \Rooster\Admin\Ui::facts(array( 
            array(
                'label' => __('Capabilities documented', 'ai-eshop-optimizer'),
                'value' => sprintf(
                    
                    _x('%1$s of %2$s (%3$s%%)', 'documented capabilities out of all', 'ai-eshop-optimizer'),
                    number_format_i18n((int) $cov['documented']),
                    number_format_i18n((int) $cov['total']),
                    number_format_i18n((float) $cov['percent'], 1)
                ),
            ),
            array('label' => __('Need re-publishing', 'ai-eshop-optimizer'), 'value' => number_format_i18n(count((array) $state['stale']))),
            array('label' => __('Pages', 'ai-eshop-optimizer'), 'value' => number_format_i18n((int) $stats['pages'])),
            array('label' => __('In-page tabs', 'ai-eshop-optimizer'), 'value' => number_format_i18n((int) $stats['tabs'])),
            array('label' => __('Described actions', 'ai-eshop-optimizer'), 'value' => number_format_i18n((int) $stats['actions'])),
        ), array('columns' => 2));

        if (!empty($state['stale'])) {
            echo '<h4 class="aieo-tools-subhead">'
                . esc_html__('Documented against an older version — re-publish these:', 'ai-eshop-optimizer')
                . '</h4><ul class="aieo-tools-stale">';
            
            
            foreach (array_slice($state['stale'], 0, 12) as $row) {
                echo '<li>' . esc_html((string) $row['label'])
                    . ' <span class="rooster-admin-count">(' . esc_html((string) $row['documented_at']) . ')</span></li>';
            }
            echo '</ul>';
            if (count($state['stale']) > 12) {
                echo '<p class="aieo-tools-note aieo-tools-note--faint">'
                    . esc_html(sprintf(
                        
                        __('…and %d more.', 'ai-eshop-optimizer'),
                        count($state['stale']) - 12
                    )) . '</p>';
            }
        }

        if (!empty($state['missing'])) {
            echo '<p class="aieo-tools-note">'
                . esc_html(sprintf(
                    
                    __('%d capabilities have no manual page at all.', 'ai-eshop-optimizer'),
                    count($state['missing'])
                )) . '</p>';
        }

        echo $close; 
    }

    private function render_wpdt_pages_card($nonce, $ajax) {
        $pages = (array) get_option('aieo_wpdt_enhance_pages', array());

        
        
        
        $anchor = 'tools-report-page-enhancements-wpdatatables';
        list($open, $close) = AIEO_DMM_UI::card(array(
            'anchor'      => $anchor,
            'icon'        => 'table-properties',
            'title'       => __('wpDataTables enhancements', 'ai-eshop-optimizer'),
            'description' => __('Page IDs that get the glass-tooltip (hidden "logger" column on hover) + origin-user tagging treatment on their wpDataTables. Comma-separated WordPress page IDs.', 'ai-eshop-optimizer'),
            'col'         => 1,
            'footer'      => self::save_footer($anchor, array('label' => __('Save pages', 'ai-eshop-optimizer'))),
        ));
        echo $open; 
        ob_start();
        echo '<p><input type="text" id="aieo-aj-pages" name="page_ids" class="rooster-admin-input rooster-admin-input--medium is-code" aria-label="' . esc_attr__('wpDataTables enhancements', 'ai-eshop-optimizer') . '" value="' . esc_attr(implode(', ', array_map('intval', $pages))) . '" placeholder="204717, 205185, 205209 …"></p>';
        echo self::form('aieo_analytics_save_pages', $anchor); 
        echo $close; 
    }

    
    private function render_branding_card($nonce, $ajax) {
        $current = AIEO_DMM::get_menu_title();
        $anchor  = 'tools-admin-menu-branding';
        list($open, $close) = AIEO_DMM_UI::card(array(
            'anchor' => $anchor,
            'icon'   => 'palette',
            'title'  => __('Admin menu branding', 'ai-eshop-optimizer'),
            'description' => __('Choose the name shown on the admin sidebar\'s pill and in page titles, such as your own shop name.', 'ai-eshop-optimizer'),
            'col'    => 2,
            'footer' => self::save_footer($anchor),
        ));
        echo $open; 
        
        
        
        $why = __('Custom label for the admin sidebar pill (and the page title). Defaults to %s — set it to your own shop name, or any per-client wording. Takes effect on the next admin page load.', 'ai-eshop-optimizer');
        echo self::why(sprintf($why, AIEO_DMM::MENU_TITLE_DEFAULT), sprintf(esc_html($why), '<code>' . esc_html(AIEO_DMM::MENU_TITLE_DEFAULT) . '</code>')); 
        
        
        
        
        
        ob_start();
        
        echo '<div class="rooster-admin-fields">' . AIEO_Kit::row( 
            __('Menu title', 'ai-eshop-optimizer'),
            AIEO_Kit::input('menu_title', $current, array('id' => 'aieo-tools-menu-title', 'medium' => true, 'maxlength' => 60, 'placeholder' => AIEO_DMM::MENU_TITLE_DEFAULT, 'help' => true)),
            __('Leave empty to fall back to the default.', 'ai-eshop-optimizer'),
            array('id' => 'aieo-tools-menu-title')
        ) . '</div>';
        echo self::form('aieo_dmm_tools_save_branding', $anchor, true); 
        echo $close; 
    }

    
    private static function form_id($anchor) {
        return 'aieo-card-' . $anchor . '-form';
    }

    
    private static function save_footer($anchor, array $opts = array()) {
        return class_exists('\Rooster\Admin\States') ? \Rooster\Admin\States::save_button(self::form_id($anchor), $opts) : '';
    }

    
    private static function form($action, $anchor, $reload = false, $after = '') {
        $attrs = array('data-aieo-tools-saved' => (string) $after);
        if ($reload) {
            $attrs['data-aieo-tools-reload'] = '1';
        }
        return AIEO_DMM_UI::card_form($action, $anchor, self::form_id($anchor), (string) ob_get_clean(), array('attrs' => $attrs));
    }

    
    private static function why($text, $html = '', $question = '') {
        if (class_exists('\Rooster\Admin\Guidance')) {
            return \Rooster\Admin\Guidance::text((string) $text, 'guidance', array_filter(array('html' => (string) $html, 'question' => (string) $question)));
        }
        return '<p class="description">' . ('' !== $html ? $html : esc_html($text)) . '</p>';
    }

    
    private static function print_saved_js() {
        echo '<script>document.addEventListener("DOMContentLoaded", function(){
            Array.prototype.forEach.call(document.querySelectorAll("form[data-aieo-tools-saved]"), function(form){
                form.addEventListener("rooster-admin:saved", function(e){
                    var msg = ((e.detail && e.detail.message ? String(e.detail.message) : "") + " " + (form.getAttribute("data-aieo-tools-saved") || "")).trim();
                    var btn = document.querySelector("[form=\"" + form.id + "\"][data-ra-save-submit]");
                    var say = btn && btn.parentNode ? btn.parentNode.querySelector(".rooster-admin-saved") : null;
                    if (say && msg) { say.textContent = msg; }
                    if (form.hasAttribute("data-aieo-tools-reload")) { setTimeout(function(){ window.location.reload(); }, 800); }
                });
            });
        });</script>';
    }

    
    public function ajax_save_branding() {
        AIEO_DMM::verify_ajax_request();
        $title = isset($_POST['menu_title']) ? sanitize_text_field((string) wp_unslash($_POST['menu_title'])) : '';
        $title = mb_substr(trim($title), 0, 60);
        update_option(AIEO_DMM::MENU_TITLE_OPTION, $title, false);

        wp_send_json_success(array(
            'message'         => __('Saved. Reloading to refresh the admin menu…', 'ai-eshop-optimizer'),
            'effective_title' => AIEO_DMM::get_menu_title(),
        ));
    }

    
    
    
    
    
    
    
    
    
    

    
    public static function suppress_bulk_product_save_hooks() {
        if (class_exists('AIEO_DMM_Brand_Margins')) {
            AIEO_DMM_Brand_Margins::suppress_bulk_product_save_hooks();
        }
    }

    
    public static function apply_cogs_batch($offset, $batch = 150) {
        if (class_exists('AIEO_DMM_Brand_Margins')) {
            return AIEO_DMM_Brand_Margins::apply_cogs_batch($offset, $batch);
        }
        
        
        return array('updated' => 0, 'skipped' => 0, 'next_offset' => (int) $offset, 'total' => 0, 'done' => true);
    }

    
    private function render_per_page_caps_card($nonce, $ajax) {
        $caps     = $this->get_caps();
        $is_admin = current_user_can('install_plugins');
        $disabled = $is_admin ? '' : ' disabled';
        
        
        
        
        
        
        
        
        
        
        $lock_cls = $is_admin ? '' : ' aieo-caps-locked';

        
        
        
        
        
        $anchor = 'tools-admin-list-table-per-page-caps';
        $why_id = 'aieo-tools-caps-save-reason';
        if ($is_admin) {
            $foot = self::save_footer($anchor, array('label' => __('Save caps', 'ai-eshop-optimizer'), 'attrs' => array('id' => 'aieo-tools-caps-save')));
        } else {
            $foot = class_exists('\Rooster\Admin\Ui') ? \Rooster\Admin\Ui::button(
                __('Save caps', 'ai-eshop-optimizer'),
                array(
                    'variant' => 'primary',
                    'type'    => 'submit',
                    'reason'  => __('Administrator only', 'ai-eshop-optimizer'),
                    'attrs'   => array('id' => 'aieo-tools-caps-save', 'form' => self::form_id($anchor)),
                )
            ) : '';
        }
        list($open, $close) = AIEO_DMM_UI::card(array(
            'anchor'      => $anchor,
            'icon'        => 'list',
            'title'       => __('Admin list-table per-page caps', 'ai-eshop-optimizer'),
            'description' => __('Hard ceiling on the "Items per page" Screen Options for the All Orders and All Products admin lists. Operators below the cap keep their personal value untouched; only those above it get clamped on the next list render. Stops 500–600 setups from grinding the admin on every refresh. Set a cap to 0 to disable enforcement for that screen.', 'ai-eshop-optimizer'),
            'class'       => trim($lock_cls),
            'col'         => 1,
            'footer'      => $foot,
        ));
        echo $open; 
        echo '<div class="aieo-tools-body">';
        ob_start();
        
        
        $aieo_caps_box = static function ($name, $id, $value) use ($is_admin, $why_id) {
            return AIEO_Kit::input($name, (string) (int) $value, array('type' => 'number', 'id' => $id, 'min' => 0, 'max' => 10000, 'step' => 1, 'short' => true, 'disabled' => !$is_admin, 'attrs' => $is_admin ? array() : array('aria-describedby' => $why_id)));
        };
        echo '<div class="rooster-admin-fields">'; 
        echo AIEO_Kit::row(__('Max orders per page', 'ai-eshop-optimizer'), $aieo_caps_box('orders_max', 'aieo-tools-orders-max', $caps['orders_max']), __('Applies to the HPOS Orders screen + legacy edit.php?post_type=shop_order.', 'ai-eshop-optimizer'), array('id' => 'aieo-tools-orders-max')); 
        echo AIEO_Kit::row(__('Max products per page', 'ai-eshop-optimizer'), $aieo_caps_box('products_max', 'aieo-tools-products-max', $caps['products_max']), __('Applies to edit.php?post_type=product.', 'ai-eshop-optimizer'), array('id' => 'aieo-tools-products-max')); 
        echo '</div>';
        echo self::form('aieo_dmm_tools_save_caps', $anchor); 

        
        
        
        if (!$is_admin) {
            echo '<div class="aieo-caps-lock-overlay" aria-hidden="true">';
            echo   '<div class="aieo-caps-lock-content">';
            echo     '<div class="aieo-caps-lock-icon">';
            echo       '<svg width="22" height="22" viewBox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg" aria-hidden="true">';
            echo         '<path d="M6 10V8a6 6 0 1112 0v2M5 10h14a1 1 0 011 1v9a1 1 0 01-1 1H5a1 1 0 01-1-1v-9a1 1 0 011-1z" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round"/>';
            echo       '</svg>';
            echo     '</div>';
            echo     '<div>';
            echo       '<strong>' . esc_html__('Administrator only', 'ai-eshop-optimizer') . '</strong><br>';
            echo       '<span>' . esc_html__('Ask the site administrator to adjust these caps. The current values above are read-only.', 'ai-eshop-optimizer') . '</span>';
            echo     '</div>';
            echo   '</div>';
            echo '</div>';
        }
        echo '</div>';

        

        
        
        echo $close; 
    }

    
    private static function lookup_table($kind, array $results = array()) {
        if (!function_exists('rooster_admin_builders') || !rooster_admin_builders()) {
            return '';
        }
        $pre     = $kind . '_';
        $sort    = static function ($key, $type) use ($pre) {
            return array('sort' => 'none', 'sort_type' => $type, 'sort_url' => '#' . $pre . 'orderby=' . $key);
        };
        $first   = 'barcode' === $kind ? __('Barcode', 'ai-eshop-optimizer') : __('SKU', 'ai-eshop-optimizer');
        $columns = array(
            array('key' => 'input', 'label' => $first, 'type' => 'text') + $sort('input', 'text'),
            array('key' => 'product_id', 'label' => __('Product ID', 'ai-eshop-optimizer'), 'type' => 'num') + $sort('product_id', 'number'),
            array('key' => 'parent_id', 'label' => __('Parent ID', 'ai-eshop-optimizer'), 'type' => 'text', 'align' => 'end') + $sort('parent_id', 'number'),
            array('key' => 'status', 'label' => __('Status', 'ai-eshop-optimizer'), 'type' => 'text') + $sort('status', 'text'),
        );
        $rows = array();
        foreach (array_values($results) as $i => $item) {
            $pid    = (int) ($item['product_id'] ?? 0);
            $parent = (int) ($item['parent_id'] ?? 0);
            $rows[] = array(
                '_id'        => (string) ($i + 1),
                '_name'      => (string) $item['input'],
                '_attrs'     => array(
                    'data-ra-s'    => array('input' => (string) $item['input'], 'product_id' => $pid ? $pid : '', 'parent_id' => $parent ? $parent : '', 'status' => (string) $item['status'], '_id' => $i + 1),
                    'data-ra-text' => (string) $item['input'],
                ),
                'input'      => (string) $item['input'],
                'product_id' => $pid ? (string) $pid : '—',
                
                'parent_id'  => $parent ? array('html' => '<a href="' . esc_url('/?p=' . $parent) . '" target="_blank" rel="noopener">' . (int) $parent . '</a>') : '—',
                'status'     => empty($item['found']) ? array('title' => (string) $item['status'], 'tone' => 'destructive') : (string) $item['status'],
            );
        }
        return \Rooster\Admin\Ui::table($columns, $rows, array(
            'id'      => 'aieo-tools-' . $kind . '-table',
            'caption' => __('Lookup results', 'ai-eshop-optimizer'),
            'local'   => array('size' => 0, 'prefix' => $pre),
            'empty'   => \Rooster\Admin\States::state('no-results', array('compact' => true, 'title' => __('Nothing to show for that input.', 'ai-eshop-optimizer'), 'text' => '')),
        ));
    }

    
    private function render_lookup_table($kind) {
        echo '<div id="aieo-tools-' . esc_attr($kind) . '-tablebox" hidden>' . self::lookup_table($kind) . '</div>'; 
    }

    
    private function render_lookup_cards($nonce, $ajax) {
        
        
        
        list($open, $close) = AIEO_DMM_UI::card(array(
            'anchor'      => 'tools-sku-parent-product-id-lookup',
            'icon'        => 'hash',
            'title'       => __('SKU → parent product', 'ai-eshop-optimizer'),
            'description' => __('Enter SKUs (comma-separated or one per line) to get their parent product IDs. Useful for finding parent IDs of variations.', 'ai-eshop-optimizer'),
            'col'         => 2,
        ));
        echo $open; 
        echo '<div class="rooster-admin-fields">' . AIEO_Kit::row(__('SKUs', 'ai-eshop-optimizer'), AIEO_Kit::textarea('', '', array('id' => 'aieo-tools-sku-input', 'rows' => 6, 'code' => true, 'help' => true, 'placeholder' => "Enter SKUs here...\nSKU-001\nSKU-002, SKU-003\nSKU-004")), __('Separated by commas or new lines.', 'ai-eshop-optimizer'), array('id' => 'aieo-tools-sku-input')) . '</div>'; 
        echo '<p><button type="button" class="rooster-admin-button rooster-admin-button--primary" id="aieo-tools-sku-btn">'
            . esc_html__('Look up parent IDs', 'ai-eshop-optimizer') . '</button></p>';
        echo '<div id="aieo-tools-sku-results" class="aieo-tools-results" hidden></div>';
        $this->render_lookup_table('sku');
        echo $close; 

        
        list($open, $close) = AIEO_DMM_UI::card(array(
            'anchor' => 'tools-barcode-parent-product-id-lookup',
            'description' => __('Look up the parent product IDs of a list of barcodes, from WooCommerce\'s GTIN field.', 'ai-eshop-optimizer'),
            'icon'   => 'barcode',
            'title'  => __('Barcode → parent product', 'ai-eshop-optimizer'),
            'col'    => 2,
        ));
        echo $open; 
        
        
        $why = __('Enter barcodes (comma-separated or one per line). Searches the %s meta field (WooCommerce 9.x GTIN).', 'ai-eshop-optimizer');
        echo self::why(sprintf($why, '_global_unique_id'), sprintf(esc_html($why), '<code>_global_unique_id</code>')); 
        echo '<div class="rooster-admin-fields">' . AIEO_Kit::row(__('Barcodes', 'ai-eshop-optimizer'), AIEO_Kit::textarea('', '', array('id' => 'aieo-tools-barcode-input', 'rows' => 6, 'code' => true, 'help' => true, 'placeholder' => "Enter barcodes here...\n1234567890123\n9876543210987, 5555555555555\n1111111111111")), __('Separated by commas or new lines.', 'ai-eshop-optimizer'), array('id' => 'aieo-tools-barcode-input')) . '</div>'; 
        echo '<p><button type="button" class="rooster-admin-button rooster-admin-button--primary" id="aieo-tools-barcode-btn">'
            . esc_html__('Look up parent IDs', 'ai-eshop-optimizer') . '</button></p>';
        echo '<div id="aieo-tools-barcode-results" class="aieo-tools-results" hidden></div>';
        $this->render_lookup_table('barcode');
        echo $close; 

        
        echo '<script>(function(){
            var ajaxUrl = "' . esc_js($ajax) . '";
            var nonce = "' . esc_js($nonce) . '";
            function escapeHtml(s){var d=document.createElement("div");d.appendChild(document.createTextNode(String(s||"")));return d.innerHTML;}
            function runLookup(kind){
                var inp = document.getElementById("aieo-tools-" + kind + "-input");
                var btn = document.getElementById("aieo-tools-" + kind + "-btn");
                var box = document.getElementById("aieo-tools-" + kind + "-results");
                var raw = (inp.value || "").trim();
                if (!raw) { alert("' . esc_js(__('Please enter at least one value.', 'ai-eshop-optimizer')) . '"); return; }
                btn.disabled = true; btn.textContent = "' . esc_js(__('Looking up…', 'ai-eshop-optimizer')) . '";
                var fd = new FormData();
                fd.set("action", "aieo_dmm_tools_" + kind + "_lookup");
                fd.set("nonce", nonce);
                fd.set("input", raw);
                fetch(ajaxUrl, {method:"POST", body:fd, credentials:"same-origin"})
                    .then(function(r){return r.json();})
                    .then(function(j){
                        btn.disabled = false; btn.textContent = "' . esc_js(__('Look up parent IDs', 'ai-eshop-optimizer')) . '";
                        if (!j || !j.success) { alert((j && j.data && j.data.message) || "' . esc_js(__('An error occurred.', 'ai-eshop-optimizer')) . '"); return; }
                        renderResults(box, kind, j.data);
                    })
                    .catch(function(){ btn.disabled = false; btn.textContent = "' . esc_js(__('Look up parent IDs', 'ai-eshop-optimizer')) . '"; alert("' . esc_js(__('Network error.', 'ai-eshop-optimizer')) . '"); });
            }
            /* The results table is the library\'s (tables rollout phase B): each answer brings it whole, with
               its rows, and the library wires it in place (CONTRACT §8.2 "A table drawn later"). */
            function el(tag, cls, text){ var n = document.createElement(tag); if (cls) { n.className = cls; } if (text != null) { n.textContent = text; } return n; }
            /* A labelled, read-only kit textarea; the parent ids select themselves on a click (an inline onclick before). */
            function area(id, label, value, rows, pick, cls){
                var wrap = el("div", "aieo-tools-lab"), lab = el("label"), box = el("textarea", "rooster-admin-textarea is-code" + (cls ? " " + cls : ""));
                lab.htmlFor = id; lab.appendChild(el("strong", "", label));
                box.id = id; box.rows = rows; box.readOnly = true; box.value = value;
                if (pick) { box.addEventListener("click", function(){ box.select(); }); }
                wrap.appendChild(lab); wrap.appendChild(box);
                return wrap;
            }
            function renderResults(box, kind, d){
                var kit = window.roosterAdmin && window.roosterAdmin.ui;
                var said = "' . esc_js(__('Found:', 'ai-eshop-optimizer')) . ' " + d.found_count + "  |  ' . esc_js(__('Not found:', 'ai-eshop-optimizer')) . ' " + d.not_found_count + "  |  ' . esc_js(__('Unique parent IDs:', 'ai-eshop-optimizer')) . ' " + d.unique_parent_ids.length;
                box.textContent = "";
                box.appendChild(kit && kit.notice ? kit.notice(said, "info", { inline: true }) : el("p", "aieo-tools-found", said));
                if (d.unique_parent_ids.length > 0) {
                    box.appendChild(area("aieo-tools-" + kind + "-parents", "' . esc_js(__('Parent product IDs (comma-separated, click to select):', 'ai-eshop-optimizer')) . '", d.unique_parent_ids.join(", "), 2, true, ""));
                }
                if (d.not_found.length > 0) {
                    box.appendChild(area("aieo-tools-" + kind + "-missing", "' . esc_js(__('Not found:', 'ai-eshop-optimizer')) . '", d.not_found.join("\\n"), 3, false, "aieo-tools-notfound"));
                }
                box.hidden = false;

                var tbox = document.getElementById("aieo-tools-" + kind + "-tablebox");
                if (!tbox || !d.table) { return; }
                tbox.innerHTML = d.table;
                if (window.roosterAdminTable && window.roosterAdminTable.enhance) { window.roosterAdminTable.enhance(tbox, d.icons || ""); }
                tbox.hidden = false;
            }
            document.addEventListener("DOMContentLoaded", function(){
                var skuBtn = document.getElementById("aieo-tools-sku-btn");
                var bcBtn  = document.getElementById("aieo-tools-barcode-btn");
                if (skuBtn) skuBtn.addEventListener("click", function(){ runLookup("sku"); });
                if (bcBtn)  bcBtn.addEventListener("click",  function(){ runLookup("barcode"); });
            });
        })();</script>';
    }

    public function ajax_sku_lookup() {
        AIEO_DMM::verify_ajax_request();
        if (!current_user_can('manage_woocommerce')) {
            wp_send_json_error(array('message' => __('Insufficient permissions.', 'ai-eshop-optimizer')));
        }
        $items = $this->parse_lookup_input(isset($_POST['input']) ? sanitize_textarea_field(wp_unslash((string) $_POST['input'])) : ''); 
        if (empty($items)) {
            wp_send_json_error(array('message' => __('No valid SKUs provided.', 'ai-eshop-optimizer')));
        }
        $results = array(); $not_found = array(); $parent_ids = array(); $found = 0;
        foreach ($items as $sku) {
            $product_id = function_exists('wc_get_product_id_by_sku') ? wc_get_product_id_by_sku($sku) : 0;
            $row = $this->resolve_lookup_row($sku, (int) $product_id);
            $results[] = $row;
            if ($row['found']) { $parent_ids[] = $row['parent_id']; $found++; }
            else { $not_found[] = $sku; }
        }
        $table = self::lookup_table('sku', $results); 
        wp_send_json_success(array(
            'results'           => $results,
            'unique_parent_ids' => array_values(array_unique(array_filter($parent_ids))),
            'not_found'         => $not_found,
            'found_count'       => $found,
            'not_found_count'   => count($not_found),
            'table'             => $table,
            'icons'             => '' !== $table ? \Rooster\Admin\Ui::icons_of($table) : '',
        ));
    }

    public function ajax_barcode_lookup() {
        AIEO_DMM::verify_ajax_request();
        if (!current_user_can('manage_woocommerce')) {
            wp_send_json_error(array('message' => __('Insufficient permissions.', 'ai-eshop-optimizer')));
        }
        global $wpdb;
        $items = $this->parse_lookup_input(isset($_POST['input']) ? sanitize_textarea_field(wp_unslash((string) $_POST['input'])) : ''); 
        if (empty($items)) {
            wp_send_json_error(array('message' => __('No valid barcodes provided.', 'ai-eshop-optimizer')));
        }
        $results = array(); $not_found = array(); $parent_ids = array(); $found = 0;
        foreach ($items as $barcode) {
            
            
            $product_id = 0;
            foreach (array('_global_unique_id', '_ean', '_gtin', '_barcode') as $mk) {
                $pid = (int) $wpdb->get_var($wpdb->prepare(
                    "SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key = %s AND meta_value = %s LIMIT 1",
                    $mk, $barcode
                ));
                if ($pid > 0) { $product_id = $pid; break; }
            }
            $row = $this->resolve_lookup_row($barcode, $product_id);
            $results[] = $row;
            if ($row['found']) { $parent_ids[] = $row['parent_id']; $found++; }
            else { $not_found[] = $barcode; }
        }
        $table = self::lookup_table('barcode', $results); 
        wp_send_json_success(array(
            'results'           => $results,
            'unique_parent_ids' => array_values(array_unique(array_filter($parent_ids))),
            'not_found'         => $not_found,
            'found_count'       => $found,
            'not_found_count'   => count($not_found),
            'table'             => $table,
            'icons'             => '' !== $table ? \Rooster\Admin\Ui::icons_of($table) : '',
        ));
    }

    
    private function parse_lookup_input($raw) {
        $raw = str_replace(array("\r\n", "\r"), "\n", (string) $raw);
        $parts = preg_split('/[\n,;]+/', $raw, -1, PREG_SPLIT_NO_EMPTY);
        $out = array();
        foreach ($parts as $p) {
            $p = trim((string) $p);
            if ($p !== '') { $out[] = $p; }
        }
        return array_values(array_unique($out));
    }

    
    private function resolve_lookup_row($input, $product_id) {
        if ($product_id <= 0) {
            return array('input' => $input, 'product_id' => null, 'parent_id' => null, 'found' => false, 'status' => __('Not found', 'ai-eshop-optimizer'));
        }
        if (!function_exists('wc_get_product')) {
            return array('input' => $input, 'product_id' => $product_id, 'parent_id' => $product_id, 'found' => true, 'status' => __('Unknown (WC missing)', 'ai-eshop-optimizer'));
        }
        $product = wc_get_product($product_id);
        if (!$product) {
            return array('input' => $input, 'product_id' => $product_id, 'parent_id' => null, 'found' => false, 'status' => __('Product not loadable', 'ai-eshop-optimizer'));
        }
        $parent_id = $product_id;
        $status    = __('Simple product', 'ai-eshop-optimizer');
        if ($product->is_type('variation')) {
            $parent_id = (int) $product->get_parent_id();
            
            $status    = sprintf(__('Variation (parent: %d)', 'ai-eshop-optimizer'), $parent_id);
        } elseif ($product->is_type('variable')) {
            $status    = __('Variable product', 'ai-eshop-optimizer');
        }
        return array('input' => $input, 'product_id' => (int) $product_id, 'parent_id' => (int) $parent_id, 'found' => true, 'status' => $status);
    }
}