<?php
/**
* CakePHP(tm) : Rapid Development Framework (https://cakephp.org)
* Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org)
*
* Licensed under The MIT License
* For full copyright and license information, please see the LICENSE.txt
* Redistributions of files must retain the above copyright notice.
*
* @copyright Copyright (c) Cake Software Foundation, Inc. (https://cakefoundation.org)
* @link https://cakephp.org CakePHP(tm) Project
* @since 3.0.0
* @license https://opensource.org/licenses/mit-license.php MIT License
*/
namespace Cake\Database\Type;
use Cake\Database\Driver;
use Cake\Database\Type;
use Cake\Database\TypeInterface;
use Cake\Database\Type\BatchCastingInterface;
use DateTimeImmutable;
use DateTimeInterface;
use DateTimeZone;
use Exception;
use PDO;
use RuntimeException;
/**
* Datetime type converter.
*
* Use to convert datetime instances to strings & back.
*/
class DateTimeType extends Type implements TypeInterface, BatchCastingInterface
{
/**
* Identifier name for this type.
*
* (This property is declared here again so that the inheritance from
* Cake\Database\Type can be removed in the future.)
*
* @var string|null
*/
protected $_name;
/**
* The class to use for representing date objects
*
* This property can only be used before an instance of this type
* class is constructed. After that use `useMutable()` or `useImmutable()` instead.
*
* @var string
* @deprecated 3.2.0 Use DateTimeType::useMutable() or DateTimeType::useImmutable() instead.
*/
public static $dateTimeClass = 'Cake\I18n\Time';
/**
* Whether or not we want to override the time of the converted Time objects
* so it points to the start of the day.
*
* This is primarily to avoid subclasses needing to re-implement the same functionality.
*
* @var bool
*/
protected $setToDateStart = false;
/**
* String format to use for DateTime parsing
*
* @var string|array
*/
protected $_format = [
'Y-m-d H:i:s',
'Y-m-d\TH:i:sP',
];
/**
* Whether dates should be parsed using a locale aware parser
* when marshalling string inputs.
*
* @var bool
*/
protected $_useLocaleParser = false;
/**
* The date format to use for parsing incoming dates for marshalling.
*
* @var string|array|int
*/
protected $_localeFormat;
/**
* An instance of the configured dateTimeClass, used to quickly generate
* new instances without calling the constructor.
*
* @var \DateTime
*/
protected $_datetimeInstance;
/**
* The classname to use when creating objects.
*
* @var string
*/
protected $_className;
/**
* Timezone instance.
*
* @var \DateTimeZone|null
*/
protected $dbTimezone;
/**
* {@inheritDoc}
*/
public function __construct($name = null)
{
$this->_name = $name;
$this->_setClassName(static::$dateTimeClass, 'DateTime');
}
/**
* Convert DateTime instance into strings.
*
* @param string|int|\DateTime|\DateTimeImmutable $value The value to convert.
* @param \Cake\Database\Driver $driver The driver instance to convert with.
* @return string|null
*/
public function toDatabase($value, Driver $driver)
{
if ($value === null || is_string($value)) {
return $value;
}
if (is_int($value)) {
$class = $this->_className;
$value = new $class('@' . $value);
}
$format = (array)$this->_format;
if (
$this->dbTimezone !== null
&& $this->dbTimezone->getName() !== $value->getTimezone()->getName()
) {
if (!$value instanceof DateTimeImmutable) {
$value = clone $value;
}
$value = $value->setTimezone($this->dbTimezone);
}
return $value->format(array_shift($format));
}
/**
* Set database timezone.
*
* Specified timezone will be set for DateTime objects before generating
* datetime string for saving to database. If `null` no timezone conversion
* will be done.
*
* @param string|\DateTimeZone|null $timezone Database timezone.
* @return $this
*/
public function setTimezone($timezone)
{
if (is_string($timezone)) {
$timezone = new DateTimeZone($timezone);
}
$this->dbTimezone = $timezone;
return $this;
}
/**
* Convert strings into DateTime instances.
*
* @param string $value The value to convert.
* @param \Cake\Database\Driver $driver The driver instance to convert with.
* @return \Cake\I18n\Time|\DateTime|null
*/
public function toPHP($value, Driver $driver)
{
if ($value === null || strpos($value, '0000-00-00') === 0) {
return null;
}
$instance = clone $this->_datetimeInstance;
$instance = $instance->modify($value);
if ($this->setToDateStart) {
$instance = $instance->setTime(0, 0, 0);
}
return $instance;
}
/**
* {@inheritDoc}
*
* @return array
*/
public function manyToPHP(array $values, array $fields, Driver $driver)
{
foreach ($fields as $field) {
if (!isset($values[$field])) {
continue;
}
if (strpos($values[$field], '0000-00-00') === 0) {
$values[$field] = null;
continue;
}
$instance = clone $this->_datetimeInstance;
$instance = $instance->modify($values[$field]);
if ($this->setToDateStart) {
$instance = $instance->setTime(0, 0, 0);
}
$values[$field] = $instance;
}
return $values;
}
/**
* Convert request data into a datetime object.
*
* @param mixed $value Request data
* @return \DateTimeInterface|null
*/
public function marshal($value)
{
if ($value instanceof DateTimeInterface) {
return $value;
}
$class = $this->_className;
try {
$compare = $date = false;
if ($value === '' || $value === null || $value === false || $value === true) {
return null;
}
$isString = is_string($value);
if (ctype_digit($value)) {
$date = new $class('@' . $value);
} elseif ($isString && $this->_useLocaleParser) {
return $this->_parseValue($value);
} elseif ($isString) {
$date = new $class($value);
$compare = true;
}
if ($compare && $date && !$this->_compare($date, $value)) {
return $value;
}
if ($date) {
return $date;
}
} catch (Exception $e) {
return $value;
}
if (is_array($value) && implode('', $value) === '') {
return null;
}
$value += ['hour' => 0, 'minute' => 0, 'second' => 0];
$format = '';
if (
isset($value['year'], $value['month'], $value['day']) &&
(is_numeric($value['year']) && is_numeric($value['month']) && is_numeric($value['day']))
) {
$format .= sprintf('%d-%02d-%02d', $value['year'], $value['month'], $value['day']);
}
if (isset($value['meridian']) && (int)$value['hour'] === 12) {
$value['hour'] = 0;
}
if (isset($value['meridian'])) {
$value['hour'] = strtolower($value['meridian']) === 'am' ? $value['hour'] : $value['hour'] + 12;
}
$format .= sprintf(
'%s%02d:%02d:%02d',
empty($format) ? '' : ' ',
$value['hour'],
$value['minute'],
$value['second']
);
$tz = isset($value['timezone']) ? $value['timezone'] : null;
return new $class($format, $tz);
}
/**
* @param \Cake\I18n\Time|\DateTime $date DateTime object
* @param mixed $value Request data
* @return bool
*/
protected function _compare($date, $value)
{
foreach ((array)$this->_format as $format) {
if ($date->format($format) === $value) {
return true;
}
}
return false;
}
/**
* Sets whether or not to parse dates passed to the marshal() function
* by using a locale aware parser.
*
* @param bool $enable Whether or not to enable
* @return $this
*/
public function useLocaleParser($enable = true)
{
if ($enable === false) {
$this->_useLocaleParser = $enable;
return $this;
}
if (method_exists($this->_className, 'parseDateTime')) {
$this->_useLocaleParser = $enable;
return $this;
}
throw new RuntimeException(
sprintf('Cannot use locale parsing with the %s class', $this->_className)
);
}
/**
* Sets the format string to use for parsing dates in this class. The formats
* that are accepted are documented in the `Cake\I18n\Time::parseDateTime()`
* function.
*
* @param string|array $format The format in which the string are passed.
* @see \Cake\I18n\Time::parseDateTime()
* @return $this
*/
public function setLocaleFormat($format)
{
$this->_localeFormat = $format;
return $this;
}
/**
* Change the preferred class name to the FrozenTime implementation.
*
* @return $this
*/
public function useImmutable()
{
$this->_setClassName('Cake\I18n\FrozenTime', 'DateTimeImmutable');
return $this;
}
/**
* Set the classname to use when building objects.
*
* @param string $class The classname to use.
* @param string $fallback The classname to use when the preferred class does not exist.
* @return void
*/
protected function _setClassName($class, $fallback)
{
if (!class_exists($class)) {
$class = $fallback;
}
$this->_className = $class;
$this->_datetimeInstance = new $this->_className();
}
/**
* Get the classname used for building objects.
*
* @return string
*/
public function getDateTimeClassName()
{
return $this->_className;
}
/**
* Change the preferred class name to the mutable Time implementation.
*
* @return $this
*/
public function useMutable()
{
$this->_setClassName('Cake\I18n\Time', 'DateTime');
return $this;
}
/**
* Converts a string into a DateTime object after parsing it using the locale
* aware parser with the specified format.
*
* @param string $value The value to parse and convert to an object.
* @return \Cake\I18n\Time|null
*/
protected function _parseValue($value)
{
/** @var \Cake\I18n\Time $class */
$class = $this->_className;
return $class::parseDateTime($value, $this->_localeFormat);
}
/**
* Casts given value to Statement equivalent
*
* @param mixed $value value to be converted to PDO statement
* @param \Cake\Database\Driver $driver object from which database preferences and configuration will be extracted
*
* @return mixed
*/
public function toStatement($value, Driver $driver)
{
return PDO::PARAM_STR;
}
}