芝麻web文件管理V1.00

编辑当前文件:/home/sditechnicalteam/socialdigivlms.com/wp-content/plugins/tutor/restapi/REST_Quiz.php

<?php
/**
 * REST API for quiz.
 *
 * @package Tutor\RestAPI
 * @author Themeum <support@themeum.com>
 * @link https://themeum.com
 * @since 1.7.1
 */

namespace TUTOR;

use Tutor\Helpers\QueryHelper;
use Tutor\Models\QuizModel;
use WP_REST_Request;

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

/**
 * Class REST_Quiz
 */
class REST_Quiz {

use REST_Response;

/**
	 * Quiz post type
	 *
	 * @var string The post type for quizzes.
	 */
	private $post_type = 'tutor_quiz';

/**
	 * Post parent ID
	 *
	 * @var int|null The post parent ID.
	 */
	private $post_parent;

/**
	 * Quiz questions table name
	 *
	 * @var string The table name for quiz questions.
	 */
	private $t_quiz_question = 'tutor_quiz_questions';

/**
	 * Quiz question answers table name
	 *
	 * @var string The table name for quiz question answers.
	 */
	private $t_quiz_ques_ans = 'tutor_quiz_question_answers';

/**
	 * Quiz question answer options table name
	 *
	 * @var string The table name for quiz attempts.
	 */
	private $t_quiz_attempt = 'tutor_quiz_attempts';

/**
	 * Quiz attempt answers table name
	 *
	 * @var string The table name for quiz attempt answers.
	 */
	private $t_quiz_attempt_ans = 'tutor_quiz_attempt_answers';

/**
	 * Obtain quiz detail for a single quiz.
	 *
	 * @since 2.7.1
	 *
	 * @param WP_REST_Request $request REST request object.
	 *
	 * @return mixed
	 */
	public function get_quiz( WP_REST_Request $request ) {
		global $wpdb;

$quiz_id   = Input::sanitize( $request->get_param( 'id' ), 0, Input::TYPE_INT );
		$wpdb->q_t = $wpdb->prefix . $this->t_quiz_question; // Question table.

$wpdb->q_a_t = $wpdb->prefix . $this->t_quiz_ques_ans; // Question answer table.

$quiz = $wpdb->get_row(
			$wpdb->prepare(
				"SELECT 
					ID,
					post_title,
					post_content,
					post_name
				FROM {$wpdb->posts}
				WHERE post_type = %s 
					AND ID = %d
				",
				$this->post_type,
				$quiz_id
			)
		);

if ( ! isset( $quiz ) ) {
			$response = array(
				'code'    => 'not_found',
				'message' => __( 'Quiz not found for given ID', 'tutor' ),
				'data'    => array(),
			);
			return self::send( $response );
		}

$quiz->quiz_settings = get_post_meta( $quiz->ID, 'tutor_quiz_option', false );
		$questions           = $wpdb->get_results(
			$wpdb->prepare(
				"SELECT
				question_id,
				question_title,
				question_description,
				question_type,
				question_mark,
				question_settings FROM {$wpdb->q_t}
				WHERE quiz_id = %d
				",
				$quiz->ID
			)
		);

foreach ( $questions as $question ) {
			if ( isset( $quiz->question_settings ) ) {
				$question->question_settings = maybe_unserialize( $quiz->question_settings );
			}

$question->question_answers = QuizModel::get_question_answers( $question->question_id, $question->question_type );
		}

$quiz->quiz_questions = $questions;

$response = array(
			'code'    => 'success',
			'message' => __( 'Quiz retrieved successfully', 'tutor' ),
			'data'    => $quiz,
		);

return self::send( $response );
	}

/**
	 * Get quiz with settings.
	 *
	 * @since 1.7.1
	 *
	 * @param WP_REST_Request $request REST request object.
	 *
	 * @return mixed
	 */
	public function quiz_with_settings( WP_REST_Request $request ) {
		$this->post_parent = $request->get_param( 'topic_id' );

global $wpdb;

$quizs = $wpdb->get_results(
			$wpdb->prepare(
				"SELECT 
					ID,
					post_title,
					post_content,
					post_name
				FROM {$wpdb->posts}
				WHERE post_type = %s 
					AND post_parent = %d
				",
				$this->post_type,
				$this->post_parent
			)
		);

$data = array();

if ( count( $quizs ) > 0 ) {
			foreach ( $quizs as $quiz ) {
				$quiz->quiz_settings = get_post_meta( $quiz->ID, 'tutor_quiz_option', false );

array_push( $data, $quiz );

$response = array(
					'code'    => 'success',
					'message' => __( 'Quiz retrieved successfully', 'tutor' ),
					'data'    => $data,
				);
			}
			return self::send( $response );
		}

$response = array(
			'code'    => 'not_found',
			'message' => __( 'Quiz not found for given ID', 'tutor' ),
			'data'    => $data,
		);
		return self::send( $response );
	}

/**
	 * Get quiz question and answers.
	 *
	 * @param WP_REST_Request $request REST request object.
	 *
	 * @return mixed
	 */
	public function quiz_question_ans( WP_REST_Request $request ) {
		global $wpdb;

$this->post_parent = $request->get_param( 'id' );

$wpdb->q_t = $wpdb->prefix . $this->t_quiz_question; // Question table.

$wpdb->q_a_t = $wpdb->prefix . $this->t_quiz_ques_ans; // Question answer table.

$quizs = $wpdb->get_results(
			$wpdb->prepare(
				"SELECT
				question_id,
				question_title,
				question_description,
				question_type,
				question_mark,
				question_settings FROM {$wpdb->q_t}
				WHERE quiz_id = %d
				",
				$this->post_parent
			)
		);
		$data  = array();

if ( count( $quizs ) > 0 ) {
			// Get question ans by question_id.
			foreach ( $quizs as $quiz ) {
				// Un-serialized question settings.
				$quiz->question_settings = maybe_unserialize( $quiz->question_settings );

// question options with correct ans.
				$options = $wpdb->get_results(
					$wpdb->prepare(
						"SELECT
						answer_id,
						answer_title,
						is_correct FROM {$wpdb->q_a_t}
						WHERE belongs_question_id = %d
						",
						$quiz->question_id
					)
				);

// set question_answers as quiz property.
				$quiz->question_answers = $options;

array_push( $data, $quiz );
			}

$response = array(
				'code'    => 'success',
				'message' => __( 'Question retrieved successfully', 'tutor' ),
				'data'    => $data,
			);

return self::send( $response );
		}

$response = array(
			'code'    => 'not_found',
			'message' => __( 'Question not found for given ID', 'tutor' ),
			'data'    => array(),
		);

return self::send( $response );
	}

/**
	 * Get quiz attempt details.
	 *
	 * @since 1.7.1
	 *
	 * @param WP_REST_Request $request REST request object.
	 *
	 * @return mixed
	 */
	public function quiz_attempt_details( WP_REST_Request $request ) {
		global $wpdb;

$quiz_id = $request->get_param( 'id' );

$wpdb->quiz_attempt = $wpdb->prefix . $this->t_quiz_attempt;

$attempts = $wpdb->get_results(
			$wpdb->prepare(
				"SELECT
				att.user_id,
				att.total_questions,
				att.total_answered_questions,
				att.total_marks,
				att.earned_marks,
				att.attempt_info,
				att.attempt_status,
				att.attempt_started_at,
				att.attempt_ended_at,
				att.is_manually_reviewed,
				att.manually_reviewed_at 
			FROM {$wpdb->quiz_attempt} att 
				WHERE att.quiz_id = %d
			",
				$quiz_id
			)
		);

if ( count( $attempts ) > 0 ) {
			// unserialize each attempt info.
			foreach ( $attempts as $key => $attempt ) {
				$attempt->attempt_info = maybe_unserialize( $attempt->attempt_info );
				// attach attempt ans.
				$answers = $this->get_quiz_attempt_ans( $quiz_id );

if ( false !== $answers ) {
					$attempt->attempts_answer = $answers;
				} else {
					$attempt->attempts_answer = array();
				}
			}

$response = array(
				'code'    => 'success',
				'message' => __( 'Quiz attempts retrieved successfully', 'tutor' ),
				'data'    => $attempts,
			);

return self::send( $response );
		}

$response = array(
			'code'    => 'not_found',
			'message' => __( 'Quiz attempts not found for given ID', 'tutor' ),
			'data'    => array(),
		);

return self::send( $response );
	}

/**
	 * Get quiz attempt answers.
	 *
	 * @since 1.7.1
	 *
	 * @param int $quiz_id quiz id.
	 *
	 * @return mixed
	 */
	protected function get_quiz_attempt_ans( $quiz_id ) {
		global $wpdb;
		$wpdb->quiz_attempt_ans = $wpdb->prefix . $this->t_quiz_attempt_ans;
		$wpdb->quiz_question    = $wpdb->prefix . $this->t_quiz_question;

// get attempt answers.
		$answers = $wpdb->get_results(
			$wpdb->prepare(
				"SELECT
				q.question_title,
				att_ans.given_answer,
				att_ans.question_mark,
				att_ans.achieved_mark,
				att_ans.minus_mark,
				att_ans.is_correct FROM {$wpdb->quiz_attempt_ans} as att_ans
			JOIN {$wpdb->quiz_question} q ON q.question_id = att_ans.question_id 
			WHERE att_ans.quiz_id = %d
			",
				$quiz_id
			)
		);

if ( count( $answers ) > 0 ) {
			// unserialize each given answer.
			foreach ( $answers as $key => $answer ) {
				$answer->given_answer = maybe_unserialize( $answer->given_answer );

if ( is_numeric( $answer->given_answer ) || is_array( $answer->given_answer ) ) {
					$ids                  = $answer->given_answer;
					$ans_title            = $this->answer_titles_by_id( $ids );
					$answer->given_answer = $ans_title;
				}
			}

return $answers;
		}
		return false;
	}

/**
	 * Get answer titles by id.
	 *
	 * @since 1.7.1
	 *
	 * @param int $id answer id.
	 *
	 * @return mixed
	 */
	protected function answer_titles_by_id( $id ) {
		global $wpdb;
		$wpdb->t_quiz_ques_ans = $wpdb->prefix . $this->t_quiz_ques_ans;

if ( is_array( $id ) ) {
			$array = QueryHelper::prepare_in_clause( $id );

$results = $wpdb->get_results(
				"SELECT
					answer_title
				FROM {$wpdb->t_quiz_ques_ans} 
				WHERE 
				answer_id IN ('" . $array . "')"//phpcs:ignore
			);
		} else {
			$results = $wpdb->get_results(
				$wpdb->prepare(
					"SELECT
					answer_title
				FROM {$wpdb->t_quiz_ques_ans}
				WHERE answer_id = %d",
					$id
				)
			);
		}

return $results;
	}
}