<?php

namespace App\Http\Controllers;

use DateTime;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Validator;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Hash;
use Illuminate\Support\Carbon;

class FunctionsController extends Controller
{
    private $responseController;

    public function __construct()
    {
        $this->responseController = new ResponseController();
    }

    public static function uuidv5($namespace, $name)
    {
        if (!self::is_valid($namespace)) return false;

        // Get hexadecimal components of namespace
        $nhex = str_replace(array('-', '{', '}'), '', $namespace);

        // Binary Value
        $nstr = '';

        // Convert Namespace UUID to bits
        for ($i = 0; $i < strlen($nhex); $i += 2) {
            $nstr .= chr(hexdec($nhex[$i] . $nhex[$i + 1]));
        }

        // Calculate hash value
        $hash = sha1($nstr . $name);

        return sprintf(
            '%08s-%04s-%04x-%04x-%12s',

            // 32 bits for "time_low"
            substr($hash, 0, 8),

            // 16 bits for "time_mid"
            substr($hash, 8, 4),

            // 16 bits for "time_hi_and_version",
            // four most significant bits holds version number 5
            (hexdec(substr($hash, 12, 4)) & 0x0fff) | 0x5000,

            // 16 bits, 8 bits for "clk_seq_hi_res",
            // 8 bits for "clk_seq_low",
            // two most significant bits holds zero and one for variant DCE1.1
            (hexdec(substr($hash, 16, 4)) & 0x3fff) | 0x8000,

            // 48 bits for "node"
            substr($hash, 20, 12)
        );
    }

    public static function is_valid($uuid)
    {
        return preg_match('/^\{?[0-9a-f]{8}\-?[0-9a-f]{4}\-?[0-9a-f]{4}\-?' .
            '[0-9a-f]{4}\-?[0-9a-f]{12}\}?$/i', $uuid) === 1;
    }

    public function generateID($seed, $timestamp)
    {
        $string = str_replace(" ", "", $seed) . $timestamp;
        $array = [];
        for ($i = 0; $i < strlen($string); $i++) {
            $array[] = $string[$i];
        }

        shuffle($array);
        $chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";

        $ID = '';
        foreach ($array as $char) {
            $ascii = ord($char);

            $s = $ascii / 100;
            if ($s >= 1) continue;

            $s = $s * strlen($chars);
            $s = intval($s);

            $l = $chars[$s];
            if (strlen($ID) < 20) $ID .= $l;
        }

        if (strlen($ID) < 20) {
            for ($i = strlen($ID); $i < 20; $i++) {
                $s = rand(0, strlen($chars) - 1);
                $l = $chars[$s];
                $ID .= $l;
            }
        }

        return $ID;
    }

    public function getType($type)
    {
        switch ($type) {
            case "insert":
                return "CREATE";
                break;
            case "update":
                return strtoupper($type);
                break;
            case "select":
                return "READ";
                break;
            case "delete":
                return strtoupper($type);
                break;
            default:
                return "UNKNOWN";
                break;
        }
    }

    public function registerLog($querys, $user, $date, $idac, $line)
    {
        foreach ($querys as $query) {
            $script = $query['query'];
            $params = json_encode($query['bindings']);

            DB::table('S002V01TLOMY')->insert([
                'LOMY_NULI' => $line,
                'LOMY_IDAC' => $idac,
                'LOMY_QUER' => $script,
                'LOMY_PARA' => $params,
                'LOMY_FECH' => $date,
                'LOMY_IDUS' => $user,
            ]);
        }
    }

    public function registerActivity($line, $module, $function, $screen, $action, $description, $user, $date, $submodule = null, $idobj = null)
    {
        $id = DB::table('S002V01TACCI')->insertGetId([
            'ACCI_NULI' => $line,
            'ACCI_IDMO' => $module,
            'ACCI_IDSM' => $submodule,
            'ACCI_IDFU' => $function,
            'ACCI_IDPA' => $screen,
            'ACCI_TIAC' => $action,
            'ACCI_DESC' => $description,
            'ACCI_IDUS' => $user,
            'ACCI_FEAC' => $date,
            'ACCI_IDOJ' => $idobj
        ]);

        DB::table('S002V01TUSUA')->where('USUA_IDUS', '=', $user)->update([
            'USUA_ULAC' => $id
        ]);

        return $id;
    }

