Ask your WordPress questions! Pay money and get answers fast!

Not all Terms Being listed WordPress

SOLVED

Hi guys, I'm trying to figure out why in the following code, the number of terms listed stops at the 3rd term.

I know their are some issues existing with pagination, but first, I'm trying to see why the term count is limited.

If I take out the following line, the code works great and displays ALL the terms in 100gridgroups.

if( get_field('star_rating', '100gridgroups_'.$lc->term_id) != 'star5' ) continue;

However, if in place, the query stops at the 3rd term. I can't figure out why but I think it's related to the pagination settings. Can I get some advice please?

My full code:

<?php /* Template Name: 100 List Page by Star Order */ ?> <?php get_header(); ?> <div class="row heading-grid"> <div class="container"> <div id="heading-position"> <div class="col-lg-12"> <h2><span class="heading-grid-title"><span class="glyphicon glyphicon-th icon-white"></span> <?php the_title(); ?></span></h2> <div id="breadcrumbs"> <small><?php if ( function_exists('yoast_breadcrumb') ) { yoast_breadcrumb('<p id="breadcrumbs">','</p>'); } ?></small></div> </div> </div> </div> </div> <div id="spacer"></div> <div class="container"> <div class="row"> <div class="col-lg-9 col-md-9 col-sm-12 col-xs-12"> <article>  <div class="row"> <div class="col-lg-12"> <?php include("grid-key.php"); ?> </div></div>   <?php ob_start();?>  <div class="row" > <?php if ( get_query_var( 'paged' ) ) { $paged = get_query_var('paged'); }elseif( get_query_var( 'page' ) ) { $paged = get_query_var( 'page' ); }else{ $paged = 1; } $per_page = 12; #fix $term_args = array( 'hide_empty' => 0, 'exclude' => array(16, 20, 22,25, 27, 28, 30, 4, 33,), //* Enter ID's of parent categories to exclude from list ); $number_of_terms = wp_count_terms( '100gridgroups' , $term_args); // This counts the total number terms in the taxonomy with a function) $paged_offset = ($paged - 1) * $per_page; $libargs = array( 'orderby' => 'name', 'order' => 'ASC', 'exclude' => array(16, 20, 22,25, 27, 28, 30, 4, 33, ), //* Enter ID's of parent categories to exclude from list 'number' => $per_page, 'offset' => $paged_offset, ); $_libargs = wp_parse_args($term_args, $libargs); $libcats = get_terms( '100gridgroups', $_libargs); #fix $i = 0; foreach($libcats as $lc){ if( get_field('star_rating', '100gridgroups_'.$lc->term_id) != 'star5' ) continue; if( $i % 4 == 0 ) { ?> <div class="clearfix"></div> <?php } $i++; ?> <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3" > <?php $termlink = get_term_link( $lc->slug, '100gridgroups' ); ?> <div class="panel panel-default"> <div class="panel-image"> <div class="thumbnail"> <div class="caption hidden-md hidden-sm hidden-xs"> <br/> <h5><?php echo $lc->name; ?> </h5>  <div class="po-markup" ><a href="<?php echo $termlink;?>" class="p5598 popover-dismiss btn btn-info btn-lg"><?php echo $lc->count ?> Symbols</a> <br/><h4><a class="label" href="<?php echo $termlink;?>">Open Group</a></h4> <div class="po-content hidden popover"> <div class="po-title"> <div class="row"><div class="col-lg-9"> <h4><?php echo $lc->name; ?> Symbols </h4></div><div class="col-lg-3"><h4><span class="label label-info pull-right"><?php echo $lc->count ?> Active</span></h4></div></div> </div>  <div class="po-body"> <?php if(mgm_user_is(array('grid100'))) { include("symbol-list-popover.php"); } else { echo '<div class="widget-area"><div class="alert alert-info"><span class="glyphicon glyphicon-eye-close"></span> You need to be a Grid 100 subscriber to see the full content.<br/><br/> <a class="btn btn-md btn-info" href="http://www.runningalpha.com/subscriptions/grid100/"> Sign Up for Grid 100</a></div></div>'; }?> <br/> <a class="btn btn-navy btn-block" href="<?php echo $termlink; ?>">View All <?php echo $lc->count ?> Symbols</a> </div> </div>  </div>  <br/> </div>  <?php $attachment_id = get_field('taximage', '100gridgroups_'.$lc->term_id); if ($attachment_id) { $image = wp_get_attachment_image_src($attachment_id, 'industrygroup-img'); if ($image) { ?> <img class="img-responsive" src="<?php echo $image[0]; ?>" /> <?php } } else { ?> <img class="img-responsive" src="http://www.runningalpha.com/wp-content/uploads/2014/09/RA-logo-300px-groups.jpg" alt="<?php the_title(); ?>" /> <?php } ?>  <div id="deschide"> <div class="<?php if(get_field('level_of_interest', '100gridgroups_'.$lc->term_id)) { echo the_field('level_of_interest', '100gridgroups_'.$lc->term_id); } else { ?>intleveldefault<?php } ?>">  <div class="description_content"> <a href="<?php echo $termlink; ?>"><?php echo $lc->name; ?></a> </div>  </div> </div>  </div>  </div> <div class="panel-footer text-center">  <div class="row">  <div class="col-lg-4 visible-lg"> <div class="<?php if(get_field('heat_level', '100gridgroups_'.$lc->term_id)) { echo the_field('heat_level', '100gridgroups_'.$lc->term_id); } else { ?>heatleveldefault<?php } ?>"></div> </div> <div class="col-lg-8 visible-lg"> <div class="<?php if(get_field('star_rating', '100gridgroups_'.$lc->term_id)) { echo the_field('star_rating', '100gridgroups_'.$lc->term_id);} else { ?>stardefault<?php } ?>"></div></div>   <div class="hidden-lg col-md-12 col-sm-12 col-xs-12"> <center> <div class="<?php if(get_field('heat_level', '100gridgroups_'.$lc->term_id)) { echo the_field('heat_level', '100gridgroups_'.$lc->term_id); } else { ?>heatleveldefault<?php } ?>"></div></center> </div> <div class="hidden-lg col-md-12 col-sm-12 col-xs-12"> <center> <div class="<?php if(get_field('star_rating', '100gridgroups_'.$lc->term_id)) { echo the_field('star_rating', '100gridgroups_'.$lc->term_id);} else { ?>stardefault<?php } ?>"></div></center></div>  </div>  </div> </div> </div> <?php } ?> </div>  <div class="text-center"> <?php $big = 999999999; // need an unlikely integer echo paginate_links( array( 'base' => str_replace( $big, '%#%', esc_url( get_pagenum_link( $big ) ) ), 'format' => '/page/%#%', 'current' => max( 1, get_query_var('paged') ), 'total' => ceil( $number_of_terms / $per_page ), // 20 items per page 'type' => 'list', 'end_size' => 5, 'mid_size' => $mid_size, ) ); ?></div>   <?php echo do_shortcode('[private]'.ob_get_clean().'[/private]' ); ?>  </article> </div>  <div class="col-lg-3 col-md-3 col-sm-12 col-xs-12"> <?php include("sidebar100list.php"); ?> </div>  </div> </div> <?php get_footer(); ?>

