0,5 bedrooms and 1,5 bathroom dilemma

Hi

Thank you, for all the changes to date for Osproperty, but sadly I have another request. We have a lot of Apartments (Bachelor) that only have 0,5 bedrooms as they have the option of a smaller separate room that could double up as a bedroom. Could it be possible to bring that in to the mix and also searchable?

Regards

Nel

Hi Nel,
I can change the database structure to from integer to decimal for you, and then, you can enter the decimal number like 1,5 or 0,5.
But the main problem is system can't search those values, it can only search the integer value like 1,2,3,4,5 v.v.
Thanks
Dam

Hi Dam

Could you maybe then just add '0+' to the number of Bedrooms and Bathrooms?

Regards

Nel

Hi,
You can add 0+ into the filter fields in Advanced search page by follow these steps
1. Open file : components > com_osproperty > classes > listing.php
2 . find
// number bath room
$bathArr[] = JHTML::_('select.option','',JText::_('OS_ANY'));
for($i=1;$i<=5;$i++){
$bathArr[] = JHTML::_('select.option',$i,$i.'+');
}
$lists = JHTML::_('select.genericlist',$bathArr,'nbath',' class="input-small" style="width:100px;"','value','text',$nbath);


//number bed room
$lists = $nbed;
$bedArr[] = JHTML::_('select.option','',JText::_('OS_ANY'));
for($i=1;$i<=5;$i++){
$bedArr[] = JHTML::_('select.option',$i,$i.'+');
}
$lists = JHTML::_('select.genericlist',$bedArr,'nbed','class="input-small" style="width:100px;"','value','text',$nbed);

from line 1046
and change to

// number bath room
$bathArr[] = JHTML::_('select.option','',JText::_('OS_ANY'));
for($i=0;$i<=5;$i++){
$bathArr[] = JHTML::_('select.option',$i,$i.'+');
}
$lists = JHTML::_('select.genericlist',$bathArr,'nbath',' class="input-small" style="width:100px;"','value','text',$nbath);


//number bed room
$lists = $nbed;
$bedArr[] = JHTML::_('select.option','',JText::_('OS_ANY'));
for($i=0;$i<=5;$i++){
$bedArr[] = JHTML::_('select.option',$i,$i.'+');
}
$lists = JHTML::_('select.genericlist',$bedArr,'nbed','class="input-small" style="width:100px;"','value','text',$nbed);

Good luck
Dam

Thanks Dam!

Hi Dam,

Hope all is well... alas I got feedback from the Estate Agency and they would rather have a decimal database structure so that the property will display 1,5 or 0,5 bedrooms and/or bathrooms in the listing (see attach). As for the searching of these values, they are not bothered about the not being able to search for that values.

Regards and thank you in advance for your assistance.

Nel

Hi,
I think you can change the attribute of those fields from integer to decimal by using phpmyadmin
Data table
#__osrs_properties
field
bed_room
bath_room
rooms
Currently, their attributes are int(11), you can change them to decimal (5,2)
Good luck
Dam

Thanks Dam

But I think I will pass on this one... scared I break the whole site.

Regards

Nel