tests/phpunit/CRM/Report/Form/Contribute/DetailTest.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/CiviReportTestCase.php';
  29
  30 /**
  31  *  Test report outcome
  32  *
  33  * @package CiviCRM
  34  */
  35 class CRM_Report_Form_Contribute_DetailTest extends CiviReportTestCase {
  36   protected $_tablesToTruncate = array(
  37     'civicrm_contact',
  38     'civicrm_email',
  39     'civicrm_phone',
  40     'civicrm_address',
  41     'civicrm_contribution',
  42   );
  43
  44   /**
  45    * @return array
  46    */
  47   public function dataProvider() {
  48     return array(
  49       array(
  50         'CRM_Report_Form_Contribute_Detail',
  51         array(
  52           'fields' => array(
  53             'sort_name',
  54             'first_name',
  55             'email',
  56             'total_amount',
  57           ),
  58           'filters' => array(
  59             'total_amount_op' => 'gte',
  60             'total_amount_value' => 50,
  61           ),
  62           // FIXME: add filters
  63         ),
  64         'fixtures/dataset-ascii.sql',
  65         'fixtures/report-ascii.csv',
  66       ),
  67     );
  68   }
  69
  70   public function setUp() {
  71     parent::setUp();
  72     $this->foreignKeyChecksOff();
  73     $this->quickCleanup($this->_tablesToTruncate);
  74   }
  75
  76   public function tearDown() {
  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');
  81   }
  82
  83   /**
  84    * @dataProvider dataProvider
  85    * @param $reportClass
  86    * @param $inputParams
  87    * @param $dataSet
  88    * @param $expectedOutputCsvFile
  89    * @throws \Exception
  90    */
  91   public function testReportOutput($reportClass, $inputParams, $dataSet, $expectedOutputCsvFile) {
  92     $config = CRM_Core_Config::singleton();
  93     CRM_Utils_File::sourceSQLFile($config->dsn, dirname(__FILE__) . "/{$dataSet}");
  94
  95     $reportCsvFile = $this->getReportOutputAsCsv($reportClass, $inputParams);
  96     $reportCsvArray = $this->getArrayFromCsv($reportCsvFile);
  97
  98     $expectedOutputCsvArray = $this->getArrayFromCsv(dirname(__FILE__) . "/{$expectedOutputCsvFile}");
  99     $this->assertCsvArraysEqual($expectedOutputCsvArray, $reportCsvArray);
 100   }
 101
 102 }