get_results( $wpdb->prepare( " SELECT e.course_id, COUNT(l.id) AS total_lessons, SUM(CASE WHEN p.completed = 1 THEN 1 ELSE 0 END) AS completed_lessons, COALESCE( ROUND(SUM(CASE WHEN p.completed = 1 THEN 1 ELSE 0 END) / COUNT(l.id) * 100, 2), 0 ) AS completion_percentage, CASE WHEN COUNT(l.id) = 0 THEN 'Not Started' WHEN SUM(CASE WHEN p.completed = 1 THEN 1 ELSE 0 END) = 0 THEN 'Not Started' WHEN SUM(CASE WHEN p.completed = 1 THEN 1 ELSE 0 END) = COUNT(l.id) THEN 'Completed' ELSE 'In Progress' END AS status, MAX(p.last_accessed) AS last_accessed FROM {$wpdb->prefix}aimslms_course_enrollments e JOIN {$wpdb->prefix}aimslms_course_lessons l ON l.course_id = e.course_id LEFT JOIN {$wpdb->prefix}aimslms_course_progress p ON p.user_id = e.user_id AND p.course_id = e.course_id AND p.lesson_id = l.id WHERE e.user_id = %d GROUP BY e.course_id ", $user_id ) ); $countries = aimslms_get_countries(); $all_states = aimslms_get_states(); $selected_country = get_user_meta( $user_id, '_aimslms_billing_country', true ); $selected_state = get_user_meta( $user_id, '_aimslms_billing_state', true ); $states = $all_states[ $selected_country ] ?? array(); if ( ! $user ) { wp_die( esc_html__( 'Student not found.', 'aims-infosoft-lms' ) ); } ?>
| Course | Progress | Lessons | Status |
|---|---|---|---|
| post_title ); ?> |
|
completed_lessons ); ?> / total_lessons ); ?> lessons | completed_lessons ) === intval( $r->total_lessons ) ) : ?> Completed completion_percentage ) > 0 ) : ?> In Progress Not Started |
| No enrolled courses found. | |||