@extends('layouts.app')

@section('content')
<div class="container-fluid">
  <div class="row justify-content-center">
    <div class="col-md-12">
      <div class="card">
        <div class="card-header bg-primary text-white d-flex justify-content-between align-items-center">
          <h4 class="mb-0">{{ __('Profit Report') }}</h4>
          <small>{{ $rangeLabel }}</small>
        </div>
        <div class="card-body">
          <form method="GET" action="{{ route('reports.profit') }}" class="row g-3 mb-4">
            <div class="col-md-3">
              <label class="form-label">{{ __('From Date') }}</label>
              <input type="date" name="date_from" value="{{ $filters['date_from'] ?? '' }}" class="form-control" />
            </div>
            <div class="col-md-3">
              <label class="form-label">{{ __('To Date') }}</label>
              <input type="date" name="date_to" value="{{ $filters['date_to'] ?? '' }}" class="form-control" />
            </div>
            <div class="col-md-2">
              <label class="form-label">{{ __('Year') }}</label>
              <input type="number" name="year" min="2000" max="2100" value="{{ $filters['year'] ?? '' }}" class="form-control" />
            </div>
            <div class="col-md-2">
              <label class="form-label">{{ __('Month') }}</label>
              <input type="number" name="month" min="1" max="12" value="{{ $filters['month'] ?? '' }}" class="form-control" />
            </div>
            <div class="col-md-2 d-flex align-items-end">
              <button type="submit" class="btn btn-primary w-100">{{ __('Apply Filters') }}</button>
            </div>
          </form>

          <div class="row mb-4">
            <div class="col-md-3">
              <div class="card text-white bg-success h-100">
                <div class="card-body">
                  <h6 class="card-title">{{ __('Revenue') }}</h6>
                  <h3 class="mb-0">{{ number_format($revenue, 2) }}</h3>
                </div>
              </div>
            </div>
            <div class="col-md-3">
              <div class="card text-white bg-secondary h-100">
                <div class="card-body">
                  <h6 class="card-title">{{ __('COGS') }}</h6>
                  <h3 class="mb-0">{{ number_format($cogs, 2) }}</h3>
                </div>
              </div>
            </div>
            <div class="col-md-3">
              <div class="card text-white bg-warning h-100">
                <div class="card-body">
                  <h6 class="card-title">{{ __('Expenses') }}</h6>
                  <h3 class="mb-0">{{ number_format($totalExpenses, 2) }}</h3>
                </div>
              </div>
            </div>
            <div class="col-md-3">
              <div class="card text-white bg-info h-100">
                <div class="card-body">
                  <h6 class="card-title">{{ __('Gross Profit') }}</h6>
                  <h3 class="mb-0">{{ number_format($grossProfit, 2) }}</h3>
                </div>
              </div>
            </div>
          </div>

          <div class="row mb-4">
            <div class="col-md-12">
              <div class="card border-success">
                <div class="card-body">
                  <h5 class="card-title text-success">{{ __('Net Profit') }}</h5>
                  <h2 class="mb-0">{{ number_format($netProfit, 2) }}</h2>
                </div>
              </div>
            </div>
          </div>

          <div class="row">
            <div class="col-md-6 mb-4">
              <div class="card h-100">
                <div class="card-header">{{ __('Revenue by Payment Method') }}</div>
                <div class="card-body p-0">
                  <table class="table mb-0">
                    <thead>
                      <tr>
                        <th>{{ __('Method') }}</th>
                        <th class="text-end">{{ __('Amount') }}</th>
                      </tr>
                    </thead>
                    <tbody>
                      @forelse($revenueByMethod as $method => $amount)
                        <tr>
                          <td>{{ ucfirst($method) }}</td>
                          <td class="text-end">{{ number_format($amount, 2) }}</td>
                        </tr>
                      @empty
                        <tr><td colspan="2" class="text-center">{{ __('No data') }}</td></tr>
                      @endforelse
                    </tbody>
                  </table>
                </div>
              </div>
            </div>

            <div class="col-md-6 mb-4">
              <div class="card h-100">
                <div class="card-header">{{ __('Expenses by Category') }}</div>
                <div class="card-body p-0">
                  <table class="table mb-0">
                    <thead>
                      <tr>
                        <th>{{ __('Category ID') }}</th>
                        <th class="text-end">{{ __('Total') }}</th>
                        <th class="text-end">#</th>
                      </tr>
                    </thead>
                    <tbody>
                      @php
                        $categoryNames = \App\Models\ExpenseCategory::whereIn('id', collect($expensesByCategory->keys())->all())->pluck('name','id');
                      @endphp
                      @forelse($expensesByCategory as $catId => $data)
                        <tr>
                          <td>{{ $categoryNames[$catId] ?? $catId }}</td>
                          <td class="text-end">{{ number_format($data['total'], 2) }}</td>
                          <td class="text-end">{{ $data['count'] }}</td>
                        </tr>
                      @empty
                        <tr><td colspan="3" class="text-center">{{ __('No data') }}</td></tr>
                      @endforelse
                    </tbody>
                  </table>
                </div>
              </div>
            </div>
          </div>

          <div class="row">
            <div class="col-md-12">
              <div class="alert alert-light">
                <strong>{{ __('Note:') }}</strong> {{ __('COGS is computed from product cost_price × quantity for each sold item within the selected period.') }}
              </div>
            </div>
          </div>

        </div>
      </div>
    </div>
  </div>
</div>
@endsection