How to send conditional mail confirmation after completing payment using webform

Question

We have a contribution webform that allows to choose between deferred payment and online payment processor.

We want to send a confirmation mail depending on the payment method choosed. If deferred, mail must contain instructions to complete the payment. If online, mail must contain a thank-you message if the payment is completed satisfactorily.

What is the best approach to achieve this? If we use email webform built in feature, the emails are sent at the time of submiting the form that is good if deferred payment method is choosed but is wrong if online method is choosed because mail is sent before payment process starts instead of when payment is complete.

Answer 1

You could use the CiviRules extension (https://civicrm.org/extensions/civirules) and the E-mail api extension (https://civicrm.org/extensions/e-mail-api).

You could setup a rule which is triggered when a contribution is added and add a condition the payment instrument (and probably also the financial type). You could then add an action which is send e-mail (this action is provided by the e-mail api extension).

Documentation of CiviRules is at: https://docs.civicrm.org/civirules/en/latest

Answer 2

<?php

/**
 * Implementation of hook_civicrm_tokens
 */

function callhooks_civicrm_tokens( &$tokens ) {
  $tokens['contribution'] = array('contribution.last_total_amount', 'contribution.last_receive_date', 'contribution.last_financial_type', 'contribution.last_trxn_id');
}

function callhooks_civicrm_tokenValues( &$values, &$contactIDs, $job = null, $tokens = array(), $context = null) {

    // KG NOTES
    // Example from Lobo: https://civicrm.org/node/480
    if ( is_array( $contactIDs ) ) {
      $contactIDString = implode( ',', array_values( $contactIDs ) );
      $single = false;
    } else {
      $contactIDString = "( $contactIDs )";
      $single = true;
    }

  // Contribution tokens
  $query = "
SELECT id, contact_id, financial_type_id, total_amount, receive_date, trxn_id
FROM   civicrm_contribution
WHERE  contact_id IN ( $contactIDString )
AND    is_test = 0
ORDER BY receive_date DESC LIMIT 1
";

  $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['contribution.last_total_amount'] = $dao->total_amount;
    $value['contribution.last_receive_date'] = $dao->receive_date;
    $value['contribution.last_financial_type'] = $dao->financial_type_id;
    $value['contribution.last_trxn_id'] = $dao->trxn_id;

    $test = 1;
  }
}