Has anyone successfully used the PHP Events list plugin to update the value of an element/column with a calculated value in the db? (without user interaction on the form).
I have some calculations that I need to make but want those to be made on the db side (before the list is shown).
Here is the plugin docs - but I don't see an example of my use case...but thinking it could be done?
http://fabrikar.com/forums/index.php?wiki/php-events-list-plugin/
Here is the calc element that I am using - I would just want this moved into the event list to save it to the db onload:
I have some calculations that I need to make but want those to be made on the db side (before the list is shown).
Here is the plugin docs - but I don't see an example of my use case...but thinking it could be done?
http://fabrikar.com/forums/index.php?wiki/php-events-list-plugin/
Here is the calc element that I am using - I would just want this moved into the event list to save it to the db onload:
PHP:
//Calc Element Query - Single Return
$cc27 = '{gci_aggregate_2___CATCODE27}';
$db = JFactory::getDbo();
$query = "select `description` from `cgi_annex1_cc27_codes_description` WHERE cc27 = " . $db->quote($cc27);
$db->setQuery($query);
$cc27_desc = $db->loadResult();
return $cc27_desc;