Author Topic: Any way to find the interval of a recurring contribution? (Read 1722 times)

molly · April 18, 2008, 07:44:51 am

When viewing a contribution record, it states whether the contribution iss recurring or otherwise, but I don't see any information about the recurrence interval...?

How can I figure out whether a contribution is going to recur once a week or once a year, etc? I could go and look it up at Authorize.net, but I know this information is stored in the civicrm database.

Thanks for your help!
molly

Donald Lobo · April 18, 2008, 01:21:29 pm

I dont think we display this currently, which is probably an oversight. Can you please file an issue and we'll fix this for 2.1/2.2

In the meantime, you will need to goto auth.net or look at the database records directly. The table is civicrm_contribution_recur. You could potentially write a custom page to display this information if you are php/mysql savvy

lobo

petednz · April 22, 2008, 08:53:46 pm

Would this be the same field that could hold 'frequency' about offline recurring payments? We are about to do 'something' to catch this missing data, and would be silly to set up a field to do this if one already exists.

Donald Lobo · April 23, 2008, 02:21:29 am

yeah that record captures all the meta information the user has entered about his/her recurring contribution, some of the fields are:

Code: [Select]

     amount decimal(20,2) NOT NULL   COMMENT 'Amount to be contributed or charged each recurrence.',
     frequency_unit enum('day', 'week', 'month', 'year')   DEFAULT 'month' COMMENT 'Time units for recurrence of payment.',
     frequency_interval int unsigned NOT NULL   COMMENT 'Number of time units for recurrence of payment.',

lobo

lcdweb · December 12, 2008, 12:02:32 pm

I just ran into this issue, needing to expose recurring contrib details on the contrib view page.

Created an issue with patches here:
http://issues.civicrm.org/jira/browse/CRM-3932

To add these values, add the following after line 72 in CRM/Contribute/Form/ContributionView.php

Code: [Select]

		//Recurring details
		if (isset( $values["contribution_recur_id"] ) && $values["contribution_recur_id"] ) {
            $sql = "SELECT installments, frequency_unit FROM civicrm_contribution_recur WHERE id = " . $values["contribution_recur_id"];
            $dao = &new CRM_Core_DAO();
            $dao->query($sql);
            if ( $dao->fetch() ) {
                $values["recur_installments"] = $dao->installments; 
				$values["recur_frequency"] = $dao->frequency_unit;
            } 
        } //recurring end

And modify the total amount line of templates/CRM/Contribute/Form/ContributionView.tpl to the following:

Code: [Select]

        <dt>{ts}Total Amount{/ts}</dt><dd class="bold">{$total_amount|crmMoney}&nbsp;
            {if $contribution_recur_id}
                (Recurring Contribution)<br />
				Installments: {$recur_installments} {$recur_frequency}(s)
            {/if}
        </dd>

-Brian

CiviCRM Community Forums (archive)

News:

Author Topic: Any way to find the interval of a recurring contribution? (Read 1722 times)

molly

Any way to find the interval of a recurring contribution?

Donald Lobo

Re: Any way to find the interval of a recurring contribution?

petednz

Re: Any way to find the interval of a recurring contribution?

Donald Lobo

Re: Any way to find the interval of a recurring contribution?

lcdweb

Re: Any way to find the interval of a recurring contribution?