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

@section('title', 'Reservas |')
<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')
                Reservas
            @endslot

            <li class="breadcrumb-item"><a class="text-default" href="{{ route('sales.index') }}">Minhas Reservas</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 Reservas</h3>
                                <p class="text-sm mb-0">
                                        Abaixo você encontra as reservas cadastradas no TravelTogether
                                    </p>
                            </div>
                            <div class="col-4 text-right">
                                <a href="{{ route('sales.create') }}" class="btn btn-sm btn-primary">Nova Reserva</a>
                            </div>
                        </div>
                    </div>

                    <div class="col-12 mt-2">
                        @include('alerts.success')
                        @include('alerts.errors')
                    </div>
                    <br>
                    {{-- 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('salesfilter') }}" 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="Usuário" {{ (Request::old("filter1") == "Usuário" ? "selected":"") }}>Usuário</option>
                                        <option value="Cliente" {{ (Request::old("filter1") == "Cliente" ? "selected":"") }}>Cliente</option>
                                        <option value="Data da Venda" {{ (Request::old("filter1") == "Data da Venda" ? "selected":"") }}>Data da Venda</option>
                                        <option value="Fornecedor" {{ (Request::old("filter1") == "Fornecedor" ? "selected":"") }}>Fornecedor</option>
                                        <option value="Prestador" {{ (Request::old("filter1") == "Prestador" ? "selected":"") }}>Prestador</option>
                                        <option value="Produto" {{ (Request::old("filter1") == "Produto" ? "selected":"") }}>Produto</option>
                                        <option value="Status"{{ (Request::old("filter1") == "Status" ? "selected":"") }}>Status</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="Cliente" {{ (Request::old("filter2") == "Cliente" ? "selected":"") }}>Cliente</option>
                                        <option value="Data da Venda" {{ (Request::old("filter2") == "Data da Venda" ? "selected":"") }}>Data da Venda</option>
                                        <option value="Fornecedor" {{ (Request::old("filter2") == "Fornecedor" ? "selected":"") }}>Fornecedor</option>
                                        <option value="Prestador" {{ (Request::old("filter2") == "Prestador" ? "selected":"") }}>Prestador</option>
                                        <option value="Produto" {{ (Request::old("filter2") == "Produto" ? "selected":"") }}>Produto</option>
                                        <option value="Status"{{ (Request::old("filter2") == "Status" ? "selected":"") }}>Status</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="Cliente" {{ (Request::old("filter3") == "Cliente" ? "selected":"") }}>Cliente</option>
                                        <option value="Data da Venda" {{ (Request::old("filter3") == "Data da Venda" ? "selected":"") }}>Data da Venda</option>
                                        <option value="Fornecedor" {{ (Request::old("filter3") == "Fornecedor" ? "selected":"") }}>Fornecedor</option>
                                        <option value="Prestador" {{ (Request::old("filter3") == "Prestador" ? "selected":"") }}>Prestador</option>
                                        <option value="Produto" {{ (Request::old("filter3") == "Produto" ? "selected":"") }}>Produto</option>
                                        <option value="Status"{{ (Request::old("filter3") == "Status" ? "selected":"") }}>Status</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="Cliente" {{ (Request::old("filter4") == "Cliente" ? "selected":"") }}>Cliente</option>
                                        <option value="Data da Venda" {{ (Request::old("filter4") == "Data da Venda" ? "selected":"") }}>Data da Venda</option>
                                        <option value="Fornecedor" {{ (Request::old("filter4") == "Fornecedor" ? "selected":"") }}>Fornecedor</option>
                                        <option value="Prestador" {{ (Request::old("filter4") == "Prestador" ? "selected":"") }}>Prestador</option>
                                        <option value="Produto" {{ (Request::old("filter4") == "Produto" ? "selected":"") }}>Produto</option>
                                        <option value="Status"{{ (Request::old("filter4") == "Status" ? "selected":"") }}>Status</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="Cliente" {{ (Request::old("filter5") == "Cliente" ? "selected":"") }}>Cliente</option>
                                        <option value="Data da Venda" {{ (Request::old("filter5") == "Data da Venda" ? "selected":"") }}>Data da Venda</option>
                                        <option value="Fornecedor" {{ (Request::old("filter5") == "Fornecedor" ? "selected":"") }}>Fornecedor</option>
                                        <option value="Prestador" {{ (Request::old("filter5") == "Prestador" ? "selected":"") }}>Prestador</option>
                                        <option value="Produto" {{ (Request::old("filter5") == "Produto" ? "selected":"") }}>Produto</option>
                                        <option value="Status"{{ (Request::old("filter5") == "Status" ? "selected":"") }}>Status</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="Cliente" {{ (Request::old("filter6") == "Cliente" ? "selected":"") }}>Cliente</option>
                                        <option value="Data da Venda" {{ (Request::old("filter6") == "Data da Venda" ? "selected":"") }}>Data da Venda</option>
                                        <option value="Fornecedor" {{ (Request::old("filter6") == "Fornecedor" ? "selected":"") }}>Fornecedor</option>
                                        <option value="Prestador" {{ (Request::old("filter6") == "Prestador" ? "selected":"") }}>Prestador</option>
                                        <option value="Produto" {{ (Request::old("filter6") == "Produto" ? "selected":"") }}>Produto</option>
                                        <option value="Status"{{ (Request::old("filter6") == "Status" ? "selected":"") }}>Status</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>
                            {{-- 7 --}}
                            <div class="row text-sm mb-0 ml-2 mr-2" id="row7" style="vertical-align:middle;align-items:center;{{ (Request::old("filter7") != null ? "selected":"") }}display:none">
                                <div class="col-4 mt-2 text-sm mb-0">
                                    <select name="filter7" id="filter7" value="{{old('filter7')}}" class="form-control" @error('filter7') is-invalid @enderror>
                                        <option value=""> -- Selecione --</option>
                                        <option value="ID" {{ (Request::old("filter7") == "ID" ? "selected":"") }} >ID</option>
                                        <option value="Cliente" {{ (Request::old("filter7") == "Cliente" ? "selected":"") }}>Cliente</option>
                                        <option value="Data da Venda" {{ (Request::old("filter7") == "Data da Venda" ? "selected":"") }}>Data da Venda</option>
                                        <option value="Fornecedor" {{ (Request::old("filter7") == "Fornecedor" ? "selected":"") }}>Fornecedor</option>
                                        <option value="Prestador" {{ (Request::old("filter7") == "Prestador" ? "selected":"") }}>Prestador</option>
                                        <option value="Produto" {{ (Request::old("filter7") == "Produto" ? "selected":"") }}>Produto</option>
                                        <option value="Status"{{ (Request::old("filter7") == "Status" ? "selected":"") }}>Status</option>
                                    </select>
                                </div>
                                <div class="col-3 mt-2 text-sm mb-0">
                                    <select name="middle7" id="middle7" value="{{old('middle7')}}" class="form-control" @error('middle7') is-invalid @enderror>
                                        @if (Request::old("middle7") == "=")
                                            <option value="=" selected>É igual</option>
                                        @elseif (Request::old("middle7") == "<>")
                                            <option value="<>" selected>Não é igual</option>
                                        @elseif (Request::old("middle7") == ">")
                                            <option value=">" selected>É maior que</option>
                                        @elseif (Request::old("middle7") == "<")
                                            <option value="<" selected>É menor que</option>
                                        @elseif (Request::old("middle7") == "LIKE")
                                            <option value="LIKE" selected>É igual</option>
                                        @elseif (Request::old("middle7") == "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="result7" type="text" id="result7" value="{{old('result7')}}" class="form-control" @error('result7') is-invalid @enderror>
                                </div>
                            </div>
                            {{-- 8 --}}
                            <div class="row text-sm mb-0 ml-2 mr-2" id="row8" style="vertical-align:middle;align-items:center;{{ (Request::old("filter8") != null ? "selected":"") }}display:none">
                                <div class="col-4 mt-2 text-sm mb-0">
                                    <select name="filter8" id="filter8" value="{{old('filter8')}}" class="form-control" @error('filter8') is-invalid @enderror>
                                        <option value=""> -- Selecione --</option>
                                        <option value="ID" {{ (Request::old("filter8") == "ID" ? "selected":"") }} >ID</option>
                                        <option value="Cliente" {{ (Request::old("filter8") == "Cliente" ? "selected":"") }}>Cliente</option>
                                        <option value="Data da Venda" {{ (Request::old("filter8") == "Data da Venda" ? "selected":"") }}>Data da Venda</option>
                                        <option value="Fornecedor" {{ (Request::old("filter8") == "Fornecedor" ? "selected":"") }}>Fornecedor</option>
                                        <option value="Prestador" {{ (Request::old("filter8") == "Prestador" ? "selected":"") }}>Prestador</option>
                                        <option value="Produto" {{ (Request::old("filter8") == "Produto" ? "selected":"") }}>Produto</option>
                                        <option value="Status"{{ (Request::old("filter8") == "Status" ? "selected":"") }}>Status</option>
                                    </select>
                                </div>
                                <div class="col-3 mt-2 text-sm mb-0">
                                    <select name="middle8" id="middle8" value="{{old('middle8')}}" class="form-control" @error('middle8') is-invalid @enderror>
                                        @if (Request::old("middle8") == "=")
                                            <option value="=" selected>É igual</option>
                                        @elseif (Request::old("middle8") == "<>")
                                            <option value="<>" selected>Não é igual</option>
                                        @elseif (Request::old("middle8") == ">")
                                            <option value=">" selected>É maior que</option>
                                        @elseif (Request::old("middle8") == "<")
                                            <option value="<" selected>É menor que</option>
                                        @elseif (Request::old("middle8") == "LIKE")
                                            <option value="LIKE" selected>É igual</option>
                                        @elseif (Request::old("middle8") == "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="result8" type="text" id="result8" value="{{old('result8')}}" class="form-control" @error('result8') 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-basic1">
                            <thead class="thead-light">
                                <tr>
                                    <th scope="col">ID</th>
                                    <th scope="col">Data da Venda</th>
                                    <th scope="col">Cliente</th>
                                    {{-- <th scope="col">Produtos Vinculados</th> --}}
                                    <th scope="col">Status</th>
                                    {{-- <th scope="col">Valor</th> --}}
                                    <th scope="col" class="text-center">Ações</th>
                                </tr>
                            </thead>
                            <tbody>
								@php
									$total = 0;
								@endphp
                                @foreach ($sales as $sale)
                                    @if ($sale->sale_id)
                                    <tr>
                                        <td>
                                            <a href="{{ route('sales.show', $sale->sale_id) }}" class="btn btn-sm btn-primary" target="_blank" rel="noopener noreferrer">{{ $sale->sale_id }}</a>
                                            {{-- <div class="modal fade" id="modal{{ $sale->sale_id }}" tabindex="-1" role="dialog" aria-labelledby="modal{{ $sale->sale_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 >Venda {{ $sale->sale_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 Venda</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">{{$sale->user}}</p>
                                                                </div>
                                                                <div class="col-6">
                                                                    <label class="form-control-label text-left" for="basic-url">Cliente</label><br>
                                                                    <p class="text-sm">{{ substr($sale->first_name ." ".$sale->last_name,0,50) }}</p>
                                                                </div>
                                                                <div class="col-3">
                                                                    <label class="form-control-label text-left" for="basic-url">Data da Venda</label><br>
                                                                    <p class="text-sm">{{ date('d/m/y', strtotime($sale->sale_date)) }}</p>
                                                                </div>
                                                            </div>
                                                            <br>
                                                            <h4 class="mb-0">Produtos</h4><br>
                                                            <hr width="100%" size="20" style="margin-top: -10px">
                                                            <div class="row">
                                                                <div class="table-responsive py-4" id="users-table" style="margin-top: -35px">
                                                                    <table class="table align-items-center table-flush"  id="datatable-basic1">
                                                                        <thead class="thead-light">
                                                                            <tr>
                                                                                <th scope="col">Produto</th>
                                                                                <th scope="col">Fornecedor</th>
                                                                                <th scope="col">Prestador</th>
                                                                                <th scope="col">Início</th>
                                                                                <th scope="col">Fim</th>
                                                                                <th scope="col">Passageiros</th>
                                                                            </tr>
                                                                        </thead>
                                                                        <tbody>
                                                                            @foreach ($products as $key => $product)
																				@foreach ($product as $prod)
																					@if ($prod['sale_id'] == $sale->sale_id)
																						<tr
																						@if($prod['product'] == "Aéreo") title="Partida: {{$prod['partida_iata'] . " - " . $prod['partida']}} | Chegada: {{$prod['chegada_iata'] . " - " . $prod['chegada']}} | Localizador: {{$prod['reservation_number']}}" @endif >
																							<td >{{$prod['product']}}</td>
																							<td>{{$prod['provider']}}</td>
																							<td>{{$prod['supplier']}}</td>
																							<td>{{ date('d/m/y H:i', strtotime($prod['start_datetime'])) }}</td>
																							<td>{{ date('d/m/y H:i', strtotime($prod['end_datetime'])) }}</td>
																							<td>
																								<a type="button" class="btn btn-sm btn-primary" target="_blank" href="{{ route('salesproductpassenger.show', $prod['spid']) }}"><i class="fa-solid fa-user text-white"> Ver</i></a>
																							</td>
																						</tr>
																					@endif
																				@endforeach
                                                                            @endforeach
                                                                        </tbody>
                                                                    </table>
                                                                </div>
                                                            </div>
                                                            <br>
                                                            <h4 class="mb-0">Formas de Pagamento</h4><br>
                                                            <hr width="100%" size="20" style="margin-top: -10px">
                                                            <div class="row">
                                                                <div class="table-responsive py-4" id="users-table" style="margin-top: -35px">
                                                                    <table class="table align-items-center table-flush"  id="datatable-basic1">
                                                                        <thead class="thead-light">
                                                                            <tr>
                                                                                <th scope="col">Forma</th>
                                                                                <th scope="col">Data</th>
                                                                                <th scope="col">Valor</th>
                                                                            </tr>
                                                                        </thead>
                                                                        <tbody>
                                                                            @foreach ($sales_method_payment as $method_payment)
																				@foreach ($method_payment as $method)
																					@if ($method['sale_id'] == $sale->sale_id)
																						<tr>
																							<td>{{$method['method']}}</td>
																							<td>{{ date('d/m/y', strtotime($method['date_payment'])) }}
																								@if($method['product'] == "Aéreo")
																									<a type="button" class="btn btn-sm btn-primary" target="_blank" href="{{ route('newflightleg', $method['spid']) }}"><i class="fa-solid fa-plane text-white"></i></a>
																								@endif
																							</td>
																							<td>R$ {{ number_format( $method['final_price'] , 2, ",", ".") }}</td>
																						</tr>
																					@endif
																				@endforeach
                                                                            @endforeach
                                                                        </tbody>
                                                                        <tfoot>
                                                                            <tr>
                                                                                <td><strong> Total</strong></td>
                                                                                <td></td>
                                                                                <td><strong>R$ {{ number_format( $sales_method_payment->sum('final_price') , 2, ",", ".")}}</strong></td>
                                                                            </tr>
                                                                        </tfoot>
                                                                    </table>
                                                                </div>
                                                            </div>
                                                            <h4 class="mb-0">Anexos</h4><br>
                                                            <hr width="100%" size="20" style="margin-top: -10px">
                                                            <div class="row">
                                                                <div class="table-responsive py-4" id="users-table" style="margin-top: -35px">
                                                                    @foreach ($file_sales as $files)
																		@foreach ($files as $file)
																			@if ($file['sale_id'] == $sale->sale_id)
																			<div class="row align-items-center" style="margin-top: 10px;">
																				<div class="col-auto">
																				<!-- Avatar -->
																					<a href="{{ asset('files/vouchers/').'/'.$file['title'] }}" target="_blank" class="avatar rounded-circle" style="margin-left: 20px;">
																						<i class="fa-solid fa-cloud-arrow-down"></i>
																					</a>
																				</div>
																				<div class="col ml--2">
																					<h4 class="mb-0">
																						<a href="{{ asset('files/vouchers/').'/'.$file['title'] }}" target="_blank">{{ substr($file['title'],0,65) }}</a>
																					</h4>

																					<span class="text-success">●</span>
																					<small>Anexado em: {{ date('d/m/Y H:m', strtotime($file['created_at'])) }}</small>
																				</div>
																			</div>
																			@endif
																		@endforeach
                                                                    @endforeach
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div> --}}
                                        </td>
                                        <td data-type="date">{{ date('d/m/Y', strtotime($sale->sale_date)) }}</td>
                                        <td>{{ $sale->first_name ." ".$sale->last_name }}</td>
                                        {{-- <td>{{ $sales_product->where('sale_id', '=', $sale->sale_id)->where('kind', '=', 'Main')->count() }}</td> --}}
                                        <td>{{ $sale->status }}</td>
                                        {{-- <td>
											@foreach ($value as $val)
												@foreach ($val as $va)
													@if ($va['id'] == $sale->sale_id)
														{{$va->sum('final_price')}}

														R$ {{ number_format($va->sum('final_price'), 2, ",", ".") }}
													@endif
												@endforeach
											@endforeach
										</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('sales.show', $sale->sale_id) }}"><i class="fas fa-pencil text-dark text-sm opacity-10"></i> Editar</a>
                                                    <form action="{{ route('sales.destroy', $sale->sale_id) }}" method="post">
                                                        @csrf
                                                        @method('delete')

                                                        <button type="button" class="dropdown-item" onclick="confirm('Tem certeza que deseja excluir essa venda?') ? 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>
                                    @endif
                                @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-select-bs4/css/select.bootstrap4.min.css">
    <script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
@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/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-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 == "Usuário") {
                    $('#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 == "Data da Venda") {
                    $('#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 == "Fornecedor") {
                    $('#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 == "Prestador") {
                    $('#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 == "Produto") {
                    $('#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 == "Status") {
                    $('#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 == "Data da Venda") {
                    $('#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 == "Fornecedor") {
                    $('#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 == "Prestador") {
                    $('#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 == "Produto") {
                    $('#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 == "Status") {
                    $('#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();
                }
            });
            $('#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 == "Data da Venda") {
                    $('#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 == "Fornecedor") {
                    $('#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 == "Prestador") {
                    $('#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 == "Produto") {
                    $('#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 == "Status") {
                    $('#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();
                }
            });
            $('#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 == "Data da Venda") {
                    $('#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 == "Fornecedor") {
                    $('#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 == "Prestador") {
                    $('#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 == "Produto") {
                    $('#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 == "Status") {
                    $('#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();
                }
            });
            $('#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 == "Data da Venda") {
                    $('#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 == "Fornecedor") {
                    $('#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 == "Prestador") {
                    $('#middle5').empty();
                    $('#row6').show();
                    $('#middle5').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val5 == "Produto") {
                    $('#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 == "Status") {
                    $('#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();
                }
            });
            $('#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 == "Data da Venda") {
                    $('#middle6').empty();
                    $('#result6').prop("type", "text");
                    $('#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 == "Fornecedor") {
                    $('#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 == "Prestador") {
                    $('#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 == "Produto") {
                    $('#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 == "Status") {
                    $('#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();
                }
            });
            $('#filter7').on('change',function(){
                let val7 = $('#filter7').val();
                console.log(val7);
                if (val7 == "ID") {
                    $('#middle7').empty();
                    $('#result7').prop("type", "text");
                    $('#row8').show();
                    $('#middle7').append([
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,

                    ]);
                } else if(val7 == "Cliente") {
                    $('#middle7').empty();
                    $('#result7').prop("type", "text");
                    $('#row8').show();
                    $('#middle7').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val7 == "Data da Venda") {
                    $('#middle7').empty();
                    $('#result7').prop("type", "date");
                    $('#row8').show();
                    $('#middle7').append([
                        `<option value=">">É maior que</option>`,
                        `<option value="<">É menor que</option>`,
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val7 == "Fornecedor") {
                    $('#middle7').empty();
                    $('#result7').prop("type", "text");
                    $('#row8').show();
                    $('#middle7').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val7 == "Prestador") {
                    $('#middle7').empty();
                    $('#result7').prop("type", "text");
                    $('#row8').show();
                    $('#middle7').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val7 == "Produto") {
                    $('#middle7').empty();
                    $('#result7').prop("type", "text");
                    $('#row8').show();
                    $('#middle7').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val7 == "Status") {
                    $('#middle7').empty();
                    $('#result7').prop("type", "text");
                    $('#row8').show();
                    $('#middle7').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else {
                    $('#middle7').empty();
                }
            });
            $('#filter8').on('change',function(){
                let val8 = $('#filter8').val();
                console.log(val8);
                if (val8 == "ID") {
                    $('#middle8').empty();
                    $('#result8').prop("type", "text");
                    $('#middle8').append([
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,

                    ]);
                } else if(val8 == "Cliente") {
                    $('#middle8').empty();
                    $('#result8').prop("type", "text");
                    $('#middle8').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val8 == "Data da Venda") {
                    $('#middle8').empty();
                    $('#result8').prop("type", "date");
                    $('#middle8').append([
                        `<option value=">">É maior que</option>`,
                        `<option value="<">É menor que</option>`,
                        `<option value="=">É igual</option>`,
                        `<option value="<>">Não é igual</option>`,
                    ]);
                } else if(val8 == "Fornecedor") {
                    $('#middle8').empty();
                    $('#result8').prop("type", "text");
                    $('#middle8').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val8 == "Prestador") {
                    $('#middle8').empty();
                    $('#result8').prop("type", "text");
                    $('#middle8').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val8 == "Produto") {
                    $('#middle8').empty();
                    $('#result8').prop("type", "text");
                    $('#middle8').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else if(val8 == "Status") {
                    $('#middle8').empty();
                    $('#result8').prop("type", "text");
                    $('#middle8').append([
                        `<option value="LIKE">É igual</option>`,
                        `<option value="not LIKE">Não é igual</option>`,
                    ]);
                } else {
                    $('#middle8').empty();
                }
            });
    </script>
    <script>
        var DatatableButtons = (function() {
        // Variables

        var $dtButtons = $('#datatable-basic1');


        // Methods

        function init($this) {

            // For more options check out the Datatables Docs:
            // https://datatables.net/extensions/buttons/

            // Basic options. For more options check out the Datatables Docs:
            // https://datatables.net/manual/options

            var options = {

                length: true,
                lengthChange: 1,
                dom: 'lfrtip',
                columnDefs: [
                        { orderable: true, targets: 6 }
                ],
                order: [[0, 'desc']],
                // select: {
                // 	style: "multi"
                // },
                language: {
                    paginate: {
                        previous: "<i class='fas fa-angle-left'>",
                        next: "<i class='fas fa-angle-right'>"
                    },
                    search: "Busca rápida:",
                    emptyTable: "Nenhuma reserva encontrada",
                    info: "Mostrando de _START_ até _END_ de _TOTAL_ registros",
                    infoEmpty: "Mostrando 0 até 0 de 0 registros",
                    infoFiltered: "(Filtrados de _MAX_ registros)",
                    infoThousands: ".",
                    loadingRecords: "Carregando...",
                    processing: "Processando...",
                    zeroRecords: "Nenhuma reserva encontrada",
                    lengthMenu: "Exibir _MENU_ registros",
                    decimal: ",",
                },
                info: "Mostrando de _START_ até _END_ de _TOTAL_ registros",
            };

            // Init the datatable

            var table = $this.on('init.dt', function() {
                $('.dt-buttons .btn').removeClass('btn-secondary').addClass('btn-sm btn-default');
            }).DataTable(options);
        }


        // Events

        if ($dtButtons.length) {
            init($dtButtons);
        }

        })();
    </script>
@endpush