> */ final readonly class GetPaginatedSlidesQuery implements Query { public function __construct( private DataTableService $dataTable, ) { } public function __invoke(QueryInput $input): LengthAwarePaginator { Assert::isAOf( $input, GetPaginatedSlidesQueryInput::class, ); $query = Slide::query(); if ($input->publishedOnly) { $now = Date::now(); $query->where(function ($q) use ($now): void { $q->whereNull('date_start') ->orWhere('date_start', '<=', $now); })->where(function ($q) use ($now): void { $q->whereNull('date_end') ->orWhere('date_end', '>=', $now); }); } if ($input->forConnectedCustomers === false) { $query->where('connected', false); } $this->dataTable->sortQuery(Slide::class, $query); $paginator = $this->dataTable->paginateQuery($query, $input->pagination); return $paginator->through(fn (Slide $slide): SlideDto => SlideDto::fromModel($slide)); } }