Merge branch 'feature/tickets_adminapp' of https://gitea.quo.ar/tbianchini/shopit-back into feature/tickets_adminapp

Reviewed-on: #2

.env.example

@@ -5,6 +5,10 @@ APP_DEBUG=false
 APP_URL=http://localhost
 
 PURCHASE_CHECKOUT_EXPIRATION_MINUTES=30
+PURCHASE_QR_EXPIRATION_MINUTES=15
+PURCHASE_TELEPAGOS_EXPIRATION_MINUTES=30
+PURCHASE_TRANSFER_EXPIRATION_MINUTES=1440
+PURCHASE_TRANSFER_CANDIDATE_AMOUNT_TOLERANCE_PERCENTAGE=5
 STOCK_RESERVATION_EXPIRATION_MINUTES=30
 FRONTEND_URLS=http://localhost:4200
 

app/Domains/Desfile/Services/InvitationPurchaseProvisioner.php

@@ -22,7 +22,7 @@ class InvitationPurchaseProvisioner
     private const ALLOCATIONS = [
         ['sector' => 'A', 'row' => 1, 'first_seat' => 1, 'last_seat' => 16, 'type' => 'NORMAL'],
         ['sector' => 'A', 'row' => 3, 'first_seat' => 1, 'last_seat' => 14, 'type' => 'NORMAL'],
-        ['sector' => 'C', 'row' => 1, 'first_seat' => 1, 'last_seat' => 16, 'type' => 'VIP + LUNCH'],
+        ['sector' => 'C', 'row' => 1, 'first_seat' => 1, 'last_seat' => 17, 'type' => 'VIP + LUNCH'],
         ['sector' => 'C', 'row' => 3, 'first_seat' => 6, 'last_seat' => 7, 'type' => 'NORMAL'],
     ];
 

app/Domains/Forms/Controllers/AdminApp/TicketFilterFormController.php

@@ -0,0 +1,20 @@
+<?php
+
+namespace App\Domains\Forms\Controllers\AdminApp;
+
+use App\Domains\Forms\Resources\TicketFilterFormResource;
+use App\Domains\Forms\Services\TicketFilterFormService;
+use App\Http\Controllers\Controller;
+use Illuminate\Http\Request;
+
+class TicketFilterFormController extends Controller
+{
+    public function __construct(private readonly TicketFilterFormService $formService) {}
+
+    public function __invoke(Request $request): TicketFilterFormResource
+    {
+        $tenant = $request->user('sanctum')->tenant()->firstOrFail();
+
+        return TicketFilterFormResource::make($this->formService->get($tenant));
+    }
+}

app/Domains/Forms/Controllers/AdminApp/TicketFormController.php

@@ -0,0 +1,22 @@
+<?php
+
+namespace App\Domains\Forms\Controllers\AdminApp;
+
+use App\Domains\Forms\Resources\TicketFormResource;
+use App\Domains\Forms\Services\TicketFormService;
+use App\Http\Controllers\Controller;
+use Illuminate\Http\Request;
+
+class TicketFormController extends Controller
+{
+    public function __construct(protected TicketFormService $ticketFormService) {}
+
+    public function __invoke(Request $request): TicketFormResource
+    {
+        return TicketFormResource::make(
+            $this->ticketFormService->get(
+                $request->user('sanctum')->tenant()->firstOrFail()
+            )
+        );
+    }
+}

app/Domains/Forms/Resources/TicketFilterFormResource.php

@@ -0,0 +1,21 @@
+<?php
+
+namespace App\Domains\Forms\Resources;
+
+use Illuminate\Http\Request;
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class TicketFilterFormResource extends JsonResource
+{
+    /** @return array<string, mixed> */
+    public function toArray(Request $request): array
+    {
+        return [
+            'code' => $this->resource['code'],
+            'action' => $this->resource['action'],
+            'method' => $this->resource['method'],
+            'fields' => $this->resource['fields'],
+            'columns' => $this->resource['columns'],
+        ];
+    }
+}

app/Domains/Forms/Resources/TicketFormResource.php

@@ -0,0 +1,18 @@
+<?php
+
+namespace App\Domains\Forms\Resources;
+
+use Illuminate\Http\Request;
+use Illuminate\Http\Resources\Json\JsonResource;
+
+class TicketFormResource extends JsonResource
+{
+    /** @return array<string, mixed> */
+    public function toArray(Request $request): array
+    {
+        return [
+            'statuses' => $this->resource['statuses'],
+            'categories' => $this->resource['categories'],
+        ];
+    }
+}

app/Domains/Forms/Services/TicketFilterFormService.php

@@ -0,0 +1,127 @@
+<?php
+
+namespace App\Domains\Forms\Services;
+
+use App\Domains\Tenant\Models\Tenant;
+use App\Domains\Ticket\Models\Ticket;
+use App\Domains\Ticket\Services\AdminAppTicketColumnService;
+
+class TicketFilterFormService
+{
+    private const FIESTA_FUTBOL_INFANTIL = 'fiesta_futbol_infantil';
+
+    public function __construct(
+        private readonly TicketFormService $ticketFormService,
+        private readonly AdminAppTicketColumnService $columnService,
+    ) {}
+
+    /** @return array<string, mixed> */
+    public function get(Tenant $tenant): array
+    {
+        $fields = $this->commonFields();
+
+        if ($tenant->codigo === self::FIESTA_FUTBOL_INFANTIL) {
+            $fields = [
+                ...$this->fiestaFutbolInfantilFields($tenant),
+                ...$fields,
+            ];
+        }
+
+        return [
+            'code' => 'tickets_filter',
+            'action' => '/api/v1/adminapp/tenant/tickets',
+            'method' => 'GET',
+            'fields' => $fields,
+            'columns' => $this->columnService->publicColumns($tenant),
+        ];
+    }
+
+    /** @return list<array<string, mixed>> */
+    private function fiestaFutbolInfantilFields(Tenant $tenant): array
+    {
+        $form = $this->ticketFormService->getForFilters($tenant);
+
+        return [
+            [
+                'name' => 'category',
+                'query_param' => 'category',
+                'label' => 'Categoría',
+                'type' => 'select',
+                'required' => false,
+                'default' => null,
+                'placeholder' => 'Categoría',
+                'options' => array_map(
+                    fn (array $category): array => [
+                        'value' => $category['value'],
+                        'label' => $category['label'],
+                        'children' => [
+                            'field' => 'product',
+                            'disabled' => $category['products'] === [],
+                            'options' => array_map(
+                                fn (array $product): array => [
+                                    'value' => $product['value'],
+                                    'label' => $product['label'],
+                                    'children' => [
+                                        'field' => 'type',
+                                        'disabled' => $product['types'] === [],
+                                        'options' => $product['types'],
+                                    ],
+                                ],
+                                $category['products'],
+                            ),
+                        ],
+                    ],
+                    $form['categories'],
+                ),
+            ],
+            $this->dependentSelect('product', 'Producto', 'category'),
+            $this->dependentSelect('type', 'Tipo', 'product'),
+        ];
+    }
+
+    /** @return list<array<string, mixed>> */
+    private function commonFields(): array
+    {
+        return [
+            [
+                'name' => 'date',
+                'query_param' => 'date',
+                'label' => 'Fecha',
+                'type' => 'date',
+                'required' => false,
+                'default' => null,
+            ],
+            [
+                'name' => 'status',
+                'query_param' => 'status',
+                'label' => 'Estado',
+                'type' => 'select',
+                'required' => false,
+                'default' => null,
+                'placeholder' => 'Estado',
+                'options' => [
+                    ['value' => Ticket::STATUS_ACTIVE, 'label' => 'Activo'],
+                    ['value' => Ticket::STATUS_USED, 'label' => 'Usado'],
+                    ['value' => Ticket::STATUS_EXPIRED, 'label' => 'Vencido'],
+                ],
+            ],
+        ];
+    }
+
+    /** @return array<string, mixed> */
+    private function dependentSelect(string $name, string $label, string $dependency): array
+    {
+        return [
+            'name' => $name,
+            'query_param' => $name,
+            'label' => $label,
+            'type' => 'select',
+            'required' => false,
+            'default' => null,
+            'placeholder' => $label,
+            'depends_on' => $dependency,
+            'disabled' => true,
+            'options' => [],
+        ];
+    }
+}

app/Domains/Forms/Services/TicketFormService.php

@@ -0,0 +1,336 @@
+<?php
+
+namespace App\Domains\Forms\Services;
+
+use App\Domains\Catalog\Models\CatalogItem;
+use App\Domains\Catalog\Models\Variant;
+use App\Domains\Tenant\Models\Tenant;
+use App\Domains\Ticket\Models\Ticket;
+use Illuminate\Database\Eloquent\Collection;
+
+class TicketFormService
+{
+    private const PRODUCT = 'product';
+
+    /**
+     * @var array<string, array{label: string|null, product: string, type: string|null, order: int}>
+     */
+    private const CATEGORY_PRESENTATIONS = [
+        'entradas' => [
+            'label' => null,
+            'product' => self::PRODUCT,
+            'type' => null,
+            'order' => 1,
+        ],
+        'alojamientos' => [
+            'label' => 'Camping',
+            'product' => 'tipo_alojamiento',
+            'type' => null,
+            'order' => 2,
+        ],
+        'camping' => [
+            'label' => null,
+            'product' => 'tipo_alojamiento',
+            'type' => null,
+            'order' => 2,
+        ],
+        'comidas' => [
+            'label' => 'Comida',
+            'product' => 'event_date',
+            'type' => 'horario',
+            'order' => 3,
+        ],
+        'comida' => [
+            'label' => null,
+            'product' => 'event_date',
+            'type' => 'horario',
+            'order' => 3,
+        ],
+        'merchandising' => [
+            'label' => null,
+            'product' => self::PRODUCT,
+            'type' => 'color',
+            'order' => 4,
+        ],
+    ];
+
+    /**
+     * @return array{
+     *     statuses: list<array{value: string, label: string}>,
+     *     categories: list<array{
+     *         value: string,
+     *         label: string,
+     *         products: list<array{
+     *             value: string,
+     *             label: string,
+     *             types: list<array{value: string, label: string}>
+     *         }>
+     *     }>
+     * }
+     */
+    public function get(Tenant $tenant): array
+    {
+        $items = CatalogItem::query()
+            ->where('tenant_code', $tenant->codigo)
+            ->where('has_tickets', true)
+            ->whereHas('category')
+            ->with($this->relations())
+            ->orderBy('group_order')
+            ->orderBy('nombre')
+            ->get();
+
+        return $this->build($items);
+    }
+
+    /**
+     * Return active catalog options plus soft-deleted sources still referenced by
+     * tickets, so historical tickets never become impossible to filter.
+     *
+     * @return array{
+     *     statuses: list<array{value: string, label: string}>,
+     *     categories: list<array{
+     *         value: string,
+     *         label: string,
+     *         products: list<array{
+     *             value: string,
+     *             label: string,
+     *             types: list<array{value: string, label: string}>
+     *         }>
+     *     }>
+     * }
+     */
+    public function getForFilters(Tenant $tenant): array
+    {
+        $historicalVariantIds = Ticket::query()
+            ->where('tenant_code', $tenant->codigo)
+            ->whereNotNull('source_variant_id')
+            ->distinct()
+            ->pluck('source_variant_id')
+            ->map(fn ($id): int => (int) $id)
+            ->all();
+        $historicalCatalogItemIds = Ticket::query()
+            ->where('tenant_code', $tenant->codigo)
+            ->whereNotNull('source_catalog_item_id')
+            ->distinct()
+            ->pluck('source_catalog_item_id')
+            ->map(fn ($id): int => (int) $id)
+            ->merge(
+                Variant::withTrashed()
+                    ->whereKey($historicalVariantIds)
+                    ->pluck('catalog_item_id')
+                    ->map(fn ($id): int => (int) $id),
+            )
+            ->unique()
+            ->values()
+            ->all();
+
+        $items = CatalogItem::withTrashed()
+            ->where('tenant_code', $tenant->codigo)
+            ->whereHas('category')
+            ->where(function ($query) use ($historicalCatalogItemIds): void {
+                $query
+                    ->where(function ($activeQuery): void {
+                        $activeQuery
+                            ->whereNull('catalog_items.deleted_at')
+                            ->where('has_tickets', true);
+                    })
+                    ->orWhereIn('catalog_items.id', $historicalCatalogItemIds);
+            })
+            ->with([
+                'category',
+                'itemAttributes.attribute.options',
+                'variants' => fn ($query) => $query
+                    ->withTrashed()
+                    ->where(function ($variantQuery) use ($historicalVariantIds): void {
+                        $variantQuery
+                            ->whereNull('variantes.deleted_at')
+                            ->orWhereIn('variantes.id', $historicalVariantIds);
+                    }),
+                'variants.definitions.itemAttribute.attribute.options',
+                'variants.eventDates',
+                'variants.eventDate',
+            ])
+            ->orderBy('group_order')
+            ->orderBy('nombre')
+            ->get();
+
+        return $this->build($items);
+    }
+
+    /**
+     * @param  Collection<int, CatalogItem>  $items
+     * @return array{
+     *     statuses: list<array{value: string, label: string}>,
+     *     categories: list<array{
+     *         value: string,
+     *         label: string,
+     *         products: list<array{
+     *             value: string,
+     *             label: string,
+     *             types: list<array{value: string, label: string}>
+     *         }>
+     *     }>
+     * }
+     */
+    private function build(Collection $items): array
+    {
+        $categories = [];
+
+        foreach ($items as $item) {
+            $sourceCategory = trim((string) $item->category?->nombre);
+            $categoryValue = mb_strtolower($sourceCategory);
+            $presentation = self::CATEGORY_PRESENTATIONS[$categoryValue] ?? [
+                'label' => null,
+                'product' => self::PRODUCT,
+                'type' => null,
+                'order' => PHP_INT_MAX,
+            ];
+
+            $categories[$categoryValue] ??= [
+                'value' => $categoryValue,
+                'label' => $presentation['label'] ?? $sourceCategory,
+                'order' => $presentation['order'],
+                'products' => [],
+            ];
+
+            foreach ($this->products($item, $presentation['product'], $presentation['type']) as $product) {
+                $productValue = $product['value'];
+                $existingProduct = $categories[$categoryValue]['products'][$productValue] ?? [
+                    'value' => $productValue,
+                    'label' => $product['label'],
+                    'types' => [],
+                ];
+
+                foreach ($product['types'] as $type) {
+                    $existingProduct['types'][$type['value']] = $type;
+                }
+
+                $categories[$categoryValue]['products'][$productValue] = $existingProduct;
+            }
+        }
+
+        uasort($categories, fn (array $left, array $right): int => $left['order'] <=> $right['order']
+            ?: $left['label'] <=> $right['label']);
+
+        return [
+            'statuses' => [
+                ['value' => Ticket::STATUS_ACTIVE, 'label' => 'Activo'],
+                ['value' => Ticket::STATUS_USED, 'label' => 'Usado'],
+                ['value' => Ticket::STATUS_EXPIRED, 'label' => 'Vencido'],
+            ],
+            'categories' => array_values(array_map(
+                fn (array $category): array => [
+                    'value' => $category['value'],
+                    'label' => $category['label'],
+                    'products' => array_values(array_map(
+                        fn (array $product): array => [
+                            'value' => $product['value'],
+                            'label' => $product['label'],
+                            'types' => array_values($product['types']),
+                        ],
+                        $category['products'],
+                    )),
+                ],
+                $categories,
+            )),
+        ];
+    }
+
+    /** @return list<string> */
+    private function relations(): array
+    {
+        return [
+            'category',
+            'itemAttributes.attribute.options',
+            'variants.definitions.itemAttribute.attribute.options',
+            'variants.eventDates',
+            'variants.eventDate',
+        ];
+    }
+
+    /**
+     * @return list<array{
+     *     value: string,
+     *     label: string,
+     *     types: list<array{value: string, label: string}>
+     * }>
+     */
+    private function products(CatalogItem $item, string $productCode, ?string $typeCode): array
+    {
+        if ($productCode === self::PRODUCT) {
+            return [[
+                'value' => $item->slug,
+                'label' => $item->nombre,
+                'types' => $this->types($item, $typeCode),
+            ]];
+        }
+
+        $products = [];
+
+        foreach ($item->variants as $variant) {
+            foreach ($this->variantOptions($variant, $productCode) as $productOption) {
+                $productValue = $productOption['value'];
+                $products[$productValue] ??= [
+                    'value' => $productValue,
+                    'label' => $this->optionLabel($productOption['label'], $productCode),
+                    'types' => [],
+                ];
+
+                foreach ($this->variantOptions($variant, $typeCode) as $typeOption) {
+                    $products[$productValue]['types'][$typeOption['value']] = $typeOption;
+                }
+            }
+        }
+
+        return array_values(array_map(
+            fn (array $product): array => [
+                'value' => $product['value'],
+                'label' => $product['label'],
+                'types' => array_values($product['types']),
+            ],
+            $products,
+        ));
+    }
+
+    /** @return list<array{value: string, label: string}> */
+    private function types(CatalogItem $item, ?string $typeCode): array
+    {
+        $types = [];
+
+        foreach ($item->variants as $variant) {
+            foreach ($this->variantOptions($variant, $typeCode) as $typeOption) {
+                $types[$typeOption['value']] = $typeOption;
+            }
+        }
+
+        return array_values($types);
+    }
+
+    /** @return list<array{value: string, label: string}> */
+    private function variantOptions(Variant $variant, ?string $attributeCode): array
+    {
+        if ($attributeCode === null) {
+            return [];
+        }
+
+        $selection = $variant->selectionOptions($variant->catalogItem->itemAttributes)
+            ->get($attributeCode);
+
+        if ($selection === null) {
+            return [];
+        }
+
+        return array_is_list($selection) ? $selection : [$selection];
+    }
+
+    private function optionLabel(string $label, string $attributeCode): string
+    {
+        if ($attributeCode !== 'event_date') {
+            return $label;
+        }
+
+        [$day, $month] = array_pad(explode('/', $label), 2, null);
+
+        return $day !== null && $month !== null ? "{$day}/{$month}" : $label;
+    }
+}

app/Domains/Forms/documentacion/README.md

@@ -9,6 +9,7 @@ Provee catálogos y opciones auxiliares para construir formularios del panel adm
 - `EventFormService`: devuelve redes sociales disponibles y las URL configuradas para el tenant.
 - `SaleFormService`: expone los estados admitidos para compras con sus etiquetas de presentación.
 - `StaffFormService`: lista categorías raíz que pueden asignarse al personal del tenant.
+- `TicketFormService`: expone estados y opciones anidadas de categoría, producto y tipo para los tickets de Fiesta Fútbol Infantil.
 
 Cada servicio tiene un controlador invocable y un `JsonResource` específico. `SocialMediaOptionResource` representa las opciones de redes sociales.
 
@@ -19,6 +20,7 @@ Bajo `/v1/adminapp/forms`, con `auth:sanctum` y `adminapp.tenant`:
 - `GET /event`.
 - `GET /sale`.
 - `GET /staff`.
+- `GET /fiesta-futbol-infantil/ticket`: estados y jerarquía categoría → producto → tipo para filtros de tickets.
 - `GET /fiesta-futbol-infantil/merchandise`: opciones de color y talle del tenant para merchandising.
 
 ## Dependencias

