OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
OrdaSoft forum Joomla Real Estate Forums Joomla Real Estate
Backend: list of Properties (0 viewing) 

Joomla Real Estate

Go to bottom Favoured: 0

Backend: list of Properties

#23795
xama (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Backend: list of Properties 7 Years, 11 Months ago
Karma: 0  
how can i change the order of properties listed in administration side of the components?

Thanks

Giovanni
Logged Logged
The administrator has disabled public write access.
#23823
admin (Admin)
Admin
Posts: 8366
graph
User Offline Click here to see the profile of this user
Re:Backend: list of Properties 7 Years, 11 Months ago
Karma: 102  
Hello,

You need in {your site}/administrator/components/com_realestatemanage.php

find function showHouses

code:
Code:
    $selectstring = "SELECT a.*, GROUP_CONCAT(DISTINCT(cc.title) SEPARATOR ',') AS category, 
            l.id as rentid, l.rent_from as rent_from, l.rent_return as rent_return,
            l.rent_until as rent_until, u.name AS editor, ue.name AS editor1" .
            "nFROM #__rem_houses AS a" .
            "nLEFT JOIN #__rem_categories AS hc ON hc.iditem = a.id" .
            "nLEFT JOIN #__rem_main_categories AS cc ON cc.id = hc.idcat" .
            "nLEFT JOIN #__rem_rent AS l ON l.fk_houseid = a.id  and l.rent_return is null " .
            "nLEFT JOIN #__users AS u ON u.id = a.owner_id" .
            "nLEFT JOIN #__users AS ue ON ue.id = a.checked_out" .
            (count($where) ? "nWHERE " . implode(' AND ', $where) : "") .
            "nGROUP BY a.id" .
            "nORDER BY a.htitle " .
            "nLIMIT $pageNav->limitstart,$pageNav->limit;";


replace to (replace ORDER BY )
Code:
    $selectstring = "SELECT a.*, GROUP_CONCAT(DISTINCT(cc.title) SEPARATOR ',') AS category, 
            l.id as rentid, l.rent_from as rent_from, l.rent_return as rent_return,
            l.rent_until as rent_until, u.name AS editor, ue.name AS editor1" .
            "nFROM #__rem_houses AS a" .
            "nLEFT JOIN #__rem_categories AS hc ON hc.iditem = a.id" .
            "nLEFT JOIN #__rem_main_categories AS cc ON cc.id = hc.idcat" .
            "nLEFT JOIN #__rem_rent AS l ON l.fk_houseid = a.id  and l.rent_return is null " .
            "nLEFT JOIN #__users AS u ON u.id = a.owner_id" .
            "nLEFT JOIN #__users AS ue ON ue.id = a.checked_out" .
            (count($where) ? "nWHERE " . implode(' AND ', $where) : "") .
            "nGROUP BY a.id" .
            "nORDER BY a.id" .
            "nLIMIT $pageNav->limitstart,$pageNav->limit;";


Before edit, Please backup this file

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