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.sql',
  61         'fixtures/report.csv',
  62       ),
  63     );
  64   }
  65
  66   function setUp() {
  67     parent::setUp();
  68   }
  69
  70   function tearDown() {}
  71
  72   /**
  73    *  @dataProvider dataProvider
  74    */
  75   public function testReportOutput($reportClass, $inputParams, $dataSet, $expectedOutputCsvFile) {
  76     $this->foreignKeyChecksOff();
  77
  78     $this->quickCleanup(self::$_tablesToTruncate);
  79
  80     $config = CRM_Core_Config::singleton();
  81     CRM_Utils_File::sourceSQLFile($config->dsn, dirname(__FILE__) . "/{$dataSet}");
  82
  83     $reportCsvFile  = $this->getReportOutputAsCsv($reportClass, $inputParams);
  84     $reportCsvArray = $this->getArrayFromCsv($reportCsvFile);
  85
  86     $expectedOutputCsvArray = $this->getArrayFromCsv(dirname(__FILE__) . "/{$expectedOutputCsvFile}");
  87     $this->assertEquals(count($reportCsvArray[0]), count($expectedOutputCsvArray[0]), 'In line ' . __LINE__);
  88
  89     foreach($reportCsvArray as $intKey => $strVal) {
  90       $this->assertNotNull($expectedOutputCsvArray[$intKey], 'In line ' . __LINE__);
  91       $this->assertEquals($expectedOutputCsvArray[$intKey], $strVal);
  92     }
  93   }
  94 }