<?php
/**
 * 译文数据页：直接浏览、编辑、删除 apgt_translations 表里的记录。
 *
 * 「页面翻译」是按页面组织的编辑视图，这里是按记录的全库视图——找某段
 * 具体译文、清理某个语言或某种类型的历史数据时用这个。
 *
 * @package Aipogeo_Context_Translate
 */

defined( 'ABSPATH' ) || exit;

// phpcs:disable WordPress.Security.NonceVerification.Recommended -- 只读筛选，无副作用。
$apgt_filters = array(
	'search_source' => isset( $_GET['search_source'] ) ? sanitize_text_field( wp_unslash( $_GET['search_source'] ) ) : '',
	'search_trans'  => isset( $_GET['search_trans'] ) ? sanitize_text_field( wp_unslash( $_GET['search_trans'] ) ) : '',
	'search_url'    => isset( $_GET['search_url'] ) ? sanitize_text_field( wp_unslash( $_GET['search_url'] ) ) : '',
	'language_from' => isset( $_GET['language_from'] ) ? sanitize_text_field( wp_unslash( $_GET['language_from'] ) ) : '',
	'language_to'   => isset( $_GET['language_to'] ) ? sanitize_text_field( wp_unslash( $_GET['language_to'] ) ) : '',
	'engine'        => isset( $_GET['engine'] ) ? sanitize_text_field( wp_unslash( $_GET['engine'] ) ) : '',
	'type'          => isset( $_GET['type'] ) ? sanitize_text_field( wp_unslash( $_GET['type'] ) ) : '',
	'only_empty'    => ! empty( $_GET['only_empty'] ),
);
$apgt_paged    = isset( $_GET['paged'] ) ? max( 1, (int) $_GET['paged'] ) : 1;
$apgt_pagesize = isset( $_GET['pagesize'] ) ? max( 5, min( 200, (int) $_GET['pagesize'] ) ) : 20;
// phpcs:enable WordPress.Security.NonceVerification.Recommended

$apgt_has_filter = false;
foreach ( $apgt_filters as $apgt_k => $apgt_v ) {
	if ( 'only_empty' === $apgt_k ? $apgt_v : '' !== $apgt_v ) {
		$apgt_has_filter = true;
	}
}

$apgt_result = APGT_Store::query(
	array_merge(
		$apgt_filters,
		array(
			'paged'    => $apgt_paged,
			'pagesize' => $apgt_pagesize,
		)
	)
);

$apgt_total    = (int) $apgt_result['total'];
$apgt_rows     = $apgt_result['rows'];
$apgt_pages    = (int) ceil( $apgt_total / $apgt_pagesize );
$apgt_engines  = APGT_Store::distinct_engines();
$apgt_types    = APGT_Store::distinct_types();
$apgt_langs    = APGT_Store::distinct_languages();

// 语言下拉的候选：库里出现过的 + 站点配置的，去重。
$apgt_from_opts = array();
$apgt_to_opts   = array();
foreach ( $apgt_langs as $apgt_pair ) {
	if ( '' !== $apgt_pair['language_from'] ) {
		$apgt_from_opts[ $apgt_pair['language_from'] ] = true;
	}
	if ( '' !== $apgt_pair['language_to'] ) {
		$apgt_to_opts[ $apgt_pair['language_to'] ] = true;
	}
}
foreach ( array_keys( APGT_Settings::target_languages() ) as $apgt_iso ) {
	$apgt_to_opts[ $apgt_iso ] = true;
}
$apgt_from_opts = array_keys( $apgt_from_opts );
$apgt_to_opts   = array_keys( $apgt_to_opts );
sort( $apgt_from_opts );
sort( $apgt_to_opts );

/**
 * 生成保留当前筛选的链接。
 *
 * @param array $extra 要覆盖的参数。
 * @return string
 */
function apgt_data_url( $extra = array() ) {
	// phpcs:ignore WordPress.Security.NonceVerification.Recommended
	$base = $_GET;
	unset( $base['_wpnonce'] );
	$base = array_merge( $base, $extra );
	$base['page'] = APGT_Admin::PAGE_DATA;
	return admin_url( 'admin.php?' . http_build_query( array_map( 'strval', array_filter( $base, 'strlen' ) ) ) );
}

/**
 * paginate_links 的 base。
 *
 * 占位符 %#% 不能经 http_build_query（会被编码成 %25%23%25，所有页码就都
 * 指向同一个无效地址了），先塞一个不会被编码的记号再换回来。
 *
 * @return string
 */
function apgt_data_page_base() {
	return str_replace(
		'APGTPAGEDPLACEHOLDER',
		'%#%',
		apgt_data_url( array( 'paged' => 'APGTPAGEDPLACEHOLDER' ) )
	);
}

/**
 * 输出分页导航。
 *
 * @param int $pages   总页数。
 * @param int $current 当前页。
 * @return void
 */
function apgt_data_pagination( $pages, $current ) {
	if ( $pages < 2 ) {
		return;
	}
	echo wp_kses_post(
		paginate_links(
			array(
				'base'      => apgt_data_page_base(),
				'format'    => '',
				'prev_text' => '‹',
				'next_text' => '›',
				'total'     => $pages,
				'current'   => $current,
				'type'      => 'plain',
			)
		)
	);
}
?>
<div class="wrap apgt-wrap apgt-data-wrap">
	<h1><?php esc_html_e( 'Translation Data', 'aipogeo-context-translate' ); ?></h1>

	<?php APGT_Admin::render_nav( APGT_Admin::PAGE_DATA ); ?>

	<form method="get" action="<?php echo esc_url( admin_url( 'admin.php' ) ); ?>" id="apgt-data-filter">
		<input type="hidden" name="page" value="<?php echo esc_attr( APGT_Admin::PAGE_DATA ); ?>">

		<div class="apgt-filters">
			<label>
				<span><?php esc_html_e( 'Source contains', 'aipogeo-context-translate' ); ?></span>
				<input type="search" name="search_source" value="<?php echo esc_attr( $apgt_filters['search_source'] ); ?>">
			</label>

			<label>
				<span><?php esc_html_e( 'Translation contains', 'aipogeo-context-translate' ); ?></span>
				<input type="search" name="search_trans" value="<?php echo esc_attr( $apgt_filters['search_trans'] ); ?>">
			</label>

			<label>
				<span><?php esc_html_e( 'Source path', 'aipogeo-context-translate' ); ?></span>
				<input type="search" name="search_url" value="<?php echo esc_attr( $apgt_filters['search_url'] ); ?>" placeholder="/sample-page/">
			</label>

			<label>
				<span><?php esc_html_e( 'Source language', 'aipogeo-context-translate' ); ?></span>
				<select name="language_from">
					<option value=""><?php esc_html_e( 'All', 'aipogeo-context-translate' ); ?></option>
					<?php foreach ( $apgt_from_opts as $apgt_iso ) : ?>
						<option value="<?php echo esc_attr( $apgt_iso ); ?>" <?php selected( $apgt_filters['language_from'], $apgt_iso ); ?>>
							<?php echo esc_html( apgt_language_label( $apgt_iso ) ); ?>
						</option>
					<?php endforeach; ?>
				</select>
			</label>

			<label>
				<span><?php esc_html_e( 'Target language', 'aipogeo-context-translate' ); ?></span>
				<select name="language_to">
					<option value=""><?php esc_html_e( 'All', 'aipogeo-context-translate' ); ?></option>
					<?php foreach ( $apgt_to_opts as $apgt_iso ) : ?>
						<option value="<?php echo esc_attr( $apgt_iso ); ?>" <?php selected( $apgt_filters['language_to'], $apgt_iso ); ?>>
							<?php echo esc_html( apgt_language_label( $apgt_iso ) ); ?>
						</option>
					<?php endforeach; ?>
				</select>
			</label>

			<label>
				<span><?php esc_html_e( 'Engine', 'aipogeo-context-translate' ); ?></span>
				<select name="engine">
					<option value=""><?php esc_html_e( 'All', 'aipogeo-context-translate' ); ?></option>
					<?php foreach ( $apgt_engines as $apgt_engine ) : ?>
						<option value="<?php echo esc_attr( $apgt_engine ); ?>" <?php selected( $apgt_filters['engine'], $apgt_engine ); ?>>
							<?php echo esc_html( $apgt_engine ); ?>
						</option>
					<?php endforeach; ?>
				</select>
			</label>

			<label>
				<span><?php esc_html_e( 'Type', 'aipogeo-context-translate' ); ?></span>
				<select name="type">
					<option value=""><?php esc_html_e( 'All', 'aipogeo-context-translate' ); ?></option>
					<?php foreach ( $apgt_types as $apgt_type ) : ?>
						<option value="<?php echo esc_attr( $apgt_type ); ?>" <?php selected( $apgt_filters['type'], $apgt_type ); ?>>
							<?php echo esc_html( $apgt_type ); ?>
						</option>
					<?php endforeach; ?>
				</select>
			</label>

			<label>
				<span><?php esc_html_e( 'Per page', 'aipogeo-context-translate' ); ?></span>
				<select name="pagesize">
					<?php foreach ( array( 20, 50, 100, 200 ) as $apgt_size ) : ?>
						<option value="<?php echo esc_attr( $apgt_size ); ?>" <?php selected( $apgt_pagesize, $apgt_size ); ?>>
							<?php echo esc_html( $apgt_size ); ?>
						</option>
					<?php endforeach; ?>
				</select>
			</label>

			<label class="apgt-filter-check">
				<input type="checkbox" name="only_empty" value="1" <?php checked( $apgt_filters['only_empty'] ); ?>>
				<?php esc_html_e( 'Empty translations only', 'aipogeo-context-translate' ); ?>
			</label>

			<span class="apgt-filter-actions">
				<button type="submit" class="button button-primary"><?php esc_html_e( 'Filter', 'aipogeo-context-translate' ); ?></button>
				<a href="<?php echo esc_url( admin_url( 'admin.php?page=' . APGT_Admin::PAGE_DATA ) ); ?>" class="button"><?php esc_html_e( 'Reset', 'aipogeo-context-translate' ); ?></a>
			</span>
		</div>
	</form>

	<div class="tablenav top">
		<div class="alignleft actions">
			<button type="button" class="button button-link-delete" id="apgt-delete-search"
				data-total="<?php echo esc_attr( $apgt_total ); ?>"
				<?php disabled( ! $apgt_has_filter || 0 === $apgt_total ); ?>>
				<?php esc_html_e( 'Delete search results', 'aipogeo-context-translate' ); ?>
			</button>
			<?php if ( ! $apgt_has_filter ) : ?>
				<span class="description"><?php esc_html_e( '(set a filter first)', 'aipogeo-context-translate' ); ?></span>
			<?php endif; ?>
		</div>

		<div class="tablenav-pages">
			<span class="displaying-num">
				<?php
				printf(
					/* translators: %s: number of records */
					esc_html( _n( '%s record', '%s records', $apgt_total, 'aipogeo-context-translate' ) ),
					esc_html( number_format_i18n( $apgt_total ) )
				);
				?>
			</span>
			<?php apgt_data_pagination( $apgt_pages, $apgt_paged ); ?>
		</div>
	</div>

	<table class="widefat striped apgt-data-table">
		<thead>
			<tr>
				<th class="apgt-col-id"><?php esc_html_e( 'ID', 'aipogeo-context-translate' ); ?></th>
				<th class="apgt-col-lang"><?php esc_html_e( 'Language', 'aipogeo-context-translate' ); ?></th>
				<th class="apgt-col-engine"><?php esc_html_e( 'Engine', 'aipogeo-context-translate' ); ?></th>
				<th class="apgt-col-type"><?php esc_html_e( 'Type', 'aipogeo-context-translate' ); ?></th>
				<th class="apgt-col-src"><?php esc_html_e( 'Source', 'aipogeo-context-translate' ); ?></th>
				<th class="apgt-col-text"><?php esc_html_e( 'Source text', 'aipogeo-context-translate' ); ?></th>
				<th class="apgt-col-text"><?php esc_html_e( 'Translation (editable)', 'aipogeo-context-translate' ); ?></th>
				<th class="apgt-col-op"><?php esc_html_e( 'Actions', 'aipogeo-context-translate' ); ?></th>
			</tr>
		</thead>
		<tbody>
			<?php if ( empty( $apgt_rows ) ) : ?>
				<tr class="no-items">
					<td colspan="8"><?php esc_html_e( 'No translation records match the filter.', 'aipogeo-context-translate' ); ?></td>
				</tr>
			<?php else : ?>
				<?php foreach ( $apgt_rows as $apgt_row ) : ?>
					<tr data-id="<?php echo esc_attr( $apgt_row['id'] ); ?>">
						<td><?php echo esc_html( $apgt_row['id'] ); ?></td>
						<td>
							<code><?php echo esc_html( $apgt_row['language_from'] ); ?></code>
							<span class="apgt-arrow">→</span>
							<code><?php echo esc_html( $apgt_row['language_to'] ); ?></code>
						</td>
						<td><span class="apgt-badge apgt-badge-<?php echo esc_attr( $apgt_row['engine'] ); ?>"><?php echo esc_html( $apgt_row['engine'] ); ?></span></td>
						<td><span class="apgt-badge"><?php echo esc_html( $apgt_row['type'] ); ?></span></td>
						<td>
							<?php if ( '' !== (string) $apgt_row['source_url'] ) : ?>
								<a href="<?php echo esc_url( apgt_data_url( array( 'search_url' => $apgt_row['source_url'], 'paged' => 1 ) ) ); ?>"
									title="<?php echo esc_attr( $apgt_row['source_url'] ); ?>">
									<?php echo esc_html( mb_strimwidth( $apgt_row['source_url'], 0, 40, '…' ) ); ?>
								</a>
							<?php else : ?>
								<span class="apgt-muted">—</span>
							<?php endif; ?>
						</td>
						<td class="apgt-cell-text"><textarea class="apgt-data-source" readonly><?php echo esc_textarea( $apgt_row['text_source'] ); ?></textarea></td>
						<td class="apgt-cell-text">
							<textarea class="apgt-data-trans"
								data-original="<?php echo esc_attr( $apgt_row['text_trans'] ); ?>"><?php echo esc_textarea( $apgt_row['text_trans'] ); ?></textarea>
							<span class="apgt-save-status"></span>
						</td>
						<td>
							<button type="button" class="button-link delete apgt-data-delete"><?php esc_html_e( 'Delete', 'aipogeo-context-translate' ); ?></button>
						</td>
					</tr>
				<?php endforeach; ?>
			<?php endif; ?>
		</tbody>
	</table>

	<div class="tablenav bottom">
		<div class="tablenav-pages">
			<?php apgt_data_pagination( $apgt_pages, $apgt_paged ); ?>
		</div>
	</div>

	<p class="description">
		<?php esc_html_e( 'Editing a translation saves it immediately and marks the engine as manual, so later bulk AI runs will not overwrite it. Deleting a record also invalidates the translation progress of the pages it belongs to, sending those pages back to pending.', 'aipogeo-context-translate' ); ?>
	</p>
</div>