<?php
/**
 * Admin tab "Redirects" (AOO Shop › Redirects): summary · Woo import (batched, assets/aoo-shop-admin.js) ·
 * fallback rules + brand landing pages · "ทดสอบ path" · review table (filter / search / paging) with edit
 * (product picker via `/wp-json/aooshop/v1/search`, budget-page picker from the ping's price buckets), quick "→ หน้าร้าน",
 * delete · CSV export / import · "จับคู่หมวดงบ" (old Woo budget categories → budget pages, manual rows).
 * Capability manage_options · every write nonce-checked (admin-post).
 *
 * @package AooShop
 */

defined( 'ABSPATH' ) || exit;

class AooShop_Admin_Redirects {

	const TAB      = 'redirects';
	const PER_PAGE = 50;
	const CSV_COLS = array( 'source_path', 'target_type', 'target_slug', 'target_url', 'status' );
	const CSV_MAX  = 5242880;

	/** @var AooShop_Settings */
	private $settings;
	/** @var AooShop_Redirects */
	private $redirects;
	/** @var AooShop_Router */
	private $router;

	public function __construct( AooShop_Settings $settings, AooShop_Redirects $redirects, AooShop_Router $router ) {
		$this->settings  = $settings;
		$this->redirects = $redirects;
		$this->router    = $router;
	}

	public function hooks() {
		add_filter( 'aooshop_admin_tabs', array( $this, 'tab' ) );
		add_action( 'aooshop_admin_tab_' . self::TAB, array( $this, 'render' ) );
		add_action( 'admin_enqueue_scripts', array( $this, 'enqueue' ) );
		foreach ( array( 'save', 'delete', 'to_shop', 'settings', 'export', 'import', 'clear', 'budget_map' ) as $a ) {
			add_action( 'admin_post_aooshop_rd_' . $a, array( $this, 'action_' . $a ) );
		}
		add_filter( 'aooshop_status_rows', array( $this, 'status_row' ) );
	}

	public function tab( $tabs ) {
		$tabs[ self::TAB ] = __( 'Redirects (old links)', 'aoo-shop' );
		return $tabs;
	}

	public function status_row( $rows ) {
		$s      = AooShop_Redirects::summary();
		$rows[] = array(
			__( 'Old link redirects', 'aoo-shop' ),
			$s['total']
				? sprintf( /* translators: 1: number of redirect rows, 2: rows with a target, 3: total hits */ __( '%1$d links · %2$d with a target · used %3$d times', 'aoo-shop' ), $s['total'], $s['matched'], $s['hits'] ) . ( $this->settings->is_preview() ? ' · ' . __( '(live mode only)', 'aoo-shop' ) : '' )
				: __( 'None yet — see the Redirects tab', 'aoo-shop' ),
		);
		return $rows;
	}

	private function page_url( array $args = array() ) {
		return add_query_arg( array_merge( array( 'page' => AooShop_Admin::tab_slug( self::TAB ), 'tab' => self::TAB ), $args ), admin_url( 'admin.php' ) );
	}

	public function enqueue( $hook ) {
		// phpcs:ignore WordPress.Security.NonceVerification.Recommended -- screen check only.
		if ( false === strpos( (string) $hook, AooShop_Admin::SLUG ) || ! isset( $_GET['tab'] ) || self::TAB !== $_GET['tab'] ) {
			return;
		}
		wp_enqueue_script( 'aooshop-admin', AOOSHOP_URL . 'assets/aoo-shop-admin.js', array(), AOOSHOP_VERSION . '-' . (string) @filemtime( AOOSHOP_DIR . 'assets/aoo-shop-admin.js' ), true ); // phpcs:ignore WordPress.PHP.NoSilencedErrors.Discouraged
		wp_localize_script(
			'aooshop-admin',
			'aooShopAdmin',
			array(
				'ajax'      => admin_url( 'admin-ajax.php' ),
				'nonce'     => wp_create_nonce( 'aooshop_woo_import' ),
				'search'    => rest_url( AooShop_Rest::NS . '/search' ),
				'restNonce' => wp_create_nonce( 'wp_rest' ),
				'i18n'      => array(
					'products' => __( 'Products', 'aoo-shop' ),
					'terms'    => __( 'Categories/brands', 'aoo-shop' ),
					'done'     => __( 'Import finished — reloading…', 'aoo-shop' ),
					'error'    => __( 'Import failed:', 'aoo-shop' ),
					'matched'  => __( 'Matched', 'aoo-shop' ),
					'none'     => __( 'No products found', 'aoo-shop' ),
					'confirm'  => __( 'Import all product, category and brand links from WooCommerce? (Rows you edited yourself will not be overwritten.)', 'aoo-shop' ),
				),
			)
		);
	}

	// ── actions ───────────────────────────────────────────────────────

	/** Capability gate for every admin-post action; each action verifies its own nonce right after. */
	private function require_cap() {
		if ( ! current_user_can( 'manage_options' ) ) {
			wp_die( esc_html__( 'You do not have permission to do this.', 'aoo-shop' ), 403 );
		}
	}

