Author Topic: Public View of Top Supporters? (Read 1631 times)

neuromusic · May 30, 2007, 09:52:58 am

I'm not sure where to start, as my php skills are limited.

I'd like to put together a public page which simply lists (1) names and (2) total contribution amounts for all contributors over the past X days which donated more than Y dollars. Can I pull this info through the API or is there already this functionality in another place? Where should I start?

Thanks,
Justin

Dave Greenberg · May 31, 2007, 09:16:53 am

Justin - There are a number of ways to do this. An example using a combination of SQL select and API can be found here:

http://wiki.civicrm.org/confluence/display/CRMDOC/Using+CiviCRM+APIs+-+Code+Snippets#UsingCiviCRMAPIs-CodeSnippets-Displaycumulativegifttotalsindaterange

You'll need to add some PHP to dynamically generate the desired date range for the query.

We have added a contribution search API for the next release - which will allow you to do this in a simpler way. If you want to try it out, you can grab api/v2/Contribute.php from "trunk" in our svn repository.

neuromusic · June 21, 2007, 10:23:48 am

Awesome. I've been distracted by theming issues, but I will let you know how this goes when I take care of it.

Thanks!

CiviCRM Community Forums (archive)

News:

Author Topic: Public View of Top Supporters? (Read 1631 times)

neuromusic

Public View of Top Supporters?

Dave Greenberg

Re: Public View of Top Supporters?

neuromusic

Re: Public View of Top Supporters?