Javascript - Onchange

[ff76]

Hi,

I have this problem.. I have create a custom Module with module builder and I have this field:

- km
- cost_km
- total

I want to do this calculation when change the field cost_km:

total = km * cost_km

I do not know javascript...

How I can do?

thank you

[eggsurplus]

Unfortunately, you'll need to know some php to create a logic hook that does that calculation before_save.

[ff76]

i have create this file logic_hooks.php in the custom folder:

 <?php
// Do not store anything in this file that is not part of the array or the hook version.  This file will    
// be automatically rebuilt in the future. 
 $hook_version = 1; 
$hook_array = Array(); 
// position, file, function 
$hook_array['before_save'] = Array(); 
$hook_array['before_save'][] = Array(1, 'calcola_totale', 'modules/med_Rimborso_Righe/aggiornaRimborsoHook.php','aggiornaRimborsoHook', 'aggiornaRiga'); 
?>  

also I have create this file aggiornaRimborsoHook.php

 <?php
class aggiornaRimborsoHook
{
  // Aggiorno i Rimborsi
  function aggiornaRiga(&$bean, $event, $arguments)
  {
    $tbl = $bean->table_name;
 
    $id = $bean->id;
 
    // calcolo il rimborso 
    $rimborso = $bean->costo_km * $bean->km;
    
    $q = "UPDATE med_rimborso_righe md SET md.rimborso_km =  $rimborso WHERE md.id = '$id'";
    $bean->db->query($q);
  }
}
?>  

The problem is that: the field rimborso_km is not updated..

Why ?

[ff76]

i have create this file logic_hooks.php in the custom folder:

 <?php
// Do not store anything in this file that is not part of the array or the hook version.  This file will    
// be automatically rebuilt in the future. 
 $hook_version = 1; 
$hook_array = Array(); 
// position, file, function 
$hook_array['before_save'] = Array(); 
$hook_array['before_save'][] = Array(1, 'calcola_totale', 'modules/med_Rimborso_Righe/aggiornaRimborsoHook.php','aggiornaRimborsoHook', 'aggiornaRiga'); 
?>  

also I have create this file aggiornaRimborsoHook.php

 <?php
class aggiornaRimborsoHook
{
  // Aggiorno i Rimborsi
  function aggiornaRiga(&$bean, $event, $arguments)
  {
    $tbl = $bean->table_name;
 
    $id = $bean->id;
 
    // calcolo il rimborso 
    $rimborso = $bean->costo_km * $bean->km;
    
    $q = "UPDATE med_rimborso_righe md SET md.rimborso_km =  $rimborso WHERE md.id = '$id'";
    $bean->db->query($q);
  }
}
?>  

The problem is that: the field rimborso_km is not updated..

Why ?

I resolved...

But how to use yhe function handleRedirect ?

[eggsurplus]

Nicely done! Instead of using SQL in your logic hook you should be able to just set the bean attribute:

 <?php
class aggiornaRimborsoHook
{
  // Aggiorno i Rimborsi
  function aggiornaRiga(&$bean, $event, $arguments)
  {
    // calcolo il rimborso 
    $bean->rimborso = $bean->costo_km * $bean->km;  
 
  }
}
?>  

A now that it is set it should save.

[tepepa]

I resolved...

But how to use yhe function handleRedirect ?

Can you please post the solution?
Thank you