Merge pull request #7032 from mlutfy/4.7-crm17432
[civicrm-core.git] / tests / phpunit / api / v3 / ContributionTest.php
1 <?php
2 /*
3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.7 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2015 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
9 | |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
13 | |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
18 | |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
26 */
27
28 require_once 'CiviTest/CiviUnitTestCase.php';
29 require_once 'CiviTest/CiviMailUtils.php';
30
31
32 /**
33 * Test APIv3 civicrm_contribute_* functions
34 *
35 * @package CiviCRM_APIv3
36 * @subpackage API_Contribution
37 */
38 class api_v3_ContributionTest extends CiviUnitTestCase {
39
40 /**
41 * Assume empty database with just civicrm_data.
42 */
43 protected $_individualId;
44 protected $_contribution;
45 protected $_financialTypeId = 1;
46 protected $_apiversion;
47 protected $_entity = 'Contribution';
48 public $debug = 0;
49 protected $_params;
50 protected $_ids = array();
51 protected $_pageParams = array();
52
53 /**
54 * Parameters to create payment processor.
55 *
56 * @var array
57 */
58 protected $_processorParams = array();
59
60 /**
61 * ID of created event.
62 *
63 * @var int
64 */
65 protected $_eventID;
66
67 /**
68 * Setup function.
69 */
70 public function setUp() {
71 parent::setUp();
72
73 $this->_apiversion = 3;
74 $this->_individualId = $this->individualCreate();
75 $this->_params = array(
76 'contact_id' => $this->_individualId,
77 'receive_date' => '20120511',
78 'total_amount' => 100.00,
79 'financial_type_id' => $this->_financialTypeId,
80 'non_deductible_amount' => 10.00,
81 'fee_amount' => 5.00,
82 'net_amount' => 95.00,
83 'source' => 'SSF',
84 'contribution_status_id' => 1,
85 );
86 $this->_processorParams = array(
87 'domain_id' => 1,
88 'name' => 'Dummy',
89 'payment_processor_type_id' => 10,
90 'financial_account_id' => 12,
91 'is_active' => 1,
92 'user_name' => '',
93 'url_site' => 'http://dummy.com',
94 'url_recur' => 'http://dummy.com',
95 'billing_mode' => 1,
96 );
97 $this->_pageParams = array(
98 'title' => 'Test Contribution Page',
99 'financial_type_id' => 1,
100 'currency' => 'USD',
101 'financial_account_id' => 1,
102 'payment_processor' => $this->processorCreate(),
103 'is_active' => 1,
104 'is_allow_other_amount' => 1,
105 'min_amount' => 10,
106 'max_amount' => 1000,
107 );
108 }
109
110 /**
111 * Clean up after each test.
112 */
113 public function tearDown() {
114 $this->quickCleanUpFinancialEntities();
115 $this->quickCleanup(array('civicrm_uf_match'));
116 }
117
118 /**
119 * Test Get.
120 */
121 public function testGetContribution() {
122 $p = array(
123 'contact_id' => $this->_individualId,
124 'receive_date' => '2010-01-20',
125 'total_amount' => 100.00,
126 'financial_type_id' => $this->_financialTypeId,
127 'non_deductible_amount' => 10.00,
128 'fee_amount' => 5.00,
129 'net_amount' => 95.00,
130 'trxn_id' => 23456,
131 'invoice_id' => 78910,
132 'source' => 'SSF',
133 'contribution_status_id' => 1,
134 );
135 $this->_contribution = $this->callAPISuccess('contribution', 'create', $p);
136
137 $params = array(
138 'contribution_id' => $this->_contribution['id'],
139 );
140
141 $contribution = $this->callAPIAndDocument('contribution', 'get', $params, __FUNCTION__, __FILE__);
142 $financialParams['id'] = $this->_financialTypeId;
143 $default = NULL;
144 CRM_Financial_BAO_FinancialType::retrieve($financialParams, $default);
145
146 $this->assertEquals(1, $contribution['count']);
147 $this->assertEquals($contribution['values'][$contribution['id']]['contact_id'], $this->_individualId);
148 // Note there was an assertion converting financial_type_id to 'Donation' which wasn't working.
149 // Passing back a string rather than an id seems like an error/cruft.
150 // If it is to be introduced we should discuss.
151 $this->assertEquals($contribution['values'][$contribution['id']]['financial_type_id'], 1);
152 $this->assertEquals($contribution['values'][$contribution['id']]['total_amount'], 100.00);
153 $this->assertEquals($contribution['values'][$contribution['id']]['non_deductible_amount'], 10.00);
154 $this->assertEquals($contribution['values'][$contribution['id']]['fee_amount'], 5.00);
155 $this->assertEquals($contribution['values'][$contribution['id']]['net_amount'], 95.00);
156 $this->assertEquals($contribution['values'][$contribution['id']]['trxn_id'], 23456);
157 $this->assertEquals($contribution['values'][$contribution['id']]['invoice_id'], 78910);
158 $this->assertEquals($contribution['values'][$contribution['id']]['contribution_source'], 'SSF');
159 $this->assertEquals($contribution['values'][$contribution['id']]['contribution_status'], 'Completed');
160 // Create a second contribution - we are testing that 'id' gets the right contribution id (not the contact id).
161 $p['trxn_id'] = '3847';
162 $p['invoice_id'] = '3847';
163
164 $contribution2 = $this->callAPISuccess('contribution', 'create', $p);
165
166 // Now we have 2 - test getcount.
167 $contribution = $this->callAPISuccess('contribution', 'getcount', array());
168 $this->assertEquals(2, $contribution);
169 // Test id only format.
170 $contribution = $this->callAPISuccess('contribution', 'get', array(
171 'id' => $this->_contribution['id'],
172 'format.only_id' => 1,
173 ));
174 $this->assertEquals($this->_contribution['id'], $contribution, print_r($contribution, TRUE));
175 // Test id only format.
176 $contribution = $this->callAPISuccess('contribution', 'get', array(
177 'id' => $contribution2['id'],
178 'format.only_id' => 1,
179 ));
180 $this->assertEquals($contribution2['id'], $contribution);
181 // Test id as field.
182 $contribution = $this->callAPISuccess('contribution', 'get', array(
183 'id' => $this->_contribution['id'],
184 ));
185 $this->assertEquals(1, $contribution['count']);
186
187 // Test get by contact id works.
188 $contribution = $this->callAPISuccess('contribution', 'get', array('contact_id' => $this->_individualId));
189
190 $this->assertEquals(2, $contribution['count']);
191 $this->callAPISuccess('Contribution', 'Delete', array(
192 'id' => $this->_contribution['id'],
193 ));
194 $this->callAPISuccess('Contribution', 'Delete', array(
195 'id' => $contribution2['id'],
196 ));
197 }
198
199 /**
200 * Test that test contributions can be retrieved.
201 */
202 public function testGetTestContribution() {
203 $this->callAPISuccess('Contribution', 'create', array_merge($this->_params, array('is_test' => 1)));
204 $this->callAPISuccessGetSingle('Contribution', array('is_test' => 1));
205 }
206
207 /**
208 * We need to ensure previous tested behaviour still works as part of the api contract.
209 */
210 public function testGetContributionLegacyBehaviour() {
211 $p = array(
212 'contact_id' => $this->_individualId,
213 'receive_date' => '2010-01-20',
214 'total_amount' => 100.00,
215 'contribution_type_id' => $this->_financialTypeId,
216 'non_deductible_amount' => 10.00,
217 'fee_amount' => 5.00,
218 'net_amount' => 95.00,
219 'trxn_id' => 23456,
220 'invoice_id' => 78910,
221 'source' => 'SSF',
222 'contribution_status_id' => 1,
223 );
224 $this->_contribution = $this->callAPISuccess('Contribution', 'create', $p);
225
226 $params = array(
227 'contribution_id' => $this->_contribution['id'],
228 );
229 $contribution = $this->callAPIAndDocument('contribution', 'get', $params, __FUNCTION__, __FILE__);
230 $financialParams['id'] = $this->_financialTypeId;
231 $default = NULL;
232 CRM_Financial_BAO_FinancialType::retrieve($financialParams, $default);
233
234 $this->assertEquals(1, $contribution['count']);
235 $this->assertEquals($contribution['values'][$contribution['id']]['contact_id'], $this->_individualId);
236 $this->assertEquals($contribution['values'][$contribution['id']]['financial_type_id'], $this->_financialTypeId);
237 $this->assertEquals($contribution['values'][$contribution['id']]['contribution_type_id'], $this->_financialTypeId);
238 $this->assertEquals($contribution['values'][$contribution['id']]['total_amount'], 100.00);
239 $this->assertEquals($contribution['values'][$contribution['id']]['non_deductible_amount'], 10.00);
240 $this->assertEquals($contribution['values'][$contribution['id']]['fee_amount'], 5.00);
241 $this->assertEquals($contribution['values'][$contribution['id']]['net_amount'], 95.00);
242 $this->assertEquals($contribution['values'][$contribution['id']]['trxn_id'], 23456);
243 $this->assertEquals($contribution['values'][$contribution['id']]['invoice_id'], 78910);
244 $this->assertEquals($contribution['values'][$contribution['id']]['contribution_source'], 'SSF');
245 $this->assertEquals($contribution['values'][$contribution['id']]['contribution_status'], 'Completed');
246
247 // Create a second contribution - we are testing that 'id' gets the right contribution id (not the contact id).
248 $p['trxn_id'] = '3847';
249 $p['invoice_id'] = '3847';
250
251 $contribution2 = $this->callAPISuccess('contribution', 'create', $p);
252
253 // now we have 2 - test getcount
254 $contribution = $this->callAPISuccess('contribution', 'getcount', array());
255 $this->assertEquals(2, $contribution);
256 //test id only format
257 $contribution = $this->callAPISuccess('contribution', 'get', array(
258 'id' => $this->_contribution['id'],
259 'format.only_id' => 1,
260 ));
261 $this->assertEquals($this->_contribution['id'], $contribution, print_r($contribution, TRUE));
262 //test id only format
263 $contribution = $this->callAPISuccess('contribution', 'get', array(
264 'id' => $contribution2['id'],
265 'format.only_id' => 1,
266 ));
267 $this->assertEquals($contribution2['id'], $contribution);
268 $contribution = $this->callAPISuccess('contribution', 'get', array(
269 'id' => $this->_contribution['id'],
270 ));
271 //test id as field
272 $this->assertEquals(1, $contribution['count']);
273 // $this->assertEquals($this->_contribution['id'], $contribution['id'] ) ;
274 //test get by contact id works
275 $contribution = $this->callAPISuccess('contribution', 'get', array('contact_id' => $this->_individualId));
276
277 $this->assertEquals(2, $contribution['count']);
278 $this->callAPISuccess('Contribution', 'Delete', array(
279 'id' => $this->_contribution['id'],
280 ));
281 $this->callAPISuccess('Contribution', 'Delete', array(
282 'id' => $contribution2['id'],
283 ));
284 }
285
286 /**
287 * Create an contribution_id=FALSE and financial_type_id=Donation.
288 */
289 public function testCreateEmptyContributionIDUseDonation() {
290 $params = array(
291 'contribution_id' => FALSE,
292 'contact_id' => 1,
293 'total_amount' => 1,
294 'check_permissions' => FALSE,
295 'financial_type_id' => 'Donation',
296 );
297 $this->callAPISuccess('contribution', 'create', $params);
298 }
299
300 /**
301 * Check with complete array + custom field.
302 *
303 * Note that the test is written on purpose without any
304 * variables specific to participant so it can be replicated into other entities
305 * and / or moved to the automated test suite
306 */
307 public function testCreateWithCustom() {
308 $ids = $this->entityCustomGroupWithSingleFieldCreate(__FUNCTION__, __FILE__);
309
310 $params = $this->_params;
311 $params['custom_' . $ids['custom_field_id']] = "custom string";
312
313 $result = $this->callAPIAndDocument($this->_entity, 'create', $params, __FUNCTION__, __FILE__);
314 $this->assertEquals($result['id'], $result['values'][$result['id']]['id']);
315 $check = $this->callAPISuccess($this->_entity, 'get', array(
316 'return.custom_' . $ids['custom_field_id'] => 1,
317 'id' => $result['id'],
318 ));
319 $this->customFieldDelete($ids['custom_field_id']);
320 $this->customGroupDelete($ids['custom_group_id']);
321 $this->assertEquals("custom string", $check['values'][$check['id']]['custom_' . $ids['custom_field_id']]);
322 }
323
324 /**
325 * Check with complete array + custom field.
326 *
327 * Note that the test is written on purpose without any
328 * variables specific to participant so it can be replicated into other entities
329 * and / or moved to the automated test suite
330 */
331 public function testCreateGetFieldsWithCustom() {
332 $ids = $this->entityCustomGroupWithSingleFieldCreate(__FUNCTION__, __FILE__);
333 $idsContact = $this->entityCustomGroupWithSingleFieldCreate(__FUNCTION__, 'ContactTest.php');
334 $result = $this->callAPISuccess('Contribution', 'getfields', array());
335 $this->assertArrayHasKey('custom_' . $ids['custom_field_id'], $result['values']);
336 $this->assertArrayNotHasKey('custom_' . $idsContact['custom_field_id'], $result['values']);
337 $this->customFieldDelete($ids['custom_field_id']);
338 $this->customGroupDelete($ids['custom_group_id']);
339 $this->customFieldDelete($idsContact['custom_field_id']);
340 $this->customGroupDelete($idsContact['custom_group_id']);
341 }
342
343 public function testCreateContributionNoLineItems() {
344
345 $params = array(
346 'contact_id' => $this->_individualId,
347 'receive_date' => '20120511',
348 'total_amount' => 100.00,
349 'financial_type_id' => $this->_financialTypeId,
350 'payment_instrument_id' => 1,
351 'non_deductible_amount' => 10.00,
352 'fee_amount' => 50.00,
353 'net_amount' => 90.00,
354 'trxn_id' => 12345,
355 'invoice_id' => 67890,
356 'source' => 'SSF',
357 'contribution_status_id' => 1,
358 'skipLineItem' => 1,
359 );
360
361 $contribution = $this->callAPISuccess('contribution', 'create', $params);
362 $lineItems = $this->callAPISuccess('line_item', 'get', array(
363 'entity_id' => $contribution['id'],
364 'entity_table' => 'civicrm_contribution',
365 'sequential' => 1,
366 ));
367 $this->assertEquals(0, $lineItems['count']);
368 }
369
370 /**
371 * Test checks that passing in line items suppresses the create mechanism.
372 */
373 public function testCreateContributionChainedLineItems() {
374 $params = array(
375 'contact_id' => $this->_individualId,
376 'receive_date' => '20120511',
377 'total_amount' => 100.00,
378 'financial_type_id' => $this->_financialTypeId,
379 'payment_instrument_id' => 1,
380 'non_deductible_amount' => 10.00,
381 'fee_amount' => 50.00,
382 'net_amount' => 90.00,
383 'trxn_id' => 12345,
384 'invoice_id' => 67890,
385 'source' => 'SSF',
386 'contribution_status_id' => 1,
387 'skipLineItem' => 1,
388 'api.line_item.create' => array(
389 array(
390 'price_field_id' => 1,
391 'qty' => 2,
392 'line_total' => '20',
393 'unit_price' => '10',
394 ),
395 array(
396 'price_field_id' => 1,
397 'qty' => 1,
398 'line_total' => '80',
399 'unit_price' => '80',
400 ),
401 ),
402 );
403
404 $description = "Create Contribution with Nested Line Items.";
405 $subfile = "CreateWithNestedLineItems";
406 $contribution = $this->callAPIAndDocument('contribution', 'create', $params, __FUNCTION__, __FILE__, $description, $subfile);
407
408 $lineItems = $this->callAPISuccess('line_item', 'get', array(
409 'entity_id' => $contribution['id'],
410 'contribution_id' => $contribution['id'],
411 'entity_table' => 'civicrm_contribution',
412 'sequential' => 1,
413 ));
414 $this->assertEquals(2, $lineItems['count']);
415 }
416
417 public function testCreateContributionOffline() {
418 $params = array(
419 'contact_id' => $this->_individualId,
420 'receive_date' => '20120511',
421 'total_amount' => 100.00,
422 'financial_type_id' => 1,
423 'trxn_id' => 12345,
424 'invoice_id' => 67890,
425 'source' => 'SSF',
426 'contribution_status_id' => 1,
427 );
428
429 $contribution = $this->callAPIAndDocument('contribution', 'create', $params, __FUNCTION__, __FILE__);
430 $this->assertEquals($contribution['values'][$contribution['id']]['contact_id'], $this->_individualId);
431 $this->assertEquals($contribution['values'][$contribution['id']]['total_amount'], 100.00);
432 $this->assertEquals($contribution['values'][$contribution['id']]['financial_type_id'], 1);
433 $this->assertEquals($contribution['values'][$contribution['id']]['trxn_id'], 12345);
434 $this->assertEquals($contribution['values'][$contribution['id']]['invoice_id'], 67890);
435 $this->assertEquals($contribution['values'][$contribution['id']]['source'], 'SSF');
436 $this->assertEquals($contribution['values'][$contribution['id']]['contribution_status_id'], 1);
437 $lineItems = $this->callAPISuccess('line_item', 'get', array(
438 'entity_id' => $contribution['id'],
439 'contribution_id' => $contribution['id'],
440 'entity_table' => 'civicrm_contribution',
441 'sequential' => 1,
442 ));
443 $this->assertEquals(1, $lineItems['count']);
444 $this->assertEquals($contribution['id'], $lineItems['values'][0]['entity_id']);
445 $this->assertEquals($contribution['id'], $lineItems['values'][0]['contribution_id']);
446 $this->_checkFinancialRecords($contribution, 'offline');
447 $this->contributionGetnCheck($params, $contribution['id']);
448 }
449
450 /**
451 * Test create with valid payment instrument.
452 */
453 public function testCreateContributionWithPaymentInstrument() {
454 $params = $this->_params + array('payment_instrument' => 'EFT');
455 $contribution = $this->callAPISuccess('contribution', 'create', $params);
456 $contribution = $this->callAPISuccess('contribution', 'get', array(
457 'sequential' => 1,
458 'id' => $contribution['id'],
459 ));
460 $this->assertArrayHasKey('payment_instrument', $contribution['values'][0]);
461 $this->assertEquals('EFT', $contribution['values'][0]['payment_instrument']);
462
463 $this->callAPISuccess('contribution', 'create', array(
464 'id' => $contribution['id'],
465 'payment_instrument' => 'Credit Card',
466 ));
467 $contribution = $this->callAPISuccess('contribution', 'get', array(
468 'sequential' => 1,
469 'id' => $contribution['id'],
470 ));
471 $this->assertArrayHasKey('payment_instrument', $contribution['values'][0]);
472 $this->assertEquals('Credit Card', $contribution['values'][0]['payment_instrument']);
473 }
474
475 public function testGetContributionByPaymentInstrument() {
476 $params = $this->_params + array('payment_instrument' => 'EFT');
477 $params2 = $this->_params + array('payment_instrument' => 'Cash');
478 $this->callAPISuccess('contribution', 'create', $params);
479 $this->callAPISuccess('contribution', 'create', $params2);
480 $contribution = $this->callAPISuccess('contribution', 'get', array(
481 'sequential' => 1,
482 'contribution_payment_instrument' => 'Cash',
483 ));
484 $this->assertArrayHasKey('payment_instrument', $contribution['values'][0]);
485 $this->assertEquals('Cash', $contribution['values'][0]['payment_instrument']);
486 $this->assertEquals(1, $contribution['count']);
487 $contribution = $this->callAPISuccess('contribution', 'get', array('sequential' => 1, 'payment_instrument' => 'Cash'));
488 $this->assertArrayHasKey('payment_instrument', $contribution['values'][0]);
489 $this->assertEquals('Cash', $contribution['values'][0]['payment_instrument']);
490 $this->assertEquals(1, $contribution['count']);
491 $contribution = $this->callAPISuccess('contribution', 'get', array(
492 'sequential' => 1,
493 'payment_instrument_id' => 5,
494 ));
495 $this->assertArrayHasKey('payment_instrument', $contribution['values'][0]);
496 $this->assertEquals('EFT', $contribution['values'][0]['payment_instrument']);
497 $this->assertEquals(1, $contribution['count']);
498 $contribution = $this->callAPISuccess('contribution', 'get', array(
499 'sequential' => 1,
500 'payment_instrument' => 'EFT',
501 ));
502 $this->assertArrayHasKey('payment_instrument', $contribution['values'][0]);
503 $this->assertEquals('EFT', $contribution['values'][0]['payment_instrument']);
504 $this->assertEquals(1, $contribution['count']);
505 $contribution = $this->callAPISuccess('contribution', 'create', array(
506 'id' => $contribution['id'],
507 'payment_instrument' => 'Credit Card',
508 ));
509 $contribution = $this->callAPISuccess('contribution', 'get', array('sequential' => 1, 'id' => $contribution['id']));
510 $this->assertArrayHasKey('payment_instrument', $contribution['values'][0]);
511 $this->assertEquals('Credit Card', $contribution['values'][0]['payment_instrument']);
512 $this->assertEquals(1, $contribution['count']);
513 }
514
515 /**
516 * CRM-16227 introduces invoice_id as a parameter.
517 */
518 public function testGetContributionByInvoice() {
519 $this->callAPISuccess('Contribution', 'create', array_merge($this->_params, array('invoice_id' => 'curly')));
520 $this->callAPISuccess('Contribution', 'create', array_merge($this->_params), array('invoice_id' => 'churlish'));
521 $this->callAPISuccessGetCount('Contribution', array(), 2);
522 $this->callAPISuccessGetSingle('Contribution', array('invoice_id' => 'curly'));
523 // The following don't work. They are the format we are trying to introduce but although the form uses this format
524 // CRM_Contact_BAO_Query::convertFormValues puts them into the other format & the where only supports that.
525 // ideally the where clause would support this format (as it does on contact_BAO_Query) and those lines would
526 // come out of convertFormValues
527 // $this->callAPISuccessGetSingle('Contribution', array('invoice_id' => array('LIKE' => '%ish%')));
528 // $this->callAPISuccessGetSingle('Contribution', array('invoice_id' => array('NOT IN' => array('curly'))));
529 // $this->callAPISuccessGetCount('Contribution', array('invoice_id' => array('LIKE' => '%ly%')), 2);
530 // $this->callAPISuccessGetCount('Contribution', array('invoice_id' => array('IN' => array('curly', 'churlish'))),
531 // 2);
532 }
533
534 /**
535 * Create test with unique field name on source.
536 */
537 public function testCreateContributionSource() {
538
539 $params = array(
540 'contact_id' => $this->_individualId,
541 'receive_date' => date('Ymd'),
542 'total_amount' => 100.00,
543 'financial_type_id' => $this->_financialTypeId,
544 'payment_instrument_id' => 1,
545 'non_deductible_amount' => 10.00,
546 'fee_amount' => 50.00,
547 'net_amount' => 90.00,
548 'trxn_id' => 12345,
549 'invoice_id' => 67890,
550 'contribution_source' => 'SSF',
551 'contribution_status_id' => 1,
552 );
553
554 $contribution = $this->callAPISuccess('contribution', 'create', $params);
555 $this->assertEquals($contribution['values'][$contribution['id']]['total_amount'], 100.00);
556 $this->assertEquals($contribution['values'][$contribution['id']]['source'], 'SSF');
557 }
558
559 /**
560 * Create test with unique field name on source.
561 */
562 public function testCreateDefaultNow() {
563
564 $params = $this->_params;
565 unset($params['receive_date']);
566
567 $contribution = $this->callAPISuccess('contribution', 'create', $params);
568 $contribution = $this->callAPISuccessGetSingle('contribution', array('id' => $contribution['id']));
569 $this->assertEquals(date('Y-m-d'), date('Y-m-d', strtotime($contribution['receive_date'])));
570 }
571
572 /**
573 * Create test with unique field name on source.
574 */
575 public function testCreateContributionSourceInvalidContact() {
576
577 $params = array(
578 'contact_id' => 999,
579 'receive_date' => date('Ymd'),
580 'total_amount' => 100.00,
581 'financial_type_id' => $this->_financialTypeId,
582 'payment_instrument_id' => 1,
583 'non_deductible_amount' => 10.00,
584 'fee_amount' => 50.00,
585 'net_amount' => 90.00,
586 'trxn_id' => 12345,
587 'invoice_id' => 67890,
588 'contribution_source' => 'SSF',
589 'contribution_status_id' => 1,
590 );
591
592 $this->callAPIFailure('contribution', 'create', $params, 'contact_id is not valid : 999');
593 }
594
595 public function testCreateContributionSourceInvalidContContact() {
596
597 $params = array(
598 'contribution_contact_id' => 999,
599 'receive_date' => date('Ymd'),
600 'total_amount' => 100.00,
601 'financial_type_id' => $this->_financialTypeId,
602 'payment_instrument_id' => 1,
603 'non_deductible_amount' => 10.00,
604 'fee_amount' => 50.00,
605 'net_amount' => 90.00,
606 'trxn_id' => 12345,
607 'invoice_id' => 67890,
608 'contribution_source' => 'SSF',
609 'contribution_status_id' => 1,
610 );
611
612 $this->callAPIFailure('contribution', 'create', $params, 'contact_id is not valid : 999');
613 }
614
615 /**
616 * Test note created correctly.
617 */
618 public function testCreateContributionWithNote() {
619 $description = "Demonstrates creating contribution with Note Entity.";
620 $subfile = "ContributionCreateWithNote";
621 $params = array(
622 'contact_id' => $this->_individualId,
623 'receive_date' => '2012-01-01',
624 'total_amount' => 100.00,
625 'financial_type_id' => $this->_financialTypeId,
626 'payment_instrument_id' => 1,
627 'non_deductible_amount' => 10.00,
628 'fee_amount' => 50.00,
629 'net_amount' => 90.00,
630 'trxn_id' => 12345,
631 'invoice_id' => 67890,
632 'source' => 'SSF',
633 'contribution_status_id' => 1,
634 'note' => 'my contribution note',
635 );
636
637 $contribution = $this->callAPIAndDocument('contribution', 'create', $params, __FUNCTION__, __FILE__, $description, $subfile);
638 $result = $this->callAPISuccess('note', 'get', array(
639 'entity_table' => 'civicrm_contribution',
640 'entity_id' => $contribution['id'],
641 'sequential' => 1,
642 ));
643 $this->assertEquals('my contribution note', $result['values'][0]['note']);
644 $this->callAPISuccess('contribution', 'delete', array('id' => $contribution['id']));
645 }
646
647 public function testCreateContributionWithNoteUniqueNameAliases() {
648 $params = array(
649 'contact_id' => $this->_individualId,
650 'receive_date' => '2012-01-01',
651 'total_amount' => 100.00,
652 'financial_type_id' => $this->_financialTypeId,
653 'payment_instrument_id' => 1,
654 'non_deductible_amount' => 10.00,
655 'fee_amount' => 50.00,
656 'net_amount' => 90.00,
657 'trxn_id' => 12345,
658 'invoice_id' => 67890,
659 'source' => 'SSF',
660 'contribution_status_id' => 1,
661 'contribution_note' => 'my contribution note',
662 );
663
664 $contribution = $this->callAPISuccess('contribution', 'create', $params);
665 $result = $this->callAPISuccess('note', 'get', array(
666 'entity_table' => 'civicrm_contribution',
667 'entity_id' => $contribution['id'],
668 'sequential' => 1,
669 ));
670 $this->assertEquals('my contribution note', $result['values'][0]['note']);
671 $this->callAPISuccess('contribution', 'delete', array('id' => $contribution['id']));
672 }
673
674 /**
675 * This is the test for creating soft credits.
676 */
677 public function testCreateContributionWithSoftCredit() {
678 $description = "Demonstrates creating contribution with SoftCredit.";
679 $subfile = "ContributionCreateWithSoftCredit";
680 $contact2 = $this->callAPISuccess('Contact', 'create', array(
681 'display_name' => 'superman',
682 'contact_type' => 'Individual',
683 ));
684 $softParams = array(
685 'contact_id' => $contact2['id'],
686 'amount' => 50,
687 'soft_credit_type_id' => 3,
688 );
689
690 $params = $this->_params + array('soft_credit' => array(1 => $softParams));
691 $contribution = $this->callAPIAndDocument('contribution', 'create', $params, __FUNCTION__, __FILE__, $description, $subfile);
692 $result = $this->callAPISuccess('contribution', 'get', array('return' => 'soft_credit', 'sequential' => 1));
693
694 $this->assertEquals($softParams['contact_id'], $result['values'][0]['soft_credit'][1]['contact_id']);
695 $this->assertEquals($softParams['amount'], $result['values'][0]['soft_credit'][1]['amount']);
696 $this->assertEquals($softParams['soft_credit_type_id'], $result['values'][0]['soft_credit'][1]['soft_credit_type']);
697
698 $this->callAPISuccess('contribution', 'delete', array('id' => $contribution['id']));
699 $this->callAPISuccess('contact', 'delete', array('id' => $contact2['id']));
700 }
701
702 public function testCreateContributionWithSoftCreditDefaults() {
703 $description = "Demonstrates creating contribution with Soft Credit defaults for amount and type.";
704 $subfile = "ContributionCreateWithSoftCreditDefaults";
705 $contact2 = $this->callAPISuccess('Contact', 'create', array(
706 'display_name' => 'superman',
707 'contact_type' => 'Individual',
708 ));
709 $params = $this->_params + array(
710 'soft_credit_to' => $contact2['id'],
711 );
712 $contribution = $this->callAPIAndDocument('contribution', 'create', $params, __FUNCTION__, __FILE__, $description, $subfile);
713 $result = $this->callAPISuccess('contribution', 'get', array('return' => 'soft_credit', 'sequential' => 1));
714
715 $this->assertEquals($contact2['id'], $result['values'][0]['soft_credit'][1]['contact_id']);
716 // Default soft credit amount = contribution.total_amount
717 $this->assertEquals($this->_params['total_amount'], $result['values'][0]['soft_credit'][1]['amount']);
718 $this->assertEquals(CRM_Core_OptionGroup::getDefaultValue("soft_credit_type"), $result['values'][0]['soft_credit'][1]['soft_credit_type']);
719
720 $this->callAPISuccess('contribution', 'delete', array('id' => $contribution['id']));
721 $this->callAPISuccess('contact', 'delete', array('id' => $contact2['id']));
722 }
723
724 public function testCreateContributionWithHonoreeContact() {
725 $description = "Demonstrates creating contribution with Soft Credit by passing in honor_contact_id.";
726 $subfile = "ContributionCreateWithHonoreeContact";
727 $contact2 = $this->callAPISuccess('Contact', 'create', array(
728 'display_name' => 'superman',
729 'contact_type' => 'Individual',
730 ));
731 $params = $this->_params + array(
732 'honor_contact_id' => $contact2['id'],
733 );
734 $contribution = $this->callAPIAndDocument('contribution', 'create', $params, __FUNCTION__, __FILE__, $description, $subfile);
735 $result = $this->callAPISuccess('contribution', 'get', array('return' => 'soft_credit', 'sequential' => 1));
736
737 $this->assertEquals($contact2['id'], $result['values'][0]['soft_credit'][1]['contact_id']);
738 // Default soft credit amount = contribution.total_amount
739 // Legacy mode in create api (honor_contact_id param) uses the standard "In Honor of" soft credit type
740 $this->assertEquals($this->_params['total_amount'], $result['values'][0]['soft_credit'][1]['amount']);
741 $this->assertEquals(CRM_Core_OptionGroup::getValue('soft_credit_type', 'in_honor_of', 'name'), $result['values'][0]['soft_credit'][1]['soft_credit_type']);
742
743 $this->callAPISuccess('contribution', 'delete', array('id' => $contribution['id']));
744 $this->callAPISuccess('contact', 'delete', array('id' => $contact2['id']));
745 }
746
747 /**
748 * Test using example code.
749 */
750 public function testContributionCreateExample() {
751 //make sure at least on page exists since there is a truncate in tear down
752 $this->callAPISuccess('contribution_page', 'create', $this->_pageParams);
753 require_once 'api/v3/examples/Contribution/Create.php';
754 $result = contribution_create_example();
755 $id = $result['id'];
756 $expectedResult = contribution_create_expectedresult();
757 $this->checkArrayEquals($expectedResult, $result);
758 $this->contributionDelete($id);
759 }
760
761 /**
762 * Function tests that additional financial records are created when fee amount is recorded.
763 */
764 public function testCreateContributionWithFee() {
765 $params = array(
766 'contact_id' => $this->_individualId,
767 'receive_date' => '20120511',
768 'total_amount' => 100.00,
769 'fee_amount' => 50,
770 'financial_type_id' => 1,
771 'trxn_id' => 12345,
772 'invoice_id' => 67890,
773 'source' => 'SSF',
774 'contribution_status_id' => 1,
775 );
776
777 $contribution = $this->callAPIAndDocument('contribution', 'create', $params, __FUNCTION__, __FILE__);
778 $this->assertEquals($contribution['values'][$contribution['id']]['contact_id'], $this->_individualId);
779 $this->assertEquals($contribution['values'][$contribution['id']]['total_amount'], 100.00);
780 $this->assertEquals($contribution['values'][$contribution['id']]['fee_amount'], 50.00);
781 $this->assertEquals($contribution['values'][$contribution['id']]['net_amount'], 50.00);
782 $this->assertEquals($contribution['values'][$contribution['id']]['financial_type_id'], 1);
783 $this->assertEquals($contribution['values'][$contribution['id']]['trxn_id'], 12345);
784 $this->assertEquals($contribution['values'][$contribution['id']]['invoice_id'], 67890);
785 $this->assertEquals($contribution['values'][$contribution['id']]['source'], 'SSF');
786 $this->assertEquals($contribution['values'][$contribution['id']]['contribution_status_id'], 1);
787
788 $lineItems = $this->callAPISuccess('line_item', 'get', array(
789
790 'entity_id' => $contribution['id'],
791 'entity_table' => 'civicrm_contribution',
792 'sequential' => 1,
793 ));
794 $this->assertEquals(1, $lineItems['count']);
795 $this->assertEquals($contribution['id'], $lineItems['values'][0]['entity_id']);
796 $this->assertEquals($contribution['id'], $lineItems['values'][0]['contribution_id']);
797 $lineItems = $this->callAPISuccess('line_item', 'get', array(
798
799 'entity_id' => $contribution['id'],
800 'contribution_id' => $contribution['id'],
801 'entity_table' => 'civicrm_contribution',
802 'sequential' => 1,
803 ));
804 $this->assertEquals(1, $lineItems['count']);
805 $this->_checkFinancialRecords($contribution, 'feeAmount');
806 }
807
808
809 /**
810 * Function tests that additional financial records are created when online contribution is created.
811 */
812 public function testCreateContributionOnline() {
813 CRM_Financial_BAO_PaymentProcessor::create($this->_processorParams);
814 $contributionPage = $this->callAPISuccess('contribution_page', 'create', $this->_pageParams);
815 $this->assertAPISuccess($contributionPage);
816 $params = array(
817 'contact_id' => $this->_individualId,
818 'receive_date' => '20120511',
819 'total_amount' => 100.00,
820 'financial_type_id' => 1,
821 'contribution_page_id' => $contributionPage['id'],
822 'payment_processor' => 1,
823 'trxn_id' => 12345,
824 'invoice_id' => 67890,
825 'source' => 'SSF',
826 'contribution_status_id' => 1,
827
828 );
829
830 $contribution = $this->callAPIAndDocument('contribution', 'create', $params, __FUNCTION__, __FILE__);
831 $this->assertEquals($contribution['values'][$contribution['id']]['contact_id'], $this->_individualId);
832 $this->assertEquals($contribution['values'][$contribution['id']]['total_amount'], 100.00);
833 $this->assertEquals($contribution['values'][$contribution['id']]['financial_type_id'], 1);
834 $this->assertEquals($contribution['values'][$contribution['id']]['trxn_id'], 12345);
835 $this->assertEquals($contribution['values'][$contribution['id']]['invoice_id'], 67890);
836 $this->assertEquals($contribution['values'][$contribution['id']]['source'], 'SSF');
837 $this->assertEquals($contribution['values'][$contribution['id']]['contribution_status_id'], 1);
838 $this->_checkFinancialRecords($contribution, 'online');
839 }
840
841 /**
842 * Check handling of financial type.
843 *
844 * In the interests of removing financial type / contribution type checks from
845 * legacy format function lets test that the api is doing this for us
846 */
847 public function testCreateInvalidFinancialType() {
848 $params = $this->_params;
849 $params['financial_type_id'] = 99999;
850 $this->callAPIFailure($this->_entity, 'create', $params, "'99999' is not a valid option for field financial_type_id");
851 }
852
853 /**
854 * Check handling of financial type.
855 *
856 * In the interests of removing financial type / contribution type checks from
857 * legacy format function lets test that the api is doing this for us
858 */
859 public function testValidNamedFinancialType() {
860 $params = $this->_params;
861 $params['financial_type_id'] = 'Donation';
862 $this->callAPISuccess($this->_entity, 'create', $params);
863 }
864
865 /**
866 * Tests that additional financial records are created.
867 *
868 * Checks when online contribution with pay later option is created
869 */
870 public function testCreateContributionPayLaterOnline() {
871 CRM_Financial_BAO_PaymentProcessor::create($this->_processorParams);
872 $this->_pageParams['is_pay_later'] = 1;
873 $contributionPage = $this->callAPISuccess('contribution_page', 'create', $this->_pageParams);
874 $this->assertAPISuccess($contributionPage);
875 $params = array(
876 'contact_id' => $this->_individualId,
877 'receive_date' => '20120511',
878 'total_amount' => 100.00,
879 'financial_type_id' => 1,
880 'contribution_page_id' => $contributionPage['id'],
881 'trxn_id' => 12345,
882 'is_pay_later' => 1,
883 'invoice_id' => 67890,
884 'source' => 'SSF',
885 'contribution_status_id' => 2,
886
887 );
888
889 $contribution = $this->callAPIAndDocument('contribution', 'create', $params, __FUNCTION__, __FILE__);
890 $this->assertEquals($contribution['values'][$contribution['id']]['contact_id'], $this->_individualId);
891 $this->assertEquals($contribution['values'][$contribution['id']]['total_amount'], 100.00);
892 $this->assertEquals($contribution['values'][$contribution['id']]['financial_type_id'], 1);
893 $this->assertEquals($contribution['values'][$contribution['id']]['trxn_id'], 12345);
894 $this->assertEquals($contribution['values'][$contribution['id']]['invoice_id'], 67890);
895 $this->assertEquals($contribution['values'][$contribution['id']]['source'], 'SSF');
896 $this->assertEquals($contribution['values'][$contribution['id']]['contribution_status_id'], 2);
897 $this->_checkFinancialRecords($contribution, 'payLater');
898 }
899
900 /**
901 * Function tests that additional financial records are created for online contribution with pending option.
902 */
903 public function testCreateContributionPendingOnline() {
904 $paymentProcessor = CRM_Financial_BAO_PaymentProcessor::create($this->_processorParams);
905 $contributionPage = $this->callAPISuccess('contribution_page', 'create', $this->_pageParams);
906 $this->assertAPISuccess($contributionPage);
907 $params = array(
908 'contact_id' => $this->_individualId,
909 'receive_date' => '20120511',
910 'total_amount' => 100.00,
911 'financial_type_id' => 1,
912 'contribution_page_id' => $contributionPage['id'],
913 'trxn_id' => 12345,
914 'invoice_id' => 67890,
915 'source' => 'SSF',
916 'contribution_status_id' => 2,
917 );
918
919 $contribution = $this->callAPIAndDocument('contribution', 'create', $params, __FUNCTION__, __FILE__);
920 $this->assertEquals($contribution['values'][$contribution['id']]['contact_id'], $this->_individualId);
921 $this->assertEquals($contribution['values'][$contribution['id']]['total_amount'], 100.00);
922 $this->assertEquals($contribution['values'][$contribution['id']]['financial_type_id'], 1);
923 $this->assertEquals($contribution['values'][$contribution['id']]['trxn_id'], 12345);
924 $this->assertEquals($contribution['values'][$contribution['id']]['invoice_id'], 67890);
925 $this->assertEquals($contribution['values'][$contribution['id']]['source'], 'SSF');
926 $this->assertEquals($contribution['values'][$contribution['id']]['contribution_status_id'], 2);
927 $this->_checkFinancialRecords($contribution, 'pending');
928 }
929
930 /**
931 * Test that BAO defaults work.
932 */
933 public function testCreateBAODefaults() {
934 unset($this->_params['contribution_source_id'], $this->_params['payment_instrument_id']);
935 $contribution = $this->callAPISuccess('contribution', 'create', $this->_params);
936 $contribution = $this->callAPISuccess('contribution', 'getsingle', array(
937 'id' => $contribution['id'],
938 'api.contribution.delete' => 1,
939 ));
940 $this->assertEquals(1, $contribution['contribution_status_id']);
941 $this->assertEquals('Check', $contribution['payment_instrument']);
942 }
943
944 /**
945 * Function tests that line items, financial records are updated when contribution amount is changed.
946 */
947 public function testCreateUpdateContributionChangeTotal() {
948 $contribution = $this->callAPISuccess('contribution', 'create', $this->_params);
949 $lineItems = $this->callAPISuccess('line_item', 'getvalue', array(
950
951 'entity_id' => $contribution['id'],
952 'entity_table' => 'civicrm_contribution',
953 'sequential' => 1,
954 'return' => 'line_total',
955 ));
956 $this->assertEquals('100.00', $lineItems);
957 $trxnAmount = $this->_getFinancialTrxnAmount($contribution['id']);
958 // Financial trxn SUM = 100 + 5 (fee)
959 $this->assertEquals('105.00', $trxnAmount);
960 $newParams = array(
961
962 'id' => $contribution['id'],
963 'total_amount' => '125',
964 );
965 $contribution = $this->callAPISuccess('contribution', 'create', $newParams);
966
967 $lineItems = $this->callAPISuccess('line_item', 'getvalue', array(
968
969 'entity_id' => $contribution['id'],
970 'entity_table' => 'civicrm_contribution',
971 'sequential' => 1,
972 'return' => 'line_total',
973 ));
974
975 $this->assertEquals('125.00', $lineItems);
976 $trxnAmount = $this->_getFinancialTrxnAmount($contribution['id']);
977
978 // Financial trxn SUM = 125 + 5 (fee).
979 $this->assertEquals('130.00', $trxnAmount);
980 $this->assertEquals('125.00', $this->_getFinancialItemAmount($contribution['id']));
981 }
982
983 /**
984 * Function tests that line items, financial records are updated when pay later contribution is received.
985 */
986 public function testCreateUpdateContributionPayLater() {
987 $contribParams = array(
988 'contact_id' => $this->_individualId,
989 'receive_date' => '2012-01-01',
990 'total_amount' => 100.00,
991 'financial_type_id' => $this->_financialTypeId,
992 'payment_instrument_id' => 1,
993 'contribution_status_id' => 2,
994 'is_pay_later' => 1,
995
996 );
997 $contribution = $this->callAPISuccess('contribution', 'create', $contribParams);
998
999 $newParams = array_merge($contribParams, array(
1000 'id' => $contribution['id'],
1001 'contribution_status_id' => 1,
1002 )
1003 );
1004 $contribution = $this->callAPISuccess('contribution', 'create', $newParams);
1005 $contribution = $contribution['values'][$contribution['id']];
1006 $this->assertEquals($contribution['contribution_status_id'], '1');
1007 $this->_checkFinancialItem($contribution['id'], 'paylater');
1008 $this->_checkFinancialTrxn($contribution, 'payLater');
1009 }
1010
1011 /**
1012 * Function tests that financial records are updated when Payment Instrument is changed.
1013 */
1014 public function testCreateUpdateContributionPaymentInstrument() {
1015 $instrumentId = $this->_addPaymentInstrument();
1016 $contribParams = array(
1017 'contact_id' => $this->_individualId,
1018 'total_amount' => 100.00,
1019 'financial_type_id' => $this->_financialTypeId,
1020 'payment_instrument_id' => 4,
1021 'contribution_status_id' => 1,
1022
1023 );
1024 $contribution = $this->callAPISuccess('contribution', 'create', $contribParams);
1025
1026 $newParams = array_merge($contribParams, array(
1027 'id' => $contribution['id'],
1028 'payment_instrument_id' => $instrumentId,
1029 )
1030 );
1031 $contribution = $this->callAPISuccess('contribution', 'create', $newParams);
1032 $this->assertAPISuccess($contribution);
1033 $this->_checkFinancialTrxn($contribution, 'paymentInstrument', $instrumentId);
1034 }
1035
1036 /**
1037 * Function tests that financial records are added when Contribution is Refunded.
1038 */
1039 public function testCreateUpdateContributionRefund() {
1040 $contribParams = array(
1041 'contact_id' => $this->_individualId,
1042 'receive_date' => '2012-01-01',
1043 'total_amount' => 100.00,
1044 'financial_type_id' => $this->_financialTypeId,
1045 'payment_instrument_id' => 4,
1046 'contribution_status_id' => 1,
1047
1048 );
1049 $contribution = $this->callAPISuccess('contribution', 'create', $contribParams);
1050 $newParams = array_merge($contribParams, array(
1051 'id' => $contribution['id'],
1052 'contribution_status_id' => 7,
1053 )
1054 );
1055
1056 $contribution = $this->callAPISuccess('contribution', 'create', $newParams);
1057 $this->_checkFinancialTrxn($contribution, 'refund');
1058 $this->_checkFinancialItem($contribution['id'], 'refund');
1059 }
1060
1061 /**
1062 * Function tests invalid contribution status change.
1063 */
1064 public function testCreateUpdateContributionInValidStatusChange() {
1065 $contribParams = array(
1066 'contact_id' => 1,
1067 'receive_date' => '2012-01-01',
1068 'total_amount' => 100.00,
1069 'financial_type_id' => 1,
1070 'payment_instrument_id' => 1,
1071 'contribution_status_id' => 1,
1072 );
1073 $contribution = $this->callAPISuccess('contribution', 'create', $contribParams);
1074 $newParams = array_merge($contribParams, array(
1075 'id' => $contribution['id'],
1076 'contribution_status_id' => 2,
1077 )
1078 );
1079 $this->callAPIFailure('contribution', 'create', $newParams, ts('Cannot change contribution status from Completed to Pending.'));
1080
1081 }
1082
1083 /**
1084 * Function tests that financial records are added when Pending Contribution is Canceled.
1085 */
1086 public function testCreateUpdateContributionCancelPending() {
1087 $contribParams = array(
1088 'contact_id' => $this->_individualId,
1089 'receive_date' => '2012-01-01',
1090 'total_amount' => 100.00,
1091 'financial_type_id' => $this->_financialTypeId,
1092 'payment_instrument_id' => 1,
1093 'contribution_status_id' => 2,
1094 'is_pay_later' => 1,
1095
1096 );
1097 $contribution = $this->callAPISuccess('contribution', 'create', $contribParams);
1098 $newParams = array_merge($contribParams, array(
1099 'id' => $contribution['id'],
1100 'contribution_status_id' => 3,
1101 )
1102 );
1103 $contribution = $this->callAPISuccess('contribution', 'create', $newParams);
1104 $this->_checkFinancialTrxn($contribution, 'cancelPending');
1105 $this->_checkFinancialItem($contribution['id'], 'cancelPending');
1106 }
1107
1108 /**
1109 * Function tests that financial records are added when Financial Type is Changed.
1110 */
1111 public function testCreateUpdateContributionChangeFinancialType() {
1112 $contribParams = array(
1113 'contact_id' => $this->_individualId,
1114 'receive_date' => '2012-01-01',
1115 'total_amount' => 100.00,
1116 'financial_type_id' => 1,
1117 'payment_instrument_id' => 1,
1118 'contribution_status_id' => 1,
1119
1120 );
1121 $contribution = $this->callAPISuccess('contribution', 'create', $contribParams);
1122 $newParams = array_merge($contribParams, array(
1123 'id' => $contribution['id'],
1124 'financial_type_id' => 3,
1125 )
1126 );
1127 $contribution = $this->callAPISuccess('contribution', 'create', $newParams);
1128 $this->_checkFinancialTrxn($contribution, 'changeFinancial');
1129 $this->_checkFinancialItem($contribution['id'], 'changeFinancial');
1130 }
1131
1132 /**
1133 * Test that update does not change status id CRM-15105.
1134 */
1135 public function testCreateUpdateWithoutChangingPendingStatus() {
1136 $contribution = $this->callAPISuccess('contribution', 'create', array_merge($this->_params, array('contribution_status_id' => 2)));
1137 $this->callAPISuccess('contribution', 'create', array('id' => $contribution['id'], 'source' => 'new source'));
1138 $contribution = $this->callAPISuccess('contribution', 'getsingle', array(
1139 'id' => $contribution['id'],
1140 'api.contribution.delete' => 1,
1141 ));
1142 $this->assertEquals(2, $contribution['contribution_status_id']);
1143 }
1144
1145 /**
1146 * Test Updating a Contribution.
1147 *
1148 * CHANGE: we require the API to do an incremental update
1149 */
1150 public function testCreateUpdateContribution() {
1151
1152 $contributionID = $this->contributionCreate(array(
1153 'contact_id' => $this->_individualId,
1154 'trxn_id' => 212355,
1155 'financial_type_id' => $this->_financialTypeId,
1156 'invoice_id' => 'old_invoice',
1157 ));
1158 $old_params = array(
1159 'contribution_id' => $contributionID,
1160 );
1161 $original = $this->callAPISuccess('contribution', 'get', $old_params);
1162 $this->assertEquals($original['id'], $contributionID);
1163 //set up list of old params, verify
1164
1165 //This should not be required on update:
1166 $old_contact_id = $original['values'][$contributionID]['contact_id'];
1167 $old_payment_instrument = $original['values'][$contributionID]['instrument_id'];
1168 $old_fee_amount = $original['values'][$contributionID]['fee_amount'];
1169 $old_source = $original['values'][$contributionID]['contribution_source'];
1170
1171 $old_trxn_id = $original['values'][$contributionID]['trxn_id'];
1172 $old_invoice_id = $original['values'][$contributionID]['invoice_id'];
1173
1174 //check against values in CiviUnitTestCase::createContribution()
1175 $this->assertEquals($old_contact_id, $this->_individualId);
1176 $this->assertEquals($old_fee_amount, 5.00);
1177 $this->assertEquals($old_source, 'SSF');
1178 $this->assertEquals($old_trxn_id, 212355);
1179 $this->assertEquals($old_invoice_id, 'old_invoice');
1180 $params = array(
1181 'id' => $contributionID,
1182 'contact_id' => $this->_individualId,
1183 'total_amount' => 110.00,
1184 'financial_type_id' => $this->_financialTypeId,
1185 'non_deductible_amount' => 10.00,
1186 'net_amount' => 100.00,
1187 'contribution_status_id' => 1,
1188 'note' => 'Donating for Nobel Cause',
1189
1190 );
1191
1192 $contribution = $this->callAPISuccess('contribution', 'create', $params);
1193
1194 $new_params = array(
1195 'contribution_id' => $contribution['id'],
1196
1197 );
1198 $contribution = $this->callAPISuccess('contribution', 'get', $new_params);
1199
1200 $this->assertEquals($contribution['values'][$contributionID]['contact_id'], $this->_individualId);
1201 $this->assertEquals($contribution['values'][$contributionID]['total_amount'], 110.00);
1202 $this->assertEquals($contribution['values'][$contributionID]['financial_type_id'], $this->_financialTypeId);
1203 $this->assertEquals($contribution['values'][$contributionID]['instrument_id'], $old_payment_instrument);
1204 $this->assertEquals($contribution['values'][$contributionID]['non_deductible_amount'], 10.00);
1205 $this->assertEquals($contribution['values'][$contributionID]['fee_amount'], $old_fee_amount);
1206 $this->assertEquals($contribution['values'][$contributionID]['net_amount'], 100.00);
1207 $this->assertEquals($contribution['values'][$contributionID]['trxn_id'], $old_trxn_id);
1208 $this->assertEquals($contribution['values'][$contributionID]['invoice_id'], $old_invoice_id);
1209 $this->assertEquals($contribution['values'][$contributionID]['contribution_source'], $old_source);
1210 $this->assertEquals($contribution['values'][$contributionID]['contribution_status'], 'Completed');
1211 $params = array(
1212 'contribution_id' => $contributionID,
1213
1214 );
1215 $result = $this->callAPISuccess('contribution', 'delete', $params);
1216 $this->assertAPISuccess($result);
1217 }
1218
1219 ///////////////// civicrm_contribution_delete methods
1220
1221 /**
1222 * Attempt (but fail) to delete a contribution without parameters.
1223 */
1224 public function testDeleteEmptyParamsContribution() {
1225 $params = array();
1226 $this->callAPIFailure('contribution', 'delete', $params);
1227 }
1228
1229 public function testDeleteParamsNotArrayContribution() {
1230 $params = 'contribution_id= 1';
1231 $contribution = $this->callAPIFailure('contribution', 'delete', $params);
1232 $this->assertEquals($contribution['error_message'], 'Input variable `params` is not an array');
1233 }
1234
1235 public function testDeleteWrongParamContribution() {
1236 $params = array(
1237 'contribution_source' => 'SSF',
1238
1239 );
1240 $this->callAPIFailure('contribution', 'delete', $params);
1241 }
1242
1243 public function testDeleteContribution() {
1244 $contributionID = $this->contributionCreate(array(
1245 'contact_id' => $this->_individualId,
1246 'financial_type_id' => $this->_financialTypeId,
1247 ));
1248 $params = array(
1249 'id' => $contributionID,
1250 );
1251 $this->callAPIAndDocument('contribution', 'delete', $params, __FUNCTION__, __FILE__);
1252 }
1253
1254 /**
1255 * Test civicrm_contribution_search with empty params.
1256 *
1257 * All available contributions expected.
1258 */
1259 public function testSearchEmptyParams() {
1260 $params = array();
1261
1262 $p = array(
1263 'contact_id' => $this->_individualId,
1264 'receive_date' => date('Ymd'),
1265 'total_amount' => 100.00,
1266 'financial_type_id' => $this->_financialTypeId,
1267 'non_deductible_amount' => 10.00,
1268 'fee_amount' => 5.00,
1269 'net_amount' => 95.00,
1270 'trxn_id' => 23456,
1271 'invoice_id' => 78910,
1272 'source' => 'SSF',
1273 'contribution_status_id' => 1,
1274
1275 );
1276 $contribution = $this->callAPISuccess('contribution', 'create', $p);
1277
1278 $result = $this->callAPISuccess('contribution', 'get', $params);
1279 // We're taking the first element.
1280 $res = $result['values'][$contribution['id']];
1281
1282 $this->assertEquals($p['contact_id'], $res['contact_id']);
1283 $this->assertEquals($p['total_amount'], $res['total_amount']);
1284 $this->assertEquals($p['financial_type_id'], $res['financial_type_id']);
1285 $this->assertEquals($p['net_amount'], $res['net_amount']);
1286 $this->assertEquals($p['non_deductible_amount'], $res['non_deductible_amount']);
1287 $this->assertEquals($p['fee_amount'], $res['fee_amount']);
1288 $this->assertEquals($p['trxn_id'], $res['trxn_id']);
1289 $this->assertEquals($p['invoice_id'], $res['invoice_id']);
1290 $this->assertEquals($p['source'], $res['contribution_source']);
1291 // contribution_status_id = 1 => Completed
1292 $this->assertEquals('Completed', $res['contribution_status']);
1293
1294 $this->contributionDelete($contribution['id']);
1295 }
1296
1297 /**
1298 * Test civicrm_contribution_search. Success expected.
1299 */
1300 public function testSearch() {
1301 $p1 = array(
1302 'contact_id' => $this->_individualId,
1303 'receive_date' => date('Ymd'),
1304 'total_amount' => 100.00,
1305 'financial_type_id' => $this->_financialTypeId,
1306 'non_deductible_amount' => 10.00,
1307 'contribution_status_id' => 1,
1308
1309 );
1310 $contribution1 = $this->callAPISuccess('contribution', 'create', $p1);
1311
1312 $p2 = array(
1313 'contact_id' => $this->_individualId,
1314 'receive_date' => date('Ymd'),
1315 'total_amount' => 200.00,
1316 'financial_type_id' => $this->_financialTypeId,
1317 'non_deductible_amount' => 20.00,
1318 'trxn_id' => 5454565,
1319 'invoice_id' => 1212124,
1320 'fee_amount' => 50.00,
1321 'net_amount' => 60.00,
1322 'contribution_status_id' => 2,
1323
1324 );
1325 $contribution2 = $this->callAPISuccess('contribution', 'create', $p2);
1326
1327 $params = array(
1328 'contribution_id' => $contribution2['id'],
1329
1330 );
1331 $result = $this->callAPISuccess('contribution', 'get', $params);
1332 $res = $result['values'][$contribution2['id']];
1333
1334 $this->assertEquals($p2['contact_id'], $res['contact_id']);
1335 $this->assertEquals($p2['total_amount'], $res['total_amount']);
1336 $this->assertEquals($p2['financial_type_id'], $res['financial_type_id']);
1337 $this->assertEquals($p2['net_amount'], $res['net_amount']);
1338 $this->assertEquals($p2['non_deductible_amount'], $res['non_deductible_amount']);
1339 $this->assertEquals($p2['fee_amount'], $res['fee_amount']);
1340 $this->assertEquals($p2['trxn_id'], $res['trxn_id']);
1341 $this->assertEquals($p2['invoice_id'], $res['invoice_id']);
1342 // contribution_status_id = 2 => Pending
1343 $this->assertEquals('Pending', $res['contribution_status']);
1344
1345 $this->contributionDelete($contribution1['id']);
1346 $this->contributionDelete($contribution2['id']);
1347 }
1348
1349 /**
1350 * Test completing a transaction via the API.
1351 *
1352 * Note that we are creating a logged in user because email goes out from
1353 * that person
1354 */
1355 public function testCompleteTransaction() {
1356 $mut = new CiviMailUtils($this, TRUE);
1357 $this->createLoggedInUser();
1358 $params = array_merge($this->_params, array('contribution_status_id' => 2));
1359 $contribution = $this->callAPISuccess('contribution', 'create', $params);
1360 $this->callAPISuccess('contribution', 'completetransaction', array(
1361 'id' => $contribution['id'],
1362 ));
1363 $contribution = $this->callAPISuccess('contribution', 'get', array('id' => $contribution['id'], 'sequential' => 1));
1364 $this->assertEquals('Completed', $contribution['values'][0]['contribution_status']);
1365 $mut->checkMailLog(array(
1366 'Receipt - Contribution',
1367 'Please print this confirmation for your records.',
1368 ));
1369 $mut->stop();
1370 }
1371
1372 /**
1373 * Test completing a transaction via the API.
1374 *
1375 * Note that we are creating a logged in user because email goes out from
1376 * that person
1377 */
1378 public function testCompleteTransactionFeeAmount() {
1379 $this->createLoggedInUser();
1380 $params = array_merge($this->_params, array('contribution_status_id' => 2));
1381 $contribution = $this->callAPISuccess('contribution', 'create', $params);
1382 $this->callAPISuccess('contribution', 'completetransaction', array(
1383 'id' => $contribution['id'],
1384 'fee_amount' => '.56',
1385 'trxn_id' => '7778888',
1386 ));
1387 $contribution = $this->callAPISuccess('contribution', 'getsingle', array('id' => $contribution['id'], 'sequential' => 1));
1388 $this->assertEquals('Completed', $contribution['contribution_status']);
1389 $this->assertEquals('7778888', $contribution['trxn_id']);
1390 $this->assertEquals('.56', $contribution['fee_amount']);
1391 $this->assertEquals('99.44', $contribution['net_amount']);
1392 }
1393
1394 /**
1395 * Test repeat contribution successfully creates line items.
1396 */
1397 public function testRepeatTransaction() {
1398 $paymentProcessorID = $this->paymentProcessorCreate();
1399 $contributionRecur = $this->callAPISuccess('contribution_recur', 'create', array(
1400 'contact_id' => $this->_individualId,
1401 'installments' => '12',
1402 'frequency_interval' => '1',
1403 'amount' => '500',
1404 'contribution_status_id' => 1,
1405 'start_date' => '2012-01-01 00:00:00',
1406 'currency' => 'USD',
1407 'frequency_unit' => 'month',
1408 'payment_processor_id' => $paymentProcessorID,
1409 ));
1410 $originalContribution = $this->callAPISuccess('contribution', 'create', array_merge(
1411 $this->_params,
1412 array('contribution_recur_id' => $contributionRecur['id']))
1413 );
1414
1415 $this->callAPISuccess('contribution', 'repeattransaction', array(
1416 'original_contribution_id' => $originalContribution['id'],
1417 'contribution_status_id' => 'Completed',
1418 'trxn_id' => uniqid(),
1419 ));
1420 $lineItemParams = array(
1421 'entity_id' => $originalContribution['id'],
1422 'sequential' => 1,
1423 'return' => array(
1424 'entity_table',
1425 'qty',
1426 'unit_price',
1427 'line_total',
1428 'label',
1429 'financial_type_id',
1430 'deductible_amount',
1431 'price_field_value_id',
1432 'price_field_id',
1433 ),
1434 );
1435 $lineItem1 = $this->callAPISuccess('line_item', 'get', array_merge($lineItemParams, array(
1436 'entity_id' => $originalContribution['id'],
1437 )));
1438 $lineItem2 = $this->callAPISuccess('line_item', 'get', array_merge($lineItemParams, array(
1439 'entity_id' => $originalContribution['id'] + 1,
1440 )));
1441 unset($lineItem1['values'][0]['id'], $lineItem1['values'][0]['entity_id']);
1442 unset($lineItem2['values'][0]['id'], $lineItem2['values'][0]['entity_id']);
1443 $this->assertEquals($lineItem1['values'][0], $lineItem2['values'][0]);
1444
1445 $this->quickCleanUpFinancialEntities();
1446 }
1447
1448 /**
1449 * CRM-16397 test appropriate action if total amount has changed for single line items.
1450 */
1451 public function testRepeatTransactionAlteredAmount() {
1452 $paymentProcessorID = $this->paymentProcessorCreate();
1453 $campaignID = $this->campaignCreate();
1454 $campaignID2 = $this->campaignCreate();
1455 $contributionRecur = $this->callAPISuccess('contribution_recur', 'create', array(
1456 'contact_id' => $this->_individualId,
1457 'installments' => '12',
1458 'frequency_interval' => '1',
1459 'amount' => '500',
1460 'contribution_status_id' => 1,
1461 'start_date' => '2012-01-01 00:00:00',
1462 'currency' => 'USD',
1463 'frequency_unit' => 'month',
1464 'payment_processor_id' => $paymentProcessorID,
1465 ));
1466 $originalContribution = $this->callAPISuccess('contribution', 'create', array_merge(
1467 $this->_params,
1468 array(
1469 'contribution_recur_id' => $contributionRecur['id'],
1470 'campaign_id' => $campaignID,
1471 ))
1472 );
1473
1474 $this->callAPISuccess('contribution', 'repeattransaction', array(
1475 'original_contribution_id' => $originalContribution['id'],
1476 'contribution_status_id' => 'Completed',
1477 'trxn_id' => uniqid(),
1478 'total_amount' => '400',
1479 'fee_amount' => 50,
1480 'campaign_id' => $campaignID2,
1481 ));
1482 $lineItemParams = array(
1483 'entity_id' => $originalContribution['id'],
1484 'sequential' => 1,
1485 'return' => array(
1486 'entity_table',
1487 'qty',
1488 'unit_price',
1489 'line_total',
1490 'label',
1491 'financial_type_id',
1492 'deductible_amount',
1493 'price_field_value_id',
1494 'price_field_id',
1495 ),
1496 );
1497 $this->callAPISuccessGetSingle('contribution', array(
1498 'total_amount' => 400,
1499 'campaign_id' => $campaignID2,
1500 'fee_amount' => 50,
1501 'net_amount' => 350,
1502 ));
1503 $lineItem1 = $this->callAPISuccess('line_item', 'get', array_merge($lineItemParams, array(
1504 'entity_id' => $originalContribution['id'],
1505 )));
1506 $expectedLineItem = array_merge(
1507 $lineItem1['values'][0], array(
1508 'line_total' => '400.00',
1509 'unit_price' => '400.00',
1510 )
1511 );
1512
1513 $lineItem2 = $this->callAPISuccess('line_item', 'get', array_merge($lineItemParams, array(
1514 'entity_id' => $originalContribution['id'] + 1,
1515 )));
1516 unset($expectedLineItem['id'], $expectedLineItem['entity_id']);
1517 unset($lineItem2['values'][0]['id'], $lineItem2['values'][0]['entity_id']);
1518 $this->assertEquals($expectedLineItem, $lineItem2['values'][0]);
1519
1520 $this->quickCleanUpFinancialEntities();
1521 }
1522
1523 /**
1524 * Test completing a transaction does not 'mess' with net amount (CRM-15960).
1525 */
1526 public function testCompleteTransactionNetAmountOK() {
1527 $this->createLoggedInUser();
1528 $params = array_merge($this->_params, array('contribution_status_id' => 2));
1529 unset($params['net_amount']);
1530 $contribution = $this->callAPISuccess('contribution', 'create', $params);
1531 $this->callAPISuccess('contribution', 'completetransaction', array(
1532 'id' => $contribution['id'],
1533 ));
1534 $contribution = $this->callAPISuccess('contribution', 'getsingle', array('id' => $contribution['id']));
1535 $this->assertEquals('Completed', $contribution['contribution_status']);
1536 $this->assertTrue(($contribution['total_amount'] - $contribution['net_amount']) == $contribution['fee_amount']);
1537 }
1538
1539 /**
1540 * CRM-14151 - Test completing a transaction via the API.
1541 */
1542 public function testCompleteTransactionWithReceiptDateSet() {
1543 $mut = new CiviMailUtils($this, TRUE);
1544 $this->createLoggedInUser();
1545 $params = array_merge($this->_params, array('contribution_status_id' => 2, 'receipt_date' => 'now'));
1546 $contribution = $this->callAPISuccess('contribution', 'create', $params);
1547 $this->callAPISuccess('contribution', 'completetransaction', array('id' => $contribution['id'], 'trxn_date' => date('Y-m-d')));
1548 $contribution = $this->callAPISuccess('contribution', 'get', array('id' => $contribution['id'], 'sequential' => 1));
1549 $this->assertEquals('Completed', $contribution['values'][0]['contribution_status']);
1550 $this->assertEquals(date('Y-m-d'), date('Y-m-d', strtotime($contribution['values'][0]['receive_date'])));
1551 $mut->checkMailLog(array(
1552 'Receipt - Contribution',
1553 'Please print this confirmation for your records.',
1554 ));
1555 $mut->stop();
1556 }
1557
1558 /**
1559 * Test completing a transaction with an event via the API.
1560 *
1561 * Note that we are creating a logged in user because email goes out from
1562 * that person
1563 */
1564 public function testCompleteTransactionWithParticipantRecord() {
1565 $mut = new CiviMailUtils($this, TRUE);
1566 $mut->clearMessages();
1567 $this->createLoggedInUser();
1568 $contributionID = $this->createPendingParticipantContribution();
1569 $this->callAPISuccess('contribution', 'completetransaction', array(
1570 'id' => $contributionID,
1571 )
1572 );
1573 $participantStatus = $this->callAPISuccessGetValue('participant', array(
1574 'id' => $this->_ids['participant'],
1575 'return' => 'participant_status_id',
1576 ));
1577 $this->assertEquals(1, $participantStatus);
1578 $mut->checkMailLog(array(
1579 'Annual CiviCRM meet',
1580 'Event',
1581 'This letter is a confirmation that your registration has been received and your status has been updated to Registered.',
1582 ));
1583 $mut->stop();
1584 }
1585
1586 /**
1587 * Test membership is renewed when transaction completed.
1588 */
1589 public function testCompleteTransactionMembershipPriceSet() {
1590 $this->createPriceSetWithPage('membership');
1591 $stateOfGrace = $this->callAPISuccess('MembershipStatus', 'getvalue', array(
1592 'name' => 'Grace',
1593 'return' => 'id')
1594 );
1595 $this->setUpPendingContribution($this->_ids['price_field_value'][0]);
1596 $membership = $this->callAPISuccess('membership', 'getsingle', array('id' => $this->_ids['membership']));
1597 $logs = $this->callAPISuccess('MembershipLog', 'get', array(
1598 'membership_id' => $this->_ids['membership'],
1599 ));
1600 $this->assertEquals(1, $logs['count']);
1601 $this->assertEquals($stateOfGrace, $membership['status_id']);
1602 $this->callAPISuccess('contribution', 'completetransaction', array('id' => $this->_ids['contribution']));
1603 $membership = $this->callAPISuccess('membership', 'getsingle', array('id' => $this->_ids['membership']));
1604 $this->assertEquals(date('Y-m-d', strtotime('yesterday + 1 year')), $membership['end_date']);
1605 $this->callAPISuccessGetSingle('LineItem', array(
1606 'entity_id' => $this->_ids['membership'],
1607 'entity_table' => 'civicrm_membership',
1608 ));
1609 $logs = $this->callAPISuccess('MembershipLog', 'get', array(
1610 'membership_id' => $this->_ids['membership'],
1611 ));
1612 $this->assertEquals(2, $logs['count']);
1613 $this->assertNotEquals($stateOfGrace, $logs['values'][2]['status_id']);
1614 $this->cleanUpAfterPriceSets();
1615 }
1616
1617 /**
1618 * Test membership is renewed when transaction completed.
1619 */
1620 public function testCompleteTransactionMembershipPriceSetTwoTerms() {
1621 $this->createPriceSetWithPage('membership');
1622 $this->setUpPendingContribution($this->_ids['price_field_value'][1]);
1623 $this->callAPISuccess('contribution', 'completetransaction', array('id' => $this->_ids['contribution']));
1624 $membership = $this->callAPISuccess('membership', 'getsingle', array('id' => $this->_ids['membership']));
1625 $this->assertEquals(date('Y-m-d', strtotime('yesterday + 2 years')), $membership['end_date']);
1626 $this->cleanUpAfterPriceSets();
1627 }
1628
1629 public function cleanUpAfterPriceSets() {
1630 $this->quickCleanUpFinancialEntities();
1631 $this->contactDelete($this->_ids['contact']);
1632 }
1633
1634
1635 /**
1636 * Create price set with contribution test for test setup.
1637 *
1638 * This could be merged with 4.5 function setup in api_v3_ContributionPageTest::setUpContributionPage
1639 * on parent class at some point (fn is not in 4.4).
1640 *
1641 * @param $entity
1642 * @param array $params
1643 */
1644 public function createPriceSetWithPage($entity, $params = array()) {
1645 $membershipTypeID = $this->membershipTypeCreate();
1646 $contributionPageResult = $this->callAPISuccess('contribution_page', 'create', array(
1647 'title' => "Test Contribution Page",
1648 'financial_type_id' => 1,
1649 'currency' => 'NZD',
1650 'goal_amount' => 50,
1651 'is_pay_later' => 1,
1652 'is_monetary' => TRUE,
1653 'is_email_receipt' => FALSE,
1654 ));
1655 $priceSet = $this->callAPISuccess('price_set', 'create', array(
1656 'is_quick_config' => 0,
1657 'extends' => 'CiviMember',
1658 'financial_type_id' => 1,
1659 'title' => 'my Page',
1660 ));
1661 $priceSetID = $priceSet['id'];
1662
1663 CRM_Price_BAO_PriceSet::addTo('civicrm_contribution_page', $contributionPageResult['id'], $priceSetID);
1664 $priceField = $this->callAPISuccess('price_field', 'create', array(
1665 'price_set_id' => $priceSetID,
1666 'label' => 'Goat Breed',
1667 'html_type' => 'Radio',
1668 ));
1669 $priceFieldValue = $this->callAPISuccess('price_field_value', 'create', array(
1670 'price_set_id' => $priceSetID,
1671 'price_field_id' => $priceField['id'],
1672 'label' => 'Long Haired Goat',
1673 'amount' => 20,
1674 'financial_type_id' => 'Donation',
1675 'membership_type_id' => $membershipTypeID,
1676 'membership_num_terms' => 1,
1677 )
1678 );
1679 $this->_ids['price_field_value'] = array($priceFieldValue['id']);
1680 $priceFieldValue = $this->callAPISuccess('price_field_value', 'create', array(
1681 'price_set_id' => $priceSetID,
1682 'price_field_id' => $priceField['id'],
1683 'label' => 'Shoe-eating Goat',
1684 'amount' => 10,
1685 'financial_type_id' => 'Donation',
1686 'membership_type_id' => $membershipTypeID,
1687 'membership_num_terms' => 2,
1688 )
1689 );
1690 $this->_ids['price_field_value'][] = $priceFieldValue['id'];
1691 $this->_ids['price_set'] = $priceSetID;
1692 $this->_ids['contribution_page'] = $contributionPageResult['id'];
1693 $this->_ids['price_field'] = array($priceField['id']);
1694
1695 $this->_ids['membership_type'] = $membershipTypeID;
1696 }
1697
1698 /**
1699 * Set up a pending transaction with a specific price field id.
1700 *
1701 * @param int $priceFieldValueID
1702 */
1703 public function setUpPendingContribution($priceFieldValueID) {
1704 $contactID = $this->individualCreate();
1705 $membership = $this->callAPISuccess('membership', 'create', array(
1706 'contact_id' => $contactID,
1707 'membership_type_id' => $this->_ids['membership_type'],
1708 'start_date' => 'yesterday - 1 year',
1709 'end_date' => 'yesterday',
1710 'join_date' => 'yesterday - 1 year',
1711 ));
1712 $contribution = $this->callAPISuccess('contribution', 'create', array(
1713 'domain_id' => 1,
1714 'contact_id' => $contactID,
1715 'receive_date' => date('Ymd'),
1716 'total_amount' => 100.00,
1717 'financial_type_id' => 1,
1718 'payment_instrument_id' => 'Credit Card',
1719 'non_deductible_amount' => 10.00,
1720 'trxn_id' => 'jdhfi88',
1721 'invoice_id' => 'djfhiewuyr',
1722 'source' => 'SSF',
1723 'contribution_status_id' => 2,
1724 'contribution_page_id' => $this->_ids['contribution_page'],
1725 'api.membership_payment.create' => array('membership_id' => $membership['id']),
1726 ));
1727
1728 $this->callAPISuccess('line_item', 'create', array(
1729 'entity_id' => $contribution['id'],
1730 'entity_table' => 'civicrm_contribution',
1731 'contribution_id' => $contribution['id'],
1732 'price_field_id' => $this->_ids['price_field'][0],
1733 'qty' => 1,
1734 'unit_price' => 20,
1735 'line_total' => 20,
1736 'financial_type_id' => 1,
1737 'price_field_value_id' => $priceFieldValueID,
1738 ));
1739 $this->_ids['contact'] = $contactID;
1740 $this->_ids['contribution'] = $contribution['id'];
1741 $this->_ids['membership'] = $membership['id'];
1742 }
1743
1744 /**
1745 * Test sending a mail via the API.
1746 */
1747 public function testSendMail() {
1748 $mut = new CiviMailUtils($this, TRUE);
1749 $contribution = $this->callAPISuccess('contribution', 'create', $this->_params);
1750 $this->callAPISuccess('contribution', 'sendconfirmation', array(
1751 'id' => $contribution['id'],
1752 'receipt_from_email' => 'api@civicrm.org',
1753 )
1754 );
1755 $mut->checkMailLog(array(
1756 '$ 100.00',
1757 'Contribution Information',
1758 'Please print this confirmation for your records',
1759 ), array(
1760 'Event',
1761 )
1762 );
1763 $mut->stop();
1764 }
1765
1766 /**
1767 * Test sending a mail via the API.
1768 */
1769 public function testSendMailEvent() {
1770 $mut = new CiviMailUtils($this, TRUE);
1771 $contribution = $this->callAPISuccess('contribution', 'create', $this->_params);
1772 $event = $this->eventCreate(array(
1773 'is_email_confirm' => 1,
1774 'confirm_from_email' => 'test@civicrm.org',
1775 ));
1776 $this->_eventID = $event['id'];
1777 $participantParams = array(
1778 'contact_id' => $this->_individualId,
1779 'event_id' => $this->_eventID,
1780 'status_id' => 1,
1781 'role_id' => 1,
1782 // to ensure it matches later on
1783 'register_date' => '2007-07-21 00:00:00',
1784 'source' => 'Online Event Registration: API Testing',
1785
1786 );
1787 $participant = $this->callAPISuccess('participant', 'create', $participantParams);
1788 $this->callAPISuccess('participant_payment', 'create', array(
1789 'participant_id' => $participant['id'],
1790 'contribution_id' => $contribution['id'],
1791 ));
1792 $this->callAPISuccess('contribution', 'sendconfirmation', array(
1793 'id' => $contribution['id'],
1794 'receipt_from_email' => 'api@civicrm.org',
1795 )
1796 );
1797
1798 $mut->checkMailLog(array(
1799 'Annual CiviCRM meet',
1800 'Event',
1801 'To: "Mr. Anthony Anderson II" <anthony_anderson@civicrm.org>',
1802 ), array()
1803 );
1804 $mut->stop();
1805 }
1806
1807 /**
1808 * This function does a GET & compares the result against the $params.
1809 *
1810 * Use as a double check on Creates.
1811 *
1812 * @param array $params
1813 * @param int $id
1814 * @param bool $delete
1815 */
1816 public function contributionGetnCheck($params, $id, $delete = TRUE) {
1817
1818 $contribution = $this->callAPISuccess('Contribution', 'Get', array(
1819 'id' => $id,
1820
1821 ));
1822
1823 if ($delete) {
1824 $this->callAPISuccess('contribution', 'delete', array('id' => $id));
1825 }
1826 $this->assertAPISuccess($contribution, 0);
1827 $values = $contribution['values'][$contribution['id']];
1828 $params['receive_date'] = date('Y-m-d H:i:s', strtotime($params['receive_date']));
1829 // this is not returned in id format
1830 unset($params['payment_instrument_id']);
1831 $params['contribution_source'] = $params['source'];
1832 unset($params['source']);
1833 foreach ($params as $key => $value) {
1834 $this->assertEquals($value, $values[$key], $key . " value: $value doesn't match " . print_r($values, TRUE));
1835 }
1836 }
1837
1838 /**
1839 * Create a pending contribution & linked pending participant record (along with an event).
1840 */
1841 public function createPendingParticipantContribution() {
1842 $event = $this->eventCreate(array('is_email_confirm' => 1, 'confirm_from_email' => 'test@civicrm.org'));
1843 $participantID = $this->participantCreate(array('event_id' => $event['id'], 'status_id' => 6));
1844 $this->_ids['participant'] = $participantID;
1845 $params = array_merge($this->_params, array('contribution_status_id' => 2, 'financial_type_id' => 'Event Fee'));
1846 $contribution = $this->callAPISuccess('contribution', 'create', $params);
1847 $this->callAPISuccess('participant_payment', 'create', array(
1848 'contribution_id' => $contribution['id'],
1849 'participant_id' => $participantID,
1850 ));
1851 $this->callAPISuccess('line_item', 'get', array(
1852 'entity_id' => $contribution['id'],
1853 'entity_table' => 'civicrm_contribution',
1854 'api.line_item.create' => array(
1855 'entity_id' => $participantID,
1856 'entity_table' => 'civicrm_participant',
1857 ),
1858 ));
1859 return $contribution['id'];
1860 }
1861
1862 /**
1863 * Get financial transaction amount.
1864 *
1865 * @param int $contId
1866 *
1867 * @return null|string
1868 */
1869 public function _getFinancialTrxnAmount($contId) {
1870 $query = "SELECT
1871 SUM( ft.total_amount ) AS total
1872 FROM civicrm_financial_trxn AS ft
1873 LEFT JOIN civicrm_entity_financial_trxn AS ceft ON ft.id = ceft.financial_trxn_id
1874 WHERE ceft.entity_table = 'civicrm_contribution'
1875 AND ceft.entity_id = {$contId}";
1876
1877 $result = CRM_Core_DAO::singleValueQuery($query);
1878 return $result;
1879 }
1880
1881 /**
1882 * @param int $contId
1883 *
1884 * @return null|string
1885 */
1886 public function _getFinancialItemAmount($contId) {
1887 $lineItem = key(CRM_Price_BAO_LineItem::getLineItems($contId, 'contribution'));
1888 $query = "SELECT
1889 SUM(amount)
1890 FROM civicrm_financial_item
1891 WHERE entity_table = 'civicrm_line_item'
1892 AND entity_id = {$lineItem}";
1893 $result = CRM_Core_DAO::singleValueQuery($query);
1894 return $result;
1895 }
1896
1897 /**
1898 * @param int $contId
1899 * @param $context
1900 */
1901 public function _checkFinancialItem($contId, $context) {
1902 if ($context != 'paylater') {
1903 $params = array(
1904 'entity_id' => $contId,
1905 'entity_table' => 'civicrm_contribution',
1906 );
1907 $trxn = current(CRM_Financial_BAO_FinancialItem::retrieveEntityFinancialTrxn($params, TRUE));
1908 $entityParams = array(
1909 'financial_trxn_id' => $trxn['financial_trxn_id'],
1910 'entity_table' => 'civicrm_financial_item',
1911 );
1912 $entityTrxn = current(CRM_Financial_BAO_FinancialItem::retrieveEntityFinancialTrxn($entityParams));
1913 $params = array(
1914 'id' => $entityTrxn['entity_id'],
1915 );
1916 }
1917 if ($context == 'paylater') {
1918 $lineItems = CRM_Price_BAO_LineItem::getLineItems($contId, 'contribution');
1919 foreach ($lineItems as $key => $item) {
1920 $params = array(
1921 'entity_id' => $key,
1922 'entity_table' => 'civicrm_line_item',
1923 );
1924 $compareParams = array('status_id' => 1);
1925 $this->assertDBCompareValues('CRM_Financial_DAO_FinancialItem', $params, $compareParams);
1926 }
1927 }
1928 elseif ($context == 'refund') {
1929 $compareParams = array(
1930 'status_id' => 1,
1931 'financial_account_id' => 1,
1932 'amount' => -100,
1933 );
1934 }
1935 elseif ($context == 'cancelPending') {
1936 $compareParams = array(
1937 'status_id' => 3,
1938 'financial_account_id' => 1,
1939 'amount' => -100,
1940 );
1941 }
1942 elseif ($context == 'changeFinancial') {
1943 $lineKey = key(CRM_Price_BAO_LineItem::getLineItems($contId, 'contribution'));
1944 $params = array(
1945 'entity_id' => $lineKey,
1946 'amount' => -100,
1947 );
1948 $compareParams = array(
1949 'financial_account_id' => 1,
1950 );
1951 $this->assertDBCompareValues('CRM_Financial_DAO_FinancialItem', $params, $compareParams);
1952 $params = array(
1953 'financial_account_id' => 3,
1954 'entity_id' => $lineKey,
1955 );
1956 $compareParams = array(
1957 'amount' => 100,
1958 );
1959 }
1960 if ($context != 'paylater') {
1961 $this->assertDBCompareValues('CRM_Financial_DAO_FinancialItem', $params, $compareParams);
1962 }
1963 }
1964
1965 /**
1966 * @param array $contribution
1967 * @param string $context
1968 * @param int $instrumentId
1969 */
1970 public function _checkFinancialTrxn($contribution, $context, $instrumentId = NULL) {
1971 $trxnParams = array(
1972 'entity_id' => $contribution['id'],
1973 'entity_table' => 'civicrm_contribution',
1974 );
1975 $trxn = current(CRM_Financial_BAO_FinancialItem::retrieveEntityFinancialTrxn($trxnParams, TRUE));
1976 $params = array(
1977 'id' => $trxn['financial_trxn_id'],
1978 );
1979 if ($context == 'payLater') {
1980 $relationTypeId = key(CRM_Core_PseudoConstant::accountOptionValues('account_relationship', NULL, " AND v.name LIKE 'Accounts Receivable Account is' "));
1981 $compareParams = array(
1982 'status_id' => 1,
1983 'from_financial_account_id' => CRM_Contribute_PseudoConstant::financialAccountType($contribution['financial_type_id'], $relationTypeId),
1984 );
1985 }
1986 elseif ($context == 'refund') {
1987 $compareParams = array(
1988 'to_financial_account_id' => 6,
1989 'total_amount' => -100,
1990 'status_id' => 7,
1991 );
1992 }
1993 elseif ($context == 'cancelPending') {
1994 $compareParams = array(
1995 'to_financial_account_id' => 7,
1996 'total_amount' => -100,
1997 'status_id' => 3,
1998 );
1999 }
2000 elseif ($context == 'changeFinancial' || $context == 'paymentInstrument') {
2001 $entityParams = array(
2002 'entity_id' => $contribution['id'],
2003 'entity_table' => 'civicrm_contribution',
2004 'amount' => -100,
2005 );
2006 $trxn = current(CRM_Financial_BAO_FinancialItem::retrieveEntityFinancialTrxn($entityParams));
2007 $trxnParams1 = array(
2008 'id' => $trxn['financial_trxn_id'],
2009 );
2010 $compareParams = array(
2011 'total_amount' => -100,
2012 'status_id' => 1,
2013 );
2014 if ($context == 'paymentInstrument') {
2015 $compareParams += array(
2016 'to_financial_account_id' => CRM_Financial_BAO_FinancialTypeAccount::getInstrumentFinancialAccount(4),
2017 'payment_instrument_id' => 4,
2018 );
2019 }
2020 else {
2021 $compareParams['to_financial_account_id'] = 12;
2022 }
2023 $this->assertDBCompareValues('CRM_Financial_DAO_FinancialTrxn', $trxnParams1, $compareParams);
2024 $compareParams['total_amount'] = 100;
2025 if ($context == 'paymentInstrument') {
2026 $compareParams['to_financial_account_id'] = CRM_Financial_BAO_FinancialTypeAccount::getInstrumentFinancialAccount($instrumentId);
2027 $compareParams['payment_instrument_id'] = $instrumentId;
2028 }
2029 else {
2030 $compareParams['to_financial_account_id'] = 12;
2031 }
2032 }
2033
2034 $this->assertDBCompareValues('CRM_Financial_DAO_FinancialTrxn', $params, $compareParams);
2035 }
2036
2037 /**
2038 * @return mixed
2039 */
2040 public function _addPaymentInstrument() {
2041 $gId = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_OptionGroup', 'payment_instrument', 'id', 'name');
2042 $optionParams = array(
2043 'option_group_id' => $gId,
2044 'label' => 'Test Card',
2045 'name' => 'Test Card',
2046 'value' => '6',
2047 'weight' => '6',
2048 'is_active' => 1,
2049 );
2050 $optionValue = $this->callAPISuccess('option_value', 'create', $optionParams);
2051 $relationTypeId = key(CRM_Core_PseudoConstant::accountOptionValues('account_relationship', NULL, " AND v.name LIKE 'Asset Account is' "));
2052 $financialParams = array(
2053 'entity_table' => 'civicrm_option_value',
2054 'entity_id' => $optionValue['id'],
2055 'account_relationship' => $relationTypeId,
2056 'financial_account_id' => 7,
2057 );
2058 CRM_Financial_BAO_FinancialTypeAccount::add($financialParams, CRM_Core_DAO::$_nullArray);
2059 $this->assertNotEmpty($optionValue['values'][$optionValue['id']]['value']);
2060 return $optionValue['values'][$optionValue['id']]['value'];
2061 }
2062
2063 /**
2064 * @param array $params
2065 * @param $context
2066 */
2067 public function _checkFinancialRecords($params, $context) {
2068 $entityParams = array(
2069 'entity_id' => $params['id'],
2070 'entity_table' => 'civicrm_contribution',
2071 );
2072 $contribution = $this->callAPISuccess('contribution', 'getsingle', array('id' => $params['id']));
2073 $this->assertEquals($contribution['total_amount'] - $contribution['fee_amount'], $contribution['net_amount']);
2074 if ($context == 'pending') {
2075 $trxn = CRM_Financial_BAO_FinancialItem::retrieveEntityFinancialTrxn($entityParams);
2076 $this->assertNull($trxn, 'No Trxn to be created until IPN callback');
2077 return;
2078 }
2079 $trxn = current(CRM_Financial_BAO_FinancialItem::retrieveEntityFinancialTrxn($entityParams));
2080 $trxnParams = array(
2081 'id' => $trxn['financial_trxn_id'],
2082 );
2083 if ($context != 'online' && $context != 'payLater') {
2084 $compareParams = array(
2085 'to_financial_account_id' => 6,
2086 'total_amount' => 100,
2087 'status_id' => 1,
2088 );
2089 }
2090 if ($context == 'feeAmount') {
2091 $compareParams['fee_amount'] = 50;
2092 }
2093 elseif ($context == 'online') {
2094 $compareParams = array(
2095 'to_financial_account_id' => 12,
2096 'total_amount' => 100,
2097 'status_id' => 1,
2098 );
2099 }
2100 elseif ($context == 'payLater') {
2101 $compareParams = array(
2102 'to_financial_account_id' => 7,
2103 'total_amount' => 100,
2104 'status_id' => 2,
2105 );
2106 }
2107 $this->assertDBCompareValues('CRM_Financial_DAO_FinancialTrxn', $trxnParams, $compareParams);
2108 $entityParams = array(
2109 'financial_trxn_id' => $trxn['financial_trxn_id'],
2110 'entity_table' => 'civicrm_financial_item',
2111 );
2112 $entityTrxn = current(CRM_Financial_BAO_FinancialItem::retrieveEntityFinancialTrxn($entityParams));
2113 $fitemParams = array(
2114 'id' => $entityTrxn['entity_id'],
2115 );
2116 $compareParams = array(
2117 'amount' => 100,
2118 'status_id' => 1,
2119 'financial_account_id' => 1,
2120 );
2121 if ($context == 'payLater') {
2122 $compareParams = array(
2123 'amount' => 100,
2124 'status_id' => 3,
2125 'financial_account_id' => 1,
2126 );
2127 }
2128 $this->assertDBCompareValues('CRM_Financial_DAO_FinancialItem', $fitemParams, $compareParams);
2129 if ($context == 'feeAmount') {
2130 $maxParams = array(
2131 'entity_id' => $params['id'],
2132 'entity_table' => 'civicrm_contribution',
2133 );
2134 $maxTrxn = current(CRM_Financial_BAO_FinancialItem::retrieveEntityFinancialTrxn($maxParams, TRUE));
2135 $trxnParams = array(
2136 'id' => $maxTrxn['financial_trxn_id'],
2137 );
2138 $compareParams = array(
2139 'to_financial_account_id' => 5,
2140 'from_financial_account_id' => 6,
2141 'total_amount' => 50,
2142 'status_id' => 1,
2143 );
2144 $trxnId = CRM_Core_BAO_FinancialTrxn::getFinancialTrxnId($params['id'], 'DESC');
2145 $this->assertDBCompareValues('CRM_Financial_DAO_FinancialTrxn', $trxnParams, $compareParams);
2146 $fitemParams = array(
2147 'entity_id' => $trxnId['financialTrxnId'],
2148 'entity_table' => 'civicrm_financial_trxn',
2149 );
2150 $compareParams = array(
2151 'amount' => 50,
2152 'status_id' => 1,
2153 'financial_account_id' => 5,
2154 );
2155 $this->assertDBCompareValues('CRM_Financial_DAO_FinancialItem', $fitemParams, $compareParams);
2156 }
2157 }
2158
2159 }