OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
RealEstateManager component support
Go to bottom Favoured: 0
TOPIC: 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 Months, 2 Weeks 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: 5132
graph
User Offline Click here to see the profile of this user
Re:Backend: list of Properties 7 Months, 2 Weeks ago Karma: 62  
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
What are you looking for?
Anti-spam question: How many eyes has a typical person?