Open-source event management and ticket selling platform — perfect for concerts, conferences, and everything in between 🎟️ If you find this project helpful, please consider giving us a star ⭐️
PHP attendize-alternativedoor-managementevent-check-inevent-managementevent-registrationevent-ticketingeventbrite-alternativeeventslaravelopen-sourcephpreactself-hostedsell-ticketssell-tickets-onlineticket-sellingticketing-systemtickettailor-alternativetito-alternative
<?php
namespace HiEvents\Services\Application\Handlers\Admin;
use HiEvents\Models\FailedJob;
use HiEvents\Services\Application\Handlers\Admin\DTO\GetAllFailedJobsDTO;
use Illuminate\Contracts\Pagination\LengthAwarePaginator;
class GetAllFailedJobsHandler
{
private const ALLOWED_SORT_COLUMNS = ['failed_at', 'queue', 'connection'];
public function handle(GetAllFailedJobsDTO $dto): LengthAwarePaginator
{
$query = FailedJob::query();
if ($dto->search) {
$searchTerm = '%'.$dto->search.'%';
$query->where(function ($q) use ($searchTerm) {
$q->where('payload', 'ilike', $searchTerm)
->orWhere('exception', 'ilike', $searchTerm);
});
}
if ($dto->queue) {
$query->where('queue', $dto->queue);
}
$sortColumn = in_array($dto->sortBy, self::ALLOWED_SORT_COLUMNS, true) ? $dto->sortBy : 'failed_at';
$sortDirection = in_array(strtolower($dto->sortDirection ?? 'desc'), ['asc', 'desc']) ? $dto->sortDirection : 'desc';
$query->orderBy($sortColumn, $sortDirection);
return $query->paginate($dto->perPage);
}
}