@include('admin.common.meta')
@include('admin.common.scripts')

<style>
    #watermarked::before {
        position: fixed;
        top: -75%;
        left: -75%;

        display: block;
        width: 300%;
        height: 300%;

        transform: rotate(-45deg);
        content: attr(data-watermark);

        font-size: 30px;
        opacity: 0.05;
        line-height: 4em;
        letter-spacing: 2px;
        color: #ff0523;
        z-index:0;
    }
    .content-wrapper, .right-side{
        background: #FFF;
    }
    .box {
        background: transparent;
        z-index: 1;
    }
    .bootstrap-select.btn-group .dropdown-menu li {
        border-bottom: 1px solid #6c6c6cde;
    }
    .box-body br {
        display: block !important;
    }

    .signatures-table  br {
        display: none !important;
    }

    ._subject .dropdown-menu {
        box-shadow: -1px 3px 13px 0 rgba(85, 85, 85, 0.52);
        border: 1px solid #b5b5b5;
        /*width: 100%;*/
    }
    ul.typeahead li {
        border-bottom: 1px solid;
    }
    .typeahead__container {
        font: 1.3rem Lato, "Helvetica Neue", Arial, Helvetica, sans-serif;
    }
    .typeahead__label {
        font-size: calc(1rem * 1.1);
    }
    #search_admin .typeahead__result ul.typeahead__list {
        overflow-y: scroll;
        height: 350px;
        overflow-x: auto;
    }
    #leads_products .typeahead__result ul.typeahead__list {
        overflow-y: scroll;
        height: 350px;
        overflow-x: auto;
    }
    input#search_text,#from_date, #to_date{
        height: 28px;
    }
    /*    new style added by Dalip on 20-05-2020*/
    .row.myFlexDiv {
        display: flex;
        margin: 15px -5px 0px;
        border-bottom: 1px solid rgba(0,0,0,0.1);
        padding-bottom: 10px;
        margin-bottom: 10px !important
    }

    .row.myFlexDiv > div {
        padding: 0 5px;
        margin-bottom: 0;
    }

    .row.myFlexDiv > div .form-group {
        margin-bottom: 0;
    }
    html .typeahead__label-container {
        position: static;
        display: flex;
        order: 2;
        padding: 5px 0 0 0 !important;
        max-height:60px;
        overflow-y: auto;
    }

    html .typeahead__query {
        position: relative;
        z-index: 2;
        width: 100%;
        display: flex;
        flex-wrap: wrap;
    }
    .typeahead__field input, .typeahead__field textarea, .typeahead__field [contenteditable], .typeahead__field .typeahead__hint {
        padding: 0.5rem 0.75rem !important;
    }
    html .typeahead__label > *{
        line-height: 1.2;
        font-size: 11px;
        align-self: center;
    }
    html .typeahead__label .typeahead__cancel-button{
        padding-top: 0;
        padding-bottom: 0;
        line-height: 1.2;
        font-size: 11px;
    }
    .row.myFlexDiv > div .btn-primary {
        line-height: 1;
        width: 100%;
    }
    ::-webkit-scrollbar {
        width: 5px;
    }

    ::-webkit-scrollbar-track {
        box-shadow: inset 0 0 6px rgba(0, 0, 0, 0.3);
    }

    ::-webkit-scrollbar-thumb {
        background-color: darkgrey;
        outline: 1px solid slategrey;
    }
    html ul.typeahead__list {
        height: auto !important;
        max-height: 50vh;
        overflow-y: auto;
    }
    #error_search_text {
        color: red;
        font-size: 12px;
    }
    .fullLoader{
        position: absolute;
        width: 100%;
        height: 100%;
        background: rgba(255, 255, 255, 0.8) url("{{ URL::to('/assets/admin/images/img/loading.svg')}}") no-repeat center 20px;
        background-size: 50px;
        display: none;
        z-index: 99;
    }
    .row.listing {
        position: relative;
    }
