@extends('admin.layout')
@section('content')

<style>
    .btn-base-info{
        background: #FFF;
        border: 1px solid #CCC;
        padding: 0.7rem 1.5rem;
        border-radius: 6px;
        margin-right: 0.5rem;
    }
    .btn-base-info-active{
        background: #f2f2f2;
        color: #000;
    }
    .link-wrapper-laravel .slick-prev, .link-wrapper-core .slick-prev{
        left: 0px;
        z-index: 2;
        opacity: 0.2;
        -webkit-transition: all 0.4s ease;
        -ms-transition: all 0.4s ease;
        -o-transition: all 0.4s ease;
        transition: all 0.4s ease;
    }
    .link-wrapper-laravel .slick-next, .link-wrapper-core .slick-next{
        right: 0px;
        z-index: 2;
        opacity: 0.2;
        -webkit-transition: all 0.4s ease;
        -ms-transition: all 0.4s ease;
        -o-transition: all 0.4s ease;
        transition: all 0.4s ease;
    }    
    .link-wrapper-laravel .slick-prev:before,
    .link-wrapper-laravel .slick-next:before,
    .link-wrapper-core .slick-prev:before,
    .link-wrapper-core .slick-next:before{
        color: #000;
    }
    .link-wrapper-laravel:hover .slick-prev, .link-wrapper-core:hover .slick-prev,
    .link-wrapper-laravel:hover .slick-next, .link-wrapper-core:hover .slick-next{
        opacity: 1;
    }
</style>

<div class="content-wrapper"> 
  <!-- Content Header (Page header) -->
  <section class="content-header">
  <h1>
    {{ trans('3CX Duplicate Data') }}
    <small class="pagination-result">

    </small>
