@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 width="10%">#</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" href="/interventions/{{ $item->int_id }}/editIntForm"><strong>{{ $item->int_number }}</strong></a>
                                        </td>
                                        <td>
                                            @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>
                                        <td>{{ $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 width="10%">#</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/{{@$pro_request->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>{{ __("Site") }}</th>
                                                    <th>{{ __("Etat") }}</th>
                                                    <th>{{ __("Prestataire") }}</th>
                                                    <th>{{ __("Montant HT") }}</th>
                                                    <th>{{ __("Montant TTC") }}</th>
                                                    <th>{{ __("Date facture") }}</th>
                                                    <th>{{ __("Payée") }}</th>
                                                    <th>{{ __("Date règlement") }}</th>
                                                    <th>{{ __("Date saisie") }}</th>
                                                </tr>
                                            </thead>
                                            <tbody class="mediumfont">
                                                @foreach ($pro_invoices as $pro_invoice)
                                                <tr>
                                                    <td>
                                                        <a class="btn btn-sm btn-info btn-see" href="/interventions/{{ $pro_invoice->int_id }}/editIntProInv"><strong>{{ $pro_invoice->proInv_number }}</strong></a>
                                                    </td>
                                                    <td>
                                                        @if(Session()->get('nb_enseignes')!='1')
                                                        <a href="enseignes/{{ $pro_invoice->sig_id }}/editSig" target="_blank">{{ $pro_invoice->sig_socialReason }}</a><br>
                                                        @endif
                                                        <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>
                                                        <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>
                                    <!-- /.mail-box-messages -->
                                </div>

                                <br><br>
                                <H4>{{ __("Devis clients") }}</H4>
                                <b>{{ $cus_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 width="10%">#</th>
                                                <th>{{ __("Site") }}</th>
                                                <th>{{ __("Etat") }}</th>
                                                <th>{{ __("Client") }}</th>
                                                <th>{{ __("Date de la demande") }}</th>
                                                <th>{{ __("Date de retour réelle") }}</th>
                                                <th>{{ __("Montant HT") }}</th>
                                            </tr>
                                        </thead>
                                        <tbody class="mediumfont">
                                            @foreach ($cus_quotes as $cus_quote)
                                            <tr>
                                                <td>
                                                    <a class="btn btn-sm btn-info btn-see" href="/interventions/{{ $cus_quote->int_id }}/editIntCusQuo"><strong>{{ $cus_quote->cusQuo_number }}</strong></a>
                                                </td>
                                                <td>
                                                    @if(Session()->get('nb_enseignes')!='1')
                                                    <a href="enseignes/{{ $cus_quote->sig_id }}/editSig" target="_blank">{{ $cus_quote->sig_socialReason }}</a><br>
                                                    @endif
                                                    <font color="red">{{ $cus_quote->sit_code  }}</font>
                                                    <a href="site/{{ $cus_quote->sit_id }}/editSit" target="_blank">{{ $cus_quote->sit_name }}</a>
                                                </td>
                                                <td>{!! $cus_quote->sta_nameFr !!}</td>
                                                <td>{!! $cus_quote->cus_socialReason !!}</td>
                                                <td>{{ $cus_quote->cusQuo_createdDate!='' ? date('d/m/Y', strtotime($cus_quote->cusQuo_createdDate)) : '' }}</td>
                                                <td>{{ $cus_quote->cusQuo_replyDate!='' ? date('d/m/Y', strtotime($cus_quote->cusQuo_replyDate)) : '' }}</td>
                                                <td>{!! $cus_quote->cusQuo_amountHT !!}</td>
                                            </tr>
                                            @endForeach

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


                                <br><br>
                                <H4>{{ __("Factures clients") }}</H4>
                                <b>{{ $cus_invoices->count() }} {{ __("résultats") }}</b>

                                <div class="table-responsive mailbox-messages">
                                    <table id="tab_cusrequests" class="table table-hover table-striped" data-order='[[ 1, "asc" ]]'>
                                        <thead class="thead-dark">
                                            <tr>
                                                <th>#</th>
                                                <th>{{ __("Site") }}</th>
                                                <th>{{ __("Etat") }}</th>
                                                <th>{{ __("Client") }}</th>
                                                <th>{{ __("Montant HT") }}</th>
                                                <th>{{ __("Montant TTC") }}</th>
                                                <th>{{ __("Date facture") }}</th>
                                                <th>{{ __("Payée") }}</th>
                                                <th>{{ __("Date règlement") }}</th>
                                                <th>{{ __("Date saisie") }}</th>
                                            </tr>
                                        </thead>
                                        <tbody class="mediumfont">
                                            @foreach ($cus_invoices as $cus_invoice)
                                            <tr>
                                                <td>
                                                    <a class="btn btn-sm btn-info btn-see" href="/interventions/{{ $cus_invoice->int_id }}/editIntCusInv"><strong>{{ $cus_invoice->cusInv_number }}</strong></a>
                                                </td>
                                                <td>
                                                    @if(Session()->get('nb_enseignes')!='1')
                                                    <a href="enseignes/{{ $cus_invoice->sig_id }}/editSig" target="_blank">{{ $cus_invoice->sig_socialReason }}</a><br>
                                                    @endif
                                                    <font color="red">{{ $cus_invoice->sit_code  }}</font>
                                                    <a href="site/{{ $cus_invoice->sit_id }}/editSit" target="_blank">{{ $cus_invoice->sit_name }}</a>
                                                </td>
                                                {{-- <td>
                                                    <font color="red">{{ $cus_invoice->sit_code  }}</font>
                                                <a href="site/{{ $cus_invoice->sit_id }}/editSit" target="_blank">{{ $cus_invoice->sit_name }}</a>
                                                </td> --}}
                                                <td>{!! $cus_invoice->sta_nameFr !!}</td>
                                                <td>{!! $cus_invoice->cus_socialReason !!}</td>

                                                <td>{!! $cus_invoice->cusInv_amountHT !!}</td>
                                                <td>{!! $cus_invoice->cusInv_amountTTC !!}</td>
                                                <td>{{ $cus_invoice->cusInv_achievementDate!='' ? date('d/m/Y', strtotime($cus_invoice->cusInv_achievementDate)) : '' }}</td>
                                                <td>

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

                                                <td>{{ $cus_invoice->cusInv_paymentDate!='' ? date('d/m/Y', strtotime($cus_invoice->cusInv_paymentDate)) : '' }}</td>
                                                <td>{{ $cus_invoice->cusInv_createdDate!='' ? date('d/m/Y', strtotime($cus_invoice->cusInv_createdDate)) : '' }}</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