WordPress.org

Forums

ReOrder Post Within Categories
reorder-post-within-categories with wp_query (11 posts)

  1. laetitia Godet
    Member
    Posted 1 year ago #

    How can we make a wp_query orderby in a post with reorder Within categories ??

    https://wordpress.org/plugins/reorder-post-within-categories/

  2. laetitia Godet
    Member
    Posted 1 year ago #

    How to use reorder Within cartegories in a wp_query orderby of??
    Thank you

  3. Lulu_n10
    Member
    Posted 1 year ago #

    Hi Laetitia,

    It is not possible with the plugin to add an order by in the wp_query.

    The solution is to add filter on the query.

    Example :

    function filter_join($join){
    	global $wp_query, $wpdb;
    	$join .= " LEFT JOIN ".$wpdb->prefix."reorder_post_rel ON cg_posts.ID = ".$wpdb->prefix."reorder_post_rel.post_id ";
        return $join;
    }
    
    function edit_posts_orderby($orderby){
    	global $wp_query, $wpdb;
    	$orderby = " ".$wpdb->prefix."reorder_post_rel.id ";
    	return $orderby;
    }
    
    add_filter('posts_join', 'filter_join');
    add_filter('posts_orderby', 'edit_posts_orderby');
    $query = new WP_Query(array(
    	'post_type' => 'your_post_type',
    	...
    ));
    remove_filter('posts_join', 'filter_join');
    remove_filter('posts_orderby', 'edit_posts_orderby');
  4. GeroDolja
    Member
    Posted 10 months ago #

    Does this work? I need a solution too. I have a modular front-page with different queries of different categories (like 3 posts on a featured category).

    I need a way to order that featured category in the homepage with this plugin.

    Thanks.

  5. laetitia Godet
    Member
    Posted 10 months ago #

    IT WORK

  6. T-Mike
    Member
    Posted 10 months ago #

    Lulu_n10's answer did not work for me when querying posts inside one taxonomy term ; mainly because I had several posts within multiple taxonomy terms.

    Just updated the LEFT JOIN from above answer and now it seems ok.

    Here's the full code :

    function filter_join($join){
      global $wp_query, $wpdb;
      $join .= " LEFT JOIN ".$wpdb->prefix."reorder_post_rel ON (".$wpdb->prefix."posts.ID = ".$wpdb->prefix."reorder_post_rel.post_id AND ".$wpdb->prefix."term_relationships.term_taxonomy_id = ".$wpdb->prefix."reorder_post_rel.category_id )";
        return $join;
    }
    
    function edit_posts_orderby($orderby){
      global $wp_query, $wpdb;
      $orderby = " ".$wpdb->prefix."reorder_post_rel.id ";
      return $orderby;
    }
    
    add_filter('posts_join', 'filter_join');
    add_filter('posts_orderby', 'edit_posts_orderby');
    $query = new WP_Query(array(
    	'post_type' => 'your_post_type',
    	...
    ));
    remove_filter('posts_join', 'filter_join');
    remove_filter('posts_orderby', 'edit_posts_orderby');
  7. raymondtbh
    Member
    Posted 5 months ago #

    Hi, can I know how does the above code work? Does it work in such a way that I can display the first 3 post of a categories that is arranged by the plugin?

    Cos Im stuck trying to achieve the above result.

  8. laetitia Godet
    Member
    Posted 5 months ago #

    Yes you can do it simply change the wp_query like this :
    $query = new WP_Query(array(
    'post_type' => 'your_post_type',
    'showposts' => 3,
    'category__in' => array(idCat)
    ));

  9. raymondtbh
    Member
    Posted 5 months ago #

    Hi laetitia Godet, thanks for your reply.

    so i need to add the below into my theme's function.php right? But how do I output the result onto a page template? Via shortcode?

    Really appricate your help.

    function filter_join($join){
      global $wp_query, $wpdb;
      $join .= " LEFT JOIN ".$wpdb->prefix."reorder_post_rel ON (".$wpdb->prefix."posts.ID = ".$wpdb->prefix."reorder_post_rel.post_id AND ".$wpdb->prefix."term_relationships.term_taxonomy_id = ".$wpdb->prefix."reorder_post_rel.category_id )";
        return $join;
    }
    
    function edit_posts_orderby($orderby){
      global $wp_query, $wpdb;
      $orderby = " ".$wpdb->prefix."reorder_post_rel.id ";
      return $orderby;
    }
    
    add_filter('posts_join', 'filter_join');
    add_filter('posts_orderby', 'edit_posts_orderby');
    $query = new WP_Query(array(
    	'post_type' => 'your_post_type',
    	...
    ));
    remove_filter('posts_join', 'filter_join');
    remove_filter('posts_orderby', 'edit_posts_orderby');
  10. laetitia Godet
    Member
    Posted 5 months ago #

    you can add in your template or fonction.php

  11. raymondtbh
    Member
    Posted 5 months ago #

    Hi laetitia Godet, i have added to the following into a custom page template.

    Not sure if its correct, cos the output is still the same
    http://sghome2buy.com/test

    <div class="span9 main-wrap">
    
                    <!-- Main Content -->
                    <div class="main">
    
                        <section class="listing-layout <?php if( $view_type == 'grid' ){ echo 'property-grid'; } ?>">
    
                            <div class="view-type clearfix">
                                <?php
                                $page_url = custom_taxonomy_page_url();
                                $separator = (parse_url($page_url, PHP_URL_QUERY) == NULL) ? '?' : '&';
                                ?>
                                <a class="list <?php if( $view_type != 'grid' ){ echo 'active'; } ?>" href="<?php echo $page_url.$separator.'view=list'; ?>"></a>
                                <a class="grid <?php if( $view_type == 'grid' ){ echo 'active'; } ?>" href="<?php echo $page_url.$separator.'view=grid'; ?>"></a>
                            </div>
    
                            <div class="list-container clearfix">
                                <?php
    
    							function filter_join($join){
    						  global $wp_query, $wpdb;
    						  $join .= " LEFT JOIN ".$wpdb->prefix."reorder_post_rel ON (".$wpdb->prefix."posts.ID = ".$wpdb->prefix."reorder_post_rel.post_id AND ".$wpdb->prefix."term_relationships.term_taxonomy_id = ".$wpdb->prefix."reorder_post_rel.category_id )";
    							return $join;
    						}
    
    						function edit_posts_orderby($orderby){
    						  global $wp_query, $wpdb;
    						  $orderby = " ".$wpdb->prefix."reorder_post_rel.id ";
    						  return $orderby;
    						}
    
    						add_filter('posts_join', 'filter_join');
    						add_filter('posts_orderby', 'edit_posts_orderby');
    						$query = new WP_Query(array(
    							'property-status' => 'landed-for-sale',
    							'post_type' => 'property',
    							'showposts' => 3,
    						));
    						remove_filter('posts_join', 'filter_join');
    						remove_filter('posts_orderby', 'edit_posts_orderby');
    
                                if ( $query->have_posts() ) :
                                    while ( $query->have_posts()) : $query->the_post(); 
    
                                        if( $view_type == 'grid' ){
                                            /* Display Property for Grid */
                                            get_template_part('template-parts/property-for-grid');
                                        }else{
                                            /* Display Property for Listing */
                                            get_template_part('template-parts/property-for-listing');
                                        }
    
                                    endwhile;
                                else:
                                    ?>
                                    <div class="alert-wrapper">
                                        <h4><?php _e('No Results Found', 'framework') ?></h4>
                                    </div>
                                    <?php
                                endif;
                                ?>
                            </div>
    
                            <?php theme_pagination( $wp_query->max_num_pages); ?>
    
                        </section>
    
                    </div><!-- End Main Content -->
    
                </div> <!-- End span9 -->

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • ReOrder Post Within Categories
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.