@extends('layouts.Admin.master')

<!-- Include necessary libraries -->
<script src="https://cdn.jsdelivr.net/npm/apexcharts"></script>

<link href="https://unpkg.com/boxicons@2.1.4/css/boxicons.min.css" rel="stylesheet">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@mdi/font@5.5.55/css/materialdesignicons.min.css">

@section('content')
    <div class="container">


        <div class="row">


            <div class="col-md-12 mb-4">
                <div class="card shadow-sm">
                    <div class="card-body">
                        <h5 class="card-title text-center">المؤشرات العقارية</h5>
                        <form id="propertySearchForm" method="POST" action="{{ route('auctionviewData') }}">
                            @csrf
                            <div class="row">
                                <div class="mb-3">
                                    <label for="propertyType" class="form-label">نوع العقار</label>
                                    <select class="form-control" name="property_type_id" data-trigger
                                        name="choices-single-default" id="choices-single-default" placeholder=" نوع العقار">
                                        <option value="">اختر نوع العقار</option>
                                        @foreach (App\Models\Lookups\PropertyType::all() as $data)
                                            <option value="{{ $data->id }}">{{ $data->name }}
                                            </option>
                                        @endforeach


                                    </select>
                                </div>


                                <div class="mb-3">

                                    <label for="periodFrom" class="form-label">الفترة من</label>
                                    <input type="date" class="form-control" id="periodFrom" name="start_date">

                                    <label for="periodTo" class="form-label">إلى</label>
                                    <input type="date" class="form-control" id="periodTo" name="end_date">
                                </div>



                                <div class="mb-3">
                                    <label for="region" class="form-label">اختر المنطقة</label>
                                    <select class="form-control" name="region_id" data-trigger name="choices-single-default"
                                        id="choices-single-default" placeholder="المنطقة">
                                        <option value="">اختر منطقة </option>
                                        @foreach (App\Models\Lookups\Region::all() as $data)
                                            <option value="{{ $data->id }}">{{ $data->name }}
                                            </option>
                                        @endforeach


                                    </select>
                                </div>


                                <button type="submit" class="btn btn-primary w-100">اطلاع</button>


                            </div>

                        </form>
                    </div>
                </div>
            </div>
            <div class="col-md- mb-4">
                <div class="card shadow-sm">
                    <div class="card-body">
                        <h5 class="card-title text-center">نشاط المناطق في المزادات العقارية</h5>

                        <!-- Scrollable Table Container -->
                        <div class="row">
                            <!-- Scrollable Table -->

                            <div style="max-height: 400px; overflow-y: auto; padding-right: 10px;">
                                @if (!empty($property) && count($property) > 0)
                                    @php
                                        $groupedByRegion = collect($property)->groupBy('region.name');
                                        $regionNames = $groupedByRegion->keys();
                                        $auctionCounts = $groupedByRegion->map(
                                            fn($props) => $props->pluck('auction.id')->unique()->count(),
                                        );
                                    @endphp

                                    <table class="table table-striped table-bordered text-center">
                                        <thead class="table-primary">
                                            <tr>
                                                <th>المنطقة</th>
                                                <th>عدد المزادات</th>
                                                <th>عدد أنواع المزادات</th>
                                                <th>عدد العقارات</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($groupedByRegion as $regionName => $properties)
                                                <tr>
                                                    <td>{{ $regionName ?? 'غير محدد' }}</td>
                                                    <td>{{ $properties->pluck('auction.id')->unique()->count() }}</td>
                                                    <td>{{ $properties->pluck('auction.auctionType.id')->unique()->count() }}
                                                    </td>
                                                    <td>{{ $properties->count() }}</td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                @else
                                    <div class="alert alert-warning text-center">
                                        لا توجد بيانات متاحة لعرضها.
                                    </div>
                                @endif
                            </div>
                        </div>
                    </div>
                    <div class="row">
                        <!-- Chart Container -->
                        <div>
                            <div id="regionChart"></div>
                        </div>
                    </div>

                    <!-- Include ApexCharts -->

                    @php
                        $auctionCounts = collect([]);
                        $regionNames = collect([]);
                    @endphp

                    @if (!empty($property) && count($property) > 0)
                        @php
                            $groupedByRegion = collect($property)->groupBy('region.name');
                            $regionNames = $groupedByRegion->keys();
                            $auctionCounts = $groupedByRegion->map(
                                fn($props) => $props->pluck('auction.id')->unique()->count(),
                            );
                        @endphp
                    @endif

                    <script>
                        document.addEventListener("DOMContentLoaded", function() {
                            var options = {
                                series: [{
                                    name: 'عدد المزادات',
                                    data: {!! json_encode($auctionCounts->values()) !!}
                                }],
                                chart: {
                                    type: 'bar',
                                    height: 400
                                },
                                plotOptions: {
                                    bar: {
                                        horizontal: false,
                                        columnWidth: '55%',
                                        endingShape: 'rounded'
                                    }
                                },
                                dataLabels: {
                                    enabled: false
                                },
                                xaxis: {
                                    categories: {!! json_encode($regionNames) !!}
                                },
                                fill: {
                                    opacity: 1
                                },
                                colors: ['#537bb4']
                            };

                            var chart = new ApexCharts(document.querySelector("#regionChart"), options);
                            chart.render();
                        });
                    </script>

                </div>
            </div>
        </div>

        <div class="row">
            <!-- Sales Table -->
            <div class="col-md-6">
                <div class="card shadow-sm">
                    <div class="card-body">
                        <h5 class="card-title text-center">إجمالي المبيعات حسب المنطقة</h5>

                        <div style="max-height: 400px; overflow-y: auto; padding-right: 10px;">
                            @if (!empty($property) && count($property) > 0)
                                @php
                                    $groupedByRegion = collect($property)->groupBy('region.name');
                                    $regionNames = $groupedByRegion->keys();
                                    $salesData = $groupedByRegion->map(
                                        fn($props) => $props->sum(fn($item) => (float) ($item['sales_price'] ?? 0)),
                                    );
                                @endphp

                                <table class="table table-striped table-bordered text-center">
                                    <thead class="table-primary">
                                        <tr>
                                            <th>المنطقة</th>
                                            <th>إجمالي المبيعات</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($groupedByRegion as $regionName => $properties)
                                            <tr>
                                                <td>{{ $regionName ?? 'غير محدد' }}</td>
                                                <td class="sales-value" data-region="{{ $regionName }}">
                                                    {{ number_format($properties->sum(fn($item) => (float) ($item['sales_price'] ?? 0)), 2) }}
                                                    <img style="width: 5%" src="{{ asset('img/ry.png') }}">
                                                </td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            @else
                                <div class="alert alert-warning text-center">
                                    لا توجد بيانات متاحة لعرضها.
                                </div>
                            @endif
                        </div>
                    </div>
                </div>
            </div>

            <!-- Chart Container -->
            <div class="col-md-6">
                <div class="card shadow-sm">
                    <div class="card-body">
                        <h5 class="card-title text-center">تحديث لحظي لإجمالي المبيعات حسب المنطقة</h5>
                        <div id="salesChart"></div>
                    </div>
                </div>
            </div>
        </div>

        @php
            $salesData = collect([]);
            $regionNames = collect([]);
        @endphp

        @if (!empty($property) && count($property) > 0)
            @php
                $groupedByRegion = collect($property)->groupBy('region.name');
                $regionNames = $groupedByRegion->keys();
                $salesData = $groupedByRegion->map(fn($props) => $props->sum('sales'));
            @endphp
        @endif

        <script>
            document.addEventListener("DOMContentLoaded", function() {
                var salesData = {!! json_encode($salesData->values()) !!};
                var regionNames = {!! json_encode($regionNames) !!};

                var options = {
                    series: [{
                        name: 'إجمالي المبيعات',
                        data: salesData
                    }],
                    chart: {
                        type: 'line',
                        height: 400,
                        animations: {
                            enabled: true,
                            easing: 'linear',
                            dynamicAnimation: {
                                speed: 2000
                            }
                        },
                        toolbar: {
                            show: false
                        }
                    },
                    stroke: {
                        curve: 'smooth'
                    },
                    xaxis: {
                        categories: regionNames
                    },
                    colors: ['#28a745'],
                    dataLabels: {
                        enabled: false
                    },
                    markers: {
                        size: 5
                    }
                };

                var chart = new ApexCharts(document.querySelector("#salesChart"), options);
                chart.render();

                // Simulating real-time data update every 5 seconds from the table
                setInterval(function() {
                    var newSalesData = [];
                    document.querySelectorAll('.sales-value').forEach(cell => {
                        newSalesData.push(parseFloat(cell.innerText.replace(/,/g, '')) || 0);
                    });

                    chart.updateSeries([{
                        data: newSalesData
                    }]);
                }, 5000);
            });
        </script>

        @php
            $platformAuctionCounts = collect([]);
            $platformNames = collect([]);

            if (!empty($property) && count($property) > 0) {
                $groupedByPlatform = collect($property)->groupBy('auction.auctionPlatform');
                $platformNames = $groupedByPlatform->keys();
                $platformAuctionCounts = $groupedByPlatform->map(fn($auctions) => $auctions->count());
            }
        @endphp
        <div class="row">
            <div class="col-md-6 mb-4">
                <div class="card shadow-sm">
                    <div class="card-body">
                        <h5 class="card-title text-center">المزادات حسب المنصة</h5>

                        <!-- Scrollable Table Container -->
                        <div style="max-height: 400px; overflow-y: auto; padding-right: 10px;">
                            @if ($platformAuctionCounts->isNotEmpty())
                                <table class="table table-striped table-bordered text-center">
                                    <thead class="table-primary">
                                        <tr>
                                            <th>اسم المنصة</th>
                                            <th>عدد المزادات</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($platformAuctionCounts as $platformName => $count)
                                            <tr>
                                                <td>{{ $platformName ?? 'غير محدد' }}</td>
                                                <td>{{ $count }}</td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            @else
                                <div class="alert alert-warning text-center">
                                    لا توجد بيانات متاحة لعرضها.
                                </div>
                            @endif
                        </div> <!-- End Scrollable Table Container -->
                    </div>
                </div>
            </div>

            <div class="col-md-6 mb-4">
                <div class="card shadow-sm">
                    <div class="card-body">
                        <!-- Pie Chart Container -->
                        <div id="platformChart" style="height: 400px;"></div>
                    </div>
                </div>
            </div>
        </div>

        <script>
            document.addEventListener("DOMContentLoaded", function() {
                var platformData = {!! json_encode($platformAuctionCounts->values()) !!};
                var platformNames = {!! json_encode($platformNames) !!};

                var options = {
                    series: platformData,
                    chart: {
                        type: 'pie',
                        height: 400
                    },
                    labels: platformNames,
                    colors: ['#ff6384', '#36a2eb', '#ffce56', '#4bc0c0', '#9966ff'],
                    responsive: [{
                        breakpoint: 480,
                        options: {
                            chart: {
                                width: 300
                            },
                            legend: {
                                position: 'bottom'
                            }
                        }
                    }]
                };

                var chart = new ApexCharts(document.querySelector("#platformChart"), options);
                chart.render();
            });
        </script>


        @php
            $propertyTypeLabels = collect([]);
            $totalSalesData = collect([]);

            if (!empty($property) && count($property) > 0) {
                $groupedByType = collect($property)->groupBy('propertyType.name');
                $propertyTypeLabels = $groupedByType->keys();
                $totalSalesData = $groupedByType->map(
                    fn($props) => $props->sum(fn($item) => (float) ($item['sales_price'] ?? 0)),
                );
            }
        @endphp

        <div class="row">
            <div class="col-md-6 mb-4">
                <div class="card shadow-sm">
                    <div class="card-body">
                        <h5 class="card-title text-center">إجمالي المبيعات حسب نوع العقار</h5>

                        <!-- Scrollable Table Container -->
                        <div style="max-height: 400px; overflow-y: auto; padding-right: 10px;">
                            @if ($totalSalesData->isNotEmpty())
                                <table class="table table-striped table-bordered text-center">
                                    <thead class="table-primary">
                                        <tr>
                                            <th>نوع العقار</th>
                                            <th>إجمالي المبيعات</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($totalSalesData as $type => $sales)
                                            <tr>
                                                <td>{{ $type ?? 'غير محدد' }}</td>
                                                <td>
                                                    {{ number_format($sales) }} <img style="width: 5%"
                                                        src="{{ asset('img/ry.png') }}">
                                                </td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            @else
                                <div class="alert alert-warning text-center">
                                    لا توجد بيانات متاحة لعرضها.
                                </div>
                            @endif
                        </div> <!-- End Scrollable Table Container -->
                    </div>
                </div>
            </div>

            <div class="col-md-6 mb-4">
                <div class="card shadow-sm">
                    <div class="card-body">
                        <div id="propertySalesChart" style="height: 400px;"></div>
                    </div>
                </div>
            </div>
        </div>
        <script>
            document.addEventListener("DOMContentLoaded", function() {
                var totalSalesData = {!! json_encode($totalSalesData->values()) !!};
                var propertyTypeLabels = {!! json_encode($propertyTypeLabels) !!};

                var options = {
                    series: [{
                            name: 'إجمالي المبيعات',
                            type: 'line',
                            data: totalSalesData
                        },
                        {
                            name: 'منطقة المبيعات',
                            type: 'area',
                            data: totalSalesData
                        }
                    ],
                    chart: {
                        type: 'line',
                        height: 400,
                        toolbar: {
                            show: false
                        }
                    },
                    stroke: {
                        curve: 'smooth',
                        width: [3, 2]
                    },
                    fill: {
                        type: 'gradient',
                        gradient: {
                            shadeIntensity: 0.4,
                            opacityFrom: 0.7,
                            opacityTo: 0.3
                        }
                    },
                    xaxis: {
                        categories: propertyTypeLabels
                    },
                    colors: ['#007bff', '#28a745'],
                    dataLabels: {
                        enabled: false
                    },
                    markers: {
                        size: 5
                    }
                };

                var chart = new ApexCharts(document.querySelector("#propertySalesChart"), options);
                chart.render();
            });
        </script>



    </div>
    </div>
@endsection