@extends('layouts.app')

@section('content')
<div class="row py-5">
    <div class="col-lg-12">
        <div class="text-end mb-3">
            <a href="{{ route('partners.campaign_counts.export', ['partner' => $partner, 'campaign_count' => $campaignCount]) }}" class="btn btn-dark">Exporter</a>

            @if($campaignCount->type === 'phone' && $partner->has_campaign_prosp)
                @if(Auth::user()->partners()->count() > 1)
                    <span class="dropdown">
                        <button class="btn btn-primary dropdown-toggle text-nowrap" type="button" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                            Utiliser le comptage sur :
                        </button>
                        <div class="dropdown-menu">
                            @foreach (Auth::user()->partners->sortBy('name') as $p)
                            <a href="{{ isset($p->front_domain) ? 'https://'.$p->front_domain : env('FRONT_URL') }}/{{ isset($p->slug) ? $p->slug.'/' : '' }}campaign_prosps/{{ $campaignCount->id }}/replicate" class="dropdown-item" target="_blank">{{ $p->name }}</a>
                            @endforeach
                        </div>
                    </span>
                @else
                    <a href="{{ isset($partner->front_domain) ? 'https://'.$partner->front_domain : env('FRONT_URL') }}/{{ isset($partner->slug) ? $partner->slug.'/' : '' }}campaign_prosps/{{ $campaignCount->id }}/replicate" class="btn btn-primary" target="_blank">Utiliser le comptage</a>
                @endif
            @endif
        </div>

        <div class="card">
            <div class="card-body">
                <h5 class="card-title">
                    {{ $campaignCount->name }}
                </h5>

                <p>
                    {{ $campaignCount->volume }} {{ $campaignCount->type === 'phone' ? 'SMS' : ($campaignCount->type === 'email' ? 'emails' : ($campaignCount->type === 'address' ? 'adresses' : 'numéros télémarketing')) }}.
                </p>

                <p>
                    @if($campaignCount->status === 'draft')
                        La demande est en brouillon.
                    @elseif($campaignCount->status === 'sent')
                        La demande a été envoyée le {{ $campaignCount->updated_at->format('d/m/Y H:i') }}
                    @elseif($campaignCount->status === 'payed')
                        La demande est programmée pour le {{ $campaignCount->updated_at->format('d/m/Y H:i') }}.
                    @elseif($campaignCount->status === 'cancel')
                        La demande est annulée.
                    @endif
                </p>

                <p class="font-weight-bold">Ciblage :</p>

                <p>
                    Cible les {{  $campaignCount->gender === 'M' ? 'hommes' : ($campaignCount->gender === 'F' ? 'Femmes' : 'hommes et femmes' ) }} de
                    @if($campaignCount->age_min === 18 && $campaignCount->age_max === 75)
                        tout âge,
                    @else
                        {{ $campaignCount->age_min}} à {{ $campaignCount->age_max}} ans.
                    @endif
                </p>


                @if($campaignCount->location_type === 'address')
                <p>
                    Autour de {{ $campaignCount->location_address }} {{ $campaignCount->location_postcode }} dans un rayon de {{ $campaignCount->location_address_proximity }} km.
                </p>
                @else
                    @if($campaignCount->departments()->count())
                        <p class="">Sur les départements suivants :</p>
                        <table class="table table-sm">
                            <thead>
                                <tr>
                                    <th scope="col">Départements</th>
                                    <th scope="col">Noms</th>
                                    <th scope="col">Volumes proposés</th>
                                    @if($campaignCount->is_split_volume)
                                    <th scope="col">Volumes demandés</th>
                                    @endif
                                </tr>
                            </thead>
                            <tbody>

                            @foreach($campaignCount->departments->unique('code') as $department)
                            <tr>
                                <td>{{ $department->code }}</td>
                                <td>{{ $department->name }}</td>
                                <td>{{ $department->pivot->count}}</td>
                                @if($campaignCount->is_split_volume)
                                <td>{{ $department->pivot->volume}}</td>
                                @endif
                            </tr>
                            @endforeach
                            </tbody>
                        </table>
                    @endif

                    @if($campaignCount->postcodes()->count())
                        <p class="">Sur les villes suivantes @if($campaignCount->location_proximity) dans un rayon de {{ $campaignCount->location_proximity }} km. @endif:</p>
                        <table class="table table-sm">
                            <thead>
                                <tr>
                                    <th scope="col">Codes postaux</th>
                                    <th scope="col">Communes</th>
                                    @if($campaignCount->is_split_volume)
                                    <th scope="col">Volumes proposés</th>
                                    <th scope="col">Volumes demandés</th>
                                    @endif
                                </tr>
                            </thead>
                            <tbody>

                            @foreach($campaignCount->postcodes->unique('postcode') as $postcode)
                            <tr>
                                <td>{{ $postcode->postcode}}</td>
                                <td>{{ implode(', ',$postcode->getCitiesNames($campaignCount->getExcludedPostcodeIds())) }}</td>
                                @if($campaignCount->is_split_volume)
                                <td>{{ $postcode->pivot->count}}</td>
                                <td>{{ $postcode->pivot->volume}}</td>
                                @endif
                            </tr>
                            @endforeach
                            </tbody>
                        </table>
                    @endif

                    @if($campaignCount->insees()->count())
                        <p class="">Sur les codes INSEE suivants @if($campaignCount->location_proximity) dans un rayon de {{ $campaignCount->location_proximity }} km. @endif:</p>

                        <table class="table table-sm">
                            <thead>
                                <tr>
                                    <th scope="col">Codes INSEE</th>
                                    <th scope="col">Noms</th>
                                    <th scope="col">Volumes proposés</th>
                                    @if($campaignCount->is_split_volume)
                                    <th scope="col">Volumes demandés</th>
                                    @endif
                                </tr>
                            </thead>
                            <tbody>

                            @foreach($campaignCount->insees->unique('insee') as $insee)
                            <tr>
                                <td>{{ $insee->insee}}</td>
                                <td>{{ implode(', ',$insee->getInseeCitiesNames()) }}</td>
                                <td>{{ $insee->pivot->count}}</td>
                                @if($campaignCount->is_split_volume)
                                <td>{{ $insee->pivot->volume}}</td>
                                @endif
                            </tr>
                            @endforeach
                            </tbody>
                        </table>
                    @endif

                    @if($campaignCount->irises()->count())
                        <p class="">Sur les codes IRIS suivants:</p>

                        <table class="table table-sm">
                            <thead>
                                <tr>
                                    <th scope="col">Codes IRIS</th>
                                    <th scope="col">Noms</th>
                                    <th scope="col">Volumes proposés</th>
                                    @if($campaignCount->is_split_volume)
                                    <th scope="col">Volumes demandés</th>
                                    @endif
                                </tr>
                            </thead>
                            <tbody>

                            @foreach($campaignCount->irises->unique('iris') as $iris)
                            <tr>
                                <td>{{ $iris->iris}}</td>
                                <td>{{ $iris->name }}</td>
                                <td>{{ $iris->pivot->count}}</td>
                                @if($campaignCount->is_split_volume)
                                <td>{{ $iris->pivot->volume}}</td>
                                @endif
                            </tr>
                            @endforeach
                            </tbody>
                        </table>
                    @endif

                    @if($campaignCount->shops()->count())
                        <p class="">Autour des adresses suivantes dans un rayon de {{$campaignCount->location_proximity }} km :</p>

                        <table class="table table-sm">
                            <thead>
                                <tr>
                                    <th scope="col">Label</th>
                                    <th scope="col">Adresse</th>
                                    <th scope="col">Volumes proposés</th>
                                    @if($campaignCount->is_split_volume)
                                    <th scope="col">Volumes demandés</th>
                                    @endif
                                </tr>
                            </thead>
                            <tbody>

                            @foreach($campaignCount->shops as $shop)
                            <tr>
                                <td>{{ $shop->label}}</td>
                                <td>{{ $shop->address }}</td>
                                <td>{{ $shop->count}}</td>
                                @if($campaignCount->is_split_volume)
                                <td>{{ $shop->volume}}</td>
                                @endif
                            </tr>
                            @endforeach
                            </tbody>
                        </table>
                    @endif


                    @if($campaignCount->regions()->count())
                        <p class="">Sur les régions suivantes :</p>
                        <table class="table table-sm">
                            <thead>
                                <tr>
                                    <th scope="col">Région</th>
                                    <th scope="col">Volumes proposés</th>
                                    @if($campaignCount->is_split_volume)
                                    <th scope="col">Volumes demandés</th>
                                    @endif
                                </tr>
                            </thead>
                            <tbody>

                            @foreach($campaignCount->regions as $region)
                            <tr>
                                <td>{{ $region->name }}</td>
                                <td>{{ $region->pivot->count}}</td>
                                @if($campaignCount->is_split_volume)
                                <td>{{ $region->pivot->volume}}</td>
                                @endif
                            </tr>
                            @endforeach
                            </tbody>
                        </table>
                    @endif

                    @if($campaignCount->cities()->count())
                        <p class="">Sur les communes suivantes @if($campaignCount->location_proximity) dans un rayon de {{ $campaignCount->location_proximity }} km. @endif:</p>

                        <table class="table table-sm">
                            <thead>
                                <tr>
                                    <th scope="col">Codes postaux</th>
                                    <th scope="col">Communes</th>
                                    <th scope="col">Volumes proposés</th>
                                    @if($campaignCount->is_split_volume)
                                    <th scope="col">Volumes demandés</th>
                                    @endif
                                </tr>
                            </thead>
                            <tbody>

                            @foreach($campaignCount->cities as $city)
                            <tr>
                                <td>{{ $city->postcode}}</td>
                                <td>{{ $city->name }}</td>
                                <td>{{ $city->pivot->count}}</td>
                                @if($campaignCount->is_split_volume)
                                <td>{{ $city->pivot->volume}}</td>
                                @endif
                            </tr>
                            @endforeach
                            </tbody>
                        </table>
                    @endif



                    @if(!$campaignCount->postcodes()->count() && !$campaignCount->departments()->count() && !$campaignCount->insees()->count() && !$campaignCount->irises()->count() && !$campaignCount->shops()->count() && !$campaignCount->regions()->count() && !$campaignCount->cities()->count())
                        <p>Sur toute la France,</p>
                    @endif
                @endif

                @if($campaignCount->interestGroups()->where('operator', 'AND')->count())
                    <p>Ayant pour centres d'intérêts :</p>
                    <ul>
                        @foreach($campaignCount->interestGroups()->where('operator', 'AND')->get() as $interestGroup)
                            <li>{{ $interestGroup->label }}</li>
                        @endforeach
                    </ul>
                @endif

                @if($campaignCount->interestGroups()->where('operator', 'OR')->count())
                    <p>Ou ayant pour centre d'intérêt :</p>
                    <ul>
                        @foreach($campaignCount->interestGroups()->where('operator', 'OR')->get() as $interestGroup)
                            <li>{{ $interestGroup->label }}</li>
                        @endforeach
                    </ul>
                @endif

                @if($campaignCount->interestGroups()->where('operator', 'AND NOT')->count())
                    <p>N'ayant pas pour centres d'intérêts :</p>
                    <ul>
                        @foreach($campaignCount->interestGroups()->where('operator', 'AND NOT')->get() as $interestGroup)
                            <li>{{ $interestGroup->label }}</li>
                        @endforeach
                    </ul>
                @endif


                @if(Auth::user()->hasRole('admin') || Auth::user()->hasRole('alpha') || Auth::user()->hasRole('alpha_tester'))
                <p class="font-weight-bold">Requête :</p>
                <pre style="white-space:pre-wrap;"><code>{{ $sqlRequest }}</code></pre>
                @endif
            </div>
        </div>
    </div>
</div>
@endsection