</style>
<div class="search-list">
    <div class="content-wrappers"> 	
        <section class="content-header">
            <h1> {{ trans(' WhatsApp Hourly Report') }}</h1>
            <ol class="breadcrumb">
                <li><a href="{{ URL::to('admin/dashboard/this_month')}}"><i class="fa fa-dashboard"></i> {{ trans('labels.breadcrumb_dashboard') }}</a></li>
                <li class="active"> {{ trans('WhatsApp Hourly Report') }}</li>
            </ol>
        </section>
        @include('admin.loader')
        @php
        $getUserRoleData = userRoleData();
        $LeadSources		= explode(",",$getUserRoleData->LeadSources);
        @endphp	
        <section class="content">
            <div class="row">
                <div class="col-xs-12">
                    <div class="box box-info">
                        <div class="box-body">	
                            <div class="col-xs-12">

                                
                            <ul class="nav nav-tabs">
                                <li class="nav-item" style="margin-left:3px">
                                    <a class="nav-link  active" aria-current="page" href="{{env('APP_URL')}}/admin/whatsapp-reporting" style="background-color: #eeeeee; color:black">WhatsApp Report</a>
                                </li>
                                <li class="nav-item" style="margin-left:3px">
                                    <a class="nav-link" href="{{env('APP_URL')}}/admin/whatsapp-reporting-timed-out" style="background-color: #eeeeee; color:black">WhatsApp Timed Out Report</a>
                                </li>
                                <li class="nav-item" style="margin-left:3px">
                                    <a class="nav-link"  href="{{env('APP_URL')}}/admin/whatsapp-hourly-data2?dropdown_data=All+Product" style="background-color: #3c8dbc; color: white;">WhatsApp Hourly Report</a>
                                </li>
                            </ul>


                                <div class="row">
                                     @if( count((array) $errors) > 0)
                                        @foreach($errors->all() as $error)
                                        <div class="alert alert-danger" role="alert">
                                            <span class="glyphicon glyphicon-exclamation-sign" aria-hidden="true"></span>
                                            <span class="sr-only">{{ trans('labels.Error') }}:</span>
                                            {{ $error }}
                                        </div>
                                        @endforeach
                                        @endif   
                                        @if(session()->has('message'))
                                        <div class="alert alert-success alert-dismissible">
                                            <button aria-hidden="true" data-dismiss="alert" class="close" type="button">×</button>
                                            <h4><i class="icon fa fa-check"></i> {{ trans('labels.Successlabel') }}</h4>
                                            {{ session()->get('message') }}
                                        </div>
                                        @endif
                                        @if(session()->has('error'))
                                        <div class="alert alert-warning alert-dismissible">
                                            <button aria-hidden="true" data-dismiss="alert" class="close" type="button">×</button>
                                            <h4><i class="icon fa fa-warning"></i> {{ trans('labels.WarningLabel') }}</h4>
                                            {{ session()->get('error') }}
                                        </div>
                                        @endif
                                   <form action="" method="GET" id="search_form">
                                        <div class="col-md-8">
                                            {{-- <strong style="color: #00c0ef;">Search By: Date Range</strong> --}}
                                        </div>
                                        <div class="col-md-4">
                                        </div>
                                        <input type="hidden" name="date_range" id="date_range" value="">
                                            <div class="col-md-12">
                                                <div class="row myFlexDiv" style="display:flex;justify-content:end; align-items: center;" >

                                        <div class="col-sm-2 col-md-2">
                                            <div class="multi-upper-cmn-bx form-control p-0">
                                                {!! Form::select('search_admin[]', $result['search_admin'], $search_admin ?? [], [
                                                    'class' => 'form-control',
                                                    'id' => 'search_admin',
                                                    'multiple' => 'multiple'
                                                ]) !!}
                                                    <div class="cmn-change-value-multi">
                                                        <span class="selected-count">
                                                            {{ is_array($search_admin ?? []) ? count($search_admin ?? []) : 0 }}
                                                        </span>
                                                        <button type="button" class="reset-btn">x</button>
                                                    </div>
                                            </div>
                                        </div>
                                    
                                                    <div class="col-sm-1 col-md-1">
                                                        <div class="input-group pull-right" style="background-color:green">
                                                            <input type="text" name="from_date" id="from_date" 
                                                                value=""
                                                                class="form-control" placeholder="Date range" autocomplete="off" style="height:35px">
                                                        </div>
                                                    </div>



                                                    {{-- <label for="dropwodn_data">Choose an option:</label>
                                                        <select id="dropwodn_data" name="dropwodn_data">
                                                        <option value="all">all</option>
                                                        <option value="guru">guru</option>
                                                        <option value="tashan">tashan</option>
                                                        <option value="boss">boss</option>
                                                    </select> --}}


                                                    <div class="row">
                                                        <div class="col-md-12" >
                                                            <div class="input-group pull-right" style="margin-left:13px">
                                                                <a class="btn btn-danger" href="{{env('APP_URL')}}/admin/whatsapp-hourly-data">Clear</a>
                                                            </div>
                                                            <div class="input-group pull-right">
                                                                <button type="submit" class="btn btn-primary" style="height:35px">Submit</button>
                                                            </div>
                                                        </div>
                                                    </div>

                                                    <input type="submit" name="csv" value="Export CSV" id="csv" class="btn btn-success" style="margin-bottom: 8px; margin-top:6px; margin-left:445px" />
                                                </div>
                                            </div>
                                        </div>
                                    </form>
                                </div>
                            </div>
       
                <div class="row" style="display: flex; justify-content: space-between;margin-bottom:32px">
                    <div class="col-xs-7 table-responsive">
