@php $messageStatusOrder = $userStatusOrder = $einVerifiedOrder = $noContactReached3Order = $noSentMessage3Order = $noFailedMessage3Order = $noFailedMessagePerc3Order = $noSpamMessage3Order = $noSpamMessagePerc3Order = $noViolationMessage3Order = $noViolationMessagePerc3Order = $noAutoOptOutContact3Order = $noAutoOptOutMessage3Order = $autoOptOutPerc3Order = $noStopOptOutContact3Order = $noStopOptOutMessage3Order = $stopOptOutPerc3Order = $totalOptOutContact3Order = $totalOptOutMessage3Order = $totalOptOutMessagePerc3Order = $avgStopOptOutPerc3Order = $noContactReached7Order = $noSentMessage7Order = $noFailedMessage7Order = $noFailedMessagePerc7Order = $noSpamMessage7Order = $noSpamMessagePerc7Order = $noViolationMessage7Order = $noViolationMessagePerc7Order = $noAutoOptOutContact7Order = $noAutoOptOutMessage7Order = $autoOptOutPerc7Order = $noStopOptOutContact7Order = $noStopOptOutMessage7Order = $stopOptOutPerc7Order = $totalOptOutContact7Order = $totalOptOutMessage7Order = $totalOptOutMessagePerc7Order = $avgStopOptOutPerc7Order = $stateUpdatedAtOrder = ''; $messageStatusSort = $userStatusSort = $einVerifiedSort = $noContactReached3Sort = $noSentMessage3Sort = $noFailedMessage3Sort = $noFailedMessagePerc3Sort = $noSpamMessage3Sort = $noSpamMessagePerc3Sort = $noViolationMessage3Sort = $noViolationMessagePerc3Sort = $noAutoOptOutContact3Sort = $noAutoOptOutMessage3Sort = $autoOptOutPerc3Sort = $noStopOptOutContact3Sort = $noStopOptOutMessage3Sort = $stopOptOutPerc3Sort = $totalOptOutContact3Sort = $totalOptOutMessage3Sort = $totalOptOutMessagePerc3Sort = $avgStopOptOutPerc3Sort = $noContactReached7Sort = $noSentMessage7Sort = $noFailedMessage7Sort = $noFailedMessagePerc7Sort = $noSpamMessage7Sort = $noSpamMessagePerc7Sort = $noViolationMessage7Sort = $noViolationMessagePerc7Sort = $noAutoOptOutContact7Sort = $noAutoOptOutMessage7Sort = $autoOptOutPerc7Sort = $noStopOptOutContact7Sort = $noStopOptOutMessage7Sort = $stopOptOutPerc7Sort = $totalOptOutContact7Sort = $totalOptOutMessage7Sort = $totalOptOutMessagePerc7Sort = $avgStopOptOutPerc7Sort = $stateUpdatedAtSort = ''; $sortField = request()->get('sort_field'); $sortOrder = request()->get('sort_order'); if(!empty($sortField)): $sortFieldArray = [ 'messaging_status' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'messageStatus'], 'status' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'userStatus'], 'ein_verified' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'einVerified'], 'no_contact_reached_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noContactReached3'], 'no_sent_message_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noSentMessage3'], 'no_failed_message_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noFailedMessage3'], 'no_failed_message_perc_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noFailedMessagePerc3'], 'no_spam_message_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noSpamMessage3'], 'no_spam_message_perc_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noSpamMessagePerc3'], 'no_violation_message_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noViolationMessage3'], 'no_violation_message_perc_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noViolationMessagePerc3'], 'no_auto_opt_out_contact_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noAutoOptOutContact3'], 'no_auto_opt_out_message_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noAutoOptOutMessage3'], 'auto_opt_out_perc_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'autoOptOutPerc3'], 'no_stop_opt_out_contact_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noStopOptOutContact3'], 'no_stop_opt_out_message_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noStopOptOutMessage3'], 'stop_opt_out_perc_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'stopOptOutPerc3'], 'total_opt_out_contact_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'totalOptOutContact3'], 'total_opt_out_message_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'totalOptOutMessage3'], 'total_opt_out_message_perc_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'totalOptOutMessagePerc3'], $columnName.'_avg_stop_opt_out_perc_3' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'avgStopOptOutPerc3'], 'no_contact_reached_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noContactReached7'], 'no_sent_message_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noSentMessage7'], 'no_failed_message_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noFailedMessage7'], 'no_failed_message_perc_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noFailedMessagePerc7'], 'no_spam_message_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noSpamMessage7'], 'no_spam_message_perc_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noSpamMessagePerc7'], 'no_violation_message_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noViolationMessage7'], 'no_violation_message_perc_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noViolationMessagePerc7'], 'no_auto_opt_out_contact_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noAutoOptOutContact7'], 'no_auto_opt_out_message_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noAutoOptOutMessage7'], 'auto_opt_out_perc_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'autoOptOutPerc7'], 'no_stop_opt_out_contact_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noStopOptOutContact7'], 'no_stop_opt_out_message_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'noStopOptOutMessage7'], 'stop_opt_out_perc_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'stopOptOutPerc7'], 'total_opt_out_contact_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'totalOptOutContact7'], 'total_opt_out_message_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'totalOptOutMessage7'], 'total_opt_out_message_perc_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'totalOptOutMessagePerc7'], $columnName.'_avg_stop_opt_out_perc_7' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'avgStopOptOutPerc7'], 'updated_at' => ['ASC' => 'ASC', 'DESC' => 'DESC', 'variableName' => 'stateUpdatedAt'], ]; 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: $stateUpdatedAtOrder = 'sorting_desc'; $stateUpdatedAtSort = 'DESC'; endif; @endphp @if(in_array('messaging_status', $tableFilterColumn)) @endif @if(in_array('status', $tableFilterColumn)) @endif @if(in_array('ein_verified', $tableFilterColumn)) @endif @if(in_array('no_contact_reached_3', $tableFilterColumn)) @endif @if(in_array('no_sent_message_3', $tableFilterColumn)) @endif @if(in_array('no_failed_message_3', $tableFilterColumn)) @endif @if(in_array('no_failed_message_perc_3', $tableFilterColumn)) @endif @if(in_array('no_spam_message_3', $tableFilterColumn)) @endif @if(in_array('no_spam_message_perc_3', $tableFilterColumn)) @endif @if(in_array('no_violation_message_3', $tableFilterColumn)) @endif @if(in_array('no_violation_message_perc_3', $tableFilterColumn)) @endif @if(in_array('no_auto_opt_out_contact_3', $tableFilterColumn)) @endif @if(in_array('no_auto_opt_out_message_3', $tableFilterColumn)) @endif @if(in_array('auto_opt_out_perc_3', $tableFilterColumn)) @endif @if(in_array('no_stop_opt_out_contact_3', $tableFilterColumn)) @endif @if(in_array('no_stop_opt_out_message_3', $tableFilterColumn)) @endif @if(in_array('stop_opt_out_perc_3', $tableFilterColumn)) @endif @if(in_array('total_opt_out_contact_3', $tableFilterColumn)) @endif @if(in_array('total_opt_out_message_3', $tableFilterColumn)) @endif @if(in_array('total_opt_out_message_perc_3', $tableFilterColumn)) @endif @if(in_array($columnName.'_avg_stop_opt_out_perc_3', $tableFilterColumn)) @endif @if(in_array('no_contact_reached_7', $tableFilterColumn)) @endif @if(in_array('no_sent_message_7', $tableFilterColumn)) @endif @if(in_array('no_failed_message_7', $tableFilterColumn)) @endif @if(in_array('no_failed_message_perc_7', $tableFilterColumn)) @endif @if(in_array('no_spam_message_7', $tableFilterColumn)) @endif @if(in_array('no_spam_message_perc_7', $tableFilterColumn)) @endif @if(in_array('no_violation_message_7', $tableFilterColumn)) @endif @if(in_array('no_violation_message_perc_7', $tableFilterColumn)) @endif @if(in_array('no_auto_opt_out_contact_7', $tableFilterColumn)) @endif @if(in_array('no_auto_opt_out_message_7', $tableFilterColumn)) @endif @if(in_array('auto_opt_out_perc_7', $tableFilterColumn)) @endif @if(in_array('no_stop_opt_out_contact_7', $tableFilterColumn)) @endif @if(in_array('no_stop_opt_out_message_7', $tableFilterColumn)) @endif @if(in_array('stop_opt_out_perc_7', $tableFilterColumn)) @endif @if(in_array('total_opt_out_contact_7', $tableFilterColumn)) @endif @if(in_array('total_opt_out_message_7', $tableFilterColumn)) @endif @if(in_array('total_opt_out_message_perc_7', $tableFilterColumn)) @endif @if(in_array($columnName.'_avg_stop_opt_out_perc_7', $tableFilterColumn)) @endif @if(isset($data) && $dataCount > 0) @foreach($data as $d) @if(in_array('messaging_status', $tableFilterColumn)) @endif @if(in_array('status', $tableFilterColumn)) @endif @if(in_array('ein_verified', $tableFilterColumn)) @endif @if(in_array('no_contact_reached_3', $tableFilterColumn)) @endif @if(in_array('no_sent_message_3', $tableFilterColumn)) @endif @if(in_array('no_failed_message_3', $tableFilterColumn)) @endif @if(in_array('no_failed_message_perc_3', $tableFilterColumn)) @endif @if(in_array('no_spam_message_3', $tableFilterColumn)) @endif @if(in_array('no_spam_message_perc_3', $tableFilterColumn)) @endif @if(in_array('no_violation_message_3', $tableFilterColumn)) @endif @if(in_array('no_violation_message_perc_3', $tableFilterColumn)) @endif @if(in_array('no_auto_opt_out_contact_3', $tableFilterColumn)) @endif @if(in_array('no_auto_opt_out_message_3', $tableFilterColumn)) @endif @if(in_array('auto_opt_out_perc_3', $tableFilterColumn)) @endif @if(in_array('no_stop_opt_out_contact_3', $tableFilterColumn)) @endif @if(in_array('no_stop_opt_out_message_3', $tableFilterColumn)) @endif @if(in_array('stop_opt_out_perc_3', $tableFilterColumn)) @endif @if(in_array('total_opt_out_contact_3', $tableFilterColumn)) @endif @if(in_array('total_opt_out_message_3', $tableFilterColumn)) @endif @if(in_array('total_opt_out_message_perc_3', $tableFilterColumn)) @endif @if(in_array($columnName.'_avg_stop_opt_out_perc_3', $tableFilterColumn)) @endif @if(in_array('no_contact_reached_7', $tableFilterColumn)) @endif @if(in_array('no_sent_message_7', $tableFilterColumn)) @endif @if(in_array('no_failed_message_7', $tableFilterColumn)) @endif @if(in_array('no_failed_message_perc_7', $tableFilterColumn)) @endif @if(in_array('no_spam_message_7', $tableFilterColumn)) @endif @if(in_array('no_spam_message_perc_7', $tableFilterColumn)) @endif @if(in_array('no_violation_message_7', $tableFilterColumn)) @endif @if(in_array('no_violation_message_perc_7', $tableFilterColumn)) @endif @if(in_array('no_auto_opt_out_contact_7', $tableFilterColumn)) @endif @if(in_array('no_auto_opt_out_message_7', $tableFilterColumn)) @endif @if(in_array('auto_opt_out_perc_7', $tableFilterColumn)) @endif @if(in_array('no_stop_opt_out_contact_7', $tableFilterColumn)) @endif @if(in_array('no_stop_opt_out_message_7', $tableFilterColumn)) @endif @if(in_array('stop_opt_out_perc_7', $tableFilterColumn)) @endif @if(in_array('total_opt_out_contact_7', $tableFilterColumn)) @endif @if(in_array('total_opt_out_message_7', $tableFilterColumn)) @endif @if(in_array('total_opt_out_message_perc_7', $tableFilterColumn)) @endif @if(in_array($columnName.'_avg_stop_opt_out_perc_7', $tableFilterColumn)) @endif @endforeach @else @endif

