Active environment where the following will reside: http://test-hdwg.pantheon.io/projects/
Ran into a little PHP wp_query() filtering task that I'd like to know how to best approach. Client would like to filter the results of a WP_Query based on the following (lamen written) algorithm utilizing Advanced Custom Fields (ACF) values within a WordPress (4.1.1) environment:
If the query produces multiple results... {
sort the results by ACF field “project_year_end” {
if the field contains “present”, filter these items first {
if multiple results, then {
further sort by the field “project_year_start” value {}
}
}
else if, sort those without “present” afterwards by the “project_year_end” value {
if multiple results for a single value (ex: 2015), then {
further sort by “project_year_start” { }
}
}
}
}
Currently, the template (PHP) that needs to include this filtered query is built in the following fashion:
<?php /* Template Name: Projects */ ?>
<?php get_header(); ?>
<main id="primary" class="content-area">
<div class="jumbotron">
<div class="row">
<div class="intro"><?php the_field('projects_heading') ?></div>
</div>
</div>
<div class="projects">
<div class="row project-list">
<div class="column-wrapper">
<?php
$args = array (
'post_type' => 'project', // target the post-type for projects
'post_per_page' => '20', // display (at max) (x) at once
'nopaging' => true, // disable automatic pagination
'order' => 'ASC', // display order = ascending
'orderby' => 'title' // organized based on the the_title() of the post
);
$projects = new WP_Query( $args );
if ( $projects->have_posts() ) {
?>
<div class="project-listing">
<?php while ( $projects->have_posts() ) {
$projects->the_post();
?>
<div class="columns ui-listing-block">
<hr/>
<h2><?php the_field('project_title') ?></h2>
<?php if( have_rows('project_date_range') ): ?>
<span>
<?php while( have_rows('project_date_range') ): the_row(); ?>
<?php the_sub_field('project_year_start'); ?>-<?php the_sub_field('project_year_end'); ?>
<?php endwhile; ?>
</span>
<?php endif; ?>
<?php echo project_excerpt(); ?>
<a href="<?php the_permalink(); ?>" title="Learn more about the project: <?php the_field('project_title') ?>" class="button postfix">Learn More</a>
</div>
<?php } ?>
</div>
<?php } else { ?>
<p>No Projects Available.</p>
<?php } wp_reset_postdata(); ?>
</div>
</div>
</div>
</main>
<?php get_footer(); ?>`
Any help would be greatly appreciated.