    public function joinName($name, $fApe, $sApe = null)
    {
        $fullName = "$name $fApe";
        if (!is_null($sApe)) {
            $fullName = "$fullName $sApe";
        }

        return $fullName;
    }

    public function checkFileSize($ext, $size)
    {
        $availableFiles = [
            250 => [
                "zip",
                "tar",
                "rar",
                "7z",
                "mp3",
                "mpeg",
                "wav",
                "ogg",
                "opus",
                "jpg",
                "png",
                "gif",
                "bmp",
                "tiff",
                "svg",
                "txt",
                "webm",
                "mp4",
                "3gp",
                "mov",
                "avi",
                "wmv",
                "flv",
                "dwg",
                "dxf",
                "3ds",
                "ai",
                "psd",
                "xml"
            ],
            50 => ["doc", "docx", "vsd", "vsdx", "pdf"],
            75 => ["xls", "xlsx"],
            100 => ["ppt", "pptx"],
        ];

        $maxFileSizeMB = 0;
        foreach ($availableFiles as $k => $v) {
            if (in_array($ext, $v)) $maxFileSizeMB = $k;
        }

        if ($maxFileSizeMB == 0) return false;

        $maxFileSize = $maxFileSizeMB * 1048576;
        return $size < $maxFileSize;
    }

    public function checkInvoice($file)
    {

        try {
            $xml = simplexml_load_string($file, 'SimpleXMLElement', LIBXML_NOCDATA);
            $ns = $xml->getNamespaces(true);
            $xml->registerXPathNamespace('c', $ns['cfdi']);
            $xml->registerXPathNamespace('t', $ns['tfd']);
        } catch (\Throwable $th) {
            return $this->responseController->makeResponse(
                true,
                "ERR_INVOICE_COMPARE006: Ocurrió un error al obtener la información del documento.",
                $th->getMessage(),
                500
            );
        }
        $arrInfoInvoice = ((array) $xml)['@attributes'];
        if (
            array_key_exists('Version', $arrInfoInvoice) &&
            array_key_exists('Serie', $arrInfoInvoice) &&
            array_key_exists('Folio', $arrInfoInvoice) &&
            array_key_exists('TipoDeComprobante', $arrInfoInvoice) &&
            array_key_exists('NoCertificado', $arrInfoInvoice) &&
            array_key_exists('Certificado', $arrInfoInvoice) &&
            array_key_exists('Sello', $arrInfoInvoice) &&
            array_key_exists('FormaPago', $arrInfoInvoice) &&
            array_key_exists('MetodoPago', $arrInfoInvoice) &&
            array_key_exists('SubTotal', $arrInfoInvoice) &&
            array_key_exists('Moneda', $arrInfoInvoice) &&
            array_key_exists('TipoCambio', $arrInfoInvoice) &&
            array_key_exists('Total', $arrInfoInvoice) &&
            array_key_exists('LugarExpedicion', $arrInfoInvoice) &&
            array_key_exists('CondicionesDePago', $arrInfoInvoice) &&
            array_key_exists('Fecha', $arrInfoInvoice) &&
            array_key_exists('Exportacion', $arrInfoInvoice)
        ) {
            return true;
        }
        return false;
    }

    public function now()
    {
        $completeDate = shell_exec('echo %date%');
        $completeDate = trim($completeDate);

        $serverDateTime = "";
        if (strlen($completeDate) == 14) {
            $serverDateTime = shell_exec('echo %date:~10,4%-%date:~4,2%-%date:~7,2% %time:~0,2%:%time:~3,2%:%time:~6,2%');
            $serverDateTime = trim($serverDateTime);
        } else {
            $serverDateTime = shell_exec('echo %date:~6,4%-%date:~3,2%-%date:~0,2% %time:~0,2%:%time:~3,2%:%time:~6,2%');
            $serverDateTime = trim($serverDateTime);
        }

        return new Carbon($serverDateTime);
    }

