123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517 |
- <?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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-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, 1E-8);
- }
- public function providerXIRR()
- {
- return new testDataFileIterator('rawTestData/Calculation/Financial/XIRR.data');
- }
- }
|