@extends('layouts.app')
@section('css')
    <style>
    .card {
        margin-bottom: 20px;
    }
    .chart-container {
        position: relative;
        height: 200px;
    }
    .stat-card {
        text-align: center;
        padding: 20px;
    }
    .filters {
        margin-bottom: 20px;
    }
    .bg-light-blue { background-color: #d1ecf1; }
    .bg-light-green { background-color: #d4edda; }
    .bg-light-red { background-color: #f8d7da; }
    .bg-light-yellow { background-color: #fff3cd; }

    .card-body li {
        padding: 10px;
        margin:10px;
    }
    .fixed-card-height {
        height: 400px; /* Adjust this value as needed */
    /*    overflow-y: auto; /* Optional: to add a scrollbar if content overflows */*/
    }
    </style>
@endsection
@section('content')
    <section class="content mb-5">
        <div class="container-fluid">
            @include('partials.title-pad', [
                'title' => __('Revenue'),
                'search' => $search,
                'searchPlaceholder' => __("Search Feature Name ..."),
                'list' => $subscriptions,
                // 'export' => 'premium.feature.export',
                'filter' => 'filter'
            ])
            <div class="mb-3 text-right">
                <a class="clear-filter" id="clear-filter">Clear Filters</a>
            </div>

            <div class="row">
                <div class="col-md-12">
                    <div class="mb-3">
                        <h6 class="my-2">Feature Wise Revenue</h6>
                        <div class="dashbed-border-bottom"></div>
                    </div>
                </div>
                <div class="col-md-12">
                    <div class="table-responsive bg-white">
                        <table class="table table-striped table-bordered admintable border-0" cellspacing="0"
                            cellpadding="0">
                            <tbody>
                                <tr>
                                    <th>S.No.</th>
                                    <th>Feature Name</th>
                                    <th>UOM</th>
                                    <th>Revenue Earned</th>
                                    <th>Total Active Users</th>
                                    <th>Total Past Users</th>
                                    <th>Total Recurring Users</th>
                                    <th>Action</th>
                                </tr>
                                @php
                                $startingIndex = ($subscriptions->currentPage() - 1) * $subscriptions->perPage() + 1;
                                @endphp
                                @forelse ($subscriptions as $key => $subscription)
                                    <tr>
                                        <td>{{++$key}}</td>
                                        <td>{{$subscription->feature->feature_name ?? 'NA'}}</td>
                                        <td>{{ucfirst($subscription->feature->unit_measurement) ?? 'NA'}}</td>
                                        <td>{{$subscription->total_price}}</td>
                                        <td><span class="badge badge-secondary">{{$subscription->active_users}}</span></td>
                                        <td><span class="badge badge-secondary">{{$subscription->last_month_users}}</span></td>
                                        <td>{{$subscription->recurring_count}}</td>
                                        <td>
                                            <a href="{{ route('masters.revenue.feature.detail', $subscription->feature->id) }}" class="text-dark f-16 mr-1"><i class="iconly-boldShow"></i></a>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="10">
                                            <p>
                                                <center class="text-danger">{{ __('labels.no_records_found') }}
                                                </center>
                                            </p>
                                        </td>
                                    </tr>
                                @endforelse
                                @if($subscriptions->count())
                                <tfoot>
                                    <tr>
                                        <td colspan="3"><strong>Grand Total</strong></td>
                                        <td><strong>{{ number_format($subscriptions->sum('total_price'), 2) }}</strong></td>
                                        <td colspan="4"></td>
                                        {{-- <td></td> --}}
                                        {{-- <td></td> --}}
                                    </tr>
                                </tfoot>
                                @endif
                            </tbody>
                        </table>
                        <br />
                    </div>
                </div>
                {{ $subscriptions->appends(request()->query())->links('partials.pagination') }}
            </div>

            {{-- Graph --}}
            <div class="row mt-4">
                <div class="col-md-4">
                    <div class="card fixed-card-height">
                        <div class="card-body">
                            <canvas id="universityChart" class="chart-container"></canvas>
                        </div>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="card fixed-card-height">
                        <div class="card-body">
                            <canvas id="genderChart" class="chart-container"></canvas>
                        </div>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="card fixed-card-height">
                        <div class="card-body">
                            <canvas id="courseChart" class="chart-container"></canvas>
                        </div>
                    </div>
                </div>
            </div>

            {{-- Second table start --}}
            <div class="row">
                <div class="col-md-12">
                    <div class="mb-3">
                        <h6 class="my-2">Package Wise Revenue</h6>
                        <div class="dashbed-border-bottom"></div>
                    </div>
                </div>
                <div class="col-md-12">
                    <div class="table-responsive bg-white">
                        <table class="table table-striped table-bordered admintable border-0" cellspacing="0"
                            cellpadding="0">
                            <tbody>
                                <tr>
                                    <th>#</th>
                                    <th>Package Name</th>
                                    <th>Revenue Earned</th>
                                    <th>Total Active Users</th>
                                    <th>Total Past Users</th>
                                    <th>Total Recurring Users</th>
                                    <th>Action</th>
                                </tr>
                                @php
                                $startingIndex = ($subscriptionPackages->currentPage() - 1) * $subscriptionPackages->perPage() + 1;
                                @endphp
                                @forelse ($subscriptionPackages as $key => $subscriptionPackage)
                                    <tr>
                                        <td>{{++$key}}</td>
                                        <td>{{$subscriptionPackage->package->name ?? 'NA'}}</td>
                                        <td>{{$subscriptionPackage->total_price}}</td>
                                        <td><span class="badge badge-secondary">{{$subscriptionPackage->active_users}}</span></td>
                                        <td><span class="badge badge-secondary">{{$subscriptionPackage->last_month_users}}</span></td>
                                        <td>{{$subscriptionPackage->recurring_count}}</td>
                                        <td>
                                            <a href="{{route('masters.revenue.package.detail', $subscriptionPackage->package_id)}}" class="text-dark f-16 mr-1"><i class="iconly-boldShow"></i></a>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="10">
                                            <p>
                                                <center class="text-danger">{{ __('labels.no_records_found') }}
                                                </center>
                                            </p>
                                        </td>
                                    </tr>
                                @endforelse
                                @if($subscriptionPackages->count())
                                <tfoot>
                                    <tr>
                                        <td colspan="2"><strong>Grand Total</strong></td>
                                        <td><strong>{{ number_format($subscriptionPackages->sum('total_price'), 2) }}</strong></td>
                                        <td colspan="4"></td>
                                        {{-- <td></td> --}}
                                        {{-- <td></td> --}}
                                    </tr>
                                </tfoot>
                                @endif
                            </tbody>
                        </table>
                        <br />
                    </div>
                </div>
                {{ $subscriptionPackages->appends(request()->query())->links('partials.pagination') }}
            </div>
            {{-- Second table end--}}

            {{-- Graph --}}
            <div class="row mt-4">
                <div class="col-md-4">
                    <div class="card fixed-card-height">
                        <div class="card-body">
                            <canvas id="universityChartPackage" class="chart-container"></canvas>
                        </div>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="card fixed-card-height">
                        <div class="card-body">
                            <canvas id="genderChartPackage" class="chart-container"></canvas>
                        </div>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="card fixed-card-height">
                        <div class="card-body">
                            <canvas id="courseChartPackage" class="chart-container"></canvas>
                        </div>
                    </div>
                </div>
            </div>

            <style>
                #clear-filter {
                    cursor: pointer;
                }
                #map1 {
                    height: 100%;
                }
                .footer-row {
                    margin-left: 118px !important;
                }
            </style>
        </div>

    </section>
    <div class="modal fade" id="filter" tabindex="-1" role="dialog" aria-labelledby="loginpopupTitle"
            aria-hidden="true">
            <div class="modal-dialog  modal-dialog-centered" role="document">
                <div class="modal-content bg-light modalPad">
                    <form class="needs-validation" novalidate>
                        <input type="hidden" name="search" value="{{request('search')}}">
                        <div class="modal-header position-relative border-0">
                            <div class="">
                                <button type="button" class="close-btn" data-dismiss="modal" aria-label="Close">
                                    <img src="{{ asset('assets/img/close.svg') }}" />
                                </button>
                                <div class="">
                                    <h5>{{ __('Feature Filter') }}</h5>
                                </div>

                            </div>
                        </div>
                        <div class="modal-body pt-0">
                            <form class="form" method="GET" action="{{ route('users.index') }}">
                                <div class="row">

                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <label for="exampleFormControlSelect1">{{ __('Select University') }}</label>
                                            <select class="form-control selectpicker" name="university_id">
                                                <option value="" {{ !request('university_id') ? 'selected' : ''}}>All</option>
                                                @foreach($universities as  $university)
                                                    <option value="{{$university->id}}" {{ request('university_id') == $university->id ? 'selected' : ''}}>{{$university->name}}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>

                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <label for="exampleFormControlSelect2">{{ __('Select Gender') }}</label>
                                            <select class="form-control selectpicker" name="gender">
                                                <option value="" {{ !request('gender') ? 'selected' : ''}}>All</option>
                                                @foreach($genders as  $gender)
                                                    <option value="{{$gender}}" {{ request('gender') == $gender ? 'selected' : ''}}>{{$gender}}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>

                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <label for="exampleFormControlSelect3">{{ __('Select Course') }}</label>
                                            <select class="form-control selectpicker" name="course_id">
                                                <option value="" {{ !request('course_id') ? 'selected' : ''}}>All</option>
                                                @foreach($courses as  $course)
                                                    <option value="{{$course->id}}" {{ request('course_id') == $course->id ? 'selected' : ''}}>{{$course->name}}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>

                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <label for="exampleFormControlSelect4">{{ __('Select Duration') }}</label>
                                            <select class="form-control selectpicker" name = "duration">
                                                <option value="" {{ !request('duration') ? 'selected' : ''}}>All</option>
                                                @foreach ($durationTypes as $key => $durationType)
                                                <option value = "{{ $durationType }}" {{request('duration') ==  $durationType ? 'selected' : ''}}>{{ ucfirst($durationType) }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>

                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <label for="exampleFormControlSelect5">{{ __('From Date') }}</label>
                                            <input type="date" name="from_date" class="form-control" value="{{request('from_date')}}">
                                        </div>
                                    </div>

                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <label for="exampleFormControlSelect6">{{ __('To') }}</label>
                                            <input type="date" name="to_date" class="form-control" value="{{request('to_date')}}">
                                        </div>
                                    </div>

                                    <div class="col-md-12 mt-1">
                                        <button type = "submit"
                                        class="btn btn-primary">{{ __('buttons.apply_filter') }}</button>
                                    </div>
                                </div>
                            </form>                         
                        </div>
                    </form>
                </div>
            </div>
        </div>
@endsection
@section('scripts')
<script src="{{asset('assets/js/chart/chart.js')}}"></script>
    <script>
        $(document).ready(function() {
            $('#clear-filter').on('click', function() {
                var currentURL = window.location.href.split('?')[0];
                window.location.href = currentURL;
            });
        });

        function getRandomColor() {
            var letters = '0123456789ABCDEF';
            var color = '#';
            for (var i = 0; i < 6; i++) {
                color += letters[Math.floor(Math.random() * 16)];
            }
            return color;
        }

        function generateRandomColors(numColors) {
            var colors = [];
            for (var i = 0; i < numColors; i++) {
                colors.push(getRandomColor());
            }
            return colors;
        }

        // Feature
        // Gender Chart
        var universityChartData = @json(array_values($revenuePerUniversity));
        var ctxGender = document.getElementById('universityChart').getContext('2d');
        var universityChart = new Chart(ctxGender, {
            type: 'pie',
            data: {
                labels: @json(array_keys($revenuePerUniversity)),
                datasets: [{
                    data: universityChartData,
                    backgroundColor: generateRandomColors(universityChartData.length),
                }]
            },
            options: {
                    // scales: {
                    //     y: {
                    //         beginAtZero: true
                    //     }
                    // },
                    // responsive: true,
                    // maintainAspectRatio: false,
                    plugins: {
                        legend: {
                            position: 'top',
                        },
                        title: {
                            display: true,
                            text: 'Feature Revenue Per University'
                        }
                    }
                }
        });

        // Gender Revenue
        var ctxGender = document.getElementById('genderChart').getContext('2d');
        var myChart = new Chart(ctxGender, {
            type: 'doughnut',
            data: {
                labels: @json(array_keys($revenuePerGender)),
                datasets: [{
                    data: @json(array_values($revenuePerGender)),
                    backgroundColor: [
                        'rgba(255, 99, 132, 0.8)',
                        'rgba(54, 162, 235, 0.8)'
                    ],
                    borderWidth: 1
                }]
            },
            options: {
                    // scales: {
                    //     y: {
                    //         beginAtZero: true
                    //     }
                    // },
                    // responsive: true,
                    // maintainAspectRatio: false,
                    plugins: {
                        legend: {
                            position: 'top',
                        },
                        title: {
                            display: true,
                            text: 'Feature Revenue Per Gender'
                        }
                    }
                }
        });

        var courseChartData = @json(array_values($revenuePerCourse));
        var ctxcourse = document.getElementById('courseChart').getContext('2d');
        var courseChart = new Chart(ctxcourse, {
                type: 'bar',
                data: {
                    labels: @json(array_keys($revenuePerCourse)),
                    datasets: [{
                        label: 'Number of Courses',
                        data: courseChartData,
                        backgroundColor: 'rgba(75, 192, 192, 0.2)',
                        borderColor: 'rgba(75, 192, 192, 1)',
                        borderWidth: 1
                    }]
                },
                options: {
                    scales: {
                        y: {
                            beginAtZero: true
                        }
                    },
                    responsive: true,
                    maintainAspectRatio: false,
                    plugins: {
                        legend: {
                            position: 'top',
                        },
                        title: {
                            display: true,
                            text: 'Feature Revenue Per Course'
                        }
                    }
                }
        });

        // Package
        // Gender Chart
        var universityChartData = @json(array_values($revenuePerUniversityPackage));
        var ctxGender = document.getElementById('universityChartPackage').getContext('2d');
        var universityChart = new Chart(ctxGender, {
            type: 'pie',
            data: {
                labels: @json(array_keys($revenuePerUniversityPackage)),
                datasets: [{
                    data: universityChartData,
                    backgroundColor: generateRandomColors(universityChartData.length),
                }]
            },
            options: {
                    // scales: {
                    //     y: {
                    //         beginAtZero: true
                    //     }
                    // },
                    // responsive: true,
                    // maintainAspectRatio: false,
                    plugins: {
                        legend: {
                            position: 'top',
                        },
                        title: {
                            display: true,
                            text: 'Package Revenue Per University'
                        }
                    }
                }
        });

        // Gender Revenue
        var ctxGender = document.getElementById('genderChartPackage').getContext('2d');
        var myChart = new Chart(ctxGender, {
            type: 'doughnut',
            data: {
                labels: @json(array_keys($revenuePerGenderPackage)),
                datasets: [{
                    data: @json(array_values($revenuePerGenderPackage)),
                    backgroundColor: [
                        'rgba(255, 99, 132, 0.8)',
                        'rgba(54, 162, 235, 0.8)'
                    ],
                    borderWidth: 1
                }]
            },
            options: {
                    // scales: {
                    //     y: {
                    //         beginAtZero: true
                    //     }
                    // },
                    // responsive: true,
                    // maintainAspectRatio: false,
                    plugins: {
                        legend: {
                            position: 'top',
                        },
                        title: {
                            display: true,
                            text: 'Package Revenue Per Gender'
                        }
                    }
                }
        });

        var courseChartData = @json(array_values($revenuePerCoursePackage));
        var ctxcourse = document.getElementById('courseChartPackage').getContext('2d');
        var courseChart = new Chart(ctxcourse, {
                type: 'bar',
                data: {
                    labels: @json(array_keys($revenuePerCoursePackage)),
                    datasets: [{
                        label: 'Revenue',
                        data: courseChartData,
                        backgroundColor: 'rgba(75, 192, 192, 0.2)',
                        borderColor: 'rgba(75, 192, 192, 1)',
                        borderWidth: 1
                    }]
                },
                options: {
                    scales: {
                        y: {
                            beginAtZero: true
                        }
                    },
                    responsive: true,
                    maintainAspectRatio: false,
                    plugins: {
                        legend: {
                            position: 'top',
                        },
                        title: {
                            display: true,
                            text: 'Package Revenue Per Course'
                        }
                    }
                }
        });
    </script>
@endsection