FM / Types

/home/techb158/dev.balacoffee.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/

/home/techb158/dev.balacoffee.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types

Name	Size	Mode	Actions
ArrayType.php	1612	0644	edit dl rm
AsciiStringType.php	606	0644	edit dl rm
BigIntType.php	857	0644	edit dl rm
BinaryType.php	1347	0644	edit dl rm
BlobType.php	1333	0644	edit dl rm
BooleanType.php	1018	0644	edit dl rm
ConversionException.php	3574	0644	edit dl rm
DateImmutableType.php	1547	0644	edit dl rm
DateIntervalType.php	1983	0644	edit dl rm
DateTimeImmutableType.php	1699	0644	edit dl rm
DateTimeType.php	1697	0644	edit dl rm
DateTimeTzImmutableType.php	1583	0644	edit dl rm
DateTimeTzType.php	2425	0644	edit dl rm
DateType.php	1526	0644	edit dl rm
DecimalType.php	976	0644	edit dl rm
FloatType.php	597	0644	edit dl rm
GuidType.php	683	0644	edit dl rm
IntegerType.php	852	0644	edit dl rm
JsonArrayType.php	899	0644	edit dl rm
JsonType.php	1790	0644	edit dl rm
ObjectType.php	1540	0644	edit dl rm
PhpDateTimeMappingType.php	183	0644	edit dl rm
PhpIntegerMappingType.php	163	0644	edit dl rm
SimpleArrayType.php	1349	0644	edit dl rm
SmallIntType.php	864	0644	edit dl rm
StringType.php	651	0644	edit dl rm
TextType.php	733	0644	edit dl rm
TimeImmutableType.php	1547	0644	edit dl rm
TimeType.php	1530	0644	edit dl rm
Type.php	12096	0644	edit dl rm
TypeRegistry.php	2839	0644	edit dl rm
Types.php	1676	0644	edit dl rm
VarDateTimeImmutableType.php	1457	0644	edit dl rm
VarDateTimeType.php	893	0644	edit dl rm

Edit: /home/techb158/dev.balacoffee.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/DateTimeTzType.php (2425B)

<?php

namespace Doctrine\DBAL\Types;

use DateTime;
use DateTimeInterface;
use Doctrine\DBAL\Platforms\AbstractPlatform;

/**
 * DateTime type saving additional timezone information.
 *
 * Caution: Databases are not necessarily experts at storing timezone related
 * data of dates. First, of all the supported vendors only PostgreSQL and Oracle
 * support storing Timezone data. But those two don't save the actual timezone
 * attached to a DateTime instance (for example "Europe/Berlin" or "America/Montreal")
 * but the current offset of them related to UTC. That means depending on daylight saving times
 * or not you may get different offsets.
 *
 * This datatype makes only sense to use, if your application works with an offset, not
 * with an actual timezone that uses transitions. Otherwise your DateTime instance
 * attached with a timezone such as Europe/Berlin gets saved into the database with
 * the offset and re-created from persistence with only the offset, not the original timezone
 * attached.
 */
class DateTimeTzType extends Type implements PhpDateTimeMappingType
{
    /**
     * {@inheritdoc}
     */
    public function getName()
    {
        return Types::DATETIMETZ_MUTABLE;
    }

/**
     * {@inheritdoc}
     */
    public function getSQLDeclaration(array $column, AbstractPlatform $platform)
    {
        return $platform->getDateTimeTzTypeDeclarationSQL($column);
    }

/**
     * {@inheritdoc}
     */
    public function convertToDatabaseValue($value, AbstractPlatform $platform)
    {
        if ($value === null) {
            return $value;
        }

if ($value instanceof DateTimeInterface) {
            return $value->format($platform->getDateTimeTzFormatString());
        }

throw ConversionException::conversionFailedInvalidType($value, $this->getName(), ['null', 'DateTime']);
    }

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

$val = DateTime::createFromFormat($platform->getDateTimeTzFormatString(), $value);
        if (! $val) {
            throw ConversionException::conversionFailedFormat(
                $value,
                $this->getName(),
                $platform->getDateTimeTzFormatString()
            );
        }

return $val;
    }
}

getDateTimeTzTypeDeclarationSQL($column); } /** * {@inheritdoc} */ public function convertToDatabaseValue($value, AbstractPlatform $platform) { if ($value === null) { return $value; } if ($value instanceof DateTimeInterface) { return $value->format($platform->getDateTimeTzFormatString()); } throw ConversionException::conversionFailedInvalidType($value, $this->getName(), ['null', 'DateTime']); } /** * {@inheritdoc} */ public function convertToPHPValue($value, AbstractPlatform $platform) { if ($value === null || $value instanceof DateTimeInterface) { return $value; } $val = DateTime::createFromFormat($platform->getDateTimeTzFormatString(), $value); if (! $val) { throw ConversionException::conversionFailedFormat( $value, $this->getName(), $platform->getDateTimeTzFormatString() ); } return $val; } }