Name	Email	Phone	Phone Status	Client Offenses	Messaging Status	Status	EIN Verfified	Contact Reached (3 Days)	No. of Sent Message (3 Days)	No. of Failed Message (3 Days)	No. of Failed Message % (3 Days)	No. of Spam Message (3 Days)	No. of Spam Message % (3 Days)	No. of Violation Message (3 Days)	No. of Violation Message % (3 Days)	No. of Auto Opt Out Contact (3 Days)	No. of Auto Opt Out Message (3 Days)	Auto Opt Out % (3 Days)	No. of Stop Opt Out Contact (3 Days)	No. of Stop Opt Out Message (3 Days)	Stop Opt Out % (3 Days)	Total Opt Out Contact (3 Days)	Total Opt Out Message (3 Days)	Total Opt Out Message % (3 Days)	Avg. Stop Opt Out % (3 Days)	Contact Reached (7 Days)	No. of Sent Message (7 Days)	No. of Failed Message (7 Days)	No. of Failed Message % (7 Days)	No. of Spam Message (7 Days)	No. of Spam Message % (7 Days)	No. of Violation Message (7 Days)	No. of Violation Message % (7 Days)	No. of Auto Opt Out Contact (7 Days)	No. of Auto Opt Out Message (7 Days)	Auto Opt Out % (7 Days)	No. of Stop Opt Out Contact (7 Days)	No. of Stop Opt Out Message (7 Days)	Stop Opt Out % (7 Days)	Total Opt Out Contact (7 Days)	Total Opt Out Message (7 Days)	Total Opt Out Message % (7 Days)	Avg. Stop Opt Out % (7 Days)	Update At	Action
{{ $d->name }}	{{ $d->email }}	{{ $d->phone }}	{!! getPhoneNumberStatus($d->sid, $d->user_id) !!}	{{$d->offend_count}}	{!! $d->messaging_status ? 'Yes':'No' !!}	{!! $d->status ? 'Yes':'No' !!}	{!! $d->ein_verified ? 'Yes':'No' !!}	{{ $d->no_contact_reached_3 }}	{{ $d->no_sent_message_3 }}	{{ $d->no_failed_message_3 }}	{{ $d->no_failed_message_perc_3."%" }}	{{ $d->no_spam_message_3 }}	{{ $d->no_spam_message_perc_3."%" }}	{{ $d->no_violation_message_3 }}	{{ $d->no_violation_message_perc_3."%" }}	{{ $d->no_auto_opt_out_contact_3 }}	{{ $d->no_auto_opt_out_message_3 }}	{{ $d->auto_opt_out_perc_3."%" }}	{{ $d->no_stop_opt_out_contact_3 }}	{{ $d->no_stop_opt_out_message_3 }}	{{ $d->stop_opt_out_perc_3."%" }}	{{ $d->total_opt_out_contact_3 }}	{{ $d->total_opt_out_message_3 }}	{{ $d->total_opt_out_message_perc_3."%" }}	{{$d->{$columnName.'_avg_stop_opt_out_perc_3'}."%"}}	{{ $d->no_contact_reached_7 }}	{{ $d->no_sent_message_7 }}	{{ $d->no_failed_message_7 }}	{{ $d->no_failed_message_perc_7."%" }}	{{ $d->no_spam_message_7 }}	{{ $d->no_spam_message_perc_7."%" }}	{{ $d->no_violation_message_7 }}	{{ $d->no_violation_message_perc_7."%" }}	{{ $d->no_auto_opt_out_contact_7 }}	{{ $d->no_auto_opt_out_message_7 }}	{{ $d->auto_opt_out_perc_7."%" }}	{{ $d->no_stop_opt_out_contact_7 }}	{{ $d->no_stop_opt_out_message_7 }}	{{ $d->stop_opt_out_perc_7."%" }}	{{ $d->total_opt_out_contact_7 }}	{{ $d->total_opt_out_message_7 }}	{{ $d->total_opt_out_message_perc_7."%" }}	{{$d->{$columnName.'_avg_stop_opt_out_perc_7'}."%"}}	{{ $d->updated_at ? formatDate($d->updated_at, 'dt','default') : '-' }}	Actions Sync
No data found

{!! $data->appends(request()->input())->onEachSide(3)->links() !!}