ILIAS  release_5-2 Revision v5.2.25-18-g3f80b82851
DateTimeTest Class Reference
+ Inheritance diagram for DateTimeTest:
+ Collaboration diagram for DateTimeTest:

Public Member Functions

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

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

10  {
11  if (!defined('PHPEXCEL_ROOT'))
12  {
13  define('PHPEXCEL_ROOT', APPLICATION_PATH . '/');
14  }
15  require_once(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
16 
18  }
const COMPATIBILITY_EXCEL
constants
Definition: Functions.php:62
defined( 'APPLICATION_ENV')||define( 'APPLICATION_ENV'
Definition: bootstrap.php:27
static setCompatibilityMode($compatibilityMode)
Definition: Functions.php:116
+ Here is the call graph for this function:

◆ testDATE()

DateTimeTest::testDATE ( )

providerDATE

Definition at line 23 of file DateTimeTest.php.

References $result, and array.

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
Create styles array
The data for the language used.

◆ testDATEDIF()

DateTimeTest::testDATEDIF ( )

providerDATEDIF

Definition at line 421 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testDATEtoPHP()

◆ testDATEtoPHPObject()

DateTimeTest::testDATEtoPHPObject ( )

Definition at line 44 of file DateTimeTest.php.

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

45  {
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  }
$result
static DATE($year=0, $month=1, $day=1)
Definition: DateTime.php:292
static setReturnDateType($returnDateType)
Definition: Functions.php:155
+ Here is the call graph for this function:

◆ testDATEVALUE()

DateTimeTest::testDATEVALUE ( )

providerDATEVALUE

Definition at line 76 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testDATEVALUEtoPHP()

◆ testDATEVALUEtoPHPObject()

DateTimeTest::testDATEVALUEtoPHPObject ( )

Definition at line 97 of file DateTimeTest.php.

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

98  {
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  }
$result
static DATEVALUE($dateValue=1)
Definition: DateTime.php:481
static setReturnDateType($returnDateType)
Definition: Functions.php:155
+ Here is the call graph for this function:

◆ testDATEwith1904Calendar()

DateTimeTest::testDATEwith1904Calendar ( )

Definition at line 57 of file DateTimeTest.php.

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

58  {
62  $this->assertEquals($result,5428);
63  }
$result
static DATE($year=0, $month=1, $day=1)
Definition: DateTime.php:292
static setExcelCalendar($baseDate)
Set the Excel calendar (Windows 1900 or Mac 1904)
Definition: Date.php:91
const CALENDAR_MAC_1904
Definition: Date.php:41
const CALENDAR_WINDOWS_1900
constants
Definition: Date.php:40
+ Here is the call graph for this function:

◆ testDATEwith1904CalendarError()

DateTimeTest::testDATEwith1904CalendarError ( )

Definition at line 65 of file DateTimeTest.php.

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

66  {
70  $this->assertEquals($result,'#NUM!');
71  }
$result
static DATE($year=0, $month=1, $day=1)
Definition: DateTime.php:292
static setExcelCalendar($baseDate)
Set the Excel calendar (Windows 1900 or Mac 1904)
Definition: Date.php:91
const CALENDAR_MAC_1904
Definition: Date.php:41
const CALENDAR_WINDOWS_1900
constants
Definition: Date.php:40
+ Here is the call graph for this function:

◆ testDAY()

DateTimeTest::testDAY ( )

providerDAY

Definition at line 177 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testDAYS360()

DateTimeTest::testDAYS360 ( )

providerDAYS360

Definition at line 437 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testEDATE()

DateTimeTest::testEDATE ( )

providerEDATE

Definition at line 347 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testEDATEtoPHP()

◆ testEDATEtoPHPObject()

DateTimeTest::testEDATEtoPHPObject ( )

Definition at line 368 of file DateTimeTest.php.

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

369  {
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  }
$result
static EDATE($dateValue=1, $adjustmentMonths=0)
EDATE.
Definition: DateTime.php:1410
static setReturnDateType($returnDateType)
Definition: Functions.php:155
+ Here is the call graph for this function:

◆ testEOMONTH()

DateTimeTest::testEOMONTH ( )

providerEOMONTH

Definition at line 384 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testEOMONTHtoPHP()

◆ testEOMONTHtoPHPObject()

DateTimeTest::testEOMONTHtoPHPObject ( )

Definition at line 405 of file DateTimeTest.php.

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

406  {
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  }
$result
static EOMONTH($dateValue=1, $adjustmentMonths=0)
EOMONTH.
Definition: DateTime.php:1455
static setReturnDateType($returnDateType)
Definition: Functions.php:155
+ Here is the call graph for this function:

◆ testHOUR()

DateTimeTest::testHOUR ( )

providerHOUR

Definition at line 267 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testMINUTE()

DateTimeTest::testMINUTE ( )

providerMINUTE

Definition at line 283 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testMONTH()

DateTimeTest::testMONTH ( )

providerMONTH

Definition at line 129 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testNETWORKDAYS()

DateTimeTest::testNETWORKDAYS ( )

providerNETWORKDAYS

Definition at line 315 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testSECOND()

DateTimeTest::testSECOND ( )

providerSECOND

Definition at line 299 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testTIME()

DateTimeTest::testTIME ( )

providerTIME

Definition at line 193 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testTIMEtoPHP()

◆ testTIMEtoPHPObject()

DateTimeTest::testTIMEtoPHPObject ( )

Definition at line 214 of file DateTimeTest.php.

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

215  {
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  }
$result
static TIME($hour=0, $minute=0, $second=0)
Definition: DateTime.php:386
static setReturnDateType($returnDateType)
Definition: Functions.php:155
+ Here is the call graph for this function:

◆ testTIMEVALUE()

DateTimeTest::testTIMEVALUE ( )

providerTIMEVALUE

Definition at line 230 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testTIMEVALUEtoPHP()

◆ testTIMEVALUEtoPHPObject()

DateTimeTest::testTIMEVALUEtoPHPObject ( )

Definition at line 251 of file DateTimeTest.php.

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

252  {
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  }
$result
static TIMEVALUE($timeValue)
Definition: DateTime.php:583
static setReturnDateType($returnDateType)
Definition: Functions.php:155
+ Here is the call graph for this function:

◆ testWEEKDAY()

DateTimeTest::testWEEKDAY ( )

providerWEEKDAY

Definition at line 161 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testWEEKNUM()

DateTimeTest::testWEEKNUM ( )

providerWEEKNUM

Definition at line 145 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testWORKDAY()

DateTimeTest::testWORKDAY ( )

providerWORKDAY

Definition at line 331 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testYEAR()

DateTimeTest::testYEAR ( )

providerYEAR

Definition at line 113 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

◆ testYEARFRAC()

DateTimeTest::testYEARFRAC ( )

providerYEARFRAC

Definition at line 453 of file DateTimeTest.php.

References $result, and array.

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  }
$result
Create styles array
The data for the language used.

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