EscolaLMS/H5P

<?php

namespace EscolaLms\HeadlessH5P\Traits;

use Illuminate\Database\Eloquent\Builder;

trait QueryExtendable
{
    private static array $extensionsJoin = [];
    private static array $extensionsSelect = [];
    private static array $extendQueryGroupBy = [];

    public static function extendQueryJoin(callable $extension, string $tableName): void
    {
        self::$extensionsJoin[$tableName] = $extension;
    }

    public static function applyQueryJoin(Builder $query): Builder
    {
        foreach (self::$extensionsJoin as $tableName => $extension) {
            $query->leftJoin($tableName, $extension());
        }

        return $query;
    }

    public static function extendQuerySelect(callable $extension, string $index): void
    {
        self::$extensionsSelect[$index] = $extension;
    }

    public static function applyQuerySelect(Builder $query): Builder
    {
        foreach (self::$extensionsSelect as $extension) {
            $query->addSelect($extension());
        }

        return $query;
    }

    public static function extendQueryGroupBy(callable $extension, string $index): void
    {
        self::$extendQueryGroupBy[$index] = $extension;
    }

    public static function applyQueryGroupBy(Builder $query): Builder
    {
        foreach (self::$extendQueryGroupBy as $extension) {
            $query->groupByRaw(implode(', ', $extension()));
        }

        return $query;
    }
}