You are here

FinancialTest.php in Loft Data Grids 6.2

File

vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/FinancialTest.php
View source
<?php

require_once 'testDataFileIterator.php';
class FinancialTest extends PHPUnit_Framework_TestCase {
  public function setUp() {
    if (!defined('PHPEXCEL_ROOT')) {
      define('PHPEXCEL_ROOT', APPLICATION_PATH . '/');
    }
    require_once PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php';
    PHPExcel_Calculation_Functions::setCompatibilityMode(PHPExcel_Calculation_Functions::COMPATIBILITY_EXCEL);
  }

  /**
   * @dataProvider providerACCRINT
   */
  public function testACCRINT() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'ACCRINT',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerACCRINT() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/ACCRINT.data');
  }

  /**
   * @dataProvider providerACCRINTM
   */
  public function testACCRINTM() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'ACCRINTM',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerACCRINTM() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/ACCRINTM.data');
  }

  /**
   * @dataProvider providerAMORDEGRC
   */
  public function testAMORDEGRC() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'AMORDEGRC',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerAMORDEGRC() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/AMORDEGRC.data');
  }

  /**
   * @dataProvider providerAMORLINC
   */
  public function testAMORLINC() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'AMORLINC',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerAMORLINC() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/AMORLINC.data');
  }

  /**
   * @dataProvider providerCOUPDAYBS
   */
  public function testCOUPDAYBS() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'COUPDAYBS',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerCOUPDAYBS() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/COUPDAYBS.data');
  }

  /**
   * @dataProvider providerCOUPDAYS
   */
  public function testCOUPDAYS() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'COUPDAYS',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerCOUPDAYS() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/COUPDAYS.data');
  }

  /**
   * @dataProvider providerCOUPDAYSNC
   */
  public function testCOUPDAYSNC() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'COUPDAYSNC',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerCOUPDAYSNC() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/COUPDAYSNC.data');
  }

  /**
   * @dataProvider providerCOUPNCD
   */
  public function testCOUPNCD() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'COUPNCD',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerCOUPNCD() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/COUPNCD.data');
  }

  /**
   * @dataProvider providerCOUPNUM
   */
  public function testCOUPNUM() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'COUPNUM',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerCOUPNUM() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/COUPNUM.data');
  }

  /**
   * @dataProvider providerCOUPPCD
   */
  public function testCOUPPCD() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'COUPPCD',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerCOUPPCD() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/COUPPCD.data');
  }

  /**
   * @dataProvider providerCUMIPMT
   */
  public function testCUMIPMT() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'CUMIPMT',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerCUMIPMT() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/CUMIPMT.data');
  }

  /**
   * @dataProvider providerCUMPRINC
   */
  public function testCUMPRINC() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'CUMPRINC',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerCUMPRINC() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/CUMPRINC.data');
  }

  /**
   * @dataProvider providerDB
   */
  public function testDB() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'DB',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerDB() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/DB.data');
  }

  /**
   * @dataProvider providerDDB
   */
  public function testDDB() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'DDB',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerDDB() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/DDB.data');
  }

  /**
   * @dataProvider providerDISC
   */
  public function testDISC() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'DISC',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerDISC() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/DISC.data');
  }

  /**
   * @dataProvider providerDOLLARDE
   */
  public function testDOLLARDE() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'DOLLARDE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerDOLLARDE() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/DOLLARDE.data');
  }

  /**
   * @dataProvider providerDOLLARFR
   */
  public function testDOLLARFR() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'DOLLARFR',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerDOLLARFR() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/DOLLARFR.data');
  }

  /**
   * @dataProvider providerEFFECT
   */
  public function testEFFECT() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'EFFECT',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerEFFECT() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/EFFECT.data');
  }

  /**
   * @dataProvider providerFV
   */
  public function testFV() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'FV',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerFV() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/FV.data');
  }

  /**
   * @dataProvider providerFVSCHEDULE
   */
  public function testFVSCHEDULE() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'FVSCHEDULE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerFVSCHEDULE() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/FVSCHEDULE.data');
  }

  /**
   * @dataProvider providerINTRATE
   */
  public function testINTRATE() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'INTRATE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerINTRATE() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/INTRATE.data');
  }

  /**
   * @dataProvider providerIPMT
   */
  public function testIPMT() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'IPMT',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerIPMT() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/IPMT.data');
  }

  /**
   * @dataProvider providerIRR
   */
  public function testIRR() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'IRR',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerIRR() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/IRR.data');
  }

  /**
   * @dataProvider providerISPMT
   */
  public function testISPMT() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'ISPMT',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerISPMT() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/ISPMT.data');
  }

  /**
   * @dataProvider providerMIRR
   */
  public function testMIRR() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'MIRR',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerMIRR() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/MIRR.data');
  }

  /**
   * @dataProvider providerNOMINAL
   */
  public function testNOMINAL() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'NOMINAL',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerNOMINAL() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/NOMINAL.data');
  }

  /**
   * @dataProvider providerNPER
   */
  public function testNPER() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'NPER',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerNPER() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/NPER.data');
  }

  /**
   * @dataProvider providerNPV
   */
  public function testNPV() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'NPV',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerNPV() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/NPV.data');
  }

  /**
   * @dataProvider providerPRICE
   */
  public function testPRICE() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'PRICE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerPRICE() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/PRICE.data');
  }

  /**
   * @dataProvider providerRATE
   */
  public function testRATE() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'RATE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerRATE() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/RATE.data');
  }

  /**
   * @dataProvider providerXIRR
   */
  public function testXIRR() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Financial',
      'XIRR',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerXIRR() {
    return new testDataFileIterator('rawTestData/Calculation/Financial/XIRR.data');
  }

}

Classes

Namesort descending Description
FinancialTest