@extends('layouts.squelette')
<!-- ************************************** -->
@section('css_header')

@endsection
<!-- ************************************** -->
@section('titre')
{{ __('Recherche') }}
@endsection
<!-- ************************************** -->
@section('titre_header')
{{ __('Recherche') }}
@endsection

<!-- ************************************** -->
@section('titre_page')
{{ __('Recherche') }}
@endsection
<!-- ************************************** -->
@section('contenu')

<!-- Main content -->
<div class="panel">

    <section class="content">
        <div class="row">

            <!-- /.col -->
            <div class="col-md-12">
                <div class="card card-info">

                    <!-- /.card-header -->
                    <div class="card-body p-100">

                        <H4>{{ __('Travaux / interventions') }}</H4>
                        <b>{{ $interventions->count() }} {{ __('résultats') }}</b>
                        <div class="table-responsive mailbox-messages">
                            <table id="tab_inrterventions" class="table table-hover table-striped" data-order='[[ 1, "asc" ]]'>
                                <thead class="thead-dark">
                                    <tr>
                                        <th>#</th>
                                        <th>{{ __('Site') }}</th>
                                        <th>{{ __('Date création') }}</th>
                                        <th>{{ __('Assignation') }}</th>
                                        <th>{{ __('Date planifiée') }}</th>
                                        <th>{{ __('Date de réalisation') }}</th>
                                        <th>{{ __('Montant HT') }}</th>
                                        <th>{{ __('Titre') }}</th>
                                        <th>{{ __('Etat') }}</th>
                                    </tr>
                                </thead>
                                <tbody class="mediumfont">

                                    @foreach ($interventions as $item)
                                    <tr>
                                        <td>
                                            <a class="btn btn-sm btn-info btn-see btn-xs" href="/interventions/{{ $item->int_id }}/editIntForm"><strong>{{ $item->int_number }}</strong></a>
                                        </td>
                                        <td width="12%">
                                            @if(Session()->get('nb_enseignes')!='1')
                                            <a href="enseignes/{{ $item->sig_id }}/editSig" target="_blank">{{ $item->sig_socialReason }}</a><br>
                                            @endif
                                            <font color="red">{{ $item->sit_code  }}</font>
                                            <a href="site/{{ $item->sit_id }}/editSit" target="_blank">{{ $item->sit_name }}</a>

                                        <td>{{ date('d/m/Y', strtotime($item->int_createdDate))  }}</td>
                                        <td>@if ($item->use_idAssigned!='')
                                            {{ $item->username }}
                                            @else
                                            {{ $item->pro_socialReason }}
                                            @endif
                                        </td>
                                        <td>{{ $item->int_planningDate }}</td>
                                        <td>{{ $item->int_achievementDate }}</td>
                                        <td>{{ $item->int_amountHT }}</td>
                                        <td>{{ $item->int_title }}</td>
                                        <td>{{ $item->sta_nameFr }}</td>
                                    </tr>
                                    @endForeach

                                </tbody>
                            </table>
                            <!-- /.table -->

                            <br><br>
                            <H4>{{ __('Demandes de devis prestataires') }}</H4>
                            <b>{{ $pro_quotes->count() }} {{ __('résultats') }}</b>

                            <div class="table-responsive mailbox-messages">
                                <table id="tab_proquotes" class="table table-hover table-striped" data-order='[[ 1, "asc" ]]'>
                                    <thead class="thead-dark">
                                        <tr>
                                            <th>#</th>
                                            <th>{{ __('Site') }}</th>
                                            <th>{{ __('Etat') }}</th>
                                            <th>{{ __('Prestataire') }}</th>
                                            <th>{{ __('Date de la demande') }}</th>
                                            <th>{{ __('Date de retour réelle') }}</th>
                                            <th>{{ __('Montant HT') }}</th>
                                        </tr>
                                    </thead>
                                    <tbody class="mediumfont">
                                        @foreach ($pro_quotes as $pro_quote)
                                        <tr>
                                            <td>
                                                <a class="btn btn-sm btn-info btn-see" href="/interventions/{{ $pro_quote->int_id }}/editIntProQuo"><strong>{{ $pro_quote->proQuo_number }}</strong></a>
                                            </td>
                                            <td>
                                                @if(Session()->get('nb_enseignes')!='1')
                                                <a href="enseignes/{{ $pro_quote->sig_id }}/editSig" target="_blank">{{ $pro_quote->sig_socialReason }}</a><br>
                                                @endif
                                                <font color="red">{{ $pro_quote->sit_code  }}</font>
                                                <a href="site/{{ $pro_quote->sit_id }}/editSit" target="_blank">{{ $pro_quote->sit_name }}</a>
                                            </td>
                                            <td>{!! $pro_quote->sta_nameFr !!}</td>
                                            <td>{!! $pro_quote->pro_socialReason !!}</td>
                                            <td>{{ $pro_quote->proQuo_requestDate!='' ? date('d/m/Y', strtotime($pro_quote->proQuo_requestDate)) : '' }}</td>
                                            <td>{{ $pro_quote->proQuo_realDateReturn!='' ? date('d/m/Y', strtotime($pro_quote->proQuo_realDateReturn)) : '' }}</td>
                                            <td>{!! $pro_quote->proQuo_amountHT !!}</td>
                                        </tr>
                                        @endForeach

                                    </tbody>
                                </table>
                                <!-- /.table -->

                                <br><br>
                                <H4>{{ __('Commandes prestataires') }}</H4>
                                <b>{{ $pro_requests->count() }} {{ __('résultats') }}</b>

                                <div class="table-responsive mailbox-messages">
                                    <table id="tab_prorequests" class="table table-hover table-striped" data-order='[[ 1, "asc" ]]'>
                                        <thead class="thead-dark">
                                            <tr>
                                                <th>#</th>
                                                <th>{{ __('Site') }}</th>
                                                <th>{{ __('Etat') }}</th>
                                                <th>{{ __('Devis') }}</th>
                                                <th>{{ __('Prestataire') }}</th>
                                                <th>{{ __('Date demande') }}</th>
                                                <th>{{ __('Date planifiée') }}</th>
                                                <th>{{ __('Date réalisation') }}</th>
                                                <th>{{ __('Montant HT') }}</th>

                                            </tr>
                                        </thead>
                                        <tbody class="mediumfont">
                                            @foreach ($pro_requests as $pro_request)
                                            <tr>
                                                <td>
                                                    <a class="btn btn-sm btn-info btn-see" href="/interventions/{{ $pro_request->int_id }}/editIntProReq"><strong>{{ $pro_request->proReq_number }}</strong></a>
                                                </td>
                                                <td>
                                                    @if(Session()->get('nb_enseignes')!='1')
                                                    <a href="enseignes/{{ $pro_request->sig_id }}/editSig" target="_blank">{{ $pro_request->sig_socialReason }}</a><br>
                                                    @endif
                                                    <font color="red">{{ $pro_request->sit_code  }}</font>
                                                    <a href="site/{{ $pro_request->sit_id }}/editSit" target="_blank">{{ $pro_request->sit_name }}</a>
                                                </td>
                                                <td>{!! $pro_request->sta_nameFr !!}</td>
                                                <td>
                                                    @if( $pro_request->proQuo_number!='')
                                                    <a class="btn btn-sm btn-info btn-see" href="/interventions/{{@$intervention->int_id}}/editIntProQuo?proQuo={{ $pro_request->proQuo_id }}">#{{ $pro_request->proQuo_number }}</a>
                                                    @else
                                                    @endif
                                                </td>
                                                <td>{!! $pro_request->pro_socialReason !!}</td>
                                                <td>{{ $pro_request->proReq_requestDate!='' ? date('d/m/Y', strtotime($pro_request->proReq_requestDate)) : '' }}</td>
                                                <td>{{ $pro_request->proReq_planningDate!='' ? date('d/m/Y', strtotime($pro_request->proReq_planningDate)) : '' }}</td>
                                                <td>{{ $pro_request->proReq_achievementDate!='' ? date('d/m/Y', strtotime($pro_request->proReq_achievementDate)) : '' }}</td>
                                                <td>{!! $pro_request->proReq_amountHT !!}</td>
                                            </tr>
                                            @endforeach

                                        </tbody>
                                    </table>


                                    <br><br>
                                    <H4>{{ __('Factures prestataires') }}</H4>
                                    <b>{{ $pro_invoices->count() }} {{ __('résultats') }}</b>

                                    <div class="table-responsive mailbox-messages">
                                        <table id="tab_prorequests" class="table table-hover table-striped" data-order='[[ 1, "asc" ]]'>
                                            <thead class="thead-dark">
                                                <tr>
                                                    <th>#</th>
                                                    <th width="10%">{{ __('Site') }}</th>
                                                    <th width="10%">{{ __('Etat') }}</th>
                                                    <th>{{ __('Prestataire') }}</th>
                                                    <th width="10%">{{ __('Montant HT') }}</th>
                                                    <th width="10%">{{ __('Montant TTC') }}</th>
                                                    <th width="10%">{{ __('Date facture') }}</th>
                                                    <th width="10%">{{ __('Payée') }}</th>
                                                    <th width="10%">{{ __('Date règlement') }}</th>
                                                    <th width="10%">{{ __('Date saisie') }}</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach ($pro_invoices as $pro_invoice)
                                                <tr>
                                                    <td>
                                                        <a class="btn btn-sm btn-info btn-see" href="/interventions/{{ $pro_invoice->int_id }}/editIntProReq"><strong>{{ $pro_invoice->proInv_number }}</strong></a>
                                                    </td>
                                                    <td>
                                                        <font color="red">{{ $pro_invoice->sit_code  }}</font>
                                                        <a href="site/{{ $pro_invoice->sit_id }}/editSit" target="_blank">{{ $pro_invoice->sit_name }}</a>
                                                    </td>
                                                    <td>{!! $pro_invoice->sta_nameFr !!}</td>
                                                    <td>{!! $pro_invoice->pro_socialReason !!}</td>

                                                    <td>{!! $pro_invoice->proInv_amountHT !!}</td>
                                                    <td>{!! $pro_invoice->proInv_amountTTC !!}</td>
                                                    <!--<td>{{ $pro_invoice->proInv_validatedDate!='' ? date('d/m/Y', strtotime($pro_invoice->proInv_validatedDate)) : '' }}</td>-->
                                                    <td>{{ $pro_invoice->proInv_achievementDate!='' ? date('d/m/Y', strtotime($pro_invoice->proInv_achievementDate)) : '' }}</td>
                                                    <td>

                                                        @if( $pro_invoice->proInv_payed=='1')
                                                        <span class="badge badge-success">{{ __('oui') }}</span>
                                                        @else
                                                        <span class="badge badge-danger">{{ __('non') }}</span>
                                                        @endif
                                                    </td>

                                                    <td>{{ $pro_invoice->proInv_paymentDate!='' ? date('d/m/Y', strtotime($pro_invoice->proInv_paymentDate)) : '' }}</td>
                                                    <td>{{ $pro_invoice->proInv_createdDate!='' ? date('d/m/Y', strtotime($pro_invoice->proInv_createdDate)) : '' }}</td>

                                                </tr>
                                                @endforeach

                                            </tbody>
                                        </table>
                                    </div>

                                    <br><br>
                                    <H4>{{ __('Sites') }}</H4>
                                    <b>{{ $sites->count() }} {{ __('résultats') }}</b>

                                    <div class="table-responsive mailbox-messages">
                                        <table id="tab_sites" class="table table-hover table-striped" data-order='[[ 1, "asc" ]]'>
                                            <thead class="thead-dark">
                                                <tr>
                                                    <th width="10%">{{ __('Site') }}</th>
                                                    <th width="10%">{{ __('Code') }}</th>
                                                    <th width="10%">{{ __('Enseigne') }}</th>
                                                    <th width="10%">{{ __('Email') }}</th>
                                                    <th width="10%">{{ __('Adresse') }}</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @foreach ($sites as $site)
                                                <tr>
                                                    <td>
                                                        <a class="btn btn-sm btn-info btn-see" href="/site/{{ $site->sit_id }}/editSit"><strong>{{ $site->sit_name }}</strong></a>
                                                    </td>
                                                    <td>{!! $site->sit_code !!}</td>
                                                    <td>{!! $site->sig_socialReason !!}</td>
                                                    <td><a href="mailto:{!! $site->sit_email !!}">{!! $site->sit_email !!}</a></td>
                                                    <td>{!! $site->sit_formattedAddress !!}</td>

                                                </tr>
                                                @endforeach

                                            </tbody>
                                        </table>
                                    </div>
                                    <!-- /.mail-box-messages -->
                                </div>
                                <!-- /.card-body -->

                            </div>
                            <!-- /.card -->
                        </div>
                        <!-- /.col -->
                    </div>
                    <!-- /.row -->
    </section>
    <!-- /.content -->
</div>

@endsection

@section('js_footer')
<script src="{{ asset('js/activites_list.js')}}"></script>
@endsection

@section('modale')


@endsection