Calculate Fields

[xf4driver]

First entry here so bear with me. I created 2 custom modules for placing orders called requisitions & line items. I have fields in line items named quantity, price & total. I have a field in the requisitions module called total cost. What I need sugar to do is calculate quantity * price = total for each of the line items, display the total, & then place the sum of total in the total cost field of the requisitions module.
I have read the thread in wiki on logic hooks & most of the ones on calculating fields in the forum. I have copied the format shown in this thread: http://www.sugarcrm.com/forums/showt...culated+fields but substituted my field names & nothing happens. I may be putting the files in the wrong place.
Can someone help with this. Would appreciate it if you could be as specific as you can as I am a programming novice. I use 5.1 CE on a Windows based system.
Also, if someone knows of a module that does something similar I can upload it & use that coding as a guide.

[Iggby]

I have a logic hook that calculates the sum of fields with a module and it works perfectly. I would suggest posting the code that you are trying that doesn't work so we can give more specific suggestions on your problem.

As far as pulling values between 2 modules, I cannot be of help as that is something I have been trying to get accomplished for months with no success.

Also this post probably would be better off in the developers help section.

[xf4driver]

Thanks for the prompt reply. Here is my code:
<?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
$hook_version=1;
$hook_array=Array();
$hook_array['before_save']=Array();
$hook_array['before_save']
[]=Array(1,'calculatefield','modules/Line6_LineItems/total.php','TotalClass','calculatefield_before_sav e');
?>
<?php

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

class Total {
function calculateField(&$focus, $event, $arguments) {
$focus->total = $focus->quantity * $focus->price;
}
}

?>
I pretty much copied the example from the referenced thread & plugged in my module & field names.

[Iggby]

Thanks for the prompt reply. Here is my code:
<?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
$hook_version=1;
$hook_array=Array();
$hook_array['before_save']=Array();
$hook_array['before_save']
[]=Array(1,'calculateField','modules/Line6_LineItems/total.php','Total','calculateField');
?>
<?php

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

class Total {
function calculateField(&$focus, $event, $arguments) {
$focus->total = $focus->quantity * $focus->price;
}
}

?>
I pretty much copied the example from the referenced thread & plugged in my module & field names.

Try the changes in bold. You are referencing the class TotalClass in your logic hook but then the class is called Total in your script. Also your function within the class needs to be the same. At least this is what looks incorrect to me. I also do the formula differently but this may be a more correct way, so try the changes mentioned first, if it still doesn't work I can show the way I accessed the fields in my script.

[xf4driver]

I know this is kind of basic but where do I put the code files. I must be putting them in the wrong place.

[Iggby]

I put the script and logic hook file in custom/modules/MODULE/ where MODULE is the name of the module the logic hook goes to. This way the files will not be overwritten in an upgrade. You also would need to change the path in the logic hook file to this location ex:

$hook_array['before_save'] []=Array(1,'calculateField','custom/modules/total.php','Total','calculateField');

make sure the permissions are correct as well, sometimes when transferring files I forget to make the file accessible by the we server and things dont work.

Good luck.

[Iggby]

by the way that wouldn't happen to be f4 as in phantom would it?

[xf4driver]

Yes it would. Flew them in the USMC many years ago. The J & S model. Can you show me your math script. Mine is still not working.

[xf4driver]

I got it to work! Thanks for all your help.

[Iggby]

Hopefully something I said led you in the right direction.

My friend flew f18's for the core. I just fly a bonanza. I appreciate your service to our country.