Logic_hooks - Wrong calculate with cents.

[jorgeluiz]

Hello,
I use Logic_hooks to make a calculation:
[Quantity] * [cost price] = [cost]
[Quantity] * [sell price] = [sale]
[cost] - [sale] = gross margin

[5] * [200.00] = [1000.00]
[5] * [300.00] = [1500.00]
[1000.00] - [1500.00] = [500.00]

My problem:

When the price is full, with only 0.00, fine works.
An error occurs when getting absurd with prices in cents.

[5] * [200.01] = [1000.05]
[5] * [300.00] = [1500.00]
[1000.05] - [1500.00] = [-98505.00]

Reviewed all the fields in mysql, formats semicolon, but not identified anything to size error.
I found some posts here on the forum and decimal precision of rounding, but did not find what you need.
Someone has encountered a problem like this?
If someone has a suggestion, thanks a lot

Sugar CE version 5.1a
PHP Version 5.2.5
MySQL Version: 5.0.45
Windows Server 2003

[andopes]

Hi Jorge

Use the format_number / unformat_number function into modules/Currencies/Currency.php
This may fix these issues.

Regards

[jorgeluiz]

Olá André,
Mais alguns detalhes:
Pelo Admin, configurei o Sugar para usar o separador de milhar o ',' (ponto) e os decimais a ',' (vírgula) e estou usando duas casas decimais.
Os campo de 'valor' são Currency e os de quantidade são Integer.
No Mysql os campos 'valor' estão como decimal (26,6) e quantidade INT(11)

Mas não sei exatamente o que deve ser alterado no arquivo Currency.php?

    function unformat_number($string) {
    static $currency = null;
    if(!isset($currency)) {
        global $current_user;
        $currency = new Currency();
        if($current_user->getPreference('currency')) $currency->retrieve($current_user->getPreference('currency'));
        else $currency->retrieve('-99'); // use default if none set
    }
    
    $seps = get_number_seperators();
    // remove num_grp_sep and replace decimal seperater with decimal
    $string = trim(str_replace(array($seps[0], $seps[1], $currency->symbol), array('', '.', ''), $string));
     preg_match('/[0-9\.]*/', $string, $string);
    return trim($string[0]); 
  

Grande abraço e obrigado pela ajuda.

Jorge
Sugar CE version 5.1a
PHP Version 5.2.5
MySQL Version: 5.0.45
Windows Server 2003

[jorgeluiz]

Hi André,
sorry, but posted in Portuguese.

A few more details:
By Admin, set up the Sugar to use the tab of thousands o ',' (point) and the decimal ',' (comma) and I am using two decimal places.
The field of 'value' are of the Currency and quantity are Integer.
Mysql in the 'value' are as decimal (26,6) and quantity INT (11)

But I do not know exactly what needs to be changed in Currency.php file?

Jorge
Sugar CE version 5.1a
PHP Version 5.2.5
MySQL Version: 5.0.45
Windows Server 2003

[andopes]

Hi Jorge

Don't you worry about that.
Your Power Translator Tabajara seems pretty good!
Actually you don't need to modify anything into Currency.php
It contains the functions I mentioned previously. Both gets parameters which guide it to format/unformat numbers.
You should create a simple php script to run outside Sugar which gets both values you are going to calculate and generate the result you are looking for.
Make changes on this script and when you get the correct result you can add the formula into your logic hook.
You may use the Currency.php functions to facility the work to you removing the formatting characters.

Regards

[jorgeluiz]

André,
Vai ter gente procurando no Google o Power Translation Tabajara pra baixar!!!
Abraços