</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('3CX Duplicate Data') }}</li>
    </ol>
  </section>
  
  
    
    <section class="inter-links-wrapper content-header">
        <div class="row">
            <div class="col-md-12">
                <div class="inter-links-inner link-wrapper-laravel">
                    <div class=""><a href="{{ URL::to('admin/3cx-report')}}" class="btn btn-base-info">CSR Data</a></div>
                    <div class=""><a href="{{ URL::to('admin/3cx-hourly-report')}}" class="btn btn-base-info">CSR Hourly Data</a></div>
                    <div class=""><a href="{{ URL::to('admin/3cx-sale-report')}}" class="btn btn-base-info">Sale Report</a></div>
                    <div class=""><a href="{{ URL::to('admin/3cx-csr-data-report')}}" class="btn btn-base-info">CSR Dashboard</a></div>
                    <div class=""><a href="{{ URL::to('admin/3cx-tl-report')}}" class="btn btn-base-info">CSR TL Report</a></div>
                    <div class=""><a href="{{ URL::to('admin/3cx-dashboard-report')}}" class="btn btn-base-info">Time Gap Report</a></div>
                    <div class=""><a href="{{ URL::to('admin/3cx-date-hour-report')}}" class="btn btn-base-info">Date Hour TT Report</a></div>
                    <div class=""><a href="{{ URL::to('admin/3cx-repeat-call-report')}}" class="btn btn-base-info">Repeat Calls Data</a></div>
                    <div class=""><a href="{{ URL::to('admin/3cx-hourly-total-data')}}" class="btn btn-base-info">Hourly Total Data</a></div>
                    <div class=""><a href="{{ URL::to('admin/3cx-duplicate-report')}}" class="btn btn-base-info btn-base-info-active">Duplicate Calls Data</a></div>
                    <div class=""><a href="{{ URL::to('admin/3cx-avg-call-report')}}" class="btn btn-base-info">Avg Ans Time</a></div>
                    <div class=""><a href="{{ URL::to('admin/3cx-avg-tt-report?dropdown_data=IBC+Talk+Time')}}" class="btn btn-base-info">Avg Talk Time</a></div>
                    <div class=""><a href="{{ URL::to('admin/3cx-abandoned-report')}}" class="btn btn-base-info">Abandoned Report</a></div>

                </div>
            </div>
        </div>
    </section>
    
    <!--    <section class="inter-links-wrapper content-header">-->
    <!--    <div class="row">-->
    <!--        <div class="col-md-12">-->
    <!--            <div class="inter-links-inner">-->
    <!--                <a href="{{ URL::to('admin/3cx-report')}}" class="btn btn-base-info">CSR Data</a>-->
    <!--                <a href="{{ URL::to('admin/3cx-hourly-report')}}" class="btn btn-base-info">CSR Hourly Data</a>-->
    <!--                <a href="{{ URL::to('admin/3cx-sale-report')}}" class="btn btn-base-info">Sale Report</a>-->
    <!--                <a href="{{ URL::to('admin/3cx-csr-data-report')}}" class="btn btn-base-info">CSR Dashboard</a>-->
    <!--                <a href="{{ URL::to('admin/3cx-tl-report')}}" class="btn btn-base-info">CSR TL Report</a>-->
    <!--                <a href="{{ URL::to('admin/3cx-dashboard-report')}}" class="btn btn-base-info">Time Gap Report</a>-->
    <!--                <a href="{{ URL::to('admin/3cx-date-hour-report')}}" class="btn btn-base-info">Date Hour TT Report</a>-->
    <!--                <a href="{{ URL::to('admin/3cx-repeat-call-report')}}" class="btn btn-base-info">Repeat Calls Data</a>-->
    <!--                <a href="{{ URL::to('admin/3cx-hourly-total-data')}}" class="btn btn-base-info">Hourly Total Data</a>-->
    <!--                <a href="{{ URL::to('admin/3cx-duplicate-report')}}" class="btn btn-base-info btn-base-info-active">Duplicate Calls Data</a>-->
    <!--                <a href="{{ URL::to('admin/3cx-avg-call-report')}}" class="btn btn-base-info">Avg Ans Time</a>-->

    <!--            </div>-->
    <!--        </div>-->
    <!--    </div>-->
    <!--</section>-->
    
  
  <!-- Main content -->
  <section class="content"> 
    <!-- Info boxes --> 
    <!-- /.row -->
    <div class="row">
      <div class="col-md-12">
        <div class="box">
          <div class="box-header">
            <h3 class="box-title">{{ trans('3CX Duplicate Data') }}</h3>
          </div>
          
          <!-- /.box-header -->
          <div class="box-body">
            <div class="row">
              <div class="col-xs-12">
                @if (count($errors) > 0)
                  @if($errors->any())
                    <div class="alert alert-success alert-dismissible" role="alert">
                      <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                      {{$errors->first()}}
                    </div>
                  @endif
                @endif
              </div>
            </div>

            
            <div class="box-header" >
              <form id="search_chat_number" name="search_chat_number" method="GET" action="{{ route('3cx-duplicate-report') }}" >

              <input type="hidden" name="order_by" id="order_by">
              <input type="hidden" name="order_type" id="order_type">

                   <div class="col-sm-2 col-md-2" style="margin-left:169px">
                      <div class="multi-upper-cmn-bx form-control p-0">
                          {!! Form::select('search_tl[]', $result['search_tl'], $search_tl ?? [], [
                              'class' => 'form-control',
                              'id' => 'search_tl',
                              'multiple' => 'multiple'
                          ]) !!}
                          <div class="cmn-change-value-multi">
                              <span class="selected-count">
                                  {{ is_array($search_tl ?? []) ? count($search_tl ?? []) : 0 }}
                              </span>
                              <button type="button" class="reset-btn">x</button>
                          </div>
                      </div>
                  </div>

                    <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">
                      <input type="text" name="from_date" id="from_date" value="{{ $from_date }}" class="form-control" placeholder="Date range" readonly="" autocomplete="off">
                  </div>

                <button type="submit" class="btn btn-success" name="submit_search" id="submit_search">Search</button>
                <a href="{{ URL::to('admin/3cx-duplicate-report')}}" class="btn btn-danger">{{ trans('labels.ClearSearch') }}</a>
                <input type="submit" name="csv" value="Export CSV" id="csv" class="btn btn-success" />
                
              </form>

            </div>

            <div class="row">
              <div class="col-xs-12">
                  
        @php
            $frequencyHeaders = [];
        
            foreach ($dateWiseReport as $row) {
                foreach ($row as $key => $val) {
                    if (Str::endsWith($key, 'Times')) {
                        $num = intval($key); // extract numeric part
                        $frequencyHeaders[$num] = $key; // use numeric key
                    }
                }
            }
        
            // Sort by numeric key descending
            krsort($frequencyHeaders); 
        @endphp



        <div class="row" style="overflow:auto">
            <table class="table table-bordered">
                <thead>
                <tr>
                    <th style="text-align:center">TL Name</th>
                    <th style="text-align:center">Agent Name</th>
                    <th style="text-align:center">Total Calls</th>
            
                    @foreach ($frequencyHeaders as $header)
                        <th style="text-align:center">{{ $header }}</th>
                    @endforeach
            
                    <th style="text-align:center">Total Calls Time</th>
                    <!--<th style="text-align:center">Date Range</th>-->
                </tr>
            </thead>
            
            <tbody>
                @foreach ($dateWiseReport as $row)
                    <tr>
                        <td style="text-align:center">{{ $row['TLName'] }}</td>
                        <td style="text-align:center">{{ $row['UserName'] }}</td>
                        <td style="text-align:center">{{ $row['TotalCall'] }}</td>
            
                        @foreach ($frequencyHeaders as $header)
                            @php
                                $time = intval($header); // e.g., "6 Times" -> 6
                                $count = $row[$header] ?? 0;
                            @endphp
                            <td style="text-align:center">
                                @if ($count > 0)
                                    <a href="{{ url('admin/3cx-duplicate-detail-report?date=' . urlencode($row['date']) . '&time=' . $time . '&id=' . $row['userId']) }}">
                                        {{ $count }}
                                    </a>
                                @else
                                    {{ $count }}
                                @endif
                            </td>
                        @endforeach

            
                        <td style="text-align:center">{{ $row['totalTimeCall'] }}</td>
                        <!--<td style="text-align:center">{{ $row['date'] }}</td>-->
                    </tr>
                @endforeach
            </tbody>
            
            </table>
        </div>

        
           
              </div>
            </div>
          </div>
          <!-- /.box-body --> 
        </div>
      </div>
    </div>
    <!-- /.row -->
  </section>
  <!-- /.content -->
</div>
<!-- /.content-wrapper -->

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script type="text/javascript" src="//cdn.jsdelivr.net/npm/slick-carousel@1.8.1/slick/slick.min.js"></script>
<script>

    $('.link-wrapper-laravel').slick({
      slidesToShow: 7,
      slidesToScroll: 1,
      loop: false,
      dots: false,
      arrows: true,
      variableWidth: true,
      swipeToSlide: true,
      infinite: true
    });
</script>
<script>

    function sortFilter(order_by, order_type) {
      console.log( order_by, order_type);
    $("#order_by").val(order_by);
    $("#order_type").val(order_type);
    $("#search_chat_number").submit();
}

    $( 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);
            $('#date_day_filter').submit();
        });
        $('#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);
            $('#date_day_filter').submit();
        });
    });
</script>

<script type="text/javascript"> 
    $(function () { 
        $("#search_admin").select2({
                closeOnSelect: false,
                placeholder: 'Select Agent Name',
            }).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
            });

            $("#search_tl").select2({
                closeOnSelect: false,
                placeholder: 'Select TL Name',
            }).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>

@endsection