@extends('layouts.layout')

@section('body_class', 'nav-md')

@section('body_content')
<div class="container body">
    <div class="main_container">
        @include('includes.sidebar')
        <div class="right_col" role="main">
            <div class="page-title">
                <div class="title_left">
                    <h3>Review Feedback Sales</h3>
                </div>
                <div class="clearfix"></div>
            </div>

            <div class="row">
                <div class="col-xs-12">
                    <ol class="breadcrumb">
                        <li><a href="{{ route('dashboard') }}">Home</a></li>
                        <li><a href="{{ route('report_tukar_fisik') }}">Report Tukar Fisik</a></li>
                    </ol>
                </div>
            </div>

            <div class="row">
                <div class="col-xs-12 col-sm-6">
                    <div class="x_panel">
                        <div class="x_title">
                            Filter
                        </div>
                        <div class="x_content">
                            <form id="form-search" class="form-horizontal">
                                <div class="col-xs-12 col-sm-12">
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-4 control-label">Tanggal Mulai :</label>
                                        <div class="col-xs-6 col-sm-4">
                                            <input name="date_start" type="date" class="form-control" placeholder="Start date" value="{{ $request['date_start'] ? : date('Y-m-01', strtotime('-2 months')) }}">
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-4 control-label">Tanggal Selesai :</label>
                                        <div class="col-xs-6 col-sm-4">
                                            <input name="date_end" type="date" class="form-control" placeholder="Start date" value="{{ $request['date_end'] ? : date('Y-m-d') }}">
                                        </div>
                                    </div>
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-4 control-label">Rating:</label>
                                        <div class="col-xs-6 col-sm-4">
                                                <select name="rating" id="rating" class="form-control">
                                                    <option value="">-- Pilih Rating --</option>
                                                    <option value="5" {{ request('rating') == 5 ? 'selected' : '' }}>-- 5 --</option>
                                                    <option value="4" {{ request('rating') == 4 ? 'selected' : '' }}>-- 4 --</option>
                                                    <option value="3" {{ request('rating') == 3 ? 'selected' : '' }}>-- 3 --</option>
                                                    <option value="2" {{ request('rating') == 2 ? 'selected' : '' }}>-- 2 --</option>
                                                    <option value="1" {{ request('rating') == 1 ? 'selected' : '' }}>-- 1 --</option>
                                                </select>
                                            </select>
                                        </div>
                                    </div> 
                                    <div class="form-group">
                                        <label class="col-xs-12 col-sm-4 control-label">Search :</label>
                                        <div class="col-xs-6 col-sm-4">
                                            <input name="search" class="form-control">
                                        </div>
                                    </div> 
                                    <div class="form-group" style="margin-top:20px">
                                        <label class="col-xs-12 col-sm-5 control-label"></label>
                                        <div class="col-xs-12 col-sm-7">
                                            <button type="submit" class="btn btn-primary btn-search"><i class="fa fa-search"></i> Search</button>
                                            {{-- <button type="button" class="btn btn-warning" id="reset_btn"><i class="fa fa-trash"></i> Reset</button> --}}
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                    
                </div>

                <div class="col-xs-12 col-sm-6">
                    <div class="row">
                        <div class="col-sm-12">
                            <div class="x_panel" style="zoom: 0.9; overflow: auto;">
                                <div class="x_title" id="summary_pecahan">
                                    <table class="table table-bordered table-striped">
                                        <thead>
                                            <tr>
                                                <th class="text-center">Rating</th>
                                                <th class="text-center">Total</th>
                                                <th class="text-center">Store Review</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $group = collect($reviews)->groupBy('bintang');
                                                $rating_desc = [5, 4, 3, 2, 1, 0];
                                            @endphp
                                            @foreach ($rating_desc as $no_rating)
                                                @if($group->has($no_rating))
                                                        @php $r = $group[$no_rating]; $first = true;
                                                        $uniqueCustomerCount = $r->unique('customer_id')->count();
                                                        @endphp
                                                         @foreach ($r as $data)
                                                    <tr>
                                                        @if ($first)
                                                            <td class="text-center" rowspan="{{ count($r) }}">{{ $no_rating }}</td>
                                                                @php $first = false;
                                                                @endphp
                                                            <td class="text-center">{{ count($r) }}</td>
                                                            <td class="text-center" rowspan="{{ count($r) }}">{{ $uniqueCustomerCount }}</td>
                                                            @php $first = false;
                                                            @endphp
                                                        @endif
                                                    </tr>
                                                    @endforeach
                                                @endif
                                            @endforeach
                                        </tbody>                       
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="row">
                <div class="col-xs-12">
                    <div class="table-responsive">
                        <div class="x_panel">
                           
                            <div class="x_content" style="zoom: 0.9; overflow: auto;">
                                <table class="table table-bordered table-striped" id="myTable">
                                    <thead>
                                        <tr>
                                            <th class="text-center">No</th>
                                            <th class="text-center">Date / Time</th>
                                            <th class="text-center">Customer Code</th>
                                            <th class="text-center">Customer</th>
                                            <th class="text-center">Nomor Transaksi</th>
                                            <th class="text-center">Rating</th>
                                            <th class="text-center">Store Reviews</th>
                                            <th class="text-center">Feedback</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @forelse ($reviews as $data)
                                            <tr>
                                                <td class="text-center">{{ $reviews->firstItem() + $loop->index }}</td>
                                                <td class="text-center"> {{  $data->created_at->format('H:i:s') }}
                                                    <br><small>{{  $data->created_at->format('d-m-Y')}}</small></br>
                                                </td>
                                                <td class="text-center">{{ $data->customer->code }}
                                                </td>
                                                 <td class="text-center">{{ $data->customer->name }}
                                                    <br><small>{{ $data->customer->created_at->format('d-m-Y') }}</small></br>
                                                </td>
                                                <td class="text-center">{{ $data->is_customer_elite ? 'Elite' : 'Reguler' }}
                                                    <br><small>{{ $data->transaksi->code }} </small></br>
                                                </td>
                                                <td class="text-center">{{ $data->bintang }}
                                                </td>
                                                <td class="text-center">
                                                    @if($data->bintang > 4)
                                                        Y
                                                    @else
                                                        N
                                                    @endif
                                                </td>
                                                <td class="text-center">
                                                    @if (!empty($data->komen))
                                                        <a href="#" 
                                                        class="show-modal" 
                                                        data-komen="{{ $data->komen }}"
                                                        data-id="{{ $data->id }}"
                                                        data-code="{{ $data->customer->code }}"
                                                        data-register="{{ $data->customer->created_at->format('d-m-Y') }}"
                                                        data-rating="{{ $data->bintang }}"
                                                        data-review ="@if($data->bintang > 4)
                                                                        Y
                                                                    @else
                                                                        N
                                                                    @endif"
                                                        data-feedback="{{ $data->komen }}">
                                                            {{ explode(' ', $data->komen)[0] }}
                                                        </a>
                                                    @else
                                                        -
                                                    @endif
                                                </td>
                                            </tr>
                                        @empty
                                            <tr>
                                                <td colspan="7" class="text-center">Tidak ada data</td>
                                            </tr>
                                        @endforelse
                                          
                                    </tbody>
                                   
                                </table>
                                {{ $reviews->links() }}

                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Modal -->
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="myModalLabel"></h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Tutup">
        </button>
      </div>
      <div class="modal-body" id="modal-body">
         <p>Customer Code <span id="modal-customer-code"></span></p>
         <p>Register Date <span id="modal-customer-register"></span></p>
         <p>Rating <span id="modal-customer-rating"></span></p>
         <p>Review <span id="modal-customer-review"></span></p>
         <hr>
         <p>Feedback <br><span id="modal-customer-feedback"></span></br></p>
        
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Tutup</button>
      </div>
    </div>
  </div>
</div>


@endsection


<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.7/css/jquery.dataTables.css" />
  
<script src="https://cdn.datatables.net/1.13.7/js/jquery.dataTables.js"></script>

<script>
    $(document).ready(function () {
        $('.show-modal').on('click', function (e) {
            e.preventDefault();

            let komen = $(this).data('komen');
            let code = $(this).data('code');
            let register = $(this).data('register');
            let rating = $(this).data('rating');
            let review = $(this).data('review');
            let feedback = $(this).data('feedback');

            $('#modal-komen-body').text(komen);
            $('#modal-customer-code').text(code);
            $('#modal-customer-register').text(register);
            $('#modal-customer-rating').text(rating);
            $('#modal-customer-review').text(review);
            $('#modal-customer-feedback').text(feedback);

            $('#myModal').modal('show');
        });
    });
</script>