@extends('admin.layout.master')
@section('dashboard','active')
@section('contant')
@php use Carbon\Carbon; @endphp
    <div class="content-body">
        <!-- Accuracy Score -->
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-header">
                        <div class="row">
                            <div class="col-md-6">
                                <h4 class="card-title">Accuracy Score (All Users)</h4>
                            </div>
                            <div class="col-md-3">
                                <form action="{{route('admin.chartfilter')}}" id="filterForm" method="post">
                                    @csrf
                                <select id="projectinput5" onchange="$('#filterForm').submit()" name="days" class="form-control border-info">
                                    <option value="none">Select</option>
                                    <option value="10">Last 30 Days</option>
                                    <option value="4">Last 15 Days</option>
                                </select>
                            </form>
                            </div>
                            <div class="col-md-1">
                                <div class="badge badge-info w-100 h-100 d-flex justify-content-center align-items-center">
                   @php  
                        if(!empty($all_problems) && $all_problems->where('status','!=','pending')->where('is_training','=',0)->count()>0) {
                            $Accuracy = number_format($all_problems->where('status','correct')->count()  * 100/$all_problems->where('status','!=','pending')->where('is_training','=',0)->count(),2);
                        }else{
                            $Accuracy=0;
                        }  
                   @endphp

                   {{$Accuracy.'%'}}
                                </div>
                            </div>
                        </div>
                        <a class="heading-elements-toggle"><i class="la la-ellipsis-v font-medium-3"></i></a>
                        <div class="heading-elements">
                            <ul class="list-inline mb-0">
                                <li><a data-action="collapse"><i class="ft-minus"></i></a></li>
                                <li><a data-action="reload"><i class="ft-rotate-cw"></i></a></li>
                                <li><a data-action="expand"><i class="ft-maximize"></i></a></li>
                                <li><a data-action="close"><i class="ft-x"></i></a></li>
                            </ul>
                        </div>
                    </div>
                    
                  
                    <div class="card-content collapse show">
                        <div class="card-body chartjs">
                            <canvas id="area-chart" height="500"></canvas>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <div class="row mb-2">
            <div class="col-md-3">
                <h4 class="d-inline font-weight-bold">Average Scores</h4>
                <div class="badge badge-info">
                    {{$mcqsAvg}}
                </div>
            </div>
            <div class="offset-md-2 col-md-3">
                <h4 class="d-inline">Total Scores</h4>
                <div class="badge badge-info">
                    {{$mcqsSum}}
                </div>
            </div>
            {{-- <div class="offset-md-1 col-md-3">
                <h4 class="d-inline">Answers</h4>
                <div class="badge badge-info">
                    {{ $all_problems->count() }}
                </div>
            </div> --}}
        </div>
        <!-- Area Chart -->
        {{-- User --}}
        <section class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-head">
                        <div class="card-header">
                            <div class="row">
                                <div class="col-md-2">
                                    <h4 class="card-title">Users</h4>
                                </div>
                                <div class="col-md-1">
                                    <div
                                        class="badge badge-info w-100 h-100 d-flex justify-content-center align-items-center">
                                        {{$users->count()}}
                                    </div>
                                </div>
                            </div>
                            <a class="heading-elements-toggle"><i class="la la-ellipsis-h font-medium-3"></i></a>
                            <div class="heading-elements">
                                <a href="{{route('admin.user.create')}}" class="btn btn-info text-white btn-sm" type="button"><i
                                        class="ft-user-plus white"></i></a>
                            </div>
                        </div>
                    </div>
                    <div class="card-content">
                        <div class="card-body">
                            <!-- Task List table -->
                            <div class="table-responsive">
                                <table id="users-contacts"
                                    class="table table-white-space table-bordered row-grouping display no-wrap icheck table-middle">
                                    <thead>
                                        <tr>
                                            <th>Tittle</th>
                                            <th>#Votes</th>
                                            <th>Accuracy</th>
                                            <th>Level</th>
                                            <th>Edit</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @if(!empty($users))
                                            @foreach($users as $user_val)
                                                <tr>
                                                    {{-- <td>
                                                        <input type="checkbox" class="input-chk">
                                                    </td> --}}
                                                    <td class="font-weight-bold text-info">
                                                        {{$user_val->name}}
                                                    </td>
                                                    <td>
                                                        {{$user_val->problemResult->where('status','!=','pending')->where('is_training','=',0)->count()}}
                                                    </td>
                                                    <td>
                                                        @if($user_val->problemResult->where('status','!=','pending')->where('is_training','=',0)->count() > 0)
                                                        @php $accuracy= number_format($user_val->problemResult->where('status','correct')->where('is_training','=',0)->count()  * 100/$user_val->problemResult->where('status','!=','pending')->where('is_training','=',0)->count(),2) @endphp
                                                        {{$accuracy.'%'}}
                                                        @else
                                                        @php $accuracy=0; @endphp
                                                        0%
                                                        @endif
                                                    </td>
                                                    <td> 
                                                        {{-- {{$accuracy}} --}}
                                                       @php $level=$handicapLevel->where('bottom_range','<=',$accuracy)->where('top_range','>',$accuracy)->first(); @endphp 
                                                       @if($level)
                                                       
                                                           {{$level->title}}
                                                       @else
                                                       
                                                           Not Available
                                                       @endif

                                                    </td>

                                                    <td><a href="{{route('admin.user.edit',$user_val->id)}}" class="btn btn-info"><i class="ft-edit-2"></i></a>
                                                    </td>
                                                </tr>
                                            @endforeach
                                        @endif
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <th>Tittle</th>
                                            <th>#Votes</th>
                                            <th>Accuracy</th>
                                            <th>Level</th>
                                            <th>Edit</th>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
        {{-- User --}}
        {{-- Open Problems --}}
        <section class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-head">
                        <div class="card-header">
                            <div class="row">
                                <div class="col-md-2">
                                    <h4 class="card-title">Open Problems</h4>
                                </div>
                                <div class="col-md-1">
                                    <div
                                        class="badge badge-info w-100 h-100 d-flex justify-content-center align-items-center">
                                        {{$open_problems->count()}}
                                    </div>
                                </div>
                            </div>
                            <a class="heading-elements-toggle"><i class="la la-ellipsis-h font-medium-3"></i></a>
                            <div class="heading-elements">
                                <a href="{{route('admin.create.problem')}}" class="btn btn-info text-white btn-sm" type="button"><i
                                        class="ft-file-plus white"></i></a>
                            </div>
                        </div>
                    </div>
                    <div class="card-content">
                        <div class="card-body">
                            <!-- Task List table -->
                            <div class="table-responsive">
                                <table id="open-problems"
                                    class="table table-white-space table-bordered row-grouping display no-wrap icheck table-middle">
                                    <thead>
                                        <tr>
                                            <th>Created Date</th>
                                            <th>Tittle</th>
                                            <th>#Votes</th>
                                            <th>A#1</th>
                                            <th>A#2</th>
                                             {{-- <th>A#3</th>
                                            <th>A#4</th>
                                             <th>A#5</th>
                                            <th>A#6</th>
                                             <th>A#7</th>
                                            <th>A#8</th> --}}
                                            <th>Correct Answer</th>
                                            <th>Status</th>
                                            <th>%Complete</th>
                                            <th>Score</th>
                                            <th>Edit</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @if(!empty($open_problems))
                                            @foreach($open_problems as $open)
                                                <tr>
                                                    {{-- <td>
                                                        <input type="checkbox" class="input-chk">
                                                    </td> --}}
                                                    <td class="font-weight-bold text-info">
                                                        {{$open->created_at}}
                                                    </td>
                                                    <td class="font-weight-bold text-info">
                                                        {{$open->title}}
                                                    </td>
                                                    <td>
                                                        {{$open->problemResult->where('is_training',0)->count()}}
                                                    </td>
                                                     <td>
                                                        {{$open->problemResult->where('answer_number',1)->where('is_training','=',0)->count()}}
                                                    </td>
                                                    <td>
                                                        {{$open->problemResult->where('answer_number',2)->where('is_training','=',0)->count()}}

                                                    </td>
                                                    {{-- <td>
                                                        {{number_format($open->problemResult->where('answer_number',1)->where('is_training','=',0)->count() * 100/$open->max_total).'%'}}
                                                    </td>
                                                    <td>
                                                        {{number_format($open->problemResult->where('answer_number',2)->where('is_training','=',0)->count() * 100/$open->max_total).'%'}}

                                                    </td>
                                                    <td>
                                                        {{number_format($open->problemResult->where('answer_number',3)->where('is_training','=',0)->count() * 100/$open->max_total).'%'}}
                                                    </td>
                                                    <td>
                                                        {{number_format($open->problemResult->where('answer_number',4)->where('is_training','=',0)->count() * 100/$open->max_total).'%'}}

                                                    </td>
                                                     <td>
                                                        {{number_format($open->problemResult->where('answer_number',5)->where('is_training','=',0)->count() * 100/$open->max_total).'%'}}
                                                    </td>
                                                    <td>
                                                        {{number_format($open->problemResult->where('answer_number',6)->where('is_training','=',0)->count() * 100/$open->max_total).'%'}}

                                                    </td>
                                                     <td>
                                                        {{number_format($open->problemResult->where('answer_number',7)->where('is_training','=',0)->count() * 100/$open->max_total).'%'}}
                                                    </td>
                                                    <td>
                                                        {{number_format($open->problemResult->where('answer_number',8)->where('is_training','=',0)->count() * 100/$open->max_total).'%'}}

                                                    </td> --}}
                                                    <td>
                                                        {{$open->correct_answer}}

                                                    </td>
                                                    <td>
                                                        {{-- @if($open->problemResult->where('is_training','=',0)->count() >= $open->max_total || $open->end_date <= Carbon::now() || $open->is_active=='0')
                                                            Closed
                                                        @else
                                                          Opened  
                                                        @endif --}}
                                                         @if($open->is_active=='0' || $open->end_date <= Carbon::now())
                                                            Closed
                                                        @else
                                                          Opened  
                                                        @endif
                                                    </td>
                                                    <td>
                                                        {{number_format($open->problemResult->where('is_training','=',0)->count() * 100/$open->max_total).'%'}}
                                                    </td>
                                                    <td>
                                                        {{$open->score}}
                                                    </td>
                                                    <td><a href="{{route('admin.edit.problem',['id' => $open->id])}}" class="btn btn-info"><i class="ft-edit-2"></i></a>
                                                    </td>
                                                </tr>
                                            @endforeach
                                        @endif
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <th>Tittle</th>
                                            <th>#Votes</th>
                                            <th>A#1</th>
                                            <th>A#2</th>
                                            {{-- <th>A#3</th>
                                            <th>A#4</th>
                                             <th>A#5</th>
                                            <th>A#6</th>
                                             <th>A#7</th>
                                            <th>A#8</th> --}}
                                            <th>Correct Answer</th>
                                            <th>Status</th>
                                            <th>%Complete</th>
                                            <th>Score</th>
                                            <th>Edit</th>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
        {{-- Open Problems --}}

        {{-- handicap level --}}
        <section class="row">
            <div class="col-md-9">
                <div class="card">
                    <div class="card-head">
                        <div class="card-header">
                            
                            <div class="row">
                                <div class="col-md-2">
                                    <h4 class="card-title">Handicap levels</h4>
                                </div>
                                <div class="col-md-1">
                                    <div
                                        class="badge badge-info w-100 h-100 d-flex justify-content-center align-items-center">
                                        {{$handicapLevel->count()}}
                                    </div>
                                </div>
                            </div>
                            <a class="heading-elements-toggle"><i class="la la-ellipsis-h font-medium-3"></i></a>
                            <div class="heading-elements">
                                <a href="{{route('admin.handicaplevel.create')}}" class="btn btn-info text-white btn-sm" type="button"><i
                                        class="ft-plus white"></i></a>
                            </div>
                        </div>
                    </div>
                    <div class="card-content">
                        <div class="card-body">
                            <!-- Task List table -->
                            <div class="table-responsive">
                                <table id="handicap-level"
                                    class="table table-white-space table-bordered row-grouping display no-wrap icheck table-middle">
                                    <thead>
                                        <tr>
                                            <th>Score</th>
                                            <th>%Range</th>
                                            <th>Weight (handicap)</th>
                                            <th>Users</th>
                                            <th>Edit</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @if(!empty($handicapLevel))
                                            @foreach($handicapLevel as $key => $handicapLevel_value)
                                                 @php
                                                        $rangeStart = $handicapLevel_value->bottom_range;  
                                                        $rangeEnd = $handicapLevel_value->top_range;  
                                                        $filtered_events = array_filter($per_arr, function($var) use ($rangeStart, $rangeEnd) {  
                                                            $evtime = $var['percentage'];  
                                                            return $evtime <= $rangeEnd && $evtime >= $rangeStart;  
                                                        });
                                                       // dd($filtered_events);
                                                 @endphp
                                                <tr>
                                                    <td class="font-weight-bold text-info">
                                                        {{$handicapLevel_value->title}}
                                                    </td>
                                                    <td>
                                                        {{$handicapLevel_value->bottom_range."% - ".$handicapLevel_value->top_range."%"}}
                                                    </td>
                                                    <td>
                                                         {{$handicapLevel_value->weight}}
                                                    </td>
                                                    <td>
                                                     {{count($filtered_events)}}
                                                    </td>
                                                    <td><a href="{{route('admin.handicaplevel.edit',$handicapLevel_value->id)}}" class="btn btn-info"><i class="ft-edit-2"></i></a>
                                                    </td>
                                                </tr>
                                                
                                            @endforeach
                                        @endif
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <th>Score</th>
                                            <th>%Range</th>
                                            <th>Weight (handicap)</th>
                                            <th>Users</th>
                                            <th>Edit</th>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!-- Simple Pie Chart -->
            <div class="col-md-3">
                <div class="card">
                  <div class="card-header">
                    <h4 class="card-title">Simple Pie Chart</h4>
                    <a class="heading-elements-toggle"><i class="la la-ellipsis-v font-medium-3"></i></a>
                    <div class="heading-elements">
                      <ul class="list-inline mb-0">
                        {{-- <li><a data-action="collapse"><i class="ft-minus"></i></a></li> --}}
                        {{-- <li><a data-action="reload"><i class="ft-rotate-cw"></i></a></li> --}}
                        <li><a data-action="expand"><i class="ft-maximize"></i></a></li>
                        {{-- <li><a data-action="close"><i class="ft-x"></i></a></li> --}}
                      </ul>
                    </div>
                  </div>
                  <div class="card-content collapse show">
                    <div class="card-body">
                      <canvas id="simple-pie-chart" height="400"></canvas>
                    </div>
                  </div>
                </div>
              </div>
              <!-- Simple Doughnut Chart -->
        </section>
        {{-- handicap level --}}
        
        {{-- Donation History --}}
        {{-- <section class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-head">
                        <div class="card-header">
                            <div class="row">
                                <div class="col-md-2">
                                    <h4 class="card-title">Gift History</h4>
                                </div>
                                <div class="col-md-1">
                                    <div
                                        class="badge badge-info w-100 h-100 d-flex justify-content-center align-items-center">
                                        {{$gift->count()}}
                                    </div>
                                </div>
                            </div>
                            <a class="heading-elements-toggle"><i class="la la-ellipsis-h font-medium-3"></i></a>
                            <div class="heading-elements">
                                <a href="{{route('admin.create.gift')}}" class="btn btn-info text-white btn-sm" type="button"><i
                                        class="ft-plus white"></i></a>
                            </div>
                        </div>
                    </div>
                    <div class="card-content">
                        <div class="card-body">
                            <!-- Task List table -->
                            <div class="table-responsive">
                                <table id="donation-history"
                                    class="table table-white-space table-bordered row-grouping display no-wrap icheck table-middle">
                                    <thead>
                                        <tr>
                                            <th>Date</th>
                                            <th>Organization</th>
                                            <th>Amount</th>
                                            <th>Status</th>
                                            <th></th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @if(!empty($gift))
                                            @foreach($gift as $key => $gift_value)
                                                <tr>
                                                    <td class="font-weight-bold text-info">
                                                        {{$gift_value->date}}
                                                    </td>
                                                    <td>
                                                       {{$gift_value->organization_name}}
                                                    </td>
                                                    <td>
                                                        {{$gift_value->amount}}
                                                    </td>
                                                    <td>
                                                        {{$gift_value->status}}
                                                    </td>
                                                    <td><a href="{{route('admin.edit.gift',['id' => $gift_value->id])}}" class="btn btn-info"><i class="ft-edit-2"></i></a>
                                                    </td>
                                                </tr>
                                            @endforeach
                                        @endif
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <th>Date</th>
                                            <th>Organization</th>
                                            <th>Amount</th>
                                            <th>Status</th>
                                            <th></th>
                                        </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section> --}}
        {{-- Donation History --}}

        <!--Display None -->
        <div class="row match-height d-none">
            <div class="col-xl-8 col-lg-12">
                <div class="card">
                    <div class="card-content ">
                        <div id="cost-revenue" class="height-250 position-relative"></div>
                    </div>
                    <div class="card-footer">
                        <div class="row mt-1">
                            <div class="col-3 text-center">
                                <h6 class="text-muted">Total Products</h6>
                                <h2 class="block font-weight-normal">18.6 k</h2>
                                <div class="progress progress-sm mt-1 mb-0 box-shadow-2">
                                    <div class="progress-bar bg-gradient-x-info" role="progressbar" style="width: 70%"
                                        aria-valuenow="70" aria-valuemin="0" aria-valuemax="100"></div>
                                </div>
                            </div>
                            <div class="col-3 text-center">
                                <h6 class="text-muted">Total Sales</h6>
                                <h2 class="block font-weight-normal">64.54 M</h2>
                                <div class="progress progress-sm mt-1 mb-0 box-shadow-2">
                                    <div class="progress-bar bg-gradient-x-warning" role="progressbar" style="width: 60%"
                                        aria-valuenow="60" aria-valuemin="0" aria-valuemax="100"></div>
                                </div>
                            </div>
                            <div class="col-3 text-center">
                                <h6 class="text-muted">Total Cost</h6>
                                <h2 class="block font-weight-normal">24.38 B</h2>
                                <div class="progress progress-sm mt-1 mb-0 box-shadow-2">
                                    <div class="progress-bar bg-gradient-x-danger" role="progressbar" style="width: 40%"
                                        aria-valuenow="40" aria-valuemin="0" aria-valuemax="100"></div>
                                </div>
                            </div>
                            <div class="col-3 text-center">
                                <h6 class="text-muted">Total Revenue</h6>
                                <h2 class="block font-weight-normal">36.72 M</h2>
                                <div class="progress progress-sm mt-1 mb-0 box-shadow-2">
                                    <div class="progress-bar bg-gradient-x-success" role="progressbar" style="width: 90%"
                                        aria-valuenow="90" aria-valuemin="0" aria-valuemax="100"></div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-xl-4 col-lg-12">
                <div class="card">
                    <div class="card-content">
                        <div class="card-body sales-growth-chart">
                            <div id="monthly-sales" class="height-250"></div>
                        </div>
                    </div>
                    <div class="card-footer">
                        <div class="chart-title mb-1 text-center">
                            <h6>Total monthly Sales.</h6>
                        </div>
                        <div class="chart-stats text-center">
                            <a href="#" class="btn btn-sm btn-danger box-shadow-2 mr-1">Statistics <i
                                    class="ft-bar-chart"></i></a>
                            <span class="text-muted">for the last year.</span>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!--Display None -->
    </div>
@endsection
@push('script')
<script>
    function PieChart(title,totalUser,color){
        var ctx = $("#simple-pie-chart");

        // Chart Options
        var chartOptions = {
            responsive: true,
            maintainAspectRatio: false,
            responsiveAnimationDuration:500,
        };

        // Chart Data
        var chartData = {
            labels: title,
            datasets: [{
                label: "My First dataset",
                data: totalUser,
                backgroundColor: color,
            }]
        };

        var config = {
            type: 'pie',

            // Chart Options
            options : chartOptions,

            data : chartData
        };

        // Create the chart
        var pieSimpleChart = new Chart(ctx, config);
    }
    $(document).ready(function() {
        

         $.ajax({
                    //url:'delete-estimate/'+id,
            url:"{{url('admin/piechart')}}",
            type:'GET',
            success:function(response)
            {  
                PieChart(response.title_arr,response.title_total_user,response.title_color)
                //console.log(response);
                //$('#ownerid'+id).remove();
            }

        });
    });
</script>
{{-- <script src="{{ asset('app-assets/js/scripts/charts/chartjs/line/line-area.js') }}" type="text/javascript"></script> --}}

<script src="{{ asset('app-assets/js/scripts/charts/chartjs/line/line-area.js') }}" type="text/javascript"></script>
<script type="text/javascript">
 var _ydata=[];
for(let i= 0; i<101; i++){
    _ydata.push(i+'%');
    }    var _xdata=JSON.parse('{!! json_encode($chart1) !!}');

   function ChangeResult()
   {
       alert('working');
   }
</script>
@endpush