    public function validDate($date)
    {
        if (preg_match("/^[0-9]{4}-(0[1-9]|1[0-2])-(0[1-9]|[1-2][0-9]|3[0-1])$/", $date)) {
            return true;
        } else {
            return false;
        }
    }

    public function floatAdd(...$numbers): float
    {
        $result = "0.0";
        foreach ($numbers as $n) {
            $result = bcadd("$result", "$n", 18);
        }
        return floatval($result);
    }

    public function floatSub($fn, $sn): float
    {
        $result = bcsub("$fn", "$sn", 18);
        return floatval($result);
    }

    public function floatDiv($fn, $sn): float
    {
        $result = bcdiv("$fn", "$sn", 18);
        return floatval($result);
    }

    public function floatMul($n1, $n2): float
    {
        $result = bcmul("$n1", "$n2", 18);
        return floatval($result);
    }

    public function formatDateTime(string $dateTime): string
    {
        if (str_contains($dateTime, '0001-01-01')) {
            return "-";
        }

        $MONTHS = [
            "01" => "Enero",
            "02" => "Febrero",
            "03" => "Marzo",
            "04" => "Abril",
            "05" => "Mayo",
            "06" => "Junio",
            "07" => "Julio",
            "08" => "Agosto",
            "09" => "Septiembre",
            "10" => "Octubre",
            "11" => "Noviembre",
            "12" => "Diciembre"
        ];
        $dateTimeArr = explode(" ", $dateTime);
        $dateArr = explode("-", $dateTimeArr[0]);
        $month = $MONTHS[$dateArr[1]];
        $day = intval($dateArr[2]);

        $dateTimeStr = $day . " de " . $month . " del " . $dateArr[0];
        $timeArr = explode(":", $dateTimeArr[1]);
        $hour = intval($timeArr[0]);
        $period = $hour < 12 ? 'AM' : 'PM';
        $hour = $hour > 12 ? $hour - 12 : $hour;

        $dateTimeStr .= " a las " . $hour . ":" . $timeArr[1] . " " . $period;
        return $dateTimeStr;
    }

    public function buildHumanCurrentDate(string $dateTime): string
    {
        $DAYS = [
            "Mo" => "Lunes",
            "Tu" => "Martes",
            "We" => "Miércoles",
            "Th" => "Jueves",
            "Fr" => "Viernes",
            "Sa" => "Sábado",
            "Su" => "Domingo"
        ];
        $MONTHS = [
            "01" => "Enero",
            "02" => "Febrero",
            "03" => "Marzo",
            "04" => "Abril",
            "05" => "Mayo",
            "06" => "Junio",
            "07" => "Julio",
            "08" => "Agosto",
            "09" => "Septiembre",
            "10" => "Octubre",
            "11" => "Noviembre",
            "12" => "Diciembre"
        ];

        $dateTimeArr = explode(" ", $dateTime);
        $dateArr = explode("-", $dateTimeArr[0]);
        $dateObj = new Carbon($dateTime);
        $dayName = $dateObj->format('l');
        $dayInd = substr($dayName, 0, 2);

        return $DAYS[$dayInd] . ", " . $dateArr[2] . " de " . $MONTHS[$dateArr[1]] . " del " . $dateArr[0];
    }

    public function buildProjectDate($dateStr): string
    {
        $MONTHS = [
            "01" => "enero",
            "02" => "febrero",
            "03" => "marzo",
            "04" => "abril",
            "05" => "mayo",
            "06" => "junio",
            "07" => "julio",
            "08" => "agosto",
            "09" => "septiembre",
            "10" => "octubre",
            "11" => "noviembre",
            "12" => "diciembre"
        ];

        $dateObj = new Carbon($dateStr);
        $dateFormatted = $dateObj->toDateTimeString();
        $dateTimeArr = explode(" ", $dateFormatted);

        $dateArr = explode('-', $dateTimeArr[0]);
        $monthName = $MONTHS[$dateArr[1]];

        $timeArr = explode(':', $dateTimeArr[1]);
        $hour = intval($timeArr[0]);
        $period = $hour < 12 ? 'a. m.' : 'p. m.';
        $hour = $hour > 12 ? $hour - 12 : $hour;
        $hourStr = $hour < 10 ? "0$hour" : "$hour";

        return "$dateArr[2] de $monthName $dateArr[0] $hourStr:$timeArr[1] $period";
    }

