<?php
/**
 * Functions
 *
 * @package GamiPress\FluentCommunity\Functions
 * @since 1.0.0
 */

// Exit if accessed directly
if( !defined( 'ABSPATH' ) ) exit;

/**
 * Overrides GamiPress AJAX Helper for selecting posts
 *
 * @since 1.0.0
 */
function gamipress_fluentcommunity_ajax_get_posts() {

    // Security check, forces to die if not security passed
    check_ajax_referer( 'gamipress_admin', 'nonce' );

    // Check if user can manage GamiPress
    if( ! current_user_can( gamipress_get_manager_capability() ) ) {
        wp_send_json_error( __( 'You\'re not allowed to perform this action.', 'gamipress' ) );
    }

    global $wpdb;

    $results = array();

    // Pull back the search string
    $search = isset( $_REQUEST['q'] ) ? $wpdb->esc_like( sanitize_text_field( $_REQUEST['q'] ) ) : '';

    if( isset( $_REQUEST['post_type'] ) && in_array( 'fluentcommunity_spaces', $_REQUEST['post_type'] ) ) {

        $spaces = \FluentCommunity\App\Functions\Utility::getSpaces();

        foreach ( $spaces as $space ) {

            // Results should meet same structure like posts
            $results[] = array(
                'ID' => $space['id'],
                'post_title' => $space['title'],
            );

        }

        // Return our results
        wp_send_json_success( $results );
        die;

    } else if( isset( $_REQUEST['post_type'] ) && in_array( 'fluentcommunity_courses', $_REQUEST['post_type'] ) ) {

        $courses = \FluentCommunity\App\Functions\Utility::getCourses();

        foreach ( $courses as $course ) {

            // Results should meet same structure like posts
            $results[] = array(
                'ID' => $course['id'],
                'post_title' => $course['title'],
            );

        }

        // Return our results
        wp_send_json_success( $results );
        die;

    } else if( isset( $_REQUEST['post_type'] ) && in_array( 'fluentcommunity_quizzes', $_REQUEST['post_type'] ) ) {

        // Return quizzes
        $quizzes = $wpdb->get_results(
            $wpdb->prepare(
                "SELECT id, title FROM {$wpdb->prefix}fcom_posts WHERE type = %s AND content_type = %s AND status = %s",
                'course_lesson',
                'quiz',
                'published'
            )
        );  

        foreach ( $quizzes as $quiz ) {

            // Results should meet same structure like posts
            $results[] = array(
                'ID'    => $quiz->id,
                'post_title'  => $quiz->title,
            );   

        }

        // Return our results
        wp_send_json_success( $results );
        die;

    } else if( isset( $_REQUEST['post_type'] ) && in_array( 'fluentcommunity_lessons', $_REQUEST['post_type'] ) ) {

        // Return lessons
        $lessons = $wpdb->get_results(
            $wpdb->prepare(
                "SELECT id, title FROM {$wpdb->prefix}fcom_posts WHERE type = %s AND content_type = %s AND status = %s",
                'course_lesson',
                'text',
                'published'
            )
        );  

        foreach ( $lessons as $lesson ) {

            // Results should meet same structure like posts
            $results[] = array(
                'ID'    => $lesson->id,
                'post_title'  => $lesson->title,
            );   

        }

        // Return our results
        wp_send_json_success( $results );
        die;

    }

}
add_action( 'wp_ajax_gamipress_get_posts', 'gamipress_fluentcommunity_ajax_get_posts', 5 );

/**
 * Get the space title
 * 
 * @param int $space_id
 *
 * @since 1.0.0
 */
function gamipress_fluentcommunity_get_space_title( $space_id ) {

    if( absint( $space_id ) === 0 ) {
        return '';
    }

    $spaces = \FluentCommunity\App\Functions\Utility::getSpaces();

    foreach ( $spaces as $space ) {
        if ( absint( $space['id'] ) === absint( $space_id ) ) {
            return $space['title']; 
        }
    }

}

/**
 * Get the course title
 * 
 * @param int $course_id
 *
 * @since 1.0.0
 */
function gamipress_fluentcommunity_get_course_title( $course_id ) {

    if( absint( $course_id ) === 0 ) {
        return '';
    }

    $courses = \FluentCommunity\App\Functions\Utility::getCourses();

    foreach ( $courses as $course ) {
        if ( absint( $course['id'] ) === absint( $course_id ) ) {
            return $course['title']; 
        }
    }

}

/**
 * Get the quiz title
 * 
 * @param int $quiz_id
 *
 * @since 1.0.0
 */
function gamipress_fluentcommunity_get_quiz_title( $quiz_id ) {

    global $wpdb;

    // Empty title if no ID provided
    if( absint( $quiz_id ) === 0 ) {
        return '';
    }

    // Get quiz title
    $quiz = $wpdb->get_var(
        $wpdb->prepare(
            "SELECT title FROM {$wpdb->prefix}fcom_posts WHERE id = %d",
            absint( $quiz_id )
        )
    );  

    return $quiz;

}

/**
 * Get the lesson title
 * 
 * @param int $lesson_id
 *
 * @since 1.0.0
 */
function gamipress_fluentcommunity_get_lesson_title( $lesson_id ) {

    global $wpdb;

    // Empty title if no ID provided
    if( absint( $lesson_id ) === 0 ) {
        return '';
    }

    // Get lesson title
    $lesson = $wpdb->get_var(
        $wpdb->prepare(
            "SELECT title FROM {$wpdb->prefix}fcom_posts WHERE id = %d",
            absint( $lesson_id )
        )
    );  

    return $lesson;

}