Rocket\Taxonomy\Utils\RecursiveQuery

Complexity

Total Complexity

11

Size/Duplication

Total Lines	100
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	5

Test Coverage

Coverage

100%

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	getAncestry()	0	10	2
A	getAncestryInitialQuery()	0	4	1
A	getRecursiveAncestry()	0	8	2
A	getDescent()	0	10	2
A	getDescentInitialQuery()	0	4	1
A	getRecursiveDescent()	0	8	2

<?php

/**
 * The simple implementation of a recursive query.
 */
namespace Rocket\Taxonomy\Utils;

use Illuminate\Support\Arr;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Rocket\Taxonomy\Model\Hierarchy;

/**
 * This Class handles recusive queries to retrieve
 * parent-child relations for terms.
 */
class RecursiveQuery implements RecursiveQueryInterface
{
    /**
     * @var string The table in which hierarchical data is stored
     */
    protected $hierarchyTable;

    /**
     * This Class handles recusive queries to retrieve
     * parent-child relations for terms.
     */
    public function __construct()
    {
        $this->hierarchyTable = (new Hierarchy)->getTable();
    }

    /**
     * Get all ancestors of a term
     *
     * @param int $id The term ID
     * @return \Illuminate\Support\Collection
     */
    public function getAncestry($id)
    {
        $all_results = new Collection(DB::select($this->getAncestryInitialQuery(), [':id' => $id]));

        if (count($all_results)) {
            $this->getRecursiveAncestry($all_results, $all_results->pluck('parent_id'));
        }

        return $all_results;
    }

    /**
     * Get the query to initiate the recursive query.
     *
     * @return string
     */
    protected function getAncestryInitialQuery()
    {
        return "select term_id, parent_id from $this->hierarchyTable where term_id = :id";
    }

    /**
     * Get the ancestry recursively
     *
     * @param Collection $all_results
     * @param int[] $ids
     */
    protected function getRecursiveAncestry(Collection $all_results, $ids)
    {
        $all_results->merge($results = DB::table($this->hierarchyTable)->whereIn('term_id', $ids)->get());

        if (count($results)) {
            $this->getRecursiveAncestry($all_results, Arr::pluck($results, 'parent_id'));
        }
    }

    /**
     * Get all descendants of a term.
     *
     * @param int $id The term ID
     * @return \Illuminate\Support\Collection
     */
    public function getDescent($id)
    {
        $all_results = new Collection(DB::select($this->getDescentInitialQuery(), [':id' => $id]));

        if (count($all_results)) {
            $this->getRecursiveDescent($all_results, $all_results->pluck('term_id'));
        }

        return $all_results;
    }

    /**
     * Get the query to initiate the recursive query.
     *
     * @return string
     */
    protected function getDescentInitialQuery()
    {
        return "select term_id, parent_id from $this->hierarchyTable where parent_id = :id";
    }

    /**
     * Get the descent recursively.
     *
     * @param Collection $all_results
     * @param int[] $ids
     */
    protected function getRecursiveDescent(Collection $all_results, $ids)
    {
        $all_results->merge($results = DB::table($this->hierarchyTable)->whereIn('parent_id', $ids)->get());

        if (count($results)) {
            $this->getRecursiveDescent($all_results, Arr::pluck($results, 'term_id'));
        }
    }
}