CSlant\Blog\Api\Supports\Queries\QueryPost

Complexity

Total Complexity

17

Size/Duplication

Total Lines	90
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
F	setBaseCustomFilterQuery()	0	53	11
A	search()	0	21	6

<?php

namespace CSlant\Blog\Api\Supports\Queries;

use Botble\Base\Models\BaseQueryBuilder;

The type Botble\Base\Models\BaseQueryBuilder was not found. Maybe you did not declare it correctly or list all dependencies?

use Botble\Language\Facades\Language;

The type Botble\Language\Facades\Language was not found. Maybe you did not declare it correctly or list all dependencies?

use CSlant\Blog\Core\Models\Post;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Query\Builder;

class QueryPost
{
    /**
     * @param  BaseQueryBuilder|Builder<Model>  $query
     * @param  array<string, mixed>  $filters
     *
     * @return BaseQueryBuilder|Builder<Model>|Post
     */
    public static function setBaseCustomFilterQuery(
        Builder|BaseQueryBuilder $query,
        array $filters
    ): Builder|BaseQueryBuilder|Post {
        if ($filters['tags'] !== null) {
            $tags = array_filter((array) $filters['tags']);

            $query = $query->whereHas('tags', function (BaseQueryBuilder|Builder $query) use ($tags): void {
                $query->whereIn('tags.id', $tags);
            });
        }

        if ($filters['categories'] !== null) {
            $categories = array_filter((array) $filters['categories']);

            $query = $query->whereHas('categories', function (BaseQueryBuilder|Builder $query) use ($categories): void {
                $query->whereIn('categories.id', $categories);
            });
        }

        if ($filters['categories_exclude'] !== null) {
            $query = $query
                ->whereHas('categories', function (BaseQueryBuilder|Builder $query) use ($filters): void {
                    $query->whereNotIn('categories.id', array_filter((array) $filters['categories_exclude']));
                });
        }

        if ($filters['exclude'] !== null) {
            $query = $query->whereNotIn('id', array_filter((array) $filters['exclude']));
        }

        if ($filters['include'] !== null) {
            $query = $query->whereNotIn('id', array_filter((array) $filters['include']));
        }

        if ($filters['author'] !== null) {
            $query = $query->whereIn('author_id', array_filter((array) $filters['author']));
        }

        if ($filters['author_exclude'] !== null) {
            $query = $query->whereNotIn('author_id', array_filter((array) $filters['author_exclude']));
        }

        if ($filters['featured'] !== null) {
            $query = $query->where('is_featured', $filters['featured']);
        }

        if ($filters['search'] !== null) {
            $keyword = isset($filters['search']) ? (string) $filters['search'] : null;
            $query = self::search($query, $keyword);
        }

        return $query;
    }

    /**
     * @param  BaseQueryBuilder|Builder<Model>  $model
     * @param  null|string  $keyword
     *
     * @return BaseQueryBuilder|Builder<Model>
     */
    public static function search(Builder|BaseQueryBuilder $model, ?string $keyword): Builder|BaseQueryBuilder
    {
        if (!$model instanceof BaseQueryBuilder || !$keyword) {
            return $model;
        }

        if (is_plugin_active('language')
            && is_plugin_active('language-advanced')
            && Language::getCurrentLocale() != Language::getDefaultLocale()
        ) {
            return $model
                ->whereHas('translations', function (BaseQueryBuilder $query) use ($keyword): void {
                    $query->addSearch('name', $keyword, false, false)
                        ->addSearch('description', $keyword, false);
                });
        }

        return $model
            ->where(function (BaseQueryBuilder $query) use ($keyword): void {
                $query->addSearch('name', $keyword, false, false)
                    ->addSearch('description', $keyword, false);
            });
    }
}