@extends('adminlte::page')

@section('title', 'Reports')

@section('content_header')
    <div class="d-flex align-items-center justify-content-between flex-wrap">
        <div>
            <h1 class="m-0">Reports</h1>
            <span class="text-muted">HR, attendance, leave, and payroll summaries</span>
        </div>
        <button type="button" class="btn btn-outline-primary btn-sm mt-2 mt-sm-0" onclick="window.print()">
            <i class="fas fa-print mr-1"></i> Print
        </button>
    </div>
@stop

@section('content')
    <x-adminlte-card title="Report Filters" icon="fas fa-filter" theme="primary" class="no-print">
        <form method="GET" action="{{ route('reports.index') }}">
            <div class="row">
                <div class="col-md-4">
                    <x-adminlte-input name="date_from" label="From" type="date" value="{{ $dateFrom }}" required/>
                </div>
                <div class="col-md-4">
                    <x-adminlte-input name="date_to" label="To" type="date" value="{{ $dateTo }}" required/>
                </div>
                <div class="col-md-4 d-flex align-items-end">
                    <button type="submit" class="btn btn-primary mb-3">
                        <i class="fas fa-sync mr-1"></i> Refresh Reports
                    </button>
                </div>
            </div>
        </form>
    </x-adminlte-card>

    <div class="row">
        <div class="col-lg-3 col-6">
            <x-adminlte-info-box title="Total Staff" text="{{ $staffSummary['total'] }}" icon="fas fa-users" theme="info"/>
        </div>
        <div class="col-lg-3 col-6">
            <x-adminlte-info-box title="Active Staff" text="{{ $staffSummary['active'] }}" icon="fas fa-user-check" theme="success"/>
        </div>
        <div class="col-lg-3 col-6">
            <x-adminlte-info-box title="Payroll Net" text="{{ number_format((float) $payrollSummary['net_total'], 2) }}" icon="fas fa-wallet" theme="primary"/>
        </div>
        <div class="col-lg-3 col-6">
            <x-adminlte-info-box title="Payroll Cost" text="{{ number_format((float) $payrollSummary['gross_total'] + (float) $payrollSummary['employer_contribution_total'], 2) }}" icon="fas fa-money-bill-wave" theme="warning"/>
        </div>
    </div>

    <div class="row">
        <div class="col-lg-6">
            <x-adminlte-card title="Staff By Department" icon="fas fa-sitemap" theme="primary">
                <div class="table-responsive">
                    <table class="table table-sm table-hover mb-0">
                        <thead>
                            <tr>
                                <th>Department</th>
                                <th>Code</th>
                                <th class="text-right">Employees</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($staffByDepartment as $department)
                                <tr>
                                    <td>{{ $department->name }}</td>
                                    <td>{{ $department->code ?: '-' }}</td>
                                    <td class="text-right">{{ $department->employees_count }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="3" class="text-center text-muted py-3">No departments found.</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </x-adminlte-card>
        </div>

        <div class="col-lg-6">
            <x-adminlte-card title="Staff Status" icon="fas fa-user-tag" theme="info">
                <div class="row">
                    <div class="col-6">
                        <div class="small text-muted">On Leave</div>
                        <h4>{{ $staffSummary['on_leave'] }}</h4>
                    </div>
                    <div class="col-6">
                        <div class="small text-muted">Suspended</div>
                        <h4>{{ $staffSummary['suspended'] }}</h4>
                    </div>
                    <div class="col-6">
                        <div class="small text-muted">Terminated</div>
                        <h4>{{ $staffSummary['terminated'] }}</h4>
                    </div>
                    <div class="col-6">
                        <div class="small text-muted">Active Ratio</div>
                        <h4>
                            {{ $staffSummary['total'] > 0 ? number_format(($staffSummary['active'] / $staffSummary['total']) * 100, 1) : '0.0' }}%
                        </h4>
                    </div>
                </div>
            </x-adminlte-card>
        </div>
    </div>

    <div class="row">
        <div class="col-lg-6">
            <x-adminlte-card title="Attendance Summary" icon="fas fa-user-clock" theme="success">
                <table class="table table-sm table-hover mb-0">
                    <thead>
                        <tr>
                            <th>Status</th>
                            <th class="text-right">Records</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($attendanceSummary as $status => $count)
                            <tr>
                                <td>{{ $status }}</td>
                                <td class="text-right">{{ $count }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </x-adminlte-card>
        </div>

        <div class="col-lg-6">
            <x-adminlte-card title="Leave Summary" icon="fas fa-calendar-check" theme="warning">
                <table class="table table-sm table-hover mb-0">
                    <thead>
                        <tr>
                            <th>Status</th>
                            <th class="text-right">Requests</th>
                            <th class="text-right">Days</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($leaveSummary as $status => $data)
                            <tr>
                                <td>{{ $status }}</td>
                                <td class="text-right">{{ $data['total'] }}</td>
                                <td class="text-right">{{ number_format((float) $data['days'], 1) }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </x-adminlte-card>
        </div>
    </div>

    <div class="row">
        <div class="col-lg-8">
            <x-adminlte-card title="Payroll Runs In Range" icon="fas fa-cogs" theme="primary">
                <div class="table-responsive">
                    <table class="table table-sm table-hover text-nowrap mb-0">
                        <thead>
                            <tr>
                                <th>Period</th>
                                <th>Status</th>
                                <th class="text-right">Gross</th>
                                <th class="text-right">Deductions</th>
                                <th class="text-right">Employer</th>
                                <th class="text-right">Net</th>
                                <th class="text-right">Cost</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($payrollRuns as $run)
                                <tr>
                                    <td>
                                        {{ $run->period->name ?? 'Unknown period' }}
                                        @if($run->period)
                                            <div class="text-muted small">
                                                {{ $run->period->period_start->format('M d') }} - {{ $run->period->period_end->format('M d, Y') }}
                                            </div>
                                        @endif
                                    </td>
                                    <td>{{ $run->status }}</td>
                                    <td class="text-right">{{ number_format((float) $run->gross_total, 2) }}</td>
                                    <td class="text-right">{{ number_format((float) $run->deduction_total, 2) }}</td>
                                    <td class="text-right">{{ number_format((float) $run->employer_contribution_total, 2) }}</td>
                                    <td class="text-right"><strong>{{ number_format((float) $run->net_total, 2) }}</strong></td>
                                    <td class="text-right">{{ number_format((float) $run->gross_total + (float) $run->employer_contribution_total, 2) }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="7" class="text-center text-muted py-3">No payroll runs found for this period.</td>
                                </tr>
                            @endforelse
                        </tbody>
                        <tfoot>
                            <tr>
                                <th colspan="2" class="text-right">Totals</th>
                                <th class="text-right">{{ number_format((float) $payrollSummary['gross_total'], 2) }}</th>
                                <th class="text-right">{{ number_format((float) $payrollSummary['deduction_total'], 2) }}</th>
                                <th class="text-right">{{ number_format((float) $payrollSummary['employer_contribution_total'], 2) }}</th>
                                <th class="text-right">{{ number_format((float) $payrollSummary['net_total'], 2) }}</th>
                                <th class="text-right">{{ number_format((float) $payrollSummary['gross_total'] + (float) $payrollSummary['employer_contribution_total'], 2) }}</th>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </x-adminlte-card>
        </div>

        <div class="col-lg-4">
            <x-adminlte-card title="Payroll Status" icon="fas fa-chart-pie" theme="info">
                <table class="table table-sm table-hover mb-0">
                    <tbody>
                        @foreach($payrollSummary['status_counts'] as $status => $count)
                            <tr>
                                <td>{{ $status }}</td>
                                <td class="text-right">{{ $count }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </x-adminlte-card>

            <x-adminlte-card title="Deduction Breakdown" icon="fas fa-minus-circle" theme="danger">
                <table class="table table-sm table-hover mb-0">
                    <tbody>
                        @forelse($deductionBreakdown as $deduction)
                            <tr>
                                <td>{{ $deduction->type }}</td>
                                <td class="text-right">{{ number_format((float) $deduction->total, 2) }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td class="text-center text-muted py-3">No deductions found.</td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </x-adminlte-card>
        </div>
    </div>

    <div class="row">
        <div class="col-lg-8">
            <x-adminlte-card title="Payroll Cost By Department" icon="fas fa-sitemap" theme="success">
                <div class="table-responsive">
                    <table class="table table-sm table-hover text-nowrap mb-0">
                        <thead>
                            <tr>
                                <th>Department</th>
                                <th class="text-right">Employees</th>
                                <th class="text-right">Basic</th>
                                <th class="text-right">Allowances</th>
                                <th class="text-right">Deductions</th>
                                <th class="text-right">Employer</th>
                                <th class="text-right">Net</th>
                                <th class="text-right">Total Cost</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($payrollCostByDepartment as $row)
                                <tr>
                                    <td>{{ $row->department_name }}</td>
                                    <td class="text-right">{{ $row->employees }}</td>
                                    <td class="text-right">{{ number_format((float) $row->basic_total, 2) }}</td>
                                    <td class="text-right">{{ number_format((float) $row->allowance_total, 2) }}</td>
                                    <td class="text-right">{{ number_format((float) $row->deduction_total, 2) }}</td>
                                    <td class="text-right">{{ number_format((float) $row->employer_contribution_total, 2) }}</td>
                                    <td class="text-right">{{ number_format((float) $row->net_total, 2) }}</td>
                                    <td class="text-right"><strong>{{ number_format((float) $row->payroll_cost_total, 2) }}</strong></td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="8" class="text-center text-muted py-3">No department payroll cost found for this period.</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </x-adminlte-card>
        </div>

        <div class="col-lg-4">
            <x-adminlte-card title="Statutory & Employer Liabilities" icon="fas fa-balance-scale" theme="warning">
                <div class="table-responsive">
                    <table class="table table-sm table-hover text-nowrap mb-0">
                        <thead>
                            <tr>
                                <th>Run</th>
                                <th class="text-right">Deductions</th>
                                <th class="text-right">Employer</th>
                                <th class="text-right">Total</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($payrollLiabilitiesByRun as $run)
                                <tr>
                                    <td>{{ $run->period->name ?? 'Run #'.$run->id }}</td>
                                    <td class="text-right">{{ number_format((float) $run->statutory_deduction_total, 2) }}</td>
                                    <td class="text-right">{{ number_format((float) $run->employer_contribution_total, 2) }}</td>
                                    <td class="text-right"><strong>{{ number_format((float) $run->liability_total, 2) }}</strong></td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="4" class="text-center text-muted py-3">No payroll liabilities found.</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </x-adminlte-card>

            <x-adminlte-card title="Contract Watch" icon="fas fa-file-contract" theme="secondary">
                <div class="d-flex align-items-center justify-content-between">
                    <span class="text-muted">Expiring in 60 days</span>
                    <strong>{{ $staffSummary['contracts_expiring_soon'] }}</strong>
                </div>
            </x-adminlte-card>
        </div>
    </div>
@stop

@section('css')
    <style>
        @media print {
            .no-print,
            .main-sidebar,
            .main-header,
            .main-footer {
                display: none !important;
            }

            .content-wrapper {
                margin-left: 0 !important;
                background: #fff !important;
            }
        }
    </style>
@stop