<?php

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

class AIEO_DMM_UTM_Explorer extends AIEO_DMM_Module_Base {

	const NONCE = 'aieo_utm_explorer';
	const CAP   = 'manage_woocommerce';

	
	const LEVELS = array(
		'channel'  => 'ordersource',
		'source'   => 'orderutmsource',
		'medium'   => 'orderutmmedium',
		'campaign' => 'orderutmcampaign',
		'term'     => 'orderutmterm',
		'content'  => 'orderutmcontent',
	);

	
	const ORDER  = array( 'channel', 'source', 'medium', 'campaign', 'term', 'content' );

	
	private static function labels() {
		return array(
			'channel'  => __( 'Channel', 'ai-eshop-optimizer' ),
			'source'   => __( 'Source', 'ai-eshop-optimizer' ),
			'medium'   => _x( 'Medium', 'UTM parameter', 'ai-eshop-optimizer' ),
			'campaign' => __( 'Campaign', 'ai-eshop-optimizer' ),
			'term'     => __( 'Term', 'ai-eshop-optimizer' ),
			'content'  => __( 'Content', 'ai-eshop-optimizer' ),
		);
	}

	public function get_id() {
		return 'utm_explorer';
	}
	public function get_icon()     { return 'hash'; }

	public function get_label() {
		return __( 'Drill-down by campaign tag', 'ai-eshop-optimizer' );
	}

	public function get_group() {
		return 'attribution';
	}

	
	public function get_section() {
		return 'sources';
	}

	
	public function get_priority() {
		return 16;
	}

	public function register_hooks() {
		add_action( 'wp_ajax_aieo_utm_explore', array( $this, 'ajax_explore' ) );
		add_action( 'wp_ajax_aieo_utm_search', array( $this, 'ajax_search' ) );
	}

	

	private function guard() {
		check_ajax_referer( self::NONCE, 'nonce' );
		if ( ! current_user_can( self::CAP ) ) {
			wp_send_json_error( array( 'msg' => 'forbidden' ), 403 );
		}
	}

	
	private function dates() {
		$to   = isset( $_REQUEST['to'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['to'] ) ) : '';
		$from = isset( $_REQUEST['from'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['from'] ) ) : '';
		$d    = '/^\d{4}-\d{2}-\d{2}$/';
		if ( ! preg_match( $d, $to ) ) {
			$to = gmdate( 'Y-m-d' );
		}
		if ( ! preg_match( $d, $from ) ) {
			$from = gmdate( 'Y-m-d', strtotime( $to . ' -30 days' ) );
		}
		return array( $from, $to );
	}

	
	private function compare_dates( $from, $to, $mode ) {
		if ( 'prev' === $mode ) {
			$days = (int) round( ( strtotime( $to ) - strtotime( $from ) ) / 86400 ) + 1;
			return array( gmdate( 'Y-m-d', strtotime( $from . ' -' . $days . ' days' ) ), gmdate( 'Y-m-d', strtotime( $from . ' -1 day' ) ) );
		}
		if ( 'yoy' === $mode ) {
			return array( gmdate( 'Y-m-d', strtotime( $from . ' -1 year' ) ), gmdate( 'Y-m-d', strtotime( $to . ' -1 year' ) ) );
		}
		return array( '', '' );
	}

	
	private function selection() {
		$sel = array();
		foreach ( self::ORDER as $lvl ) {
			$sel[ $lvl ] = isset( $_REQUEST[ $lvl ] )
				? array_values( array_filter( array_map( 'sanitize_text_field', (array) wp_unslash( $_REQUEST[ $lvl ] ) ), 'strlen' ) )
				: array();
		}
		return $sel;
	}

	
	private function where_and_args( $sel, $consider, $from, $to ) {
		$w    = 'orderdate >= %s AND orderdate <= %s';
		$args = array( $from, $to );
		foreach ( $consider as $lvl ) {
			$vals = isset( $sel[ $lvl ] ) ? (array) $sel[ $lvl ] : array();
			if ( ! empty( $vals ) ) {
				$w     .= ' AND `' . self::LEVELS[ $lvl ] . '` IN (' . implode( ',', array_fill( 0, count( $vals ), '%s' ) ) . ')';
				$args   = array_merge( $args, array_values( $vals ) );
			}
		}
		return array( $w, $args );
	}

	

