efureev/laravel-support-db

<?php

declare(strict_types=1);

namespace Php\Support\Laravel\Database\Schema\Postgres\Compilers;

use Illuminate\Support\Fluent;
use Php\Support\Laravel\Database\Schema\Postgres\Blueprint;
use Php\Support\Laravel\Database\Schema\Postgres\Grammar;

trait WheresBuilder
{
    protected static function whereRaw(Grammar $grammar, Blueprint $blueprint, array $where = []): string
    {
        return call_user_func_array(
            'sprintf',
            array_merge(
                [str_replace('?', '%s', $where['sql'])],
                static::wrapValues($where['bindings'])
            )
        );
    }

    protected static function whereBasic(Grammar $grammar, Blueprint $blueprint, array $where): string
    {
        return implode(
            ' ',
            [
                $grammar->wrap($where['column']),
                $where['operator'],
                static::wrapValue($where['value']),
            ]
        );
    }

    protected static function whereColumn(Grammar $grammar, Blueprint $blueprint, array $where): string
    {
        return implode(
            ' ',
            [
                $grammar->wrap($where['first']),
                $where['operator'],
                $grammar->wrap($where['second']),
            ]
        );
    }

    protected static function whereIn(Grammar $grammar, Blueprint $blueprint, array $where = []): string
    {
        if (!empty($where['values'])) {
            return implode(
                ' ',
                [
                    $grammar->wrap($where['column']),
                    'in',
                    '(' . implode(',', static::wrapValues($where['values'])) . ')',
                ]
            );
        }
        return '0 = 1';
    }

    protected static function whereNotIn(Grammar $grammar, Blueprint $blueprint, array $where = []): string
    {
        if (!empty($where['values'])) {
            return implode(
                ' ',
                [
                    $grammar->wrap($where['column']),
                    'not in',
                    '(' . implode(',', static::wrapValues($where['values'])) . ')',
                ]
            );
        }
        return '1 = 1';
    }

    protected static function whereBoolean(Grammar $grammar, Blueprint $blueprint, array $where): string
    {
        return implode(' ', [$grammar->wrap($where['column']), 'is ' . static::wrapValueForBool($where['value'])]);
    }

    protected static function whereNull(Grammar $grammar, Blueprint $blueprint, array $where): string
    {
        return implode(' ', [$grammar->wrap($where['column']), 'is null']);
    }

    protected static function whereNotNull(Grammar $grammar, Blueprint $blueprint, array $where): string
    {
        return implode(' ', [$grammar->wrap($where['column']), 'is not null']);
    }

    protected static function whereBetween(Grammar $grammar, Blueprint $blueprint, array $where): string
    {
        return implode(
            ' ',
            [
                $grammar->wrap($where['column']),
                $where['not'] ? 'not between' : 'between',
                static::wrapValue(reset($where['values'])),
                'and',
                static::wrapValue(end($where['values'])),
            ]
        );
    }

    protected static function wrapValues(array $values = []): array
    {
        return collect($values)->map(
            function ($value) {
                return static::wrapValue($value);
            }
        )->toArray();
    }

    protected static function wrapValue($value)
    {
        if (is_string($value)) {
            return "'{$value}'";
        }
        return (int)$value;
    }

    protected static function wrapValueForBool(bool $value): string
    {
        return $value ? 'TRUE' : 'FALSE';
    }

    protected static function removeLeadingBoolean(string $value): string
    {
        return preg_replace('/and |or /i', '', $value, 1);
    }

    private static function build(Grammar $grammar, Blueprint $blueprint, Fluent $command): array
    {
        return collect($command->get('wheres'))
            ->map(
                static function ($where) use ($grammar, $blueprint) {
                    return implode(
                        ' ',
                        [
                            $where['boolean'],
                            '(' . static::{"where{$where['type']}"}($grammar, $blueprint, $where) . ')',
                        ]
                    );
                }
            )
            ->all();
    }
}