<?php

namespace ChargeForms\Admin;

use ChargeForms\Includes\Entry;
use ChargeForms\Includes\Form;
use ChargeForms\Includes\Icon;

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

/**
 * ChargeForms > Reports. Matches the real the reference product Reports screen's
 * structure: Overview / Payments / Submissions sub-tabs, a form + date-range
 * filter, stat tiles, and real charts computed from our own entries/payments
 * data — including Completion Rates (a genuine started-vs-submitted signal,
 * see Form_Start), Submissions By Country (from each form's own Country List
 * field answers, not IP geolocation — ChargeForms has no GeoIP data source),
 * and a Submission Timeline Patterns heatmap (derived straight from
 * entries.created_at, no new tracking needed).
 */
class Reports_Page {

	const SUBTABS = [ 'overview', 'payments', 'submissions' ];

	public function __construct() {
		add_action( 'admin_menu', [ $this, 'register' ] );
		add_action( 'admin_post_chargeforms_export_report', [ $this, 'handle_export' ] );
	}

	public function register() {
		add_submenu_page(
			'chargeforms',
			__( 'Reports', 'chargeforms' ),
			__( 'Reports', 'chargeforms' ),
			'chargeforms_manage_forms',
			'chargeforms-reports',
			[ $this, 'render' ]
		);
	}

	private function current_subtab() {
		$tab = isset( $_GET['tab'] ) ? sanitize_key( wp_unslash( $_GET['tab'] ) ) : 'overview'; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
		return in_array( $tab, self::SUBTABS, true ) ? $tab : 'overview';
	}

	/**
	 * Same preset resolution used on Entries/Forms — default here is
	 * 'last_month' to match the real Reports screen's default filter.
	 *
	 * roadmap issue #27 ("Date Handling Mixes GMT and Site Time"): `$today`
	 * must be computed in GMT, not site-local time, because every actual
	 * date-range comparison this resolves into (Entry::for_form()'s
	 * date_from/date_to filters, Form_Start's counts) is built with
	 * gmdate() against `created_at` columns whose value comes from
	 * MySQL's own CURRENT_TIMESTAMP default — a site-local "today" from
	 * current_time('Y-m-d') would silently shift which entries fall in
	 * "today"/"this week"/etc. by the site's UTC offset, worse the further
	 * a site's timezone is from UTC.
	 */
	private function resolve_date_preset( $preset, $custom_from, $custom_to ) {
		$today = current_time( 'Y-m-d', true );
		switch ( $preset ) {
			case 'today':
				return [ $today, $today ];
			case 'yesterday':
				$y = gmdate( 'Y-m-d', strtotime( $today . ' -1 day' ) );
				return [ $y, $y ];
			case 'last_week':
				return [ gmdate( 'Y-m-d', strtotime( $today . ' -7 days' ) ), $today ];
			// the reference product's real Reports date-range quick-select (DateRangeControls.vue)
			// also offers 3/6-month and 1-year presets — ChargeForms previously
			// stopped at "Last month", a real parity gap for anyone reviewing a
			// longer trend than 30 days.
			case 'last_3_months':
				return [ gmdate( 'Y-m-d', strtotime( $today . ' -90 days' ) ), $today ];
			case 'last_6_months':
				return [ gmdate( 'Y-m-d', strtotime( $today . ' -182 days' ) ), $today ];
			case 'last_year':
				return [ gmdate( 'Y-m-d', strtotime( $today . ' -365 days' ) ), $today ];
			case 'custom':
				return [ $custom_from, $custom_to ];
			case 'all':
				return [ '', '' ];
			default: // 'last_month'
				return [ gmdate( 'Y-m-d', strtotime( $today . ' -30 days' ) ), $today ];
		}
	}

	/**
	 * Returns the equal-length window immediately before the given range,
	 * used for period-over-period change badges. When no real range is
	 * active (e.g. "All time"), returns [ '', '' ] so callers can skip
	 * the comparison.
	 */
	private function prior_period( $date_from, $date_to ) {
		if ( ! $date_from || ! $date_to ) {
			return [ '', '' ];
		}
		$days     = max( 1, ( strtotime( $date_to ) - strtotime( $date_from ) ) / DAY_IN_SECONDS + 1 );
		$prior_to = gmdate( 'Y-m-d', strtotime( $date_from . ' -1 day' ) );
		return [ gmdate( 'Y-m-d', strtotime( $prior_to . ' -' . ( $days - 1 ) . ' days' ) ), $prior_to ];
	}

	public function render() {
		$subtab      = $this->current_subtab();
		$forms       = Form::all();
		$form_id     = isset( $_GET['form_id'] ) ? (int) $_GET['form_id'] : 0; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
		$date_preset = isset( $_GET['date_preset'] ) ? sanitize_key( wp_unslash( $_GET['date_preset'] ) ) : 'last_month'; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
		list( $date_from, $date_to ) = $this->resolve_date_preset(
			$date_preset,
			isset( $_GET['date_from'] ) ? sanitize_text_field( wp_unslash( $_GET['date_from'] ) ) : '', // phpcs:ignore WordPress.Security.NonceVerification.Recommended
			isset( $_GET['date_to'] ) ? sanitize_text_field( wp_unslash( $_GET['date_to'] ) ) : '' // phpcs:ignore WordPress.Security.NonceVerification.Recommended
		);
		?>
		<div class="wrap chargeforms-wrap chargeforms-reports-wrap">
			<?php Page_Header::render( 'chargeforms-reports' ); ?>
			<h1 class="screen-reader-text"><?php esc_html_e( 'Reports', 'chargeforms' ); ?></h1>
			<div class="chargeforms-page-head chargeforms-reports-page-head">
				<div class="chargeforms-page-head-text">
					<h1><?php esc_html_e( 'Reports', 'chargeforms' ); ?></h1>
					<p class="chargeforms-page-head-sub"><?php
						printf(
							/* translators: 1: start date, 2: end date */
							esc_html__( 'All forms · %1$s – %2$s', 'chargeforms' ),
							esc_html( date_i18n( 'M j, Y', strtotime( $date_from ) ) ),
							esc_html( date_i18n( 'M j, Y', strtotime( $date_to ) ) )
						);
					?></p>
				</div>
			</div>

			<div id="chargeforms-ajax-region">

			<div class="chargeforms-underline-tabs chargeforms-reports-subtabs">
				<a class="<?php echo 'overview' === $subtab ? 'is-active' : ''; ?>" href="<?php echo esc_url( admin_url( 'admin.php?page=chargeforms-reports&tab=overview' ) ); ?>"><?php esc_html_e( 'Overview', 'chargeforms' ); ?></a>
				<a class="<?php echo 'payments' === $subtab ? 'is-active' : ''; ?>" href="<?php echo esc_url( admin_url( 'admin.php?page=chargeforms-reports&tab=payments' ) ); ?>"><?php esc_html_e( 'Payments', 'chargeforms' ); ?></a>
				<a class="<?php echo 'submissions' === $subtab ? 'is-active' : ''; ?>" href="<?php echo esc_url( admin_url( 'admin.php?page=chargeforms-reports&tab=submissions' ) ); ?>"><?php esc_html_e( 'Submissions', 'chargeforms' ); ?></a>
			</div>

			<?php
			// Real bug found auditing against the reference product's actual Reports/App.vue:
			// each tab there has its own description ("A brief look at your
			// overall form performance" / "...at all payments" / "...at
			// submission performance") — this used to hardcode the Overview
			// copy under every tab, including Payments and Submissions.
			$subtab_descriptions = [
				'overview'    => __( 'A brief look at your overall form performance', 'chargeforms' ),
				'payments'    => __( 'A brief look at all payments', 'chargeforms' ),
				'submissions' => __( 'A brief look at submission performance', 'chargeforms' ),
			];
			?>
			<div class="chargeforms-reports-filterbar">
				<div>
					<h2 class="chargeforms-reports-heading"><?php echo esc_html( ucfirst( $subtab ) ); ?></h2>
					<p class="description"><?php echo esc_html( $subtab_descriptions[ $subtab ] ); ?></p>
				</div>
				<form method="get" class="chargeforms-reports-filters">
					<input type="hidden" name="page" value="chargeforms-reports">
					<input type="hidden" name="tab" value="<?php echo esc_attr( $subtab ); ?>">
					<select name="form_id" onchange="this.form.submit()">
						<option value="0"><?php esc_html_e( 'All Forms', 'chargeforms' ); ?></option>
						<?php foreach ( $forms as $form ) : ?>
							<option value="<?php echo (int) $form['id']; ?>" <?php selected( $form_id, $form['id'] ); ?>><?php echo esc_html( $form['title'] ); ?></option>
						<?php endforeach; ?>
					</select>
					<select name="date_preset" id="chargeforms-reports-date-preset" onchange="document.getElementById('chargeforms-reports-custom-range').style.display = ('custom' === this.value) ? '' : 'none'; if ('custom' !== this.value) { this.form.submit(); }">
						<option value="today" <?php selected( $date_preset, 'today' ); ?>><?php esc_html_e( 'Today', 'chargeforms' ); ?></option>
						<option value="yesterday" <?php selected( $date_preset, 'yesterday' ); ?>><?php esc_html_e( 'Yesterday', 'chargeforms' ); ?></option>
						<option value="last_week" <?php selected( $date_preset, 'last_week' ); ?>><?php esc_html_e( 'Last 7 days', 'chargeforms' ); ?></option>
						<option value="last_month" <?php selected( $date_preset, 'last_month' ); ?>><?php esc_html_e( 'Last month', 'chargeforms' ); ?></option>
						<?php // Matches the reference product's real DateRangeControls.vue preset list exactly from this point — a real parity gap ChargeForms previously stopped short of (see resolve_date_preset()). ?>
						<option value="last_3_months" <?php selected( $date_preset, 'last_3_months' ); ?>><?php esc_html_e( 'Last 3 months', 'chargeforms' ); ?></option>
						<option value="last_6_months" <?php selected( $date_preset, 'last_6_months' ); ?>><?php esc_html_e( 'Last 6 months', 'chargeforms' ); ?></option>
						<option value="last_year" <?php selected( $date_preset, 'last_year' ); ?>><?php esc_html_e( 'Last Year', 'chargeforms' ); ?></option>
						<option value="all" <?php selected( $date_preset, 'all' ); ?>><?php esc_html_e( 'All time', 'chargeforms' ); ?></option>
						<?php /* the reference product's own date-range controls (DateRangeControls.vue) pair a quick-select dropdown with a real from/to date picker — resolve_date_preset() already had a working 'custom' branch reading $_GET['date_from']/['date_to'], but nothing in the UI ever exposed it. Completing that half-built path rather than leaving it dead code. */ ?>
						<option value="custom" <?php selected( $date_preset, 'custom' ); ?>><?php esc_html_e( 'Custom range', 'chargeforms' ); ?></option>
					</select>
					<span id="chargeforms-reports-custom-range" style="<?php echo 'custom' === $date_preset ? '' : 'display:none;'; ?>">
						<input type="date" name="date_from" value="<?php echo esc_attr( 'custom' === $date_preset ? $date_from : '' ); ?>" max="<?php echo esc_attr( current_time( 'Y-m-d' ) ); ?>">
						<input type="date" name="date_to" value="<?php echo esc_attr( 'custom' === $date_preset ? $date_to : '' ); ?>" max="<?php echo esc_attr( current_time( 'Y-m-d' ) ); ?>">
						<button type="submit" class="button"><?php esc_html_e( 'Apply', 'chargeforms' ); ?></button>
					</span>
					<?php if ( $date_from || $date_to ) : ?>
						<span class="chargeforms-reports-daterange">
							<?php Icon::render( 'calendar-alt' ); ?>
							<?php echo esc_html( date_i18n( 'M j, Y', strtotime( $date_from ) ) . ' – ' . date_i18n( 'M j, Y', strtotime( $date_to ) ) ); ?>
						</span>
					<?php endif; ?>
				</form>
			</div>

			<?php if ( \ChargeForms\Includes\Settings::get( 'disable_form_analytics' ) ) : ?>
				<div class="chargeforms-empty-state">
					<?php Icon::render( 'hidden' ); ?>
					<p><?php esc_html_e( 'Form Analytics is disabled — turn it back on under Global Settings > Miscellaneous to see Reports again.', 'chargeforms' ); ?></p>
				</div>
			<?php else : ?>
				<?php
				switch ( $subtab ) {
					case 'payments':
						$this->render_payments_tab( $date_from, $date_to );
						break;
					case 'submissions':
						$this->render_submissions_tab( $forms, $date_from, $date_to );
						break;
					default:
						$this->render_overview_tab( $form_id, $date_from, $date_to, $forms );
				}
				?>
			<?php endif; ?>
		</div>
		<?php
	}

