CiviCRM Community Forums (archive)

Great work Samuel on adding the tokens and Print PDF letter to the Find Contributions page!!!

One question/request: Can you add a token that will list all the contributions from the search in a list?

Currently the way it works is that if I do a letter with the following:

{contact.first_name} {contact.last_name} {contact.contact_id}

ID: {contribution.contribution_id}

receive date: {contribution.receive_date}

source: {contribution.contribution_source}

paid by: {contribution.payment_instrument}

total amt: {contribution.total_amount}

Then each contribution becomes a separate letter. I'd like to be able to do a letter like the following:


Dear {contact.first_name} {contact.last_name},

Thank you for your contributions for the past year. Below is a list of your contributions.

ID..........Date...............Paid by.................Source..............................Amount
100        1/1/12            Check 2020          Donations blah blah         200.00
232        2/2/12             Credit Card          Donation                          100.00
321        3/5/12             Cash                    Donation                          50.00


Is there a way I could do that with a foreach within the letter?

This comes up quite often and is definitely a quite-requested feature

Ideaman, would be great if you can help with the implementation of this

FrTommy's idea, of sending in an "array token" with values for each contribution is probably a good way to go and allows multiple contributions easily. There are a few things that need to be adjustable including the dates / contribution types / contribution status with regard to the below

ping us on irc if u need help getting started. The two modules close to this work are:

http://civicrm.org/blogs/markimus/civicrm-contributions-and-year-end-tax-crunch
http://drupal.org/sandbox/semperit/1289724

lobo
lobo

You can hire someone from here:

http://civicrm.org/what/experts

to do the needful. I'd recommend you get this done as an extension so folks across multiple CMS's can benefit. They can use one of the drupal modules as a starting point

thanx for taking the initiative and helping push it forward

lobo

I'm working on tweaking Hershel's CiviReceipts module. I really suck at SQL.

Here's what i'm trying to do:
SELECT ccontr.id,contact_id,display_name,payment_instrument_id as pid,total_amount,
          DATE_FORMAT(receive_date,'%b %d, %Y') as gift_date
          FROM civicrm_contribution ccontr
          LEFT JOIN civicrm_contact cc ON cc.id = ccontr.contact_id
          WHERE receive_date BETWEEN '2012-09-09 00:00:00' AND '2012-12-31 23:59:59'
          AND contact_id = 4476
 LEFT JOIN civicrm_option_value cov ON cov.value = pid
WHERE cov.option_group_id = 10
ORIGINAL CODE:
"SELECT id,contact_id,display_name,payment_instrument_id as pid,total_amount,
                 DATE_FORMAT(receive_date,'%b %d, %Y') as gift_date
          FROM civicrm_contribution ccontr
          LEFT JOIN civicrm_contact cc ON cc.id = ccontr.contact_id
          LEFT JOIN pid ON civicrm_option_value.value WHERE option_group_id = 10
          WHERE receive_date BETWEEN '$begin_date 00:00:00' AND '$end_date 23:59:59'
          AND contact_id = {$cid}";
Basically, I'm trying to add the fields id, payment_instrument_id (but have it lookup the actual type from the civicrm_option_group table) I can't get the sql right to make that look up. Anyone willing to help me with the sql?