OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
OrdaSoft forum Joomla Real Estate Forums Joomla Real Estate
Amenities - displaying in alphabetical order (0 viewing) 

Joomla Real Estate

Go to bottom Favoured: 0

Amenities - displaying in alphabetical order

#41139
damianradek (User)
Fresh Boarder
Posts: 13
graphgraph
User Offline Click here to see the profile of this user
Amenities - displaying in alphabetical order 5 Years, 7 Months 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: 8366
graph
User Offline Click here to see the profile of this user
Re:Amenities - displaying in alphabetical order 5 Years, 6 Months ago
Karma: 102  
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: 13
graphgraph
User Offline Click here to see the profile of this user
Re:Amenities - displaying in alphabetical order 5 Years, 6 Months ago
Karma: 0  
Hi,

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

Regards
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
Go to top
Powered by OrdaSoft
 
What are you looking for?
»