	private function render_overview_tab( $form_id, $date_from, $date_to, array $forms ) {
		$range_args = array_filter( [
			'form_id'   => $form_id ?: null,
			'date_from' => $date_from ?: null,
			'date_to'   => $date_to ?: null,
			'per_page'  => 1,
		] );

		$total        = Entry::query( $range_args )['total'];
		$series       = Entry::counts_by_day_and_status( 14 );
		$max_daily    = max( 1, ...array_values( $series['total'] ) );
		$total_change = Entry::percent_change( $form_id, $date_from, $date_to );

		// Key Metrics content matches the mockup's own set exactly
		// (Submissions / Form Views / Conversion / Revenue) — a prior
		// version substituted a different set (Spam Blocked/Unread/Created
		// Forms), a real content mismatch, not just styling.
		$views              = \ChargeForms\Includes\Form_Start::count_total( $form_id, $date_from, $date_to, 'view' );
		$views_change       = \ChargeForms\Includes\Form_Start::percent_change( $form_id, $date_from, $date_to, 'view' );
		$conversion         = $views > 0 ? round( ( $total / $views ) * 100, 1 ) : null;
		$revenue            = \ChargeForms\Includes\Entry::payment_total( $date_from, $date_to );

		$starts          = \ChargeForms\Includes\Form_Start::count_total( $form_id, $date_from, $date_to, 'start' );
		$completion_rate = $starts > 0 ? min( 100, round( ( $total / $starts ) * 100 ) ) : null;

		// Conversion and Revenue get the same current-vs-prior-equal-length
		// change badges the Submissions/Views tiles have - the prior period
		// is computed from real data (Entry/Form_Start queries), so all four
		// Key Metrics tiles carry a real badge like the mockup's.
		$conversion_change = null;
		$revenue_change    = null;
		if ( $date_from && $date_to ) {
			list( $prior_from, $prior_to ) = $this->prior_period( $date_from, $date_to );

			$prior_total      = Entry::query( array_filter( [
				'form_id'   => $form_id ?: null,
				'date_from' => $prior_from,
				'date_to'   => $prior_to,
				'per_page'  => 1,
			] ) )['total'];
			$prior_views      = \ChargeForms\Includes\Form_Start::count_total( $form_id, $prior_from, $prior_to, 'view' );
			$prior_conversion = $prior_views > 0 ? ( $prior_total / $prior_views ) * 100 : null;
			$conversion_change = ( null !== $conversion && null !== $prior_conversion && $prior_conversion > 0 )
				? round( ( ( $conversion - $prior_conversion ) / $prior_conversion ) * 100 )
				: null;

			$prior_revenue = Entry::payment_total( $prior_from, $prior_to );
			$revenue_change = $prior_revenue > 0 ? round( ( ( $revenue - $prior_revenue ) / $prior_revenue ) * 100 ) : null;
		}

		$export_url = wp_nonce_url(
			admin_url( 'admin-post.php?action=chargeforms_export_report&form_id=' . $form_id . '&date_from=' . $date_from . '&date_to=' . $date_to ),
			'chargeforms_export_report'
		);
		?>
		<div class="chargeforms-reports-export">
			<a href="<?php echo esc_url( $export_url . '&format=csv' ); ?>" class="button">
				<?php Icon::render( 'media-spreadsheet' ); ?> <?php esc_html_e( 'Export CSV', 'chargeforms' ); ?>
			</a>
			<a href="<?php echo esc_url( $export_url . '&format=json' ); ?>" class="button">
				<?php Icon::render( 'media-code' ); ?> <?php esc_html_e( 'Export JSON', 'chargeforms' ); ?>
			</a>
			<button type="button" class="button" onclick="window.print()">
				<?php Icon::render( 'printer' ); ?> <?php esc_html_e( 'Print Report', 'chargeforms' ); ?>
			</button>
		</div>

		<?php $this->render_category_header( 'bar-chart', __( 'Key Metrics', 'chargeforms' ), __( 'The headline numbers for this period.', 'chargeforms' ), 'primary' ); ?>
		<?php
			// Real daily series exists only for Submissions (counts_by_day_and_status());
			// see render_sparkline()'s doc comment for why the other three tiles
			// don't get a fabricated one.
			$submissions_trend = array_values( $series['total'] );
		?>
		<div class="chargeforms-stat-grid chargeforms-stat-grid-4">
			<div class="chargeforms-stat-tile chargeforms-stat-tile--metric is-primary">
				<span class="chargeforms-stat-icon is-primary"><?php echo wp_kses( self::icon_svg( 'send' ), Icon::allowed_svg_html() ); ?></span>
				<span class="chargeforms-stat-label"><?php esc_html_e( 'Submissions', 'chargeforms' ); ?></span>
				<span class="chargeforms-stat-number"><?php echo (int) $total; ?></span>
				<?php $this->render_change_badge( $total_change ); ?>
			</div>
			<div class="chargeforms-stat-tile chargeforms-stat-tile--metric is-info">
				<span class="chargeforms-stat-icon is-info"><?php echo wp_kses( self::icon_svg( 'eye' ), Icon::allowed_svg_html() ); ?></span>
				<span class="chargeforms-stat-label"><?php esc_html_e( 'Form Views', 'chargeforms' ); ?></span>
				<span class="chargeforms-stat-number"><?php echo (int) $views; ?></span>
				<?php $this->render_change_badge( $views_change ); ?>
			</div>
			<div class="chargeforms-stat-tile chargeforms-stat-tile--metric is-success">
				<span class="chargeforms-stat-icon is-success"><?php echo wp_kses( self::icon_svg( 'trending-up' ), Icon::allowed_svg_html() ); ?></span>
				<span class="chargeforms-stat-label"><?php esc_html_e( 'Conversion', 'chargeforms' ); ?></span>
				<span class="chargeforms-stat-number"><?php echo null === $conversion ? '-' : esc_html( $conversion . '%' ); ?></span>
				<?php $this->render_change_badge( $conversion_change ); ?>
			</div>
			<div class="chargeforms-stat-tile chargeforms-stat-tile--metric is-warning">
				<span class="chargeforms-stat-icon is-warning"><?php echo wp_kses( self::icon_svg( 'dollar-sign' ), Icon::allowed_svg_html() ); ?></span>
				<span class="chargeforms-stat-label"><?php esc_html_e( 'Revenue', 'chargeforms' ); ?></span>
				<span class="chargeforms-stat-number"><?php echo esc_html( number_format_i18n( $revenue, 2 ) ); ?></span>
				<?php $this->render_change_badge( $revenue_change ); ?>
			</div>
		</div>


		<?php $this->render_category_header( 'trending-up', __( 'Submission Trends', 'chargeforms' ), __( 'Volume over time, and how far visitors get before submitting.', 'chargeforms' ), 'teal' ); ?>
		<div class="chargeforms-card chargeforms-card-trend">
				<?php if ( 0 === array_sum( $series['total'] ) ) : ?>
					<div class="chargeforms-empty-state"><?php Icon::render( 'chart-bar' ); ?><p><?php esc_html_e( 'No Submission Data Available', 'chargeforms' ); ?></p></div>
				<?php else : ?>
					<?php
					// Coded straight from the design source (design_handoff_
					// chargeforms/ChargeForms Screens.dc.html, `isReports` →
					// the Submission Trends card): one solid violet bar per
					// day, 4px top radius, 180px plot height, 5px gaps, and a
					// day label only every 3rd column. The design has no
					// gridlines, no legend and no title inside this card — the
					// "Submission Trends" category header above it is the
					// title — so all three are gone from here rather than
					// carried over from an earlier pass that added them.
					//
					// The per-status split (read/unread/pending) that the
					// stacked version used to show visually is preserved in
					// each bar's own tooltip, so no real information is lost
					// by matching the design's single-series bar.
					$day_index = 0;
					?>
					<div class="chargeforms-bar-chart">
						<?php foreach ( $series['total'] as $day => $count ) : ?>
							<?php
							$tooltip = sprintf(
								/* translators: 1: date, 2: total count, 3: read count, 4: unread count, 5: pending count */
								__( '%1$s — %2$s submissions (%3$s read · %4$s unread · %5$s pending)', 'chargeforms' ),
								date_i18n( 'M j', strtotime( $day ) ),
								number_format_i18n( $count ),
								number_format_i18n( $series['read'][ $day ] ),
								number_format_i18n( $series['unread'][ $day ] ),
								number_format_i18n( $series['pending'][ $day ] )
							);
							?>
							<div class="chargeforms-bar-col" data-tooltip="<?php echo esc_attr( $tooltip ); ?>">
								<div class="chargeforms-bar" style="height: <?php echo esc_attr( max( 2, round( ( $count / $max_daily ) * 100 ) ) ); ?>%;"></div>
								<span class="chargeforms-bar-label"><?php echo 0 === $day_index % 3 ? esc_html( date_i18n( 'j', strtotime( $day ) ) ) : ''; ?></span>
							</div>
							<?php $day_index++; ?>
						<?php endforeach; ?>
					</div>
				<?php endif; ?>
		</div>

		<div class="chargeforms-reports-columns">
			<?php $this->render_completion_rate_card( $completion_rate, $starts, $total ); ?>
			<?php $this->render_country_card( $form_id, $date_from, $date_to ); ?>
		</div>

		<?php $this->render_category_header( 'users', __( 'Audience Insights', 'chargeforms' ), __( 'Who is submitting, and from what kind of device.', 'chargeforms' ), 'purple' ); ?>
		<div class="chargeforms-reports-columns">
			<?php $this->render_device_card( $form_id, $date_from, $date_to ); ?>
			<?php $this->render_browser_card( $form_id, $date_from, $date_to ); ?>
		</div>

		<?php $this->render_category_header( 'clock', __( 'Activity Patterns', 'chargeforms' ), __( 'When submissions actually come in, by day and hour.', 'chargeforms' ), 'indigo' ); ?>
		<?php $this->render_timeline_card( $form_id, $date_from, $date_to ); ?>

		<?php $this->render_category_header( 'trophy', __( 'Performance', 'chargeforms' ), __( 'Which forms are actually converting.', 'chargeforms' ), 'amber' ); ?>
		<div class="chargeforms-card">
			<h2><?php esc_html_e( 'Top Performing Forms', 'chargeforms' ); ?></h2>
			<?php $this->render_top_forms( $forms, $date_from, $date_to ); ?>
		</div>

		<?php $this->render_category_header( 'list', __( 'Field Analytics', 'chargeforms' ), __( 'Every chartable field on the form, shown at once.', 'chargeforms' ), 'blue' ); ?>
		<?php $this->render_field_analytics( $form_id, $forms ); ?>

		<?php $this->render_category_header( 'shield', __( 'Integration Deliveries', 'chargeforms' ), __( 'How outbound integrations — Slack, webhooks, and the rest — performed.', 'chargeforms' ), 'green' ); ?>
		<?php $this->render_integration_deliveries_card(); ?>
		<?php
	}

