@extends('layouts.app', [
    'navClass' => 'navbar-light bg-secondary',
    'parentSection' => 'laravel',
    'elementName' => 'client-management'
])

@section('title', 'Viagens |')
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.1.1/css/all.min.css" integrity="sha512-KfkfwYDsLkIlwQp6LFnl8zNdLGxu9YAA1QvwINks4PhcElQSvqcyVLLD9aMhXd13uQjoXtEKNosOWaZqXgel0g==" crossorigin="anonymous" referrerpolicy="no-referrer" />

@section('content')
    @component('layouts.headers.auth')
        @component('layouts.headers.breadcrumbs')
            @slot('title')
                Viagens
            @endslot

            <li class="breadcrumb-item"><a class="text-default" href="{{ route('trips.index') }}">Minhas Viagens</a></li>
        @endcomponent
    @endcomponent

    <div class="container-fluid mt--6">
        <div class="row">
            <div class="col">
                <div class="card">
                    <div class="card-header">
                        <div class="row align-items-center">
                            <div class="col-8">
                                <h3 class="mb-0">Lista de Viagens</h3>
                                <p class="text-sm mb-0">
                                        Abaixo você encontra os Viagens cadastradas no TravelTogether
                                    </p>
                            </div>
                            <div class="col-4 text-right">
                                <a href="{{ route('trips.create') }}" class="btn btn-sm btn-primary">Nova Viagem</a>
                            </div>
                        </div>
                    </div>

                    <div class="col-12 mt-2">
                        @include('alerts.success')
                        @include('alerts.errors')
                    </div>

                    {{-- Filters --}}
                    <div class="ml-4 mr-4" style="background-color: #F2F3F9;border-radius:10px">
                        <p class="form-control-label mb-0 ml-4 mt-4" for="input-name">Filtros</p>
                        <form action="{{ route('tripsfilter') }}" method="POST" autocomplete="off"
                            enctype="multipart/form-data">
                            @csrf
                            {{-- 1 --}}
                            <div class="row text-sm mb-0 ml-2 mr-2" id="row1" style="vertical-align:middle;align-items:center">
                                <div class="col-4 mt-2 text-sm mb-0">
                                    <select name="filter1" id="filter1" value="{{ old('filter1') }}" class="form-control" @error('filter1') is-invalid @enderror>
                                        <option value=""> -- Selecione --</option>
                                        <option value="ID" {{ (Request::old("filter1") == "ID" ? "selected":"") }} >ID</option>
                                        <option value="Nome" {{ (Request::old("filter1") == "Nome" ? "selected":"") }}>Nome</option>
                                        <option value="Cliente" {{ (Request::old("filter1") == "Cliente" ? "selected":"") }}>Cliente</option>
                                        <option value="Início" {{ (Request::old("filter1") == "Início" ? "selected":"") }}>Início</option>
                                        <option value="Fim" {{ (Request::old("filter1") == "Fim" ? "selected":"") }}>Fim</option>
                                    </select>
                                </div>
                                <div class="col-3 mt-2 text-sm mb-0">
                                    <select name="middle1" id="middle1" value="{{ old('middle1') }}" class="form-control" @error('middle1') is-invalid @enderror>
                                        @if (Request::old("middle1") == "=")
                                            <option value="=" selected>É igual</option>
                                        @elseif (Request::old("middle1") == "<>")
                                            <option value="<>" selected>Não é igual</option>
                                        @elseif (Request::old("middle1") == ">")
                                            <option value=">" selected>É maior que</option>
                                        @elseif (Request::old("middle1") == "<")
                                            <option value="<" selected>É menor que</option>
                                        @elseif (Request::old("middle1") == "LIKE")
                                            <option value="LIKE" selected>É igual</option>
                                        @elseif (Request::old("middle1") == "not LIKE")
                                            <option value="not LIKE" selected>Não é igual</option>
                                        @endif
                                    </select>
                                </div>
                                <div class="col-5 mt-2 text-sm mb-0">
                                    <input name="result1" type="text" required id="result1" value="{{ old('result1') }}" class="form-control" @error('result1') is-invalid @enderror>
                                </div>
                            </div>
                            {{-- 2 --}}
                            <div class="row text-sm mb-0 ml-2 mr-2" id="row2" style="vertical-align:middle;align-items:center;{{ (Request::old("filter2") != null ? "selected":"") }}display:none">
                                <div class="col-4 mt-2 text-sm mb-0">
                                    <select name="filter2" id="filter2" value="{{old('filter2')}}" class="form-control" @error('filter2') is-invalid @enderror>
                                        <option value=""> -- Selecione --</option>
                                        <option value="ID" {{ (Request::old("filter2") == "ID" ? "selected":"") }} >ID</option>
                                        <option value="Nome" {{ (Request::old("filter2") == "Nome" ? "selected":"") }}>Nome</option>
                                        <option value="Cliente" {{ (Request::old("filter2") == "Cliente" ? "selected":"") }}>Cliente</option>
                                        <option value="Início" {{ (Request::old("filter2") == "Início" ? "selected":"") }}>Início</option>
                                        <option value="Fim" {{ (Request::old("filter2") == "Fim" ? "selected":"") }}>Fim</option>
                                    </select>
                                </div>
                                <div class="col-3 mt-2 text-sm mb-0">
                                    <select name="middle2" id="middle2" value="{{old('middle2')}}" class="form-control" @error('middle2') is-invalid @enderror>
                                        @if (Request::old("middle2") == "=")
                                            <option value="=" selected>É igual</option>
                                        @elseif (Request::old("middle2") == "<>")
                                            <option value="<>" selected>Não é igual</option>
                                        @elseif (Request::old("middle2") == ">")
                                            <option value=">" selected>É maior que</option>
                                        @elseif (Request::old("middle2") == "<")
                                            <option value="<" selected>É menor que</option>
                                        @elseif (Request::old("middle2") == "LIKE")
                                            <option value="LIKE" selected>É igual</option>
                                        @elseif (Request::old("middle2") == "not LIKE")
                                            <option value="not LIKE" selected>Não é igual</option>
                                        @endif
                                    </select>
                                </div>
                                <div class="col-5 mt-2 text-sm mb-0">
                                    <input name="result2" type="text" id="result2" value="{{old('result2')}}" class="form-control" @error('result2') is-invalid @enderror>
                                </div>
                            </div>
                            {{-- 3 --}}
                            <div class="row text-sm mb-0 ml-2 mr-2" id="row3" style="vertical-align:middle;align-items:center;{{ (Request::old("filter3") != null ? "selected":"") }}display:none">
                                <div class="col-4 mt-2 text-sm mb-0">
                                    <select name="filter3" id="filter3" value="{{old('filter3')}}" class="form-control" @error('filter3') is-invalid @enderror>
                                        <option value=""> -- Selecione --</option>
                                        <option value="ID" {{ (Request::old("filter3") == "ID" ? "selected":"") }} >ID</option>
                                        <option value="Nome" {{ (Request::old("filter3") == "Nome" ? "selected":"") }}>Nome</option>
                                        <option value="Cliente" {{ (Request::old("filter3") == "Cliente" ? "selected":"") }}>Cliente</option>
                                        <option value="Início" {{ (Request::old("filter3") == "Início" ? "selected":"") }}>Início</option>
                                        <option value="Fim" {{ (Request::old("filter3") == "Fim" ? "selected":"") }}>Fim</option>
                                    </select>
                                </div>
                                <div class="col-3 mt-2 text-sm mb-0">
                                    <select name="middle3" id="middle3" value="{{old('middle3')}}" class="form-control" @error('middle3') is-invalid @enderror>
                                        @if (Request::old("middle3") == "=")
                                            <option value="=" selected>É igual</option>
                                        @elseif (Request::old("middle3") == "<>")
                                            <option value="<>" selected>Não é igual</option>
                                        @elseif (Request::old("middle3") == ">")
                                            <option value=">" selected>É maior que</option>
                                        @elseif (Request::old("middle3") == "<")
                                            <option value="<" selected>É menor que</option>
                                        @elseif (Request::old("middle3") == "LIKE")
                                            <option value="LIKE" selected>É igual</option>
                                        @elseif (Request::old("middle3") == "not LIKE")
                                            <option value="not LIKE" selected>Não é igual</option>
                                        @endif
                                    </select>
                                </div>
                                <div class="col-5 mt-2 text-sm mb-0">
                                    <input name="result3" type="text" id="result3" value="{{old('result3')}}" class="form-control" @error('result3') is-invalid @enderror>
                                </div>
                            </div>
                            {{-- 4 --}}
                            <div class="row text-sm mb-0 ml-2 mr-2" id="row4" style="vertical-align:middle;align-items:center;{{ (Request::old("filter4") != null ? "selected":"") }}display:none">
                                <div class="col-4 mt-2 text-sm mb-0">
                                    <select name="filter4" id="filter4" value="{{old('filter4')}}" class="form-control" @error('filter4') is-invalid @enderror>
                                        <option value=""> -- Selecione --</option>
                                        <option value="ID" {{ (Request::old("filter4") == "ID" ? "selected":"") }} >ID</option>
                                        <option value="Nome" {{ (Request::old("filter4") == "Nome" ? "selected":"") }}>Nome</option>
                                        <option value="Cliente" {{ (Request::old("filter4") == "Cliente" ? "selected":"") }}>Cliente</option>
                                        <option value="Início" {{ (Request::old("filter4") == "Início" ? "selected":"") }}>Início</option>
                                        <option value="Fim" {{ (Request::old("filter4") == "Fim" ? "selected":"") }}>Fim</option>
                                    </select>
                                </div>
                                <div class="col-3 mt-2 text-sm mb-0">
                                    <select name="middle4" id="middle4" value="{{old('middle4')}}" class="form-control" @error('middle4') is-invalid @enderror>
                                        @if (Request::old("middle4") == "=")
                                            <option value="=" selected>É igual</option>
                                        @elseif (Request::old("middle4") == "<>")
                                            <option value="<>" selected>Não é igual</option>
                                        @elseif (Request::old("middle4") == ">")
                                            <option value=">" selected>É maior que</option>
                                        @elseif (Request::old("middle4") == "<")
                                            <option value="<" selected>É menor que</option>
                                        @elseif (Request::old("middle4") == "LIKE")
                                            <option value="LIKE" selected>É igual</option>
                                        @elseif (Request::old("middle4") == "not LIKE")
                                            <option value="not LIKE" selected>Não é igual</option>
                                        @endif
                                    </select>
                                </div>
                                <div class="col-5 mt-2 text-sm mb-0">
                                    <input name="result4" type="text" id="result4" value="{{old('result4')}}" class="form-control" @error('result4') is-invalid @enderror>
                                </div>
                            </div>
                            {{-- 5 --}}
                            <div class="row text-sm mb-0 ml-2 mr-2" id="row5" style="vertical-align:middle;align-items:center;{{ (Request::old("filter5") != null ? "selected":"") }}display:none">
                                <div class="col-4 mt-2 text-sm mb-0">
                                    <select name="filter5" id="filter5" value="{{old('filter5')}}" class="form-control" @error('filter5') is-invalid @enderror>
                                        <option value=""> -- Selecione --</option>
                                        <option value="ID" {{ (Request::old("filter5") == "ID" ? "selected":"") }} >ID</option>
                                        <option value="Nome" {{ (Request::old("filter5") == "Nome" ? "selected":"") }}>Nome</option>
                                        <option value="Cliente" {{ (Request::old("filter5") == "Cliente" ? "selected":"") }}>Cliente</option>
                                        <option value="Início" {{ (Request::old("filter5") == "Início" ? "selected":"") }}>Início</option>
                                        <option value="Fim" {{ (Request::old("filter5") == "Fim" ? "selected":"") }}>Fim</option>
                                    </select>
                                </div>
                                <div class="col-3 mt-2 text-sm mb-0">
                                    <select name="middle5" id="middle5" value="{{old('middle5')}}" class="form-control" @error('middle5') is-invalid @enderror>
                                        @if (Request::old("middle5") == "=")
                                            <option value="=" selected>É igual</option>
                                        @elseif (Request::old("middle5") == "<>")
                                            <option value="<>" selected>Não é igual</option>
                                        @elseif (Request::old("middle5") == ">")
                                            <option value=">" selected>É maior que</option>
                                        @elseif (Request::old("middle5") == "<")
                                            <option value="<" selected>É menor que</option>
                                        @elseif (Request::old("middle5") == "LIKE")
                                            <option value="LIKE" selected>É igual</option>
                                        @elseif (Request::old("middle5") == "not LIKE")
                                            <option value="not LIKE" selected>Não é igual</option>
                                        @endif
                                    </select>
                                </div>
                                <div class="col-5 mt-2 text-sm mb-0">
                                    <input name="result5" type="text" id="result5" value="{{old('result5')}}" class="form-control" @error('result5') is-invalid @enderror>
                                </div>
                            </div>
                            {{-- 6 --}}
                            <div class="row text-sm mb-0 ml-2 mr-2" id="row6" style="vertical-align:middle;align-items:center;{{ (Request::old("filter6") != null ? "selected":"") }}display:none">
                                <div class="col-4 mt-2 text-sm mb-0">
                                    <select name="filter6" id="filter6" value="{{old('filter6')}}" class="form-control" @error('filter6') is-invalid @enderror>
                                        <option value=""> -- Selecione --</option>
                                        <option value="ID" {{ (Request::old("filter6") == "ID" ? "selected":"") }} >ID</option>
                                        <option value="Nome" {{ (Request::old("filter6") == "Nome" ? "selected":"") }}>Nome</option>
                                        <option value="Cliente" {{ (Request::old("filter6") == "Cliente" ? "selected":"") }}>Cliente</option>
                                        <option value="Início" {{ (Request::old("filter6") == "Início" ? "selected":"") }}>Início</option>
                                        <option value="Fim" {{ (Request::old("filter6") == "Fim" ? "selected":"") }}>Fim</option>
                                    </select>
                                </div>
                                <div class="col-3 mt-2 text-sm mb-0">
                                    <select name="middle6" id="middle6" value="{{old('middle6')}}" class="form-control" @error('middle6') is-invalid @enderror>
                                        @if (Request::old("middle6") == "=")
                                            <option value="=" selected>É igual</option>
                                        @elseif (Request::old("middle6") == "<>")
                                            <option value="<>" selected>Não é igual</option>
                                        @elseif (Request::old("middle6") == ">")
                                            <option value=">" selected>É maior que</option>
                                        @elseif (Request::old("middle6") == "<")
                                            <option value="<" selected>É menor que</option>
                                        @elseif (Request::old("middle6") == "LIKE")
                                            <option value="LIKE" selected>É igual</option>
                                        @elseif (Request::old("middle6") == "not LIKE")
                                            <option value="not LIKE" selected>Não é igual</option>
                                        @endif
                                    </select>
                                </div>
                                <div class="col-5 mt-2 text-sm mb-0">
                                    <input name="result6" type="text" id="result6" value="{{old('result6')}}" class="form-control" @error('result6') is-invalid @enderror>
                                </div>
                            </div>
                            <br>
                            <div class="row mr-2">
                                <div class="col-md-2 ml-md-auto">
                                    <div class="row">
                                        <div class="col-3 mt-3">
                                            <label class="form-control-label" for="pagina">Mostrar:</label>
                                        </div>
                                        <div class="col-9">
                                            <select class="span form-control" id="pagina" name="pagina">
                                                <option value="0" {{ (Request::old("pagina") == "0" ? "selected":"") }}>Todos</option>
                                                <option value="10" {{ (Request::old("pagina") == "10" ? "selected":"") }}>10</option>
                                                <option value="25" {{ (Request::old("pagina") == "25" ? "selected":"") }}>25</option>
                                                <option value="50" {{ (Request::old("pagina") == "50" ? "selected":"") }}>50</option>
                                            </select>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <br>
                            <div class="controls controls-row">
                                <div class="col-md-1 ml-md-auto mr-0">
                                    <button type="submit" class="btn btn-sm btn-primary" value="Pesquisar" class="btn pull-right"><i class="fas fa-light fa-filter text-bg opacity-10 shadow"></i> Pesquisar</button>
                                </div>
                            </div>
                        </form>
                    </div>
                    <br>
                    <div class="table-responsive py-4" id="users-table">
                        <table class="table align-items-center table-flush"  id="datatable-basic">
                            <thead class="thead-light">
                                <tr>
                                    <th scope="col">ID</th>
                                    <th scope="col">Cliente</th>
                                    <th scope="col">Nome</th>
                                    <th scope="col">Início</th>
                                    <th scope="col">Fim</th>
                                    <th scope="col">Vendas Vinculadas</th>
                                    <th scope="col">Valor Total</th>
                                    <th scope="col" class="text-center">Ações</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $total = 0;
                                @endphp
                                @foreach ($trips as $key => $trip)
                                    <tr>
                                        @php
                                            $total += $value->where('trip_id', '=', $trip->id)->sum('final_price');
                                        @endphp
                                        <td>
                                            <button type="button" class="btn btn-sm btn-primary" data-toggle="modal" data-target="#modal{{ $trip->id }}">{{ $trip->id }}</button>
                                            <div class="modal fade" id="modal{{ $trip->id }}" tabindex="-1" role="dialog" aria-labelledby="modal{{ $trip->id }}" aria-hidden="true">
                                                <div class="modal-dialog modal-lg modal-dialog-centered modal-" role="document">
                                                    <div class="modal-content">
                                                        <div class="modal-header">
                                                            <h3 >Viagem {{ $trip->id }}</h3>
                                                            <button style="float: right;" type="button" class="close" data-dismiss="modal" aria-label="Close">
                                                                <span aria-hidden="true">×</span>
                                                            </button>
                                                        </div>
                                                        <hr width="100%" size="20" style="margin-top: -10px">
                                                        <div class="modal-body" style="margin-top: -30px">
                                                            <h4 class="mb-0">Dados Gerais da Viagem</h4><br>
                                                            <hr width="100%" size="20" style="margin-top: -10px">
                                                            <div class="row">
                                                                <div class="col-3">
                                                                    <label class="form-control-label text-left" for="basic-url">Vendedor</label><br>
                                                                    <p class="text-sm text-left">{{$trip->user}}</p>
                                                                </div>
                                                                <div class="col-3">
                                                                    <label class="form-control-label text-left" for="basic-url">Cliente</label><br>
                                                                    <p class="text-sm">{{ substr($trip->first_name ." ".$trip->last_name,0,30) }}</p>
                                                                </div>
                                                                <div class="col-3">
                                                                    <label class="form-control-label text-left" for="basic-url">Início</label><br>
                                                                    <p class="text-sm">{{ date('d/m/y', strtotime($trip->start_date)) }}</p>
                                                                </div>
                                                                <div class="col-3">
                                                                    <label class="form-control-label text-left" for="basic-url">Fim</label><br>
                                                                    <p class="text-sm">{{ date('d/m/y', strtotime($trip->end_date)) }}</p>
                                                                </div>
                                                            </div>
                                                            <br>
                                                        </div>
                                                        <h4 class="mb-0 ml-4">Vendas</h4><br>
                                                        <hr width="100%" size="20" style="margin-top: -10px">
                                                        @foreach ($trip_sale->where('trip_id','=',$trip->id) as $sales)
                                                          <p>
                                                            <a class="btn btn-primary btn-sm ml-4" href="{{route('sales.show', $sales->sale_id)}}" target="_blank" >
                                                                Venda {{$sales->sale_id}}
                                                            </a>
                                                          </p>
                                                        @endforeach
                                                    </div>
                                                </div>
                                            </div>
                                        </td>
                                        <td>{{ $trip->first_name ." ".$trip->last_name }}</td>
                                        <td>{{ $trip->title }}</td>
                                        <td>{{ date('d/m/Y', strtotime($trip->start_date)) }}</td>
                                        <td>{{ date('d/m/Y', strtotime($trip->end_date)) }}</td>
                                        <td>{{ $trip_sale->where('trip_id', '=', $trip->id)->count() }}</td>
                                        <td>
                                            @if ( $trip_sale->where('trip_id', '=', $trip->id)->count() != 0)
                                                R$ {{ number_format($value->where('trip_id', '=', $trip->id)->sum('final_price'), 2, ",", ".") }}
                                            @else
                                                R$ 0,00
                                            @endif
                                        </td>
                                        <td class="text-center">
                                            <div class="dropdown">
                                                <a class="btn btn-sm btn-icon-only text-light" href="#" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                                    <i class="fas fa-ellipsis-v"></i>
                                                </a>
                                                <div class="dropdown-menu dropdown-menu-right dropdown-menu-arrow">
                                                    <a class="dropdown-item" href="{{ route('trips.edit', $trip->id) }}"><i class="fas fa-pencil text-dark text-sm opacity-10"></i> Editar</a>
                                                    <form action="{{ route('trips.destroy', $trip->id) }}" method="post">
                                                        @csrf
                                                        @method('delete')
                                                        <button type="button" class="dropdown-item" onclick="confirm('Tem certeza que deseja excluir essa viagem?') ? this.parentElement.submit() : ''">
                                                        <i class="fas fa-light fa-trash-can text-dark text-sm opacity-10"></i> Excluir
                                                        </button>
                                                    </form>
                                                </div>
                                            </div>
                                        </td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
        @include('layouts.footers.auth')
    </div>
