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 Carbon\Carbon;
use HiEvents\DomainObjects\Generated\MessageDomainObjectAbstract;
use HiEvents\DomainObjects\MessageDomainObject;
use HiEvents\DomainObjects\Status\MessageStatus;
use HiEvents\Http\DTO\QueryParamsDTO;
use HiEvents\Models\Message;
use HiEvents\Repository\Interfaces\MessageRepositoryInterface;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Pagination\LengthAwarePaginator;
/**
* @extends BaseRepository<MessageDomainObject>
*/
class MessageRepository extends BaseRepository implements MessageRepositoryInterface
{
protected function getModel(): string
{
return Message::class;
}
public function getDomainObject(): string
{
return MessageDomainObject::class;
}
public function findByEventId(int $eventId, QueryParamsDTO $params): LengthAwarePaginator
{
$where = [
[MessageDomainObjectAbstract::EVENT_ID, '=', $eventId],
];
if ($params->query) {
$where[] = static function (Builder $builder) use ($params) {
$builder
->where(MessageDomainObjectAbstract::SUBJECT, 'ilike', '%'.$params->query.'%')
->orWhere(MessageDomainObjectAbstract::MESSAGE, 'ilike', '%'.$params->query.'%');
};
}
if ($params->filter_fields && $params->filter_fields->isNotEmpty()) {
$this->applyFilterFields($params, MessageDomainObject::getAllowedFilterFields());
}
$this->model = $this->model->orderBy(
$this->validateSortColumn($params->sort_by, MessageDomainObject::class),
$this->validateSortDirection($params->sort_direction, MessageDomainObject::class),
);
return $this->paginateWhere(
where: $where,
limit: $params->per_page,
page: $params->page,
);
}
public function countMessagesInLast24Hours(int $accountId): int
{
$count = $this->model
->join('events', 'messages.event_id', '=', 'events.id')
->where('events.account_id', $accountId)
->where('messages.created_at', '>=', Carbon::now()->subHours(24))
->whereIn('messages.status', [
MessageStatus::PROCESSING->name,
MessageStatus::SENT->name,
MessageStatus::PENDING_REVIEW->name,
])
->count();
$this->resetModel();
return $count;
}
}