@php
    $today = date('Y-m-d');
    $month = date('m');
    $year = date('Y');


    $invest_today = \App\Models\Investment::where(['status'=> 3, 'closing_request'=>0])->where('package_id','!=',1)->where('invest_end_date', '=', $today)->count();
    $invest_this_month = \App\Models\Investment::where(['status'=> 3, 'closing_request'=>0])->where('package_id','!=',1)->whereMonth('invest_end_date', '=', $month)->whereYear('invest_end_date', '=', $year)->count();
    $invest_over = \App\Models\Investment::where(['status'=> 3, 'closing_request'=>0])->where('package_id','!=',1)->where('invest_end_date', '<', $today)->count();


@endphp

@push('css')
    <style>
        .top-manue{
            margin-top:-20px;
        }
        .fsize{
            font-size:15px;
        }
    </style>
@endpush

<div class="card top-manue" >
    <div class="col-md-12">
        <nav class="navbar navbar-expand-lg navbar-light">
            <div class="navbar-nav ">
                <a class="nav-item fsize nav-link " href="{{ route('invest_closing_list', $type='') }}">Today List ({{$invest_today}})</a>
                <a class="nav-item fsize nav-link" href="{{ route('invest_closing_list', $type='this_month') }}">This Month ({{$invest_this_month}})</a>
                <a class="nav-item fsize nav-link" href="{{ route('invest_closing_list', $type='over_due') }}">Over Due ({{$invest_over}})</a>
            </div>
        </nav>
    </div>
</div>