@extends('theme.master')
@section('title', 'Profile & Setting')
@section('content')

@include('admin.message')


<!-- about-home start -->
<section id="blog-home" class="blog-home-main-block profile_had">
    <div class="container">
        <h1 class="blog-home-heading text-white">Dashboard</h1>
    </div>
</section> 
<section id="profile-item" class="profile-item-block homepad">
    <div class="container">
            <div class="row dashboard-row">
                @include('institute.sidebar')
                {{-- <div class="col-xl-3 col-lg-4 mb-4">
                    <div class="bg-gradent rounded overflow-hidden shadow p-4">
                        <div class="dashboard-author-block text-center">
                            <div class="author-image mb-3">
                                <div class="avatar-upload">
                                    <div class="avatar-preview">
                                        @if (Auth::User()->user_img != null || Auth::User()->user_img != '')
                                            <div class="avatar-preview-img" id="imagePreview"
                                                style="background-image: url({{ url('/images/user_img/' . Auth::User()->user_img) }});">
                                            </div>
                                        @else
                                            <div class="avatar-preview-img" id="imagePreview"
                                                style="background-image: url({{ asset('images/default/user.jpg') }});">
                                            </div>
                                        @endif
                                    </div>
                                </div>
                            </div>
                            <div class="author-name font-size-18 text-white font-weight-semibold line-hight-1">
                                {{ Auth::User()->fname }} <span
                                    class="font-weight-light font-size-16 d-block">{{ Auth::User()->lname }}</span>
                            </div>
                        </div>
                        <div class="dashboard-items text-white mt-3">
                            <ul>
                               
                                <li><i class="fa fa-dashboard"></i><a href="{{ route('institute.dashboard') }}"
                                        title="Dashboard">Dashboard</a></li>
                                <li><i class="fa fa-bookmark"></i><a href="{{ route('mycourse.show') }}"
                                        title="{{ __('frontstaticword.MyCourses') }}">{{ __('frontstaticword.MyCourses') }}</a></li>

                                <li><i class="fa fa-file-text"></i><a href="{{ route('view.institute.meterial') }}"
                                        title="View Meterial">Meterials</a></li>
                                <li><i class="fa fa-question"></i><a href="{{ route('institute.question-bank.index') }}" 
                                    title="question-bank">Questions</a></li>

                                <li><i class="fa fa-user"></i><a href="{{ route('profile.show', Auth::User()->id) }}"
                                        title="Upload Items">{{ __('frontstaticword.UserProfile') }}</a></li>
                                <li style="border-bottom: 0 !important;"><i class="fa fa-address-book"></i><a
                                        href="{{ url('/contact-us') }}"
                                        title="Followers">{{ __('Help And Support') }}</a></li>
                            </ul>
                        </div>
                    </div>
                </div> --}}
                <div class="col-xl-9 col-lg-8">

                    <div class="profile-info-block px-0">
                        <div class="row dashboard-for-card">
                            <div class="col-sm-6 col-md-3 mb-4">
                                <div class="card cource_card border-0">
                                    <div class="card-body text-center">
                                    <h5 class="card-title text-white font-weight-normal">Course</h5>
                                    <p class="card-text text-white font-weight-bold font-size-40 pb-4">{{$course_count}}</p>
                                    <a href="{{ route('view.institute.meterial') }}" class="card-link text-white"><i class="fa fa-arrow-right mr-2"></i></a>
                                    </div>
                                </div>
                            </div>
                            <div class="col-sm-6 col-md-3 mb-4">
                            <div class="card users_card border-0">
                                <div class="card-body text-center">
                                <h5 class="card-title font-weight-normal">Users</h5>
                                <p class="card-text font-weight-bold font-size-40 pb-4">{{$user_count}}</p>
                                <a href="{{ route('institute.users') }}" class="card-link text-primary"><i class="fa fa-arrow-right mr-2"></i></a>
                                </div>
                            </div>
                        </div>
                        <div class="col-sm-6 col-md-3 mb-4">
                            <div class="card newusers_card border-0">
                                <div class="card-body text-center">
                                <h5 class="card-title font-weight-normal">New Users</h5>
                                <p class="card-text font-weight-bold font-size-40 pb-4">{{$new_user_count}}</p>
                                <a href="{{ route('institute.recent.users') }}" class="card-link text-primary"><i class="fa fa-arrow-right mr-2"></i></a>
                                </div>
                            </div>
                        </div>
                        <div class="col-sm-6 col-md-3">
                            <div class="card totalsales_card border-0">
                                <div class="card-body text-center">
                                <h5 class="card-title font-weight-normal">Finance</h5>
                                <p class="card-text font-weight-bold font-size-40 pb-4">{{$total}}</p>
                                <a href="{{ route('institute.institute.institute_profit') }}" class="card-link text-primary"><i class="fa fa-arrow-right mr-2"></i></a>

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

                        <div class="row pb-3">
                            <div class="col-12">
                                <hr>
                            </div>
                        </div>


                        <div class="row">
                            <div class="col-12">
                                <h5 class="btm-30 font-size-30 text-primary font-weight-medium mb-4  line-hight-1">Recent Top 5 Users</h5>
                                <form method="GET">
                                 <div class="row  p-2">
                                  <div class="col-sm-3">
                                    <div class="form-group">
                                        <select class="form-control" name="cource">
                                        <option value="">Select Course</option>
                                        @if(!empty($institutecources))
                                        @foreach($institutecources  as  $ins => $value_cource)
                                        <option  value="{{$value_cource->id}}" @if($cource == $value_cource->id){{'selected'}} @endif> {{$value_cource->title}}
                                            </option>
                                        @endforeach
                                        
                                        @endif
                                        </select>
                                    </div>
                                </div>
                                <div class="col-sm-3">
                                        <div class="form-group">
                                           
                                            <select class="form-control" name="topic">
                                            <option value="">Select Topic</option>
                                             @foreach($quiztopic as $key_topic  =>  $value_topic)
                                            <option value="{{$value_topic->id}}" @if($topic == $value_topic->id){{'selected'}} @endif >{{$value_topic->title}}</option>
                                             @endforeach
                                            </select>
                                           

                                        </div>
                                </div>

                                 <div class="col-sm-3">
                                        <div class="form-group">
                                           <input class="btn btn-primary" type="submit" name="search" value="search">
                                           <a  href="{{route('institute.dashboard')}}" class="btn btn-dark" > Reset</a>

                                        </div>
                                </div>
                            </div>
                            </form>
                            </div>
                            <div class="col-12 dashboard-table table-responsive">
                                <div class="table-responsive">
                            <table class="table table-bordered table-striped text-dark font-weight-normal line-hight-2 font-size-13 table-hover bg-white mb-0">
                                <tr>
                                    <th width="14%">Date</th>
                                    <th width="21%">Course</th>
                                    <th width="8%">Topic</th>
                                    <th class="text-center" width="10%">User Name</th>
                                    <th class="text-center" width="13%">Mark Obtained</th>
                                    <th width="8%">View Score</th>

                                </tr>
                                @php
                    $counter = 0;
                    @endphp
                    @if ($quizanswer != null && $quizanswer->count() > 0)
                    @foreach($quizanswer as $quizanswe)
                    
                    <tr>
                        <td>
                            <span>{{ date('F d, Y', strtotime($quizanswe->created_at)) }}</span>
                        </td>
                        <td class="text-course font-weight-medium">
                            <span>{{ !empty($quizanswe->courses)?$quizanswe->courses->title:'-'}}</span>
                        </td>
                        <td>
                             <span>{{$quizanswe->topic->title}}

                            </span>
                        </td>
                        <td class="table-img text-center">
                            <!--<span>{{$quizanswe->user->fname}}-->

                            <!--</span>-->
                             <div class="avatar-preview-img" id="imagePreview"
                                                style="background-image: url({{ url('/images/user_img/' . $quizanswe->user->user_img) }});">
                                            </div>
                            @if ($quizanswe->user->user_img)
                                <img src="{{ url('/images/user_img/' . $quizanswe->user->user_img) }}" class="img-thumbnail" alt="{{$quizanswe->user->fname}}">
                            @else
                                <img src="{{ asset('images/default/user.jpg') }}" class="img-thumbnail" alt="{{$quizanswe->user->fname}}">
                            @endif
                        </td>
                        <td class="text-center">
                            <p>{{$quizanswe->score_card}}</p>
                        </td>
                        <td class="text-right">
                             <a href="{{route('start.quiz.show',[$quizanswe->topic_id,$quizanswe->user->id])}}" class="btn btn-primary">View Score</a>
                           
                        </td>

                       
                      

                    </tr>
                    @endforeach
                @else
                    <tr>
                        <td colspan="3">No records found.</td>
                    </tr>
                @endif
                            </table>
                        </div>
                        </div>
                        </div>

                        <div class="row pb-3">
                            <div class="col-12">
                                <hr>
                            </div>
                        </div>

                        
                        <div class="row">
                            <div class="col-12">
                                <h5 class="btm-30 font-size-30 text-primary font-weight-medium mb-4  line-hight-1">Expired Users Plan In Current Month</h5>
                            </div>
                            <div class="col-12 dashboard-table table-responsive">
                                <div class="table-responsive">
                            <table class="table table-bordered table-striped text-dark font-weight-normal line-hight-2 font-size-14 table-hover bg-white mb-0">
                                <tr>
                                    <th class="text-center">No.</th>
                                    <th class="text-center">Image</th>
                                    <th>Name</th>
                                    <th>Courses</th>
                                    <th>Expire Date</th>
                                    <th>Number</th>

                                </tr>
                                @if ($users != null && $users->count() > 0)
                                @foreach($users as $key => $user)
                                <tr>
                                    <td class="text-center">
                                        <span>{{$key + 1}}</span>
                                    </td>
                                    <td class="table-img text-center">
                                            @if ($user->user_img != null || $user->user_img != '')
                                                <div class="">
                                                    <img src="{{ url('/images/user_img/' . $user->user_img) }}" class="img-thumbnail" alt="Test2">
                                                </div>
                                            @else
                                                <div class="">
                                                    <img src="{{ asset('images/default/user.jpg') }}" class="img-thumbnail" alt="Test2">
                                                </div>
                                            @endif
                                    </td>
                                    <td>
                                        <span>{{$user->fname}} {{$user->lname}}</span>
                                    </td>
                                    <td>
                                        @foreach($user->UserInstitute as $key => $value)
                                        <span>
                                            {{$key + 1}} . {{$value->course->title}}
                                        </span>
                                        <br>
                                        @endforeach
                                    </td>
                                    <td>
                                        <span>{{ \Carbon\Carbon::parse($user->subscription_date)->format('d M Y') }}</span>
                                    </td>
                                    <td>
                                        <span>{{$user->mobile}}</span>
                                    </td>
                                </tr>
                                @endforeach
                            @else
                                <tr>
                                    <td colspan="3">No records found.</td>
                                </tr>
                            @endif
                            </table>
                        </div>
                        </div>
                        </div>
                        
                    </div>
                    
                </div>
            </div>
    </div>
</section>

@endsection

@section('custom-script')



@endsection