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\Repository\Eloquent;
use HiEvents\DomainObjects\CapacityAssignmentDomainObject;
use HiEvents\DomainObjects\Generated\CapacityAssignmentDomainObjectAbstract;
use HiEvents\Http\DTO\QueryParamsDTO;
use HiEvents\Models\CapacityAssignment;
use HiEvents\Repository\Interfaces\CapacityAssignmentRepositoryInterface;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Pagination\LengthAwarePaginator;
/**
* @extends BaseRepository<CapacityAssignmentDomainObject>
*/
class CapacityAssignmentRepository extends BaseRepository implements CapacityAssignmentRepositoryInterface
{
protected function getModel(): string
{
return CapacityAssignment::class;
}
public function getDomainObject(): string
{
return CapacityAssignmentDomainObject::class;
}
public function findByEventId(int $eventId, QueryParamsDTO $params): LengthAwarePaginator
{
$where = [
[CapacityAssignmentDomainObjectAbstract::EVENT_ID, '=', $eventId],
];
if (! empty($params->query)) {
$where[] = static function (Builder $builder) use ($params) {
$builder
->where(CapacityAssignmentDomainObjectAbstract::NAME, 'ilike', '%'.$params->query.'%');
};
}
$this->model = $this->model->orderBy(
$this->validateSortColumn($params->sort_by, CapacityAssignmentDomainObject::class),
$this->validateSortDirection($params->sort_direction, CapacityAssignmentDomainObject::class),
);
return $this->paginateWhere(
where: $where,
limit: $params->per_page,
page: $params->page,
);
}
}