@endsection

@push('css')
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.1.1/css/all.min.css" integrity="sha512-KfkfwYDsLkIlwQp6LFnl8zNdLGxu9YAA1QvwINks4PhcElQSvqcyVLLD9aMhXd13uQjoXtEKNosOWaZqXgel0g==" crossorigin="anonymous" referrerpolicy="no-referrer" />
    <link rel="stylesheet" href="{{ asset('argon') }}/vendor/datatables.net-bs4/css/dataTables.bootstrap4.min.css">
    <link rel="stylesheet" href="{{ asset('argon') }}/vendor/datatables.net-buttons-bs4/css/buttons.bootstrap4.min.css">
    <link rel="stylesheet" href="{{ asset('argon') }}/vendor/datatables.net-select-bs4/css/select.bootstrap4.min.css">
@endpush

@push('js')
    <script src="{{ asset('argon') }}/vendor/datatables.net/js/jquery.dataTables.min.js"></script>
    <script src="{{ asset('argon') }}/vendor/datatables.net-bs4/js/dataTables.bootstrap4.min.js"></script>
    <script src="{{ asset('argon') }}/vendor/datatables.net-buttons/js/dataTables.buttons.min.js"></script>
    <script src="{{ asset('argon') }}/vendor/datatables.net-buttons-bs4/js/buttons.bootstrap4.min.js"></script>
    <script src="{{ asset('argon') }}/vendor/datatables.net-buttons/js/buttons.html5.min.js"></script>
    <script src="{{ asset('argon') }}/vendor/datatables.net-buttons/js/buttons.flash.min.js"></script>
    <script src="{{ asset('argon') }}/vendor/datatables.net-buttons/js/buttons.print.min.js"></script>
    <script src="{{ asset('argon') }}/vendor/datatables.net-select/js/dataTables.select.min.js"></script>
    <script>
        const decodeUTF8  = (s) => decodeURIComponent(escape(s));
            $.ajaxSetup({
            headers: {
                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
            }
            });
            $('#filter1').on('change',function(){
                let val = $('#filter1').val();
                console.log(val);
                if (val == "ID") {
                    $('#middle1').empty();
                    $('#result1').prop("type", "text");
                    $('#row2').show();
                    $('#middle1').append([
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val == "Cliente") {
                    $('#middle1').empty();
                    $('#result1').prop("type", "text");
                    $('#row2').show();
                    $('#middle1').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val == "Início") {
                    $('#middle1').empty();
                    $('#result1').prop("type", "date");
                    $('#row2').show();
                    $('#middle1').append([
                        `<option value=">">É maior que</option>`,
                        `<option value="<">É menor que</option>`,
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val == "Fim") {
                    $('#middle1').empty();
                    $('#result1').prop("type", "date");
                    $('#row2').show();
                    $('#middle1').append([
                        `<option value=">">É maior que</option>`,
                        `<option value="<">É menor que</option>`,
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val == "Nome") {
                    $('#middle1').empty();
                    $('#result1').prop("type", "text");
                    $('#row2').show();
                    $('#middle1').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,,
                    ]);
                } else {
                    $('#middle1').empty();
                    $('#result1').prop("type", "text");
                }
            });
            $('#filter2').on('change',function(){
                let val2 = $('#filter2').val();
                console.log(val2);
                if (val2 == "ID") {
                    $('#middle2').empty();
                    $('#result2').prop("type", "text");
                    $('#row3').show();
                    $('#middle2').append([
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val2 == "Cliente") {
                    $('#middle2').empty();
                    $('#result2').prop("type", "text");
                    $('#row3').show();
                    $('#middle2').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val2 == "Início") {
                    $('#middle2').empty();
                    $('#result2').prop("type", "date");
                    $('#row3').show();
                    $('#middle2').append([
                        `<option value=">">É maior que</option>`,
                        `<option value="<">É menor que</option>`,
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val2 == "Fim") {
                    $('#middle2').empty();
                    $('#result2').prop("type", "date");
                    $('#row3').show();
                    $('#middle2').append([
                        `<option value=">">É maior que</option>`,
                        `<option value="<">É menor que</option>`,
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val2 == "Nome") {
                    $('#middle2').empty();
                    $('#result2').prop("type", "text");
                    $('#row3').show();
                    $('#middle2').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,,
                    ]);
                } else {
                    $('#middle2').empty();
                    $('#result2').prop("type", "text");
                }
            });
            $('#filter3').on('change',function(){
                let val3 = $('#filter3').val();
                console.log(val3);
                if (val3 == "ID") {
                    $('#middle3').empty();
                    $('#result3').prop("type", "text");
                    $('#row4').show();
                    $('#middle3').append([
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val3 == "Cliente") {
                    $('#middle3').empty();
                    $('#result3').prop("type", "text");
                    $('#row4').show();
                    $('#middle3').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val3 == "Início") {
                    $('#middle3').empty();
                    $('#result3').prop("type", "date");
                    $('#row4').show();
                    $('#middle3').append([
                        `<option value=">">É maior que</option>`,
                        `<option value="<">É menor que</option>`,
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val3 == "Fim") {
                    $('#middle3').empty();
                    $('#result3').prop("type", "date");
                    $('#row4').show();
                    $('#middle3').append([
                        `<option value=">">É maior que</option>`,
                        `<option value="<">É menor que</option>`,
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val3 == "Nome") {
                    $('#middle3').empty();
                    $('#result3').prop("type", "text");
                    $('#row4').show();
                    $('#middle3').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,,
                    ]);
                } else {
                    $('#middle3').empty();
                    $('#result3').prop("type", "text");
                }
            });
            $('#filter4').on('change',function(){
                let val4 = $('#filter4').val();
                console.log(val4);
                if (val4 == "ID") {
                    $('#middle4').empty();
                    $('#result4').prop("type", "text");
                    $('#row5').show();
                    $('#middle4').append([
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val4 == "Cliente") {
                    $('#middle4').empty();
                    $('#result4').prop("type", "text");
                    $('#row5').show();
                    $('#middle4').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val4 == "Início") {
                    $('#middle4').empty();
                    $('#result4').prop("type", "date");
                    $('#row5').show();
                    $('#middle4').append([
                        `<option value=">">É maior que</option>`,
                        `<option value="<">É menor que</option>`,
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val4 == "Fim") {
                    $('#middle4').empty();
                    $('#result4').prop("type", "date");
                    $('#row5').show();
                    $('#middle4').append([
                        `<option value=">">É maior que</option>`,
                        `<option value="<">É menor que</option>`,
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val4 == "Nome") {
                    $('#middle4').empty();
                    $('#result4').prop("type", "text");
                    $('#row5').show();
                    $('#middle4').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,,
                    ]);
                } else {
                    $('#middle4').empty();
                    $('#result4').prop("type", "text");
                }
            });
            $('#filter5').on('change',function(){
                let val5 = $('#filter5').val();
                console.log(val5);
                if (val5 == "ID") {
                    $('#middle5').empty();
                    $('#result5').prop("type", "text");
                    $('#row6').show();
                    $('#middle5').append([
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val5 == "Cliente") {
                    $('#middle5').empty();
                    $('#result5').prop("type", "text");
                    $('#row6').show();
                    $('#middle5').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val5 == "Início") {
                    $('#middle5').empty();
                    $('#result5').prop("type", "date");
                    $('#row6').show();
                    $('#middle5').append([
                        `<option value=">">É maior que</option>`,
                        `<option value="<">É menor que</option>`,
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val5 == "Fim") {
                    $('#middle5').empty();
                    $('#result5').prop("type", "date");
                    $('#row6').show();
                    $('#middle5').append([
                        `<option value=">">É maior que</option>`,
                        `<option value="<">É menor que</option>`,
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val5 == "Nome") {
                    $('#middle5').empty();
                    $('#result5').prop("type", "text");
                    $('#row6').show();
                    $('#middle5').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,,
                    ]);
                } else {
                    $('#middle5').empty();
                    $('#result5').prop("type", "text");
                }
            });
            $('#filter6').on('change',function(){
                let val6 = $('#filter6').val();
                console.log(val6);
                if (val6 == "ID") {
                    $('#middle6').empty();
                    $('#result6').prop("type", "text");
                    $('#row7').show();
                    $('#middle6').append([
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val6 == "Cliente") {
                    $('#middle6').empty();
                    $('#result6').prop("type", "text");
                    $('#row7').show();
                    $('#middle6').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val6 == "Início") {
                    $('#middle6').empty();
                    $('#result6').prop("type", "date");
                    $('#row7').show();
                    $('#middle6').append([
                        `<option value=">">É maior que</option>`,
                        `<option value="<">É menor que</option>`,
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val6 == "Fim") {
                    $('#middle6').empty();
                    $('#result6').prop("type", "date");
                    $('#row7').show();
                    $('#middle6').append([
                        `<option value=">">É maior que</option>`,
                        `<option value="<">É menor que</option>`,
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val6 == "Nome") {
                    $('#middle6').empty();
                    $('#result6').prop("type", "text");
                    $('#row7').show();
                    $('#middle6').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,,
                    ]);
                } else {
                    $('#middle6').empty();
                    $('#result6').prop("type", "text");
                }
            });
    </script>
@endpush