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\Repository\Eloquent;
use HiEvents\DomainObjects\AccountDomainObject;
use HiEvents\Models\Account;
use HiEvents\Repository\Interfaces\AccountRepositoryInterface;
use Illuminate\Contracts\Pagination\LengthAwarePaginator;
/**
* @extends BaseRepository<AccountDomainObject>
*/
class AccountRepository extends BaseRepository implements AccountRepositoryInterface
{
protected function getModel(): string
{
return Account::class;
}
public function getDomainObject(): string
{
return AccountDomainObject::class;
}
public function findByEventId(int $eventId): AccountDomainObject
{
return $this->runQuery(function () use ($eventId) {
$account = $this
->model
->select('accounts.*')
->join('events', 'accounts.id', '=', 'events.account_id')
->where('events.id', $eventId)
->first();
return $this->handleSingleResult($account, AccountDomainObject::class);
});
}
public function getAllAccountsWithCounts(?string $search, int $perPage): LengthAwarePaginator
{
$query = $this->model
->select('accounts.*')
->withCount(['events', 'users'])
->with([
'users' => function ($query) {
$query->select('users.id', 'users.first_name', 'users.last_name', 'users.email')
->withPivot('role');
},
'messagingTier',
]);
if ($search) {
$query->where(function ($q) use ($search) {
$q->where('accounts.name', 'ilike', "%{$search}%")
->orWhere('accounts.email', 'ilike', "%{$search}%")
->orWhereHas('users', function ($userQuery) use ($search) {
$userQuery->where('users.email', 'ilike', "%{$search}%");
});
});
}
return $query->orderBy('created_at', 'desc')->paginate($perPage);
}
public function getAccountWithDetails(int $accountId): Account
{
return $this->model
->withCount(['events', 'users'])
->with([
'messagingTier',
'active_deletion_request',
'lifecycleNudges',
'organizers.organizer_configuration',
'organizers.organizer_vat_setting',
'users' => function ($query) {
$query->select('users.id', 'users.first_name', 'users.last_name', 'users.email')
->withPivot('role');
},
])
->findOrFail($accountId);
}
}