<?php

declare(strict_types=1);

namespace AetosSeo\Utils;

if (!defined('ABSPATH')) {
    exit;
}

final class Time
{
    /**
     * Convert a WordPress site-local MySQL datetime to a Unix timestamp.
     */
    public static function mysql_to_timestamp(string $value): int
    {
        $value = trim($value);
        if (!preg_match('/^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$/D', $value)) {
            return 0;
        }

        $date = \DateTimeImmutable::createFromFormat('!Y-m-d H:i:s', $value, wp_timezone());
        $errors = \DateTimeImmutable::getLastErrors();
        if (
            $date instanceof \DateTimeImmutable
            && ($errors === false || ((int) $errors['warning_count'] === 0 && (int) $errors['error_count'] === 0))
        ) {
            return $date->getTimestamp();
        }

        return 0;
    }
}