← All changes | models/CourseModel.php +60 -1098 4.0.0 → 2.7.2 View file →

		@@ -9,17 +9,9 @@
9	9	*/
10	10
11	11	namespace Tutor\Models;
12	12
13		-use Tutor\Helpers\DateTimeHelper;
14		-use TUTOR\Icon;
15		-use TUTOR\Course;
16		-use TUTOR\Lesson;
17		-use Tutor\Ecommerce\Tax;
18		-use InvalidArgumentException;
19	13	use Tutor\Helpers\QueryHelper;
20		-use TUTOR\User;
21		-use TUTOR_ASSIGNMENTS\Assignments;
22	14
23	15	/**
24	16	* CourseModel Class
25	17	*
		@@ -30,11 +22,9 @@
30	22	* WordPress course type name
31	23	*
32	24	* @var string
33	25	*/
34		- const POST_TYPE = 'courses';
35		- const COURSE_CATEGORY = 'course-category';
36		- const COURSE_TAG = 'course-tag';
	26	+ const POST_TYPE = 'courses';
37	27
38	28	const STATUS_PUBLISH = 'publish';
39	29	const STATUS_DRAFT = 'draft';
40	30	const STATUS_AUTO_DRAFT = 'auto-draft';
		@@ -40,9 +30,8 @@
40	30	const STATUS_AUTO_DRAFT = 'auto-draft';
41	31	const STATUS_PENDING = 'pending';
42	32	const STATUS_PRIVATE = 'private';
43	33	const STATUS_FUTURE = 'future';
44		- const STATUS_TRASH = 'trash';
45	34
46	35	/**
47	36	* Course completion modes
48	37	*/
		@@ -49,89 +38,38 @@
49	38	const MODE_FLEXIBLE = 'flexible';
50	39	const MODE_STRICT = 'strict';
51	40
52	41	/**
53		- * Course attachment/downloadable resources meta key
	42	+ * Course mapped with the product using this meta key
54	43	*
55	44	* @var string
56	45	*/
57		- const ATTACHMENT_META_KEY = '_tutor_attachments';
	46	+ const WC_PRODUCT_META_KEY = '_tutor_course_product_id';
58	47
59	48	/**
60		- * Course benefits meta key
	49	+ * Course attachment/downloadable resources meta key
61	50	*
62	51	* @var string
63	52	*/
64		- const BENEFITS_META_KEY = '_tutor_course_benefits';
	53	+ const ATTACHMENT_META_KEY = '_tutor_attachments';
65	54
66	55	/**
67		- * The constant representing the status when a course is completed.
	56	+ * Course benefits meta key
68	57	*
69		- * @since 3.8.1
70		- *
71	58	* @var string
72	59	*/
73		- const COURSE_COMPLETED = 'course_completed';
	60	+ const BENEFITS_META_KEY = '_tutor_course_benefits';
