@extends('layouts.admin')
@section('title', 'Dashboard')
@section('content')
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<div class="dashboard-content bg-light mt-5">
    <div class="dashboard-breadcrumb p-lg-5 p-md-5 p-4 position-relative">
        <h4 class="mt-4">Hi, {{ auth()->guard('admin')->user()->name }}</h4>
        <p>Let’s get started with the .......................................</p>
    </div>
    <div class="col-md-12 dashboard-container py-4 px-lg-5 px-md-5 px-4">
        <div class="row">
           
            <div class="col-lg-3 col-md-3 col-6 mt-lg-0 mt-md-0 mt-4">
                <div class="dashboard-card p-4 bg-white h-100">
                    <div class="d-flex justify-content-between align-items-center">
                        <h4 class="mb-0">{{ $allusers ?? '' }}</h4>
                        <!-- <p class="mb-0 up-para">(60.5) <i class="fa-solid fa-arrow-up"></i></p> -->
                    </div>
                    <div class="dashboard-progress mt-4">
                        <p class="mb-2">Total User</p>
                        <!-- <div class="progress" style="height: 10px;">
                            <div class="progress-bar" style="width:20%; height: 10px;"></div>
                        </div> -->
                    </div>
                </div>
            </div>
            <div class="col-lg-3 col-md-3 col-6 mt-lg-0 mt-md-0 mt-4">
                <div class="dashboard-card p-4 bg-white h-100">
                    <div class="d-flex justify-content-between align-items-center">
                        <h4 class="mb-0">{{ $activeuser ?? '' }}</h4>
                    </div>
                    <div class="dashboard-progress mt-4">
                        <p class="mb-2">Total Active User</p>
                    </div>
                </div>
            </div>
            <div class="col-lg-3 col-md-3 col-6 mt-lg-0 mt-md-0 mt-4">
                <div class="dashboard-card p-4 bg-white h-100">
                    <div class="d-flex justify-content-between align-items-center">
                        <h4 class="mb-0">{{ $subscribedUsers ?? '' }}</h4>
                        <!-- <p class="mb-0 up-para">(60.5) <i class="fa-solid fa-arrow-up"></i></p> -->
                    </div>
                    <div class="dashboard-progress mt-4">
                        <p class="mb-2">Subscribed user</p>
                        <!-- <div class="progress" style="height: 10px;">
                            <div class="progress-bar" style="width:20%; height: 10px;"></div>
                        </div> -->
                    </div>
                </div>
            </div>
            <div class="col-lg-3 col-md-3 col-6 mt-lg-0 mt-md-0 mt-4">
                <div class="dashboard-card p-4 bg-white h-100">
                    <div class="d-flex justify-content-between align-items-center">
                        <h4 class="mb-0">{{ $unsubscribedUsers ?? '' }}</h4>
                        <!-- <p class="mb-0 up-para2">(60.5) <i class="fa-solid fa-arrow-down"></i></p> -->
                    </div>
                    <div class="dashboard-progress mt-4">
                        <p class="mb-2">Un Subscribed user</p>
                        <!-- <div class="progress" style="height: 10px;">
                            <div class="progress-bar" style="width:20%; height: 10px;"></div>
                        </div> -->
                    </div>
                </div>
            </div>
        </div>
        <div class="row mt-4">
            <div class="offset-1 col-md-10">
                <div class="dashboard-box h-100 p-4 bg-white">
                    <div class="row align-items-center">
                        <div class="col-lg-9 col-md-9 col-6">
                            <h5 class="mb-0">Revenue</h5>
                        </div>
                        <!-- <div class="col-lg-3 col-md-3 col-6">
                            <select class="form-control form-select" name="yearly" id="yearly">
                                <option value="yearly">Yearly</option>
                            </select>
                        </div> -->
                    </div>
                    <div class="row">
                        <div class="col-md-12">
                            <!-- <div id="chartdiv1" class="mt-4"></div> -->
                            <canvas id="lineChart"></canvas>
                        </div>
                    </div>
                </div>
            </div>
            <!-- <div class="col-md-4 mt-lg-0 mt-md-0 mt-4">
                <div class="dashboard-box h-100 p-4 bg-white">
                    <div class="row align-items-center">
                        <div class="col-md-12">
                            <h5 class="mb-0">Subjects Information</h5>
                        </div>
                    </div>
                    <div id="chartdiv" class="mt-4"></div>
                </div>
            </div> -->
        </div>
        <div class="row mt-4">
            <!-- <div class="col-md-6">
                <div class="dashboard-box h-100 p-4 bg-white">
                    <div class="row align-items-center">
                        <div class="col-lg-9 col-md-9 col-6">
                            <h5 class="mb-0">New User</h5>
                        </div>
                        <div class="col-lg-3 col-md-3 col-6">
                            <select class="form-control form-select" name="yearly" id="yearly">
                                <option value="yearly">Yearly</option>
                            </select>
                        </div>
                    </div>
                    <div id="chartdiv2" class="mt-4"></div>
                </div>
            </div> -->
            <div class="offset-1 col-md-10 mt-lg-0 mt-md-0 mt-4">
                <div class="dashboard-box h-100 p-4 bg-white">
                    <div class="row align-items-center">
                        <div class="col-lg-9 col-md-9 col-9">
                            <h5 class="mb-0">Subjects Information</h5>
                        </div>
                        <div class="col-lg-3 col-md-3 col-3 text-end">
                            <a href="#" class="text-decoration-none">View all</a>
                        </div>
                    </div>
                    <div class="row mt-4">
                        <div class="col-md-12">
                            <div class="table-responsive user-table">
                                <table class="table table-striped">
                                    <thead class="border-bottom">
                                        <tr>
                                            <th>S.No.</th>
                                            <th>User Name</th>
                                            <th>Email</th>
                                            <th>Sub ID</th>
                                            <th>Plan Type</th>
                                            <th>Amount</th> 
                                            <th>Start Date</th> 
                                            <th>End Date</th> 
                                            <th>Interval</th> 
                                            <th>Sub. Status</th>
                                            <th>Payment Status</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach($latestRec as $key => $sub)
                                            <tr>
                                                <td>{{ ++$key }}</td>
                                                <td>
                                                    @if($sub->user!=null)
                                                        {{-- <img src="{{ asset('storage/avatars/'.$sub->user->avatar) }}" alt=""> --}}
                                                        {{ $sub->user->name }}
                                                    @else
                                                        N/A
                                                    @endif
                                                </td>
                                                <td>
                                                    @if($sub->user!=null)
                                                        {{ $sub->user->email }}
                                                    @else
                                                        N/A
                                                    @endif
                                                </td>
                                                <td>
                                                    {!! $sub->stripe_subscription_id != 'Free Trial' ? '<a href="https://dashboard.stripe.com/test/subscriptions/'.$sub->stripe_subscription_id.'">'.$sub->stripe_subscription_id.'</a>' : $sub->stripe_subscription_id !!}
                                                </td>
                                                <td>
                                                    @if($sub->is_trial==1)
                                                        Free Trial
                                                    @else
                                                        @if($sub->plan!=null)
                                                            {{ $sub->plan->name }}
                                                        @else
                                                            N/A
                                                        @endif
                                                    @endif
                                                </td>
                                                <td>${{ $sub->amount }}</td>
                                                <td>
                                                    {{ date('Y/m/d',strtotime($sub->start_at)).' at '.date('h:i:s a',strtotime($sub->start_at)) }}
                                                </td>
                                                <td>
                                                    {{ date('Y/m/d',strtotime($sub->end_at)) }}
                                                </td>
                                                <td>
                                                    @if($sub->is_trial==1)
                                                        7 Days
                                                    @else
                                                        @if($sub->plan!=null)
                                                            {{ ucfirst($sub->plan->interval) }}
                                                        @else
                                                            N/A
                                                        @endif
                                                    @endif
                                                </td>
                                                <td>
                                                    {{ ucfirst($sub->status) }}
                                                </td>
                                                <td>
                                                    @if($sub->is_trial==1)
                                                        <span class="text-success">--</span>
                                                    @else
                                                        @if($sub->payment_status==1)
                                                            <span class="text-success">Success</span>
                                                        @else
                                                            <span class="text-danger">Failed</span>
                                                        @endif
                                                    @endif
                                                </td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

  <script>
    const ctx = document.getElementById('lineChart').getContext('2d');

    const labels = @json($months);
    // [
    //   'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',
    //   'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'
    // ];

    const data = {
      labels: labels,
      datasets: [
        {
          label: '{{ $previousYear }}',
          data: @json($pyRec),//[120, 130, 125, 150, 170, 180, 160, 175, 190, 210, 200, 220],
          borderColor: '#1c8ed5',
        //   backgroundColor: 'rgba(75, 192, 192, 0.2)',
          fill: false,
          tension: 0.4,
          cubicInterpolationMode: 'monotone',
          pointRadius: 4,
          pointHoverRadius: 6
        },
        {
          label: '{{ $currentYear }}',
          data:  @json($cyRec), //[230, 240, 235, 250, 265, 270, 260, 275, 290, 300, 310, 320],
          borderColor: '#b22797',
        //   backgroundColor: 'rgba(255, 99, 132, 0.2)',
          fill: false,
          tension: 0.4,
          cubicInterpolationMode: 'monotone',
          pointRadius: 4,
          pointHoverRadius: 6
        }
      ]
    };

    const config = {
      type: 'line',
      data: data,
      options: {
        responsive: true,
        plugins: {
          title: {
            display: true,
            text: 'Monthly Data Comparison: 2023 vs 2024'
          },
          tooltip: {
            mode: 'index',
            intersect: false,
          },
          legend: {
            display: true,
            position: 'top',
          }
        },
        interaction: {
          mode: 'nearest',
          axis: 'x',
          intersect: false
        },
        scales: {
          x: {
            title: {
              display: true,
              text: 'Month'
            }
          },
          y: {
            beginAtZero: false,
            title: {
              display: true,
              text: 'Value'
            }
          }
        }
      }
    };

    new Chart(ctx, config);
  </script>

@endsection