Calculated fields in 6.0 CE

[edlentz]

I want to be able to take a field that is already calculated and divide it by half and insert it into another field. I have a quote module that totals the quote amount. I want to take the total and divide it in half for a down payment amount. Can someone show me how to do this?

Thanks

[davidboris]

Hello,

You can write a before_save logic hook. And put code something like,

 $bean-><FINAL_FIELD_NAME> = $bean-><FIELD_NAME_TO_DIVIDE_BY_2> / 2; 
  

[edlentz]

Hi David

I see what you are doing there. But I am new to this and in the AOS module I want to work I can't find where to use that code. Can you help me with "logic hooks" I am not sure where to go to make this work

Thanks

Ed

[edlentz]

Well, looking around I was able to come up with this:

<?php
$hook_version = 1;
$hook_array = Array();
$hook_array['before_save'] = Array(1,'$bean-><downpayment_c> = $bean-><total_amount> / 2');

?>

I put this in a logic_hooks.php file and into the root of the module.
So this does nothing at this point.

What have I got wrong?

Thanks

[davidboris]

Hello,

You should write something like,

 $hook_version = 1;
$hook_array = Array();
$hook_array['before_save'] = Array(1,'Calculating field', 'custom/modules/<YOUR_MODULE_NAME>/<ANYFILE>.php','calculate_field_class', 'calculate_field_function'); 
  

In that <ANYFILE>.php, must be located as mentioned above, write following code

 Class calculate_field_class
{
 function calculate_field_function()
  {
      $bean->downpayment_c = $bean->total_amount / 2;
   }
} 
  

NOW, change every variables here, <YOUR_MODULE_NAME>, <ANYFILE>.

[edlentz]

I think I havre it now. I'll try it and report back

Thanks!

[edlentz]

OK so here's what I have:

here is my logic_hooks.php file

<?php
$hook_version = 1;
$hook_array = Array();
$hook_array['before_save'] = Array(1,'Calculating field', 'custom/modules/AOS_Quotes/downpaymentcalc.php','calculate_field_class', 'calculate_field_function');
 ?>

In the downpaymentcalc.php

<?php
Class calculate_field_class
{
 function calculate_field_function()
  {
      $bean->downpayment_c = $bean->total_amount / 2;
   }
}
 ?>

Both are in the /custom/modules/AOS_Quotes directory.

Will this work on existing DB entries? Or do I need to start from a new Quote?

Thanks

[davidboris]

Hello,

For old database records, you will need to run following query in database directly(Take backup of custom table, to avoid any mishap.),

 UPDATE CUSTOM_TABLE_NAME c 
INNER JOIN TABLE_NAME m ON m.id = c.id_c 
SET c.downpayment_c = (m.total_amount / 2) WHERE m.deleted = 0; 
  

Change the custom_table_name and table_name with respective table names.

Logic hook will work when you edit a record or create new one.

[edlentz]

Hi David,

Is there a way to stop a Logic Hook from working when a module is built? The reason I ask is that this isn't working. I have checked over and over and don't see any typos in my field entries.

Any suggestions?

thanks for your help

[davidboris]

Hello,

Paste the code you have implemented, with the path you have put the files at, etc.