3 +--------------------------------------------------------------------+
4 | Copyright CiviCRM LLC. All rights reserved. |
6 | This work is published under the GNU AGPLv3 license with some |
7 | permitted exceptions and without any warranty. For full license |
8 | and copyright information, see https://civicrm.org/licensing |
9 +--------------------------------------------------------------------+
13 * Class CRM_Contribute_BAO_ContributionRecurTest
16 class CRM_Contribute_BAO_ContributionRecurTest
extends CiviUnitTestCase
{
18 use CRMTraits_Financial_OrderTrait
;
23 * @throws \CRM_Core_Exception
25 public function setUp() {
27 $this->_ids
['payment_processor'] = $this->paymentProcessorCreate();
29 'contact_id' => $this->individualCreate(),
31 'frequency_unit' => 'week',
32 'frequency_interval' => 1,
34 'start_date' => 'yesterday',
35 'create_date' => 'yesterday',
36 'modified_date' => 'yesterday',
37 'cancel_date' => NULL,
38 'end_date' => '+ 2 weeks',
39 'processor_id' => '643411460836',
40 'trxn_id' => 'e0d0808e26f3e661c6c18eb7c039d363',
41 'invoice_id' => 'e0d0808e26f3e661c6c18eb7c039d363',
42 'contribution_status_id' => 1,
45 'next_sched_contribution_date' => '+ 1 week',
47 'failure_retry_date' => NULL,
50 'payment_processor_id' => $this->_ids
['payment_processor'],
51 'is_email_receipt' => 1,
52 'financial_type_id' => 1,
53 'payment_instrument_id' => 1,
54 'campaign_id' => NULL,
61 * @throws \CRM_Core_Exception
63 public function teardown() {
64 $this->quickCleanUpFinancialEntities();
68 * Test that an object can be retrieved & saved (per CRM-14986).
70 * This has been causing a DB error so we are checking for absence of error
72 * @throws \CRM_Core_Exception
74 public function testFindSave() {
75 $contributionRecur = $this->callAPISuccess('contribution_recur', 'create', $this->_params
);
76 $dao = new CRM_Contribute_BAO_ContributionRecur();
77 $dao->id
= $contributionRecur['id'];
79 $dao->is_email_receipt
= 0;
84 * Test cancellation works per CRM-14986.
86 * We are checking for absence of error.
88 * @throws \CRM_Core_Exception
90 public function testCancelRecur() {
91 $contributionRecur = $this->callAPISuccess('contribution_recur', 'create', $this->_params
);
92 CRM_Contribute_BAO_ContributionRecur
::cancelRecurContribution(['id' => $contributionRecur['id']]);
96 * Test checking if contribution recur object can allow for changes to financial types.
98 * @throws \CRM_Core_Exception
100 public function testSupportFinancialTypeChange() {
101 $contributionRecur = $this->callAPISuccess('contribution_recur', 'create', $this->_params
);
102 $this->callAPISuccess('Contribution', 'create', [
103 'contribution_recur_id' => $contributionRecur['id'],
104 'total_amount' => '3.00',
105 'financial_type_id' => 1,
106 'payment_instrument_id' => 1,
108 'contact_id' => $this->individualCreate(),
109 'contribution_status_id' => 1,
110 'receive_date' => 'yesterday',
112 $this->assertTrue(CRM_Contribute_BAO_ContributionRecur
::supportsFinancialTypeChange($contributionRecur['id']));
116 * Test we don't change unintended fields on API edit
118 * @throws \CRM_Core_Exception
120 public function testUpdateRecur() {
121 $createParams = $this->_params
;
122 $createParams['currency'] = 'XAU';
123 $contributionRecur = $this->callAPISuccess('contribution_recur', 'create', $createParams);
125 'id' => $contributionRecur['id'],
126 'end_date' => '+ 4 weeks',
128 $contributionRecur = $this->callAPISuccess('contribution_recur', 'create', $editParams);
129 $dao = new CRM_Contribute_BAO_ContributionRecur();
130 $dao->id
= $contributionRecur['id'];
132 $this->assertEquals('XAU', $dao->currency
, 'Edit clobbered recur currency');
136 * Check test contributions aren't picked up as template for non-test recurs
138 * @throws \API_Exception
139 * @throws \CRM_Core_Exception
140 * @throws \CiviCRM_API3_Exception
141 * @throws \Civi\API\Exception\UnauthorizedException
143 public function testGetTemplateContributionMatchTest1() {
144 $contributionRecur = $this->callAPISuccess('contribution_recur', 'create', $this->_params
);
145 // Create a first contrib
146 $firstContrib = $this->callAPISuccess('Contribution', 'create', [
147 'contribution_recur_id' => $contributionRecur['id'],
148 'total_amount' => '3.00',
149 'financial_type_id' => 1,
150 'payment_instrument_id' => 1,
152 'contact_id' => $this->individualCreate(),
153 'contribution_status_id' => 1,
154 'receive_date' => 'yesterday',
156 // Create a test contrib - should not be picked up as template for non-test recur
157 $this->callAPISuccess('Contribution', 'create', [
158 'contribution_recur_id' => $contributionRecur['id'],
159 'total_amount' => '3.00',
160 'financial_type_id' => 1,
161 'payment_instrument_id' => 1,
163 'contact_id' => $this->individualCreate(),
164 'contribution_status_id' => 1,
165 'receive_date' => 'yesterday',
168 $fetchedTemplate = CRM_Contribute_BAO_ContributionRecur
::getTemplateContribution($contributionRecur['id']);
169 $this->assertEquals($firstContrib['id'], $fetchedTemplate['id']);
173 * Check non-test contributions aren't picked up as template for test recurs
175 * @throws \API_Exception
176 * @throws \CRM_Core_Exception
177 * @throws \CiviCRM_API3_Exception
178 * @throws \Civi\API\Exception\UnauthorizedException
180 public function testGetTemplateContributionMatchTest() {
181 $params = $this->_params
;
182 $params['is_test'] = 1;
183 $contributionRecur = $this->callAPISuccess('contribution_recur', 'create', $params);
184 // Create a first test contrib
185 $firstContrib = $this->callAPISuccess('Contribution', 'create', [
186 'contribution_recur_id' => $contributionRecur['id'],
187 'total_amount' => '3.00',
188 'financial_type_id' => 1,
189 'payment_instrument_id' => 1,
191 'contact_id' => $this->individualCreate(),
192 'contribution_status_id' => 1,
193 'receive_date' => 'yesterday',
196 // Create a non-test contrib - should not be picked up as template for non-test recur
197 // This shouldn't occur - a live contrib against a test recur, but that's not the point...
198 $this->callAPISuccess('Contribution', 'create', [
199 'contribution_recur_id' => $contributionRecur['id'],
200 'total_amount' => '3.00',
201 'financial_type_id' => 1,
202 'payment_instrument_id' => 1,
204 'contact_id' => $this->individualCreate(),
205 'contribution_status_id' => 1,
206 'receive_date' => 'yesterday',
209 $fetchedTemplate = CRM_Contribute_BAO_ContributionRecur
::getTemplateContribution($contributionRecur['id']);
210 $this->assertEquals($firstContrib['id'], $fetchedTemplate['id']);
214 * Test that is_template contribution is used where available
216 * @throws \API_Exception
217 * @throws \CRM_Core_Exception
218 * @throws \CiviCRM_API3_Exception
219 * @throws \Civi\API\Exception\UnauthorizedException
221 public function testGetTemplateContributionNewTemplate() {
222 $contributionRecur = $this->callAPISuccess('contribution_recur', 'create', $this->_params
);
223 // Create the template
224 $templateContrib = $this->callAPISuccess('Contribution', 'create', [
225 'contribution_recur_id' => $contributionRecur['id'],
226 'total_amount' => '3.00',
227 'financial_type_id' => 1,
228 'payment_instrument_id' => 1,
230 'contact_id' => $this->individualCreate(),
231 'contribution_status_id' => 1,
232 'receive_date' => 'yesterday',
235 // Create another normal contrib
236 $this->callAPISuccess('Contribution', 'create', [
237 'contribution_recur_id' => $contributionRecur['id'],
238 'total_amount' => '3.00',
239 'financial_type_id' => 1,
240 'payment_instrument_id' => 1,
242 'contact_id' => $this->individualCreate(),
243 'contribution_status_id' => 1,
244 'receive_date' => 'yesterday',
246 $fetchedTemplate = CRM_Contribute_BAO_ContributionRecur
::getTemplateContribution($contributionRecur['id']);
247 // Fetched template should be the is_template, not the latest contrib
248 $this->assertEquals($fetchedTemplate['id'], $templateContrib['id']);
252 * Test to check if correct membership is auto renewed.
254 * @throws \CRM_Core_Exception
256 public function testAutoRenewalWhenOneMemberIsDeceased() {
257 $contactId1 = $this->individualCreate();
258 $contactId2 = $this->individualCreate();
259 $membershipOrganizationId = $this->organizationCreate();
261 $this->createExtraneousContribution();
262 $this->callAPISuccess('Contribution', 'create', [
263 'contact_id' => $contactId1,
264 'receive_date' => '2010-01-20',
265 'financial_type_id' => 'Member Dues',
266 'contribution_status_id' => 'Completed',
267 'total_amount' => 150,
270 // create membership type
271 $membershipTypeId1 = $this->callAPISuccess('MembershipType', 'create', [
273 'member_of_contact_id' => $membershipOrganizationId,
274 'financial_type_id' => 'Member Dues',
275 'duration_unit' => 'month',
276 'duration_interval' => 1,
277 'period_type' => 'rolling',
278 'minimum_fee' => 100,
282 $membershipTypeID = $this->callAPISuccess('MembershipType', 'create', [
284 'member_of_contact_id' => $membershipOrganizationId,
285 'financial_type_id' => 'Member Dues',
286 'duration_unit' => 'month',
287 'duration_interval' => 1,
288 'period_type' => 'rolling',
294 $contactId1 => $membershipTypeId1,
295 $contactId2 => $membershipTypeID,
298 $contributionRecurId = $this->callAPISuccess('contribution_recur', 'create', $this->_params
)['id'];
300 $priceFields = CRM_Price_BAO_PriceSet
::getDefaultPriceSet('membership');
302 // prepare order api params.
304 'contact_id' => $contactId1,
305 'receive_date' => '2010-01-20',
306 'financial_type_id' => 'Member Dues',
307 'contribution_status_id' => 'Pending',
308 'contribution_recur_id' => $contributionRecurId,
309 'total_amount' => 150,
310 'api.Payment.create' => ['total_amount' => 150],
313 foreach ($priceFields as $priceField) {
315 $contactId = array_search($priceField['membership_type_id'], $contactIDs);
317 'price_field_id' => $priceField['priceFieldID'],
318 'price_field_value_id' => $priceField['priceFieldValueID'],
319 'label' => $priceField['label'],
320 'field_title' => $priceField['label'],
322 'unit_price' => $priceField['amount'],
323 'line_total' => $priceField['amount'],
324 'financial_type_id' => $priceField['financial_type_id'],
325 'entity_table' => 'civicrm_membership',
326 'membership_type_id' => $priceField['membership_type_id'],
328 $params['line_items'][] = [
329 'line_item' => $lineItems,
331 'contact_id' => $contactId,
332 'membership_type_id' => $priceField['membership_type_id'],
333 'source' => 'Payment',
334 'join_date' => '2020-04-28',
335 'start_date' => '2020-04-28',
336 'contribution_recur_id' => $contributionRecurId,
337 'status_id' => 'Pending',
342 $order = $this->callAPISuccess('Order', 'create', $params);
343 $contributionId = $order['id'];
344 $membershipId1 = $this->callAPISuccessGetValue('Membership', [
345 'contact_id' => $contactId1,
346 'membership_type_id' => $membershipTypeId1,
350 $membershipId2 = $this->callAPISuccessGetValue('Membership', [
351 'contact_id' => $contactId2,
352 'membership_type_id' => $membershipTypeID,
356 // First renewal (2nd payment).
357 $this->callAPISuccess('Contribution', 'repeattransaction', [
358 'original_contribution_id' => $contributionId,
359 'contribution_status_id' => 'Completed',
362 // Second Renewal (3rd payment).
363 $this->callAPISuccess('Contribution', 'repeattransaction', [
364 'original_contribution_id' => $contributionId,
365 'contribution_status_id' => 'Completed',
368 // Third renewal (4th payment).
369 $this->callAPISuccess('Contribution', 'repeattransaction', ['original_contribution_id' => $contributionId, 'contribution_status_id' => 'Completed']);
371 // check line item and membership payment count.
372 $this->validateAllCounts($membershipId1, 4);
373 $this->validateAllCounts($membershipId2, 4);
375 // check membership end date.
376 foreach ([$membershipId1, $membershipId2] as $mId) {
377 $endDate = $this->callAPISuccessGetValue('Membership', [
379 'return' => 'end_date',
381 $this->assertEquals($endDate, '2020-08-27', ts('End date incorrect.'));
384 // At this moment Contact 2 is deceased, but we wait until payment is recorded in civi before marking the contact deceased.
385 // At payment Gateway we update the amount from 150 to 100
386 // IPN is recorded for subsequent payment (5th payment).
387 $contribution = $this->callAPISuccess('Contribution', 'repeattransaction', [
388 'original_contribution_id' => $contributionId,
389 'contribution_status_id' => 'Completed',
390 'total_amount' => '100',
393 // now we mark the contact2 as deceased.
394 $this->callAPISuccess('Contact', 'create', [
399 // We delete latest membership payment and line item.
400 $lineItemId = $this->callAPISuccessGetValue('LineItem', [
401 'contribution_id' => $contribution['id'],
402 'entity_id' => $membershipId2,
403 'entity_table' => 'civicrm_membership',
407 // No api to delete membership payment.
408 CRM_Core_DAO
::executeQuery('
409 DELETE FROM civicrm_membership_payment
410 WHERE contribution_id = %1
411 AND membership_id = %2
413 1 => [$contribution['id'], 'Integer'],
414 2 => [$membershipId2, 'Integer'],
417 $this->callAPISuccess('LineItem', 'delete', [
421 // set membership recurring to null.
422 $this->callAPISuccess('Membership', 'create', [
423 'id' => $membershipId2,
424 'contribution_recur_id' => NULL,
427 // check line item and membership payment count.
428 $this->validateAllCounts($membershipId1, 5);
429 $this->validateAllCounts($membershipId2, 4);
431 $checkAgainst = $this->callAPISuccessGetSingle('Membership', [
432 'id' => $membershipId2,
433 'return' => ['end_date', 'status_id'],
436 // record next subsequent payment (6th payment).
437 $this->callAPISuccess('Contribution', 'repeattransaction', [
438 'original_contribution_id' => $contributionId,
439 'contribution_status_id' => 'Completed',
440 'total_amount' => '100',
443 // check membership id 1 is renewed
444 $endDate = $this->callAPISuccessGetValue('Membership', [
445 'id' => $membershipId1,
446 'return' => 'end_date',
448 $this->assertEquals($endDate, '2020-10-27', ts('End date incorrect.'));
449 // check line item and membership payment count.
450 $this->validateAllCounts($membershipId1, 6);
451 $this->validateAllCounts($membershipId2, 4);
453 // check if membership status and end date is not changed.
454 $membership2 = $this->callAPISuccessGetSingle('Membership', [
455 'id' => $membershipId2,
456 'return' => ['end_date', 'status_id'],
458 $this->assertSame($membership2, $checkAgainst);
462 * Check line item and membership payment count.
464 * @param int $membershipId
467 * @throws \CRM_Core_Exception
469 public function validateAllCounts($membershipId, $count) {
471 'membership_id' => $membershipId,
474 'entity_id' => $membershipId,
475 'entity_table' => 'civicrm_membership',
477 $this->callAPISuccessGetCount('LineItem', $lineItemParams, $count);
478 $this->callAPISuccessGetCount('MembershipPayment', $memPayParams, $count);