publish;
$total_lessons = wp_count_posts( 'slms_lesson' )->publish;
$active_enrollment = Enrollment::count_enrollments( array( 'status' => 'active' ) );
$completed = Enrollment::count_enrollments( array( 'status' => 'completed' ) );
global $wpdb;
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table, no user input.
$recent = $wpdb->get_results(
"SELECT e.*, u.display_name, p.post_title
FROM {$wpdb->prefix}slms_enrollments e
LEFT JOIN {$wpdb->users} u ON e.user_id = u.ID
LEFT JOIN {$wpdb->posts} p ON e.course_id = p.ID
ORDER BY e.enrolled_at DESC LIMIT 5"
);
echo '';
if ( ! empty( $recent ) ) {
echo '' . esc_html__( 'Recent Enrollments', 'accessnow-lms' ) . '
';
echo '';
foreach ( $recent as $r ) {
printf(
'- %s → %s (%s)
',
esc_html( $r->display_name ),
esc_html( $r->post_title ),
/* translators: %s: human-readable time difference, e.g. "3 days". */
esc_html( sprintf( __( '%s ago', 'accessnow-lms' ), human_time_diff( strtotime( $r->enrolled_at . ' UTC' ), time() ) ) )
);
}
echo '
';
}
printf(
'%s
',
esc_url( admin_url( 'admin.php?page=slms-reports' ) ),
esc_html__( 'View Full Reports →', 'accessnow-lms' )
);
}
}