class DateTimeTest in Loft Data Grids 7.2

Same name and namespace in other branches

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

Hierarchy

class \DateTimeTest extends \PHPUnit_Framework_TestCase

Expanded class hierarchy of DateTimeTest

File

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

View source

class DateTimeTest 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 providerDATE
   */
  public function testDATE() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'DATE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerDATE() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/DATE.data');
  }
  public function testDATEtoPHP() {
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
    $result = PHPExcel_Calculation_DateTime::DATE(2012, 1, 31);
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
    $this
      ->assertEquals(1327968000, $result, NULL, 1.0E-8);
  }
  public function testDATEtoPHPObject() {
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
    $result = PHPExcel_Calculation_DateTime::DATE(2012, 1, 31);
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);

    //    Must return an object...
    $this
      ->assertTrue(is_object($result));

    //    ... of the correct type
    $this
      ->assertTrue(is_a($result, 'DateTime'));

    //    ... with the correct value
    $this
      ->assertEquals($result
      ->format('d-M-Y'), '31-Jan-2012');
  }
  public function testDATEwith1904Calendar() {
    PHPExcel_Shared_Date::setExcelCalendar(PHPExcel_Shared_Date::CALENDAR_MAC_1904);
    $result = PHPExcel_Calculation_DateTime::DATE(1918, 11, 11);
    PHPExcel_Shared_Date::setExcelCalendar(PHPExcel_Shared_Date::CALENDAR_WINDOWS_1900);
    $this
      ->assertEquals($result, 5428);
  }
  public function testDATEwith1904CalendarError() {
    PHPExcel_Shared_Date::setExcelCalendar(PHPExcel_Shared_Date::CALENDAR_MAC_1904);
    $result = PHPExcel_Calculation_DateTime::DATE(1901, 1, 31);
    PHPExcel_Shared_Date::setExcelCalendar(PHPExcel_Shared_Date::CALENDAR_WINDOWS_1900);
    $this
      ->assertEquals($result, '#NUM!');
  }

  /**
   * @dataProvider providerDATEVALUE
   */
  public function testDATEVALUE() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'DATEVALUE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerDATEVALUE() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/DATEVALUE.data');
  }
  public function testDATEVALUEtoPHP() {
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
    $result = PHPExcel_Calculation_DateTime::DATEVALUE('2012-1-31');
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
    $this
      ->assertEquals(1327968000, $result, NULL, 1.0E-8);
  }
  public function testDATEVALUEtoPHPObject() {
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
    $result = PHPExcel_Calculation_DateTime::DATEVALUE('2012-1-31');
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);

    //    Must return an object...
    $this
      ->assertTrue(is_object($result));

    //    ... of the correct type
    $this
      ->assertTrue(is_a($result, 'DateTime'));

    //    ... with the correct value
    $this
      ->assertEquals($result
      ->format('d-M-Y'), '31-Jan-2012');
  }

  /**
   * @dataProvider providerYEAR
   */
  public function testYEAR() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'YEAR',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerYEAR() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/YEAR.data');
  }

  /**
   * @dataProvider providerMONTH
   */
  public function testMONTH() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'MONTHOFYEAR',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerMONTH() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/MONTH.data');
  }

  /**
   * @dataProvider providerWEEKNUM
   */
  public function testWEEKNUM() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'WEEKOFYEAR',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerWEEKNUM() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/WEEKNUM.data');
  }

  /**
   * @dataProvider providerWEEKDAY
   */
  public function testWEEKDAY() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'DAYOFWEEK',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerWEEKDAY() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/WEEKDAY.data');
  }

  /**
   * @dataProvider providerDAY
   */
  public function testDAY() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'DAYOFMONTH',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerDAY() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/DAY.data');
  }

  /**
   * @dataProvider providerTIME
   */
  public function testTIME() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'TIME',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerTIME() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/TIME.data');
  }
  public function testTIMEtoPHP() {
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
    $result = PHPExcel_Calculation_DateTime::TIME(7, 30, 20);
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
    $this
      ->assertEquals(27020, $result, NULL, 1.0E-8);
  }
  public function testTIMEtoPHPObject() {
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
    $result = PHPExcel_Calculation_DateTime::TIME(7, 30, 20);
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);

    //    Must return an object...
    $this
      ->assertTrue(is_object($result));

    //    ... of the correct type
    $this
      ->assertTrue(is_a($result, 'DateTime'));

    //    ... with the correct value
    $this
      ->assertEquals($result
      ->format('H:i:s'), '07:30:20');
  }

  /**
   * @dataProvider providerTIMEVALUE
   */
  public function testTIMEVALUE() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'TIMEVALUE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerTIMEVALUE() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/TIMEVALUE.data');
  }
  public function testTIMEVALUEtoPHP() {
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
    $result = PHPExcel_Calculation_DateTime::TIMEVALUE('7:30:20');
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
    $this
      ->assertEquals(23420, $result, NULL, 1.0E-8);
  }
  public function testTIMEVALUEtoPHPObject() {
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
    $result = PHPExcel_Calculation_DateTime::TIMEVALUE('7:30:20');
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);

    //    Must return an object...
    $this
      ->assertTrue(is_object($result));

    //    ... of the correct type
    $this
      ->assertTrue(is_a($result, 'DateTime'));

    //    ... with the correct value
    $this
      ->assertEquals($result
      ->format('H:i:s'), '07:30:20');
  }

  /**
   * @dataProvider providerHOUR
   */
  public function testHOUR() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'HOUROFDAY',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerHOUR() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/HOUR.data');
  }

  /**
   * @dataProvider providerMINUTE
   */
  public function testMINUTE() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'MINUTEOFHOUR',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerMINUTE() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/MINUTE.data');
  }

  /**
   * @dataProvider providerSECOND
   */
  public function testSECOND() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'SECONDOFMINUTE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerSECOND() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/SECOND.data');
  }

  /**
   * @dataProvider providerNETWORKDAYS
   */
  public function testNETWORKDAYS() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'NETWORKDAYS',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerNETWORKDAYS() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/NETWORKDAYS.data');
  }

  /**
   * @dataProvider providerWORKDAY
   */
  public function testWORKDAY() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'WORKDAY',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerWORKDAY() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/WORKDAY.data');
  }

  /**
   * @dataProvider providerEDATE
   */
  public function testEDATE() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'EDATE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerEDATE() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/EDATE.data');
  }
  public function testEDATEtoPHP() {
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
    $result = PHPExcel_Calculation_DateTime::EDATE('2012-1-26', -1);
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
    $this
      ->assertEquals(1324857600, $result, NULL, 1.0E-8);
  }
  public function testEDATEtoPHPObject() {
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
    $result = PHPExcel_Calculation_DateTime::EDATE('2012-1-26', -1);
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);

    //    Must return an object...
    $this
      ->assertTrue(is_object($result));

    //    ... of the correct type
    $this
      ->assertTrue(is_a($result, 'DateTime'));

    //    ... with the correct value
    $this
      ->assertEquals($result
      ->format('d-M-Y'), '26-Dec-2011');
  }

  /**
   * @dataProvider providerEOMONTH
   */
  public function testEOMONTH() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'EOMONTH',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerEOMONTH() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/EOMONTH.data');
  }
  public function testEOMONTHtoPHP() {
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC);
    $result = PHPExcel_Calculation_DateTime::EOMONTH('2012-1-26', -1);
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);
    $this
      ->assertEquals(1325289600, $result, NULL, 1.0E-8);
  }
  public function testEOMONTHtoPHPObject() {
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT);
    $result = PHPExcel_Calculation_DateTime::EOMONTH('2012-1-26', -1);
    PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);

    //    Must return an object...
    $this
      ->assertTrue(is_object($result));

    //    ... of the correct type
    $this
      ->assertTrue(is_a($result, 'DateTime'));

    //    ... with the correct value
    $this
      ->assertEquals($result
      ->format('d-M-Y'), '31-Dec-2011');
  }

  /**
   * @dataProvider providerDATEDIF
   */
  public function testDATEDIF() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'DATEDIF',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerDATEDIF() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/DATEDIF.data');
  }

  /**
   * @dataProvider providerDAYS360
   */
  public function testDAYS360() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'DAYS360',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerDAYS360() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/DAYS360.data');
  }

  /**
   * @dataProvider providerYEARFRAC
   */
  public function testYEARFRAC() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_DateTime',
      'YEARFRAC',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerYEARFRAC() {
    return new testDataFileIterator('rawTestData/Calculation/DateTime/YEARFRAC.data');
  }

}

Members

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

You are here

class DateTimeTest in Loft Data Grids 7.2

Hierarchy

File

Members

API Navigation