@extends('admin.admin_master')
@section('admin')
    <div class="page-content">
        <div class="container-fluid">

            <!-- start page title -->
            <div class="row">
                <div class="col-12">
                    <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                        <h4 class="mb-sm-0">Dashboard</h4>

                        <div class="page-title-right">
                            <ol class="breadcrumb m-0">
                                <li class="breadcrumb-item"><a href="javascript: void(0);">Kalyani's</a></li>
                                <li class="breadcrumb-item active">Dashboard</li>
                            </ol>
                        </div>

                    </div>
                </div>
            </div>
            <!-- end page title -->
            @if ($current_user->user_groups == 1)
                <div class="row">
                    <div class="col-xl-3 col-md-6">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex">
                                    <div class="flex-grow-1">
                                        <p class="text-truncate font-size-14 mb-2">Total Sales</p>
                                        <h4 class="mb-2">&#8377; {{ $total_sale }}</h4>
                                        {{-- <p class="text-muted mb-0"><span class="text-success fw-bold font-size-12 me-2"><i
                                                    class="ri-arrow-right-up-line me-1 align-middle"></i>0.00%</span>from
                                            previous period</p> --}}
                                    </div>
                                    <div class="avatar-sm">
                                        <span class="avatar-title bg-light text-primary rounded-3">
                                            <i class="mdi mdi-currency-inr font-size-24"></i>
                                        </span>
                                    </div>
                                </div>
                            </div><!-- end cardbody -->
                        </div><!-- end card -->
                    </div><!-- end col -->
                    <div class="col-xl-3 col-md-6">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex">
                                    <div class="flex-grow-1">
                                        <p class="text-truncate font-size-14 mb-2">New Orders</p>
                                        <h4 class="mb-2">{{ $new_order }}</h4>
                                        {{-- <p class="text-muted mb-0"><span class="text-danger fw-bold font-size-12 me-2"><i
                                                    class="ri-arrow-right-down-line me-1 align-middle"></i>0.00%</span>from
                                            previous period</p> --}}
                                    </div>
                                    <div class="avatar-sm">
                                        <span class="avatar-title bg-light text-success rounded-3">
                                            <i class="mdi mdi-currency-inr font-size-24"></i>
                                        </span>
                                    </div>
                                </div>
                            </div><!-- end cardbody -->
                        </div><!-- end card -->
                    </div><!-- end col -->
                    <div class="col-xl-3 col-md-6">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex">
                                    <div class="flex-grow-1">
                                        <p class="text-truncate font-size-14 mb-2">Customer</p>
                                        <h4 class="mb-2">{{ $total_customer }}</h4>
                                        {{-- <p class="text-muted mb-0"><span class="text-success fw-bold font-size-12 me-2"><i
                                                    class="ri-arrow-right-up-line me-1 align-middle"></i>16.2%</span>from
                                            previous period</p> --}}
                                    </div>
                                    <div class="avatar-sm">
                                        <span class="avatar-title bg-light text-primary rounded-3">
                                            <i class="ri-user-3-line font-size-24"></i>
                                        </span>
                                    </div>
                                </div>
                            </div><!-- end cardbody -->
                        </div><!-- end card -->
                    </div><!-- end col -->
                    <div class="col-xl-3 col-md-6">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex">
                                    <div class="flex-grow-1">
                                        <p class="text-truncate font-size-14 mb-2">Sales Visit</p>
                                        <h4 class="mb-2">{{ $sales_visit }}</h4>
                                    </div>
                                    <div class="avatar-sm">
                                        <span class="avatar-title bg-light text-success rounded-3">
                                            <i class="mdi mdi-currency-btc font-size-24"></i>
                                        </span>
                                    </div>
                                </div>
                            </div><!-- end cardbody -->
                        </div><!-- end card -->
                    </div><!-- end col -->
                </div><!-- end row -->
            @endif
            <!--  Sales User -->

            @if ($current_user->user_groups > 1)
                <div class="row">
                    <div class="col-xl-6 col-md-6">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex">
                                    <div class="flex-grow-1">
                                        <p class="text-truncate font-size-14 mb-2">My Sales</p>
                                        <h4 class="mb-2">0</h4>
                                        <p class="text-muted mb-0"><span class="text-success fw-bold font-size-12 me-2"><i
                                                    class="ri-arrow-right-up-line me-1 align-middle"></i>0.00%</span>from
                                            previous period</p>
                                    </div>
                                    <div class="avatar-sm">
                                        <span class="avatar-title bg-light text-primary rounded-3">
                                            <i class="ri-shopping-cart-2-line font-size-24"></i>
                                        </span>
                                    </div>
                                </div>
                            </div><!-- end cardbody -->
                        </div><!-- end card -->
                    </div><!-- end col -->
                    <div class="col-xl-6 col-md-6">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex">
                                    <div class="flex-grow-1">
                                        <p class="text-truncate font-size-14 mb-2">Customer</p>
                                        <h4 class="mb-2">1</h4>
                                        <p class="text-muted mb-0"><span class="text-success fw-bold font-size-12 me-2"><i
                                                    class="ri-arrow-right-up-line me-1 align-middle"></i>16.2%</span>from
                                            previous period</p>
                                    </div>
                                    <div class="avatar-sm">
                                        <span class="avatar-title bg-light text-primary rounded-3">
                                            <i class="ri-user-3-line font-size-24"></i>
                                        </span>
                                    </div>
                                </div>
                            </div><!-- end cardbody -->
                        </div><!-- end card -->
                    </div><!-- end col -->
                </div>



                <div class="row">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-header ">
                                <h4 class="card-title mb-4">Product Price Area Wise</h4>
                            </div>
                            <div class="card-body">
                                <table style="font-size:12px" class="table table-bordered dt-responsive nowrap table-fixed">
                                    @foreach ($category as $key => $item)
                                        <thead style="position: sticky;top: 0">
                                            <tr style="background-color: #505d69;color:#fff">
                                                <th class="header" scope="col">{{ $item->name }}</th>
                                                <th class="header" scope="col"> MRP (&#8377;) </th>
                                                @foreach ($areas as $key1 => $areai)
                                                    <th class="header" scope="col">{{ $areai->name }} (&#8377;) </th>
                                                @endforeach
                                            </tr>
                                            <thead>
                                            <tbody>
                                                @foreach ($product as $key2 => $producti)
                                                    @if ($producti->category_id == $item->id)
                                                        <tr>
                                                            <td>{{ $producti->name }}</td>
                                                            <td>{{ $producti->mrp_price }}</td>
                                                            @foreach ($areas as $key1 => $areai)
                                                                <td>
                                                                    {{ isset($producAreaData[$areai->id][$producti->id]) ? $producAreaData[$areai->id][$producti->id] : '0.00' }}
                                                                </td>
                                                            @endforeach
                                                        </tr>
                                                    @endif
                                                @endforeach
                                            </tbody>
                                    @endforeach
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            @endif

            <div class="row">


                <div class="row">
                    <div class="col-xl-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="dropdown float-end">
                                    <a href="#" class="dropdown-toggle arrow-none card-drop"
                                        data-bs-toggle="dropdown" aria-expanded="false">
                                        <i class="mdi mdi-dots-vertical"></i>
                                    </a>

                                </div>

                                <h4 class="card-title mb-4">Latest Transactions</h4>

                                <div class="table-responsive">
                                    <table class="table table-centered mb-0 align-middle table-hover table-nowrap">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Invoice Id</th>
                                                <th>Customer Name</th>
                                                <th>Date</th>
                                                <th>Status</th>
                                                <th style="width: 120px;">Amount</th>
                                            </tr>
                                        </thead><!-- end thead -->
                                        <tbody>

                                            @foreach ($invoice_latest as $key => $item)
                                                <tr>
                                                    <td>#{{ $item->invoice_id }} </td>
                                                    <td>{{ $item->customer->name }} </td>
                                                    <td>{{ date('Y-m-d', strtotime($item->created_at)) }} </td>
                                                    <td>
                                                        <div class="font-size-13"><i
                                                                class="ri-checkbox-blank-circle-fill font-size-10 text-success align-middle me-2"></i>Active
                                                        </div>
                                                    </td>
                                                    <td>&#8377; {{ $item->total_amount }} </td>

                                                </tr>
                                            @endforeach
                                        </tbody><!-- end tbody -->
                                    </table>
                                    <!-- end table -->
                                </div>
                            </div><!-- end card -->
                        </div><!-- end card -->
                    </div>
                    <!-- end col -->



                </div>
                <!-- end row -->
            </div>

        </div>
    @endsection