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 Tests\Feature\Services\Domain\Account;
use HiEvents\Models\Account;
use HiEvents\Models\AccountUser;
use HiEvents\Models\Attendee;
use HiEvents\Models\Event;
use HiEvents\Models\Order;
use HiEvents\Models\Organizer;
use HiEvents\Models\Product;
use HiEvents\Models\ProductPrice;
use HiEvents\Models\Question;
use HiEvents\Models\QuestionAnswer;
use HiEvents\Models\StripeCustomer;
use HiEvents\Models\User;
use HiEvents\Services\Domain\Account\AccountAnonymizationService;
use HiEvents\Services\Domain\Account\AccountHardDeletionService;
use Illuminate\Foundation\Testing\DatabaseTransactions;
use Illuminate\Support\Facades\DB;
use Tests\TestCase;
class AccountDeletionExecutionTest extends TestCase
{
use DatabaseTransactions;
private Account $account;
private Account $otherAccount;
private User $soleUser;
private User $sharedUser;
private Event $event;
private Event $otherEvent;
private Order $order;
private Attendee $attendee;
private Question $question;
private int $profileId;
protected function setUp(): void
{
parent::setUp();
$this->seedAccountGraph();
}
public function test_anonymization_scrubs_pii_and_retains_financial_records(): void
{
$manifest = $this->app->make(AccountAnonymizationService::class)
->anonymizeAccount($this->account->id);
$order = $this->order->fresh();
$this->assertSame('Anonymized', $order->first_name);
$this->assertStringContainsString('@anonymized.invalid', $order->email);
$this->assertNull($order->address);
$this->assertNull($order->session_id);
$this->assertNotSame('pub-order-1', $order->public_id);
$this->assertSame('25.00', (string) number_format((float) $order->total_gross, 2));
$this->assertSame('COMPLETED', $order->status);
$this->assertNull($order->deleted_at);
$attendee = $this->attendee->fresh();
$this->assertSame('Anonymized', $attendee->first_name);
$this->assertNotSame('pub-att-1', $attendee->public_id);
$this->assertDatabaseMissing('question_answers', ['question_id' => $this->question->id]);
$this->assertDatabaseCount('question_answers', 1);
$soleUser = $this->soleUser->fresh();
$this->assertSame('Anonymized', $soleUser->first_name);
$this->assertStringContainsString('@anonymized.invalid', $soleUser->email);
$this->assertNotNull($soleUser->deleted_at);
$sharedUser = $this->sharedUser->fresh();
$this->assertSame('[email protected]', $sharedUser->email);
$this->assertNull($sharedUser->deleted_at);
$this->assertSoftDeleted('account_users', [
'account_id' => $this->account->id,
'user_id' => $this->sharedUser->id,
]);
$this->assertDatabaseHas('account_users', [
'account_id' => $this->otherAccount->id,
'user_id' => $this->sharedUser->id,
'deleted_at' => null,
]);
$account = $this->account->fresh();
$this->assertSame('Anonymized', $account->name);
$this->assertNotNull($account->deleted_at);
$this->assertDatabaseHas('stripe_customers', [
'stripe_account_id' => 'acct_deltest123',
'name' => 'Anonymized',
]);
$profile = DB::table('profiles')->where('id', $this->profileId)->first();
$this->assertNotSame('Ada Speaker', $profile->name);
$this->assertNull($profile->tagline);
$this->assertNull($profile->bio);
$this->assertNull($profile->links);
$this->assertNotEmpty($manifest);
$this->assertContains('orders', array_column($manifest, 'entity'));
}
public function test_hard_deletion_removes_account_graph_and_preserves_shared_users(): void
{
$this->app->make(AccountHardDeletionService::class)
->deleteAccount($this->account->id);
$this->assertDatabaseMissing('accounts', ['id' => $this->account->id]);
$this->assertDatabaseMissing('events', ['id' => $this->event->id]);
$this->assertDatabaseMissing('orders', ['id' => $this->order->id]);
$this->assertDatabaseMissing('attendees', ['id' => $this->attendee->id]);
$this->assertDatabaseMissing('questions', ['event_id' => $this->event->id]);
$this->assertDatabaseMissing('users', ['id' => $this->soleUser->id]);
$this->assertDatabaseMissing('stripe_customers', ['stripe_account_id' => 'acct_deltest123']);
$this->assertDatabaseHas('users', ['id' => $this->sharedUser->id]);
$this->assertDatabaseHas('accounts', ['id' => $this->otherAccount->id]);
$this->assertDatabaseCount('question_answers', 1);
}
public function test_hard_deletion_removes_spam_checks_and_releases_reviewer(): void
{
$doomedCheckId = $this->seedSpamCheck($this->event->id, $this->soleUser->id);
$survivingCheckId = $this->seedSpamCheck($this->otherEvent->id, $this->soleUser->id);
$manifest = $this->app->make(AccountHardDeletionService::class)
->deleteAccount($this->account->id);
$this->assertSame(1, $manifest['event_spam_checks']);
$this->assertDatabaseMissing('event_spam_checks', ['id' => $doomedCheckId]);
$this->assertDatabaseMissing('events', ['id' => $this->event->id]);
$this->assertDatabaseMissing('users', ['id' => $this->soleUser->id]);
$this->assertDatabaseHas('event_spam_checks', [
'id' => $survivingCheckId,
'event_id' => $this->otherEvent->id,
'reviewed_by_user_id' => null,
]);
}
public function test_both_deletion_paths_remove_the_sso_connection_domains_and_connection_identities(): void
{
foreach ([AccountAnonymizationService::class => 'anonymizeAccount', AccountHardDeletionService::class => 'deleteAccount'] as $service => $method) {
$connectionId = $this->seedSsoConnection();
$this->app->make($service)->{$method}($this->account->id);
$this->assertDatabaseMissing('account_sso_connections', ['id' => $connectionId]);
$this->assertDatabaseMissing('account_sso_domains', ['account_id' => $this->account->id]);
$this->assertDatabaseMissing('user_identities', ['subject' => 'connection-subject']);
$this->assertDatabaseHas('user_identities', ['subject' => 'social-subject']);
DB::table('user_identities')->delete();
}
}
public function test_both_deletion_paths_remove_the_accounts_api_keys_and_keep_other_accounts_keys(): void
{
foreach ([AccountAnonymizationService::class => 'anonymizeAccount', AccountHardDeletionService::class => 'deleteAccount'] as $service => $method) {
$doomedKeyId = $this->seedApiKey($this->sharedUser, $this->account->id);
$survivingKeyId = $this->seedApiKey($this->sharedUser, $this->otherAccount->id);
$this->app->make($service)->{$method}($this->account->id);
$this->assertDatabaseMissing('personal_access_tokens', ['id' => $doomedKeyId]);
$this->assertDatabaseHas('personal_access_tokens', ['id' => $survivingKeyId]);
DB::table('personal_access_tokens')->delete();
}
}
private function seedApiKey(User $user, int $accountId): int
{
return DB::table('personal_access_tokens')->insertGetId([
'tokenable_type' => User::class,
'tokenable_id' => $user->id,
'account_id' => $accountId,
'name' => 'Integration',
'token' => hash('sha256', uniqid('', true)),
'token_hint' => 'abcd',
'abilities' => '["read"]',
'created_at' => now(),
'updated_at' => now(),
]);
}
private function seedSsoConnection(): int
{
$connectionId = DB::table('account_sso_connections')->insertGetId([
'account_id' => $this->account->id,
'type' => 'OKTA',
'issuer' => 'https://acme.okta.test',
'client_id' => 'client',
'client_secret' => encrypt('secret', false),
'created_at' => now(),
'updated_at' => now(),
]);
DB::table('account_sso_domains')->insert([
'account_id' => $this->account->id,
'domain' => 'doomed.test',
'verification_token' => 'token',
'verified_at' => now(),
'created_at' => now(),
'updated_at' => now(),
]);
foreach (['connection-subject' => $connectionId, 'social-subject' => null] as $subject => $identityConnectionId) {
DB::table('user_identities')->insert([
'user_id' => $this->sharedUser->id,
'account_sso_connection_id' => $identityConnectionId,
'provider_key' => $identityConnectionId === null ? 'google' : 'connection-'.$connectionId,
'issuer' => $identityConnectionId === null ? 'https://accounts.google.com' : 'https://acme.okta.test',
'subject' => $subject,
'created_at' => now(),
'updated_at' => now(),
]);
}
return $connectionId;
}
private function seedSpamCheck(int $eventId, int $reviewedByUserId): int
{
return DB::table('event_spam_checks')->insertGetId([
'event_id' => $eventId,
'status' => 'CONFIRMED_SPAM',
'content_hash' => str_repeat('a', 64),
'checked_at' => now(),
'reviewed_by_user_id' => $reviewedByUserId,
'reviewed_at' => now(),
'created_at' => now(),
'updated_at' => now(),
]);
}
private function seedAccountGraph(): void
{
$this->account = Account::forceCreate([
'name' => 'Doomed Account',
'email' => '[email protected]',
'timezone' => 'UTC',
'currency_code' => 'USD',
'short_id' => 'acc_doomed',
'stripe_account_id' => 'acct_deltest123',
]);
$this->otherAccount = Account::forceCreate([
'name' => 'Surviving Account',
'email' => '[email protected]',
'timezone' => 'UTC',
'currency_code' => 'USD',
'short_id' => 'acc_survivor',
]);
$this->soleUser = User::forceCreate([
'email' => '[email protected]',
'first_name' => 'Sole',
'last_name' => 'User',
'password' => 'hash',
'timezone' => 'UTC',
]);
$this->sharedUser = User::forceCreate([
'email' => '[email protected]',
'first_name' => 'Shared',
'last_name' => 'User',
'password' => 'hash',
'timezone' => 'UTC',
]);
AccountUser::forceCreate([
'account_id' => $this->account->id,
'user_id' => $this->soleUser->id,
'role' => 'ADMIN',
'status' => 'ACTIVE',
'is_account_owner' => true,
]);
AccountUser::forceCreate([
'account_id' => $this->account->id,
'user_id' => $this->sharedUser->id,
'role' => 'ADMIN',
'status' => 'ACTIVE',
]);
AccountUser::forceCreate([
'account_id' => $this->otherAccount->id,
'user_id' => $this->sharedUser->id,
'role' => 'ADMIN',
'status' => 'ACTIVE',
]);
$organizer = Organizer::forceCreate([
'name' => 'Doomed Organizer',
'account_id' => $this->account->id,
'email' => '[email protected]',
'currency' => 'USD',
'timezone' => 'UTC',
'status' => 'LIVE',
]);
$this->event = $this->seedEvent('Past Event', $this->account->id, $organizer->id, $this->soleUser->id, 'evt_doomed');
$this->profileId = DB::table('profiles')->insertGetId([
'account_id' => $this->account->id,
'organizer_id' => $organizer->id,
'name' => 'Ada Speaker',
'tagline' => 'CTO',
'bio' => '<p>Personal bio</p>',
'links' => json_encode([['type' => 'WEBSITE', 'url' => 'https://ada.example.com']]),
'created_at' => now(),
'updated_at' => now(),
]);
$product = Product::forceCreate([
'event_id' => $this->event->id,
'title' => 'Ticket',
'type' => 'PAID',
'product_type' => 'TICKET',
'order' => 1,
]);
$productPrice = ProductPrice::forceCreate([
'product_id' => $product->id,
'price' => 25,
'order' => 1,
]);
$this->order = Order::forceCreate([
'event_id' => $this->event->id,
'short_id' => 'ord_doomed',
'public_id' => 'pub-order-1',
'first_name' => 'Jane',
'last_name' => 'Buyer',
'email' => '[email protected]',
'address' => ['line1' => '1 Main St'],
'session_id' => 'sess-123',
'total_before_additions' => 25,
'total_gross' => 25,
'currency' => 'USD',
'status' => 'COMPLETED',
]);
$this->attendee = Attendee::forceCreate([
'order_id' => $this->order->id,
'event_id' => $this->event->id,
'product_id' => $product->id,
'product_price_id' => $productPrice->id,
'email' => '[email protected]',
'first_name' => 'Jane',
'last_name' => 'Buyer',
'status' => 'ACTIVE',
'public_id' => 'pub-att-1',
'short_id' => 'att_doomed',
]);
$this->question = Question::forceCreate([
'event_id' => $this->event->id,
'title' => 'Dietary requirements',
'type' => 'SINGLE_LINE_TEXT',
'belongs_to' => 'ORDER',
'required' => false,
'is_hidden' => false,
]);
QuestionAnswer::forceCreate([
'question_id' => $this->question->id,
'order_id' => $this->order->id,
'answer' => ['text' => 'Nut allergy'],
]);
$otherOrganizer = Organizer::forceCreate([
'name' => 'Surviving Organizer',
'account_id' => $this->otherAccount->id,
'email' => '[email protected]',
'currency' => 'USD',
'timezone' => 'UTC',
'status' => 'LIVE',
]);
$this->otherEvent = $otherEvent = $this->seedEvent('Surviving Event', $this->otherAccount->id, $otherOrganizer->id, $this->sharedUser->id, 'evt_survivor');
$otherQuestion = Question::forceCreate([
'event_id' => $otherEvent->id,
'title' => 'Other question',
'type' => 'SINGLE_LINE_TEXT',
'belongs_to' => 'ORDER',
'required' => false,
'is_hidden' => false,
]);
$otherOrder = Order::forceCreate([
'event_id' => $otherEvent->id,
'short_id' => 'ord_survivor',
'public_id' => 'pub-order-2',
'first_name' => 'Sam',
'last_name' => 'Survivor',
'email' => '[email protected]',
'total_before_additions' => 10,
'total_gross' => 10,
'currency' => 'USD',
'status' => 'COMPLETED',
]);
QuestionAnswer::forceCreate([
'question_id' => $otherQuestion->id,
'order_id' => $otherOrder->id,
'answer' => ['text' => 'Should survive'],
]);
StripeCustomer::forceCreate([
'name' => 'Jane Buyer',
'email' => '[email protected]',
'stripe_customer_id' => 'cus_deltest1',
'stripe_account_id' => 'acct_deltest123',
]);
DB::table('question_answers')->whereNotIn('question_id', [$this->question->id, $otherQuestion->id])->delete();
}
private function seedEvent(string $title, int $accountId, int $organizerId, int $userId, string $shortId): Event
{
$eventId = DB::table('events')->insertGetId([
'title' => $title,
'account_id' => $accountId,
'organizer_id' => $organizerId,
'user_id' => $userId,
'short_id' => $shortId,
'status' => 'DRAFT',
'timezone' => 'UTC',
'currency' => 'USD',
'created_at' => now(),
'updated_at' => now(),
]);
return Event::findOrFail($eventId);
}
}