ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
Public Member Functions
DateTimeTest Class Reference
+ Inheritance diagram for DateTimeTest:
+ Collaboration diagram for DateTimeTest:

Public Member Functions

 setUp ()
 
 testDATE ()
 @dataProvider providerDATE More...
 
 providerDATE ()
 
 testDATEtoPHP ()
 
 testDATEtoPHPObject ()
 
 testDATEwith1904Calendar ()
 
 testDATEwith1904CalendarError ()
 
 testDATEVALUE ()
 @dataProvider providerDATEVALUE More...
 
 providerDATEVALUE ()
 
 testDATEVALUEtoPHP ()
 
 testDATEVALUEtoPHPObject ()
 
 testYEAR ()
 @dataProvider providerYEAR More...
 
 providerYEAR ()
 
 testMONTH ()
 @dataProvider providerMONTH More...
 
 providerMONTH ()
 
 testWEEKNUM ()
 @dataProvider providerWEEKNUM More...
 
 providerWEEKNUM ()
 
 testWEEKDAY ()
 @dataProvider providerWEEKDAY More...
 
 providerWEEKDAY ()
 
 testDAY ()
 @dataProvider providerDAY More...
 
 providerDAY ()
 
 testTIME ()
 @dataProvider providerTIME More...
 
 providerTIME ()
 
 testTIMEtoPHP ()
 
 testTIMEtoPHPObject ()
 
 testTIMEVALUE ()
 @dataProvider providerTIMEVALUE More...
 
 providerTIMEVALUE ()
 
 testTIMEVALUEtoPHP ()
 
 testTIMEVALUEtoPHPObject ()
 
 testHOUR ()
 @dataProvider providerHOUR More...
 
 providerHOUR ()
 
 testMINUTE ()
 @dataProvider providerMINUTE More...
 
 providerMINUTE ()
 
 testSECOND ()
 @dataProvider providerSECOND More...
 
 providerSECOND ()
 
 testNETWORKDAYS ()
 @dataProvider providerNETWORKDAYS More...
 
 providerNETWORKDAYS ()
 
 testWORKDAY ()
 @dataProvider providerWORKDAY More...
 
 providerWORKDAY ()
 
 testEDATE ()
 @dataProvider providerEDATE More...
 
 providerEDATE ()
 
 testEDATEtoPHP ()
 
 testEDATEtoPHPObject ()
 
 testEOMONTH ()
 @dataProvider providerEOMONTH More...
 
 providerEOMONTH ()
 
 testEOMONTHtoPHP ()
 
 testEOMONTHtoPHPObject ()
 
 testDATEDIF ()
 @dataProvider providerDATEDIF More...
 
 providerDATEDIF ()
 
 testDAYS360 ()
 @dataProvider providerDAYS360 More...
 
 providerDAYS360 ()
 
 testYEARFRAC ()
 @dataProvider providerYEARFRAC More...
 
 providerYEARFRAC ()
 

Detailed Description

Definition at line 6 of file DateTimeTest.php.

Member Function Documentation

◆ providerDATE()

DateTimeTest::providerDATE ( )

Definition at line 31 of file DateTimeTest.php.

32 {
33 return new testDataFileIterator('rawTestData/Calculation/DateTime/DATE.data');
34 }

◆ providerDATEDIF()

DateTimeTest::providerDATEDIF ( )

Definition at line 429 of file DateTimeTest.php.

430 {
431 return new testDataFileIterator('rawTestData/Calculation/DateTime/DATEDIF.data');
432 }

◆ providerDATEVALUE()

DateTimeTest::providerDATEVALUE ( )

Definition at line 84 of file DateTimeTest.php.

85 {
86 return new testDataFileIterator('rawTestData/Calculation/DateTime/DATEVALUE.data');
87 }

◆ providerDAY()

DateTimeTest::providerDAY ( )

Definition at line 185 of file DateTimeTest.php.

186 {
187 return new testDataFileIterator('rawTestData/Calculation/DateTime/DAY.data');
188 }

◆ providerDAYS360()

DateTimeTest::providerDAYS360 ( )

Definition at line 445 of file DateTimeTest.php.

446 {
447 return new testDataFileIterator('rawTestData/Calculation/DateTime/DAYS360.data');
448 }

◆ providerEDATE()

DateTimeTest::providerEDATE ( )

Definition at line 355 of file DateTimeTest.php.

356 {
357 return new testDataFileIterator('rawTestData/Calculation/DateTime/EDATE.data');
358 }

