@extends('layout.app')

@section('content')
<div class="container-fluid">
    <div class="card">
        <div class="card-header">
            <h3 class="card-title">Monthly Report</h3>
            <div class="card-tools">
                <span class="text-muted">From {{ $from_date }} to {{ $to_date }}</span>
                <a href="{{ route('newJoinMonthlyReport') . '?' . http_build_query(array_merge(request()->query(), ['download' => 'excel'])) }}" class="btn btn-sm btn-success ml-2">
                    <i class="fa fa-file-excel-o"></i> Download Excel
                </a>
                <a href="{{ route('list', 'new-join') }}" class="btn btn-sm btn-secondary ml-1">
                    <i class="fa fa-arrow-left"></i> Back to List
                </a>
            </div>
        </div>
        <div class="card-body">
            <div class="row mb-3">
                <div class="col-md-4">
                    <div class="card bg-light">
                        <div class="card-body text-center py-2">
                            <div class="text-muted">Total Client</div>
                            <h4 class="mb-0">{{ $clients->count() }}</h4>
                        </div>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="card bg-light">
                        <div class="card-body text-center py-2">
                            <div class="text-muted">Total OTC</div>
                            <h4 class="mb-0">{{ $totalOtc }}</h4>
                        </div>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="card bg-light">
                        <div class="card-body text-center py-2">
                            <div class="text-muted">Total Lastmile Fiber Length</div>
                            <h4 class="mb-0">{{ $totalLastmileFiberLength }}</h4>
                        </div>
                    </div>
                </div>
            </div>
            <table class="table table-bordered table-striped">
                <thead>
                    <tr style="background:#78716C !important; color:white;">
                        <th>SI</th>
                        <th>CID</th>
                        <th>Package</th>
                        <th>OTC</th>
                        <th>POP Name</th>
                        <th>KAM Name</th>
                        <th>Lastmile fiber Length</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach ($clients as $index => $client)
                        <tr>
                            <td>{{ $index + 1 }}</td>
                            <td>{{ $client->id }}</td>
                            <td>{{ $client->packages->package_name ?? '' }}</td>
                            <td>{{ $client->clientsinfo->otc ?? '' }}</td>
                            <td>{{ $client->pop->popname ?? '' }}</td>
                            <td>{{ $client->marketingEmployeeUser->name ?? $client->marketing_employee_id }}</td>
                            <td>{{ $client->required_cable ?? 0 }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
            @if ($clients->isEmpty())
                <p class="text-muted mb-0">No records found for the selected date range and filters.</p>
            @endif
        </div>
    </div>
</div>
@endsection