@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
                                            $dates = collect([...$user->companies, ...$user->products])
                                                ->pluck('date')
                                                ->unique()
                                                ->sort();
                                        @endphp

                                        @foreach ($dates as $index => $date)
                                            @php
                                                $companyCount = $user->companies->firstWhere('date', $date)->companies_count ?? 0;
                                                $productCount = $user->products->firstWhere('date', $date)->products_count ?? 0;
                                                $grandTotalCompanies += $companyCount;
                                                $grandTotalProducts += $productCount;
                                            @endphp
                                            <tr>
                                                @if ($index === 0)
                                                    <td rowspan="{{ count($dates) }}">{{ $user->name }}</td>
                                                @endif
                                                <td>{{ $date }}</td>
                                                <td>{{ $companyCount }}</td>
                                                <td>{{ $productCount }}</td>
                                            </tr>
                                        @endforeach
                                    @endforeach

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

                        </div>
                    </div>
                </div>
                <!-- /.row -->

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

@include('hk.footer')