◆ providerEOMONTH()

DateTimeTest::providerEOMONTH ( )

Definition at line 392 of file DateTimeTest.php.

393 {
394 return new testDataFileIterator('rawTestData/Calculation/DateTime/EOMONTH.data');
395 }

◆ providerHOUR()

DateTimeTest::providerHOUR ( )

Definition at line 275 of file DateTimeTest.php.

276 {
277 return new testDataFileIterator('rawTestData/Calculation/DateTime/HOUR.data');
278 }

◆ providerMINUTE()

DateTimeTest::providerMINUTE ( )

Definition at line 291 of file DateTimeTest.php.

292 {
293 return new testDataFileIterator('rawTestData/Calculation/DateTime/MINUTE.data');
294 }

◆ providerMONTH()

DateTimeTest::providerMONTH ( )

Definition at line 137 of file DateTimeTest.php.

138 {
139 return new testDataFileIterator('rawTestData/Calculation/DateTime/MONTH.data');
140 }

◆ providerNETWORKDAYS()

DateTimeTest::providerNETWORKDAYS ( )

Definition at line 323 of file DateTimeTest.php.

324 {
325 return new testDataFileIterator('rawTestData/Calculation/DateTime/NETWORKDAYS.data');
326 }

◆ providerSECOND()

DateTimeTest::providerSECOND ( )

Definition at line 307 of file DateTimeTest.php.

308 {
309 return new testDataFileIterator('rawTestData/Calculation/DateTime/SECOND.data');
310 }

◆ providerTIME()

DateTimeTest::providerTIME ( )

Definition at line 201 of file DateTimeTest.php.

202 {
203 return new testDataFileIterator('rawTestData/Calculation/DateTime/TIME.data');
204 }

◆ providerTIMEVALUE()

DateTimeTest::providerTIMEVALUE ( )

Definition at line 238 of file DateTimeTest.php.

239 {
240 return new testDataFileIterator('rawTestData/Calculation/DateTime/TIMEVALUE.data');
241 }

◆ providerWEEKDAY()

DateTimeTest::providerWEEKDAY ( )

Definition at line 169 of file DateTimeTest.php.

170 {
171 return new testDataFileIterator('rawTestData/Calculation/DateTime/WEEKDAY.data');
172 }

◆ providerWEEKNUM()

DateTimeTest::providerWEEKNUM ( )

Definition at line 153 of file DateTimeTest.php.

154 {
155 return new testDataFileIterator('rawTestData/Calculation/DateTime/WEEKNUM.data');
156 }

◆ providerWORKDAY()

DateTimeTest::providerWORKDAY ( )

Definition at line 339 of file DateTimeTest.php.

340 {
341 return new testDataFileIterator('rawTestData/Calculation/DateTime/WORKDAY.data');
342 }

◆ providerYEAR()

DateTimeTest::providerYEAR ( )

Definition at line 121 of file DateTimeTest.php.

122 {
123 return new testDataFileIterator('rawTestData/Calculation/DateTime/YEAR.data');
124 }

◆ providerYEARFRAC()

DateTimeTest::providerYEARFRAC ( )

Definition at line 461 of file DateTimeTest.php.

462 {
463 return new testDataFileIterator('rawTestData/Calculation/DateTime/YEARFRAC.data');
464 }

◆ setUp()

DateTimeTest::setUp ( )

Definition at line 9 of file DateTimeTest.php.