74	61
75	62	/**
76		- * Get available status list.
77		- *
78		- * @since 3.0.0
79		- *
80		- * @return array
81		- */
82		- public static function get_status_list() {
83		- return array(
84		- self::STATUS_DRAFT,
85		- self::STATUS_AUTO_DRAFT,
86		- self::STATUS_PUBLISH,
87		- self::STATUS_PRIVATE,
88		- self::STATUS_FUTURE,
89		- self::STATUS_PENDING,
90		- self::STATUS_TRASH,
91		- );
92		- }
93		-
94		- /**
95		- * Check if a course is available for enrollment or purchase.
96		- *
97		- * @since 4.0.0
98		- *
99		- * @param integer $course_id the course id.
100		- *
101		- * @return bool
102		- */
103		- public static function is_course_accessible( $course_id = 0 ) {
104		- $course = get_post( $course_id );
105		- if ( ! $course || ! is_object( $course ) ) {
106		- return false;
107		- }
108		-
109		- if ( ! in_array( $course->post_type, array( tutor()->course_post_type, tutor()->bundle_post_type ), true ) ) {
110		- return false;
111		- }
112		-
113		- if ( ! in_array( $course->post_status, array( self::STATUS_PUBLISH, self::STATUS_PRIVATE ), true ) ) {
114		- return false;
115		- }
116		-
117		- return true;
118		- }
119		-
120		- /**
121	63	* Course record count
122	64	*
123	65	* @since 2.0.7
124	66	*
125		- * @since 3.6.0 $post_type param added
126		- *
127		- * @param string $status Post status.
128		- * @param string $post_type Post type.
129		- *
	67	+ * @param string $status course status.
130	68	* @return int
131	69	*/
132		- public static function count( $status = self::STATUS_PUBLISH, $post_type = self::POST_TYPE ) {
133		- $count_obj = wp_count_posts( $post_type );
	70	+ public static function count( $status = self::STATUS_PUBLISH ) {
	71	+ $count_obj = wp_count_posts( self::POST_TYPE );
134	72	if ( 'all' === $status ) {
135	73	return array_sum( (array) $count_obj );
136	74	}
137	75
		@@ -138,21 +76,8 @@
138	76	return (int) $count_obj->{$status};
139	77	}
140	78
141	79	/**
142		- * Get tutor post types
143		- *
144		- * @since 3.5.0
145		- *
146		- * @param int|\WP_POST $post the post id or object.
147		- *
148		- * @return bool
149		- */
150		- public static function get_post_types( $post ) {
151		- return apply_filters( 'tutor_check_course_post_type', self::POST_TYPE === get_post_type( $post ), get_post_type( $post ) );
152		- }
153		-
154		- /**
155	80	* Get courses
156	81	*
157	82	* @since 1.0.0
158	83	*
		@@ -203,36 +128,8 @@
203	128	return $query;
204	129	}
205	130
206	131	/**
207		- * Get courses using provided args
208		- *
209		- * If user is not admin then it will return only current user's post
210		- *
211		- * @since 3.0.0
212		- *
213		- * @param array $args Args.
214		- *
215		- * @return \WP_Query
216		- */
217		- public static function get_courses_by_args( array $args = array() ) {
218		-
219		- $default_args = array(
220		- 'post_type' => tutor()->course_post_type,
221		- 'posts_per_page' => -1,
222		- 'post_status' => 'publish',
223		- );
224		-
225		- if ( ! current_user_can( 'manage_options' ) ) {
226		- $default_args['author'] = get_current_user_id();
227		- }
228		-
229		- $args = wp_parse_args( $args, apply_filters( 'tutor_get_course_list_filter_args', $default_args ) );
230		-
231		- return new \WP_Query( $args );
232		- }
233		-
234		- /**
235	132	* Get course count by instructor
236	133	*
237	134	* @since 1.0.0
238	135	*
		@@ -291,47 +188,28 @@
291	188
292	189	return false;
293	190	}
294	191
295		- /**
296		- * Get courses by a instructor
297		- *
298		- * @since 1.0.0
299		- * @since 3.5.0 param $post_types added.
300		- * @since 4.0.0 params $search and $order added.
301		- *
302		- * @param integer $instructor_id instructor id.
303		- * @param array|string $post_status post status.
304		- * @param integer $offset offset.
305		- * @param integer $limit limit.
306		- * @param boolean $count_only count or not.
307		- * @param array $post_types array of post types.
308		- * @param string $search search keyword.
309		- * @param string $order order.
310		- *
311		- * @return array|null|object
312		- */
313		- public static function get_courses_by_instructor(
314		- $instructor_id = 0,
315		- $post_status = array( 'publish' ),
316		- int $offset = 0,
317		- int $limit = PHP_INT_MAX,
318		- $count_only = false,
319		- $post_types = array(),
320		- $search = '',
321		- $order = 'DESC'
322		- ) {
	192	+ /**
	193	+ * Get courses by a instructor
	194	+ *
	195	+ * @since 1.0.0
	196	+ *
	197	+ * @param integer $instructor_id instructor id.
	198	+ * @param array|string $post_status post status.
	199	+ * @param integer $offset offset.
	200	+ * @param integer $limit limit.
	201	+ * @param boolean $count_only count or not.
	202	+ *
	203	+ * @return array|null|object
	204	+ */
	205	+ public static function get_courses_by_instructor( $instructor_id = 0, $post_status = array( 'publish' ), int $offset = 0, int $limit = PHP_INT_MAX, $count_only = false ) {
323	206	global $wpdb;
324		- $offset = sanitize_text_field( $offset );
325		- $limit = sanitize_text_field( $limit );
326		- $instructor_id = tutils()->get_user_id( $instructor_id );
	207	+ $offset = sanitize_text_field( $offset );
	208	+ $limit = sanitize_text_field( $limit );
	209	+ $instructor_id = tutils()->get_user_id( $instructor_id );
	210	+ $course_post_type = tutor()->course_post_type;
327	211
328		- if ( ! count( $post_types ) ) {
329		- $post_types = array( tutor()->course_post_type );
330		- }
331		-
332		- $post_types = QueryHelper::prepare_in_clause( $post_types );
333		-
334	212	if ( empty( $post_status ) || 'any' == $post_status ) {
335	213	$where_post_status = '';
336	214	} else {
337	215	! is_array( $post_status ) ? $post_status = array( $post_status ) : 0;
		@@ -338,21 +216,8 @@
338	216	$statuses = "'" . implode( "','", $post_status ) . "'";
339	217	$where_post_status = "AND $wpdb->posts.post_status IN({$statuses}) ";
340	218	}
341	219
342		- $search_sql = '';
343		- if ( ! empty( $search ) ) {
344		- $like = '%' . $wpdb->esc_like( $search ) . '%';
345		- $search_sql = $wpdb->prepare(
346		- " AND ( {$wpdb->posts}.post_title LIKE %s OR {$wpdb->posts}.post_excerpt LIKE %s ) ",
347		- $like,
348		- $like
349		- );
350		- }
351		-
352		- $order = strtoupper( $order ) === 'ASC' ? 'ASC' : 'DESC';
353		- $order_sql = " ORDER BY $wpdb->posts.post_date {$order} ";
354		-
355	220	$select_col = $count_only ? " COUNT(DISTINCT $wpdb->posts.ID) " : " $wpdb->posts.* ";
356	221	$limit_offset = $count_only ? '' : " LIMIT $offset, $limit ";
357	222
358	223	//phpcs:disable
		@@ -357,27 +222,25 @@
357	222
358	223	//phpcs:disable
359	224	$query = $wpdb->prepare(
360	225	"SELECT $select_col
361		- FROM $wpdb->posts
	226	+ FROM $wpdb->posts
362	227	LEFT JOIN {$wpdb->usermeta}
363		- ON $wpdb->usermeta.user_id = %d
364		- AND $wpdb->usermeta.meta_key = %s
365		- AND $wpdb->usermeta.meta_value = $wpdb->posts.ID
366		- WHERE 1 = 1 {$where_post_status}
367		- AND $wpdb->posts.post_type IN ({$post_types})
	228	+ ON $wpdb->usermeta.user_id = %d
	229	+ AND $wpdb->usermeta.meta_key = %s
	230	+ AND $wpdb->usermeta.meta_value = $wpdb->posts.ID
	231	+ WHERE 1 = 1 {$where_post_status}
	232	+ AND $wpdb->posts.post_type = %s
368	233	AND ($wpdb->posts.post_author = %d OR $wpdb->usermeta.user_id = %d)
369		- {$search_sql}
370		- {$order_sql} {$limit_offset}",
	234	+ ORDER BY $wpdb->posts.post_date DESC $limit_offset",
371	235	$instructor_id,
372	236	'_tutor_instructor_course_id',
	237	+ $course_post_type,
373	238	$instructor_id,
374	239	$instructor_id
375	240	);
376	241	//phpcs:enable
377	242
378		- $query = apply_filters( 'modify_get_courses_by_instructor_query', $query, $instructor_id, $where_post_status, $post_types, $limit_offset, $select_col );
379		-
380	243	//phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
381	244	return $count_only ? $wpdb->get_var( $query ) : $wpdb->get_results( $query, OBJECT );
382	245	}
383	246
		@@ -418,9 +281,9 @@
418	281	public static function is_main_instructor( $course_id, $user_id = 0 ) {
419	282	$course = get_post( $course_id );
420	283	$user_id = tutor_utils()->get_user_id( $user_id );
421	284
422		- if ( ! $course || ! self::get_post_types( $course_id ) || $user_id !== (int) $course->post_author ) {
	285	+ if ( ! $course || self::POST_TYPE !== $course->post_type || $user_id !== (int) $course->post_author ) {
423	286	return false;
424	287	}
425	288
426	289	return true;
		@@ -490,9 +353,9 @@
490	353	* @param int $post_id course id that need to delete.
491	354	* @return bool
492	355	*/
493	356	public static function delete_course( $post_id ) {
494		- if ( ! self::get_post_types( $post_id ) ) {
	357	+ if ( get_post_type( $post_id ) !== tutor()->course_post_type ) {
495	358	return false;
496	359	}
497	360
498	361	wp_delete_post( $post_id, true );
		@@ -534,10 +397,8 @@
534	397	if ( get_post_type( $post_id ) !== $course_post_type ) {
535	398	return false;
536	399	}
537	400
538		- do_action( 'tutor_before_delete_course_content', $post_id, 0 );
539		-
540	401	global $wpdb;
541	402
542	403	$lesson_post_type = tutor()->lesson_post_type;
543	404	$assignment_post_type = tutor()->assignment_post_type;
		@@ -554,49 +415,19 @@
554	415	foreach ( $topic_content_ids as $content_id ) {
555	416	/**
556	417	* Delete Quiz data
557	418	*/
558		- if ( get_post_type( $content_id ) === $quiz_post_type ) {
559		- // Collect file paths from all question types that store files before deleting rows (files deleted after DB for safety).
560		- $attempts_for_quiz = QueryHelper::get_all( 'tutor_quiz_attempts', array( 'quiz_id' => $content_id ), 'attempt_id', -1 );
561		- $attempt_file_paths = array();
562		- if ( ! empty( $attempts_for_quiz ) ) {
563		- $attempt_ids = array_map(
564		- function ( $row ) {
565		- return (int) $row->attempt_id;
566		- },
567		- $attempts_for_quiz
568		- );
569		- $attempt_file_paths = apply_filters( 'tutor_quiz/attempt_file_paths_for_deletion', array(), $attempt_ids );
570		- $attempt_file_paths = is_array( $attempt_file_paths ) ? array_values( array_filter( array_unique( $attempt_file_paths ) ) ) : array();
571		- }
572		-
	419	+ if ( get_post_type( $content_id ) === 'tutor_quiz' ) {
573	420	$wpdb->delete( $wpdb->prefix . 'tutor_quiz_attempts', array( 'quiz_id' => $content_id ) );
574	421	$wpdb->delete( $wpdb->prefix . 'tutor_quiz_attempt_answers', array( 'quiz_id' => $content_id ) );
575	422
576		- QuizModel::delete_files_by_paths( $attempt_file_paths );
577		-
578		- do_action( 'tutor_before_delete_quiz_content', $content_id, null );
579		-
580		- // Collect instructor file paths before deleting question data (e.g. draw_image / pin_image masks).
581		- /**
582		- * Filter to get file paths for quiz deletion.
583		- * Pro and other add-ons register their question types via this filter.
584		- *
585		- * @param string[] $file_paths Paths collected so far.
586		- * @param int $quiz_id Quiz post ID.
587		- */
588		- $quiz_file_paths = apply_filters( 'tutor_quiz_quiz_file_paths_for_deletion', array(), $content_id );
589		-
590	423	$questions_ids = $wpdb->get_col( $wpdb->prepare( "SELECT question_id FROM {$wpdb->prefix}tutor_quiz_questions WHERE quiz_id = %d ", $content_id ) );
591	424	if ( is_array( $questions_ids ) && count( $questions_ids ) ) {
592		- $in_clause = QueryHelper::prepare_in_clause( $questions_ids );
	425	+ $in_question_ids = "'" . implode( "','", $questions_ids ) . "'";
593	426	//phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
594		- $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}tutor_quiz_question_answers WHERE belongs_question_id IN({$in_clause}) " ) );
	427	+ $wpdb->query( "DELETE FROM {$wpdb->prefix}tutor_quiz_question_answers WHERE belongs_question_id IN({$in_question_ids}) " );
595	428	}
596	429	$wpdb->delete( $wpdb->prefix . 'tutor_quiz_questions', array( 'quiz_id' => $content_id ) );
597		-
598		- QuizModel::delete_files_by_paths( $quiz_file_paths );
599	430	}
600	431
601	432	/**
602	433	* Delete assignment data ( Assignments, Assignment Submit, Assignment Evalutation )
		@@ -721,38 +552,28 @@
721	552	* like WC Product or EDD product meta key will be used
722	553	*
723	554	* @since 2.2.0
724	555	*
725		- * @since 3.0.0
	556	+ * @param string $meta_key course product id meta key.
	557	+ * @param array $args wp_query args.
726	558	*
727		- * Meta key removed and default meta query updated
728		- *
729		- * @since 3.0.1
730		- * Course::COURSE_PRICE_META meta key exists clause added
731		- *
732		- * @param array $args wp_query args.
733		- *
734		- * @return \WP_Query
	559	+ * @return array
735	560	*/
736		- public static function get_paid_courses( array $args = array() ) {
	561	+ public static function get_paid_courses( string $meta_key, array $args = array() ): array {
737	562	$current_user = wp_get_current_user();
738		-
739	563	$default_args = array(
740		- 'post_type' => tutor()->course_post_type,
	564	+ 'post_type' => 'courses',
	565	+ 'post_status' => 'publish',
	566	+ 'no_found_rows' => true,
741	567	'posts_per_page' => -1,
742		- 'offset' => 0,
743		- 'post_status' => 'publish',
	568	+ 'relation' => 'AND',
744	569	'meta_query' => array(
745		- 'relation' => 'AND',
746	570	array(
747		- 'key' => Course::COURSE_PRICE_TYPE_META,
748		- 'value' => Course::PRICE_TYPE_SUBSCRIPTION,
	571	+ 'key' => sanitize_text_field( $meta_key ),
	572	+ 'value' => 0,
749	573	'compare' => '!=',
	574	+ 'type' => 'NUMERIC',
750	575	),
751		- array(
752		- 'key' => Course::COURSE_PRICE_META,
753		- 'compare' => 'EXISTS',
754		- ),
755	576	),
756	577	);
757	578
758	579	// Check if the current user is an admin.
		@@ -759,10 +580,15 @@
759	580	if ( ! current_user_can( 'administrator' ) ) {
760	581	$args['author'] = $current_user->ID;
761	582	}
762	583
763		- $args = wp_parse_args( $args, $default_args );
764		- return new \WP_Query( $args );
	584	+ $query = new \WP_Query( wp_parse_args( $args, $default_args ) );
	585	+
	586	+ if ( $query->have_posts() ) {
	587	+ return $query->posts;
	588	+ }
	589	+
	590	+ return array();
765	591	}
766	592
767	593	/**
768	594	* Check the course is completeable or not
		@@ -822,8 +648,9 @@
822	648	return true;
823	649	}
824	650
825	651	return false;
	652	+
826	653	}
827	654
828	655	/**
829	656	* Check a course can be auto complete by an enrolled student.
		@@ -896,871 +723,6 @@
896	723	$permalink = tutils()->get_course_first_lesson( $course_id );
897	724	}
898	725
899	726	return $permalink;
900		- }
901		-
902		- /**
903		- * Get course preview image placeholder
904		- *
905		- * @since 3.0.0
906		- *
907		- * @return string
908		- */
909		- public static function get_course_preview_image_placeholder() {
910		- return tutor()->url . 'assets/images/placeholder.svg';
911		- }
912		-
913		- /**
914		- * Retrieve the courses or course bundles that a given coupon code applies to.
915		- *
916		- * This function fetches published courses or course bundles from the database
917		- * based on the specified type. For each course, it retrieves the course prices
918		- * and the course thumbnail URL. If the user has Tutor Pro, it additionally
919		- * retrieves the total number of courses in a course bundle.
920		- *
921		- * @since 3.0.0
922		- *
923		- * @param string $applies_to The type of items the coupon applies to. Accepts 'specific_courses'
924		- * for individual courses or any other value for course bundles.
925		- *
926		- * @global wpdb $wpdb WordPress database abstraction object.
927		- *
928		- * @return array An array of course objects. Each course object contains:
929		- * - int $id: The ID of the course.
930		- * - string $title: The title of the course.
931		- * - string $type: The post type of the course (e.g., 'courses', 'course-bundle').
932		- * - float $price: The regular price of the course.
933		- * - float $sale_price: The sale price of the course.
934		- * - string $image: The URL of the course's thumbnail image.
935		- * - int|null $total_courses: The total number of courses in the bundle
936		- * (only if the user has Tutor Pro and the course type is 'course-bundle').
937		- */
938		- public function get_coupon_applies_to_courses( string $applies_to ) {
939		- global $wpdb;
940		-
941		- $post_type = 'specific_courses' === $applies_to ? 'courses' : 'course-bundle';
942		-
943		- $where = array(
944		- 'post_status' => 'publish',
945		- 'post_type' => $post_type,
946		- );
947		-
948		- $courses = QueryHelper::get_all( $wpdb->posts, $where, 'ID' );
949		-
950		- if ( tutor()->has_pro ) {
951		- $bundle_model = new \TutorPro\CourseBundle\Models\BundleModel();
952		- }
953		-
954		- $final_data = array();
955		-
956		- if ( ! empty( $courses ) ) {
957		- foreach ( $courses as $course ) {
958		- $data = new \stdClass();
959		-
960		- if ( tutor()->has_pro && 'course-bundle' === $course->type ) {
961		- $data->total_courses = count( $bundle_model->get_bundle_course_ids( $course->ID ) );
962		- }
963		-
964		- $author_name = get_the_author_meta( 'display_name', $course->post_author );
965		- $course_prices = tutor_utils()->get_raw_course_price( $course->ID );
966		- $data->id = (int) $course->ID;
967		- $data->title = $course->post_title;
968		- $data->price = $course_prices->regular_price;
969		- $data->sale_price = $course_prices->sale_price;
970		- $data->image = get_the_post_thumbnail_url( $course->ID );
971		- $data->author = $author_name;
972		-
973		- $final_data[] = $data;
974		- }
975		- }
976		-
977		- return ! empty( $final_data ) ? $final_data : array();
978		- }
979		-
980		- /**
981		- * Get course instructor IDs.
982		- *
983		- * @since 3.0.0
984		- *
985		- * @param int $course_id course id.
986		- *
987		- * @return array
988		- */
989		- public static function get_course_instructor_ids( $course_id ) {
990		- global $wpdb;
991		- $instructor_ids = $wpdb->get_col(
992		- $wpdb->prepare(
993		- "SELECT user_id FROM {$wpdb->usermeta} WHERE meta_key=%s AND meta_value=%s",
994		- '_tutor_instructor_course_id',
995		- $course_id
996		- )
997		- );
998		-
999		- return $instructor_ids;
1000		- }
1001		-
1002		- /**
1003		- * Check tax collection is enabled for single purchase course/bundle
1004		- *
1005		- * @since 3.7.0
1006		- *
1007		- * @param int $post_id course or bundle id.
1008		- *
1009		- * @return boolean
1010		- */
1011		- public static function is_tax_enabled_for_single_purchase( $post_id ) {
1012		- if ( ! Tax::is_individual_control_enabled() ) {
1013		- return true;
1014		- }
1015		-
1016		- $data = get_post_meta( $post_id, Course::TAX_ON_SINGLE_META, true );
1017		- return ( '1' === $data || '' === $data );
1018		- }
1019		-
1020		- /**
1021		- * Count total attachments available in all courses or specific
1022		- *
1023		- * @since 3.6.0
1024		- *
1025		- * @param int|array $course_id Course id or array of ids, to get course's attachment.
1026		- *
1027		- * @return int
1028		- */
1029		- public static function count_attachment( $course_id = 0 ) {
1030		- global $wpdb;
1031		-
1032		- $total_count = 0;
1033		-
1034		- $primary_table = "$wpdb->posts p";
1035		- $joining_tables = array(
1036		- array(
1037		- 'type' => 'INNER',
1038		- 'table' => "{$wpdb->postmeta} pm",
1039		- 'on' => "p.ID = pm.post_id AND pm.meta_key = '_tutor_attachments' AND pm.meta_value != 'a:0:{}'",
1040		- ),
1041		- );
1042		-
1043		- // Prepare query.
1044		- $select = array( 'pm.meta_value' );
1045		- $where = array();
1046		- if ( $course_id ) {
1047		- $where['p.ID'] = is_array( $course_id ) ? array( 'IN', $course_id ) : $course_id;
1048		- }
1049		-
1050		- $search = array();
1051		- $limit = 0; // Get all.
1052		- $offset = 0;
1053		- $order_by = '';
1054		-
1055		- $results = QueryHelper::get_joined_data(
1056		- $primary_table,
1057		- $joining_tables,
1058		- $select,
1059		- $where,
1060		- $search,
1061		- $order_by,
1062		- $limit,
1063		- $offset
1064		- )['results'];
1065		-
1066		- if ( $results ) {
1067		- foreach ( $results as $row ) {
1068		- $attachment_ids = maybe_unserialize( $row->meta_value );
1069		- if ( ! is_array( $attachment_ids ) || empty( $attachment_ids ) ) {
1070		- continue;
1071		- }
1072		-
1073		- $attachments = get_posts(
1074		- array(
1075		- 'post_type' => 'attachment',
1076		- 'post__in' => $attachment_ids,
1077		- 'posts_per_page' => -1,
1078		- )
1079		- );
1080		-
1081		- $total_count += count( $attachments );
1082		- }
1083		- }
1084		-
1085		- return $total_count;
1086		- }
1087		-
1088		- /**
1089		- * Count total questions available in all or specific courses
1090		- *
1091		- * @since 3.7.1
1092		- *
1093		- * @param int|array $course_id Course id or array of ids, to get course's attachment.
1094		- *
1095		- * @return int
1096		- */
1097		- public static function count_questions( $course_id = 0 ) {
1098		- global $wpdb;
1099		-
1100		- $total_count = 0;
1101		- $quiz_post_type = tutor()->quiz_post_type;
1102		- $topic_post_type = tutor()->topics_post_type;
1103		- $course_post_type = tutor()->course_post_type;
1104		-
1105		- $primary_table = "{$wpdb->prefix}tutor_quiz_questions question";
1106		-
1107		- $joining_tables = array(
1108		- array(
1109		- 'type' => 'INNER',
1110		- 'table' => "{$wpdb->posts} q",
1111		- 'on' => "q.ID = question.quiz_id AND q.post_type='{$quiz_post_type}'",
1112		- ),
1113		- array(
1114		- 'type' => 'INNER',
1115		- 'table' => "{$wpdb->posts} t",
1116		- 'on' => "q.post_parent = t.ID AND t.post_type='{$topic_post_type}'",
1117		- ),
1118		- array(
1119		- 'type' => 'INNER',
1120		- 'table' => "{$wpdb->posts} c",
1121		- 'on' => "c.ID = t.post_parent AND c.post_type='{$course_post_type}'",
1122		- ),
1123		- );
1124		-
1125		- // Prepare query.
1126		- $where = array();
1127		- if ( $course_id ) {
1128		- $where['c.ID'] = is_array( $course_id ) ? array( 'IN', $course_id ) : $course_id;
1129		- }
1130		-
1131		- $search = array();
1132		-
1133		- $total_count = QueryHelper::get_joined_count(
1134		- $primary_table,
1135		- $joining_tables,
1136		- $where,
1137		- $search,
1138		- '*'
1139		- );
1140		-
1141		- return $total_count;
1142		- }
1143		-
1144		- /**
1145		- * Count course content
1146		- *
1147		- * @since 3.6.0
1148		- *
1149		- * @param string $content_type Content type.
1150		- * @param array $course_ids Course ids.
1151		- *
1152		- * @return int
1153		- */
1154		- public static function count_course_content( string $content_type, array $course_ids = array() ): int {
1155		- $total_count = 0;
1156		- switch ( $content_type ) {
1157		- case tutor()->lesson_post_type:
1158		- $total_count = tutor_utils()->get_total_lesson( $course_ids );
1159		- break;
1160		- case tutor()->quiz_post_type:
1161		- $total_count = tutor_utils()->get_total_quiz( $course_ids );
1162		- break;
1163		- case tutor()->assignment_post_type:
1164		- if ( tutor_utils()->is_addon_enabled( 'tutor-assignments' ) ) {
1165		- $total_count = ( new Assignments( false ) )->get_total_assignment( $course_ids );
1166		- }
1167		- break;
1168		- case 'attachments':
1169		- $total_count = self::count_attachment( $course_ids );
1170		- break;
1171		- case 'questions':
1172		- $total_count = self::count_questions( $course_ids );
1173		- break;
1174		- default:
1175		- break;
1176		- }
1177		-
1178		- return (int) $total_count;
1179		- }
1180		-
1181		- /**
1182		- * Get course dropdown options
1183		- *
1184		- * @since 3.7.0
1185		- *
1186		- * @return array
1187		- */
1188		- public static function get_course_dropdown_options() {
1189		- $course_options = array(
1190		- array(
1191		- 'key' => '',
1192		- 'title' => __( 'All Courses', 'tutor' ),
1193		- ),
1194		- );
1195		-
1196		- $courses = current_user_can( 'administrator' ) ? self::get_courses() : self::get_courses_by_instructor();
1197		- if ( ! empty( $courses ) ) {
1198		- foreach ( $courses as $course ) {
1199		- $course_options[] = array(
1200		- 'key' => $course->ID,
1201		- 'title' => $course->post_title,
1202		- );
1203		- }
1204		- }
1205		-
1206		- return apply_filters( 'tutor_course_dropdown_options', $course_options );
1207		- }
1208		-
1209		- /**
1210		- * Get category dropdown options
1211		- *
1212		- * @since 3.7.0
1213		- *
1214		- * @return array
1215		- */
1216		- public static function get_category_dropdown_options() {
1217		- $category_options = array(
1218		- array(
1219		- 'key' => '',
1220		- 'title' => __( 'All Categories', 'tutor' ),
1221		- ),
1222		- );
1223		-
1224		- $categories = get_terms(
1225		- array(
1226		- 'taxonomy' => self::COURSE_CATEGORY,
1227		- 'orderby' => 'term_id',
1228		- 'order' => 'DESC',
1229		- )
1230		- );
1231		- if ( ! is_wp_error( $categories ) && ! empty( $categories ) ) {
1232		- foreach ( $categories as $category ) {
1233		- $category_options[] = array(
1234		- 'key' => $category->slug,
1235		- 'title' => $category->name,
1236		- );
1237		- }
1238		- }
1239		-
1240		- return $category_options;
1241		- }
1242		-
1243		- /**
1244		- * Retrieve all course completion records for a specific course, including meta data.
1245		- *
1246		- * @since 3.8.1
1247		- *
1248		- * @param int $course_id The ID of the course.
1249		- *
1250		- * @return array Array of course completion objects with meta, empty array if none found, or on database error.
1251		- */
1252		- public function get_course_completion_data_by_course_id( int $course_id ): array {
1253		-
1254		- global $wpdb;
1255		-
1256		- $where = array(
1257		- 'comment_type' => self::COURSE_COMPLETED,
1258		- 'comment_post_ID' => $course_id,
1259		- 'comment_agent' => 'TutorLMSPlugin',
1260		- );
1261		-
1262		- $result = QueryHelper::get_all( $wpdb->comments, $where, 'comment_post_ID', -1 );
1263		-
1264		- if ( empty( $result ) ) {
1265		- return array();
1266		- }
1267		-
1268		- return array_map(
1269		- function ( $item ) {
1270		-
1271		- return array(
1272		- 'completion' => $item,
1273		- 'completion_meta' => get_comment_meta( $item->comment_ID ),
1274		- );
1275		- },
1276		- $result
1277		- );
1278		- }
1279		-
1280		- /**
1281		- * Return completed courses by user_id
1282		- *
1283		- * @since 1.0.0
1284		- *
1285		- * @param int $user_id user id.
1286		- * @param int $offset offset.
1287		- * @param int $posts_per_page posts per page.
1288		- * @param array $args Args to override the defaults.
1289		- *
1290		- * @return bool|\WP_Query
1291		- */
1292		- public static function get_completed_courses_by_user( $user_id = 0, $offset = 0, $posts_per_page = -1, $args = array() ) {
1293		- $user_id = tutor_utils()->get_user_id( $user_id );
1294		- $course_ids = tutor_utils()->get_completed_courses_ids_by_user( $user_id, false );
1295		-
1296		- if ( count( $course_ids ) ) {
1297		- $course_post_type = tutor()->course_post_type;
1298		- $course_args = array(
1299		- 'post_type' => $course_post_type,
1300		- 'post_status' => 'publish',
1301		- 'post__in' => $course_ids,
1302		- 'posts_per_page' => $posts_per_page,
1303		- 'offset' => $offset,
1304		- 'orderby' => 'post__in',
1305		- );
1306		-
1307		- $args = apply_filters( 'tutor_get_completed_courses_by_user', $args, $user_id, $course_post_type );
1308		- $course_args = wp_parse_args( $args, $course_args );
1309		-
1310		- return new \WP_Query( $course_args );
1311		- }
1312		-
1313		- return false;
1314		- }
1315		-
1316		- /**
1317		- * Get the active course by user
1318		- *
1319		- * @since 1.0.0
1320		- *
1321		- * @param int $user_id user id.
1322		- * @param int $offset offset.
1323		- * @param int $posts_per_page posts per page.
1324		- * @param array $args Args to override the defaults.
1325		- *
1326		- * @return bool|\WP_Query
1327		- */
1328		- public static function get_active_courses_by_user( $user_id = 0, $offset = 0, $posts_per_page = -1, $args = array() ) {
1329		- $user_id = tutor_utils()->get_user_id( $user_id );
1330		- $course_ids = tutor_utils()->get_completed_courses_ids_by_user( $user_id, false );
1331		- $enrolled_course_ids = tutor_utils()->get_enrolled_courses_ids_by_user( $user_id, false );
1332		- $active_courses = array_diff( $enrolled_course_ids, $course_ids );
1333		-
1334		- if ( count( $active_courses ) ) {
1335		- $course_post_type = tutor()->course_post_type;
1336		- $course_args = array(
1337		- 'post_type' => apply_filters( 'tutor_active_courses_post_types', array( $course_post_type ) ),
1338		- 'post_status' => 'publish',
1339		- 'post__in' => $active_courses,
1340		- 'posts_per_page' => $posts_per_page,
1341		- 'offset' => $offset,
1342		- 'orderby' => 'post__in',
1343		- );
1344		-
1345		- $args = apply_filters( 'tutor_get_active_courses_by_user', $args, $user_id, $course_post_type );
1346		- $course_args = wp_parse_args( $args, $course_args );
1347		-
1348		- return new \WP_Query( $course_args );
1349		- }
1350		-
1351		- return false;
1352		- }
1353		-
1354		- /**
1355		- * Get the enrolled courses by user
1356		- *
1357		- * @since 1.0.0
1358		- * @since 2.5.0 $filters param added to query enrolled courses with additional filters.
1359		- *
1360		- * @since 3.4.0 $filters replaced with $args to override the defaults.
1361		- *
1362		- * @param integer $user_id user id.
1363		- * @param mixed $post_status post status.
1364		- * @param integer $offset offset.
1365		- * @param integer $posts_per_page post per page.
1366		- * @param array $args Args to override the defaults.
1367		- *
1368		- * @return bool|\WP_Query
1369		- */
1370		- public static function get_enrolled_courses_by_user( $user_id = 0, $post_status = 'publish', $offset = 0, $posts_per_page = -1, $args = array() ) {
1371		- $user_id = tutor_utils()->get_user_id( $user_id );
1372		- $course_ids = array_unique( tutor_utils()->get_enrolled_courses_ids_by_user( $user_id, false ) );
1373		-
1374		- if ( count( $course_ids ) ) {
1375		- $course_post_type = tutor()->course_post_type;
1376		- $course_args = array(
1377		- 'post_type' => $course_post_type,
1378		- 'post_status' => $post_status,
1379		- 'post__in' => $course_ids,
1380		- 'offset' => $offset,
1381		- 'posts_per_page' => $posts_per_page,
1382		- 'orderby' => 'post__in',
1383		- );
1384		-
1385		- $args = apply_filters( 'tutor_get_enrolled_courses_by_user', $args, $user_id, $course_post_type );
1386		- $course_args = wp_parse_args( $args, $course_args );
1387		-
1388		- $result = new \WP_Query( $course_args );
1389		-
1390		- if ( is_object( $result ) && is_array( $result->posts ) ) {
1391		-
1392		- // Sort courses according to the id list.
1393		- $new_array = array();
1394		-
1395		- foreach ( $course_ids as $id ) {
1396		- foreach ( $result->posts as $post ) {
1397		- $post->ID == $id ? $new_array[] = $post : 0;
1398		- }
1399		- }
1400		-
1401		- $result->posts = $new_array;
1402		- }
1403		-
1404		- return $result;
1405		- }
1406		-
1407		- return false;
1408		- }
1409		-
1410		- /**
1411		- * Get the number of courses created by an instructor within a given date range.
1412		- *
1413		- * @since 4.0.0
1414		- *
1415		- * If no date range is provided, returns the total course count for the instructor.
1416		- * Course creation date is determined using the `_wp_old_date` meta value when available; otherwise, the course
1417		- * post date is used.
1418		- *
1419		- * @param string|null $start_date Start date in Y-m-d format.
1420		- * @param string|null $end_date End date in Y-m-d format.
1421		- * @param int $user_id Course author (user) ID.
1422		- *
1423		- * @return int Total number of matching courses.
1424		- */
1425		- public static function get_course_count_by_date( $start_date, $end_date, $user_id ) {
1426		-
1427		- $user_id = tutor_utils()->get_user_id( $user_id );
1428		-
1429		- if ( empty( $start_date ) && empty( $end_date ) ) {
1430		- return (int) self::get_courses_by_instructor( $user_id, array( 'publish', 'private' ), 0, PHP_INT_MAX, true );
1431		- }
1432		-
1433		- $courses = self::get_courses_by_instructor( $user_id, array( 'publish', 'private' ), 0, PHP_INT_MAX );
1434		-
1435		- if ( empty( $courses ) ) {
1436		- return 0;
1437		- }
1438		-
1439		- $start_date_timestamp = strtotime( $start_date . ' 00:00:00' );
1440		- $end_date_timestamp = strtotime( $end_date . ' 23:59:59' );
1441		-
1442		- $filtered = array_filter(
1443		- $courses,
1444		- function ( $course ) use ( $start_date_timestamp, $end_date_timestamp ) {
1445		- $creation_date = get_post_meta( $course->ID, '_wp_old_date', true );
1446		-
1447		- $course_creation_date = empty( $creation_date ) ? strtotime( $course->post_date_gmt ) : strtotime( $creation_date );
1448		-
1449		- return $start_date_timestamp <= $course_creation_date && $end_date_timestamp >= $course_creation_date;
1450		- }
1451		- );
1452		-
1453		- return count( $filtered );
1454		- }
1455		-
1456		- /**
1457		- * Get topic-wise progress data for a course and a student.
1458		- *
1459		- * @since 4.0.0
1460		- *
1461		- * @param int $course_id Course ID.
1462		- * @param int $student_id Student ID.
1463		- *
1464		- * @return array[] Topic progress data.
1465		- */
1466		- public static function get_course_progress_details( $course_id, $student_id ) {
1467		-
1468		- $topics_query = tutor_utils()->get_topics( $course_id );
1469		- $topic_list = array();
1470		-
1471		- if ( empty( $topics_query ) || ! $topics_query->have_posts() ) {
1472		- return $topic_list;
1473		- }
1474		-
1475		- foreach ( $topics_query->posts as $topic_post ) {
1476		- $topic_id = (int) $topic_post->ID;
1477		- $items = array();
1478		- $completion_percentage = tutor_utils()->count_completed_contents_by_topic( $topic_id, $student_id );
1479		- $contents_query = tutor_utils()->get_course_contents_by_topic( $topic_id, -1 );
1480		-
1481		- if ( ! empty( $contents_query ) && $contents_query->have_posts() ) {
1482		- foreach ( $contents_query->posts as $content_post ) {
1483		- $items[] = ( new self() )->build_course_progress_item( $content_post, $student_id, $course_id );
1484		- }
1485		- }
1486		-
1487		- $topic_list[] = array(
1488		- 'id' => $topic_id,
1489		- 'summary' => $topic_post->post_content,
1490		- 'title' => get_the_title( $topic_id ),
1491		- 'items' => $items,
1492		- 'completion_percentage' => $completion_percentage['percentage'] ?? 0,
1493		- );
1494		- }
1495		-
1496		- wp_reset_postdata();
1497		-
1498		- return $topic_list;
1499		- }
1500		-
1501		- /**
1502		- * Check if the current user has course content access
1503		- *
1504		- * @since 4.0.0
1505		- *
1506		- * @throws InvalidArgumentException If args are invalid.
1507		- *
1508		- * @param array $args Array of arguments.
1509		- *
1510		- * `$defaults = array(
1511		- * 'current_post_type' => '',
1512		- * 'current_post_id' => 0,
1513		- * 'course_id' => 0,
1514		- * 'is_public' => false,
1515		- * 'is_enrolled' => false,
1516		- * );`.
1517		- *
1518		- * @return bool
1519		- */
1520		- public static function has_course_content_access( array $args = array() ): bool {
1521		- if ( User::is_admin() ) {
1522		- return true;
1523		- }
1524		-
1525		- $defaults = array(
1526		- 'current_post_type' => '',
1527		- 'current_post_id' => 0,
1528		- 'course_id' => 0,
1529		- 'is_public' => false,
1530		- 'is_enrolled' => false,
1531		- );
1532		-
1533		- $args = wp_parse_args( $args, $defaults );
1534		-
1535		- if ( ! $args['course_id'] || ! $args['current_post_id'] || ! $args['current_post_type'] ) {
1536		- throw new InvalidArgumentException( __( 'Invalid argument passed', 'tutor' ) );
1537		- }
1538		-
1539		- $has_access = false;
1540		- $user_id = get_current_user_id();
1541		- switch ( $args['current_post_type'] ) {
1542		- case tutor()->lesson_post_type:
1543		- $is_preview = (int) get_post_meta( $args['current_post_id'], Lesson::PREVIEW_META_KEY, true );
1544		- if ( $args['is_public'] || $is_preview ) {
1545		- $has_access = true;
1546		- } elseif ( $args['is_enrolled'] || tutor_utils()->has_enrolled_content_access( 'lesson' ) ) {
1547		- $has_access = true;
1548		- }
1549		- break;
1550		- case tutor()->quiz_post_type:
1551		- case tutor()->assignment_post_type:
1552		- if ( $user_id ) {
1553		- $content_type = tutor()->quiz_post_type === $args['current_post_type'] ? 'quiz' : 'assignment';
1554		- if ( $args['is_enrolled'] || $args['is_public'] || tutor_utils()->has_enrolled_content_access( $content_type ) ) {
1555		- $has_access = true;
1556		- }
1557		- }
1558		- break;
1559		- default:
1560		- if ( $args['is_enrolled'] ) {
1561		- $has_access = true;
1562		- }
1563		- break;
1564		- }
1565		-
1566		- return apply_filters( 'tutor_course_content_access', $has_access, $args );
1567		- }
1568		-
1569		- /**
1570		- * Build course progress item data for a specific lesson, quiz, assignment, or meeting.
1571		- *
1572		- * @since 4.0.0
1573		- *
1574		- * @param \WP_Post $post The course content post object.
1575		- * @param int $user_id The user ID for whom progress is being calculated.
1576		- * @param int $course_id The course ID to which the content belongs.
1577		- *
1578		- * @return array Associative array of progress item data
1579		- */
1580		- private function build_course_progress_item( \WP_Post $post, $user_id, $course_id ) {
1581		-
1582		- $base_items = array(
1583		- 'id' => $post->ID,
1584		- 'type' => $post->post_type,
1585		- 'link' => esc_url_raw( get_permalink( $post->ID ) ),
1586		- 'title' => $post->post_title,
1587		- );
1588		-
1589		- switch ( $post->post_type ) {
1590		- case tutor()->quiz_post_type:
1591		- $quiz_status = '';
1592		- $icon_name = Icon::QUIZ_2;
1593		- $icon_class = 'tutor-text-subdued';
1594		- $last_attempt = ( new QuizModel() )->get_first_or_last_attempt( $post->ID, $user_id );
1595		-
1596		- if ( is_object( $last_attempt ) && QuizModel::ATTEMPT_STARTED !== $last_attempt->attempt_status ) {
1597		- $quiz_status = QuizModel::get_quiz_result( $post->ID, $user_id );
1598		-
1599		- $quiz_icon_map = array(
1600		- QuizModel::RESULT_FAIL => array( Icon::CROSS_COLORIZE, 'tutor-icon-critical' ),
1601		- QuizModel::RESULT_PENDING => array( Icon::INFO_COLORIZE, 'tutor-icon-warning-secondary' ),
1602		- );
1603		-
1604		- if ( isset( $quiz_icon_map[ $quiz_status ] ) ) {
1605		- list( $icon_name, $icon_class ) = $quiz_icon_map[ $quiz_status ];
1606		- }
1607		- }
1608		-
1609		- return array_merge(
1610		- $base_items,
1611		- array(
1612		- 'is_completed' => QuizModel::RESULT_PASS === $quiz_status,
1613		- 'label' => __( 'Quiz', 'tutor' ),
1614		- 'icon' => $icon_name,
1615		- 'icon_class' => $icon_class,
1616		- )
1617		- );
1618		-
1619		- case tutor()->assignment_post_type:
1620		- $status = '';
1621		-
1622		- $is_submitted = tutor_utils()->is_assignment_submitted( $post->ID, $user_id );
1623		- $status = $is_submitted ? Assignments::get_assignment_result( $post->ID, $user_id ) : $status;
1624		-
1625		- if ( ! $is_submitted && Assignments::is_expired( $post->ID, $user_id, $course_id ) ) {
1626		- $status = 'fail';
1627		- }
1628		-
1629		- $icon = Icon::BOOK_2;
1630		- $icon_class = 'tutor-text-subdued';
1631		-
1632		- $status_map = array(
1633		- 'pending' => array( Icon::INFO_COLORIZE, 'tutor-icon-warning-secondary' ),
1634		- 'fail' => array( Icon::CROSS_COLORIZE, 'tutor-icon-critical' ),
1635		- );
1636		-
1637		- if ( isset( $status_map[ $status ] ) ) {
1638		- list( $icon, $icon_class ) = $status_map[ $status ];
1639		- }
1640		-
1641		- return array_merge(
1642		- $base_items,
1643		- array(
1644		- 'is_completed' => 'pass' === $status,
1645		- 'label' => __( 'Assignment', 'tutor' ),
1646		- 'icon' => $icon,
1647		- 'icon_class' => $icon_class,
1648		- )
1649		- );
1650		-
1651		- case tutor()->zoom_post_type:
1652		- if ( ! tutor_utils()->is_addon_enabled( 'tutor-zoom' ) ) {
1653		- return $base_items;
1654		- }
1655		-
1656		- return array_merge(
1657		- $base_items,
1658		- array(
1659		- 'label' => __( 'Zoom', 'tutor' ),
1660		- 'icon' => Icon::ZOOM,
1661		- 'is_completed' => \TUTOR_ZOOM\Zoom::is_zoom_lesson_done( '', $post->ID, $user_id ),
1662		- )
1663		- );
1664		-
1665		- case tutor()->meet_post_type:
1666		- if ( ! tutor_utils()->is_addon_enabled( 'google-meet' ) ) {
1667		- return $base_items;
1668		- }
1669		-
1670		- return array_merge(
1671		- $base_items,
1672		- array(
1673		- 'label' => __( 'Google Meet', 'tutor' ),
1674		- 'icon' => Icon::GOOGLE_MEET,
1675		- 'is_completed' => \TutorPro\GoogleMeet\Frontend\Frontend::is_lesson_completed( false, $post->ID, $user_id ),
1676		- )
1677		- );
1678		-
1679		- default:
1680		- $video = tutor_utils()->get_video_info( $post->ID );
1681		-
1682		- return array_merge(
1683		- $base_items,
1684		- array(
1685		- 'video' => $video,
1686		- 'video_play_time' => isset( $video->playtime ) ? $video->playtime : '',
1687		- 'is_completed' => (bool) tutor_utils()->is_completed_lesson( $post->ID, $user_id ),
1688		- 'label' => empty( $video ) ? __( 'Reading', 'tutor' ) : __( 'Video', 'tutor' ),
1689		- 'icon' => empty( $video ) ? Icon::COURSES : Icon::VIDEO_CAMERA,
1690		- )
1691		- );
1692		- }
1693		- }
1694		-
1695		- /**
1696		- * Calculate the total course duration for a set of courses and returns the total time in hours, minutes, and
1697		- * seconds.
1698		- *
1699		- * @since 4.0.0
1700		- *
1701		- * @param array<int> | int $course_ids List of course IDs or a single course ID.
1702		- *
1703		- * @return array{
1704		- * hours: int,
1705		- * minutes: int,
1706		- * seconds: int
1707		- * } Total accumulated duration from all given courses.
1708		- */
1709		- public static function get_total_course_duration( $course_ids ): array {
1710		- $total_seconds = 0;
1711		- $course_ids = is_array( $course_ids ) ? $course_ids : array( $course_ids );
1712		- foreach ( $course_ids as $id ) {
1713		- $total_seconds += self::get_course_duration_in_seconds( $id );
1714		- }
1715		-
1716		- return DateTimeHelper::split_seconds_into_time_units( $total_seconds );
1717		- }
1718		-
1719		- /**
1720		- * Calculate the estimated time spent on courses based on completion progress.
1721		- *
1722		- * @since 4.0.0
1723		- *
1724		- * @param array<int> $course_ids List of course IDs.
1725		- *
1726		- * @return array{
1727		- * hours: int,
1728		- * minutes: int,
1729		- * seconds: int
1730		- * } Total accumulated duration from all given courses.
1731		- */
1732		- public static function get_total_estimated_time_spent( $course_ids ): array {
1733		- $total_seconds = 0;
1734		- foreach ( $course_ids as $id ) {
1735		- $completion_percentage = tutor_utils()->is_completed_course( $id )
1736		- ? 100
1737		- : (int) tutor_utils()->get_course_completed_percent( (int) $id );
1738		-
1739		- if ( 0 === $completion_percentage ) {
1740		- continue;
1741		- }
1742		- $course_duration_in_seconds = self::get_course_duration_in_seconds( $id );
1743		- // Calculate the time spent by a user based on the course completion percentage.
1744		- $total_seconds += (int) round( $course_duration_in_seconds * ( $completion_percentage / 100 ) );
1745		- }
1746		-
1747		- return DateTimeHelper::split_seconds_into_time_units( $total_seconds );
1748		- }
1749		-
1750		- /**
1751		- * Get the total duration of a course in seconds.
1752		- *
1753		- * @since 4.0.0
1754		- *
1755		- * @param int $course_id Course ID.
1756		- *
1757		- * @return int Course duration in seconds.
1758		- */
1759		- public static function get_course_duration_in_seconds( int $course_id ): int {
1760		- $duration = tutor_utils()->get_course_duration( $course_id, true );
1761		-
1762		- return ( $duration['durationHours'] * HOUR_IN_SECONDS )
1763		- + ( $duration['durationMinutes'] * MINUTE_IN_SECONDS )
1764		- + ( $duration['durationSeconds'] );
1765	727	}
1766	728	}