OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
OrdaSoft forum Joomla Real Estate Forums Joomla Real Estate
Search options in free edition (0 viewing) 

Joomla Real Estate

Go to bottom Favoured: 0

Search options in free edition

#12420
panda (Visitor)
Posts: 0
graphgraph
User Offline
Re:Search options in free edition 10 Years, 6 Months ago
Karma: 0  
and i found in Search Function the variable for pricefrom,priceto

Code:
$pricefrom = intval(mosGetParam($_REQUEST, 'pricefrom', ''));
        $priceto = intval(mosGetParam($_REQUEST, 'priceto', ''));
        if ($pricefrom > 0)
            $where[] = " CAST( b.price AS SIGNED) >= $pricefrom ";
        if ($priceto > 0)
            $where[] = " CAST( b.price AS SIGNED) <= $priceto ";


so i added the variable for lotsize in this way ...

Code:
$lotsizefrom = intval(mosGetParam($_REQUEST, 'lotsizefrom', ''));
        $otsizeto = intval(mosGetParam($_REQUEST, 'lotsizeto', ''));
        if ($lotsizefrom > 0)
            $where[] = " CAST( b.price AS SIGNED) >= $lotsizefrom ";
        if ($lotsizeto > 0)
            $where[] = " CAST( b.price AS SIGNED) <= $lotsizeto ";
Logged Logged
The administrator has disabled public write access.
#12432
panda (Visitor)
Posts: 0
graphgraph
User Offline
Re:Search options in free edition 10 Years, 6 Months ago
Karma: 0  
no way to make the search work ... i miss something probably definition of lotsizefrom lotsizeto ?
Logged Logged
The administrator has disabled public write access.
#12433
admin (Admin)
Admin
Posts: 8367
graph
User Offline Click here to see the profile of this user
Re:Search options in free edition 10 Years, 6 Months ago
Karma: 102  
hello,

you was need save that lotsize to some database field and now add to select search by that field

Thanks,
ordaspoft team
Logged Logged
The administrator has disabled public write access.
#12442
panda (Visitor)
Posts: 0
graphgraph
User Offline
Re:Search options in free edition 10 Years, 6 Months ago
Karma: 0  
lotsize should already be stored in database , as agents can insert it in house fields when entering new houses ...

so i only need the code to add search for that filed . I think this would be a good add for mod_search_free

if you can help me on this cause i can't find any tips
Logged Logged
The administrator has disabled public write access.
#12449
admin (Admin)
Admin
Posts: 8367
graph
User Offline Click here to see the profile of this user
Re:Search options in free edition 10 Years, 6 Months ago
Karma: 102  
Table rem_houses - not have by default field lot_size

so you need use that field, and start you need from end select. Please print - end select with lot_size - and debug it

Thanks,
ordasoft tean
Logged Logged
The administrator has disabled public write access.
#12460
panda (Visitor)
Posts: 0
graphgraph
User Offline
Re:Search options in free edition 10 Years, 6 Months ago
Karma: 0  
can you be more specific ? i can't understand ur last message . thank you
Logged Logged
The administrator has disabled public write access.
Go to top
Powered by OrdaSoft
 
What are you looking for?
»