function webform_civicrm_civicrm_merge in Webform CiviCRM Integration 7.2

Same name and namespace in other branches

1. 8.5 webform_civicrm.module \webform_civicrm_civicrm_merge()
2. 6.2 webform_civicrm.module \webform_civicrm_civicrm_merge()
3. 6 webform_civicrm.module \webform_civicrm_civicrm_merge()
4. 7.5 webform_civicrm.module \webform_civicrm_civicrm_merge()
5. 7 webform_civicrm.module \webform_civicrm_civicrm_merge()
6. 7.3 webform_civicrm.module \webform_civicrm_civicrm_merge()
7. 7.4 webform_civicrm.module \webform_civicrm_civicrm_merge()

Implements hook_civicrm_merge(). Update submission data to reflect new cids when contacts are merged.

File

./webform_civicrm.module, line 266

Webform CiviCRM Integration Module: Links webform submissions to contacts in a CiviCRM database. @author Coleman Watts

Code

function webform_civicrm_civicrm_merge($type, $data, $new_id = NULL, $old_id = NULL, $tables = NULL) {
  if (!empty($new_id) && !empty($old_id) && $type == 'sqls') {
    db_update('webform_civicrm_submissions')
      ->expression('contact_id', 'REPLACE(contact_id, :old, :new)', array(
      ':old' => '-' . $old_id . '-',
      ':new' => '-' . $new_id . '-',
    ))
      ->condition('contact_id', '%-' . $old_id . '-%', 'LIKE')
      ->execute();
  }
}