58 lines
1.6 KiB
PHP
58 lines
1.6 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace App\Queries\Slides;
|
|
|
|
use App\Contracts\Query;
|
|
use App\Contracts\QueryInput;
|
|
use App\Dto\SlideDto;
|
|
use App\Models\Slide;
|
|
use App\Services\DataTableService;
|
|
use Illuminate\Contracts\Pagination\LengthAwarePaginator;
|
|
use Illuminate\Support\Facades\Date;
|
|
use Webmozart\Assert\Assert;
|
|
|
|
/**
|
|
* phpcs:disable Generic.Files.LineLength.TooLong
|
|
*
|
|
* @implements \App\Contracts\Query<\App\Queries\Slides\GetPaginatedSlidesQueryInput, \Illuminate\Contracts\Pagination\LengthAwarePaginator<int, \App\Dto\SlideDto>>
|
|
*/
|
|
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));
|
|
}
|
|
}
|