@extends('template.template')
@section('content')
@php
    $user_id = $_GET['vendedor'];

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

    $vendedor = User::find($user_id);

    $mesAtual = ucfirst(Carbon::create()
                ->month($_GET['mes'])
                ->locale('pt_BR')->monthName);;

    $mesNumber = $_GET['mes'];

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

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

    $valorTotalComissoes = $vendas->sum('commission');
    $valorTotalComissoesPagas = $vendas->sum('commission_paid');

    $vendasMesAtual = Venda::where('user_id', $user_id)
        ->whereRaw("month(date) = $mesNumber")
        ->orderBy('id', 'desc')
        ->get();

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


    $valorTotalComissoesMes = $vendasMesAtual->sum('commission');

@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">Resumo 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">Resumo de vendas</li>
                                </ol>
                            </nav>
                        </div> --}}
                    </div>
                </div>
            </div>
            <div class="row">
                <!-- 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">Vendedor</h5>
                            <div class="metric-value d-inline-block">
                                <h3 class="mb-1 text-primary">{{$vendedor->name}}</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">Total de vendas</h5>
                            <div class="metric-value d-inline-block">
                                <h3 class="mb-1 text-primary">{{ 'R$ ' . number_format($valorTotalMes, 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">Total de comissões</h5>
                            <div class="metric-value d-inline-block">
                                <h3 class="mb-1 text-primary">
                                    {{ 'R$ ' . number_format($valorTotalComissoesMes, 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">Mês de referência</h5>
                            <div class="metric-value d-inline-block">
                                <h3 class="mb-1 text-primary">{{$mesAtual}}</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 class="card">
                        <h5 class="card-header">RESUMO DE VENDA</h5>
                        <div class="card-body p-0">
                            <div class="table-responsive">
                                <table class="table">
                                    @foreach ($vendas as $venda)
                                        <thead class="bg-light">
                                            <tr class="border-0">
                                                @if (auth()->user()->is_admin)
                                                    <th class="border-0">Data de cadastro</th>
                                                @endif
                                                <th class="border-0">Data de venda</th>
                                                <th class="border-0">Nota Fiscal</th>
                                                <th class="border-0">Cliente</th>
                                                <th class="border-0">Valor de venda</th>
                                                <th class="border-0">Valor de comissão</th>
                                                <th class="border-0">Forma de pagamento</th>
                                                <th class="border-0">Condição</th>
                                                <th class="border-0">Empresa</th>
                                                <th class="border-0">Tipo de material</th>
                                                <th class="border-0">Cliente quitou?</th>
                                                <th class="border-0"></th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <tr>
                                                @if (auth()->user()->is_admin)
                                                @php
                                                    $createdDate = Carbon::parse($venda->created_at);
                                                    $vendaDate = Carbon::parse($venda->date);
                                                    $is_red = $createdDate->month > $vendaDate->month && !(Carbon::now()->day == 1) && is_null($venda->commission_paid);
                                                @endphp
                                                    <td style="color: {{ $is_red ? 'rgb(173, 0, 0)' : '' }}">{{ $createdDate->format('d/m/Y') }}</td>
                                                @endif
                                                <td>{{ Carbon::parse($venda->date)->format('d/m/Y') }}</td>
                                                <td>{{ $venda->invoice }}</td>
                                                <td>{{ $venda->client_name }}</td>
                                                <td>{{ 'R$ ' . number_format($venda->product_value + $venda->frame_value, 2, ',', '.') }}</td>
                                                <td>{{ 'R$ ' . number_format($venda->commission, 2, ',', '.') }}</td>
                                                {{-- <td>{{ 'R$ ' . number_format($venda->commission_paid, 2, ',', '.') }}</td> --}}
                                                <td>{{ $venda->payment_method }}</td>
                                                <td>{{ $venda->condition }}</td>
                                                <td>{{ $venda->company }}</td>
                                                <td>{{ $venda->product_type == 'PRODUCT' ? 'Produto' : ($venda->product_type == 'FRAME' ? 'Quadro' : 'Produto e Quadro') }}
                                                </td>
                                                <td>
                                                    @if ($venda->settled)
                                                        Quitado |
                                                        <a style="font-size: 0.8rem; color: blue;" href="{{route('quitar', ['id' => $venda->id])}}">(desfazer)</a>
                                                    @else
                                                        <a class="btn btn-sm  btn-outline-light"
                                                            style="margin-right:5px; border-color: #007003;"
                                                            href="{{route('quitar', ['id' => $venda->id])}}">
                                                            Quitar
                                                        </a>
                                                    @endif
                                                </td>
                                                <td>
                                                    <a href="{{ route('venda', ['id' => $venda->id]) }}">
                                                        <button
                                                            class="btn btn-sm float-right btn-outline-light">Editar</button>
                                                    </a>
                                                </td>
                                            </tr>
                                        </tbody>
                                    @endforeach
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection