@extends('../layouts.navigation')
@section('content')
    @php
        $user_id = Auth::user()->id;
        $user_type = Auth::user()->tipo_id;
        $entrada = $saida = $saldo = 0;
        $index = 0;
        
        $has_permission_delete = $permissao->has_permission_by_name($user_id, 'excluir movimentação de caixa');
       /* 
        $has_permission_edit = $permissao->has_permission_by_name($user_id, 'editar cliente');
        $has_permission_create = $permissao->has_permission_by_name($user_id, 'criar cliente');
        */
        $moeda = "";
        foreach ($entidade as $item) {
           $moeda = $item->moeda_code ;
        }
    @endphp
    <!-- Content -->
    <div class="container-xxl flex-grow-1 container-p-y">
        <div class="card mb-6">
            <div class="card-widget-separator-wrapper">
                <div class="card-body card-widget-separator">
                    <div class="row gy-4 gy-sm-1">
                        <div class="col-sm-6 col-lg-3">
                            <div
                                class="d-flex justify-content-between align-items-start card-widget-1 border-end pb-4 pb-sm-0">
                                <div>
                                    <p class="mb-1">Saldo</p>
                                    <h4 class="mb-1"> <span id="saldo_object">{{ $saldo }}</span> {{ $moeda }}</h4>
                                    <p class="mb-0">
                                        <span class="me-2" >Percentual:</span>
                                        <span class="badge bg-label-success" id="percent_saldo_object">100%</span>
                                    </p>
                                </div>
                                <span class="avatar me-sm-6">
                                    <span class="bg-label-success avatar-initial rounded">
                                        <i class="icon-base ti tabler-coin icon-28px text-heading"></i>
                                    </span>
                                </span>
                            </div>
                            <hr class="d-none d-sm-block d-lg-none me-6">
                        </div>
                        <div class="col-sm-6 col-lg-3">
                            <div
                                class="d-flex justify-content-between align-items-start card-widget-2 border-end pb-4 pb-sm-0">
                                <div>
                                    <p class="mb-1">Entrada</p>
                                    <h4 class="mb-1"><span id="entrada_object">{{ $entrada }}</span> {{ $moeda }}</h4>
                                    <p class="mb-0">
                                        <span class="me-2">Percentual:</span>
                                        <span class="badge bg-label-success" id="percent_entrada_object">0%</span>
                                    </p>
                                </div>
                                <span class="avatar p-2 me-lg-6">
                                    <span class="bg-label-success avatar-initial rounded">
                                        <i class="icon-base ti tabler-arrow-up icon-28px text-heading"></i></span>
                                </span>
                            </div>
                            <hr class="d-none d-sm-block d-lg-none">
                        </div>
                        <div class="col-sm-6 col-lg-3">
                            <div
                                class="d-flex justify-content-between align-items-start border-end pb-4 pb-sm-0 card-widget-3">
                                <div>
                                    <p class="mb-1">Saídas</p>
                                    <h4 class="mb-1"> <span id="saida_object">{{ $saida }}</span> {{ $moeda }}</h4>
                                    <p class="mb-0">
                                        <span class="me-2">Percentual:</span>
                                        <span class="badge bg-label-danger" id="percent_saida_object">0%</span>
                                    </p>
                                </div>
                                <span class="avatar p-2 me-sm-6">
                                    <span class="bg-label-danger avatar-initial rounded">
                                        <i class="icon-base ti tabler-arrow-down icon-28px text-heading"></i>
                                    </span>
                                </span>
                            </div>
                        </div>
                        <div class="col-sm-6 col-lg-3">
                            <div class="d-flex justify-content-between align-items-start">
                                <div>
                                    <p class="mb-1">Movimentos</p>
                                    <h4 class="mb-1" id="movimento_object">{{ $index }}</h4>
                                    <p class="mb-0">
                                        <span class="me-2">Percentual:</span>
                                        <span class="badge">100%</span>
                                    </p>
                                </div>
                                <span class="avatar p-2">
                                    <span class="avatar-initial rounded"><i
                                            class="icon-base ti tabler-wallet icon-28px text-heading"></i></span>
                                </span>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!-- Product List Widget -->  
        @if (session('status') && session('status')=='Registado com sucesso!')
            <div class="alert alert-success alert-dismissible fade show" role="alert">
                {{ session('status') }}
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
        @elseif (session('status'))
            <div class="alert alert-warning alert-dismissible fade show" role="alert">
                {{ session('status') }}
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
        @endif
        <!-- Product List Table -->

        <div class="card mb-4">
            <div class="card-header">
                <h5>Filtros</h5>
            </div>
            <div class="card-body">
                <form method="GET" action="{{ route('movimento.index') }}">
                    <div class="row">
                        <!-- Data -->
                        <div class="col-md-3">
                            <div class="form-group">
                                <label>Período</label>
                                <div class="input-daterange input-group">
                                    @php
                                        $dataInicioValue = $request->filled('data_inicio') 
                                            ? \Carbon\Carbon::parse($request->data_inicio)->format('Y-m-d\TH:i')
                                            : now()->startOfMonth()->format('Y-m-d\TH:i');

                                        $dataFimValue = $request->filled('data_fim') 
                                            ? \Carbon\Carbon::parse($request->data_fim)->format('Y-m-d\TH:i')
                                            : now()->endOfMonth()->format('Y-m-d\TH:i');
                                    @endphp
                                
                                    <input type="datetime-local" class="form-control" name="data_inicio" 
                                       value="{{ $dataInicioValue }}">
                                    <span class="input-group-text">até</span>
                                    <input type="datetime-local" class="form-control" name="data_fim" 
                                           value="{{ $dataFimValue }}">
                                </div>
                            </div>
                        </div>
                        
                         <!-- Caixas -->
                         <div class="col-md-2">
                            <div class="form-group">
                                <label for="caixa">Caixas</label>
                                <select class="form-select" id="caixa" name="caixa">
                                    <option value="">Todos</option>
                                    @foreach($caixas as $caixa)
                                        <option value="{{ $caixa->id }}" {{ request('caixa') == $caixa->id ? 'selected' : '' }}>
                                            {{ $caixa->caixa }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                        </div>

                        <!-- C -->
                        <div class="col-md-2">
                            <div class="form-group">
                                <label for="categoria">Categoria</label>
                                <select class="form-select" id="categoria" name="categoria">
                                    <option value="">Todos</option>
                                    <option value="1" {{ request('categoria') == '1' ? 'selected' : '' }}>Entradas</option>
                                    <option value="-1" {{ request('categoria') == '-1' ? 'selected' : '' }}>Saídas</option>
                                </select>
                            </div>
                        </div>
                        
                        <!-- Tipo de Movimento -->
                        <div class="col-md-2">
                            <div class="form-group">
                                <label for="tipo">Tipo Movimento</label>
                                <select class="form-select" id="tipo" name="tipo">
                                    <option value="">Todos</option>
                                    @foreach($tipo_movimentos as $tipo)
                                        <option value="{{ $tipo->id }}" {{ request('tipo') == $tipo->id ? 'selected' : '' }}>
                                            {{ $tipo->movimento }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <!-- Tipo de Movimento -->
                        <div class="col-md-2">
                            <div class="form-group">
                                <label for="user">Usuários</label>
                                <select class="form-select" id="user" name="user">
                                    <option value="">Todos</option>
                                    @foreach($users as $item)
                                        <option value="{{ $item->id }}" {{ request('user') == $tipo->id ? 'selected' : '' }}>
                                            {{ $item->name }} ({{ $item->email }})
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                    </div>
                    
                    <div class="row mt-2">
                        <!-- Botões -->
                        <div class="col-md-11 text-end">
                            <button type="submit" class="btn btn-primary">
                                <i class="fas fa-filter"></i> Filtrar
                            </button>
                            <a href="{{ route('movimento.index') }}" class="btn btn-secondary">
                                <i class="fas fa-times"></i> Limpar
                            </a>
                        </div>
                    </div>
                </form>
            </div>
        </div>
        <div class="card mb-4">
            <div class="card-header d-flex justify-content-between align-items-center">
                <h5>Fluxo de caixa</h5>
                <div>
                    <a href="{{ route('movimento.index', array_merge(request()->all(), ['export' => 'excel'])) }}"
                        class="btn btn-success btn-sm">
                        <i class="icon-base ti tabler-file-type-xls icon-18px"></i> Excel
                    </a>
                    <a href="{{ route('movimento.index', array_merge(request()->all(), ['export' => 'pdf'])) }}"
                        class="btn btn-danger btn-sm">
                        <i class="icon-base ti tabler-file-type-pdf icon-18px"></i> PDF
                    </a>
                    <a href="#" class="btn add-new btn-primary btn-sm" tabindex="0" data-bs-toggle="offcanvas"
                        data-bs-target="#offcanvasEcommerceCustomerAdd">
                        <span>
                            <span class="d-flex align-items-center gap-2">
                                <i class="icon-base ti tabler-plus icon-xs"></i>
                                <span class="d-none d-sm-inline-block">Add Novo</span>
                            </span>
                        </span>
                    </a>

                </div>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-bordered table-striped table-hover">
                        <thead class="thead-dark">
                            <tr>
                                <th>Caixa</th>
                                <th>Valor</th>
                                <th>Descrição</th>
                                <th>OBS</th>
                                <th>Tipo</th>
                                <th>Usuário</th>
                                <th>Data</th>
                                <th>Acção</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($movimentos as $Item)

                                @php
                                    $index++;
                                @endphp
                                <tr>
                                    <td>
                                        {{ $Item->caixa }}
                                    </td>
                                    <td>
                                        @if ($Item->valor >= 0)
                                            @php
                                                $entrada+=$Item->valor;
                                            @endphp
                                            <i class="bg-success icon-base ti tabler-arrow-up icon-18px"></i>
                                            {{ number_format($Item->valor, 2, ',', ' ') }} {{ $Item->moeda_code }}
                                        @else
                                            @php
                                                $saida+=$Item->valor;
                                            @endphp
                                            <i class="bg-danger icon-base ti tabler-arrow-down icon-18px"></i>
                                            {{ number_format($Item->valor, 2, ',', ' ') }} {{ $Item->moeda_code }}
                                        @endif
                                    </td>
                                    <td>
                                        {{ $Item->descricao }}
                                    </td>
                                    <td>
                                        {{ $Item->observacao }}
                                    </td>
                                    <td>
                                        {{ $Item->movimento }}
                                    </td>
                                    <td>
                                        {{ $Item->realizado_por }} ({{ $Item->email }})
                                    </td>

                                    <td>{{ \Carbon\Carbon::parse($Item->created_at)->format('d/m/Y H:i') }}</td>
                                    <td>
                                        @if (@$user_type<3 or @$has_permission_delete!=null)
                                            <form style="display: inline-block" action="{{route('movimento.destroy')}}" method="post">
                                                @method('PUT')
                                                @csrf
                                                <input type="hidden" value="{{ $Item->id }}" name="movimentoId">
                                                <button type="submit" class="btn btn-sm btn-icon btn-text-danger rounded-pill waves-effect" title="Deletar permanentemente">
                                                    <i class="bg-danger icon-base ti tabler-trash icon-18px"></i>
                                                </button>
                                            </form>
                                        @endif
                                    </td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="9" class="text-center">Nenhuma movimentação encontrada</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>

                <!-- Paginação -->
                <!-- Paginação -->
                <div class="d-flex justify-content-center mt-3">
                    {{ $movimentos->appends(request()->query())->links() }}
                </div>
            </div>
        </div>


    </div>
    <!-- / Content percent_saldo_object -->
    @include('movimento.create');
    @php
       $saldo = $entrada+$saida;
    @endphp
    <script>
            document.getElementById('movimento_object').innerHTML={{ $index }};
            
            document.getElementById('entrada_object').innerHTML= Number({{ $entrada }}).toLocaleString('pt-BR', {
                minimumFractionDigits: 2,
                maximumFractionDigits: 2
            });
            document.getElementById('saida_object').innerHTML= Number({{ $saida }}).toLocaleString('pt-BR', {
                minimumFractionDigits: 2,
                maximumFractionDigits: 2
            });
            document.getElementById('saldo_object').innerHTML= Number({{ $saldo }}).toLocaleString('pt-BR', {
                minimumFractionDigits: 2,
                maximumFractionDigits: 2
            });
            //  document.getElementById('percent_saldo_object').innerHTML= 100+"%";
    </script>
    @if ($entrada>0)
        @if ($saida!=0)
            <script>
                document.getElementById('percent_entrada_object').innerHTML=Math.round({{ 100*$entrada/($entrada+(-1*$saida)) }})+"%";
            </script>
        @else
            <script>
                document.getElementById('percent_entrada_object').innerHTML=100+"%";
            </script>
        @endif
    @endif
    @if ($saida<0)
        @if ($entrada!=0)
            <script>
                document.getElementById('percent_saida_object').innerHTML=Math.round({{ -100*$saida/($entrada+(-1*$saida)) }})+"%";
            </script>
        @else
            <script>
                document.getElementById('percent_saida_object').innerHTML=100+"%";
            </script>
        @endif
    @endif

    
    
@endsection