<?php

defined( 'ABSPATH' ) || exit;

class Persian_Woocommerce_Translate extends Persian_Woocommerce_Core {

	const TRANSLATE_OPTION_KEY = 'persian_woocommerce_translates';

	static $translates;

	public $table;

	public function __construct() {

		self::$translates = get_option( self::TRANSLATE_OPTION_KEY );

		$this->translates();
		add_filter( 'override_unload_textdomain', [ $this, 'unload_textdomain' ], 9999, 2 );
		add_filter( 'load_textdomain_mofile', [ $this, 'load_textdomain' ], 10, 2 );

		add_action( 'add_meta_boxes', [ $this, 'add_meta_box' ] );
		add_action( 'admin_init', [ $this, 'search_delete' ] );

		add_action( 'wp_ajax_pw_save_translates', [ $this, 'save_translates' ] );
	}

	public function unload_textdomain( $override, $domain ) {
		return get_locale() == 'fa_IR' && $domain === 'woocommerce' ? true : $override;
	}

	public function load_textdomain( $mo_file, $domain ) {
		if ( get_locale() == 'fa_IR' && $domain === 'woocommerce' ) {
			$mo_file = dirname( plugin_dir_path( __FILE__ ) ) . '/languages/woocommerce-fa_IR.mo';
		}

		return $mo_file;
	}

	public function translates() {
		global $wpdb;

		$this->table = $wpdb->prefix . 'woocommerce_ir';

		if ( ! is_array( self::$translates ) ) {
			$wpdb->suppress_errors = true;
			$result                = $wpdb->get_results( "SELECT * FROM {$this->table};" );
			$wpdb->suppress_errors = false;

			if ( ! $wpdb->last_error ) {
				self::$translates = wp_list_pluck( $result, 'text2', 'text1' );
				update_option( self::TRANSLATE_OPTION_KEY, self::$translates, 'yes' );
			}
		}

		if ( is_array( self::$translates ) && count( self::$translates ) ) {
			add_filter( 'gettext_with_context', [ $this, 'gettext' ] );
			add_filter( 'ngettext_with_context', [ $this, 'gettext' ] );
			add_filter( 'gettext', [ $this, 'gettext' ] );
			add_filter( 'ngettext', [ $this, 'gettext' ] );
		}
	}

	public function gettext( $text ) {
		return self::$translates[ $text ] ?? $text;
	}

	public function translate_page() {
		do_action( 'add_meta_boxes', 'woocommerce_persian_translate', 0 );
		?>
		<div class="wrap">
			<h2 id="title">حلقه های ترجمه</h2>
			<div class="fx-settings-meta-box-wrap">
				<div id="poststuff">
					<div id="post-body" class="metabox-holder columns-2">
						<div id="postbox-container-1" class="postbox-container">
							<?php do_meta_boxes( 'woocommerce_persian_translate', 'side', null ); ?>
						</div>

						<div id="postbox-container-2" class="postbox-container">
							<?php settings_errors();
							echo '<form method="POST" id="list-project">';
							echo '<input type="hidden" name="page" value="persian-wc" />';
							wp_nonce_field( 'delete_item', 'pw_translate_nonce' );
							$list = new Persian_Woocommerce_Translate_List_Table();
							$list->prepare_items();
							$list->search_box( 'جستجو', 'PW-search-input' );
							$list->display();
							echo '</form>';
							?>
							<div class="clear"></div>
						</div>
					</div>
					<br class="clear">
				</div>
			</div>
		</div>
		<script type="text/javascript">
            jQuery(document).ready(function ($) {
                $("#woocommerce_persian_translate").submit(function () {
                    $("#save_loop_button").val("در حال ذخیره ...");
                    jQuery.post(ajaxurl, $("#woocommerce_persian_translate").serialize(), function (response) {
                        var obj = jQuery.parseJSON(response);
                        if (obj.success) {
                            $("#the-list").prepend(obj.code);
                            $(".displaying-num").html(obj.count);
                            document.getElementById("woocommerce_persian_translate").reset();
                            if (obj.count === "1 مورد") {
                                $("tr.no-items").remove();
                                $(".tablenav-pages").removeClass("no-pages").addClass("one-page");
                            }
                        }
                        setTimeout(function () {
                            $("#setting-error-pw_msg_" + obj.rand).slideUp('slow', function () {
                                $("#setting-error-pw_msg_" + obj.rand).remove();
                            })
                        }, 3000);
                        $(".wrap h2#title").after(obj.message);
                    });
                    setTimeout(function () {
                        $("#save_loop_button").val("ذخیره حلقه");
                    }, 2000);
                    return false;
                });
            });
		</script>
		<?php
	}

