1:  2:  3:  4:  5:  6:  7:  8:  9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 

<?php

/*
 * This file is part of the Incipio package.
 *
 * (c) Théo FIDRY <theo.fidry@gmail.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace ApiBundle\Doctrine\DBAL\Type;

use Doctrine\DBAL\Platforms\AbstractPlatform;
use Doctrine\DBAL\Types\ConversionException;
use Doctrine\DBAL\Types\DateTimeType;

/**
 * Class UTCDateTimeType: used to set the timezone of any date to UTC.
 *
 * @link https://github.com/Atlantic18/DoctrineExtensions/blob/master/doc/timestampable.md#creating-a-utc-datetime-type-that-stores-your-datetimes-in-utc
 *
 * @author Théo FIDRY <theo.fidry@gmail.com>
 */
class UTCDateTimeType extends DateTimeType
{
    /**
     * {@inheritdoc}
     */
    public function convertToDatabaseValue($phpValue, AbstractPlatform $platform)
    {
        if ($phpValue instanceof \DateTime) {
            $phpValue->setTimeZone(new \DateTimeZone('UTC'));
        }

        return parent::convertToDatabaseValue($phpValue, $platform);
    }

    /**
     * {@inheritdoc}
     */
    public function convertToPHPValue($databaseValue, AbstractPlatform $platform)
    {
        if (null === $databaseValue || $databaseValue instanceof \DateTime) {
            return $databaseValue;
        }

        // The changed part is the following bloc where we put the DateTimeZone as the third argument rather than
        // relying on the local timezone
        $phpValue = \DateTime::createFromFormat(
            $platform->getDateTimeFormatString(),
            $databaseValue,
            new \DateTimeZone('UTC')
        );

        if (false === $phpValue) {
            $phpValue = date_create($databaseValue);
        }

        if (false === $phpValue) {
            throw ConversionException::conversionFailedFormat(
                $databaseValue,
                $this->getName(),
                $platform->getDateTimeFormatString()
            );
        }

        return $phpValue;
    }
}