<table border="1" bordercolor="teal" cellpadding="6" cellspacing="6" style="border-collapse: collapse;" class="table table-bordered table-striped">
    <thead>
        <tr>
            <th colspan="6" style="text-align: center;">
                All Products
            </th>
        </tr>
        <tr>
            <th style="width:111px; text-align:center">Time Interval</th>
            <th  style="width:111px; text-align:center">Unique Chat Count</th>
            <th  style="width:111px; text-align:center">Total Messages Received</th>
            <th  style="width:111px; text-align:center">Total Messages Sent</th>
            <th  style="width:111px; text-align:center">Sent Agent Name</th>
            <th  style="width:111px; text-align:center">Unique Chat Agent Name</th>

        </tr>
    </thead>
    <tbody>
        {{-- Loop through mergedUniqueChatsPerHour to show the unique chat counts and user names --}}
        @foreach ($mergedUniqueChatsPerHour as $timeInterval => $uniqueChatData)
            <tr>
                <td style="text-align:center">{{ $timeInterval }}</td>
                
                {{-- Display the unique chat count --}}
                <td style="text-align:center">{{ $uniqueChatData['count'] }}</td>
                
                {{-- Display total messages received for this time interval --}}
                <td style="text-align:center">
                    @if (isset($mergedReceivedMessages[$timeInterval]) && is_array($mergedReceivedMessages[$timeInterval]))
                        {{ $mergedReceivedMessages[$timeInterval]['count'] }}
                    @else
                        {{ $mergedReceivedMessages[$timeInterval] ?? 0 }}
                    @endif
                </td>

                {{-- Display total messages sent for this time interval --}}
                <td style="text-align:center">
                    @if (isset($groupedSentMessages[$timeInterval]) && is_array($groupedSentMessages[$timeInterval]))
                        {{ $groupedSentMessages[$timeInterval]['count'] }}
                    @else
                        {{ $groupedSentMessages[$timeInterval] ?? 0 }}
                    @endif
                </td>

                {{-- Display agent names (users) for sent messages --}}
                <td style="font-size: 12px; margin-right: 5px;">
                    @if (isset($groupedSentMessages[$timeInterval]) && isset($groupedSentMessages[$timeInterval]['users']))
                        {{ implode(', ', $groupedSentMessages[$timeInterval]['users']) }}
                    @else
                        'N/A'
                    @endif
                </td>

                   {{-- Show the list of unique users and their chat counts below the Unique Chat Count --}}
          
                <td  style="font-size: 12px; margin-right: 5px;">
                    @if (isset($uniqueChatData['users']) && !empty($uniqueChatData['users']))
                        {{ implode(', ', $uniqueChatData['users']) }}
                    @else
                        'N/A'
                    @endif
                </td>
            </tr>

         
         
        @endforeach

        {{-- Handle time intervals that are only in mergedReceivedMessages --}}
        @foreach ($mergedReceivedMessages as $timeInterval => $receivedData)
            @if (!isset($mergedUniqueChatsPerHour[$timeInterval]))
                <tr>
                    <td>{{ $timeInterval }}</td>
                    <td>0</td>
                    
                    {{-- Display received messages count --}}
                    <td>
                        @if (is_array($receivedData))
                            {{ $receivedData['count'] }}
                        @else
                            {{ $receivedData ?? 0 }}
                        @endif
                    </td>

                    {{-- Display sent messages count --}}
                    <td>
                        @if (isset($groupedSentMessages[$timeInterval]) && is_array($groupedSentMessages[$timeInterval]))
                            {{ $groupedSentMessages[$timeInterval]['count'] }}
                        @else
                            {{ $groupedSentMessages[$timeInterval] ?? 0 }}
                        @endif
                    </td>
                    
                    {{-- Display agent names (users) for sent messages --}}
                    <td style="font-size: 12px; margin-right: 5px;"> 
                        @if (isset($groupedSentMessages[$timeInterval]) && isset($groupedSentMessages[$timeInterval]['users']))
                            {{ implode(', ', $groupedSentMessages[$timeInterval]['users']) }}
                        @else
                            'N/A'
                        @endif
                    </td>
                </tr>
            @endif
        @endforeach

        {{-- Handle time intervals that are only in groupedSentMessages --}}
        @foreach ($groupedSentMessages as $timeInterval => $sentData)
            @if (!isset($mergedReceivedMessages[$timeInterval]) && !isset($mergedUniqueChatsPerHour[$timeInterval]))
                <tr>
                    <td>{{ $timeInterval }}</td>
                    <td>0</td>
                    <td>0</td>

                    {{-- Display sent messages count --}}
                    <td>
                        @if (is_array($sentData))
                            {{ $sentData['count'] }}
                        @else
                            {{ $sentData ?? 0 }}
                        @endif
                    </td>
                    
                    {{-- Display agent names (users) for sent messages --}}
                    <td style="font-size: 12px; margin-right: 5px;">
                        @if (isset($sentData['users']))
                            {{ implode(', ', $sentData['users']) }}
                        @else
                            'N/A'
                        @endif
                    </td>
                </tr>
            @endif
        @endforeach
    </tbody>