	public function add_meta_box() {
		add_meta_box( 'add_form', 'افزودن حلقه ترجمه', [
			$this,
			'meta_box_form',
		], 'woocommerce_persian_translate', 'side', 'high' );
	}

	public function meta_box_form() {
		?>
		<form action="" method="post" id="woocommerce_persian_translate">
			<input type="hidden" name="s" value="<?php echo esc_attr( sanitize_text_field( $_GET['s'] ?? null ) ); ?>"/>
			<input type="hidden" name="action" value="pw_save_translates"/>
			<input type="hidden" name="security"
				   value="<?php echo wp_create_nonce( 'pw_save_translates' ); ?>"/>
			<label for="input_text_1">کلمه‌ی مورد نظر:</label>
			<input type="text" class="widefat" id="input_text_1" name="text1"/>
			<br>
			<label for="input_text_2">جایگزین شود با:</label>
			<input type="text" class="widefat" id="input_text_2" name="text2"/>
			<?php echo '</div>'; ?>
			<div id="major-publishing-actions">
				<div id="publishing-action">
					<span class="spinner"></span>
					<?php submit_button( 'ذخیره حلقه', 'primary', 'submit', false, [ 'id' => 'save_loop_button' ] ); ?>
				</div>
				<div class="clear"></div>
		</form>
		<?php
	}

	public function save_translates() {
		global $wpdb;

		check_ajax_referer( 'pw_save_translates', 'security' );

		delete_option( self::TRANSLATE_OPTION_KEY );

		$json = [
			'success' => false,
			'message' => 'مشکلی هنگام افزودن حلقه رخ داده است. لطفا مجددا تلاش کنید.',
			'rand'    => mt_rand(),
		];

		if ( ! isset( $_POST['text1'], $_POST['text2'], $_POST['s'] ) ) {
			die( json_encode( $json ) );
		}

		$text1 = wp_kses_data( $_POST['text1'] );
		$text2 = wp_kses_data( $_POST['text2'] );
		$s     = sanitize_text_field( $_POST['s'] );

		if ( empty( $text1 ) ) {
			$json['message'] = sprintf( '<div id="setting-error-pw_msg_%d" class="error settings-error notice is-dismissible"><p><strong>پر کردن فیلد کلمه‌ی مورد نظر اجباری می باشد.</strong></p><button type="button" class="notice-dismiss"><span class="screen-reader-text">بستن این اعلان.</span></button></div>', $json['rand'] );
			die( json_encode( $json ) );
		}

		$insert = $wpdb->insert( $this->table, [
			'text1' => esc_html( $text1 ),
			'text2' => esc_html( $text2 ),
		] );

		if ( ! $insert ) {
			$json['message'] = sprintf( '<div id="setting-error-pw_msg_%d" class="error settings-error notice is-dismissible"><p><strong>خطایی در زمان افزودن حلقه (%s => %s) به دیتابیس رخ داده است. لطفا مجددا تلاش کنید</strong></p><button type="button" class="notice-dismiss"><span class="screen-reader-text">بستن این اعلان.</span></button></div>', $json['rand'], $text1, $text2 );
			die( json_encode( $json ) );
		}

		$json['success'] = true;
		$json['message'] = sprintf( '<div id="setting-error-pw_msg_%d" class="updated settings-error notice is-dismissible"><p><strong>حلقه (%s => %s) با موفقیت افزوده شد.</strong></p><button type="button" class="notice-dismiss"><span class="screen-reader-text">بستن این اعلان.</span></button></div>', $json['rand'], $text1, $text2 );

		$json['code'] = '';

		if ( empty( $s ) || array_search( $s, [
				$text1,
				$text2,
			] ) !== false ) {
			$json['code'] = sprintf( '<tr id="PW_item_%1$d" data-id="%1$d"><th scope="row" class="check-column"><input name="text_delete_id[]" value="%1$d" type="checkbox"></th><td class="text1 column-text1 has-row-actions column-primary" data-colname="حلقه‌ی اصلی">%2$s<button type="button" class="toggle-row"><span class="screen-reader-text">نمایش جزئیات بیشتر</span></button></td><td class="text2 column-text2" data-colname="حلقه‌ی جایگزین شده">%3$s</td></tr>', $wpdb->insert_id, $text1, $text2 );
		}

		$search = empty( $s ) ? '' : sprintf( ' WHERE text1 LIKE "%%%1$s%%" OR text2 LIKE "%%%1$s%%"', $s );

		$json['count'] = $wpdb->get_var( "SELECT COUNT(*) FROM $this->table{$search}" ) . " مورد";

		die( json_encode( $json ) );
	}

