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\AccountUserDomainObject;
use HiEvents\DomainObjects\Enums\Role;
use HiEvents\DomainObjects\UserDomainObject;
use HiEvents\Models\AccountUser;
use HiEvents\Models\User;
use HiEvents\Repository\Interfaces\UserRepositoryInterface;
use Illuminate\Contracts\Pagination\LengthAwarePaginator;
use Illuminate\Database\Eloquent\ModelNotFoundException;
use Illuminate\Support\Collection;
use Symfony\Component\Routing\Exception\ResourceNotFoundException;
/**
* @extends BaseRepository<UserDomainObject>
*/
class UserRepository extends BaseRepository implements UserRepositoryInterface
{
public function getModel(): string
{
return User::class;
}
public function getDomainObject(): string
{
return UserDomainObject::class;
}
public function findByIdAndAccountId(int $userId, int $accountId): UserDomainObject
{
$accountUser = AccountUser::where('user_id', $userId)->where('account_id', $accountId)->first();
if (! $accountUser) {
throw new ResourceNotFoundException(__('User not found in this account'));
}
$accountUser = $this->handleSingleResult($accountUser, AccountUserDomainObject::class);
try {
/** @var UserDomainObject $user */
$user = $this->handleSingleResult($this->model->findOrFail($userId));
} catch (ModelNotFoundException) {
throw new ResourceNotFoundException(__('User not found'));
}
$user->setCurrentAccountUser($accountUser);
return $user;
}
public function findUsersByAccountId(int $accountId): ?Collection
{
return $this->runQuery(fn () => $this->handleResults(
$this->model->whereHas('accounts', function ($query) use ($accountId) {
$query->where('account_id', $accountId)->whereNull('account_users.deleted_at');
})->get()
))->sortByDesc(fn (UserDomainObject $user) => $user->getUpdatedAt());
}
public function findByEmailIgnoringCase(string $email): Collection
{
return $this->runQuery(fn () => $this->handleResults(
$this->model->whereRaw('lower(email) = ?', [strtolower(trim($email))])->get()
));
}
public function countWithoutSingleSignOnExcludingSuperAdmins(): int
{
return $this->runQuery(fn () => $this->model
->whereDoesntHave('identities')
->whereDoesntHave('accounts', fn ($query) => $query->where('account_users.role', Role::SUPERADMIN->name))
->count());
}
public function getAllUsersWithAccounts(?string $search, int $perPage): LengthAwarePaginator
{
$query = $this->model->query()
->with(['accounts' => function ($query) {
$query->withPivot('role', 'is_account_owner', 'last_login_at', 'status');
}]);
if ($search) {
$query->where(function ($q) use ($search) {
$q->where('first_name', 'ilike', "%$search%")
->orWhere('last_name', 'ilike', "%$search%")
->orWhere('email', 'ilike', "%$search%")
->orWhereHas('accounts', function ($accountQuery) use ($search) {
$accountQuery->where('name', 'ilike', "%$search%");
});
});
}
return $query->orderBy('created_at', 'desc')->paginate($perPage);
}
}