CPT Based Leaderboard Grouped by Meta Entries WordPress

Andrea P answers:

hi there!

I gave it a go and I made some code which could be what you are looking for.

I assumed you are using ACF to create the fields.
I also assumed, as per your last phrase, that you have a custom taxonomy with companies as terms, and you attach the company term to the trips post, based on the submitter's company.
ultimately, I have assumed (and actually is the thing that makes more sense to do, in my opinion), that you have another post type for companies, where you create a post for each company, with all their details, including the number of employees. (to make my code work, you'll also need to have a ACF taxonomy field in company posts, where you select the company term from the taxonomy.

I have made a separate function to calculate the per_capita, so it's easier to eventually change it if your structure is not like the one described above


// define the function to calculate the per capita value
// assuming that companies details are stored in custom posts of the post_type 'companies'
// which have an ACF taxonomy field called "company_term_id" which uses a single selector and pass the term_ID from the taxonomy "companies_tax"
// and also have a normal field called "company_employees" where you store the number of employees
function calculate_per_capita_trips( $term_id, $trips_count ){
// query the companies to retrieve the company page id
$args = array(
'post_type' => 'companies',
'posts_per_page' => 1,
'fields' => 'ids',
'meta_key' => 'company_term_id',
'meta_value' => $term_id,
'meta_compare' => '='
);
$companies_query = new WP_Query( $args );
// loop it (we are getting just an array of ids, as we don't need anything else from that post now
if ($companies_query->have_posts()):
foreach( $companies_query->posts as $company_id ):
// get the number of employees
$employees = get_field('company_employees', $company_id);
// calculate the per-capita
$per_capita = $trips_count / $employees;

endforeach;
endif;
// if we've got the value return it, otherwise return false
if ($per_capita){
return $per_capita;
}
else{
return false;
}
}




// get all terms of the companies taxonomy
$companies = get_terms('companies_tax');
// loop them and create a new array with $term_id => $per_capita_trips
$companies_array = array();
foreach ($companies as $company){
// calculate the per-capita
$per_capita_trips = calculate_per_capita_trips( $company->term_id, $company->count );
// if we've got a value, add it to the array
if ($per_capita_trips){
$companies_array[$company->term_id] = $per_capita_trips;
}
}
// order the list based on the per-capita
arsort($companies_array);
// now we can loop each term (company) and retrieve all posts (trips) from that company
// you could set up a counter variable to print the position (like in your mockup)
$company_rank = "1";

// example loop
foreach ( $companies_array as $company_id => $per_capita_val){
$company_args = array(
'post_type' => 'trips',
'posts_per_page' => -1,
'tax_query' => array(
'taxonomy' => 'companies_tax',
'field' => 'id',
'terms' => array($company_id),
'operator' => 'IN'
),
);
$company_trips = new WP_Query( $company_args );
// The Loop
if ( $company_trips->have_posts() ) :
echo $company_rank;
// get company term
$company_obj = get_term( $company_id, 'companies_tax' );
//print name
echo $company_obj-name;
// number of trips
echo $company_obj->count;

while ( $company_trips->have_posts() ) : $company_trips->the_post();
// print the post (trip)
endwhile;
endif;
// Reset Post Data
wp_reset_postdata();
// increment the rank value for the next company
$company_rank++;

}


*** UPDATED THE CODE ***
there was a typo and the per_capita function was always outputting "false"

---

---

---