<?php
/**
 * Qixit Admin Class
 * Handles admin settings page and configuration
 * 
 * @package Qixit
 * @version 2.0.0
 */

// Exit if accessed directly
if (!defined('ABSPATH')) {
    exit;
}

class Qixit_Admin {
    
    /**
     * Singleton instance
     */
    private static $instance = null;
    
    /**
     * Auth instance
     */
    private $auth;
    
    /**
     * Logger instance
     */
    private $logger;
    
    /**
     * Get singleton instance
     */
    public static function get_instance() {
        if (self::$instance === null) {
            self::$instance = new self();
        }
        return self::$instance;
    }
    
    /**
     * Constructor
     */
    private function __construct() {
        $this->auth = Qixit_Auth::get_instance();
        $this->logger = Qixit_Logger::get_instance();
        
        // Add admin menu
        add_action('admin_menu', array($this, 'add_admin_menu'));
        
        // Register settings
        add_action('admin_init', array($this, 'register_settings'));
        
        // Enqueue admin styles and scripts
        add_action('admin_enqueue_scripts', array($this, 'enqueue_admin_assets'));

        // Show/manage Qixit ID in WordPress Users screens.
        add_filter('manage_users_columns', array($this, 'add_qixit_user_column'));
        add_filter('manage_users_custom_column', array($this, 'render_qixit_user_column'), 10, 3);
        add_action('show_user_profile', array($this, 'render_qixit_user_profile_field'));
        add_action('edit_user_profile', array($this, 'render_qixit_user_profile_field'));
        add_action('personal_options_update', array($this, 'save_qixit_user_profile_field'));
        add_action('edit_user_profile_update', array($this, 'save_qixit_user_profile_field'));
        add_action('admin_init', array($this, 'handle_author_approval_actions'));
        add_action('admin_notices', array($this, 'render_author_approval_notice'));
        add_action('admin_notices', array($this, 'render_pending_submission_queue_notice'));
        add_action('admin_notices', array($this, 'render_global_paid_comments_sync_notice'));
        add_action('update_option_qixit_enable_paid_comments_global', array($this, 'handle_global_paid_comments_option_change'), 10, 2);
        add_action('update_option_qixit_global_paid_comments_price', array($this, 'handle_global_paid_comments_price_change'), 10, 2);
    }
    
    /**
     * Add admin menu
     */
    public function add_admin_menu() {
        add_menu_page(
            __('2WayMicropay Settings', '2waymicropay'),
            __('2WayMicropay', '2waymicropay'),
            'manage_options',
            'qixit-settings',
            array($this, 'render_settings_page'),
            'dashicons-money-alt',
            80
        );
        
        add_submenu_page(
            'qixit-settings',
            __('Settings', '2waymicropay'),
            __('Settings', '2waymicropay'),
            'manage_options',
            'qixit-settings',
            array($this, 'render_settings_page')
        );
        
        add_submenu_page(
            'qixit-settings',
            __('Customers', '2waymicropay'),
            __('👥 Customers', '2waymicropay'),
            'manage_options',
            'qixit-customers',
            array($this, 'render_customers_page')
        );
        
        add_submenu_page(
            'qixit-settings',
            __('Instructions', '2waymicropay'),
            __('📖 Instructions', '2waymicropay'),
            'manage_options',
            'qixit-instructions',
            array($this, 'render_instructions_page')
        );
    }
    
    /**
     * Register settings
     */
    public function register_settings() {
        // General Settings Section
        add_settings_section(
            'qixit_general_section',
            __('General Settings', '2waymicropay'),
            array($this, 'render_general_section'),
            'qixit-settings'
        );
        
        // Default Commercial Category (required)
        register_setting('qixit_settings', 'qixit_default_commercial_category', array(
            'type' => 'string',
            'sanitize_callback' => 'sanitize_text_field',
            'default' => ''
        ));
        
        register_setting('qixit_settings', 'qixit_enable_logging', array(
            'type' => 'boolean',
            'sanitize_callback' => array($this, 'sanitize_checkbox'),
            'default' => false
        ));
        
        // Site API Key (required for production - usage tracking and rate limiting)
        add_settings_section(
            'qixit_developer_section',
            __('Site API Key', '2waymicropay'),
            array($this, 'render_developer_section'),
            'qixit-settings'
        );
        
        register_setting('qixit_settings', 'qixit_site_api_key', array(
            'type' => 'string',
            'sanitize_callback' => 'sanitize_text_field',
            'default' => ''
        ));

        // Keep old option for backwards compatibility
        register_setting('qixit_settings', 'qixit_developer_api_key', array(
            'type' => 'string',
            'sanitize_callback' => 'sanitize_text_field',
            'default' => ''
        ));

        // Author commerce settings (v4.0)
        register_setting('qixit_settings', 'qixit_enable_author_commerce', array(
            'type' => 'boolean',
            'sanitize_callback' => array($this, 'sanitize_checkbox'),
            'default' => false
        ));
        register_setting('qixit_settings', 'qixit_author_onboarding_fee', array(
            'type' => 'number',
            'sanitize_callback' => array($this, 'sanitize_decimal'),
            'default' => 0
        ));
        register_setting('qixit_settings', 'qixit_author_publish_fee', array(
            'type' => 'number',
            'sanitize_callback' => array($this, 'sanitize_decimal'),
            'default' => 0
        ));
        register_setting('qixit_settings', 'qixit_author_default_split_percent', array(
            'type' => 'integer',
            'sanitize_callback' => array($this, 'sanitize_percentage'),
            'default' => 0
        ));
        register_setting('qixit_settings', 'qixit_author_require_moderation', array(
            'type' => 'boolean',
            'sanitize_callback' => array($this, 'sanitize_checkbox'),
            'default' => true
        ));
        register_setting('qixit_settings', 'qixit_author_terms_text', array(
            'type' => 'string',
            'sanitize_callback' => array($this, 'sanitize_author_terms_html'),
            'default' => ''
        ));
        register_setting('qixit_settings', 'qixit_author_signup_email_mode', array(
            'type' => 'string',
            'sanitize_callback' => array($this, 'sanitize_signup_email_mode'),
            'default' => 'required'
        ));
        register_setting('qixit_settings', 'qixit_author_immediate_access_redirect_url', array(
            'type' => 'string',
            'sanitize_callback' => array($this, 'sanitize_pending_review_redirect_url'),
            'default' => ''
        ));
        register_setting('qixit_settings', 'qixit_share_comment_revenue_with_authors', array(
            'type' => 'boolean',
            'sanitize_callback' => array($this, 'sanitize_checkbox'),
            'default' => false
        ));
        register_setting('qixit_settings', 'qixit_comment_author_share_percent', array(
            'type' => 'integer',
            'sanitize_callback' => array($this, 'sanitize_percentage'),
            'default' => 0
        ));
        register_setting('qixit_settings', 'qixit_enable_paid_comments_global', array(
            'type' => 'boolean',
            'sanitize_callback' => array($this, 'sanitize_checkbox'),
            'default' => false
        ));
        register_setting('qixit_settings', 'qixit_global_paid_comments_price', array(
            'type' => 'number',
            'sanitize_callback' => array($this, 'sanitize_decimal'),
            'default' => 0.05
        ));
        register_setting('qixit_settings', 'qixit_enable_forwarder_commissions', array(
            'type' => 'boolean',
            'sanitize_callback' => array($this, 'sanitize_checkbox'),
            'default' => false
        ));
        register_setting('qixit_settings', 'qixit_forwarder_percent', array(
            'type' => 'integer',
            'sanitize_callback' => array($this, 'sanitize_percentage'),
            'default' => 0
        ));
    }
    
    /**
     * Render Site API key section description
     */
    public function render_developer_section() {
        echo '<p style="font-weight: bold; color: #d63638;">' . esc_html__('Required: Enter your Site API Key for production usage tracking, rate limiting, and analytics.', '2waymicropay') . '</p>';
        echo '<p>' . esc_html__('Create a Site API Key in the Products Portal:', '2waymicropay') . ' <a href="https://products.qixit.com/api-keys" target="_blank">products.qixit.com/api-keys</a></p>';
        echo '<p><small>' . esc_html__('This key identifies your website to the 2WayMicropay platform and enables per-site usage tracking.', '2waymicropay') . '</small></p>';
    }
    
    /**
     * Sanitize password (encrypt before storing)
     */
    public function sanitize_password($password) {
        $current = get_option('qixit_vendor_password');
        if (empty($password)) {
            // Preserve existing encrypted password when settings are saved
            // without typing a new password into the field.
            return !empty($current) ? $current : '';
        }
        
        // Don't re-encrypt if it's already encrypted
        if ($password === $current) {
            return $current;
        }
        
        return $this->auth->encrypt_password($password);
    }
    
    /**
     * Sanitize checkbox settings using WordPress REST boolean sanitizer.
     */
    public function sanitize_checkbox($value) {
        if (function_exists('rest_sanitize_boolean')) {
            return rest_sanitize_boolean($value);
        }

        if (is_bool($value)) {
            return $value;
        }

        $normalized = strtolower(trim((string) $value));
        return in_array($normalized, array('1', 'true', 'yes', 'on'), true);
    }

    /**
     * Sanitize decimal currency field.
     */
    public function sanitize_decimal($value) {
        return max(0, round(floatval($value), 2));
    }

    /**
     * Sanitize percentage field (0-100).
     */
    public function sanitize_percentage($value) {
        $value = intval($value);
        if ($value < 0) {
            return 0;
        }
        if ($value > 100) {
            return 100;
        }
        return $value;
    }

    /**
     * Sanitize author signup email mode.
     *
     * @param string $value
     * @return string
     */
    public function sanitize_signup_email_mode($value) {
        $allowed = array('required', 'optional', 'hidden');
        $value = sanitize_text_field($value);
        return in_array($value, $allowed, true) ? $value : 'required';
    }

    /**
     * Sanitize pending-review redirect URL.
     *
     * @param string $value
     * @return string
     */
    public function sanitize_pending_review_redirect_url($value) {
        return esc_url_raw($value);
    }

    /**
     * Sanitize author terms allowing safe hyperlink markup.
     *
     * @param string $value
     * @return string
     */
    public function sanitize_author_terms_html($value) {
        // Allow standard post content HTML so publisher-entered formatting
        // and links are preserved in [qixit_author_rights].
        return wp_kses_post($value);
    }

    /**
     * Add Qixit ID column to users list.
     *
     * @param array $columns
     * @return array
     */
    public function add_qixit_user_column($columns) {
        $columns['qixit_id'] = __('Qixit ID', '2waymicropay');
        $columns['qixit_author_approval'] = __('Author Access', '2waymicropay');
        return $columns;
    }

    /**
     * Render Qixit ID in users list.
     *
     * @param string $value
     * @param string $column_name
     * @param int    $user_id
     * @return string
     */
    public function render_qixit_user_column($value, $column_name, $user_id) {
        if ($column_name === 'qixit_author_approval') {
            $user = get_user_by('id', intval($user_id));
            if (!$user) {
                return '&mdash;';
            }
            if (in_array('contributor', (array)$user->roles, true)) {
                return esc_html__('Contributor (editor/admin approval required to publish)', '2waymicropay');
            }
            if (in_array('author', (array)$user->roles, true)) {
                return esc_html__('Author (can publish)', '2waymicropay');
            }
            return esc_html__('N/A', '2waymicropay');
        }

        if ($column_name !== 'qixit_id') {
            return $value;
        }

        $qixit_id = '';
        if (class_exists('Qixit_Author_Commerce')) {
            $qixit_id = Qixit_Author_Commerce::get_instance()->get_author_qixit_id(intval($user_id));
        }
        return !empty($qixit_id) ? esc_html($qixit_id) : '&mdash;';
    }

    /**
     * Render editable Qixit ID on user profile pages.
     *
     * @param WP_User $user
     * @return void
     */
    public function render_qixit_user_profile_field($user) {
        if (!current_user_can('edit_user', $user->ID)) {
            return;
        }

        $qixit_id = '';
        if (class_exists('Qixit_Author_Commerce')) {
            $qixit_id = Qixit_Author_Commerce::get_instance()->get_author_qixit_id(intval($user->ID));
        }
        ?>
        <h2><?php esc_html_e('2WayMicropay Author Mapping', '2waymicropay'); ?></h2>
        <table class="form-table" role="presentation">
            <tr>
                <th><label for="qixit_user_profile_id"><?php esc_html_e('Qixit ID / Username', '2waymicropay'); ?></label></th>
                <td>
                    <input type="text"
                           id="qixit_user_profile_id"
                           name="qixit_user_profile_id"
                           value="<?php echo esc_attr($qixit_id); ?>"
                           class="regular-text" />
                    <p class="description">
                        <?php esc_html_e('Used for author revenue sharing and affiliate attribution.', '2waymicropay'); ?>
                    </p>
                </td>
            </tr>
        </table>
        <?php
    }

    /**
     * Persist Qixit ID updates from user profile.
     *
     * @param int $user_id
     * @return void
     */
    public function save_qixit_user_profile_field($user_id) {
        if (!current_user_can('edit_user', $user_id)) {
            return;
        }

        // Profile form submission nonce (WordPress core user/profile screens).
        if (
            !isset($_POST['_wpnonce']) ||
            !wp_verify_nonce(sanitize_text_field(wp_unslash($_POST['_wpnonce'])), 'update-user_' . $user_id)
        ) {
            return;
        }

        $qixit_id = isset($_POST['qixit_user_profile_id'])
            ? sanitize_text_field(wp_unslash($_POST['qixit_user_profile_id']))
            : '';

        if (class_exists('Qixit_Author_Commerce')) {
            Qixit_Author_Commerce::get_instance()->sync_author_identity(intval($user_id), $qixit_id, false);
            return;
        }

        update_user_meta($user_id, 'qixit_id', $qixit_id);
        update_user_meta($user_id, 'qixit_user_id', $qixit_id);
        update_user_meta($user_id, 'qixit_username', $qixit_id);
    }

    /**
     * Approve pending new-author account from Users admin.
     *
     * @return void
     */
    public function handle_author_approval_actions() {
        if (!is_admin() || !current_user_can('manage_options')) {
            return;
        }

        $qixit_action = isset($_GET['qixit_action']) ? sanitize_key(wp_unslash($_GET['qixit_action'])) : '';
        if ($qixit_action !== 'approve_author') {
            return;
        }

        $user_id = isset($_GET['user_id']) ? intval(wp_unslash($_GET['user_id'])) : 0;
        if ($user_id <= 0) {
            return;
        }

        if (!isset($_GET['_wpnonce']) || !wp_verify_nonce(sanitize_text_field(wp_unslash($_GET['_wpnonce'])), 'qixit_approve_author_' . $user_id)) {
            return;
        }

        $user = get_user_by('id', $user_id);
        if (!$user) {
            return;
        }

        $user->set_role('author');
        delete_user_meta($user_id, 'qixit_author_approval_pending');
        update_user_meta($user_id, 'qixit_author_approved_at', current_time('mysql'));
        update_user_meta($user_id, 'qixit_author_approved_by', get_current_user_id());

        if (class_exists('Qixit_Author_Commerce')) {
            $commerce = Qixit_Author_Commerce::get_instance();
            $qixit_id = $commerce->get_author_qixit_id($user_id);
            $commerce->sync_author_identity($user_id, $qixit_id, true);
        }

        wp_safe_redirect(add_query_arg('qixit_author_approved', '1', admin_url('users.php')));
        exit;
    }

    /**
     * Render admin notice after approval action.
     *
     * @return void
     */
    public function render_author_approval_notice() {
        if (!is_admin() || !current_user_can('manage_options')) {
            return;
        }
        // phpcs:ignore WordPress.Security.NonceVerification.Recommended -- read-only success flag used only for admin notice rendering.
        $author_approved = isset($_GET['qixit_author_approved']) ? sanitize_text_field(wp_unslash($_GET['qixit_author_approved'])) : '';
        if ($author_approved !== '1') {
            return;
        }
        echo '<div class="notice notice-success is-dismissible"><p>' .
            esc_html__('Author approved successfully. The user can now create and publish content.', '2waymicropay') .
            '</p></div>';
    }

    /**
     * Render editor/admin notice when contributor submissions are pending review.
     *
     * @return void
     */
    public function render_pending_submission_queue_notice() {
        if (!is_admin() || !current_user_can('edit_others_posts')) {
            return;
        }
        if (!boolval(get_option('qixit_enable_author_commerce', false))) {
            return;
        }
        if (!boolval(get_option('qixit_author_require_moderation', true))) {
            return;
        }

        $pending_posts = wp_count_posts('post');
        $pending_count = isset($pending_posts->pending) ? intval($pending_posts->pending) : 0;
        if ($pending_count <= 0) {
            return;
        }

        $review_url = admin_url('edit.php?post_status=pending&post_type=post');
        $post_label = _n('post', 'posts', $pending_count, '2waymicropay');
        $message = sprintf(
            /* translators: 1: count of pending posts, 2: singular/plural label */
            __('Contributor release queue: %1$d pending %2$s waiting for editor/admin approval.', '2waymicropay'),
            $pending_count,
            $post_label
        );

        echo '<div class="notice notice-warning is-dismissible"><p>' .
            esc_html($message) .
            ' <a class="button button-secondary" href="' . esc_url($review_url) . '">' .
            esc_html__('Review Pending Posts', '2waymicropay') .
            '</a></p></div>';
    }

    /**
     * Apply global paid-comments defaults when option is turned on.
     *
     * @param mixed $old_value
     * @param mixed $new_value
     * @return void
     */
    public function handle_global_paid_comments_option_change($old_value, $new_value) {
        $was_enabled = boolval($old_value);
        $is_enabled = boolval($new_value);
        if ($was_enabled || !$is_enabled || !class_exists('Qixit_Comments')) {
            return;
        }
        $result = Qixit_Comments::apply_global_paid_comments_defaults_to_existing_content();
        set_transient('qixit_global_paid_comments_sync_notice', $result, 120);
    }

    /**
     * Refresh global paid-comments defaults when default price changes.
     *
     * @param mixed $old_value
     * @param mixed $new_value
     * @return void
     */
    public function handle_global_paid_comments_price_change($old_value, $new_value) {
        if (floatval($old_value) === floatval($new_value)) {
            return;
        }
        if (!boolval(get_option('qixit_enable_paid_comments_global', false)) || !class_exists('Qixit_Comments')) {
            return;
        }
        $result = Qixit_Comments::apply_global_paid_comments_defaults_to_existing_content();
        set_transient('qixit_global_paid_comments_sync_notice', $result, 120);
    }

    /**
     * Show one-time admin notice after global paid-comments backfill.
     *
     * @return void
     */
    public function render_global_paid_comments_sync_notice() {
        if (!is_admin() || !current_user_can('manage_options')) {
            return;
        }
        $result = get_transient('qixit_global_paid_comments_sync_notice');
        if (!is_array($result)) {
            return;
        }
        delete_transient('qixit_global_paid_comments_sync_notice');
        $processed = isset($result['processed']) ? intval($result['processed']) : 0;
        $synced = isset($result['synced']) ? intval($result['synced']) : 0;
        $message = sprintf(
            /* translators: 1: number of posts/pages updated, 2: number of comments products synced */
            __('Global paid comments applied to %1$d existing posts/pages. Shared comments product sync attempts: %2$d.', '2waymicropay'),
            $processed,
            $synced
        );
        echo '<div class="notice notice-success is-dismissible"><p>' . esc_html($message) . '</p></div>';
    }
    