app/Domains/Forms/routes/adminapp.php

@@ -5,6 +5,8 @@ use App\Domains\Forms\Controllers\AdminApp\FoodFormController;
 use App\Domains\Forms\Controllers\AdminApp\MerchandiseFormController;
 use App\Domains\Forms\Controllers\AdminApp\SaleFormController;
 use App\Domains\Forms\Controllers\AdminApp\StaffFormController;
+use App\Domains\Forms\Controllers\AdminApp\TicketFilterFormController;
+use App\Domains\Forms\Controllers\AdminApp\TicketFormController;
 use Illuminate\Support\Facades\Route;
 
 Route::prefix('v1/adminapp/forms')
@@ -13,6 +15,13 @@ Route::prefix('v1/adminapp/forms')
         Route::get('event', EventFormController::class);
         Route::get('sale', SaleFormController::class);
         Route::get('staff', StaffFormController::class);
+        Route::get('tickets-filter', TicketFilterFormController::class)
+            ->middleware('tenant.menu:adminapp.tickets')
+            ->name('adminapp.forms.tickets-filter');
+        Route::get(
+            'fiesta-futbol-infantil/ticket',
+            TicketFormController::class
+        );
         Route::get(
             'fiesta-futbol-infantil/merchandise',
             MerchandiseFormController::class

app/Domains/Integration/Services/TelepagosWebhookService.php

@@ -7,7 +7,10 @@ use App\Domains\Purchase\Models\Purchase;
 use App\Domains\Purchase\Models\TelepagosPayment;
 use App\Domains\Purchase\Models\TelepagosQr;
 use App\Domains\Purchase\Services\CheckoutService;
+use App\Domains\Purchase\Services\DniDistanceService;
 use Exception;
+use Illuminate\Database\Eloquent\Builder;
+use Illuminate\Database\Eloquent\Collection;
 use Illuminate\Support\Facades\DB;
 use Illuminate\Support\Facades\Log;
 
@@ -15,6 +18,7 @@ class TelepagosWebhookService
 {
     public function __construct(
         private readonly CheckoutService $checkoutService,
+        private readonly DniDistanceService $dniDistance,
     ) {}
 
     /**
@@ -41,7 +45,6 @@ class TelepagosWebhookService
 
             $paymentData = [
                 'compra_id' => null,
-                'matched_purchase_ids' => null,
                 'cuit_buyer' => $details['data']['buyer']['cuit'] ?? $details['buyer']['cuit'] ?? null,
                 'cvu_buyer' => $details['data']['buyer']['cvu'] ?? $details['buyer']['cvu'] ?? null,
                 'amount' => $amount,
@@ -73,24 +76,55 @@ class TelepagosWebhookService
                 $dni = substr($cuit, 2, -1);
 
                 $tenantCodes = $client->tenants()->pluck('codigo');
-                $purchases = Purchase::whereIn('tenant_codigo', $tenantCodes)
-                    ->where('transfer_payer_dni', $dni)
+                $eligiblePurchases = Purchase::query()
+                    ->whereIn('tenant_codigo', $tenantCodes)
                     ->whereIn('status', [
                         Purchase::STATUS_CREATED,
                         Purchase::STATUS_PENDING_PAYMENT,
                         Purchase::STATUS_IN_REVIEW,
                     ])
-                    ->where('payment_method', 'transfer')
+                    ->where('payment_method', 'transfer');
+
+                $purchases = (clone $eligiblePurchases)
                     ->where('total', $amount)
                     ->latest()
-                    ->get();
+                    ->get()
+                    ->filter(fn (Purchase $purchase): bool => $purchase->transfer_payer_dni !== null
+                        && $this->dniDistance->distance($dni, $purchase->transfer_payer_dni) === 0)
+                    ->values();
 
-                $paymentData['matched_purchase_ids'] = $purchases->pluck('id')->all();
                 $compra = $purchases->count() === 1 ? $purchases->first() : null;
 
                 if (! $compra) {
-                    if ($purchases->count() > 1) {
-                        TelepagosPayment::create($paymentData);
+                    $candidatePurchases = $this->findTransferCandidates(
+                        $eligiblePurchases,
+                        $dni,
+                        $amount,
+                    );
+                    if ($candidatePurchases->isNotEmpty()) {
+                        $payment = $this->storeTransferCandidates(
+                            $paymentData,
+                            $candidatePurchases,
+                            $dni,
+                            $amount,
+                        );
+
+                        Log::channel('telepagos')->info('Telepagos webhook: Transfer payment candidates found.', [
+                            'client_code' => $client->code,
+                            'cashin_id' => $cashinId,
+                            'telepagos_payment_id' => $payment->id,
+                            'amount' => $amount,
+                            'candidate_count' => $payment->candidates->count(),
+                            'candidates' => $payment->candidates
+                                ->map(fn ($candidate): array => [
+                                    'purchase_id' => $candidate->compra_id,
+                                    'match_reason' => $candidate->match_reason,
+                                    'dni_distance' => $candidate->dni_distance,
+                                    'amount_difference' => $candidate->amount_difference,
+                                    'confidence' => $candidate->confidence,
+                                ])
+                                ->all(),
+                        ]);
                     }
 
                     Log::channel('telepagos')->warning('Telepagos webhook: Expected exactly one matching purchase.', [
@@ -209,4 +243,91 @@ class TelepagosWebhookService
     {
         return number_format((float) $amount, 2, '.', '');
     }
+
+    /**
+     * @param  Builder<Purchase>  $eligiblePurchases
+     * @return Collection<int, Purchase>
+     */
+    private function findTransferCandidates(Builder $eligiblePurchases, string $dni, string $amount): Collection
+    {
+        $tolerancePercentage = max(
+            0,
+            (float) config('purchase.transfer_candidate_amount_tolerance_percentage', 5),
+        );
+        $numericAmount = (float) $amount;
+        $tolerance = $numericAmount * ($tolerancePercentage / 100);
+        $minimumAmount = $this->normalizeAmount(max(0, $numericAmount - $tolerance));
+        $maximumAmount = $this->normalizeAmount($numericAmount + $tolerance);
+
+        return (clone $eligiblePurchases)
+            ->whereBetween('total', [$minimumAmount, $maximumAmount])
+            ->latest()
+            ->get()
+            ->filter(function (Purchase $purchase) use ($dni, $amount): bool {
+                if ($purchase->transfer_payer_dni === null) {
+                    return false;
+                }
+
+                $purchaseAmount = $this->normalizeAmount($purchase->total);
+                $distance = $this->dniDistance->distance(
+                    $dni,
+                    (string) $purchase->transfer_payer_dni,
+                );
+
+                return $distance === 0
+                    || ($purchaseAmount === $amount && $distance <= 2);
+            })
+            ->values();
+    }
+
+    /**
+     * @param  array<string, mixed>  $paymentData
+     * @param  Collection<int, Purchase>  $candidatePurchases
+     */
+    private function storeTransferCandidates(
+        array $paymentData,
+        Collection $candidatePurchases,
+        string $dni,
+        string $amount,
+    ): TelepagosPayment {
+        return DB::transaction(function () use ($paymentData, $candidatePurchases, $dni, $amount): TelepagosPayment {
+            $payment = TelepagosPayment::create($paymentData);
+
+            $payment->candidates()->createMany(
+                $candidatePurchases
+                    ->map(function (Purchase $purchase) use ($dni, $amount): array {
+                        $purchaseAmount = $this->normalizeAmount($purchase->total);
+                        $dniDistance = $this->dniDistance->distance(
+                            $dni,
+                            (string) $purchase->transfer_payer_dni,
+                        );
+                        $dniMatches = $dniDistance === 0;
+                        $amountMatches = $purchaseAmount === $amount;
+
+                        return [
+                            'compra_id' => $purchase->id,
+                            'dni_matches' => $dniMatches,
+                            'dni_distance' => $dniDistance,
+                            'payment_dni' => $dni,
+                            'purchase_dni' => $purchase->transfer_payer_dni,
+                            'amount_matches' => $amountMatches,
+                            'payment_amount' => $amount,
+                            'purchase_amount' => $purchaseAmount,
+                            'amount_difference' => $this->normalizeAmount(
+                                abs((float) $purchaseAmount - (float) $amount),
+                            ),
+                            'match_reason' => $amountMatches
+                                ? ($dniMatches ? 'ambiguous_exact_match' : 'exact_amount_near_dni')
+                                : 'exact_dni_near_amount',
+                            'confidence' => $amountMatches
+                                ? ($dniMatches ? 'exact' : 'medium')
+                                : 'high',
+                        ];
+                    })
+                    ->all(),
+            );
+
+            return $payment->load('candidates');
+        });
+    }
 }

app/Domains/Purchase/Models/Purchase.php

@@ -145,6 +145,12 @@ class Purchase extends Model
         return $this->hasMany(TelepagosPayment::class, 'compra_id');
     }
 
+    /** @return HasMany<TelepagosPaymentCandidate, $this> */
+    public function telepagosPaymentCandidates(): HasMany
+    {
+        return $this->hasMany(TelepagosPaymentCandidate::class, 'compra_id');
+    }
+
     public function getTotalAmount(): float
     {
         if ($this->total !== null) {

app/Domains/Purchase/Models/TelepagosPayment.php

@@ -6,10 +6,10 @@ use Illuminate\Database\Eloquent\Attributes\Fillable;
 use Illuminate\Database\Eloquent\Factories\HasFactory;
 use Illuminate\Database\Eloquent\Model;
 use Illuminate\Database\Eloquent\Relations\BelongsTo;
+use Illuminate\Database\Eloquent\Relations\HasMany;
 
 #[Fillable([
     'compra_id',
-    'matched_purchase_ids',
     'cuit_buyer',
     'cvu_buyer',
     'amount',
@@ -30,7 +30,6 @@ class TelepagosPayment extends Model
     {
         return [
             'compra_id' => 'integer',
-            'matched_purchase_ids' => 'array',
             'amount' => 'decimal:2',
         ];
     }
@@ -42,4 +41,10 @@ class TelepagosPayment extends Model
     {
         return $this->belongsTo(Purchase::class, 'compra_id');
     }
+
+    /** @return HasMany<TelepagosPaymentCandidate, $this> */
+    public function candidates(): HasMany
+    {
+        return $this->hasMany(TelepagosPaymentCandidate::class, 'telepagos_payment_id');
+    }
 }

app/Domains/Purchase/Models/TelepagosPaymentCandidate.php

@@ -0,0 +1,50 @@
+<?php
+
+namespace App\Domains\Purchase\Models;
+
+use Illuminate\Database\Eloquent\Attributes\Fillable;
+use Illuminate\Database\Eloquent\Model;
+use Illuminate\Database\Eloquent\Relations\BelongsTo;
+
+#[Fillable([
+    'telepagos_payment_id',
+    'compra_id',
+    'dni_matches',
+    'dni_distance',
+    'payment_dni',
+    'purchase_dni',
+    'amount_matches',
+    'payment_amount',
+    'purchase_amount',
+    'amount_difference',
+    'match_reason',
+    'confidence',
+])]
+class TelepagosPaymentCandidate extends Model
+{
+    protected $table = 'telepagos_payment_candidates';
+
+    protected function casts(): array
+    {
+        return [
+            'telepagos_payment_id' => 'integer',
+            'compra_id' => 'integer',
+            'dni_matches' => 'boolean',
+            'dni_distance' => 'integer',
+            'amount_matches' => 'boolean',
+            'payment_amount' => 'decimal:2',
+            'purchase_amount' => 'decimal:2',
+            'amount_difference' => 'decimal:2',
+        ];
+    }
+
+    public function payment(): BelongsTo
+    {
+        return $this->belongsTo(TelepagosPayment::class, 'telepagos_payment_id');
+    }
+
+    public function purchase(): BelongsTo
+    {
+        return $this->belongsTo(Purchase::class, 'compra_id');
+    }
+}

app/Domains/Purchase/Resources/PurchaseResource.php

@@ -4,6 +4,7 @@ namespace App\Domains\Purchase\Resources;
 
 use App\Domains\Purchase\Models\Purchase;
 use App\Domains\Purchase\Models\PurchaseItem;
+use App\Domains\Purchase\Models\TelepagosPaymentCandidate;
 use Illuminate\Http\Request;
 use Illuminate\Http\Resources\Json\JsonResource;
 
@@ -25,6 +26,7 @@ class PurchaseResource extends JsonResource
         $ticketsCount = array_key_exists('tickets_count', $this->resource->getAttributes())
             ? (int) $this->resource->getAttribute('tickets_count')
             : null;
+        $paymentVerification = $this->resolvePaymentVerification();
 
         $subtotal = $items->isNotEmpty()
             ? $items->reduce(
@@ -64,6 +66,7 @@ class PurchaseResource extends JsonResource
             'items' => PurchaseItemResource::collection($items),
             'tickets_count' => $this->when($ticketsCount !== null, $ticketsCount),
             'has_generated_tickets' => $this->when($ticketsCount !== null, $ticketsCount > 0),
+            'payment_verification' => $this->when($paymentVerification !== null, $paymentVerification),
             'subtotal' => $this->formatMoney($subtotal),
             'total' => $this->formatMoney($total),
         ];
@@ -83,4 +86,75 @@ class PurchaseResource extends JsonResource
     {
         return number_format((float) ($amount ?? 0), 2, '.', '');
     }
+
+    /** @return array<string, mixed>|null */
+    private function resolvePaymentVerification(): ?array
+    {
+        if (
+            $this->status !== Purchase::STATUS_IN_REVIEW
+            || $this->payment_method !== 'transfer'
+            || ! $this->resource->relationLoaded('telepagosPaymentCandidates')
+        ) {
+            return null;
+        }
+
+        $candidates = $this->resource
+            ->getRelation('telepagosPaymentCandidates')
+            ->sort(fn (TelepagosPaymentCandidate $left, TelepagosPaymentCandidate $right): int => $this->comparePaymentCandidates($left, $right))
+            ->values();
+        /** @var TelepagosPaymentCandidate|null $primary */
+        $primary = $candidates->first();
+
+        return [
+            'status' => $primary === null ? 'pending' : 'candidate',
+            'candidate_count' => $candidates->count(),
+            'primary' => $primary === null ? null : [
+                'reason' => $primary->match_reason,
+                'dni_distance' => $primary->dni_distance,
+                'payment_amount' => $this->formatMoney($primary->payment_amount),
+                'purchase_amount' => $this->formatMoney($primary->purchase_amount),
+                'amount_difference' => $this->formatMoney($primary->amount_difference),
+                'confidence' => $primary->confidence,
+                'detected_at' => $primary->payment?->created_at?->toIso8601String(),
+            ],
+            'reasons' => $candidates
+                ->pluck('match_reason')
+                ->unique()
+                ->values()
+                ->all(),
+        ];
+    }
+
+    private function comparePaymentCandidates(
+        TelepagosPaymentCandidate $left,
+        TelepagosPaymentCandidate $right,
+    ): int {
+        $reasonComparison = $this->paymentCandidateRank($left->match_reason)
+            <=> $this->paymentCandidateRank($right->match_reason);
+
+        if ($reasonComparison !== 0) {
+            return $reasonComparison;
+        }
+
+        $differenceComparison = (float) $left->amount_difference <=> (float) $right->amount_difference;
+
+        if ($differenceComparison !== 0) {
+            return $differenceComparison;
+        }
+
+        $leftTimestamp = $left->payment?->created_at?->getTimestamp() ?? 0;
+        $rightTimestamp = $right->payment?->created_at?->getTimestamp() ?? 0;
+
+        return ($rightTimestamp <=> $leftTimestamp) ?: ($right->id <=> $left->id);
+    }
+
+    private function paymentCandidateRank(string $reason): int
+    {
+        return match ($reason) {
+            'ambiguous_exact_match' => 0,
+            'exact_dni_near_amount' => 1,
+            'exact_amount_near_dni' => 2,
+            default => 3,
+        };
+    }
 }

app/Domains/Purchase/Services/Checkout/PurchaseResponseLoader.php

@@ -8,6 +8,15 @@ class PurchaseResponseLoader
 {
     public function load(Purchase $purchase): Purchase
     {
-        return $purchase->load(['tenant', 'items.imageAttachment', 'stockReservation']);
+        $relations = ['tenant', 'items.imageAttachment', 'stockReservation'];
+
+        if (
+            $purchase->status === Purchase::STATUS_IN_REVIEW
+            && $purchase->payment_method === 'transfer'
+        ) {
+            $relations[] = 'telepagosPaymentCandidates.payment';
+        }
+
+        return $purchase->load($relations);
     }
 }

app/Domains/Purchase/Services/DniDistanceService.php

@@ -0,0 +1,82 @@
+<?php
+
+namespace App\Domains\Purchase\Services;
+
+/**
+ * Measures likely DNI typing errors using the optimal-string-alignment
+ * variant of the Damerau-Levenshtein distance.
+ *
+ * The returned value is the minimum number of single-character edits needed
+ * to transform one DNI into the other. Supported edits are insertion,
+ * deletion, substitution and transposition of two adjacent digits.
+ */
+class DniDistanceService
+{
+    /**
+     * Calculate the edit distance between two normalized DNI strings.
+     *
+     * Each matrix cell [row][column] stores the minimum edits required to
+     * transform the first $row digits of $left into the first $column digits
+     * of $right. The bottom-right cell therefore contains the final distance.
+     */
+    public function distance(string $left, string $right): int
+    {
+        $left = $this->normalize($left);
+        $right = $this->normalize($right);
+        $leftLength = strlen($left);
+        $rightLength = strlen($right);
+        $matrix = [];
+
+        // Transforming a prefix into an empty string requires deleting every digit.
+        for ($row = 0; $row <= $leftLength; $row++) {
+            $matrix[$row] = [$row];
+        }
+
+        // Transforming an empty string into a prefix requires inserting every digit.
+        for ($column = 0; $column <= $rightLength; $column++) {
+            $matrix[0][$column] = $column;
+        }
+
+        for ($row = 1; $row <= $leftLength; $row++) {
+            for ($column = 1; $column <= $rightLength; $column++) {
+                $substitutionCost = $left[$row - 1] === $right[$column - 1] ? 0 : 1;
+                $deletionDistance = $matrix[$row - 1][$column] + 1;
+                $insertionDistance = $matrix[$row][$column - 1] + 1;
+                $substitutionDistance = $matrix[$row - 1][$column - 1] + $substitutionCost;
+
+                // Keep the cheapest way to align the two prefixes at this position.
+                $matrix[$row][$column] = min(
+                    $deletionDistance,
+                    $insertionDistance,
+                    $substitutionDistance,
+                );
+
+                // Count two adjacent inverted digits as one edit instead of two substitutions.
+                if (
+                    $row > 1
+                    && $column > 1
+                    && $left[$row - 1] === $right[$column - 2]
+                    && $left[$row - 2] === $right[$column - 1]
+                ) {
+                    $matrix[$row][$column] = min(
+                        $matrix[$row][$column],
+                        $matrix[$row - 2][$column - 2] + 1,
+                    );
+                }
+            }
+        }
+
+        return $matrix[$leftLength][$rightLength];
+    }
+
+    /**
+     * Keep only digits and left-pad seven-digit DNIs so comparisons preserve
+     * the leading zero that is present when the DNI is extracted from a CUIT.
+     */
+    public function normalize(string $dni): string
+    {
+        $digits = preg_replace('/\D+/', '', $dni) ?? '';
+
+        return str_pad($digits, 8, '0', STR_PAD_LEFT);
+    }
+}

