OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
Amenities - displaying in alphabetical order (0 viewing) 
RealEstateManager component support
Go to bottom Favoured: 0
TOPIC: Amenities - displaying in alphabetical order
#41139
damianradek (User)
Fresh Boarder
Posts: 11
graphgraph
User Offline Click here to see the profile of this user
Amenities - displaying in alphabetical order 3 Months, 3 Weeks ago Karma: 0  
Hi,

I would like to display amenities in alphabetical order (to avoid mess, for easier reading). What file is to be edited and how can I do it?
Big thanks.

Regards,
Radek
 
Logged Logged  
  The administrator has disabled public write access.
#41148
admin (Admin)
Admin
Posts: 6520
graph
User Offline Click here to see the profile of this user
Re:Amenities - displaying in alphabetical order 3 Months, 3 Weeks ago Karma: 75  
Hello

You need in file
{site}/components/com_realestatemanager/realestatemanager.php

find code look like:

Code:

        $query = "SELECT f.* ";
        $query .= "FROM #__rem_feature as f ";
        $query .= "LEFT JOIN #__rem_feature_houses as fv ON f.id = fv.fk_featureid ";
        $query .= "WHERE f.published = 1 and fv.fk_houseid = $id ";
        $query .= "ORDER BY f.categories";
        $database->setQuery($query);
        $house_feature = $database->loadObjectList();



and replace it to code like

Code:

        $query = "SELECT f.* ";
        $query .= "FROM #__rem_feature as f ";
        $query .= "LEFT JOIN #__rem_feature_houses as fv ON f.id = fv.fk_featureid ";
        $query .= "WHERE f.published = 1 and fv.fk_houseid = $id ";
        $query .= "ORDER BY f.categories, f.name";
        $database->setQuery($query);
        $house_feature = $database->loadObjectList();



Please backup file first

Regards
Andrew
OrdaSoft team
 
Logged Logged  
  The administrator has disabled public write access.
#41151
damianradek (User)
Fresh Boarder
Posts: 11
graphgraph
User Offline Click here to see the profile of this user
Re:Amenities - displaying in alphabetical order 3 Months, 3 Weeks ago Karma: 0  
Hi,

It works great! Thank you
 
Logged Logged  
  The administrator has disabled public write access.
#41162
admin (Admin)
Admin
Posts: 6520
graph
User Offline Click here to see the profile of this user
Re:Amenities - displaying in alphabetical order 3 Months, 3 Weeks ago Karma: 75  
You are welcome !

Regards
OrdaSoft team
 
Logged Logged  
  The administrator has disabled public write access.
Go to top
What are you looking for?
Anti-spam question: How many eyes has a typical person?