function prepare_items() { /* set up the columns */ $columns = $this->get_columns(); $hidden = array(); $sortable = $this->get_sortable_columns(); $this->_column_headers = array($columns, $hidden, $sortable); /* set paging parameters */ $per_page = ltp_options::get_admin_per_page('ltp_student_users_pp'); $current_page = $this->get_pagenum(); $offset = ($current_page - 1) * $per_page; /* set ordering parameters */ $poss_orderby = array('first_name', 'last_name', 'user_login', 'user_email'); $orderby = isset($_REQUEST["orderby"]) && in_array($_REQUEST["orderby"], $poss_orderby) ? $_REQUEST["orderby"] : 'last_name'; $order = isset($_REQUEST["order"]) && in_array(strtoupper($_REQUEST["order"]), array('ASC', 'DESC')) ? strtoupper($_REQUEST["order"]) : 'ASC'; $searchterm = isset($_REQUEST["s"]) && trim($_REQUEST["s"]) !== '' ? trim($_REQUEST["s"]) : ''; /* build arguments to user query */ $args = array('role' => 'student', 'number' => $per_page, 'offset' => $offset, 'fields' => 'all_with_meta', 'count_total' => true); if ($searchterm !== '') { $args['meta_query'] = array('relation' => 'OR', array('key' => 'first_name', 'value' => $searchterm, 'compare' => 'LIKE'), array('key' => 'last_name', 'value' => $searchterm, 'compare' => 'LIKE')); } if ($orderby) { switch ($orderby) { case 'first_name': case 'last_name': $args['orderby'] = 'meta_value'; $args['meta_key'] = $orderby; break; default: $args['orderby'] = $orderby; } $args['order'] = $order; } /* query users */ $user_query = new WP_User_Query($args); /* get total users */ $total_items = $user_query->get_total(); /* get results */ $wpp_users = $user_query->get_results(); /* get additional data */ /* get people pages */ $people_pages = get_posts(array('post_type' => 'people', 'numberposts' => -1, 'nopaging' => true, 'post_status' => 'any')); /* map people page IDs to usernames */ $pages_map = array(); foreach ($people_pages as $pp) { $wp_username = get_post_meta($pp->ID, 'wp_username', true); if ($wp_username) { $pages_map[$wp_username] = $pp; } } /* build items for table */ $this->items = array(); if (!empty($user_query->results)) { foreach ($user_query->results as $user) { $userdata = ltp_template::get_user_data($user); $student_user = array(); $student_user["ID"] = $user->ID; $student_user["first_name"] = $user->first_name; $student_user["last_name"] = $user->last_name; $student_user["user_login"] = $user->user_login; $student_user["user_email"] = $user->user_email; $student_user["showcase_count"] = 0; $student_user["downloads_count"] = 0; $student_user["cv_uploaded"] = false; $student_user["profile_url"] = ''; $student_user["profile_views"] = 0; /* get data related to profile publishing status */ if (!isset($pages_map[$user->user_login])) { $student_user["profile_status"] = "Not started"; } else { /* find out how much has been done on the profile */ for ($i = 1; $i < 4; $i++) { if (trim($userdata["showcase" . $i . "_title"]) !== '' || trim($userdata["showcase" . $i . "_text"]) !== '' || trim($userdata["showcase" . $i . "_image"]) !== '' || trim($userdata["showcase" . $i . "_file"]) !== '' || trim($userdata["showcase" . $i . "_video"]) !== '') { $student_user["showcase_count"]++; } } if (!empty($userdata["cv"])) { $student_user["cv_uploaded"] = true; $student_user["downloads_count"] = ltp_data::get_downloads($pages_map[$user->user_login]->ID); } /* set status, view count and URL */ if ($pages_map[$user->user_login]->post_status == "publish") { $student_user["profile_status"] = "Published"; $student_user["profile_url"] = get_permalink($pages_map[$user->user_login]->ID); } else { $student_user["profile_status"] = "Draft"; } $student_user["profile_views"] = ltp_data::get_views($pages_map[$user->user_login]->ID); } //print('<pre>' . print_r($student_user, true) . '</pre>'); array_push($this->items, $student_user); } } }
ltp_data::save_actions(); get_header(); print '<div class="section sticky toolbar">'; global $current_user; $previous_login_date = ltp_data::get_previous_login($current_user->ID); $profiles_added = ltp_data::get_profiles_added_since($previous_login_date); print ltp_template::wpp_toolbar($current_user->ID, $previous_login_date, $profiles_added); print '</div>'; print '<div class="ltp-profiles">'; if (count($people_pages)) { // get all students $students = array(); $users = get_users(array('role' => 'student', 'fields' => 'all')); if (count($users)) { foreach ($users as $user) { $students[$user->user_login] = ltp_template::get_user_data($user); } } // apply filters on $students to see which pages are to be displayed //$to_display = apply_filters( 'ltp_results', $students ); $count = 0; // loop through people pages displaying users foreach ($people_pages as $post) { $username = get_post_meta($post->ID, 'wp_username', true); if (in_array($username, array_keys($students))) { // display user data if (trim($students[$username]["firstname"]) !== '' && trim($students[$username]["surname"]) !== '') { $latest = false; foreach ($profiles_added as $newprofile) { if ($post->ID == $newprofile->ID) { $latest = true;