flipbox\craft\domains\fields\ModifyElementsQueryTrait

Complexity

Total Complexity

13

Size/Duplication

Total Lines	99
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Test Coverage

Coverage

0%

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	modifyElementsQuery()	0	17	5
A	modifyElementsQueryForStringValue()	0	13	4
A	modifyElementsQueryForTargetValue()	0	18	1
A	modifyElementsQueryForEmptyValue()	0	13	2
A	emptyValueSubSelect()	0	10	1

<?php
/**
 * @copyright  Copyright (c) Flipbox Digital Limited
 * @license    https://github.com/flipboxfactory/craft-sortable-associations/blob/master/LICENSE
 * @link       https://github.com/flipboxfactory/craft-sortable-associations
 */

namespace flipbox\craft\domains\fields;

use craft\elements\db\ElementQuery;
use craft\elements\db\ElementQueryInterface;
use craft\helpers\Db;
use flipbox\craft\domains\records\Domain;

/**
 * @author Flipbox Factory <hello@flipboxfactory.com>
 * @since 1.0.0
 *
 * @property int $id
 */
trait ModifyElementsQueryTrait
{
    /**
     * @inheritdoc
     */
    public function modifyElementsQuery(
        ElementQueryInterface $query,
        $value
    ) {
        if ($value === null || !$query instanceof ElementQuery) {
            return null;
        }
        if ($value === false) {
            return false;
        }
        if (is_string($value)) {
            $this->modifyElementsQueryForStringValue($query, $value);
            return null;
        }
        $this->modifyElementsQueryForTargetValue($query, $value);
        return null;
    }

    /**
     * @param ElementQuery $query
     * @param string $value
     */
    protected function modifyElementsQueryForStringValue(
        ElementQuery $query,
        string $value
    ) {
        if ($value === 'not :empty:') {
            $value = ':notempty:';
        }
        if ($value === ':notempty:' || $value === ':empty:') {
            $this->modifyElementsQueryForEmptyValue($query, $value);
            return;
        }
        $this->modifyElementsQueryForTargetValue($query, $value);
    }

    /**
     * @param ElementQuery $query
     * @param $value
     */
    protected function modifyElementsQueryForTargetValue(
        ElementQuery $query,
        $value
    ) {
        $alias = Domain::tableAlias();
        $name = Domain::tableName();

        $joinTable = "{$name} {$alias}";
        $query->query->innerJoin($joinTable, "[[{$alias}.elementId]] = [[subquery.elementsId]]");
        $query->subQuery->innerJoin($joinTable, "[[{$alias}.elementId]] = [[elements.id]]");
        $query->subQuery->andWhere(
            Db::parseParam($alias . '.fieldId', $this->id)

It seems like \craft\helpers\Db::parseParam($alias . '.fieldId', $this->id) targeting craft\helpers\Db::parseParam() can also be of type string; however, craft\db\Query::andWhere() does only seem to accept array, maybe add an additional type check?

        );
        $query->subQuery->andWhere(
            Db::parseParam($alias . '.domain', $value)

It seems like \craft\helpers\Db::parseParam($alias . '.domain', $value) targeting craft\helpers\Db::parseParam() can also be of type string; however, craft\db\Query::andWhere() does only seem to accept array, maybe add an additional type check?

        );
        $query->query->distinct(true);
    }

    /**
     * @param ElementQuery $query
     * @param string $value
     */
    protected function modifyElementsQueryForEmptyValue(
        ElementQuery $query,
        string $value
    ) {
        $operator = ($value === ':notempty:' ? '!=' : '=');
        $query->subQuery->andWhere(
            $this->emptyValueSubSelect(

$this->emptyValueSubSelect(\flipbox\craft\domains\records\Domain::tableAlias(), \flipbox\craft\domains\records\Domain::tableName(), $operator) is of type string, but the function expects a array.

                Domain::tableAlias(),
                Domain::tableName(),
                $operator
            )
        );
    }

    /**
     * @param string $alias
     * @param string $name
     * @param string $operator
     * @return string
     */
    protected function emptyValueSubSelect(
        string $alias,
        string $name,
        string $operator
    ): string {
        return "(select count([[{$alias}.elementId]]) from " .
            $name .
            " {{{$alias}}} where [[{$alias}.elementId" .
            "]] = [[elements.id]] and [[{$alias}.fieldId]] = {$this->id}) {$operator} 0";
    }
}