{{-- @dd($headOfficeUser->filter_pref); --}} {{-- @foreach ($headOfficeUser->filter_pref as $user_filter) @dd($user_filter); @endforeach --}}
@if (in_array(request()->route()->getName(), [ 'case_manager.edit_report', 'case_manager.request_information', 'case_manager.index', 'case_manager.view', 'case_manager.view_report', 'case_manager.view_root_cause_analysis', 'case_manager.view_sharing', 'case_manager.intelligence.mrege_contact', 'head_office.case.requested_informations', 'case_manager.case_archives' ]))
@php $headOfficeId = $headOffice->id; $is_archive_page = request()->route()->getName() == 'case_manager.case_archives' ? 1 : 0; // 1. Cases grouped by form (id, name, count) $casesGroupedByForm = DB::table('head_office_cases') ->join('be_spoke_form_records', 'be_spoke_form_records.id', '=', 'head_office_cases.last_linked_incident_id') ->join('be_spoke_form', 'be_spoke_form.id', '=', 'be_spoke_form_records.form_id') ->where('head_office_cases.head_office_id', $headOfficeId) ->where('head_office_cases.isArchived', $is_archive_page) ->select('be_spoke_form.id as id', 'be_spoke_form.name as name', DB::raw('count(head_office_cases.id) as count')) ->groupBy('be_spoke_form.id', 'be_spoke_form.name') ->get(); // 2. Count head_office_cases by status $statusCount = DB::table('head_office_cases') ->where('head_office_id', $headOfficeId) ->where('isArchived', $is_archive_page) ->select('status', DB::raw('count(*) as count')) ->groupBy('status') ->get() ->pluck('count', 'status'); // key = status, value = count // 3. Count stages by name $stagesCount = DB::table('case_stages') ->join('head_office_cases', 'case_stages.case_id', '=', 'head_office_cases.id') ->where('head_office_cases.head_office_id', $headOfficeId) ->where('head_office_cases.isArchived', $is_archive_page) ->select('case_stages.name', DB::raw('count(case_stages.id) as count')) ->groupBy('case_stages.name') ->get() ->pluck('count', 'name'); // 4. Count root cause analysis head_office_cases where status = 0 $rootCauseAnalysisCount = DB::table('root_cause_analysis') ->join('head_office_cases', 'root_cause_analysis.case_id', '=', 'head_office_cases.id') ->where('head_office_cases.head_office_id', $headOfficeId) ->where('head_office_cases.isArchived', $is_archive_page) ->where('root_cause_analysis.status', 0) ->distinct('head_office_cases.id') ->count('head_office_cases.id'); // 5. Count case request informations where status = 0 $requestInfoCount = DB::table('case_request_informations') ->join('head_office_cases', 'case_request_informations.case_id', '=', 'head_office_cases.id') ->where('head_office_cases.head_office_id', $headOfficeId) ->where('head_office_cases.isArchived', $is_archive_page) ->where('case_request_informations.status', 0) ->distinct('head_office_cases.id') ->count('head_office_cases.id'); // 6. Count shared head_office_cases (head_office_cases with share_head_office_cases entries) $shareCaseCount = DB::table('share_cases') ->join('head_office_cases', 'share_cases.case_id', '=', 'head_office_cases.id') ->where('head_office_cases.head_office_id', $headOfficeId) ->where('head_office_cases.isArchived', $is_archive_page) ->distinct('head_office_cases.id') ->count('head_office_cases.id'); // 7. Count head_office_cases where share_case_extension attribute = 1 $shareCaseExtensionCount = DB::table('share_cases') ->join('head_office_cases', 'share_cases.case_id', '=', 'head_office_cases.id') ->join('share_case_request_extensions', 'share_case_request_extensions.share_case_id', '=', 'share_cases.id') ->where('head_office_cases.head_office_id', $headOfficeId) ->where('head_office_cases.isArchived', $is_archive_page) ->where('share_case_request_extensions.status', 1) ->distinct('head_office_cases.id') ->count('head_office_cases.id'); $selected_stages = []; $selected_forms = []; $selected_status = []; $selected_awaiting = []; $selected_sharing = []; $selected_case_tags = []; $selected_contact_tags = []; $selected_site_tags = []; if(request()->has('case_tags')) { $selected_case_tags = explode(',', request()->query('case_tags')); } if(request()->has('contact_tags')) { $selected_contact_tags = explode(',', request()->query('contact_tags')); } if(request()->has('loc_tags')) { $selected_site_tags = explode(',', request()->query('loc_tags')); } $userStarredFilters = isset($starredFilters) ? $starredFilters : []; if(request()->has('date_type')) { $date_type = request()->query('date_type'); } if(request()->has('date_value')) { $date_value = request()->query('date_value'); } if(request()->has('stages')) { $selected_stages = explode(',', request()->query('stages')); } if(request()->has('form')) { $selected_forms = explode(',', request()->query('form')); $statusCount = DB::table('head_office_cases') ->when(request()->has('form'), function ($query) { $selected_forms = explode(',', request()->query('form')); $query->whereIn('last_linked_incident_id', function ($subQuery) use ($selected_forms) { $subQuery->select('id') ->from('be_spoke_form_records') ->whereIn('form_id', $selected_forms); }); }) ->where('head_office_id', $headOfficeId) ->where('isArchived', $is_archive_page) ->select('status', DB::raw('count(*) as count')) ->groupBy('status') ->get() ->pluck('count', 'status'); } if(request()->has('status')) { $selected_status = explode(',', request()->query('status')); } if(request()->has('awaiting')) { $selected_awaiting = explode(',', request()->query('awaiting')); } if(request()->has('sharing')) { $selected_sharing = explode(',', request()->query('sharing')); } @endphp
Create Custom Filter
APPLIED FILTER
×
SAVED FILTERS
Stage
0
Search stages...
Select All
@foreach ($stagesCount as $stageName => $stageCount)
{{ $stageName }}
{{ $stageCount }}
@endforeach
Type
0
Search case types...
Select All
@foreach ($casesGroupedByForm as $index => $f_form) @if ($f_form->name !== 'Near Miss') @php $formSlug = str_ireplace(' ', '_', strtolower($f_form->name)); @endphp
id, $selected_forms)) ? 'checked' : '' }}>
{{ $f_form->name }}
{{ $f_form->count }}
@endif @endforeach
NHS LFPSE Status
Submitted
0
Not Submitted
0
Submitted With Warning
0
Submitted With Error
0
Status
0
New
{{ $statusCount['open'] ?? 0 }}
Completed
{{ $statusCount['closed'] ?? 0 }}
In Progress
{{ $statusCount['In Progress'] ?? 0 }}
Updated
{{ $statusCount['Updated'] ?? 0 }}
Final Approval
{{ $statusCount['waiting'] ?? 0 }}
@foreach ($headOffice->case_statuses as $status) @if ($status->status === 'In Progress') @continue @endif
status, $selected_status)) checked @endif>
{{ $status->status }}
{{ $statusCount[$status->status] ?? 0 }}
@endforeach
Awaiting
0
Select All
Root Cause Analysis
{{ $rootCauseAnalysisCount }}
Request Information
{{ $requestInfoCount }}
Sharing
0
Select All
Shared
{{ $shareCaseCount }}
Extension Requested
{{ $shareCaseExtensionCount }}
Tags
{{ (isset($selected_case_tags) && $selected_case_tags ? 1 : 0) + (isset($selected_contact_tags) && $selected_contact_tags ? 1 : 0) + (isset($selected_site_tags) && $selected_site_tags ? 1 : 0) }}
@if ($headOffice->case_tags->count() > 0)
Case tags
@php $tagTree = (new \App\Models\case_tags)->buildTagTree( $headOffice->case_tags->whereNull('parent_id') ); @endphp
@foreach ($tagTree as $tag)
{!! str_repeat(' ', $tag['level']) !!} {{ $tag['name'] }}
@endforeach
@endif @if ($headOffice->contact_tags->count() > 0)
Contact tags
@foreach ($headOffice->contact_tags as $contact_tags_t )
id, $selected_contact_tags)) selected @endif value="{{ $contact_tags_t->id }}">{{ $contact_tags_t->name }}
@endforeach
@endif @if ($headOffice->location_tags->count() > 0)
Location
@foreach ($headOffice->location_tags as $loc_tags_t )
id, $selected_site_tags)) selected @endif value="{{ $loc_tags_t->id }}">{{ $loc_tags_t->name }}
@endforeach
@endif
Sites
Please select a Groups/Sites.
Date
Incident date
Reported date
Select Date Mode:
Date
Multiple Dates
Date Range
Case Investigator
0
Select Case Investigator
@php $caseInvestigators = DB::table('case_interested_parties') ->distinct('case_interested_parties.head_office_user_id') ->join('head_office_users', 'head_office_users.id', '=', 'case_interested_parties.head_office_user_id') ->join('users', 'users.id', '=', 'head_office_users.user_id') ->join('head_office_cases', 'case_interested_parties.case_id', '=', 'head_office_cases.id') ->where('head_office_cases.head_office_id', $headOfficeId) ->where('head_office_cases.isArchived', $is_archive_page) ->select('head_office_users.id', DB::raw("CONCAT(users.first_name, ' ', users.surname) as name")) ->orderBy('name') ->get(); $selected_investigators = []; if(request()->has('case_investigator')) { $selected_investigators = explode(',', request()->query('case_investigator')); } @endphp
@foreach ($caseInvestigators as $investigator)
id, $selected_investigators)) selected @endif> {{ $investigator->name }}
@endforeach
Case Handler
{{ request()->has('case_handler') ? count(explode(',', request()->query('case_handler'))) : 0 }}
Select Case Handler
@php $caseHandlers = DB::table('case_handler_users') ->distinct('case_handler_users.head_office_user_id') ->join('head_office_users', 'head_office_users.id', '=', 'case_handler_users.head_office_user_id') ->join('users', 'users.id', '=', 'head_office_users.user_id') ->join('head_office_cases', 'case_handler_users.case_id', '=', 'head_office_cases.id') ->where('head_office_cases.head_office_id', $headOfficeId) ->where('head_office_cases.isArchived', $is_archive_page) ->select('head_office_users.id', DB::raw("CONCAT(users.first_name, ' ', users.surname) as name")) ->orderBy('name') ->get(); $selected_handlers = []; if(request()->has('case_handler')) { $selected_handlers = explode(',', request()->query('case_handler')); } @endphp
@foreach ($caseHandlers as $handler)
id, $selected_handlers)) selected @endif> {{ $handler->name }}
@endforeach
Apply
Clear
@endif
@if(isset($headOffice))
Create Custom Filter
Filter Name *
@if(isset($stagesCount) && $stagesCount->count() > 0)
Stage
@foreach ($stagesCount as $stageName => $stageCount)
{{ $stageName }}
@endforeach
@endif
@if(isset($casesGroupedByForm) && $casesGroupedByForm->count() > 0)
Type
@foreach ($casesGroupedByForm as $f_form) @if ($f_form->name !== 'Near Miss')
{{ $f_form->name }}
@endif @endforeach
@endif
Status
New
Completed
In Progress
Updated
Final Approval
@if(isset($headOffice) && isset($headOffice->case_statuses)) @foreach ($headOffice->case_statuses as $status) @if ($status->status !== 'In Progress')
{{ $status->status }}
@endif @endforeach @endif
Awaiting
Request Information
Sharing
Shared
Extension Requested
@if (isset($headOffice) && isset($headOffice->case_tags) && $headOffice->case_tags->count() > 0)
Case Tags
@php $tagTree = (new \App\Models\case_tags)->buildTagTree($headOffice->case_tags->whereNull('parent_id')); @endphp @foreach ($tagTree as $tag)
{!! str_repeat(' ', $tag['level']) !!}{{ $tag['name'] }}
@endforeach
@else
No case tags available
@endif
@if(isset($headOfficeId)) @php $caseHandlers = DB::table('case_handler_users') ->distinct('case_handler_users.head_office_user_id') ->join('head_office_users', 'head_office_users.id', '=', 'case_handler_users.head_office_user_id') ->join('users', 'users.id', '=', 'head_office_users.user_id') ->join('head_office_cases', 'case_handler_users.case_id', '=', 'head_office_cases.id') ->where('head_office_cases.head_office_id', $headOfficeId) ->select('head_office_users.id', DB::raw("CONCAT(users.first_name, ' ', users.surname) as name")) ->orderBy('name') ->get(); @endphp
Case Handler
@foreach ($caseHandlers as $handler)
{{ $handler->name }}
@endforeach
@endif
@if(isset($headOfficeId)) @php $caseInvestigators = DB::table('case_interested_parties') ->distinct('case_interested_parties.head_office_user_id') ->join('head_office_users', 'head_office_users.id', '=', 'case_interested_parties.head_office_user_id') ->join('users', 'users.id', '=', 'head_office_users.user_id') ->join('head_office_cases', 'case_interested_parties.case_id', '=', 'head_office_cases.id') ->where('head_office_cases.head_office_id', $headOfficeId) ->select('head_office_users.id', DB::raw("CONCAT(users.first_name, ' ', users.surname) as name")) ->orderBy('name') ->get(); @endphp
Case Investigator
@foreach ($caseInvestigators as $investigator)
{{ $investigator->name }}
@endforeach
@endif
Sites
Date Filter Type
No Date Filter
Incident Date
Reported Date
Date Mode
Single Date
Multiple Dates
Date Range
Select Date
Select Multiple Dates
Select Date Range
@endif