@extends('layouts.main')
@section('content')
<div class="container-fluid py-4">
   <div class="d-flex justify-content-between align-items-center mb-4">
      <h4>MIS Reports</h4>
   </div>
   <div class="row g-4">
      <!-- ================= SESSION BOOKING REPORT ================= -->
      <div class="col-md-6">
         <div class="card shadow-sm">
            <div class="card-header bg-primary text-white">
               Session Booking Report
            </div>
            <div class="card-body">
               <table class="table table-bordered">
                  <thead class="table-light">
                     <tr>
                        <th>Total Bookings</th>
                        <th>Completed</th>
                        <th>Cancelled</th>
                        <th>Pending</th>
                     </tr>
                  </thead>
                  <tbody>
                     <tr>
                        <td>120</td>
                        <td>90</td>
                        <td>10</td>
                        <td>20</td>
                     </tr>
                  </tbody>
               </table>
            </div>
         </div>
      </div>
      <!-- ================= EARNING REPORT ================= -->
      <div class="col-md-6">
         <div class="card shadow-sm">
            <div class="card-header bg-success text-white">
               Earning Report
            </div>
            <div class="card-body">
               <table class="table table-bordered">
                  <thead class="table-light">
                     <tr>
                        <th>Total Earnings</th>
                        <th>Today</th>
                        <th>This Week</th>
                        <th>This Month</th>
                     </tr>
                  </thead>
                  <tbody>
                     <tr>
                        <td>₹ 2,50,000</td>
                        <td>₹ 10,000</td>
                        <td>₹ 45,000</td>
                        <td>₹ 1,20,000</td>
                     </tr>
                  </tbody>
               </table>
            </div>
         </div>
      </div>
      <!-- ================= CONSULTANT REPORT ================= -->
      <div class="col-md-12">
         <div class="card shadow-sm">
            <div class="card-header bg-info text-white">
               Consultant Wise Report
            </div>
            <div class="card-body">
               <table class="table table-striped">
                  <thead class="table-dark">
                     <tr>
                        <th>#</th>
                        <th>Consultant Name</th>
                        <th>Total Sessions</th>
                        <th>Total Earnings</th>
                     </tr>
                  </thead>
                  <tbody>
                     <tr>
                        <td>1</td>
                        <td>Dr. Raj Patel</td>
                        <td>35</td>
                        <td>₹ 70,000</td>
                     </tr>
                     <tr>
                        <td>2</td>
                        <td>Dr. Mehul Shah</td>
                        <td>25</td>
                        <td>₹ 50,000</td>
                     </tr>
                     <tr>
                        <td>3</td>
                        <td>Dr. Neha Desai</td>
                        <td>20</td>
                        <td>₹ 40,000</td>
                     </tr>
                  </tbody>
               </table>
            </div>
         </div>
      </div>
      <!-- ================= CATEGORY REPORT (DYNAMIC) ================= -->
      <div class="col-md-12">
         <div class="card shadow-sm">
            <div class="card-header bg-warning text-dark">
               Category / SubCategory Report
            </div>
            <div class="card-body">
               <table class="table table-bordered">
                  <thead class="table-light">
                     <tr>
                        <th>#</th>
                        <th>Category</th>
                        <th>Sub Category</th>
                        <th>Total Sessions</th>
                     </tr>
                  </thead>
                  <tbody>
                     @foreach($categories as $key => $cat)
                     <tr>
                        <td>{{ $key+1 }}</td>
                        <td>{{ $cat->category_name }}</td>
                        <td>{{ $cat->subcategory_name }}</td>
                        <td>{{ $cat->sessions_count }}</td>
                     </tr>
                     @endforeach
                  </tbody>
               </table>
            </div>
         </div>
      </div>
   </div>
</div>
@endsection