@extends('layouts.app')

@section('title', 'Dashboard')

@section('page-specific-style')
<link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />
<link rel="stylesheet" href="{{ asset('assets/css/leads.css') }}">
<style>
.custom-tooltip {
  --bs-tooltip-bg: var(--bs-primary);
}

.clickable {
    cursor: pointer;
}

.clickable.active {
    border: 2px solid #007bff; /* Highlight color */
    background-color: rgba(0, 123, 255, 0.1); /* Light background color */
}
</style>
@endsection

@section('content')
<div class="container-fluid">

    <div class="dash-search">
        <form action="{{ url()->current() }}" method="GET" id="search-dashboard">
            <div class="row mt-0">
                <div class="col-4">
                    <div class="select-wrapper position-relative">
                        <select class="form-select" id="assigned_to" name="assigned_to_user" required>
                            <option value="all" {{ request('assigned_to_user') == 'all' ? 'selected' : '' }}>All</option>
                            @forelse ($assignedToUsers ?? [] as $user)
                                <option value="{{ $user->id }}"
                                    @if(request('assigned_to_user') == $user->id ||
                                        (auth()->user()->roles('agent') && auth()->user()->id == $user->id))
                                        selected
                                    @endif>
                                    {{ $user->name }}
                                </option>
                            @empty
                                <option value="">No user found!</option>
                            @endforelse
                        </select>
                        <label for="assigned_to" class="flotting-label">Assigned To</label>
                    </div>
                </div>
                <div class="col-4">
                    <div class="select-wrapper position-relative">
                        <select class="form-select" id="source-status" name="source" required>
                            <option value="all" {{ request('source') == 'all' ? 'selected' : '' }}>All</option>
                            @forelse ($sourceItems ?? [] as $key => $source)
                                <option value="{{ $source->value }}"
                                    {{ request('source') == $source->value ? 'selected' : '' }}>
                                    {{ $source->value }}
                                </option>
                            @empty
                                <option value="">No source found!</option>
                            @endforelse
                        </select>
                        <label for="source" class="flotting-label">Source</label>
                    </div>
                </div>

                <div class="col-4">
                    <div class="form-group">
                        <input type="text" class="form-control" id="date" placeholder="Date" autocomplete="off" autosuggest="off" value="{{ request()->date }}">
                    </div>
                </div>

                <input type="hidden" name="start_date" id="start_date" value="{{ request('start_date') }}">
                <input type="hidden" name="end_date" id="end_date" value="{{ request('end_date') }}">
            </div>
        </form>
    </div>

    <div class="section py-2">
        <div class="row">
            <div class="col-md-12">
                <div class="page-title-box">
                    <h4 class="mb-sm-0 font-size-18 mt-4">Overview</h4>
                </div>
            </div>
        </div>
        <div class="row crm-Stat mb-3">
            <div class="col-md-2 col-sm-6 col-xxl-auto text-left p-3 clickable active" data-metric="newLeads">
                <span>New Lead</span>
                <h1>{{ formatNumberShort($totalLeadCount) }}</h1>
            </div>
            <div class="col-md-2 col-sm-6 col-xxl-auto text-left p-3 clickable" data-metric="activitiesCreated">
                <span>Activities Created</span>
                <h1>{{ formatNumberShort($totalActivitiesCreated) }}</h1>
            </div>
            <div class="col-md-2 col-sm-6 col-xxl-auto text-left p-3 clickable" data-metric="activitiesFinished">
                <span>Activities Finished</span>
                <h1>{{ formatNumberShort($totalActivitiesFinished) }}</h1>
            </div>
            <div class="col-md-2 col-sm-6 col-xxl-auto text-left p-3 clickable" data-metric="policiesCount">
                <span>New Policy</span>
                <h1>{{ formatNumberShort($policiesCount) }}</h1>
            </div>
            <div class="col-md-2 col-sm-6 col-xxl-auto text-left p-3 clickable" data-metric="cpa">
                <span>CPA</span>
                <h1><span class="currency-symbol">$</span>{{ formatNumberShort($cpa) }}</h1>
            </div>
            @can('View commission setting')
            <div class="col-md-2 col-sm-6 col-xxl-auto text-left p-3 clickable" data-metric="estimatedCommission">
                <span>Estimated Commission</span>
                <h1><span class="currency-symbol">$</span>{{ formatNumberShort($estimatedCommission ) }}</h1>
            </div>
            @endcan
            {{-- <div class="col-md-2 col-sm-6 col-xxl-auto text-left p-3 clickable" data-metric="totalPremium">
                <span>Monthly Premium</span>
                <h1><span class="currency-symbol">$</span>{{ formatNumberShort($totalPremium) }}</h1>
            </div>
            <div class="col-md-2 col-sm-6 col-xxl-auto text-left p-3 clickable" data-metric="actualPremium">
                <span>Annualized Premium</span>
                <h1><span class="currency-symbol">$</span>{{ formatNumberShort($actualPremium) }}</h1>
            </div> --}}
        </div>


        <div class="row mt-2">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-body">
                        <div id="spline_area" class="apex-charts" dir="ltr"></div>
                    </div>
                </div>
            </div>
        </div>

    </div>

    <div class="section py-2">
        <div class="row">
            <div class="col-md-12">
                <div class="page-title-box">
                    <h4 class="mb-sm-0 font-size-18">Leads</h4>
                </div>
            </div>
        </div>
        <div class="row">
            <div class="col-md-6">
                <div class="card">
                    <div class="card-body">
                        <div class="table-responsive" style="max-height: 535px; overflow-y: auto; position: relative;">
                            <table class="table table-bordered">
                                <thead class="table-light" style="position: sticky; top: 0; z-index: 10;">
                                    <tr>
                                        <th>Source</th>
                                        <th>New</th>
                                        <th>Open</th>
                                        <th>Won</th>
                                        <th>Closed</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse($summary as $source => $counts)
                                        <tr>
                                            <td>{{ $source == '' || $source == null ? 'Null' : $source }}</td>
                                            <td>{{ $counts['new'] }}</td>
                                            <td>{{ $counts['open'] }}</td>
                                            <td>{{ $counts['won'] }}</td>
                                            <td>{{ $counts['closed'] }}</td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="5" class="text-center">Data not found!</td>
                                        </tr>
                                    @endforelse

                                    @if(count($summary) > 0)
                                        @if (($totals['new'] - array_sum(array_column($summary, 'new'))) > 0 ||
                                            ($totals['open'] - array_sum(array_column($summary, 'open'))) > 0 ||
                                            ($totals['won'] - array_sum(array_column($summary, 'won'))) > 0 ||
                                            ($totals['closed'] - array_sum(array_column($summary, 'closed'))) > 0)
                                        <tr>
                                            <td>Null</td>
                                            <td>
                                                {!! $totals['new'] - array_sum(array_column($summary, 'new')) > 0 ?
                                                    $totals['new'] - array_sum(array_column($summary, 'new')) : 0 !!}
                                            </td>
                                            <td>{!! $totals['open'] - array_sum(array_column($summary, 'open')) > 0 ?
                                                $totals['open'] - array_sum(array_column($summary, 'open')) : 0 !!}</td>
                                            <td>{!! $totals['won'] - array_sum(array_column($summary, 'won')) > 0 ?
                                                $totals['won'] - array_sum(array_column($summary, 'won')) : 0 !!}</td>
                                            <td>{!! $totals['closed'] - array_sum(array_column($summary, 'closed')) > 0 ?
                                                $totals['closed'] - array_sum(array_column($summary, 'closed')) : 0 !!}</td>
                                        </tr>
                                        @endif
                                    @endif

                                </tbody>
                                @if(count($summary) > 0)
                                    <tfoot class="table-light" style="position: sticky; bottom: 0; z-index: 10; background: white;">
                                        <tr>
                                            <td>Total</td>
                                            <td>{{ $totals['new'] }}</td>
                                            <td>{{ $totals['open'] }}</td>
                                            <td>{{ $totals['won'] }}</td>
                                            <td>{{ $totals['closed'] }}</td>
                                        </tr>
                                    </tfoot>
                                @endif
                            </table>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-md-6">
                <div class="card">
                    <div class="card-body">
                        <div class="table-responsive" style="max-height: 535px; overflow-y: auto; position: relative;">
                            <table class="table table-bordered">
                                <thead class="table-light" style="position: sticky; top: 0; z-index: 10;">
                                    <tr>
                                        <th>Agent</th>
                                        <th>New</th>
                                        <th>Open</th>
                                        <th>Won</th>
                                        <th>Closed</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php $hasData = false; @endphp
                                    @forelse($assignedToUsers as $user)
                                        @php
                                            $new = $agentSummary[$user->id]['new'] ?? 0;
                                            $open = $agentSummary[$user->id]['open'] ?? 0;
                                            $won = $agentSummary[$user->id]['won'] ?? 0;
                                            $closed = $agentSummary[$user->id]['closed'] ?? 0;
                                        @endphp

                                        @if($new != 0 || $open != 0 || $won != 0 || $closed != 0)
                                            @php $hasData = true; @endphp
                                            <tr>
                                                <td>{{ $user->name }}</td>
                                                <td>{{ $new }}</td>
                                                <td>{{ $open }}</td>
                                                <td>{{ $won }}</td>
                                                <td>{{ $closed }}</td>
                                            </tr>
                                        @endif
                                    @empty
                                        <tr>
                                            <td colspan="5" class="text-center">No agents found</td>
                                        </tr>
                                    @endforelse

                                    @if ($hasData)
                                    @php
                                        $agentTotals = [
                                            'new' => array_sum(array_column($agentSummary, 'new')),
                                            'open' => array_sum(array_column($agentSummary, 'open')),
                                            'won' => array_sum(array_column($agentSummary, 'won')),
                                            'closed' => array_sum(array_column($agentSummary, 'closed'))
                                        ];
                                    @endphp

                                    @if (($totals['new'] - $agentTotals['new']) > 0 || ($totals['open'] - $agentTotals['open']) > 0 ||
                                        ($totals['won'] - $agentTotals['won']) > 0 || ($totals['closed'] - $agentTotals['closed']) > 0)

                                    <tr>
                                        <td>Null</td>
                                        <td>
                                            {{-- sum of new from the able and minus $$totalLeadCount --}}
                                            {!! $totals['new'] - $agentTotals['new'] > 0 ? $totals['new'] - $agentTotals['new'] : 0 !!}
                                        </td>
                                        <td>{!! $totals['open'] - $agentTotals['open'] > 0 ? $totals['open'] - $agentTotals['open'] : 0 !!}</td>
                                        <td>{!! $totals['won'] - $agentTotals['won'] > 0 ? $totals['won'] - $agentTotals['won'] : 0 !!}</td>
                                        <td>{!! $totals['closed'] - $agentTotals['closed'] > 0 ? $totals['closed'] - $agentTotals['closed'] : 0 !!}</td>
                                    </tr>
                                    @endif
                                    @endif

                                </tbody>

                                @if($hasData)
                                    <tfoot class="table-light" style="position: sticky; bottom: 0; z-index: 10; background: white;">
                                        <tr>
                                            <td>Total</td>
                                            <td>
                                                {{ $totals['new'] }}
                                            </td>
                                            <td>{{ $totals['open'] }}</td>
                                            <td>{{ $totals['won'] }}</td>
                                            <td>{{ $totals['closed'] }}</td>
                                        </tr>
                                    </tfoot>
                                @else
                                    <tr>
                                        <td colspan="5" class="text-center">No data found</td>
                                    </tr>
                                @endif
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="section py-2">
        <div class="row">
            <div class="col-md-12">
                <div class="page-title-box">
                    <h4 class="mb-sm-0 font-size-18">Activities</h4>
                </div>
            </div>
        </div>
        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table table-bordered">
                                <thead class="table-light">
                                    <tr>
                                        <th>Agent</th>
                                        <th>Overdue</th>
                                        <th>Pending</th>
                                        <th>Done</th>
                                        <th>Deleted</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $totalOverdue = 0;
                                        $totalPending = 0;
                                        $totalDone = 0;
                                        $totalDeleted = 0;
                                        $hasData = false;
                                    @endphp
                                    @forelse($activitySummary as $summary)

                                        @php
                                            $totalOverdue += $summary['overdue'];
                                            $totalPending += $summary['pending'];
                                            $totalDone += $summary['done'];
                                            $totalDeleted += $summary['deleted'];

                                            if ($summary['overdue'] != 0 || $summary['pending'] != 0 ||
                                                $summary['done'] != 0 || $summary['deleted'] != 0) {
                                                $hasData = true;

                                        @endphp

                                        <tr>
                                            <td>{{ $summary['agent'] }}</td>
                                            <td>{{ $summary['overdue'] }}</td>
                                            <td>{{ $summary['pending'] }}</td>
                                            <td>{{ $summary['done'] }}</td>
                                            <td>{{ $summary['deleted'] }}</td>
                                        </tr>
                                        @php
                                            }
                                        @endphp
                                    @empty
                                    @endforelse

                                    {{-- @php
                                        $totalOverdue = 0;
                                        $totalPending = 0;
                                        $totalDone = 0;
                                        $totalDeleted = 0;
                                        $hasData = false;
                                    @endphp

                                    @forelse($assignedToUsers as $user)

                                        @php
                                            $overdue = $activitySummary[$user->id]['overdue'] ?? 0;
                                            $pending = $activitySummary[$user->id]['pending'] ?? 0;
                                            $done = $activitySummary[$user->id]['done'] ?? 0;
                                            $deleted = $activitySummary[$user->id]['deleted'] ?? 0;

                                            // Only display the row if any of the values are not 0
                                            if ($overdue != 0 || $pending != 0 || $done != 0 || $deleted != 0) {
                                                $hasData = true;
                                                $totalOverdue += $overdue;
                                                $totalPending += $pending;
                                                $totalDone += $done;
                                                $totalDeleted += $deleted;
                                        @endphp

                                        <tr>
                                            <td>{{ $user->name }}</td>
                                            <td>{{ $overdue }}</td>
                                            <td>{{ $pending }}</td>
                                            <td>{{ $done }}</td>
                                            <td>{{ $deleted }}</td>
                                        </tr>

                                        @php
                                            }
                                        @endphp
                                    @empty
                                        <tr>
                                            <td colspan="5" class="text-center">No Data Found</td>
                                        </tr>
                                    @endforelse --}}
                                </tbody>

                                @if($hasData)
                                <tfoot class="table-light">
                                    <tr>
                                        <td>Total</td>
                                        <td>{{ $totalOverdue }}</td>
                                        <td>{{ $totalPending }}</td>
                                        <td>{{ $totalDone }}</td>
                                        <td>{{ $totalDeleted }}</td>
                                    </tr>
                                </tfoot>
                                @else
                                    {{-- <tr>
                                        <td colspan="5" class="text-center">No Data Found</td>
                                    </tr> --}}
                                @endif
                            </table>

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

        </div>
        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table table-bordered">
                                <thead class="table-light">
                                    <tr>
                                        <th>Activity Type</th>
                                        <th>Overdue</th>
                                        <th>Pending</th>
                                        <th>Done</th>
                                        <th>Deleted</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                        $totalOverdue = 0;
                                        $totalPending = 0;
                                        $totalDone = 0;
                                        $totalDeleted = 0;
                                        $hasData = false;
                                    @endphp

                                    @forelse($activityTypeSummary as $activityType => $counts)
                                        @php
                                            $pending = $counts['pending'] ?? 0;
                                            $done = $counts['done'] ?? 0;
                                            $deleted = $counts['deleted'] ?? 0;
                                            $overdue = $counts['overdue'] ?? 0;

                                            if ($overdue != 0 || $pending != 0 || $done != 0 || $deleted != 0) {
                                                $hasData = true;
                                                $totalOverdue += $overdue;
                                                $totalPending += $pending;
                                                $totalDone += $done;
                                                $totalDeleted += $deleted;
                                        @endphp

                                        <tr>
                                            <td>{{ $activityType }}</td>
                                            <td>{{ $overdue }}</td>
                                            <td>{{ $pending }}</td>
                                            <td>{{ $done }}</td>
                                            <td>{{ $deleted }}</td>
                                        </tr>
                                        @php
                                            }
                                        @endphp

                                    @empty
                                        <tr>
                                            <td colspan="5" class="text-center">Data not found</td>
                                        </tr>
                                    @endforelse




                                    {{-- @forelse($activityTypeSummary as $activityType => $counts)
                                        @php
                                            $pending = $counts['pending'] ?? 0;
                                            $done = $counts['done'] ?? 0;
                                            $deleted = $counts['deleted'] ?? 0;
                                            $overdue = $counts['overdue'] ?? 0;

                                            if ($overdue != 0 || $pending != 0 || $done != 0 || $deleted != 0) {
                                                $hasData = true;
                                                $totalOverdue += $overdue;
                                                $totalPending += $pending;
                                                $totalDone += $done;
                                                $totalDeleted += $deleted;
                                        @endphp

                                        <tr>
                                            <td>{{ $activityType }}</td>
                                            <td>{{ $overdue }}</td>
                                            <td>{{ $pending }}</td>
                                            <td>{{ $done }}</td>
                                            <td>{{ $deleted }}</td>
                                        </tr>
                                        @php
                                            }
                                        @endphp
                                    @empty
                                        <tr>
                                            <td colspan="5" class="text-center">Data not found</td>
                                        </tr>
                                    @endforelse --}}
                                </tbody>

                                <tfoot class="table-light">
                                    <tr>
                                        <td>Total</td>
                                        <td>{{ $activityTotals['overdue'] }}</td>
                                        <td>{{ $activityTotals['pending'] }}</td>
                                        <td>{{ $activityTotals['done'] }}</td>
                                        <td>{{ $activityTotals['deleted'] }}</td>
                                    </tr>
                                </tfoot>
                            </table>

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

    <div class="section py-2">
        <div class="row">
            <div class="col-md-12">
                <div class="page-title-box">
                    <h4 class="mb-sm-0 font-size-18">Policies</h4>
                </div>
            </div>
        </div>
        <div class="row">
            <div class="col-md-6">
                <div class="card">
                    <div class="card-body">
                        <div class="table-responsive" style="max-height: 535px; overflow-y: auto; position: relative;">
                            <table class="table table-bordered">
                                <thead class="table-light" style="position: sticky; top: 0; z-index: 10;">
                                    <tr>
                                        <th>Agent</th>
                                        <th>New</th>
                                        <th>CPA</th>
                                        @can('View commission setting')
                                        <th>Estimated Commission</th>
                                        @endcan
                                    </tr>
                                </thead>
                                <tbody>
                                    @php $hasData = false; @endphp

                                    @forelse($policiesSummary as $userId => $summary)
                                        @php
                                            $new = $summary['new'] ?? 0;
                                            $policiesCPA = $summary['cpa'] ?? 0;
                                            $earnedCommission = $summary['earned_commission'] ?? 0;
                                        @endphp

                                        @if($new != 0 || $policiesCPA != 0 || $earnedCommission != 0)
                                            @php $hasData = true; @endphp
                                            <tr>
                                                <td>{{ $assignedToUsers->firstWhere('id', $userId)->name ?? 'N/A' }}</td>
                                                <td>{{ $new }}</td>
                                                <td><span>$</span>{{ number_format($policiesCPA, 2) }}</td>
                                                @can('View commission setting')
                                                <td><span>$</span>{{ number_format($earnedCommission, 2) }}</td>
                                                @endcan
                                            </tr>
                                        @endif
                                    @empty
                                        <tr>
                                            @can('View commission setting')
                                            <td colspan="4" class="text-center">No data available</td>
                                            @else
                                            <td colspan="3" class="text-center">No data available</td>
                                            @endcan
                                        </tr>
                                    @endforelse

                                    @if($hasData)
                                        @php
                                            $totalNew = array_sum(array_column($policiesSummary, 'new'));
                                            $totalCPA = $cpa;
                                            // $totalEstimatedCommission = array_sum(array_column($policiesSummary, 'earned_commission'));
                                            $totalEstimatedCommission = $estimatedCommission;

                                            $unassignedNew = max($totalLeadCount - $totalNew, 0);
                                            $unassignedCPA = max($totalCPA - array_sum(array_column($policiesSummary, 'cpa')), 0);
                                            $unassignedCommission = max($totalEstimatedCommission - array_sum(array_column($policiesSummary, 'estimated_commission')), 0);
                                        @endphp

                                        @if ($unassignedNew > 0 || $unassignedCPA > 0 || $unassignedCommission > 0)
                                            <tr>
                                                <td>Null</td>
                                                <td>{{ $unassignedNew }}</td>
                                                <td><span>$</span>{{ number_format($unassignedCPA, 2) }}</td>

                                                @can('View commission setting')
                                                    <td>
                                                        {!! $totalEstimatedCommission - array_sum(array_column($policiesSummary, 'estimated_commission')) > 0 ?
                                                    '<span>$</span>' . number_format($totalEstimatedCommission - array_sum(array_column($policiesSummary, 'estimated_commission')), 2) : '$'. $totalEstimatedCommission - array_sum(array_column($policiesSummary, 'earned_commission')) !!}
                                                    </td>
                                                @endcan
                                            </tr>
                                        @endif
                                    @endif
                                </tbody>

                                @if($hasData)
                                    <tfoot class="table-light" style="position: sticky; bottom: 0; z-index: 10; background: white;">
                                        <tr>
                                            <td>Total</td>
                                            <td>{{ $totalNew }}</td>
                                            <td><span>$</span>{{ number_format($totalCPA, 2) }}</td>
                                            @can('View commission setting')
                                                <td><span>$</span>{{ number_format($totalEstimatedCommission, 2) }}</td>
                                            @endcan
                                        </tr>
                                    </tfoot>
                                @endif
                            </table>

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

            <div class="col-md-6">
                <div class="card">
                    <div class="card-body">
                        <div class="table-responsive" style="max-height: 535px; overflow-y: auto; position: relative;">
                            <table class="table table-bordered">
                                <thead class="table-light" style="position: sticky; top: 0; z-index: 10;">
                                    <tr>
                                        <th>Product</th>
                                        <th>New</th>
                                        <th>CPA</th>
                                        @can('View commission setting')
                                        <th>Estimated Commission</th>
                                        @endcan
                                    </tr>
                                </thead>
                                <tbody>
                                    @php $hasData = false; @endphp

                                    @forelse($policiesProductSummary as $productId => $summary)
                                        @php
                                            $new = $summary['new'] ?? 0;
                                            $productCPA = $summary['cpa'] ?? 0;
                                            $ProductEstimatedCommission = $summary['estimated_commission'] ?? 0;
                                        @endphp

                                        @if($new != 0 || $productCPA != 0 || $ProductEstimatedCommission != 0)
                                            @php $hasData = true; @endphp
                                            <tr>
                                                <td>{{ $summary['name'] }}</td>
                                                <td>{{ $new }}</td>
                                                <td><span>$</span>{{ number_format($productCPA, 2) }}</td>
                                                @can('View commission setting')
                                                <td><span>$</span>{{ number_format($ProductEstimatedCommission, 2) }}</td>
                                                @endcan
                                            </tr>
                                        @endif
                                    @empty
                                        <tr>
                                            @can('View commission setting')
                                            <td colspan="4" class="text-center">No data available</td>
                                            @else
                                            <td colspan="3" class="text-center">No data available</td>
                                            @endcan
                                        </tr>
                                    @endforelse

                                    @if ($hasData)
                                        @php
                                            $productTotalCPA = $cpa;

                                            $totalEstimatedCommission = $estimatedCommission;
                                        @endphp
                                        @if (($productTotalCPA - array_sum(array_column($policiesProductSummary, 'cpa'))) > 0 ||
                                            ($totalEstimatedCommission - array_sum(array_column($policiesProductSummary, 'estimated_commission'))) > 0)
                                        <tr>
                                            <td>Null</td>
                                            <td>
                                                {!! $totalLeadCount - array_sum(array_column($policiesProductSummary, 'new')) > 0 ?
                                                    $totalLeadCount - array_sum(array_column($policiesProductSummary, 'new')) : 0 !!}
                                            </td>
                                            <td>{!! $productTotalCPA - array_sum(array_column($policiesProductSummary, 'cpa')) > 0 ?
                                                '<span>$</span>' . number_format($productTotalCPA - array_sum(array_column($policiesProductSummary, 'cpa')), 2) : 0 !!}</td>
                                            @can('View commission setting')
                                            <td>{!! $totalEstimatedCommission - array_sum(array_column($policiesProductSummary, 'estimated_commission')) > 0 ?
                                                '<span>$</span>' . number_format($totalEstimatedCommission - array_sum(array_column($policiesProductSummary, 'estimated_commission')), 2) : '$'. $totalEstimatedCommission - array_sum(array_column($policiesProductSummary, 'estimated_commission')) !!}
                                            @endcan
                                        </tr>
                                        @endif
                                    @endif

                                </tbody>
                                @if($hasData)
                                <tfoot class="table-light" style="position: sticky; bottom: 0; z-index: 10; background: white;">
                                    <tr>
                                        <td>Total</td>
                                        <td>
                                            {{ array_sum(array_column($policiesProductSummary, 'new')) }}
                                        </td>
                                        <td><span>$</span>{{ number_format($productTotalCPA, 2) }}</td>
                                        @can('View commission setting')
                                        <td><span>$</span>{{ number_format($totalEstimatedCommission, 2) }}</td>
                                        @endcan
                                    </tr>
                                </tfoot>
                                @else
                                    <tr>
                                        @can('View commission setting')
                                        <td colspan="4" class="text-center">No data available</td>
                                        @else
                                        <td colspan="3" class="text-center">No data available</td>
                                        @endcan
                                    </tr>
                                @endif
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="row">
            <div class="col-md-6">
                <div class="card">
                    <div class="card-body">
                        <div class="table-responsive" style="max-height: 535px; overflow-y: auto; position: relative;">
                            <table class="table table-bordered">
                                <thead class="table-light" style="position: sticky; top: 0; z-index: 10;">
                                    <tr>
                                        <th>State</th>
                                        <th>New</th>
                                        <th>CPA</th>
                                        @can('View commission setting')
                                        <th>Estimated Commission</th>
                                        @endcan
                                    </tr>
                                </thead>
                                <tbody>
                                    @php $hasData = false; @endphp

                                    @forelse($stateSummary as $productId => $summary)
                                        @php
                                            $stateNew = $summary['new'] ?? 0;
                                            $stateCPA = $summary['cpa'] ?? 0;
                                            $stateEstimatedCommission = $summary['estimated_commission'] ?? 0;
                                        @endphp

                                        @if($stateNew != 0 || $stateCPA != 0 || $stateEstimatedCommission != 0)
                                            @php $hasData = true; @endphp
                                            <tr>
                                                <td>{{ $summary['name'] }}</td>
                                                <td>{{ $stateNew }}</td>
                                                <td><span>$</span>{{ number_format($stateCPA, 2) }}</td>
                                                @can('View commission setting')
                                                <td><span>$</span>{{ number_format($stateEstimatedCommission, 2) }}</td>
                                                @endcan
                                            </tr>
                                        @endif
                                    @empty
                                        <tr>
                                            @can('View commission setting')
                                            <td colspan="4" class="text-center">No data available</td>
                                            @else
                                            <td colspan="3" class="text-center">No data available</td>
                                            @endcan
                                        </tr>
                                    @endforelse

                                    @if ($hasData)
                                        @php
                                            $stateTotalCPA = $cpa;

                                            $stateTotalEstimatedCommission = $estimatedCommission;
                                        @endphp
                                        @if (($stateTotalCPA - array_sum(array_column($policiesProductSummary, 'cpa'))) > 0 ||
                                            ($stateTotalEstimatedCommission - array_sum(array_column($policiesProductSummary, 'estimated_commission'))) > 0)
                                        <tr>
                                            <td>Null</td>
                                            <td>
                                                {!! $totalLeadCount - array_sum(array_column($policiesProductSummary, 'new')) > 0 ?
                                                    $totalLeadCount - array_sum(array_column($policiesProductSummary, 'new')) : 0 !!}
                                            </td>
                                            <td>{!! $stateTotalCPA - array_sum(array_column($policiesProductSummary, 'cpa')) > 0 ?
                                                '<span>$</span>' . number_format($stateTotalCPA - array_sum(array_column($policiesProductSummary, 'cpa')), 2) : 0 !!}</td>
                                            @can('View commission setting')
                                            <td>
                                                {!! $stateTotalEstimatedCommission - array_sum(array_column($policiesProductSummary, 'estimated_commission')) > 0 ?
                                                '<span>$</span>' . number_format($stateTotalEstimatedCommission - array_sum(array_column($policiesProductSummary, 'estimated_commission')), 2) : '$'. $stateTotalEstimatedCommission - array_sum(array_column($policiesProductSummary, 'estimated_commission')) !!}
                                            </td>
                                            @endcan
                                        </tr>
                                        @endif
                                    @endif

                                </tbody>
                                @if($hasData)
                                <tfoot class="table-light" style="position: sticky; bottom: 0; z-index: 10; background: white;">
                                    <tr>
                                        <td>Total</td>
                                        <td>
                                            {{ array_sum(array_column($policiesProductSummary, 'new')) }}
                                        </td>
                                        <td><span>$</span>{{ number_format($stateTotalCPA, 2) }}</td>
                                        @can('View commission setting')
                                        <td><span>$</span>{{ number_format($stateTotalEstimatedCommission, 2) }}</td>
                                        @endcan
                                    </tr>
                                </tfoot>
                                @else
                                    <tr>
                                        @can('View commission setting')
                                        <td colspan="4" class="text-center">No data available</td>
                                        @else
                                        <td colspan="3" class="text-center">No data available</td>
                                        @endcan
                                    </tr>
                                @endif
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

