LessonModel.php
82 lines
| 1 | <?php |
| 2 | namespace Tutor\Models; |
| 3 | |
| 4 | /** |
| 5 | * Class LessonModel |
| 6 | * |
| 7 | * @since 2.0.10 |
| 8 | */ |
| 9 | class LessonModel { |
| 10 | |
| 11 | /** |
| 12 | * Get total number of lesson |
| 13 | * |
| 14 | * @return int |
| 15 | * @since 2.0.2 |
| 16 | */ |
| 17 | public static function get_total_lesson() { |
| 18 | global $wpdb; |
| 19 | $lesson_type = tutor()->lesson_post_type; |
| 20 | |
| 21 | $sql = "SELECT COUNT(DISTINCT lesson.ID) |
| 22 | FROM {$wpdb->posts} lesson |
| 23 | INNER JOIN {$wpdb->posts} topic ON lesson.post_parent=topic.ID |
| 24 | INNER JOIN {$wpdb->posts} course ON topic.post_parent=course.ID |
| 25 | WHERE lesson.post_type = %s |
| 26 | AND lesson.post_status = %s |
| 27 | AND course.post_status = %s |
| 28 | AND topic.post_status = %s"; |
| 29 | |
| 30 | return $wpdb->get_var( $wpdb->prepare( $sql, $lesson_type, 'publish', 'publish', 'publish' ) ); |
| 31 | } |
| 32 | |
| 33 | /** |
| 34 | * Get total lesson count by a course |
| 35 | * |
| 36 | * @param int $course_id |
| 37 | * @return int |
| 38 | * @since 1.0.0 |
| 39 | */ |
| 40 | public function get_lesson_count_by_course( $course_id = 0 ) { |
| 41 | $course_id = tutor_utils()->get_post_id( $course_id ); |
| 42 | return count( tutor_utils()->get_course_content_ids_by( tutor()->lesson_post_type, tutor()->course_post_type, $course_id ) ); |
| 43 | } |
| 44 | |
| 45 | /** |
| 46 | * Get lesson reading info by key |
| 47 | * |
| 48 | * @param int $lesson_id |
| 49 | * @param int $user_id |
| 50 | * @param string $key |
| 51 | * |
| 52 | * @return array|bool|mixed |
| 53 | * |
| 54 | * @since 1.0.0 |
| 55 | */ |
| 56 | public function get_lesson_reading_info( $lesson_id = 0, $user_id = 0, $key = '' ) { |
| 57 | $lesson_id = tutor_utils()->get_post_id( $lesson_id ); |
| 58 | $user_id = tutor_utils()->get_user_id( $user_id ); |
| 59 | $lesson_info = $this->get_lesson_reading_info_full( $lesson_id, $user_id ); |
| 60 | |
| 61 | return tutor_utils()->avalue_dot( $key, $lesson_info ); |
| 62 | } |
| 63 | |
| 64 | /** |
| 65 | * Get student lesson reading current info |
| 66 | * |
| 67 | * @param int $lesson_id |
| 68 | * @param int $user_id |
| 69 | * |
| 70 | * @return array|bool|mixed |
| 71 | * |
| 72 | * @since 1.0.0 |
| 73 | */ |
| 74 | public function get_lesson_reading_info_full( $lesson_id = 0, $user_id = 0 ) { |
| 75 | $lesson_id = tutor_utils()->get_post_id( $lesson_id ); |
| 76 | $user_id = tutor_utils()->get_user_id( $user_id ); |
| 77 | |
| 78 | $lesson_info = (array) maybe_unserialize( get_user_meta( $user_id, '_lesson_reading_info', true ) ); |
| 79 | return tutor_utils()->avalue_dot( $lesson_id, $lesson_info ); |
| 80 | } |
| 81 | } |
| 82 |