    /**
     * Get commercial categories from the API
     * Categories are cached for 1 hour to avoid excessive API calls
     * 
     * @return array Associative array of code => display name
     */
    public function get_commercial_categories() {
        // Check for cached categories
        $cached = get_transient('qixit_commercial_categories');
        if ($cached !== false) {
            return $cached;
        }
        
        // Default categories in case API call fails
        $default_categories = array(
            '' => __('-- Select a Category (Required) --', '2waymicropay'),
            '015' => __('Entertainment', '2waymicropay'),
            '030' => __('Digital Goods', '2waymicropay'),
            '050' => __('Professional Services', '2waymicropay'),
            '060' => __('Charitable Donations', '2waymicropay'),
            '070' => __('Media & Content', '2waymicropay')
        );
        
        try {
            // Fetch categories from the API
            $api = Qixit_API::get_instance();
            $response = $api->get_categories();
            
            if ($response['success'] && !empty($response['data'])) {
                $categories = array(
                    '' => __('-- Select a Category (Required) --', '2waymicropay')
                );
                
                foreach ($response['data'] as $category) {
                    $code = isset($category['code']) ? $category['code'] : '';
                    $name = isset($category['categoryName']) ? $category['categoryName'] : '';
                    
                    if (!empty($code)) {
                        // Show code in parentheses for clarity
                        $categories[$code] = !empty($name) ? "{$name} ({$code})" : "Category {$code}";
                    }
                }
                
                // Cache for 1 hour
                set_transient('qixit_commercial_categories', $categories, HOUR_IN_SECONDS);
                
                $this->logger->log("Fetched " . (count($categories) - 1) . " commercial categories from API");
                
                return $categories;
            } else {
                $error_msg = isset($response['message']) ? $response['message'] : 'Unknown error';
                $this->logger->log("Failed to fetch commercial categories: {$error_msg}", 'error');
            }
        } catch (Exception $e) {
            $this->logger->log("Exception fetching commercial categories: " . $e->getMessage(), 'error');
        }
        
        // Return defaults on failure, but don't cache them (try again next time)
        return $default_categories;
    }
    
    /**
     * Clear cached commercial categories
     * Called when a user clicks "Refresh Categories" button
     */
    public function clear_categories_cache() {
        delete_transient('qixit_commercial_categories');
        $this->logger->log("Commercial categories cache cleared");
    }
    
    /**
     * Enqueue admin assets
     */
    public function enqueue_admin_assets($hook) {
        // Load on Qixit pages, post editor, and post list (for bulk actions)
        $allowed_hooks = array('post.php', 'post-new.php', 'edit.php');
        
        // WordPress hook names for this plugin are usually qixit-* (for example
        // "toplevel_page_qixit-settings"), not always "2WayMicropay".
        if (strpos($hook, 'qixit') === false && strpos($hook, '2waymicropay') === false && !in_array($hook, $allowed_hooks, true)) {
            return;
        }
        
        wp_enqueue_style('qixit-admin');
        wp_enqueue_script('qixit-admin');
    }
    
    /**
     * Render credentials section
     */
    public function render_credentials_section() {
        echo '<p>' . esc_html__('Enter your 2WayMicropay vendor credentials to authenticate with the API.', '2waymicropay') . '</p>';
    }
    
    /**
     * Render general section
     */
    public function render_general_section() {
        echo '<p>' . esc_html__('General plugin settings.', '2waymicropay') . '</p>';
    }
    
    /**
     * Render settings page
     */
    public function render_settings_page() {
        if (!current_user_can('manage_options')) {
            return;
        }
        
        // Get token status
        $token_status = $this->auth->get_token_status();

        // After settings save, proactively provision required author-commerce products.
        // phpcs:ignore WordPress.Security.NonceVerification.Recommended -- WordPress settings API owns nonce validation for options.php submissions.
        $settings_updated = isset($_GET['settings-updated']) ? sanitize_text_field(wp_unslash($_GET['settings-updated'])) : '';
        if ($settings_updated === 'true' && class_exists('Qixit_Author_Commerce')) {
            $provision = Qixit_Author_Commerce::get_instance()->ensure_required_products(true);
            if (!empty($provision['messages']) && is_array($provision['messages'])) {
                foreach ($provision['messages'] as $message) {
                    add_settings_error('qixit_messages', 'qixit_author_commerce_provision_ok', $message, 'success');
                }
            }
            if (!empty($provision['errors']) && is_array($provision['errors'])) {
                foreach ($provision['errors'] as $error) {
                    add_settings_error('qixit_messages', 'qixit_author_commerce_provision_error', $error, 'error');
                }
            }
        }
        
        ?>
        <div class="wrap">
            <h1><?php echo esc_html(get_admin_page_title()); ?></h1>
            
            <?php settings_errors('qixit_messages'); ?>
            
            <!-- Compact Connection/Diagnostics/Sync Card -->
            <div class="qixit-status-card" style="padding:3px; margin:3px 0;">
                <div style="display:flex; gap:10px; flex-wrap:wrap; align-items:center;">
                    <h2 style="margin:0;"><?php esc_html_e('Connection & Sync', '2waymicropay'); ?></h2>
                    <div class="qixit-status-info" style="margin:0;">
                        <span class="qixit-status-indicator qixit-status-<?php echo esc_attr($token_status['status']); ?>"></span>
                        <strong><?php echo esc_html($token_status['message']); ?></strong>
                    </div>
                    <button type="button" class="button button-secondary" id="qixit-test-connection">
                        <?php esc_html_e('Test API Connection', '2waymicropay'); ?>
                    </button>
                    <form method="post" style="margin:0;">
                    <?php wp_nonce_field('qixit_resync_all', 'qixit_resync_nonce'); ?>
                    <button type="submit" name="qixit_resync_all" class="button button-primary" 
                            onclick="return confirm('This will resync ALL products and paid comments to the Products Portal API (including Price Optimization Categories). This may take a while for sites with many products. Continue?');">
                        🔄 <?php esc_html_e('Resync All Products & Payouts', '2waymicropay'); ?>
                    </button>
                </form>
                </div>
                <p class="description" style="margin-top:8px;">
                    <?php esc_html_e('Use Test API for troubleshooting. Use Resync to refresh Report URLs, purchase tracking links, and Price Optimization Categories (WordPress categories or WP Post/WP Page / Paid Comments / Author Rights defaults). Metrics and A/B tests remain in the Vendor portal.', '2waymicropay'); ?>
                </p>
                <div id="qixit-test-results" style="display:none; margin-top:10px;"></div>
                
                <?php
                // Handle resync action
                if (isset($_POST['qixit_resync_all']) && isset($_POST['qixit_resync_nonce']) && wp_verify_nonce(sanitize_text_field(wp_unslash($_POST['qixit_resync_nonce'])), 'qixit_resync_all')) {
                    $resync_result = $this->resync_all_products();
                    echo '<div class="notice notice-' . ($resync_result['success'] ? 'success' : 'error') . '" style="margin-top: 15px;"><p>' . esc_html($resync_result['message']) . '</p></div>';
                }
                ?>
            </div>

            <!-- Settings Form -->
            <form action="options.php" method="post">
                <?php
                settings_fields('qixit_settings');
                ?>
                
                <h2><?php esc_html_e('Connection Settings', '2waymicropay'); ?></h2>
                <p class="description"><?php esc_html_e('Configure your Site API Key to connect this WordPress site to Products Portal.', '2waymicropay'); ?></p>
                
                <table class="form-table" role="presentation">
                    <!-- Site API Key (Required) -->
                    <tr>
                        <th scope="row">
                            <label for="qixit_site_api_key"><?php esc_html_e('Site API Key', '2waymicropay'); ?> <span style="color:red;">*</span></label>
                        </th>
                        <td>
                            <?php
                            // Use new option name, fall back to old for backwards compatibility
                            $site_key = get_option('qixit_site_api_key', '');
                            if (empty($site_key)) {
                                $site_key = get_option('qixit_developer_api_key', '');
                            }
                            ?>
                            <input type="text" 
                                   id="qixit_site_api_key" 
                                   name="qixit_site_api_key" 
                                   value="<?php echo esc_attr($site_key); ?>" 
                                   class="regular-text" 
                                   placeholder="sk_site_..." />
                            <p class="description">
                                <?php esc_html_e('Required: Your Site API Key for usage tracking, rate limiting, and analytics.', '2waymicropay'); ?>
                                <a href="https://products.qixit.com/api-keys" target="_blank"><?php esc_html_e('Create your Site API Key', '2waymicropay'); ?></a>
                            </p>
                            <?php if (empty($site_key)): ?>
                            <p class="description" style="color: #d63638; font-weight: bold;">
                                &#9888; <?php esc_html_e('A Site API Key is required for production use. Create one in the Products Portal.', '2waymicropay'); ?>
                            </p>
                            <?php endif; ?>
                        </td>
                    </tr>
                </table>
                
                <h2><?php esc_html_e('Content Settings', '2waymicropay'); ?></h2>
                
                <?php
                // Fetch commercial categories from the API
                $commercial_categories = $this->get_commercial_categories();
                $default_category = get_option('qixit_default_commercial_category', '');
                ?>
                
                <table class="form-table" role="presentation">
                    <!-- Default Commercial Category -->
                    <tr>
                        <th scope="row">
                            <label for="qixit_default_commercial_category"><?php esc_html_e('Default Commercial Code', '2waymicropay'); ?> <span style="color:red;">*</span></label>
                        </th>
                        <td>
                            <select id="qixit_default_commercial_category" 
                                    name="qixit_default_commercial_category" 
                                    class="regular-text"
                                    required>
                                <?php foreach ($commercial_categories as $value => $label): ?>
                                    <option value="<?php echo esc_attr($value); ?>" <?php selected($default_category, $value); ?>>
                                        <?php echo esc_html($label); ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                            <p class="description">
                                <?php esc_html_e('Postage / commercial classification for new premium content (not the Vendor portal Price Optimization Category). Individual posts can override this. Price Optimization Categories follow WordPress categories on posts/pages, or defaults such as Paid Comments and Author Rights.', '2waymicropay'); ?>
                            </p>
                            <p class="description">
                                <?php
                                echo wp_kses_post(
                                    sprintf(
                                        /* translators: %s: products portal pricing URL */
                                        __('View priced-render metrics, demand curves, and A/B price tests in the <a href="%s" target="_blank" rel="noopener noreferrer">Vendor portal (Pricing)</a>. This plugin does not show those metrics.', '2waymicropay'),
                                        esc_url('https://products.qixit.com/pricing')
                                    )
                                );
                                ?>
                            </p>
                            <?php if (empty($default_category)): ?>
                            <p class="description" style="color: #d63638; font-weight: bold;">
                                ⚠️ <?php esc_html_e('You must select a default commercial code before creating premium content.', '2waymicropay'); ?>
                            </p>
                            <?php endif; ?>
                        </td>
                    </tr>
                    <tr>
                        <th scope="row"><?php esc_html_e('Global Paid Comments', '2waymicropay'); ?></th>
                        <td>
                            <label>
                                <input type="checkbox"
                                       name="qixit_enable_paid_comments_global"
                                       value="1"
                                       <?php checked(get_option('qixit_enable_paid_comments_global', false), true); ?> />
                                <?php esc_html_e('Enable paid comments on all existing and future posts/pages (fallback mode)', '2waymicropay'); ?>
                            </label>
                            <p class="description">
                                <?php esc_html_e('This creates a shared comments product and enables comment payment globally. Individual post settings can still change price or disable paid comments.', '2waymicropay'); ?>
                            </p>
                            <label for="qixit_global_paid_comments_price"><strong><?php esc_html_e('Default Comment Price ($)', '2waymicropay'); ?></strong></label><br />
                            <input type="number"
                                   id="qixit_global_paid_comments_price"
                                   name="qixit_global_paid_comments_price"
                                   value="<?php echo esc_attr(number_format(floatval(get_option('qixit_global_paid_comments_price', 0.05)), 2, '.', '')); ?>"
                                   min="0.01" step="0.01" class="small-text" />
                            <p class="description">
                                <?php esc_html_e('Used as the fallback paid-comments price when a post has no specific comments price configured.', '2waymicropay'); ?>
                            </p>
                        </td>
                    </tr>
                    
                </table>

                <h2><?php esc_html_e('Forwarder Referral Commissions', '2waymicropay'); ?></h2>
                <p class="description">
                    <?php esc_html_e('Allow promoters to earn a commission when they share your purchase links with their Qixit ID in the URL (?fwd= or &fwd=). If the forwarder ID is missing or invalid, that commission percentage stays with you.', '2waymicropay'); ?>
                </p>
                <table class="form-table" role="presentation">
                    <tr>
                        <th scope="row"><?php esc_html_e('Allow Forwarder Split', '2waymicropay'); ?></th>
                        <td>
                            <label>
                                <input type="checkbox"
                                       name="qixit_enable_forwarder_commissions"
                                       id="qixit_enable_forwarder_commissions"
                                       value="1"
                                       <?php checked(get_option('qixit_enable_forwarder_commissions', false), true); ?> />
                                <?php esc_html_e('Enable forwarder referral commissions on purchase products created by this site', '2waymicropay'); ?>
                            </label>
                        </td>
                    </tr>
                    <tr>
                        <th scope="row">
                            <label for="qixit_forwarder_percent"><?php esc_html_e('Forwarder Commission (%)', '2waymicropay'); ?></label>
                        </th>
                        <td>
                            <input type="number"
                                   id="qixit_forwarder_percent"
                                   name="qixit_forwarder_percent"
                                   value="<?php echo esc_attr(get_option('qixit_forwarder_percent', 0)); ?>"
                                   min="0" max="100" step="1" class="small-text" />
                            <p class="description">
                                <?php esc_html_e('When enabled, purchase links include an empty &fwd= suffix so promoters can copy the link and type their Qixit ID. Author/affiliate share plus forwarder share must not exceed 100%.', '2waymicropay'); ?>
                            </p>
                            <?php
                            $author_share = intval(get_option('qixit_author_default_split_percent', 0));
                            $fwd_share = intval(get_option('qixit_forwarder_percent', 0));
                            if (boolval(get_option('qixit_enable_forwarder_commissions', false)) && ($author_share + $fwd_share) > 100):
                            ?>
                            <p class="description" style="color:#d63638; font-weight:bold;">
                                <?php esc_html_e('Warning: Default author share + forwarder commission exceeds 100%. Reduce one of them before syncing products.', '2waymicropay'); ?>
                            </p>
                            <?php endif; ?>
                        </td>
                    </tr>
                </table>

                <h2><?php esc_html_e('Author Commerce Settings', '2waymicropay'); ?></h2>
                <p class="description">
                    <?php esc_html_e('Configure paid author rights, publish fees, and default revenue-sharing terms for contributor content.', '2waymicropay'); ?>
                </p>
                <?php
                $immediate_destination_url = get_option('qixit_author_immediate_access_redirect_url', '');
                if (class_exists('Qixit_Author_Commerce')) {
                    $author_commerce = Qixit_Author_Commerce::get_instance();
                    $immediate_destination_url = $author_commerce->get_immediate_access_destination_url();
                }
                ?>

                <table class="form-table" role="presentation">
                    <tr>
                        <th scope="row"><?php esc_html_e('Enable Author Commerce', '2waymicropay'); ?></th>
                        <td>
                            <label>
                                <input type="checkbox"
                                       name="qixit_enable_author_commerce"
                                       value="1"
                                       <?php checked(get_option('qixit_enable_author_commerce', false), true); ?> />
                                <?php esc_html_e('Require paid author rights and optional publish fees for contributors', '2waymicropay'); ?>
                            </label>
                        </td>
                    </tr>
                    <tr>
                        <th scope="row">
                            <label for="qixit_author_onboarding_fee"><?php esc_html_e('Author Rights Fee ($)', '2waymicropay'); ?></label>
                        </th>
                        <td>
                            <input type="number"
                                   id="qixit_author_onboarding_fee"
                                   name="qixit_author_onboarding_fee"
                                   value="<?php echo esc_attr(get_option('qixit_author_onboarding_fee', 0)); ?>"
                                   min="0" step="0.01" class="small-text" />
                            <p class="description">
                                <?php esc_html_e('One-time fee for third parties to purchase author rights.', '2waymicropay'); ?>
                            </p>
                        </td>
                    </tr>
                    <tr>
                        <th scope="row">
                            <label for="qixit_author_publish_fee"><?php esc_html_e('Per Publish Fee ($)', '2waymicropay'); ?></label>
                        </th>
                        <td>
                            <input type="number"
                                   id="qixit_author_publish_fee"
                                   name="qixit_author_publish_fee"
                                   value="<?php echo esc_attr(get_option('qixit_author_publish_fee', 0)); ?>"
                                   min="0" step="0.01" class="small-text" />
                            <p class="description">
                                <?php esc_html_e('Fee required only for the first publish of a new post.', '2waymicropay'); ?>
                            </p>
                        </td>
                    </tr>
                    <tr>
                        <th scope="row">
                            <label for="qixit_author_default_split_percent"><?php esc_html_e('Default Author Revenue Share (%)', '2waymicropay'); ?></label>
                        </th>
                        <td>
                            <input type="number"
                                   id="qixit_author_default_split_percent"
                                   name="qixit_author_default_split_percent"
                                   value="<?php echo esc_attr(get_option('qixit_author_default_split_percent', 0)); ?>"
                                   min="0" max="100" step="1" class="small-text" />
                            <p class="description">
                                <?php esc_html_e('Default split used when post-level author share is not explicitly set.', '2waymicropay'); ?>
                            </p>
                        </td>
                    </tr>
                    <tr>
                        <th scope="row"><?php esc_html_e('Moderation Policy', '2waymicropay'); ?></th>
                        <td>
                            <?php $require_moderation = boolval(get_option('qixit_author_require_moderation', true)); ?>
                            <input type="hidden"
                                   name="qixit_author_require_moderation"
                                   id="qixit_author_require_moderation"
                                   value="<?php echo $require_moderation ? '1' : '0'; ?>" />
                            <label style="display:block; margin-bottom:8px;">
                                <input type="checkbox"
                                       class="qixit-moderation-choice"
                                       data-moderation-value="1"
                                       <?php checked($require_moderation, true); ?> />
                                <?php esc_html_e('User role: Contributor. Contributions must be approved by Editor or Admin.', '2waymicropay'); ?>
                            </label>
                            <label style="display:block;">
                                <input type="checkbox"
                                       class="qixit-moderation-choice"
                                       data-moderation-value="0"
                                       <?php checked($require_moderation, false); ?> />
                                <?php esc_html_e('User role: Author. Authors can publish posts at their discretion.', '2waymicropay'); ?>
                            </label>
                            <p class="description">
                                <?php esc_html_e('These options are mutually exclusive. Choose whether paid applicants become Contributors (approval required) or Authors (can publish).', '2waymicropay'); ?>
                            </p>
                        </td>
                    </tr>
                    <tr>
                        <th scope="row">
                            <label for="qixit_author_immediate_access_redirect_url"><?php esc_html_e('Author Instructions URL', '2waymicropay'); ?></label>
                        </th>
                        <td>
                            <input type="url"
                                   id="qixit_author_immediate_access_redirect_url"
                                   name="qixit_author_immediate_access_redirect_url"
                                   value="<?php echo esc_attr(get_option('qixit_author_immediate_access_redirect_url', '')); ?>"
                                   class="regular-text"
                                   placeholder="<?php echo esc_attr(home_url('/author-login-instructions/')); ?>" />
                            <p class="description">
                                <?php esc_html_e('After successful payment, new authors are redirected to login instructions.', '2waymicropay'); ?>
                            </p>
                            <?php if (!empty($immediate_destination_url)): ?>
                            <p class="description">
                                <?php esc_html_e('Current destination:', '2waymicropay'); ?>
                                <a href="<?php echo esc_url($immediate_destination_url); ?>" target="_blank" rel="noopener">
                                    <?php echo esc_html($immediate_destination_url); ?>
                                </a>
                            </p>
                            <?php endif; ?>
                            <p class="description">
                                <?php esc_html_e('Site owner note: edit this page and consider adding your own provisions, contract terms, and onboarding policy.', '2waymicropay'); ?>
                            </p>
                        </td>
                    </tr>
                    <tr>
                        <th scope="row">
                            <label for="qixit_author_terms_text"><?php esc_html_e('Author Terms', '2waymicropay'); ?></label>
                        </th>
                        <td>
                            <textarea id="qixit_author_terms_text"
                                      name="qixit_author_terms_text"
                                      rows="5"
                                      class="large-text"><?php echo esc_textarea(get_option('qixit_author_terms_text', '')); ?></textarea>
                            <p class="description">
                                <?php esc_html_e('Displayed to contributors when purchasing author rights.', '2waymicropay'); ?>
                            </p>
                        </td>
                    </tr>
                    <tr>
                        <th scope="row">
                            <label for="qixit_author_signup_email_mode"><?php esc_html_e('Signup Email Field', '2waymicropay'); ?></label>
                        </th>
                        <td>
                            <?php $email_mode = get_option('qixit_author_signup_email_mode', 'required'); ?>
                            <select id="qixit_author_signup_email_mode" name="qixit_author_signup_email_mode" class="regular-text">
                                <option value="required" <?php selected($email_mode, 'required'); ?>><?php esc_html_e('Required', '2waymicropay'); ?></option>
                                <option value="optional" <?php selected($email_mode, 'optional'); ?>><?php esc_html_e('Optional', '2waymicropay'); ?></option>
                                <option value="hidden" <?php selected($email_mode, 'hidden'); ?>><?php esc_html_e('Hidden', '2waymicropay'); ?></option>
                            </select>
                            <p class="description">
                                <?php esc_html_e('Controls whether new-author signup asks for email. Hidden mode auto-generates an internal placeholder if needed.', '2waymicropay'); ?>
                            </p>
                            <p class="description">
                                <?php esc_html_e('Guardrail: first identity may keep a real email; duplicate signup emails are auto-replaced with DoNotDuplicate placeholders to protect existing WordPress account recovery.', '2waymicropay'); ?>
                            </p>
                        </td>
                    </tr>
                    <tr>
                        <th scope="row"><?php esc_html_e('Share Revenue from Comments', '2waymicropay'); ?></th>
                        <td>
                            <label>
                                <input type="checkbox"
                                       name="qixit_share_comment_revenue_with_authors"
                                       value="1"
                                       <?php checked(get_option('qixit_share_comment_revenue_with_authors', false), true); ?> />
                                <?php esc_html_e('Use author-share paid-comment products on author-owned pages/posts', '2waymicropay'); ?>
                            </label>
                        </td>
                    </tr>
                    <tr>
                        <th scope="row">
                            <label for="qixit_comment_author_share_percent"><?php esc_html_e('Comment Revenue Share (%)', '2waymicropay'); ?></label>
                        </th>
                        <td>
                            <input type="number"
                                   id="qixit_comment_author_share_percent"
                                   name="qixit_comment_author_share_percent"
                                   value="<?php echo esc_attr(get_option('qixit_comment_author_share_percent', 0)); ?>"
                                   min="0" max="100" step="1" class="small-text" />
                            <p class="description">
                                <?php esc_html_e('Applied to lazy-created paid-comment products named "Paid Comments Share for [Author Name]".', '2waymicropay'); ?>
                            </p>
                        </td>
                    </tr>
                </table>
                
                <?php submit_button(__('Save Settings', '2waymicropay')); ?>
            </form>
            
            <!-- Data Management -->
            <div class="qixit-data-management" style="margin-top: 30px; padding: 20px; background: #fff; border: 1px solid #ccd0d4;">
                <h2><?php esc_html_e('Data Management', '2waymicropay'); ?></h2>
                <p class="description">
                    <?php esc_html_e('Customer purchase data is stored in your WordPress database and accumulates over time. You can purge old records to save space.', '2waymicropay'); ?>
                </p>
                
                <?php
                // Get purchase statistics
                global $wpdb;
                $table_name = $wpdb->prefix . QIXIT_PAYMENT_DETAILS;
                // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- analytics query against trusted plugin table name.
                $total_records = $wpdb->get_var("SELECT COUNT(*) FROM {$table_name}");
                // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- analytics query against trusted plugin table name.
                $oldest_record = $wpdb->get_var("SELECT MIN(date_purchased) FROM {$table_name}");
                // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- analytics query against trusted plugin table name.
                $newest_record = $wpdb->get_var("SELECT MAX(date_purchased) FROM {$table_name}");
                ?>
                
                <table class="form-table" role="presentation">
                    <tr>
                        <th scope="row"><?php esc_html_e('Purchase Records', '2waymicropay'); ?></th>
                        <td>
                            <strong><?php echo number_format($total_records); ?></strong> <?php esc_html_e('records stored', '2waymicropay'); ?>
                            <?php if ($oldest_record && $newest_record): ?>
                            <br><small style="color: #666;">
                                <?php
                                // translators: 1: oldest purchase date, 2: newest purchase date
                                $date_range_label = __('Date range: %1$s to %2$s', '2waymicropay');
                                echo esc_html(
                                    sprintf(
                                        $date_range_label,
                                        date_i18n(get_option('date_format'), strtotime($oldest_record)),
                                        date_i18n(get_option('date_format'), strtotime($newest_record))
                                    )
                                );
                                ?>
                            </small>
                            <?php endif; ?>
                        </td>
                    </tr>
                    <tr>
                        <th scope="row">
                            <label for="qixit_purge_age"><?php esc_html_e('Purge Old Data', '2waymicropay'); ?></label>
                        </th>
                        <td>
                            <select id="qixit_purge_age" style="width: 200px;">
                                <option value=""><?php esc_html_e('-- Select Age --', '2waymicropay'); ?></option>
                                <option value="30"><?php esc_html_e('Older than 30 days', '2waymicropay'); ?></option>
                                <option value="90"><?php esc_html_e('Older than 90 days', '2waymicropay'); ?></option>
                                <option value="180"><?php esc_html_e('Older than 6 months', '2waymicropay'); ?></option>
                                <option value="365"><?php esc_html_e('Older than 1 year', '2waymicropay'); ?></option>
                                <option value="730"><?php esc_html_e('Older than 2 years', '2waymicropay'); ?></option>
                                <option value="1095"><?php esc_html_e('Older than 3 years', '2waymicropay'); ?></option>
                            </select>
                            <button type="button" id="qixit-purge-data" class="button">
                                <?php esc_html_e('Preview Purge', '2waymicropay'); ?>
                            </button>
                            <p class="description">
                                <?php esc_html_e('Select an age threshold and preview how many records would be deleted before confirming.', '2waymicropay'); ?>
                            </p>
                            <div id="qixit-purge-preview" style="display: none; margin-top: 10px; padding: 10px; background: #fef7e5; border-left: 4px solid #ffb900;"></div>
                            <div id="qixit-purge-result" style="display: none; margin-top: 10px; padding: 10px; background: #e7f5e7; border-left: 4px solid #46b450;"></div>
                        </td>
                    </tr>
                </table>
            </div>
            
            <!-- Quick Actions -->
            <div class="qixit-quick-actions">
                <h2><?php esc_html_e('Quick Actions', '2waymicropay'); ?></h2>
                <p>
                    <a href="<?php echo esc_url(admin_url('admin.php?page=qixit-instructions')); ?>" class="button">
                        <?php esc_html_e('View Instructions', '2waymicropay'); ?>
                    </a>
                </p>
            </div>
        </div>
        
        <?php
        wp_add_inline_style('qixit-admin', '
            .qixit-status-card {
                background: #fff;
                border: 1px solid #ccd0d4;
                border-left: 4px solid #72aee6;
                padding: 20px;
                margin: 20px 0;
                box-shadow: 0 1px 1px rgba(0,0,0,.04);
            }
            .qixit-status-info {
                display: flex;
                align-items: center;
                gap: 10px;
                margin-bottom: 15px;
            }
            .qixit-status-indicator {
                display: inline-block;
                width: 12px;
                height: 12px;
                border-radius: 50%;
            }
            .qixit-status-valid { background: #46b450; }
            .qixit-status-expiring_soon { background: #ffb900; }
            .qixit-status-expired,
            .qixit-status-not_authenticated { background: #dc3232; }
            .qixit-dev-badge {
                display: inline-block;
                background: #f0ad4e;
                color: #fff;
                padding: 2px 8px;
                border-radius: 3px;
                font-size: 11px;
                font-weight: bold;
                margin-left: 10px;
                text-transform: uppercase;
            }
            .qixit-prod-badge {
                display: inline-block;
                background: #5cb85c;
                color: #fff;
                padding: 2px 8px;
                border-radius: 3px;
                font-size: 11px;
                font-weight: bold;
                margin-left: 10px;
                text-transform: uppercase;
            }
            .qixit-quick-actions { margin-top: 30px; }
            #qixit-test-results {
                padding: 10px;
                background: #f0f0f1;
                border-left: 4px solid #72aee6;
            }
            #qixit-test-results.success {
                border-left-color: #46b450;
                background: #ecf7ed;
            }
            #qixit-test-results.error {
                border-left-color: #dc3232;
                background: #fef2f2;
            }
        ');
        ?>
        <?php
    }
    
    /**
     * Render customers page
     * Shows a list of customers who have made purchases ON THIS SITE
     * This is YOUR customer data for marketing purposes
     */
    public function render_customers_page() {
        if (!current_user_can('manage_options')) {
            return;
        }
        
        global $wpdb;
        $table_name = esc_sql($wpdb->prefix . QIXIT_PAYMENT_DETAILS);
        $table_name_display = $wpdb->prefix . QIXIT_PAYMENT_DETAILS;
        $logger = Qixit_Logger::get_instance();
        
        // Handle rebuild tables action
        $rebuild_message = '';
        if (isset($_POST['qixit_rebuild_tables']) && isset($_POST['qixit_rebuild_nonce']) && wp_verify_nonce(sanitize_text_field(wp_unslash($_POST['qixit_rebuild_nonce'])), 'qixit_rebuild_tables')) {
            $rebuild_message = $this->rebuild_database_tables();
            $logger->log("Customers page: Rebuild tables action - " . $rebuild_message);
        }
        
        // DEBUG: Log table name and check if table exists
        $logger->log("Customers page: Using table {$table_name}");
        
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- schema existence check for trusted plugin table.
        $table_exists = $wpdb->get_var("SHOW TABLES LIKE '{$table_name}'");
        $logger->log("Customers page: Table exists = " . ($table_exists ? 'YES' : 'NO'));
        
        if (!$table_exists) {
            $logger->log("Customers page: Table does not exist - attempting to create it now...");
            
            // Create the table using direct SQL (dbDelta can be finicky)
            $charset_collate = $wpdb->get_charset_collate();
            
            // Simplified CREATE TABLE without backticks (MySQL compatibility)
            $sql = "CREATE TABLE IF NOT EXISTS {$table_name} (
                payment_id BIGINT NOT NULL AUTO_INCREMENT,
                product_id BIGINT NULL,
                type VARCHAR(1) NOT NULL DEFAULT 'P',
                qixit_PID VARCHAR(255) DEFAULT NULL,
                qixit_PID_guid CHAR(36) DEFAULT NULL,
                qixit_id VARCHAR(60) DEFAULT NULL,
                qixit_user_id VARCHAR(100) DEFAULT NULL,
                txn_id VARCHAR(100) DEFAULT NULL,
                total DECIMAL(15,4) NOT NULL DEFAULT 0,
                payment_for VARCHAR(50) NOT NULL DEFAULT 'view_post',
                wp_user_id BIGINT DEFAULT NULL,
                percent_to_author DECIMAL(15,2) DEFAULT NULL,
                date_purchased DATETIME NULL DEFAULT NULL,
                PRIMARY KEY (payment_id),
                KEY idx_guid (qixit_PID_guid),
                KEY idx_user (wp_user_id),
                KEY idx_qixit_user (qixit_user_id),
                KEY idx_txn (txn_id)
            ) {$charset_collate}";
            
            $logger->log("Customers page: Executing SQL: " . substr($sql, 0, 200) . "...");
            
            // Use direct query instead of dbDelta
            // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared,WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.DirectDatabaseQuery.SchemaChange -- CREATE TABLE statement is built from trusted constants/table names.
            $result = $wpdb->query($sql);
            
            $logger->log("Customers page: Query result = " . wp_json_encode($result));
            
            if ($wpdb->last_error) {
                $logger->log("Customers page: SQL Error: " . $wpdb->last_error, 'error');
            }
            
            // Check if creation succeeded
            // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- schema existence check for trusted plugin table.
            $table_exists = $wpdb->get_var("SHOW TABLES LIKE '{$table_name}'");
            if ($table_exists) {
                $logger->log("Customers page: SUCCESS - Table created!");
            } else {
                $logger->log("Customers page: FAILED to create table after query.", 'error');
                // Try to get more info about what tables exist
                // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- troubleshooting-only schema listing.
                $all_tables = $wpdb->get_col("SHOW TABLES LIKE 'wpqi_%'");
                $logger->log("Customers page: Existing wpqi_* tables: " . implode(', ', $all_tables));
            }
        }

        // Detect all payment-detail table variants and select the most recently active one.
        // This helps older sites where historical rows may live in a different WP prefix.
        $report_table_name = $table_name_display;
        $payment_table_candidates = array();
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- metadata query for diagnostics.
        $candidate_tables = $wpdb->get_col("SHOW TABLES LIKE '%qixit_payment_details%'");
        if (is_array($candidate_tables) && !empty($candidate_tables)) {
            $chosen_latest = '';
            $chosen_rows = -1;
            foreach ($candidate_tables as $candidate_table) {
                $candidate_table = sanitize_text_field((string) $candidate_table);
                if ($candidate_table === '' || !preg_match('/^[A-Za-z0-9_]+$/', $candidate_table) || strpos($candidate_table, 'qixit_payment_details') === false) {
                    continue;
                }
                $candidate_table_sql = esc_sql($candidate_table);
                // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared,PluginCheck.Security.DirectDB.UnescapedDBParameter -- table name validated from SHOW TABLES and escaped with esc_sql().
                $candidate_row_count = intval($wpdb->get_var("SELECT COUNT(*) FROM {$candidate_table_sql}"));
                // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared,PluginCheck.Security.DirectDB.UnescapedDBParameter -- table name validated from SHOW TABLES and escaped with esc_sql().
                $candidate_latest = (string) $wpdb->get_var("SELECT MAX(date_purchased) FROM {$candidate_table_sql}");
                $payment_table_candidates[] = array(
                    'table' => sanitize_text_field((string) $candidate_table),
                    'rows' => $candidate_row_count,
                    'latest' => $candidate_latest,
                );
                if ($candidate_latest > $chosen_latest || ($candidate_latest === $chosen_latest && $candidate_row_count > $chosen_rows)) {
                    $chosen_latest = $candidate_latest;
                    $chosen_rows = $candidate_row_count;
                    $report_table_name = sanitize_text_field((string) $candidate_table);
                }
            }
        }

        if ($report_table_name !== $table_name_display) {
            $logger->log("Customers page: Reporting from alternate table {$report_table_name} (current prefix table is {$table_name_display})");
        }
        $table_name_display = $report_table_name;
        if ($report_table_name !== '' && preg_match('/^[A-Za-z0-9_]+$/', $report_table_name) && strpos($report_table_name, 'qixit_payment_details') !== false) {
            $table_name = esc_sql($report_table_name);
        } else {
            $table_name = esc_sql($wpdb->prefix . QIXIT_PAYMENT_DETAILS);
            $table_name_display = $wpdb->prefix . QIXIT_PAYMENT_DETAILS;
        }
        
        // DEBUG: Count total rows in table
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared,PluginCheck.Security.DirectDB.UnescapedDBParameter -- diagnostics query against validated/escaped plugin table name.
        $total_rows = $wpdb->get_var("SELECT COUNT(*) FROM {$table_name}");
        $logger->log("Customers page: Total rows in payment_details table = " . ($total_rows !== null ? $total_rows : 'ERROR'));
        $test_row_count = 0;
        $non_test_row_count = 0;
        
        // DEBUG: Show sample of raw data
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared,PluginCheck.Security.DirectDB.UnescapedDBParameter -- diagnostics query against validated/escaped plugin table name.
        $sample_rows = $wpdb->get_results("SELECT payment_id, qixit_user_id, wp_user_id, total, date_purchased FROM {$table_name} ORDER BY date_purchased DESC LIMIT 5");
        if ($sample_rows) {
            foreach ($sample_rows as $row) {
                $logger->log("  Sample row: id={$row->payment_id}, qixit_user='{$row->qixit_user_id}', wp_user={$row->wp_user_id}, total={$row->total}, date={$row->date_purchased}");
            }
        } else {
            $logger->log("  No sample rows found or error: " . $wpdb->last_error);
        }

        // Keep plugin diagnostics rows out of customer analytics.
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared,PluginCheck.Security.DirectDB.UnescapedDBParameter -- diagnostics query against validated/escaped plugin table name.
        $test_row_count = intval($wpdb->get_var("SELECT COUNT(*) FROM {$table_name} WHERE qixit_user_id LIKE 'TEST_%' OR txn_id LIKE 'TEST_TXN_%'"));
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared,PluginCheck.Security.DirectDB.UnescapedDBParameter -- diagnostics query against validated/escaped plugin table name.
        $non_test_row_count = intval($wpdb->get_var("SELECT COUNT(*) FROM {$table_name} WHERE (qixit_user_id IS NULL OR qixit_user_id NOT LIKE 'TEST_%') AND (txn_id IS NULL OR txn_id NOT LIKE 'TEST_TXN_%')"));
        
        // Get customer statistics from the payment details table.
        // Keep all real identities (including guest-like and UUID-like values) and exclude
        // only explicit test rows inserted by plugin diagnostics.
        // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared,PluginCheck.Security.DirectDB.UnescapedDBParameter,WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching
        $customers = $wpdb->get_results("
            SELECT 
                COALESCE(NULLIF(qixit_user_id, ''), NULLIF(qixit_id, '')) AS qixit_user_id,
                wp_user_id,
                COUNT(*) as purchase_count,
                SUM(total) as total_spent,
                MAX(date_purchased) as last_purchase,
                MIN(date_purchased) as first_purchase
            FROM {$table_name}
            WHERE COALESCE(NULLIF(qixit_user_id, ''), NULLIF(qixit_id, '')) IS NOT NULL
                AND COALESCE(NULLIF(qixit_user_id, ''), NULLIF(qixit_id, '')) NOT LIKE 'TEST_%'
                AND (txn_id IS NULL OR txn_id NOT LIKE 'TEST_TXN_%')
            GROUP BY COALESCE(NULLIF(qixit_user_id, ''), NULLIF(qixit_id, '')), wp_user_id
            ORDER BY purchase_count DESC
        ");
        
        $logger->log("Customers page: Qixit customers query returned " . count($customers) . " rows");
        if ($wpdb->last_error) {
            $logger->log("Customers page: Query error: " . $wpdb->last_error, 'error');
        }
        
        // Also get WordPress users who made purchases
        $wp_customers = $wpdb->get_results("
            SELECT 
                wp_user_id,
                COUNT(*) as purchase_count,
                SUM(total) as total_spent,
                MAX(date_purchased) as last_purchase,
                MIN(date_purchased) as first_purchase
            FROM {$table_name}
            WHERE wp_user_id IS NOT NULL AND wp_user_id > 0
                AND (qixit_user_id IS NULL OR qixit_user_id = '')
                AND (txn_id IS NULL OR txn_id NOT LIKE 'TEST_TXN_%')
            GROUP BY wp_user_id
            ORDER BY purchase_count DESC
        ");
        $logger->log("Customers page: WP customers query returned " . count($wp_customers) . " rows");
        
        // Date context for quick "current month" validation from real payment rows.
        $payment_date_context = $wpdb->get_row("
            SELECT
                MIN(date_purchased) AS earliest_purchase,
                MAX(date_purchased) AS latest_purchase
            FROM {$table_name}
            WHERE (qixit_user_id IS NULL OR qixit_user_id NOT LIKE 'TEST_%')
              AND (txn_id IS NULL OR txn_id NOT LIKE 'TEST_TXN_%')
        ");

        // Lightweight diagnostics for rows that cannot be attributed to a user identity bucket.
        $unknown_identity = $wpdb->get_row("
            SELECT
                COUNT(*) AS row_count,
                COALESCE(SUM(total), 0) AS total_amount
            FROM {$table_name}
            WHERE (qixit_user_id IS NULL OR qixit_user_id = '')
              AND (wp_user_id IS NULL OR wp_user_id = 0)
              AND (txn_id IS NULL OR txn_id NOT LIKE 'TEST_TXN_%')
        ");

        // Author/contributor fee totals (onboarding + publish fees) mapped to current WP roles.
        $author_fee_rows = $wpdb->get_results("
            SELECT
                wp_user_id,
                SUM(CASE WHEN payment_for = 'author_registration' THEN total ELSE 0 END) AS onboarding_fees,
                SUM(CASE WHEN payment_for = 'add_post' THEN total ELSE 0 END) AS publish_fees,
                SUM(total) AS total_paid_fees,
                COUNT(*) AS fee_count,
                MIN(date_purchased) AS first_fee_date,
                MAX(date_purchased) AS last_fee_date
            FROM {$table_name}
            WHERE wp_user_id IS NOT NULL
              AND wp_user_id > 0
              AND payment_for IN ('author_registration', 'add_post')
              AND (txn_id IS NULL OR txn_id NOT LIKE 'TEST_TXN_%')
            GROUP BY wp_user_id
            ORDER BY total_paid_fees DESC
        ");

        $author_fee_rows = is_array($author_fee_rows) ? $author_fee_rows : array();
        foreach ($author_fee_rows as $idx => $row) {
            $wp_user = get_userdata(intval($row->wp_user_id));
            if (!$wp_user) {
                continue;
            }
            $user_roles = (array) $wp_user->roles;
            if (!in_array('author', $user_roles, true) && !in_array('contributor', $user_roles, true)) {
                unset($author_fee_rows[$idx]);
                continue;
            }
            $roles = array_map('ucfirst', $user_roles);
            $author_fee_rows[$idx]->role_label = implode(', ', $roles);
            $author_fee_rows[$idx]->display_name = $wp_user->display_name;
            $author_fee_rows[$idx]->user_login = $wp_user->user_login;
        }
        $author_fee_rows = array_values($author_fee_rows);

        // Comment payment reporting via comments product GUID relationships.
        $comment_guid_map = array();
        $products_table = esc_sql($wpdb->prefix . QIXIT_PRODUCTS);
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- products table name derived from trusted prefix constant.
        $comment_product_guids = $wpdb->get_col("
            SELECT DISTINCT comments_qixit_PID_guid
            FROM {$products_table}
            WHERE comments_qixit_PID_guid IS NOT NULL
              AND comments_qixit_PID_guid != ''
        ");
        foreach ((array) $comment_product_guids as $guid) {
            $guid = trim((string) $guid);
            if ($guid !== '') {
                $comment_guid_map[$guid] = true;
            }
        }

        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- reporting query uses trusted wp_options table.
        $comment_guid_options = $wpdb->get_col("
            SELECT option_value
            FROM {$wpdb->options}
            WHERE option_name = 'qixit_comments_product_guid_global'
               OR option_name LIKE 'qixit_comments_product_guid_author_%'
        ");
        foreach ((array) $comment_guid_options as $guid) {
            $guid = trim((string) $guid);
            if ($guid !== '') {
                $comment_guid_map[$guid] = true;
            }
        }

        $comment_report = array();
        $comment_total = 0.0;
        $all_non_test_rows = $wpdb->get_results("
            SELECT qixit_user_id, wp_user_id, qixit_PID_guid, total, payment_for, date_purchased
            FROM {$table_name}
            WHERE (qixit_user_id IS NULL OR qixit_user_id NOT LIKE 'TEST_%')
              AND (txn_id IS NULL OR txn_id NOT LIKE 'TEST_TXN_%')
        ");
        foreach ((array) $all_non_test_rows as $payment_row) {
            $payment_guid = trim((string) $payment_row->qixit_PID_guid);
            $payment_for = trim((string) $payment_row->payment_for);
            $is_comment_payment = ($payment_for === 'comments') || ($payment_guid !== '' && isset($comment_guid_map[$payment_guid]));
            if (!$is_comment_payment) {
                continue;
            }

            $amount = floatval($payment_row->total);
            $comment_total += $amount;
            $qixit_user_id = trim((string) $payment_row->qixit_user_id);
            $wp_user_id = intval($payment_row->wp_user_id);

            if ($qixit_user_id !== '') {
                $bucket_key = 'q:' . $qixit_user_id;
                $label = $qixit_user_id;
                $identity_type = __('Qixit Username', '2waymicropay');
            } elseif ($wp_user_id > 0) {
                $bucket_key = 'w:' . $wp_user_id;
                $wp_user = get_userdata($wp_user_id);
                $label = $wp_user ? $wp_user->display_name : ('User #' . $wp_user_id);
                $identity_type = __('WordPress User', '2waymicropay');
            } else {
                $bucket_key = 'u:unknown';
                $label = __('Unknown identity', '2waymicropay');
                $identity_type = __('Unknown', '2waymicropay');
            }

            if (!isset($comment_report[$bucket_key])) {
                $comment_report[$bucket_key] = (object) array(
                    'identity_label' => $label,
                    'identity_type' => $identity_type,
                    'payment_count' => 0,
                    'total_paid' => 0.0,
                    'first_payment' => $payment_row->date_purchased,
                    'last_payment' => $payment_row->date_purchased,
                );
            }
            $comment_report[$bucket_key]->payment_count++;
            $comment_report[$bucket_key]->total_paid += $amount;
            if (strtotime((string) $payment_row->date_purchased) < strtotime((string) $comment_report[$bucket_key]->first_payment)) {
                $comment_report[$bucket_key]->first_payment = $payment_row->date_purchased;
            }
            if (strtotime((string) $payment_row->date_purchased) > strtotime((string) $comment_report[$bucket_key]->last_payment)) {
                $comment_report[$bucket_key]->last_payment = $payment_row->date_purchased;
            }
        }

        // Monthly rollup to quickly validate "where did May go?" questions.
        $monthly_totals = $wpdb->get_results("
            SELECT
                DATE_FORMAT(date_purchased, '%Y-%m') AS year_month,
                COUNT(*) AS payment_count,
                COALESCE(SUM(total), 0) AS total_amount
            FROM {$table_name}
            WHERE date_purchased IS NOT NULL
              AND (qixit_user_id IS NULL OR qixit_user_id NOT LIKE 'TEST_%')
              AND (txn_id IS NULL OR txn_id NOT LIKE 'TEST_TXN_%')
            GROUP BY DATE_FORMAT(date_purchased, '%Y-%m')
            ORDER BY year_month DESC
            LIMIT 12
        ");
        // phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared,PluginCheck.Security.DirectDB.UnescapedDBParameter,WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching


        // Calculate totals
        $total_customers = count($customers) + count($wp_customers);
        $total_purchases = array_sum(array_column($customers, 'purchase_count')) +
                           array_sum(array_column($wp_customers, 'purchase_count'));
        $total_revenue = array_sum(array_column($customers, 'total_spent')) +
                         array_sum(array_column($wp_customers, 'total_spent'));
        $author_fee_total = array_sum(array_map(static function ($row) {
            return floatval($row->total_paid_fees);
        }, $author_fee_rows));
        
        ?>
        <div class="wrap">
            <h1><?php esc_html_e('Your Customers', '2waymicropay'); ?></h1>
            
            <div class="qixit-customers-intro" style="background: linear-gradient(135deg, #52ac5b 0%, #306817 100%); color: white; padding: 20px 25px; border-radius: 8px; margin-bottom: 25px;">
                <h2 style="color: white; margin-top: 0; margin-bottom: 10px;">📊 Build Your Customer Database</h2>
                <p style="margin: 0; font-size: 14px; opacity: 0.95;">
                    This page shows customers who have purchased content <strong>on your website</strong>. 
                    Every time someone uses a purchase link generated by your site, their username is captured here. 
                    Use this data to build marketing lists and send follow-up offers to your paying customers.
                    <?php echo ' '; ?>
                    <?php esc_html_e('This data can also be found in the Vendors Portal', '2waymicropay'); ?>:
                    <a href="https://products.qixit.com" target="_blank" rel="noopener noreferrer" style="color:#fff; text-decoration:underline; font-weight:600;">products.qixit.com</a>.
                </p>
            </div>
            
            <?php if (!empty($rebuild_message)): ?>
                <div class="notice notice-success is-dismissible" style="margin: 20px 0;">
                    <p><?php echo esc_html($rebuild_message); ?></p>
                </div>
            <?php endif; ?>
            
            <!-- Database Tools Section -->
            <div style="background: #fff; border: 1px solid #c3c4c7; border-radius: 4px; padding: 15px 20px; margin-bottom: 25px;">
                <div style="display: flex; align-items: center; justify-content: space-between; flex-wrap: wrap; gap: 15px;">
                    <div>
                        <strong>🔧 Database Status:</strong>
                        <?php 
                        $products_table = $wpdb->prefix . QIXIT_PRODUCTS;
                        $payment_table = $wpdb->prefix . QIXIT_PAYMENT_DETAILS;
                        $author_table = $wpdb->prefix . QIXIT_AUTHOR_SETTINGS;
                        
                        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- schema checks for trusted plugin tables.
                        $products_exists = $wpdb->get_var("SHOW TABLES LIKE '{$products_table}'") ? '✅' : '❌';
                        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- schema checks for trusted plugin tables.
                        $payment_exists = $wpdb->get_var("SHOW TABLES LIKE '{$payment_table}'") ? '✅' : '❌';
                        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- schema checks for trusted plugin tables.
                        $author_exists = $wpdb->get_var("SHOW TABLES LIKE '{$author_table}'") ? '✅' : '❌';
                        
                        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- summary count for trusted plugin table.
                        $payment_count = $wpdb->get_var("SELECT COUNT(*) FROM {$payment_table}");
                        ?>
                        <span style="margin-left: 10px;">
                            Products <?php echo esc_html($products_exists); ?> | 
                            Payments <?php echo esc_html($payment_exists); ?> (<?php echo esc_html((string) intval($payment_count)); ?> records) | 
                            Authors <?php echo esc_html($author_exists); ?>
                        </span>
                        <br />
                        <small style="color:#666;">
                            <?php
                            /* translators: 1: reporting table name, 2: current prefix table name */
                            $reporting_table_label = __('Reporting table: %1$s | Current prefix table: %2$s', '2waymicropay');
                            echo esc_html(sprintf(
                                $reporting_table_label,
                                $table_name_display,
                                $payment_table
                            ));
                            ?>
                        </small>
                        <?php if (!empty($payment_table_candidates)): ?>
                            <br />
                            <small style="color:#666;">
                                <?php esc_html_e('Detected payment tables:', '2waymicropay'); ?>
                                <?php
                                $candidate_bits = array();
                                foreach ($payment_table_candidates as $candidate) {
                                    $candidate_bits[] = sprintf(
                                        '%s (%d, %s)',
                                        $candidate['table'],
                                        intval($candidate['rows']),
                                        !empty($candidate['latest']) ? $candidate['latest'] : 'n/a'
                                    );
                                }
                                echo esc_html(implode(' | ', $candidate_bits));
                                ?>
                            </small>
                        <?php endif; ?>
                    </div>
                    <form method="post" style="margin: 0; display: flex; gap: 10px;">
                        <?php wp_nonce_field('qixit_rebuild_tables', 'qixit_rebuild_nonce'); ?>
                        <button type="submit" name="qixit_rebuild_tables" class="button button-secondary" 
                                onclick="return confirm('This will create any missing database tables. Existing data will NOT be deleted. Continue?');">
                            🔄 Rebuild Tables
                        </button>
                    </form>
                </div>
            </div>

            <div style="margin-top: -10px; margin-bottom: 20px; color: #555;">
                <strong><?php esc_html_e('Date context:', '2waymicropay'); ?></strong>
                <?php
                $earliest_purchase = $payment_date_context ? $payment_date_context->earliest_purchase : '';
                $latest_purchase = $payment_date_context ? $payment_date_context->latest_purchase : '';
                if (!empty($earliest_purchase) && !empty($latest_purchase)) {
                    echo esc_html(date_i18n('M j, Y', strtotime($earliest_purchase)) . ' - ' . date_i18n('M j, Y', strtotime($latest_purchase)));
                } else {
                    esc_html_e('No non-test payments found yet.', '2waymicropay');
                }
                ?>
                <span style="margin-left: 15px;">
                    <?php
                    /* translators: 1: row count, 2: total dollar amount */
                    $unknown_identity_label = __('Unknown identity rows: %1$d ($%2$s)', '2waymicropay');
                    echo esc_html(sprintf(
                        $unknown_identity_label,
                        intval($unknown_identity ? $unknown_identity->row_count : 0),
                        number_format(floatval($unknown_identity ? $unknown_identity->total_amount : 0), 2)
                    ));
                    ?>
                </span>
                <?php if ($test_row_count > 0): ?>
                    <span style="margin-left: 15px;">
                        <?php
                        /* translators: %d: number of hidden test rows */
                        $hidden_test_rows_label = __('Hidden test rows: %d', '2waymicropay');
                        echo esc_html(sprintf(
                            $hidden_test_rows_label,
                            intval($test_row_count)
                        ));
                        ?>
                    </span>
                <?php endif; ?>
            </div>
            
            <?php if (empty($customers) && empty($wp_customers) && $non_test_row_count <= 0): ?>
                <div class="notice notice-info inline" style="margin: 20px 0;">
                    <p><strong><?php esc_html_e('No customer purchases recorded yet.', '2waymicropay'); ?></strong></p>
                    <p><?php esc_html_e('Once visitors start purchasing your premium content, their usernames will appear here automatically.', '2waymicropay'); ?></p>
                </div>
                
                <div style="background: #fff; border: 1px solid #ccd0d4; border-radius: 4px; padding: 20px; margin-top: 20px;">
                    <h3 style="margin-top: 0;">💡 How to get started</h3>
                    <ol>
                        <li>Create premium content (posts, pages, games, videos)</li>
                        <li>Set a price using the 2WayMicropay settings box</li>
                        <li>Save/Publish — the product syncs to the API automatically</li>
                        <li>When customers pay, they appear in this list!</li>
                    </ol>
                </div>
            <?php else: ?>
                
                <!-- Export Button -->
                <div style="margin-bottom: 20px;">
                    <button type="button" class="button button-primary" id="qixit-export-customers">
                        📥 <?php esc_html_e('Export to CSV', '2waymicropay'); ?>
                    </button>
                    <span style="margin-left: 15px; color: #666; font-size: 13px;">
                        <?php esc_html_e('Download all customer and fee breakdown sections', '2waymicropay'); ?>
                    </span>
                </div>
                
                <h2><?php esc_html_e('2WayMicropay Customers', '2waymicropay'); ?></h2>
                <p style="color: #666; margin-top: -10px; margin-bottom: 15px;">
                    <?php esc_html_e('Users who paid via their 2WayMicropay account on your site', '2waymicropay'); ?>
                </p>
                
                <?php if (!empty($customers)): ?>
                <table class="wp-list-table widefat fixed striped qixit-export-table" id="qixit-customers-table" data-export-title="2WayMicropay Customers">
                    <thead>
                        <tr>
                            <th><?php esc_html_e('Username', '2waymicropay'); ?></th>
                            <th style="width: 100px;"><?php esc_html_e('Purchases', '2waymicropay'); ?></th>
                            <th style="width: 120px;"><?php esc_html_e('Total Spent', '2waymicropay'); ?></th>
                            <th><?php esc_html_e('First Purchase', '2waymicropay'); ?></th>
                            <th><?php esc_html_e('Last Purchase', '2waymicropay'); ?></th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($customers as $customer): 
                            $username = $customer->qixit_user_id;
                        ?>
                        <tr data-username="<?php echo esc_attr($username); ?>" 
                            data-purchases="<?php echo esc_attr($customer->purchase_count); ?>"
                            data-spent="<?php echo esc_attr($customer->total_spent); ?>"
                            data-first="<?php echo esc_attr($customer->first_purchase); ?>"
                            data-last="<?php echo esc_attr($customer->last_purchase); ?>">
                            <td>
                                <strong><?php echo esc_html($username); ?></strong>
                            </td>
                            <td><?php echo intval($customer->purchase_count); ?></td>
                            <td>$<?php echo number_format(floatval($customer->total_spent), 2); ?></td>
                            <td><?php echo esc_html(gmdate('M j, Y', strtotime($customer->first_purchase))); ?></td>
                            <td><?php echo esc_html(gmdate('M j, Y', strtotime($customer->last_purchase))); ?></td>
                        </tr>
                        <?php endforeach; ?>
                    </tbody>
                    <tfoot>
                        <tr>
                            <th><strong><?php echo count($customers); ?> <?php esc_html_e('customers', '2waymicropay'); ?></strong></th>
                            <th><strong><?php echo esc_html((string) array_sum(array_column($customers, 'purchase_count'))); ?></strong></th>
                            <th><strong>$<?php echo number_format(array_sum(array_column($customers, 'total_spent')), 2); ?></strong></th>
                            <th colspan="2"></th>
                        </tr>
                    </tfoot>
                </table>
                <?php else: ?>
                    <p><em><?php esc_html_e('No purchases from 2WayMicropay users yet.', '2waymicropay'); ?></em></p>
                <?php endif; ?>
                
                <?php if (!empty($wp_customers)): ?>
                <h2 style="margin-top: 30px;"><?php esc_html_e('WordPress Users', '2waymicropay'); ?></h2>
                <p style="color: #666; margin-top: -10px; margin-bottom: 15px;">
                    <?php esc_html_e('Logged-in WordPress users who made purchases', '2waymicropay'); ?>
                </p>
                <table class="wp-list-table widefat fixed striped qixit-export-table" data-export-title="WordPress Users">
                    <thead>
                        <tr>
                            <th><?php esc_html_e('WordPress User', '2waymicropay'); ?></th>
                            <th style="width: 100px;"><?php esc_html_e('Purchases', '2waymicropay'); ?></th>
                            <th style="width: 120px;"><?php esc_html_e('Total Spent', '2waymicropay'); ?></th>
                            <th><?php esc_html_e('First Purchase', '2waymicropay'); ?></th>
                            <th><?php esc_html_e('Last Purchase', '2waymicropay'); ?></th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($wp_customers as $customer): 
                            $wp_user = get_userdata($customer->wp_user_id);
                            $display_name = $wp_user ? $wp_user->display_name : 'User #' . $customer->wp_user_id;
                            $user_login = $wp_user ? $wp_user->user_login : '';
                        ?>
                        <tr>
                            <td>
                                <strong><?php echo esc_html($display_name); ?></strong>
                                <?php if ($user_login): ?>
                                    <br><small style="color:#666;"><?php echo esc_html($user_login); ?></small>
                                <?php endif; ?>
                            </td>
                            <td><?php echo intval($customer->purchase_count); ?></td>
                            <td>$<?php echo number_format(floatval($customer->total_spent), 2); ?></td>
                            <td><?php echo esc_html(gmdate('M j, Y', strtotime($customer->first_purchase))); ?></td>
                            <td><?php echo esc_html(gmdate('M j, Y', strtotime($customer->last_purchase))); ?></td>
                        </tr>
                        <?php endforeach; ?>
                    </tbody>
                    <tfoot>
                        <tr>
                            <th><strong><?php echo count($wp_customers); ?> <?php esc_html_e('customers', '2waymicropay'); ?></strong></th>
                            <th><strong><?php echo esc_html((string) array_sum(array_column($wp_customers, 'purchase_count'))); ?></strong></th>
                            <th><strong>$<?php echo number_format(array_sum(array_column($wp_customers, 'total_spent')), 2); ?></strong></th>
                            <th colspan="2"></th>
                        </tr>
                    </tfoot>
                </table>
                <?php endif; ?>

                <h2 style="margin-top: 30px;"><?php esc_html_e('Author / Contributor Fee Totals', '2waymicropay'); ?></h2>
                <p style="color: #666; margin-top: -10px; margin-bottom: 15px;">
                    <?php esc_html_e('Includes onboarding fees (author_registration) and publish fees (add_post), grouped by current WordPress user roles.', '2waymicropay'); ?>
                </p>
                <?php if (!empty($author_fee_rows)): ?>
                <table class="wp-list-table widefat fixed striped qixit-export-table" data-export-title="Author Contributor Fees">
                    <thead>
                        <tr>
                            <th><?php esc_html_e('WordPress User', '2waymicropay'); ?></th>
                            <th><?php esc_html_e('Current Role(s)', '2waymicropay'); ?></th>
                            <th style="width: 130px;"><?php esc_html_e('Onboarding Fees', '2waymicropay'); ?></th>
                            <th style="width: 130px;"><?php esc_html_e('Publish Fees', '2waymicropay'); ?></th>
                            <th style="width: 130px;"><?php esc_html_e('Total Paid Fees', '2waymicropay'); ?></th>
                            <th style="width: 90px;"><?php esc_html_e('Payments', '2waymicropay'); ?></th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($author_fee_rows as $fee_row): ?>
                        <tr>
                            <td>
                                <strong><?php echo esc_html(!empty($fee_row->display_name) ? $fee_row->display_name : ('User #' . intval($fee_row->wp_user_id))); ?></strong>
                                <?php if (!empty($fee_row->user_login)): ?>
                                    <br><small style="color:#666;"><?php echo esc_html($fee_row->user_login); ?></small>
                                <?php endif; ?>
                            </td>
                            <td><?php echo esc_html(!empty($fee_row->role_label) ? $fee_row->role_label : __('Unknown', '2waymicropay')); ?></td>
                            <td>$<?php echo esc_html(number_format(floatval($fee_row->onboarding_fees), 2)); ?></td>
                            <td>$<?php echo esc_html(number_format(floatval($fee_row->publish_fees), 2)); ?></td>
                            <td><strong>$<?php echo esc_html(number_format(floatval($fee_row->total_paid_fees), 2)); ?></strong></td>
                            <td><?php echo esc_html((string) intval($fee_row->fee_count)); ?></td>
                        </tr>
                        <?php endforeach; ?>
                    </tbody>
                    <tfoot>
                        <tr>
                            <th colspan="4"><?php esc_html_e('Total Author/Contributor Fees', '2waymicropay'); ?></th>
                            <th><strong>$<?php echo esc_html(number_format($author_fee_total, 2)); ?></strong></th>
                            <th></th>
                        </tr>
                    </tfoot>
                </table>
                <?php else: ?>
                    <p><em><?php esc_html_e('No author/contributor fee payments found yet.', '2waymicropay'); ?></em></p>
                <?php endif; ?>

                <h2 style="margin-top: 30px;"><?php esc_html_e('Paid Comments Activity', '2waymicropay'); ?></h2>
                <p style="color: #666; margin-top: -10px; margin-bottom: 15px;">
                    <?php esc_html_e('Classified from comments product GUID relationships and payment_for=comments.', '2waymicropay'); ?>
                </p>
                <?php if (!empty($comment_report)): ?>
                <table class="wp-list-table widefat fixed striped qixit-export-table" data-export-title="Paid Comment Activity">
                    <thead>
                        <tr>
                            <th><?php esc_html_e('Identity', '2waymicropay'); ?></th>
                            <th><?php esc_html_e('Identity Type', '2waymicropay'); ?></th>
                            <th style="width: 100px;"><?php esc_html_e('Payments', '2waymicropay'); ?></th>
                            <th style="width: 130px;"><?php esc_html_e('Total Paid', '2waymicropay'); ?></th>
                            <th><?php esc_html_e('First Payment', '2waymicropay'); ?></th>
                            <th><?php esc_html_e('Last Payment', '2waymicropay'); ?></th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($comment_report as $comment_row): ?>
                        <tr>
                            <td><strong><?php echo esc_html($comment_row->identity_label); ?></strong></td>
                            <td><?php echo esc_html($comment_row->identity_type); ?></td>
                            <td><?php echo esc_html((string) intval($comment_row->payment_count)); ?></td>
                            <td>$<?php echo esc_html(number_format(floatval($comment_row->total_paid), 2)); ?></td>
                            <td><?php echo esc_html(gmdate('M j, Y', strtotime($comment_row->first_payment))); ?></td>
                            <td><?php echo esc_html(gmdate('M j, Y', strtotime($comment_row->last_payment))); ?></td>
                        </tr>
                        <?php endforeach; ?>
                    </tbody>
                    <tfoot>
                        <tr>
                            <th colspan="3"><?php esc_html_e('Total Paid Comments Revenue', '2waymicropay'); ?></th>
                            <th><strong>$<?php echo esc_html(number_format($comment_total, 2)); ?></strong></th>
                            <th colspan="2"></th>
                        </tr>
                    </tfoot>
                </table>
                <?php else: ?>
                    <p><em><?php esc_html_e('No paid-comment transactions found yet.', '2waymicropay'); ?></em></p>
                <?php endif; ?>

                <h2 style="margin-top: 30px;"><?php esc_html_e('Monthly Payment Totals', '2waymicropay'); ?></h2>
                <p style="color: #666; margin-top: -10px; margin-bottom: 15px;">
                    <?php esc_html_e('Latest 12 months from qixit_payment_details (non-test rows).', '2waymicropay'); ?>
                </p>
                <?php if (!empty($monthly_totals)): ?>
                <table class="wp-list-table widefat fixed striped qixit-export-table" data-export-title="Monthly Payment Totals">
                    <thead>
                        <tr>
                            <th><?php esc_html_e('Month', '2waymicropay'); ?></th>
                            <th style="width: 120px;"><?php esc_html_e('Payments', '2waymicropay'); ?></th>
                            <th style="width: 140px;"><?php esc_html_e('Total Amount', '2waymicropay'); ?></th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($monthly_totals as $month_row): ?>
                        <tr>
                            <td><strong><?php echo esc_html($month_row->year_month); ?></strong></td>
                            <td><?php echo esc_html((string) intval($month_row->payment_count)); ?></td>
                            <td>$<?php echo esc_html(number_format(floatval($month_row->total_amount), 2)); ?></td>
                        </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
                <?php else: ?>
                    <p><em><?php esc_html_e('No monthly totals available yet.', '2waymicropay'); ?></em></p>
                <?php endif; ?>

            <?php endif; ?>
            
            <!-- Summary Box -->
            <div class="qixit-customers-summary" style="margin-top: 30px; padding: 20px; background: #f0f0f1; border-left: 4px solid #2271b1; border-radius: 0 4px 4px 0;">
                <h3 style="margin-top: 0;"><?php esc_html_e('Summary', '2waymicropay'); ?></h3>
                <div style="display: flex; gap: 40px; flex-wrap: wrap;">
                    <div>
                        <div style="font-size: 28px; font-weight: bold; color: #2271b1;"><?php echo esc_html((string) $total_customers); ?></div>
                        <div style="color: #666;"><?php esc_html_e('Unique Customers', '2waymicropay'); ?></div>
                    </div>
                    <div>
                        <div style="font-size: 28px; font-weight: bold; color: #2271b1;"><?php echo esc_html((string) $total_purchases); ?></div>
                        <div style="color: #666;"><?php esc_html_e('Total Purchases', '2waymicropay'); ?></div>
                    </div>
                    <div>
                        <div style="font-size: 28px; font-weight: bold; color: #00a32a;">$<?php echo number_format($total_revenue, 2); ?></div>
                        <div style="color: #666;"><?php esc_html_e('Total Revenue', '2waymicropay'); ?></div>
                    </div>
                    <div>
                        <div style="font-size: 28px; font-weight: bold; color: #8a4baf;">$<?php echo number_format($author_fee_total, 2); ?></div>
                        <div style="color: #666;"><?php esc_html_e('Author/Contributor Fees', '2waymicropay'); ?></div>
                    </div>
                    <div>
                        <div style="font-size: 28px; font-weight: bold; color: #b35f00;">$<?php echo number_format($comment_total, 2); ?></div>
                        <div style="color: #666;"><?php esc_html_e('Paid Comments Revenue', '2waymicropay'); ?></div>
                    </div>
                </div>
            </div>
            
            <!-- Marketing Tips Box -->
            <div style="margin-top: 25px; padding: 20px; background: #fff; border: 1px solid #c3c4c7; border-radius: 4px;">
                <h3 style="margin-top: 0;">📬 Marketing Your Customer List</h3>
                <p>These are <strong>your customers</strong> - people who have already paid for content on your site. They're valuable because:</p>
                <ul style="margin-left: 20px;">
                    <li>They've already shown willingness to pay for your content</li>
                    <li>They have 2WayMicropay accounts with balance ready to spend</li>
                    <li>They're familiar with your brand and offerings</li>
                </ul>
                <p style="margin-bottom: 0;">
                    <strong>Coming soon:</strong> Export this list and upload it to the Marketing Portal to send targeted offers directly to your paying customers!
                </p>
            </div>
        </div>
        
        <?php
        wp_add_inline_script('qixit-admin', <<<'JS'
jQuery(document).ready(function($) {
    function getCellValue($row, idx) {
        return $row.children('td').eq(idx).text().trim();
    }

    function compareValues(a, b, asc) {
        var numA = parseFloat(String(a).replace(/[^0-9.\-]/g, ''));
        var numB = parseFloat(String(b).replace(/[^0-9.\-]/g, ''));
        var bothNumeric = !isNaN(numA) && !isNaN(numB);
        if (bothNumeric) {
            return asc ? (numA - numB) : (numB - numA);
        }
        return asc
            ? String(a).localeCompare(String(b), undefined, { numeric: true, sensitivity: 'base' })
            : String(b).localeCompare(String(a), undefined, { numeric: true, sensitivity: 'base' });
    }

    // Click-to-sort for all report tables by any column header.
    $('.qixit-export-table thead th').css('cursor', 'pointer').on('click', function() {
        var $th = $(this);
        var $table = $th.closest('table');
        var index = $th.index();
        var asc = !$th.data('asc');
        $th.data('asc', asc);

        var $tbody = $table.find('tbody');
        var rows = $tbody.find('tr').get();

        rows.sort(function(rowA, rowB) {
            var valueA = getCellValue($(rowA), index);
            var valueB = getCellValue($(rowB), index);
            return compareValues(valueA, valueB, asc);
        });

        $.each(rows, function(_, row) {
            $tbody.append(row);
        });
    });

    // Export to CSV functionality
    $('#qixit-export-customers').on('click', function() {
        var rows = [];

        $('.qixit-export-table').each(function() {
            var $table = $(this);
            var sectionTitle = $table.data('export-title') || 'Report Section';

            rows.push([sectionTitle]);
            rows.push([]);

            var headers = [];
            $table.find('thead th').each(function() {
                headers.push($(this).text().trim());
            });
            if (headers.length > 0) {
                rows.push(headers);
            }

            $table.find('tbody tr').each(function() {
                var row = [];
                $(this).find('td').each(function() {
                    row.push($(this).text().replace(/\s+/g, ' ').trim());
                });
                if (row.length > 0) {
                    rows.push(row);
                }
            });

            rows.push([]);
        });
        
        // Create CSV content
        var csvContent = rows.map(function(row) {
            return row.map(function(cell) {
                // Escape quotes and wrap in quotes if contains comma
                var str = String(cell);
                if (str.indexOf(',') > -1 || str.indexOf('"') > -1) {
                    return '"' + str.replace(/"/g, '""') + '"';
                }
                return str;
            }).join(',');
        }).join('\n');
        
        // Download
        var blob = new Blob([csvContent], { type: 'text/csv;charset=utf-8;' });
        var link = document.createElement('a');
        var url = URL.createObjectURL(blob);
        link.setAttribute('href', url);
        link.setAttribute('download', 'customers-' + new Date().toISOString().split('T')[0] + '.csv');
        link.style.visibility = 'hidden';
        document.body.appendChild(link);
        link.click();
        document.body.removeChild(link);
    });
});
JS
        );
        ?>
        <?php
    }
    
    /**
     * Rebuild database tables
     * Creates all required tables if they don't exist
     * 
     * @return string Result message
     */
    private function rebuild_database_tables() {
        global $wpdb;
        $logger = Qixit_Logger::get_instance();
        $charset_collate = $wpdb->get_charset_collate();
        $results = array();
        
        // Table 1: Products
        $table_name = $wpdb->prefix . QIXIT_PRODUCTS;
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- schema existence check for trusted plugin table.
        if (!$wpdb->get_var("SHOW TABLES LIKE '{$table_name}'")) {
            // phpcs:ignore WordPress.DB.DirectDatabaseQuery.SchemaChange -- CREATE TABLE template for plugin-owned schema.
            $sql = "CREATE TABLE IF NOT EXISTS {$table_name} (
                product_id BIGINT NOT NULL AUTO_INCREMENT,
                post_id BIGINT NULL,
                post_qixit_PID VARCHAR(255) DEFAULT NULL,
                post_qixit_PID_guid CHAR(36) DEFAULT NULL,
                comments_qixit_PID_guid CHAR(36) DEFAULT NULL,
                premium_post_type VARCHAR(50) DEFAULT 'premium',
                premium_post_cost DECIMAL(15,4) NOT NULL DEFAULT 0,
                comments_cost DECIMAL(15,4) DEFAULT 0.05,
                access_hours INT DEFAULT -1,
                active TINYINT(1) DEFAULT 1,
                date_created DATETIME NULL DEFAULT NULL,
                date_updated DATETIME NULL DEFAULT NULL,
                PRIMARY KEY (product_id),
                UNIQUE KEY post_qixit_PID (post_qixit_PID),
                KEY idx_guid (post_qixit_PID_guid),
                KEY idx_post (post_id)
            ) {$charset_collate}";
            
            // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared,WordPress.DB.DirectDatabaseQuery.SchemaChange,WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- CREATE TABLE statement is built from trusted constants/table names.
            $result = $wpdb->query($sql);
            // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- schema existence check for trusted plugin table.
            if ($wpdb->get_var("SHOW TABLES LIKE '{$table_name}'")) {
                $results[] = "Products table created ✅";
                $logger->log("Rebuild: Products table created successfully");
            } else {
                $results[] = "Products table FAILED: " . $wpdb->last_error;
                $logger->log("Rebuild: Products table failed - " . $wpdb->last_error, 'error');
            }
        } else {
            $results[] = "Products table already exists ✅";
        }
        
        // Table 2: Payment Details
        $table_name = $wpdb->prefix . QIXIT_PAYMENT_DETAILS;
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- schema existence check for trusted plugin table.
        if (!$wpdb->get_var("SHOW TABLES LIKE '{$table_name}'")) {
            // phpcs:ignore WordPress.DB.DirectDatabaseQuery.SchemaChange -- CREATE TABLE template for plugin-owned schema.
            $sql = "CREATE TABLE IF NOT EXISTS {$table_name} (
                payment_id BIGINT NOT NULL AUTO_INCREMENT,
                product_id BIGINT NULL,
                type VARCHAR(1) NOT NULL DEFAULT 'P',
                qixit_PID VARCHAR(255) DEFAULT NULL,
                qixit_PID_guid CHAR(36) DEFAULT NULL,
                qixit_id VARCHAR(60) DEFAULT NULL,
                qixit_user_id VARCHAR(100) DEFAULT NULL,
                txn_id VARCHAR(100) DEFAULT NULL,
                total DECIMAL(15,4) NOT NULL DEFAULT 0,
                payment_for VARCHAR(50) NOT NULL DEFAULT 'view_post',
                wp_user_id BIGINT DEFAULT NULL,
                percent_to_author DECIMAL(15,2) DEFAULT NULL,
                date_purchased DATETIME NULL DEFAULT NULL,
                PRIMARY KEY (payment_id),
                KEY idx_guid (qixit_PID_guid),
                KEY idx_user (wp_user_id),
                KEY idx_qixit_user (qixit_user_id),
                KEY idx_txn (txn_id)
            ) {$charset_collate}";
            
            // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared,WordPress.DB.DirectDatabaseQuery.SchemaChange,WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- CREATE TABLE statement is built from trusted constants/table names.
            $result = $wpdb->query($sql);
            // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- schema existence check for trusted plugin table.
            if ($wpdb->get_var("SHOW TABLES LIKE '{$table_name}'")) {
                $results[] = "Payment Details table created ✅";
                $logger->log("Rebuild: Payment Details table created successfully");
            } else {
                $results[] = "Payment Details table FAILED: " . $wpdb->last_error;
                $logger->log("Rebuild: Payment Details table failed - " . $wpdb->last_error, 'error');
            }
        } else {
            $results[] = "Payment Details table already exists ✅";
        }
        
        // Table 3: Author Settings
        $table_name = $wpdb->prefix . QIXIT_AUTHOR_SETTINGS;
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- schema existence check for trusted plugin table.
        if (!$wpdb->get_var("SHOW TABLES LIKE '{$table_name}'")) {
            // phpcs:ignore WordPress.DB.DirectDatabaseQuery.SchemaChange -- CREATE TABLE template for plugin-owned schema.
            $sql = "CREATE TABLE IF NOT EXISTS {$table_name} (
                id BIGINT NOT NULL AUTO_INCREMENT,
                wp_user_id INT NOT NULL,
                qixit_id VARCHAR(255) DEFAULT NULL,
                entitlement_status VARCHAR(30) DEFAULT 'inactive',
                entitlement_purchased_at DATETIME DEFAULT NULL,
                entitlement_expires_at DATETIME DEFAULT NULL,
                date_created DATETIME DEFAULT NULL,
                date_updated DATETIME DEFAULT NULL,
                PRIMARY KEY (id),
                KEY idx_user (wp_user_id)
            ) {$charset_collate}";
            
            // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared,WordPress.DB.DirectDatabaseQuery.SchemaChange,WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- CREATE TABLE statement is built from trusted constants/table names.
            $result = $wpdb->query($sql);
            // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- schema existence check for trusted plugin table.
            if ($wpdb->get_var("SHOW TABLES LIKE '{$table_name}'")) {
                $results[] = "Author Settings table created ✅";
                $logger->log("Rebuild: Author Settings table created successfully");
            } else {
                $results[] = "Author Settings table FAILED: " . $wpdb->last_error;
                $logger->log("Rebuild: Author Settings table failed - " . $wpdb->last_error, 'error');
            }
        } else {
            $results[] = "Author Settings table already exists ✅";
        }
        
        return implode(' | ', $results);
    }
    
    /**
     * Resync all products to the Products Portal API
     * Updates reportUrl for all products and paid comments
     * 
     * @return array ['success' => bool, 'message' => string]
     */
    private function resync_all_products() {
        global $wpdb;
        $logger = Qixit_Logger::get_instance();
        $product_manager = Qixit_Product::get_instance();
        
        $logger->log("Resync All: Starting bulk resync of all products");

        // Ensure Site API Key validation is healthy before running a long resync.
        // This avoids false "success" messages when every API update would fail.
        $token_status = $this->auth->get_token_status();
        if (!is_array($token_status) || ($token_status['status'] ?? '') !== 'valid') {
            $status_message = is_array($token_status) && !empty($token_status['message'])
                ? $token_status['message']
                : __('Site API Key validation failed. Please verify your Site API Key first.', '2waymicropay');
            $logger->log("Resync All: Aborted due to failed key validation: " . $status_message, 'error');
            return array(
                'success' => false,
                'message' => sprintf(
                    /* translators: %s: validation failure message */
                    __('Resync aborted: %s', '2waymicropay'),
                    $status_message
                )
            );
        }
        
        $table_name = $wpdb->prefix . QIXIT_PRODUCTS;
        
        // First, log what's in the products table for debugging
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- debug count against trusted plugin table.
        $total_count = $wpdb->get_var("SELECT COUNT(*) FROM {$table_name}");
        $logger->log("Resync All: Total products in table: {$total_count}");
        
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- debug sample query against trusted plugin table.
        $all_products = $wpdb->get_results("SELECT product_id, post_id, qixit_post_type, enable_paid_comments, active, post_qixit_PID_guid, comments_qixit_PID_guid FROM {$table_name} LIMIT 20");
        if ($all_products) {
            foreach ($all_products as $p) {
                $has_guid = !empty($p->post_qixit_PID_guid) ? 'Y' : 'N';
                $has_comment_guid = !empty($p->comments_qixit_PID_guid) ? 'Y' : 'N';
                $logger->log("  Product ID={$p->product_id}, post_id={$p->post_id}, type='{$p->qixit_post_type}', paid_comments={$p->enable_paid_comments}, active={$p->active}, has_guid={$has_guid}, has_comment_guid={$has_comment_guid}");
            }
        } else {
            $logger->log("  No products found in table at all!");
        }
        
        // Get all products from local database that need syncing
        // Include products that have: premium content, paid comments, or existing API guid
        $reg_type = QIXIT_REG;
        // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching -- resync selection query uses trusted plugin table name.
        $products = $wpdb->get_results($wpdb->prepare(
            "SELECT * FROM {$table_name}
            WHERE post_id IS NOT NULL
              AND post_id > 0
              AND (
                  (qixit_post_type IS NOT NULL AND qixit_post_type != '' AND qixit_post_type != %s)
                  OR enable_paid_comments = 1
                  OR post_qixit_PID_guid IS NOT NULL
                  OR comments_qixit_PID_guid IS NOT NULL
              )",
            $reg_type
        ));
        // phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared
        
        $logger->log("Resync All: Query for syncable products returned " . ($products ? count($products) : 0) . " rows");
        if ($wpdb->last_error) {
            $logger->log("Resync All: Query error: " . $wpdb->last_error, 'error');
        }
        
        if (!$products || count($products) === 0) {
            $logger->log("Resync All: No products matched the sync criteria");
            return array('success' => true, 'message' => __('No products to sync. Check that you have premium content or paid comments enabled on some posts.', '2waymicropay'));
        }
        
        $total = count($products);
        $synced = 0;
        $errors = 0;
        $comments_synced = 0;
        
        $logger->log("Resync All: Found {$total} products to sync");
        
        foreach ($products as $product) {
            if (empty($product->post_id)) {
                continue;
            }
            
            // Check if post still exists
            $post = get_post($product->post_id);
            if (!$post) {
                $logger->log("Resync All: Post {$product->post_id} no longer exists, skipping");
                continue;
            }
            
            // Check if this is a premium product (not just paid comments)
            $is_premium = !empty($product->qixit_post_type) && $product->qixit_post_type !== QIXIT_REG;
            
            if ($is_premium) {
                // Sync the main product
                $logger->log("Resync All: Syncing product for post {$product->post_id}");
                $result = $product_manager->sync_product_to_api($product->post_id);
                
                if ($result && isset($result['success']) && $result['success']) {
                    $synced++;
                    $logger->log("Resync All: Successfully synced product for post {$product->post_id}");
                } else {
                    $errors++;
                    $logger->log("Resync All: Failed to sync product for post {$product->post_id}: " . json_encode($result), 'error');
                }
            }
            
            // Check for paid comments
            if (!empty($product->enable_paid_comments)) {
                $logger->log("Resync All: Syncing comments product for post {$product->post_id}");
                $result = $product_manager->sync_comments_product_to_api($product->post_id, $product);
                
                if ($result && isset($result['success']) && $result['success']) {
                    $comments_synced++;
                    $logger->log("Resync All: Successfully synced comments product for post {$product->post_id}");
                } else {
                    $errors++;
                    $logger->log("Resync All: Failed to sync comments product for post {$product->post_id}: " . json_encode($result), 'error');
                }
            }
        }
        
        // Re-provision author-rights / publication / revision products so Categories update too.
        if (class_exists('Qixit_Author_Commerce')) {
            $logger->log('Resync All: Ensuring author commerce products (incl. Price Optimization Categories)');
            try {
                Qixit_Author_Commerce::get_instance()->ensure_required_products(true);
            } catch (Exception $e) {
                $errors++;
                $logger->log('Resync All: Author commerce ensure failed: ' . $e->getMessage(), 'error');
            }
        }

        // translators: 1: synced products count, 2: synced comments count, 3: error count
        $resync_message_template = __('Resync complete! Products: %1$d synced. Paid Comments: %2$d synced. Errors: %3$d. Author-rights products refreshed when configured.', '2waymicropay');
        $message = sprintf(
            $resync_message_template,
            $synced, $comments_synced, $errors
        );
        
        $logger->log("Resync All: Complete - {$message}");
        
        return array(
            'success' => ($errors === 0),
            'message' => $message
        );
    }
    
    /**
     * Insert a test record into the payment details table
     * 
     * @return string Result message
     */
    private function insert_test_record() {
        global $wpdb;
        $logger = Qixit_Logger::get_instance();
        $table_name = $wpdb->prefix . QIXIT_PAYMENT_DETAILS;
        
        $test_data = array(
            'product_id' => 0,
            'type' => 'P',
            'qixit_PID' => 'TEST_' . time(),
            'qixit_PID_guid' => null,
            'qixit_id' => '',
            'qixit_user_id' => 'TEST_USER_' . gmdate('His'),
            'txn_id' => 'TEST_TXN_' . time(),
            'total' => 0.01,
            'payment_for' => 'view_post',
            'wp_user_id' => get_current_user_id(),
            'percent_to_author' => 0,
            'date_purchased' => current_time('mysql')
        );
        
        $logger->log("Test insert: Attempting to insert test record into {$table_name}");
        $logger->log("Test insert: Data = " . json_encode($test_data));
        
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery -- direct write to plugin-owned test table.
        $result = $wpdb->insert($table_name, $test_data);
        
        if ($result === false) {
            $error_msg = "FAILED to insert test record: " . $wpdb->last_error;
            $logger->log("Test insert: " . $error_msg, 'error');
            return $error_msg;
        }
        
        $insert_id = $wpdb->insert_id;
        $success_msg = "SUCCESS! Test record inserted with ID: {$insert_id} into {$table_name}. Note: TEST rows are intentionally hidden from customer analytics and only appear in the table diagnostics counts.";
        $logger->log("Test insert: " . $success_msg);
        
        return $success_msg;
    }
    
    /**
     * Render logs page
     */
    public function render_logs_page() {
        if (!current_user_can('manage_options')) {
            return;
        }
        
        $logs = $this->logger->get_recent_logs(100);
        
        ?>
        <div class="wrap">
            <h1><?php esc_html_e('Debug Logs', '2waymicropay'); ?></h1>
            
            <div class="qixit-logs-info">
                <?php if (get_option('qixit_enable_logging')): ?>
                    <p><?php esc_html_e('Showing the last 100 log entries:', '2waymicropay'); ?></p>
                    
                    <p>
                        <button type="button" class="button button-secondary" id="qixit-refresh-logs">
                            <?php esc_html_e('Refresh Logs', '2waymicropay'); ?>
                        </button>
                        <button type="button" class="button button-secondary" id="qixit-clear-logs">
                            <?php esc_html_e('Clear Logs', '2waymicropay'); ?>
                        </button>
                    </p>
                    
                    <div class="qixit-log-viewer">
                        <pre><?php 
                        if (!empty($logs)) {
                            foreach ($logs as $log) {
                                echo esc_html($log);
                            }
                        } else {
                            echo esc_html__('No logs available.', '2waymicropay');
                        }
                        ?></pre>
                    </div>
                <?php else: ?>
                    <div class="notice notice-warning inline">
                        <p>
                            <?php esc_html_e('Debug logging is currently disabled.', '2waymicropay'); ?>
                            <a href="<?php echo esc_url(admin_url('admin.php?page=qixit-settings')); ?>">
                                <?php esc_html_e('Enable it in Settings', '2waymicropay'); ?>
                            </a>
                        </p>
                    </div>
                <?php endif; ?>
            </div>
        </div>
        
        <?php
        wp_add_inline_style('qixit-admin', '
            .qixit-log-viewer {
                background: #1e1e1e;
                color: #d4d4d4;
                padding: 20px;
                border-radius: 3px;
                margin-top: 20px;
                max-height: 600px;
                overflow-y: auto;
                font-family: "Courier New", monospace;
                font-size: 12px;
                line-height: 1.5;
            }
            .qixit-log-viewer pre {
                margin: 0;
                white-space: pre-wrap;
                word-wrap: break-word;
            }
        ');
        ?>
        <?php
    }
    
    /**
     * Render instructions page
     */
    public function render_instructions_page() {
        if (!current_user_can('manage_options')) {
            return;
        }

        // Bundled asset for documentation examples only (no remote image/embed dependencies).
        $qixit_doc_example_image = esc_url(trailingslashit(QIXIT_PLUGIN_URL) . 'images/overlay-logo.svg');
        
        ?>
        <div class="wrap qixit-instructions">
            <h1><?php esc_html_e('2WayMicropay - Instructions', '2waymicropay'); ?></h1>
            
            <div class="qixit-instructions-content">
                <div class="qixit-section qixit-toc-section">
                    <h2><?php esc_html_e('Table of Contents', '2waymicropay'); ?></h2>
                    <p class="description"><?php esc_html_e('Jump to any section below.', '2waymicropay'); ?></p>
                    <ul id="qixit-instructions-toc"></ul>
                </div>
                
                <div class="qixit-section">
                    <h2>🚀 Getting Started</h2>
                    <ol>
                        <li><strong>Configure API Connection</strong> - Go to <a href="<?php echo esc_url(admin_url('admin.php?page=qixit-settings')); ?>">Settings</a> and enter your vendor credentials and Site API Key.</li>
                        <li><strong>Connect</strong> - Save a valid Site API Key to connect this site to the Products API.</li>
                        <li><strong>Set Up Premium Content</strong> - Edit any post or page and use the 2WayMicropay Settings box.</li>
                    </ol>
                    
                    <h3>🌐 Products Portal Direct Access</h3>
                    <p>
                        You can also manage your products directly through the <strong>Products Portal</strong>:
                        <a href="https://products.qixit.com" target="_blank">https://products.qixit.com</a>
                    </p>
                    <p>
                        Log in with the same vendor credentials you use here. The Products Portal allows you to:
                    </p>
                    <ul>
                        <li>View all your products and their sales history</li>
                        <li>Create and manage products manually</li>
                        <li>View transaction reports and payouts</li>
                        <li>Manage your account settings</li>
                        <li><strong>Price Optimization</strong> — priced-render metrics, demand curves, and A/B price tests at <a href="https://products.qixit.com/pricing" target="_blank" rel="noopener noreferrer">products.qixit.com/pricing</a> (not shown in this plugin)</li>
                    </ul>
                    <p>
                        <strong>Commercial Code</strong> (postage) is set in plugin Settings / the post metabox.
                        <strong>Price Optimization Category</strong> follows each post or page’s WordPress categories
                        (or defaults to <em>WP Post</em> / <em>WP Page</em> when none). Paid Comments and Author Rights
                        use those named Categories. Use <strong>Resync All</strong> to push Categories to existing products.
                    </p>
                </div>
                
                <div class="qixit-section">
                    <h2>💰 Setting Prices on Posts/Pages</h2>
                    <h3>Method 1: Individual Post/Page Editor</h3>
                    <ol>
                        <li>Edit any post or page</li>
                        <li>Find the <strong>"2WayMicropay Settings"</strong> box in the sidebar</li>
                        <li>Select <strong>"Premium - Pay Once, View Forever"</strong> or <strong>"Premium - Pay Per View"</strong></li>
                        <li>Set your price (min $0.01, max $100.00)</li>
                        <li>Optionally check <strong>"Use Read More as paywall"</strong> to show free preview up to the &lt;!--more--&gt; tag</li>
                        <li>Publish/Update your post — the product is automatically synced to the API</li>
                    </ol>
                    
                    <h3>Method 2: Bulk Actions (Multiple Posts/Pages)</h3>
                    <ol>
                        <li>Go to <strong>Posts → All Posts</strong> or <strong>Pages → All Pages</strong></li>
                        <li>Check the boxes next to the posts/pages you want to monetize</li>
                        <li>From the <strong>Bulk Actions</strong> dropdown, select:
                            <ul>
                                <li><strong>2WayMicropay: Set Premium (Forever Access)</strong> - One-time purchase</li>
                                <li><strong>2WayMicropay: Set Premium (Pay Per View)</strong> - Pay each time</li>
                                <li><strong>2WayMicropay: Set as Free</strong> - Remove paywall</li>
                                <li><strong>2WayMicropay: Sync All to API</strong> - Register all selected products</li>
                            </ul>
                        </li>
                        <li>Click <strong>Apply</strong></li>
                    </ol>
                </div>
                
                <div class="qixit-section">
                    <h2>📝 Using the "Read More" Paywall</h2>
                    <p>The Read More paywall lets you show a <strong>free preview</strong> of your content:</p>
                    <ol>
                        <li>In your post editor, add the <strong>&lt;!--more--&gt;</strong> tag (click "Read More" button in editor)</li>
                        <li>Content <strong>before</strong> the tag = FREE preview visible to all</li>
                        <li>Content <strong>after</strong> the tag = PREMIUM content behind paywall</li>
                        <li>Enable <strong>"Use Read More as paywall"</strong> in 2WayMicropay settings</li>
                    </ol>
                    <div class="qixit-example">
                        <strong>Example Post Content:</strong>
                        <pre>This is the free teaser that everyone can read.
It hooks the reader and makes them want more!

&lt;!--more--&gt;

This is the premium content that readers
must pay to access. Include your best 
insights and exclusive content here!</pre>
                    </div>
                </div>
                
                <div class="qixit-section">
                    <h2>🔗 Getting Payment Links</h2>
                    <p>You can get a direct payment link for any premium content:</p>
                    <ol>
                        <li>Edit the post/page</li>
                        <li>Products sync automatically when you save. Look for the green "✅ Synced to API" badge.</li>
                        <li>Click <strong>"🔗 Get Payment Link"</strong></li>
                        <li>Copy the link and share it anywhere (email, social media, etc.)</li>
                    </ol>
                </div>
                
                <div class="qixit-section">
                    <h2>📋 Available Shortcodes</h2>
                    <table class="widefat">
                        <thead>
                            <tr>
                                <th>Shortcode</th>
                                <th>Description</th>
                                <th>Example</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr>
                                <td><code>[qixit_buy_button]</code></td>
                                <td>Display a buy button with micro-frame popup</td>
                                <td><code>[qixit_buy_button text="Buy Now" class="my-button"]</code></td>
                            </tr>
                            <tr>
                                <td><code>[qixit_readmore]</code></td>
                                <td>Inline "Read more..." link with tooltip and micro-frame</td>
                                <td><code>[qixit_readmore text="Continue reading..."]</code></td>
                            </tr>
                            <tr>
                                <td><code>[qixit_paywall]</code></td>
                                <td>Display the full paywall box for the current post</td>
                                <td><code>[qixit_paywall]</code></td>
                            </tr>
                            <tr>
                                <td><code>[qixit_price]</code></td>
                                <td>Display the price of the current post</td>
                                <td><code>[qixit_price]</code> → "$0.99"</td>
                            </tr>
                            <tr>
                                <td><code>[qixit_status]</code></td>
                                <td>Show purchase status for current user</td>
                                <td><code>[qixit_status]</code> → "✓ Purchased" or "🔒 $0.99"</td>
                            </tr>
                            <tr>
                                <td><code>[qixit_premium_content]</code></td>
                                <td>Wrap content to only show if purchased (alias: <code>[qixit_premium]</code>)</td>
                                <td><code>[qixit_premium_content]Secret content here[/qixit_premium_content]</code></td>
                            </tr>
                            <tr>
                                <td><code>[qixit_image]</code></td>
                                <td>Image with purchase or payout overlay (alias: <code>[2waymicropay_image]</code>)</td>
                                <td><code>[qixit_image src="..." link="https://products.qixit.com/purchasefast?PID=..."]</code></td>
                            </tr>
                            <tr>
                                <td><code>[qixit_payperplay]</code></td>
                                <td>Pay-Per-Play wrapper for games, songs, videos (alias: <code>[qixit_pay_per_play]</code>; see below)</td>
                                <td><code>[qixit_payperplay pid="GUID" image="screenshot.jpg" price="0.05"]Game embed[/qixit_payperplay]</code></td>
                            </tr>
                            <tr>
                                <td><code>[qixit_author_rights]</code></td>
                                <td>Displays configured Author Terms text only (informational; no buy button)</td>
                                <td><code>[qixit_author_rights]</code></td>
                            </tr>
                            <tr>
                                <td><code>[qixit_become_an_author]</code></td>
                                <td>Signup form + purchase button for Author or Contributor rights (based on Moderation Policy)</td>
                                <td><code>[qixit_become_an_author]</code></td>
                            </tr>
                        </tbody>
                    </table>
                    <p class="description" style="margin-top:12px;">
                        <strong><?php esc_html_e('Shortcode placement:', '2waymicropay'); ?></strong>
                        <?php esc_html_e('Put shortcodes in a normal paragraph or a Shortcode block. Do not apply Block Editor “Code” / inline code formatting to shortcodes — that can leave small theme-styled boxes on the page.', '2waymicropay'); ?>
                    </p>
                </div>

                <div class="qixit-section">
                    <h2>🔗 Forwarder Referral Commissions</h2>
                    <p>
                        Forwarder commissions let promoters earn a percentage when they share your purchase links.
                        Enable this under <strong>Settings → Forwarder Referral Commissions</strong> and set the forwarder percentage
                        (same model as the Vendors Portal product forwarder split).
                    </p>
                    <ol>
                        <li>Enable <strong>Allow Forwarder Split</strong> and set <strong>Forwarder Commission (%)</strong>.</li>
                        <li>Save settings, then update/re-sync affected premium posts so Products Portal products receive the new <code>forwardPercentage</code>.</li>
                        <li>Purchase links generated by this site include an empty <code>&amp;fwd=</code> suffix when forwarder commissions are enabled.</li>
                        <li>Promoters copy the link, paste it, and type their Qixit username/ID after <code>fwd=</code> (example: <code>...purchasefast?PID=…&amp;fwd=promotername</code>).</li>
                        <li>If <code>fwd</code> is missing or the ID is invalid/inactive, that commission percentage stays with the vendor — the purchase still completes normally.</li>
                        <li>Author/affiliate share plus forwarder share must not exceed 100%.</li>
                    </ol>
                </div>

                <div class="qixit-section">
                    <h2>👥 Author Commerce</h2>
                    <p>
                        Author Commerce lets site owners monetize contributor access and share revenue with post authors.
                        The workflow includes: paid onboarding rights, optional per-publish fees, and post-level revenue share.
                    </p>

                    <h3>Owner Setup Checklist</h3>
                    <ol>
                        <li>Go to <a href="<?php echo esc_url(admin_url('admin.php?page=qixit-settings')); ?>">Settings</a> and open <strong>Author Commerce Settings</strong>.</li>
                        <li>Enable <strong>Author Commerce</strong>.</li>
                        <li>
                            <strong>Moderation Policy</strong>. Choose Contributor Rights or Author Rights (mutually exclusive checkboxes).
                            <ul>
                                <li><strong>Contributor:</strong> Contributions must be approved by Editor or Admin before publication.</li>
                                <li><strong>Author:</strong> Authors can publish posts at their discretion.</li>
                            </ul>
                        </li>
                        <li>Set <strong>Author Rights Fee</strong> (one-time onboarding payment).</li>
                        <li>Optional: Set <strong>Per Publish Fee</strong> (charged only on first publication of a new post).</li>
                        <li>Set <strong>Default Author Revenue Share (%)</strong> for new premium content.</li>
                        <li>Optional: Enable <strong>Share Revenue from Comments</strong> and set <strong>Comment Revenue Share (%)</strong>.</li>
                        <li>Enter <strong>Author Terms</strong> text shown on the author-rights purchase page.</li>
                        <li>Set <strong>Author Instructions URL</strong> as the post-payment destination page for all successful author-rights purchases.</li>
                        <li>Save settings.</li>
                    </ol>

                    <h3>Create the Author-Rights Purchase Page</h3>
                    <ol>
                        <li>Create a new WordPress page (for example: <code>Become an Author</code>).</li>
                        <li>Add <code>[qixit_become_an_author]</code> to collect applicant details (username, optional/required email based on settings, and new WordPress password). The purchase button label is <strong>Purchase Author Rights</strong> or <strong>Purchase Contributor Rights</strong> based on Moderation Policy.</li>
                        <li>Optionally add <code>[qixit_author_rights]</code> to display your Author Terms text (informational only — no buy button).</li>
                        <li>Publish the page and add it to site navigation or onboarding emails.</li>
                        <li>Do <strong>not</strong> format these shortcodes as Code / inline code in the block editor.</li>
                        <li><strong>Purchase … Rights</strong> validates required signup fields, then launches checkout. Checkout login uses the applicant’s existing <strong>Qixit/mailbox</strong> password (not the new WordPress password).</li>
                        <li>The plugin creates/updates reusable site products named for Author or Contributor rights and publication fees.</li>
                        <li>After successful payment callback, the new WordPress account is created and linked for payout mapping.</li>
                    </ol>
                    <p>
                        The plugin automatically creates a default <strong>Author Instructions</strong> page (<em>Logging into your author account</em>) and sets it as the <strong>Author Instructions URL</strong> when that setting is empty. Site owners should edit that page as needed for their own onboarding terms and workflow.
                    </p>
                    <p>
                        The public <strong>author-rights purchase/signup page</strong> (with <code>[qixit_become_an_author]</code>) is still owner-controlled content, so you can tailor messaging and placement.
                    </p>
                    <p>
                        The contributor's Qixit identity is captured from the successful payment callback and linked to their WordPress account for revenue-sharing payouts.
                    </p>

                    <h3>Users Admin: Qixit ID Mapping</h3>
                    <ul>
                        <li>Go to <a href="<?php echo esc_url(admin_url('users.php')); ?>">Users</a> to see a <strong>Qixit ID</strong> column for all users.</li>
                        <li>Use the <strong>Author Access</strong> column to confirm whether each user is Contributor (approval required to publish) or Author (can publish).</li>
                        <li>Edit any user profile to set/update <strong>Qixit ID / Username</strong>.</li>
                        <li>This mapping is required for author revenue-sharing payouts.</li>
                    </ul>

                    <h3>How Publish Gating Works</h3>
                    <ul>
                        <li>If onboarding fee is enabled and a contributor has no active entitlement, publish is blocked and they get a payment link.</li>
                        <li>If publication fee is enabled, first publish is blocked until publication fee is paid.</li>
                        <li>After publication fee payment, the editor unlock window is 15 minutes for that post.</li>
                        <li>Admins and editors are never blocked by author-commerce gating.</li>
                        <li>Signup form requires a WordPress password separate from the contributor's 2WayMicropay password.</li>
                    </ul>

                    <h3>Owner Management of Author Share</h3>
                    <ol>
                        <li>Open a post/page and find the <strong>2WayMicropay Settings</strong> metabox.</li>
                        <li>Set <strong>Author Share (%)</strong> per post (or keep default from settings).</li>
                        <li>Ensure the post author has a mapped Qixit ID (profile/user-meta or author settings table).</li>
                        <li>Save/update the post so the API payload includes affiliate split headers for that product.</li>
                    </ol>
                    <p>
                        If author share is set but no author Qixit ID is mapped, the metabox shows a warning and split payload is not sent until mapping is fixed.
                    </p>

                    <h3>Approval Toggle (On/Off)</h3>
                    <ul>
                        <li>In Settings, <strong>Moderation Policy</strong> controls the WordPress role assigned after successful payment.</li>
                        <li>In Settings, <strong>Author Instructions URL</strong> controls where all paid applicants land after checkout.</li>
                        <li>In Settings, <strong>Signup Email Field</strong> controls whether email is required, optional, or hidden on the signup form.</li>
                        <li><strong>When OFF:</strong> after payment, account is created as Author and redirected to the Author Instructions URL.</li>
                        <li><strong>When ON:</strong> after payment, account is created as Contributor and redirected to the Author Instructions URL. Contributor posts require Editor/Admin approval to publish.</li>
                    </ul>
                </div>
                
                <div class="qixit-section">
                    <h2>🖼️ Payout Image Links (Pay Visitors to Visit)</h2>
                    <p>
                        The <strong>payout image link</strong> is a special link you attach to an image on your site. 
                        When a visitor clicks the image, the 2WayMicropay platform <strong>pays them</strong> a small 
                        amount of real money or vendor credits for visiting the destination page. This is perfect for 
                        sponsored content, advertisements, or any scenario where you want to reward visitors.
                    </p>

                    <h3>How to Set Up a Payout Image Link</h3>
                    <ol>
                        <li>Log in to the <a href="https://products.qixit.com" target="_blank">Products Portal</a> as a vendor</li>
                        <li>Create a new <strong>Payout Link</strong> (under the Payouts section)</li>
                        <li>Set the <strong>Pay Amount</strong> (what each visitor earns), <strong>Delivery URL</strong> (where the visitor goes), budget, and expiration date</li>
                        <li>Copy the generated payout link (it contains a <code>PYID=</code> parameter)</li>
                        <li>In your WordPress page/post, use the <code>[qixit_image]</code> shortcode, setting the <code>link</code> attribute to the payout URL:</li>
                    </ol>
                    <div class="qixit-example">
                        <pre>[qixit_image src="<?php echo esc_html($qixit_doc_example_image); ?>" link="https://products.qixit.com/paymentfast?PYID=your-payout-guid-here" width="600" height="200"]</pre>
                        <p class="description"><?php esc_html_e('Use a Media Library image URL or another asset hosted on your own WordPress site for src. The payout link attribute points at the Qixit payment service configured in plugin settings.', '2waymicropay'); ?></p>
                    </div>
                    <p>Visitors will see a price overlay on the image showing how much they will earn (for example <strong>+ $1.00 vendor credits</strong>). Hovering the image or the related hyperlink shows the same amount in a tooltip. Clicking the image opens the payment page where they log in (or create a free account) and receive the payment.</p>

                    <h3>Correct Link Setup (Avoid Broken Overlays)</h3>
                    <ul>
                        <li><strong>Use a Products Portal URL</strong> for the micropay / shortcode <code>link</code> attribute: <code>https://products.qixit.com/paymentfast?PYID=…</code> or <code>…/purchasefast?PID=…</code>. Do <strong>not</strong> paste a Media Library or CDN image URL into that field.</li>
                        <li><strong>Block editor:</strong> Enable micropay in the Image block&rsquo;s 2WayMicropay sidebar panel and paste the Portal link there. Prefer that over wrapping the image in a separate custom hyperlink (nested links break overlays).</li>
                        <li><strong>Visual reference:</strong> <a href="https://2waymicropay.com/wp/test-this-image-link/" target="_blank" rel="noopener noreferrer">2waymicropay.com — Images pay</a> shows the intended badge (compact logo mark + amount on a small white badge).</li>
                    </ul>

                    <h3>Payout Types</h3>
                    <table class="widefat" style="margin-bottom: 20px;">
                        <thead><tr><th>Type</th><th>What Visitor Receives</th><th>Budget Field</th></tr></thead>
                        <tbody>
                            <tr>
                                <td><strong>Real Funds</strong></td>
                                <td>Actual money credited to their account (withdrawable)</td>
                                <td>Max Pay (total dollar budget across all recipients)</td>
                            </tr>
                            <tr>
                                <td><strong>Vendor Credits (Promo)</strong></td>
                                <td>Credits redeemable for purchases on this vendor&rsquo;s site</td>
                                <td>Promo Budget (total credit budget across all recipients)</td>
                            </tr>
                        </tbody>
                    </table>

                    <h3>Active vs. Inactive Payout Links</h3>
                    <p>A payout link is <strong>active</strong> as long as:</p>
                    <ul>
                        <li>The expiration date has not passed (or no expiration is set), <strong>and</strong></li>
                        <li>The total budget has not been exhausted, <strong>and</strong></li>
                        <li>The vendor has sufficient funds in their account</li>
                    </ul>
                    <p>When a payout link becomes <strong>inactive</strong>, the plugin automatically changes its behavior:</p>
                    <table class="widefat" style="margin-bottom: 20px;">
                        <thead><tr><th>State</th><th>Price Overlay</th><th>Click Destination</th></tr></thead>
                        <tbody>
                            <tr>
                                <td><strong>Active</strong></td>
                                <td>Shown (e.g., &ldquo;+ 5&cent;&rdquo; or &ldquo;+ $1.00 vendor credits&rdquo;)</td>
                                <td>Payout page &rarr; visitor earns payment &rarr; redirected to Delivery URL</td>
                            </tr>
                            <tr>
                                <td><strong>Inactive</strong> (expired or budget exhausted)</td>
                                <td>Hidden — no price overlay is shown</td>
                                <td>Delivery URL directly (plain link, no payment process)</td>
                            </tr>
                        </tbody>
                    </table>
                    <div style="background: #e7f5ea; border-left: 4px solid #4caf50; padding: 12px 15px; margin: 15px 0;">
                        <strong>Key benefit:</strong> Once you attach a payout link to an image, you never need to update the WordPress post again. 
                        The image will always link to the destination page. When the payout is active, visitors earn money. 
                        When it expires or the budget runs out, visitors still reach the page &mdash; they just don&rsquo;t earn anything. 
                        If you later extend the expiration date or add more budget in the Products Portal, the payout link automatically becomes active again.
                    </div>

                    <p>
                        <strong>Block editor:</strong> Use the standard Image block alignment controls (left, center, right).
                        Enable micropay in the 2WayMicropay sidebar panel — alignment is preserved on the frontend.
                        <strong>Classic editor:</strong> Insert an image with Add Media, set alignment, then use the
                        2WayMicropay Image toolbar button (or set <code>align</code> on the shortcode).
                    </p>

                    <h3>Shortcode Attributes</h3>
                    <table class="widefat" style="margin-bottom: 20px;">
                        <thead><tr><th>Attribute</th><th>Required</th><th>Description</th></tr></thead>
                        <tbody>
                            <tr><td><code>src</code></td><td>Yes</td><td>URL of the image to display</td></tr>
                            <tr><td><code>link</code></td><td>Yes</td><td>The payout URL (contains <code>PYID=</code>) or a plain URL</td></tr>
                            <tr><td><code>width</code></td><td>No</td><td>Image width in pixels or CSS value (e.g., <code>600</code> or <code>300px</code>)</td></tr>
                            <tr><td><code>height</code></td><td>No</td><td>Image height in pixels</td></tr>
                            <tr><td><code>max_width</code></td><td>No</td><td>Maximum width of the micropay container (e.g., <code>500px</code>)</td></tr>
                            <tr><td><code>align</code></td><td>No</td><td>Image alignment: <code>left</code>, <code>right</code>, or <code>center</code> (text wraps around left/right floats)</td></tr>
                            <tr><td><code>alt</code></td><td>No</td><td>Alt text for the image</td></tr>
                        </tbody>
                    </table>

                    <h3>Troubleshooting Payout Links</h3>
                    <dl>
                        <dt><strong>No price overlay showing on the image</strong></dt>
                        <dd>The payout is most likely inactive (expired or budget exhausted). Check the payout settings in the Products Portal. Extending the expiration date or adding budget will restore the overlay automatically on next page load.</dd>

                        <dt><strong>Overlay shows &ldquo;+ click to earn&rdquo; without an amount, or hover says &ldquo;Offer details unavailable&rdquo;</strong></dt>
                        <dd>Confirm the image micropay link is a Products Portal <code>paymentfast?PYID=</code> URL (not a media file URL). Also wait if the public Products API recently returned &ldquo;Too many requests&rdquo; for your IP — that block clears automatically within about an hour.</dd>

                        <dt><strong>Green &ldquo;2WayMicropay&rdquo; oval appears on top of the price badge</strong></dt>
                        <dd>Update to plugin 4.1.6 or later. Overlays use the compact branding logo mark plus the amount; a full wordmark pill is not used on image badges.</dd>

                        <dt><strong>Image clicks go directly to the destination without the payout page</strong></dt>
                        <dd>This is normal behavior when the payout is inactive. The plugin falls back to the Delivery URL so visitors still reach the destination.</dd>

                        <dt><strong>Payout says &ldquo;Promo budget exhausted&rdquo; or &ldquo;Promotion has expired&rdquo;</strong></dt>
                        <dd>The payout link has run out of budget or passed its expiration date. Increase the budget or extend the date in the Products Portal to reactivate it.</dd>
                    </dl>
                </div>

                <div class="qixit-section">
                    <h2>🎮 Pay-Per-Play (Games, Songs, Videos)</h2>
                    <p>
                        Use the <code>[qixit_payperplay]</code> shortcode to require payment for <strong>each play</strong> 
                        of a game, song, or video. Unlike session-based content, users must pay again every time they want to play.
                    </p>
                    
                    <h3>How It Works</h3>
                    <ol>
                        <li>Create a product in the <a href="https://products.qixit.com" target="_blank">Products Portal</a> (Delivery URL is <strong>optional</strong> for Pay Per Play)</li>
                        <li>Copy the Product GUID (from the product's edit page or URL)</li>
                        <li>Create/edit a WordPress page and add the shortcode with your game embedded inside</li>
                        <li>Visitors see a screenshot/placeholder with a "Play Now" button</li>
                        <li>Clicking triggers the payment micro-frame</li>
                        <li>After payment, the content loads &mdash; audio and video begin playing automatically</li>
                        <li>To play again, they must pay again (no session cookies)</li>
                    </ol>
                    
                    <h3>Shortcode Attributes</h3>
                    <table class="widefat" style="margin-bottom: 20px;">
                        <thead>
                            <tr>
                                <th>Attribute</th>
                                <th>Required</th>
                                <th>Description</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr>
                                <td><code>pid</code></td>
                                <td>✅ Yes</td>
                                <td>Product GUID from the Products Portal (e.g., "28b5242d-deef-40fa-a3e6-e41f8c3da3e8")</td>
                            </tr>
                            <tr>
                                <td><code>image</code></td>
                                <td>✅ Yes</td>
                                <td>URL to placeholder image/screenshot (shows before payment)</td>
                            </tr>
                            <tr>
                                <td><code>price</code></td>
                                <td>No</td>
                                <td>Price to display on button (default: "0.01"). For display only - actual price is set in Products Portal</td>
                            </tr>
                            <tr>
                                <td><code>button_text</code></td>
                                <td>No</td>
                                <td>Text on the play button (default: "Play Now")</td>
                            </tr>
                            <tr>
                                <td><code>button_again_text</code></td>
                                <td>No</td>
                                <td>Button text after first play (default: "Play Again")</td>
                            </tr>
                            <tr>
                                <td><code>width</code></td>
                                <td>No</td>
                                <td>Container width (default: "100%")</td>
                            </tr>
                            <tr>
                                <td><code>height</code></td>
                                <td>No</td>
                                <td>Container height (default: "400px")</td>
                            </tr>
                            <tr>
                                <td><code>title</code></td>
                                <td>No</td>
                                <td>Title displayed on the placeholder overlay</td>
                            </tr>
                        </tbody>
                    </table>
                    
                    <div class="qixit-warning" style="background: #fff3cd; border-left: 4px solid #ffc107; padding: 12px; margin-bottom: 20px;">
                        <strong>⚠️ Important:</strong> WordPress does not handle multi-line shortcodes well. 
                        All shortcode parameters must be on <strong>one line</strong> (no line breaks between attributes).
                    </div>
                    
                    <h3>Example: Pay-Per-Play Game</h3>
                    <p>This example embeds self-hosted game HTML that requires 5&cent; per play. Upload your game to the Media Library or theme and reference it locally:</p>
                    <div class="qixit-example">
                        <pre>[qixit_payperplay pid="your-product-guid-here" image="<?php echo esc_html($qixit_doc_example_image); ?>" price="0.05" button_text="Play Game" title="Snake Game" width="800px" height="600px"]
&lt;iframe src="/wp-content/uploads/your-game.html" width="100%" height="100%" frameborder="0"&gt;&lt;/iframe&gt;
[/qixit_payperplay]</pre>
                    </div>
                    
                    <h3>Example: Pay-Per-Play Video</h3>
                    <p>Embed self-hosted video content (upload to your Media Library or theme) that requires payment to watch:</p>
                    <div class="qixit-example">
                        <pre>[qixit_payperplay pid="your-product-guid-here" image="<?php echo esc_html($qixit_doc_example_image); ?>" price="0.05" button_text="▶ Watch Video" title="Premium Video" width="560px" height="315px"]
&lt;video controls autoplay style="width:100%"&gt;
    &lt;source src="/wp-content/uploads/your-video.mp4" type="video/mp4"&gt;
&lt;/video&gt;
[/qixit_payperplay]</pre>
                    </div>
                    
                    <h3>Example: Pay-Per-Play Audio (Song or Speech)</h3>
                    <p>Embed self-hosted audio (upload to your Media Library) that requires payment to listen:</p>
                    <div class="qixit-example">
                        <pre>[qixit_payperplay pid="your-product-guid-here" image="<?php echo esc_html($qixit_doc_example_image); ?>" price="0.02" button_text="▶ Listen Now" title="Premium Audio" width="400px" height="200px"]
&lt;audio controls autoplay style="width:100%"&gt;
    &lt;source src="/wp-content/uploads/your-audio.mp3" type="audio/mpeg"&gt;
&lt;/audio&gt;
[/qixit_payperplay]</pre>
                    </div>
                    
                    <h3>Product Portal Setup</h3>
                    <p>Before using Pay-Per-Play, you must create the product in the <a href="https://products.qixit.com" target="_blank">Products Portal</a>:</p>
                    <ol>
                        <li>Log in to the Products Portal</li>
                        <li>Create a new product or edit an existing one</li>
                        <li>Set the price (e.g., $0.05)</li>
                        <li><strong>Important:</strong> Set Access Type to <strong>&ldquo;Pay Per Play (Single Use Only)&rdquo;</strong></li>
                        <li><strong>Delivery URL</strong> is <strong>optional</strong>. Leave it blank when the content is embedded via shortcode (the shortcode content IS the delivery). If you provide a Delivery URL, it will also open in a new window after payment.</li>
                        <li>Copy the Product GUID and use it in the <code>pid</code> attribute</li>
                    </ol>
                    
                    <div style="background: #e7f5ea; border-left: 4px solid #4caf50; padding: 12px 15px; margin: 15px 0;">
                        <strong>Delivery URL behavior:</strong>
                        <ul style="margin: 5px 0 0 0;">
                            <li><strong>Shortcode + no Delivery URL:</strong> Embedded content (game, audio, video) reveals after payment. This is the typical setup.</li>
                            <li><strong>Shortcode + Delivery URL:</strong> Embedded content reveals AND the Delivery URL opens in a new window.</li>
                            <li><strong>Standalone link + Delivery URL:</strong> The Delivery URL opens in a new window (the URL is what the buyer is paying for).</li>
                            <li><strong>Standalone link + no Delivery URL:</strong> Error &mdash; there is nothing to deliver. Always set a Delivery URL when not using the shortcode.</li>
                        </ul>
                    </div>
                    
                    <h3>JavaScript API for Game Developers</h3>
                    <p>
                        If you're embedding a custom game, you can call <code>QixitFrontend.resetPayPerPlay(containerId)</code> 
                        when the game ends to show the placeholder again and require payment for the next play.
                    </p>
                    <div class="qixit-example">
                        <pre>// Call this from your game when play ends:
window.parent.QixitFrontend.resetPayPerPlay('qixit-payperplay-1');</pre>
                    </div>
                </div>
                
                <div class="qixit-section">
                    <h2>🎨 Branding Integration (Developer Standard)</h2>
                    <p>
                        To keep all sites in sync with platform branding updates, integrations should load
                        branding assets from the manifest endpoint and avoid hardcoded colors in UI overlays/paywalls.
                    </p>
                    <ol>
                        <li>Fetch <code>GET /api/branding/config</code> from the Products API host.</li>
                        <li>Load <code>urls.css</code> and <code>urls.js</code> from that manifest (versioned assets).</li>
                        <li>Use branding-provided logo URLs (<code>urls.logoPng</code> / <code>urls.logoSvg</code>). For image purchase/payout badges, prefer the compact <code>logoPng</code> mark next to the price — not a full wordmark.</li>
                        <li>In local CSS, use tokenized values with fallbacks (for example <code>var(--qixit-brand-start, #52ac5b)</code>) instead of fixed colors.</li>
                        <li>Keep plugin-specific CSS limited to layout/spacing/behavior, not hardcoded brand palettes.</li>
                    </ol>
                    <p>
                        This plugin now follows that rule for paywalls, comment purchase tooltips, image link badges, and pay-per-play overlays.
                        If central branding changes later, those surfaces can update across customer sites without per-site code edits.
                    </p>
                </div>

                <div class="qixit-section">
                    <h2>🖼️ Micro-Frame Purchase Flow</h2>
                    <p>
                        When visitors click a "Buy" button or "Read more..." link on premium content, a compact 
                        purchase frame (about 380×180 pixels when already logged in; taller when login is required) appears directly on the page—no redirects or popups needed.
                    </p>
                    
                    <h3>How It Works</h3>
                    <ol>
                        <li>Visitor clicks a purchase link/button</li>
                        <li>A small iframe appears near the click point</li>
                        <li>The PurchaseFast page loads inside the frame</li>
                        <li>If not logged in, a compact login form appears</li>
                        <li>After login, one-click purchase confirmation</li>
                        <li>Content unlocks automatically upon successful payment</li>
                    </ol>
                    
                    <h3>Read More Style</h3>
                    <p>
                        Enable the <strong>"Use Read More tag"</strong> option in the post editor to show free 
                        content above the <code>&lt;!--more--&gt;</code> tag, with an inline "Read more..." 
                        link that opens the micro-frame. This creates a natural paywall break point.
                    </p>
                    
                    <h3>Tooltip Preview</h3>
                    <p>
                        "Read more..." links include a hover tooltip showing the price before clicking, 
                        e.g., "Pay 5 cents to continue reading".
                    </p>
                    
                    <h3>Products Portal</h3>
                    <p>
                        The micro-frame loads from the <strong>Products Portal</strong> at 
                        <a href="https://products.qixit.com" target="_blank">https://products.qixit.com</a>.
                    </p>
                </div>
                
                <div class="qixit-section">
                    <h2>💬 Paid Comments</h2>
                    <p>Require users to <strong>pay before commenting</strong> on your posts/pages. When enabled, the comment form is locked until payment is complete.</p>
                    
                    <h3>How It Works</h3>
                    <ol>
                        <li>You enable paid comments on a post/page and set a price</li>
                        <li>Visitors see the comment section but must pay to unlock it</li>
                        <li>They click "Pay to Comment" and complete checkout in the purchase frame</li>
                        <li>They log in (or create a free account) and pay</li>
                        <li>After payment, they're returned to your post with the comment form unlocked</li>
                        <li>Their comment is auto-approved (no moderation needed)</li>
                    </ol>
                    
                    <h3>How to Enable Paid Comments</h3>
                    <ol>
                        <li>Edit a post or page</li>
                        <li>In the <strong>Qixit Micropayment Settings</strong> box, check <strong>"Require payment for comments"</strong></li>
                        <li>Set the <strong>Comment Price</strong> (e.g., $0.05)</li>
                        <li>Save the post — the comment product is automatically synced to the API</li>
                    </ol>

                    <h3>Global Paid Comments Fallback (Site-Wide)</h3>
                    <ol>
                        <li>Go to <strong>2WayMicropay Settings</strong> and enable <strong>"Global Paid Comments"</strong>.</li>
                        <li>Set a <strong>Default Comment Price</strong> used when a post/page has no per-post comment price.</li>
                        <li>When enabled, existing posts/pages are backfilled and future posts/pages inherit paid comments automatically.</li>
                        <li>The plugin uses a <strong>shared comments product</strong> as a fallback path (not a unique product for every page by default).</li>
                    </ol>
                    <p><strong>Priority order:</strong> explicit per-post settings and author-share comment products are used first; the global shared comments product is fallback only.</p>
                    <p><strong>Per-post override:</strong> owners/editors can still change comment price per post, enable a per-post paid-comment product, or allow unpaid comments on a specific post/page.</p>
                    
                    <h3>What Users See</h3>
                    <table class="widefat" style="max-width: 600px;">
                        <tr>
                            <td style="width:50%;"><strong>Before Payment</strong></td>
                            <td style="width:50%;"><strong>After Payment</strong></td>
                        </tr>
                        <tr>
                            <td>
                                <ul style="margin:0;padding-left:20px;">
                                    <li>Comment form is hidden</li>
                                    <li>"Pay $X to Comment" button shown</li>
                                    <li>Existing comments visible</li>
                                </ul>
                            </td>
                            <td>
                                <ul style="margin:0;padding-left:20px;">
                                    <li>✅ "Payment Confirmed!" message</li>
                                    <li>Comment form unlocked</li>
                                    <li>Comment is auto-approved</li>
                                </ul>
                            </td>
                        </tr>
                    </table>
                    
                    <h3>Benefits for You</h3>
                    <ul>
                        <li>💰 <strong>Revenue</strong> - Monetize your comment sections</li>
                        <li>🛡️ <strong>Spam Prevention</strong> - Payment barrier stops spam bots</li>
                        <li>⚡ <strong>Less Moderation</strong> - Paid comments auto-approve</li>
                        <li>📧 <strong>Quality Engagement</strong> - Paying users post thoughtful comments</li>
                    </ul>
                </div>
                
                <div class="qixit-section">
                    <h2>⚙️ Content Types Explained</h2>
                    <table class="widefat">
                        <thead>
                            <tr>
                                <th>Type</th>
                                <th>Description</th>
                                <th>Best For</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr>
                                <td><strong>Regular (Free)</strong></td>
                                <td>No paywall, content is freely accessible</td>
                                <td>Blog posts, teasers, general content</td>
                            </tr>
                            <tr>
                                <td><strong>Pay Once, View Forever</strong></td>
                                <td>User pays once and can access anytime</td>
                                <td>Articles, tutorials, downloads, ebooks</td>
                            </tr>
                            <tr>
                                <td><strong>Pay Per View</strong></td>
                                <td>User pays each time they view</td>
                                <td>Time-sensitive content, live streams, events</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
                
                <div class="qixit-section">
                    <h2>❓ Troubleshooting</h2>
                    <dl>
                        <dt><strong>"Not Connected" error</strong></dt>
                        <dd>The Settings page shows <strong>Connected</strong> when the Site API Key validates for this account context. Vendor username/password are no longer probed during status checks, preventing IP/email step-up challenges for plugin traffic. For troubleshooting only, use "Test API Connection" in <strong>Advanced Diagnostics</strong>.</dd>
                        
                        <dt><strong>"Not authenticated" after entering credentials</strong></dt>
                        <dd>Save settings after updating Site API Key so the connection status can revalidate immediately.</dd>
                        
                        <dt><strong>Paywall not showing</strong></dt>
                        <dd>Make sure the post type is set to Premium (not Regular). Products sync automatically when you save; look for the green "✅ Synced to API" badge.</dd>
                        
                        <dt><strong>Payment link not working</strong></dt>
                        <dd>Verify the product is synced (green badge in the Qixit Micropayment Settings box). Re-saving the post triggers a fresh sync.</dd>
                        
                        <dt><strong>Payout image link shows no overlay and goes straight to destination</strong></dt>
                        <dd>The payout is inactive: either the expiration date has passed, the budget has been exhausted, or the vendor has insufficient funds. Check the payout settings in the Products Portal (<a href="https://products.qixit.com" target="_blank">products.qixit.com</a>). Extending the date or adding budget reactivates the payout automatically.</dd>
                        
                        <dt><strong>Payout image link shows no overlay and the image is not clickable</strong></dt>
                        <dd>If no Delivery URL was set on the payout link, the link becomes unclickable when inactive. Set a Delivery URL in the Products Portal to ensure the image always links somewhere.</dd>

                        <dt><strong>Image badge missing the dollar/cent amount, or a green &ldquo;2WayMicropay&rdquo; oval appears</strong></dt>
                        <dd>Use plugin 4.1.6+. Set the micropay link to a Products Portal purchase/payment URL (not a media URL). See <strong>Payout Image Links → Correct Link Setup</strong> above. Demo: <a href="https://2waymicropay.com/wp/test-this-image-link/" target="_blank" rel="noopener noreferrer">Images pay</a>.</dd>
                        
                        <dt><strong>Read More not working</strong></dt>
                        <dd>Make sure you added the &lt;!--more--&gt; tag in your post AND enabled "Use Read More as paywall" in settings.</dd>
                    </dl>
                </div>
                
                <div class="qixit-section">
                    <h2>📞 Support</h2>
                    <p>Need help? Contact us:</p>
                    <ul>
                        <li>Website: <a href="https://www.qixit.com" target="_blank">www.qixit.com</a></li>
                        <li>Plugin Site: <a href="https://www.qixit.com" target="_blank">qixit.com</a></li>
                    </ul>
                </div>
                
            </div>
        </div>

        <?php
        wp_add_inline_script('qixit-admin', <<<'JS'
(function() {
    var tocList = document.getElementById('qixit-instructions-toc');
    var container = document.querySelector('.qixit-instructions-content');
    if (!tocList || !container) return;

    var headings = container.querySelectorAll('.qixit-section h2');
    var usedIds = {};
    headings.forEach(function(h2) {
        var text = (h2.textContent || '').trim();
        if (!text || text.toLowerCase() === 'table of contents') return;

        var slug = text
            .toLowerCase()
            .replace(/[^\w\s-]/g, '')
            .replace(/\s+/g, '-')
            .replace(/-+/g, '-')
            .replace(/^-|-$/g, '');
        if (!slug) return;

        var baseSlug = slug;
        var count = 1;
        while (document.getElementById(slug) || usedIds[slug]) {
            slug = baseSlug + '-' + count;
            count++;
        }
        usedIds[slug] = true;
        h2.id = slug;

        var li = document.createElement('li');
        var a = document.createElement('a');
        a.href = '#' + slug;
        a.textContent = text;
        li.appendChild(a);
        tocList.appendChild(li);
    });
})();
JS
        );
        wp_add_inline_style('qixit-admin', '
            .qixit-instructions-content {
                max-width: 900px;
                background: #fff;
                padding: 30px;
                border: 1px solid #ccd0d4;
                margin-top: 20px;
            }
            .qixit-section {
                margin-bottom: 40px;
                padding-bottom: 30px;
                border-bottom: 1px solid #eee;
            }
            .qixit-section:last-child {
                border-bottom: none;
                margin-bottom: 0;
            }
            .qixit-section h2 {
                color: #1d2327;
                border-bottom: 2px solid #2271b1;
                padding-bottom: 10px;
                margin-top: 0;
            }
            .qixit-section h3 {
                color: #50575e;
                margin-top: 25px;
            }
            .qixit-toc-section ul {
                margin: 0;
                padding-left: 18px;
            }
            .qixit-toc-section li { margin: 4px 0; }
            .qixit-section ol, .qixit-section ul { line-height: 1.8; }
            .qixit-section ul ul {
                margin-top: 5px;
                margin-bottom: 5px;
            }
            .qixit-section code {
                background: #f0f0f1;
                padding: 2px 6px;
                border-radius: 3px;
            }
            .qixit-section pre {
                background: #f6f7f7;
                padding: 15px;
                border-left: 4px solid #2271b1;
                overflow-x: auto;
                font-family: "Courier New", monospace;
                font-size: 13px;
                line-height: 1.5;
            }
            .qixit-example {
                background: #f0f6fc;
                border: 1px solid #c3c4c7;
                padding: 15px;
                border-radius: 4px;
                margin: 15px 0;
            }
            .qixit-section table { margin-top: 15px; }
            .qixit-section table td, .qixit-section table th { padding: 12px; }
            .qixit-section dl { line-height: 1.6; }
            .qixit-section dt {
                font-weight: 600;
                margin-top: 15px;
                color: #1d2327;
            }
            .qixit-section dd {
                margin-left: 20px;
                color: #50575e;
            }
        ');
        ?>
        <?php
    }
}

// Initialize admin
if (is_admin()) {
    Qixit_Admin::get_instance();
}