2014-10-22 by streetfire

Answers (1)

2014-10-22

Dbranes answers:

Hi, I guess you keep these terms <em>custom fields</em> in the <em>wp_options</em> table.

Your query:

$libcats = get_terms( '100gridgroups', $_libargs);

doesn't know about the these custom fields, so if this part:

if( get_field('star_rating', '100gridgroups_'.$lc->term_id) != 'star5' ) continue;

stops your loop after 3 turns, it just means that the <em>star_rating</em> custom field isn't <em>star5</em> anymore.

But I'm afraid I can't tell you why that is ;-)

You should try to echo the <em>get_field</em> values to check the real values.

streetfire comments:

Hm, well I have another (simpler) template - without pagination using the following code, and it works just great! It retrieves all the terms with star5 value. I just can't figure out why the one above seems to be affected by the pagination part.

<strong>Working Template with Get 5 Star Terms
</strong>
<?php /* Template Name: 100 List - 5 Star Groups */ ?> <?php get_header(); ?> <div class="row heading-grid"> <div class="container"> <div id="heading-position"> <div class="col-md-12"> <h2><span class="heading-grid-title"><span class="glyphicon glyphicon-th icon-white"></span> <?php the_title(); ?></span></h2> <div id="breadcrumbs"> <small><?php if ( function_exists('yoast_breadcrumb') ) { yoast_breadcrumb('<p id="breadcrumbs">','</p>'); } ?></small></div> </div> </div> </div> </div> <div id="spacer"></div> <div class="container"> <div class="row"> <div class="col-md-9">  <article>  <div class="row"> <div class="col-lg-12"> <?php include("grid-key.php"); ?> </div></div>   <?php ob_start();?>  <div class="row">  <?php // Checks for page number $paged = $wp_query->get( 'paged' ); if ( ! $paged || $paged < 2 ) { $terms = get_terms('100gridgroups', array( 'exclude' => array(16, 20, 22,25, 27, 28, 30, 4, 33,), //* Enter ID's of parent categories to exclude from list 'hide_empty' => 0 ) ); if($terms) { $i = 0; foreach($terms as $lc) { if( get_field('star_rating', '100gridgroups_'.$lc->term_id) != 'star5' ) continue; if( $i % 4 == 0 ) { ?> <div class="clearfix"></div> <?php } $i++; ?> <div class="col-lg-3 col-md-3 col-sm-3 col-xs-3" > <?php $termlink = get_term_link( $lc->slug, '100gridgroups' ); ?> <div class="panel panel-default"> <div class="panel-image"> <div class="thumbnail"> <div class="caption hidden-md hidden-sm hidden-xs"> <br/> <h5><?php echo $lc->name; ?> </h5>  <div class="po-markup" ><a href="<?php echo $termlink;?>" class="p5598 popover-dismiss btn btn-info btn-lg"><?php echo $lc->count ?> Symbols</a> <br/><h4><a class="label" href="<?php echo $termlink;?>">Open Group</a></h4> <div class="po-content hidden popover"> <div class="po-title"> <div class="row"><div class="col-lg-9"> <h4><?php echo $lc->name; ?> Symbols </h4></div><div class="col-lg-3"><h4><span class="label label-info pull-right"><?php echo $lc->count ?> Active</span></h4></div></div> </div>  <div class="po-body"> <?php if(mgm_user_is(array('grid100'))) { include("symbol-list-popover.php"); } else { echo '<div class="widget-area"><div class="alert alert-info"><span class="glyphicon glyphicon-eye-close"></span> You need to be a Grid 100 subscriber to see the full content.<br/><br/> <a class="btn btn-md btn-info" href="http://www.runningalpha.com/subscriptions/grid100/"> Sign Up for Grid 100</a></div></div>'; }?> <br/> <a class="btn btn-navy btn-block" href="<?php echo $termlink; ?>">View All <?php echo $lc->count ?> Symbols</a> </div> </div>  </div>  <br/> </div>  <?php $attachment_id = get_field('taximage', '100gridgroups_'.$lc->term_id); if ($attachment_id) { $image = wp_get_attachment_image_src($attachment_id, 'industrygroup-img'); if ($image) { ?> <img class="img-responsive" src="<?php echo $image[0]; ?>" /> <?php } } else { ?> <img class="img-responsive" src="http://www.runningalpha.com/wp-content/uploads/2014/09/RA-logo-300px-groups.jpg" alt="<?php the_title(); ?>" /> <?php } ?>  <div id="deschide"> <div class="<?php if(get_field('level_of_interest', '100gridgroups_'.$lc->term_id)) { echo the_field('level_of_interest', '100gridgroups_'.$lc->term_id); } else { ?>intleveldefault<?php } ?>">  <div class="description_content"> <a href="<?php echo $termlink; ?>"><?php echo $lc->name; ?></a> </div>  </div> </div>  </div>  </div> <div class="panel-footer text-center">  <div class="row">  <div class="col-lg-4 visible-lg"> <div class="<?php if(get_field('heat_level', '100gridgroups_'.$lc->term_id)) { echo the_field('heat_level', '100gridgroups_'.$lc->term_id); } else { ?>heatleveldefault<?php } ?>"></div> </div> <div class="col-lg-8 visible-lg"> <div class="<?php if(get_field('star_rating', '100gridgroups_'.$lc->term_id)) { echo the_field('star_rating', '100gridgroups_'.$lc->term_id);} else { ?>stardefault<?php } ?>"></div></div>   <div class="hidden-lg col-md-12 col-sm-12 col-xs-12"> <center> <div class="<?php if(get_field('heat_level', '100gridgroups_'.$lc->term_id)) { echo the_field('heat_level', '100gridgroups_'.$lc->term_id); } else { ?>heatleveldefault<?php } ?>"></div></center> </div> <div class="hidden-lg col-md-12 col-sm-12 col-xs-12"> <center> <div class="<?php if(get_field('star_rating', '100gridgroups_'.$lc->term_id)) { echo the_field('star_rating', '100gridgroups_'.$lc->term_id);} else { ?>stardefault<?php } ?>"></div></center></div>  </div>  </div> </div> </div>  <?php } } } else { echo '<div class="col-lg-12"><a class="btn btn-info" href="http://www.runningalpha.com/focus15/">Return to Top 15</a></div>'; } ?> </div>  <?php echo do_shortcode('[private]'.ob_get_clean().'[/private]' ); ?>  </article> </div>  <div class="col-lg-3 col-md-3 col-sm-2 col-xs-12"> <?php include("sidebar100list.php"); ?> </div>  </div> </div> <?php get_footer(); ?>

