@extends('layouts.master')

@section('content')
<div class="container-fluid">
    <h2 class="mb-4">{{ $reportTitle }}</h2>

    <!-- Stats -->
    <div class="row mb-4">
        <div class="col-md-3">
            <div class="card text-white bg-danger">
                <div class="card-body">
                    <h5>Total Mismatches</h5>
                    <h3>{{ $totalMismatches }}</h3>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-info">
                <div class="card-body">
                    <h5>Affected People</h5>
                    <h3>{{ $uniquePeople }}</h3>
                </div>
            </div>
        </div>
    </div>

    <!-- Comparison Table -->
    <table class="table table-bordered table-striped">
        <thead class="thead-dark">
            <tr>
                <th>Man #</th>
                <th>Old Gross</th>
                <th>New Gross</th>
                <th>Old Net</th>
                <th>New Net</th>
                <th>Old Deductions</th>
                <th>New Deductions</th>
                <th>Details</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($results as $row)
                <tr>
                    <td>{{ $row->man_number }}</td>
                    <td>{{ number_format($row->old_gross, 2) }}</td>
                    <td>{{ number_format($row->new_gross, 2) }}</td>
                    <td>{{ number_format($row->old_net, 2) }}</td>
                    <td>{{ number_format($row->new_net, 2) }}</td>
                    <td>{{ number_format($row->old_deductions, 2) }}</td>
                    <td>{{ number_format($row->new_deductions, 2) }}</td>
                    <td>
                        <button class="btn btn-sm btn-primary" data-toggle="collapse" data-target="#details-{{ $row->man_number }}">
                            View Details
                        </button>
                    </td>
                </tr>

                <!-- Collapsible Details -->
                <tr class="collapse" id="details-{{ $row->man_number }}">
                    <td colspan="8">
                        <div class="row">
                            <!-- Earnings -->
                            <div class="col-md-4">
                                <h5>Earnings</h5>
                                <table class="table table-sm table-bordered">
                                    <thead>
                                        <tr>
                                            <th>Old</th>
                                            <th>New</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($row->old_earns as $i => $earn)
                                            <tr>
                                                <td>{{ $earn->amount ?? 0 }}</td>
                                                <td>{{ $row->new_earns[$i]->amount ?? '-' }}</td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>

                            <!-- Deductions -->
                            <div class="col-md-4">
                                <h5>Deductions</h5>
                                <table class="table table-sm table-bordered">
                                    <thead>
                                        <tr>
                                            <th>Old</th>
                                            <th>New</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($row->old_dedus as $i => $dedu)
                                            <tr>
                                                <td>{{ $dedu->amount ?? 0 }}</td>
                                                <td>{{ $row->new_dedus[$i]->amount ?? '-' }}</td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>

                            <!-- Contributions -->
                            <div class="col-md-4">
                                <h5>Contributions</h5>
                                <table class="table table-sm table-bordered">
                                    <thead>
                                        <tr>
                                            <th>Old</th>
                                            <th>New</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($row->old_conts as $i => $cont)
                                            <tr>
                                                <td>{{ $cont->amount ?? 0 }}</td>
                                                <td>{{ $row->new_conts[$i]->amount ?? '-' }}</td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
</div>
@endsection