@include('hk.header')

<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <div class="content-header">
        <div class="container-fluid">
            <div class="mb-2 row">
                <div class="col-sm-6">
                    <h1 class="m-0">{{ $page_title }}</h1>
                </div><!-- /.col -->
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">
                        <li class="breadcrumb-item"><a href="#">Home</a></li>
                        <li class="breadcrumb-item active">{{ $page_title }}</li>
                    </ol>
                </div><!-- /.col -->
            </div><!-- /.row -->
        </div><!-- /.container-fluid -->
    </div>
    <!-- /.content-header -->

    <!-- Main content -->
    <section class="content">
        <div class="container-fluid">
            <!-- Small boxes (Stat box) -->
            <div class="row">
                <div class="col-md-12">
                    <div class="card">
                        <div class="card-body">
                            <h2 class="mb-4">User Activity Report</h2>

                            {{-- Filter Form --}}
                            <form method="GET" action="/hrm" class="mb-4">
                                <div class="row">
                                    {{-- Search User --}}
                                    <div class="col-md-4">
                                        <input type="text" name="user" class="form-control"
                                            placeholder="Search by user name" value="{{ request('user') }}">
                                    </div>

                                    {{-- Start Date --}}
                                    <div class="col-md-3">
                                        <input type="date" name="start_date" class="form-control"
                                            value="{{ request('start_date') }}">
                                    </div>

                                    {{-- End Date --}}
                                    <div class="col-md-3">
                                        <input type="date" name="end_date" class="form-control"
                                            value="{{ request('end_date') }}">
                                    </div>

                                    {{-- Submit Button --}}
                                    <div class="col-md-2">
                                        <button type="submit" class="btn btn-primary w-100">Filter</button>
                                    </div>
                                </div>
                            </form>

                            {{-- Data Table --}}
                            <table class="table table-bordered">
                                <thead>
                                    <tr>
                                        <th>User Name</th>
                                        <th>Date</th>
                                        <th>No. of Companies Added</th>
                                        <th>No. of Products Added</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $grandTotalCompanies = 0;
                                        $grandTotalProducts = 0;
                                    @endphp

                                    @foreach ($users as $user)
                                        @php
                                            // use the aggregated properties created in controller
                                            $companyDates = collect($user->company_dates);
                                            $productDates = collect($user->product_dates);

                                            // merge dates from both collections
                                            $dates = $companyDates
                                                ->pluck('date')
                                                ->merge($productDates->pluck('date'))
                                                ->unique()
                                                ->sort()
                                                ->values(); // reindex
                                        @endphp

                                        @if ($dates->isEmpty())
                                            {{-- show a single empty row for user if no data --}}
                                            <tr>
                                                <td>{{ $user->name }}</td>
                                                <td>-</td>
                                                <td>0</td>
                                                <td>0</td>
                                            </tr>
                                        @else
                                            @foreach ($dates as $index => $date)
                                                @php
                                                    // get counts from aggregated rows (null-safe)
                                                    $companyRow = $companyDates->firstWhere('date', $date);
                                                    $productRow = $productDates->firstWhere('date', $date);

                                                    $companyCount = $companyRow->companies_count ?? 0;
                                                    $productCount = $productRow->products_count ?? 0;

                                                    $grandTotalCompanies += $companyCount;
                                                    $grandTotalProducts += $productCount;

                                                    $rowspan = $dates->count();
                                                @endphp

                                                <tr>
                                                    @if ($index === 0)
                                                        <td rowspan="{{ $rowspan }}">{{ $user->name }}</td>
                                                    @endif
                                                    <td>{{ $date }}</td>
                                                    <td>{{ $companyCount }}</td>
                                                    <td>{{ $productCount }}</td>
                                                </tr>
                                            @endforeach
                                        @endif
                                    @endforeach

                                    <tr class="fw-bold">
                                        <th colspan="2">Total</th>
                                        <th>{{ $grandTotalCompanies }}</th>
                                        <th>{{ $grandTotalProducts }}</th>
                                    </tr>
                                </tbody>

                            </table>

                            <div class="patination">
                                {{ $users->links() }}
                            </div>
                        </div>
                    </div>
                </div>
                <!-- /.row -->

                <!-- /.row (main row) -->
            </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->
</div>
<!-- /.content-wrapper -->

@include('hk.footer')