	public function ajax_search() {
		$this->guard();
		global $wpdb;
		$st    = $wpdb->prefix . 'aieo_order_stats';
		$level = isset( $_REQUEST['level'] ) ? sanitize_key( $_REQUEST['level'] ) : '';
		if ( ! isset( self::LEVELS[ $level ] ) ) {
			wp_send_json( array( 'results' => array() ) );
		}
		$q   = isset( $_REQUEST['q'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['q'] ) ) : '';
		$sel = $this->selection();

		
		
		
		
		$idx       = array_search( $level, self::ORDER, true );
		$ancestors = array_slice( self::ORDER, 0, $idx );
		$w    = '1=1';
		$args = array();
		foreach ( $ancestors as $alvl ) {
			$avals = isset( $sel[ $alvl ] ) ? (array) $sel[ $alvl ] : array();
			if ( ! empty( $avals ) ) {
				$w     .= ' AND `' . self::LEVELS[ $alvl ] . '` IN (' . implode( ',', array_fill( 0, count( $avals ), '%s' ) ) . ')';
				$args   = array_merge( $args, array_values( $avals ) );
			}
		}
		$col   = self::LEVELS[ $level ];
		$w    .= " AND `{$col}` IS NOT NULL AND `{$col}` <> '' AND `{$col}` LIKE %s";
		$args[] = '%' . $wpdb->esc_like( $q ) . '%';

		$vals = $wpdb->get_col( $wpdb->prepare( "SELECT DISTINCT `{$col}` FROM {$st} WHERE {$w} ORDER BY `{$col}` LIMIT 200", $args ) );
		$out  = array();
		foreach ( (array) $vals as $v ) {
			$out[] = array( 'value' => (string) $v, 'label' => (string) $v );
		}
		wp_send_json( array( 'results' => $out ) );
	}

	
	private function breakdown_expr( $drill ) {
		$col = '`' . self::LEVELS[ $drill ] . '`';
		if ( ! in_array( $drill, array( 'channel', 'source' ), true ) ) {
			return $col;
		}
		return "CASE {$col}
			WHEN 'paid_google'      THEN 'Google - Paid'
			WHEN 'paid_fb'          THEN 'Facebook - Paid'
			WHEN 'paid_fb-sitelink' THEN 'Facebook - Paid'
			WHEN 'paid_facebook'    THEN 'Facebook - Paid'
			WHEN 'paid_microsoft'   THEN 'Microsoft - Paid'
			WHEN 'paid_other'       THEN 'Paid - Other'
			WHEN 'organic'          THEN 'Organic Search'
			WHEN 'organic_search'   THEN 'Organic Search'
			WHEN 'google'           THEN 'Organic Search'
			WHEN 'direct'           THEN 'Direct'
			WHEN '(direct)'         THEN 'Direct'
			WHEN 'referral'         THEN 'Referral'
			WHEN 'social'           THEN 'Social'
			WHEN 'ig'               THEN 'Instagram'
			WHEN 'fb'               THEN 'Facebook'
			WHEN 'newsletter'       THEN 'Newsletter'
			WHEN 'aieo_push'        THEN 'Push notification'
			WHEN 'skroutz'          THEN 'Skroutz'
			WHEN 'shopflix'         THEN 'Shopflix'
			ELSE {$col}
		END";
	}

	

