Statamic Custom Query - filteredPosts

FilteredPostsQuery.php

<?php

namespace App\GraphQL\Queries;

use GraphQL\Type\Definition\Type;
use Illuminate\Support\Str;
use Statamic\Facades\Entry;
use Statamic\Facades\GraphQL;
use Statamic\GraphQL\Middleware\ResolvePage;
use Statamic\GraphQL\Queries\Concerns\FiltersQuery;
use Statamic\GraphQL\Queries\Query;
use Statamic\GraphQL\Types\JsonArgument;

class FilteredPostsQuery extends Query
{
    use FiltersQuery;

    protected $attributes = [
        'name' => 'filteredPosts',
    ];

    protected $middleware = [
        ResolvePage::class,
    ];

    public function type(): Type
    {
        return GraphQL::paginate(
            GraphQL::type('Entry_Blog_Post')
        );
    }

    public function args(): array
    {
        return [
            'limit' => GraphQL::int(),
            'page' => GraphQL::int(),
            'site' => GraphQL::string(),
            'filter' => GraphQL::type(JsonArgument::NAME),
            'sort' => GraphQL::listOf(GraphQL::string()),
        ];
    }

    public function resolve($root, $args)
    {
        $filters = $args['filter'] ?? [];

        $query = Entry::query()
            ->where('site', $args['site'])
            ->where('collection', 'blog')
            ->whereIn('blueprint', ['post', 'cluster']);

        foreach ($filters as $key => &$definitions) {
            if (isset($definitions['json_contains']) && is_array($definitions['json_contains'])) {
                $query->whereJsonContains($key, $definitions['json_contains']);
                unset($definitions['json_contains']);
            }
        }

        $this->filterQuery($query, $filters);

        $this->sortQuery($query, $args['sort'] ?? []);

        return $query->paginate($args['limit'] ?? 1000);
    }

    private function sortQuery($query, $sorts)
    {
        if (empty($sorts)) {
            $sorts = ['date'];
        }

        foreach ($sorts as $sort) {
            $order = 'desc';

            if (Str::contains($sort, ' ')) {
                [$sort, $order] = explode(' ', $sort);
            }

            $query->orderBy($sort, $order);
        }
    }
}