CiviCRM Community Forums (archive)

hey oliver:

u'll need to do this via the token hook

the main issue will be, what happens when a contact has multiple memberships

lobo

I have been trying to do this with a custom module using token hook, without luck.

I also only need the membership to contact relationship to be singular, so please do post your solution here, if you manage to make Membership details available as Tokens!

Yeah, it's frustrating! I have also tried to write my own SQL calls in a module, but the information don't get passed to the PDF print process.

I have a dream that somebody have at some point made a solution like the one pasted below, using the API of the system to retrieve membership data, or in your case activities data. Specifically I need the membership type and fee of a member, where members will only have a single membership type. I have tried, but just can't find the magical Membership.php file, AND figure out how to write the code which will extract membership name and fee...

This module extracts the address information for a member using the Contact.php and Address.php files of the system:
<?php
function addressblocktoken_civicrm_tokens( &$tokens ) {
    $tokens['contact'] = array( 
        'contact.address_block' => 'Address block' );
}

function addressblocktoken_civicrm_tokenValues( &$values, &$contactIDs ) {
require_once 'api/v2/Contact.php';
require_once 'CRM/Utils/Address.php';
foreach($contactIDs as $id){
$params=array('contact_id'=>$id);
$contact=civicrm_contact_get($params);
$values[$id]['contact.address_block']=nl2br(CRM_Utils_Address::format($contact[$id]));
}
}
?>http://w2.forum.civicrm.org/blogs/michael-mcandrew/creating-address-block-token

resga:

i tried the following on 3.4 and it worked. I just added it to civicrm.module since i was "hacking" on my local sandbox. u'll need to put this in  a seperate module:

function civicrm_civicrm_tokens( &$tokens ) {
    $tokens['membership'] = array( 'membership.membership_type_id', 'membership.start_date' );
}

function civicrm_civicrm_tokenValues( &$values, &$contactIDs ) {
    if ( is_array( $contactIDs ) ) {
        $contactIDString = implode( ',', array_values( $contactIDs ) );
        $single = false;
    } else {
        $contactIDString = "( $contactIDs )";
        $single = true;
    }

    $query = "                                                                                                                             
SELECT contact_id,                                                                                                                         
       membership_type_id,                                                                                                                 
       start_date                                                                                                                           
FROM   civicrm_membership                                                                                                                   
WHERE  contact_id IN ( $contactIDString )                                                                                                   
AND    is_test = 0                                                                                                                         
GROUP BY contact_id                                                                                                                         
";

    $dao = CRM_Core_DAO::executeQuery( $query );
    while ( $dao->fetch( ) ) {
        if ( $single ) {
            $value =& $values;
        } else {
            if ( ! array_key_exists( $dao->contact_id, $values ) ) {
                $values[$dao->contact_id] = array( );
            }
            $value =& $values[$dao->contact_id];
        }

        $value['membership.membership_type_id'] = $dao->membership_type_id;
        $value['membership.start_date'  ] = $dao->start_date;
    }
}

I used the "Source" mode of the html editor to enter the following letter

Dear {contact.first_name}, {contact.last_name}
<p>
Your membership started on {membership.start_date} and is of type {membership.membership_type_id}
<p>
Thanx
<p>
Your friends @ CiviCRM

Hopefully this will get you going. If you find CiviCRM useful, please do contribute to one of the many MIH's for 4.1 or ot the general project:

http://civicrm.org/mih
http://civicrm.org/civicrm/contribute/transact&reset=1&id=19

lobo

I do not mean to hijack this thread and I am very happy to see that resga has developed a solution. It appears that using the hook is not as straightforward when a table does not have contact_id as a field.

The structure of the fmlaLeaveOccurrence table that was created by civi for use in a Case lacks the contact_id field. It does have an entity_id field. From examining the schema, the entity_id is a foreign key related to the activity table id field. The source_contact_id foreign key within the activity table relates to the civicrm_contact.id field.

This means that I cannot simply pull the fields from my fmlaLeaveOccurence table and reference them with the id field from that table, instead I must tie the entity id field back to a contact id.

The dao seems to balk at the idea of using .field parameters so I do not know how to make it play nice with the id fields. I have tried several variations all with no luck.

My module fmla_hooks works properly, but obtaining the correct values for the array values does not.

Is there a proper way to include fields referenced inside of the dao object that use the . parameter? Such as civicrm_activity.source_contact_id

I am new to the dao design pattern and I apologize if this is a silly question.

For testing purposes this is the query that I would like to run with the dao object. It works properly within the mysql console when I replace $contactIDString with a value.

SELECT leave_type_14, request_receieved_15, civicrm_value_fmla_leave_occurence_2.id, civicrm_contact.id as ContactID, civicrm_case.id as Case_ID, display_name, civicrm_case_contact.case_id, civicrm_value_fmla_leave_occurence_2.entity_id, civicrm_activity.id as Activity_ID, civicrm_activity.source_contact_id as ActivitySource
FROM   civicrm_value_fmla_leave_occurence_2, civicrm_contact, civicrm_case, civicrm_case_contact, civicrm_activity
WHERE civicrm_value_fmla_leave_occurence_2.id = civicrm_contact.id
AND
civicrm_value_fmla_leave_occurence_2.entity_id = civicrm_activity.id
AND
civicrm_contact.id IN ($contactIDString)
GROUP BY civicrm_contact.id