@extends('template.template')
@section('content')
    @php
        $user_id = $_GET['id'];
        $user = auth()->user();

        use App\Models\Venda;
        use Carbon\Carbon;

        $yearAtual = isset($_GET['year']) ? $_GET['year'] : ucfirst(Carbon::now()->locale('pt_BR')->year);
        $ano = Carbon::now()->locale('pt_BR')->year;
        $monthName = ucfirst(Carbon::now()->locale('pt_BR')->monthName);

        // $vendas = Venda::where('user_id', $user_id)->whereRaw("year(date) = $yearAtual")->orderBy('id', 'desc')->get();

        $vendas = Venda::selectRaw('MONTH(date) as month, 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')
        ->where('user_id', $user_id)
        ->whereYear('date', $yearAtual)
        ->groupBy('month')
        ->orderBy('month', 'desc')
        ->get();

        foreach ($vendas as $venda) {
            $venda->month_name = ucfirst(Carbon::create()
                ->month($venda->month)
                ->locale('pt_BR')->monthName);
        }

        $valorTotal = $vendas->sum(function ($venda) {
            return $venda->product_value + $venda->frame_value;
        });

        $valorTotal = $vendas->sum('total_product_value') + $vendas->sum('total_frame_value');
        $valorTotalComissoes = $vendas->sum('total_commission');
        $valorTotalComissoesPagas = $vendas->sum('total_commission_paid');

    @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">Histórico de vendas </h3>

                        {{-- <div class="page-breadcrumb">
                            <nav aria-label="breadcrumb">
                                <ol class="breadcrumb">
                                    <li class="breadcrumb-item"><a href="https://www.tecnopartes.com.br/comissao/admin/"
                                            class="breadcrumb-link">Início</a></li>
                                    <li class="breadcrumb-item active" aria-current="page">Histórico de vendas</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, ',', '.') }}</h3>
                            </div>

                        </div>
                    </div>
                </div>
                <!-- /. metric -->
                <!-- metric -->
                <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, ',', '.') }}</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">Ano de referência</h5>
                            <div class="metric-value d-inline-block d-flex">
                                <form action="">
                                    <input type="hidden" value="{{$user_id}}" name="id">
                                    <select name="year" id="" style="border-radius:10px; padding: 5px 15px; font-size:1.1rem;" class="text-primary">
                                        <option {{$yearAtual == $ano ? 'selected' : ''}} value="{{$ano}}">{{ $ano }}</option>

                                        @for ($i=0; $i < 6; $i++)
                                            <option  {{$yearAtual == $ano-($i+1) ? 'selected' : ''}} value="{{ $ano-($i+1) }}">{{ $ano-($i+1) }}</option>
                                        @endfor
                                    </select>
                                    <input class="ml-2 btn-primary" style="height: 30px;" type="submit" value="Filtrar">
                                </form>
                            </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 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">Mês de referência</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 ($vendas as $venda)
                                            <tr>
                                                <td>{{ $user->id }}</td>
                                                <td>{{ $user->name }}</td>
                                                <td>{{ 'R$ ' . number_format($venda->total_product_value + $venda->total_frame_value, 2, ',', '.') }}
                                                <td>{{ 'R$ ' . number_format($venda->total_commission, 2, ',', '.') }}
                                                <td>{{ 'R$ ' . number_format($venda->total_commission_paid, 2, ',', '.') }}
                                                <td>{{ 'R$ ' . number_format($venda->total_commission - $venda->total_commission_paid, 2, ',', '.') }}

                                                <td>{{ $venda->month_name }} de {{ $yearAtual }}</td>

                                                <td colspan="5"><a href="{{route('resumo_vendedor', ['vendedor' => $_GET['id'], 'mes' => $venda->month])}}"
                                                        class="btn btn-outline-light float-right">Visualizar</a></td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection