@extends('layouts.master')
@section('title')
    @lang('Escritorio')
@endsection

@php


    # Obtener los pedidos de venta más recientes utilizando Carbon para filtrar por fecha.

    $startOfDay = Carbon\Carbon::now('America/Caracas')->startOfDay();
    $endOfDay = Carbon\Carbon::now('America/Caracas')->endOfDay();

    # Obtener los pedidos de venta que fueron creados dentro del rango de tiempo del día actual.

    $recentOrders = App\Models\Sale::with('client', 'currency', 'condition', 'shipping', 'saleDetails', 'seller')
        ->whereBetween('created_at', [$startOfDay, $endOfDay])
        ->get();


    if (!$recentOrders->isEmpty())
    {
        $recentOrders = $recentOrders->map(function ($order) {
                        return [
                            'id' => $order->id,
                            'serial' => $order->serial,
                            'description' => $order->description,
                            'delivery_address' => $order->delivery_address,
                            'client_name' => $order->client ? $order->client->description : null,
                            'client_rif' => $order->client ? $order->client->rif : null,
                            'region_description' => $order->client->region ? $order->client->region->region_description : null,
                            'currency_code' => $order->currency ? $order->currency->currency_code : null,
                            'condition_description' => $order->condition ? $order->condition->condition_description : null,
                            'seller_name' => $order->seller ? $order->seller->users()->first()->name : null,
                            'shipping_description' => $order->shipping ? $order->shipping->description : null,
                            'subtotal_amount' => $order->subtotal,
                            'tax_amount' => $order->tax_amount,
                            'discount_amount' => $order->discount_amount,
                            'total_amount' => $order->total,
                            'issue_date' => Carbon\Carbon::parse($order->issue_date)->format('d-m-Y'),
                            'due_date' => Carbon\Carbon::parse($order->due_date)->format('d-m-Y'),
                            'status' => $order->status,
                            'products' => $order->saleDetails->map(function ($detail) {
                                return [
                                    'product_code' => $detail->product_code,
                                    'product_description' => $detail->product ? $detail->product->description : null,
                                    'unit_code' => $detail->unit_code,
                                    'quantity' => $detail->quantity,
                                    'unit_price' => $detail->unit_price,
                                    'tax_amount' => $detail->tax_amount,
                                    'tax_type' => $detail->tax ? $detail->tax->description : null,
                                    'tax_percent' => $detail->tax ? $detail->tax->rate : null,
                                ];
                            }),
                        ];
                    });
    }

    // dd($recentOrders);

    # Obtener el inicio y el fin del mes actual utilizando Carbon.

    $startOfMonth = Carbon\Carbon::now('America/Caracas')->startOfMonth();
    $endOfMonth = Carbon\Carbon::now('America/Caracas')->endOfMonth();

    # Contar los pedidos de ventas que fueron creados dentro del rango de tiempo del mes actual.

    $monthlyOrdersCount = App\Models\Sale::whereBetween('created_at', [$startOfMonth, $endOfMonth])->count();

    # Obtener la suma total de los montos de los pedidos de ventas que fueron creados dentro del rango de tiempo del mes actual.

    $monthlySalesTotal = App\Models\Sale::WhereIn('status', [2, 3])->whereBetween('created_at', [$startOfMonth, $endOfMonth])->sum('total');

    // dd($monthlyOrdersCount, $monthlySalesTotal);

@endphp

@section('css')
    <link href="{{ URL::asset('build/libs/jsvectormap/jsvectormap.min.css') }}" rel="stylesheet" type="text/css" />
    <link href="{{ URL::asset('build/libs/swiper/swiper-bundle.min.css') }}" rel="stylesheet" type="text/css" />
@endsection
@section('content')
    <div class="row">
        <div class="col">

            <div class="h-100">

                <div class="row">
                    <div class="col-xl-4">
                        <div class="row">
                            <div class="col-xl-12 col-md-12">
                                <!-- card -->
                                <div class="card card-animate">
                                    <div class="card-body">
                                        <div class="d-flex align-items-center">
                                            <div class="flex-grow-1 overflow-hidden">
                                                <p class="text-uppercase fw-medium text-muted text-truncate mb-0">
                                                    Total Facturado Mensual</p>
                                            </div>
                                        </div>
                                        <div class="d-flex align-items-end justify-content-between mt-4">
                                            <div>
                                                <h4 class="fs-22 fw-semibold ff-secondary mb-4">$<span class="counter-value" data-target="{{ $monthlySalesTotal }}" data-decimals="2">0</span>
                                                </h4>
                                                <span class="text-muted">Monto facturado en el mes</span>
                                            </div>
                                            <div class="avatar-sm flex-shrink-0">
                                                <span class="avatar-title bg-success-subtle rounded fs-3">
                                                    <i class="bx bx-dollar-circle text-success"></i>
                                                </span>
                                            </div>
                                        </div>
                                    </div><!-- end card body -->
                                </div><!-- end card -->
                            </div><!-- end col -->

                            <div class="col-xl-12 col-md-12">
                                <!-- card -->
                                <div class="card card-animate">
                                    <div class="card-body">
                                        <div class="d-flex align-items-center">
                                            <div class="flex-grow-1 overflow-hidden">
                                                <p class="text-uppercase fw-medium text-muted text-truncate mb-0">Total Pedidos del Mes</p>
                                            </div>
                                        </div>
                                        <div class="d-flex align-items-end justify-content-between mt-4">
                                            <div>
                                                <h4 class="fs-22 fw-semibold ff-secondary mb-4"><span class="counter-value" data-target="{{ $monthlyOrdersCount }}" data-decimals="0">0</span></h4>
                                                <a href="" class="text-decoration-underline text-muted">Cantidad de pedidos mensuales</a>
                                            </div>
                                            <div class="avatar-sm flex-shrink-0">
                                                <span class="avatar-title bg-info-subtle rounded fs-3">
                                                    <i class="bx bx-shopping-bag text-info"></i>
                                                </span>
                                            </div>
                                        </div>
                                    </div><!-- end card body -->
                                </div><!-- end card -->
                            </div><!-- end col -->
                        </div> <!-- end row-->
                    </div>
                    <div class="col-xl-8">
                        <div class="card">
                            <div class="card-header border-0 align-items-center d-flex">
                                <h4 class="card-title mb-0 flex-grow-1">Ventas Mensuales</h4>
                            </div><!-- end card header -->

                            <div class="card-header p-0 border-0 bg-light-subtle">
                                <div class="row g-0 text-center">
                                    <div class="col-6 col-sm-4">
                                        <div class="p-3 border border-dashed border-start-0">
                                            <h5 class="mb-1"><span class="counter-value" data-target="7585">0</span></h5>
                                            <p class="text-muted mb-0">Pedidos</p>
                                        </div>
                                    </div>
                                    <!--end col-->
                                    <div class="col-6 col-sm-4">
                                        <div class="p-3 border border-dashed border-start-0">
                                            <h5 class="mb-1">$<span class="counter-value" data-target="22.89">0</span>k</h5>
                                            <p class="text-muted mb-0">Ganancias</p>
                                        </div>
                                    </div>
                                    <!--end col-->
                                    <div class="col-6 col-sm-4">
                                        <div class="p-3 border border-dashed border-start-0">
                                            <h5 class="mb-1"><span class="counter-value" data-target="367">0</span></h5>
                                            <p class="text-muted mb-0">Pedidos Rechazados</p>
                                        </div>
                                    </div>
                                    <!--end col-->
                                </div>
                            </div><!-- end card header -->

                            <div class="card-body p-0 pb-2">
                                <div class="w-100">
                                    <div id="customer_impression_charts" data-colors='["--vz-success", "--vz-info", "--vz-danger"]' class="apex-charts" dir="ltr"></div>
                                </div>
                            </div><!-- end card body -->
                        </div><!-- end card -->
                    </div><!-- end col -->
                </div>

                <div class="row">

                    <div class="col-xl-12">
                        <div class="card">
                            <div class="card-header align-items-center d-flex">
                                <h4 class="card-title mb-0 flex-grow-1">Pedidos Recientes</h4>
                            </div><!-- end card header -->

                            <div class="card-body">
                                <div class="table-responsive table-card">
                                    <table class="table table-borderless table-centered align-middle table-nowrap mb-0">
                                        <thead class="text-muted table-light">
                                            <tr>
                                                <th scope="col">ID de Pedido</th>
                                                <th scope="col">Cliente</th>
                                                <th scope="col">Zona de Pedido</th>
                                                <th scope="col">Tipo Moneda</th>
                                                <th scope="col">Subtotal</th>
                                                <th scope="col">Total</th>
                                                <th scope="col">Vendedor</th>
                                                <th scope="col">Estado</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @if ($recentOrders->isEmpty())
                                                <tr>
                                                    <td colspan="8" class="text-center">No hay pedidos recientes.</td>
                                                </tr>
                                            @else
                                                @foreach ($recentOrders as $order)
                                                    <tr>
                                                        <td>
                                                            <span class="fw-medium link-primary">{{ $order['serial'] }}</span>
                                                        </td>
                                                        <td>
                                                            <div class="d-flex align-items-center">
                                                                <div class="flex-grow-1">{{ $order['client_name'] ?? 'N/A' }} <small class="text text-muted">{{ $order['client_rif'] ?? '' }}</small></div>
                                                            </div>
                                                        </td>
                                                        <td>{{ $order['region_description'] ?? 'N/A' }}</td>
                                                        <td>{{ $order['currency_code'] ?? 'N/A' }}</td>
                                                        <td>
                                                            <span class="text-success">{{ number_format($order['subtotal_amount'], 2) }}</span>
                                                        </td>
                                                        <td>
                                                            <span class="text-primary">{{ number_format($order['total_amount'], 2) }}</span>
                                                        </td>
                                                        <td>{{ $order['seller_name'] ?? 'N/A' }}</td>
                                                        <td>
                                                            @if ($order['status'] == '1')
                                                                <span class="badge bg-waring-subtle text-warning">Pendiente</span>
                                                            @elseif ($order['status'] == '2')
                                                                <span class="badge bg-success-subtle text-secondary">Aprobado</span>
                                                            @elseif ($order['status'] == '3')
                                                                <span class="badge bg-secundary-subtle text-success">Facturado</span>
                                                            @else
                                                                <span class="badge bg-danger-subtle text-danger">Rechazado</span>
                                                            @endif
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            @endif<!-- end tr -->

                                        </tbody><!-- end tbody -->
                                    </table><!-- end table -->
                                </div>
                            </div>
                        </div> <!-- .card-->
                    </div> <!-- .col-->
                </div> <!-- end row-->

            </div> <!-- end .h-100-->

        </div> <!-- end col -->

    </div>
@endsection
@section('script')
    <!-- apexcharts -->
    <script src="{{ URL::asset('build/libs/apexcharts/apexcharts.min.js') }}"></script>
    <script src="{{ URL::asset('build/libs/jsvectormap/jsvectormap.min.js') }}"></script>
    <script src="{{ URL::asset('build/libs/jsvectormap/maps/world-merc.js') }}"></script>
    <script src="{{ URL::asset('build/libs/swiper/swiper-bundle.min.js') }}"></script>
    <!-- dashboard init -->
    <script src="{{ URL::asset('build/js/pages/dashboard-ecommerce.init.js') }}"></script>
    <script src="{{ URL::asset('build/js/app.js') }}"></script>
@endsection