	public function search_delete() {
		global $wpdb;

		$page = sanitize_text_field( $_GET['page'] ?? null );

		if ( $page != 'persian-wc' ) {
			return;
		}

		if ( isset( $_POST['action'], $_POST['text_delete_id'] ) && check_admin_referer( 'delete_item', 'pw_translate_nonce' ) ) {
			$success = $failed = 0;

			foreach ( (array) $_POST['text_delete_id'] as $delete_id ) {

				$delete = $wpdb->delete( $wpdb->prefix . 'woocommerce_ir', [ 'id' => intval( $delete_id ) ] );

				if ( $delete ) {
					$success ++;
				} else {
					$failed ++;
				}
			}

			delete_option( self::TRANSLATE_OPTION_KEY );

			if ( $success ) {
				add_settings_error( 'delete_text', 'pw_msg', sprintf( '%d حلقه با موفقیت حذف شد.', $success ), 'updated' );
			}

			if ( $failed ) {
				add_settings_error( 'delete_text', 'pw_msg', sprintf( 'حذف %d حلقه با شکست مواجه شد.', $failed ) );
			}
		}

		if ( isset( $_POST['s'] ) ) {

			if ( empty( $_POST['s'] ) ) {
				wp_redirect( remove_query_arg( [ 's' ] ) );
			} else {
				wp_redirect( add_query_arg( [ 's' => urlencode( $_POST['s'] ) ] ) );
			}

			exit;
		}
	}
}

PW()->translate = new Persian_Woocommerce_Translate();

if ( ! class_exists( 'WP_List_Table' ) ) {
	require_once( ABSPATH . 'wp-admin/includes/class-wp-list-table.php' );
}

class Persian_Woocommerce_Translate_List_Table extends WP_List_Table {

	private $data;

	public function __construct() {
		global $wpdb;

		$table   = $wpdb->prefix . 'woocommerce_ir';
		$perPage = 20;
		$db_page = ( $this->get_pagenum() - 1 ) * $perPage;

		$s = sanitize_text_field( trim( $_GET['s'] ?? '' ) );

		$query       = $wpdb->prepare( "SELECT * FROM %i 
								 WHERE `text1` LIKE '%%%s%' OR `text2` LIKE '%%%s%'
							 ORDER BY `id` DESC LIMIT %d, %d;", $table, $s, $s, $db_page, $perPage );
		$total_query = $wpdb->prepare( "SELECT COUNT(*) FROM %i WHERE `text1` LIKE '%%%s%' OR `text2` LIKE '%%%s%';", $table, $s, $s );

		$this->data = $wpdb->get_results( $query, ARRAY_A );

		$this->set_pagination_args( [
			'total_items' => $wpdb->get_var( $total_query ),
			'per_page'    => $perPage,
		] );

		parent::__construct( [
			'singular' => 'text',
			'plural'   => 'texts',
			'ajax'     => false,
		] );
	}

	public function column_default( $item, $column_name ): string {
		return esc_html( $item[ $column_name ] ?? null );
	}

	public function get_columns(): array {
		return [
			'cb'    => '<input type="checkbox" />',
			'text1' => 'کلمه اصلی',
			'text2' => 'کلمه جایگزین شده',
		];
	}

	public function column_cb( $item ): string {
		return sprintf( '<input type="checkbox" name="text_delete_id[]" value="%d" />', $item['id'] );
	}

	public function prepare_items() {
		$this->_column_headers = [ $this->get_columns(), [], [] ];
		$this->items           = $this->data;;
	}

	public function single_row( $item ) {
		printf( '<tr id="PW_item_%1$d" data-id="%1$d">', $item['id'] );
		$this->single_row_columns( $item );
		echo '</tr>';
	}

	public function get_bulk_actions(): array {
		return [
			'delete' => 'حذف',
		];
	}
}
