CiviCRM Community Forums (archive)

Ok - In case anyone else wants to have this feature.  Baiscally we wanted to have donations made offline be counted in the totals shown by the widget generated by a contribution page.

Here is how we accomplished this: 

1) define a new contribution type for the fund raising effort where you want both online and offline funds raised.
2) when making the online page choose the new contribution type you just defined in step 1.

The CRM/widget/widget.php file needs the following modification:

/* letapjar: 10/20/2010 added this in to find contribution type to add in non-online donations in the widget totals
* need to find the contribution type id to include it inthe query below
*/
$ctquery = "SELECT DISTINCT contribution_type_id as ct FROM civicrm_contribution_page WHERE id = %1";
$params = array(1 => array($contributionPageID, 'Integer') );
$dao = CRM_Core_DAO::executeQuery($ctquery, $params);
if ($dao->fetch()){
  $contributionTypeID = $dao->ct;
  }
else $contributionTypeID = 0;

 /** letapjar: 10/20/2010
 * modified this query to include the contribution type id in the wehre clause to add up offline donations as well
 */
        $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 OR contribution_type_id = %2)";
        $params = array( 1 => array( $contributionPageID, 'Integer' ), 2 => array($contributionTypeID, 'Integer') ) ;
What this does - is to query the contribution page table to find the contribution type (which should be distinct since you defined a new type when you created the online fundraising page)

then when the widget queries the database to get the donor count and the total donations raised - it chooses all completed donations that are either associated with the online fundraising page OR that have the same contribution type (the new one you defined in step 1).

3) When you have offline donations - enter the new contribution as usual and just choose the same contribution type that you defined in step 1  - all offline contributions will show up in the widget's totals.

Thanks for providing a solution.  I definitely need to allow offline contributions to be counted in the campaign widget.  It seems to me this should be the normal behavior and should be integrated into the base code.  Is there a real reason (use case?) why someone would want to exclude contributions of the same type from other sources?

I also need this. It seems to mejavascript:void(0); that the solution is to provide functionality to set contribution_page_id for each contribution.

I was able to edit contribution_page_id manually in phpmyadmin for a few contributions and it now displays those donations on the widget.

Places where it would be good to be able to set this via the interface:
* import contributions
* contributions search results
* edit contribution

I'd be willing to contribute to this - who else is game?

Cheers,

Tobias