@extends('layouts.app')

@section('content')
<section>
    <div class="utitlities-buttons">
        <button class="btn btn-primary btn-utilities-to" id="apa">Apa</button>
        <button class="btn btn-danger btn-utilities-to" id="gaze">Gaze</button>
        <button class="btn btn-warning btn-utilities-to" id="curent">Curent</button>
        <button class="btn btn-success btn-utilities-to" id="salubritate">Salubritate</button>
        <button class="btn btn-info btn-utilities-to" id="intretinere">Intretinere</button>
        <button class="btn btn-lg btn-warning btn-utilities-to" id="tot">Vezi tot</button>
    </div>

    <form class="w-100  mb-2" id="dataTableSearchUtilities" action="/vezi-utilitati-introduse" method="GET">
        <div class="d-flex">
            <label class="d-flex flex-column w-100">
                Alege agentie
                <select name="agency" id="agencySearchUtilities" class="form-control w-100">
                    <option value="">Alege agentie</option>
                    @foreach ($branches as $branch)
                    <option value="{{ $branch->branch }}"> {{ $branch->name }} </option>
                    @endforeach
                </select>
            </label>

            <label class="d-flex flex-column w-100">
                Perioada trans start
                <input type="date" class="form-control" name="data_start">
            </label>

            <label class="d-flex flex-column w-100">
                Perioada trans sfarsit
                <input type="date" class="form-control" name="data_end">
            </label>
        </div>
        <button type="submit" class="btn btn-success mt-2">Cauta</button>
    </form>
    <form class="w-100  mb-2" action="/genereaza-excel-utilitati-introduse" method="GET">
        <p>Genereaza excel</p>
        <input type="hidden" id="valueOfFilter" name="filter">
        <div class="d-flex">
            <label class="d-flex flex-column w-100">
                Alege agentie
                <select name="agency" id="agencySearchUtilities" class="form-control w-100">
                    <option value="">Alege agentie</option>
                    @foreach ($branches as $branch)
                    <option value="{{ $branch->branch }}"> {{ $branch->name }} </option>
                    @endforeach
                </select>
            </label>

            <label class="d-flex flex-column w-100">
                Perioada trans start
                <input type="date" class="form-control" name="data_start_excel">
            </label>

            <label class="d-flex flex-column w-100">
                Perioada trans sfarsit
                <input type="date" class="form-control" name="data_end_end">
            </label>
        </div>
        <button type="submit" class="btn btn-info mt-2">Genereaza excel</button>
    </form>
    <div class="table-responsive">
        <table class="table table-responsive table-dark">
            <thead>
                <tr class="text-center">
                    <th scope="col">Agentie</th>
                    <th scope="col">Perioada introducere</th>
                    <th scope="col" class="apa">Index apa rece</th>
                    <th scope="col" class="apa">Index apa calda</th>
                    <th scope="col" class="apa">Citire apa</th>
                    <th scope="col" class="apa">Poze apa</th>
                    <th scope="col" class="gaze">Index Gaze</th>
                    <th scope="col" class="gaze">Estimat?</th>
                    <th scope="col" class="gaze">Data citire index gaze</th>
                    <th scope="col" class="gaze">Data citire gaze</th>
                    <th scope="col" class="gaze">Poze gaz</th>
                    <th scope="col" class="curent">Contor principal electricitate</th>
                    <th scope="col" class="curent">Contor pasant electricitate</th>
                    <th scope="col" class="curent">Estimat?</th>
                    <th scope="col" class="curent">Data transmitere index electricitate</th>
                    <th scope="col" class="curent">Data citire electricitate</th>
                    <th scope="col" class="curent">Poze electricitate</th>
                    <th scope="col" class="salubritate">Salubrizare suma lunara</th>
                    <th scope="col" class="salubritate">Luna salubrizare</th>
                    <th scope="col" class="salubritate">Data citire salubrizare</th>
                    <th scope="col" class="salubritate">Companie care plateste salubrizare</th>
                    <th scope="col" class="intretinere">Suma intretinere lunar</th>
                    <th scope="col" class="intretinere">Luna pentru intretinere</th>
                    <th scope="col" class="intretinere">Data citire intretinere</th>
                    <th scope="col" class="intretinere">Compania ce plateste intretinerea</th>
                </tr>
            </thead>
            <tbody>
                @foreach ($indexes as $index)
                @php
                $branch = App\Models\Branch::where('branch',$index->branch_id)->first();
                if($index->water_id) {
                $waterPhotos = App\Models\UtilityImage::where('water_utility_id',$index->water_id)->get();
                }else {
                $waterPhotos = [];
                }

                if($index->electricity_id) {
                $electricityPhotos =
                App\Models\UtilityImage::where('electricity_utility_id',$index->electricity_id)->get();
                } else {
                $electricityPhotos = [];
                }

                if($index->electricity_id) {
                $gasPhotos = App\Models\UtilityImage::where('gas_utility_id',$index->gas_id)->get();
                } else {
                $gasPhotos = [];
                }
                @endphp
                <tr class="text-center">
                    <th scope="row"> @if($branch) {{ $branch->name }} @else Nu am gasit agentia @endif </th>
                    <td> {{ Carbon\Carbon::parse($index->start_date)->format('d-m-Y') }} -
                        {{ Carbon\Carbon::parse($index->end_date)->format('d-m-Y') }} </td>
                    <td class="apa"> {{ $index->cold_water_index }} </td>
                    <td class="apa"> {{ $index->warm_water_index }} </td>
                    <td class="apa"> {{ Carbon\Carbon::parse($index->water_reading_date)->format('d-m-Y') }} </td>
                    <td class="apa"><button class="btn btn btn-info" data-bs-toggle="modal"
                            data-bs-target="#showPozeApa{{ $index->water_id }}">Poze apa</button></td>
                    <td class="gaze"> {{ $index->gas_index }} </td>
                    <td class="gaze"> @if($index->gas_estimated == 1) Citit @elseif($index->gas_estimated == 0) Estimat @else - @endif </td>
                    <td class="gaze">
                        {{ Carbon\Carbon::parse($index->gas_start_index_transmission_period)->format('d-m-Y') }} -
                        {{ Carbon\Carbon::parse($index->gas_end_index_transmission_period)->format('d-m-Y') }} </td>
                    <td class="gaze"> {{ Carbon\Carbon::parse($index->gas_reading_date)->format('d-m-Y') }} </td>
                    <td class="gaze"><button class="btn btn btn-info" data-bs-toggle="modal"
                            data-bs-target="#showPozeGaz{{ $index->gas_id }}">Poze gaz</button></td>
                    <td class="curent"> {{ $index->electricity_index_contor_principal }} </td>
                    <td class="curent"> {{ $index->electricity_index_contor_pasant }} </td>
                    <td class="curent"> @if($index->electricity_estimated == 1) Citit @elseif($index->electricity_estimated == 0) Estimat @else - @endif </td>
                    <td class="curent">
                        {{ Carbon\Carbon::parse($index->electricity_start_index_transmission_period)->format('d-m-Y') }}
                        - {{ Carbon\Carbon::parse($index->electricity_end_index_transmission_period)->format('d-m-Y') }}
                    </td>
                    <td class="curent"> {{ Carbon\Carbon::parse($index->electricity_reading_date)->format('d-m-Y') }}
                    </td>
                    <td class="curent"><button class="btn btn btn-info" data-bs-toggle="modal"
                            data-bs-target="#showPozeElectricity{{ $index->electricity_id }}">Poze
                            electricitate</button></td>
                    <td class="salubritate"> {{ $index->sanitation_monthly_sum }} </td>
                    <td class="salubritate"> {{ $index->sanitation_month }} </td>
                    <td class="salubritate">@if($index->sanitation_reading_date)
                        {{ Carbon\Carbon::parse($index->sanitation_reading_date)->format('d-m-Y') }} @endif </td>
                    <td class="salubritate"> {{ $index->sanitation_company }} </td>
                    <td class="intretinere"> {{ $index->maintanance_monthly_sum }} </td>
                    <td class="intretinere"> {{ $index->maintanance_month }} </td>
                    <td class="intretinere">@if($index->maintanance_reading_date)
                        {{ Carbon\Carbon::parse($index->maintanance_reading_date)->format('d-m-Y') }} @endif</td>
                    <td class="intretinere"> {{ $index->maintanance_company }} </td>
                </tr>

                <div class="modal fade" id="showPozeApa{{ $index->water_id }}" tabindex="-1"
                    aria-labelledby="showPozeApa{{ $index->water_id }}Label" aria-hidden="true">
                    <div class="modal-dialog">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title" id="showPozeApa{{ $index->water_id }}Label">Poze apa din
                                    {{ Carbon\Carbon::parse($index->start_date)->format('d-m-Y') }} -
                                    {{ Carbon\Carbon::parse($index->end_date)->format('d-m-Y') }}</h5>
                                <button type="button" class="close" data-bs-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                            <div class="modal-body">
                                <p>{{ $index->water_description }}</p>
                                @if(count($waterPhotos) >= 0)
                                @foreach ($waterPhotos as $file)
                                <img src="storage/utilities/{{ $file->file }}" alt=""
                                    style="max-width:100%;width:100%;margin-bottom:1rem;">
                                @endforeach
                                @else
                                <p>Nu sunt poze adaugate</p>
                                @endif
                            </div>
                            <div class="modal-footer">
                                <button type="button" class="btn btn-secondary w-100"
                                    data-bs-dismiss="modal">Inchide</button>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="modal fade" id="showPozeGaz{{ $index->gas_id }}" tabindex="-1"
                    aria-labelledby="showPozeGaz{{ $index->gas_id }}Label" aria-hidden="true">
                    <div class="modal-dialog">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title" id="showPozeGaz{{ $index->gas_id }}Label">Poze gaz din
                                    {{ Carbon\Carbon::parse($index->start_date)->format('d-m-Y') }} -
                                    {{ Carbon\Carbon::parse($index->end_date)->format('d-m-Y') }}</h5>
                                <button type="button" class="close" data-bs-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                            <div class="modal-body">
                                <p>{{ $index->gas_description }}</p>
                                @if(count($gasPhotos) >= 0)
                                @foreach ($gasPhotos as $file)
                                <img src="storage/utilities/{{ $file->file }}" alt=""
                                    style="max-width:100%;width:100%;margin-bottom:1rem;">
                                @endforeach
                                @else
                                <p>Nu sunt poze adaugate</p>
                                @endif
                            </div>
                            <div class="modal-footer">
                                <button type="button" class="btn btn-secondary w-100"
                                    data-bs-dismiss="modal">Inchide</button>
                            </div>
                        </div>
                    </div>
                </div>

                <div class="modal fade" id="showPozeElectricity{{ $index->electricity_id }}" tabindex="-1"
                    aria-labelledby="showPozeElectricity{{ $index->electricity_id }}Label" aria-hidden="true">
                    <div class="modal-dialog">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title" id="showPozeElectricity{{ $index->electricity_id }}Label">Poze
                                    apa din {{ Carbon\Carbon::parse($index->start_date)->format('d-m-Y') }} -
                                    {{ Carbon\Carbon::parse($index->end_date)->format('d-m-Y') }}</h5>
                                <button type="button" class="close" data-bs-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                            <div class="modal-body">
                                <p>{{ $index->electricity_description }}</p>
                                @if(count($electricityPhotos) >= 0)
                                @foreach ($electricityPhotos as $file)
                                <img src="storage/utilities/{{ $file->file }}" alt=""
                                    style="max-width:100%;width:100%;margin-bottom:1rem;">
                                @endforeach
                                @else
                                <p>Nu sunt poze adaugate</p>
                                @endif
                            </div>
                            <div class="modal-footer">
                                <button type="button" class="btn btn-secondary w-100"
                                    data-bs-dismiss="modal">Inchide</button>
                            </div>
                        </div>
                    </div>
                </div>
                @endforeach
            </tbody>
        </table>
        {{ $indexes->withQueryString()->links() }}
    </div>
</section>
@endsection

@push('js')


<script>
    $(document).ready(function () {

        $("#agencySearchUtilities").select2({
            'height': '100%',
            'width': 'resolve'
        });
        const savedFilter = localStorage.getItem("selectedFilter");
        const selectedFilter = savedFilter || "apa";
        applyFilter(selectedFilter);
        $(".btn-utilities-to").click(function () {
            const filterValue = $(this).attr("id");
            const url = window.location.href.split('?')[0] + `?filter=${filterValue}`;
            $("#valueOfFilter").val(filterValue);
            window.history.pushState({
                path: url
            }, '', url);
            if (filterValue === "tot") {
                $(".apa, .gaze, .curent, .salubritate, .intretinere").show();
            } else {
                applyFilter(filterValue);
            }
        });

        function applyFilter(filterValue) {
            localStorage.setItem("selectedFilter", filterValue);
            $("#valueOfFilter").val(filterValue);
            $(".apa, .gaze, .curent, .salubritate, .intretinere").hide();
            $(`.${filterValue}`).show();
        }
    });

</script>

@endpush