@extends('backend.layouts.master')
@section('title')
    Home
@endsection
@push('styles')
    <style>
        .card-custom {
            margin: 20px 0;
        }
        .card-header-custom {
            background-color: #343a40;
            color: white;
        }
        .list-group-item-custom {
            background-color: #f8f9fa;
        }
    </style>
@endpush
@section('admin-content')

    <div class="main-panel">
        @include('backend.layouts.partials.message')
        <div class="content-wrapper">
            <div class="row">
                <div class="col-md-6 col-lg-6 col-xl-3 grid-margin stretch-card">
                    <div class="card">
                        <div class="card-body">
                            <div class="d-flex justify-content-between align-items-center">
                                {{--                                <div class="icon-wrap">--}}
                                {{--                                    <i class="mdi mdi-folder-outline"></i>--}}
                                {{--                                </div>--}}
                               <div class="flex-right-height">
                                    <p class="font-weight-bold mb-1">Total Flats</p>
                                    <h3>{{ $totalFlats }}</h3>
                                    <p class="font-weight-medium p-0"><span class="text-success mr-2"></span></p>
                                </div>

                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-md-6 col-lg-6 col-xl-3 grid-margin stretch-card">
                    <div class="card">
                        <div class="card-body">
                            <div class="d-flex justify-content-between align-items-center">
                                {{--                                <div class="icon-wrap">--}}
                                {{--                                    <i class="mdi mdi-clipboard-text"></i>--}}
                                {{--                                </div>--}}
                               <div class="flex-right-height">
                                    <p class="font-weight-bold mb-1">Total Sales</p>
                                    <h3>{{ $totalInvoices }}</h3>
                                    <p class="font-weight-medium p-0"><span class="text-success mr-2"></span></p>
                                </div>

                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-md-6 col-lg-6 col-xl-3 grid-margin stretch-card">
                    <div class="card">
                        <div class="card-body">
                            <div class="d-flex justify-content-between align-items-center">
                                {{--                                <div class="icon-wrap">--}}
                                {{--                                    <i class="mdi mdi-file-document"></i>--}}
                                {{--                                </div>--}}
                                <div class="flex-right-height">
                                    <p class="font-weight-bold mb-1">Available Flats</p>
                                    <h3>{{ $availableFlats }}</h3>

                                </div>

                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-md-6 col-lg-6 col-xl-3 grid-margin stretch-card">
                    <div class="card">
                        <div class="card-body">
                            <div class="d-flex justify-content-between align-items-center">
                                {{--                                <div class="icon-wrap">--}}
                                {{--                                    <i class="mdi mdi-account-outline"></i>--}}
                                {{--                                </div>--}}
                                <div class="flex-right-height">
                                    <p class="font-weight-bold mb-1">Total Customers</p>
                                    <h3>{{ $totalUsers }}</h3>

                                </div>

                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="row g-4">

                <div class="col-md-3 col-sm-6">
                    <div class="card shadow-sm border-0">
                        <div class="card-body text-center">
                            <p class="text-muted mb-1">Total Categories</p>
                            <h3 class="mb-0">{{ $totalCategories }}</h3>
                        </div>
                    </div>
                </div>


                <div class="col-md-3 col-sm-6">
                    <div class="card shadow-sm border-0">
                        <div class="card-body text-center">
                            <p class="text-muted mb-1">Today's Collection</p>
                            <h3 class="mb-0">{{ number_format($todayCollection, 2) }} ৳</h3>
                        </div>
                    </div>
                </div>

                <div class="col-md-3 col-sm-6">
                    <div class="card shadow-sm border-0 bg-info text-white">
                        <div class="card-body text-center">
                            <p class="mb-1">Total Investors</p>
                            <h3 class="mb-0">{{ $totalInvestors }}</h3>
                        </div>
                    </div>
                </div>

                <div class="col-md-3 col-sm-6">
                    <div class="card shadow-sm border-0 bg-success text-white">
                        <div class="card-body text-center">
                            <p class="mb-1">Total Investment</p>
                            <h3 class="mb-0">{{ number_format($totalInvestment, 2) }} ৳</h3>
                        </div>
                    </div>
                </div>

            </div>

            <!-- Category-wise Breakdown -->
            <div class="row mt-4">
                <div class="col-12">
                    <div class="card shadow-sm border-0">
                        <div class="card-body">
                            <h5 class="card-title mb-3">Category-wise Flats Breakdown</h5>
                            <div class="table-responsive">
                                <table class="table table-striped table-bordered mb-0">
                                    <thead class="table-dark">
                                        <tr>
                                            <th>Category</th>
                                            <th class="text-center">Total Flats</th>
                                            <th class="text-center">Sold</th>
                                            <th class="text-center">Available</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @forelse($categoryStats as $category)
                                            <tr>
                                                <td>{{ $category->name }}</td>
                                                <td class="text-center">{{ $category->total_flats }}</td>
                                                <td class="text-center text-danger">{{ $category->sold_flats }}</td>
                                                <td class="text-center text-success">{{ $category->available_flats }}</td>
                                            </tr>
                                        @empty
                                            <tr>
                                                <td colspan="4" class="text-center">No categories found.</td>
                                            </tr>
                                        @endforelse
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <!-- Project-wise Breakdown -->
            <div class="row mt-4">
                <div class="col-12">
                    <div class="card shadow-sm border-0">
                        <div class="card-body">
                            <h5 class="card-title mb-3">Project-wise Flats Breakdown</h5>
                            <div class="table-responsive">
                                <table class="table table-striped table-bordered mb-0">
                                    <thead class="table-primary">
                                        <tr>
                                            <th>Project</th>
                                            <th class="text-center">Total Flats</th>
                                            <th class="text-center">Sold</th>
                                            <th class="text-center">Available</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @forelse($projectStats as $project)
                                            <tr>
                                                <td>{{ $project->name }}</td>
                                                <td class="text-center">{{ $project->total_flats }}</td>
                                                <td class="text-center text-danger">{{ $project->sold_flats }}</td>
                                                <td class="text-center text-success">{{ $project->available_flats }}</td>
                                            </tr>
                                        @empty
                                            <tr>
                                                <td colspan="4" class="text-center">No projects found.</td>
                                            </tr>
                                        @endforelse
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>


            <div class="row mt-4">
                <div class="col-12">
                    <div class="card shadow-sm border-0">
                        <div class="card-body">
                            <h5 class="card-title mb-3">Date-wise Collection</h5>
                            <div class="table-responsive">
                                <table class="table table-striped table-bordered mb-0">
                                    <thead class="table-light">
                                        <tr>
                                            <th>Date</th>
                                            <th>Total Collected (৳)</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @forelse($dateWiseCollection as $data)
                                            <tr>
                                                <td>{{ $data->collection_date }}</td>
                                                <td>{{ number_format($data->total_paid, 2) }}</td>
                                            </tr>
                                        @empty
                                            <tr>
                                                <td colspan="2" class="text-center">No collection data found.</td>
                                            </tr>
                                        @endforelse
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>



        </div>
        <!-- content-wrapper ends -->
        <!-- partial:partials/_footer.html -->
        <footer class="footer">
            <div class="d-sm-flex justify-content-center justify-content-sm-between">
                <span class="text-muted text-center text-sm-left d-block d-sm-inline-block">Copyright © 2020 <a
                        href="https://www.hkdevs.tech/" target="_blank">HKDevelopers</a>. All rights reserved.</span>
                <span class="float-none float-sm-right d-block mt-1 mt-sm-0 text-center">Hand-crafted & made with <i
                        class="mdi mdi-heart text-danger"></i></span>
            </div>
        </footer>
        <!-- partial -->
    </div>
@endsection

@push('scripts')
@endpush