CiviCRM Community Forums (archive)

I've had a look at the API documentation and can't seem to work out how to implement a hook for Joomla.

Can anyone point me to a reasonably complete example of a Joomla (not Drupal) hook that would allow me to:

1. Use hook_civicrm_post to detect a create or update of an Individual's address in the database;
2. Use data from the new/changed address to execute a SQL query against a MySQL table (worked example of how to use BAO rather than native SQL - I am comfortable with all things SQL and not PHP);
3. Computes new values from the data of 1 and 2;
4. Assigns the calculated values to custom fields.
5. Outlines how to install the hook and test it.

If there are no reasonably compete examples around, then a template hook that does all I want so I can fill in the blanks.

regards
Simon

Hi,

If you are pretty clear about the sql you want to use you might want to try using a mysql trigger - e.g if you look at this extension (which you can easily download, install & modify). As it is an civicrm native extension it should be CMS-agnostic.

https://github.com/eileenmcnaughton/nz.co.fuzion.regionfields

The code is the function

https://github.com/eileenmcnaughton/nz.co.fuzion.regionfields/blob/master/regionfields.php#L85

& the query enacted is

https://github.com/eileenmcnaughton/nz.co.fuzion.regionfields/blob/master/regionfields.php#L97

The trigger simply updates a (hard-coded) custom field based on a lookup in a table that exists in this particular DB. Although I haven't played with it in theory both old & new values are available to you as if they were in the tables aliased in 'old' & 'new'.


The value of doing a trigger this way as opposed to just creating it in your DB is that CiviCRM re-instates it after upgrades etc & integrates it with any other triggers on that table

hmm - have you considered investing your $$ in switching to something like civihosting which provides civi-suitable shared hosting for very reasonable $$$?

My preferred method is to use a trigger BUT the version of MySQL that my client is using does not provide the functionality that I need to implement a trigger. I need MySQL 5.6 or above.

My customer uses CiviHosting.

To clarify this situation, the feature sggreener is looking for is not simple a MySQL trigger. That of course is available in MySQL 5.5, which is what CiviHosting provides as of this writing. sggreener needs what is called a "point in polygon" operation, which is a function required for geospatial calculations. This unique feature is available only in MySQL 5.6+ however.

Thus sggreener must resort to a PHP-based hook so that he can execute PHP or Python code to achieve this functionality.

Anyhow, sggreener, there are examples here:

http://wiki.civicrm.org/confluence/display/CRMDOC42/Example+Joomla+Plugin+for+implementing+hooks
https://civicrm.org/blogs/mcsmom/hooks-and-joomla

and to execute your own SQL, this code works (in Drupal at least):

  require_once "CRM/Core/DAO.php";
  $sql = "SELECT something OR UPDATE something etc.";
  $dao =& CRM_Core_DAO::executeQuery($sql);

That require_once is no longer required in the example