    public function getApiURI(): string
    {
        return "http://git.ittec.mx/";
    }

    public function getBasePath(): string
    {
        return "C:\SistemaMantenimiento\sistema-mantenimiento-back";
    }

    public function validPhoneNumber(string $number): bool
    {
        if (intval($number) <= 0) return false;

        $validChars = ['0', '1', '2', '3', '4', '5', '6', '7', '8', '9'];
        $numberArr = str_split($number);
        $validNumber = '';

        foreach ($numberArr as $char) {
            if (in_array($char, $validChars)) $validNumber .= $char;
        }

        if (strlen($validNumber) >= 10 && strlen($validNumber) <= 11) {
            return true;
        } else {
            return false;
        }
    }

    public function unaccent(string $value): string
    {
        $transliteration = array(
            'Ĳ' => 'I',
            'Ö' => 'O',
            'Œ' => 'O',
            'Ü' => 'U',
            'ä' => 'a',
            'æ' => 'a',
            'ĳ' => 'i',
            'ö' => 'o',
            'œ' => 'o',
            'ü' => 'u',
            'ß' => 's',
            'ſ' => 's',
            'À' => 'A',
            'Á' => 'A',
            'Â' => 'A',
            'Ã' => 'A',
            'Ä' => 'A',
            'Å' => 'A',
            'Æ' => 'A',
            'Ā' => 'A',
            'Ą' => 'A',
            'Ă' => 'A',
            'Ç' => 'C',
            'Ć' => 'C',
            'Č' => 'C',
            'Ĉ' => 'C',
            'Ċ' => 'C',
            'Ď' => 'D',
            'Đ' => 'D',
            'È' => 'E',
            'É' => 'E',
            'Ê' => 'E',
            'Ë' => 'E',
            'Ē' => 'E',
            'Ę' => 'E',
            'Ě' => 'E',
            'Ĕ' => 'E',
            'Ė' => 'E',
            'Ĝ' => 'G',
            'Ğ' => 'G',
            'Ġ' => 'G',
            'Ģ' => 'G',
            'Ĥ' => 'H',
            'Ħ' => 'H',
            'Ì' => 'I',
            'Í' => 'I',
            'Î' => 'I',
            'Ï' => 'I',
            'Ī' => 'I',
            'Ĩ' => 'I',
            'Ĭ' => 'I',
            'Į' => 'I',
            'İ' => 'I',
            'Ĵ' => 'J',
            'Ķ' => 'K',
            'Ľ' => 'K',
            'Ĺ' => 'K',
            'Ļ' => 'K',
            'Ŀ' => 'K',
            'Ł' => 'L',
            'Ñ' => 'N',
            'Ń' => 'N',
            'Ň' => 'N',
            'Ņ' => 'N',
            'Ŋ' => 'N',
            'Ò' => 'O',
            'Ó' => 'O',
            'Ô' => 'O',
            'Õ' => 'O',
            'Ø' => 'O',
            'Ō' => 'O',
            'Ő' => 'O',
            'Ŏ' => 'O',
            'Ŕ' => 'R',
            'Ř' => 'R',
            'Ŗ' => 'R',
            'Ś' => 'S',
            'Ş' => 'S',
            'Ŝ' => 'S',
            'Ș' => 'S',
            'Š' => 'S',
            'Ť' => 'T',
            'Ţ' => 'T',
            'Ŧ' => 'T',
            'Ț' => 'T',
            'Ù' => 'U',
            'Ú' => 'U',
            'Û' => 'U',
            'Ū' => 'U',
            'Ů' => 'U',
            'Ű' => 'U',
            'Ŭ' => 'U',
            'Ũ' => 'U',
            'Ų' => 'U',
            'Ŵ' => 'W',
            'Ŷ' => 'Y',
            'Ÿ' => 'Y',
            'Ý' => 'Y',
            'Ź' => 'Z',
            'Ż' => 'Z',
            'Ž' => 'Z',
            'à' => 'a',
            'á' => 'a',
            'â' => 'a',
            'ã' => 'a',
            'ā' => 'a',
            'ą' => 'a',
            'ă' => 'a',
            'å' => 'a',
            'ç' => 'c',
            'ć' => 'c',
            'č' => 'c',
            'ĉ' => 'c',
            'ċ' => 'c',
            'ď' => 'd',
            'đ' => 'd',
            'è' => 'e',
            'é' => 'e',
            'ê' => 'e',
            'ë' => 'e',
            'ē' => 'e',
            'ę' => 'e',
            'ě' => 'e',
            'ĕ' => 'e',
            'ė' => 'e',
            'ƒ' => 'f',
            'ĝ' => 'g',
            'ğ' => 'g',
            'ġ' => 'g',
            'ģ' => 'g',
            'ĥ' => 'h',
            'ħ' => 'h',
            'ì' => 'i',
            'í' => 'i',
            'î' => 'i',
            'ï' => 'i',
            'ī' => 'i',
            'ĩ' => 'i',
            'ĭ' => 'i',
            'į' => 'i',
            'ı' => 'i',
            'ĵ' => 'j',
            'ķ' => 'k',
            'ĸ' => 'k',
            'ł' => 'l',
            'ľ' => 'l',
            'ĺ' => 'l',
            'ļ' => 'l',
            'ŀ' => 'l',
            'ñ' => 'n',
            'ń' => 'n',
            'ň' => 'n',
            'ņ' => 'n',
            'ŉ' => 'n',
            'ŋ' => 'n',
            'ò' => 'o',
            'ó' => 'o',
            'ô' => 'o',
            'õ' => 'o',
            'ø' => 'o',
            'ō' => 'o',
            'ő' => 'o',
            'ŏ' => 'o',
            'ŕ' => 'r',
            'ř' => 'r',
            'ŗ' => 'r',
            'ś' => 's',
            'š' => 's',
            'ť' => 't',
            'ù' => 'u',
            'ú' => 'u',
            'û' => 'u',
            'ū' => 'u',
            'ů' => 'u',
            'ű' => 'u',
            'ŭ' => 'u',
            'ũ' => 'u',
            'ų' => 'u',
            'ŵ' => 'w',
            'ÿ' => 'y',
            'ý' => 'y',
            'ŷ' => 'y',
            'ż' => 'z',
            'ź' => 'z',
            'ž' => 'z',
            'Α' => 'A',
            'Ά' => 'A',
            'Ἀ' => 'A',
            'Ἁ' => 'A',
            'Ἂ' => 'A',
            'Ἃ' => 'A',
            'Ἄ' => 'A',
            'Ἅ' => 'A',
            'Ἆ' => 'A',
            'Ἇ' => 'A',
            'ᾈ' => 'A',
            'ᾉ' => 'A',
            'ᾊ' => 'A',
            'ᾋ' => 'A',
            'ᾌ' => 'A',
            'ᾍ' => 'A',
            'ᾎ' => 'A',
            'ᾏ' => 'A',
            'Ᾰ' => 'A',
            'Ᾱ' => 'A',
            'Ὰ' => 'A',
            'ᾼ' => 'A',
            'Β' => 'B',
            'Γ' => 'G',
            'Δ' => 'D',
            'Ε' => 'E',
            'Έ' => 'E',
            'Ἐ' => 'E',
            'Ἑ' => 'E',
            'Ἒ' => 'E',
            'Ἓ' => 'E',
            'Ἔ' => 'E',
            'Ἕ' => 'E',
            'Ὲ' => 'E',
            'Ζ' => 'Z',
            'Η' => 'I',
            'Ή' => 'I',
            'Ἠ' => 'I',
            'Ἡ' => 'I',
            'Ἢ' => 'I',
            'Ἣ' => 'I',
            'Ἤ' => 'I',
            'Ἥ' => 'I',
            'Ἦ' => 'I',
            'Ἧ' => 'I',
            'ᾘ' => 'I',
            'ᾙ' => 'I',
            'ᾚ' => 'I',
            'ᾛ' => 'I',
            'ᾜ' => 'I',
            'ᾝ' => 'I',
            'ᾞ' => 'I',
            'ᾟ' => 'I',
            'Ὴ' => 'I',
            'ῌ' => 'I',
            'Θ' => 'T',
            'Ι' => 'I',
            'Ί' => 'I',
            'Ϊ' => 'I',
            'Ἰ' => 'I',
            'Ἱ' => 'I',
            'Ἲ' => 'I',
            'Ἳ' => 'I',
            'Ἴ' => 'I',
            'Ἵ' => 'I',
            'Ἶ' => 'I',
            'Ἷ' => 'I',
            'Ῐ' => 'I',
            'Ῑ' => 'I',
            'Ὶ' => 'I',
            'Κ' => 'K',
            'Λ' => 'L',
            'Μ' => 'M',
            'Ν' => 'N',
            'Ξ' => 'K',
            'Ο' => 'O',
            'Ό' => 'O',
            'Ὀ' => 'O',
            'Ὁ' => 'O',
            'Ὂ' => 'O',
            'Ὃ' => 'O',
            'Ὄ' => 'O',
            'Ὅ' => 'O',
            'Ὸ' => 'O',
            'Π' => 'P',
            'Ρ' => 'R',
            'Ῥ' => 'R',
            'Σ' => 'S',
            'Τ' => 'T',
            'Υ' => 'Y',
            'Ύ' => 'Y',
            'Ϋ' => 'Y',
            'Ὑ' => 'Y',
            'Ὓ' => 'Y',
            'Ὕ' => 'Y',
            'Ὗ' => 'Y',
            'Ῠ' => 'Y',
            'Ῡ' => 'Y',
            'Ὺ' => 'Y',
            'Φ' => 'F',
            'Χ' => 'X',
            'Ψ' => 'P',
            'Ω' => 'O',
            'Ώ' => 'O',
            'Ὠ' => 'O',
            'Ὡ' => 'O',
            'Ὢ' => 'O',
            'Ὣ' => 'O',
            'Ὤ' => 'O',
            'Ὥ' => 'O',
            'Ὦ' => 'O',
            'Ὧ' => 'O',
            'ᾨ' => 'O',
            'ᾩ' => 'O',
            'ᾪ' => 'O',
            'ᾫ' => 'O',
            'ᾬ' => 'O',
            'ᾭ' => 'O',
            'ᾮ' => 'O',
            'ᾯ' => 'O',
            'Ὼ' => 'O',
            'ῼ' => 'O',
            'α' => 'a',
            'ά' => 'a',
            'ἀ' => 'a',
            'ἁ' => 'a',
            'ἂ' => 'a',
            'ἃ' => 'a',
            'ἄ' => 'a',
            'ἅ' => 'a',
            'ἆ' => 'a',
            'ἇ' => 'a',
            'ᾀ' => 'a',
            'ᾁ' => 'a',
            'ᾂ' => 'a',
            'ᾃ' => 'a',
            'ᾄ' => 'a',
            'ᾅ' => 'a',
            'ᾆ' => 'a',
            'ᾇ' => 'a',
            'ὰ' => 'a',
            'ᾰ' => 'a',
            'ᾱ' => 'a',
            'ᾲ' => 'a',
            'ᾳ' => 'a',
            'ᾴ' => 'a',
            'ᾶ' => 'a',
            'ᾷ' => 'a',
            'β' => 'b',
            'γ' => 'g',
            'δ' => 'd',
            'ε' => 'e',
            'έ' => 'e',
            'ἐ' => 'e',
            'ἑ' => 'e',
            'ἒ' => 'e',
            'ἓ' => 'e',
            'ἔ' => 'e',
            'ἕ' => 'e',
            'ὲ' => 'e',
            'ζ' => 'z',
            'η' => 'i',
            'ή' => 'i',
            'ἠ' => 'i',
            'ἡ' => 'i',
            'ἢ' => 'i',
            'ἣ' => 'i',
            'ἤ' => 'i',
            'ἥ' => 'i',
            'ἦ' => 'i',
            'ἧ' => 'i',
            'ᾐ' => 'i',
            'ᾑ' => 'i',
            'ᾒ' => 'i',
            'ᾓ' => 'i',
            'ᾔ' => 'i',
            'ᾕ' => 'i',
            'ᾖ' => 'i',
            'ᾗ' => 'i',
            'ὴ' => 'i',
            'ῂ' => 'i',
            'ῃ' => 'i',
            'ῄ' => 'i',
            'ῆ' => 'i',
            'ῇ' => 'i',
            'θ' => 't',
            'ι' => 'i',
            'ί' => 'i',
            'ϊ' => 'i',
            'ΐ' => 'i',
            'ἰ' => 'i',
            'ἱ' => 'i',
            'ἲ' => 'i',
            'ἳ' => 'i',
            'ἴ' => 'i',
            'ἵ' => 'i',
            'ἶ' => 'i',
            'ἷ' => 'i',
            'ὶ' => 'i',
            'ῐ' => 'i',
            'ῑ' => 'i',
            'ῒ' => 'i',
            'ῖ' => 'i',
            'ῗ' => 'i',
            'κ' => 'k',
            'λ' => 'l',
            'μ' => 'm',
            'ν' => 'n',
            'ξ' => 'k',
            'ο' => 'o',
            'ό' => 'o',
            'ὀ' => 'o',
            'ὁ' => 'o',
            'ὂ' => 'o',
            'ὃ' => 'o',
            'ὄ' => 'o',
            'ὅ' => 'o',
            'ὸ' => 'o',
            'π' => 'p',
            'ρ' => 'r',
            'ῤ' => 'r',
            'ῥ' => 'r',
            'σ' => 's',
            'ς' => 's',
            'τ' => 't',
            'υ' => 'y',
            'ύ' => 'y',
            'ϋ' => 'y',
            'ΰ' => 'y',
            'ὐ' => 'y',
            'ὑ' => 'y',
            'ὒ' => 'y',
            'ὓ' => 'y',
            'ὔ' => 'y',
            'ὕ' => 'y',
            'ὖ' => 'y',
            'ὗ' => 'y',
            'ὺ' => 'y',
            'ῠ' => 'y',
            'ῡ' => 'y',
            'ῢ' => 'y',
            'ῦ' => 'y',
            'ῧ' => 'y',
            'φ' => 'f',
            'χ' => 'x',
            'ψ' => 'p',
            'ω' => 'o',
            'ώ' => 'o',
            'ὠ' => 'o',
            'ὡ' => 'o',
            'ὢ' => 'o',
            'ὣ' => 'o',
            'ὤ' => 'o',
            'ὥ' => 'o',
            'ὦ' => 'o',
            'ὧ' => 'o',
            'ᾠ' => 'o',
            'ᾡ' => 'o',
            'ᾢ' => 'o',
            'ᾣ' => 'o',
            'ᾤ' => 'o',
            'ᾥ' => 'o',
            'ᾦ' => 'o',
            'ᾧ' => 'o',
            'ὼ' => 'o',
            'ῲ' => 'o',
            'ῳ' => 'o',
            'ῴ' => 'o',
            'ῶ' => 'o',
            'ῷ' => 'o',
            'А' => 'A',
            'Б' => 'B',
            'В' => 'V',
            'Г' => 'G',
            'Д' => 'D',
            'Е' => 'E',
            'Ё' => 'E',
            'Ж' => 'Z',
            'З' => 'Z',
            'И' => 'I',
            'Й' => 'I',
            'К' => 'K',
            'Л' => 'L',
            'М' => 'M',
            'Н' => 'N',
            'О' => 'O',
            'П' => 'P',
            'Р' => 'R',
            'С' => 'S',
            'Т' => 'T',
            'У' => 'U',
            'Ф' => 'F',
            'Х' => 'K',
            'Ц' => 'T',
            'Ч' => 'C',
            'Ш' => 'S',
            'Щ' => 'S',
            'Ы' => 'Y',
            'Э' => 'E',
            'Ю' => 'Y',
            'Я' => 'Y',
            'а' => 'A',
            'б' => 'B',
            'в' => 'V',
            'г' => 'G',
            'д' => 'D',
            'е' => 'E',
            'ё' => 'E',
            'ж' => 'Z',
            'з' => 'Z',
            'и' => 'I',
            'й' => 'I',
            'к' => 'K',
            'л' => 'L',
            'м' => 'M',
            'н' => 'N',
            'о' => 'O',
            'п' => 'P',
            'р' => 'R',
            'с' => 'S',
            'т' => 'T',
            'у' => 'U',
            'ф' => 'F',
            'х' => 'K',
            'ц' => 'T',
            'ч' => 'C',
            'ш' => 'S',
            'щ' => 'S',
            'ы' => 'Y',
            'э' => 'E',
            'ю' => 'Y',
            'я' => 'Y',
            'ð' => 'd',
            'Ð' => 'D',
            'þ' => 't',
            'Þ' => 'T',
            'ა' => 'a',
            'ბ' => 'b',
            'გ' => 'g',
            'დ' => 'd',
            'ე' => 'e',
            'ვ' => 'v',
            'ზ' => 'z',
            'თ' => 't',
            'ი' => 'i',
            'კ' => 'k',
            'ლ' => 'l',
            'მ' => 'm',
            'ნ' => 'n',
            'ო' => 'o',
            'პ' => 'p',
            'ჟ' => 'z',
            'რ' => 'r',
            'ს' => 's',
            'ტ' => 't',
            'უ' => 'u',
            'ფ' => 'p',
            'ქ' => 'k',
            'ღ' => 'g',
            'ყ' => 'q',
            'შ' => 's',
            'ჩ' => 'c',
            'ც' => 't',
            'ძ' => 'd',
            'წ' => 't',
            'ჭ' => 'c',
            'ხ' => 'k',
            'ჯ' => 'j',
            'ჰ' => 'h'
        );
        $str = str_replace(array_keys($transliteration),  array_values($transliteration), $value);
        return $str;
    }

