Custom calculated field based on CustomAgingField.php from Sugar University

[Billwobo]

I created this custom field to calculate an amount from a price & a Quantity. I based this process on this Tutorial, from Sugar University: http://developers.sugarcrm.com/tutor...AgingField.pdf


So my custom vardef is :

   'amount' => 
  array (
    'required' => false,
    'name' => 'amount',
    'vname' => 'LBL_AMOUNT',
    'type' => 'float',
    'CustomCode' => 'array('name'=>'getAmount', 'returns'=>'html',         'include'=>'custom/CustomCode.php'),
    'len' => '6',
    'comment' => 'Calculated total amount',
    'massupdate' => 0,
    'comments' => '',
    'help' => '',
    'duplicate_merge' => 'enabled',
    'duplicate_merge_dom_value' => '1',
    'audited' => 1,
    'reportable' => 0,
    'len' => '18',
    'precision' => '4,
  ), 
  

It includes a custom file called custom/CustomCode.php.

The Customcode.php file is:

 function getAmount($bean,$field,$value) {
 
$price=($bean->price);
$quantity=($bean->quantity);
$amount = ($quantity * $price);
//
return ($amount); 
  

First of all the Amount doesn't appear in the "Amount" field, but rather at the top of the page, below the header.

Then, although it does display an amount, the result is wrong.

I know it's probably basic, but can anyone comment on this code? It would greatly help me comprehend php better.

[chad.hutchins]

In your vardefs.php code, try changing 'CustomCode' to 'function'.

[Billwobo]

Yeah, you're right about the 'function'. I forgot, that I had tried 'customCode' and forgot to change it. I fixed it.

But it didn't do the trick.

When I put only $price, or $quantity in the $amount() it gives me the right answer. It seems to be the a * b function that doesn't work.

[chad.hutchins]

Hmm... What if you tried casting the variables to floats first? They might be returning as strings, so it is multiplying the two strings rather than the actual float values?

 $price = (float) $bean->price;
$quantity= (float) $bean->quantity;
$amount = $quantity * $price; 
  

[sidh211]

Hi,

I tried this solution its working fine. But is it possible to store this calculated filed into database.
I have crested column but null value is getting stored there. pls help.

Thanks & Regards
Sid