فیلتر
گزارش کلی
گزارش درس به درس
کل زمان صرف شده
{{ number_format($authUser->reports()->filterDate($filterDateMode, $dates)->where('box_type_id', '1')->whereIn('lesson_id', $data['reading'])->sum('time') / 60, 1) }} ساعت
@foreach($data['reading'] as $item) @php $lesson = \App\Models\Lesson::find($item); // Total $userReports = $authUser->reports()->filterDate($filterDateMode, $dates)->where(['box_type_id' => '1', 'lesson_id' => $item])->pluck('id')->toArray(); $userReportsSubjects = $authUser->getSubjects($userReports); $percent = $lesson->subjects()->count() > 0 ? ($userReportsSubjects->count() * 100) / $lesson->subjects()->count() : 0; // Plan // $userPlans = $authUser->plans()->pluck('plan_id')->toArray(); // $planDates = \App\Models\PlanDate::whereIn('plan_id', $userPlans)->pluck('id')->toArray(); // $dateBoxes = \App\Models\Box::whereIn('plan_date_id', $planDates)->whereLessonId($item)->pluck('id')->toArray(); // $boxSubjects = \App\Models\BoxSubject::whereIn('box_id', $dateBoxes)->get(); @endphp {{-- {{ $lesson->name }}--}}
{{ $lesson->name }}
{{--
درصد مطالعه از کل
--}} {{ $lesson->subjects()->count() }} / {{ $userReportsSubjects->count() }}
{{--
--}} {{--
--}} {{--
درصد مطالعه از برنامه
--}} {{-- {{ $boxSubjects->count() }} / {{ $userReportsSubjects->count() }}--}} {{--
--}} {{--
--}} {{--
--}} {{--
--}} {{--
--}} {{--
--}}
@if(!$loop->last)
@endif @endforeach
کل تست های زده شده
{{ $authUser->reports()->filterDate($filterDateMode, $dates)->whereIn('box_type_id', ['2', '3'])->whereIn('lesson_id', $data['reading'])->sum('test_count') }} تست
@foreach($data['reading'] as $item) @php $lesson = \App\Models\Lesson::find($item); $userPlans = $authUser->plans()->pluck('plan_id')->toArray(); $planDates = \App\Models\PlanDate::whereIn('plan_id', $userPlans)->pluck('id')->toArray(); $boxesSumTests = \App\Models\Box::whereIn('plan_date_id', $planDates)->whereLessonId($item)->sum('test_count'); $userReportsSumTest = $authUser->reports()->filterDate($filterDateMode, $dates)->whereIn('box_type_id', ['2', '3'])->where(['lesson_id' => $item])->sum('test_count'); if($boxesSumTests != 0){ $percent = ($userReportsSumTest * 100) / $boxesSumTests; }else{ $percent = 0; } @endphp
{{ $lesson->name }}
{{ $boxesSumTests }} / {{ $userReportsSumTest }}
@if(!$loop->last)
@endif @endforeach