	private function back( $msg, array $extra = array() ) {
		$keep = array();
		foreach ( array( 'filter', 's', 'paged' ) as $k ) {
			if ( isset( $_REQUEST[ $k ] ) && '' !== $_REQUEST[ $k ] ) { // phpcs:ignore WordPress.Security.NonceVerification.Recommended -- nonce checked by the calling action.
				$keep[ $k ] = sanitize_text_field( wp_unslash( $_REQUEST[ $k ] ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended
			}
		}
		wp_safe_redirect( $this->page_url( array_merge( $keep, array( 'aoo_msg' => $msg ), $extra ) ) );
		exit;
	}

	public function action_save() {
		$this->require_cap();
		check_admin_referer( 'aooshop_rd_save' );
		$id  = isset( $_POST['id'] ) ? absint( $_POST['id'] ) : 0;
		$old = $id ? AooShop_Redirects::get( $id ) : null;
		$in  = array(
			'source_path' => $old ? $old->source_path : ( isset( $_POST['source_path'] ) ? sanitize_text_field( wp_unslash( $_POST['source_path'] ) ) : '' ),
			'target_type' => isset( $_POST['target_type'] ) ? sanitize_key( wp_unslash( $_POST['target_type'] ) ) : 'none',
			'target_slug' => isset( $_POST['target_slug'] ) ? sanitize_text_field( wp_unslash( $_POST['target_slug'] ) ) : '',
			'target_url'  => isset( $_POST['target_url'] ) ? esc_url_raw( wp_unslash( $_POST['target_url'] ) ) : '',
			'status'      => isset( $_POST['status'] ) ? absint( $_POST['status'] ) : 301,
			'origin'      => 'manual',
			'source_kind' => $old ? $old->source_kind : 'other',
			'source_name' => $old ? $old->source_name : '',
			'matched_by'  => 'manual',
		);
		if ( 'page' === $in['target_type'] && isset( $_POST['target_page'] ) ) {
			$in['target_slug'] = (string) absint( $_POST['target_page'] );
		}
		if ( 'budget' === $in['target_type'] ) {
			$in['target_slug'] = isset( $_POST['target_budget'] ) ? sanitize_text_field( wp_unslash( $_POST['target_budget'] ) ) : '';
		}
		if ( 'url' === $in['target_type'] && isset( $_POST['target_url'] ) ) {
			$raw = trim( sanitize_text_field( wp_unslash( $_POST['target_url'] ) ) );
			$in['target_url'] = 0 === strpos( $raw, '/' ) ? $raw : esc_url_raw( $raw );
		}
		$row = AooShop_Redirects::clean_row( $in );
		if ( is_wp_error( $row ) ) {
			$this->back( 'error', array( 'aoo_err' => rawurlencode( $row->get_error_message() ) ) );
		}
		if ( $old && $old->source_hash !== $row['source_hash'] ) {
			AooShop_Redirects::delete( $old->id );
		}
		AooShop_Redirects::upsert( $row, false );
		AooShop_Redirects::refresh_count();
		$this->back( 'saved' );
	}

	public function action_delete() {
		$this->require_cap();
		check_admin_referer( 'aooshop_rd_delete' );
		AooShop_Redirects::delete( isset( $_POST['id'] ) ? absint( $_POST['id'] ) : 0 );
		AooShop_Redirects::refresh_count();
		$this->back( 'deleted' );
	}

	public function action_to_shop() {
		$this->require_cap();
		check_admin_referer( 'aooshop_rd_to_shop' );
		$old = AooShop_Redirects::get( isset( $_POST['id'] ) ? absint( $_POST['id'] ) : 0 );
		if ( $old ) {
			$row = AooShop_Redirects::clean_row(
				array(
					'source_path' => $old->source_path,
					'source_kind' => $old->source_kind,
					'source_name' => $old->source_name,
					'target_type' => 'shop',
					'origin'      => 'manual',
					'matched_by'  => 'manual',
					'status'      => (int) $old->status,
				)
			);
			if ( ! is_wp_error( $row ) ) {
				AooShop_Redirects::upsert( $row, false );
				AooShop_Redirects::refresh_count();
			}
		}
		$this->back( 'saved' );
	}

	public function action_clear() {
		$this->require_cap();
		check_admin_referer( 'aooshop_rd_clear' );
		AooShop_Redirects::delete_generated();
		AooShop_Redirects::refresh_count();
		$this->back( 'cleared' );
	}

	/** "จับคู่หมวดงบ": one manual row per old Woo budget category the owner mapped (budget page / shop). */
	public function action_budget_map() {
		$this->require_cap();
		check_admin_referer( 'aooshop_rd_budget_map' );
		// phpcs:disable WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- sanitized per item.
		$paths   = isset( $_POST['bm_path'] ) ? (array) wp_unslash( $_POST['bm_path'] ) : array();
		$names   = isset( $_POST['bm_name'] ) ? (array) wp_unslash( $_POST['bm_name'] ) : array();
		$targets = isset( $_POST['bm_target'] ) ? (array) wp_unslash( $_POST['bm_target'] ) : array();
		// phpcs:enable
		$slugs = wp_list_pluck( $this->settings->price_buckets(), 'slug' );
		$n     = 0;
		foreach ( $paths as $i => $path ) {
			$to = isset( $targets[ $i ] ) ? sanitize_text_field( (string) $targets[ $i ] ) : '';
			if ( '' === $to ) {
				continue; // Unchanged.
			}
			if ( 'shop' !== $to && ! in_array( $to, $slugs, true ) ) {
				continue;
			}
			$row = AooShop_Redirects::clean_row(
				array(
					'source_path' => sanitize_text_field( (string) $path ),
					'source_kind' => 'category',
					'source_name' => isset( $names[ $i ] ) ? sanitize_text_field( (string) $names[ $i ] ) : '',
					'target_type' => 'shop' === $to ? 'shop' : 'budget',
					'target_slug' => 'shop' === $to ? '' : $to,
					'origin'      => 'manual',
					'matched_by'  => 'budget',
				)
			);
			if ( ! is_wp_error( $row ) ) {
				AooShop_Redirects::upsert( $row, false );
				$n++;
			}
		}
		AooShop_Redirects::refresh_count();
		$this->back( 'budget_saved', array( 'aoo_ok' => $n ) );
	}

	public function action_settings() {
		$this->require_cap();
		check_admin_referer( 'aooshop_rd_settings' );
		$landing = array();
		$slugs   = isset( $_POST['landing_slug'] ) ? (array) wp_unslash( $_POST['landing_slug'] ) : array(); // phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotSanitized -- sanitized per item.
		$pages   = isset( $_POST['landing_page'] ) ? array_map( 'absint', (array) $_POST['landing_page'] ) : array();
		foreach ( $slugs as $i => $slug ) {
			$slug = trim( rawurldecode( sanitize_text_field( (string) $slug ) ), '/ ' );
			$slug = function_exists( 'mb_strtolower' ) ? mb_strtolower( $slug, 'UTF-8' ) : strtolower( $slug );
			$page = isset( $pages[ $i ] ) ? (int) $pages[ $i ] : 0;
			if ( '' !== $slug && $page && 'page' === get_post_type( $page ) ) {
				$landing[ $slug ] = $page;
			}
		}
		AooShop_Redirects::save_rd_settings(
			array(
				'fallback_category' => empty( $_POST['fallback_category'] ) ? 0 : 1,
				'fallback_brand'    => empty( $_POST['fallback_brand'] ) ? 0 : 1,
				'brand_landing'     => $landing,
			)
		);
		$this->back( 'settings_saved' );
	}

	public function action_export() {
		$this->require_cap();
		check_admin_referer( 'aooshop_rd_export' );
		global $wpdb;
		$table = AooShop_Redirects::table();
		// phpcs:ignore WordPress.DB.DirectDatabaseQuery
		$rows = $wpdb->get_results( $wpdb->prepare( "SELECT source_path, target_type, target_slug, target_url, status, source_kind, source_name, origin, matched_by, hits FROM %i ORDER BY source_path", $table ), ARRAY_A );
		nocache_headers();
		header( 'Content-Type: text/csv; charset=utf-8' );
		header( 'Content-Disposition: attachment; filename="aoo-redirects-' . gmdate( 'Ymd-His' ) . '.csv"' );
		$out = fopen( 'php://output', 'w' );
		fwrite( $out, "\xEF\xBB\xBF" ); // phpcs:ignore WordPress.WP.AlternativeFunctions.file_system_operations_fwrite -- Excel needs the BOM for Thai.
		fputcsv( $out, array_merge( self::CSV_COLS, array( 'source_kind', 'source_name', 'origin', 'matched_by', 'hits' ) ) );
		foreach ( (array) $rows as $r ) {
			$line = array();
			foreach ( array( 'source_path', 'target_type', 'target_slug', 'target_url', 'status', 'source_kind', 'source_name', 'origin', 'matched_by', 'hits' ) as $c ) {
				$v = (string) $r[ $c ];
				// Spreadsheet formula injection guard.
				if ( '' !== $v && in_array( $v[0], array( '=', '+', '-', '@' ), true ) ) {
					$v = "'" . $v;
				}
				$line[] = $v;
			}
			fputcsv( $out, $line );
		}
		fclose( $out ); // phpcs:ignore WordPress.WP.AlternativeFunctions.file_system_operations_fclose
		exit;
	}

	public function action_import() {
		$this->require_cap();
		check_admin_referer( 'aooshop_rd_import' );
		// phpcs:disable WordPress.Security.ValidatedSanitizedInput -- uploaded file, validated below.
		if ( empty( $_FILES['csv']['tmp_name'] ) || ! is_uploaded_file( $_FILES['csv']['tmp_name'] ) ) {
			$this->back( 'error', array( 'aoo_err' => rawurlencode( __( 'No file selected.', 'aoo-shop' ) ) ) );
		}
		if ( (int) $_FILES['csv']['size'] > self::CSV_MAX ) {
			$this->back( 'error', array( 'aoo_err' => rawurlencode( __( 'The file is larger than 5 MB.', 'aoo-shop' ) ) ) );
		}
		$fh = fopen( $_FILES['csv']['tmp_name'], 'r' ); // phpcs:ignore WordPress.WP.AlternativeFunctions.file_system_operations_fopen
		// phpcs:enable
		$head = $fh ? fgetcsv( $fh ) : false;
		if ( ! $head ) {
			$this->back( 'error', array( 'aoo_err' => rawurlencode( __( 'Could not read the CSV file.', 'aoo-shop' ) ) ) );
		}
		$head[0] = preg_replace( '/^\xEF\xBB\xBF/', '', (string) $head[0] );
		$cols    = array_flip( array_map( 'trim', array_map( 'strtolower', $head ) ) );
		if ( ! isset( $cols['source_path'], $cols['target_type'] ) ) {
			$this->back( 'error', array( 'aoo_err' => rawurlencode( __( 'The file must have source_path and target_type columns.', 'aoo-shop' ) ) ) );
		}
		$ok  = 0;
		$bad = 0;
		$n   = 0;
		while ( ( $line = fgetcsv( $fh ) ) !== false && $n < 20000 ) { // phpcs:ignore WordPress.CodeAnalysis.AssignmentInCondition.FoundInWhileCondition
			$n++;
			$get = function ( $c ) use ( $cols, $line ) {
				if ( ! isset( $cols[ $c ], $line[ $cols[ $c ] ] ) ) {
					return '';
				}
				$v = trim( (string) $line[ $cols[ $c ] ] );
				return ( '' !== $v && "'" === $v[0] && isset( $v[1] ) && in_array( $v[1], array( '=', '+', '-', '@' ), true ) ) ? substr( $v, 1 ) : $v;
			};
			$row = AooShop_Redirects::clean_row(
				array(
					'source_path' => $get( 'source_path' ),
					'target_type' => '' !== $get( 'target_type' ) ? $get( 'target_type' ) : 'none',
					'target_slug' => $get( 'target_slug' ),
					'target_url'  => $get( 'target_url' ),
					'status'      => '' !== $get( 'status' ) ? (int) $get( 'status' ) : 301,
					'source_kind' => $get( 'source_kind' ),
					'source_name' => $get( 'source_name' ),
					'origin'      => 'manual',
					'matched_by'  => 'csv',
				)
			);
			if ( is_wp_error( $row ) ) {
				$bad++;
				continue;
			}
			AooShop_Redirects::upsert( $row, false );
			$ok++;
		}
		fclose( $fh ); // phpcs:ignore WordPress.WP.AlternativeFunctions.file_system_operations_fclose
		AooShop_Redirects::refresh_count();
		$this->back( 'imported', array( 'aoo_ok' => $ok, 'aoo_bad' => $bad ) );
	}

	// ── screen ────────────────────────────────────────────────────────

	private function notice() {
		// phpcs:disable WordPress.Security.NonceVerification.Recommended -- display only.
		$msg = isset( $_GET['aoo_msg'] ) ? sanitize_key( wp_unslash( $_GET['aoo_msg'] ) ) : '';
		$map = array(
			'saved'          => __( 'Saved.', 'aoo-shop' ),
			'deleted'        => __( 'Deleted.', 'aoo-shop' ),
			'cleared'        => __( 'Removed imported and auto-generated rows (rows you edited yourself are kept).', 'aoo-shop' ),
			'settings_saved' => __( 'Fallback rules saved.', 'aoo-shop' ),
		);
		if ( 'budget_saved' === $msg ) {
			$map[ $msg ] = sprintf( /* translators: %d: number of categories saved */ __( 'Budget category mapping saved: %d categories.', 'aoo-shop' ), isset( $_GET['aoo_ok'] ) ? absint( $_GET['aoo_ok'] ) : 0 );
		}
		if ( isset( $map[ $msg ] ) ) {
			echo '<div class="notice notice-success is-dismissible"><p>' . esc_html( $map[ $msg ] ) . '</p></div>';
		} elseif ( 'imported' === $msg ) {
			$ok  = isset( $_GET['aoo_ok'] ) ? absint( $_GET['aoo_ok'] ) : 0;
			$bad = isset( $_GET['aoo_bad'] ) ? absint( $_GET['aoo_bad'] ) : 0;
			echo '<div class="notice ' . ( $bad ? 'notice-warning' : 'notice-success' ) . '"><p>' . esc_html( sprintf( /* translators: 1: number of imported rows, 2: number of skipped rows */ __( 'Imported %1$d CSV rows · skipped %2$d invalid rows.', 'aoo-shop' ), $ok, $bad ) ) . '</p></div>';
		} elseif ( 'error' === $msg ) {
			$err = isset( $_GET['aoo_err'] ) ? sanitize_text_field( wp_unslash( $_GET['aoo_err'] ) ) : '';
			echo '<div class="notice notice-error"><p>' . esc_html( $err ) . '</p></div>';
		}
		// phpcs:enable
	}

	private static function type_label( $type ) {
		$labels = array(
			'product'  => __( 'Product', 'aoo-shop' ),
			'category' => __( 'Category', 'aoo-shop' ),
			'brand'      => __( 'Brand', 'aoo-shop' ),
			'collection' => __( 'Collection', 'aoo-shop' ),
			'budget'     => __( 'Budget page', 'aoo-shop' ),
			'shop'     => __( 'Shop', 'aoo-shop' ),
			'page'     => __( 'WordPress page', 'aoo-shop' ),
			'url'      => __( 'Other URL', 'aoo-shop' ),
			'none'     => __( 'Not found (404)', 'aoo-shop' ),
			'other'    => __( 'Other', 'aoo-shop' ),
		);
		return isset( $labels[ $type ] ) ? $labels[ $type ] : $type;
	}

	public function render() {
		if ( ! current_user_can( 'manage_options' ) ) {
			return;
		}
		if ( ! AooShop_Redirects::table_exists() ) {
			AooShop_Redirects::install();
		}
		$this->notice();
		$sum = AooShop_Redirects::summary();
		?>
		<p class="description" style="max-width:900px">
			<?php esc_html_e( 'Old links on your site (such as WooCommerce product and category pages) send visitors to the matching new shop page with a 301, so Google carries over your existing rankings. Works in live mode only (in preview mode WooCommerce still serves the old links). Product links that cannot be matched return 404 instead of being sent to a random shop page.', 'aoo-shop' ); ?>
		</p>
		<?php if ( $this->settings->is_preview() ) : ?>
			<div class="notice notice-info inline"><p><?php esc_html_e( 'Preview mode is on — redirects do not apply to visitors yet. Use "Test a path" below to check the results in advance.', 'aoo-shop' ); ?></p></div>
		<?php endif; ?>

		<h2><?php esc_html_e( 'Summary', 'aoo-shop' ); ?></h2>
		<p>
			<?php
			echo esc_html(
				sprintf(
					/* translators: 1: total rows, 2: rows with a target, 3: rows without a target, 4: manual rows, 5: auto-generated rows, 6: total hits */
					__( 'Total %1$d · with a target %2$d · no target %3$d · manual %4$d · auto-generated %5$d · used %6$d times in total', 'aoo-shop' ),
					$sum['total'],
					$sum['matched'],
					$sum['unmatched'],
					$sum['manual'],
					$sum['auto'],
					$sum['hits']
				)
			);
			?>
		</p>

		<?php
		$this->render_import();
		$this->render_test();
		$this->render_edit();
		$this->render_table();
		$this->render_budget_map();
		$this->render_csv();
		$this->render_fallback();
	}

	private function render_import() {
		echo '<h2>' . esc_html__( 'Import from WooCommerce', 'aoo-shop' ) . '</h2>';
		$last = get_option( AooShop_Woo_Import::STATS_OPTION );
		if ( is_array( $last ) && ! empty( $last['finished'] ) ) {
			$p = $last['products'];
			$t = $last['terms'];
			echo '<p>' . esc_html(
				sprintf(
					/* translators: 1: date and time of the last import, 2: matched products, 3: products sent, 4: match percentage, 5: matched categories/brands, 6: categories/brands sent */
					__( 'Last import %1$s · products matched %2$d/%3$d (%4$s%%) · categories/brands %5$d/%6$d', 'aoo-shop' ),
					wp_date( 'j M Y H:i', (int) $last['finished'] ),
					$p['matched'],
					$p['sent'],
					$p['sent'] ? number_format_i18n( 100 * $p['matched'] / $p['sent'], 1 ) : '0',
					$t['matched'],
					$t['sent']
				)
			);
			$by = array();
			foreach ( array_merge_recursive( (array) $p['by'], (array) $t['by'] ) as $k => $v ) {
				$by[] = $k . ' ' . ( is_array( $v ) ? array_sum( $v ) : (int) $v );
			}
			if ( $by ) {
				echo ' · ' . esc_html__( 'Matched by', 'aoo-shop' ) . ' ' . esc_html( implode( ', ', $by ) );
			}
			echo '</p>';
		}
		if ( ! AooShop_Woo_Import::available() ) {
			echo '<p class="description">' . esc_html__( 'WooCommerce is not active — importing only works while WooCommerce is still active (do it before moving the shop). You can use CSV instead.', 'aoo-shop' ) . '</p>';
			return;
		}
		if ( ! $this->settings->is_configured() ) {
			echo '<p class="description" style="color:#b32d2e">' . esc_html__( 'Enter the API key first (Settings tab).', 'aoo-shop' ) . '</p>';
			return;
		}
		?>
		<p class="description"><?php esc_html_e( 'Reads every product link (including drafts and private products), category and brand from WooCommerce and matches them to AOO products by SKU → code → name → slug. Rows you edited yourself are not overwritten. Safe to run again.', 'aoo-shop' ); ?></p>
		<p>
			<button type="button" class="button button-primary" id="aoo-woo-import"><?php esc_html_e( 'Import from WooCommerce', 'aoo-shop' ); ?></button>
			<span id="aoo-woo-import-status" style="margin-left:8px"></span>
		</p>
		<progress id="aoo-woo-import-progress" max="100" value="0" style="width:420px;display:none"></progress>
		<?php
	}

	private function render_test() {
		// phpcs:ignore WordPress.Security.NonceVerification.Recommended -- read-only test.
		$test = isset( $_GET['aoo_test'] ) ? sanitize_text_field( wp_unslash( $_GET['aoo_test'] ) ) : '';
		?>
		<h2><?php esc_html_e( 'Test a path', 'aoo-shop' ); ?></h2>
		<form method="get" action="<?php echo esc_url( admin_url( 'admin.php' ) ); ?>">
			<input type="hidden" name="page" value="<?php echo esc_attr( AooShop_Admin::tab_slug( self::TAB ) ); ?>" />
			<input type="hidden" name="tab" value="<?php echo esc_attr( self::TAB ); ?>" />
			<input type="text" class="regular-text" name="aoo_test" value="<?php echo esc_attr( $test ); ?>" placeholder="/product-category/fruit/" />
			<?php submit_button( __( 'Test', 'aoo-shop' ), 'secondary', '', false ); ?>
		</form>
		<?php
		if ( '' === $test ) {
			return;
		}
		$norm = AooShop_Redirects::normalize_path( $test );
		$hit  = '' !== $norm ? $this->redirects->resolve( $norm, true ) : null;
		$rule = array(
			'row'               => __( 'Matches a row in the table', 'aoo-shop' ),
			'brand_landing'     => __( 'Brand landing page', 'aoo-shop' ),
			'fallback_category' => __( 'Fallback rule: old category → AOO category', 'aoo-shop' ),
			'fallback_brand'    => __( 'Fallback rule: old brand → AOO brand', 'aoo-shop' ),
			'fallback_shop'     => __( 'Fallback rule: not found in AOO → shop', 'aoo-shop' ),
		);
		echo '<p><code>' . esc_html( '' !== $norm ? $norm : $test ) . '</code> → ';
		if ( ! $hit ) {
			echo esc_html__( 'No redirect (WordPress handles it — 404 if the page does not exist)', 'aoo-shop' );
		} elseif ( '' === $hit['target'] ) {
			echo esc_html( $rule[ $hit['rule'] ] ) . ' · ' . esc_html__( 'no target → 404', 'aoo-shop' );
		} else {
			echo '<strong>' . (int) $hit['status'] . '</strong> <a href="' . esc_url( $hit['target'] ) . '" target="_blank" rel="noopener">' . esc_html( rawurldecode( $hit['target'] ) ) . '</a> · ' . esc_html( $rule[ $hit['rule'] ] );
			if ( ! empty( $hit['note'] ) ) {
				echo ' (' . esc_html( $hit['note'] ) . ')';
			}
		}
		echo '</p>';
	}

	private function render_edit() {
		// phpcs:ignore WordPress.Security.NonceVerification.Recommended -- display only.
		$id  = isset( $_GET['edit'] ) ? absint( $_GET['edit'] ) : 0;
		$row = $id ? AooShop_Redirects::get( $id ) : null;
		$t   = $row ? $row->target_type : 'product';
		?>
		<h2 id="aoo-rd-edit"><?php echo $row ? esc_html__( 'Edit target', 'aoo-shop' ) : esc_html__( 'Add redirect', 'aoo-shop' ); ?></h2>
		<form method="post" action="<?php echo esc_url( admin_url( 'admin-post.php' ) ); ?>" id="aoo-rd-form">
			<input type="hidden" name="action" value="aooshop_rd_save" />
			<input type="hidden" name="id" value="<?php echo (int) $id; ?>" />
			<?php wp_nonce_field( 'aooshop_rd_save' ); ?>
			<table class="form-table" role="presentation">
				<tr>
					<th scope="row"><?php esc_html_e( 'Old link (path)', 'aoo-shop' ); ?></th>
					<td>
						<?php if ( $row ) : ?>
							<code><?php echo esc_html( $row->source_path ); ?></code>
							<?php if ( '' !== $row->source_name ) : ?>
								<span class="description"> — <?php echo esc_html( $row->source_name ); ?></span>
							<?php endif; ?>
						<?php else : ?>
							<input type="text" class="regular-text" name="source_path" placeholder="/product/old-slug/" required />
						<?php endif; ?>
					</td>
				</tr>
				<tr>
					<th scope="row"><?php esc_html_e( 'Target', 'aoo-shop' ); ?></th>
					<td>
						<?php
						foreach ( AooShop_Redirects::TYPES as $type ) {
							printf(
								'<label style="margin-right:12px"><input type="radio" name="target_type" value="%1$s" %2$s data-aoo-target-type /> %3$s</label>',
								esc_attr( $type ),
								checked( $t, $type, false ),
								esc_html( 'shop' === $type ? self::type_label( $type ) . ' ' . $this->router->url( 'index' ) : self::type_label( $type ) )
							);
						}
						?>
						<div data-aoo-show="product category brand collection" style="margin-top:8px">
							<input type="text" class="regular-text" name="target_slug" id="aoo-rd-slug" value="<?php echo esc_attr( $row && in_array( $row->target_type, array( 'product', 'category', 'brand', 'collection' ), true ) ? $row->target_slug : '' ); ?>" placeholder="<?php esc_attr_e( 'AOO slug', 'aoo-shop' ); ?>" />
							<p class="description"><?php esc_html_e( 'Product: type a name or SKU to search below, then click a result. Category/brand/collection: enter the AOO slug.', 'aoo-shop' ); ?></p>
						</div>
						<div data-aoo-show="budget" style="margin-top:8px">
							<?php $this->budget_select( 'target_budget', $row && 'budget' === $row->target_type ? $row->target_slug : '', false ); ?>
						</div>
						<div data-aoo-show="product" style="margin-top:8px">
							<input type="search" class="regular-text" id="aoo-rd-search" placeholder="<?php esc_attr_e( 'Search AOO products…', 'aoo-shop' ); ?>" autocomplete="off" />
							<ul id="aoo-rd-results" style="max-width:520px;margin:4px 0"></ul>
						</div>
						<div data-aoo-show="page" style="margin-top:8px">
							<?php
							AooShop_Admin::pages_dropdown(
								array(
									'name'              => 'target_page',
									'selected'          => $row && 'page' === $row->target_type ? (int) $row->target_slug : 0,
									'show_option_none'  => esc_html__( '— Select a page —', 'aoo-shop' ),
									'option_none_value' => '0',
								)
							);
							?>
						</div>
						<div data-aoo-show="url" style="margin-top:8px">
							<input type="text" class="regular-text" name="target_url" value="<?php echo esc_attr( $row && 'url' === $row->target_type ? $row->target_url : '' ); ?>" placeholder="<?php esc_attr_e( 'https://… or /path/', 'aoo-shop' ); ?>" />
						</div>
					</td>
				</tr>
				<tr>
					<th scope="row"><?php esc_html_e( 'Status', 'aoo-shop' ); ?></th>
					<td>
						<select name="status">
							<?php foreach ( AooShop_Redirects::STATUSES as $code ) : ?>
								<option value="<?php echo (int) $code; ?>" <?php selected( $row ? (int) $row->status : 301, $code ); ?>><?php echo (int) $code . ( 301 === $code ? ' — ' . esc_html__( 'Moved permanently (recommended)', 'aoo-shop' ) : '' ); ?></option>
							<?php endforeach; ?>
						</select>
					</td>
				</tr>
			</table>
			<?php submit_button( $row ? __( 'Save', 'aoo-shop' ) : __( 'Add', 'aoo-shop' ), 'primary', 'submit', false ); ?>
			<?php if ( $row ) : ?>
				<a class="button" href="<?php echo esc_url( $this->page_url() ); ?>"><?php esc_html_e( 'Cancel', 'aoo-shop' ); ?></a>
			<?php endif; ?>
		</form>
		<?php
	}

	private function render_table() {
		global $wpdb;
		// phpcs:disable WordPress.Security.NonceVerification.Recommended -- list filters.
		$filter = isset( $_GET['filter'] ) ? sanitize_key( wp_unslash( $_GET['filter'] ) ) : '';
		$search = isset( $_GET['s'] ) ? sanitize_text_field( wp_unslash( $_GET['s'] ) ) : '';
		$paged  = isset( $_GET['paged'] ) ? max( 1, absint( $_GET['paged'] ) ) : 1;
		// phpcs:enable
		$table   = AooShop_Redirects::table();
		$where   = array( '1=1' );
		$filters = array(
			''          => __( 'All', 'aoo-shop' ),
			'matched'   => __( 'With a target', 'aoo-shop' ),
			'unmatched' => __( 'No target', 'aoo-shop' ),
			'manual'    => __( 'Manual', 'aoo-shop' ),
			'auto'      => __( 'Automatic', 'aoo-shop' ),
			'product'   => __( 'Products', 'aoo-shop' ),
			'category'  => __( 'Categories', 'aoo-shop' ),
			'brand'     => __( 'Brands', 'aoo-shop' ),
		);
		switch ( $filter ) {
			case 'matched':
				$where[] = "target_type <> 'none'";
				break;
			case 'unmatched':
				$where[] = "target_type = 'none'";
				break;
			case 'manual':
			case 'auto':
				$where[] = $wpdb->prepare( 'origin = %s', $filter );
				break;
			case 'product':
			case 'category':
			case 'brand':
				$where[] = $wpdb->prepare( 'source_kind = %s', $filter );
				break;
		}
		if ( '' !== $search ) {
			$like    = '%' . $wpdb->esc_like( function_exists( 'mb_strtolower' ) ? mb_strtolower( rawurldecode( $search ), 'UTF-8' ) : strtolower( $search ) ) . '%';
			$where[] = $wpdb->prepare( '(source_path LIKE %s OR source_name LIKE %s OR target_slug LIKE %s)', $like, '%' . $wpdb->esc_like( $search ) . '%', $like );
		}
		$w     = implode( ' AND ', $where );
		// phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.DirectDatabaseQuery -- $w built from prepare() pieces.
		$total = (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM %i WHERE {$w}", $table ) );
		$rows  = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM %i WHERE {$w} ORDER BY target_type = 'none' DESC, hits DESC, source_path ASC LIMIT %d OFFSET %d", $table, self::PER_PAGE, ( $paged - 1 ) * self::PER_PAGE ) );
		// phpcs:enable
		?>
		<h2><?php esc_html_e( 'Redirect list', 'aoo-shop' ); ?></h2>
		<ul class="subsubsub" style="float:none">
			<?php
			$links = array();
			foreach ( $filters as $k => $label ) {
				$links[] = '<li><a href="' . esc_url( $this->page_url( '' === $k ? array() : array( 'filter' => $k ) ) ) . '"' . ( $filter === $k ? ' class="current"' : '' ) . '>' . esc_html( $label ) . '</a></li>';
			}
			echo wp_kses_post( implode( ' | ', $links ) );
			?>
		</ul>
		<form method="get" action="<?php echo esc_url( admin_url( 'admin.php' ) ); ?>" style="margin:8px 0">
			<input type="hidden" name="page" value="<?php echo esc_attr( AooShop_Admin::tab_slug( self::TAB ) ); ?>" />
			<input type="hidden" name="tab" value="<?php echo esc_attr( self::TAB ); ?>" />
			<?php if ( '' !== $filter ) : ?>
				<input type="hidden" name="filter" value="<?php echo esc_attr( $filter ); ?>" />
			<?php endif; ?>
			<input type="search" name="s" value="<?php echo esc_attr( $search ); ?>" placeholder="<?php esc_attr_e( 'Search path / name / slug', 'aoo-shop' ); ?>" />
			<?php submit_button( __( 'Search', 'aoo-shop' ), 'secondary', '', false ); ?>
			<span class="description" style="margin-left:8px"><?php echo esc_html( sprintf( /* translators: %d: number of rows */ __( '%d rows', 'aoo-shop' ), $total ) ); ?></span>
		</form>
		<table class="widefat striped">
			<thead><tr>
				<th><?php esc_html_e( 'Old link', 'aoo-shop' ); ?></th>
				<th><?php esc_html_e( 'Target', 'aoo-shop' ); ?></th>
				<th><?php esc_html_e( 'Matched by', 'aoo-shop' ); ?></th>
				<th><?php esc_html_e( 'Source', 'aoo-shop' ); ?></th>
				<th style="width:60px"><?php esc_html_e( 'Hits', 'aoo-shop' ); ?></th>
				<th style="width:230px"></th>
			</tr></thead>
			<tbody>
			<?php if ( ! $rows ) : ?>
				<tr><td colspan="6"><?php esc_html_e( 'No items', 'aoo-shop' ); ?></td></tr>
			<?php endif; ?>
			<?php
			$origins = array(
				'woo'    => 'WooCommerce',
				'manual' => __( 'Manual', 'aoo-shop' ),
				'auto'   => __( 'Automatic', 'aoo-shop' ),
			);
			$rd = AooShop_Redirects::rd_settings();
			foreach ( (array) $rows as $r ) :
				$target = $this->redirects->target_url( $r );
				?>
				<tr>
					<td>
						<code style="word-break:break-all"><?php echo esc_html( $r->source_path ); ?></code>
						<br /><span class="description"><?php echo esc_html( self::type_label( $r->source_kind ) . ( '' !== $r->source_name ? ' · ' . $r->source_name : '' ) ); ?></span>
					</td>
					<td>
						<?php if ( '' !== $target ) : ?>
							<a href="<?php echo esc_url( $target ); ?>" target="_blank" rel="noopener" style="word-break:break-all"><?php echo esc_html( rawurldecode( wp_make_link_relative( $target ) ) ); ?></a>
							<br /><span class="description"><?php echo esc_html( self::type_label( $r->target_type ) . ( 301 !== (int) $r->status ? ' · ' . (int) $r->status : '' ) ); ?></span>
						<?php elseif ( 'manual' !== $r->origin && in_array( $r->source_kind, array( 'category', 'brand' ), true ) && ! empty( $rd[ 'fallback_' . $r->source_kind ] ) ) : ?>
							<span style="color:#996800"><?php esc_html_e( 'Not found in AOO → shop (fallback rule)', 'aoo-shop' ); ?></span>
						<?php else : ?>
							<span style="color:#b32d2e"><?php echo esc_html( self::type_label( 'none' ) ); ?></span>
						<?php endif; ?>
					</td>
					<td><?php echo esc_html( '' !== $r->matched_by ? $r->matched_by : '–' ); ?></td>
					<td><?php echo esc_html( isset( $origins[ $r->origin ] ) ? $origins[ $r->origin ] : $r->origin ); ?></td>
					<td><?php echo (int) $r->hits; ?></td>
					<td>
						<a class="button button-small" href="<?php echo esc_url( $this->page_url( array( 'edit' => (int) $r->id ) ) . '#aoo-rd-edit' ); ?>"><?php esc_html_e( 'Edit', 'aoo-shop' ); ?></a>
						<?php if ( 'shop' !== $r->target_type ) : ?>
							<?php $this->mini_form( 'to_shop', (int) $r->id, __( '→ Shop', 'aoo-shop' ) ); ?>
						<?php endif; ?>
						<?php $this->mini_form( 'delete', (int) $r->id, __( 'Delete', 'aoo-shop' ), true ); ?>
					</td>
				</tr>
			<?php endforeach; ?>
			</tbody>
		</table>
		<?php
		$pages = (int) ceil( $total / self::PER_PAGE );
		if ( $pages > 1 ) {
			echo '<p>';
			for ( $i = 1; $i <= $pages; $i++ ) {
				$args = array( 'paged' => $i );
				if ( '' !== $filter ) {
					$args['filter'] = $filter;
				}
				if ( '' !== $search ) {
					$args['s'] = $search;
				}
				echo $i === $paged ? '<strong style="margin:0 4px">' . (int) $i . '</strong>' : '<a style="margin:0 4px" href="' . esc_url( $this->page_url( $args ) ) . '">' . (int) $i . '</a>';
			}
			echo '</p>';
		}
	}

	private function mini_form( $action, $id, $label, $confirm = false ) {
		?>
		<form method="post" action="<?php echo esc_url( admin_url( 'admin-post.php' ) ); ?>" style="display:inline" <?php echo $confirm ? 'onsubmit="return confirm(\'' . esc_js( __( 'Delete this row?', 'aoo-shop' ) ) . '\')"' : ''; ?>>
			<input type="hidden" name="action" value="aooshop_rd_<?php echo esc_attr( $action ); ?>" />
			<input type="hidden" name="id" value="<?php echo (int) $id; ?>" />
			<?php wp_nonce_field( 'aooshop_rd_' . $action ); ?>
			<button type="submit" class="button button-small<?php echo 'delete' === $action ? ' button-link-delete' : ''; ?>"><?php echo esc_html( $label ); ?></button>
		</form>
		<?php
	}

	/**
	 * <select> of the shop's budget pages (ping price buckets). No buckets yet → text box for the slug.
	 *
	 * @param string $name       Field name.
	 * @param string $selected   Bucket slug.
	 * @param bool   $with_keep  Add "— ไม่เปลี่ยน —" + "หน้าร้าน" (budget-map table).
	 */
	private function budget_select( $name, $selected, $with_keep ) {
		$buckets = $this->settings->price_buckets();
		if ( ! $buckets && ! $with_keep ) {
			printf( '<input type="text" name="%1$s" value="%2$s" placeholder="1500-2000" style="width:10em" /> ', esc_attr( $name ), esc_attr( $selected ) );
			echo '<span class="description">' . esc_html__( 'The shop has no price ranges in AOO yet (or "Test connection" has not been clicked) — type a range yourself, e.g. 0-1500 · 1500-2000 · 3000-', 'aoo-shop' ) . '</span>';
			return;
		}
		echo '<select name="' . esc_attr( $name ) . '">';
		if ( $with_keep ) {
			echo '<option value="">' . esc_html__( '— No change —', 'aoo-shop' ) . '</option>';
		}
		$known = false;
		foreach ( $buckets as $b ) {
			$known = $known || $b['slug'] === $selected;
			printf( '<option value="%1$s" %2$s>%3$s</option>', esc_attr( $b['slug'] ), selected( $selected, $b['slug'], false ), esc_html( $b['label'] . ' — ' . wp_make_link_relative( $this->router->url( 'budget', $b['slug'] ) ) ) );
		}
		if ( '' !== $selected && ! $known && 'shop' !== $selected ) {
			printf( '<option value="%1$s" selected>%2$s</option>', esc_attr( $selected ), esc_html( $selected . ' ' . __( '(this range no longer exists in AOO)', 'aoo-shop' ) ) );
		}
		if ( $with_keep ) {
			printf( '<option value="shop" %1$s>%2$s</option>', selected( $selected, 'shop', false ), esc_html__( 'Shop', 'aoo-shop' ) );
		}
		echo '</select>';
	}

	/**
	 * Old Woo categories for the budget table: live product_cat terms (Woo still on) or imported category rows.
	 * Budget-looking ones only unless `$all` (name/slug has งบ · budget · budjet · ราคา · price, or a 3+ digit number).
	 *
	 * @return array<int, array{path:string, name:string, slug:string}>
	 */
	private static function budget_terms( $all ) {
		$out = array();
		if ( taxonomy_exists( 'product_cat' ) ) {
			$terms = get_terms(
				array(
					'taxonomy'   => 'product_cat',
					'hide_empty' => false,
					'orderby'    => 'name',
				)
			);
			foreach ( is_wp_error( $terms ) ? array() : $terms as $t ) {
				$link = get_term_link( $t );
				$path = is_wp_error( $link ) ? '' : AooShop_Redirects::normalize_path( (string) $link );
				if ( '' !== $path ) {
					$out[] = array(
						'path' => $path,
						'name' => html_entity_decode( (string) $t->name, ENT_QUOTES, 'UTF-8' ),
						'slug' => rawurldecode( (string) $t->slug ),
					);
				}
			}
		} elseif ( AooShop_Redirects::table_exists() ) {
			global $wpdb;
			$table = AooShop_Redirects::table();
			// phpcs:ignore WordPress.DB.DirectDatabaseQuery
			$rows = (array) $wpdb->get_results( $wpdb->prepare( "SELECT source_path, source_name FROM %i WHERE source_kind = 'category' ORDER BY source_name LIMIT 500", $table ) );
			foreach ( $rows as $r ) {
				$out[] = array(
					'path' => (string) $r->source_path,
					'name' => (string) $r->source_name,
					'slug' => AooShop_Redirects::last_segment( $r->source_path ),
				);
			}
		}
		if ( ! $all ) {
			$out = array_values(
				array_filter(
					$out,
					function ( $t ) {
						return (bool) preg_match( '/งบ|budget|budjet|ราคา|price|\d{3,}/iu', $t['name'] . ' ' . $t['slug'] );
					}
				)
			);
		}
		return $out;
	}

	/**
	 * Bucket a Woo budget term most likely means ('' = no guess): "งบ 1500-2000" → 1500-2000 ·
	 * "งบไม่เกิน 1500" / less-than-1500 → 0-1500 · "งบมากกว่า 3000" / more-than-3000 → 3000-.
	 */
	private static function guess_bucket( array $term, array $buckets ) {
		$text = str_replace( ',', '', $term['name'] . ' ' . $term['slug'] );
		preg_match_all( '/\d{3,}/', $text, $m );
		$nums = array_values( array_unique( array_map( 'intval', $m[0] ) ) );
		if ( ! $nums ) {
			return '';
		}
		foreach ( $buckets as $b ) {
			$min = (int) $b['min'];
			$max = null === $b['max'] ? null : (int) $b['max'];
			if ( 2 <= count( $nums ) && $min === $nums[0] && $max === $nums[1] ) {
				return $b['slug'];
			}
			if ( 1 === count( $nums ) ) {
				$up   = (bool) preg_match( '/มากกว่า|ขึ้นไป|เกินกว่า|more|over|above|plus/iu', $text );
				$down = (bool) preg_match( '/ไม่เกิน|ต่ำกว่า|น้อยกว่า|less|under|below/iu', $text );
				if ( $up && null === $max && $min === $nums[0] ) {
					return $b['slug'];
				}
				if ( $down && 0 === $min && $max === $nums[0] ) {
					return $b['slug'];
				}
			}
		}
		return '';
	}

	private function render_budget_map() {
		// phpcs:ignore WordPress.Security.NonceVerification.Recommended -- display toggle.
		$all     = ! empty( $_GET['aoo_budget_all'] );
		$terms   = self::budget_terms( $all );
		$buckets = $this->settings->price_buckets();
		?>
		<h2 id="aoo-rd-budget"><?php esc_html_e( 'Map budget categories', 'aoo-shop' ); ?></h2>
		<p class="description" style="max-width:900px"><?php esc_html_e( 'Old WooCommerce "by budget" categories (e.g. budget 1,500–2,000) → budget pages of the new shop, which pick products by price automatically. Saved mappings become "manual" rows (a repeat WooCommerce import does not overwrite them). The range is guessed from the category name — check it before saving.', 'aoo-shop' ); ?></p>
		<?php if ( ! $buckets ) : ?>
			<p class="description" style="color:#b32d2e"><?php esc_html_e( 'The shop has no price ranges in AOO yet (Settings › Storefront) — set them, then click "Test connection" in the Settings tab.', 'aoo-shop' ); ?></p>
			<?php
			return;
		endif;
		?>
		<p>
			<a href="<?php echo esc_url( $this->page_url( $all ? array() : array( 'aoo_budget_all' => 1 ) ) . '#aoo-rd-budget' ); ?>"><?php echo $all ? esc_html__( 'Show only budget-like categories', 'aoo-shop' ) : esc_html__( 'Show all categories', 'aoo-shop' ); ?></a>
		</p>
		<?php if ( ! $terms ) : ?>
			<p><?php esc_html_e( 'No budget-like categories found.', 'aoo-shop' ); ?></p>
			<?php
			return;
		endif;
		?>
		<form method="post" action="<?php echo esc_url( admin_url( 'admin-post.php' ) ); ?>">
			<input type="hidden" name="action" value="aooshop_rd_budget_map" />
			<?php wp_nonce_field( 'aooshop_rd_budget_map' ); ?>
			<table class="widefat striped" style="max-width:1000px">
				<thead><tr>
					<th><?php esc_html_e( 'Old category', 'aoo-shop' ); ?></th>
					<th><?php esc_html_e( 'Currently goes to', 'aoo-shop' ); ?></th>
					<th><?php esc_html_e( 'Change to', 'aoo-shop' ); ?></th>
				</tr></thead>
				<tbody>
				<?php
				foreach ( $terms as $i => $t ) :
					$row     = AooShop_Redirects::find( $t['path'] );
					$current = $row ? $this->redirects->target_url( $row ) : '';
					$pick    = '';
					if ( $row && 'manual' === $row->origin && 'budget' === $row->target_type ) {
						$pick = $row->target_slug;
					} elseif ( ! $row || 'manual' !== $row->origin ) {
						$pick = self::guess_bucket( $t, $buckets );
					}
					?>
					<tr>
						<td>
							<?php echo esc_html( $t['name'] ); ?><br />
							<code style="word-break:break-all"><?php echo esc_html( $t['path'] ); ?></code>
							<input type="hidden" name="bm_path[<?php echo (int) $i; ?>]" value="<?php echo esc_attr( $t['path'] ); ?>" />
							<input type="hidden" name="bm_name[<?php echo (int) $i; ?>]" value="<?php echo esc_attr( $t['name'] ); ?>" />
						</td>
						<td>
							<?php if ( '' !== $current ) : ?>
								<?php echo esc_html( rawurldecode( wp_make_link_relative( $current ) ) ); ?>
								<br /><span class="description"><?php echo esc_html( self::type_label( $row->target_type ) ); ?></span>
							<?php else : ?>
								<span class="description"><?php echo $row ? esc_html( self::type_label( 'none' ) ) : esc_html__( 'No row yet', 'aoo-shop' ); ?></span>
							<?php endif; ?>
						</td>
						<td><?php $this->budget_select( 'bm_target[' . $i . ']', $pick, true ); ?></td>
					</tr>
				<?php endforeach; ?>
				</tbody>
			</table>
			<?php submit_button( __( 'Save budget mapping', 'aoo-shop' ) ); ?>
		</form>
		<?php
	}

	private function render_csv() {
		?>
		<h2><?php esc_html_e( 'CSV', 'aoo-shop' ); ?></h2>
		<p class="description"><?php esc_html_e( 'Columns: source_path, target_type (product / category / brand / collection / budget / shop / page / url / none), target_slug (budget = price range, e.g. 1500-2000), target_url, status. Rows imported from CSV count as "manual" (a repeat WooCommerce import does not overwrite them).', 'aoo-shop' ); ?></p>
		<div style="display:flex;gap:8px;flex-wrap:wrap;align-items:center">
			<form method="post" action="<?php echo esc_url( admin_url( 'admin-post.php' ) ); ?>">
				<input type="hidden" name="action" value="aooshop_rd_export" />
				<?php wp_nonce_field( 'aooshop_rd_export' ); ?>
				<?php submit_button( __( 'Download CSV', 'aoo-shop' ), 'secondary', 'submit', false ); ?>
			</form>
			<form method="post" action="<?php echo esc_url( admin_url( 'admin-post.php' ) ); ?>" enctype="multipart/form-data">
				<input type="hidden" name="action" value="aooshop_rd_import" />
				<?php wp_nonce_field( 'aooshop_rd_import' ); ?>
				<input type="file" name="csv" accept=".csv,text/csv" required />
				<?php submit_button( __( 'Import CSV', 'aoo-shop' ), 'secondary', 'submit', false ); ?>
			</form>
			<form method="post" action="<?php echo esc_url( admin_url( 'admin-post.php' ) ); ?>" onsubmit="return confirm('<?php echo esc_js( __( 'Delete every row imported from WooCommerce or generated automatically? (Rows you edited yourself are kept.)', 'aoo-shop' ) ); ?>')">
				<input type="hidden" name="action" value="aooshop_rd_clear" />
				<?php wp_nonce_field( 'aooshop_rd_clear' ); ?>
				<?php submit_button( __( 'Delete imported rows', 'aoo-shop' ), 'delete', 'submit', false ); ?>
			</form>
		</div>
		<?php
	}

	private function render_fallback() {
		$s     = AooShop_Redirects::rd_settings();
		$bases = AooShop_Redirects::bases();
		$brand_rows = $s['brand_landing'];
		// Old brand slugs seen at import → offer them in the landing table.
		global $wpdb;
		$table = AooShop_Redirects::table();
		// phpcs:ignore WordPress.DB.DirectDatabaseQuery
		$paths = (array) $wpdb->get_col( $wpdb->prepare( "SELECT source_path FROM %i WHERE source_kind = 'brand' ORDER BY source_path LIMIT 200", $table ) );
		foreach ( $paths as $p ) {
			$slug = AooShop_Redirects::last_segment( $p );
			if ( '' !== $slug && ! isset( $brand_rows[ $slug ] ) ) {
				$brand_rows[ $slug ] = 0;
			}
		}
		$brand_rows[''] = 0; // One empty row to add.
		?>
		<h2><?php esc_html_e( 'Fallback rules (links not in the table)', 'aoo-shop' ); ?></h2>
		<form method="post" action="<?php echo esc_url( admin_url( 'admin-post.php' ) ); ?>">
			<input type="hidden" name="action" value="aooshop_rd_settings" />
			<?php wp_nonce_field( 'aooshop_rd_settings' ); ?>
			<p>
				<label><input type="checkbox" name="fallback_category" value="1" <?php checked( 1, (int) $s['fallback_category'] ); ?> />
				<?php echo esc_html( sprintf( /* translators: %s: old category URL bases, e.g. /product-category/ */ __( 'Old categories (%s) → AOO category with the same name · not found → shop', 'aoo-shop' ), '/' . implode( '/ /', $bases['category'] ) . '/' ) ); ?></label>
			</p>
			<p>
				<label><input type="checkbox" name="fallback_brand" value="1" <?php checked( 1, (int) $s['fallback_brand'] ); ?> />
				<?php echo esc_html( sprintf( /* translators: %s: old brand URL bases */ __( 'Old brands (%s) → brand landing page set below · none set → AOO brand · not found → shop', 'aoo-shop' ), '/' . implode( '/ /', $bases['brand'] ) . '/' ) ); ?></label>
			</p>
			<p class="description"><?php esc_html_e( 'Old product links that are not in the table always return 404 (they are not sent to the shop — Google treats that as a soft 404).', 'aoo-shop' ); ?></p>
			<h3><?php esc_html_e( 'Brand landing pages on this site', 'aoo-shop' ); ?></h3>
			<table class="widefat striped" style="max-width:700px">
				<thead><tr><th><?php esc_html_e( 'Old brand slug', 'aoo-shop' ); ?></th><th><?php esc_html_e( 'Go to page', 'aoo-shop' ); ?></th></tr></thead>
				<tbody>
				<?php
				$i = 0;
				foreach ( $brand_rows as $slug => $page ) :
					?>
					<tr>
						<td><input type="text" name="landing_slug[<?php echo (int) $i; ?>]" value="<?php echo esc_attr( (string) $slug ); ?>" placeholder="stokke" /></td>
						<td>
							<?php
							AooShop_Admin::pages_dropdown(
								array(
									'name'              => 'landing_page[' . $i . ']',
									'selected'          => (int) $page,
									'show_option_none'  => esc_html__( '— Use the AOO brand page —', 'aoo-shop' ),
									'option_none_value' => '0',
								)
							);
							?>
						</td>
					</tr>
					<?php
					$i++;
				endforeach;
				?>
				</tbody>
			</table>
			<?php submit_button( __( 'Save fallback rules', 'aoo-shop' ) ); ?>
		</form>
		<?php
	}
}