@extends('backend.admin.layouts.app')
@section('content')
    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <div class="content-header">
            <div class="container-fluid">
                <div class="row mb-2">
                    <div class="col-sm-6">
                        <h1 class="m-0 text-dark">Dashboard - {{ date('d F Y') }}</h1>
                    </div><!-- /.col -->

                </div><!-- /.row -->
            </div><!-- /.container-fluid -->
        </div>
        <!-- /.content-header -->

        <!-- Main content -->
        <section class="content">
            <div class="container-fluid">
                <!-- Small boxes (Stat box) -->
                <div class="row">
                    <div class="col-lg-3 col-6">
                        <!-- small box -->
                        <div class="small-box bg-danger">
                            <div class="inner">
                                <h3>{{ App\Models\Order::count() }}</h3>

                                <p>Orders</p>
                            </div>
                            <div class="icon">
                                <i class="ion ion-bag"></i>
                            </div>
                            <a href="{{ route('users.index', 'pending') }}" class="small-box-footer">More info <i
                                    class="fas fa-arrow-circle-right"></i></a>
                        </div>
                    </div>
                    <div class="col-lg-3 col-6">
                        <!-- small box -->
                        <div class="small-box bg-warning">
                            <div class="inner">
                                <h3>{{ App\Models\Vendor::count() }}</h3>

                                <p>Vendors/Shops</p>
                            </div>
                            <div class="icon">
                                <i class="ion ion-home"></i>
                            </div>
                            <a href="{{ route('vendors') }}" class="small-box-footer">More info <i
                                    class="fas fa-arrow-circle-right"></i></a>
                        </div>
                    </div>
                    <div class="col-lg-3 col-6">
                        <!-- small box -->
                        <div class="small-box bg-info">
                            <div class="inner">
                                <h3>{{ App\Models\Product::count() }}</h3>

                                <p>Products</p>
                            </div>
                            <div class="icon">
                                <i class="ion ion-stats-bars"></i>
                            </div>
                            <a href="{{ route('users.index', 'client') }}" class="small-box-footer">More info <i
                                    class="fas fa-arrow-circle-right"></i></a>
                        </div>
                    </div>
                    <div class="col-lg-3 col-6">
                        <!-- small box -->
                        <div class="small-box bg-success">
                            <div class="inner">
                                <h3>{{ App\Models\Category::count() }}</h3>

                                <p>Categories</p>
                            </div>
                            <div class="icon">
                                <i class="ion ion-person-add"></i>
                            </div>
                            <a href="{{ route('users.index', 'client') }}" class="small-box-footer">More info <i
                                    class="fas fa-arrow-circle-right"></i></a>
                        </div>
                    </div>


                </div>
                @php
$countryIds = App\Models\BankAccount::pluck('country_id')
    ->unique()
    ->values()
    ->all();

                @endphp
               @foreach ($countryIds as $country_id)
    @php
    $bankAccounts = App\Models\BankAccount::where('country_id', $country_id)->get();
    $country = App\Models\Country::find($country_id);
    @endphp
    <div class="col-12">
        <div class="card collapsed-card">
            <div class="card-header">
                <h3 class="card-title font-weight-bold">{{ $country->name ?? '' }}</h3>
                <div class="card-tools">
                    <button type="button" class="btn btn-tool" data-card-widget="collapse" title="Show">
                        <i class="fas fa-plus"></i>
                    </button>
                </div>
            </div>
            <div class="card-body" style="display: none;">
                <div class="row">
                    @php
    $total_balance = 0; // Initialize total balance for this country
                    @endphp
                    @foreach ($bankAccounts as $bankAccount)
                        @php
        $total_balance += $bankAccount->balance;
                        @endphp
                        <div class="col-lg-3 col-6">
                            <!-- small box -->
                            <div class="small-box bg-danger">
                                <div class="inner">
                                    <h3>{{ number_format($bankAccount->balance, 2) }} {{ !empty ($country->currency) ? $country->currency : '' }}</h3>
                                    <p class="font-weight-bold">{{ $bankAccount->bank_name }}</p>
                                </div>
                            </div>
                        </div>
                    @endforeach
                </div>
                <!-- Display total balance outside of bank account loop -->
                <div>Total Balance: {{ number_format($total_balance, 2) }} {{ !empty ($country->currency) ? $country->currency : '' }}</div>
            </div>
        </div>
    </div>
@endforeach

                <hr>
                <h4>{{ date('F') }}</h4>
                <div class="row mt-2">
                    <div class="col-md-12">
                        <div class="card">

                            <div class="card-body">
                                <div class="row">
                                    <div class="col-sm-3 col-6">
                                        <div class="description-block border-right">
                                            <h5>$35,210.43</h5>
                                            <h5 class="font-weight-bold">TOTAL REVENUE</h5>
                                        </div>
                                        <!-- /.description-block -->
                                    </div>
                                    <!-- /.col -->
                                    <div class="col-sm-3 col-6">
                                        <div class="description-block border-right">

                                            <h5>$35,210.43</h5>
                                            <h5 class="font-weight-bold">TOTAL COST</span>
                                        </div>
                                        <!-- /.description-block -->
                                    </div>
                                    <!-- /.col -->
                                    <div class="col-sm-3 col-6">
                                        <div class="description-block border-right">
                                            <h5>$35,210.43</h5>
                                            <h5 class="font-weight-bold">TOTAL PROFIT</span>
                                        </div>
                                        <!-- /.description-block -->
                                    </div>
                                    <!-- /.col -->
                                    <div class="col-sm-3 col-6">
                                        <div class="description-block">
                                            <h5>$35,210.43</h5>
                                            <h5 class="font-weight-bold">Donation</span>
                                        </div>
                                        <!-- /.description-block -->
                                    </div>
                                </div>
                            </div>
                            <!-- /.card-header -->

                        </div>
                    </div>

                </div>

            </div><!-- /.container-fluid -->
        </section>

        <!-- /.content -->
    </div>
@endsection