CiviCRM Community Forums (archive)

My use-case requires that printed mailing labels addressed to individuals should use the address of the individual's employer rather than the address attached to the individual contact record. If anyone knows of existing tokens to achieve this, stop reading now and reply with that info.

I wrote a Drupal module and used the token hooks to define a custom token. It shows up in the insert token GUI and I can get it to insert data when my PHP fills $values[$cid]['employer.address'] with a static value (for testing). So all of that is working. However, when I try to get it to work dynamically as intended, using the following code, it does not insert values and the token does not work at all:

<?php
function mtx_crm_civicrm_tokens(&$tokens) {
  $tokens['employer'] = array(
    'employer.address' => 'Employer Address',
  );
}

function mtx_crm_civicrm_tokenValues(&$values, $cids, $job = null, $tokens = array(), $context = null) {
  $contacts = implode(',', $cids);
     $dao = &CRM_Core_DAO::executeQuery("
        SELECT civicrm_contact.id, street_address as employer_address
        FROM civicrm_contact 
        INNER JOIN civicrm_address ON civicrm_contact.employer_id=civicrm_address.contact_id 
        WHERE is_primary=1 AND civicrm_contact.id IN ($contacts)
      ");
     while ($dao->fetch()) {
        $cid = $dao->civicrm_contact.id;
        $values[$cid]['employer.address'] = $dao->employer_address;       
      }

}


I ran the query from the MySQL command prompt and it works as intended. [Note: right now I am just pulling street_address to get going - I realize that later I will need to pull all address fields and format them before inserting into the token.]
Any ideas or tips are greatly appreciated. Thanks!

Thanks Coleman!

I overlooked the shared address feature. This would work better than what I am trying to achieve with my hook.

Questions:

• What is the best way to update 2,000 contacts so that their "Work" address is shared with their Current Employer?
• Since the mailing label creation screen allows you to select from address types (Home, Work, Main, etc.) I assume that tokens work with this. I always used to select "Main" and it worked (all of my addresses are set to "Main"). However, after upgrading to 4.5 I can only use "Primary" - all others result in a blank PDF. Is this a bug?

Thanks for your tip, this is exactly why I said "stop reading now and post with that info"

Link

I did try the query at the MySQL prompt and it returns cid and the employer's street address, so it's good there.

Problem is somewhere in the process of getting data into $values[$cid]['employer.address']

@Coleman RE:

What is the best way to update 2,000 contacts so that their "Work" address is shared with their Current Employer?

There's no easy way that I know of

Found a solid method to mass update all contacts to share "work" address with Current Employer address:

http://forum.civicrm.org/index.php/topic,30353.0.html