LaravelHelpers

LaravelHelpers.php

<?php

/**
 * Return the SQL query with the bindings.
 *
 * @param \Illuminate\Database\Eloquent\Builder $query
 * @return string
 */
function getSql(Builder $query): string
{
    $bindings = $query->getBindings();

    return preg_replace_callback('/\?/', function ($match) use (&$bindings, $query) {
        return $query->getConnection()->getPdo()->quote(array_shift($bindings));
    }, $query->toSql());
}

/**
 * Removes all non-numeric characters from a string.
 *
 * @param string $string
 * @return string
 */
function onlyNumbers($string): string
{
    return preg_replace('/\D/', '', $string);
}

/**
 * Returns the next work day.
 *
 * @param Carbon|null $date
 * @return Carbon
 */
function nextWorkDay(Carbon $date = null)
{
    $date = $date ?? today();
    while ($date->isHoliday() || $date->isWeekend() || $date->isPast()) {
        $date->addDay();
    }

    return $date;
}