app/Domains/Ticket/Controllers/AdminApp/TicketController.php

@@ -0,0 +1,53 @@
+<?php
+
+namespace App\Domains\Ticket\Controllers\AdminApp;
+
+use App\Domains\Ticket\Requests\AdminAppTicketExportRequest;
+use App\Domains\Ticket\Requests\AdminAppTicketIndexRequest;
+use App\Domains\Ticket\Resources\AdminApp\AdminAppTicketCollection;
+use App\Domains\Ticket\Services\AdminAppTicketExcelService;
+use App\Domains\Ticket\Services\AdminAppTicketPdfService;
+use App\Domains\Ticket\Services\AdminAppTicketService;
+use App\Http\Controllers\Controller;
+use Illuminate\Http\Response;
+use Symfony\Component\HttpFoundation\StreamedResponse;
+
+class TicketController extends Controller
+{
+    public function __construct(
+        private readonly AdminAppTicketService $ticketService,
+        private readonly AdminAppTicketPdfService $ticketPdfService,
+        private readonly AdminAppTicketExcelService $ticketExcelService,
+    ) {}
+
+    public function index(AdminAppTicketIndexRequest $request): AdminAppTicketCollection
+    {
+        $tenant = $request->user()->tenant()->firstOrFail();
+
+        return new AdminAppTicketCollection(
+            $this->ticketService->search($tenant, $request->validated())
+        );
+    }
+
+    public function downloadPdf(AdminAppTicketExportRequest $request): Response
+    {
+        $tenant = $request->user()->tenant()->firstOrFail();
+
+        return $this->ticketPdfService->download(
+            $tenant,
+            $this->ticketService->ticketsForExport($tenant, $request->validated()),
+            $request->validated('timezone'),
+        );
+    }
+
+    public function downloadExcel(AdminAppTicketExportRequest $request): StreamedResponse
+    {
+        $tenant = $request->user()->tenant()->firstOrFail();
+
+        return $this->ticketExcelService->download(
+            $tenant,
+            $this->ticketService->ticketsForExport($tenant, $request->validated()),
+            $request->validated('timezone'),
+        );
+    }
+}

app/Domains/Ticket/Requests/AdminAppTicketExportRequest.php

@@ -0,0 +1,17 @@
+<?php
+
+namespace App\Domains\Ticket\Requests;
+
+use App\Domains\Shared\Rules\ValidTimezone;
+
+class AdminAppTicketExportRequest extends AdminAppTicketIndexRequest
+{
+    /** @return array<string, mixed> */
+    public function rules(): array
+    {
+        return [
+            ...parent::rules(),
+            'timezone' => ['required', 'string', new ValidTimezone],
+        ];
+    }
+}

app/Domains/Ticket/Requests/AdminAppTicketIndexRequest.php

@@ -0,0 +1,46 @@
+<?php
+
+namespace App\Domains\Ticket\Requests;
+
+use App\Domains\Ticket\Models\Ticket;
+use App\Domains\Ticket\Services\AdminAppTicketColumnService;
+use Illuminate\Foundation\Http\FormRequest;
+use Illuminate\Validation\Rule;
+
+class AdminAppTicketIndexRequest extends FormRequest
+{
+    public function authorize(): bool
+    {
+        return true;
+    }
+
+    /** @return array<string, list<string>> */
+    public function rules(): array
+    {
+        $tenant = $this->user()?->tenant()->first();
+        $sortableKeys = $tenant === null
+            ? []
+            : app(AdminAppTicketColumnService::class)->sortableKeys($tenant);
+
+        return [
+            'q' => ['sometimes', 'nullable', 'string', 'max:255'],
+            'category' => ['sometimes', 'nullable', 'string', 'max:255'],
+            'product' => ['sometimes', 'nullable', 'string', 'max:255'],
+            'type' => ['sometimes', 'nullable', 'string', 'max:255'],
+            'date' => ['sometimes', 'nullable', 'date_format:Y-m-d'],
+            'status' => [
+                'sometimes',
+                'nullable',
+                Rule::in([
+                    Ticket::STATUS_ACTIVE,
+                    Ticket::STATUS_USED,
+                    Ticket::STATUS_EXPIRED,
+                ]),
+            ],
+            'page' => ['sometimes', 'integer', 'min:1'],
+            'per_page' => ['sometimes', 'integer', 'min:1', 'max:100'],
+            'sort_by' => ['sometimes', 'nullable', 'string', Rule::in($sortableKeys)],
+            'sort_direction' => ['sometimes', 'nullable', 'string', Rule::in(['asc', 'desc'])],
+        ];
+    }
+}

app/Domains/Ticket/Resources/AdminApp/AdminAppTicketCollection.php

@@ -0,0 +1,34 @@
+<?php
+
+namespace App\Domains\Ticket\Resources\AdminApp;
+
+use App\Domains\Ticket\Services\AdminAppTicketResult;
+use Illuminate\Http\Request;
+use Illuminate\Http\Resources\Json\ResourceCollection;
+
+class AdminAppTicketCollection extends ResourceCollection
+{
+    /** @var class-string<AdminAppTicketResource> */
+    public $collects = AdminAppTicketResource::class;
+
+    private readonly int $scannedTickets;
+
+    private readonly int $totalTickets;
+
+    public function __construct(AdminAppTicketResult $result)
+    {
+        parent::__construct($result->tickets);
+
+        $this->scannedTickets = $result->scannedTickets;
+        $this->totalTickets = $result->totalTickets;
+    }
+
+    /** @return array{scanned_tickets: int, total_tickets: int} */
+    public function with(Request $request): array
+    {
+        return [
+            'scanned_tickets' => $this->scannedTickets,
+            'total_tickets' => $this->totalTickets,
+        ];
+    }
+}

app/Domains/Ticket/Resources/AdminApp/AdminAppTicketResource.php

@@ -0,0 +1,25 @@
+<?php
+
+namespace App\Domains\Ticket\Resources\AdminApp;
+
+use App\Domains\Ticket\Models\Ticket;
+use App\Domains\Ticket\Resources\TicketResource;
+use App\Domains\Ticket\Services\AdminAppTicketRowService;
+use Illuminate\Http\Request;
+
+/** @mixin Ticket */
+class AdminAppTicketResource extends TicketResource
+{
+    /** @return array<string, mixed> */
+    public function toArray(Request $request): array
+    {
+        $rowService = app(AdminAppTicketRowService::class);
+        $details = $rowService->details($this->resource);
+
+        return [
+            ...parent::toArray($request),
+            ...$details,
+            'values' => $rowService->values($this->resource, $details),
+        ];
+    }
+}

app/Domains/Ticket/Services/AdminAppTicketColumnService.php

@@ -0,0 +1,103 @@
+<?php
+
+namespace App\Domains\Ticket\Services;
+
+use App\Domains\Tenant\Models\Tenant;
+
+class AdminAppTicketColumnService
+{
+    private const FIESTA_FUTBOL_INFANTIL = 'fiesta_futbol_infantil';
+
+    /** @return list<array{key: string, label: string, type: string, sortable: bool, sort_param: string, width: string, excel_width: int}> */
+    public function columns(Tenant $tenant): array
+    {
+        $keys = $tenant->codigo === self::FIESTA_FUTBOL_INFANTIL
+            ? ['order_number', 'category', 'product', 'type', 'amount', 'client', 'ticket', 'date', 'status', 'scanned_by']
+            : ['order_number', 'product', 'amount', 'client', 'ticket', 'date', 'status', 'scanned_by'];
+
+        $columns = array_map(fn (string $key): array => $this->definitions()[$key], $keys);
+
+        if ($tenant->codigo === self::FIESTA_FUTBOL_INFANTIL) {
+            $columns = array_map(function (array $column): array {
+                if (in_array($column['key'], ['product', 'type'], true)) {
+                    $column['sortable'] = false;
+                }
+
+                return $column;
+            }, $columns);
+        } else {
+            $widths = [
+                'order_number' => '11%',
+                'product' => '15%',
+                'amount' => '10%',
+                'client' => '15%',
+                'ticket' => '19%',
+                'date' => '11%',
+                'status' => '8%',
+                'scanned_by' => '11%',
+            ];
+            $columns = array_map(function (array $column) use ($widths): array {
+                $column['width'] = $widths[$column['key']];
+
+                return $column;
+            }, $columns);
+        }
+
+        return $columns;
+    }
+
+    /** @return list<array{key: string, label: string, type: string, sortable: bool, sort_param: string, width: string}> */
+    public function publicColumns(Tenant $tenant): array
+    {
+        return array_map(function (array $column): array {
+            unset($column['excel_width']);
+
+            return $column;
+        }, $this->columns($tenant));
+    }
+
+    /** @return list<string> */
+    public function sortableKeys(Tenant $tenant): array
+    {
+        return array_values(array_map(
+            fn (array $column): string => $column['sort_param'],
+            array_filter($this->columns($tenant), fn (array $column): bool => $column['sortable']),
+        ));
+    }
+
+    /** @return array<string, array{key: string, label: string, type: string, sortable: bool, sort_param: string, width: string, excel_width: int}> */
+    private function definitions(): array
+    {
+        return [
+            'order_number' => $this->column('order_number', 'N° de orden', 'order_number', '10.5%', 14),
+            'category' => $this->column('category', 'Categoría', 'text', '11%', 18),
+            'product' => $this->column('product', 'Producto', 'text', '11%', 22),
+            'type' => $this->column('type', 'Tipo', 'text', '8%', 18),
+            'amount' => $this->column('amount', 'Importe', 'currency', '9%', 15),
+            'client' => $this->column('client', 'Cliente', 'text', '13%', 30),
+            'ticket' => $this->column('ticket', 'ID', 'text', '14.5%', 39),
+            'date' => $this->column('date', 'Fecha', 'date', '9.5%', 20),
+            'status' => $this->column('status', 'Estado', 'status', '7%', 13),
+            'scanned_by' => $this->column('scanned_by', 'Escaneado por', 'text', '9%', 28),
+        ];
+    }
+
+    /** @return array{key: string, label: string, type: string, sortable: bool, sort_param: string, width: string, excel_width: int} */
+    private function column(
+        string $key,
+        string $label,
+        string $type,
+        string $width,
+        int $excelWidth,
+    ): array {
+        return [
+            'key' => $key,
+            'label' => $label,
+            'type' => $type,
+            'sortable' => true,
+            'sort_param' => $key,
+            'width' => $width,
+            'excel_width' => $excelWidth,
+        ];
+    }
+}

app/Domains/Ticket/Services/AdminAppTicketExcelService.php

@@ -0,0 +1,105 @@
+<?php
+
+namespace App\Domains\Ticket\Services;
+
+use App\Domains\Tenant\Models\Tenant;
+use App\Domains\Ticket\Models\Ticket;
+use Carbon\CarbonInterface;
+use Illuminate\Support\Collection;
+use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
+use PhpOffice\PhpSpreadsheet\Cell\DataType;
+use PhpOffice\PhpSpreadsheet\Shared\Date;
+use PhpOffice\PhpSpreadsheet\Spreadsheet;
+use PhpOffice\PhpSpreadsheet\Style\Alignment;
+use PhpOffice\PhpSpreadsheet\Style\Fill;
+use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
+use Symfony\Component\HttpFoundation\StreamedResponse;
+
+class AdminAppTicketExcelService
+{
+    public function __construct(
+        private readonly AdminAppTicketReportService $reportService,
+        private readonly AdminAppTicketColumnService $columnService,
+    ) {}
+
+    /** @param Collection<int, Ticket> $tickets */
+    public function download(Tenant $tenant, Collection $tickets, string $timeZone): StreamedResponse
+    {
+        $generatedAt = now();
+        $rows = $this->reportService->rows($tickets);
+        $columns = $this->columnService->columns($tenant);
+        $spreadsheet = new Spreadsheet;
+        $spreadsheet->getProperties()
+            ->setCreator('Shopit')
+            ->setTitle('Listado de tickets')
+            ->setSubject($tenant->nombre);
+        $sheet = $spreadsheet->getActiveSheet();
+        $sheet->setTitle('Tickets');
+        $sheet->fromArray([array_column($columns, 'label')], null, 'A1');
+
+        foreach ($rows as $index => $ticket) {
+            $row = $index + 2;
+            foreach ($columns as $columnIndex => $column) {
+                $coordinate = Coordinate::stringFromColumnIndex($columnIndex + 1).$row;
+                $value = $ticket[$column['key']] ?? null;
+
+                if ($column['type'] === 'currency' && $value !== null) {
+                    $sheet->setCellValue($coordinate, (float) $value);
+
+                    continue;
+                }
+
+                if ($column['type'] === 'date' && $value instanceof CarbonInterface) {
+                    $sheet->setCellValue(
+                        $coordinate,
+                        Date::dateTimeToExcel($value->copy()->timezone($timeZone)),
+                    );
+
+                    continue;
+                }
+
+                $sheet->setCellValueExplicit(
+                    $coordinate,
+                    $this->reportService->displayValue($value, $column['type'], $timeZone),
+                    DataType::TYPE_STRING,
+                );
+            }
+        }
+
+        $lastRow = max(2, $rows->count() + 1);
+        $lastColumn = Coordinate::stringFromColumnIndex(count($columns));
+        foreach ($columns as $columnIndex => $column) {
+            $letter = Coordinate::stringFromColumnIndex($columnIndex + 1);
+            if ($column['type'] === 'currency') {
+                $sheet->getStyle("{$letter}2:{$letter}{$lastRow}")
+                    ->getNumberFormat()->setFormatCode('$ #,##0.00');
+            }
+            if ($column['type'] === 'date') {
+                $sheet->getStyle("{$letter}2:{$letter}{$lastRow}")
+                    ->getNumberFormat()->setFormatCode('dd/mm/yyyy hh:mm');
+            }
+            $sheet->getColumnDimension($letter)->setWidth($column['excel_width']);
+        }
+        $sheet->getStyle("A1:{$lastColumn}1")->applyFromArray([
+            'font' => ['bold' => true, 'color' => ['rgb' => 'FFFFFF']],
+            'fill' => [
+                'fillType' => Fill::FILL_SOLID,
+                'startColor' => ['rgb' => '26382E'],
+            ],
+            'alignment' => ['vertical' => Alignment::VERTICAL_CENTER],
+        ]);
+        $sheet->getRowDimension(1)->setRowHeight(24);
+        $sheet->freezePane('A2');
+        $sheet->setAutoFilter("A1:{$lastColumn}{$lastRow}");
+
+        $filename = 'tickets_'.$tenant->codigo.'_'
+            .$generatedAt->copy()->timezone($timeZone)->format('Ymd_His').'.xlsx';
+
+        return response()->streamDownload(function () use ($spreadsheet): void {
+            (new Xlsx($spreadsheet))->save('php://output');
+            $spreadsheet->disconnectWorksheets();
+        }, $filename, [
+            'Content-Type' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
+        ]);
+    }
+}

app/Domains/Ticket/Services/AdminAppTicketPdfService.php

@@ -0,0 +1,56 @@
+<?php
+
+namespace App\Domains\Ticket\Services;
+
+use App\Domains\Tenant\Models\Tenant;
+use App\Domains\Ticket\Models\Ticket;
+use Barryvdh\DomPDF\Facade\Pdf;
+use Barryvdh\DomPDF\PDF as DomPdf;
+use Illuminate\Http\Response;
+use Illuminate\Support\Collection;
+
+class AdminAppTicketPdfService
+{
+    public function __construct(
+        private readonly AdminAppTicketReportService $reportService,
+        private readonly AdminAppTicketColumnService $columnService,
+    ) {}
+
+    /** @param Collection<int, Ticket> $tickets */
+    public function download(Tenant $tenant, Collection $tickets, string $timeZone): Response
+    {
+        $generatedAt = now();
+        $columns = $this->columnService->columns($tenant);
+        $rows = $this->reportService->rows($tickets);
+        $pdf = Pdf::loadView('pdf.adminapp.tickets', [
+            'tenant' => $tenant,
+            'columns' => $columns,
+            'tickets' => $this->reportService->displayRows($rows, $columns, $timeZone),
+            'generatedAt' => $generatedAt,
+            'timeZone' => $timeZone,
+        ])->setPaper('a3', 'landscape');
+
+        $this->addPageNumbers($pdf);
+
+        return $pdf->download(
+            'tickets_'.$tenant->codigo.'_'
+            .$generatedAt->copy()->timezone($timeZone)->format('Ymd_His').'.pdf'
+        );
+    }
+
+    private function addPageNumbers(DomPdf $pdf): void
+    {
+        $pdf->render();
+        $domPdf = $pdf->getDomPDF();
+        $font = $domPdf->getFontMetrics()->getFont('DejaVu Sans');
+
+        $domPdf->getCanvas()->page_text(
+            565,
+            805,
+            'Página {PAGE_NUM} de {PAGE_COUNT}',
+            $font,
+            7,
+            [0.48, 0.52, 0.49],
+        );
+    }
+}

app/Domains/Ticket/Services/AdminAppTicketReportService.php

@@ -0,0 +1,35 @@
+<?php
+
+namespace App\Domains\Ticket\Services;
+
+use App\Domains\Ticket\Models\Ticket;
+use Illuminate\Support\Collection;
+
+class AdminAppTicketReportService
+{
+    public function __construct(private readonly AdminAppTicketRowService $rowService) {}
+
+    /**
+     * @param  Collection<int, Ticket>  $tickets
+     * @return Collection<int, array<string, mixed>>
+     */
+    public function rows(Collection $tickets): Collection
+    {
+        return $this->rowService->rows($tickets);
+    }
+
+    /**
+     * @param  Collection<int, array<string, mixed>>  $rows
+     * @param  list<array<string, mixed>>  $columns
+     * @return Collection<int, array<string, string>>
+     */
+    public function displayRows(Collection $rows, array $columns, string $timeZone): Collection
+    {
+        return $this->rowService->displayRows($rows, $columns, $timeZone);
+    }
+
+    public function displayValue(mixed $value, string $type, string $timeZone): string
+    {
+        return $this->rowService->displayValue($value, $type, $timeZone);
+    }
+}

app/Domains/Ticket/Services/AdminAppTicketResult.php

@@ -0,0 +1,16 @@
+<?php
+
+namespace App\Domains\Ticket\Services;
+
+use App\Domains\Ticket\Models\Ticket;
+use Illuminate\Pagination\LengthAwarePaginator;
+
+final readonly class AdminAppTicketResult
+{
+    /** @param LengthAwarePaginator<Ticket> $tickets */
+    public function __construct(
+        public LengthAwarePaginator $tickets,
+        public int $scannedTickets,
+        public int $totalTickets,
+    ) {}
+}

app/Domains/Ticket/Services/AdminAppTicketRowService.php

