@include('backend.layouts.autocomplete')
@extends('backend.layouts.app')
@section('content')
    <div class="card page-container" id="page-container">
        <div class="card-body p-lg-25 content-wrap">
            <div class="toolbar" id="kt_toolbar">
                <div id="kt_toolbar_container" class="container-fluid d-flex flex-stack">
                    <div data-kt-swapper="true" data-kt-swapper-mode="prepend"
                        data-kt-swapper-parent="{default: '#kt_content_container', 'lg': '#kt_toolbar_container'}"
                        class="page-title d-flex align-items-center flex-wrap me-3 mb-5 mb-lg-0">
                        <h1 class="d-flex align-items-center text-dark fw-bolder fs-3 my-1">{{ TranslationManager::translate('Exams Accounts') }}</h1>
                        <span class="h-20px border-gray-200 border-start mx-4"></span>
                        <ul class="breadcrumb breadcrumb-separatorless fw-bold fs-7 my-1">
                            <li class="breadcrumb-item text-muted">
                                <a href="{{ route('admin.index') }}"
                                    class="text-muted text-hover-primary">{{ TranslationManager::translate('Home') }}</a>
                            </li>
                            <li class="breadcrumb-item">
                                <span class="bullet bg-gray-200 w-5px h-2px"></span>
                            </li>
                            <li class="breadcrumb-item text-muted">{{ TranslationManager::translate('Account') }}</li>
                            <li class="breadcrumb-item">
                                <span class="bullet bg-gray-200 w-5px h-2px"></span>
                            </li>
                            <li class="breadcrumb-item text-dark">{{ TranslationManager::translate('Exams Accounts') }}</li>
                        </ul>
                    </div>
                    <div class="d-flex align-items-center py-1">
                        {{-- <a href="{{ route('admin.accounts.create') }}" class="btn btn-sm btn-primary">{{ TranslationManager::translate('Create') }}</a> --}}
                    </div>
                </div>
            </div>
            <div class="post d-flex flex-column-fluid" id="kt_post">
                <div id="kt_content_container" class="container-sm">
                    <div class="card">
                        <div class="card-header border-0 pt-6"></div>

                        <div class="card-body">

                            <form action="{{ route('admin.accounts.exams.index') }}" method="get">
                                @csrf
                                <input type="hidden" name="model" value="{{ request()->model }}">
                                <div class="container">
                                    <div class="row">
                                        <div class="col-sm">
                                            <label class="fs-6 fw-bold mb-2">{{ TranslationManager::translate('Students') }}</label>
                                            <select class="form-select form-select-solid" data-control="select2"
                                                data-hide-search="false" name="student_id">
                                                <option value="">{{ TranslationManager::translate('Select') }}</option>
                                                @foreach ($students as $student)
                                                    <option value="{{ $student->id }}"
                                                        {{ request()->student_id == $student->id ? 'selected' : '' }}>
                                                        {{ $student->getName() }} ({{ $student->getPhone() }})</option>
                                                @endforeach
                                            </select>
                                        </div>

                                        <div class="col-sm">
                                            <label class="fs-6 fw-bold mb-2">{{ TranslationManager::translate('Instructors') }}</label>
                                            <select class="form-select form-select-solid" data-control="select2"
                                                data-hide-search="true" name="instructor_id">
                                                <option value="">{{ TranslationManager::translate('Select') }}</option>
                                                @foreach ($instructors as $instructor)
                                                    <option value="{{ $instructor->id }}"
                                                        {{ request()->instructor_id == $instructor->id ? 'selected' : '' }}>
                                                        {{ $instructor->getName() }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                        {{--
                                        <div class="col-sm">
                                            <label class="fs-6 fw-bold mb-2">{{ TranslationManager::translate('Courses') }}</label>
                                            <select class="form-select form-select-solid" data-control="select2"
                                                data-hide-search="true" name="course_id">
                                                <option value="">{{ TranslationManager::translate('Select') }}</option>
                                                @foreach ($courses as $course)
                                                    <option value="{{ $course->id }}"
                                                        {{ request()->course_id == $course->id ? 'selected' : '' }}>
                                                        {{ $course->getName() }}
                                                    </option>
                                                @endforeach
                                            </select>
                                        </div>
                                        --}}
                                    </div>
                                </div>
                                <div class="mb-8"></div>

                                <div class="container">
                                    <div class="row">
                                        <div class="col-sm">
                                            <label class="fs-6 fw-bold mb-2">{{ TranslationManager::translate('Is Accepted') }}</label>
                                            <select class="form-select form-select-solid" data-control="select2"
                                                data-hide-search="true" name="is_accepted">
                                                <option value="">{{ TranslationManager::translate('Select') }}</option>
                                                <option value="1" {{ request()->is_accepted == 1 ? 'selected' : '' }}>
                                                    {{ TranslationManager::translate('Yes') }}</option>
                                                <option value="0"
                                                    {{ request()->is_accepted === '0' ? 'selected' : '' }}>
                                                    {{ TranslationManager::translate('No') }}</option>
                                            </select>
                                        </div>

                                        <div class="col-sm">
                                            <label class="fs-6 fw-bold mb-2">{{ TranslationManager::translate('Date From') }}</label>
                                            <input type="date" class="form-control" name="date_from"
                                                placeholder="Date From" value="{{ request()->date_from }}">
                                        </div>

                                        <div class="col-sm">
                                            <label class="fs-6 fw-bold mb-2">{{ TranslationManager::translate('Date To') }}</label>
                                            <input type="date" class="form-control" name="date_to" placeholder="Date To"
                                                value="{{ request()->date_to }}">
                                        </div>



                                    </div>
                                </div>

                                <div class="mb-8"></div>

                                
                                <div class="mb-3"></div>
                                <div class="container">
                                    <div class="row">

                                        <div class="col-sm">
                                            <label class="fs-6 fw-bold mb-2">{{ TranslationManager::translate('Student Phone Number') }}</label>
                                            <input type="text" class="form-control" name="student_phone"
                                                placeholder="Student Phone Number"
                                                value="{{ request()->student_phone }}">
                                        </div>


                                        <div class="col-sm" style="align-self: self-end !important;">
                                            <button type="submit"
                                                class="btn btn-primary form-control">{{ TranslationManager::translate('Search') }}</button>
                                        </div>

                                        <div class="col-sm">
                                        </div>
                                    </div>
                                </div>
                            </form>

                            <div class="mb-8"></div>

                            <table id="table" class="display">
                                <thead class="table-thead">
                                    <tr>
                                        <th class="text-center">#</th>
                                        <th class="text-center">{{ TranslationManager::translate('Exam') }}</th>
                                        <th class="text-center">{{ TranslationManager::translate('Total Amount') }}</th>
                                        <th class="text-center">{{ TranslationManager::translate('Details') }}</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($exams as $key => $exam)
                                        <tr>
                                            <td class="text-center">{{ $key + 1 }}</td>
                                            <td class="text-center">{{ $exam->getName() }}</td>
                                            <td class="text-center">{{
                                                number_format(\App\Models\ExamOrder\ExamOrder::filter(request()->all())->Accepted()->where('exam_id', $exam->id)->sum('price'), 2)
                                            }} {{ TranslationManager::translate('SAR') }}</td>
                                            <td class="text-center">
                                                <a href="{{ route('admin.accounts.exam.details', $exam->id) }}"
                                                    class="btn btn-sm btn-primary">{{ TranslationManager::translate('Details') }}</a>
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                        {{ $exams->appends(request()->all())->links() }}
                        <br>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection
@push('scripts')
    @include('backend.layouts.table-scripts')
@endpush