<?php declare(strict_types = 1);
/**
 * Duplicate database query output for HTML pages.
 *
 * @package query-monitor
 */

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

class QM_Output_Html_DB_Dupes extends QM_Output_Html {

	/**
	 * Collector instance.
	 *
	 * @var QM_Collector_DB_Dupes Collector.
	 */
	protected $collector;

	public function __construct( QM_Collector $collector ) {
		parent::__construct( $collector );
		add_filter( 'qm/output/menus', array( $this, 'admin_menu' ), 45 );
		add_filter( 'qm/output/panel_menus', array( $this, 'panel_menu' ), 25 );
	}

	/**
	 * @return string
	 */
	public function name() {
		return __( 'Duplicate Queries', 'query-monitor' );
	}

	/**
	 * @return void
	 */
	public function output() {
		/** @var QM_Data_DB_Dupes $data */
		$data = $this->collector->get_data();

		if ( empty( $data->dupes ) ) {
			return;
		}

		$this->before_tabular_output();

		echo '<thead>' . "\n";

		echo '<tr>' . "\n";
		echo '<th scope="col">' . esc_html__( 'Query', 'query-monitor' ) . '</th>' . "\n";
		echo '<th scope="col" class="qm-num">' . esc_html__( 'Count', 'query-monitor' ) . '</th>' . "\n";
		echo '<th scope="col" class="qm-num">' . esc_html__( 'Time', 'query-monitor' ) . '</th>' . "\n";
		echo '<th scope="col">' . esc_html__( 'Callers', 'query-monitor' ) . '</th>' . "\n";
		if ( ! empty( $data->dupe_components ) ) {
			echo '<th scope="col">' . esc_html__( 'Components', 'query-monitor' ) . '</th>' . "\n";
		}
		echo '<th scope="col">' . esc_html__( 'Potential Troublemakers', 'query-monitor' ) . '</th>' . "\n";
		echo '</tr>' . "\n";

		echo '</thead>' . "\n";

		echo '<tbody>' . "\n";

		/* translators: %s: Number of calls to a PHP function */
		$call_text = _n_noop( '%s call', '%s calls', 'query-monitor' );

		foreach ( $data->dupes as $sql => $queries ) {

			// This should probably happen in the collector's processor
			$type = QM_Util::get_query_type( $sql );
			$sql_out = self::format_sql( $sql );
			$time = $data->dupe_times[ $sql ];

			if ( 'SELECT' !== $type ) {
				$sql_out = "<span class='qm-nonselectsql'>{$sql_out}</span>";
			}

			echo '<tr>' . "\n";
			echo '<td class="qm-row-sql qm-ltr qm-wrap">';
			echo $sql_out; // WPCS: XSS ok;
			echo '</td>' . "\n";
			echo '<td class="qm-num">';
			echo esc_html( number_format_i18n( count( $queries ), 0 ) );
			echo '</td>' . "\n";
			echo '<td class="qm-num">';
			echo esc_html( number_format_i18n( $time, 4 ) );
			echo '</td>' . "\n";
			echo '<td class="qm-row-caller qm-nowrap qm-ltr">';
			foreach ( $data->dupe_callers[ $sql ] as $caller => $calls ) {
				echo self::build_filter_trigger( 'db_queries', 'caller', $caller, '<code>' . esc_html( $caller ) . '</code>' ); // WPCS: XSS ok;
				printf(
					'<br><span class="qm-info qm-supplemental">%s</span><br>',
					esc_html( sprintf(
						translate_nooped_plural( $call_text, $calls, 'query-monitor' ),
						number_format_i18n( $calls )
					) )
				);
			}
			echo '</td>' . "\n";
			if ( isset( $data->dupe_components[ $sql ] ) ) {
				echo '<td class="qm-row-component qm-nowrap">';
				foreach ( $data->dupe_components[ $sql ] as $component => $calls ) {
					printf(
						'%s<br><span class="qm-info qm-supplemental">%s</span><br>',
						esc_html( $component ),
						esc_html( sprintf(
							translate_nooped_plural( $call_text, $calls, 'query-monitor' ),
							number_format_i18n( $calls )
						) )
					);
				}
				echo '</td>' . "\n";
			}
			echo '<td class="qm-row-caller qm-nowrap qm-ltr">';
			foreach ( $data->dupe_sources[ $sql ] as $source => $calls ) {
				printf(
					'<code>%s</code><br><span class="qm-info qm-supplemental">%s</span><br>',
					esc_html( $source ),
					esc_html( sprintf(
						translate_nooped_plural( $call_text, $calls, 'query-monitor' ),
						number_format_i18n( $calls )
					) )
				);
			}
			echo '</td>' . "\n";
			echo '</tr>' . "\n";
		}
		echo '</tbody>' . "\n";

		$this->after_tabular_output();
	}

	/**
	 * @param array<string, mixed[]> $menu
	 * @return array<string, mixed[]>
	 */
	public function admin_menu( array $menu ) {
		/** @var QM_Collector_DB_Dupes|null $dbq */
		$dbq = QM_Collectors::get( 'db_dupes' );

		if ( $dbq ) {
			/** @var QM_Data_DB_Queries $dbq_data */
			$dbq_data = $dbq->get_data();
			if ( ! empty( $dbq_data->dupes ) ) {
				$count = 0;

				foreach ( $dbq_data->dupes as $dupe ) {
					$count += count( $dupe );
				}

				$menu[ $this->collector->id() ] = $this->menu( array(
					'title' => esc_html( sprintf(
						/* translators: %s: Number of duplicate database queries */
						__( 'Duplicate Queries (%s)', 'query-monitor' ),
						number_format_i18n( $count )
					) ),
				) );
			}
		}
		return $menu;

	}

	/**
	 * @param array<string, mixed[]> $menu
	 * @return array<string, mixed[]>
	 */
	public function panel_menu( array $menu ) {
		$id = $this->collector->id();
		if ( isset( $menu[ $id ] ) ) {
			$menu['qm-db_queries']['children'][] = $menu[ $id ];
			unset( $menu[ $id ] );
		}

		return $menu;
	}

}

/**
 * @param array<string, QM_Output> $output
 * @param QM_Collectors $collectors
 * @return array<string, QM_Output>
 */
function register_qm_output_html_db_dupes( array $output, QM_Collectors $collectors ) {
	$collector = QM_Collectors::get( 'db_dupes' );
	if ( $collector ) {
		$output['db_dupes'] = new QM_Output_Html_DB_Dupes( $collector );
	}
	return $output;
}

add_filter( 'qm/outputter/html', 'register_qm_output_html_db_dupes', 45, 2 );