@@ -0,0 +1,217 @@
+<?php
+
+namespace App\Domains\Ticket\Services;
+
+use App\Domains\Catalog\Models\ItemAttribute;
+use App\Domains\Purchase\Models\PurchaseItem;
+use App\Domains\Ticket\Models\Ticket;
+use Carbon\Carbon;
+use Carbon\CarbonInterface;
+use Illuminate\Support\Collection;
+
+class AdminAppTicketRowService
+{
+    private const FIESTA_FUTBOL_INFANTIL = 'fiesta_futbol_infantil';
+
+    private const CATEGORY_PRESENTATIONS = [
+        'alojamientos' => ['category' => 'Camping', 'product' => 'tipo_alojamiento', 'type' => null],
+        'camping' => ['category' => null, 'product' => 'tipo_alojamiento', 'type' => null],
+        'entradas' => ['category' => null, 'product' => 'product', 'type' => null],
+        'comidas' => ['category' => 'Comida', 'product' => 'event_date', 'type' => 'horario'],
+        'comida' => ['category' => null, 'product' => 'event_date', 'type' => 'horario'],
+        'merchandising' => ['category' => null, 'product' => 'product', 'type' => 'color'],
+    ];
+
+    /** @return array<string, mixed> */
+    public function details(Ticket $ticket): array
+    {
+        $purchaseItem = $this->sourcePurchaseItem($ticket);
+
+        return [
+            'source_purchase_id' => $ticket->source_purchase_id,
+            'order_number' => $ticket->source_purchase_id,
+            'product' => $purchaseItem?->item_nombre
+                ?? $ticket->sourceCatalogItem?->nombre
+                ?? $ticket->name,
+            'amount' => $purchaseItem?->precio_unitario,
+            'client' => $ticket->sourcePurchase?->nombre_apellido ?? $ticket->user?->nombre_apellido,
+            'date' => $ticket->sourcePurchase?->created_at,
+            'status' => $ticket->status,
+            'scanned_by' => $ticket->scannerUser?->nombre_apellido,
+            'variant_properties' => $this->variantProperties($ticket),
+        ];
+    }
+
+    /** @param array<string, mixed>|null $details */
+    public function values(Ticket $ticket, ?array $details = null): array
+    {
+        $details ??= $this->details($ticket);
+        $presentation = $this->presentation($ticket, $details);
+
+        return [
+            'order_number' => $details['order_number'],
+            'category' => $presentation['category'],
+            'product' => $presentation['product'],
+            'type' => $presentation['type'],
+            'amount' => $details['amount'] === null ? null : (float) $details['amount'],
+            'client' => $details['client'] ?? 'Sin nombre',
+            'ticket' => $ticket->ticket,
+            'date' => $details['date'],
+            'status' => $details['status'],
+            'scanned_by' => $details['scanned_by'] ?? '-',
+        ];
+    }
+
+    /**
+     * @param  Collection<int, Ticket>  $tickets
+     * @return Collection<int, array<string, mixed>>
+     */
+    public function rows(Collection $tickets): Collection
+    {
+        return $tickets->values()->map(fn (Ticket $ticket): array => $this->values($ticket));
+    }
+
+    /**
+     * @param  Collection<int, array<string, mixed>>  $rows
+     * @param  list<array<string, mixed>>  $columns
+     * @return Collection<int, array<string, string>>
+     */
+    public function displayRows(Collection $rows, array $columns, string $timeZone): Collection
+    {
+        return $rows->map(fn (array $row): array => collect($columns)
+            ->mapWithKeys(fn (array $column): array => [
+                $column['key'] => $this->displayValue(
+                    $row[$column['key']] ?? null,
+                    $column['type'],
+                    $timeZone,
+                ),
+            ])
+            ->all());
+    }
+
+    public function displayValue(mixed $value, string $type, string $timeZone): string
+    {
+        if ($value === null || $value === '') {
+            return '-';
+        }
+
+        return match ($type) {
+            'order_number' => '#'.$value,
+            'currency' => '$'.number_format((float) $value, 2, ',', '.'),
+            'date' => ($value instanceof CarbonInterface ? $value : Carbon::parse((string) $value))
+                ->copy()->timezone($timeZone)->format('d/m/Y H:i'),
+            'status' => match ((string) $value) {
+                Ticket::STATUS_USED => 'Usado',
+                Ticket::STATUS_EXPIRED => 'Vencido',
+                default => 'Activo',
+            },
+            default => (string) $value,
+        };
+    }
+
+    /** @param array<string, mixed> $details */
+    private function presentation(Ticket $ticket, array $details): array
+    {
+        $sourceCategory = trim((string) ($ticket->sourceCatalogItem?->category?->nombre ?? '')) ?: '-';
+
+        if ($ticket->tenant_code !== self::FIESTA_FUTBOL_INFANTIL) {
+            return [
+                'category' => $sourceCategory,
+                'product' => (string) ($details['product'] ?: $ticket->name ?: '-'),
+                'type' => $this->allPropertyLabels($details) ?: '-',
+            ];
+        }
+
+        $configuration = self::CATEGORY_PRESENTATIONS[mb_strtolower($sourceCategory)] ?? null;
+        if ($configuration === null) {
+            return [
+                'category' => $sourceCategory,
+                'product' => (string) ($details['product'] ?: $ticket->name ?: '-'),
+                'type' => $this->allPropertyLabels($details) ?: '-',
+            ];
+        }
+
+        return [
+            'category' => $configuration['category'] ?? $sourceCategory,
+            'product' => $configuration['product'] === 'product'
+                ? (string) ($details['product'] ?: $ticket->name ?: '-')
+                : ($this->propertyLabels($details, $configuration['product']) ?: '-'),
+            'type' => $configuration['type'] === null
+                ? '-'
+                : ($this->propertyLabels($details, $configuration['type']) ?: '-'),
+        ];
+    }
+
+    /** @param array<string, mixed> $details */
+    private function propertyLabels(array $details, string $code): string
+    {
+        $property = collect($details['variant_properties'] ?? [])->firstWhere('code', $code);
+        $labels = collect($property['values'] ?? [])->pluck('label')->filter();
+
+        if ($code === 'event_date') {
+            $labels = $labels->map(function (string $label): string {
+                [$day, $month] = array_pad(explode('/', $label), 2, null);
+
+                return $day !== null && $month !== null ? "{$day}/{$month}" : $label;
+            });
+        }
+
+        return $labels->implode(', ');
+    }
+
+    /** @param array<string, mixed> $details */
+    private function allPropertyLabels(array $details): string
+    {
+        return collect($details['variant_properties'] ?? [])
+            ->flatMap(fn (array $property): array => $property['values'] ?? [])
+            ->pluck('label')
+            ->filter()
+            ->implode(', ');
+    }
+
+    private function sourcePurchaseItem(Ticket $ticket): ?PurchaseItem
+    {
+        return $ticket->sourcePurchase?->items->first(function (PurchaseItem $item) use ($ticket): bool {
+            if ($ticket->source_variant_id !== null) {
+                return $item->source_variant_id === $ticket->source_variant_id;
+            }
+
+            return $item->source_catalog_item_id === $ticket->source_catalog_item_id
+                && $item->source_variant_id === null;
+        });
+    }
+
+    /** @return list<array{code: string, label: string, values: list<array{value: string, label: string}>}> */
+    private function variantProperties(Ticket $ticket): array
+    {
+        $variant = $ticket->sourceVariant;
+        if ($variant === null) {
+            return [];
+        }
+
+        $itemAttributes = $variant->definitions
+            ->map(fn ($definition) => $definition->itemAttribute)
+            ->filter()
+            ->merge($variant->catalogItem?->itemAttributes ?? collect())
+            ->unique('id')
+            ->values();
+
+        return $variant->selectionOptions($itemAttributes)
+            ->map(function (array $selection, string $attributeCode) use ($itemAttributes): array {
+                $itemAttribute = $itemAttributes->first(
+                    fn (ItemAttribute $itemAttribute): bool => $itemAttribute->attribute?->codigo
+                        === $attributeCode,
+                );
+                $values = array_is_list($selection) ? $selection : [$selection];
+
+                return [
+                    'code' => $attributeCode,
+                    'label' => $itemAttribute?->attribute?->nombre
+                        ?? ($attributeCode === 'event_date' ? 'Fecha' : $attributeCode),
+                    'values' => array_values($values),
+                ];
+            })
+            ->values()
+            ->all();
+    }
+}

app/Domains/Ticket/Services/AdminAppTicketService.php

@@ -0,0 +1,338 @@
+<?php
+
+namespace App\Domains\Ticket\Services;
+
+use App\Domains\Auth\Models\User;
+use App\Domains\Purchase\Models\Purchase;
+use App\Domains\Purchase\Models\PurchaseItem;
+use App\Domains\Tenant\Models\Tenant;
+use App\Domains\Ticket\Models\Ticket;
+use Illuminate\Database\Eloquent\Builder;
+use Illuminate\Pagination\LengthAwarePaginator;
+use Illuminate\Support\Collection;
+
+class AdminAppTicketService
+{
+    private const RELATIONS = [
+        ...TicketValidityResolver::RELATIONS,
+        ...TicketPresentationResolver::RELATIONS,
+        'user',
+        'scannerUser',
+        'sourceCatalogItem.category',
+        'sourcePurchase.items',
+    ];
+
+    public function __construct(
+        private readonly AdminAppTicketColumnService $columnService,
+        private readonly AdminAppTicketRowService $rowService,
+    ) {}
+
+    /**
+     * @param  array{q?: string|null, category?: string|null, product?: string|null, type?: string|null, date?: string|null, status?: string|null, page?: int, per_page?: int, sort_by?: string|null, sort_direction?: string|null}  $filters
+     */
+    public function search(Tenant $tenant, array $filters = []): AdminAppTicketResult
+    {
+        $query = $this->baseQuery($tenant, $filters);
+        $countQuery = clone $query;
+
+        $databaseSorted = $this->applyDatabaseSort($query, $tenant, $filters);
+
+        if (($filters['sort_by'] ?? null) && ! $databaseSorted) {
+            $matchingTickets = (clone $query)
+                ->with(self::RELATIONS)
+                ->get();
+            $matchingTickets = $this->sortTickets($matchingTickets, $tenant, $filters);
+            $tickets = $this->paginate($matchingTickets, $filters);
+            $scannedTickets = $matchingTickets->whereNotNull('used_at')->count();
+        } else {
+            $tickets = (clone $query)
+                ->with(self::RELATIONS)
+                ->when(! $databaseSorted, fn (Builder $query): Builder => $query->orderByDesc('id'))
+                ->paginateFromRequest()
+                ->withQueryString();
+            $scannedTickets = $countQuery->whereNotNull('used_at')->count();
+        }
+
+        return new AdminAppTicketResult(
+            tickets: $tickets,
+            scannedTickets: $scannedTickets,
+            totalTickets: $tickets->total(),
+        );
+    }
+
+    /**
+     * @param  array{q?: string|null, category?: string|null, product?: string|null, type?: string|null, date?: string|null, status?: string|null, sort_by?: string|null, sort_direction?: string|null}  $filters
+     * @return Collection<int, Ticket>
+     */
+    public function ticketsForExport(Tenant $tenant, array $filters = []): Collection
+    {
+        $query = $this->baseQuery($tenant, $filters);
+        $databaseSorted = $this->applyDatabaseSort($query, $tenant, $filters);
+        $tickets = $query
+            ->with(self::RELATIONS)
+            ->when(! $databaseSorted, fn (Builder $query): Builder => $query->orderByDesc('id'))
+            ->get();
+
+        return $databaseSorted ? $tickets : $this->sortTickets($tickets, $tenant, $filters);
+    }
+
+    /**
+     * @param  array{q?: string|null, category?: string|null, product?: string|null, type?: string|null, date?: string|null, status?: string|null, page?: int, per_page?: int}  $filters
+     * @return Builder<Ticket>
+     */
+    private function baseQuery(Tenant $tenant, array $filters): Builder
+    {
+        $search = trim((string) ($filters['q'] ?? ''));
+
+        $query = Ticket::query()
+            ->where('tenant_code', $tenant->codigo)
+            ->when($search !== '', function (Builder $query) use ($search): void {
+                $query->when(
+                    ctype_digit($search),
+                    fn (Builder $searchQuery): Builder => $searchQuery
+                        ->where('tickets.id', (int) $search),
+                    fn (Builder $searchQuery): Builder => $searchQuery
+                        ->where('ticket', 'like', "%{$search}%"),
+                );
+            })
+            ->when($filters['category'] ?? null, function (Builder $query, string $category): void {
+                $query->whereHas('sourceCatalogItem.category', fn (Builder $categoryQuery): Builder => $categoryQuery
+                    ->whereRaw('LOWER(nombre) = ?', [mb_strtolower(trim($category))]));
+            })
+            ->when($filters['product'] ?? null, function (Builder $query, string $product) use ($filters): void {
+                $this->applyProductFilter($query, (string) ($filters['category'] ?? ''), $product);
+            })
+            ->when($filters['type'] ?? null, function (Builder $query, string $type) use ($filters): void {
+                $this->applyTypeFilter($query, (string) ($filters['category'] ?? ''), $type);
+            })
+            ->when($filters['date'] ?? null, fn (Builder $query, string $date): Builder => $query
+                ->whereHas('sourcePurchase', fn (Builder $purchaseQuery): Builder => $purchaseQuery
+                    ->whereDate('created_at', $date)));
+
+        $this->applyStatusFilter($query, $filters['status'] ?? null);
+
+        return $query;
+    }
+
+    /** @param Builder<Ticket> $query */
+    private function applyProductFilter(Builder $query, string $category, string $product): void
+    {
+        $category = $this->normalizedCategory($category);
+
+        if (in_array($category, ['alojamientos', 'camping'], true)) {
+            $this->whereVariantDefinition($query, 'tipo_alojamiento', $product);
+
+            return;
+        }
+
+        if (in_array($category, ['comidas', 'comida'], true)) {
+            $query->whereHas('sourceVariant', function (Builder $variantQuery) use ($product): void {
+                $variantQuery->where(function (Builder $dateQuery) use ($product): void {
+                    $dateQuery
+                        ->where('event_date_id', $product)
+                        ->orWhereHas('eventDates', fn (Builder $eventDateQuery): Builder => $eventDateQuery
+                            ->whereKey($product));
+                });
+            });
+
+            return;
+        }
+
+        $query->whereHas('sourceCatalogItem', fn (Builder $itemQuery): Builder => $itemQuery
+            ->where('slug', $product));
+    }
+
+    /** @param Builder<Ticket> $query */
+    private function applyTypeFilter(Builder $query, string $category, string $type): void
+    {
+        $attribute = match ($this->normalizedCategory($category)) {
+            'comidas', 'comida' => 'horario',
+            'merchandising' => 'color',
+            default => null,
+        };
+
+        if ($attribute !== null) {
+            $this->whereVariantDefinition($query, $attribute, $type);
+        }
+    }
+
+    /** @param Builder<Ticket> $query */
+    private function whereVariantDefinition(Builder $query, string $attribute, string $value): void
+    {
+        $query->whereHas('sourceVariant.definitions', fn (Builder $definitionQuery): Builder => $definitionQuery
+            ->where('value', $value)
+            ->whereHas('itemAttribute.attribute', fn (Builder $attributeQuery): Builder => $attributeQuery
+                ->where('codigo', $attribute)));
+    }
+
+    /** @param Builder<Ticket> $query */
+    private function applyStatusFilter(Builder $query, ?string $status): void
+    {
+        if ($status === null || $status === '') {
+            return;
+        }
+
+        if ($status === Ticket::STATUS_USED) {
+            $query->whereNotNull('used_at');
+
+            return;
+        }
+
+        $matchingIds = (clone $query)
+            ->whereNull('used_at')
+            ->with(TicketValidityResolver::RELATIONS)
+            ->get()
+            ->filter(fn (Ticket $ticket): bool => $ticket->status === $status)
+            ->pluck('id');
+
+        $query->whereIn('tickets.id', $matchingIds);
+    }
+
+    private function normalizedCategory(string $category): string
+    {
+        return mb_strtolower(trim($category));
+    }
+
+    /**
+     * @param  Builder<Ticket>  $query
+     * @param  array{sort_by?: string|null, sort_direction?: string|null}  $filters
+     */
+    private function applyDatabaseSort(Builder $query, Tenant $tenant, array $filters): bool
+    {
+        $sortBy = (string) ($filters['sort_by'] ?? '');
+        if ($sortBy === '') {
+            return false;
+        }
+
+        $direction = ($filters['sort_direction'] ?? 'asc') === 'desc' ? 'desc' : 'asc';
+
+        $sortExpression = match ($sortBy) {
+            'order_number' => 'tickets.source_purchase_id',
+            'ticket' => 'tickets.ticket',
+            'date' => Purchase::query()
+                ->select('created_at')
+                ->whereColumn('compras.id', 'tickets.source_purchase_id'),
+            'amount' => $this->purchaseItemSortQuery('precio_unitario'),
+            'scanned_by' => User::query()
+                ->select('nombre_apellido')
+                ->whereColumn('users.id', 'tickets.scanner_user_id'),
+            'product' => $tenant->codigo === 'fiesta_futbol_infantil'
+                ? null
+                : $this->purchaseItemSortQuery('item_nombre'),
+            default => null,
+        };
+
+        if ($sortExpression === null) {
+            return false;
+        }
+
+        $query->orderBy($sortExpression, $direction)->orderByDesc('tickets.id');
+
+        return true;
+    }
+
+    /** @return Builder<PurchaseItem> */
+    private function purchaseItemSortQuery(string $column): Builder
+    {
+        return PurchaseItem::query()
+            ->select($column)
+            ->whereColumn('compra_items.compra_id', 'tickets.source_purchase_id')
+            ->where(function (Builder $query): void {
+                $query
+                    ->where(function (Builder $variantQuery): void {
+                        $variantQuery
+                            ->whereNotNull('tickets.source_variant_id')
+                            ->whereColumn('compra_items.source_variant_id', 'tickets.source_variant_id');
+                    })
+                    ->orWhere(function (Builder $itemQuery): void {
+                        $itemQuery
+                            ->whereNull('tickets.source_variant_id')
+                            ->whereNull('compra_items.source_variant_id')
+                            ->whereColumn('compra_items.source_catalog_item_id', 'tickets.source_catalog_item_id');
+                    });
+            })
+            ->limit(1);
+    }
+
+    /**
+     * @param  Collection<int, Ticket>  $tickets
+     * @param  array{sort_by?: string|null, sort_direction?: string|null}  $filters
+     * @return Collection<int, Ticket>
+     */
+    private function sortTickets(Collection $tickets, Tenant $tenant, array $filters): Collection
+    {
+        $sortBy = (string) ($filters['sort_by'] ?? '');
+        if ($sortBy === '') {
+            return $tickets;
+        }
+
+        $column = collect($this->columnService->columns($tenant))
+            ->firstWhere('sort_param', $sortBy);
+        if ($column === null) {
+            return $tickets;
+        }
+
+        $direction = ($filters['sort_direction'] ?? 'asc') === 'desc' ? -1 : 1;
+        $values = $tickets->mapWithKeys(fn (Ticket $ticket): array => [
+            $ticket->getKey() => $this->rowService->values($ticket)[$column['key']] ?? null,
+        ]);
+
+        return $tickets->sort(function (Ticket $left, Ticket $right) use ($column, $direction, $values): int {
+            $leftValue = $values->get($left->getKey());
+            $rightValue = $values->get($right->getKey());
+
+            if ($leftValue === null || $leftValue === '') {
+                return $rightValue === null || $rightValue === '' ? $right->id <=> $left->id : 1;
+            }
+            if ($rightValue === null || $rightValue === '') {
+                return -1;
+            }
+
+            $comparison = $this->compareValues($leftValue, $rightValue, $column['type']);
+
+            return $comparison === 0
+                ? $right->id <=> $left->id
+                : $comparison * $direction;
+        })->values();
+    }
+
+    private function compareValues(mixed $left, mixed $right, string $type): int
+    {
+        if (in_array($type, ['currency', 'order_number'], true)) {
+            return (float) $left <=> (float) $right;
+        }
+
+        if ($type === 'date') {
+            $leftTimestamp = $left instanceof \DateTimeInterface ? $left->getTimestamp() : strtotime((string) $left);
+            $rightTimestamp = $right instanceof \DateTimeInterface ? $right->getTimestamp() : strtotime((string) $right);
+
+            return $leftTimestamp <=> $rightTimestamp;
+        }
+
+        if ($type === 'status') {
+            $left = $this->rowService->displayValue($left, $type, 'UTC');
+            $right = $this->rowService->displayValue($right, $type, 'UTC');
+        }
+
+        return strnatcasecmp((string) $left, (string) $right);
+    }
+
+    /**
+     * @param  Collection<int, Ticket>  $tickets
+     * @param  array{page?: int, per_page?: int}  $filters
+     * @return LengthAwarePaginator<Ticket>
+     */
+    private function paginate(Collection $tickets, array $filters): LengthAwarePaginator
+    {
+        $page = (int) ($filters['page'] ?? 1);
+        $perPage = (int) ($filters['per_page'] ?? 15);
+
+        return (new LengthAwarePaginator(
+            $tickets->forPage($page, $perPage)->values(),
+            $tickets->count(),
+            $perPage,
+            $page,
+            ['path' => request()->url()],
+        ))->withQueryString();
+    }
+}

