tests/phpunit/CRM/Report/Form/Contribute/DetailTest.php

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