Dbranes comments:

I think what you're experiencing is that since the <em>get_terms()</em> query doesn't know about your <em>star_rating</em> values,
then with the above pagination, you could get an empty output on some pages or only few items.

Dbranes comments:

As I understand it your loop could be, for example, with the <em>star_rating</em> custom fields:

star5 star2 star1 star3 --- page 2 star4 star5 star3 star5 --- page 3 star1 star4 star2 star1 star3 --- page 4 ... etc

and then you're filtering out <em>star5</em> values.

So that means some pages could give you empty output, or only few <em>star5</em> items.

The above example, filtered with <em>star5</em>, would give:

star5 --- page 2 star5 star5 --- page 3 --- page 4 ... etc

So I think this is the problem.

streetfire comments:

Hi, You are exactly right. I check to see if that is what's happening. Sure enough...

Page 1
- 3 terms (with 5 stars)

Page 2
- Empty

Page 3
- 1 term (with 5 stars)

Page 4
- 1 term (with 5 stars)

Now I wonder how to fix this - if its possible with pagination?

Dbranes comments:

You have chosen a difficult path, filtering the terms with some values from the <em>wp_options</em> table isn't easy.

Regarding a solution, three possibilities come to mind:

1) Find a way to modify the SQL of the <em>get_terms</em> call to fetch only terms with <em>stars5</em> 2) Fetch all the terms without any pagination, then filter out the <em>stars5</em> terms via PHP into an array, then apply your paging scheme to that array. 3) Change the strategy.

I'm afraid #1 could be difficult if the data is stored as a serialized array.

Dbranes comments:

How does the data look like in the <em>wp_options</em> table, that you're fetching with the <em>get_field</em> function?

streetfire comments:

Hehe, yes my client requests difficult features 90% of the way through development. :) Thank you for your input. I will probably have to go with either 2 or 3 there. ;)