	public function ajax_explore() {
		$this->guard();
		global $wpdb;
		$st  = $wpdb->prefix . 'aieo_order_stats';
		$sel = $this->selection();
		list( $from, $to ) = $this->dates();

		
		$drill = null;
		foreach ( self::ORDER as $lvl ) {
			if ( empty( $sel[ $lvl ] ) ) {
				$drill = $lvl;
				break;
			}
		}
		list( $w, $args ) = $this->where_and_args( $sel, self::ORDER, $from, $to );

		$rows = array();
		if ( null !== $drill ) {
			$expr = $this->breakdown_expr( $drill );
			$res  = $wpdb->get_results( $wpdb->prepare(
				"SELECT {$expr} AS label, COUNT(*) AS orders, COALESCE(SUM(orderspend),0) AS revenue
				 FROM {$st} WHERE {$w} GROUP BY {$expr} ORDER BY revenue DESC LIMIT 300",
				$args
			) );
			foreach ( (array) $res as $r ) {
				$o   = (int) $r->orders;
				$rev = (float) $r->revenue;
				$rows[] = array(
					'label'   => ( '' === (string) $r->label ) ? '(none)' : (string) $r->label,
					'orders'  => $o,
					'revenue' => round( $rev, 2 ),
					'aov'     => $o > 0 ? round( $rev / $o, 2 ) : 0.0,
				);
			}
		}

		$tot = $wpdb->get_row( $wpdb->prepare(
			"SELECT COUNT(*) AS orders, COALESCE(SUM(orderspend),0) AS revenue FROM {$st} WHERE {$w}",
			$args
		) );

		$total = array(
			'orders'  => (int) ( $tot->orders ?? 0 ),
			'revenue' => round( (float) ( $tot->revenue ?? 0 ), 2 ),
		);

		
		$compare = isset( $_REQUEST['compare'] ) ? sanitize_key( wp_unslash( $_REQUEST['compare'] ) ) : '';
		$cfrom   = '';
		$cto     = '';
		if ( in_array( $compare, array( 'prev', 'yoy' ), true ) ) {
			list( $cfrom, $cto ) = $this->compare_dates( $from, $to, $compare );
			list( $cw, $cargs )  = $this->where_and_args( $sel, self::ORDER, $cfrom, $cto );
			$ct  = $wpdb->get_row( $wpdb->prepare( "SELECT COUNT(*) AS orders, COALESCE(SUM(orderspend),0) AS revenue FROM {$st} WHERE {$cw}", $cargs ) );
			$pco = (int) ( $ct->orders ?? 0 );
			$pcr = (float) ( $ct->revenue ?? 0 );
			$total['d_orders']  = $pco > 0 ? round( 100 * ( $total['orders'] - $pco ) / $pco, 1 ) : null;
			$total['d_revenue'] = $pcr > 0 ? round( 100 * ( $total['revenue'] - $pcr ) / $pcr, 1 ) : null;
			if ( null !== $drill ) {
				$expr = $this->breakdown_expr( $drill );
				$cmap = array();
				foreach ( (array) $wpdb->get_results( $wpdb->prepare( "SELECT {$expr} AS label, COUNT(*) AS orders, COALESCE(SUM(orderspend),0) AS revenue FROM {$st} WHERE {$cw} GROUP BY {$expr}", $cargs ) ) as $cr ) {
					$cmap[ ( '' === (string) $cr->label ) ? '(none)' : (string) $cr->label ] = $cr;
				}
				foreach ( $rows as $ri => $r ) {
					$c   = isset( $cmap[ $r['label'] ] ) ? $cmap[ $r['label'] ] : null;
					$pco = $c ? (int) $c->orders : 0;
					$pcr = $c ? (float) $c->revenue : 0.0;
					$rows[ $ri ]['d_orders']  = $pco > 0 ? round( 100 * ( $r['orders'] - $pco ) / $pco, 1 ) : null;
					$rows[ $ri ]['d_revenue'] = $pcr > 0 ? round( 100 * ( $r['revenue'] - $pcr ) / $pcr, 1 ) : null;
				}
			}
		}

		wp_send_json_success( array(
			'table'       => null !== $drill && $rows ? $this->utm_table( self::labels()[ $drill ], $rows, $total, '' !== $cfrom ) : null,
			'drill'       => $drill,
			'drill_label' => $drill ? self::labels()[ $drill ] : '',
			'rows'        => $rows,
			'total'       => $total,
			'from'        => $from,
			'to'          => $to,
			'compare'     => $compare,
			'cfrom'       => $cfrom,
			'cto'         => $cto,
		) );
	}

	
	private function utm_table( $level, array $rows, array $total, $compare ) {
		$with = static function ( $cell, $delta ) use ( $compare ) {
			if ( ! $compare || null === $delta ) {
				return $cell;
			}
			$cell         = is_array( $cell ) ? $cell : array( 'html' => esc_html( (string) $cell ) );
			$cell['html'] = ( $cell['html'] ?? esc_html( (string) ( $cell['value'] ?? '' ) ) ) . ' ' . esc_html( '(' . ( $delta >= 0 ? '+' : '' ) . number_format_i18n( (float) $delta, 1 ) . '%)' );
			$cell['tone'] = $delta >= 0 ? 'success' : 'destructive';
			unset( $cell['value'] );
			return $cell;
		};
		$out = array();
		foreach ( $rows as $i => $r ) {
			$out[] = array(
				'_id'     => (string) ( $i + 1 ),
				'label'   => (string) $r['label'],
				'orders'  => $with( number_format_i18n( (int) $r['orders'] ), $r['d_orders'] ?? null ),
				'revenue' => $with( AIEO_Table_Columns::money( $r['revenue'] ), $r['d_revenue'] ?? null ),
				'aov'     => AIEO_Table_Columns::money( $r['aov'] ),
				'_s'      => array(
					'label'   => (string) $r['label'],
					'orders'  => (int) $r['orders'],
					'revenue' => (float) $r['revenue'],
					'aov'     => (float) $r['aov'],
				),
				'_text'   => (string) $r['label'],
			);
		}
		$orders = (int) ( $total['orders'] ?? 0 );
		return AIEO_Table::local_answer(
			'aieo-utm-table',
			array(
				array( 'key' => 'label', 'label' => $level, 'sort_type' => 'text' ),
				array( 'key' => 'orders', 'label' => __( 'Orders', 'ai-eshop-optimizer' ), 'type' => 'num', 'sort_type' => 'number' ),
				array( 'key' => 'revenue', 'label' => __( 'Revenue', 'ai-eshop-optimizer' ), 'type' => 'num', 'sort_type' => 'number', 'format' => 'money' ),
				array(
					'key'       => 'aov',
					'label'     => __( 'Avg order', 'ai-eshop-optimizer' ),
					'type'      => 'num',
					'sort_type' => 'number',
					'format'    => 'money',
					'total'     => array( 'ratio' => array( 'revenue', 'orders' ) ),
				),
			),
			$out,
			array(
				'prefix'  => 'utm_',
				'size'    => 0,
				'caption' => __( 'UTM explorer', 'ai-eshop-optimizer' ),
				'totals'  => array(
					'orders'  => $orders,
					'revenue' => (float) ( $total['revenue'] ?? 0 ),
				),
			)
		);
	}

	

