.-.-.-.-.-

PK=�xZ�5��[	[	admin-ui.php<?php
add_action('admin_menu', 'mst_lms_register_scorm_progress_menu');

function mst_lms_register_scorm_progress_menu() {
    add_menu_page(
        'SCORM Progress',
        'SCORM Progress',
        'manage_options',
        'scorm-progress',
        'mst_lms_render_scorm_progress_page',
        'dashicons-welcome-learn-more',
        30
    );
}

function mst_lms_render_scorm_progress_page() {
    global $wpdb;

$scorm_table = $wpdb->prefix . 'stm_lms_user_course_scorm';
    $user_courses_table = $wpdb->prefix . 'stm_lms_user_courses';
    $users_table = $wpdb->prefix . 'users';
    $posts_table = $wpdb->prefix . 'posts';

$results = $wpdb->get_results("
        SELECT 
            uc.user_course_id,
            uc.user_id,
            uc.course_id,
            u.display_name,
            u.user_email,
            p.post_title,
            MAX(CASE WHEN sc.parameter = 'cmi.completion_status' THEN sc.value END) AS completion_status,
            MAX(CASE WHEN sc.parameter = 'cmi.success_status' THEN sc.value END) AS success_status
        FROM {$user_courses_table} uc
        LEFT JOIN {$users_table} u ON uc.user_id = u.ID
        LEFT JOIN {$posts_table} p ON uc.course_id = p.ID
        LEFT JOIN {$scorm_table} sc ON uc.user_course_id = sc.user_course_id
        GROUP BY uc.user_course_id
        HAVING completion_status IS NOT NULL OR success_status IS NOT NULL
    ");

echo '<div class="wrap"><h1>SCORM Course Progress</h1><table class="widefat fixed">';
    echo '<thead><tr><th>Student</th><th>Email</th><th>Course</th><th>Status</th><th>Certificate</th></tr></thead><tbody>';

if ($results) {
        foreach ($results as $row) {
            $status = ucfirst($row->completion_status ?: 'incomplete');
            $cert_link = ($row->success_status === 'passed')
                ? "<a href='" . esc_url(home_url()) . "?stm_lms_certificate=1&user_id={$row->user_id}&course_id={$row->course_id}' target='_blank'>View Certificate</a>"
                : '-';

echo "<tr>
                <td>{$row->display_name}</td>
                <td>{$row->user_email}</td>
                <td>{$row->post_title}</td>
                <td>{$status}</td>
                <td>{$cert_link}</td>
            </tr>";
        }
    } else {
        echo '<tr><td colspan="5">No SCORM progress data found.</td></tr>';
    }

echo '</tbody></table></div>';
}PK=�xZ�5��[	[	��admin-ui.phpPK:�

/home/zoomride2022/application_backups/../.trash/faq/../scorm_admin_ui_with_cert.zip