3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.7 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2017 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
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. |
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. |
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 +--------------------------------------------------------------------+
29 * Test APIv3 civicrm_report_instance_* functions
31 * @package CiviCRM_APIv3
32 * @subpackage API_Report
35 class api_v3_ReportTemplateTest
extends CiviUnitTestCase
{
36 protected $_apiversion = 3;
39 * Our group reports use an alter so transaction cleanup won't work.
43 public function tearDown() {
44 $this->quickCleanUpFinancialEntities();
45 $this->quickCleanup(array('civicrm_group', 'civicrm_saved_search', 'civicrm_group_contact', 'civicrm_group_contact_cache', 'civicrm_group'));
49 public function testReportTemplate() {
50 $result = $this->callAPISuccess('ReportTemplate', 'create', array(
51 'label' => 'Example Form',
52 'description' => 'Longish description of the example form',
53 'class_name' => 'CRM_Report_Form_Examplez',
54 'report_url' => 'example/path',
55 'component' => 'CiviCase',
57 $this->assertAPISuccess($result);
58 $this->assertEquals(1, $result['count']);
59 $entityId = $result['id'];
60 $this->assertTrue(is_numeric($entityId));
61 $this->assertEquals(7, $result['values'][$entityId]['component_id']);
62 $this->assertDBQuery(1, 'SELECT count(*) FROM civicrm_option_value
63 WHERE name = "CRM_Report_Form_Examplez"
64 AND option_group_id IN (SELECT id from civicrm_option_group WHERE name = "report_template") ');
65 $this->assertDBQuery(1, 'SELECT is_active FROM civicrm_option_value
66 WHERE name = "CRM_Report_Form_Examplez"');
68 // change component to null
69 $result = $this->callAPISuccess('ReportTemplate', 'create', array(
73 $this->assertAPISuccess($result);
74 $this->assertEquals(1, $result['count']);
75 $this->assertDBQuery(1, 'SELECT count(*) FROM civicrm_option_value
76 WHERE name = "CRM_Report_Form_Examplez"
77 AND option_group_id IN (SELECT id from civicrm_option_group WHERE name = "report_template") ');
78 $this->assertDBQuery(1, 'SELECT count(*) FROM civicrm_option_value
79 WHERE name = "CRM_Report_Form_Examplez"
80 AND component_id IS NULL');
83 $result = $this->callAPISuccess('ReportTemplate', 'create', array(
87 $this->assertAPISuccess($result);
88 $this->assertEquals(1, $result['count']);
89 $this->assertDBQuery(1, 'SELECT count(*) FROM civicrm_option_value
90 WHERE name = "CRM_Report_Form_Examplez"
91 AND option_group_id IN (SELECT id from civicrm_option_group WHERE name = "report_template") ');
92 $this->assertDBQuery(0, 'SELECT is_active FROM civicrm_option_value
93 WHERE name = "CRM_Report_Form_Examplez"');
96 $result = $this->callAPISuccess('ReportTemplate', 'create', array(
100 $this->assertAPISuccess($result);
101 $this->assertEquals(1, $result['count']);
102 $this->assertDBQuery(1, 'SELECT count(*) FROM civicrm_option_value
103 WHERE name = "CRM_Report_Form_Examplez"
104 AND option_group_id IN (SELECT id from civicrm_option_group WHERE name = "report_template") ');
105 $this->assertDBQuery(1, 'SELECT is_active FROM civicrm_option_value
106 WHERE name = "CRM_Report_Form_Examplez"');
108 $result = $this->callAPISuccess('ReportTemplate', 'delete', array(
111 $this->assertAPISuccess($result);
112 $this->assertEquals(1, $result['count']);
113 $this->assertDBQuery(0, 'SELECT count(*) FROM civicrm_option_value
114 WHERE name = "CRM_Report_Form_Examplez"
119 * Test getrows on contact summary report.
121 public function testReportTemplateGetRowsContactSummary() {
122 $description = "Retrieve rows from a report template (optionally providing the instance_id).";
123 $result = $this->callAPIAndDocument('report_template', 'getrows', array(
124 'report_id' => 'contact/summary',
125 'options' => array('metadata' => array('labels', 'title')),
126 ), __FUNCTION__
, __FILE__
, $description, 'Getrows');
127 $this->assertEquals('Contact Name', $result['metadata']['labels']['civicrm_contact_sort_name']);
129 //the second part of this test has been commented out because it relied on the db being reset to
131 //wasn't able to get that to work consistently
132 // however, when the db is in the base state the tests do pass
133 // and because the test covers 'all' contacts we can't create our own & assume the others don't exist
135 $this->assertEquals(2, $result['count']);
136 $this->assertEquals('Default Organization', $result[0]['civicrm_contact_sort_name']);
137 $this->assertEquals('Second Domain', $result[1]['civicrm_contact_sort_name']);
138 $this->assertEquals('15 Main St', $result[1]['civicrm_address_street_address']);
143 * Tet api to get rows from reports.
145 * @dataProvider getReportTemplates
149 * @throws \PHPUnit_Framework_IncompleteTestError
151 public function testReportTemplateGetRowsAllReports($reportID) {
152 if (stristr($reportID, 'has existing issues')) {
153 $this->markTestIncomplete($reportID);
155 $this->callAPISuccess('report_template', 'getrows', array(
156 'report_id' => $reportID,
161 * Test get statistics.
163 * @dataProvider getReportTemplates
167 * @throws \PHPUnit_Framework_IncompleteTestError
169 public function testReportTemplateGetStatisticsAllReports($reportID) {
170 if (stristr($reportID, 'has existing issues')) {
171 $this->markTestIncomplete($reportID);
173 if (in_array($reportID, array('contribute/softcredit', 'contribute/bookkeeping'))) {
174 $this->markTestIncomplete($reportID . " has non enotices when calling statistics fn");
176 $description = "Get Statistics from a report (note there isn't much data to get in the test DB).";
177 $result = $this->callAPIAndDocument('report_template', 'getstatistics', array(
178 'report_id' => $reportID,
179 ), __FUNCTION__
, __FILE__
, $description, 'Getstatistics', 'getstatistics');
183 * Data provider function for getting all templates.
185 * Note that the function needs to
186 * be static so cannot use $this->callAPISuccess
188 public static function getReportTemplates() {
189 $reportsToSkip = array(
190 'activity' => 'does not respect function signature on from clause',
191 'contribute/topDonor' => 'construction of query in postProcess makes inaccessible ',
192 'event/income' => 'I do no understand why but error is Call to undefined method CRM_Report_Form_Event_Income::from() in CRM/Report/Form.php on line 2120',
193 'logging/contact/summary' => '(likely to be test related) probably logging off Undefined index: Form/Contact/LoggingSummary.php(231): PHP',
194 'logging/contribute/summary' => '(likely to be test related) probably logging off DB Error: no such table',
195 'contribute/history' => 'Declaration of CRM_Report_Form_Contribute_History::buildRows() should be compatible with CRM_Report_Form::buildRows($sql, &$rows)',
196 'activitySummary' => 'We use temp tables for the main query generation and name are dynamic. These names are not available in stats() when called directly.',
199 $reports = civicrm_api3('report_template', 'get', array('return' => 'value', 'options' => array('limit' => 500)));
200 foreach ($reports['values'] as $report) {
201 if (empty($reportsToSkip[$report['value']])) {
202 $reportTemplates[] = array($report['value']);
205 $reportTemplates[] = array($report['value'] . " has existing issues : " . $reportsToSkip[$report['value']]);
209 return $reportTemplates;
213 * Get contribution templates that work with basic filter tests.
215 * These templates require minimal data config.
217 public static function getContributionReportTemplates() {
218 return array(array('contribute/summary'), array('contribute/detail'), array('contribute/repeat'), array('topDonor' => 'contribute/topDonor'));
222 * Get contribution templates that work with basic filter tests.
224 * These templates require minimal data config.
226 public static function getMembershipReportTemplates() {
227 return array(array('member/detail'));
230 public static function getMembershipAndContributionReportTemplatesForGroupTests() {
231 $templates = array_merge(self
::getContributionReportTemplates(), self
::getMembershipReportTemplates());
232 foreach ($templates as $key => $value) {
233 if (array_key_exists('topDonor', $value)) {
234 // Report is not standard enough to test here.
235 unset($templates[$key]);
243 * Test Lybunt report to check basic inclusion of a contact who gave in the year before the chosen year.
245 public function testLybuntReportWithData() {
246 $inInd = $this->individualCreate();
247 $outInd = $this->individualCreate();
248 $this->contributionCreate(array('contact_id' => $inInd, 'receive_date' => '2014-03-01'));
249 $this->contributionCreate(array('contact_id' => $outInd, 'receive_date' => '2015-03-01', 'trxn_id' => NULL, 'invoice_id' => NULL));
250 $rows = $this->callAPISuccess('report_template', 'getrows', array(
251 'report_id' => 'contribute/lybunt',
253 'yid_op' => 'calendar',
254 'options' => array('metadata' => array('sql')),
256 $this->assertEquals(1, $rows['count'], "Report failed - the sql used to generate the results was " . print_r($rows['metadata']['sql'], TRUE));
260 * Test Lybunt report applies ACLs.
262 public function testLybuntReportWithDataAndACLFilter() {
263 CRM_Core_Config
::singleton()->userPermissionClass
->permissions
= array('administer CiviCRM');
264 $inInd = $this->individualCreate();
265 $outInd = $this->individualCreate();
266 $this->contributionCreate(array('contact_id' => $inInd, 'receive_date' => '2014-03-01'));
267 $this->contributionCreate(array('contact_id' => $outInd, 'receive_date' => '2015-03-01', 'trxn_id' => NULL, 'invoice_id' => NULL));
268 $this->hookClass
->setHook('civicrm_aclWhereClause', array($this, 'aclWhereHookNoResults'));
270 'report_id' => 'contribute/lybunt',
272 'yid_op' => 'calendar',
273 'options' => array('metadata' => array('sql')),
274 'check_permissions' => 1,
277 $rows = $this->callAPISuccess('report_template', 'getrows', $params);
278 $this->assertEquals(0, $rows['count'], "Report failed - the sql used to generate the results was " . print_r($rows['metadata']['sql'], TRUE));
280 CRM_Utils_Hook
::singleton()->reset();
284 * Test Lybunt report to check basic inclusion of a contact who gave in the year before the chosen year.
286 public function testLybuntReportWithFYData() {
287 $inInd = $this->individualCreate();
288 $outInd = $this->individualCreate();
289 $this->contributionCreate(array('contact_id' => $inInd, 'receive_date' => '2014-10-01'));
290 $this->contributionCreate(array('contact_id' => $outInd, 'receive_date' => '2015-03-01', 'trxn_id' => NULL, 'invoice_id' => NULL));
291 $this->callAPISuccess('Setting', 'create', array('fiscalYearStart' => array('M' => 7, 'd' => 1)));
292 $rows = $this->callAPISuccess('report_template', 'getrows', array(
293 'report_id' => 'contribute/lybunt',
295 'yid_op' => 'fiscal',
296 'options' => array('metadata' => array('sql')),
297 'order_bys' => array(
299 'column' => 'first_name',
305 $this->assertEquals(2, $rows['count'], "Report failed - the sql used to generate the results was " . print_r($rows['metadata']['sql'], TRUE));
307 $this->assertContains('DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
308 SELECT SQL_CALC_FOUND_ROWS contact_civireport.id as cid FROM civicrm_contact contact_civireport INNER JOIN civicrm_contribution contribution_civireport USE index (received_date) ON contribution_civireport.contact_id = contact_civireport.id
309 AND contribution_civireport.is_test = 0
310 AND contribution_civireport.receive_date BETWEEN \'20140701000000\' AND \'20150630235959\'
312 LEFT JOIN civicrm_contribution cont_exclude ON cont_exclude.contact_id = contact_civireport.id
313 AND cont_exclude.receive_date BETWEEN \'2015-7-1\' AND \'20160630235959\' WHERE cont_exclude.id IS NULL AND 1 AND ( contribution_civireport.contribution_status_id IN (1) )
314 GROUP BY contact_civireport.id', $rows['metadata']['sql'][0]);
318 * Test Lybunt report to check basic inclusion of a contact who gave in the year before the chosen year.
320 public function testLybuntReportWithFYDataOrderByLastYearAmount() {
321 $inInd = $this->individualCreate();
322 $outInd = $this->individualCreate();
323 $this->contributionCreate(array('contact_id' => $inInd, 'receive_date' => '2014-10-01'));
324 $this->contributionCreate(array('contact_id' => $outInd, 'receive_date' => '2015-03-01', 'trxn_id' => NULL, 'invoice_id' => NULL));
325 $this->callAPISuccess('Setting', 'create', array('fiscalYearStart' => array('M' => 7, 'd' => 1)));
326 $rows = $this->callAPISuccess('report_template', 'getrows', array(
327 'report_id' => 'contribute/lybunt',
329 'yid_op' => 'fiscal',
330 'options' => array('metadata' => array('sql')),
331 'fields' => array('first_name'),
332 'order_bys' => array(
334 'column' => 'last_year_total_amount',
340 $this->assertEquals(2, $rows['count'], "Report failed - the sql used to generate the results was " . print_r($rows['metadata']['sql'], TRUE));
344 * Test the group filter works on the contribution summary (with a smart group).
346 * @dataProvider getMembershipAndContributionReportTemplatesForGroupTests
348 * @param string $template
349 * Name of the template to test.
351 public function testContributionSummaryWithSmartGroupFilter($template) {
352 $groupID = $this->setUpPopulatedSmartGroup();
353 $rows = $this->callAPISuccess('report_template', 'getrows', array(
354 'report_id' => $template,
355 'gid_value' => $groupID,
357 'options' => array('metadata' => array('sql')),
359 $this->assertNumberOfContactsInResult(3, $rows, $template);
360 if ($template === 'contribute/summary') {
361 $this->assertEquals(3, $rows['values'][0]['civicrm_contribution_total_amount_count']);
366 * Test the group filter works on the contribution summary.
368 * @dataProvider getMembershipAndContributionReportTemplatesForGroupTests
370 public function testContributionSummaryWithNotINSmartGroupFilter($template) {
371 $groupID = $this->setUpPopulatedSmartGroup();
372 $rows = $this->callAPISuccess('report_template', 'getrows', array(
373 'report_id' => 'contribute/summary',
374 'gid_value' => $groupID,
376 'options' => array('metadata' => array('sql')),
378 $this->assertEquals(2, $rows['values'][0]['civicrm_contribution_total_amount_count']);
383 * Test the group filter works on the various reports.
385 * @dataProvider getMembershipAndContributionReportTemplatesForGroupTests
387 * @param string $template
388 * Report template unique identifier.
390 public function testReportsWithNonSmartGroupFilter($template) {
391 $groupID = $this->setUpPopulatedGroup();
392 $rows = $this->callAPISuccess('report_template', 'getrows', array(
393 'report_id' => $template,
394 'gid_value' => array($groupID),
396 'options' => array('metadata' => array('sql')),
398 $this->assertNumberOfContactsInResult(1, $rows, $template);
402 * Assert the included results match the expected.
404 * There may or may not be a group by in play so the assertion varies a little.
406 * @param int $numberExpected
408 * Rows returned from the report.
409 * @param string $template
411 protected function assertNumberOfContactsInResult($numberExpected, $rows, $template) {
412 if (isset($rows['values'][0]['civicrm_contribution_total_amount_count'])) {
413 $this->assertEquals($numberExpected, $rows['values'][0]['civicrm_contribution_total_amount_count'], 'wrong row count in ' . $template);
416 $this->assertEquals($numberExpected, count($rows['values']), 'wrong row count in ' . $template);
421 * Test the group filter works on the contribution summary when 2 groups are involved.
423 public function testContributionSummaryWithTwoGroups() {
424 $groupID = $this->setUpPopulatedGroup();
425 $groupID2 = $this->setUpPopulatedSmartGroup();
426 $rows = $this->callAPISuccess('report_template', 'getrows', array(
427 'report_id' => 'contribute/summary',
428 'gid_value' => array($groupID, $groupID2),
430 'options' => array('metadata' => array('sql')),
432 $this->assertEquals(4, $rows['values'][0]['civicrm_contribution_total_amount_count']);
436 * CRM-20640: Test the group filter works on the contribution summary when a single contact in 2 groups.
438 public function testContributionSummaryWithSingleContactsInTwoGroups() {
439 list($groupID1, $individualID) = $this->setUpPopulatedGroup(TRUE);
440 // create second group and add the individual to it.
441 $groupID2 = $this->groupCreate(array('name' => uniqid(), 'title' => uniqid()));
442 $this->callAPISuccess('GroupContact', 'create', array(
443 'group_id' => $groupID2,
444 'contact_id' => $individualID,
448 $rows = $this->callAPISuccess('report_template', 'getrows', array(
449 'report_id' => 'contribute/summary',
450 'gid_value' => array($groupID1, $groupID2),
452 'options' => array('metadata' => array('sql')),
454 $this->assertEquals(1, $rows['count']);
458 * Test the group filter works on the contribution summary when 2 groups are involved.
460 public function testContributionSummaryWithTwoGroupsWithIntersection() {
461 $groups = $this->setUpIntersectingGroups();
463 $rows = $this->callAPISuccess('report_template', 'getrows', array(
464 'report_id' => 'contribute/summary',
465 'gid_value' => $groups,
467 'options' => array('metadata' => array('sql')),
469 $this->assertEquals(7, $rows['values'][0]['civicrm_contribution_total_amount_count']);
473 * Set up a smart group for testing.
475 * The smart group includes all Households by filter. In addition an individual
476 * is created and hard-added and an individual is created that is not added.
478 * One household is hard-added as well as being in the filter.
480 * This gives us a range of scenarios for testing contacts are included only once
481 * whenever they are hard-added or in the criteria.
485 public function setUpPopulatedSmartGroup() {
486 $household1ID = $this->householdCreate();
487 $individual1ID = $this->individualCreate();
488 $householdID = $this->householdCreate();
489 $individualID = $this->individualCreate();
490 $individualIDRemoved = $this->individualCreate();
491 $groupID = $this->smartGroupCreate(array(), array('name' => uniqid(), 'title' => uniqid()));
492 $this->callAPISuccess('GroupContact', 'create', array(
493 'group_id' => $groupID,
494 'contact_id' => $individualIDRemoved,
495 'status' => 'Removed',
497 $this->callAPISuccess('GroupContact', 'create', array(
498 'group_id' => $groupID,
499 'contact_id' => $individualID,
502 $this->callAPISuccess('GroupContact', 'create', array(
503 'group_id' => $groupID,
504 'contact_id' => $householdID,
507 foreach (array($household1ID, $individual1ID, $householdID, $individualID, $individualIDRemoved) as $contactID) {
508 $this->contributionCreate(array('contact_id' => $contactID, 'invoice_id' => '', 'trxn_id' => ''));
509 $this->contactMembershipCreate(array('contact_id' => $contactID));
512 // Refresh the cache for test purposes. It would be better to alter to alter the GroupContact add function to add contacts to the cache.
513 CRM_Contact_BAO_GroupContactCache
::clearGroupContactCache($groupID);
518 * Set up a static group for testing.
520 * An individual is created and hard-added and an individual is created that is not added.
522 * This gives us a range of scenarios for testing contacts are included only once
523 * whenever they are hard-added or in the criteria.
525 * @param bool $returnAddedContact
529 public function setUpPopulatedGroup($returnAddedContact = FALSE) {
530 $individual1ID = $this->individualCreate();
531 $individualID = $this->individualCreate();
532 $individualIDRemoved = $this->individualCreate();
533 $groupID = $this->groupCreate(array('name' => uniqid(), 'title' => uniqid()));
534 $this->callAPISuccess('GroupContact', 'create', array(
535 'group_id' => $groupID,
536 'contact_id' => $individualIDRemoved,
537 'status' => 'Removed',
539 $this->callAPISuccess('GroupContact', 'create', array(
540 'group_id' => $groupID,
541 'contact_id' => $individualID,
545 foreach (array($individual1ID, $individualID, $individualIDRemoved) as $contactID) {
546 $this->contributionCreate(array('contact_id' => $contactID, 'invoice_id' => '', 'trxn_id' => ''));
547 $this->contactMembershipCreate(array('contact_id' => $contactID));
550 // Refresh the cache for test purposes. It would be better to alter to alter the GroupContact add function to add contacts to the cache.
551 CRM_Contact_BAO_GroupContactCache
::clearGroupContactCache($groupID);
553 if ($returnAddedContact) {
554 return array($groupID, $individualID);
563 public function setUpIntersectingGroups() {
564 $groupID = $this->setUpPopulatedGroup();
565 $groupID2 = $this->setUpPopulatedSmartGroup();
566 $addedToBothIndividualID = $this->individualCreate();
567 $removedFromBothIndividualID = $this->individualCreate();
568 $addedToSmartGroupRemovedFromOtherIndividualID = $this->individualCreate();
569 $removedFromSmartGroupAddedToOtherIndividualID = $this->individualCreate();
570 $this->callAPISuccess('GroupContact', 'create', array(
571 'group_id' => $groupID,
572 'contact_id' => $addedToBothIndividualID,
575 $this->callAPISuccess('GroupContact', 'create', array(
576 'group_id' => $groupID2,
577 'contact_id' => $addedToBothIndividualID,
580 $this->callAPISuccess('GroupContact', 'create', array(
581 'group_id' => $groupID,
582 'contact_id' => $removedFromBothIndividualID,
583 'status' => 'Removed',
585 $this->callAPISuccess('GroupContact', 'create', array(
586 'group_id' => $groupID2,
587 'contact_id' => $removedFromBothIndividualID,
588 'status' => 'Removed',
590 $this->callAPISuccess('GroupContact', 'create', array(
591 'group_id' => $groupID2,
592 'contact_id' => $addedToSmartGroupRemovedFromOtherIndividualID,
595 $this->callAPISuccess('GroupContact', 'create', array(
596 'group_id' => $groupID,
597 'contact_id' => $addedToSmartGroupRemovedFromOtherIndividualID,
598 'status' => 'Removed',
600 $this->callAPISuccess('GroupContact', 'create', array(
601 'group_id' => $groupID,
602 'contact_id' => $removedFromSmartGroupAddedToOtherIndividualID,
605 $this->callAPISuccess('GroupContact', 'create', array(
606 'group_id' => $groupID2,
607 'contact_id' => $removedFromSmartGroupAddedToOtherIndividualID,
608 'status' => 'Removed',
612 $addedToBothIndividualID,
613 $removedFromBothIndividualID,
614 $addedToSmartGroupRemovedFromOtherIndividualID,
615 $removedFromSmartGroupAddedToOtherIndividualID,
617 $this->contributionCreate(array(
618 'contact_id' => $contactID,
623 return array($groupID, $groupID2);
627 * Test Deferred Revenue Report.
629 public function testDeferredRevenueReport() {
630 $indv1 = $this->individualCreate();
631 $indv2 = $this->individualCreate();
633 'contribution_invoice_settings' => array(
634 'deferred_revenue_enabled' => '1',
637 $this->callAPISuccess('Setting', 'create', $params);
638 $this->contributionCreate(
640 'contact_id' => $indv1,
641 'receive_date' => '2016-10-01',
642 'revenue_recognition_date' => date('Y-m-t', strtotime(date('ymd') . '+3 month')),
643 'financial_type_id' => 2,
646 $this->contributionCreate(
648 'contact_id' => $indv1,
649 'revenue_recognition_date' => date('Y-m-t', strtotime(date('ymd') . '+22 month')),
650 'financial_type_id' => 4,
652 'invoice_id' => NULL,
655 $this->contributionCreate(
657 'contact_id' => $indv2,
658 'revenue_recognition_date' => date('Y-m-t', strtotime(date('ymd') . '+1 month')),
659 'financial_type_id' => 4,
661 'invoice_id' => NULL,
664 $this->contributionCreate(
666 'contact_id' => $indv2,
667 'receive_date' => '2016-03-01',
668 'revenue_recognition_date' => date('Y-m-t', strtotime(date('ymd') . '+4 month')),
669 'financial_type_id' => 2,
671 'invoice_id' => NULL,
674 $rows = $this->callAPISuccess('report_template', 'getrows', array(
675 'report_id' => 'contribute/deferredrevenue',
677 $this->assertEquals(2, $rows['count'], "Report failed to get row count");
678 $count = array(2, 1);
679 foreach ($rows['values'] as $row) {
680 $this->assertEquals(array_pop($count), count($row['rows']), "Report failed to get row count");