@extends('layouts.default') @push('title', get_phrase('Home')) @push('meta')@endpush @push('css') @endpush @section('content') @php $bannerData = json_decode(get_frontend_settings('banner_image')); $banneractive = get_frontend_settings('home_page'); if ($bannerData !== null && is_object($bannerData) && property_exists($bannerData, $banneractive)) { $banner = asset(json_decode(get_frontend_settings('banner_image'))->$banneractive); } else { $defaultBanner = asset('assets/frontend/default/image/bannerM.jpg'); } $total_students = DB::table('users')->where('role', 'student')->get(); @endphp

{{ get_phrase('Top Categories') }}

{{ get_phrase('Top Courses') }}

@php $top_courses = DB::table('courses') ->leftJoin('payment_histories', 'courses.id', '=', 'payment_histories.course_id') ->select('courses.id', 'courses.slug', 'courses.thumbnail', 'courses.title', 'courses.average_rating', 'courses.discount_flag', 'courses.is_paid', 'courses.price', 'courses.discounted_price', DB::raw('COUNT(payment_histories.id) as total_sales')) ->groupBy('courses.id', 'courses.slug', 'courses.thumbnail', 'courses.title', 'courses.average_rating', 'courses.discount_flag', 'courses.is_paid', 'courses.price', 'courses.discounted_price') ->where('status', 'active') ->orderByDesc('total_sales') ->take(4) // Number of courses you want to get, e.g., top 4 ->get(); @endphp @foreach ($top_courses as $key => $row) @endforeach
@php $total_students = DB::table('users')->where('role', 'student')->get(); $total_instructors = DB::table('users')->where('role', 'instructor')->get(); $free_courses = DB::table('courses')->where('is_paid', 0)->get(); $premium_courses = DB::table('courses')->where('is_paid', 1)->get(); @endphp

{{ count($total_students) }}+

{{ get_phrase('Happy Student') }}

{{ count($total_instructors) }}

{{ get_phrase('Quality educators') }}+

{{ count($premium_courses) }}+

{{ get_phrase('Premium courses') }}

{{ count($free_courses) }}+

{{ get_phrase('Cost-free course') }}

@php $settings = get_homepage_settings('marketplace'); $marketplace = json_decode($settings); if ($marketplace && isset($marketplace->instructor)) { $instructor = $marketplace->instructor; } @endphp @if ($marketplace)
@if (isset($instructor->image)) @endif

{{ $instructor->title }}

{!! $instructor->description !!}

@endif

{{ get_phrase('Frequently Asked Questions') }}

@php $faqs = count(json_decode(get_frontend_settings('website_faqs'), true)) > 0 ? json_decode(get_frontend_settings('website_faqs'), true) : [['question' => '', 'answer' => '']]; @endphp @foreach ($faqs as $key => $faq)

{{ $faq['answer'] }}

@endforeach

{{ get_phrase('What the people Thinks About Us') }}

@php $reviews = DB::table('user_reviews')->get(); @endphp @foreach ($reviews as $review) @php $userDetails = App\Models\User::where('id', $review->user_id)->firstOrNew(); @endphp

{{ $userDetails->name }}

{{ date('h:i A', strtotime($review->created_at)) }}

{{ $review->review }}

@for ($i = 1; $i <= 5; $i++) @if ($i <= $review->rating) @else @endif @endfor
@endforeach
@if (get_frontend_settings('blog_visibility_on_the_home_page'))

{{ get_phrase('Our Latest Blog') }}

@endif @endsection @push('js') @endpush