    public function validateDate($date, $format = 'Y-m-d H:i:s'): bool
    {
        $d = DateTime::createFromFormat($format, $date);
        return $d && $d->format($format) == $date;
    }

    public function getDatesDifference($startDate, $endDate)
    {
        $startDateObj = new Carbon($startDate);
        $endDateObj = new Carbon($endDate);

        $startDateNum = $startDateObj->timestamp;
        $endDateNum = $endDateObj->timestamp;

        $differenceStr = "";
        $diffInSecs = $this->floatSub($endDateNum, $startDateNum);
        $diffInMins = intval($this->floatDiv($diffInSecs, 60));
        if ($diffInMins <= 0) {
            $differenceStr = "$diffInSecs segundos.";
            return $differenceStr;
        } else {
            $seconds = $diffInSecs - ($diffInMins * 60);
            $differenceStr = "$seconds segundos.";
        }

        $diffInHours = intval($this->floatDiv($diffInMins, 60));
        if ($diffInHours <= 0) {
            $differenceStr = "$diffInMins minutos.";
            return $differenceStr;
        } else {
            $minutes = $diffInMins - ($diffInHours * 60);
            $differenceStr = "$minutes minutos, $differenceStr";
        }

        $diffInDays = intval($this->floatDiv($diffInHours, 24));
        if ($diffInDays <= 0) {
            $differenceStr = "$diffInHours horas.";
            return $differenceStr;
        } else {
            $hours = $diffInHours - ($diffInDays * 24);
            $differenceStr = "$hours horas, $differenceStr";
        }

        return "$diffInDays días, $differenceStr";
    }

    public function validNumber(string $number, bool $decimal): bool
    {
        if ($number == '' || is_null($number)) return false;
        $validChars = ['0', '1', '2', '3', '4', '5', '6', '7', '8', '9'];
        $numberArr = str_split($number, 1);
        $pointsCount = 0;
        $cointainsInvalidChars = false;

        foreach ($numberArr as $char) {
            if ($decimal) {
                if ($char == '.') {
                    $pointsCount++;
                } else {
                    if (!in_array($char, $validChars)) $cointainsInvalidChars = true;
                }
            } else {
                if (!in_array($char, $validChars)) $cointainsInvalidChars = true;
            }
        }

        if ($decimal && $pointsCount > 1) return false;
        if ($cointainsInvalidChars) return false;
        return true;
    }
}