@extends('portal.layouts.app', [
'class' => '',
'elementActive' => ''
])

@section('title', 'Agent Company Performance')

@section('css')
@endsection

@section('content')
<!-- Page Content -->
<div id="content-page" class="content-page">
   <div class="container-fluid">
      <div class="row">
         <div class="col-sm-12">
            <div class="iq-card">
               <div class="iq-card-header d-flex justify-content-between">
                  <div class="iq-header-title">
                     <h4 class="card-title">Agent Company Performance</h4>
                  </div>
               </div>
               @php
                   $from = request()->from_date ?? date('Y-m-d');
                   $to = request()->to_date ?? date('Y-m-d');
               @endphp
               <div class="iq-card-body m-2">
                    <div class="row my-2">
                         <div class="col-md-12">
                            <form action="" method="Get" class="form-inline">
                                <div class="row">

                                    <div class="col">
                                        <label for="loan_type" class="mr-2">From Date:</label>
                                        <input type="date" name="from_date" class="form-control" value="{{$from}}">
                                    </div>
                                    <div class="col">
                                        <label for="loan_type" class="mr-2">To Date:</label>
                                        <input type="date" name="to_date" class="form-control" value="{{ $to }}">
                                    </div>
                                    <div class="col">
                                        <button type="submit" class="btn btn-primary mt-4">Filter</button>
                                    </div>
                                </div>
                            </form>
                         </div>
                  <div class="table-responsive">

                     <!-- Table: Agent Company Performance -->
<table class="table table-striped table-bordered downloadable align-middle">
    <thead class="table-light">
        <tr>
            <th>#</th>
            <th>Agent</th>
            <th class="text-end">Total Jobs</th>
            <th class="text-end">Demand</th>
            <th class="text-end">Recruited</th>
            <th class="text-end">Interviewed</th>
            <th class="text-end text-success">Passed</th>
            <th class="text-end text-danger">Failed</th>
            <th class="text-end text-success">Travelled</th>
        </tr>
    </thead>

    <tbody>
        @forelse ($data as $index => $row)
            <tr>
                <td>{{ $index + 1 }}</td>
                <td>{{ $row->name ?? 'N/A' }}</td>
                <td class="text-end">{{ number_format($row->total_jobs) }}</td>
                <td class="text-end">{{ number_format($row->total_needed) }}</td>
                <td class="text-end">{{ number_format($row->total_applications) }}</td>
                <td class="text-end">{{ number_format($row->total_interviews) }}</td>
                <td class="text-end text-success fw-bold">{{ number_format($row->passed_interviews) }}</td>
                <td class="text-end text-danger fw-bold">{{ number_format($row->failed_interviews) }}</td>
                <td class="text-end text-success fw-bold">{{ number_format($row->travelled) }}</td>
            </tr>
        @empty
            <tr>
                <td colspan="9" class="text-center text-muted">No data available</td>
            </tr>
        @endforelse
    </tbody>

    <tfoot class="fw-bold">
        <tr>
            <td colspan="2" class="text-center">Totals</td>
            <td class="text-end">{{ number_format($data->sum('total_jobs')) }}</td>
            <td class="text-end">{{ number_format($data->sum('total_needed')) }}</td>
            <td class="text-end">{{ number_format($data->sum('total_applications')) }}</td>
            <td class="text-end">{{ number_format($data->sum('total_interviews')) }}</td>
            <td class="text-end text-success">{{ number_format($data->sum('passed_interviews')) }}</td>
            <td class="text-end text-danger">{{ number_format($data->sum('failed_interviews')) }}</td>
            <td class="text-end text-success">{{ number_format($data->sum('travelled')) }}</td>
        </tr>
    </tfoot>
</table>


                  </div>
               </div>
            </div>
         </div>
      </div>
   </div>
</div>
<!-- Wrapper END -->
@endsection

@section('script')
<script src="{{asset('portal/js/formsubmission.js')}}"></script>

@endsection