app/Domains/Ticket/documentacion/README.md

@@ -30,6 +30,12 @@ Bajo `/tenants/{tenant:codigo}`, protegidos por `auth:sanctum`:
 - `GET /tickets`.
 - `POST /tickets/pdf`.
 
+Bajo `/v1/adminapp/tenant`, protegido por `auth:sanctum`, `adminapp.tenant` y el menú
+`adminapp.tickets`:
+
+- `GET /tickets`, paginado y con búsqueda opcional mediante `q`. La respuesta incluye
+  `scanned_tickets` y `total_tickets` para el tenant autenticado.
+
 `TicketPdfService` genera la descarga y `TicketResource`/`ValidityTimeResource` definen las respuestas.
 
 ## Dependencias y reglas

app/Domains/Ticket/routes/adminapp.php

@@ -0,0 +1,18 @@
+<?php
+
+use App\Domains\Ticket\Controllers\AdminApp\TicketController;
+use Illuminate\Support\Facades\Route;
+
+Route::prefix('v1/adminapp/tenant')
+    ->middleware(['auth:sanctum', 'adminapp.tenant'])
+    ->group(function (): void {
+        Route::get('tickets', [TicketController::class, 'index'])
+            ->middleware('tenant.menu:adminapp.tickets')
+            ->name('adminapp.tickets.index');
+        Route::get('tickets/pdf', [TicketController::class, 'downloadPdf'])
+            ->middleware('tenant.menu:adminapp.tickets')
+            ->name('adminapp.tickets.pdf');
+        Route::get('tickets/excel', [TicketController::class, 'downloadExcel'])
+            ->middleware('tenant.menu:adminapp.tickets')
+            ->name('adminapp.tickets.excel');
+    });

app/Domains/Ticket/routes/api.php

@@ -11,3 +11,4 @@ Route::prefix('tenants/{tenant:codigo}')
     });
 
 require __DIR__.'/scanner.php';
+require __DIR__.'/adminapp.php';

config/purchase.php

@@ -2,4 +2,15 @@
 
 return [
     'checkout_expiration_minutes' => (int) env('PURCHASE_CHECKOUT_EXPIRATION_MINUTES', 30),
+
+    'payment_expiration_minutes' => [
+        'qr' => (int) env('PURCHASE_QR_EXPIRATION_MINUTES', 15),
+        'telepagos' => (int) env('PURCHASE_TELEPAGOS_EXPIRATION_MINUTES', 30),
+        'transfer' => (int) env('PURCHASE_TRANSFER_EXPIRATION_MINUTES', 1440),
+    ],
+
+    'transfer_candidate_amount_tolerance_percentage' => (float) env(
+        'PURCHASE_TRANSFER_CANDIDATE_AMOUNT_TOLERANCE_PERCENTAGE',
+        5,
+    ),
 ];

database/migrations/2026_08_27_000000_create_telepagos_payment_candidates_table.php

@@ -0,0 +1,141 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    public function up(): void
+    {
+        Schema::create('telepagos_payment_candidates', function (Blueprint $table) {
+            $table->id();
+            $table->foreignId('telepagos_payment_id')
+                ->constrained('telepagos_payments')
+                ->cascadeOnDelete();
+            $table->foreignId('compra_id')->constrained('compras')->cascadeOnDelete();
+            $table->boolean('dni_matches');
+            $table->boolean('amount_matches');
+            $table->decimal('payment_amount', 10, 2);
+            $table->decimal('purchase_amount', 10, 2);
+            $table->decimal('amount_difference', 10, 2);
+            $table->string('match_reason');
+            $table->string('confidence');
+            $table->timestamps();
+
+            $table->unique(
+                ['telepagos_payment_id', 'compra_id'],
+                'telepagos_payment_candidate_unique',
+            );
+        });
+
+        $this->migrateExistingCandidates();
+
+        Schema::table('telepagos_payments', function (Blueprint $table) {
+            $table->dropColumn('matched_purchase_ids');
+        });
+    }
+
+    public function down(): void
+    {
+        Schema::table('telepagos_payments', function (Blueprint $table) {
+            $table->json('matched_purchase_ids')->nullable()->after('compra_id');
+        });
+
+        DB::table('telepagos_payments')
+            ->whereNull('compra_id')
+            ->orderBy('id')
+            ->each(function (object $payment): void {
+                $candidateIds = DB::table('telepagos_payment_candidates')
+                    ->where('telepagos_payment_id', $payment->id)
+                    ->pluck('compra_id')
+                    ->all();
+
+                if ($candidateIds !== []) {
+                    DB::table('telepagos_payments')
+                        ->where('id', $payment->id)
+                        ->update(['matched_purchase_ids' => json_encode($candidateIds)]);
+                }
+            });
+
+        Schema::dropIfExists('telepagos_payment_candidates');
+    }
+
+    private function migrateExistingCandidates(): void
+    {
+        DB::table('telepagos_payments')
+            ->whereNull('compra_id')
+            ->whereNotNull('matched_purchase_ids')
+            ->orderBy('id')
+            ->each(function (object $payment): void {
+                $candidateIds = json_decode((string) $payment->matched_purchase_ids, true);
+
+                if (! is_array($candidateIds)) {
+                    return;
+                }
+
+                $paymentAmount = number_format((float) $payment->amount, 2, '.', '');
+                $payerDni = $payment->cuit_buyer
+                    ? substr((string) $payment->cuit_buyer, 2, -1)
+                    : null;
+
+                foreach ($candidateIds as $candidateId) {
+                    $purchase = DB::table('compras')->find($candidateId);
+
+                    if ($purchase === null) {
+                        continue;
+                    }
+
+                    $purchaseAmount = number_format((float) $purchase->total, 2, '.', '');
+                    $dniMatches = $payerDni !== null && $purchase->transfer_payer_dni === $payerDni;
+                    $amountMatches = $purchaseAmount === $paymentAmount;
+
+                    DB::table('telepagos_payment_candidates')->insertOrIgnore([
+                        'telepagos_payment_id' => $payment->id,
+                        'compra_id' => $purchase->id,
+                        'dni_matches' => $dniMatches,
+                        'amount_matches' => $amountMatches,
+                        'payment_amount' => $paymentAmount,
+                        'purchase_amount' => $purchaseAmount,
+                        'amount_difference' => number_format(
+                            abs((float) $purchaseAmount - (float) $paymentAmount),
+                            2,
+                            '.',
+                            '',
+                        ),
+                        'match_reason' => $this->matchReason($dniMatches, $amountMatches),
+                        'confidence' => $this->confidence($dniMatches, $amountMatches),
+                        'created_at' => $payment->created_at,
+                        'updated_at' => $payment->updated_at,
+                    ]);
+                }
+            });
+    }
+
+    private function matchReason(bool $dniMatches, bool $amountMatches): string
+    {
+        if ($dniMatches && $amountMatches) {
+            return 'ambiguous_exact_match';
+        }
+
+        if ($dniMatches) {
+            return 'exact_dni_near_amount';
+        }
+
+        if ($amountMatches) {
+            return 'exact_amount_different_dni';
+        }
+
+        return 'legacy_candidate';
+    }
+
+    private function confidence(bool $dniMatches, bool $amountMatches): string
+    {
+        if ($dniMatches && $amountMatches) {
+            return 'exact';
+        }
+
+        return $dniMatches ? 'high' : 'medium';
+    }
+};

database/migrations/2026_08_27_010000_add_dni_distance_to_telepagos_payment_candidates.php

@@ -0,0 +1,61 @@
+<?php
+
+use App\Domains\Purchase\Services\DniDistanceService;
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+    public function up(): void
+    {
+        Schema::table('telepagos_payment_candidates', function (Blueprint $table) {
+            $table->unsignedTinyInteger('dni_distance')->nullable()->after('dni_matches');
+            $table->string('payment_dni', 8)->nullable()->after('dni_distance');
+            $table->string('purchase_dni', 8)->nullable()->after('payment_dni');
+        });
+
+        $dniDistance = new DniDistanceService;
+
+        DB::table('telepagos_payment_candidates as candidate')
+            ->join('telepagos_payments as payment', 'payment.id', '=', 'candidate.telepagos_payment_id')
+            ->join('compras as purchase', 'purchase.id', '=', 'candidate.compra_id')
+            ->select([
+                'candidate.id',
+                'candidate.match_reason',
+                'payment.cuit_buyer',
+                'purchase.transfer_payer_dni',
+            ])
+            ->orderBy('candidate.id')
+            ->each(function (object $candidate) use ($dniDistance): void {
+                if ($candidate->cuit_buyer === null || $candidate->transfer_payer_dni === null) {
+                    return;
+                }
+
+                $payerDni = substr((string) $candidate->cuit_buyer, 2, -1);
+                $distance = $dniDistance->distance($payerDni, (string) $candidate->transfer_payer_dni);
+
+                if ($candidate->match_reason === 'exact_amount_different_dni' && $distance > 2) {
+                    DB::table('telepagos_payment_candidates')->where('id', $candidate->id)->delete();
+
+                    return;
+                }
+
+                DB::table('telepagos_payment_candidates')
+                    ->where('id', $candidate->id)
+                    ->update([
+                        'dni_distance' => $distance,
+                        'payment_dni' => $payerDni,
+                        'purchase_dni' => $candidate->transfer_payer_dni,
+                    ]);
+            });
+    }
+
+    public function down(): void
+    {
+        Schema::table('telepagos_payment_candidates', function (Blueprint $table) {
+            $table->dropColumn(['dni_distance', 'payment_dni', 'purchase_dni']);
+        });
+    }
+};

database/migrations/2026_08_27_020000_rename_near_dni_candidate_reason.php

@@ -0,0 +1,21 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Support\Facades\DB;
+
+return new class extends Migration
+{
+    public function up(): void
+    {
+        DB::table('telepagos_payment_candidates')
+            ->where('match_reason', 'exact_amount_different_dni')
+            ->update(['match_reason' => 'exact_amount_near_dni']);
+    }
+
+    public function down(): void
+    {
+        DB::table('telepagos_payment_candidates')
+            ->where('match_reason', 'exact_amount_near_dni')
+            ->update(['match_reason' => 'exact_amount_different_dni']);
+    }
+};

database/migrations/2026_08_28_000000_add_fiesta_futbol_infantil_tickets_adminapp_menu.php

@@ -0,0 +1,82 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Support\Facades\DB;
+
+return new class extends Migration
+{
+    private const MENU_CODE = 'adminapp.tickets';
+
+    private const TENANT_CODE = 'fiesta_futbol_infantil';
+
+    public function up(): void
+    {
+        if (! DB::table('menues')->where('code', 'main.adminapp')->exists()) {
+            // Reference data is added by seeders on fresh installations.
+            return;
+        }
+
+        $now = now();
+
+        DB::transaction(function () use ($now): void {
+            DB::table('menues')->updateOrInsert(
+                ['code' => self::MENU_CODE],
+                [
+                    'label' => 'Tickets',
+                    'parent_menu_code' => 'main.adminapp',
+                    'content_type' => 'dynamic',
+                    'static_content_schema' => null,
+                    'route' => '/admin/tickets',
+                    'created_at' => $now,
+                    'updated_at' => $now,
+                ],
+            );
+
+            DB::table('tenants_menues')
+                ->where('menu_code', self::MENU_CODE)
+                ->where('tenant_code', '!=', self::TENANT_CODE)
+                ->delete();
+
+            if (DB::table('tenants')->where('codigo', self::TENANT_CODE)->exists()) {
+                DB::table('tenants_menues')->updateOrInsert(
+                    [
+                        'tenant_code' => self::TENANT_CODE,
+                        'menu_code' => self::MENU_CODE,
+                    ],
+                    [
+                        'static_content' => null,
+                        'created_at' => $now,
+                        'updated_at' => $now,
+                    ],
+                );
+            }
+
+            DB::table('roles')
+                ->whereIn('codigo', ['admin', 'adminapp'])
+                ->pluck('codigo')
+                ->each(function (string $roleCode): void {
+                    DB::table('roles_menues')->updateOrInsert([
+                        'rol_codigo' => $roleCode,
+                        'menu_codigo' => self::MENU_CODE,
+                    ]);
+                });
+        });
+    }
+
+    public function down(): void
+    {
+        DB::transaction(function (): void {
+            DB::table('tenants_menues')
+                ->where('menu_code', self::MENU_CODE)
+                ->delete();
+
+            DB::table('roles_menues')
+                ->where('menu_codigo', self::MENU_CODE)
+                ->delete();
+
+            DB::table('menues')
+                ->where('code', self::MENU_CODE)
+                ->delete();
+        });
+    }
+};

database/seeders/MenuSeeder.php

@@ -78,6 +78,12 @@ class MenuSeeder extends Seeder
                 'parent_menu_code' => 'main.adminapp',
                 'route' => '/admin/staff',
             ],
