flipbox\craft\element\lists\queries\AssociationQuery

Complexity

Total Complexity

29

Size/Duplication

Total Lines	203
Duplicated Lines	0 %

Coupling/Cohesion

Components	2
Dependencies	8

Test Coverage

Coverage

0%

Importance

Changes

0

15 Methods

Rating	Name	Duplication	Size	Complexity
A	sortOrder()	0	5	1
A	setSortOrder()	0	4	1
A	setTargetId()	0	4	1
A	targetId()	0	4	1
A	setTarget()	0	5	1
A	target()	0	4	1
A	setSourceId()	0	4	1
A	sourceId()	0	4	1
A	setSource()	0	5	1
A	source()	0	4	1
A	init()	0	12	3
B	prepare()	0	28	10
A	applyFieldConditions()	0	6	2
A	applySiteConditions()	0	6	2
A	parseElementValue()	0	14	2

<?php

/**
 * @copyright  Copyright (c) Flipbox Digital Limited
 * @license    https://github.com/flipboxfactory/craft-element-lists/LICENSE
 * @link       https://github.com/flipboxfactory/craft-element-lists/
 */

namespace flipbox\craft\element\lists\queries;

use craft\base\ElementInterface;
use craft\db\QueryAbortedException;
use craft\helpers\Db;
use flipbox\craft\element\lists\records\Association;
use flipbox\craft\ember\helpers\QueryHelper;
use flipbox\craft\ember\queries\AuditAttributesTrait;
use flipbox\craft\ember\queries\CacheableActiveQuery;
use flipbox\craft\ember\queries\FieldAttributeTrait;
use yii\db\Query;

/**
 * @author Flipbox Factory <hello@flipboxfactory.com>
 * @since 2.0.0
 *
 * @method Association[] getCachedResult()
 * @method Association[] all()
 * @method Association one()
 */
class AssociationQuery extends CacheableActiveQuery
{
    use AuditAttributesTrait,
        FieldAttributeTrait,
        SourceSiteAttributeTrait;

    /**
     * @var int|null Sort order
     */
    public $sortOrder;

    /**
     * @var string|string[]|null
     */
    public $target;

    /**
     * @var string|string[]|null
     */
    public $source;

    /**
     * @param $value
     * @return $this
     */
    public function sortOrder($value)
    {
        $this->sortOrder = $value;
        return $this;
    }

    /**
     * @param $value
     * @return $this
     */
    public function setSortOrder($value)
    {
        return $this->sortOrder($value);
    }

    /**
     * @param int|int[]|string|string[]|ElementInterface|ElementInterface[]|false|null $value
     * @return static
     */
    public function setTargetId($value)
    {
        return $this->setTarget($value);
    }

    /**
     * @param int|int[]|string|string[]|ElementInterface|ElementInterface[]|false|null $value
     * @return static
     */
    public function targetId($value)
    {
        return $this->setTarget($value);
    }

    /**
     * @param int|int[]|string|string[]|ElementInterface|ElementInterface[]|false|null $value
     * @return static
     */
    public function setTarget($value)
    {
        $this->target = $value;
        return $this;
    }

    /**
     * @param int|int[]|string|string[]|ElementInterface|ElementInterface[]|false|null $value
     * @return static
     */
    public function target($value)
    {
        return $this->setTarget($value);
    }


    /**
     * @param int|int[]|string|string[]|ElementInterface|ElementInterface[]|false|null $value
     * @return static
     */
    public function setSourceId($value)
    {
        return $this->setSource($value);
    }

    /**
     * @param int|int[]|string|string[]|ElementInterface|ElementInterface[]|false|null $value
     * @return static
     */
    public function sourceId($value)
    {
        return $this->setSource($value);
    }

    /**
     * @param int|int[]|string|string[]|ElementInterface|ElementInterface[]|false|null $value
     * @return static
     */
    public function setSource($value)
    {
        $this->source = $value;
        return $this;
    }

    /**
     * @param int|int[]|string|string[]|ElementInterface|ElementInterface[]|false|null $value
     * @return static
     */
    public function source($value)
    {
        return $this->setSource($value);
    }

    /**
     * @inheritdoc
     */
    public function init()
    {
        parent::init();

        if ($this->select === null) {
            $this->select = ['*'];
        }

        if ($this->orderBy === null) {
            $this->orderBy = ['sortOrder' => SORT_ASC];
        }
    }

    /**
     * @inheritdoc
     * @throws QueryAbortedException
     */
    public function prepare($builder)
    {
        // Is the query already doomed?
        if (($this->field !== null && empty($this->field)) ||
            ($this->target !== null && empty($this->target)) ||
            ($this->source !== null && empty($this->source))
        ) {
            throw new QueryAbortedException();
        }

        $this->applyFieldConditions();
        $this->applySiteConditions();
        $this->applyAuditAttributeConditions();

        if ($this->sortOrder !== null) {
            $this->andWhere(Db::parseParam('sortOrder', $this->sortOrder));
        }

        if ($this->target !== null) {
            $this->andWhere(Db::parseParam('targetId', $this->parseElementValue($this->target)));
        }

        if ($this->source !== null) {
            $this->andWhere(Db::parseParam('sourceId', $this->parseElementValue($this->source)));
        }

        return parent::prepare($builder);
    }

    /**
     * Apply attribute conditions
     */
    protected function applyFieldConditions()
    {
        if ($this->field !== null) {
            $this->andWhere(Db::parseParam('fieldId', $this->parseFieldValue($this->field)));
        }
    }

    /**
     * Apply attribute conditions
     */
    protected function applySiteConditions()
    {
        if ($this->site !== null) {
            $this->andWhere(Db::parseParam('sourceSiteId', $this->parseSiteValue($this->site)));
        }
    }

    /**
     * @param $value
     * @return array|string
     */
    protected function parseElementValue($value)
    {
        return QueryHelper::prepareParam(
            $value,
            function (string $uri) {
                $value = (new Query())
                    ->select(['id'])
                    ->from(['{{%elements_sites}} elements_sites'])
                    ->where(['uri' => $uri])
                    ->scalar();
                return empty($value) ? false : $value;
            }
        );
    }
}