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 +--------------------------------------------------------------------+
33 class CRM_Report_Form_Contribute_DetailTest
extends CiviReportTestCase
{
34 protected $_tablesToTruncate = array(
39 'civicrm_contribution',
45 public function dataProvider() {
48 'CRM_Report_Form_Contribute_Detail',
57 'total_amount_op' => 'gte',
58 'total_amount_value' => 50,
62 'fixtures/dataset-ascii.sql',
63 'fixtures/report-ascii.csv',
68 public function setUp() {
70 $this->quickCleanup($this->_tablesToTruncate
);
73 public function tearDown() {
75 CRM_Core_DAO
::executeQuery('DROP TEMPORARY TABLE IF EXISTS civireport_contribution_detail_temp1');
76 CRM_Core_DAO
::executeQuery('DROP TEMPORARY TABLE IF EXISTS civireport_contribution_detail_temp2');
77 CRM_Core_DAO
::executeQuery('DROP TEMPORARY TABLE IF EXISTS civireport_contribution_detail_temp3');
81 * @dataProvider dataProvider
85 * @param $expectedOutputCsvFile
88 public function testReportOutput($reportClass, $inputParams, $dataSet, $expectedOutputCsvFile) {
89 $config = CRM_Core_Config
::singleton();
90 CRM_Utils_File
::sourceSQLFile($config->dsn
, dirname(__FILE__
) . "/{$dataSet}");
92 $reportCsvFile = $this->getReportOutputAsCsv($reportClass, $inputParams);
93 $reportCsvArray = $this->getArrayFromCsv($reportCsvFile);
95 $expectedOutputCsvArray = $this->getArrayFromCsv(dirname(__FILE__
) . "/{$expectedOutputCsvFile}");
96 $this->assertCsvArraysEqual($expectedOutputCsvArray, $reportCsvArray);
102 public function postalCodeDataProvider() {
105 'CRM_Report_Form_Contribute_Detail',
115 'postal_code_value' => 'B10 G56',
116 'postal_code_op' => 'has',
119 'fixtures/dataset-ascii.sql',
120 'fixtures/DetailPostalCodeTest-ascii.csv',
126 * @dataProvider postalCodeDataProvider
127 * @param $reportClass
128 * @param $inputParams
130 * @param $expectedOutputCsvFile
133 public function testPostalCodeSearchReportOutput($reportClass, $inputParams, $dataSet, $expectedOutputCsvFile) {
134 $config = CRM_Core_Config
::singleton();
135 CRM_Utils_File
::sourceSQLFile($config->dsn
, dirname(__FILE__
) . "/{$dataSet}");
137 $reportCsvFile = $this->getReportOutputAsCsv($reportClass, $inputParams);
138 $reportCsvArray = $this->getArrayFromCsv($reportCsvFile);
140 $expectedOutputCsvArray = $this->getArrayFromCsv(dirname(__FILE__
) . "/{$expectedOutputCsvFile}");
141 $this->assertCsvArraysEqual($expectedOutputCsvArray, $reportCsvArray);