Service Request Report
@include('service_request::admin.service_request.report.filters')


@php $groupby = $group['groupby']; $name = ''; if ($groupby == 'service_requests.departmentid') { $name = 'Department'; } elseif($groupby == 'service_requests.workdepartmentid'){ $name = 'Work Department'; } elseif($groupby == 'assets.category_id'){ $name = 'Category'; } elseif($groupby == 'assets.subcategory_id'){ $name = 'Sub Category'; } elseif($groupby == 'assets.subclass_id'){ $name = 'Sub Class'; } @endphp
Summary View - {{ $name}}
{{-- @forelse($service_requests['available'] as $key=>$service_request) @empty @endif
Group By Pending Assigned Accepted WIP Cancelled By User Completed Total
{{$service_request->labels}} {{$service_request->pending}} {{$service_request->assigned}} {{$service_request->accepted}} {{$service_request->wip}} {{$service_request->cancelled_by_user}} {{$service_request->completed}} {{$service_request->total}}
--}} @php $pendingcount = 0; $assignedcount = 0; $acceptedcount = 0; $wipcount = 0; $cancelusercount = 0; $completedcount = 0; foreach ($service_requests['available'] as $service_request) { $pendingcount += $service_request->pending; $assignedcount += $service_request->assigned; $acceptedcount += $service_request->accepted; $wipcount += $service_request->wip; $cancelusercount += $service_request->cancelled_by_user; $completedcount += $service_request->completed; } @endphp

{{-- {{dd($group)}} --}} @if($group['groupby'] === 'service_requests.workdepartmentid' && $group['show_sub_work'] === 'Yes') @endif @if($pendingcount > 0) @else @endif @if($assignedcount > 0) @else @endif @if($acceptedcount > 0) @else @endif @if($wipcount > 0) @else @endif @if($cancelusercount > 0) @else @endif @if($completedcount > 0) @else @endif @forelse($service_requests['available'] as $key=>$service_request) @if($group['groupby'] === 'service_requests.workdepartmentid' && $group['show_sub_work'] === 'Yes') @endif @if($pendingcount > 0) @else @endif @if($assignedcount > 0) @else @endif @if($acceptedcount > 0) @else @endif @if($wipcount > 0) @else @endif @if($cancelusercount > 0) @else @endif @if($completedcount > 0) @else @endif @empty @endif
Group BySub Work Job TypePendingAssignedAcceptedWIPCancelled By UserCompletedTotal
{{$service_request->labels}}{{$service_request->sub_work}} {{$service_request->job_type}}{{$service_request->pending}}{{$service_request->assigned}}{{$service_request->accepted}}{{$service_request->wip}}{{$service_request->cancelled_by_user}}{{$service_request->completed}}{{$service_request->total}}


Service Requests Graph
@php $total = 0; @endphp @forelse ($service_requests['available'] as $key=>$service_request) @php $total += $service_request->total; @endphp @endforeach @forelse($service_requests['available'] as $key=>$service_request) @php $percentage = ($service_request->total / $total) * 100; @endphp @empty @endif
{{$service_request->labels}}:{{$service_request->total}} ({{ number_format($percentage, 1, '.', '.') }}%)
{{$service_requests['labels']/4}} {{$service_requests['labels']/2}} {{$service_requests['labels']/2+$service_requests['labels']/4}} {{$service_requests['labels']}}

@forelse(array_slice($service_requests['all'], 0, $pageLength) as $key=>$row) @if($key == 00)

Detail View
@endif @forelse($row as $key=>$inner_row) @php if($inner_row['workorder_no'] !=''){ $workno = 'WO-'.$inner_row['workorder_no']; } else { $workno = ''; } @endphp @empty @endif
Service Request Preferred Date Request By Asset Request Type Job Priority Department Work Department Status Work Order Work Order Status Company Division
{{@$inner_row['request_no']}} {{@$inner_row['request_date']}} {{@$inner_row['employee']['name']}} ({{(@$inner_row['asset']['rfc']?@$inner_row['asset']['rfc']:@$inner_row['asset']['id'])}}) - {{@$inner_row['asset']['name']}} {{@$inner_row['request_type']}} {{@$inner_row['job_priority']}} {{@$inner_row['department']['name']}} {{@$inner_row['work_department']['name']}} {{@$inner_row['status']}} {{@$workno}} {{@$inner_row['workorder_status']}} {{@$inner_row['company']['name']}} {{@$inner_row['division']['name']}}
@empty @endif