@extends('dashboard.layouts.app')

@section('content')
@include('components.alert')
<div class="container-fluid">
  <div class="row">
    <div class="col-12">
      <div class="card h-100 border-0 shadow-sm overflow-hidden p-3">
        <div class="card-header border-bottom py-3 px-5 d-flex align-items-center justify-content-between">
          <h5 class="mb-0">Payroll Details (Per Staff)</h5>
          @php
            $currentMonth = now()->month;
            $currentYear = now()->year;
            $monthParam = request('month');
            $yearParam = request('year');
            $isAllMonth = ($monthParam === 'all');
            $isAllYear = ($yearParam === 'all');
            $selectedMonth = $isAllMonth ? null : (int) ($monthParam ?: $currentMonth);
            $selectedYear = $isAllYear ? null : (int) ($yearParam ?: $currentYear);
            $selectedMonthName = $selectedMonth ? date('F', mktime(0, 0, 0, $selectedMonth, 10)) : 'All months';
            $selectedYearLabel = $selectedYear ? (string) $selectedYear : 'All years';
            $canCheckRun = !is_null($selectedMonth) && !is_null($selectedYear);
            $runExistsForSelected = $canCheckRun ? \App\Models\PayrollRun::where('month', $selectedMonth)->where('year', $selectedYear)->exists() : null;
            $isCurrentSelection = $canCheckRun && ($selectedMonth === $currentMonth && $selectedYear === $currentYear);
            $currentMonthName = date('F', mktime(0, 0, 0, $currentMonth, 10));
          @endphp
          <div class="text-end">
            @if (!$canCheckRun)
              <span class="badge bg-info">Showing {{ $selectedMonthName }} {{ $selectedYearLabel }}</span>
            @else
              <span class="badge {{ $runExistsForSelected ? 'bg-success' : 'bg-secondary' }}">
                {{ $runExistsForSelected ? 'Run' : 'Not run' }} for {{ $selectedMonthName }} {{ $selectedYearLabel }}
              </span>
            @endif
          </div>
        </div>

        <div class="card-body">
          <!-- Search by Month and Year -->
          <form action="{{ route('payroll.saff') }}" method="GET" class="mb-4">
            <div class="row g-2 align-items-end">
              <div class="col-md-4">
                <label for="month" class="form-label">Select Month</label>
                <select name="month" id="month" class="form-control">
                  <option value="all" {{ $isAllMonth ? 'selected' : '' }}>All months</option>
                  @for ($m = 1; $m <= 12; $m++)
                    @php $mName = date('F', mktime(0, 0, 0, $m, 10)); @endphp
                    <option value="{{ $m }}" {{ (!$isAllMonth && (int)request('month', $selectedMonth ?? 0) === $m) ? 'selected' : '' }}>
                      {{ $mName }}
                    </option>
                  @endfor
                </select>
              </div>
              <div class="col-md-4">
                <label for="year" class="form-label">Select Year</label>
                <select name="year" id="year" class="form-control">
                  @php $thisYear = (int)now()->year; @endphp
                  <option value="all" {{ $isAllYear ? 'selected' : '' }}>All years</option>
                  @for ($y = $thisYear + 1; $y >= $thisYear - 5; $y--)
                    <option value="{{ $y }}" {{ (!$isAllYear && (int)request('year', $selectedYear ?? 0) === (int)$y) ? 'selected' : '' }}>
                      {{ $y }}
                    </option>
                  @endfor
                </select>
              </div>
              <div class="col-md-4">
                <button type="submit" class="btn btn-primary">Search</button>
                <a href="{{ route('payroll.saff') }}" class="btn btn-secondary">Clear</a>
              </div>
            </div>
          </form>

          <div class="row mb-4">
            <div class="col-md-12 mb-2 d-flex gap-2 justify-content-end">
              @if($canCheckRun && $runExistsForSelected)
                <a href="{{ route('payroll.saff.export.pdf', ['month' => $selectedMonth, 'year' => $selectedYear]) }}" target="_blank" class="btn btn-outline-danger btn-sm">View PDF</a>
                <a href="{{ route('payroll.saff.export.csv', ['month' => $selectedMonth, 'year' => $selectedYear]) }}" class="btn btn-outline-success btn-sm">Export CSV</a>
              @endif
            </div>
            <div class="col-md-4">
              <div class="card border-0 shadow-sm">
                <div class="card-body">
                  <div class="small text-muted">Total Gross Salaries</div>
                  <div class="fs-4 text-primary fw-semibold">{{ number_format($totalGross, 2) }}</div>
                </div>
              </div>
            </div>
            <div class="col-md-4">
              <div class="card border-0 shadow-sm">
                <div class="card-body">
                  <div class="small text-muted">Total Net Salaries</div>
                  <div class="fs-4 text-success fw-semibold">{{ number_format($totalNet, 2) }}</div>
                </div>
              </div>
            </div>
            <div class="col-md-4">
              <div class="card border-0 shadow-sm">
                <div class="card-body">
                  <div class="small text-muted">Total Bonuses </div>
                  <div class="fs-4 text-success fw-semibold">{{ $bonuses_total }}</div>
                </div>
              </div>
            </div>



              <div class="col-md-4">
                  <div class="card border-0 shadow-sm">
                  <div class="card-body">
                      <div class="small text-muted">Total Benalties </div>
                      <div class="fs-4 text-danger fw-semibold">{{ $penalties_total }}</div>
                  </div>
                  </div>
              </div>
          </div>

          <div class="table-responsive">
            <table class="table table-bordered table-sm table-bordered-table sm-table mb-0">
              <thead class="table-dark">
                <tr>
                  <th>Staff</th>
                  <th>Pay Period</th>
                  <th>Pay Date</th>
                  <th>Gross Salary</th>
                  <th>Net Salary</th>
                  <th>Bonuses</th>
                  <th>Penalties</th>
                  <th>Notes</th>
                  <th>Show Before</th>
                  <th>Action</th>
                </tr>
              </thead>
              <tbody>
                @forelse($rows as $row)
                  @php
                    $staffName = $row->full_name ?: trim(($row->first_name ?? '') . ' ' . ($row->last_name ?? ''));
                  @endphp
                  <tr>
                    <td>{{ $staffName ?: '—' }}</td>
                    <td>
                      @if(!empty($row->run_date))
                        {{ \Carbon\Carbon::createFromDate($row->run_date)->firstOfMonth()->format('d-m-y') }}
                        -
                        {{ \Carbon\Carbon::createFromDate($row->run_date)->endOfMonth()->format('d-m-y') }}
                      @else
                        —
                      @endif
                    </td>
                    <td>
                      @if(!empty($row->run_date))
                        {{ \Illuminate\Support\Carbon::parse($row->run_date)->format('Y-m-d') }}
                      @else
                        —
                      @endif
                    </td>
                    <td>{{ number_format($row->gross_salary, 2) }}</td>
                    <td>{{ number_format($row->net_salary, 2) }}</td>
                    <td class="text-success">{{ number_format($row->bonuses, 2) }}</td>
                    <td class="text-danger">{{ number_format($row->penalties, 2) }}</td>
                    <td>{{ $row->notes }}</td>
                    <td>
                      @if($row->in_compensation_log)
                        <p class="text-success">Viewed</p>
                      @else
                        <p class="text-danger">Not Viewed</p>
                      @endif
                    </td>
                    <td>
                      @if(!empty($row->user_id))
                        @if(!$canCheckRun || !$runExistsForSelected)
                          <a href="{{ route('compensations.user.index', $row->user_id) }}" class="btn btn-sm @if($row->in_compensation_log) btn-outline-success @else btn-outline-primary @endif">Add Compensations</a>
                        @else
                          —
                        @endif
                      @else
                        —
                      @endif
                    </td>
                  </tr>
                @empty
                  <tr>
                    <td colspan="9" class="text-center text-muted">No payroll staff data found.</td>
                  </tr>
                @endforelse
              </tbody>
              <tfoot class="table-light">
                <tr>
                  <td colspan="3" class="fw-semibold">Total</td>
                  <td class="fw-semibold">{{ number_format($totalGross, 2) }}</td>
                  <td class="fw-semibold">{{ number_format($totalNet, 2) }}</td>
                  <td colspan="4"></td>
                </tr>
              </tfoot>
            </table>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>
@endsection

@push('scripts')
<style>
  .table-bordered-table {
    border: 1px solid #dee2e6;
  }
  .table-bordered-table th,
  .table-bordered-table td {
    border: 1px solid #dee2e6;
  }
</style>
@endpush