CiviCRM Community Forums (archive)

Hi, and thanks for any help on this.

I am sure there are multiple ways of accomplishing the following request, but perhaps someone can suggest a best practice using drupal:

Throughout my drupal site i'd like retrieve from the civcirm DB:

- the total amount contributed
- the total number of contributors (unique)

I plan on using this data in two different ways:
As a block in the sidebar or scattered throughout text in a blog post or basic page (using php as the input filter). The intent of course is to ensure the data is always up to date.

Should I create a function in the template.php file that calls on the civi DB directly?
Use the civi API?
or perhaps there is already a feature that allows me to do this?

Thank you again for your help,

chris

Hi Hershel,

Thank you for your help, I will go that route. Another question related to this:

I noticed that the information I was after is already calculated at top of the "Find Contributions" page (after a search). Where can find the tpl and php pages that make this call? (so i can see how the civi team did it)

Ok, after looking at the source and tracing all the smarty calls I get to a file located at:
CRM/Contribute/Page/ContributionTotals.tpl
that file called these three lines:
   
<th class="contriTotalLeft right">{ts}Total Amount{/ts} - {$contributionSummary.total.amount}</th>
<th class="right"> &nbsp; {ts}# Completed Contributions{/ts} - {$contributionSummary.total.count}</th>
<th class="right contriTotalRight"> &nbsp; {ts}Avg Amount{/ts} - {$contributionSummary.total.avg}</th>

so now I am stuck at trying to figure out where this $contributionSummary object is created. Again, the reason why, I want to see how the CIVI team generated these summary totals so I can use them else where in drupal.

Any idea where this $contributionSummary object was created?

Logical, but I tried that, it's not there. 

Thank you. Hershel and Lobo.