@extends('adminlte::page')

@section('title_prefix', __('Dashboard'))

@section('content_header')
    <h1 class="m-0 text-dark">Faturamento</h1>
@stop

@section('content')
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <form action="" @submit="return verificaFiltros()">
                        <input type="hidden" name="filtro" value="1">
                        <div class="card bg-gradient-gray ">
                            <div class="row rounded px-3">
                                <div class="col-md-5 form-group">
                                    <label>Período do faturamento</label>
                                    <div class="input-group">
                                        <input type="month" class="form-control" name="competencia_inicial" value="{{ request()->competencia_inicial }}" placeholder="Inicial"/>
                                        <input type="month" class="form-control" name="competencia_final" value="{{ request()->competencia_final }}" placeholder="Final"/>
                                    </div>
                                </div>
                                <div class="form-group col-md-5">
                                    <label>Período do atendimento</label>
                                    <div class="input-group">
                                        <input type="date" class="form-control" name="data_atendimento_inicial" value="{{ request()->data_atendimento_inicial ?? '' }}" placeholder="Inicial"/>
                                        <input type="date" class="form-control" name="data_atendimento_final" value="{{ request()->data_atendimento_final ?? '' }}" placeholder="Final"/>
                                    </div>
                                </div>
                                <div class="col-md-2 form-group">
                                    <br>
                                    <button class="btn btn-block btn-success">Pesquisar</button>
                                </div>
                            </div>
                        </div>
                    </form>
                    @if (request()->has('filtro'))
                        <button onclick="window.print()" class="btn btn-sm float-right btn-dark" title="Imprimir"><i class="fas fa-print"></i></button>
                        <a href="{{ route('cliente.faturamento.grafico', array_merge(['excel' => 1], request()->all())) }}" target="_blank">
                            <button class="btn btn-sm btn-dark float-right mr-1" title="Exportar para Excel"><i class="fas fa-file-excel"></i>
                            </button></a>
                    @endif
                </div>
                <div class="card-body row justify-content-center">
                    <div class="col-md-12">
                        @if (request()->has('filtro'))
                            <table class="table table-sm">
                                <tr class="bg-gradient-secondary">
                                    <th>
                                        <a style="color: white;" class="{{ request()->ordem == 'nome' ? 'text-success' : '' }}"
                                            href="{{ route(Route::currentRouteName(), array_merge(request()->all(), ['ordem' => 'nome', 'desc' => request()->ordem == 'nome' && !request()->desc])) }}">Convênio
                                            {!! request()->ordem == 'nome' ? (!request()->desc ? '&darr;' : '&uarr;') : '' !!}
                                        </a>
                                    </th>
                                    <th style="text-align: right">
                                        <a style="color: white;" class="{{ request()->ordem == 'valor' ? 'text-success' : '' }}"
                                            href="{{ route(Route::currentRouteName(), array_merge(request()->all(), ['ordem' => 'valor', 'desc' => request()->ordem == 'valor' && !request()->desc])) }}">Total
                                            (R$)
                                            {!! request()->ordem == 'valor' ? (!request()->desc ? '&darr;' : '&uarr;') : '' !!}
                                        </a>
                                    </th>
                                    <th style="text-align: right">
                                        <a style="color: white;" class="{{ request()->ordem == 'participacao' ? 'text-success' : '' }}"
                                            href="{{ route(Route::currentRouteName(), array_merge(request()->all(), ['ordem' => 'participacao', 'desc' => request()->ordem == 'participacao' && !request()->desc])) }}">%
                                            {!! request()->ordem == 'participacao' ? (!request()->desc ? '&darr;' : '&uarr;') : '' !!}
                                        </a>
                                    </th>
                                    <th style="text-align: right">
                                        <a style="color: white;" class="{{ request()->ordem == 'valor_recebido' ? 'text-success' : '' }}"
                                            href="{{ route(Route::currentRouteName(), array_merge(request()->all(), ['ordem' => 'valor_recebido', 'desc' => request()->ordem == 'valor_recebido' && !request()->desc])) }}">Recebido
                                            {!! request()->ordem == 'valor_recebido' ? (!request()->desc ? '&darr;' : '&uarr;') : '' !!}
                                        </a>
                                    </th>
                                    <th style="text-align: right">
                                        <a style="color: white;" class="{{ request()->ordem == 'valor_glosado_devido' ? 'text-success' : '' }}"
                                            href="{{ route(Route::currentRouteName(), array_merge(request()->all(), ['ordem' => 'valor_glosado_devido', 'desc' => request()->ordem == 'valor_glosado_devido' && !request()->desc])) }}">Glosa
                                            Devida
                                            {!! request()->ordem == 'valor_glosado_devido' ? (!request()->desc ? '&darr;' : '&uarr;') : '' !!}
                                        </a>
                                    </th>
                                    <th style="text-align: right">
                                        <a style="color: white;" class="{{ request()->ordem == 'valor_glosa_indevido' ? 'text-success' : '' }}"
                                            href="{{ route(Route::currentRouteName(), array_merge(request()->all(), ['ordem' => 'valor_glosa_indevido', 'desc' => request()->ordem == 'valor_glosa_indevido' && !request()->desc])) }}">Glosa
                                            Indevida
                                            {!! request()->ordem == 'valor_glosa_indevido' ? (!request()->desc ? '&darr;' : '&uarr;') : '' !!}
                                        </a>
                                    </th>
                                    <th style="text-align: right">
                                        <a style="color: white;" class="{{ request()->ordem == 'valor_recurso_recebido' ? 'text-success' : '' }}"
                                            href="{{ route(Route::currentRouteName(), array_merge(request()->all(), ['ordem' => 'valor_recurso_recebido', 'desc' => request()->ordem == 'valor_recurso_recebido' && !request()->desc])) }}">Glosa
                                            Recebida
                                            {!! request()->ordem == 'valor_recurso_recebido' ? (!request()->desc ? '&darr;' : '&uarr;') : '' !!}
                                        </a>
                                    </th>
                                </tr>
                                @foreach ($dados as $dado)
                                    <tr>
                                        <td>{{ $dado['nome'] }}</td>
                                        <td style="text-align: right">{{ number_format($dado['valor'], 2, ',', '.') }}</td>
                                        <td style="text-align: right">{{ number_format($dado['participacao'], 2, ',', '.') }}%</td>
                                        <td style="text-align: right">{{ number_format($dado['valor_recebido'], 2, ',', '.') }}</td>
                                        <td style="text-align: right">{{ number_format($dado['valor_glosado_devido'], 2, ',', '.') }}</td>
                                        <td style="text-align: right">{{ number_format($dado['valor_glosa_indevido'], 2, ',', '.') }}</td>
                                        <td style="text-align: right">{{ number_format($dado['valor_recurso_recebido'], 2, ',', '.') }}</td>
                                    </tr>
                                @endforeach
                                <tr class="bg-gradient-secondary text-bold">
                                    <td>Total geral</td>
                                    <td style="text-align: right">{{ number_format($total, 2, ',', '.') }}</td>
                                    <td style="text-align: right">100%</td>
                                    <td style="text-align: right">{{ number_format($total_valor_recebido, 2, ',', '.') }}</td>
                                    <td style="text-align: right">{{ number_format($total_valor_glosado_devido, 2, ',', '.') }}</td>
                                    <td style="text-align: right">{{ number_format($total_valor_glosa_indevido, 2, ',', '.') }}</td>
                                    <td style="text-align: right">{{ number_format($total_valor_recurso_recebido, 2, ',', '.') }}</td>
                                </tr>
                            </table>
                        @else
                            <h3>Selecione um filtro de pesquisa</h3>
                        @endif

                    </div>
                    <div class="col-md-12 d-flex">
                        <div id="chart_div" class="w-100" style="height: 40vh"></div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@stop


@push('js')
    @if (request()->has('filtro'))
        <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
        <script>
            google.charts.load('current', {
                'packages': ['corechart']
            });
            google.charts.setOnLoadCallback(drawChart);

            function drawChart() {
                var data = new google.visualization.DataTable();
                data.addColumn('string', 'Convênio');
                data.addColumn('number', 'Valor');
                data.addRows([
                    @foreach ($dados as $dado)
                        [
                            '{{ $dado['nome'] }}', {{ $dado['valor'] }}
                        ],
                    @endforeach
                ]);

                var options = {
                    title: 'Faturamento',
                    is3D: true,
                    colors: {!! json_encode($chart_colors) !!},
                    legend: {
                        position: 'right'
                    }
                };
                var chart = new google.visualization.PieChart(document.getElementById('chart_div'));
                chart.draw(data, options);
            }

            $(window).resize(function() {
                drawChart();
            });
        </script>
    @endif
@endpush