@include('admin.loader')
@php
$getUserRoleData = userRoleData();
$LeadSources = explode(",",$getUserRoleData->LeadSources);
@endphp
@if( count((array) $errors) > 0)
@foreach($errors->all() as $error)
{{ trans('labels.Error') }}:
{{ $error }}
@endforeach
@endif
@if(session()->has('message'))
{{ trans('labels.Successlabel') }}
{{ session()->get('message') }}
@endif
@if(session()->has('error'))
{{ trans('labels.WarningLabel') }}
{{ session()->get('error') }}
@endif
|
Delay Summary
|
| Date |
Average |
@foreach($result['allDataCountinue'] as $date => $data)
{{ \Carbon\Carbon::parse($date)->format('d-M') }} |
@endforeach
@php
$totalMessageReceived_average = collect($result['allDataCountinue'])->sum(function($dateCollection) {
return collect($dateCollection)->sum(function($message) {
return $message->total_message_received ?? 0;
});
});
$entriesCount = collect($result['allDataCountinue'])->flatten()->count();
$totalMessageReceived_average = $entriesCount > 0 ? round($totalMessageReceived_average / $entriesCount, 2): 0;
$totalMessagesend_average = collect($result['allDataCountinue'])->sum(function($dateCollection) {
return collect($dateCollection)->sum(function($message) {
return $message->total_message_sent ?? 0;
});
});
$entriesCount = collect($result['allDataCountinue'])->flatten()->count();
$totalMessagesend_average = $entriesCount > 0 ? round($totalMessagesend_average / $entriesCount, 2): 0;
$total_delay_message_average = collect($result['allDataCountinue'])->sum(function($dateCollection) {
return collect($dateCollection)->sum(function($message) {
return $message->total_delay_message ?? 0;
});
});
$entriesCount = collect($result['allDataCountinue'])->flatten()->count();
$total_delay_message_average = $entriesCount > 0 ? round($total_delay_message_average / $entriesCount, 2): 0;
$total_delay_message_percentage = $totalMessageReceived_average > 0 ? round(($total_delay_message_average / $totalMessageReceived_average) * 100, 2) : 0;
$totalDelayPercent = 0;
$count = 0;
foreach ($result['allDataCountinue'] as $data) {
$delayPercent = $data->first()->delay_percent ?? 0;
$totalDelayPercent += $delayPercent;
$count++;
}
// Calculate the average delay_percent
$averageDelayPercent = round($count > 0 ? $totalDelayPercent / $count : 0, 2);
@endphp
| Total Message Received |
{{ $totalMessageReceived_average }} |
@foreach($result['allDataCountinue'] as $data)
{{ $data->first()->total_message_received ?? 0 }} |
@endforeach
| Total Message Sent |
{{ $totalMessagesend_average }} |
@foreach($result['allDataCountinue'] as $data)
{{ $data->first()->total_message_sent ?? 0 }} |
@endforeach
| Total Delay Messages |
{{ $total_delay_message_average }} |
@foreach($result['allDataCountinue'] as $data)
{{ $data->first()->total_delay_message ?? 0 }} |
@endforeach
| Delay % |
{{ $averageDelayPercent }}
|
@foreach($result['allDataCountinue'] as $data)
{{ $data->first()->delay_percent ?? 0 }} |
@endforeach
@php
$total_unique_guru = collect($result['UniqueDataCount'])->sum(function($dateCollection) {
return collect($dateCollection)->sum(function($message) {
return $message->total_unique_guru ?? 0;
});
});
$unique_guru_report = $total_unique_guru;
$entriesCount = collect($result['UniqueDataCount'])->flatten()->count();
$total_unique_guru = $entriesCount > 0 ? round($total_unique_guru / $entriesCount, 2) : 0;
$total_unique_tashan = collect($result['UniqueDataCount'])->sum(function($dateCollection) {
return collect($dateCollection)->sum(function($message) {
return $message->total_unique_tashan ?? 0;
});
});
$unique_tashan_report = $total_unique_tashan;
$entriesCount = collect($result['UniqueDataCount'])->flatten()->count();
$total_unique_tashan = $entriesCount > 0 ? round($total_unique_tashan / $entriesCount, 2): 0;
$total_unique_vois = collect($result['UniqueDataCount'])->sum(function($dateCollection) {
return collect($dateCollection)->sum(function($message) {
return $message->total_unique_vois ?? 0;
});
});
$unique_vois_report = $total_unique_vois;
$entriesCount = collect($result['UniqueDataCount'])->flatten()->count();
$total_unique_vois = $entriesCount > 0 ? round($total_unique_vois / $entriesCount, 2): 0;
$total_unique_boss = collect($result['UniqueDataCount'])->sum(function($dateCollection) {
return collect($dateCollection)->sum(function($message) {
return $message->total_unique_boss ?? 0;
});
});
$unique_boss_report = $total_unique_boss;
$entriesCount = collect($result['UniqueDataCount'])->flatten()->count();
$total_unique_boss = $entriesCount > 0 ? round($total_unique_boss / $entriesCount, 2): 0;
$total_unique_brampton = collect($result['UniqueDataCount'])->sum(function($dateCollection) {
return collect($dateCollection)->sum(function($message) {
return $message->total_unique_brampton ?? 0;
});
});
$unique_brampton_report = $total_unique_brampton;
$entriesCount = collect($result['UniqueDataCount'])->flatten()->count();
$total_unique_brampton = $entriesCount > 0 ? round($total_unique_brampton / $entriesCount, 2): 0;
$total_unique_indian = collect($result['UniqueDataCount'])->sum(function($dateCollection) {
return collect($dateCollection)->sum(function($message) {
return $message->total_unique_indian ?? 0;
});
});
$unique_indian_report = $total_unique_indian;
$entriesCount = collect($result['UniqueDataCount'])->flatten()->count();
$total_unique_indian = $entriesCount > 0 ? round($total_unique_indian / $entriesCount, 2): 0;
$total_unique_all_products = collect($result['UniqueDataCount'])->sum(function($dateCollection) {
return collect($dateCollection)->sum(function($message) {
return $message->total_unique_all_products ?? 0;
});
});
$totalUniqueProducts = 0;
$count = 0;
foreach($result['UniqueDataCount'] as $data) {
$totalUniqueProducts += $data->first()->total_unique_all_products ?? 0;
$count++;
}
$averageUniqueProducts = $count > 0 ? round($totalUniqueProducts / $count, 2) : 0;
@endphp
|
Unique Chat Received Summary
|
| Brand |
Average |
@foreach($result['UniqueDataCount'] as $date => $data)
{{ \Carbon\Carbon::parse($date)->format('d-M') }} |
@endforeach
| Guru |
{{ $total_unique_guru }} |
@foreach($result['UniqueDataCount'] as $data)
{{ $data->first()->total_unique_guru ?? 0 }} |
@endforeach
| Tashan |
{{ $total_unique_tashan }} |
@foreach($result['UniqueDataCount'] as $data)
{{ $data->first()->total_unique_tashan ?? 0 }} |
@endforeach
| Boss |
{{ $total_unique_vois }} |
@foreach($result['UniqueDataCount'] as $data)
{{ $data->first()->total_unique_vois ?? 0 }} |
@endforeach
| Vois |
{{ $total_unique_boss }}
|
@foreach($result['UniqueDataCount'] as $data)
{{ $data->first()->total_unique_boss ?? 0 }} |
@endforeach
| Brampton |
{{ $total_unique_brampton }}
|
@foreach($result['UniqueDataCount'] as $data)
{{ $data->first()->total_unique_brampton ?? 0 }} |
@endforeach
| Indian |
{{ $total_unique_indian }}
|
@foreach($result['UniqueDataCount'] as $data)
{{ $data->first()->total_unique_indian ?? 0 }} |
@endforeach
| Total |
{{ $averageUniqueProducts }}
|
@foreach($result['UniqueDataCount'] as $data)
{{ $data->first()->total_unique_all_products ?? 0 }} |
@endforeach
|
Guru
|
| Total Message Send |
@if($result['guruProductCount']->isNotEmpty())
{{ $result['guruProductCount'][0]->sender_count_guru }}
@else
0
@endif |
| Total Message Received |
{{ $result['guruProductCount'][0]->recipient_count_guru }}
|
| Total Unique Number |
{{ $unique_guru_report }}
|
| Name |
Sent Message |
Delay Message |
Unique Number |
@if(count((array) $result['guru'])>0)
@foreach ($result['guru'] as $atVal)
| {{ $atVal->first_name }} {{ $atVal->last_name }} |
{{ $atVal->total_messages }} |
{{ $atVal->delay_message_count_less_than_5}} |
{{ $atVal->unique_message_recipient_id}} |
@endforeach
@endif
|
Tashan
|
| Total Message Send |
@if($result['tashanProductCount']->isNotEmpty())
{{ $result['tashanProductCount'][0]->sender_count }}
@else
0
@endif |
| Total Message Received |
@if($result['tashanProductCount']->isNotEmpty())
{{ $result['tashanProductCount'][0]->recipient_count }}
@else
0
@endif |
| Total Unique Number |
{{ $unique_tashan_report }}
|
| Name |
Sent Message |
Delay Message |
Unique Number |
@if(count((array) $result['tashan'])>0)
@foreach ($result['tashan'] as $atVal)
| {{ $atVal->first_name }} {{ $atVal->last_name }} |
{{ $atVal->total_messages }} |
{{ $atVal->delay_message_count_less_than_5}} |
{{ $atVal->unique_message_recipient_id}} |
@endforeach
@endif
|
Boss
|
| Total Message Send |
@if($result['bossProductCount']->isNotEmpty())
{{ $result['bossProductCount'][0]->sender_count }}
@else
0
@endif |
| Total Message Received |
@if($result['bossProductCount']->isNotEmpty())
{{ $result['bossProductCount'][0]->recipient_count }}
@else
0
@endif |
| Total Unique Number |
{{ $unique_boss_report }}
|
| Name |
Sent Message |
Delay Message |
Unique Number |
@if(count((array) $result['boss'])>0)
@foreach ($result['boss'] as $atVal)
| {{ $atVal->first_name }} {{ $atVal->last_name }} |
{{ $atVal->total_messages }} |
{{ $atVal->delay_message_count_less_than_5}} |
{{ $atVal->unique_message_recipient_id}} |
@endforeach
@endif
|
Vois
|
| Total Message Send |
@if($result['voisProductCount']->isNotEmpty())
{{ $result['voisProductCount'][0]->sender_count }}
@else
0
@endif |
| Total Message Received |
@if($result['voisProductCount']->isNotEmpty())
{{ $result['voisProductCount'][0]->recipient_count }}
@else
0
@endif |
| Total Unique Number |
{{ $unique_vois_report }}
|
| Name |
Sent Message |
Delay Message |
Unique Number |
@if(count((array) $result['vois'])>0)
@foreach ($result['vois'] as $atVal)
| {{ $atVal->first_name }} {{ $atVal->last_name }} |
{{ $atVal->total_messages }} |
{{ $atVal->delay_message_count_less_than_5}} |
{{ $atVal->unique_message_recipient_id}} |
@endforeach
@endif
|
Brampton
|
| Total Message Send |
@if($result['bramptonProductCount']->isNotEmpty())
{{ $result['bramptonProductCount'][0]->sender_count }}
@else
0
@endif |
| Total Message Received |
@if($result['bramptonProductCount']->isNotEmpty())
{{ $result['bramptonProductCount'][0]->recipient_count }}
@else
0
@endif |
| Total Unique Number |
{{ $unique_brampton_report }}
|
| Name |
Sent Message |
Delay Message |
Unique Number |
@if(count((array) $result['brampton'])>0)
@foreach ($result['brampton'] as $atVal)
| {{ $atVal->first_name }} {{ $atVal->last_name }} |
{{ $atVal->total_messages }} |
{{ $atVal->delay_message_count_less_than_5}} |
{{ $atVal->unique_message_recipient_id}} |
@endforeach
@endif
|
Indian
|
| Total Message Send |
@if($result['indianProductCount']->isNotEmpty())
{{ $result['indianProductCount'][0]->sender_count }}
@else
0
@endif |
| Total Message Received |
@if($result['indianProductCount']->isNotEmpty())
{{ $result['indianProductCount'][0]->recipient_count }}
@else
0
@endif |
| Total Unique Number |
{{ $unique_indian_report }}
|
| Name |
Sent Message |
Delay Message |
Unique Number |
@if(count((array) $result['indian'])>0)
@foreach ($result['indian'] as $atVal)
| {{ $atVal->first_name }} {{ $atVal->last_name }} |
{{ $atVal->total_messages }} |
{{ $atVal->delay_message_count_less_than_5}} |
{{ $atVal->unique_message_recipient_id}} |
@endforeach
@endif