|
@@ 35-41 (lines=7) @@
|
| 32 |
|
return require 'data/Calculation/DateTime/DATE.php'; |
| 33 |
|
} |
| 34 |
|
|
| 35 |
|
public function testDATEtoPHP() |
| 36 |
|
{ |
| 37 |
|
Functions::setReturnDateType(Functions::RETURNDATE_PHP_NUMERIC); |
| 38 |
|
$result = DateTime::DATE(2012, 1, 31); |
| 39 |
|
Functions::setReturnDateType(Functions::RETURNDATE_EXCEL); |
| 40 |
|
$this->assertEquals(1327968000, $result, null, 1E-8); |
| 41 |
|
} |
| 42 |
|
|
| 43 |
|
public function testDATEtoPHPObject() |
| 44 |
|
{ |
|
@@ 88-94 (lines=7) @@
|
| 85 |
|
return require 'data/Calculation/DateTime/DATEVALUE.php'; |
| 86 |
|
} |
| 87 |
|
|
| 88 |
|
public function testDATEVALUEtoPHP() |
| 89 |
|
{ |
| 90 |
|
Functions::setReturnDateType(Functions::RETURNDATE_PHP_NUMERIC); |
| 91 |
|
$result = DateTime::DATEVALUE('2012-1-31'); |
| 92 |
|
Functions::setReturnDateType(Functions::RETURNDATE_EXCEL); |
| 93 |
|
$this->assertEquals(1327968000, $result, null, 1E-8); |
| 94 |
|
} |
| 95 |
|
|
| 96 |
|
public function testDATEVALUEtoPHPObject() |
| 97 |
|
{ |
|
@@ 211-219 (lines=9) @@
|
| 208 |
|
return require 'data/Calculation/DateTime/TIME.php'; |
| 209 |
|
} |
| 210 |
|
|
| 211 |
|
public function testTIMEtoPHP() |
| 212 |
|
{ |
| 213 |
|
$this->markTestIncomplete('TODO: This test should be fixed'); |
| 214 |
|
|
| 215 |
|
Functions::setReturnDateType(Functions::RETURNDATE_PHP_NUMERIC); |
| 216 |
|
$result = DateTime::TIME(7, 30, 20); |
| 217 |
|
Functions::setReturnDateType(Functions::RETURNDATE_EXCEL); |
| 218 |
|
$this->assertEquals(27020, $result, null, 1E-8); |
| 219 |
|
} |
| 220 |
|
|
| 221 |
|
public function testTIMEtoPHPObject() |
| 222 |
|
{ |
|
@@ 250-258 (lines=9) @@
|
| 247 |
|
return require 'data/Calculation/DateTime/TIMEVALUE.php'; |
| 248 |
|
} |
| 249 |
|
|
| 250 |
|
public function testTIMEVALUEtoPHP() |
| 251 |
|
{ |
| 252 |
|
$this->markTestIncomplete('TODO: This test should be fixed'); |
| 253 |
|
|
| 254 |
|
Functions::setReturnDateType(Functions::RETURNDATE_PHP_NUMERIC); |
| 255 |
|
$result = DateTime::TIMEVALUE('7:30:20'); |
| 256 |
|
Functions::setReturnDateType(Functions::RETURNDATE_EXCEL); |
| 257 |
|
$this->assertEquals(23420, $result, null, 1E-8); |
| 258 |
|
} |
| 259 |
|
|
| 260 |
|
public function testTIMEVALUEtoPHPObject() |
| 261 |
|
{ |
|
@@ 373-379 (lines=7) @@
|
| 370 |
|
return require 'data/Calculation/DateTime/EDATE.php'; |
| 371 |
|
} |
| 372 |
|
|
| 373 |
|
public function testEDATEtoPHP() |
| 374 |
|
{ |
| 375 |
|
Functions::setReturnDateType(Functions::RETURNDATE_PHP_NUMERIC); |
| 376 |
|
$result = DateTime::EDATE('2012-1-26', -1); |
| 377 |
|
Functions::setReturnDateType(Functions::RETURNDATE_EXCEL); |
| 378 |
|
$this->assertEquals(1324857600, $result, null, 1E-8); |
| 379 |
|
} |
| 380 |
|
|
| 381 |
|
public function testEDATEtoPHPObject() |
| 382 |
|
{ |
|
@@ 410-416 (lines=7) @@
|
| 407 |
|
return require 'data/Calculation/DateTime/EOMONTH.php'; |
| 408 |
|
} |
| 409 |
|
|
| 410 |
|
public function testEOMONTHtoPHP() |
| 411 |
|
{ |
| 412 |
|
Functions::setReturnDateType(Functions::RETURNDATE_PHP_NUMERIC); |
| 413 |
|
$result = DateTime::EOMONTH('2012-1-26', -1); |
| 414 |
|
Functions::setReturnDateType(Functions::RETURNDATE_EXCEL); |
| 415 |
|
$this->assertEquals(1325289600, $result, null, 1E-8); |
| 416 |
|
} |
| 417 |
|
|
| 418 |
|
public function testEOMONTHtoPHPObject() |
| 419 |
|
{ |
PHPOffice /
PhpSpreadsheet
