@include('dataentry.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">Activity Report</h2>

                        {{-- Filter Form --}}
                        <form method="GET" action="/dataentry/home" class="mb-4">
                            <div class="row">

                                {{-- 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>Date</th>
                                    <th>No. of Companies Added</th>
                                    <th>No. of Products Added</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $dates = collect([...$companies, ...$products])
                                        ->pluck('date')
                                        ->unique()
                                        ->sort();

                                    $totalCompanies = 0;
                                    $totalProducts = 0;
                                @endphp

                                @foreach ($dates as $date)
                                    @php
                                        $companyCount = $companies->firstWhere('date', $date)->companies_count ?? 0;
                                        $productCount = $products->firstWhere('date', $date)->products_count ?? 0;
                                        $totalCompanies += $companyCount;
                                        $totalProducts += $productCount;
                                    @endphp
                                    <tr>
                                        <td>{{ $date }}</td>
                                        <td>{{ $companyCount }}</td>
                                        <td>{{ $productCount }}</td>
                                    </tr>
                                @endforeach

                                <tr class="fw-bold">
                                    <th>Total</th>
                                    <th>{{ $totalCompanies }}</th>
                                    <th>{{ $totalProducts }}</th>
                                </tr>
                            </tbody>
                        </table>


                    </div>
                </div>
            </div>

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

  @include('dataentry.footer')