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
declare(strict_types=1);
namespace HiEvents\Services\Domain\Event;
use Carbon\Carbon;
use HiEvents\DomainObjects\EventDomainObject;
use HiEvents\DomainObjects\EventOccurrenceDomainObject;
use HiEvents\DomainObjects\Generated\EventOccurrenceDomainObjectAbstract;
use HiEvents\DomainObjects\Status\EventOccurrenceStatus;
use HiEvents\DomainObjects\Status\WaitlistEntryStatus;
use HiEvents\Helper\IdHelper;
use HiEvents\Repository\Interfaces\EventOccurrenceRepositoryInterface;
use HiEvents\Repository\Interfaces\WaitlistEntryRepositoryInterface;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
class EventOccurrenceGeneratorService
{
private const INSERT_CHUNK_SIZE = 500;
public function __construct(
private readonly RecurrenceRuleParserService $ruleParser,
private readonly EventOccurrenceRepositoryInterface $occurrenceRepository,
private readonly WaitlistEntryRepositoryInterface $waitlistEntryRepository,
) {}
public function generate(EventDomainObject $event, array $recurrenceRule): void
{
$candidates = $this->ruleParser->parse($recurrenceRule, $event->getTimezone() ?? 'UTC');
$existingOccurrences = $this->occurrenceRepository->findWhere([
EventOccurrenceDomainObjectAbstract::EVENT_ID => $event->getId(),
]);
$existingByStartDate = collect($existingOccurrences)->keyBy(
fn (EventOccurrenceDomainObject $occ) => Carbon::parse($occ->getStartDate())->utc()->toDateTimeString()
);
$existingIds = collect($existingOccurrences)
->map(fn (EventOccurrenceDomainObject $occ) => $occ->getId())
->all();
$occurrenceIdsInUse = $this->getOccurrenceIdsInUse($existingIds);
$matchedExistingIds = [];
$rowsToInsert = [];
foreach ($candidates as $candidate) {
$startDateKey = $candidate['start']->copy()->utc()->toDateTimeString();
$existing = $existingByStartDate->get($startDateKey);
if ($existing) {
$matchedExistingIds[] = $existing->getId();
if ($occurrenceIdsInUse->contains($existing->getId()) || $existing->getIsOverridden()) {
continue;
}
if (! $this->candidateMatchesExisting($candidate, $existing)) {
$this->occurrenceRepository->updateWhere(
attributes: [
EventOccurrenceDomainObjectAbstract::START_DATE => $candidate['start']->toDateTimeString(),
EventOccurrenceDomainObjectAbstract::END_DATE => $candidate['end']?->toDateTimeString(),
EventOccurrenceDomainObjectAbstract::CAPACITY => $candidate['capacity'],
EventOccurrenceDomainObjectAbstract::LABEL => $candidate['label'] ?? null,
],
where: [EventOccurrenceDomainObjectAbstract::ID => $existing->getId()]
);
}
} else {
$rowsToInsert[] = [
EventOccurrenceDomainObjectAbstract::EVENT_ID => $event->getId(),
EventOccurrenceDomainObjectAbstract::SHORT_ID => IdHelper::shortId(IdHelper::OCCURRENCE_PREFIX),
EventOccurrenceDomainObjectAbstract::START_DATE => $candidate['start']->toDateTimeString(),
EventOccurrenceDomainObjectAbstract::END_DATE => $candidate['end']?->toDateTimeString(),
EventOccurrenceDomainObjectAbstract::STATUS => EventOccurrenceStatus::ACTIVE->name,
EventOccurrenceDomainObjectAbstract::CAPACITY => $candidate['capacity'],
EventOccurrenceDomainObjectAbstract::USED_CAPACITY => 0,
EventOccurrenceDomainObjectAbstract::IS_OVERRIDDEN => false,
EventOccurrenceDomainObjectAbstract::LABEL => $candidate['label'] ?? null,
];
}
}
foreach (array_chunk($rowsToInsert, self::INSERT_CHUNK_SIZE) as $chunk) {
$this->occurrenceRepository->insert($chunk);
}
$this->removeStaleOccurrences($existingOccurrences, $matchedExistingIds, $occurrenceIdsInUse);
}
private function candidateMatchesExisting(array $candidate, EventOccurrenceDomainObject $existing): bool
{
$existingEnd = $existing->getEndDate() !== null
? Carbon::parse($existing->getEndDate())->utc()->toDateTimeString()
: null;
return $existingEnd === $candidate['end']?->copy()->utc()->toDateTimeString()
&& $existing->getCapacity() === $candidate['capacity']
&& $existing->getLabel() === ($candidate['label'] ?? null);
}
private function removeStaleOccurrences(
Collection $existingOccurrences,
array $matchedExistingIds,
Collection $occurrenceIdsInUse,
): void {
$idsToDelete = [];
$eventIdsToDelete = [];
$idsToMarkOverridden = [];
foreach ($existingOccurrences as $existing) {
if (in_array($existing->getId(), $matchedExistingIds, true)) {
continue;
}
if ($existing->getIsOverridden()) {
continue;
}
if ($occurrenceIdsInUse->contains($existing->getId())) {
$idsToMarkOverridden[] = $existing->getId();
continue;
}
if ($existing->getStatus() === EventOccurrenceStatus::CANCELLED->name) {
continue;
}
$idsToDelete[] = $existing->getId();
$eventIdsToDelete[$existing->getEventId()] = true;
}
if ($idsToMarkOverridden !== []) {
$this->occurrenceRepository->updateWhere(
attributes: [
EventOccurrenceDomainObjectAbstract::IS_OVERRIDDEN => true,
],
where: [[EventOccurrenceDomainObjectAbstract::ID, 'in', $idsToMarkOverridden]]
);
}
if ($idsToDelete === []) {
return;
}
$this->waitlistEntryRepository->updateWhere(
attributes: [
'status' => WaitlistEntryStatus::CANCELLED->name,
],
where: [
['event_id', 'in', array_keys($eventIdsToDelete)],
['event_occurrence_id', 'in', $idsToDelete],
['status', 'in', [
WaitlistEntryStatus::WAITING->name,
WaitlistEntryStatus::OFFERED->name,
]],
],
);
$this->occurrenceRepository->deleteWhere([
[EventOccurrenceDomainObjectAbstract::ID, 'in', $idsToDelete],
]);
}
private function getOccurrenceIdsInUse(array $occurrenceIds): Collection
{
if (empty($occurrenceIds)) {
return collect();
}
$withOrderItems = DB::table('order_items')
->whereIn('event_occurrence_id', $occurrenceIds)
->whereNull('deleted_at')
->distinct()
->pluck('event_occurrence_id');
$withAttendees = DB::table('attendees')
->whereIn('event_occurrence_id', $occurrenceIds)
->whereNull('deleted_at')
->distinct()
->pluck('event_occurrence_id');
$withPriceOverrides = DB::table('product_price_occurrence_overrides')
->whereIn('event_occurrence_id', $occurrenceIds)
->distinct()
->pluck('event_occurrence_id');
$withVisibility = DB::table('product_occurrence_visibility')
->whereIn('event_occurrence_id', $occurrenceIds)
->distinct()
->pluck('event_occurrence_id');
$withSeatClaims = DB::table('seat_claims')
->whereIn('event_occurrence_id', $occurrenceIds)
->distinct()
->pluck('event_occurrence_id');
$withBoxOffices = DB::table('box_offices')
->whereIn('event_occurrence_id', $occurrenceIds)
->whereNull('deleted_at')
->distinct()
->pluck('event_occurrence_id');
return $withOrderItems
->merge($withAttendees)
->merge($withPriceOverrides)
->merge($withVisibility)
->merge($withSeatClaims)
->merge($withBoxOffices)
->unique()
->values();
}
}