Addons.php
5 years ago
Admin.php
5 years ago
Ajax.php
5 years ago
Assets.php
5 years ago
Course.php
5 years ago
Course_Settings_Tabs.php
5 years ago
Course_Widget.php
5 years ago
Dashboard.php
5 years ago
Email.php
5 years ago
FormHandler.php
5 years ago
Frontend.php
5 years ago
Gutenberg.php
5 years ago
Instructor.php
5 years ago
Instructors_List.php
5 years ago
Lesson.php
5 years ago
Options.php
5 years ago
Post_types.php
5 years ago
Q_and_A.php
5 years ago
Question_Answers_List.php
5 years ago
Quiz.php
5 years ago
Quiz_Attempts_List.php
5 years ago
RestAPI.php
5 years ago
Rewrite_Rules.php
5 years ago
Shortcode.php
5 years ago
Student.php
5 years ago
Students_List.php
5 years ago
Taxonomies.php
5 years ago
Template.php
5 years ago
Theme_Compatibility.php
5 years ago
Tools.php
5 years ago
Tutor.php
5 years ago
TutorEDD.php
5 years ago
Tutor_Base.php
5 years ago
Tutor_List_Table.php
5 years ago
Tutor_Setup.php
5 years ago
Upgrader.php
5 years ago
User.php
5 years ago
Utils.php
5 years ago
Video_Stream.php
5 years ago
Withdraw.php
5 years ago
Withdraw_Requests_List.php
5 years ago
WooCommerce.php
5 years ago
RestAPI.php
118 lines
| 1 | <?php |
| 2 | /** |
| 3 | * RestAPI class |
| 4 | * |
| 5 | * @author: themeum |
| 6 | * @author_uri: https://themeum.com |
| 7 | * @package Tutor |
| 8 | * @since v.1.5.0 |
| 9 | */ |
| 10 | |
| 11 | |
| 12 | namespace TUTOR; |
| 13 | |
| 14 | if ( ! defined( 'ABSPATH' ) ) |
| 15 | exit; |
| 16 | |
| 17 | class RestAPI { |
| 18 | |
| 19 | protected $namespace = 'tutor/v1'; |
| 20 | protected $course_post_type; |
| 21 | |
| 22 | public function __construct() { |
| 23 | $this->course_post_type = tutor()->course_post_type; |
| 24 | |
| 25 | add_action('rest_api_init', array($this, 'rest_api_init')); |
| 26 | |
| 27 | } |
| 28 | |
| 29 | |
| 30 | public function rest_api_init(){ |
| 31 | register_rest_route( $this->namespace, 'courses', array( 'methods' => 'GET', 'callback' => array($this, 'courses_api') ) ); |
| 32 | } |
| 33 | |
| 34 | public function courses_api(){ |
| 35 | global $wpdb; |
| 36 | |
| 37 | $a = array_merge(array( |
| 38 | 'post_type' => $this->course_post_type, |
| 39 | 'post_status' => 'publish', |
| 40 | |
| 41 | 'id' => '', |
| 42 | 'exclude_ids' => '', |
| 43 | 'category' => '', |
| 44 | |
| 45 | 'orderby' => 'ID', |
| 46 | 'order' => 'DESC', |
| 47 | 'count' => '10', |
| 48 | ), $_GET); |
| 49 | |
| 50 | $limit = (int) $a['count']; |
| 51 | $exclude_ids_query = ''; |
| 52 | $in_ids_query = ''; |
| 53 | $tax_join = ''; |
| 54 | $tax_where = ''; |
| 55 | |
| 56 | $orderby = sanitize_text_field($a['orderby']); |
| 57 | $order = sanitize_text_field($a['order']); |
| 58 | |
| 59 | /** |
| 60 | * Exclude Course IDS |
| 61 | */ |
| 62 | if ( ! empty($a['exclude_ids'])){ |
| 63 | $exclude_ids = (array) explode(',', sanitize_text_field($a['exclude_ids'])); |
| 64 | if (tutils()->count($exclude_ids)){ |
| 65 | $exclude_ids_query = "AND ID NOT IN('$exclude_ids')"; |
| 66 | } |
| 67 | } |
| 68 | |
| 69 | if ( ! empty($a['id'])){ |
| 70 | $ids = (array) explode(',', $a['id']); |
| 71 | if (tutils()->count($ids)){ |
| 72 | $in_ids_query = "AND ID IN('$ids')"; |
| 73 | } |
| 74 | } |
| 75 | |
| 76 | if ( ! empty($a['category'])){ |
| 77 | $category = (array) explode(',', $a['category']); |
| 78 | $tax = new \WP_Tax_Query( |
| 79 | array( |
| 80 | array( |
| 81 | 'taxonomy' => 'course-category', |
| 82 | 'field' => 'term_id', |
| 83 | 'terms' => $category, |
| 84 | 'operator' => 'IN', |
| 85 | ) |
| 86 | ) |
| 87 | ); |
| 88 | |
| 89 | $tax_sql = $tax->get_sql($wpdb->posts, 'ID'); |
| 90 | $tax_join = tutils()->array_get('join', $tax_sql); |
| 91 | $tax_where = tutils()->array_get('where', $tax_sql); |
| 92 | } |
| 93 | |
| 94 | $course_post_type = tutor()->course_post_type; |
| 95 | $query = $wpdb->get_results("SELECT ID, post_author, post_title |
| 96 | from {$wpdb->posts} |
| 97 | |
| 98 | {$tax_join} |
| 99 | |
| 100 | WHERE 1=1 AND post_status = 'publish' |
| 101 | {$exclude_ids_query} |
| 102 | {$in_ids_query} |
| 103 | {$tax_where} |
| 104 | AND post_type = '{$course_post_type}' ORDER BY {$orderby} {$order} LIMIT {$limit} ", ARRAY_A); |
| 105 | |
| 106 | |
| 107 | if (tutils()->count($query)){ |
| 108 | $results = apply_filters('tutor/api/get_courses', $query); |
| 109 | wp_send_json_success($results); |
| 110 | } |
| 111 | wp_send_json_error(); |
| 112 | |
| 113 | |
| 114 | } |
| 115 | |
| 116 | |
| 117 | |
| 118 | } |