</table>

</div>
</div>

                <div class="row" style="display: flex; justify-content: space-between;">
                    <div class="col-xs-5 table-responsive">
                        <table border="1" bordercolor="teal" cellpadding="6" cellspacing="6" style="border-collapse: collapse;" class="table table-bordered table-striped">
                            <thead>
                                <tr>
                                    <th colspan="6" style="text-align: center;">
                                        Guru IPTV
                                    </th>
                                </tr>
                                <tr>
                                    <th>Time Interval</th>
                                    <th>Unique Chat Count</th>
                                    <th>Total Messages Received</th>
                                    <th>Total Messages Sent</th>
                                    <th>Send Agent Name</th>
                                    <th>Unique Agent Name</th>
                                </tr>
                            </thead>
                            <tbody>

                                @php
                                    // Collect and merge all unique time intervals for Guru IPTV
                                    $guruTimeIntervals = collect($uniqueChatsPerTimeInterval['guru'] ?? [])
                                        ->keys()
                                        ->merge(array_keys($finalData['guru'] ?? []))
                                        ->merge(array_keys($finalSenderData['guru'] ?? []))
                                        ->unique()
                                        ->sort()
                                        ->values();
                                @endphp

                                @foreach ($guruTimeIntervals as $timeInterval)
                                    <tr>
                                
                                        <td>{{ $timeInterval }}</td>

                                        <td>{{ $uniqueChatsPerTimeInterval['guru'][$timeInterval]['count'] ?? 0 }}</td>

                                        <td>{{ $finalData['guru'][$timeInterval] ?? 0 }}</td>
                                        <td>{{ $finalSenderData['guru'][$timeInterval][0] ?? 0 }}</td>
                                        <td>
                                            @php
                                                $raw = $finalSenderData['guru'][$timeInterval][1] ?? '';
                                                $items = $raw ? explode(',', $raw) : [];
                                            @endphp

                                            @if (!empty($items))
                                                    @foreach ($items as $item)
                                                        {{ $item }}
                                                    @endforeach
                                            @else
                                                N/A
                                            @endif
                                        </td>

                                        <td>
                                            @if (isset($uniqueChatsPerTimeInterval['guru'][$timeInterval]['users'] ))
                                                {{ implode(', ', $uniqueChatsPerTimeInterval['guru'][$timeInterval]['users'] ) }}
                                            @else
                                                'N/A'
                                            @endif
                                        </td>

                                    </tr>
                                @endforeach

                            </tbody>
                        </table>
                    </div>


                    <div class="col-xs-5 table-responsive">
                        <table border="1" bordercolor="teal" cellpadding="6" cellspacing="6" style="border-collapse: collapse;" class="table table-bordered table-striped">
                            <thead>
                                <tr>
                                    <th colspan="6" style="text-align: center;">
                                        Tashan IPTV
                                    </th>
                                </tr>
                                <tr>
                                    <th style="width:111px; text-align:center">Time Interval</th>
                                    <th style="width:111px; text-align:center">Unique Chat Count</th>
                                    <th >Total Messages Received</th>
                                    <th>Total Messages Sent</th>
                                    <th>Send Agent Name</th>
                                    <th>Unique Agent Name</th>


                                </tr>
                            </thead>
                            <tbody>

                                @php
                                    $tashanTimeIntervals = collect($uniqueChatsPerTimeInterval['tashan'] ?? [])
                                        ->keys()
                                        ->merge(array_keys($finalData['tashan'] ?? []))
                                        ->merge(array_keys($finalSenderData['tashan'] ?? []))
                                        ->unique()
                                        ->sort()
                                        ->values();
                                @endphp

                                @foreach ($tashanTimeIntervals as $timeInterval)
                                    <tr>
                                        <td>{{ $timeInterval }}</td>
                                          <td>{{ $uniqueChatsPerTimeInterval['tashan'][$timeInterval]['count'] ?? 0 }}</td>
                                        {{-- <td>{{ $uniqueChatsPerTimeInterval['tashan'][$timeInterval] ?? 0 }}</td> --}}
                                        <td>{{ $finalData['tashan'][$timeInterval] ?? 0 }}</td>
                                        <td>{{ $finalSenderData['tashan'][$timeInterval][0] ?? 0 }}</td>
                                        {{-- <td >{{ $finalSenderData['tashan'][$timeInterval][1] ?? 'N/A' }}</td> --}}
                                              <td>
                                            @php
                                                $raw = $finalSenderData['tashan'][$timeInterval][1] ?? '';
                                                $items = $raw ? explode(',', $raw) : [];
                                            @endphp

                                            @if (!empty($items))
                                                    @foreach ($items as $item)
                                                        {{ $item }}
                                                    @endforeach
                                            @else
                                                N/A
                                            @endif
                                        </td>
                                        {{-- <td>{{ $uniqueChatsPerTimeInterval['tashan'][$timeInterval]['users'] ?? 0 }}</td> --}}
                                        <td >
                                            @if (isset($uniqueChatsPerTimeInterval['tashan'][$timeInterval]['users'] ))
                                                {{ implode(', ', $uniqueChatsPerTimeInterval['tashan'][$timeInterval]['users'] ) }}
                                            @else
                                                'N/A'
                                            @endif
                                        </td>
                                    </tr>
                                @endforeach

                            </tbody>
                        </table>
                    </div>

                </div>

                <div class="row" style="display: flex; justify-content: space-between;margin-top:33px">
                    <div class="col-xs-5 table-responsive">
                        <table border="1" bordercolor="teal" cellpadding="6" cellspacing="6" style="border-collapse: collapse;" class="table table-bordered table-striped">
                            <thead>
                                <tr>
                                    <th colspan="6" style="text-align: center;">
                                        Boss IPTV
                                    </th>
                                </tr>
                                <tr>
                                    <th>Time Interval</th>
                                    <th>Unique Chat Count</th>
                                    <th>Total Messages Received</th>
                                    <th>Total Messages Sent</th>
                                    <th>Send Agent Name</th>
                                    <th>UniqueAgent Name</th>


                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($uniqueChatsPerTimeInterval['boss'] as $timeInterval => $uniqueChatCount)
                                    <tr>
                                        <td>{{ $timeInterval }}</td>
                                          <td>{{ $uniqueChatsPerTimeInterval['boss'][$timeInterval]['count'] ?? 0 }}</td>

                                        {{-- <td>{{ $uniqueChatCount }}</td> --}}
                                        <td>{{ isset($finalData['boss'][$timeInterval]) ? $finalData['boss'][$timeInterval] : 0 }}</td>
                                        <td>{{ isset($finalSenderData['boss'][$timeInterval]) ? $finalSenderData['boss'][$timeInterval][0] : 0 }}</td>
                                        {{-- <td >{{ isset($finalSenderData['boss'][$timeInterval]) ? $finalSenderData['boss'][$timeInterval][1] : 'N/A' }}</td>  --}}
                                                     <td>
                                            @php
                                                $raw = $finalSenderData['boss'][$timeInterval][1] ?? '';
                                                $items = $raw ? explode(',', $raw) : [];
                                            @endphp

                                            @if (!empty($items))
                                                    @foreach ($items as $item)
                                                        {{ $item }}
                                                    @endforeach
                                            @else
                                                N/A
                                            @endif
                                        </td>
                                        {{-- <td>{{ $uniqueChatsPerTimeInterval['boss'][$timeInterval]['users'] ?? 0 }}</td> --}}
                                          <td >
                                        @if (isset($uniqueChatsPerTimeInterval['boss'][$timeInterval]['users'] ))
                                            {{ implode(', ', $uniqueChatsPerTimeInterval['boss'][$timeInterval]['users'] ) }}
                                        @else
                                            'N/A'
                                        @endif
                                         </td>
                                    
                                    </tr>
                                @endforeach

                                @foreach ($finalData['boss'] as $timeInterval => $sentCount)
                                    @if (!isset($uniqueChatsPerTimeInterval['boss'][$timeInterval]))
                                        <tr>
                                            <td>{{ $timeInterval }}</td>
                                            <td>0</td> 
                                            <td>{{ $sentCount }}</td>
                                            <td>{{ isset($finalSenderData['boss'][$timeInterval]) ? $finalSenderData['boss'][$timeInterval][0] : 0 }}</td>
                                            <td style="font-size: 12px; margin-right: 5px;">{{ isset($finalSenderData['boss'][$timeInterval]) ? $finalSenderData['boss'][$timeInterval][1] : 'N/A' }}</td> 
                                                <td>0</td> 

                                        </tr>
                                    @endif
                                @endforeach

                                @foreach ($finalSenderData['boss'] as $timeInterval => $receivedCount)
                                    @if (!isset($finalData['boss'][$timeInterval]) && !isset($uniqueChatsPerTimeInterval['boss'][$timeInterval]))
                                        <tr>
                                            <td>{{ $timeInterval }}</td>
                                            <td>0</td> 
                                            <td>0</td> 
                                        <td>{{ isset($finalSenderData['boss'][$timeInterval]) ? $finalSenderData['boss'][$timeInterval][0] : 0 }}</td>
                                        <td style="font-size: 12px; margin-right: 5px;">{{ isset($finalSenderData['boss'][$timeInterval]) ? $finalSenderData['boss'][$timeInterval][1] : 'N/A' }}</td> 
                                                <td>0</td> 
                                      
                                        </tr>
                                    @endif
                                @endforeach
                            </tbody>
                        </table>
                    </div>

                    <div class="col-xs-5 table-responsive">
                        <table border="1" bordercolor="teal" cellpadding="6" cellspacing="6" style="border-collapse: collapse;" class="table table-bordered table-striped">
                            <thead>
                                <tr>
                                    <th colspan="6" style="text-align: center;">
                                        Vois IPTV
                                    </th>
                                </tr>
                                <tr>
                                    <th>Time Interval</th>
                                    <th>Unique Chat Count</th>
                                    <th>Total Messages Received</th>
                                    <th>Total Messages Sent</th>
                                    <th>Send Agent Name</th>
                                    <th>UniqueAgent Name</th>


                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $voiceTimeIntervals = collect($uniqueChatsPerTimeInterval['voice'] ?? [])
                                        ->keys()
                                        ->merge(array_keys($finalData['voice'] ?? []))
                                        ->merge(array_keys($finalSenderData['voice'] ?? []))
                                        ->unique()
                                        ->sort()
                                        ->values();
                                @endphp
                                @foreach ($voiceTimeIntervals as $timeInterval)
                                    <tr>
                                        <td>{{ $timeInterval }}</td>
                                          <td>{{ $uniqueChatsPerTimeInterval['voice'][$timeInterval]['count'] ?? 0 }}</td>

                                        {{-- <td>{{ $uniqueChatsPerTimeInterval['voice'][$timeInterval] ?? 0 }}</td> --}}
                                        <td>{{ $finalData['voice'][$timeInterval] ?? 0 }}</td>
                                       <td>{{ $finalSenderData['voice'][$timeInterval][0] ?? 0 }}</td>
                                        {{-- <td style="font-size: 12px; margin-right: 5px;">{{ $finalSenderData['voice'][$timeInterval][1] ?? 'N/A' }}</td> --}}
                                                            <td>
                                            @php
                                                $raw = $finalSenderData['voice'][$timeInterval][1] ?? '';
                                                $items = $raw ? explode(',', $raw) : [];
                                            @endphp

                                            @if (!empty($items))
                                                    @foreach ($items as $item)
                                                        {{ $item }}
                                                    @endforeach
                                            @else
                                                N/A
                                            @endif
                                        </td>
                                        {{-- <td>{{ $uniqueChatsPerTimeInterval['voice'][$timeInterval]['users'] ?? 0 }}</td> --}}
                                             <td >
                                        @if (isset($uniqueChatsPerTimeInterval['voice'][$timeInterval]['users'] ))
                                            {{ implode(', ', $uniqueChatsPerTimeInterval['voice'][$timeInterval]['users'] ) }}
                                        @else
                                            'N/A'
                                        @endif
                                         </td>

                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>

                <div class="row" style="display: flex; justify-content: space-between;margin-top:33px">
                    <div class="col-xs-5 table-responsive">
                        <table border="1" bordercolor="teal" cellpadding="6" cellspacing="6" style="border-collapse: collapse;" class="table table-bordered table-striped">
                            <thead>
                                <tr>
                                    <th colspan="6" style="text-align: center;">
                                        Brampton IPTV
                                    </th>
                                </tr>
                                <tr>
                                    <th>Time Interval</th>
                                    <th>Unique Chat Count</th>
                                    <th>Total Messages Received</th>
                                    <th>Total Messages Sent</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach ($uniqueChatsPerTimeInterval['brampton'] as $timeInterval => $uniqueChatCount)
                                    <tr>
                                        <td>{{ $timeInterval }}</td>
                                        <td>{{ $uniqueChatCount }}</td>
                                        <td>{{ isset($finalData['brampton'][$timeInterval]) ? $finalData['brampton'][$timeInterval] : 0 }}</td>
                                        <td>{{ isset($finalSenderData['brampton'][$timeInterval]) ? $finalSenderData['brampton'][$timeInterval][0] : 0 }}</td>
                                        {{-- <td >{{ isset($finalSenderData['brampton'][$timeInterval]) ? $finalSenderData['brampton'][$timeInterval][1] : 'N/A' }}</td>  --}}
                                              <td>
                                            @php
                                                $raw = $finalSenderData['brampton'][$timeInterval][1] ?? '';
                                                $items = $raw ? explode(',', $raw) : [];
                                            @endphp

                                            @if (!empty($items))
                                                    @foreach ($items as $item)
                                                        {{ $item }}
                                                    @endforeach
                                            @else
                                                N/A
                                            @endif
                                        </td>
                                    </tr>
                                @endforeach

                                @foreach ($finalData['brampton'] as $timeInterval => $sentCount)
                                    @if (!isset($uniqueChatsPerTimeInterval['brampton'][$timeInterval]))
                                        <tr>
                                            <td>{{ $timeInterval }}</td>
                                            <td>0</td> 
                                            <td>{{ $sentCount }}</td>
                                        <td>{{ isset($finalSenderData['brampton'][$timeInterval]) ? $finalSenderData['brampton'][$timeInterval][0] : 0 }}</td>
                                        <td >{{ isset($finalSenderData['brampton'][$timeInterval]) ? $finalSenderData['brampton'][$timeInterval][1] : 'N/A' }}</td> 
                                        </tr>
                                    @endif
                                @endforeach

                                @foreach ($finalSenderData['brampton'] as $timeInterval => $receivedCount)
                                    @if (!isset($finalData['brampton'][$timeInterval]) && !isset($uniqueChatsPerTimeInterval['brampton'][$timeInterval]))
                                        <tr>
                                            <td>{{ $timeInterval }}</td>
                                            <td>0</td> 
                                            <td>0</td> 
                                        <td>{{ isset($finalSenderData['brampton'][$timeInterval]) ? $finalSenderData['brampton'][$timeInterval][0] : 0 }}</td>
                                        <td >{{ isset($finalSenderData['brampton'][$timeInterval]) ? $finalSenderData['brampton'][$timeInterval][1] : 'N/A' }}</td> 
                                        
                                        </tr>
                                    @endif
                                @endforeach
                            </tbody>
                        </table>
                    </div>

                    <div class="col-xs-5 table-responsive">
                        <table border="1" bordercolor="teal" cellpadding="6" cellspacing="6" style="border-collapse: collapse;" class="table table-bordered table-striped">
                            <thead>
                                <tr>
                                    <th colspan="6" style="text-align: center;">
                                        Indian IPTV
                                    </th>
                                </tr>
                                <tr>
                                    <th>Time Interval</th>
                                    <th>Unique Chat Count</th>
                                    <th>Total Messages Received</th>
                                    <th>Total Messages Sent</th>
                                    <th>Send message agent name</th>
                                    <th>Unique message agent name</th>


                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $indianTimeIntervals = collect($uniqueChatsPerTimeInterval['indian'] ?? [])
                                        ->keys()
                                        ->merge(array_keys($finalData['indian'] ?? []))
                                        ->merge(array_keys($finalSenderData['indian'] ?? []))
                                        ->unique()
                                        ->sort()
                                        ->values();
                                @endphp
                                @foreach ($indianTimeIntervals as $timeInterval)

                               
                                    <tr>
                                        <td>{{ $timeInterval }}</td>
                                          <td>{{ $uniqueChatsPerTimeInterval['indian'][$timeInterval]['count'] ?? 0 }}</td>
{{-- @dd($finalSenderData['indian']); --}}
                                        {{-- <td>{{ $uniqueChatsPerTimeInterval['indian'][$timeInterval] ?? 0 }}</td> --}}
                                        <td>{{ $finalData['indian'][$timeInterval] ?? 0 }}</td>
                                        <td>{{ $finalSenderData['indian'][$timeInterval][0] ?? 0 }}</td>
                                        {{-- <td >{{ $finalSenderData['indian'][$timeInterval][1] ?? 'N/A' }}</td> --}}
                                        <td>
                                            @php
                                                $raw = $finalSenderData['indian'][$timeInterval][1] ?? '';
                                                $items = $raw ? explode(',', $raw) : [];
                                            @endphp

                                            @if (!empty($items))
                                                    @foreach ($items as $item)
                                                        {{ $item }}
                                                    @endforeach
                                            @else
                                                N/A
                                            @endif
                                        </td>
                                        
                                        <td >
                                        @if (isset($uniqueChatsPerTimeInterval['indian'][$timeInterval]['users'] ))
                                            {{ implode(', ', $uniqueChatsPerTimeInterval['indian'][$timeInterval]['users'] ) }}
                                        @else               
                                            'N/A'
                                        @endif
                                         </td>
                                    </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
         
                </div>
            </div>
        </section> 
    </div>
