@extends('admin.layouts.app')

@section('content')
    <section class="section">
        <div class="section-header">
            <h1>{{ trans('admin/main.sales_reports') }}</h1>
            <div class="section-header-breadcrumb">
                <div class="breadcrumb-item active"><a href="/admin/">{{trans('admin/main.dashboard')}}</a>
                </div>
                <div class="breadcrumb-item">{{ trans('admin/main.sales_reports') }}</div>
            </div>
        </div>

        <div class="section-body">

            <section class="card">
                <div class="card-body">
                    <form method="get" class="mb-0">
                        <div class="row">

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label class="input-label">{{ trans('admin/main.student') }}</label>
                                    <select name="student_id" data-search-option="just_student_role" class="form-control search-user-select2"
                                            data-placeholder="{{ trans('admin/main.search_student') }}">
                                            <option value="" {{ !empty($students) ? 'selected' : '' }} disabled>{{ trans('public.select') }}</option>
                                            @foreach($students as $student)
                                                <option value="{{ $student->id }}"@if( !empty($student) and request()->get('student_id')  == $student->id) selected @endif >{{ $student->full_name }}</option>
                                            @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label class="input-label">{{ trans('admin/main.instructor') }}</label>
                                    <select name="teacher_id" data-search-option="just_teacher_role" class="form-control search-user-select2"
                                            data-placeholder="{{ trans('admin/main.search_instructors') }}">
                                            <option value="" {{ !empty($teachers) ? 'selected' : '' }} disabled>{{ trans('public.select') }}</option>
                                            @foreach($teachers as $teacher)
                                                <option value="{{ $teacher->id }}" @if( !empty($teacher) and request()->get('teacher_id')  == $teacher->id) selected @endif>{{ $teacher->full_name }}</option>
                                            @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label class="input-label">{{ trans('admin/main.class') }}</label>
                                    <select name="webinar_id" class="form-control search-webinar-select2"
                                            data-placeholder="{{ trans('admin/main.search_classes') }}">
                                            <option value="" {{ !empty($webinars) ? 'selected' : '' }} disabled>{{ trans('public.select') }}</option>
                                            @foreach($webinars as $webinar)
                                                <option value="{{ $webinar->id }}" @if( !empty($webinar) and request()->get('webinar_id')  == $webinar->id) selected @endif >{{ $webinar->title }}</option>
                                            @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label class="input-label">{{trans('admin/main.organization')}}</label>
                                    <select name="organization_id" data-placeholder="{{ trans('admin/main.search_organization') }}" data-search-option="just_organization_role" data-plugin-selectTwo class="form-control select2 populate">
                                        <option value="" {{ !empty($organizations) ? 'selected' : '' }} disabled>{{ trans('public.select') }}</option>
                                        
                                            @foreach($organizations as $organization)
                                                <option value="{{ $organization->id }}" @if(request()->get('organization_id') == $organization->id) selected @endif>{{ $organization->full_name }}</option>
                                            @endforeach
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label class="input-label">{{trans('admin/main.category')}}</label>
                                    <select name="category_id" data-placeholder="{{ trans('admin/main.search_category') }}" data-plugin-selectTwo class="form-control select2 populate">
                                        
                                        <option value="" {{ !empty($categories) ? 'selected' : '' }} disabled>{{ trans('public.select') }}</option>
                                        @foreach($categories as $category)
                                                <option value="{{ $category->id }}" @if(request()->get('category_id') == $category->title) selected @endif>{{ $category->title }}</option>
                                            @endforeach
                                    </select>
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group">
                                    <label class="input-label">{{ trans('admin/main.start_date') }}</label>
                                    <div class="input-group">
                                        <input type="date" id="fsdate" class="text-center form-control" name="from" value="{{ request()->get('from') }}" placeholder="Start Date">
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label class="input-label">{{ trans('admin/main.end_date') }}</label>
                                    <div class="input-group">
                                        <input type="date" id="lsdate" class="text-center form-control" name="to" value="{{ request()->get('to') }}" placeholder="End Date">
                                    </div>
                                </div>
                            </div>

                            <div class="col-md-3">
                                <div class="form-group mt-1">
                                    <label class="input-label mb-4"> </label>
                                    <input type="submit" class="text-center btn btn-primary w-100" value="{{ trans('admin/main.show_results') }}">
                                </div>
                            </div>
                        </div>

                    </form>
                </div>
            </section>

            <div class="row">
                <div class="col-12 col-md-12">
                    <div class="card">

                        <div class="card-body">
                            <div class="table-responsive">
                                <table class="table table-striped font-14">
                                    <tr>
                                        <th>{{ trans('admin/main.day') }}</th>
                                        <th>{{ trans('admin/main.successful_count') }}</th>
                                        <th>{{ trans('admin/main.refund_count') }}</th>
                                        <th>{{ trans('admin/main.successful_amount') }}</th>
                                        <th>{{ trans('admin/main.refund_amount') }}</th>
                                    </tr>
 
                                    @foreach($days as $day)
                                        <tr>
                                            <td>{{ $day->day }}</td>
                                            <td>{{ $day->successful_count }}</td>
                                            <td>{{ $day->refund_count }}</td>
                                            <td>{{ addCurrencyToPrice(handlePriceFormat($day->successful_total)) }}</td>
                                            <td>{{ addCurrencyToPrice(handlePriceFormat($day->refund_total)) }}</td>
                                        </tr>
                                    @endforeach

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

                        <div class="card-footer text-center">
                            {{ $days->appends(request()->input())->links() }}
                        </div>

                    </div>
                </div>
            </div>
        </div>
    </section>
@endsection