class FinancialTest in Loft Data Grids 7.2

Same name and namespace in other branches

6.2 vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/FinancialTest.php \FinancialTest

Hierarchy

class \FinancialTest extends \PHPUnit_Framework_TestCase

Expanded class hierarchy of FinancialTest

File

vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/FinancialTest.php, line 6

View source

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');
  }

}

Members

Name	Modifiers	Type	Description
FinancialTest::providerACCRINT	public	function
FinancialTest::providerACCRINTM	public	function
FinancialTest::providerAMORDEGRC	public	function
FinancialTest::providerAMORLINC	public	function
FinancialTest::providerCOUPDAYBS	public	function
FinancialTest::providerCOUPDAYS	public	function
FinancialTest::providerCOUPDAYSNC	public	function
FinancialTest::providerCOUPNCD	public	function
FinancialTest::providerCOUPNUM	public	function
FinancialTest::providerCOUPPCD	public	function
FinancialTest::providerCUMIPMT	public	function
FinancialTest::providerCUMPRINC	public	function
FinancialTest::providerDB	public	function
FinancialTest::providerDDB	public	function
FinancialTest::providerDISC	public	function
FinancialTest::providerDOLLARDE	public	function
FinancialTest::providerDOLLARFR	public	function
FinancialTest::providerEFFECT	public	function
FinancialTest::providerFV	public	function
FinancialTest::providerFVSCHEDULE	public	function
FinancialTest::providerINTRATE	public	function
FinancialTest::providerIPMT	public	function
FinancialTest::providerIRR	public	function
FinancialTest::providerISPMT	public	function
FinancialTest::providerMIRR	public	function
FinancialTest::providerNOMINAL	public	function
FinancialTest::providerNPER	public	function
FinancialTest::providerNPV	public	function
FinancialTest::providerPRICE	public	function
FinancialTest::providerRATE	public	function
FinancialTest::providerXIRR	public	function
FinancialTest::setUp	public	function
FinancialTest::testACCRINT	public	function	@dataProvider providerACCRINT
FinancialTest::testACCRINTM	public	function	@dataProvider providerACCRINTM
FinancialTest::testAMORDEGRC	public	function	@dataProvider providerAMORDEGRC
FinancialTest::testAMORLINC	public	function	@dataProvider providerAMORLINC
FinancialTest::testCOUPDAYBS	public	function	@dataProvider providerCOUPDAYBS
FinancialTest::testCOUPDAYS	public	function	@dataProvider providerCOUPDAYS
FinancialTest::testCOUPDAYSNC	public	function	@dataProvider providerCOUPDAYSNC
FinancialTest::testCOUPNCD	public	function	@dataProvider providerCOUPNCD
FinancialTest::testCOUPNUM	public	function	@dataProvider providerCOUPNUM
FinancialTest::testCOUPPCD	public	function	@dataProvider providerCOUPPCD
FinancialTest::testCUMIPMT	public	function	@dataProvider providerCUMIPMT
FinancialTest::testCUMPRINC	public	function	@dataProvider providerCUMPRINC
FinancialTest::testDB	public	function	@dataProvider providerDB
FinancialTest::testDDB	public	function	@dataProvider providerDDB
FinancialTest::testDISC	public	function	@dataProvider providerDISC
FinancialTest::testDOLLARDE	public	function	@dataProvider providerDOLLARDE
FinancialTest::testDOLLARFR	public	function	@dataProvider providerDOLLARFR
FinancialTest::testEFFECT	public	function	@dataProvider providerEFFECT
FinancialTest::testFV	public	function	@dataProvider providerFV
FinancialTest::testFVSCHEDULE	public	function	@dataProvider providerFVSCHEDULE
FinancialTest::testINTRATE	public	function	@dataProvider providerINTRATE
FinancialTest::testIPMT	public	function	@dataProvider providerIPMT
FinancialTest::testIRR	public	function	@dataProvider providerIRR
FinancialTest::testISPMT	public	function	@dataProvider providerISPMT
FinancialTest::testMIRR	public	function	@dataProvider providerMIRR
FinancialTest::testNOMINAL	public	function	@dataProvider providerNOMINAL
FinancialTest::testNPER	public	function	@dataProvider providerNPER
FinancialTest::testNPV	public	function	@dataProvider providerNPV
FinancialTest::testPRICE	public	function	@dataProvider providerPRICE
FinancialTest::testRATE	public	function	@dataProvider providerRATE
FinancialTest::testXIRR	public	function	@dataProvider providerXIRR

You are here

class FinancialTest in Loft Data Grids 7.2

Hierarchy

File

Members

API Navigation