@php
    use App\Enums\PriceType;
    use App\Enums\PriceTypeTravaux;
    use App\Enums\MarketingTagType;
    use App\Enums\Fiscalite;

    // Image - utiliser le CDN
    $firstMedia = $program->getFirstMedia('images');
    $image = $firstMedia ? getImageFromCDN($firstMedia, 'miniature') : ($themeLogo ?? asset('assets/img/logo.png'));

    // Fiscalités
    $fiscalites = $program->fiscalites->pluck('type')->map(fn($f) => $f->label())->toArray();
    $fiscaliteLibelle = !empty($fiscalites) ? implode(', ', $fiscalites) : '';

    // Date de livraison
    $dateLivraison = $program->dates->where('type', 'date_livraison')->first();
    $dateLivraisonValue = $dateLivraison ? $dateLivraison->value : null;

    // Prix minimum depuis les lots (uniquement les lots non vendus)
    // Utiliser les lots déjà chargés si disponibles, sinon faire une requête
    $lots = $program->relationLoaded('lots') ? $program->lots : $program->lots()->with(['prices', 'states'])->get();

    $isDenormandie = $program->fiscalites->contains(function ($fiscalite) {
        return (($fiscalite->type->value ?? null) === Fiscalite::DENORMANDIE->value);
    });

    // Filtrer les lots non vendus avec un prix de référence > 0
    $availableLots = $lots->filter(function($lot) use ($isDenormandie) {
        // Exclure les lots vendus
        $isVendu = $lot->states->contains(function($state) {
            return $state->type->value === \App\Enums\ProductState::VENDU->value;
        });
        if ($isVendu) {
            return false;
        }

        $startingPrice = $isDenormandie
            ? $lot->getTotalLotEtAnnexes()
            : ($lot->prices->where('type', PriceType::PRIX_IMMO_TTC->value)->first()?->value ?? 0);

        return $startingPrice > 0;
    });

    // Trouver le prix minimum
    $prixMin = 0;
    if ($availableLots->count() > 0) {
        $prices = $availableLots->map(function($lot) use ($isDenormandie) {
            return $isDenormandie
                ? $lot->getTotalLotEtAnnexes()
                : ($lot->prices->where('type', PriceType::PRIX_IMMO_TTC->value)->first()?->value ?? 0);
        })->filter(function($price) {
            return $price > 0;
        });

        if ($prices->count() > 0) {
            $prixMin = $prices->min();
        }
    }

    // Exclusivité
    $hasExclusivite = $program->marketingTags()->where('type', MarketingTagType::EXCLUSIVITE->value)->exists();

    // Opérations commerciales (opeComs)
    $hasOpeComs = $program->opeComs()->exists() || $program->lots()->whereHas('opeComs')->exists();
    $hasCashback = $program->opeComs()->where('type', \App\Enums\OpeCom::CASHBACK->value)->exists()
        || $program->lots()->whereHas('opeComs', function($q) {
            $q->where('type', \App\Enums\OpeCom::CASHBACK->value);
        })->exists();
    $hasNonCashbackOpeComs = $program->opeComs()->where('type', '!=', \App\Enums\OpeCom::CASHBACK->value)->exists()
        || $program->lots()->whereHas('opeComs', function($q) {
            $q->where('type', '!=', \App\Enums\OpeCom::CASHBACK->value);
        })->exists();

    // TVA 5.5% - vérifier si au moins un lot a un prix_tva_5_5
    $hasTva5 = $program->lots()
        ->whereHas('prices', function($q) {
            $q->where('type', PriceType::PRIX_TVA_5_5->value)
              ->where('value', '>', 0);
        })
        ->exists();

    // LLI (TVA 10%) - vérifier si au moins un lot a un prix_tva_10
    $hasLli = $program->lots()
        ->whereHas('prices', function($q) {
            $q->where('type', PriceType::PRIX_TVA_10->value)
              ->where('value', '>', 0);
        })
        ->exists();

    // Quote/travaux - calculer le pourcentage moyen
    $quoteTravaux = null;
    $lotsWithTravaux = $program->lots()
        ->whereHas('prices', function($q) {
            $q->whereIn('type', [
                PriceTypeTravaux::PRIX_TRAVAUX_ELIGIBLE->value,
                PriceTypeTravaux::PRIX_TRAVAUX_NON_ELIGIBLE->value
            ])
            ->where('value', '>', 0);
        })
        ->with(['prices' => function($q) {
            $q->whereIn('type', [
                'prix_ttc',
                PriceTypeTravaux::PRIX_TRAVAUX_ELIGIBLE->value,
                PriceTypeTravaux::PRIX_TRAVAUX_NON_ELIGIBLE->value
            ]);
        }])
        ->get();

    if ($lotsWithTravaux->count() > 0) {
        $quotes = [];
        foreach ($lotsWithTravaux as $lot) {
            $prixTTC = $lot->prices->where('type', 'prix_ttc')->first()?->value ?? 0;
            $prixTravaux = $lot->prices
                ->whereIn('type', [
                    PriceTypeTravaux::PRIX_TRAVAUX_ELIGIBLE->value,
                    PriceTypeTravaux::PRIX_TRAVAUX_NON_ELIGIBLE->value
                ])
                ->sum('value');

            if ($prixTTC > 0 && $prixTravaux > 0) {
                $quotes[] = ($prixTravaux / $prixTTC) * 100;
            }
        }
        if (!empty($quotes)) {
            $quoteTravaux = round(max($quotes));
        }
    }

    // Déterminer si TTC ou HT (basé sur la fiscalité principale)
    $isHT = false;
    $mainFiscalite = $program->fiscalites->first();
    if ($mainFiscalite && $mainFiscalite->type->value === 'monument_historique') {
        $isHT = true;
    }

    // Ville
    $address = $program->addresses->first();
    $city = $address ? ucwords(strtolower($address->city)) : '';