</div>
@endsection

@section('page-specific-script')
<script type="text/javascript" src="https://cdn.jsdelivr.net/momentjs/latest/moment.min.js"></script>
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/dayjs@latest"></script>
<script src="{{ asset('assets/libs/apexcharts/apexcharts.min.js') }}"></script>
<script src="{{ asset('assets/js/dashboard/index.js') }}"></script>

<script>
    $(document).ready(function() {

        let chart;

        // Get URL parameters
        const urlParams = new URLSearchParams(window.location.search);
        const urlStartDate = urlParams.get('start_date');
        const urlEndDate = urlParams.get('end_date');

        // Initialize start and end dates
        let startDate, endDate;


        if (urlStartDate && urlEndDate && urlStartDate !== urlEndDate) {
            startDate = dayjs(urlStartDate, 'MM/DD/YYYY').format('YYYY-MM-DD');
            endDate = dayjs(urlEndDate, 'MM/DD/YYYY').format('YYYY-MM-DD');
        } else {
            endDate = dayjs().format('YYYY-MM-DD'); // Today's date
            startDate = dayjs().subtract(6, 'days').format('YYYY-MM-DD'); // 7 days ago
        }

        // Function to fetch chart data
        function fetchChartData(metric, startDate, endDate, type) {
            $.ajax({
                url: "{{ route('dashboard.chartData') }}",
                type: "GET",
                data: {
                    metric: metric,
                    start_date: startDate,
                    end_date: endDate,
                    type: type
                },
                success: function(data) {
                    updateChart(data, metric);

                    // Hide loader
                    $.LoadingOverlay("hide");
                },
                error: function() {
                    console.error("Failed to fetch chart data.");
                }
            });
        }

        function updateChart(data, metric) {
            if (chart) {
                chart.destroy();
            }

            chart = new ApexCharts(document.querySelector("#spline_area"), {
                chart: {
                    height: 350,
                    type: "area",
                    toolbar: { show: false }
                },
                dataLabels: { enabled: false },
                stroke: {
                    curve: "smooth",
                    width: 3
                },
                series: [{
                    name: "Data",
                    data: data.values
                }],
                xaxis: {
                    categories: formatCategories(data.dates),
                    title: {
                        text: metricName(metric),
                        style: {
                            fontSize: '14px',
                            fontWeight: 'bold',
                            color: '#333'
                        }
                    }
                },
                yaxis: {
                    labels: {
                        formatter: function (value) {
                            if (value >= 1000) {
                                return (value / 1000).toFixed(1) + "k"; // Format as "1.2k"
                            }
                            return value; // Keep the original value for numbers below 1000
                        },
                        style: {
                            fontSize: '12px',
                            colors: '#666'
                        }
                    }
                },
                grid: { borderColor: "#f1f1f1" },
                tooltip: { x: { format: "dd/MM/yy" } }
            });

            chart.render();
        }
function formatCategories(dates) {
    const formattedDates = [];
    const startDateModified = dayjs(dates[0]);
    const endDateModified = dayjs(dates[dates.length - 1]);
    const daysDiff = endDateModified.diff(startDateModified, 'days');

    if (daysDiff > 31) {
        let currentMonth = "";
        let monthStart = null;

        dates.forEach(date => {
            const dayjsDate = dayjs(date);
            const month = dayjsDate.format('MMM');

            if (month !== currentMonth) {
                // Start of a new month
                if (currentMonth && monthStart) {
                    formattedDates.push(`${currentMonth} ${monthStart}-${dayjsDate.subtract(1, 'day').format('D')}`);
                }
                currentMonth = month;
                monthStart = dayjsDate.format('D');
            }

            // If last date in range, push final entry
            if (date === dates[dates.length - 1]) {
                formattedDates.push(`${currentMonth} ${monthStart}-${dayjsDate.format('D')}`);
            }
        });
    } else {
        // If range is <= 31 days, display all dates normally with Month before day
        dates.forEach(date => {
            formattedDates.push(dayjs(date).format('MMM D'));
        });
    }

    return formattedDates;
}



        // Function to get the name of the metric
        function metricName(metric) {
            switch (metric) {
                case 'newLeads': return 'New Leads';
                case 'activitiesCreated': return 'Activities Created';
                case 'activitiesFinished': return 'Activities Finished';
                case 'policiesCount': return 'New Policies';
                case 'cpa': return 'CPA';
                case 'estimatedCommission': return 'Estimated Commission';
                default: return '';
            }
        }


        // Check date range and fetch initial chart data
        const daysDiff = dayjs(endDate).diff(dayjs(startDate), 'day');
        const monthsDiff = dayjs(endDate).diff(dayjs(startDate), 'month');

        if (daysDiff > 20 && monthsDiff > 0) {
            fetchChartData("newLeads", startDate, endDate, "multiMonthData");
        } else {
            fetchChartData("newLeads", startDate, endDate, "dailyData");
        }


        // Click event for metric boxes
        $(document).on('click', '.clickable', function() {
            $('.crm-Stat .clickable').removeClass('active');
            $(this).addClass('active');

            var metric = $(this).data('metric');
            // fetchChartData(metric, startDate, endDate, "dailyData");

            // Show loader
            $.LoadingOverlay("show", {
                image: "",
                text: "Loading...",
                background: "rgba(0, 0, 0, 0.5)",
                textColor: "#fff",
                fontSize: "10px !important"
            });

            if (daysDiff > 20 && monthsDiff > 0) {
                fetchChartData(metric, startDate, endDate, "multiMonthData");
            } else {
                fetchChartData(metric, startDate, endDate, "dailyData");
            }
        });
    });
</script>



@endsection