	/**
	 * "API Logs" (the reference product parity — its Reports screen has a Success/
	 * Processing/Failed time series for outbound integration calls;
	 * ChargeForms's own Reports didn't have an equivalent). Built from real
	 * data that already existed (Includes\Api_Log, which every integration
	 * class already writes to) rather than adding new logging — see
	 * Api_Log::counts_by_day_and_result()'s own doc comment for the
	 * success/failed derivation and the 500-row pruning caveat. Deliberately
	 * NOT scoped by the Overview tab's own form/date-range filters: API Logs
	 * has no `date_to` upper bound of its own in the underlying table query
	 * (only a rolling "last N days" window, same as Submission Trends), and
	 * scoping by form would undercount site-wide integrations like the
	 * global Webhook default that aren't tied to one form.
	 */
	private function render_integration_deliveries_card() {
		$series    = \ChargeForms\Includes\Api_Log::counts_by_day_and_result( 14 );
		$max_daily = max( 1, ...array_values( $series['total'] ) );
		?>
		<div class="chargeforms-card chargeforms-card-trend">
			<?php if ( 0 === array_sum( $series['total'] ) ) : ?>
				<div class="chargeforms-empty-state"><?php Icon::render( 'chart-bar' ); ?><p><?php esc_html_e( 'No integration deliveries in this period.', 'chargeforms' ); ?></p></div>
			<?php else : ?>
				<?php $day_index = 0; ?>
				<div class="chargeforms-bar-chart">
					<?php foreach ( $series['total'] as $day => $count ) : ?>
						<?php
						$tooltip = sprintf(
							/* translators: 1: date, 2: total count, 3: success count, 4: failed count */
							__( '%1$s — %2$s deliveries (%3$s succeeded · %4$s failed)', 'chargeforms' ),
							date_i18n( 'M j', strtotime( $day ) ),
							number_format_i18n( $count ),
							number_format_i18n( $series['success'][ $day ] ),
							number_format_i18n( $series['failed'][ $day ] )
						);
						?>
						<div class="chargeforms-bar-col" data-tooltip="<?php echo esc_attr( $tooltip ); ?>">
							<div class="chargeforms-bar<?php echo $series['failed'][ $day ] > 0 ? ' chargeforms-bar--has-failures' : ''; ?>" style="height: <?php echo esc_attr( max( 2, round( ( $count / $max_daily ) * 100 ) ) ); ?>%;"></div>
							<span class="chargeforms-bar-label"><?php echo 0 === $day_index % 3 ? esc_html( date_i18n( 'j', strtotime( $day ) ) ) : ''; ?></span>
						</div>
						<?php $day_index++; ?>
					<?php endforeach; ?>
				</div>
			<?php endif; ?>
		</div>
		<?php
	}

	/**
	 * Hand-drawn line-style icon set (24x24, stroke=currentColor) used across
	 * Reports instead of the WP-core dashicon glyphs — dashicons read as
	 * generic wp-admin chrome everywhere else in this plugin (menus, list
	 * table row actions), so reusing them here made every "premium" stat
	 * tile/category header look like a stock admin screen rather than a
	 * distinct report surface. currentColor means the existing semantic
	 * color classes (is-primary/is-danger/is-warning/is-neutral) still work
	 * unchanged — only the glyph itself changed, not the color system.
	 */
	private static function icon_svg( $name ) {
		$paths = [
			'bar-chart'   => '<rect x="4" y="10" width="4" height="10" rx="1"/><rect x="10" y="5" width="4" height="15" rx="1"/><rect x="16" y="13" width="4" height="7" rx="1"/>',
			'shield'      => '<path d="M12 3.5l6.5 2.6v4.9c0 4.6-2.8 7.9-6.5 9.5-3.7-1.6-6.5-4.9-6.5-9.5V6.1L12 3.5z"/><path d="M9 12l2 2 4-4.5"/>',
			'inbox'       => '<path d="M4 12h4l1.8 2.5h4.4L16 12h4"/><path d="M4.8 12 6 6.3A1 1 0 0 1 7 5.5h10a1 1 0 0 1 1 .8L19.2 12"/><path d="M4 12v5.5a1 1 0 0 0 1 1h14a1 1 0 0 0 1-1V12"/>',
			'document'    => '<path d="M7.5 3.5h6l4 4v13h-10z"/><path d="M13.5 3.5v4h4"/><path d="M9.5 12.5h5M9.5 15.8h5"/>',
			'trending-up'   => '<path d="M4 16.5l5-5 3.5 3.5L19.5 7"/><path d="M14.5 7h5v5"/>',
			'trending-down' => '<path d="M4 7l5 5 3.5-3.5L19.5 17"/><path d="M14.5 17h5v-5"/>',
			'trophy'      => '<path d="M7 4h10v3.5a5 5 0 0 1-10 0V4z"/><path d="M7 5H4.5a2.5 2.5 0 0 0 2.5 3.3M17 5h2.5a2.5 2.5 0 0 1-2.5 3.3"/><path d="M12 12.5v3"/><path d="M9 20h6"/><path d="M9.6 20a2.4 2.4 0 0 1 4.8 0"/>',
			'users'       => '<circle cx="9" cy="8.3" r="2.8"/><path d="M3.5 20c0-3.3 2.5-6 6-6s6 2.7 6 6"/><circle cx="17" cy="9.5" r="2.2"/><path d="M15.6 14.3a4.6 4.6 0 0 1 5 5.7"/>',
			'clock'       => '<circle cx="12" cy="12" r="8.5"/><path d="M12 7.5V12l3.2 2"/>',
			'check-ring'  => '<circle cx="12" cy="12" r="8.5"/><path d="M8.3 12.3l2.4 2.4 5-5.4"/>',
			'money'       => '<rect x="3.5" y="6.5" width="17" height="11" rx="2"/><circle cx="12" cy="12" r="2.3"/><path d="M6.5 9v0M17.5 15v0"/>',
			'list'        => '<path d="M8 6.5h12M8 12h12M8 17.5h12"/><path d="M4 6.5v0M4 12v0M4 17.5v0" stroke-width="3"/>',
		];
		return '<svg class="chargeforms-icon-svg" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round">' . ( $paths[ $name ] ?? $paths['bar-chart'] ) . '</svg>';
	}

