Difference between revisions of "How to change ordering after featured listings"

From JReviews Documentation
Jump to: navigation, search
Line 22: Line 22:
  
 
<source lang="php">
 
<source lang="php">
case 'featured':
 
 
     $order = 'Field.featured DESC, Listing.title ASC';
 
     $order = 'Field.featured DESC, Listing.title ASC';
 
</source>
 
</source>
Line 29: Line 28:
 
'''Ordering by most viewed listings'''
 
'''Ordering by most viewed listings'''
 
<source lang="php">
 
<source lang="php">
case 'featured':
 
 
     $order = 'Field.featured DESC, Listing.hits DESC';
 
     $order = 'Field.featured DESC, Listing.hits DESC';
 
</source>
 
</source>
Line 37: Line 35:
  
 
<source lang="php">
 
<source lang="php">
case 'featured':
 
 
     $order = 'Field.featured DESC, Totals.user_rating DESC, Totals.user_rating_count DESC';
 
     $order = 'Field.featured DESC, Totals.user_rating DESC, Totals.user_rating_count DESC';
 
</source>
 
</source>
Line 46: Line 43:
 
   
 
   
 
<source lang="php">
 
<source lang="php">
case 'featured':
 
 
     $order = 'Field.featured DESC, Totals.editor_rating DESC, Totals.editor_rating_count DESC';
 
     $order = 'Field.featured DESC, Totals.editor_rating DESC, Totals.editor_rating_count DESC';
 
</source>
 
</source>
Line 54: Line 50:
 
   
 
   
 
<source lang="php">
 
<source lang="php">
case 'featured':
 
 
     $order = 'Field.featured DESC, Totals.user_comment_count DESC';
 
     $order = 'Field.featured DESC, Totals.user_comment_count DESC';
 
</source>
 
</source>

Revision as of 22:52, 1 April 2014

When you set the default ordering for list pages to Featured in global configuration, the rest of the listings below featured will be ordered by submission date.

If you want to change that, edit this file:

  • /com_jreviews/jreviews/models/everywhere/everywhere_com_content.php


Find the code for featured ordering:

case 'featured':
 
   // ... some other lines in between ...
 
   $order = 'Field.featured DESC, Field.contentid DESC';


And change it to one of the below, depending which ordering after featured listings you want:


Ordering by title

    $order = 'Field.featured DESC, Listing.title ASC';


Ordering by most viewed listings

    $order = 'Field.featured DESC, Listing.hits DESC';


Ordering by highest user rating

    $order = 'Field.featured DESC, Totals.user_rating DESC, Totals.user_rating_count DESC';


Ordering by highest editor rating

    $order = 'Field.featured DESC, Totals.editor_rating DESC, Totals.editor_rating_count DESC';


Ordering by number of reviews

    $order = 'Field.featured DESC, Totals.user_comment_count DESC';