Client Name :	{{ $client->txt_company }}	Report Generated :	{{ date('d-M-Y') }}
Report Period	{{ request('from_date') }} to {{ request('to_date') }}

1. Client Ticket Summary

@foreach($summary as $row) @endforeach

Description	Count
{{ $row['name'] }}	{{ $row['count'] }}

Priority Summary

@foreach($prioritySummary as $row) @endforeach

Priority	Count
{{ $row['priority'] }}	{{ $row['total'] }}

Service Summary

@foreach($serviceSummary as $row) @endforeach

Service	Tickets
{{ $row['service'] }}	{{ $row['total'] }}

2. Client Ticket Details

@foreach($tickets as $ticket) @endforeach

ID	Subject	Service	Priority	Status	Assigned	Created	Updated	Hours
# {{ $ticket->int_ID }}	{{ $ticket->txt_subject }}	{{ $ticket->servicename }}	{{ $ticket->txt_priorityList }}	{{ $ticket->status }}	{{ $ticket->staffname }}	{{ date('d-M-Y',strtotime($ticket->date_created_at)) }}	{{ date('d-M-Y',strtotime($ticket->date_lastUpdate)) }}	{{ $ticket->txt_hrsSpent ?: '-' }}

3. Client Agent Performance

@foreach($agentReport as $agent) @endforeach

Staff Name	Assigned Tickets	Complete	Open	onprocess	Hours Spent
{{ $agent['name'] }}	{{ $agent['assigned'] }}	{{ $agent['complete'] }}	{{ $agent['open'] }}	{{ $agent['onprocess'] }}	{{ $agent['hours'] }}

4. Client Priority Report

@foreach($priorityReport as $row) @endforeach

Priority	Total Tickets	complete	Open	onprocess
{{ $row['priority'] }}	{{ $row['total'] }}	{{ $row['complete'] }}	{{ $row['open'] }}	{{ $row['onprocess'] }}

5. Client Service Report

@foreach($serviceReport as $row) @endforeach

Service Name	Total Tickets	complete	Open	onprocess	Hours Spent
{{ $row['service'] }}	{{ $row['total'] }}	{{ $row['complete'] }}	{{ $row['open'] }}	{{ $row['onprocess'] }}	{{ $row['hours'] }}