Dashboard Dashboard {{-- Test --}} {{-- {{ dd($data->where('main_service_id', 6)->where('created_at', 'like', '%'.date('Y-08').'%')->count()) }} --}}
@foreach ($services as $service)
{{ $service->name }}
Total
{{-- {{ $data->where('main_service_id', $service->id)->count() }} --}} 0
Approve
0 {{-- {{ $data->where('main_service_id', $service->id)->where('status', 4)->count() }} --}}
Reject
0 {{-- {{ $data->where('main_service_id', $service->id)->where('status', 5)->count() }} --}}
Pending
0 {{-- {{ $data->where('main_service_id', $service->id)->whereNotIn('status', ['4', '5'])->count() }} --}}
@endforeach
{{-- tab system service --}}

Pending Application

    @foreach ($services as $service) @endforeach
@foreach ($services as $service)

Pending {{ $service->name }} Application

@foreach ($service->services as $ser) @endforeach
Sr No. Service Name 3+ days 7+ days 10+ days
{{ $loop->iteration }} {{ $ser->name }} {{-- {{ $data->where('main_service_id', $service->id)->where('service_id', $ser->id)->whereNotIn('status', ['4', '5'])->where('created_at', '<=', date('Y-m-d', strtotime('-4 days')))->where('created_at', '>=', date('Y-m-d', strtotime('-7 days')))->count() }} --}} 0 0 {{-- {{ $data->where('main_service_id', $service->id)->where('service_id', $ser->id)->whereNotIn('status', ['4', '5'])->where('created_at', '<=', date('Y-m-d', strtotime('-8 days')))->where('created_at', '>=', date('Y-m-d', strtotime('-10 days')))->count() }} --}} 0 {{-- {{ $data->where('main_service_id', $service->id)->where('service_id', $ser->id)->whereNotIn('status', ['4', '5'])->where('created_at', '<', date('Y-m-d', strtotime('-10 days')))->count() }} --}}
@endforeach
{{-- end of tab system service --}}

Service Wise Pie Chart

Portal Wise Pie Chart

Month Wise Application Received

@for ($i = 1; $i <= 12; $i++) @endfor @foreach ($services as $service) {{-- --}} @endforeach
Service{{ date('F', mktime(0, 0, 0, $i, 1, date('Y'))) . ' ' . date('Y') }}
{{ $service->name }}{{ $data->where('main_service_id', $service->id)->where('yearmonth', date('Y-01'))->count() }} {{ $data->where('main_service_id', $service->id)->where('yearmonth', date('Y-02'))->count() }} {{ $data->where('main_service_id', $service->id)->where('yearmonth', date('Y-03'))->count() }} {{ $data->where('main_service_id', $service->id)->where('yearmonth', date('Y-04'))->count() }} {{ $data->where('main_service_id', $service->id)->where('yearmonth', date('Y-05'))->count() }} {{ $data->where('main_service_id', $service->id)->where('yearmonth', date('Y-06'))->count() }} {{ $data->where('main_service_id', $service->id)->where('yearmonth', date('Y-07'))->count() }} {{ $data->where('main_service_id', $service->id)->where('yearmonth', date('Y-08'))->count() }} {{ $data->where('main_service_id', $service->id)->where('yearmonth', date('Y-09'))->count() }} {{ $data->where('main_service_id', $service->id)->where('yearmonth', date('Y-10'))->count() }} {{ $data->where('main_service_id', $service->id)->where('yearmonth', date('Y-11'))->count() }} {{ $data->where('main_service_id', $service->id)->where('yearmonth', date('Y-12'))->count() }}0 0 0 0 0 0 0 0 0 0 0 0
@push('scripts') @endpush