<?php

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

/**
 * Class that handles migration logic
 *
 * @since 7.3.0
 */
class QSM_Migrate {


	public function __construct() {
		add_action( 'wp_ajax_enable_multiple_categories', array( $this, 'enable_multiple_categories' ) );
	}

	/**
	 * This function enables multiple categories feature in QSM
	 *
	 * @since 7.3.0
	 * @return void
	 */
	public function enable_multiple_categories() {
		if ( ! isset( $_POST['nonce'] ) || ! wp_verify_nonce( sanitize_text_field( wp_unslash( $_POST['nonce'] ) ), 'wp_rest' ) ) {
			wp_send_json_error();
		}
		global $wpdb;
		global $mlwQuizMasterNext;
		$value = isset( $_POST['value'] ) ? sanitize_text_field( wp_unslash( $_POST['value'] ) ) : '';
		switch ( $value ) {
			case 'enable':
				$new_category  = '';
				$term_id       = 0;
				$values_array  = array();
				$result        = false;
				$category_data = $wpdb->get_results( "SELECT question_id, quiz_id, category FROM {$wpdb->prefix}mlw_questions WHERE category <> '' ORDER BY category" );
				if ( ! empty( $category_data ) ) {
					foreach ( $category_data as $data ) {
						if ( $new_category != $data->category ) {
							$term_data = get_term_by( 'name', $data->category, 'qsm_category' );
							if ( $term_data ) {
								$term_id = $term_data->term_id;
							} else {
								$term_array  = wp_insert_term( $data->category, 'qsm_category' );
								$term_id     = $term_array['term_id'];
							}
						}
						$values_array[] = "($data->question_id, $data->quiz_id, $term_id, 'qsm_category')";
					}
					$values          = join( ',', $values_array );
					$insert_query    = stripslashes( $wpdb->prepare( "INSERT INTO {$wpdb->prefix}mlw_question_terms (question_id, quiz_id, term_id, taxonomy) VALUES %1s", $values ) );
					$result          = $wpdb->query( $insert_query );
					if ( $result > 0 ) {
						update_option( 'qsm_multiple_category_enabled', gmdate( time() ) );
						$update      = "UPDATE {$wpdb->prefix}mlw_questions SET category = '' ";
						$updated     = $wpdb->query( $update );
						wp_send_json_success();
					} else {
						wp_send_json_error();
					}
				} else {
					update_option( 'qsm_multiple_category_enabled', gmdate( time() ) );
				}
				wp_send_json_success();
				break;

			case 'cancel':
				update_option( 'qsm_multiple_category_enabled', 'cancelled' );
				wp_send_json_success();
				break;
		}
		exit;
	}

	/**
	 * This function check which regime of category is available and returns category data accordingly
	 *
	 * @param string $name
	 * @return array
	 */
	public function get_category_data( $name ) {
		$enabled  = get_option( 'qsm_multiple_category_enabled' );
		$migrated = false;
		if ( $enabled && 'cancelled' !== $enabled ) {
			$migrated = true;
		}

		$response = array(
			'migrated' => $migrated,
		);

		if ( $migrated ) {
			$cats = explode( '_', $name );
			$ids  = array();
			foreach ( $cats as $category ) {
				$category = trim( $category );
				if ( '' !== $category ) {
					$cat_data = get_term_by( 'name', $category, 'qsm_category' );
					if ( $cat_data ) {
						$ids[] = $cat_data->term_id;
					}
				}
			}

			if ( ! empty( $ids ) ) {
				$response['ids'] = $ids;
			} else {
				$response['migrated'] = false;
				$response['name']     = $name;
			}
		} else {
			$response['name'] = $name;
		}

		return $response;
	}

	public static function fix_duplicate_questions() {
		global $wpdb, $mlwQuizMasterNext;
		$all_quizzes = $wpdb->get_results( "SELECT `quiz_id`, `quiz_settings` FROM `{$wpdb->prefix}mlw_quizzes` ORDER BY `quiz_id` DESC" );
		if ( ! empty( $all_quizzes ) ) {
			foreach ( $all_quizzes as $quiz ) {
				$quiz_id     = $quiz->quiz_id;
				$settings    = ! empty( $quiz->quiz_settings ) ? maybe_unserialize( $quiz->quiz_settings ) : array();
				$pages       = isset( $settings['pages'] ) ? maybe_unserialize( $settings['pages'] ) : array();
				$qpages      = isset( $settings['qpages'] ) ? maybe_unserialize( $settings['qpages'] ) : array();
				if ( ! empty( $pages ) ) {
					foreach ( $pages as $key => $page ) {
						$questions       = array_unique( $page );
						$pages[ $key ]     = $questions;
						if ( ! isset( $qpages[ $key ] ) ) {
							$qpages[ $key ] = array();
						}
						$qpages[ $key ]['questions'] = $questions;
					}
				}
				/**
				 * Setup new data
				 */
				$settings['pages']   = ! empty( $pages ) && is_array( $pages) ? maybe_serialize( $pages ) : "";
				$settings['qpages']  = ! empty( $qpages ) && is_array( $qpages) ? maybe_serialize( $qpages ) : "";
				/**
				 * Update quiz settings
				 */
				$wpdb->update( $wpdb->prefix . 'mlw_quizzes', array( 'quiz_settings' => maybe_serialize( $settings ) ), array( 'quiz_id' => $quiz_id ), array( '%s' ), array( '%d' ) );
			}
		}
		update_option( 'fixed_duplicate_questions', 1 );

		return;
	}

	/**
	 * This function check qsm post have assigned a quiz
	 *
	 * @since 8.0.3
	 * @return void
	 */
	public static function fix_deleted_quiz_posts() {
		global $wpdb;
		$qsm_post_list = get_posts( array(
			'post_type'      => 'qsm_quiz',
			'posts_per_page' => -1,
			'fields'         => 'ids',
			'post_status'    => array( 'publish', 'pending', 'draft', 'auto-draft', 'future', 'private', 'inherit', 'trash' ),
		) );
		$qmn_quiz_ids  = $wpdb->get_results( "SELECT `quiz_id` FROM `{$wpdb->prefix}mlw_quizzes` WHERE `deleted`='0'" );
		if ( ! empty( $qsm_post_list ) ) {
			$quiz_ids = array( 0 );
			if ( ! empty( $qmn_quiz_ids ) ) {
				$quiz_ids = array_column( $qmn_quiz_ids, 'quiz_id' );
			}
			foreach ( $qsm_post_list as $post_id ) {
				$quiz_id = get_post_meta( $post_id, 'quiz_id', true );
				if ( empty( $quiz_id ) || ! in_array( $quiz_id , $quiz_ids, true) ) {
					wp_delete_post( $post_id );
				}
			}
		}
		update_option( 'fix_deleted_quiz_posts', 1 );
	}

}