@extends('layouts.admin')
@section('title','الإيرادات')
@section('breadcrumb')<span class="text-gray-900">الإيرادات</span>@endsection

@section('content')
<div class="space-y-5">
  <h1 class="text-xl font-bold text-gray-900">الإيرادات</h1>

  @php
    $plans = \App\Models\Plan::withCount('tenants')->where('is_active',true)->get();
    $activeTenants = \App\Models\Tenant::with('plan')->where('subscription_status','active')->get();
    $monthlyRevenue = $activeTenants->sum(fn($t) => $t->plan?->price_monthly ?? 0);
    $yearlyRevenue  = $monthlyRevenue * 12;
    $trialCount     = \App\Models\Tenant::where('subscription_status','trial')->count();
  @endphp

  {{-- KPIs --}}
  <div class="grid grid-cols-2 sm:grid-cols-4 gap-4">
    <div class="bg-white border border-gray-100 rounded-2xl p-5">
      <p class="text-sm text-gray-400 mb-2">الإيراد الشهري (MRR)</p>
      <p class="text-3xl font-bold text-gray-900">{{ number_format($monthlyRevenue) }}</p>
      <p class="text-xs text-gray-400 mt-1">SAR</p>
    </div>
    <div class="bg-white border border-gray-100 rounded-2xl p-5">
      <p class="text-sm text-gray-400 mb-2">الإيراد السنوي المتوقع</p>
      <p class="text-3xl font-bold text-gray-900">{{ number_format($yearlyRevenue) }}</p>
      <p class="text-xs text-gray-400 mt-1">SAR</p>
    </div>
    <div class="bg-white border border-gray-100 rounded-2xl p-5">
      <p class="text-sm text-gray-400 mb-2">عملاء نشطون</p>
      <p class="text-3xl font-bold text-green-600">{{ $activeTenants->count() }}</p>
      <p class="text-xs text-gray-400 mt-1">شركة</p>
    </div>
    <div class="bg-white border border-gray-100 rounded-2xl p-5">
      <p class="text-sm text-gray-400 mb-2">في فترة تجريبية</p>
      <p class="text-3xl font-bold text-yellow-600">{{ $trialCount }}</p>
      <p class="text-xs text-gray-400 mt-1">شركة</p>
    </div>
  </div>

  {{-- Revenue by Plan --}}
  <div class="bg-white rounded-2xl border border-gray-100 p-5">
    <h3 class="font-semibold text-gray-800 mb-4">الإيرادات حسب الخطة</h3>
    <div class="space-y-4">
      @foreach($plans as $plan)
      @php $planRevenue = $plan->tenants_count * $plan->price_monthly @endphp
      <div>
        <div class="flex items-center justify-between mb-1.5 text-sm">
          <span class="font-medium text-gray-700">{{ $plan->name_ar }}</span>
          <div class="flex items-center gap-4 text-gray-500">
            <span>{{ $plan->tenants_count }} شركة × {{ number_format($plan->price_monthly) }} SAR</span>
            <span class="font-bold text-gray-900">{{ number_format($planRevenue) }} SAR/شهر</span>
          </div>
        </div>
        <div class="bg-gray-100 rounded-full h-2">
          <div class="bg-blue-500 h-2 rounded-full transition-all"
               style="width:{{ $monthlyRevenue>0 ? min(($planRevenue/$monthlyRevenue)*100,100) : 0 }}%"></div>
        </div>
      </div>
      @endforeach
    </div>
  </div>

  {{-- Active Tenants Table --}}
  <div class="bg-white rounded-2xl border border-gray-100 overflow-hidden">
    <div class="p-5 border-b border-gray-50">
      <h3 class="font-semibold text-gray-800">الشركات النشطة</h3>
    </div>
    <div class="overflow-x-auto">
      <table class="w-full text-sm">
        <thead class="bg-gray-50 border-b border-gray-100">
          <tr>
            <th class="text-right px-5 py-3 text-gray-500 font-medium">الشركة</th>
            <th class="text-right px-4 py-3 text-gray-500 font-medium">الخطة</th>
            <th class="text-right px-4 py-3 text-gray-500 font-medium">الإيراد الشهري</th>
            <th class="text-right px-4 py-3 text-gray-500 font-medium">انتهاء الاشتراك</th>
          </tr>
        </thead>
        <tbody class="divide-y divide-gray-50">
          @forelse($activeTenants as $t)
          <tr class="hover:bg-gray-50/50">
            <td class="px-5 py-3.5">
              <p class="font-medium text-gray-900">{{ $t->name }}</p>
              <p class="text-xs text-gray-400">{{ $t->email }}</p>
            </td>
            <td class="px-4 py-3.5">
              <span class="px-2.5 py-1 bg-blue-50 text-blue-700 rounded-full text-xs font-medium">{{ $t->plan?->name_ar ?? '—' }}</span>
            </td>
            <td class="px-4 py-3.5 font-medium text-gray-800">
              {{ number_format($t->plan?->price_monthly ?? 0) }} SAR
            </td>
            <td class="px-4 py-3.5 text-gray-500 text-xs">
              {{ $t->subscription_ends_at?->format('d/m/Y') ?? '—' }}
            </td>
          </tr>
          @empty
          <tr><td colspan="4" class="px-5 py-8 text-center text-gray-400">لا توجد شركات نشطة</td></tr>
          @endforelse
        </tbody>
      </table>
    </div>
  </div>

</div>
@endsection