@extends('template.template')
@section('content')
    @php
        use App\Models\Venda;
        use App\Models\User;
        use Carbon\Carbon;

        $mesNumber = Carbon::now()->locale('pt_BR')->month;
        $mesAtualNome = ucfirst(Carbon::now()->locale('pt_BR')->monthName);
        $anoAtual = Carbon::now()->locale('pt_BR')->year;
        $vendas = Venda::whereRaw("month(date) = $mesNumber")->get();

        $vendasPorUsuarioMes = Venda::selectRaw('user_id, MONTH(date) as month, SUM(product_value) as total_product_value, SUM(frame_value) as total_frame_value, SUM(commission) as total_commission')
            ->whereRaw("MONTH(date) = $mesNumber")
            ->whereRaw("YEAR(date) = $anoAtual")
            ->groupBy('user_id', 'month')
            ->get();

        $historicoTotalPorUsuario = Venda::selectRaw('user_id, SUM(product_value) as total_product_value, SUM(frame_value) as total_frame_value, SUM(commission) as total_commission, SUM(commission_paid) as total_commission_paid')
            ->whereRaw("YEAR(date) = $anoAtual")
            ->groupBy('user_id')
            ->get();

        $valorTotalComissoes = $vendas->sum('commission');
        $valorTotalQuadro = $vendas->sum('frame_value');
        $valorTotalProduto = $vendas->sum('product_value');
        $valorTotal = $valorTotalQuadro + $valorTotalProduto;

    @endphp
    <div class="dashboard-wrapper">
        <div class="container-fluid  dashboard-content">
            <div class="row">
                <div class="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
                    <div class="page-header">
                        <h3 class="mb-2">Sistema de comissão - Tecnopartes RJ</h3>

                        {{-- <div class="page-breadcrumb">
                            <nav aria-label="breadcrumb">
                                <ol class="breadcrumb">
                                    <li class="breadcrumb-item"><a href="#" class="breadcrumb-link">Início</a></li>
                                </ol>
                            </nav>
                        </div> --}}
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-xl-3 col-lg-6 col-md-6 col-sm-12 col-12">
                    <div class="card">
                        <div class="card-body">
                            <h5 class="text-muted">Total de vendas</h5>
                            <div class="metric-value d-inline-block">
                                <h3 class="mb-1 text-primary">{{ 'R$ ' . number_format($valorTotal, 2, ',', '.') }}
                            </div>

                        </div>
                    </div>
                </div>

                <div class="col-xl-3 col-lg-6 col-md-6 col-sm-12 col-12">
                    <div class="card">
                        <div class="card-body">
                            <h5 class="text-muted">Total de comissões</h5>
                            <div class="metric-value d-inline-block">
                                <h3 class="mb-1 text-primary">{{ 'R$ ' . number_format($valorTotalComissoes, 2, ',', '.') }}
                            </div>
                        </div>
                    </div>
                </div>

                <div class="col-xl-3 col-lg-6 col-md-6 col-sm-12 col-12">
                    <div class="card">
                        <div class="card-body">
                            <h5 class="text-muted">Mês de referência </h5>
                            <div class="metric-value d-inline-block">
                                <h3 class="mb-1 text-primary">{{ $mesAtualNome }}</h3>
                            </div>

                        </div>
                    </div>
                </div>

                <div class="col-xl-3 col-lg-6 col-md-6 col-sm-12 col-12">
                    <div class="card">
                        <div class="card-body">
                            <h5 class="text-muted">Data de hoje</h5>
                            <div class="metric-value d-inline-block">
                                <h3 class="mb-1 text-primary" name="face">
                                    <div id="data-hora"></div>
                                    <script>
                                        const options = {

                                            timeZone: 'America/Sao_Paulo',
                                            hour: 'numeric',
                                            minute: 'numeric'
                                        };
                                        const date = new Intl.DateTimeFormat([], options);
                                        console.log(date.format(new Date()));
                                        const zeroFill = n => {
                                            return ('0' + n).slice(-2);
                                        }
                                        const interval = setInterval(() => {
                                            const now = new Date();
                                            const dataHora = zeroFill(now.getUTCDate() + 0) + '/' + zeroFill((now.getMonth() + 1)) + '/' + now
                                                .getFullYear() + ' ' + zeroFill(now.getHours()) + ':' + zeroFill(now.getMinutes()) + ':' + zeroFill(
                                                    now.getSeconds());

                                            document.getElementById('data-hora').innerHTML = dataHora;
                                        }, 1000);
                                    </script>
                                </h3>
                            </div>
                        </div>
                    </div>
                </div>

            </div>
            <div class="row">
                <div class="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
                    <div style="margin: 5px"> <i class="fa-regular fa fa-circle fa-xs" style="color: #006D02;"></i>
                        Realizado<br>
                        <i class="fa-regular fa fa-circle fa-xs" style="color: #e32400;"></i> Atrasado (Após dia 10 do
                        mês)<br>
                        <i class="fa-regular fa fa-circle fa-xs" style="color: #EDE800"></i> Pendente (Entre dia 1 e dia 10
                        do mês)
                    </div>
                    <div class="card">
                        <h5 class="card-header">RESUMO DOS VENDEDORES</h5>
                        <div class="card-body p-0">
                            <div class="table-responsive">
                                <table class="table">
                                    <thead class="bg-light">
                                        <tr class="border-0">
                                            <th class="border-0">#</th>
                                            <th class="border-0">Vendedor</th>
                                            <th class="border-0">Valor total</th>
                                            <th class="border-0">Valor de comissão</th>
                                            <th class="border-0">Mês de referência</th>
                                            <th class="border-0">Pagamento</th>
                                            <th class="border-0">Antecipou</th>
                                            <th class="border-0">Pagou a comissão?</th>
                                            <th class="border-0"></th>
                                            <th class="border-0"></th>
                                            <th class="border-0"></th>
                                            <th class="border-0"></th>
                                            <th class="border-0"></th>
                                            <th class="border-0"></th>
                                            <th class="border-0"></th>
                                            <th class="border-0"></th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($vendasPorUsuarioMes as $indice => $vendasUsuarioMes)
                                            @php
                                                $ultimo = Venda::whereRaw('MONTH(date) = ?', [$vendasUsuarioMes->month])
                                                    ->where('user_id', $vendasUsuarioMes->user_id)
                                                    ->orderBy('date', 'desc')
                                                    ->first();

                                                $verde = '#006D02';
                                                $amarelo = '#EDE800';
                                                $vermelho = '#e32400';
                                                $cor = '';

                                                if ($ultimo->commission_paid != 0) {
                                                    $cor = $verde;
                                                } else {
                                                    $dataUltimaVenda = Carbon::now();
                                                    if ($dataUltimaVenda->day > 10) {
                                                        $cor = $vermelho;
                                                    } else {
                                                        $cor = $amarelo;
                                                    }
                                                }

                                            @endphp
                                            <tr>
                                                <td>{{ $indice + 1 }}</td>
                                                <td>{{ User::find($vendasUsuarioMes->user_id)->name }}</td>
                                                <td>{{ 'R$ ' . number_format($vendasUsuarioMes->total_product_value + $vendasUsuarioMes->total_frame_value, 2, ',', '.') }}
                                                </td>
                                                <td>{{ 'R$ ' . number_format($vendasUsuarioMes->total_commission - $ultimo->advance, 2, ',', '.') }}
                                                </td>
                                                <td>{{ $mesAtualNome }} de {{ $anoAtual }}</td>
                                                <td><i class="fa-regular fa fa-circle fa-xs"
                                                        style="color: {{ $cor }};"></i></td>
                                                <td>
                                                    <form action="{{ route('save_advance') }}">
                                                        <input type="hidden" name="venda_id" value="{{ $ultimo->id }}">
                                                        <span class="input-group-prepend">
                                                            <input id="antecipou" type="text" name="advance"
                                                                value="{{ $ultimo->advance ?? '' }}"
                                                                placeholder="diminuir do valor da comissao"
                                                                autocomplete="off" class="btn-outline-light"
                                                                style="padding: 5px; cursor: auto; border-right: none !important; border: 1px solid #e6e6f2; text-align: left">
                                                            <button style="display: inline" type="submit"
                                                                class="btn btn-outline-light float-right">Salvar</button>
                                                        </span>
                                                    </form>
                                                </td>
                                                @if ($ultimo->commission_paid)
                                                <td colspan="8">Comissão paga</td>
                                                @else
                                                    <td colspan="8"><a href="{{route('pay_commission', ['user_id' => $ultimo->user_id, 'commission' => $vendasUsuarioMes->total_commission])}}"
                                                            class="btn btn-outline-light float-left"
                                                            style="border-color: #007003;">Pagar comissão</a></td>
                                                @endif
                                                <td>
                                                    <a href="{{ route('historico_vendedor', ['id' => $vendasUsuarioMes->user_id]) }}" class="btn btn-outline-light float-right">Visualizar</a></td>
                                                </td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="row">
                <div class="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">

                    <div class="card">
                        <h5 class="card-header">HISTÓRICO TOTAL DO VENDEDOR</h5>
                        <div class="card-body p-0">
                            <div class="table-responsive">
                                <table class="table">
                                    <thead class="bg-light">
                                        <tr class="border-0">
                                            <th class="border-0">#</th>
                                            <th class="border-0">Vendedor</th>
                                            <th class="border-0">Valor total</th>
                                            <th class="border-0">Valor de comissão</th>
                                            <th class="border-0">Recebido</th>
                                            <th class="border-0">Pendente</th>
                                            <th class="border-0"></th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($historicoTotalPorUsuario as $indice => $historicoTotalUsuario)
                                            <tr>
                                                <td>{{ $indice }}</td>
                                                <td>{{ User::find($historicoTotalUsuario->user_id)->name }}</td>
                                                <td>{{ 'R$ ' . number_format($historicoTotalUsuario->total_product_value + $historicoTotalUsuario->total_frame_value, 2, ',', '.') }}
                                                </td>
                                                <td>{{ 'R$ ' . number_format($historicoTotalUsuario->total_commission, 2, ',', '.') }}
                                                </td>
                                                <td>{{ 'R$ ' . number_format($historicoTotalUsuario->total_commission_paid, 2, ',', '.') }}
                                                </td>
                                                <td>{{ 'R$ ' . number_format($historicoTotalUsuario->total_commission - $historicoTotalUsuario->total_commission_paid, 2, ',', '.') }}
                                                </td>

                                                <td><a href="{{ route('historico_vendedor', ['id' => $historicoTotalUsuario->user_id]) }}"
                                                        class="btn btn-outline-light float-right">Visualizar</a></td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>

            </div>

        </div>

    </div>
    </div>
    <script>
        startclock();
    </script>
@endsection