	/**
	 * Renders a Key Metrics stat tile's trend sparkline as a real
	 * polyline over $values (chronological order) — approved-redesign
	 * detail, but only drawn where a real daily series backs it
	 * (Submissions has one via counts_by_day_and_status(); Form Views/
	 * Conversion/Revenue don't have a daily series computed anywhere in
	 * this codebase, so no sparkline is faked for them rather than
	 * inventing numbers to fill the shape).
	 */
	private function render_sparkline( array $values, $color ) {
		$values = array_values( $values );
		$count  = count( $values );
		if ( $count < 2 ) {
			return;
		}
		$width  = 64;
		$height = 26;
		$max    = max( 1, ...$values );
		$min    = min( $values );
		$range  = max( 1, $max - $min );
		$points = [];
		foreach ( $values as $i => $v ) {
			$x        = round( ( $i / ( $count - 1 ) ) * $width, 1 );
			$y        = round( $height - ( ( $v - $min ) / $range ) * ( $height - 4 ) - 2, 1 );
			$points[] = "{$x} {$y}";
		}
		printf(
			'<svg width="%1$d" height="%2$d" viewBox="0 0 %1$d %2$d" class="chargeforms-stat-spark"><path d="M%3$s" fill="none" stroke="%4$s" stroke-width="2" stroke-linecap="round" stroke-linejoin="round"/></svg>',
			(int) $width,
			(int) $height,
			esc_attr( implode( ' L', $points ) ),
			esc_attr( $color )
		);
	}

	/**
	 * A labeled section header — grouping the report widgets below it by
	 * what they're actually about (trends, performance, audience,
	 * timing) instead of one undifferentiated stack of cards. Each
	 * category gets its own accent color so the sections read as visually
	 * distinct at a glance, not just separated by a text label.
	 */
	/**
	 * Restored the icon chip the mockup's own "Key Metrics"/"Submission
	 * Trends" section headers actually use (30x30, 8px radius, ~10%-opacity
	 * accent tint, icon in the solid accent color) — a prior pass dropped
	 * this in favor of "the reference product's real" plain-text-with-underline heading,
	 * which is the wrong authority per the .dc.html-over-everything-else
	 * rule. Colors for the two mockup-confirmed accents (primary, teal)
	 * are exact matches; amber/purple/indigo back this plugin's own extra
	 * category headers (Performance/Audience/Activity) that group cards
	 * beyond what the mockup itself splits out, so those three are a
	 * reasonable extension of the same system rather than a sourced value.
	 */
	private function render_category_header( $icon, $title, $description = '', $accent = 'primary' ) {
		$colors = [
			'primary' => '#6c4ef5',
			'teal'    => '#00b27f',
			'amber'   => '#fcbe2d',
			'purple'  => '#8b5cf6',
			'indigo'  => '#6366f1',
			'blue'    => '#1a7efb',
			'green'   => '#00a86b',
		];
		$color = $colors[ $accent ] ?? $colors['primary'];
		?>
		<div class="chargeforms-reports-category">
			<span class="chargeforms-reports-category-icon" style="background:<?php echo esc_attr( $color ); ?>1a;color:<?php echo esc_attr( $color ); ?>;"><?php echo wp_kses( self::icon_svg( $icon ), Icon::allowed_svg_html() ); ?></span>
			<span>
				<h2 class="chargeforms-reports-category-title"><?php echo esc_html( $title ); ?></h2>
				<?php if ( $description ) : ?>
					<p class="chargeforms-reports-category-desc"><?php echo esc_html( $description ); ?></p>
				<?php endif; ?>
			</span>
		</div>
		<?php
	}

	private function render_change_badge( $change ) {
		if ( null === $change ) {
			echo '<span class="chargeforms-stat-change is-flat">&middot; ' . esc_html__( 'No prior period', 'chargeforms' ) . '</span>';
			return;
		}
		$is_up = $change >= 0;
		printf(
			'<span class="chargeforms-stat-change %s">%s %s%%</span>',
			esc_attr( $is_up ? 'is-up' : 'is-down' ),
			wp_kses( self::icon_svg( $is_up ? 'trending-up' : 'trending-down' ), Icon::allowed_svg_html() ),
			esc_html( ( $is_up ? '+' : '' ) . $change )
		);
	}

	/**
	 * Completion Rate - a real submitted-vs-started ratio, not a
	 * placeholder. "Starts" come from Form_Start (see class-form-start.php
	 * and the tracking snippet in class-shortcode.php), a real signal
	 * recorded the first time a visitor actually interacts with a field -
	 * distinct from a plain page view.
	 */
	private function render_completion_rate_card( $rate, $starts, $submissions ) {
		// Horizontal bar (matches the design handoff: a 40px violet rate,
		// a 10px track/fill, and started/submitted counts beneath), not a
		// semi-circle gauge. The rate stays a real submitted-vs-started
		// ratio from Form_Start tracking, never a view-count guess.
		?>
		<div class="chargeforms-card">
			<h2><?php esc_html_e( 'Completion Rate', 'chargeforms' ); ?></h2>
			<p class="chargeforms-form-row-desc" style="margin:0 0 16px;"><?php esc_html_e( 'From real form-start tracking, not view counts.', 'chargeforms' ); ?></p>
			<?php if ( null === $rate ) : ?>
				<div class="chargeforms-empty-state">
					<?php Icon::render( 'chart-area' ); ?>
					<p><?php esc_html_e( 'No one has started filling out a form yet in this period - starts are tracked the moment a visitor interacts with a field, not just loads the page.', 'chargeforms' ); ?></p>
				</div>
			<?php else : ?>
				<div class="chargeforms-completion-body">
					<div class="chargeforms-completion-pct"><?php echo (int) $rate; ?>%</div>
					<div class="chargeforms-completion-track-wrap">
						<div class="chargeforms-completion-track">
							<div class="chargeforms-completion-fill" style="width: <?php echo (int) $rate; ?>%;"></div>
						</div>
						<div class="chargeforms-completion-counts">
							<span><?php
							/* translators: %1$s: number of form starts, formatted with thousands separators */
							printf( esc_html__( '%1$s started', 'chargeforms' ), esc_html( number_format_i18n( $starts ) ) );
							?></span>
							<span><?php
							/* translators: %1$s: number of form submissions, formatted with thousands separators */
							printf( esc_html__( '%1$s submitted', 'chargeforms' ), esc_html( number_format_i18n( $submissions ) ) );
							?></span>
						</div>
					</div>
				</div>
				<div class="chargeforms-completion-note">
					<?php esc_html_e( 'Free in ChargeForms - this metric is Pro-gated in comparable plugins.', 'chargeforms' ); ?>
				</div>
			<?php endif; ?>
		</div>
		<?php
	}
	/**
	 * Submissions By Country — derived from each form's own Country List
	 * field answers (see Entry::country_breakdown()), not IP geolocation;
	 * ChargeForms has no GeoIP database or service to call, so this is the
	 * honest version of this report rather than a faked map.
	 */
	private function render_country_card( $form_id, $date_from, $date_to ) {
		$counts     = Entry::country_breakdown( $form_id, $date_from, $date_to );
		$top        = array_slice( $counts, 0, 8, true );
		$max_count  = max( 1, ...array_values( $top ?: [ 0 ] ) );
		?>
		<div class="chargeforms-card chargeforms-country-card">
			<h2><?php esc_html_e( 'Submissions By Country', 'chargeforms' ); ?></h2>
			<?php if ( ! empty( $top ) ) : ?>
				<div class="chargeforms-country-scale">
					<span><?php esc_html_e( 'Fewer', 'chargeforms' ); ?></span>
					<span class="chargeforms-country-scale-bar"></span>
					<span><?php esc_html_e( 'More', 'chargeforms' ); ?></span>
				</div>
			<?php endif; ?>
			<?php if ( empty( $top ) ) : ?>
				<div class="chargeforms-empty-state chargeforms-empty-state-compact">
					<?php Icon::render( 'admin-site-alt3' ); ?>
					<p><?php esc_html_e( 'No data yet.', 'chargeforms' ); ?></p>
					<p class="chargeforms-empty-state-hint"><?php esc_html_e( 'Add a Country List field to a form to see submissions broken down here — based on what visitors actually select, not IP geolocation.', 'chargeforms' ); ?></p>
				</div>
			<?php else : ?>
				<div class="chargeforms-hbar-chart">
					<?php foreach ( $top as $country => $count ) : ?>
						<div class="chargeforms-hbar-row">
							<span class="chargeforms-hbar-label" title="<?php echo esc_attr( $country ); ?>"><?php echo esc_html( $country ); ?></span>
							<div class="chargeforms-hbar-track">
								<div class="chargeforms-hbar-fill" style="width: <?php echo esc_attr( max( 3, round( ( $count / $max_count ) * 100 ) ) ); ?>%;"></div>
							</div>
							<span class="chargeforms-hbar-count"><?php echo (int) $count; ?></span>
						</div>
					<?php endforeach; ?>
				</div>
			<?php endif; ?>
		</div>
		<?php
	}

	/**
	 * Device Breakdown — a genuinely new report, not one of the three
	 * originally requested, added because the data was already sitting
	 * right there: every entry already stores the submitter's user_agent
	 * (captured for the double opt-in flow), so this needed no new
	 * tracking to become real either.
	 */
	private function render_device_card( $form_id, $date_from, $date_to ) {
		$counts    = Entry::device_breakdown( $form_id, $date_from, $date_to );
		arsort( $counts );
		$max_count = max( 1, ...array_values( $counts ?: [ 0 ] ) );
		$icons     = [ 'Desktop' => 'monitor', 'Mobile' => 'smartphone', 'Tablet' => 'tablet' ];
		?>
		<div class="chargeforms-card">
			<h2><?php esc_html_e( 'Device Breakdown', 'chargeforms' ); ?></h2>
			<?php if ( empty( $counts ) ) : ?>
				<div class="chargeforms-empty-state chargeforms-empty-state-compact">
					<?php Icon::render( 'smartphone' ); ?>
					<p><?php esc_html_e( 'No submissions yet for the selected period.', 'chargeforms' ); ?></p>
				</div>
			<?php else : ?>
				<div class="chargeforms-device-list chargeforms-device-list--device">
					<?php foreach ( $counts as $device => $count ) : ?>
						<div class="chargeforms-device-row">
							<?php Icon::render( $icons[ $device ] ?? 'monitor', 16, 'chargeforms-device-icon' ); ?>
							<span class="chargeforms-device-label"><?php echo esc_html( $device ); ?></span>
							<div class="chargeforms-hbar-track">
								<div class="chargeforms-hbar-fill" style="width: <?php echo esc_attr( max( 3, round( ( $count / $max_count ) * 100 ) ) ); ?>%;"></div>
							</div>
							<span class="chargeforms-hbar-count"><?php echo (int) $count; ?></span>
						</div>
					<?php endforeach; ?>
				</div>
			<?php endif; ?>
		</div>
		<?php
	}

	/**
	 * Browser Breakdown — same "the data was already sitting right there"
	 * reasoning as the Device card right above (Entry::browser_breakdown()),
	 * and the real gap the reference product-fidelity audit flagged: only device
	 * family was broken out, no separate browser-family report existed.
	 */
	private function render_browser_card( $form_id, $date_from, $date_to ) {
		$counts    = Entry::browser_breakdown( $form_id, $date_from, $date_to );
		arsort( $counts );
		$max_count = max( 1, ...array_values( $counts ?: [ 0 ] ) );
		?>
		<div class="chargeforms-card">
			<h2><?php esc_html_e( 'Browser Breakdown', 'chargeforms' ); ?></h2>
			<?php if ( empty( $counts ) ) : ?>
				<div class="chargeforms-empty-state chargeforms-empty-state-compact">
					<?php Icon::render( 'admin-site-alt3' ); ?>
					<p><?php esc_html_e( 'No submissions yet for the selected period.', 'chargeforms' ); ?></p>
				</div>
			<?php else : ?>
				<div class="chargeforms-device-list chargeforms-device-list--browser">
					<?php foreach ( $counts as $browser => $count ) : ?>
						<div class="chargeforms-device-row">
							<?php Icon::render( 'globe', 16, 'chargeforms-device-icon' ); ?>
							<span class="chargeforms-device-label"><?php echo esc_html( $browser ); ?></span>
							<div class="chargeforms-hbar-track">
								<div class="chargeforms-hbar-fill" style="width: <?php echo esc_attr( max( 3, round( ( $count / $max_count ) * 100 ) ) ); ?>%;"></div>
							</div>
							<span class="chargeforms-hbar-count"><?php echo (int) $count; ?></span>
						</div>
					<?php endforeach; ?>
				</div>
			<?php endif; ?>
		</div>
		<?php
	}

	/**
	 * Submission Timeline Patterns — a real hour-of-day x day-of-week
	 * heatmap computed straight from entries.created_at (see
	 * Entry::submissions_by_hour_and_dow()) — every submission already
	 * has this timestamp, so unlike Completion Rates this needed no new
	 * tracking at all to become real.
	 *
	 * Redesigned away from a 12-column-per-row AM/PM grid: at 26px per
	 * cell that layout needed a horizontal-scroll wrapper, and any
	 * ancestor with overflow-x set (without an explicit overflow-y)
	 * becomes a scroll container that clips the hover tooltip — which is
	 * an absolutely-positioned pseudo-element positioned above the cell,
	 * i.e. outside that ancestor's own painted box. Collapsing the 24
	 * hours into 6 four-hour blocks keeps every row + label comfortably
	 * inside a normal card width, so no scroll wrapper — and therefore no
	 * clipping ancestor — is needed at all.
	 */
	private function render_timeline_card( $form_id, $date_from, $date_to ) {
		$matrix = Entry::submissions_by_hour_and_dow( $form_id, $date_from, $date_to );
		$day_labels = [ __( 'Sun', 'chargeforms' ), __( 'Mon', 'chargeforms' ), __( 'Tue', 'chargeforms' ), __( 'Wed', 'chargeforms' ), __( 'Thu', 'chargeforms' ), __( 'Fri', 'chargeforms' ), __( 'Sat', 'chargeforms' ) ];
		$total  = array_sum( array_map( 'array_sum', $matrix ) );

		$blocks = [
			[ 0, 3 ],
			[ 4, 7 ],
			[ 8, 11 ],
			[ 12, 15 ],
			[ 16, 19 ],
			[ 20, 23 ],
		];

		$block_totals = array_fill( 0, 7, array_fill( 0, count( $blocks ), 0 ) );
		$max          = 1;
		foreach ( $matrix as $dow => $hours ) {
			foreach ( $blocks as $b => $range ) {
				$sum = 0;
				for ( $h = $range[0]; $h <= $range[1]; $h++ ) {
					$sum += $hours[ $h ];
				}
				$block_totals[ $dow ][ $b ] = $sum;
				$max                        = max( $max, $sum );
			}
		}
		?>
		<div class="chargeforms-card chargeforms-card-full">
			<div class="chargeforms-card-head">
				<h2><?php esc_html_e( 'Submission Timeline Patterns', 'chargeforms' ); ?></h2>
			</div>
			<?php if ( 0 === $total ) : ?>
				<div class="chargeforms-empty-state">
					<?php Icon::render( 'chart-area' ); ?>
					<p><?php esc_html_e( 'No submission data available for the selected period.', 'chargeforms' ); ?></p>
				</div>
			<?php else : ?>
				<div class="chargeforms-timeline-heatmap">
					<div class="chargeforms-timeline-hours">
						<span></span>
						<?php foreach ( $blocks as $range ) : ?>
							<span class="chargeforms-timeline-hour-label">
								<?php echo esc_html( date_i18n( 'ga', mktime( $range[0], 0, 0 ) ) . '–' . date_i18n( 'ga', mktime( $range[1] + 1 === 24 ? 0 : $range[1] + 1, 0, 0 ) ) ); ?>
							</span>
						<?php endforeach; ?>
					</div>
					<?php foreach ( $block_totals as $dow => $sums ) : ?>
						<div class="chargeforms-timeline-row">
							<span class="chargeforms-timeline-day-label"><?php echo esc_html( $day_labels[ $dow ] ); ?></span>
							<?php foreach ( $sums as $b => $count ) : ?>
								<?php
								$range     = $blocks[ $b ];
								$intensity = $count > 0 ? max( 0.15, round( ( $count / $max ), 2 ) ) : 0;
								$tooltip   = sprintf(
									/* translators: 1: day, 2: hour range (e.g. "12am–4am"), 3: submission count */
									_n( '%1$s, %2$s — %3$s submission', '%1$s, %2$s — %3$s submissions', $count, 'chargeforms' ),
									$day_labels[ $dow ],
									date_i18n( 'ga', mktime( $range[0], 0, 0 ) ) . '–' . date_i18n( 'ga', mktime( $range[1] + 1 === 24 ? 0 : $range[1] + 1, 0, 0 ) ),
									number_format_i18n( $count )
								);
								?>
								<span
									class="chargeforms-timeline-cell<?php echo $count > 0 ? ' has-value' : ''; ?>"
									<?php
									// Mockup's heat scale is the brand violet family
									// (#f2f2f2 -> #6c4ef5 = rgb(108,78,245)), not blue —
									// this used to shade with rgba(26,115,232,...), a
									// real color-family mismatch, not just a shade off.
									?>
									style="background: rgba(108, 78, 245, <?php echo esc_attr( $intensity ); ?>); animation-delay: <?php echo esc_attr( round( ( $dow * 6 + $b ) * 12 ) ); ?>ms;"
									data-tooltip="<?php echo esc_attr( $tooltip ); ?>"
									aria-label="<?php echo esc_attr( $tooltip ); ?>"
								><?php echo $count > 0 ? esc_html( number_format_i18n( $count ) ) : ''; ?></span>
							<?php endforeach; ?>
						</div>
					<?php endforeach; ?>
				</div>
				<p class="chargeforms-timeline-legend">
					<span class="chargeforms-timeline-legend-label"><?php esc_html_e( 'Low', 'chargeforms' ); ?></span>
					<?php foreach ( [ 0.1, 0.3, 0.5, 0.7, 0.85, 1 ] as $step ) : ?>
						<span class="chargeforms-timeline-legend-swatch" style="background: rgba(108, 78, 245, <?php echo esc_attr( $step ); ?>);"></span>
					<?php endforeach; ?>
					<span class="chargeforms-timeline-legend-label"><?php esc_html_e( 'High', 'chargeforms' ); ?></span>
				</p>
			<?php endif; ?>
		</div>
		<?php
	}

