@php $nameOrder = $emailOrder = $noSentMessage3Order = $noSentMessage7Order = $customerSpam3Order = $customerSpam7Order = $stopOptOutPerc3Order = $stopOptOutPerc7Order = $brandIdOrder = $campaignIdOrder = $createdAtOrder = $ageOrder = $noOfPhoneOrder = ''; $nameSort = $emailSort = $noSentMessage3Sort = $noSentMessage7Sort = $customerSpam3Sort = $customerSpam7Sort = $stopOptOutPerc3Sort = $stopOptOutPerc7Sort = $brandIdSort = $campaignIdSort = $createdAtSort = $ageSort = $noOfPhoneSort = ''; $sortField = request()->get('sort_field'); $sortOrder = request()->get('sort_order'); if(!empty($sortField)): $sortFieldArray = [ 'name' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'name'], 'email' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'email'], 'no_sent_message_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noSentMessage3'], 'no_sent_message_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noSentMessage7'], 'customer_spam_3_perc' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'customerSpam3'], 'customer_spam_7_perc' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'customerSpam7'], 'stop_opt_out_perc_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'stopOptOutPerc3'], 'stop_opt_out_perc_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'stopOptOutPerc7'], 'brand_id' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'brandId'], 'campaign_id' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'campaignId'], 'created_at' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'createdAt'], 'age' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'age'], 'phone_number' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noOfPhone'], ]; $sortOrder = strtoupper($sortOrder); if(isset($sortFieldArray[$sortField]) && isset($sortFieldArray[$sortField][$sortOrder]) ): $orderName = $sortFieldArray[$sortField]['variableName'].'Order'; $sortName = $sortFieldArray[$sortField]['variableName'].'Sort'; $$orderName = ($sortOrder == 'ASC') ? 'sorting_asc':'sorting_desc'; $$sortName = $sortOrder; endif; else: $createdAtOrder = 'sorting_desc'; $createdAtSort = 'DESC'; endif; @endphp @php $providers = getMessagingAPI(); @endphp @if ($dataCount > 0) @foreach ($data as $d) @endforeach @else @endif

Name	Email	Service Provider	No. of Sent Message (3 Days)	No. of Sent Message (7 Days)	Customer Spam % (3 Days)	Customer Spam % (7 Days)	Stop Opted Out % (3 Days)	Stop Opted Out % (7 Days)	Brand ID	Campaign ID	Register Date	Age	No. of Phones
@if ($auth_user->avatar) @else {{ $d->name }} @endif	{{ $d->email }}	@php $numberProvider = ($d->number_provider == 0) ? 1 : $d->number_provider; echo ucfirst($providers[$numberProvider]); @endphp	{{ ($d->no_sent_message_3) ? $d->no_sent_message_3 :'-' }}	{{ ($d->no_sent_message_7) ? $d->no_sent_message_7 :'-' }}	{{ ($d->customer_spam_3_perc) ? round($d->customer_spam_3_perc,2)."%" : "0.00%" }}	{{ ($d->customer_spam_7_perc) ? round($d->customer_spam_7_perc,2)."%" : "0.00%" }}	{{ ($d->stop_opt_out_perc_3) ? round($d->stop_opt_out_perc_3,2)."%" : "0.00%" }}	{{ ($d->stop_opt_out_perc_7) ? round($d->stop_opt_out_perc_7,2)."%" : "0.00%" }}	{{ ($d->brand_id) ? $d->brand_id : '-' }}	{{ ($d->campaign_id) ? $d->campaign_id : '-' }}	{{ formatDate($d->created_at, 'dt','default') }}	{{ ($d->age)?$d->age:'-' }}	{{ ($d->phone_number)?$d->phone_number:'-' }}
No data found.

@if($data->total() > 0) {!! $data->appends(request()->input())->onEachSide(3)->links() !!} @endif