Logic Hook Calculation Will Only Add Up To 999.99?

[lassociates]

I have created a logic hook to calculate fields in the leads table from a post I found by andopes. If the calculation is between -999.99 and 999.99 there is no problem but if the result is 1000.00 then the logic hook inserts NULL in to the table. All of the fields are decimal fields in the database and I am not real sure what is causing this. Any help would be greatly appreciated.

 <?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');

class LeadLogicHook {
    function calculate_field(&$focus, $event, $arguments) {
        // andopes comment: for float numbers it is necessary to unformat them to avoid wrong calculation
        require_once('modules/Currencies/Currency.php');

        $field1 = unformat_number($focus->field1);
        $field2 = unformat_number($focus->field2);
        $field3 = unformat_number($focus->field3);
        $field4 = $field1 + $field2 + $field3;
        $focus->field4 = format_number($field4);
    }
}
?>  

[andopes]

Let us know the file cache/modules/Leads/Leadvardefs.php

Add the lines:

 echo "<LI>field 1 before transformation: '{$focus->field1}'</LI>";
echo "<LI>field 1 after transformation: '{$field1}'</LI>";
echo "<LI>field 2 before transformation: '{$focus->field2}'</LI>";
echo "<LI>field 2 after transformation: '{$field2}'</LI>";
echo "<LI>field 3 before transformation: '{$focus->field3}'</LI>";
echo "<LI>field 3 after transformation: '{$field3}'</LI>";
echo "<LI>field 4 before transformation: '{$field4}'</LI>";
echo "<LI>field 4 after transformation: '{$focus->field4}'</LI>";
die(); 
  

Just after the line

 $focus->field4 = format_number($field4); 
  

And try again. Let us know the result.

Cheers

[lassociates]

The results:

# field 1 before transformation: '952.00'
# field 1 after transformation: '952.00'
# field 2 before transformation: '210.00'
# field 2 after transformation: '210.00'
# field 3 before transformation: '1.00'
# field 3 after transformation: '1.00'
# field 4 before transformation: '1.00'
# field 4 after transformation: '1.00'
# Total Calculation: '1,184.00'

The exp_total_c field in the database says NULL even though the calculation is correct. I have attached the Leadvardefs.php as there are a bunch of custom fields and that file is getting large.


Thank you for taking the time to help me on this.
Jason

[lassociates]

Any ideas on what might be causing this?

[andopes]

The calculation does not seem OK.
Let us know the logic_hook function.

Best regards

[lassociates]

I have attached the files requested, thank you again for taking a look.

Regards,
Jason

[andopes]

The script seems fine.

Make sure the field exp_total_c exists on leads_cstm table.

Cheers

[lassociates]

The field does exist in the table and will display the value accurately up to the value of 999.99. Once the value goes above that then the database shows a NULL value.

[lassociates]

Ok, here's the problem...

If you look at the results the calculation does great, the problem is when it gets to 1000.00 it will no longer insert the number into the database. The results tells all, the total says 1,184.00 which cannot be inserted into a decimal field in the database. Strip the , out of the number being inserted into the database and the calculation now works as it should.

changing:

 $focus->field4 = format_number($field4); 
  

to:

 $focus->field4 = unformat_number($field4); 
  

Seems to fix this calculation.