CiviCRM Community Forums (archive)

I'm looking for a way to get all contributions w/out a thank-you date and receipt date set.  They also must be completed.  This is the API call I used:
$params = array(
        'rowCount'               => 9999999,
        'contribution_status_id' => 1,
        'receipt_date'           => '', 
        'thankyou_date'          => '', 
        'return.id'              => 1,   
        'return.contact_id'      => 1   
        );     
$contributions = civicrm_contribution_search( $params );


This call, unfortunately returns every single contribution.  Can someone suggest a call/parameter list that will return the query I desire?

Thanks,
--
Keith

The CiviContribute search allows this so it would be interesting to see the API improved to do something similar.  I've created an feature improvement issue here:

http://issues.civicrm.org/jira/browse/CRM-5365

Okay, since I am already knee deep I will take a look at this.  Where can I find how the params are parsed.  I tried looking in the code yesterday but I didn't see anything.  I didn't even see a complete list of what IS and is not supported for the $params array of any API call.

What I am really after is printing thank-you letters to those who don't have a "thank-you" letter date set.  I'm thinking now I might copy the "receipt" printing capability that is currently in place from the contribution search menu.  Using the CiviContribute search I can already search for a thank-you date that "IS NULL."  Once I get my recipients I can generate a PDF, which is what I was going to do anyway.  I think I might generate some templates for a thank-you letter based off of how the print contribution receipts is already working. 

Any complaints?  Comments, suggestions?

I've always had it customizable with a textarea.  My logo, header, etc. was all hard-coded though, but I think I can make that all customizable as well on the same screen. 

My thought is that I will do a search on contributions, then select the contributions to send thank-yous for.  After that, click the drop-down menu and select "Print thank-you letters" (similar to how you can print contribution receipts today).  The "Print thank-you letters" screen will have the textarea and customization settings right there.  Once you fill out the form you can click Preview until you are satisfied with the PDFs and then you can click on save final and it will present your thank-you letters for printing or saving.

For my needs one of the features is that the thank-you date in the contribution is updated to the date that the letters were generated.  This allows me to track which contributions have had a thank-you letter sent or not for the next batch.

Dave,

That is what I had in mind.  It's nice to see other people with the same ideas.  I'll check it out.


Thanks,
--
Keith