Akeneo\Component\SpreadsheetParser\Xlsx\DateTransformer

Complexity

Total Complexity

2

Size/Duplication

Total Lines	34
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	0

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	transform()	0	11	1

<?php

namespace Akeneo\Component\SpreadsheetParser\Xlsx;

/**
 * Transforms Excel dates in DateTime objects
 *
 * @author    Antoine Guigan <antoine@akeneo.com>
 * @copyright 2014 Akeneo SAS (http://www.akeneo.com)
 * @license   http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 */
class DateTransformer
{
    /**
     * @var \DateTime
     */
    protected $baseDate;

    /**
     * Constructor
     */
    public function __construct()
    {
        $this->baseDate = new \DateTime('1900-01-00 00:00:00 UTC');
    }

    /**
     * Transforms an Excel date into a DateTime object
     *
     * @param String $value
     *
     * @return \DateTime
     */
    public function transform($value)
    {
        $days = floor($value);

        $seconds = round(($value - $days) * 86400);

        $date = clone $this->baseDate;
        $date->modify(sprintf('+%sday +%ssecond', $days - 1, $seconds));

        return $date;
    }
}