	/**
	 * Views come from Form_Start's 'view' event (recorded server-side the
	 * moment a form actually renders — see class-shortcode.php), a
	 * genuinely different signal from Submissions, not the same number
	 * relabeled. Both toggle states render into the page at once; the
	 * Submissions/Views buttons just swap a CSS class, no reload.
	 */
	private function render_top_forms( array $forms, $date_from, $date_to ) {
		if ( empty( $forms ) ) {
			echo '<div class="chargeforms-empty-state">' . wp_kses( Icon::html( 'bar-chart-3' ), Icon::allowed_svg_html() ) . '<p>' . esc_html__( 'No forms yet.', 'chargeforms' ) . '</p></div>';
			return;
		}

		// roadmap issue #36 ("Reports May Become Expensive on Large Entry
		// Tables"): this used to run Entry::query() + Form_Start::
		// count_for_form() ONCE PER FORM to find the top 5 — two GROUP BY
		// queries covering every form on the site, regardless of how many
		// there are, replaces what used to be 2 * count($forms) queries.
		$form_ids        = array_column( $forms, 'id' );
		$submission_counts = Entry::count_by_form( $form_ids, $date_from, $date_to );
		$view_counts       = \ChargeForms\Includes\Form_Start::count_by_form( $form_ids, 'view', $date_from, $date_to );

		$ranked = array_map( function ( $form ) use ( $submission_counts, $view_counts ) {
			$form['submissions'] = $submission_counts[ $form['id'] ] ?? 0;
			$form['views']       = $view_counts[ $form['id'] ] ?? 0;
			return $form;
		}, $forms );

		usort( $ranked, fn( $a, $b ) => $b['submissions'] <=> $a['submissions'] );
		$ranked = array_slice( $ranked, 0, 5 );

		if ( 0 === array_sum( array_column( $ranked, 'submissions' ) ) && 0 === array_sum( array_column( $ranked, 'views' ) ) ) {
			echo '<div class="chargeforms-empty-state">' . wp_kses( Icon::html( 'bar-chart-3' ), Icon::allowed_svg_html() ) . '<p>' . esc_html__( 'No form data available for the selected period', 'chargeforms' ) . '</p></div>';
			return;
		}

		$max_submissions = max( 1, ...array_column( $ranked, 'submissions' ) );
		$max_views       = max( 1, ...array_column( $ranked, 'views' ) );
		?>
		<div class="chargeforms-toggle-group" id="chargeforms-top-forms-toggle">
			<button type="button" class="is-active" data-metric="submissions"><?php esc_html_e( 'Submissions', 'chargeforms' ); ?></button>
			<button type="button" data-metric="views"><?php esc_html_e( 'Views', 'chargeforms' ); ?></button>
		</div>
		<?php $total_submissions_all = max( 1, array_sum( array_column( $ranked, 'submissions' ) ) ); ?>
		<div class="chargeforms-hbar-chart chargeforms-top-forms-list" id="chargeforms-top-forms-chart">
			<?php foreach ( $ranked as $rank => $form ) : ?>
				<?php
				$total_views_all       = max( 1, array_sum( array_column( $ranked, 'views' ) ) );
				$submissions_tooltip = sprintf(
					/* translators: 1: form title, 2: submission count, 3: percentage of all submissions */
					__( '%1$s — %2$s submissions (%3$d%% of total)', 'chargeforms' ),
					$form['title'],
					number_format_i18n( $form['submissions'] ),
					round( ( $form['submissions'] / $total_submissions_all ) * 100 )
				);
				$views_tooltip = sprintf(
					/* translators: 1: form title, 2: view count, 3: percentage of all views */
					__( '%1$s — %2$s views (%3$d%% of total)', 'chargeforms' ),
					$form['title'],
					number_format_i18n( $form['views'] ),
					round( ( $form['views'] / $total_views_all ) * 100 )
				);
				?>
				<div
					class="chargeforms-hbar-row chargeforms-top-forms-row"
					data-tooltip="<?php echo esc_attr( $submissions_tooltip ); ?>"
					data-tooltip-submissions="<?php echo esc_attr( $submissions_tooltip ); ?>"
					data-tooltip-views="<?php echo esc_attr( $views_tooltip ); ?>"
					data-submissions-pct="<?php echo esc_attr( max( 3, round( ( $form['submissions'] / $max_submissions ) * 100 ) ) ); ?>"
					data-submissions-count="<?php echo (int) $form['submissions']; ?>"
					data-views-pct="<?php echo esc_attr( max( 3, round( ( $form['views'] / $max_views ) * 100 ) ) ); ?>"
					data-views-count="<?php echo (int) $form['views']; ?>"
					style="animation-delay: <?php echo esc_attr( $rank * 60 ); ?>ms;"
				>
					<span class="chargeforms-top-forms-rank chargeforms-top-forms-rank-<?php echo (int) $rank; ?>"><?php echo (int) ( $rank + 1 ); ?></span>
					<a class="chargeforms-hbar-label" href="<?php echo esc_url( admin_url( 'admin.php?page=chargeforms-entries&form_id=' . $form['id'] ) ); ?>"><?php echo esc_html( $form['title'] ); ?></a>
					<div class="chargeforms-hbar-track">
						<div class="chargeforms-hbar-fill" style="width: <?php echo esc_attr( max( 3, round( ( $form['submissions'] / $max_submissions ) * 100 ) ) ); ?>%; animation-delay: <?php echo esc_attr( $rank * 60 + 80 ); ?>ms;"></div>
					</div>
					<span class="chargeforms-hbar-count"><?php echo (int) $form['submissions']; ?></span>
				</div>
			<?php endforeach; ?>
		</div>
		<?php
		wp_add_inline_script( 'chargeforms-admin', "
		( function () {
			var group = document.getElementById( 'chargeforms-top-forms-toggle' );
			var chart = document.getElementById( 'chargeforms-top-forms-chart' );
			if ( ! group || ! chart ) { return; }
			var buttons = group.querySelectorAll( 'button' );
			Array.prototype.forEach.call( buttons, function ( btn ) {
				btn.addEventListener( 'click', function () {
					Array.prototype.forEach.call( buttons, function ( b ) { b.classList.remove( 'is-active' ); } );
					btn.classList.add( 'is-active' );
					var metric = btn.getAttribute( 'data-metric' );
					var rows = chart.querySelectorAll( '.chargeforms-hbar-row' );
					Array.prototype.forEach.call( rows, function ( row ) {
						var pct     = row.getAttribute( 'data-' + metric + '-pct' );
						var count   = row.getAttribute( 'data-' + metric + '-count' );
						var tooltip = row.getAttribute( 'data-tooltip-' + metric );
						row.querySelector( '.chargeforms-hbar-fill' ).style.width = pct + '%';
						row.querySelector( '.chargeforms-hbar-count' ).textContent = count;
						if ( tooltip ) { row.setAttribute( 'data-tooltip', tooltip ); }
					} );
				} );
			} );
		} )();
		" );
	}


	private function render_payments_tab( $date_from, $date_to ) {
		// Real bug found auditing Reports (2026-08-18): this used to call
		// Entry::payment_total() with no gateway filter, silently summing
		// Stripe and PayPal amounts together and labelling the result with
		// the Stripe currency alone - wrong whenever the two gateways are
		// configured with different currencies. Computed per-gateway now;
		// each currency only ever gets summed with itself.
		$stripe_currency = strtoupper( \ChargeForms\Includes\Settings::get( 'stripe_currency', 'usd' ) );
		$paypal_currency = strtoupper( \ChargeForms\Includes\Settings::get( 'paypal_currency', 'usd' ) );
		$stripe_total    = Entry::payment_total( $date_from, $date_to, 'stripe' );
		$paypal_total    = Entry::payment_total( $date_from, $date_to, 'paypal' );
		$result          = Entry::payment_transactions( [ 'date_from' => $date_from, 'date_to' => $date_to, 'per_page' => 1 ] );
		$daily           = Entry::payment_totals_by_day( 14 );
		$max_daily       = max( 0.01, ...array_values( $daily ) );

		$transactions = (int) $result['total'];
		$combined     = $stripe_total + $paypal_total;
		$avg_order    = $transactions > 0 ? $combined / $transactions : 0;

		// Change badges for the flat payment tiles, same current-vs-prior
		// equal-length-period math the Overview Key Metrics use (real data).
		$revenue_change       = null;
		$transactions_change  = null;
		$avg_order_change     = null;
		if ( $date_from && $date_to ) {
			list( $prior_from, $prior_to ) = $this->prior_period( $date_from, $date_to );
			$prior_stripe = Entry::payment_total( $prior_from, $prior_to, 'stripe' );
			$prior_paypal = Entry::payment_total( $prior_from, $prior_to, 'paypal' );
			$prior_total  = $prior_stripe + $prior_paypal;
			$prior_count  = (int) Entry::payment_transactions( [ 'date_from' => $prior_from, 'date_to' => $prior_to, 'per_page' => 1 ] )['total'];
			$prior_avg    = $prior_count > 0 ? $prior_total / $prior_count : 0;

			$revenue_change      = $prior_total > 0 ? round( ( ( $combined - $prior_total ) / $prior_total ) * 100 ) : null;
			$transactions_change = $prior_count > 0 ? round( ( ( $transactions - $prior_count ) / $prior_count ) * 100 ) : null;
			$avg_order_change    = ( $prior_avg > 0 && $avg_order > 0 ) ? round( ( ( $avg_order - $prior_avg ) / $prior_avg ) * 100 ) : null;
		}

		// By-gateway breakdown: real per-gateway transaction counts and
		// amounts (legacy rows COALESCE to Stripe inside payment_*()).
		$gateway_rows = [];
		foreach ( [ 'stripe', 'paypal' ] as $gw ) {
			$gateway_count  = (int) Entry::payment_transactions( [ 'date_from' => $date_from, 'date_to' => $date_to, 'gateway' => $gw, 'per_page' => 1 ] )['total'];
			$gateway_amount = Entry::payment_total( $date_from, $date_to, $gw );
			if ( $gateway_count > 0 ) {
				$gateway_rows[] = [
					'key'    => $gw,
					'label'  => 'stripe' === $gw ? 'STRIPE' : 'PAYPAL',
					'tag'    => 'stripe' === $gw ? '#635bff' : '#003087',
					'amount' => $gateway_amount,
					'currency' => 'stripe' === $gw ? $stripe_currency : $paypal_currency,
					'count'  => $gateway_count,
				];
			}
		}
		$gateway_amounts = array_column( $gateway_rows, 'amount' );
		$gateway_max     = $gateway_amounts ? max( ...$gateway_amounts ) : 1;
		?>
		<div class="chargeforms-stat-grid chargeforms-stat-grid-4">
			<?php if ( $paypal_total > 0 ) : ?>
				<div class="chargeforms-stat-tile chargeforms-stat-tile--metric is-warning">
					<span class="chargeforms-stat-icon is-warning"><?php echo wp_kses( self::icon_svg( 'dollar-sign' ), Icon::allowed_svg_html() ); ?></span>
					<span class="chargeforms-stat-label"><?php esc_html_e( 'Revenue (Stripe)', 'chargeforms' ); ?></span>
					<span class="chargeforms-stat-number"><?php echo esc_html( $stripe_currency . ' ' . number_format_i18n( $stripe_total, 2 ) ); ?></span>
					<?php $this->render_change_badge( $revenue_change ); ?>
				</div>
				<div class="chargeforms-stat-tile chargeforms-stat-tile--metric is-warning">
					<span class="chargeforms-stat-icon is-warning"><?php echo wp_kses( self::icon_svg( 'dollar-sign' ), Icon::allowed_svg_html() ); ?></span>
					<span class="chargeforms-stat-label"><?php esc_html_e( 'Revenue (PayPal)', 'chargeforms' ); ?></span>
					<span class="chargeforms-stat-number"><?php echo esc_html( $paypal_currency . ' ' . number_format_i18n( $paypal_total, 2 ) ); ?></span>
					<?php $this->render_change_badge( $revenue_change ); ?>
				</div>
			<?php else : ?>
				<div class="chargeforms-stat-tile chargeforms-stat-tile--metric is-warning">
					<span class="chargeforms-stat-icon is-warning"><?php echo wp_kses( self::icon_svg( 'dollar-sign' ), Icon::allowed_svg_html() ); ?></span>
					<span class="chargeforms-stat-label"><?php esc_html_e( 'Revenue', 'chargeforms' ); ?></span>
					<span class="chargeforms-stat-number"><?php echo esc_html( $stripe_currency . ' ' . number_format_i18n( $stripe_total, 2 ) ); ?></span>
					<?php $this->render_change_badge( $revenue_change ); ?>
				</div>
			<?php endif; ?>
			<div class="chargeforms-stat-tile chargeforms-stat-tile--metric is-primary">
				<span class="chargeforms-stat-icon is-primary"><?php echo wp_kses( self::icon_svg( 'send' ), Icon::allowed_svg_html() ); ?></span>
				<span class="chargeforms-stat-label"><?php esc_html_e( 'Transactions', 'chargeforms' ); ?></span>
				<span class="chargeforms-stat-number"><?php echo (int) $transactions; ?></span>
				<?php $this->render_change_badge( $transactions_change ); ?>
			</div>
			<div class="chargeforms-stat-tile chargeforms-stat-tile--metric is-info">
				<span class="chargeforms-stat-icon is-info"><?php echo wp_kses( self::icon_svg( 'trending-up' ), Icon::allowed_svg_html() ); ?></span>
				<span class="chargeforms-stat-label"><?php esc_html_e( 'Avg. order', 'chargeforms' ); ?></span>
				<span class="chargeforms-stat-number"><?php echo esc_html( $stripe_currency . ' ' . number_format_i18n( $avg_order, 2 ) ); ?></span>
				<?php $this->render_change_badge( $avg_order_change ); ?>
			</div>
		</div>

		<div class="chargeforms-card">
			<h2><?php esc_html_e( 'Revenue by day', 'chargeforms' ); ?></h2>
			<?php if ( 0.0 === array_sum( $daily ) ) : ?>
				<div class="chargeforms-empty-state"><?php Icon::render( 'chart-bar' ); ?><p><?php esc_html_e( 'No payment data available', 'chargeforms' ); ?></p></div>
			<?php else : ?>
				<?php if ( $paypal_total > 0 ) : ?>
					<p class="description" style="margin: 0 0 12px;"><?php esc_html_e( 'Combined volume across both gateways - see the totals above for a per-gateway, per-currency breakdown.', 'chargeforms' ); ?></p>
				<?php endif; ?>
				<div class="chargeforms-bar-chart">
					<?php foreach ( $daily as $day => $amount ) : ?>
						<div class="chargeforms-bar-col">
							<div class="chargeforms-bar chargeforms-bar--revenue" style="height: <?php echo esc_attr( max( 2, round( ( $amount / $max_daily ) * 100 ) ) ); ?>%;" title="<?php echo esc_attr( date_i18n( 'M j', strtotime( $day ) ) . ' - ' . ( $paypal_total > 0 ? '' : $stripe_currency . ' ' ) . number_format( $amount, 2 ) ); ?>">
								<span class="chargeforms-bar-value"><?php echo esc_html( number_format( $amount, 0 ) ); ?></span>
							</div>
							<span class="chargeforms-bar-label"><?php echo esc_html( date_i18n( 'j', strtotime( $day ) ) ); ?></span>
						</div>
					<?php endforeach; ?>
				</div>
			<?php endif; ?>
		</div>

		<div class="chargeforms-reports-columns">
			<div class="chargeforms-card">
				<h2><?php esc_html_e( 'By gateway', 'chargeforms' ); ?></h2>
				<?php if ( empty( $gateway_rows ) ) : ?>
					<p class="description"><?php esc_html_e( 'No payment data yet.', 'chargeforms' ); ?></p>
				<?php else : ?>
					<div class="chargeforms-device-list">
						<?php foreach ( $gateway_rows as $gw ) : ?>
							<div class="chargeforms-device-row">
								<span class="chargeforms-reports-tag" style="background: <?php echo esc_attr( $gw['tag'] ); ?>;"><?php echo esc_html( $gw['label'] ); ?></span>
								<div class="chargeforms-hbar-track">
									<div class="chargeforms-hbar-fill" style="width: <?php echo esc_attr( max( 3, round( ( $gw['amount'] / $gateway_max ) * 100 ) ) ); ?>%; background: <?php echo esc_attr( $gw['tag'] ); ?>;"></div>
								</div>
								<span class="chargeforms-hbar-count"><?php echo esc_html( $gw['currency'] . ' ' . number_format_i18n( $gw['amount'], 2 ) ); ?></span>
							</div>
						<?php endforeach; ?>
					</div>
				<?php endif; ?>
			</div>
		</div>

		<p class="description">
			<?php
			printf(
				wp_kses_post(
					/* translators: %s: link to the full Payments screen */
					__( 'See individual transactions on the <a href="%s">Payments</a> screen.', 'chargeforms' )
				),
				esc_url( admin_url( 'admin.php?page=chargeforms-payments' ) )
			);
			?>
		</p>
		<?php
	}

	/**
	 * Field Analytics - every chartable field on the selected form at
	 * once, each its own card (label + type chip + distribution bars),
	 * matching the design handoff's Overview Field Analytics section.
	 * One entry fetch tallies every chartable field in a single pass
	 * (Entry::field_value_counts_multi()) instead of a query loop.
	 */
	private function render_field_analytics( $form_id, array $forms ) {
		$chart_form_id    = $form_id ?: ( $forms[0]['id'] ?? 0 );
		$chart_form       = $chart_form_id ? Form::get( $chart_form_id ) : null;
		$chartable_fields = $chart_form ? array_values( array_filter( $chart_form['fields'], function ( $field ) {
			return in_array( $field['type'], [ 'select', 'radio', 'checkbox', 'multi_select', 'multiple_choice', 'country' ], true );
		} ) ) : [];
		$counts_by_field  = ( $chart_form && $chartable_fields )
			? Entry::field_value_counts_multi( $chart_form_id, array_column( $chartable_fields, 'id' ) )
			: [];

		$type_labels = [
			'select'          => __( 'Dropdown', 'chargeforms' ),
			'radio'           => __( 'Radio', 'chargeforms' ),
			'checkbox'        => __( 'Checkbox', 'chargeforms' ),
			'multi_select'    => __( 'Multi-Select', 'chargeforms' ),
			'multiple_choice' => __( 'Multiple Choice', 'chargeforms' ),
			'country'         => __( 'Country', 'chargeforms' ),
		];
		?>
		<?php if ( empty( $chartable_fields ) ) : ?>
			<div class="chargeforms-card">
				<h2><?php esc_html_e( 'Field Analytics', 'chargeforms' ); ?></h2>
				<p class="description"><?php esc_html_e( 'This form has no Dropdown, Radio, Checkbox, or Multi-Select fields to chart.', 'chargeforms' ); ?></p>
			</div>
		<?php else : ?>
			<div class="chargeforms-field-analytics-grid">
				<?php foreach ( $chartable_fields as $field ) : ?>
					<?php
					$field_counts    = $counts_by_field[ $field['id'] ] ?? [];
					$max_field_count = max( 1, ...array_values( $field_counts ?: [ 0 ] ) );
					?>
					<div class="chargeforms-card chargeforms-field-analytics-card">
						<div class="chargeforms-field-analytics-head">
							<span class="chargeforms-field-analytics-label"><?php echo esc_html( $field['label'] ); ?></span>
							<span class="chargeforms-field-analytics-type"><?php echo esc_html( $type_labels[ $field['type'] ] ?? $field['type'] ); ?></span>
						</div>
						<?php if ( empty( $field_counts ) ) : ?>
							<div class="chargeforms-empty-state chargeforms-empty-state-compact"><?php Icon::render( 'chart-bar' ); ?><p><?php esc_html_e( 'No answers recorded for this field yet.', 'chargeforms' ); ?></p></div>
						<?php else : ?>
							<div class="chargeforms-hbar-chart">
								<?php foreach ( $field_counts as $value => $count ) : ?>
									<div class="chargeforms-hbar-row">
										<span class="chargeforms-hbar-label" title="<?php echo esc_attr( $value ); ?>"><?php echo esc_html( $value ); ?></span>
										<div class="chargeforms-hbar-track">
											<div class="chargeforms-hbar-fill" style="width: <?php echo esc_attr( max( 3, round( ( $count / $max_field_count ) * 100 ) ) ); ?>%;"></div>
										</div>
										<span class="chargeforms-hbar-count"><?php echo (int) $count; ?></span>
									</div>
								<?php endforeach; ?>
							</div>
						<?php endif; ?>
					</div>
				<?php endforeach; ?>
			</div>
		<?php endif; ?>
		<?php
	}

	/**
	 * Submissions per form - the design handoff's Submissions sub-tab: a
	 * single table of every form's started / submitted / completion / last
	 * entry for the filtered period (real Form_Start + Entry counts).
	 */
	private function render_submissions_tab( array $forms, $date_from, $date_to ) {
		if ( empty( $forms ) ) {
			echo '<div class="chargeforms-card"><h2>' . esc_html__( 'Submissions per form', 'chargeforms' ) . '</h2><p>' . esc_html__( 'No forms yet.', 'chargeforms' ) . '</p></div>';
			return;
		}

		$form_ids         = array_column( $forms, 'id' );
		$started_by_form  = \ChargeForms\Includes\Form_Start::count_by_form( $form_ids, 'start', $date_from, $date_to );
		$submitted_by_form = Entry::count_by_form( $form_ids, $date_from, $date_to );
		?>
		<div class="chargeforms-card chargeforms-card-reports-submissions">
			<div class="chargeforms-card-head">
				<h2><?php esc_html_e( 'Submissions per form', 'chargeforms' ); ?></h2>
				<p class="chargeforms-form-row-desc" style="margin:0;"><?php esc_html_e( 'Every form volume, completion and last activity in one table.', 'chargeforms' ); ?></p>
			</div>
			<div class="chargeforms-table-scroll">
				<table class="chargeforms-reports-table">
					<thead>
						<tr>
							<th><?php esc_html_e( 'Form', 'chargeforms' ); ?></th>
							<th class="is-right"><?php esc_html_e( 'Started', 'chargeforms' ); ?></th>
							<th class="is-right"><?php esc_html_e( 'Submitted', 'chargeforms' ); ?></th>
							<th class="is-right"><?php esc_html_e( 'Completion', 'chargeforms' ); ?></th>
							<th><?php esc_html_e( 'Last entry', 'chargeforms' ); ?></th>
						</tr>
					</thead>
					<tbody>
						<?php foreach ( $forms as $i => $form ) : ?>
							<?php
							$started     = (int) ( $started_by_form[ $form['id'] ] ?? 0 );
							$submitted   = (int) ( $submitted_by_form[ $form['id'] ] ?? 0 );
							$completion  = $started > 0 ? round( ( $submitted / $started ) * 100, 1 ) : 0;
							$latest      = Entry::query( [ 'form_id' => $form['id'], 'per_page' => 1 ] )['items'][0]['created_at'] ?? '';
							$last_label  = '';
							if ( $latest ) {
								$last_time  = strtotime( $latest );
								$recent_ago = human_time_diff( $last_time, current_time( 'timestamp' ) );
								$last_label = ( time() - $last_time ) < 2 * DAY_IN_SECONDS
									? sprintf( /* translators: %s: human time diff */ __( '%s ago', 'chargeforms' ), $recent_ago )
									: date_i18n( 'M j, H:i', $last_time );
							} else {
								$last_label = __( 'No entries yet', 'chargeforms' );
							}
							?>
							<tr<?php echo 0 === $i % 2 ? '' : ' class="is-zebra"'; ?>>
								<td class="is-form"><?php echo esc_html( $form['title'] ); ?></td>
								<td class="is-right is-muted"><?php echo esc_html( number_format_i18n( $started ) ); ?></td>
								<td class="is-right"><?php echo esc_html( number_format_i18n( $submitted ) ); ?></td>
								<td class="is-right is-accent"><?php echo esc_html( number_format_i18n( $completion, 1 ) . '%' ); ?></td>
								<td class="is-last"><?php echo esc_html( $last_label ); ?></td>
							</tr>
						<?php endforeach; ?>
					</tbody>
				</table>
			</div>
		</div>
		<?php
	}

	/**
	 * Exports the same Overview-tab data currently on screen (daily
	 * submissions, top forms, country breakdown, timeline heatmap) as a
	 * CSV or a single JSON payload — not just entries, which the Entries
	 * screen's own export already covers.
	 */
	public function handle_export() {
		if ( ! current_user_can( 'chargeforms_manage_forms' ) || ! check_admin_referer( 'chargeforms_export_report' ) ) {
			wp_die( esc_html__( 'Not allowed.', 'chargeforms' ), 403 );
		}

		$form_id   = isset( $_GET['form_id'] ) ? (int) $_GET['form_id'] : 0; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
		$date_from = isset( $_GET['date_from'] ) ? sanitize_text_field( wp_unslash( $_GET['date_from'] ) ) : ''; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
		$date_to   = isset( $_GET['date_to'] ) ? sanitize_text_field( wp_unslash( $_GET['date_to'] ) ) : ''; // phpcs:ignore WordPress.Security.NonceVerification.Recommended
		$format    = isset( $_GET['format'] ) && 'json' === $_GET['format'] ? 'json' : 'csv'; // phpcs:ignore WordPress.Security.NonceVerification.Recommended

		$daily   = Entry::counts_by_day( 14 );
		$forms   = Form::all();
		// One GROUP BY query for every form instead of one Entry::query()
		// call each (roadmap issue #36 — see render_top_forms()'s
		// identical fix above).
		$counts_by_form = Entry::count_by_form( array_column( $forms, 'id' ), $date_from, $date_to );
		$ranked  = array_map( function ( $form ) use ( $counts_by_form ) {
			$form['count'] = $counts_by_form[ $form['id'] ] ?? 0;
			return $form;
		}, $forms );
		usort( $ranked, fn( $a, $b ) => $b['count'] <=> $a['count'] );
		$countries = Entry::country_breakdown( $form_id, $date_from, $date_to );
		$devices   = Entry::device_breakdown( $form_id, $date_from, $date_to );
		$browsers  = Entry::browser_breakdown( $form_id, $date_from, $date_to );
		$timeline  = Entry::submissions_by_hour_and_dow( $form_id, $date_from, $date_to );
		$starts    = \ChargeForms\Includes\Form_Start::count_total( $form_id, $date_from, $date_to );

		nocache_headers();

		if ( 'json' === $format ) {
			header( 'Content-Type: application/json; charset=utf-8' );
			header( 'Content-Disposition: attachment; filename="chargeforms-report-' . gmdate( 'Y-m-d' ) . '.json"' );
			echo wp_json_encode( [
				'daily_submissions' => $daily,
				'top_forms'         => array_map( fn( $f ) => [ 'title' => $f['title'], 'submissions' => $f['count'] ], $ranked ),
				'submissions_by_country' => $countries,
				'device_breakdown'       => $devices,
				'browser_breakdown'      => $browsers,
				'timeline_hour_by_dow'   => $timeline,
				'form_starts'            => $starts,
			] );
			exit;
		}

		header( 'Content-Type: text/csv; charset=utf-8' );
		header( 'Content-Disposition: attachment; filename="chargeforms-report-' . gmdate( 'Y-m-d' ) . '.csv"' );

		$out = fopen( 'php://output', 'w' ); // phpcs:ignore WordPress.WP.AlternativeFunctions.file_system_operations_fopen

		fputcsv( $out, [ __( 'Daily Submissions (last 14 days)', 'chargeforms' ) ] );
		fputcsv( $out, [ __( 'Date', 'chargeforms' ), __( 'Submissions', 'chargeforms' ) ] );
		foreach ( $daily as $day => $count ) {
			fputcsv( $out, [ $day, $count ] );
		}

		fputcsv( $out, [] );
		fputcsv( $out, [ __( 'Top Performing Forms', 'chargeforms' ) ] );
		fputcsv( $out, [ __( 'Form', 'chargeforms' ), __( 'Submissions', 'chargeforms' ) ] );
		foreach ( $ranked as $form ) {
			fputcsv( $out, [ $form['title'], $form['count'] ] );
		}

		fputcsv( $out, [] );
		fputcsv( $out, [ __( 'Submissions By Country', 'chargeforms' ) ] );
		fputcsv( $out, [ __( 'Country', 'chargeforms' ), __( 'Submissions', 'chargeforms' ) ] );
		foreach ( $countries as $country => $count ) {
			fputcsv( $out, [ $country, $count ] );
		}

		fputcsv( $out, [] );
		fputcsv( $out, [ __( 'Device Breakdown', 'chargeforms' ) ] );
		fputcsv( $out, [ __( 'Device', 'chargeforms' ), __( 'Submissions', 'chargeforms' ) ] );
		foreach ( $devices as $device => $count ) {
			fputcsv( $out, [ $device, $count ] );
		}

		fputcsv( $out, [] );
		fputcsv( $out, [ __( 'Browser Breakdown', 'chargeforms' ) ] );
		fputcsv( $out, [ __( 'Browser', 'chargeforms' ), __( 'Submissions', 'chargeforms' ) ] );
		foreach ( $browsers as $browser => $count ) {
			fputcsv( $out, [ $browser, $count ] );
		}

		fputcsv( $out, [] );
		fputcsv( $out, [ __( 'Completion Rate', 'chargeforms' ) ] );
		fputcsv( $out, [ __( 'Form Starts', 'chargeforms' ), __( 'Submissions', 'chargeforms' ) ] );
		fputcsv( $out, [ $starts, Entry::query( array_filter( [ 'form_id' => $form_id ?: null, 'date_from' => $date_from ?: null, 'date_to' => $date_to ?: null, 'per_page' => 1 ] ) )['total'] ] );

		fclose( $out ); // phpcs:ignore WordPress.WP.AlternativeFunctions.file_system_operations_fclose

		exit;
	}
}