tsukasa-mixer / QueryBuilder

src/BaseLookupCollection.php

<?php

namespace Tsukasa\QueryBuilder;

use Tsukasa\QueryBuilder\Expression\Expression;
use Tsukasa\QueryBuilder\Interfaces\IAdapter;
use Tsukasa\QueryBuilder\Interfaces\ILookupCollection;
use Tsukasa\QueryBuilder\Interfaces\ISQLGenerator;

class BaseLookupCollection implements ILookupCollection
{
    /**
     * @param $lookup
     * @return bool
     */
    public function has($lookup)
    {
        return in_array(strtolower($lookup), [
            'exact', 'gte', 'gt', 'lte', 'lt',
            'range', 'isnt', 'isnull', 'contains',
            'icontains', 'startswith', 'istartswith',
            'endswith', 'iendswith', 'in', 'raw'
        ]);
    }

    /**
     * @param IAdapter|ISQLGenerator $adapter
     * @param $lookup
     * @param $column
     * @param $value
     * @return string
     */
    public function process(IAdapter $adapter, $lookup, $column, $value)
    {
        switch (strtolower($lookup)) {
            case 'exact':
                if ($value instanceof \DateTime) {
                    $value = $adapter->getDateTime($value);

The method getDateTime() does not exist on Tsukasa\QueryBuilder\Interfaces\IAdapter. Since it exists in all sub-types, consider adding an abstract or default implementation to Tsukasa\QueryBuilder\Interfaces\IAdapter.

                }

                if ($value instanceof Expression) {
                    $sqlValue = $value->toSQL();
                }
                else if ($value instanceof QueryBuilder) {
                    $sqlValue = '(' . $value->toSQL() . ')';
                }
                else if (strpos($value, 'SELECT') !== false) {
                    $sqlValue = '(' . $value . ')';
                }
                else {
                    $sqlValue = $adapter->quoteValue($value);
                }
                return $adapter->quoteColumn($column) . '=' . $sqlValue;

            case 'gte':
                if ($value instanceof \DateTime) {
                    $value = $adapter->getDateTime($value);
                }
                return $adapter->quoteColumn($column) . '>=' . $adapter->quoteValue($value);

            case 'gt':
                if ($value instanceof \DateTime) {
                    $value = $adapter->getDateTime($value);
                }
                return $adapter->quoteColumn($column) . '>' . $adapter->quoteValue($value);

            case 'lte':
                if ($value instanceof \DateTime) {
                    $value = $adapter->getDateTime($value);
                }
                return $adapter->quoteColumn($column) . '<=' . $adapter->quoteValue($value);

            case 'lt':
                if ($value instanceof \DateTime) {
                    $value = $adapter->getDateTime($value);
                }
                return $adapter->quoteColumn($column) . '<' . $adapter->quoteValue($value);

            case 'range':
                list($min, $max) = $value;
                return $adapter->quoteColumn($column) . ' BETWEEN ' . $adapter->quoteValue($min) . ' AND ' . $adapter->quoteValue($max);

            case 'isnt':
                if (in_array($adapter->getSqlType($value), ['TRUE', 'FALSE', 'NULL'])) {

The method getSqlType() does not exist on Tsukasa\QueryBuilder\Interfaces\IAdapter. Since it exists in all sub-types, consider adding an abstract or default implementation to Tsukasa\QueryBuilder\Interfaces\IAdapter.

                    return $adapter->quoteColumn($column) . ' IS NOT ' . $adapter->getSqlType($value);
                }

                return $adapter->quoteColumn($column) . '!=' . $adapter->quoteValue($value);

            case 'isnull':
                return $adapter->quoteColumn($column) . ' ' . ((bool)$value ? 'IS NULL' : 'IS NOT NULL');

            case 'contains':
                return $adapter->quoteColumn($column) . ' LIKE ' . $adapter->quoteValue('%' . $value . '%');

            case 'icontains':
                return 'LOWER(' . $adapter->quoteColumn($column) . ') LIKE ' . $adapter->quoteValue('%' . mb_strtolower($value, 'UTF-8') . '%');

            case 'startswith':
                return $adapter->quoteColumn($column) . ' LIKE ' . $adapter->quoteValue($value . '%');

            case 'istartswith':
                return 'LOWER(' . $adapter->quoteColumn($column) . ') LIKE ' . $adapter->quoteValue(mb_strtolower($value, 'UTF-8') . '%');

            case 'endswith':
                return $adapter->quoteColumn($column) . ' LIKE ' . $adapter->quoteValue('%' . $value);

            case 'iendswith':
                return 'LOWER(' . $adapter->quoteColumn($column) . ') LIKE ' . $adapter->quoteValue('%' . mb_strtolower($value, 'UTF-8'));

            case 'in':
                if (is_array($value)) {
                    $quotedValues = array_map(function($item) use ($adapter) {
                        return $adapter->quoteValue($item);
                    }, $value);
                    $sqlValue = implode(', ', $quotedValues);
                }
                else if ($value instanceof QueryBuilder) {
                    $sqlValue = $value->toSQL();
                }
                else {
                    $sqlValue = $adapter->quoteSql($value);

The method quoteSql() does not exist on Tsukasa\QueryBuilder\Interfaces\IAdapter. Since it exists in all sub-types, consider adding an abstract or default implementation to Tsukasa\QueryBuilder\Interfaces\IAdapter.

                }
                return $adapter->quoteColumn($column) . ' IN (' . $sqlValue . ')';

            case 'raw':
                return $adapter->quoteColumn($column) . ' ' . $adapter->quoteSql($value);

            default:
                return null;
        }
    }
}