Add company phone

Hi, I need (customer request) to add company phone or agent mobile phone to property listing and to property details.
How can I do that ?
Thank you for your help.

Hi Frederic,
The agent mobile number is shown at the property details page already.
With the list of properties page, you can edit in file
components > com_osproperty > templates > your_current_template > listing.html.tpl.php
and
components > com_osproperty > templates > your_current_template > result.html.tpl.php
Thanks
Dam

I have add this in listing.html.tpl.php and in result.html.tpl.php :

Same blank result with company phone, the phone is not showing, I think it must be declared in a php file in classes, but which ?

Hi,
Please submit ticket and send your site information so i can help you add agent mobile number in the listing
Thanks
Dam

Thank you but the site is not in production, give me the code I can do it.

Hi,
You need to retrieve the mobile number of agent in the sql query in file
components > com_osproperty > classes > listing.php
function listProperties
query:
$query = "Select a.*,b.id as catid,b.category_name$lang_suffix as category_name,c.name as agent_name,c.photo as agent_photo,c.email as agent_email,d.id as typeid,d.type_name$lang_suffix as type_name,e.country_name from #__osrs_properties as a"
." LEFT JOIN #__osrs_categories as b on b.id = a.category_id"
." INNER JOIN #__osrs_agents as c on c.id = a.agent_id"
." LEFT JOIN #__osrs_types as d on d.id = a.pro_type"
." LEFT JOIN #__osrs_countries as e on e.id = a.country"
." WHERE 1=1";

and you add mobile into that sql

$query = "Select a.*,b.id as catid,b.category_name$lang_suffix as category_name,c.name as agent_name,c.mobile,c.photo as agent_photo,c.email as agent_email,d.id as typeid,d.type_name$lang_suffix as type_name,e.country_name from #__osrs_properties as a"
." LEFT JOIN #__osrs_categories as b on b.id = a.category_id"
." INNER JOIN #__osrs_agents as c on c.id = a.agent_id"
." LEFT JOIN #__osrs_types as d on d.id = a.pro_type"
." LEFT JOIN #__osrs_countries as e on e.id = a.country"
." WHERE 1=1";

And then, you will have call $row->mobile to show the mobile number of agent in the list of Properties page

Good luck
Dam

Wonderful, it's work fine, thank you !

Last request. The results (displaying property list) after filter from search module must be order by price, where is the code to change please ?

Hi,
You can edit in the file
components > com_osproperty > classes > listing.php
function advSearch line 741

find: $Order_by = " ORDER BY a.isFeatured desc,a.id desc ";
and change to
$Order_by = " ORDER BY a.price desc ";

Good luck
Dam