@endphp

<a href="{{ route('programmes.show', $program->slug) }}" data-id="{{ $program->id }}" class="programme_miniature_lien" target="_blank">
    <div class="bg-grey border-radius-10 programme_miniature">
        <img class="img-fluid" src="{{ $image }}" alt="{{ strtolower($program->name) }}" loading="lazy" />
        <div class="programme_miniature_header">
            <x-livraison-badge :value="$dateLivraisonValue" />
            @if($hasOpeComs)
                @if($hasNonCashbackOpeComs)
                    <span><i class="fa-regular fa-gift text-primary"></i></span>
                @endif
                @if($hasCashback)
                    <span class="euro-icon"></span>
                @endif
            @endif
            @if($hasExclusivite)
                <x-marketing-tag-badge :type="MarketingTagType::EXCLUSIVITE" />
            @endif
        </div>

        <div class="row px-3">
            <div class="col-8" style="display: table;">
                <p class="pb-2 text-black-or-white programme_miniature_nom" style="vertical-align: bottom; display: table-cell;">{{ ucwords(strtolower($program->name)) }}</p>
            </div>

            <div class="col-4 text-right">
                <p class="mt-0 mb-1 text-primary">
                    <sub>à partir de</sub><br />
                    <span class="programe_price">
                        {{ number_format($prixMin, 0, ',', ' ') }} €
                        <sup style="font-size: 8px; top: -10px;">{{ $isHT ? 'HT' : 'TTC' }}</sup>
                    </span>
                </p>
            </div>

            <div class="col-12">
                <hr class="my-1" />
            </div>
            <div class="my-2 col-6 programme_miniature_footer">
                <p class="m-0 text-black-or-white">{{ $city }}</p>
                <p class="m-0 text-primary">
                    {{ $fiscaliteLibelle }}
                    @if($hasTva5)
                        <span class="text-primary"> / TVA 5,5%</span>
                    @endif
                    @if($hasLli)
                        <span class="text-primary"> / LLI</span>
                    @endif
                </p>
            </div>
            <div class="my-2 col-6 programme_miniature_footer text-right">
                @if($quoteTravaux)
                    <p class="m-0 text-white">Quote/travaux : <span class="text-primary">{{ $quoteTravaux }} %</span></p>
                @endif
            </div>
        </div>
    </div>
</a>