Property reference number

Hi, I have a few questions about property reference numbers.

Is it possible to automatically generate a reference number each time a property is created?

Can I change the listing links, currently I have this very long link
example : mysite.com/houselisting/house-for-sale/spacious-condo
I would like instead to be mysite.com/351266 (reference number)

Thanks

Hi Richard,
OS Property only create the ID number automatically. It doesn't have feature to create REF field number automatically. By the way, if you want to shorten the Property Detais link, you can modify file
components > com_osproperty > router.php
and change bellow code
case "property_details":
include_once(JPATH_ROOT.'/components/com_osproperty/helpers/helper.php');
$default_language = OSPHelper::getDefaultLanguage();
$default_language = explode("-",$default_language);
$default_language = $default_language[0];
$default_language = "_".$default_language;
$lang = isset($query) ? $query : "";
$id = $query;
if($lang != ""){
if($default_language == $lang){
$db->setQuery("Select pro_name,pro_alias from #__osrs_properties where id = '$id'");
}else{
$db->setQuery("Select pro_name$lang as pro_name,pro_alias$lang as pro_alias from #__osrs_properties where id = '$id'");
}
$property = $db->loadObject();
$pro_alias = $property->pro_alias;
$pro_name = $property->name;
if(($pro_alias == "") AND ($pro_name == "")){
$db->setQuery("Select * from #__osrs_properties where id = '$id'");
$property = $db->loadObject();
$pro_alias = OSPHelper::getLanguageFieldValue($property,'pro_alias');
$pro_name = OSPHelper::getLanguageFieldValue($property,'pro_name');
}
}else{
$db->setQuery("Select * from #__osrs_properties where id = '$id'");
$property = $db->loadObject();
$pro_alias = OSPHelper::getLanguageFieldValue($property,'pro_alias');
$pro_name = OSPHelper::getLanguageFieldValue($property,'pro_name');
}
unset($query);

if($pro_alias != ""){
$segs = $pro_alias;
}else{
$segs = $pro_name;
}
$segments[] = $segs;
unset($query);
if (!isset($query) or ($query == 0) or ($query == 99999) or ($query == 9999)){
unset($query);
}
break;
To make the shorter url alias
Thanks
Dam

I tried replacing the code you gave and it just broke the site, error 1054 or something...
Not sure I understand properly.

Thank you

Hi Richard,
Yes, we agree with you. It's one of difficult tasks of OS Property.
You can try to replace by this code
case "property_details":
include_once(JPATH_ROOT.'/components/com_osproperty/helpers/helper.php');
$default_language = OSPHelper::getDefaultLanguage();
$default_language = explode("-",$default_language);
$default_language = $default_language[0];
$default_language = "_".$default_language;
$lang = isset($query) ? $query : "";
$id = $query;
if($lang != ""){
if($default_language == $lang){
$db->setQuery("Select ref,pro_name,pro_alias from #__osrs_properties where id = '$id'");
}else{
$db->setQuery("Select ref,pro_name$lang as pro_name,pro_alias$lang as pro_alias from #__osrs_properties where id = '$id'");
}
$property = $db->loadObject();
$pro_alias = $property->pro_alias;
$ref = $property->ref;
if($ref != ""){
$segs = $ref;
}elseif($pro_alias != ""){
$segs = $pro_alias;
}else{
$segs = $pro_name;
}
$segments[] = $segs;
unset($query);
if (!isset($query) or ($query == 0) or ($query == 99999) or ($query == 9999)){
unset($query);
}
break;

But i am not sure it will work properly, in that case, please sympathize to us.
Thanks
Dam

It does not work, but thank you for trying!

I will find a different method, maybe use less submenus.

Thanks again

Ok Richard
Dam