'student', 'plural' => 'students', 'ajax' => false, ) ); } /** * Defines the table columns. * * @return array Column key to label map. */ public function get_columns() { return array( 'cb' => '', 'display_name' => __( 'Student', 'aims-infosoft-lms' ), 'user_email' => __( 'Email', 'aims-infosoft-lms' ), 'enrollments' => __( 'Enrollments', 'aims-infosoft-lms' ), 'completed_courses' => __( 'Completed Courses', 'aims-infosoft-lms' ), 'last_enrolled' => __( 'Last Enrolled', 'aims-infosoft-lms' ), ); } /** * Defines the available bulk actions. * * @return array Bulk action key to label map. */ protected function get_bulk_actions() { return array( 'delete_students' => __( 'Delete', 'aims-infosoft-lms' ), ); } /** * Defines which columns are sortable. * * @return array Column key to array( orderby key, is default ). */ protected function get_sortable_columns() { return array( 'display_name' => array( 'display_name', true ), 'enrollments' => array( 'enrollments', false ), 'last_enrolled' => array( 'last_enrolled', false ), ); } /** * Renders the row checkbox column. * * @param array $item Current row data. * @return string Checkbox input markup. */ protected function column_cb( $item ) { return sprintf( '', $item['ID'] ); } /** * Renders the student name column with row actions. * * @param array $item Current row data. * @return string Column markup. */ protected function column_display_name( $item ) { $view_url = admin_url( 'admin.php?page=aimslms-students&view=' . absint( $item['ID'] ) ); $edit_url = admin_url( 'admin.php?page=aimslms-students&edit=' . absint( $item['ID'] ) ); $delete_url = wp_nonce_url( admin_url( 'admin.php?page=aimslms-students&action=delete&student=' . absint( $item['ID'] ) ), 'delete_student_' . absint( $item['ID'] ) ); $actions = array( 'edit' => sprintf( '%s', esc_url( $edit_url ), __( 'Edit', 'aims-infosoft-lms' ) ), 'delete' => sprintf( '%s', esc_url( $delete_url ), __( 'Delete', 'aims-infosoft-lms' ) ), ); return sprintf( '%2$s %3$s', esc_url( $view_url ), esc_html( $item['display_name'] ), $this->row_actions( $actions ) ); } /** * Renders the email column. * * @param array $item Current row data. * @return string Escaped email address. */ protected function column_user_email( $item ) { return esc_html( $item['user_email'] ); } /** * Renders the enrollments count column. * * @param array $item Current row data. * @return int Number of enrollments. */ protected function column_enrollments( $item ) { return intval( $item['enrollments'] ); } /** * Renders the completed courses count column. * * @param array $item Current row data. * @return int Number of completed courses. */ protected function column_completed_courses( $item ) { $completed = 0; if ( ! empty( $item['enrolled_course_ids'] ) ) { $course_ids = explode( ',', $item['enrolled_course_ids'] ); foreach ( $course_ids as $course_id ) { if ( aimslms_is_course_completed( $course_id, $item['ID'] ) ) { ++$completed; } } } return intval( $completed ); } /** * Renders the last enrolled date column. * * @param array $item Current row data. * @return string Formatted date, or a placeholder when unavailable. */ protected function column_last_enrolled( $item ) { if ( ! empty( $item['last_enrolled'] ) ) { if ( '-' !== $item['last_enrolled'] ) { return esc_html( gmdate( 'Y-m-d', strtotime( $item['last_enrolled'] ) ) ); } else { return $item['last_enrolled']; } } else { return '-'; } } /** * Fallback renderer for any column without a dedicated method. * * @param array $item Current row data. * @param string $column_name Column key being rendered. * @return string Escaped column value, or an empty string when unset. */ protected function column_default( $item, $column_name ) { return isset( $item[ $column_name ] ) ? esc_html( $item[ $column_name ] ) : ''; } /** * Builds the query, applies search/sort/pagination, and populates the table items. * * @return void */ public function prepare_items() { // phpcs:disable WordPress.Security.NonceVerification.Recommended -- read-only display filter on a manage_options-gated admin screen; every value below is either allowlist-compared or passed through $wpdb->prepare()/intval(). global $wpdb; $per_page = 10; $paged = $this->get_pagenum(); $offset = ( $paged - 1 ) * $per_page; $where = "WHERE 1=1 AND EXISTS ( SELECT 1 FROM {$wpdb->usermeta} um WHERE um.user_id = u.ID AND um.meta_key = '{$wpdb->prefix}capabilities' AND um.meta_value LIKE '%\"student\"%' )"; $join = "LEFT JOIN {$wpdb->prefix}aimslms_course_enrollments e ON u.ID = e.user_id"; if ( ! empty( $_GET['course_id'] ) ) { $join = $wpdb->prepare( "LEFT JOIN {$wpdb->prefix}aimslms_course_enrollments e ON u.ID = e.user_id AND e.course_id = %d", intval( $_GET['course_id'] ) ); } // Search. if ( ! empty( $_REQUEST['s'] ) ) { $search = '%' . $wpdb->esc_like( sanitize_text_field( wp_unslash( $_REQUEST['s'] ) ) ) . '%'; $where .= $wpdb->prepare( ' AND (u.display_name LIKE %s OR u.user_email LIKE %s)', $search, $search ); } // Sorting. $orderby = 'u.display_name'; $order = 'ASC'; if ( ! empty( $_GET['orderby'] ) ) { $allowed = array( 'display_name' => 'u.display_name', 'enrollments' => 'enrollments', 'last_enrolled' => 'last_enrolled', ); $requested_sort = sanitize_key( wp_unslash( $_GET['orderby'] ) ); if ( ! empty( $requested_sort ) && isset( $allowed[ $requested_sort ] ) ) { $orderby = $allowed[ $requested_sort ]; } } if ( ! empty( $_GET['order'] ) ) { $requested_order = strtoupper( sanitize_text_field( wp_unslash( $_GET['order'] ) ) ); if ( in_array( $requested_order, array( 'ASC', 'DESC' ), true ) ) { $order = $requested_order; } } // phpcs:enable WordPress.Security.NonceVerification.Recommended /* Main query */ // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- $wpdb->users is derived from $wpdb->prefix, not user input; $join and $where are built entirely from hardcoded SQL, $wpdb->prepare() calls, or allowlist-compared values above; $orderby/$order are allowlist-compared above; the LIMIT/OFFSET placeholders below are filled via $wpdb->prepare() at the point of execution. $sql = " SELECT u.ID, u.display_name, u.user_email, COUNT(DISTINCT e.course_id) AS enrollments, GROUP_CONCAT(DISTINCT e.course_id ORDER BY e.course_id SEPARATOR ',') AS enrolled_course_ids, COALESCE(MAX(e.enrollment_date), '-') AS last_enrolled FROM {$wpdb->users} u {$join} {$where} GROUP BY u.ID ORDER BY {$orderby} {$order} LIMIT %d OFFSET %d "; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Custom table, no WP API alternative. $this->items = $wpdb->get_results( // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- $sql interpolates $wpdb->users (from $wpdb->prefix), $join and $where which are themselves either hardcoded or built via $wpdb->prepare()/allowlist above; this $wpdb->prepare() call fills the LIMIT/OFFSET placeholders. $wpdb->prepare( $sql, $per_page, $offset ), ARRAY_A ); $this->_column_headers = array( $this->get_columns(), array(), $this->get_sortable_columns(), ); // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- $wpdb->users is derived from $wpdb->prefix, not user input; $join and $where are built entirely from hardcoded SQL or $wpdb->prepare() calls above. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Custom table, no WP API alternative. $total_items = $wpdb->get_var( " SELECT COUNT(DISTINCT u.ID) FROM {$wpdb->users} u {$join} {$where} " ); // phpcs:enable WordPress.DB.PreparedSQL.InterpolatedNotPrepared $this->set_pagination_args( array( 'total_items' => $total_items, 'per_page' => $per_page, ) ); } /** * Renders the course filter dropdown above the table. * * @param string $which Whether this is the 'top' or 'bottom' table nav. * @return void */ protected function extra_tablenav( $which ) { if ( 'top' !== $which ) { return; } global $wpdb; $courses = get_posts( array( 'post_type' => 'aimslms_course', 'numberposts' => -1, ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended -- read-only list filtering/sorting. $selected_course_id = isset( $_GET['course_id'] ) ? sanitize_text_field( wp_unslash( $_GET['course_id'] ) ) : ''; ?>