CiviCRM Community Forums (archive)

Hi all,

I am setting up multiple contribution pages with the donation widget included to show how close we are to goal. My question is, how do I enter an offline donation recived via check to associate it with the specific contribution page so it will be messured on the widget? Your help on this is so appreciated and I am sorry if this is an obvious question. Again thanks 

Ugly hack but...

/sites/all/modules/civicrm/CRM/Widget/Widget.php


Either remove this line:
AND    contribution_page_id = %1

Or do what I did and put a conditional clause that removes it only for one contribution page.  It will list all.  I guess you can play around with the mysql query to get your exact results.


if ($contributionPageID != 4)
        {$query = "
SELECT count( id ) as count,
       sum( total_amount) as amount
FROM   civicrm_contribution
WHERE  is_test = 0
AND    contribution_status_id = 1
AND    contribution_page_id = %1";} else {$query = "

SELECT count( id ) as count,
       sum( total_amount) as amount
FROM   civicrm_contribution
WHERE  is_test = 0
AND    contribution_status_id = 1";

}