10 {
11 if (!defined('PHPEXCEL_ROOT'))
12 {
13 define('PHPEXCEL_ROOT', APPLICATION_PATH . '/');
14 }
15 require_once(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
16
17 PHPExcel_Calculation_Functions::setCompatibilityMode(PHPExcel_Calculation_Functions::COMPATIBILITY_EXCEL);
18 }
PHPExcel_Calculation_Functions\COMPATIBILITY_EXCEL
const COMPATIBILITY_EXCEL
constants
Definition: Functions.php:62
PHPExcel_Calculation_Functions\setCompatibilityMode
static setCompatibilityMode($compatibilityMode)
Definition: Functions.php:116
defined
defined( 'APPLICATION_ENV')||define( 'APPLICATION_ENV'
Definition: bootstrap.php:27

References PHPExcel_Calculation_Functions\COMPATIBILITY_EXCEL, defined, and PHPExcel_Calculation_Functions\setCompatibilityMode().

+ Here is the call graph for this function:

◆ testDATE()

DateTimeTest::testDATE ( )

@dataProvider providerDATE

Definition at line 23 of file DateTimeTest.php.

24 {
25 $args = func_get_args();
26 $expectedResult = array_pop($args);
27 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','DATE'),$args);
28 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
29 }
$result
$result
Definition: CleanUpTest.php:463

References $result.

◆ testDATEDIF()

DateTimeTest::testDATEDIF ( )

@dataProvider providerDATEDIF

Definition at line 421 of file DateTimeTest.php.

422 {
423 $args = func_get_args();
424 $expectedResult = array_pop($args);
425 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','DATEDIF'),$args);
426 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
427 }

References $result.

◆ testDATEtoPHP()

DateTimeTest::testDATEtoPHP ( )

Definition at line 36 of file DateTimeTest.php.

37 {
38 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
39 $result = PHPExcel_Calculation_DateTime::DATE(2012,1,31);
40 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
41 $this->assertEquals(1327968000, $result, NULL, 1E-8);
42 }
PHPExcel_Calculation_DateTime\DATE
static DATE($year=0, $month=1, $day=1)
Definition: DateTime.php:292
PHPExcel_Calculation_Functions\setReturnDateType
static setReturnDateType($returnDateType)
Definition: Functions.php:155
PHPExcel_Calculation_Functions\RETURNDATE_EXCEL
const RETURNDATE_EXCEL
Definition: Functions.php:68
PHPExcel_Calculation_Functions\RETURNDATE_PHP_NUMERIC
const RETURNDATE_PHP_NUMERIC
Definition: Functions.php:66

References $result, PHPExcel_Calculation_DateTime\DATE(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_NUMERIC, and PHPExcel_Calculation_Functions\setReturnDateType().

+ Here is the call graph for this function:

◆ testDATEtoPHPObject()

DateTimeTest::testDATEtoPHPObject ( )

Definition at line 44 of file DateTimeTest.php.

45 {
46 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
47 $result = PHPExcel_Calculation_DateTime::DATE(2012,1,31);
48 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
49 // Must return an object...
50 $this->assertTrue(is_object($result));
51 // ... of the correct type
52 $this->assertTrue(is_a($result,'DateTime'));
53 // ... with the correct value
54 $this->assertEquals($result->format('d-M-Y'),'31-Jan-2012');
55 }
PHPExcel_Calculation_Functions\RETURNDATE_PHP_OBJECT
const RETURNDATE_PHP_OBJECT
Definition: Functions.php:67

References $result, PHPExcel_Calculation_DateTime\DATE(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_OBJECT, and PHPExcel_Calculation_Functions\setReturnDateType().

+ Here is the call graph for this function:

◆ testDATEVALUE()

DateTimeTest::testDATEVALUE ( )

@dataProvider providerDATEVALUE

Definition at line 76 of file DateTimeTest.php.

77 {
78 $args = func_get_args();
79 $expectedResult = array_pop($args);
80 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','DATEVALUE'),$args);
81 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
82 }

References $result.

◆ testDATEVALUEtoPHP()

DateTimeTest::testDATEVALUEtoPHP ( )

Definition at line 89 of file DateTimeTest.php.

90 {
91 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
92 $result = PHPExcel_Calculation_DateTime::DATEVALUE('2012-1-31');
93 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
94 $this->assertEquals(1327968000, $result, NULL, 1E-8);
95 }
PHPExcel_Calculation_DateTime\DATEVALUE
static DATEVALUE($dateValue=1)
Definition: DateTime.php:481

References $result, PHPExcel_Calculation_DateTime\DATEVALUE(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_NUMERIC, and PHPExcel_Calculation_Functions\setReturnDateType().

+ Here is the call graph for this function:

◆ testDATEVALUEtoPHPObject()

DateTimeTest::testDATEVALUEtoPHPObject ( )

Definition at line 97 of file DateTimeTest.php.

98 {
99 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
100 $result = PHPExcel_Calculation_DateTime::DATEVALUE('2012-1-31');
101 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
102 // Must return an object...
103 $this->assertTrue(is_object($result));
104 // ... of the correct type
105 $this->assertTrue(is_a($result,'DateTime'));
106 // ... with the correct value
107 $this->assertEquals($result->format('d-M-Y'),'31-Jan-2012');
108 }

References $result, PHPExcel_Calculation_DateTime\DATEVALUE(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_OBJECT, and PHPExcel_Calculation_Functions\setReturnDateType().

+ Here is the call graph for this function:

◆ testDATEwith1904Calendar()

DateTimeTest::testDATEwith1904Calendar ( )

Definition at line 57 of file DateTimeTest.php.

58 {
59 PHPExcel_Shared_Date::setExcelCalendar(PHPExcel_Shared_Date::CALENDAR_MAC_1904);
60 $result = PHPExcel_Calculation_DateTime::DATE(1918,11,11);
61 PHPExcel_Shared_Date::setExcelCalendar(PHPExcel_Shared_Date::CALENDAR_WINDOWS_1900);
62 $this->assertEquals($result,5428);
63 }
PHPExcel_Shared_Date\setExcelCalendar
static setExcelCalendar($baseDate)
Set the Excel calendar (Windows 1900 or Mac 1904)
Definition: Date.php:91
PHPExcel_Shared_Date\CALENDAR_MAC_1904
const CALENDAR_MAC_1904
Definition: Date.php:41
PHPExcel_Shared_Date\CALENDAR_WINDOWS_1900
const CALENDAR_WINDOWS_1900
constants
Definition: Date.php:40

References $result, PHPExcel_Shared_Date\CALENDAR_MAC_1904, PHPExcel_Shared_Date\CALENDAR_WINDOWS_1900, PHPExcel_Calculation_DateTime\DATE(), and PHPExcel_Shared_Date\setExcelCalendar().

+ Here is the call graph for this function:

◆ testDATEwith1904CalendarError()

DateTimeTest::testDATEwith1904CalendarError ( )

Definition at line 65 of file DateTimeTest.php.

66 {
67 PHPExcel_Shared_Date::setExcelCalendar(PHPExcel_Shared_Date::CALENDAR_MAC_1904);
68 $result = PHPExcel_Calculation_DateTime::DATE(1901,1,31);
69 PHPExcel_Shared_Date::setExcelCalendar(PHPExcel_Shared_Date::CALENDAR_WINDOWS_1900);
70 $this->assertEquals($result,'#NUM!');
71 }

References $result, PHPExcel_Shared_Date\CALENDAR_MAC_1904, PHPExcel_Shared_Date\CALENDAR_WINDOWS_1900, PHPExcel_Calculation_DateTime\DATE(), and PHPExcel_Shared_Date\setExcelCalendar().

+ Here is the call graph for this function:

◆ testDAY()

DateTimeTest::testDAY ( )

@dataProvider providerDAY

Definition at line 177 of file DateTimeTest.php.

178 {
179 $args = func_get_args();
180 $expectedResult = array_pop($args);
181 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','DAYOFMONTH'),$args);
182 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
183 }

References $result.

◆ testDAYS360()

DateTimeTest::testDAYS360 ( )

@dataProvider providerDAYS360

Definition at line 437 of file DateTimeTest.php.

438 {
439 $args = func_get_args();
440 $expectedResult = array_pop($args);
441 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','DAYS360'),$args);
442 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
443 }

References $result.

◆ testEDATE()

DateTimeTest::testEDATE ( )

@dataProvider providerEDATE

Definition at line 347 of file DateTimeTest.php.

348 {
349 $args = func_get_args();
350 $expectedResult = array_pop($args);
351 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','EDATE'),$args);
352 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
353 }

References $result.

◆ testEDATEtoPHP()

DateTimeTest::testEDATEtoPHP ( )

Definition at line 360 of file DateTimeTest.php.

361 {
362 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
363 $result = PHPExcel_Calculation_DateTime::EDATE('2012-1-26',-1);
364 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
365 $this->assertEquals(1324857600, $result, NULL, 1E-8);
366 }
PHPExcel_Calculation_DateTime\EDATE
static EDATE($dateValue=1, $adjustmentMonths=0)
EDATE.
Definition: DateTime.php:1410

References $result, PHPExcel_Calculation_DateTime\EDATE(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_NUMERIC, and PHPExcel_Calculation_Functions\setReturnDateType().

+ Here is the call graph for this function:

◆ testEDATEtoPHPObject()

DateTimeTest::testEDATEtoPHPObject ( )

Definition at line 368 of file DateTimeTest.php.

369 {
370 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
371 $result = PHPExcel_Calculation_DateTime::EDATE('2012-1-26',-1);
372 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
373 // Must return an object...
374 $this->assertTrue(is_object($result));
375 // ... of the correct type
376 $this->assertTrue(is_a($result,'DateTime'));
377 // ... with the correct value
378 $this->assertEquals($result->format('d-M-Y'),'26-Dec-2011');
379 }

References $result, PHPExcel_Calculation_DateTime\EDATE(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_OBJECT, and PHPExcel_Calculation_Functions\setReturnDateType().

+ Here is the call graph for this function:

◆ testEOMONTH()

DateTimeTest::testEOMONTH ( )

@dataProvider providerEOMONTH

Definition at line 384 of file DateTimeTest.php.

385 {
386 $args = func_get_args();
387 $expectedResult = array_pop($args);
388 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','EOMONTH'),$args);
389 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
390 }

References $result.

◆ testEOMONTHtoPHP()

DateTimeTest::testEOMONTHtoPHP ( )

Definition at line 397 of file DateTimeTest.php.

398 {
399 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
400 $result = PHPExcel_Calculation_DateTime::EOMONTH('2012-1-26',-1);
401 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
402 $this->assertEquals(1325289600, $result, NULL, 1E-8);
403 }
PHPExcel_Calculation_DateTime\EOMONTH
static EOMONTH($dateValue=1, $adjustmentMonths=0)
EOMONTH.
Definition: DateTime.php:1455

References $result, PHPExcel_Calculation_DateTime\EOMONTH(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_NUMERIC, and PHPExcel_Calculation_Functions\setReturnDateType().

+ Here is the call graph for this function:

◆ testEOMONTHtoPHPObject()

DateTimeTest::testEOMONTHtoPHPObject ( )

Definition at line 405 of file DateTimeTest.php.

406 {
407 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
408 $result = PHPExcel_Calculation_DateTime::EOMONTH('2012-1-26',-1);
409 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
410 // Must return an object...
411 $this->assertTrue(is_object($result));
412 // ... of the correct type
413 $this->assertTrue(is_a($result,'DateTime'));
414 // ... with the correct value
415 $this->assertEquals($result->format('d-M-Y'),'31-Dec-2011');
416 }

References $result, PHPExcel_Calculation_DateTime\EOMONTH(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_OBJECT, and PHPExcel_Calculation_Functions\setReturnDateType().

+ Here is the call graph for this function:

◆ testHOUR()

DateTimeTest::testHOUR ( )

@dataProvider providerHOUR

Definition at line 267 of file DateTimeTest.php.

268 {
269 $args = func_get_args();
270 $expectedResult = array_pop($args);
271 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','HOUROFDAY'),$args);
272 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
273 }

References $result.

◆ testMINUTE()

DateTimeTest::testMINUTE ( )

@dataProvider providerMINUTE

Definition at line 283 of file DateTimeTest.php.

284 {
285 $args = func_get_args();
286 $expectedResult = array_pop($args);
287 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','MINUTEOFHOUR'),$args);
288 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
289 }

References $result.

◆ testMONTH()

DateTimeTest::testMONTH ( )

@dataProvider providerMONTH

Definition at line 129 of file DateTimeTest.php.

130 {
131 $args = func_get_args();
132 $expectedResult = array_pop($args);
133 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','MONTHOFYEAR'),$args);
134 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
135 }

References $result.

◆ testNETWORKDAYS()

DateTimeTest::testNETWORKDAYS ( )

@dataProvider providerNETWORKDAYS

Definition at line 315 of file DateTimeTest.php.

316 {
317 $args = func_get_args();
318 $expectedResult = array_pop($args);
319 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','NETWORKDAYS'),$args);
320 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
321 }

References $result.

◆ testSECOND()

DateTimeTest::testSECOND ( )

@dataProvider providerSECOND

Definition at line 299 of file DateTimeTest.php.

300 {
301 $args = func_get_args();
302 $expectedResult = array_pop($args);
303 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','SECONDOFMINUTE'),$args);
304 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
305 }

References $result.

◆ testTIME()

DateTimeTest::testTIME ( )

@dataProvider providerTIME

Definition at line 193 of file DateTimeTest.php.

194 {
195 $args = func_get_args();
196 $expectedResult = array_pop($args);
197 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','TIME'),$args);
198 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
199 }

References $result.

◆ testTIMEtoPHP()

DateTimeTest::testTIMEtoPHP ( )

Definition at line 206 of file DateTimeTest.php.

207 {
208 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
209 $result = PHPExcel_Calculation_DateTime::TIME(7,30,20);
210 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
211 $this->assertEquals(27020, $result, NULL, 1E-8);
212 }
PHPExcel_Calculation_DateTime\TIME
static TIME($hour=0, $minute=0, $second=0)
Definition: DateTime.php:386

References $result, PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_NUMERIC, PHPExcel_Calculation_Functions\setReturnDateType(), and PHPExcel_Calculation_DateTime\TIME().

+ Here is the call graph for this function:

◆ testTIMEtoPHPObject()

DateTimeTest::testTIMEtoPHPObject ( )

Definition at line 214 of file DateTimeTest.php.

215 {
216 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
217 $result = PHPExcel_Calculation_DateTime::TIME(7,30,20);
218 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
219 // Must return an object...
220 $this->assertTrue(is_object($result));
221 // ... of the correct type
222 $this->assertTrue(is_a($result,'DateTime'));
223 // ... with the correct value
224 $this->assertEquals($result->format('H:i:s'),'07:30:20');
225 }

References $result, PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_OBJECT, PHPExcel_Calculation_Functions\setReturnDateType(), and PHPExcel_Calculation_DateTime\TIME().

+ Here is the call graph for this function:

◆ testTIMEVALUE()

DateTimeTest::testTIMEVALUE ( )

@dataProvider providerTIMEVALUE

Definition at line 230 of file DateTimeTest.php.

231 {
232 $args = func_get_args();
233 $expectedResult = array_pop($args);
234 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','TIMEVALUE'),$args);
235 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
236 }

References $result.

◆ testTIMEVALUEtoPHP()

DateTimeTest::testTIMEVALUEtoPHP ( )

Definition at line 243 of file DateTimeTest.php.

244 {
245 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
246 $result = PHPExcel_Calculation_DateTime::TIMEVALUE('7:30:20');
247 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
248 $this->assertEquals(23420, $result, NULL, 1E-8);
249 }
PHPExcel_Calculation_DateTime\TIMEVALUE
static TIMEVALUE($timeValue)
Definition: DateTime.php:583

References $result, PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_NUMERIC, PHPExcel_Calculation_Functions\setReturnDateType(), and PHPExcel_Calculation_DateTime\TIMEVALUE().

+ Here is the call graph for this function:

◆ testTIMEVALUEtoPHPObject()

DateTimeTest::testTIMEVALUEtoPHPObject ( )

Definition at line 251 of file DateTimeTest.php.

252 {
253 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
254 $result = PHPExcel_Calculation_DateTime::TIMEVALUE('7:30:20');
255 PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
256 // Must return an object...
257 $this->assertTrue(is_object($result));
258 // ... of the correct type
259 $this->assertTrue(is_a($result,'DateTime'));
260 // ... with the correct value
261 $this->assertEquals($result->format('H:i:s'),'07:30:20');
262 }

References $result, PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\RETURNDATE_PHP_OBJECT, PHPExcel_Calculation_Functions\setReturnDateType(), and PHPExcel_Calculation_DateTime\TIMEVALUE().

+ Here is the call graph for this function:

◆ testWEEKDAY()

DateTimeTest::testWEEKDAY ( )

@dataProvider providerWEEKDAY

Definition at line 161 of file DateTimeTest.php.

162 {
163 $args = func_get_args();
164 $expectedResult = array_pop($args);
165 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','DAYOFWEEK'),$args);
166 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
167 }

References $result.

◆ testWEEKNUM()

DateTimeTest::testWEEKNUM ( )

@dataProvider providerWEEKNUM

Definition at line 145 of file DateTimeTest.php.

146 {
147 $args = func_get_args();
148 $expectedResult = array_pop($args);
149 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','WEEKOFYEAR'),$args);
150 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
151 }

References $result.

◆ testWORKDAY()

DateTimeTest::testWORKDAY ( )

@dataProvider providerWORKDAY

Definition at line 331 of file DateTimeTest.php.

332 {
333 $args = func_get_args();
334 $expectedResult = array_pop($args);
335 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','WORKDAY'),$args);
336 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
337 }

References $result.

◆ testYEAR()

DateTimeTest::testYEAR ( )

@dataProvider providerYEAR

Definition at line 113 of file DateTimeTest.php.

114 {
115 $args = func_get_args();
116 $expectedResult = array_pop($args);
117 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','YEAR'),$args);
118 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
119 }

References $result.

◆ testYEARFRAC()

DateTimeTest::testYEARFRAC ( )

@dataProvider providerYEARFRAC

Definition at line 453 of file DateTimeTest.php.

454 {
455 $args = func_get_args();
456 $expectedResult = array_pop($args);
457 $result = call_user_func_array(array('PHPExcel_Calculation_DateTime','YEARFRAC'),$args);
458 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
459 }

References $result.

The documentation for this class was generated from the following file: