<?php
if (!defined('ABSPATH')) exit;

/**
 * Render the external links (outbound clicks) report.
 */
function eistat_render_links() {
    global $wpdb;
    $eistat_p = $wpdb->prefix . 'eistat_';

    // phpcs:ignore WordPress.Security.NonceVerification.Recommended
    $days = isset($_GET['days']) && (int) $_GET['days'] === 28 ? 28 : 7;

    // phpcs:ignore WordPress.Security.NonceVerification.Recommended
    $eistat_raw_link_type = isset($_GET['link_type'])
        ? sanitize_key(wp_unslash($_GET['link_type']))
        : '';
    $eistat_filter_type = in_array($eistat_raw_link_type, ['outbound', 'email', 'phone'], true)
        ? $eistat_raw_link_type
        : '';

    if ($eistat_filter_type !== '') {
        $eistat_where_type = " AND link_type = %s";
        $eistat_args_links = [$days, $eistat_filter_type];
        $eistat_args_pages = [$days, $eistat_filter_type];
    } else {
        $eistat_where_type = "";
        $eistat_args_links = [$days];
        $eistat_args_pages = [$days];
    }

    // --- Top links ---
    $eistat_sql_links = "SELECT link_type, link_url, link_text, SUM(count) AS c
        FROM {$eistat_p}events
        WHERE date >= DATE_SUB(CURDATE(), INTERVAL %d DAY){$eistat_where_type}
        GROUP BY link_type, link_url, link_text
        ORDER BY c DESC
        LIMIT 50";

    // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter
    $eistat_top_links = $wpdb->get_results($wpdb->prepare($eistat_sql_links, ...$eistat_args_links));

    // --- Top pages with clicks ---
    $eistat_sql_pages = "SELECT page_type, page_id, SUM(count) AS c
        FROM {$eistat_p}events
        WHERE date >= DATE_SUB(CURDATE(), INTERVAL %d DAY){$eistat_where_type}
        GROUP BY page_type, page_id
        ORDER BY c DESC
        LIMIT 20";

    // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter
    $eistat_top_pages = $wpdb->get_results($wpdb->prepare($eistat_sql_pages, ...$eistat_args_pages));

    // --- Load page URLs for the top pages ---
    $eistat_page_urls = [];
    if ($eistat_top_pages) {
        $eistat_keys = [];
        foreach ($eistat_top_pages as $tp) {
            $eistat_keys[] = $wpdb->prepare("(page_type = %s AND page_id = %d)", $tp->page_type, $tp->page_id);
        }
        $eistat_where = implode(' OR ', $eistat_keys);
        // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter
        $eistat_rows = $wpdb->get_results(
            "SELECT DISTINCT page_type, page_id, page_url
             FROM {$eistat_p}pageviews
             WHERE date >= DATE_SUB(CURDATE(), INTERVAL " . (int) $days . " DAY)
               AND ({$eistat_where})"
        );
        foreach ($eistat_rows as $r) {
            $eistat_page_urls[$r->page_type . '|' . $r->page_id] = $r->page_url;
        }
    }

    // --- Summary by link type ---
    // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter
    $eistat_by_type = $wpdb->get_results($wpdb->prepare(
        "SELECT link_type, SUM(count) AS c
         FROM {$eistat_p}events
         WHERE date >= DATE_SUB(CURDATE(), INTERVAL %d DAY)
         GROUP BY link_type
         ORDER BY c DESC",
        $days
    ));

    $eistat_type_labels = [
        'outbound' => __('External links', 'statinform'),
        'email'    => __('Email', 'statinform'),
        'phone'    => __('Phone', 'statinform'),
    ];

    $eistat_type_totals = ['outbound' => 0, 'email' => 0, 'phone' => 0];
    $eistat_grand_total = 0;
    foreach ($eistat_by_type as $t) {
        $eistat_type_totals[$t->link_type] = (int) $t->c;
        $eistat_grand_total += (int) $t->c;
    }
    ?>
    <div class="wrap eistat-wrap">
        <div class="eistat-tabs">
            <a href="?page=eistat-dashboard&days=<?php echo (int) $days; ?>"><?php echo esc_html__('Overview', 'statinform'); ?></a>
            <a href="?page=eistat-dashboard&view=paths&days=<?php echo (int) $days; ?>"><?php echo esc_html__('Paths', 'statinform'); ?></a>
            <a href="?page=eistat-dashboard&view=entry-exit&days=<?php echo (int) $days; ?>"><?php echo esc_html__('Entry & Exit', 'statinform'); ?></a>
            <a href="?page=eistat-dashboard&view=links&days=<?php echo (int) $days; ?>" class="active"><?php echo esc_html__('External links', 'statinform'); ?></a>
            <a href="?page=eistat-dashboard&view=archives"><?php echo esc_html__('Export & Archives', 'statinform'); ?></a>
        </div>

        <h2 class="eistat-section">
            <?php
            /* translators: %d: number of days */
            echo esc_html(sprintf(__('External link clicks (last %d days)', 'statinform'), $days));
            ?>
        </h2>

        <div style="margin: 12px 0;">
            <a href="?page=eistat-dashboard&view=links&days=7"
               class="button <?php echo $days === 7 ? 'button-primary' : ''; ?>">
                <?php echo esc_html__('7 days', 'statinform'); ?>
            </a>
            <a href="?page=eistat-dashboard&view=links&days=28"
               class="button <?php echo $days === 28 ? 'button-primary' : ''; ?>">
                <?php echo esc_html__('28 days', 'statinform'); ?>
            </a>
        </div>

        <?php if (!$eistat_grand_total): ?>
            <p><?php echo esc_html__('No clicks recorded in this period.', 'statinform'); ?></p>
        <?php else: ?>

            <div class="eistat-cards">
                <?php foreach ($eistat_type_labels as $eistat_key => $eistat_label): ?>
                    <div class="eistat-card">
                        <div class="eistat-card-label"><?php echo esc_html($eistat_label); ?></div>
                        <div class="eistat-card-value"><?php echo esc_html(number_format_i18n($eistat_type_totals[$eistat_key])); ?></div>
                        <div class="eistat-card-sub">
                            <?php
                            $eistat_pct = $eistat_grand_total > 0 ? round($eistat_type_totals[$eistat_key] / $eistat_grand_total * 100, 1) : 0;
                            /* translators: %s: percentage of all clicks */
                            echo esc_html(sprintf(__('%s%% of all clicks', 'statinform'), $eistat_pct));
                            ?>
                        </div>
                    </div>
                <?php endforeach; ?>
            </div>

            <div style="margin: 12px 0;">
                <a href="?page=eistat-dashboard&view=links&days=<?php echo (int) $days; ?>"
                   class="button <?php echo $eistat_filter_type === '' ? 'button-primary' : ''; ?>">
                    <?php echo esc_html__('All types', 'statinform'); ?>
                </a>
                <?php foreach ($eistat_type_labels as $eistat_key => $eistat_label): ?>
                    <a href="?page=eistat-dashboard&view=links&days=<?php echo (int) $days; ?>&link_type=<?php echo esc_attr($eistat_key); ?>"
                       class="button <?php echo $eistat_filter_type === $eistat_key ? 'button-primary' : ''; ?>">
                        <?php echo esc_html($eistat_label); ?>
                    </a>
                <?php endforeach; ?>
            </div>

            <div style="display: grid; grid-template-columns: 2fr 1fr; gap: 20px; margin-top: 20px;">
                <div>
                    <h3 style="margin-top: 0;"><?php echo esc_html__('Top clicked links', 'statinform'); ?></h3>
                    <table class="eistat-table">
                        <thead><tr>
                            <th><?php echo esc_html__('Link', 'statinform'); ?></th>
                            <th style="width:80px;"><?php echo esc_html__('Type', 'statinform'); ?></th>
                            <th style="width:80px;"><?php echo esc_html__('Clicks', 'statinform'); ?></th>
                        </tr></thead>
                        <tbody>
                        <?php if (!$eistat_top_links): ?>
                            <tr><td colspan="3"><?php echo esc_html__('No data.', 'statinform'); ?></td></tr>
                        <?php endif; ?>
                        <?php foreach ($eistat_top_links as $l): ?>
                            <tr>
                                <td>
                                    <a href="<?php echo esc_url($l->link_url); ?>" target="_blank" rel="nofollow noopener">
                                        <?php echo esc_html($l->link_url); ?>
                                    </a>
                                    <?php if (!empty($l->link_text)): ?>
                                        <div class="eistat-muted">
                                            <?php echo esc_html($l->link_text); ?>
                                        </div>
                                    <?php endif; ?>
                                </td>
                                <td>
                                    <?php echo esc_html($eistat_type_labels[$l->link_type] ?? $l->link_type); ?>
                                </td>
                                <td><strong><?php echo esc_html(number_format_i18n((int) $l->c)); ?></strong></td>
                            </tr>
                        <?php endforeach; ?>
                        </tbody>
                    </table>
                </div>

                <div>
                    <h3 style="margin-top: 0;"><?php echo esc_html__('Pages with clicks', 'statinform'); ?></h3>
                    <table class="eistat-table">
                        <thead><tr>
                            <th><?php echo esc_html__('Page', 'statinform'); ?></th>
                            <th style="width:70px;"><?php echo esc_html__('Clicks', 'statinform'); ?></th>
                        </tr></thead>
                        <tbody>
                        <?php if (!$eistat_top_pages): ?>
                            <tr><td colspan="2"><?php echo esc_html__('No data.', 'statinform'); ?></td></tr>
                        <?php endif; ?>
                        <?php foreach ($eistat_top_pages as $tp):
                            $eistat_key = $tp->page_type . '|' . $tp->page_id;
                            $eistat_url = $eistat_page_urls[$eistat_key] ?? '';
                        ?>
                            <tr>
                                <td>
                                    <?php if ($eistat_url): ?>
                                        <a href="<?php echo esc_url($eistat_url); ?>" target="_blank"><?php echo esc_html($eistat_url); ?></a>
                                    <?php else: ?>
                                        <em>
                                            <?php
                                            /* translators: 1: page type, 2: page ID */
                                            echo esc_html(sprintf(__('%1$s #%2$d', 'statinform'), $tp->page_type, (int) $tp->page_id));
                                            ?>
                                        </em>
                                    <?php endif; ?>
                                </td>
                                <td><?php echo esc_html(number_format_i18n((int) $tp->c)); ?></td>
                            </tr>
                        <?php endforeach; ?>
                        </tbody>
                    </table>
                </div>
            </div>
        <?php endif; ?>
    </div>
    <?php
}
eistat_render_links();