</div>
<script>
    function reloadPage(){
        window.location.href='http://callcrm833-naveen.local:8080/admin/whatsapp-reporting';
    }

    function submitSearchForm() {
        $('.fullLoader').show();
        $('#search_form').submit();
    }

    function fetch_data(page) {
        $('#error_search_text').hide();
        $('.fullLoader').show();
        var startDate = $('#date_range').val();
        $.ajax({
            url: '{{URL("admin/getWhasappReporting")}}',
            type: "POST",
            //async: false,		                   
            data: {'from_date': startDate},
            success: function (data) {
                $('tbody.opp').html('');
                $('.currentDate').html('');
                $('.todayTotalLeads').html('');
                $('.todayTotalOpp').html('');
                $('.currentDate').html(data.currentDate);
                $('.todayTotalLeads').html(data.todayTotalLeads);
                $('.todayTotalOpp').html(data.todayTotalOpp);
                $('tbody.opp').html(data.data);
                //$('.pagination-result').html(data.pagination_val);
                setTimeout(function () {
                    $('.fullLoader').hide();
                }, 300)
            }
        });
    }


    $(function () {
        $('#from_date').daterangepicker({
            opens: 'left',
            locale: {cancelLabel: 'Clear'},
            //autoUpdateInput: false,
            //startDate: moment().subtract('days', 29),
            startDate: moment().subtract(1, 'month').startOf('month'),
            endDate: moment(),
            ranges: {
                'Today': [moment(), moment()],
                'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                'Last 7 Days': [moment().subtract(6, 'days'), moment()],
                'Last 30 Days': [moment().subtract(29, 'days'), moment()],
                'This Month': [moment().startOf('month'), moment().endOf('month')],
                'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
            }
        },
                function (start, end, label) {
                    console.log("A new date selection was made: " + start.format('YYYY-MM-DD') + ' to ' + end.format('YYYY-MM-DD'));
                });
        $('#from_date').on('apply.daterangepicker', function (ev, picker) {
            //console.log(picker.startDate.format('YYYY-MM-DD'));
            //console.log(picker.endDate.format('YYYY-MM-DD'));
            var startDate = picker.startDate.format('YYYY-MM-DD') + '/' + picker.endDate.format('YYYY-MM-DD');
            $('#date_range').val(startDate);
            //console.log(startDate);
            //return false;
            var page = '';
            //fetch_data(page);
            // submitSearchForm();
        });
        $('#from_date').on('apply.daterangepicker', function (ev, picker) {
            $(this).val(picker.startDate.format('DD/MM/YYYY') + ' - ' + picker.endDate.format('DD/MM/YYYY'));
        });
        $('#from_date').on('cancel.daterangepicker', function (ev, picker) {
            //do something, like clearing an input
            $('#date_range').val('');
            $('#from_date').val('');
            var page = '';
            //fetch_data(page);
            // submitSearchForm();
        });
    });
</script>

<script>
    document.querySelectorAll('#watermarked').forEach(function (el) {
        el.dataset.watermark = (el.dataset.watermark + ' ').repeat(500);
    });
</script>

<script type="text/javascript"> 
    $(function () { 
        $("#search_admin").select2({
                closeOnSelect: false,
                placeholder: 'Select Agent',
            }).on("select2:select", function (e) {
                var selected_element = $(e.currentTarget);
                var selected_state = selected_element.val(); // Get the selected state

                // You can use selected_state for any further processing (like form submission, etc.)
                // If you want to reset the page when selecting a state, you can do so here:
                $('#hidden_page').val('1'); // Reset page if needed
                
                // Optional: Trigger form submission if needed
                // submitSearchForm();
            }).on('select2:unselect', function (e) {
                var selected_element = $(e.currentTarget);
                var selected_state = selected_element.val(); // Get the selected state (null when unselected)

                // If you need to perform any action when a state is unselected, do it here
                $('#hidden_page').val('1'); // Reset page if needed
            });

    });
</script>