	public function render_subtab() {
		$this->render_card( true );
	}

	
	public function render_card( $as_page = false ) {
		$nonce    = wp_create_nonce( self::NONCE );
		$def_from = gmdate( 'Y-m-d', strtotime( '-30 days' ) );
		$def_to   = gmdate( 'Y-m-d' );
		if ( defined( 'AIEO_FILE' ) ) {
			$vp_abs = dirname( AIEO_FILE ) . '/assets/js/aieo-value-picker.js';
			wp_enqueue_script( 'aieo-value-picker', plugins_url( 'assets/js/aieo-value-picker.js', AIEO_FILE ), array(), is_readable( $vp_abs ) ? (string) filemtime( $vp_abs ) : '1', true );
		}
		$ajaxurl = esc_attr( admin_url( 'admin-ajax.php' ) );

		
		
		
		
		
		
		
		list( $aieo_utm_open, $aieo_utm_close ) = AIEO_DMM_UI::card( array(
			'anchor'      => 'utm-explorer-overview',
			'icon'        => 'hash',
			'title'       => $as_page ? __( 'Campaign tags', 'ai-eshop-optimizer' ) : __( 'Drill-down by campaign tag', 'ai-eshop-optimizer' ),
			
			
			
			'description' => $as_page
				? __( 'Orders, revenue and average order value for each campaign tag, narrowed by source, medium, campaign, term and content.', 'ai-eshop-optimizer' )
				: __( 'Takes your revenue down to the campaign tags that brought it, from the source and medium to the campaign and its content.', 'ai-eshop-optimizer' ),
		) );
		echo $aieo_utm_open; 
		
		
		
		
		
		
		echo \Rooster\Admin\Guidance::text( __( 'A stepped drill-down across the five campaign tags. Each is a searchable multi-select — pick any mix of Sources and the lists below narrow to what occurred under them, then Medium, Campaign, Term, Content. The table breaks your current selection down by the next level, with orders, revenue and average order value.', 'ai-eshop-optimizer' ), 'guidance', array( 'question' => __( 'How does the drill-down work?', 'ai-eshop-optimizer' ) ) ); 

		echo '<div class="rooster-admin-filters">';
		echo \Rooster\Admin\Ui::filter( __( 'From', 'ai-eshop-optimizer' ), \Rooster\Admin\Ui::input( '', $def_from, array( 'type' => 'date', 'id' => 'aieo-utm-from' ) ), 'aieo-utm-from' ); 
		echo \Rooster\Admin\Ui::filter( __( 'To', 'ai-eshop-optimizer' ), \Rooster\Admin\Ui::input( '', $def_to, array( 'type' => 'date', 'id' => 'aieo-utm-to' ) ), 'aieo-utm-to' ); 
		foreach ( self::ORDER as $i => $lvl ) {
			$ctx = array( 'from:aieo-utm-from', 'to:aieo-utm-to' );
			foreach ( array_slice( self::ORDER, 0, $i ) as $anc ) {
				$ctx[] = $anc . ':aieo-utm-' . $anc;
			}
			$lvl_suffix = ( 'channel' === $lvl ) ? __( 'resolved', 'ai-eshop-optimizer' ) : 'utm_' . $lvl;
			$picker     = '<span class="aieo-valpick" id="aieo-utm-' . esc_attr( $lvl ) . '" data-search-action="aieo_utm_search"'
				. ' data-params="level=' . esc_attr( $lvl ) . '" data-multi="1"'
				. ' data-title="' . esc_attr( sprintf(  __( 'Choose %s values', 'ai-eshop-optimizer' ), self::labels()[ $lvl ] ) ) . '"'
				. ' data-placeholder="' . esc_attr__( 'Search…', 'ai-eshop-optimizer' ) . '" data-empty="' . esc_attr__( '— all —', 'ai-eshop-optimizer' ) . '"'
				. ' data-context="' . esc_attr( implode( ',', $ctx ) ) . '"'
				. ' data-ajaxurl="' . $ajaxurl . '" data-nonce="' . esc_attr( $nonce ) . '">'
				. '<input type="hidden" class="aieo-valpick-store" value="">'
				. '<button type="button" class="rooster-admin-button aieo-valpick-open" id="aieo-utm-' . esc_attr( $lvl ) . '-open">' . esc_html__( '— all —', 'ai-eshop-optimizer' ) . '</button>'
				. '<span class="aieo-valpick-chips"></span>'
				. '</span>';
			echo \Rooster\Admin\Ui::filter( self::labels()[ $lvl ] . ' (' . $lvl_suffix . ')', $picker, 'aieo-utm-' . $lvl . '-open' ); 
		}
		$compare = \Rooster\Admin\Ui::select(
			'',
			array(
				''     => __( '— off —', 'ai-eshop-optimizer' ),
				'prev' => __( 'Previous period', 'ai-eshop-optimizer' ),
				'yoy'  => __( 'Same period last year', 'ai-eshop-optimizer' ),
			),
			'',
			array( 'id' => 'aieo-utm-compare' )
		);
		echo \Rooster\Admin\Ui::filter( __( 'Compare', 'ai-eshop-optimizer' ), $compare, 'aieo-utm-compare' ); 
		echo '<div class="rooster-admin-filters__actions"><button type="button" class="rooster-admin-button" id="aieo-utm-reset">' . esc_html__( 'Reset', 'ai-eshop-optimizer' ) . '</button></div>';
		echo '</div>';

		
		
		
		
		
		
		\Rooster\Admin\States::enqueue();
		echo \Rooster\Admin\States::result_head( '', array( 'id' => 'aieo-utm-breadcrumb', 'attrs' => array( 'hidden' => true ) ) ); 
		
		$aieo_utm_states = array(
			'loading' => \Rooster\Admin\States::state( 'loading' ),
			'first'   => \Rooster\Admin\States::state( 'first-use', array( 'title' => __( 'No data for this selection / period.', 'ai-eshop-optimizer' ) ) ),
			'none'    => \Rooster\Admin\States::state( 'no-results', array( 'clear' => '#' ) ),
			'failed'  => \Rooster\Admin\States::state( 'failed', array( 'text' => __( 'Error.', 'ai-eshop-optimizer' ) ) ),
		);
		foreach ( $aieo_utm_states as $aieo_utm_kind => $aieo_utm_state ) {
			echo '<div id="aieo-utm-state-' . esc_attr( $aieo_utm_kind ) . '"' . ( 'loading' === $aieo_utm_kind ? '' : ' hidden' ) . '>' . $aieo_utm_state . '</div>'; 
		}
		
		
		AIEO_Table::table_assets( array( 'totals' ) );
		echo '<div id="aieo-utm-tablebox" hidden></div>';
		
		
		$aieo_utm_note = sprintf(
			
			__( 'Broken down by %1$s. Pick value(s) above to drill deeper. Period %2$s → %3$s.', 'ai-eshop-optimizer' ),
			self::labels()['channel'],
			$def_from,
			$def_to
		);
		echo '<div hidden>' . \Rooster\Admin\Guidance::text( $aieo_utm_note, 'guidance', array( 'id' => 'aieo-utm-note', 'question' => __( 'What does the table show?', 'ai-eshop-optimizer' ) ) ) . '</div>'; 
		echo $aieo_utm_close; 

		$this->print_js( $nonce, $def_from, $def_to, $this->has_orders() );
	}

	
	private function has_orders() {
		global $wpdb;
		$st = $wpdb->prefix . 'aieo_order_stats';
		if ( $st !== (string) $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $st ) ) ) { 
			return false;
		}
		return (bool) $wpdb->get_var( "SELECT 1 FROM `{$st}` LIMIT 1" ); 
	}

	
	private function print_js( $nonce, $def_from = '', $def_to = '', $has_orders = true ) {
		$ajax   = admin_url( 'admin-ajax.php' );
		$labels = array();
		foreach ( self::ORDER as $l ) {
			$labels[ $l ] = self::labels()[ $l ];
		}
		?>
		<script>
		document.addEventListener('DOMContentLoaded', function () {
			var AJAX = <?php echo wp_json_encode( $ajax ); ?>, NONCE = <?php echo wp_json_encode( $nonce ); ?>;
			var ORDER = <?php echo wp_json_encode( array_values( self::ORDER ) ); ?>, LABELS = <?php echo wp_json_encode( $labels ); ?>;
			function $(id){ return document.getElementById(id); }
			function post(action, data){ data=data||{}; data.action=action; data.nonce=NONCE; var fd=new FormData(); for(var k in data){ var v=data[k]; if(Array.isArray(v)){ v.forEach(function(x){ fd.append(k+'[]', x); }); } else { fd.append(k, v); } } return fetch(AJAX,{method:'POST',credentials:'same-origin',body:fd}).then(function(r){return r.json();}); }
			var MONEY = <?php echo wp_json_encode( array( 'symbol' => html_entity_decode( get_woocommerce_currency_symbol(), ENT_QUOTES, 'UTF-8' ), 'position' => (string) get_option( 'woocommerce_currency_pos', 'left' ) ) ); ?>;
			function money(n){ if(n==null){return '—';} var v=(Math.round(n*100)/100).toLocaleString(undefined,{minimumFractionDigits:2,maximumFractionDigits:2}); return MONEY.position==='left'?MONEY.symbol+v:MONEY.position==='left_space'?MONEY.symbol+' '+v:MONEY.position==='right'?v+MONEY.symbol:v+' '+MONEY.symbol; }
			function esc(s){ var d=document.createElement('div'); d.textContent=(s==null?'':s); return d.innerHTML; }
			function vals(l){ return window.aieoValPicker ? aieoValPicker.values($('aieo-utm-'+l)) : []; }
			/* Post-conversion (session 21): the component owns the table shell;
			   this fills the breadcrumb, the first header, the tbody and a
			   component-classed tfoot. Every string resolves through UTM_I18N
			   or the server's translated drill_label (B81/B23 family). */
			var UTM_I18N = <?php echo wp_json_encode( array(
				'all'      => __( 'All traffic', 'ai-eshop-optimizer' ),
				'error'    => __( 'Error.', 'ai-eshop-optimizer' ),
				'orders'   => __( 'orders', 'ai-eshop-optimizer' ),
				'total'    => __( 'Total', 'ai-eshop-optimizer' ),
				
				'note'     => __( 'Broken down by %1$s. Pick value(s) above to drill deeper. Period %2$s → %3$s.', 'ai-eshop-optimizer' ),
				
				'filtered' => __( 'Every level is filtered — %s orders.', 'ai-eshop-optimizer' ),
				'yoy'      => __( 'same period last year', 'ai-eshop-optimizer' ),
				'prev'     => __( 'previous period', 'ai-eshop-optimizer' ),
			) ); ?>;
			/* UI wave 2 (A5, second agent): the result head, the states in the table's place, the note's guidance text. */
			var HAS_ORDERS = <?php echo $has_orders ? 'true' : 'false'; ?>, DEF = { from: <?php echo wp_json_encode( (string) $def_from ); ?>, to: <?php echo wp_json_encode( (string) $def_to ); ?> };
			var head = $('aieo-utm-breadcrumb'), stateEls = {};
			['loading', 'first', 'none', 'failed'].forEach(function(k){ stateEls[k] = $('aieo-utm-state-' + k); });
			function showState(which, text){
				Object.keys(stateEls).forEach(function(k){ if (stateEls[k]) { stateEls[k].hidden = k !== which; } });
				if (which) { $('aieo-utm-tablebox').hidden = true; }
				if (which === 'failed' && stateEls.failed && text) {
					var t = stateEls.failed.querySelector('.rooster-admin-empty__text');
					if (t) { t.textContent = text; }
				}
			}
			function setNote(text){
				var note = $('aieo-utm-note'), box = note ? note.parentNode.parentNode : null;
				if (note && text) { note.textContent = text; } // hidden, it keeps its last text: its "Why?" describes one
				if (box) { box.hidden = !text; }
			}
			function dtxt(d){ return d == null ? '' : ' (' + (d >= 0 ? '+' : '') + d + '%)'; }
			function setHead(o){ var s = window.roosterAdmin && window.roosterAdmin.states; if (head && s && s.result) { s.result(head, o); } }
			function explore(){
				var data={from:$('aieo-utm-from').value,to:$('aieo-utm-to').value};
				ORDER.forEach(function(l){ data[l]=vals(l); });
				data.compare=($('aieo-utm-compare')?$('aieo-utm-compare').value:'');
				/* A state in the table's place gives way to the loading one; a table stays until the answer. */
				if ($('aieo-utm-tablebox').hidden) { showState('loading'); setHead({count: '', facts: []}); }
				post('aieo_utm_explore', data).then(function(j){
					var box=$('aieo-utm-tablebox');
					if(!j||!j.success){ setHead({count: '', facts: []}); showState('failed', (j && j.data && j.data.msg) || UTM_I18N.error); setNote(''); return; }
					var d=j.data;
					var crumbs=[]; ORDER.forEach(function(l){ var vv=vals(l); if(vv.length){ crumbs.push(LABELS[l]+': '+vv.join(' / ')); } });
					var bc = crumbs.length ? crumbs.join(' › ') : UTM_I18N.all.charAt(0).toLocaleLowerCase() + UTM_I18N.all.slice(1);
					/* The head: the orders (and their change), the selection, the revenue (and its change), the window compared. */
					setHead({
						count: Number(d.total.orders).toLocaleString() + ' ' + UTM_I18N.orders,
						after: dtxt(d.total.d_orders),
						facts: [bc, money(d.total.revenue) + dtxt(d.total.d_revenue)].concat(d.compare && d.cfrom ? ['Δ% vs ' + d.cfrom + ' → ' + d.cto + ', ' + (d.compare === 'yoy' ? UTM_I18N.yoy : UTM_I18N.prev)] : [])
					});
					if(d.drill){
						if(d.rows.length){
							showState('');
							/* The table is the library table, drawn by the answer and wired by enhance(). */
							if(d.table && d.table.html){ box.innerHTML=d.table.html; if(window.roosterAdminTable && roosterAdminTable.enhance){ roosterAdminTable.enhance(box, d.table.icons); } }
							box.hidden=false;
							setNote(UTM_I18N.note.replace('%1$s', d.drill_label).replace('%2$s', d.from).replace('%3$s', d.to));
						} else {
							/* Nothing in this selection or period: no results (Clear filters) once any order was recorded, else first use. */
							setHead({count: '', facts: []});
							showState(HAS_ORDERS ? 'none' : 'first');
							setNote('');
						}
					} else {
						showState('');
						box.hidden=true;
						setNote(UTM_I18N.filtered.replace('%s', d.total.orders));
					}
				}).catch(function(){ setHead({count: '', facts: []}); showState('failed', UTM_I18N.error); setNote(''); });
			}
			// Changing a level invalidates its descendants → clear them (suppressing
			// the cascade of change events), then explore once.
			var suppress=false;
			ORDER.forEach(function(l, i){
				var w=$('aieo-utm-'+l);
				if(!w){ return; }
				w.addEventListener('aieo-valpick:change', function(){
					if(suppress){ return; }
					suppress=true;
					for(var k=i+1;k<ORDER.length;k++){ if(window.aieoValPicker){ aieoValPicker.clear($('aieo-utm-'+ORDER[k])); } }
					suppress=false;
					explore();
				});
			});
			$('aieo-utm-from').addEventListener('change', explore);
			$('aieo-utm-to').addEventListener('change', explore);
			/* Compare re-reads too (it did not until another filter changed). */
			if ($('aieo-utm-compare')) { $('aieo-utm-compare').addEventListener('change', explore); }
			function clearTags(){ suppress=true; ORDER.forEach(function(l){ if(window.aieoValPicker){ aieoValPicker.clear($('aieo-utm-'+l)); } }); suppress=false; }
			$('aieo-utm-reset').addEventListener('click', function(){ clearTags(); explore(); });
			/* Clear filters (the no-results state): every tag and the period back to the last 30 days, one read. */
			var clearLink = stateEls.none ? stateEls.none.querySelector('a') : null;
			clearLink && clearLink.addEventListener('click', function(e){
				e.preventDefault();
				clearTags();
				$('aieo-utm-from').value = DEF.from;
				$('aieo-utm-to').value = DEF.to;
				explore();
			});
			explore();
		});
		</script>
		<?php
	}
}