+            [
+                'code' => 'adminapp.tickets',
+                'label' => 'Tickets',
+                'parent_menu_code' => 'main.adminapp',
+                'route' => '/admin/tickets',
+            ],
             [
                 'code' => 'adminapp.fiesta-futbol-infantil.entradas',
                 'label' => 'Entradas',
@@ -270,6 +276,7 @@ class MenuSeeder extends Seeder
             'fiesta_futbol_infantil',
         ];
         $fiestaCategoryMenuCodes = [
+            'adminapp.tickets',
             'adminapp.fiesta-futbol-infantil.entradas',
             'adminapp.fiesta-futbol-infantil.alojamientos',
             'adminapp.fiesta-futbol-infantil.merchandising',

phpunit.xml

@@ -18,7 +18,8 @@
         </include>
     </source>
     <php>
-        <env name="APP_ENV" value="testing"/>
+        <env name="APP_ENV" value="testing" force="true"/>
+        <env name="DB_DATABASE" value="shopit_test" force="true"/>
         <env name="APP_MAINTENANCE_DRIVER" value="file"/>
         <env name="APP_CONFIG_CACHE" value="bootstrap/cache/phpunit-config.php"/>
         <env name="APP_EVENTS_CACHE" value="bootstrap/cache/phpunit-events.php"/>

resources/views/pdf/adminapp/tickets.blade.php

@@ -0,0 +1,60 @@
+<!doctype html>
+<html lang="es">
+<head>
+    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
+    <style>
+        @page { margin: 28px 34px 58px; }
+        body { color: #17211b; font-family: DejaVu Sans, sans-serif; font-size: 8px; margin: 0; }
+        h1 { font-size: 21px; margin: 0 0 3px; }
+        .subtitle { color: #66736b; margin: 0 0 15px; }
+        .summary { background: #eef5f1; border-left: 4px solid #198754; margin-bottom: 14px; padding: 8px 11px; }
+        .summary strong { font-size: 12px; }
+        table { border-collapse: collapse; table-layout: fixed; width: 100%; }
+        thead { display: table-header-group; }
+        tr { page-break-inside: avoid; }
+        th { background: #26382e; color: #fff; font-size: 7px; letter-spacing: .25px; padding: 6px 5px; text-align: left; text-transform: uppercase; }
+        td { border-bottom: 1px solid #dfe7e2; overflow-wrap: break-word; padding: 6px 5px; vertical-align: top; }
+        tbody tr:nth-child(even) { background: #f7f9f8; }
+        .number { text-align: right; }
+        .ticket-id { font-size: 6.8px; word-break: break-all; }
+        .empty { color: #66736b; padding: 24px; text-align: center; }
+    </style>
+</head>
+<body>
+    <h1>Listado de tickets</h1>
+    <p class="subtitle">{{ $tenant->nombre }} · Generado el {{ $generatedAt->copy()->timezone($timeZone)->format('d/m/Y H:i') }}</p>
+
+    <div class="summary">
+        Tickets incluidos: <strong>{{ $tickets->count() }}</strong>
+        &nbsp;&nbsp;·&nbsp;&nbsp;
+        Escaneados: <strong>{{ $tickets->where('status', 'Usado')->count() }}</strong>
+    </div>
+
+    <table>
+        <thead>
+            <tr>
+                @foreach ($columns as $column)
+                    <th
+                        style="width: {{ $column['width'] }}"
+                        @class(['number' => $column['type'] === 'currency'])
+                    >{{ $column['label'] }}</th>
+                @endforeach
+            </tr>
+        </thead>
+        <tbody>
+            @forelse ($tickets as $ticket)
+                <tr>
+                    @foreach ($columns as $column)
+                        <td @class([
+                            'number' => $column['type'] === 'currency',
+                            'ticket-id' => $column['key'] === 'ticket',
+                        ])>{{ $ticket[$column['key']] }}</td>
+                    @endforeach
+                </tr>
+            @empty
+                <tr><td class="empty" colspan="{{ count($columns) }}">No hay tickets para los criterios seleccionados.</td></tr>
+            @endforelse
+        </tbody>
+    </table>
+</body>
+</html>

tests/Feature/Forms/AdminAppTicketFilterFormControllerTest.php

@@ -0,0 +1,309 @@
+<?php
+
+namespace Tests\Feature\Forms;
+
+use App\Domains\Attachable\Enums\AttachmentType;
+use App\Domains\Attachable\Models\Attachment;
+use App\Domains\Auth\Models\User;
+use App\Domains\Authorization\Enums\RoleCode;
+use App\Domains\Catalog\Models\CatalogItem;
+use App\Domains\Catalog\Services\CatalogService;
+use App\Domains\Menu\Models\Menu;
+use App\Domains\Tenant\Models\Tenant;
+use App\Domains\Ticket\Models\Ticket;
+use Database\Seeders\AttributeSeeder;
+use Database\Seeders\AuthorizationSeeder;
+use Database\Seeders\FiestaFutbolInfantilProductSeeder;
+use Illuminate\Foundation\Testing\RefreshDatabase;
+use Illuminate\Support\Str;
+use Laravel\Sanctum\Sanctum;
+use Tests\TestCase;
+
+class AdminAppTicketFilterFormControllerTest extends TestCase
+{
+    use RefreshDatabase;
+
+    protected function setUp(): void
+    {
+        parent::setUp();
+
+        $this->seed(AuthorizationSeeder::class);
+    }
+
+    public function test_authentication_is_required(): void
+    {
+        $this->getJson('/api/v1/adminapp/forms/tickets-filter')->assertUnauthorized();
+    }
+
+    public function test_the_tenant_must_have_the_tickets_menu(): void
+    {
+        $tenant = $this->createTenant('tenant_without_tickets');
+        Sanctum::actingAs($this->createAdminAppUser($tenant));
+
+        $this->getJson('/api/v1/adminapp/forms/tickets-filter')->assertNotFound();
+    }
+
+    public function test_it_returns_the_common_ticket_filter_fields_for_other_tenants(): void
+    {
+        $tenant = $this->createTenant('another_tenant');
+        $this->grantTicketsMenu($tenant);
+        Sanctum::actingAs($this->createAdminAppUser($tenant));
+
+        $this->getJson('/api/v1/adminapp/forms/tickets-filter')
+            ->assertOk()
+            ->assertExactJson([
+                'data' => [
+                    'code' => 'tickets_filter',
+                    'action' => '/api/v1/adminapp/tenant/tickets',
+                    'method' => 'GET',
+                    'columns' => $this->commonColumns(),
+                    'fields' => [
+                        [
+                            'name' => 'date',
+                            'query_param' => 'date',
+                            'label' => 'Fecha',
+                            'type' => 'date',
+                            'required' => false,
+                            'default' => null,
+                        ],
+                        [
+                            'name' => 'status',
+                            'query_param' => 'status',
+                            'label' => 'Estado',
+                            'type' => 'select',
+                            'required' => false,
+                            'default' => null,
+                            'placeholder' => 'Estado',
+                            'options' => [
+                                ['value' => 'active', 'label' => 'Activo'],
+                                ['value' => 'used', 'label' => 'Usado'],
+                                ['value' => 'expired', 'label' => 'Vencido'],
+                            ],
+                        ],
+                    ],
+                ],
+            ]);
+    }
+
+    public function test_it_returns_the_complete_nested_form_for_fiesta_futbol_infantil(): void
+    {
+        $tenant = $this->createFiestaFutbolInfantilTenant();
+        $this->grantTicketsMenu($tenant);
+        $admin = $this->createAdminAppUser($tenant);
+        Sanctum::actingAs($admin);
+
+        $response = $this->getJson('/api/v1/adminapp/forms/tickets-filter')
+            ->assertOk()
+            ->assertJsonPath('data.fields.0.name', 'category')
+            ->assertJsonPath('data.fields.0.query_param', 'category')
+            ->assertJsonPath('data.fields.1.name', 'product')
+            ->assertJsonPath('data.fields.1.query_param', 'product')
+            ->assertJsonPath('data.fields.1.depends_on', 'category')
+            ->assertJsonPath('data.fields.2.name', 'type')
+            ->assertJsonPath('data.fields.2.query_param', 'type')
+            ->assertJsonPath('data.fields.2.depends_on', 'product')
+            ->assertJsonPath('data.fields.3.name', 'date')
+            ->assertJsonPath('data.fields.3.query_param', 'date')
+            ->assertJsonPath('data.fields.4.name', 'status')
+            ->assertJsonPath('data.fields.4.query_param', 'status')
+            ->assertJsonPath('data.columns.0.key', 'order_number')
+            ->assertJsonPath('data.columns.0.sort_param', 'order_number')
+            ->assertJsonPath('data.columns.1.key', 'category')
+            ->assertJsonPath('data.columns.2.key', 'product')
+            ->assertJsonPath('data.columns.2.sortable', false)
+            ->assertJsonPath('data.columns.3.key', 'type')
+            ->assertJsonPath('data.columns.3.sortable', false);
+
+        $categories = collect($response->json('data.fields.0.options'));
+        $this->assertSame(
+            ['Entradas', 'Camping', 'Comida', 'Merchandising'],
+            $categories->pluck('label')->all(),
+        );
+
+        $entries = $categories->firstWhere('value', 'entradas');
+        $this->assertSame('Abono', $entries['children']['options'][0]['label']);
+        $this->assertTrue($entries['children']['options'][0]['children']['disabled']);
+
+        $camping = $categories->firstWhere('value', 'alojamientos');
+        $this->assertSame(
+            ['Carpa', 'Motorhome'],
+            collect($camping['children']['options'])->pluck('label')->all(),
+        );
+        $this->assertTrue($camping['children']['options'][0]['children']['disabled']);
+
+        $merchandise = $categories->firstWhere('value', 'merchandising');
+        $this->assertSame('Camiseta', $merchandise['children']['options'][0]['label']);
+        $this->assertSame(
+            ['Verde', 'Blanco'],
+            collect($merchandise['children']['options'][0]['children']['options'])->pluck('label')->all(),
+        );
+    }
+
+    public function test_a_food_schedule_is_only_returned_when_a_variant_exists_for_the_date(): void
+    {
+        $tenant = $this->createFiestaFutbolInfantilTenant();
+        $this->grantTicketsMenu($tenant);
+        Sanctum::actingAs($this->createAdminAppUser($tenant));
+
+        $date = $tenant->eventDates()->orderByDesc('date')->firstOrFail();
+        $food = CatalogItem::query()
+            ->where('tenant_code', $tenant->codigo)
+            ->where('slug', 'comida')
+            ->with([
+                'itemAttributes.attribute.options',
+                'variants.definitions.itemAttribute.attribute.options',
+                'variants.eventDates',
+                'variants.eventDate',
+            ])
+            ->firstOrFail();
+
+        $food->variants
+            ->filter(fn ($variant): bool => $variant->selectedEventDates()->contains('id', $date->id)
+                && $variant->selectionValues()->get('horario') === 'Almuerzo')
+            ->each->delete();
+
+        $response = $this->getJson('/api/v1/adminapp/forms/tickets-filter')->assertOk();
+        $foodCategory = collect($response->json('data.fields.0.options'))->firstWhere('value', 'comidas');
+        $dateProduct = collect($foodCategory['children']['options'])
+            ->firstWhere('value', (string) $date->id);
+        $schedules = collect($dateProduct['children']['options'])->pluck('value');
+
+        $this->assertNotContains('Almuerzo', $schedules);
+        $this->assertContains('Desayuno', $schedules);
+        $this->assertContains('Cena', $schedules);
+    }
+
+    public function test_a_deleted_food_variant_remains_in_the_filter_when_a_ticket_references_it(): void
+    {
+        $tenant = $this->createFiestaFutbolInfantilTenant();
+        $this->grantTicketsMenu($tenant);
+        $admin = $this->createAdminAppUser($tenant);
+        Sanctum::actingAs($admin);
+
+        $food = CatalogItem::query()
+            ->where('tenant_code', $tenant->codigo)
+            ->where('slug', 'comida')
+            ->with([
+                'itemAttributes.attribute.options',
+                'variants.definitions.itemAttribute.attribute.options',
+                'variants.eventDates',
+                'variants.eventDate',
+            ])
+            ->firstOrFail();
+        $historicalVariant = $food->variants->first(function ($variant): bool {
+            return $variant->selectedEventDates()->first()?->date->format('d/m') === '12/10'
+                && $variant->selectionValues()->get('horario') === 'Cena';
+        });
+        $this->assertNotNull($historicalVariant);
+
+        $ticket = Ticket::query()->create([
+            'tenant_code' => $tenant->codigo,
+            'ticket' => (string) Str::uuid(),
+            'user_id' => $admin->id,
+            'source_catalog_item_id' => $food->id,
+            'source_variant_id' => $historicalVariant->id,
+        ]);
+
+        $catalogService = app(CatalogService::class);
+        foreach ($food->variants as $variant) {
+            $catalogService->deleteVariant($variant);
+        }
+
+        $this->assertTrue(CatalogItem::withTrashed()->findOrFail($food->id)->trashed());
+
+        $response = $this->getJson('/api/v1/adminapp/forms/tickets-filter')->assertOk();
+        $foodCategory = collect($response->json('data.fields.0.options'))->firstWhere('value', 'comidas');
+        $products = collect($foodCategory['children']['options']);
+
+        $this->assertCount(1, $products);
+        $this->assertSame('12/10', $products->first()['label']);
+        $this->assertSame(
+            ['Cena'],
+            collect($products->first()['children']['options'])->pluck('label')->all(),
+        );
+
+        $this->getJson('/api/v1/adminapp/tenant/tickets?'.http_build_query([
+            'category' => 'comidas',
+            'product' => $products->first()['value'],
+            'type' => 'Cena',
+        ]))
+            ->assertOk()
+            ->assertJsonCount(1, 'data')
+            ->assertJsonPath('data.0.id', $ticket->id)
+            ->assertJsonPath('data.0.values.category', 'Comida')
+            ->assertJsonPath('data.0.values.product', '12/10')
+            ->assertJsonPath('data.0.values.type', 'Cena');
+    }
+
+    private function createFiestaFutbolInfantilTenant(): Tenant
+    {
+        $tenant = $this->createTenant('fiesta_futbol_infantil');
+        $this->seed([AttributeSeeder::class, FiestaFutbolInfantilProductSeeder::class]);
+
+        return $tenant->refresh();
+    }
+
+    /** @return list<array<string, mixed>> */
+    private function commonColumns(): array
+    {
+        return [
+            ['key' => 'order_number', 'label' => 'N° de orden', 'type' => 'order_number', 'sortable' => true, 'sort_param' => 'order_number', 'width' => '11%'],
+            ['key' => 'product', 'label' => 'Producto', 'type' => 'text', 'sortable' => true, 'sort_param' => 'product', 'width' => '15%'],
+            ['key' => 'amount', 'label' => 'Importe', 'type' => 'currency', 'sortable' => true, 'sort_param' => 'amount', 'width' => '10%'],
+            ['key' => 'client', 'label' => 'Cliente', 'type' => 'text', 'sortable' => true, 'sort_param' => 'client', 'width' => '15%'],
+            ['key' => 'ticket', 'label' => 'ID', 'type' => 'text', 'sortable' => true, 'sort_param' => 'ticket', 'width' => '19%'],
+            ['key' => 'date', 'label' => 'Fecha', 'type' => 'date', 'sortable' => true, 'sort_param' => 'date', 'width' => '11%'],
+            ['key' => 'status', 'label' => 'Estado', 'type' => 'status', 'sortable' => true, 'sort_param' => 'status', 'width' => '8%'],
+            ['key' => 'scanned_by', 'label' => 'Escaneado por', 'type' => 'text', 'sortable' => true, 'sort_param' => 'scanned_by', 'width' => '11%'],
+        ];
+    }
+
+    private function createTenant(string $code): Tenant
+    {
+        $headerLogo = $this->createAttachment("{$code}-header.png");
+        $footerLogo = $this->createAttachment("{$code}-footer.png");
+
+        return Tenant::query()->create([
+            'codigo' => $code,
+            'nombre' => ucfirst($code),
+            'dominio' => "{$code}.test",
+            'primary_color' => '#111111',
+            'secondary_color' => '#222222',
+            'danger_color' => '#333333',
+            'success_color' => '#444444',
+            'header_bg_color' => '#ffffff',
+            'footer_bg_color' => '#ffffff',
+            'header_logo_id' => $headerLogo->id,
+            'footer_logo_id' => $footerLogo->id,
+        ]);
+    }
+
+    private function createAttachment(string $filename): Attachment
+    {
+        return Attachment::query()->create([
+            'path' => "tests/{$filename}",
+            'filename' => $filename,
+            'type' => AttachmentType::Image,
+            'mime_type' => 'image/png',
+        ]);
+    }
+
+    private function createAdminAppUser(Tenant $tenant): User
+    {
+        return User::factory()->create([
+            'rol_codigo' => RoleCode::AdminApp->value,
+            'tenant_codigo' => $tenant->codigo,
+        ]);
+    }
+
+    private function grantTicketsMenu(Tenant $tenant): void
+    {
+        $menu = Menu::query()->create([
+            'code' => 'adminapp.tickets',
+            'label' => 'Tickets',
+            'route' => '/admin/tickets',
+        ]);
+
+        $tenant->menues()->attach($menu->code);
+    }
+}

tests/Feature/Forms/AdminAppTicketFormControllerTest.php

@@ -0,0 +1,155 @@
+<?php
+
+namespace Tests\Feature\Forms;
+
+use App\Domains\Attachable\Enums\AttachmentType;
+use App\Domains\Attachable\Models\Attachment;
+use App\Domains\Auth\Models\User;
+use App\Domains\Authorization\Enums\RoleCode;
+use App\Domains\Tenant\Models\Tenant;
+use Database\Seeders\AttributeSeeder;
+use Database\Seeders\AuthorizationSeeder;
+use Database\Seeders\FiestaFutbolInfantilProductSeeder;
+use Illuminate\Foundation\Testing\RefreshDatabase;
+use Laravel\Sanctum\Sanctum;
+use Tests\TestCase;
+
+class AdminAppTicketFormControllerTest extends TestCase
+{
+    use RefreshDatabase;
+
+    protected function setUp(): void
+    {
+        parent::setUp();
+
+        $this->seed(AuthorizationSeeder::class);
+    }
+
+    public function test_authentication_is_required(): void
+    {
+        $this->getJson('/api/v1/adminapp/forms/fiesta-futbol-infantil/ticket')
+            ->assertUnauthorized();
+    }
+
+    public function test_it_returns_nested_ticket_options_using_the_frontend_presentation_mapping(): void
+    {
+        $headerLogo = $this->createAttachment('header.png');
+        $footerLogo = $this->createAttachment('footer.png');
+        $tenant = Tenant::query()->create([
+            'codigo' => 'fiesta_futbol_infantil',
+            'nombre' => 'Fiesta Fútbol Infantil',
+            'dominio' => 'fiesta-futbol-infantil.test',
+            'primary_color' => '#00973F',
+            'secondary_color' => '#A0A0A0',
+            'danger_color' => '#FF8888',
+            'success_color' => '#198754',
+            'header_bg_color' => '#ffffff',
+            'footer_bg_color' => '#015327',
+            'header_logo_id' => $headerLogo->id,
+            'footer_logo_id' => $footerLogo->id,
+        ]);
+        $this->seed([AttributeSeeder::class, FiestaFutbolInfantilProductSeeder::class]);
+
+        Sanctum::actingAs(User::factory()->create([
+            'rol_codigo' => RoleCode::AdminApp->value,
+            'tenant_codigo' => $tenant->codigo,
+        ]));
+
+        $response = $this->getJson('/api/v1/adminapp/forms/fiesta-futbol-infantil/ticket')
+            ->assertOk()
+            ->assertExactJson([
+                'data' => [
+                    'statuses' => [
+                        ['value' => 'active', 'label' => 'Activo'],
+                        ['value' => 'used', 'label' => 'Usado'],
+                        ['value' => 'expired', 'label' => 'Vencido'],
+                    ],
+                    'categories' => [
+                        [
+                            'value' => 'entradas',
+                            'label' => 'Entradas',
+                            'products' => [[
+                                'value' => 'abono',
+                                'label' => 'Abono',
+                                'types' => [],
+                            ]],
+                        ],
+                        [
+                            'value' => 'alojamientos',
+                            'label' => 'Camping',
+                            'products' => [
+                                ['value' => 'Carpa', 'label' => 'Carpa', 'types' => []],
+                                ['value' => 'Motorhome', 'label' => 'Motorhome', 'types' => []],
+                            ],
+                        ],
+                        [
+                            'value' => 'comidas',
+                            'label' => 'Comida',
+                            'products' => [
+                                [
+                                    'value' => (string) $tenant->eventDates[0]->id,
+                                    'label' => '09/10',
+                                    'types' => [
+                                        ['value' => 'Desayuno', 'label' => 'Desayuno'],
+                                        ['value' => 'Almuerzo', 'label' => 'Almuerzo'],
+                                        ['value' => 'Cena', 'label' => 'Cena'],
+                                    ],
+                                ],
+                                [
+                                    'value' => (string) $tenant->eventDates[1]->id,
+                                    'label' => '10/10',
+                                    'types' => [
+                                        ['value' => 'Desayuno', 'label' => 'Desayuno'],
+                                        ['value' => 'Almuerzo', 'label' => 'Almuerzo'],
+                                        ['value' => 'Cena', 'label' => 'Cena'],
+                                    ],
+                                ],
+                                [
+                                    'value' => (string) $tenant->eventDates[2]->id,
+                                    'label' => '11/10',
+                                    'types' => [
+                                        ['value' => 'Desayuno', 'label' => 'Desayuno'],
+                                        ['value' => 'Almuerzo', 'label' => 'Almuerzo'],
+                                        ['value' => 'Cena', 'label' => 'Cena'],
+                                    ],
+                                ],
+                                [
+                                    'value' => (string) $tenant->eventDates[3]->id,
+                                    'label' => '12/10',
+                                    'types' => [
+                                        ['value' => 'Desayuno', 'label' => 'Desayuno'],
+                                        ['value' => 'Almuerzo', 'label' => 'Almuerzo'],
+                                        ['value' => 'Cena', 'label' => 'Cena'],
+                                    ],
+                                ],
+                            ],
+                        ],
+                        [
+                            'value' => 'merchandising',
+                            'label' => 'Merchandising',
+                            'products' => [[
+                                'value' => 'camiseta',
+                                'label' => 'Camiseta',
+                                'types' => [
+                                    ['value' => 'Verde', 'label' => 'Verde'],
+                                    ['value' => 'Blanco', 'label' => 'Blanco'],
+                                ],
+                            ]],
+                        ],
+                    ],
+                ],
+            ]);
+
+        $response->assertJsonMissingPath('data.categories.0.products.0.category');
+    }
+
+    private function createAttachment(string $filename): Attachment
+    {
+        return Attachment::query()->create([
+            'path' => "tests/{$filename}",
+            'filename' => $filename,
+            'type' => AttachmentType::Image,
+            'mime_type' => 'image/png',
+        ]);
+    }
+}

tests/Feature/Integration/TelepagosWebhookTest.php

@@ -341,8 +341,9 @@ class TelepagosWebhookTest extends TestCase
             ->firstOrFail();
         $this->assertEqualsCanonicalizing(
             [$firstPurchase->id, $secondPurchase->id, $thirdPurchase->id],
-            $payment->matched_purchase_ids,
+            $payment->candidates()->pluck('compra_id')->all(),
         );
+        $this->assertSame(3, $payment->candidates()->where('match_reason', 'ambiguous_exact_match')->count());
         $this->assertDatabaseHas('compras', [
             'id' => $firstPurchase->id,
             'status' => Purchase::STATUS_PENDING_PAYMENT,
@@ -357,6 +358,183 @@ class TelepagosWebhookTest extends TestCase
         ]);
     }
 
+    public function test_transfer_webhook_records_near_amount_only_with_exact_dni_or_exact_amount_with_different_dni(): void
+    {
+        config(['purchase.transfer_candidate_amount_tolerance_percentage' => 5]);
+
+        $tenant = $this->createTenant('candidates', 'Candidates', 'candidates.com.ar');
+        $this->configureTelepagosIntegration($tenant);
+
+        $nearAmountVariant = $this->createVariantForTenant('candidates', 10, '52.00', 'near');
+        $exactAmountVariant = $this->createVariantForTenant('candidates', 10, '50.00', 'exact');
+        $distanceTwoExactAmountVariant = $this->createVariantForTenant('candidates', 10, '50.00', 'distance-two');
+        $farExactAmountVariant = $this->createVariantForTenant('candidates', 10, '50.00', 'far-exact');
+        $nearAmountDifferentDniVariant = $this->createVariantForTenant('candidates', 10, '51.00', 'near-other-dni');
+        $outsideRangeVariant = $this->createVariantForTenant('candidates', 10, '100.00', 'outside');
+
+        $nearAmountPurchase = $this->createPendingTransferPurchase(
+            $tenant,
+            User::factory()->create()->id,
+            $nearAmountVariant->id,
+            1,
+            '12345678',
+        );
+        $exactAmountDifferentDniPurchase = $this->createPendingTransferPurchase(
+            $tenant,
+            User::factory()->create()->id,
+            $exactAmountVariant->id,
+            1,
+            '12345687',
+        );
+        $farExactAmountDifferentDniPurchase = $this->createPendingTransferPurchase(
+            $tenant,
+            User::factory()->create()->id,
+            $farExactAmountVariant->id,
+            1,
+            '87654321',
+        );
+        $distanceTwoExactAmountPurchase = $this->createPendingTransferPurchase(
+            $tenant,
+            User::factory()->create()->id,
+            $distanceTwoExactAmountVariant->id,
+            1,
+            '12345087',
+        );
+        $nearAmountDifferentDniPurchase = $this->createPendingTransferPurchase(
+            $tenant,
+            User::factory()->create()->id,
+            $nearAmountDifferentDniVariant->id,
+            1,
+            '87654321',
+        );
+        $outsideRangePurchase = $this->createPendingTransferPurchase(
+            $tenant,
+            User::factory()->create()->id,
+            $outsideRangeVariant->id,
+            1,
+            '12345678',
+        );
+
+        Http::fake([
+            'https://api.telepagos.com.ar/v2/auth/token' => Http::response([
+                'status' => 'ok',
+                'token' => 'test-token',
+                'expires_at' => now()->addHour()->toIso8601String(),
+            ]),
+            'https://api.telepagos.com.ar/v2/payment/cashin/candidates' => Http::response([
+                'status' => 'ok',
+                'data' => [
+                    'amount' => 50,
+                    'operation_id' => 1,
+                    'transaction_id' => 'tx-candidates',
+                    'buyer' => ['cuit' => '20123456789'],
+                ],
+            ]),
+        ]);
+
+        $this->postJson('/api/webhooks/telepagos/candidates', ['id' => 'candidates'])
+            ->assertOk()
+            ->assertJsonPath('status', 'success');
+
+        $payment = TelepagosPayment::query()
+            ->where('transaction_id', 'tx-candidates')
+            ->firstOrFail();
+
+        $this->assertNull($payment->compra_id);
+        $this->assertEqualsCanonicalizing([
+            $nearAmountPurchase->id,
+            $exactAmountDifferentDniPurchase->id,
+            $distanceTwoExactAmountPurchase->id,
+        ], $payment->candidates()->pluck('compra_id')->all());
+        $this->assertDatabaseHas('telepagos_payment_candidates', [
+            'telepagos_payment_id' => $payment->id,
+            'compra_id' => $nearAmountPurchase->id,
+            'dni_matches' => true,
+            'dni_distance' => 0,
+            'payment_dni' => '12345678',
+            'purchase_dni' => '12345678',
+            'amount_matches' => false,
+            'payment_amount' => 50,
+            'purchase_amount' => 52,
+            'amount_difference' => 2,
+            'match_reason' => 'exact_dni_near_amount',
+            'confidence' => 'high',
+        ]);
+        $this->assertDatabaseHas('telepagos_payment_candidates', [
+            'telepagos_payment_id' => $payment->id,
+            'compra_id' => $exactAmountDifferentDniPurchase->id,
+            'dni_matches' => false,
+            'dni_distance' => 1,
+            'payment_dni' => '12345678',
+            'purchase_dni' => '12345687',
+            'amount_matches' => true,
+            'payment_amount' => 50,
+            'purchase_amount' => 50,
+            'amount_difference' => 0,
+            'match_reason' => 'exact_amount_near_dni',
+            'confidence' => 'medium',
+        ]);
+        $this->assertDatabaseHas('telepagos_payment_candidates', [
+            'telepagos_payment_id' => $payment->id,
+            'compra_id' => $distanceTwoExactAmountPurchase->id,
+            'dni_matches' => false,
+            'dni_distance' => 2,
+            'payment_dni' => '12345678',
+            'purchase_dni' => '12345087',
+            'amount_matches' => true,
+            'match_reason' => 'exact_amount_near_dni',
+        ]);
+        $this->assertDatabaseMissing('telepagos_payment_candidates', [
+            'telepagos_payment_id' => $payment->id,
+            'compra_id' => $farExactAmountDifferentDniPurchase->id,
+        ]);
+        $this->assertDatabaseMissing('telepagos_payment_candidates', [
+            'telepagos_payment_id' => $payment->id,
+            'compra_id' => $nearAmountDifferentDniPurchase->id,
+        ]);
+        $this->assertDatabaseMissing('telepagos_payment_candidates', [
+            'telepagos_payment_id' => $payment->id,
+            'compra_id' => $outsideRangePurchase->id,
+        ]);
+        $this->assertSame(Purchase::STATUS_PENDING_PAYMENT, $nearAmountPurchase->fresh()->status);
+        $this->assertSame(Purchase::STATUS_PENDING_PAYMENT, $exactAmountDifferentDniPurchase->fresh()->status);
+
+        $higherPriorityPayment = TelepagosPayment::query()->create([
+            'cuit_buyer' => '20123456789',
+            'amount' => 52,
+            'operation_id' => 1,
+            'transaction_id' => 'tx-primary-candidate',
+        ]);
+        $higherPriorityPayment->candidates()->create([
+            'compra_id' => $nearAmountPurchase->id,
+            'dni_matches' => true,
+            'dni_distance' => 0,
+            'payment_dni' => '12345678',
+            'purchase_dni' => '12345678',
+            'amount_matches' => true,
+            'payment_amount' => 52,
+            'purchase_amount' => 52,
+            'amount_difference' => 0,
+            'match_reason' => 'ambiguous_exact_match',
+            'confidence' => 'exact',
+        ]);
+
+        app(CheckoutService::class)->submitForReview($nearAmountPurchase->fresh());
+        $buyer = User::query()->findOrFail($nearAmountPurchase->user_id);
+
+        $this->actingAs($buyer, 'sanctum')
+            ->getJson("/api/tenants/candidates/compras/{$nearAmountPurchase->id}")
+            ->assertOk()
+            ->assertJsonPath('data.status', Purchase::STATUS_IN_REVIEW)
+            ->assertJsonPath('data.payment_verification.status', 'candidate')
+            ->assertJsonPath('data.payment_verification.candidate_count', 2)
+            ->assertJsonPath('data.payment_verification.primary.reason', 'ambiguous_exact_match')
+            ->assertJsonPath('data.payment_verification.primary.amount_difference', '0.00')
+            ->assertJsonPath('data.payment_verification.primary.confidence', 'exact')
+            ->assertJsonPath('data.payment_verification.reasons.0', 'ambiguous_exact_match')
+            ->assertJsonPath('data.payment_verification.reasons.1', 'exact_dni_near_amount');
+    }
+
     public function test_webhook_confirms_a_purchase_with_tickets_enabled(): void
     {
         $tenant = $this->createTenant('expired-ticket', 'Expired Ticket', 'expired-ticket.com.ar');

tests/Feature/Seeders/DesfilePuraTendenciaSeederTest.php

@@ -218,13 +218,13 @@ class DesfilePuraTendenciaSeederTest extends TestCase
             ->whereIn('variant_id', (clone $variants)->pluck('id'))
             ->count());
         $this->assertSame(330, (clone $variants)->whereNull('event_date_id')->count());
-        $this->assertSame(284, DB::table('inventories')
+        $this->assertSame(283, DB::table('inventories')
             ->whereIn('id', (clone $variants)->pluck('inventory_id'))
             ->where('real_stock', 1)
             ->where('reserved_stock', 0)
             ->where('sold_units', 0)
             ->count());
-        $this->assertSame(46, DB::table('inventories')
+        $this->assertSame(47, DB::table('inventories')
             ->whereIn('id', (clone $variants)->pluck('inventory_id'))
             ->where('real_stock', 0)
             ->where('reserved_stock', 0)
@@ -289,14 +289,14 @@ class DesfilePuraTendenciaSeederTest extends TestCase
 
         $items = DB::table('compra_items')->where('compra_id', $purchase->id);
 
-        $this->assertSame(48, (clone $items)->count());
-        $this->assertSame(48, (clone $items)
+        $this->assertSame(49, (clone $items)->count());
+        $this->assertSame(49, (clone $items)
             ->where('precio_unitario', 0)
             ->where('discount_total', 0)
             ->where('tax_total', 0)
             ->where('total', 0)
             ->count());
-        $this->assertSame(48, DB::table('tickets')
+        $this->assertSame(49, DB::table('tickets')
             ->where('source_purchase_id', $purchase->id)
             ->where('user_id', $user->id)
             ->where('source_catalog_item_id', $catalogItemId)
@@ -312,7 +312,13 @@ class DesfilePuraTendenciaSeederTest extends TestCase
         foreach ([
             ['sector' => 'A', 'fila' => '1', 'tipo' => 'NORMAL', 'count' => 16],
             ['sector' => 'A', 'fila' => '3', 'tipo' => 'NORMAL', 'count' => 14],
-            ['sector' => 'C', 'fila' => '1', 'tipo' => 'VIP + LUNCH', 'count' => 16],
+            [
+                'sector' => 'C',
+                'fila' => '1',
+                'tipo' => 'VIP + LUNCH',
+                'count' => 17,
+                'seats' => array_map('strval', range(1, 17)),
+            ],
             ['sector' => 'C', 'fila' => '3', 'tipo' => 'NORMAL', 'count' => 2, 'seats' => ['6', '7']],
         ] as $allocation) {
             $allocatedVariants = DB::table('variantes')

tests/Feature/Seeders/MenuSeederTest.php

@@ -34,6 +34,7 @@ class MenuSeederTest extends TestCase
             'adminapp.ventas' => ['Ventas', '/admin/ventas'],
         ];
         $fiestaCategoryMenus = [
+            'adminapp.tickets' => ['Tickets', '/admin/tickets'],
             'adminapp.fiesta-futbol-infantil.entradas' => ['Entradas', '/admin/entradas'],
             'adminapp.fiesta-futbol-infantil.alojamientos' => ['Alojamientos', '/admin/alojamientos'],
             'adminapp.fiesta-futbol-infantil.merchandising' => ['Merchandising', '/admin/merchandising'],
@@ -49,7 +50,11 @@ class MenuSeederTest extends TestCase
         $this->assertSame(Menu::CONTENT_TYPE_DYNAMIC, $adminApp->content_type);
         $this->assertSame('/', $adminApp->route);
         $this->assertSame(
-            array_keys([...$expectedMenus, ...$fiestaCategoryMenus]),
+            collect(array_keys([
+                ...$expectedMenus,
+                ...$fiestaCategoryMenus,
+                'adminapp.desfile.entradas' => ['Entradas', '/admin/desfile/entradas'],
+            ]))->sort()->values()->all(),
             $adminApp->children->pluck('code')->sort()->values()->all()
         );
         $this->assertTrue(

tests/Feature/Ticket/AdminAppTicketControllerTest.php

@@ -0,0 +1,455 @@
+<?php
+
+namespace Tests\Feature\Ticket;
+
+use App\Domains\Attachable\Enums\AttachmentType;
+use App\Domains\Attachable\Models\Attachment;
+use App\Domains\Auth\Models\User;
+use App\Domains\Authorization\Enums\RoleCode;
+use App\Domains\Catalog\Models\Attribute;
+use App\Domains\Catalog\Models\CatalogItem;
+use App\Domains\Catalog\Models\Inventory;
+use App\Domains\Catalog\Models\Variant;
+use App\Domains\Menu\Models\Menu;
+use App\Domains\Purchase\Models\Purchase;
+use App\Domains\Purchase\Models\PurchaseItem;
+use App\Domains\Shared\Enums\FieldType;
+use App\Domains\Tenant\Models\Tenant;
+use App\Domains\Tenant\Models\WebsiteType;
+use App\Domains\Ticket\Models\Ticket;
+use Barryvdh\DomPDF\ServiceProvider as DomPdfServiceProvider;
+use Database\Seeders\AttributeSeeder;
+use Database\Seeders\AuthorizationSeeder;
+use Database\Seeders\FiestaFutbolInfantilProductSeeder;
+use Illuminate\Foundation\Testing\RefreshDatabase;
+use Illuminate\Support\Str;
+use Laravel\Sanctum\Sanctum;
+use Tests\TestCase;
+
+class AdminAppTicketControllerTest extends TestCase
+{
+    use RefreshDatabase;
+
+    protected function setUp(): void
+    {
+        parent::setUp();
+
+        $this->app->register(DomPdfServiceProvider::class);
+
+        $this->seed(AuthorizationSeeder::class);
+        WebsiteType::query()->create(['codigo' => 'onticket', 'nombre' => 'OnTicket']);
+    }
+
+    public function test_authentication_is_required(): void
+    {
+        $this->getJson('/api/v1/adminapp/tenant/tickets')->assertUnauthorized();
+    }
+
+    public function test_the_tenant_must_have_the_tickets_menu(): void
+    {
+        $tenant = $this->createTenant('fiesta_futbol_infantil');
+        Sanctum::actingAs($this->createAdminAppUser($tenant));
+
+        $this->getJson('/api/v1/adminapp/tenant/tickets')->assertNotFound();
+    }
+
+    public function test_it_lists_only_tickets_from_the_authenticated_tenant(): void
+    {
+        $tenant = $this->createTenant('fiesta_futbol_infantil');
+        $otherTenant = $this->createTenant('other');
+        $admin = $this->createAdminAppUser($tenant);
+        $otherUser = $this->createAdminAppUser($otherTenant);
+        $this->grantTicketsMenu($tenant);
+        Sanctum::actingAs($admin);
+
+        $ticket = $this->createTicket($tenant, $admin);
+        $this->createTicket($otherTenant, $otherUser);
+
+        $this->getJson('/api/v1/adminapp/tenant/tickets')
+            ->assertOk()
+            ->assertJsonCount(1, 'data')
+            ->assertJsonPath('data.0.id', $ticket->id)
+            ->assertJsonPath('data.0.tenant_code', $tenant->codigo)
+            ->assertJsonPath('data.0.values.ticket', $ticket->ticket)
+            ->assertJsonPath('data.0.values.status', Ticket::STATUS_ACTIVE)
+            ->assertJsonPath('meta.total', 1);
+    }
+
+    public function test_it_supports_id_and_uuid_search(): void
+    {
+        $tenant = $this->createTenant('fiesta_futbol_infantil');
+        $admin = $this->createAdminAppUser($tenant);
+        $this->grantTicketsMenu($tenant);
+        Sanctum::actingAs($admin);
+
+        $matching = $this->createTicket($tenant, $admin);
+        $this->createTicket($tenant, $admin);
+
+        $this->getJson("/api/v1/adminapp/tenant/tickets?q={$matching->id}")
+            ->assertOk()
+            ->assertJsonCount(1, 'data')
+            ->assertJsonPath('data.0.id', $matching->id);
+
+        $this->getJson('/api/v1/adminapp/tenant/tickets?q='.substr($matching->ticket, 0, 8))
+            ->assertOk()
+            ->assertJsonCount(1, 'data')
+            ->assertJsonPath('data.0.ticket', $matching->ticket);
+    }
+
+    public function test_it_sorts_the_complete_filtered_result_before_paginating(): void
+    {
+        $tenant = $this->createTenant('fiesta_futbol_infantil');
+        $admin = $this->createAdminAppUser($tenant);
+        $this->grantTicketsMenu($tenant);
+        Sanctum::actingAs($admin);
+
+        foreach (['ticket-c', 'ticket-a', 'ticket-d', 'ticket-b'] as $value) {
+            $this->createTicket($tenant, $admin)->update(['ticket' => $value]);
+        }
+
+        $query = http_build_query([
+            'sort_by' => 'ticket',
+            'sort_direction' => 'asc',
+            'per_page' => 2,
+        ]);
+
+        $this->getJson('/api/v1/adminapp/tenant/tickets?'.$query)
+            ->assertOk()
+            ->assertJsonPath('data.0.values.ticket', 'ticket-a')
+            ->assertJsonPath('data.1.values.ticket', 'ticket-b')
+            ->assertJsonPath('meta.total', 4)
+            ->assertJsonPath('meta.last_page', 2);
+
+        $this->getJson('/api/v1/adminapp/tenant/tickets?'.$query.'&page=2')
+            ->assertOk()
+            ->assertJsonPath('data.0.values.ticket', 'ticket-c')
+            ->assertJsonPath('data.1.values.ticket', 'ticket-d');
+    }
+
+    public function test_it_rejects_sort_columns_not_enabled_for_the_tenant(): void
+    {
+        $tenant = $this->createTenant('other');
+        $this->grantTicketsMenu($tenant);
+        Sanctum::actingAs($this->createAdminAppUser($tenant));
+
+        $this->getJson('/api/v1/adminapp/tenant/tickets?sort_by=category&sort_direction=sideways')
+            ->assertUnprocessable()
+            ->assertJsonValidationErrors(['sort_by', 'sort_direction']);
+    }
+
+    public function test_it_rejects_product_and_type_sorting_for_fiesta_futbol_infantil(): void
+    {
+        $tenant = $this->createTenant('fiesta_futbol_infantil');
+        $this->grantTicketsMenu($tenant);
+        Sanctum::actingAs($this->createAdminAppUser($tenant));
+
+        foreach (['product', 'type'] as $column) {
+            $this->getJson('/api/v1/adminapp/tenant/tickets?sort_by='.$column)
+                ->assertUnprocessable()
+                ->assertJsonValidationErrors('sort_by');
+        }
+    }
+
+    public function test_it_includes_tenant_scanned_and_total_ticket_counts(): void
+    {
+        $tenant = $this->createTenant('fiesta_futbol_infantil');
+        $otherTenant = $this->createTenant('other');
+        $admin = $this->createAdminAppUser($tenant);
+        $otherUser = $this->createAdminAppUser($otherTenant);
+        $this->grantTicketsMenu($tenant);
+        Sanctum::actingAs($admin);
+
+        $this->createTicket($tenant, $admin)->update(['used_at' => now()]);
+        $this->createTicket($tenant, $admin);
+        $this->createTicket($otherTenant, $otherUser)->update(['used_at' => now()]);
+
+        $this->getJson('/api/v1/adminapp/tenant/tickets?q=does-not-match')
+            ->assertOk()
+            ->assertJsonCount(0, 'data')
+            ->assertJsonPath('scanned_tickets', 0)
+            ->assertJsonPath('total_tickets', 0);
+
+        $this->getJson('/api/v1/adminapp/tenant/tickets')
+            ->assertOk()
+            ->assertJsonPath('scanned_tickets', 1)
+            ->assertJsonPath('total_tickets', 2);
+    }
+
+    public function test_it_returns_structured_variant_properties(): void
+    {
+        $tenant = $this->createTenant('fiesta_futbol_infantil');
+        $admin = $this->createAdminAppUser($tenant);
+        $this->grantTicketsMenu($tenant);
+        Sanctum::actingAs($admin);
+
+        $item = CatalogItem::query()->create([
+            'tenant_code' => $tenant->codigo,
+            'slug' => 'remera',
+            'nombre' => 'Remera',
+            'precio' => '8000.00',
+            'has_tickets' => true,
+        ]);
+        $attribute = Attribute::query()->create([
+            'tenant_codigo' => $tenant->codigo,
+            'codigo' => 'size',
+            'nombre' => 'Talle',
+            'type' => FieldType::Select,
+        ]);
+        $attribute->options()->create(['value' => 'xl', 'label' => 'XL']);
+        $itemAttribute = $item->itemAttributes()->create([
+            'attribute_id' => $attribute->id,
+            'sort_order' => 1,
+        ]);
+        $variant = Variant::query()->create([
+            'catalog_item_id' => $item->id,
+            'inventory_id' => Inventory::query()->create()->id,
+        ]);
+        $variant->definitions()->create([
+            'item_attribute_id' => $itemAttribute->id,
+            'value' => 'xl',
+        ]);
+        $purchase = Purchase::query()->create([
+            'tenant_codigo' => $tenant->codigo,
+            'user_id' => $admin->id,
+            'status' => Purchase::STATUS_PAID,
+            'nombre_apellido' => 'Nombre Apellido',
+            'total' => '8000.00',
+        ]);
+        PurchaseItem::query()->create([
+            'compra_id' => $purchase->id,
+            'source_catalog_item_id' => $item->id,
+            'source_variant_id' => $variant->id,
+            'nombre' => 'Remera',
+            'descripcion' => '',
+            'slug' => 'remera',
+            'item_nombre' => 'Remera',
+            'cantidad' => 1,
+            'precio_unitario' => '8000.00',
+            'total' => '8000.00',
+        ]);
+        $ticket = $this->createTicket($tenant, $admin, [
+            'source_purchase_id' => $purchase->id,
+            'source_catalog_item_id' => $item->id,
+            'source_variant_id' => $variant->id,
+            'scanner_user_id' => $admin->id,
+            'used_at' => now(),
+        ]);
+
+        $this->getJson('/api/v1/adminapp/tenant/tickets')
+            ->assertOk()
+            ->assertJsonPath('data.0.id', $ticket->id)
+            ->assertJsonPath('data.0.order_number', $purchase->id)
+            ->assertJsonPath('data.0.product', 'Remera')
+            ->assertJsonPath('data.0.amount', '8000.00')
+            ->assertJsonPath('data.0.status', Ticket::STATUS_USED)
+            ->assertJsonPath('data.0.scanned_by', $admin->nombre_apellido)
+            ->assertJsonPath('data.0.variant_properties.0.code', 'size')
+            ->assertJsonPath('data.0.variant_properties.0.label', 'Talle')
+            ->assertJsonPath('data.0.variant_properties.0.values.0.value', 'xl')
+            ->assertJsonPath('data.0.variant_properties.0.values.0.label', 'XL');
+    }
+
+    public function test_it_applies_the_ticket_filter_form_values(): void
+    {
+        $tenant = $this->createTenant('fiesta_futbol_infantil');
+        $admin = $this->createAdminAppUser($tenant);
+        $this->grantTicketsMenu($tenant);
+        $this->seed([AttributeSeeder::class, FiestaFutbolInfantilProductSeeder::class]);
+        Sanctum::actingAs($admin);
+
+        $date = $tenant->eventDates()->orderByDesc('date')->firstOrFail();
+        $food = CatalogItem::query()
+            ->where('tenant_code', $tenant->codigo)
+            ->where('slug', 'comida')
+            ->with([
+                'variants.definitions.itemAttribute.attribute.options',
+                'variants.eventDates',
+                'variants.eventDate',
+            ])
+            ->firstOrFail();
+        $dinner = $food->variants->first(fn (Variant $variant): bool => $variant
+            ->selectedEventDates()->contains('id', $date->id)
+            && $variant->selectionValues()->get('horario') === 'Cena');
+        $lunch = $food->variants->first(fn (Variant $variant): bool => $variant
+            ->selectedEventDates()->contains('id', $date->id)
+            && $variant->selectionValues()->get('horario') === 'Almuerzo');
+        $this->assertNotNull($dinner);
+        $this->assertNotNull($lunch);
+
+        $matchingPurchase = $this->createPurchase($tenant, $admin, '2026-08-20 10:00:00');
+        $otherPurchase = $this->createPurchase($tenant, $admin, '2026-08-21 10:00:00');
+        $matching = $this->createTicket($tenant, $admin, [
+            'source_purchase_id' => $matchingPurchase->id,
+            'source_catalog_item_id' => $food->id,
+            'source_variant_id' => $dinner->id,
+            'used_at' => now(),
+        ]);
+        $this->createTicket($tenant, $admin, [
+            'source_purchase_id' => $matchingPurchase->id,
+            'source_catalog_item_id' => $food->id,
+            'source_variant_id' => $lunch->id,
+            'used_at' => now(),
+        ]);
+        $this->createTicket($tenant, $admin, [
+            'source_purchase_id' => $otherPurchase->id,
+            'source_catalog_item_id' => $food->id,
+            'source_variant_id' => $dinner->id,
+            'used_at' => now(),
+        ]);
+
+        $this->getJson('/api/v1/adminapp/tenant/tickets?'.http_build_query([
+            'category' => 'comidas',
+            'product' => (string) $date->id,
+            'type' => 'Cena',
+            'date' => '2026-08-20',
+            'status' => Ticket::STATUS_USED,
+        ]))
+            ->assertOk()
+            ->assertJsonCount(1, 'data')
+            ->assertJsonPath('data.0.id', $matching->id)
+            ->assertJsonPath('scanned_tickets', 1)
+            ->assertJsonPath('total_tickets', 1);
+    }
+
+    public function test_it_filters_computed_active_and_expired_statuses(): void
+    {
+        $tenant = $this->createTenant('fiesta_futbol_infantil');
+        $admin = $this->createAdminAppUser($tenant);
+        $this->grantTicketsMenu($tenant);
+        $this->seed([AttributeSeeder::class, FiestaFutbolInfantilProductSeeder::class]);
+        Sanctum::actingAs($admin);
+
+        $food = CatalogItem::query()
+            ->where('tenant_code', $tenant->codigo)
+            ->where('slug', 'comida')
+            ->with('variants')
+            ->firstOrFail();
+        $expired = $this->createTicket($tenant, $admin, [
+            'source_catalog_item_id' => $food->id,
+            'source_variant_id' => $food->variants->firstOrFail()->id,
+        ]);
+        $active = $this->createTicket($tenant, $admin);
+
+        $this->travelTo('2026-10-20 12:00:00');
+
+        $this->getJson('/api/v1/adminapp/tenant/tickets?status=expired')
+            ->assertOk()
+            ->assertJsonCount(1, 'data')
+            ->assertJsonPath('data.0.id', $expired->id);
+
+        $this->getJson('/api/v1/adminapp/tenant/tickets?status=active')
+            ->assertOk()
+            ->assertJsonCount(1, 'data')
+            ->assertJsonPath('data.0.id', $active->id);
+    }
+
+    public function test_it_downloads_filtered_ticket_reports(): void
+    {
+        $tenant = $this->createTenant('fiesta_futbol_infantil');
+        $admin = $this->createAdminAppUser($tenant);
+        $this->grantTicketsMenu($tenant);
+        Sanctum::actingAs($admin);
+
+        $ticket = $this->createTicket($tenant, $admin);
+        $query = http_build_query([
+            'q' => (string) $ticket->id,
+            'timezone' => 'America/Argentina/Buenos_Aires',
+        ]);
+
+        $this->get('/api/v1/adminapp/tenant/tickets/pdf?'.$query)
+            ->assertOk()
+            ->assertHeader('content-type', 'application/pdf');
+
+        $this->get('/api/v1/adminapp/tenant/tickets/excel?'.$query)
+            ->assertOk()
+            ->assertHeader(
+                'content-type',
+                'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
+            );
+    }
+
+    public function test_ticket_reports_require_a_valid_timezone(): void
+    {
+        $tenant = $this->createTenant('fiesta_futbol_infantil');
+        $this->grantTicketsMenu($tenant);
+        Sanctum::actingAs($this->createAdminAppUser($tenant));
+
+        $this->getJson('/api/v1/adminapp/tenant/tickets/pdf')->assertUnprocessable();
+        $this->getJson('/api/v1/adminapp/tenant/tickets/excel?timezone=Invalid')
+            ->assertUnprocessable();
+    }
+
+    private function createTenant(string $code): Tenant
+    {
+        $headerLogo = $this->createAttachment("{$code}-header.png");
+        $footerLogo = $this->createAttachment("{$code}-footer.png");
+
+        return Tenant::query()->create([
+            'codigo' => $code,
+            'nombre' => ucfirst($code),
+            'dominio' => "{$code}.test",
+            'website_type_code' => 'onticket',
+            'primary_color' => '#111111',
+            'secondary_color' => '#222222',
+            'danger_color' => '#333333',
+            'success_color' => '#444444',
+            'header_bg_color' => '#ffffff',
+            'footer_bg_color' => '#ffffff',
+            'header_logo_id' => $headerLogo->id,
+            'footer_logo_id' => $footerLogo->id,
+        ]);
+    }
+
+    private function createAttachment(string $filename): Attachment
+    {
+        return Attachment::query()->create([
+            'path' => "test/{$filename}",
+            'filename' => $filename,
+            'type' => AttachmentType::Image,
+            'mime_type' => 'image/png',
+        ]);
+    }
+
+    private function createAdminAppUser(Tenant $tenant): User
+    {
+        return User::factory()->create([
+            'rol_codigo' => RoleCode::AdminApp->value,
+            'tenant_codigo' => $tenant->codigo,
+        ]);
+    }
+
+    private function createPurchase(Tenant $tenant, User $user, string $createdAt): Purchase
+    {
+        $purchase = Purchase::query()->create([
+            'tenant_codigo' => $tenant->codigo,
+            'user_id' => $user->id,
+            'status' => Purchase::STATUS_PAID,
+            'nombre_apellido' => $user->nombre_apellido,
+            'total' => '0.00',
+        ]);
+        $purchase->forceFill(['created_at' => $createdAt, 'updated_at' => $createdAt])->saveQuietly();
+
+        return $purchase;
+    }
+
+    private function grantTicketsMenu(Tenant $tenant): void
+    {
+        $menu = Menu::query()->create([
+            'code' => 'adminapp.tickets',
+            'label' => 'Tickets',
+            'route' => '/admin/tickets',
+        ]);
+
+        $tenant->menues()->attach($menu->code);
+    }
+
+    /** @param array<string, mixed> $attributes */
+    private function createTicket(Tenant $tenant, User $user, array $attributes = []): Ticket
+    {
+        return Ticket::query()->create(array_merge([
+            'tenant_code' => $tenant->codigo,
+            'ticket' => (string) Str::uuid(),
+            'user_id' => $user->id,
+        ], $attributes));
+    }
+}

tests/TestCase.php

@@ -2,9 +2,30 @@
 
 namespace Tests;
 
+use Illuminate\Foundation\Application;
 use Illuminate\Foundation\Testing\TestCase as BaseTestCase;
+use RuntimeException;
 
 abstract class TestCase extends BaseTestCase
 {
-    //
+    /**
+     * Boot the application only when the test database is explicitly isolated.
+     */
+    public function createApplication(): Application
+    {
+        $app = parent::createApplication();
+
+        $database = (string) $app['config']->get(
+            'database.connections.'.$app['config']->get('database.default').'.database'
+        );
+
+        if (! preg_match('/^shopit_(?:test|testing)(?:_\d+)?$/', $database)) {
+            throw new RuntimeException(sprintf(
+                'Refusing to run tests against database [%s]. Use [shopit_test] or [shopit_testing].',
+                $database !== '' ? $database : '(empty)'
+            ));
+        }
+
+        return $app;
+    }
 }

tests/Unit/Purchase/DniDistanceServiceTest.php

@@ -0,0 +1,31 @@
+<?php
+
+namespace Tests\Unit\Purchase;
+
+use App\Domains\Purchase\Services\DniDistanceService;
+use PHPUnit\Framework\Attributes\DataProvider;
+use PHPUnit\Framework\TestCase;
+
+class DniDistanceServiceTest extends TestCase
+{
+    /** @return iterable<string, array{string, string, int}> */
+    public static function distances(): iterable
+    {
+        yield 'exact' => ['40123456', '40123456', 0];
+        yield 'leading transposition' => ['40123456', '04123456', 1];
+        yield 'trailing transposition' => ['40123456', '40123465', 1];
+        yield 'single substitution' => ['40123456', '40123856', 1];
+        yield 'substitution and transposition' => ['12345678', '12345087', 2];
+        yield 'seven digits normalized with leading zero' => ['04123456', '4123456', 0];
+        yield 'more than two edits' => ['40123456', '87654321', 7];
+    }
+
+    #[DataProvider('distances')]
+    public function test_it_calculates_damerau_levenshtein_distance(
+        string $left,
+        string $right,
+        int $expected,
+    ): void {
+        $this->assertSame($expected, (new DniDistanceService)->distance($left, $right));
+    }
+}

tests/Unit/Ticket/AdminAppTicketExportServiceTest.php

@@ -0,0 +1,151 @@
+<?php
+
+namespace Tests\Unit\Ticket;
+
+use App\Domains\Tenant\Models\Tenant;
+use App\Domains\Ticket\Services\AdminAppTicketColumnService;
+use App\Domains\Ticket\Services\AdminAppTicketExcelService;
+use App\Domains\Ticket\Services\AdminAppTicketPdfService;
+use App\Domains\Ticket\Services\AdminAppTicketReportService;
+use App\Domains\Ticket\Services\AdminAppTicketRowService;
+use Barryvdh\DomPDF\ServiceProvider;
+use Illuminate\Support\Carbon;
+use Mockery;
+use PhpOffice\PhpSpreadsheet\IOFactory;
+use Symfony\Component\HttpFoundation\StreamedResponse;
+use Tests\TestCase;
+
+class AdminAppTicketExportServiceTest extends TestCase
+{
+    protected function setUp(): void
+    {
+        parent::setUp();
+
+        $this->app->register(ServiceProvider::class);
+        Carbon::setTestNow(Carbon::parse('2026-08-24 17:53:00', 'UTC'));
+    }
+
+    protected function tearDown(): void
+    {
+        Carbon::setTestNow();
+
+        parent::tearDown();
+    }
+
+    public function test_it_downloads_the_ticket_report_as_an_excel_file(): void
+    {
+        $response = (new AdminAppTicketExcelService($this->reportService(), $this->columnService()))
+            ->download($this->tenant(), collect(), 'America/La_Paz');
+
+        $this->assertSame(
+            'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
+            $response->headers->get('content-type'),
+        );
+        $this->assertStringContainsString(
+            'attachment; filename=tickets_fiesta_futbol_infantil_20260824_135300.xlsx',
+            (string) $response->headers->get('content-disposition'),
+        );
+
+        $path = $this->spreadsheetPath($response);
+        try {
+            $sheet = IOFactory::load($path)->getActiveSheet();
+
+            $this->assertSame('Tickets', $sheet->getTitle());
+            $this->assertSame('N° de orden', $sheet->getCell('A1')->getValue());
+            $this->assertSame('#15', $sheet->getCell('A2')->getValue());
+            $this->assertSame('Cena', $sheet->getCell('D2')->getValue());
+            $this->assertSame(8000.0, $sheet->getCell('E2')->getValue());
+            $this->assertSame('00000000-0000-0000-0000-000000000001', $sheet->getCell('G2')->getValue());
+            $this->assertSame('Usado', $sheet->getCell('I2')->getValue());
+        } finally {
+            @unlink($path);
+        }
+    }
+
+    public function test_it_downloads_the_ticket_report_as_a_pdf(): void
+    {
+        $response = (new AdminAppTicketPdfService($this->reportService(), $this->columnService()))
+            ->download($this->tenant(), collect(), 'America/La_Paz');
+
+        $this->assertSame('application/pdf', $response->headers->get('content-type'));
+        $this->assertStringContainsString(
+            'attachment; filename=tickets_fiesta_futbol_infantil_20260824_135300.pdf',
+            (string) $response->headers->get('content-disposition'),
+        );
+        $this->assertStringStartsWith('%PDF', $response->getContent());
+    }
+
+    public function test_the_pdf_view_contains_the_report_data_and_requested_timezone(): void
+    {
+        $columns = $this->columnService()->columns($this->tenant());
+        $html = view('pdf.adminapp.tickets', [
+            'tenant' => $this->tenant(),
+            'columns' => $columns,
+            'tickets' => (new AdminAppTicketRowService)->displayRows(
+                collect([$this->row()]),
+                $columns,
+                'America/La_Paz',
+            ),
+            'generatedAt' => now(),
+            'timeZone' => 'America/La_Paz',
+        ])->render();
+
+        $this->assertStringContainsString('Generado el 24/08/2026 13:53', $html);
+        $this->assertStringContainsString('00000000-0000-0000-0000-000000000001', $html);
+        $this->assertStringContainsString('Cena', $html);
+        $this->assertStringContainsString('24/08/2026 13:53', $html);
+    }
+
+    private function reportService(): AdminAppTicketReportService
+    {
+        $rowService = Mockery::mock(AdminAppTicketRowService::class)->makePartial();
+        $rowService->shouldReceive('rows')->once()->andReturn(collect([$this->row()]));
+
+        return new AdminAppTicketReportService($rowService);
+    }
+
+    /** @return array<string, mixed> */
+    private function row(): array
+    {
+        return [
+            'order_number' => 15,
+            'category' => 'Comida',
+            'product' => '12/10',
+            'type' => 'Cena',
+            'amount' => 8000.0,
+            'client' => 'Cliente Test',
+            'ticket' => '00000000-0000-0000-0000-000000000001',
+            'date' => now(),
+            'status' => 'used',
+            'scanned_by' => 'Admin Test',
+        ];
+    }
+
+    private function tenant(): Tenant
+    {
+        return (new Tenant)->forceFill([
+            'codigo' => 'fiesta_futbol_infantil',
+            'nombre' => 'Fiesta del Fútbol Infantil',
+        ]);
+    }
+
+    private function columnService(): AdminAppTicketColumnService
+    {
+        return new AdminAppTicketColumnService;
+    }
+
+    private function spreadsheetPath(StreamedResponse $response): string
+    {
+        ob_start();
+        ($response->getCallback())();
+        $contents = ob_get_clean();
+        $this->assertIsString($contents);
+        $this->assertStringStartsWith('PK', $contents);
+
+        $path = tempnam(sys_get_temp_dir(), 'shopit_ticket_excel_');
+        $this->assertNotFalse($path);
+        file_put_contents($path, $contents);
+
+        return $path;
+    }
+}