Commit | Line | Data |
---|---|---|
ae555e90 DS |
1 | <?php |
2 | /* | |
3 | +--------------------------------------------------------------------+ | |
06a1bc01 | 4 | | CiviCRM version 4.5 | |
ae555e90 | 5 | +--------------------------------------------------------------------+ |
06a1bc01 | 6 | | Copyright CiviCRM LLC (c) 2004-2014 | |
ae555e90 DS |
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/CiviReportTestCase.php'; | |
29 | ||
30 | /** | |
31 | * Test report outcome | |
32 | * | |
4be6c8f8 | 33 | * @package CiviCRM |
ae555e90 DS |
34 | */ |
35 | class CRM_Report_Form_Contribute_DetailTest extends CiviReportTestCase { | |
745bc660 | 36 | protected $_tablesToTruncate = array( |
ae555e90 DS |
37 | 'civicrm_contact', |
38 | 'civicrm_email', | |
39 | 'civicrm_phone', | |
40 | 'civicrm_address', | |
41 | 'civicrm_contribution', | |
42 | ); | |
43 | ||
4cbe18b8 EM |
44 | /** |
45 | * @return array | |
46 | */ | |
ae555e90 DS |
47 | public function dataProvider() { |
48 | return array( | |
49 | array( | |
50 | 'CRM_Report_Form_Contribute_Detail', | |
2efcf0c2 | 51 | array( |
ae555e90 | 52 | 'fields' => array( |
3fbae312 | 53 | 'sort_name', |
ae555e90 DS |
54 | 'first_name', |
55 | 'email', | |
56 | 'total_amount', | |
57 | ), | |
ec24e302 | 58 | 'filters' => array( |
4be6c8f8 | 59 | 'total_amount_op' => 'gte', |
ec24e302 DS |
60 | 'total_amount_value' => 50, |
61 | ), | |
ae555e90 DS |
62 | // FIXME: add filters |
63 | ), | |
2d71e99f TO |
64 | 'fixtures/dataset-ascii.sql', |
65 | 'fixtures/report-ascii.csv', | |
66 | ) | |
ae555e90 DS |
67 | ); |
68 | } | |
69 | ||
70 | function setUp() { | |
71 | parent::setUp(); | |
2d71e99f | 72 | $this->foreignKeyChecksOff(); |
745bc660 | 73 | $this->quickCleanup($this->_tablesToTruncate); |
ae555e90 DS |
74 | } |
75 | ||
4be6c8f8 | 76 | function tearDown() { |
2d71e99f TO |
77 | parent::tearDown(); |
78 | CRM_Core_DAO::executeQuery('DROP TEMPORARY TABLE IF EXISTS civireport_contribution_detail_temp1'); | |
79 | CRM_Core_DAO::executeQuery('DROP TEMPORARY TABLE IF EXISTS civireport_contribution_detail_temp2'); | |
80 | CRM_Core_DAO::executeQuery('DROP TEMPORARY TABLE IF EXISTS civireport_contribution_detail_temp3'); | |
4be6c8f8 | 81 | } |
ae555e90 DS |
82 | |
83 | /** | |
4be6c8f8 | 84 | * @dataProvider dataProvider |
ae555e90 DS |
85 | */ |
86 | public function testReportOutput($reportClass, $inputParams, $dataSet, $expectedOutputCsvFile) { | |
ae555e90 DS |
87 | $config = CRM_Core_Config::singleton(); |
88 | CRM_Utils_File::sourceSQLFile($config->dsn, dirname(__FILE__) . "/{$dataSet}"); | |
89 | ||
4be6c8f8 | 90 | $reportCsvFile = $this->getReportOutputAsCsv($reportClass, $inputParams); |
ae555e90 DS |
91 | $reportCsvArray = $this->getArrayFromCsv($reportCsvFile); |
92 | ||
93 | $expectedOutputCsvArray = $this->getArrayFromCsv(dirname(__FILE__) . "/{$expectedOutputCsvFile}"); | |
3b608e05 | 94 | $this->assertCsvArraysEqual($expectedOutputCsvArray, $reportCsvArray); |
ae555e90 DS |
95 | } |
96 | } |