';
echo '' . esc_html__( 'Students', 'learnpress' ) . '
';
do_action( 'learn-press/admin/enrolled-students/layout', $instructor_id );
echo '';
}
/**
* Allow callback for AJAX.
*
* @param array $callbacks
*
* @return array
*/
public function allow_callback( array $callbacks ): array {
$callbacks[] = get_class( $this ) . ':render_enrolled_students';
return $callbacks;
}
/**
* Render initial layout with TemplateAJAX::load_content_via_ajax().
*
* @param int $instructor_id 0 for Admin (all), user ID for Instructor.
*/
public function enrolled_students_layout( $instructor_id = 0 ) {
try {
$page_current = '';
if ( function_exists( 'get_current_screen' ) ) {
$wp_screen = get_current_screen();
if ( $wp_screen ) {
// Page on the Admin screen.
if ( $wp_screen->id === 'learnpress_page_learn-press-students-enrolled' ) {
$page_current = 'learnpress_page_learn-press-students-enrolled';
}
}
}
// Enqueue styles — lp-enrolled-students-table CSS is loaded via admin.css/frontend.css import.
// Build toolbar HTML (outside AJAX so it persists across reloads).
$instructor_id = self::resolve_instructor_id_for_request(
array(
'instructor_id' => $instructor_id,
)
);
$args = array(
'id_url' => 'lp-enrolled-students',
'instructor_id' => (int) $instructor_id,
'course_id' => abs( LP_Helper::sanitize_params_submitted( $_GET['course_id'] ?? 0, 'int' ) ),
'course_name' => LP_Helper::sanitize_params_submitted( $_GET['course_name'] ?? '' ),
'paged' => 1,
'search' => LP_Helper::sanitize_params_submitted( $_GET['search'] ?? '' ),
'start_date' => self::sanitize_date_filter( $_GET['start_date'] ?? '' ),
'end_date' => self::sanitize_date_filter( $_GET['end_date'] ?? '' ),
'enableUpdateParamsUrl' => false,
);
$call_back = array(
'class' => self::class,
'method' => 'render_enrolled_students',
);
$section = [
'wrap' => sprintf(
'',
$page_current
),
'toolbar' => $this->html_toolbar(),
'table' => TemplateAJAX::load_content_via_ajax( $args, $call_back ),
'wrap-end' => '
',
];
echo Template::combine_components( $section );
} catch ( Throwable $e ) {
LP_Debug::error_log( $e );
Template::print_message( $e->getMessage(), 'error' );
}
}
/**
* Static render method called by AJAX — returns stdClass{ content }.
*
* Permission check: Admin=full, Instructor=own courses only.
*
* @param array $data
*
* @return stdClass
*/
public static function render_enrolled_students( array $data ): stdClass {
$content = new stdClass();
$content->content = '';
try {
// Check permission
if ( ! current_user_can( UserModel::ROLE_ADMINISTRATOR )
&& ! current_user_can( UserModel::ROLE_INSTRUCTOR ) ) {
throw new Exception( esc_html__( 'You do not have permission to view enrolled students.', 'learnpress' ) );
}
$instructor_id = self::resolve_instructor_id_for_request( $data );
$course_id = abs( LP_Helper::sanitize_params_submitted( $data['course_id'] ?? 0, 'int' ) );
$paged = max( 1, abs( LP_Helper::sanitize_params_submitted( $data['paged'] ?? 1, 'int' ) ) );
$course_name = LP_Helper::sanitize_params_submitted( $data['course_name'] ?? '' );
$search = LP_Helper::sanitize_params_submitted( $data['search'] ?? '' );
$start_date = self::sanitize_date_filter( $data['start_date'] ?? '' );
$end_date = self::sanitize_date_filter( $data['end_date'] ?? '' );
$per_page = self::PER_PAGE;
// Normalize date range if request is reversed.
if ( $start_date && $end_date && strtotime( $start_date ) > strtotime( $end_date ) ) {
$tmp = $start_date;
$start_date = $end_date;
$end_date = $tmp;
}
$lp_db_user_items = UserItemsDB::getInstance();
$filter = new UserItemsFilter();
$filter->item_type = LP_COURSE_CPT;
$filter->statues = array( 'enrolled', 'finished' );
$filter->limit = $per_page;
$filter->page = $paged;
$filter->order_by = 'ui.start_time';
$filter->order = 'DESC';
$filter->field_count = 'ui.user_item_id';
$filter->only_fields = array(
'ui.user_item_id',
'ui.user_id',
'ui.item_id',
'ui.start_time',
'ui.status',
'ui.graduation',
'u.display_name',
'u.user_email',
'p.post_title AS course_title',
);
$filter->join[] = "JOIN {$lp_db_user_items->wpdb->posts} p ON ui.item_id = p.ID";
$filter->join[] = "JOIN {$lp_db_user_items->wpdb->users} u ON ui.user_id = u.ID";
if ( $instructor_id > 0 ) {
$filter->where[] = $lp_db_user_items->wpdb->prepare( 'AND p.post_author = %d', $instructor_id );
}
if ( $course_id > 0 ) {
$filter->item_id = $course_id;
} elseif ( ! empty( $course_name ) ) {
$course_name_like = '%' . $lp_db_user_items->wpdb->esc_like( $course_name ) . '%';
$filter->where[] = $lp_db_user_items->wpdb->prepare(
'AND p.post_title LIKE %s',
$course_name_like
);
}
if ( ! empty( $search ) ) {
$search_like = '%' . $lp_db_user_items->wpdb->esc_like( $search ) . '%';
$filter->where[] = $lp_db_user_items->wpdb->prepare(
'AND ( u.display_name LIKE %s OR u.user_email LIKE %s )',
$search_like,
$search_like
);
}
if ( ! empty( $start_date ) ) {
$filter->where[] = $lp_db_user_items->wpdb->prepare(
'AND ui.start_time >= %s',
$start_date . ' 00:00:00'
);
}
if ( ! empty( $end_date ) ) {
$filter->where[] = $lp_db_user_items->wpdb->prepare(
'AND ui.start_time <= %s',
$end_date . ' 23:59:59'
);
}
$total_rows = 0;
$rows = $lp_db_user_items->get_user_items( $filter, $total_rows );
if ( ! is_array( $rows ) ) {
$rows = array();
}
// Build HTML.
$html = self::instance()->html_table(
$rows,
array(
'total' => $total_rows,
'paged' => $paged,
'per_page' => $per_page,
'students-of-course' => $course_id,
)
);
$content->content = $html;
} catch ( Throwable $e ) {
$content->content = Template::print_message( $e->getMessage(), 'error', false );
LP_Debug::error_log( $e );
}
return $content;
}
/**
* Check whether user can view enrolled students content.
*
* @param int $user_id
*
* @return bool
*/
private static function can_view_enrolled_students( int $user_id = 0 ): bool {
if ( $user_id < 1 ) {
$user_id = get_current_user_id();
}
if ( $user_id < 1 ) {
return false;
}
$user_model = UserModel::find( $user_id, true );
if ( ! $user_model instanceof UserModel ) {
return false;
}
return $user_model->is_instructor();
}
/**
* Resolve instructor_id from request by permission.
* Admin can keep requested instructor_id; instructor is forced to self.
*
* @param array $data
*
* @return int
*/
private static function resolve_instructor_id_for_request( array $data ): int {
$current_user_id = get_current_user_id();
if ( ! self::can_view_enrolled_students( $current_user_id ) ) {
return 0;
}
$is_admin = user_can( $current_user_id, UserModel::ROLE_ADMINISTRATOR );
if ( $is_admin ) {
return max( 0, abs( LP_Helper::sanitize_params_submitted( $data['instructor_id'] ?? 0, 'int' ) ) );
}
return $current_user_id;
}
/**
* HTML builder: toolbar (course filter, search).
*
* @return string
*/
public function html_toolbar(): string {
$courses = array();
$data_get = LP_Helper::sanitize_params_submitted( $_GET );
$selected_course = abs( LP_Helper::sanitize_params_submitted( $data_get['course_id'] ?? 0, 'int' ) );
$search_course = LP_Helper::sanitize_params_submitted( $data_get['course_name'] ?? '' );
$search_student = LP_Helper::sanitize_params_submitted( $data_get['search'] ?? '' );
$search_start = self::sanitize_date_filter( $data_get['start_date'] ?? '' );
$search_end = self::sanitize_date_filter( $data_get['end_date'] ?? '' );
$section = array(
'wrap' => '',
);
$section = apply_filters(
'learn-press/admin/enrolled-students/toolbar/section',
$section,
$courses,
$selected_course,
);
return Template::combine_components( $section );
}
/**
* Render toolbar used inside View Students modal.
*
* @return string
*/
public function html_toolbar_modal(): string {
$section = array(
'wrap' => '',
);
return Template::combine_components( $section );
}
/**
* Render lp-target layout used in View Students modal.
*
* @return string
*/
public function html_modal_students_target(): string {
$args = array(
'id_url' => 'lp-modal-enrolled-students',
'course_id' => 0,
'paged' => 1,
'enableScrollToView' => false,
'enableUpdateParamsUrl' => false,
'html_no_load_ajax_first' => sprintf(
'%s
',
'width: 95%;',
esc_html__( 'Loading', 'learnpress' )
),
);
$call_back = array(
'class' => self::class,
'method' => 'render_enrolled_students',
);
$section = array(
'wrap' => '',
'target' => TemplateAJAX::load_content_via_ajax( $args, $call_back ),
'wrap-end' => '
',
);
return Template::combine_components( $section );
}
/**
* Print HTML template for modal toolbar.
*
* @return void
*/
public function print_modal_toolbar_template() {
$should_print = false;
if ( is_admin() ) {
$screen = function_exists( 'get_current_screen' ) ? get_current_screen() : null;
if ( $screen && isset( $screen->id ) && $screen->id === 'edit-' . LP_COURSE_CPT ) {
$should_print = true;
}
} elseif ( class_exists( 'LP_Page_Controller' ) && defined( 'LP_PAGE_PROFILE' ) ) {
$should_print = LP_Page_Controller::page_current() === LP_PAGE_PROFILE;
}
if ( ! $should_print ) {
return;
}
echo '';
echo '';
}
/**
* HTML builder: table wrapper.
*
* @param array $rows DB result rows.
* @param array $meta [ total, paged, per_page ].
*
* @return string
*/
private function html_table( array $rows, array $meta ): string {
if ( empty( $rows ) ) {
$section_empty = array(
'wrap' => '',
'empty' => '
' . esc_html__( 'No students found.', 'learnpress' ) . '
',
'wrap-end' => '
',
'table' => TableListTemplate::instance()->html_table( $table_args ),
'wrap-end' => '
',
);
$section = apply_filters(
'learn-press/admin/enrolled-students/table/section',
$section,
$rows,
$results_map,
$meta
);
return Template::combine_components( $section );
}
/**
* HTML builder: single student row.
*
* @param UserCourseModel $userCourseModel
*
* @return string
*/
private function html_student_row( UserCourseModel $userCourseModel, array $data = [] ): string {
// Avatar initials.
$userModel = $userCourseModel->get_user_model();
if ( ! $userModel instanceof UserModel ) {
return '';
}
$courseModel = $userCourseModel->get_course_model();
if ( ! $courseModel instanceof CourseModel ) {
return '';
}
// Progress.
$course_result = $userCourseModel->calculate_course_results();
$progress = (float) ( $course_result['result'] ?? 0 );
// Status badge.
$graduation = $userCourseModel->get_graduation();
$status_raw = $graduation !== UserItemModel::GRADUATION_IN_PROGRESS
? $userCourseModel->get_graduation()
: $userCourseModel->get_status();
$status_label = ucfirst( str_replace( array( '-', '_' ), ' ', $status_raw ) );
$badge_class = 'lp-badge--' . sanitize_html_class( $status_raw );
// Date.
$date = UserCourseTemplate::instance()->html_start_date_time( $userCourseModel, false );
$user_display_name = $userModel->get_display_name();
if ( empty( $user_display_name ) ) {
$user_display_name = $userModel->get_username();
}
$section = array(
'row' => '',
'student-cell-open' => '| ',
'avatar' => SingleInstructorTemplate::instance()->html_avatar( $userModel ),
'meta-open' => ' ',
'name' => sprintf(
'%s',
esc_html( $user_display_name )
),
'email' => sprintf(
'%s',
esc_html( $userModel->get_email() )
),
'meta-close' => ' ',
'student-cell-close' => ' | ',
'course-cell' => sprintf(
'%s | ',
esc_url_raw( $courseModel->get_permalink() ),
$courseModel->get_title()
),
'date-cell' => sprintf(
'%s | ',
wp_kses_post( $date )
),
'progress-cell-open' => '',
'progress-bar' => sprintf(
'
',
$progress
),
'progress-text' => sprintf(
'%d%%',
$progress
),
'progress-cell-close' => ' | ',
'status-cell-open' => '',
'status-badge' => sprintf(
'%s',
esc_attr( $badge_class ),
esc_html( $status_label )
),
'status-cell-close' => ' | ',
'row-end' => '
',
);
if ( ! empty( $data['students-of-course'] ) ) {
unset( $section['course-cell'] ); // Remove Course cell if filtering by course, as it's redundant.
}
$section = apply_filters(
'learn-press/admin/enrolled-students/row/section',
$section,
$userCourseModel
);
return Template::combine_components( $section );
}
/**
* HTML builder: pagination.
*
* Uses .page-numbers class for loadAJAX.js compatibility.
*
* @param int $total
* @param int $paged
* @param int $per_page
*
* @return string
*/
private function html_pagination( int $total, int $paged, int $per_page ): string {
$total_pages = max( 1, ceil( $total / $per_page ) );
$pagination_items = Template::instance()->html_pagination(
array(
'total_pages' => $total_pages,
'paged' => $paged,
'wrapper' => array(
'',
),
)
);
$pagination_items = apply_filters(
'learn-press/admin/enrolled-students/pagination/items',
$pagination_items,
$total,
$paged,
$per_page,
$total_pages
);
$section = array(
'wrap' => '',
);
$section = apply_filters(
'learn-press/admin/enrolled-students/pagination/section',
$section,
$total,
$paged,
$per_page,
$total_pages
);
return Template::combine_components( $section );
}
/**
* Sanitize date filter value in Y-m-d format.
*
* @param string $date
*
* @return string
*/
private static function sanitize_date_filter( $date ): string {
if ( ! is_scalar( $date ) ) {
return '';
}
$date = LP_Helper::sanitize_params_submitted( (string) $date );
if ( preg_match( '/^\d{4}-\d{2}-\d{2}$/', $date ) ) {
return $date;
}
return '';
}
}