umbrellio / laravel-ltree

src/Helpers/LTreeHelper.php

<?php

declare(strict_types=1);

namespace Umbrellio\LTree\Helpers;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;
use Umbrellio\LTree\Interfaces\LTreeInterface;
use Umbrellio\LTree\Interfaces\LTreeModelInterface;
use Umbrellio\LTree\Types\LTreeType;

class LTreeHelper
{
    /**
     * @param LTreeInterface|Model $model
     */
    public function buildPath($model): void
    {
        $pathValue = [];
        if ($model->getLtreeParentId()) {

The method getLtreeParentId() does not exist on Illuminate\Database\Eloquent\Model. It seems like you code against a sub-type of Illuminate\Database\Eloquent\Model such as Umbrellio\LTree\tests\_data\Models\CategoryStub or Umbrellio\LTree\tests\_data\Models\ProductStub.

The expression $model->getLtreeParentId() of type integer|null is loosely compared to true; this is ambiguous if the integer can be 0. You might want to explicitly use !== null instead.

            $parent = $model->ltreeParent;
            $pathValue = array_merge($pathValue, $parent->getLtreePath());
        }
        $pathValue[] = $model->getKey();

The method getKey() does not exist on Illuminate\Database\Eloquent\Model. It seems like you code against a sub-type of Illuminate\Database\Eloquent\Model such as Umbrellio\LTree\tests\_data\Models\CategoryStub or Umbrellio\LTree\tests\_data\Models\ProductStub.

The method getKey() does not exist on Umbrellio\LTree\Interfaces\LTreeInterface. Since it exists in all sub-types, consider adding an abstract or default implementation to Umbrellio\LTree\Interfaces\LTreeInterface.

        DB::statement(sprintf(
            "UPDATE %s SET %s = text2ltree('%s') WHERE %s = %s",
            $model->getTable(),

The method getTable() does not exist on Illuminate\Database\Eloquent\Model. It seems like you code against a sub-type of Illuminate\Database\Eloquent\Model such as Illuminate\Database\Eloquent\Relations\Pivot.

The method getTable() does not exist on Umbrellio\LTree\Interfaces\LTreeInterface.

            $model->getLtreePathColumn(),

The method getLtreePathColumn() does not exist on Illuminate\Database\Eloquent\Model. It seems like you code against a sub-type of Illuminate\Database\Eloquent\Model such as Umbrellio\LTree\tests\_data\Models\CategoryStub or Umbrellio\LTree\tests\_data\Models\ProductStub.

            implode(LTreeType::TYPE_SEPARATE, $pathValue),
            $model->getKeyName(),

The method getKeyName() does not exist on Illuminate\Database\Eloquent\Model. It seems like you code against a sub-type of Illuminate\Database\Eloquent\Model such as Umbrellio\LTree\tests\_data\Models\CategoryStub or Umbrellio\LTree\tests\_data\Models\ProductStub.

The method getKeyName() does not exist on Umbrellio\LTree\Interfaces\LTreeInterface. Since it exists in all sub-types, consider adding an abstract or default implementation to Umbrellio\LTree\Interfaces\LTreeInterface.

            $model->getKey()
        ));
        $model->refresh();

The method refresh() does not exist on Illuminate\Database\Eloquent\Model.

The method refresh() does not exist on Umbrellio\LTree\Interfaces\LTreeInterface.

    }

    /**
     * @param LTreeInterface|Model $model
     * @param LTreeInterface|Model|null $to
     */
    public function moveNode($model, $to = null, array $columns = []): void
    {
        $pathName = $model->getLtreePathColumn();
        $oldPath = $model->getLtreePath(LTreeModelInterface::AS_STRING);

The method getLtreePath() does not exist on Illuminate\Database\Eloquent\Model. It seems like you code against a sub-type of Illuminate\Database\Eloquent\Model such as Umbrellio\LTree\tests\_data\Models\CategoryStub or Umbrellio\LTree\tests\_data\Models\ProductStub.

        $newPath = $to ? $to->getLtreePath(LTreeModelInterface::AS_STRING) : '';
        $expressions = static::wrapExpressions($columns);
        $expressions[] = "
            \"${pathName}\" = (text2ltree('${newPath}') || subpath(\"${pathName}\", (nlevel(text2ltree('${oldPath}')) - 1)))
        ";

        DB::statement(sprintf(
            "UPDATE %s SET %s WHERE (%s <@ text2ltree('%s')) = true",
            $model->getTable(),
            implode(', ', $expressions),
            $pathName,
            $oldPath
        ));
        $model->refresh();
    }

    /**
     * @param LTreeInterface|Model $model
     */
    public function dropDescendants($model, array $columns = []): void
    {
        $sql = sprintf(
            "UPDATE %s SET %s WHERE (%s <@ text2ltree('%s')) = true",
            $model->getTable(),
            implode(', ', static::wrapExpressions($columns)),
            $model->getLtreePathColumn(),
            $model->getLtreePath(LTreeModelInterface::AS_STRING)
        );
        DB::statement($sql);
        $model->refresh();
    }

    private function wrapExpressions(array $columns): array
    {
        $expressions = [];
        foreach ($columns as $column => $value) {
            switch (true) {
                case $value === null:
                    $expressions[] = sprintf('%s = null', (string) $column);
                    break;
                case is_string($value):
                    $expressions[] = sprintf("%s = '%s'", (string) $column, (string) $value);
                    break;
                default:
                    $expressions[] = sprintf('%s = %s', (string) $column, (string) $value);
            }
        }
        return $expressions;
    }
}