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

    // 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
    $minPrice = $program->lots()
        ->whereHas('prices', function($q) {
            $q->where('type', 'prix_ttc')
              ->where('value', '>', 0);
        })
        ->with(['prices' => function($q) {
            $q->where('type', 'prix_ttc')
              ->where('value', '>', 0)
              ->orderBy('value', 'asc');
        }])
        ->first();
    $prixMin = $minPrice && $minPrice->prices->first() ? $minPrice->prices->first()->value : 0;

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

    // Opérations commerciales (opeComs)
    $hasOpeComs = $program->opeComs()->exists() || $program->lots()->whereHas('opeComs')->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;
    }
@endphp

<div class="col-xs-12 col-sm-12 col-md-6 col-lg-4 wow fadeInLeft" data-wow-delay="0s">
                                <a href="{{ route('programmes.show', $program->slug) }}" data-id="{{ $program->id }}" class="programme_miniature_lien">
        <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">
                @if($dateLivraisonValue)
                    <span>Livré en {{ date('Y', strtotime($dateLivraisonValue)) }}</span>
                @endif
                @if($hasOpeComs)
                    <span><i class="fa-regular fa-gift text-gold"></i></span>
                @endif
                @if($hasExclusivite)
                    <span class="programme_exclusivite">
                        <img src="{{ isset($themeExclu) && (strpos($themeExclu, 'http://') === 0 || strpos($themeExclu, 'https://') === 0) ? $themeExclu : asset($themeExclu ?? 'assets/img/exclusivite.svg') }}" class="img img-fluid" alt="Exclusivité" /> Exclusivité
                    </span>
                @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-gold">
                        <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">{{ ucwords(strtolower($program->city)) }}</p>
                    <p class="m-0 text-gold">
                        {{ $fiscaliteLibelle }}
                        @if($hasTva5)
                            <span class="text-gold"> / TVA 5,5%</span>
                        @endif
                        @if($hasLli)
                            <span class="text-gold"> / 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-gold">{{ $quoteTravaux }} %</span></p>
                    @endif
                </div>
            </div>
        </div>
    </a>
</div>