Subpanel field format - SugarCRM 5

[nicholak]

I have successfully installed a custom module including tables etc and it is correctly displaying detail view and the subpanel in the Accounts module view.

Whilst the currency format fields for the new module display correctly in their detail view (rounded to 2 decimal places), the subpanel shows the exact db field content which is 6 decimal places (which is odd given that I chose currency type in the module builder...).

Can anyone suggest how to apply formatting to the subpanel view? Perhaps a custom template is required?

TIA.

Nicholas

[lvangool]

I looked into it last night, and I couldn't get it right either. In Opportunities' subpanels, there's a nice currency character, and rounding as you say. But setting the fields to type=>currency did not make a difference...

Please please Sugar, enlighten us.

[mareczek1982]

I have a question related to your problems.. I would like to disable .00 (decimal separator and 00) values in amount (opportunities).. also.. In list view I want to change display format of amount.. now I have zl2,207.00.. I would like to have 2,207 zl .. What should I do ?

marekk

/I've found the answer
I've edited format_number and format_place_symbol funcions in /var/www/sugarcrm/modules/Currency/Currency.php

[dlorenzetti]

Try to put a function named "get_list_view_data" in the Bean of the your module ( MODULE_NAME.php )

Ex: in this case "amount" field.

function get_list_view_data(){
global $locale, $current_language, $current_user, $mod_strings, $app_list_strings, $sugar_config;
$app_strings = return_application_language($current_language);
$params = array();
require_once('modules/Currencies/Currency.php');
$temp_array = $this->get_list_view_array();
$temp_array[AMOUNT'] = currency_format_number($this->amount,$params);
return $temp_array;
}

Any doubt, you cam see this function in modules/Opportunity/Opportunity.php

_________
Diego Lorenzetti
Lampada Global Services
SugarCRM Silver Partner
+55 11 3237-3110
Sao Paulo, Brasil
www.lampadaglobal.com

[nicholak]

I have a question related to your problems.. I would like to disable .00 (decimal separator and 00) values in amount (opportunities).. also.. In list view I want to change display format of amount.. now I have zl2,207.00.. I would like to have 2,207 zl

Your question is not specific to this thread. Please do not hijack the threads of others - just start a new thread in future.

[nicholak]

Thanks Diego. I'll try your suggestion and report back just as soon as I can get it done.

[nicholak]

Diego, can you please clarify if your suggestion is in reply to my question, or to that of mareczek1982? It appears related to his and not mine. Thank you.

Nicholas

[dlorenzetti]

Hey Nicholas,

it's to your question, for to show the fields with the currency format in SubPanel.

[Dentalman]

Hi dlorenzetti,

I got the get_list_view_data() function working for a field, but what are you supposed to do when you have let's say 3 fields to show as currencies in the subpanel?

I am a bit surprised that only 'currency_format' => true, is needed to display currency fields in the list view but you need to go through all this trouble for a subpanel.

Cheers
DM

[dlorenzetti]

Hi Dentalman,

To show more than one field as currencies in the subpanel you is just add the line:
$temp_array[AMOUNT'] = currency_format_number($this->amount,$params);
for each field.

i.e.:
$temp_array[<NAME_OF_FIELD>'] = currency_format_number($this-> <name_of_field> ,$params);

this parameter: 'currency_format' => true, work only in ListView.