CiviCRM Forums
News: You can learn more about CiviCRM from our new free book: Understanding CiviCRM. Also Check the CiviCRM Blog for updated information on CiviCRM
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
September 02, 2010, 08:21:00 am


Login with username, password and session length


Pages: [1]
  Print  
Author Topic: Help with Offline contributions --Please--  (Read 1215 times)
nightlrd
I post occasionally
**

Karma: 0
Offline Offline

CiviCRM: 3.0.1
CMS: Joomla 1.5.14
MySQL: 5.0.81
PHP: 5.2.9

Posts: 61


View Profile
« on: January 04, 2009, 03:48:16 pm »

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  Grin
Logged
Donald Lobo
Administrator
I’m (like) Lobo ;)
*****

Karma: 330
Offline Offline

CiviCRM: 3.2
CMS: Drupal 6.x, Joomla 1.5.x
MySQL: MySQL 5.1.x
PHP: PHP 5.3.x

Posts: 9357



View Profile WWW
« Reply #1 on: January 04, 2009, 05:32:54 pm »


I dont think you can associate an offline contribution to a contribution page via the UI.

Your best bet will be to modify the database directly for such contributions (if not a lot). You could also patch the offline contribution code to collect the contribution page. If you do the latter please publish your code so other folks can use it. If you need help, ping us on IRC

lobo
Logged

Use CiviCRM? Like CiviCRM? Then show your appreciation and make a donation.
vanalive
I post occasionally
**

Karma: 1
Offline Offline

Posts: 35


View Profile
« Reply #2 on: January 07, 2009, 06:30:51 pm »

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";

}
Logged
conductorchris
I post frequently
***

Karma: 7
Offline Offline

CiviCRM: 3.1 beta 6
CMS: Joomla 1.5.15
MySQL: 5.0.82
PHP: 5.2.12

Posts: 140



View Profile WWW
« Reply #3 on: January 08, 2009, 10:00:44 am »

Can you not enter it as an on-line donation, paid by check?  I've got my contribution pages set up that a person can either pay now by credit card or pay later by check. 

I've been busy entering lots of off-line contributions.  But then, I've only got one contribution page right now.
Logged

Thanks to those who help create and enhance civiCRM!
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC

Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM